dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | acteur_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.acteurRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
| 8 | mandat_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.mandatRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|
| 16060000095203 | L16/dossiers | 16 | 16060000095202 | 16060000095202 | 1 | PA1206 | PM797637 |
| 16060000095210 | L16/dossiers | 16 | 16060000095209 | 16060000095209 | 1 | PA703520 | PM775705 |
| 16060000095217 | L16/dossiers | 16 | 16060000095216 | 16060000095216 | 1 | PA717161 | PM791583 |
| 16060000095281 | L16/dossiers | 16 | 16060000095280 | 16060000095280 | 1 | PA717161 | PM791583 |
| 16060000095282 | L16/dossiers | 16 | 16060000095280 | 16060000095280 | 2 | PA331481 | PM791666 |
| 16060000095283 | L16/dossiers | 16 | 16060000095280 | 16060000095280 | 3 | PA722190 | PM791668 |
| 16060000095408 | L16/dossiers | 16 | 16060000095407 | 16060000095407 | 1 | PA717161 | PM791583 |
| 16060000095409 | L16/dossiers | 16 | 16060000095407 | 16060000095407 | 2 | PA773443 | PM791682 |
| 16060000095417 | L16/dossiers | 16 | 16060000095416 | 16060000095416 | 1 | PA717161 | PM791583 |
| 16060000095418 | L16/dossiers | 16 | 16060000095416 | 16060000095416 | 2 | PA312976 | PM791676 |
| 16060000095450 | L16/dossiers | 16 | 16060000095449 | 16060000095449 | 1 | PA720614 | PM797055 |
| 16060000095457 | L16/dossiers | 16 | 16060000095456 | 16060000095456 | 1 | PA2116 | PM736339 |
| 16060000095464 | L16/dossiers | 16 | 16060000095463 | 16060000095463 | 1 | PA267762 | PM736366 |
| 16060000095471 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 1 | PA429886 | PM736385 |
| 16060000095472 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 2 | PA304082 | PM736354 |
| 16060000095473 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 3 | PA756685 | PM775777 |
| 16060000095474 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 4 | PA736173 | PM736369 |
| 16060000095475 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 5 | PA757676 | PM757692 |
| 16060000095476 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 6 | PA775172 | PM775474 |
| 16060000095477 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 7 | PA429894 | PM736364 |
| 16060000095478 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 8 | PA429836 | PM736345 |
| 16060000095479 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 9 | PA736195 | PM736357 |
| 16060000095480 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 10 | PA775246 | PM775532 |
| 16060000095481 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 11 | PA678263 | PM736330 |
| 16060000095482 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 12 | PA1978 | PM736337 |
| 16060000095483 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 13 | PA736243 | PM736413 |
| 16060000095484 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 14 | PA736175 | PM736344 |
| 16060000095485 | L16/dossiers | 16 | 16060000095470 | 16060000095470 | 15 | PA775296 | PM775596 |
| 16060000095492 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 1 | PA429886 | PM736385 |
| 16060000095493 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 2 | PA304082 | PM736354 |
| 16060000095494 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 3 | PA756685 | PM775777 |
| 16060000095495 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 4 | PA736173 | PM736369 |
| 16060000095496 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 5 | PA757676 | PM757692 |
| 16060000095497 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 6 | PA775172 | PM775474 |
| 16060000095498 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 7 | PA429894 | PM736364 |
| 16060000095499 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 8 | PA429836 | PM736345 |
| 16060000095500 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 9 | PA736195 | PM736357 |
| 16060000095501 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 10 | PA775246 | PM775532 |
| 16060000095502 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 11 | PA678263 | PM736330 |
| 16060000095503 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 12 | PA1978 | PM736337 |
| 16060000095504 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 13 | PA736243 | PM736413 |
| 16060000095505 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 14 | PA736175 | PM736344 |
| 16060000095506 | L16/dossiers | 16 | 16060000095491 | 16060000095491 | 15 | PA775296 | PM775596 |
| 16060000095513 | L16/dossiers | 16 | 16060000095512 | 16060000095512 | 1 | PA720892 | PM797520 |
| 16060000095526 | L16/dossiers | 16 | 16060000095525 | 16060000095525 | 1 | PA382672 | PM736263 |
| 16060000095557 | L16/dossiers | 16 | 16060000095556 | 16060000095556 | 1 | PA736236 | PM736341 |
| 16060000095564 | L16/dossiers | 16 | 16060000095563 | 16060000095563 | 1 | PA642847 | PM796872 |
| 16060000095571 | L16/dossiers | 16 | 16060000095570 | 16060000095570 | 1 | PA717161 | PM791583 |
| 16060000095572 | L16/dossiers | 16 | 16060000095570 | 16060000095570 | 2 | PA721134 | PM801926 |
| 16060000095573 | L16/dossiers | 16 | 16060000095570 | 16060000095570 | 3 | PA331481 | PM791666 |