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 |
|---|---|---|---|---|---|---|---|
| 15060000161997 | L15/dossiers | 15 | 15060000161996 | 15060000161996 | 1 | PA345619 | PM725692 |
| 15060000161998 | L15/dossiers | 15 | 15060000161996 | 15060000161996 | 2 | PA331481 | PM730094 |
| 15060000161999 | L15/dossiers | 15 | 15060000161996 | 15060000161996 | 3 | PA607846 | PM730066 |
| 15060000162028 | L15/dossiers | 15 | 15060000162027 | 15060000162027 | 1 | PA721012 | PM755861 |
| 15060000162041 | L15/dossiers | 15 | 15060000162040 | 15060000162040 | 1 | PA382672 | PM736263 |
| 15060000162048 | L15/dossiers | 15 | 15060000162047 | 15060000162047 | 1 | PA345619 | PM725692 |
| 15060000162103 | L15/dossiers | 15 | 15060000162102 | 15060000162102 | 1 | PA345619 | PM725692 |
| 15060000162136 | L15/dossiers | 15 | 15060000162135 | 15060000162135 | 1 | PA223837 | PM722458 |
| 15060000162140 | L15/dossiers | 15 | 15060000162139 | 15060000162139 | 1 | PA721474 | PM723286 |
| 15060000162144 | L15/dossiers | 15 | 15060000162143 | 15060000162143 | 1 | PA2960 | PM723006 |
| 15060000162151 | L15/dossiers | 15 | 15060000162150 | 15060000162150 | 1 | PA719946 | PM722808 |
| 15060000162158 | L15/dossiers | 15 | 15060000162157 | 15060000162157 | 1 | PA718784 | PM722456 |
| 15060000162165 | L15/dossiers | 15 | 15060000162164 | 15060000162164 | 1 | PA643089 | PM758076 |
| 15060000162172 | L15/dossiers | 15 | 15060000162171 | 15060000162171 | 1 | PA643134 | PM722824 |
| 15060000162179 | L15/dossiers | 15 | 15060000162178 | 15060000162178 | 1 | PA719364 | PM722638 |
| 15060000162186 | L15/dossiers | 15 | 15060000162185 | 15060000162185 | 1 | PA609726 | PM723426 |
| 15060000162204 | L15/dossiers | 15 | 15060000162203 | 15060000162203 | 1 | PA719798 | PM722766 |
| 15060000162246 | L15/dossiers | 15 | 15060000162245 | 15060000162245 | 1 | PA718780 | PM722454 |
| 15060000162253 | L15/dossiers | 15 | 15060000162252 | 15060000162252 | 1 | PA720634 | PM736312 |
| 15060000162260 | L15/dossiers | 15 | 15060000162259 | 15060000162259 | 1 | PA720630 | PM723020 |
| 15060000162267 | L15/dossiers | 15 | 15060000162266 | 15060000162266 | 1 | PA718884 | PM722488 |
| 15060000162274 | L15/dossiers | 15 | 15060000162273 | 15060000162273 | 1 | PA721410 | PM723266 |
| 15060000162281 | L15/dossiers | 15 | 15060000162280 | 15060000162280 | 1 | PA703525 | PM703688 |
| 15060000162288 | L15/dossiers | 15 | 15060000162287 | 15060000162287 | 1 | PA1037 | PM703690 |
| 15060000162295 | L15/dossiers | 15 | 15060000162294 | 15060000162294 | 1 | PA2116 | PM736339 |
| 15060000162302 | L15/dossiers | 15 | 15060000162301 | 15060000162301 | 1 | PA2116 | PM736339 |
| 15060000162309 | L15/dossiers | 15 | 15060000162308 | 15060000162308 | 1 | PA719608 | PM722710 |
| 15060000162316 | L15/dossiers | 15 | 15060000162315 | 15060000162315 | 1 | PA345722 | PM723428 |
| 15060000162323 | L15/dossiers | 15 | 15060000162322 | 15060000162322 | 1 | PA720630 | PM723020 |
| 15060000162330 | L15/dossiers | 15 | 15060000162329 | 15060000162329 | 1 | PA266797 | PM722884 |
| 15060000162337 | L15/dossiers | 15 | 15060000162336 | 15060000162336 | 1 | PA266797 | PM722884 |
| 15060000162344 | L15/dossiers | 15 | 15060000162343 | 15060000162343 | 1 | PA1874 | PM722598 |
| 15060000162351 | L15/dossiers | 15 | 15060000162350 | 15060000162350 | 1 | PA266788 | PM722914 |
| 15060000162355 | L15/dossiers | 15 | 15060000162354 | 15060000162354 | 1 | PA721932 | PM734586 |
| 15060000162362 | L15/dossiers | 15 | 15060000162361 | 15060000162361 | 1 | PA709315 | PM722526 |
| 15060000162369 | L15/dossiers | 15 | 15060000162368 | 15060000162368 | 1 | PA2796 | PM722510 |
| 15060000162376 | L15/dossiers | 15 | 15060000162375 | 15060000162375 | 1 | PA404656 | PM736328 |
| 15060000162392 | L15/dossiers | 15 | 15060000162391 | 15060000162391 | 1 | PA712015 | PM722448 |
| 15060000162399 | L15/dossiers | 15 | 15060000162398 | 15060000162398 | 1 | PA721046 | PM723154 |
| 15060000162403 | L15/dossiers | 15 | 15060000162402 | 15060000162402 | 1 | PA718780 | PM722454 |
| 15060000162410 | L15/dossiers | 15 | 15060000162409 | 15060000162409 | 1 | PA718850 | PM722478 |
| 15060000162417 | L15/dossiers | 15 | 15060000162416 | 15060000162416 | 1 | PA998 | PM723046 |
| 15060000162424 | L15/dossiers | 15 | 15060000162423 | 15060000162423 | 1 | PA266788 | PM722914 |
| 15060000162431 | L15/dossiers | 15 | 15060000162430 | 15060000162430 | 1 | PA304108 | PM736399 |
| 15060000162438 | L15/dossiers | 15 | 15060000162437 | 15060000162437 | 1 | PA719272 | PM722612 |
| 15060000162445 | L15/dossiers | 15 | 15060000162444 | 15060000162444 | 1 | PA719272 | PM722612 |
| 15060000162452 | L15/dossiers | 15 | 15060000162451 | 15060000162451 | 1 | PA609590 | PM723326 |
| 15060000162459 | L15/dossiers | 15 | 15060000162458 | 15060000162458 | 1 | PA719930 | PM722804 |
| 15060000162466 | L15/dossiers | 15 | 15060000162465 | 15060000162465 | 1 | PA1592 | PM723060 |
| 15060000162473 | L15/dossiers | 15 | 15060000162472 | 15060000162472 | 1 | PA267306 | PM723054 |