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 |
|---|---|---|---|---|---|---|---|
| 16060000097327 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 16 | PA429844 | PM736276 |
| 16060000097328 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 17 | PA703512 | PM775665 |
| 16060000097329 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 18 | PA643211 | PM775749 |
| 16060000097330 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 19 | PA775268 | PM775574 |
| 16060000097331 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 20 | PA736209 | PM736400 |
| 16060000097332 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 21 | PA775274 | PM775560 |
| 16060000097333 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 22 | PA736214 | PM736290 |
| 16060000097334 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 23 | PA736217 | PM736384 |
| 16060000097335 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 24 | PA227096 | PM736342 |
| 16060000097336 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 25 | PA227096 | PM736342 |
| 16060000097337 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 26 | PA2870 | PM736316 |
| 16060000097338 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 27 | PA2870 | PM736316 |
| 16060000097339 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 28 | PA429852 | PM736275 |
| 16060000097340 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 29 | PA429833 | PM736271 |
| 16060000097341 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 30 | PA775206 | PM775506 |
| 16060000097342 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 31 | PA775256 | PM775546 |
| 16060000097343 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 32 | PA415488 | PM775641 |
| 16060000097344 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 33 | PA736241 | PM736300 |
| 16060000097345 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 34 | PA736162 | PM736320 |
| 16060000097346 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 35 | PA775194 | PM775476 |
| 16060000097365 | L16/dossiers | 16 | 16060000097364 | 16060000097364 | 1 | PA267762 | PM736366 |
| 16060000097372 | L16/dossiers | 16 | 16060000097371 | 16060000097371 | 1 | PA266795 | PM775711 |
| 16060000097404 | L16/dossiers | 16 | 16060000097403 | 16060000097403 | 1 | PA720334 | PM796884 |
| 16060000097427 | L16/dossiers | 16 | 16060000097426 | 16060000097426 | 1 | PA720386 | PM796908 |
| 16060000097434 | L16/dossiers | 16 | 16060000097433 | 16060000097433 | 1 | PA718850 | PM796203 |
| 16060000097441 | L16/dossiers | 16 | 16060000097440 | 16060000097440 | 1 | PA2116 | PM736339 |
| 16060000097448 | L16/dossiers | 16 | 16060000097447 | 16060000097447 | 1 | PA330240 | PM796155 |
| 16060000097455 | L16/dossiers | 16 | 16060000097454 | 16060000097454 | 1 | PA720038 | PM796746 |
| 16060000097463 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 1 | PA775196 | PM775482 |
| 16060000097464 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 2 | PA702993 | PM736362 |
| 16060000097465 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 3 | PA736177 | PM736318 |
| 16060000097466 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 4 | PA736167 | PM736327 |
| 16060000097467 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 5 | PA429889 | PM736313 |
| 16060000097468 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 6 | PA429889 | PM736313 |
| 16060000097469 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 7 | PA590034 | PM775606 |
| 16060000097470 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 8 | PA703538 | PM775715 |
| 16060000097471 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 9 | PA736191 | PM736336 |
| 16060000097472 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 10 | PA757676 | PM757692 |
| 16060000097473 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 11 | PA775170 | PM775468 |
| 16060000097474 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 12 | PA736219 | PM736387 |
| 16060000097475 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 13 | PA775172 | PM775474 |
| 16060000097476 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 14 | PA775180 | PM775466 |
| 16060000097477 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 15 | PA775186 | PM775484 |
| 16060000097478 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 16 | PA429894 | PM736364 |
| 16060000097479 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 17 | PA415488 | PM775641 |
| 16060000097480 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 18 | PA775194 | PM775476 |
| 16060000097481 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 19 | PA775200 | PM775504 |
| 16060000097482 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 20 | PA756685 | PM775777 |
| 16060000097483 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 21 | PA760322 | PM775649 |
| 16060000097484 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 22 | PA703528 | PM775693 |