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 |
|---|---|---|---|---|---|---|---|
| 14060000111827 | L14/dossiers | 14 | 14060000111826 | 14060000111826 | 1 | PA429837 | PM430063 |
| 14060000111874 | L14/dossiers | 14 | 14060000111873 | 14060000111873 | 1 | PA267622 | PM702957 |
| 14060000111875 | L14/dossiers | 14 | 14060000111873 | 14060000111873 | 2 | PA328 | PM711554 |
| 14060000111917 | L14/dossiers | 14 | 14060000111916 | 14060000111916 | 1 | PA267622 | PM702957 |
| 14060000111918 | L14/dossiers | 14 | 14060000111916 | 14060000111916 | 2 | PA711558 | PM711571 |
| 14060000111928 | L14/dossiers | 14 | 14060000111927 | 14060000111927 | 1 | PA346886 | PM695110 |
| 14060000111932 | L14/dossiers | 14 | 14060000111931 | 14060000111931 | 1 | PA2011 | PM645434 |
| 14060000111939 | L14/dossiers | 14 | 14060000111938 | 14060000111938 | 1 | PA267622 | PM702957 |
| 14060000111946 | L14/dossiers | 14 | 14060000111945 | 14060000111945 | 1 | PA267622 | PM700712 |
| 14060000111947 | L14/dossiers | 14 | 14060000111945 | 14060000111945 | 2 | PA2679 | PM700726 |
| 14060000111954 | L14/dossiers | 14 | 14060000111953 | 14060000111953 | 1 | PA2952 | PM645464 |
| 14060000111961 | L14/dossiers | 14 | 14060000111960 | 14060000111960 | 1 | PA1886 | PM645099 |
| 14060000111969 | L14/dossiers | 14 | 14060000111968 | 14060000111968 | 1 | PA606098 | PM645171 |
| 14060000111976 | L14/dossiers | 14 | 14060000111975 | 14060000111975 | 1 | PA334654 | PM645596 |
| 14060000111984 | L14/dossiers | 14 | 14060000111983 | 14060000111983 | 1 | PA267622 | PM702957 |
| 14060000111985 | L14/dossiers | 14 | 14060000111983 | 14060000111983 | 2 | PA1268 | PM702961 |
| 14060000111997 | L14/dossiers | 14 | 14060000111996 | 14060000111996 | 1 | PA330684 | PM645497 |
| 14060000112004 | L14/dossiers | 14 | 14060000112003 | 14060000112003 | 1 | PA605703 | PM645418 |
| 14060000112011 | L14/dossiers | 14 | 14060000112010 | 14060000112010 | 1 | PA1886 | PM645099 |
| 14060000112062 | L14/dossiers | 14 | 14060000112061 | 14060000112061 | 1 | PA334149 | PM645127 |
| 14060000112069 | L14/dossiers | 14 | 14060000112068 | 14060000112068 | 1 | PA785 | PM715797 |
| 14060000112078 | L14/dossiers | 14 | 14060000112077 | 14060000112077 | 1 | PA2690 | PM645458 |
| 14060000112088 | L14/dossiers | 14 | 14060000112087 | 14060000112087 | 1 | PA332228 | PM645546 |
| 14060000112104 | L14/dossiers | 14 | 14060000112103 | 14060000112103 | 1 | PA330684 | PM645497 |
| 14060000112111 | L14/dossiers | 14 | 14060000112110 | 14060000112110 | 1 | PA415488 | PM703558 |
| 14060000112130 | L14/dossiers | 14 | 14060000112129 | 14060000112129 | 1 | PA606478 | PM645457 |
| 14060000112140 | L14/dossiers | 14 | 14060000112139 | 14060000112139 | 1 | PA328 | PM653228 |
| 14060000112195 | L14/dossiers | 14 | 14060000112194 | 14060000112194 | 1 | PA267762 | PM645455 |
| 14060000112202 | L14/dossiers | 14 | 14060000112201 | 14060000112201 | 1 | PA2796 | PM645520 |
| 14060000112209 | L14/dossiers | 14 | 14060000112208 | 14060000112208 | 1 | PA346886 | PM695110 |
| 14060000112216 | L14/dossiers | 14 | 14060000112215 | 14060000112215 | 1 | PA2155 | PM705467 |
| 14060000112223 | L14/dossiers | 14 | 14060000112222 | 14060000112222 | 1 | PA608120 | PM645159 |
| 14060000112230 | L14/dossiers | 14 | 14060000112229 | 14060000112229 | 1 | PA267492 | PM645465 |
| 14060000112234 | L14/dossiers | 14 | 14060000112233 | 14060000112233 | 1 | PA1886 | PM645099 |
| 14060000112241 | L14/dossiers | 14 | 14060000112240 | 14060000112240 | 1 | PA1874 | PM645474 |
| 14060000112248 | L14/dossiers | 14 | 14060000112247 | 14060000112247 | 1 | PA266788 | PM645294 |
| 14060000112255 | L14/dossiers | 14 | 14060000112254 | 14060000112254 | 1 | PA2971 | PM645392 |
| 14060000112262 | L14/dossiers | 14 | 14060000112261 | 14060000112261 | 1 | PA267506 | PM645270 |
| 14060000112269 | L14/dossiers | 14 | 14060000112268 | 14060000112268 | 1 | PA267246 | PM645340 |
| 14060000112276 | L14/dossiers | 14 | 14060000112275 | 14060000112275 | 1 | PA267622 | PM702957 |
| 14060000112283 | L14/dossiers | 14 | 14060000112282 | 14060000112282 | 1 | PA1661 | PM645181 |
| 14060000112294 | L14/dossiers | 14 | 14060000112293 | 14060000112293 | 1 | PA2971 | PM645392 |
| 14060000112304 | L14/dossiers | 14 | 14060000112303 | 14060000112303 | 1 | PA331567 | PM645186 |
| 14060000112311 | L14/dossiers | 14 | 14060000112310 | 14060000112310 | 1 | PA1585 | PM645094 |
| 14060000112318 | L14/dossiers | 14 | 14060000112317 | 14060000112317 | 1 | PA2048 | PM693013 |
| 14060000112325 | L14/dossiers | 14 | 14060000112324 | 14060000112324 | 1 | PA331582 | PM645198 |
| 14060000112343 | L14/dossiers | 14 | 14060000112342 | 14060000112342 | 1 | PA331567 | PM645186 |
| 14060000112350 | L14/dossiers | 14 | 14060000112349 | 14060000112349 | 1 | PA268019 | PM645116 |
| 14060000112360 | L14/dossiers | 14 | 14060000112359 | 14060000112359 | 1 | PA340755 | PM645506 |
| 14060000112367 | L14/dossiers | 14 | 14060000112366 | 14060000112366 | 1 | PA2257 | PM645201 |