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 |
|---|---|---|---|---|---|---|---|
| 17060000124283 | L17/dossiers | 17 | 17060000124282 | 17060000124282 | 1 | PA343988 | PM829809 |
| 17060000124290 | L17/dossiers | 17 | 17060000124289 | 17060000124289 | 1 | PA736207 | PM829847 |
| 17060000124297 | L17/dossiers | 17 | 17060000124296 | 17060000124296 | 1 | PA794802 | PM843191 |
| 17060000124304 | L17/dossiers | 17 | 17060000124303 | 17060000124303 | 1 | PA794802 | PM843191 |
| 17060000124311 | L17/dossiers | 17 | 17060000124310 | 17060000124310 | 1 | PA827926 | PM828562 |
| 17060000124318 | L17/dossiers | 17 | 17060000124317 | 17060000124317 | 1 | PA841693 | PM843266 |
| 17060000124322 | L17/dossiers | 17 | 17060000124321 | 17060000124321 | 1 | PA335054 | PM843332 |
| 17060000124342 | L17/dossiers | 17 | 17060000124341 | 17060000124341 | 1 | PA346782 | PM840426 |
| 17060000124349 | L17/dossiers | 17 | 17060000124348 | 17060000124348 | 1 | PA758716 | PM775771 |
| 17060000124350 | L17/dossiers | 17 | 17060000124348 | 17060000124348 | 2 | PA758716 | PM775771 |
| 17060000124357 | L17/dossiers | 17 | 17060000124356 | 17060000124356 | 1 | PA703514 | PM775661 |
| 17060000124364 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 1 | PA1744 | PM775781 |
| 17060000124365 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 2 | PA763158 | PM775683 |
| 17060000124366 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 3 | PA267112 | PM775737 |
| 17060000124367 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 4 | PA758716 | PM775771 |
| 17060000124368 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 5 | PA758716 | PM775771 |
| 17060000124369 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 6 | PA775258 | PM775544 |
| 17060000124370 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 7 | PA736169 | PM829791 |
| 17060000124371 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 8 | PA703517 | PM775675 |
| 17060000124372 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 9 | PA775240 | PM775530 |
| 17060000124373 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 10 | PA205280 | PM829891 |
| 17060000124374 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 11 | PA703500 | PM775643 |
| 17060000124375 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 12 | PA736227 | PM829901 |
| 17060000124376 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 13 | PA415451 | PM775787 |
| 17060000124377 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 14 | PA267743 | PM829699 |
| 17060000124378 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 15 | PA736216 | PM829875 |
| 17060000124379 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 16 | PA703534 | PM775695 |
| 17060000124380 | L17/dossiers | 17 | 17060000124363 | 17060000124363 | 17 | PA1744 | PM775781 |
| 17060000124387 | L17/dossiers | 17 | 17060000124386 | 17060000124386 | 1 | PA368 | PM847741 |
| 17060000124394 | L17/dossiers | 17 | 17060000124393 | 17060000124393 | 1 | PA368 | PM847741 |
| 17060000124401 | L17/dossiers | 17 | 17060000124400 | 17060000124400 | 1 | PA721182 | PM843815 |
| 17060000124405 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 1 | PA720892 | PM840420 |
| 17060000124406 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 2 | PA795228 | PM840447 |
| 17060000124407 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 3 | PA793262 | PM842438 |
| 17060000124408 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 4 | PA794906 | PM843284 |
| 17060000124409 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 5 | PA794138 | PM842909 |
| 17060000124410 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 6 | PA795588 | PM843557 |
| 17060000124411 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 7 | PA795084 | PM840369 |
| 17060000124412 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 8 | PA842105 | PM843626 |
| 17060000124413 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 9 | PA841657 | PM843224 |
| 17060000124414 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 10 | PA720430 | PM843092 |
| 17060000124415 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 11 | PA793772 | PM842708 |
| 17060000124416 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 12 | PA795616 | PM840462 |
| 17060000124417 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 13 | PA793444 | PM840270 |
| 17060000124418 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 14 | PA794938 | PM843308 |
| 17060000124419 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 15 | PA795318 | PM843689 |
| 17060000124420 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 16 | PA841023 | PM842645 |
| 17060000124421 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 17 | PA796090 | PM840372 |
| 17060000124422 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 18 | PA793912 | PM842795 |
| 17060000124423 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 19 | PA842187 | PM843704 |