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 |
|---|---|---|---|---|---|---|---|
| 14060000127969 | L14/dossiers | 14 | 14060000127968 | 14060000127968 | 1 | PA680 | PM645536 |
| 14060000128063 | L14/dossiers | 14 | 14060000128062 | 14060000128062 | 1 | PA785 | PM715797 |
| 14060000128071 | L14/dossiers | 14 | 14060000128070 | 14060000128070 | 1 | PA607090 | PM645143 |
| 14060000128075 | L14/dossiers | 14 | 14060000128074 | 14060000128074 | 1 | PA346886 | PM695110 |
| 14060000128082 | L14/dossiers | 14 | 14060000128081 | 14060000128081 | 1 | PA330684 | PM645497 |
| 14060000128089 | L14/dossiers | 14 | 14060000128088 | 14060000128088 | 1 | PA332950 | PM645251 |
| 14060000128097 | L14/dossiers | 14 | 14060000128096 | 14060000128096 | 1 | PA267622 | PM702957 |
| 14060000128098 | L14/dossiers | 14 | 14060000128096 | 14060000128096 | 2 | PA1268 | PM702961 |
| 14060000128130 | L14/dossiers | 14 | 14060000128129 | 14060000128129 | 1 | PA267492 | PM645465 |
| 14060000128137 | L14/dossiers | 14 | 14060000128136 | 14060000128136 | 1 | PA785 | PM715797 |
| 14060000128146 | L14/dossiers | 14 | 14060000128145 | 14060000128145 | 1 | PA267622 | PM702957 |
| 14060000128147 | L14/dossiers | 14 | 14060000128145 | 14060000128145 | 2 | PA331594 | PM711625 |
| 14060000128154 | L14/dossiers | 14 | 14060000128153 | 14060000128153 | 1 | PA266788 | PM645294 |
| 14060000128161 | L14/dossiers | 14 | 14060000128160 | 14060000128160 | 1 | PA328 | PM653228 |
| 14060000128162 | L14/dossiers | 14 | 14060000128160 | 14060000128160 | 2 | PA1268 | PM653525 |
| 14060000128194 | L14/dossiers | 14 | 14060000128193 | 14060000128193 | 1 | PA1874 | PM645474 |
| 14060000128201 | L14/dossiers | 14 | 14060000128200 | 14060000128200 | 1 | PA2345 | PM645548 |
| 14060000128216 | L14/dossiers | 14 | 14060000128215 | 14060000128215 | 1 | PA267492 | PM645465 |
| 14060000128226 | L14/dossiers | 14 | 14060000128225 | 14060000128225 | 1 | PA267762 | PM645455 |
| 14060000128249 | L14/dossiers | 14 | 14060000128248 | 14060000128248 | 1 | PA267433 | PM645316 |
| 14060000128256 | L14/dossiers | 14 | 14060000128255 | 14060000128255 | 1 | PA1155 | PM645285 |
| 14060000128263 | L14/dossiers | 14 | 14060000128262 | 14060000128262 | 1 | PA328 | PM653228 |
| 14060000128270 | L14/dossiers | 14 | 14060000128269 | 14060000128269 | 1 | PA609764 | PM645323 |
| 14060000128277 | L14/dossiers | 14 | 14060000128276 | 14060000128276 | 1 | PA754 | PM645050 |
| 14060000128284 | L14/dossiers | 14 | 14060000128283 | 14060000128283 | 1 | PA346886 | PM695110 |
| 14060000128288 | L14/dossiers | 14 | 14060000128287 | 14060000128287 | 1 | PA643069 | PM701218 |
| 14060000128295 | L14/dossiers | 14 | 14060000128294 | 14060000128294 | 1 | PA332747 | PM645155 |
| 14060000128302 | L14/dossiers | 14 | 14060000128301 | 14060000128301 | 1 | PA2236 | PM645149 |
| 14060000128312 | L14/dossiers | 14 | 14060000128311 | 14060000128311 | 1 | PA429840 | PM429983 |
| 14060000128331 | L14/dossiers | 14 | 14060000128330 | 14060000128330 | 1 | PA1874 | PM645474 |
| 14060000128338 | L14/dossiers | 14 | 14060000128337 | 14060000128337 | 1 | PA267622 | PM700712 |
| 14060000128348 | L14/dossiers | 14 | 14060000128347 | 14060000128347 | 1 | PA709315 | PM709318 |
| 14060000128355 | L14/dossiers | 14 | 14060000128354 | 14060000128354 | 1 | PA345937 | PM645177 |
| 14060000128375 | L14/dossiers | 14 | 14060000128374 | 14060000128374 | 1 | PA267801 | PM645153 |
| 14060000128385 | L14/dossiers | 14 | 14060000128384 | 14060000128384 | 1 | PA1886 | PM645099 |
| 14060000128407 | L14/dossiers | 14 | 14060000128406 | 14060000128406 | 1 | PA328 | PM653228 |
| 14060000128408 | L14/dossiers | 14 | 14060000128406 | 14060000128406 | 2 | PA267278 | PM695770 |
| 14060000128564 | L14/dossiers | 14 | 14060000128563 | 14060000128563 | 1 | PA1585 | PM645094 |
| 14060000128571 | L14/dossiers | 14 | 14060000128570 | 14060000128570 | 1 | PA267266 | PM645489 |
| 14060000128578 | L14/dossiers | 14 | 14060000128577 | 14060000128577 | 1 | PA606212 | PM645330 |
| 14060000128588 | L14/dossiers | 14 | 14060000128587 | 14060000128587 | 1 | PA872 | PM645331 |
| 14060000128678 | L14/dossiers | 14 | 14060000128677 | 14060000128677 | 1 | PA2250 | PM645539 |
| 14060000128694 | L14/dossiers | 14 | 14060000128693 | 14060000128693 | 1 | PA713448 | PM713451 |
| 14060000128701 | L14/dossiers | 14 | 14060000128700 | 14060000128700 | 1 | PA328 | PM653228 |
| 14060000128702 | L14/dossiers | 14 | 14060000128700 | 14060000128700 | 2 | PA2240 | PM653295 |
| 14060000128784 | L14/dossiers | 14 | 14060000128783 | 14060000128783 | 1 | PA267260 | PM645459 |
| 14060000128802 | L14/dossiers | 14 | 14060000128801 | 14060000128801 | 1 | PA1874 | PM645474 |
| 14060000128809 | L14/dossiers | 14 | 14060000128808 | 14060000128808 | 1 | PA2257 | PM645201 |
| 14060000128816 | L14/dossiers | 14 | 14060000128815 | 14060000128815 | 1 | PA328 | PM653228 |
| 14060000128872 | L14/dossiers | 14 | 14060000128871 | 14060000128871 | 1 | PA1364 | PM645084 |