dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 15060000157286 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 9 | PA415447 | PM703616 |
| 15060000157287 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 10 | PA703501 | PM703629 |
| 15060000157288 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 11 | PA415455 | PM703587 |
| 15060000157289 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 12 | PA703527 | PM703580 |
| 15060000157290 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 13 | PA736168 | PM736301 |
| 15060000157291 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 14 | PA747420 | PM747430 |
| 15060000157292 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 15 | PA736235 | PM736426 |
| 15060000157293 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 16 | PA703521 | PM703544 |
| 15060000157294 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 17 | PA736158 | PM736414 |
| 15060000157295 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 18 | PA736237 | PM736417 |
| 15060000157296 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 19 | PA1883 | PM736286 |
| 15060000157297 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 20 | PA736170 | PM736266 |
| 15060000157298 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 21 | PA736171 | PM736322 |
| 15060000157299 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 22 | PA742505 | PM742506 |
| 15060000157300 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 23 | PA415451 | PM703594 |
| 15060000157301 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 24 | PA415446 | PM703678 |
| 15060000157302 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 25 | PA266795 | PM703637 |
| 15060000157303 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 26 | PA736203 | PM736432 |
| 15060000157304 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 27 | PA736222 | PM736436 |
| 15060000157305 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 28 | PA703532 | PM703568 |
| 15060000157306 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 29 | PA415486 | PM703623 |
| 15060000157307 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 30 | PA736182 | PM736346 |
| 15060000157308 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 31 | PA703539 | PM703693 |
| 15060000157309 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 32 | PA736217 | PM736384 |
| 15060000157310 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 33 | PA736167 | PM736327 |
| 15060000157311 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 34 | PA736166 | PM736435 |
| 15060000157312 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 35 | PA736202 | PM736392 |
| 15060000157313 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 36 | PA341381 | PM703618 |
| 15060000157314 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 37 | PA736179 | PM736420 |
| 15060000157315 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 38 | PA703482 | PM703642 |
| 15060000157316 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 39 | PA703525 | PM703688 |
| 15060000157317 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 40 | PA736232 | PM736401 |
| 15060000157318 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 41 | PA703498 | PM736260 |
| 15060000157319 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 42 | PA342665 | PM736382 |
| 15060000157320 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 43 | PA736242 | PM736349 |
| 15060000157321 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 44 | PA703510 | PM703672 |
| 15060000157322 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 45 | PA703529 | PM703650 |
| 15060000157323 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 46 | PA266867 | PM703554 |
| 15060000157324 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 47 | PA736231 | PM736381 |
| 15060000157325 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 48 | PA703487 | PM703711 |
| 15060000157326 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 49 | PA266812 | PM736265 |
| 15060000157327 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 50 | PA235 | PM703560 |
| 15060000157334 | L15/dossiers | 15 | 15060000157333 | 15060000157333 | 1 | PA343775 | PM736367 |
| 15060000157341 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 1 | PA732420 | PM732493 |
| 15060000157342 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 2 | PA429895 | PM736262 |
| 15060000157343 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 3 | PA703486 | PM703718 |
| 15060000157344 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 4 | PA267840 | PM736423 |
| 15060000157345 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 5 | PA429890 | PM736393 |
| 15060000157346 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 6 | PA736190 | PM736255 |
| 15060000157347 | L15/dossiers | 15 | 15060000157340 | 15060000157340 | 7 | PA703531 | PM703701 |