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 |
|---|---|---|---|---|---|---|---|
| 14060000104853 | L14/dossiers | 14 | 14060000104852 | 14060000104852 | 1 | PA346886 | PM695110 |
| 14060000104860 | L14/dossiers | 14 | 14060000104859 | 14060000104859 | 1 | PA689 | PM645113 |
| 14060000104864 | L14/dossiers | 14 | 14060000104863 | 14060000104863 | 1 | PA610125 | PM645088 |
| 14060000104882 | L14/dossiers | 14 | 14060000104881 | 14060000104881 | 1 | PA785 | PM715797 |
| 14060000104934 | L14/dossiers | 14 | 14060000104933 | 14060000104933 | 1 | PA267306 | PM645210 |
| 14060000104944 | L14/dossiers | 14 | 14060000104943 | 14060000104943 | 1 | PA267622 | PM702957 |
| 14060000104986 | L14/dossiers | 14 | 14060000104985 | 14060000104985 | 1 | PA328 | PM653228 |
| 14060000105040 | L14/dossiers | 14 | 14060000105039 | 14060000105039 | 1 | PA268019 | PM645116 |
| 14060000105056 | L14/dossiers | 14 | 14060000105055 | 14060000105055 | 1 | PA429846 | PM429917 |
| 14060000105057 | L14/dossiers | 14 | 14060000105055 | 14060000105055 | 2 | PA425322 | PM430019 |
| 14060000105091 | L14/dossiers | 14 | 14060000105090 | 14060000105090 | 1 | PA328 | PM653228 |
| 14060000105098 | L14/dossiers | 14 | 14060000105097 | 14060000105097 | 1 | PA267622 | PM702957 |
| 14060000105105 | L14/dossiers | 14 | 14060000105104 | 14060000105104 | 1 | PA267492 | PM645465 |
| 14060000105112 | L14/dossiers | 14 | 14060000105111 | 14060000105111 | 1 | PA267042 | PM645368 |
| 14060000105122 | L14/dossiers | 14 | 14060000105121 | 14060000105121 | 1 | PA266788 | PM645294 |
| 14060000105129 | L14/dossiers | 14 | 14060000105128 | 14060000105128 | 1 | PA346886 | PM695110 |
| 14060000105136 | L14/dossiers | 14 | 14060000105135 | 14060000105135 | 1 | PA1857 | PM645505 |
| 14060000105143 | L14/dossiers | 14 | 14060000105142 | 14060000105142 | 1 | PA1874 | PM645474 |
| 14060000105150 | L14/dossiers | 14 | 14060000105149 | 14060000105149 | 1 | PA267622 | PM702957 |
| 14060000105187 | L14/dossiers | 14 | 14060000105186 | 14060000105186 | 1 | PA2960 | PM645040 |
| 14060000105197 | L14/dossiers | 14 | 14060000105196 | 14060000105196 | 1 | PA2664 | PM645139 |
| 14060000105204 | L14/dossiers | 14 | 14060000105203 | 14060000105203 | 1 | PA2690 | PM645458 |
| 14060000105211 | L14/dossiers | 14 | 14060000105210 | 14060000105210 | 1 | PA1695 | PM645157 |
| 14060000105218 | L14/dossiers | 14 | 14060000105217 | 14060000105217 | 1 | PA267622 | PM702957 |
| 14060000105219 | L14/dossiers | 14 | 14060000105217 | 14060000105217 | 2 | PA642983 | PM709254 |
| 14060000105342 | L14/dossiers | 14 | 14060000105341 | 14060000105341 | 1 | PA334906 | PM645577 |
| 14060000105364 | L14/dossiers | 14 | 14060000105363 | 14060000105363 | 1 | PA563 | PM645307 |
| 14060000105371 | L14/dossiers | 14 | 14060000105370 | 14060000105370 | 1 | PA608662 | PM645592 |
| 14060000105378 | L14/dossiers | 14 | 14060000105377 | 14060000105377 | 1 | PA266788 | PM645294 |
| 14060000105385 | L14/dossiers | 14 | 14060000105384 | 14060000105384 | 1 | PA606212 | PM645330 |
| 14060000105392 | L14/dossiers | 14 | 14060000105391 | 14060000105391 | 1 | PA267492 | PM645465 |
| 14060000105402 | L14/dossiers | 14 | 14060000105401 | 14060000105401 | 1 | PA346886 | PM695110 |
| 14060000105409 | L14/dossiers | 14 | 14060000105408 | 14060000105408 | 1 | PA608662 | PM645592 |
| 14060000105416 | L14/dossiers | 14 | 14060000105415 | 14060000105415 | 1 | PA267622 | PM702957 |
| 14060000105417 | L14/dossiers | 14 | 14060000105415 | 14060000105415 | 2 | PA1268 | PM702961 |
| 14060000105429 | L14/dossiers | 14 | 14060000105428 | 14060000105428 | 1 | PA346886 | PM695110 |
| 14060000105436 | L14/dossiers | 14 | 14060000105435 | 14060000105435 | 1 | PA267178 | PM645473 |
| 14060000105446 | L14/dossiers | 14 | 14060000105445 | 14060000105445 | 1 | PA608011 | PM645066 |
| 14060000105459 | L14/dossiers | 14 | 14060000105458 | 14060000105458 | 1 | PA1632 | PM303924 |
| 14060000105477 | L14/dossiers | 14 | 14060000105476 | 14060000105476 | 1 | PA1874 | PM645474 |
| 14060000105484 | L14/dossiers | 14 | 14060000105483 | 14060000105483 | 1 | PA267433 | PM645316 |
| 14060000105491 | L14/dossiers | 14 | 14060000105490 | 14060000105490 | 1 | PA610634 | PM645262 |
| 14060000105498 | L14/dossiers | 14 | 14060000105497 | 14060000105497 | 1 | PA785 | PM715797 |
| 14060000105505 | L14/dossiers | 14 | 14060000105504 | 14060000105504 | 1 | PA267492 | PM645465 |
| 14060000105509 | L14/dossiers | 14 | 14060000105508 | 14060000105508 | 1 | PA2048 | PM693013 |
| 14060000105516 | L14/dossiers | 14 | 14060000105515 | 14060000105515 | 1 | PA267822 | PM645151 |
| 14060000105523 | L14/dossiers | 14 | 14060000105522 | 14060000105522 | 1 | PA335054 | PM645614 |
| 14060000105538 | L14/dossiers | 14 | 14060000105537 | 14060000105537 | 1 | PA267622 | PM702957 |
| 14060000105539 | L14/dossiers | 14 | 14060000105537 | 14060000105537 | 2 | PA328 | PM711554 |
| 14060000105549 | L14/dossiers | 14 | 14060000105548 | 14060000105548 | 1 | PA331594 | PM645208 |