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 |
|---|---|---|---|---|---|---|---|
| 14060000130960 | L14/dossiers | 14 | 14060000130959 | 14060000130959 | 1 | PA563 | PM645307 |
| 14060000130967 | L14/dossiers | 14 | 14060000130966 | 14060000130966 | 1 | PA2236 | PM645149 |
| 14060000130974 | L14/dossiers | 14 | 14060000130973 | 14060000130973 | 1 | PA712015 | PM712024 |
| 14060000130981 | L14/dossiers | 14 | 14060000130980 | 14060000130980 | 1 | PA2690 | PM645458 |
| 14060000130991 | L14/dossiers | 14 | 14060000130990 | 14060000130990 | 1 | PA563 | PM645307 |
| 14060000131002 | L14/dossiers | 14 | 14060000131001 | 14060000131001 | 1 | PA687214 | PM687217 |
| 14060000131009 | L14/dossiers | 14 | 14060000131008 | 14060000131008 | 1 | PA328 | PM653228 |
| 14060000131010 | L14/dossiers | 14 | 14060000131008 | 14060000131008 | 2 | PA2240 | PM653295 |
| 14060000131017 | L14/dossiers | 14 | 14060000131016 | 14060000131016 | 1 | PA2690 | PM645458 |
| 14060000131030 | L14/dossiers | 14 | 14060000131029 | 14060000131029 | 1 | PA267622 | PM702957 |
| 14060000131031 | L14/dossiers | 14 | 14060000131029 | 14060000131029 | 2 | PA1268 | PM702961 |
| 14060000131063 | L14/dossiers | 14 | 14060000131062 | 14060000131062 | 1 | PA267492 | PM645465 |
| 14060000131070 | L14/dossiers | 14 | 14060000131069 | 14060000131069 | 1 | PA330684 | PM645497 |
| 14060000131077 | L14/dossiers | 14 | 14060000131076 | 14060000131076 | 1 | PA2011 | PM645434 |
| 14060000131084 | L14/dossiers | 14 | 14060000131083 | 14060000131083 | 1 | PA267622 | PM702957 |
| 14060000131114 | L14/dossiers | 14 | 14060000131113 | 14060000131113 | 1 | PA342935 | PM645244 |
| 14060000131121 | L14/dossiers | 14 | 14060000131120 | 14060000131120 | 1 | PA227019 | PM429938 |
| 14060000131174 | L14/dossiers | 14 | 14060000131173 | 14060000131173 | 1 | PA1263 | PM645432 |
| 14060000131181 | L14/dossiers | 14 | 14060000131180 | 14060000131180 | 1 | PA267622 | PM702957 |
| 14060000131188 | L14/dossiers | 14 | 14060000131187 | 14060000131187 | 1 | PA1699 | PM645390 |
| 14060000131195 | L14/dossiers | 14 | 14060000131194 | 14060000131194 | 1 | PA266788 | PM645294 |
| 14060000131206 | L14/dossiers | 14 | 14060000131205 | 14060000131205 | 1 | PA609726 | PM645311 |
| 14060000131213 | L14/dossiers | 14 | 14060000131212 | 14060000131212 | 1 | PA267622 | PM702957 |
| 14060000131214 | L14/dossiers | 14 | 14060000131212 | 14060000131212 | 2 | PA1268 | PM702961 |
| 14060000131253 | L14/dossiers | 14 | 14060000131252 | 14060000131252 | 1 | PA609442 | PM645214 |
| 14060000131260 | L14/dossiers | 14 | 14060000131259 | 14060000131259 | 1 | PA2056 | PM415567 |
| 14060000131269 | L14/dossiers | 14 | 14060000131268 | 14060000131268 | 1 | PA330684 | PM645497 |
| 14060000131276 | L14/dossiers | 14 | 14060000131275 | 14060000131275 | 1 | PA334149 | PM645127 |
| 14060000131283 | L14/dossiers | 14 | 14060000131282 | 14060000131282 | 1 | PA1364 | PM645084 |
| 14060000131298 | L14/dossiers | 14 | 14060000131297 | 14060000131297 | 1 | PA1857 | PM645505 |
| 14060000131305 | L14/dossiers | 14 | 14060000131304 | 14060000131304 | 1 | PA609963 | PM645045 |
| 14060000131312 | L14/dossiers | 14 | 14060000131311 | 14060000131311 | 1 | PA328 | PM653228 |
| 14060000131390 | L14/dossiers | 14 | 14060000131389 | 14060000131389 | 1 | PA551 | PM645487 |
| 14060000131408 | L14/dossiers | 14 | 14060000131407 | 14060000131407 | 1 | PA332523 | PM645550 |
| 14060000131418 | L14/dossiers | 14 | 14060000131417 | 14060000131417 | 1 | PA267801 | PM645153 |
| 14060000131425 | L14/dossiers | 14 | 14060000131424 | 14060000131424 | 1 | PA1695 | PM645157 |
| 14060000131440 | L14/dossiers | 14 | 14060000131439 | 14060000131439 | 1 | PA267762 | PM645455 |
| 14060000131447 | L14/dossiers | 14 | 14060000131446 | 14060000131446 | 1 | PA429867 | PM429921 |
| 14060000131496 | L14/dossiers | 14 | 14060000131495 | 14060000131495 | 1 | PA610667 | PM645269 |
| 14060000131503 | L14/dossiers | 14 | 14060000131502 | 14060000131502 | 1 | PA346886 | PM695110 |
| 14060000131510 | L14/dossiers | 14 | 14060000131509 | 14060000131509 | 1 | PA267622 | PM700712 |
| 14060000131511 | L14/dossiers | 14 | 14060000131509 | 14060000131509 | 2 | PA590032 | PM700721 |
| 14060000131522 | L14/dossiers | 14 | 14060000131521 | 14060000131521 | 1 | PA1263 | PM645432 |
| 14060000131529 | L14/dossiers | 14 | 14060000131528 | 14060000131528 | 1 | PA267622 | PM702957 |
| 14060000131559 | L14/dossiers | 14 | 14060000131558 | 14060000131558 | 1 | PA785 | PM715797 |
| 14060000131568 | L14/dossiers | 14 | 14060000131567 | 14060000131567 | 1 | PA345619 | PM717221 |
| 14060000131587 | L14/dossiers | 14 | 14060000131586 | 14060000131586 | 1 | PA1886 | PM645099 |
| 14060000131596 | L14/dossiers | 14 | 14060000131595 | 14060000131595 | 1 | PA330240 | PM645425 |
| 14060000131606 | L14/dossiers | 14 | 14060000131605 | 14060000131605 | 1 | PA415447 | PM415513 |
| 14060000131618 | L14/dossiers | 14 | 14060000131617 | 14060000131617 | 1 | PA328 | PM653228 |