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 |
|---|---|---|---|---|---|---|---|
| 14060000125015 | L14/dossiers | 14 | 14060000125014 | 14060000125014 | 1 | PA1931 | PM645042 |
| 14060000125022 | L14/dossiers | 14 | 14060000125021 | 14060000125021 | 1 | PA267622 | PM702957 |
| 14060000125052 | L14/dossiers | 14 | 14060000125051 | 14060000125051 | 1 | PA2792 | PM645308 |
| 14060000125059 | L14/dossiers | 14 | 14060000125058 | 14060000125058 | 1 | PA1857 | PM645505 |
| 14060000125066 | L14/dossiers | 14 | 14060000125065 | 14060000125065 | 1 | PA328 | PM653228 |
| 14060000125136 | L14/dossiers | 14 | 14060000125135 | 14060000125135 | 1 | PA267306 | PM645210 |
| 14060000125143 | L14/dossiers | 14 | 14060000125142 | 14060000125142 | 1 | PA267622 | PM702957 |
| 14060000125144 | L14/dossiers | 14 | 14060000125142 | 14060000125142 | 2 | PA328 | PM711554 |
| 14060000125176 | L14/dossiers | 14 | 14060000125175 | 14060000125175 | 1 | PA1886 | PM645099 |
| 14060000125198 | L14/dossiers | 14 | 14060000125197 | 14060000125197 | 1 | PA606545 | PM645470 |
| 14060000125219 | L14/dossiers | 14 | 14060000125218 | 14060000125218 | 1 | PA266788 | PM645294 |
| 14060000125236 | L14/dossiers | 14 | 14060000125235 | 14060000125235 | 1 | PA607846 | PM645441 |
| 14060000125254 | L14/dossiers | 14 | 14060000125253 | 14060000125253 | 1 | PA267762 | PM645455 |
| 14060000125261 | L14/dossiers | 14 | 14060000125260 | 14060000125260 | 1 | PA643069 | PM701218 |
| 14060000125268 | L14/dossiers | 14 | 14060000125267 | 14060000125267 | 1 | PA1466 | PM645240 |
| 14060000125275 | L14/dossiers | 14 | 14060000125274 | 14060000125274 | 1 | PA609726 | PM645311 |
| 14060000125282 | L14/dossiers | 14 | 14060000125281 | 14060000125281 | 1 | PA563 | PM645307 |
| 14060000125289 | L14/dossiers | 14 | 14060000125288 | 14060000125288 | 1 | PA267622 | PM702957 |
| 14060000125290 | L14/dossiers | 14 | 14060000125288 | 14060000125288 | 2 | PA605606 | PM708671 |
| 14060000125297 | L14/dossiers | 14 | 14060000125296 | 14060000125296 | 1 | PA2048 | PM693013 |
| 14060000125304 | L14/dossiers | 14 | 14060000125303 | 14060000125303 | 1 | PA267622 | PM702957 |
| 14060000125341 | L14/dossiers | 14 | 14060000125340 | 14060000125340 | 1 | PA1206 | PM645054 |
| 14060000125348 | L14/dossiers | 14 | 14060000125347 | 14060000125347 | 1 | PA1886 | PM645099 |
| 14060000125358 | L14/dossiers | 14 | 14060000125357 | 14060000125357 | 1 | PA1886 | PM645099 |
| 14060000125385 | L14/dossiers | 14 | 14060000125384 | 14060000125384 | 1 | PA328 | PM653228 |
| 14060000125386 | L14/dossiers | 14 | 14060000125384 | 14060000125384 | 2 | PA2240 | PM653295 |
| 14060000125451 | L14/dossiers | 14 | 14060000125450 | 14060000125450 | 1 | PA267042 | PM645368 |
| 14060000125458 | L14/dossiers | 14 | 14060000125457 | 14060000125457 | 1 | PA1886 | PM645099 |
| 14060000125561 | L14/dossiers | 14 | 14060000125560 | 14060000125560 | 1 | PA330240 | PM645425 |
| 14060000125568 | L14/dossiers | 14 | 14060000125567 | 14060000125567 | 1 | PA429870 | PM429969 |
| 14060000125595 | L14/dossiers | 14 | 14060000125594 | 14060000125594 | 1 | PA345619 | PM717221 |
| 14060000125602 | L14/dossiers | 14 | 14060000125601 | 14060000125601 | 1 | PA267492 | PM645465 |
| 14060000125610 | L14/dossiers | 14 | 14060000125609 | 14060000125609 | 1 | PA330240 | PM645425 |
| 14060000125617 | L14/dossiers | 14 | 14060000125616 | 14060000125616 | 1 | PA334149 | PM645127 |
| 14060000125627 | L14/dossiers | 14 | 14060000125626 | 14060000125626 | 1 | PA267622 | PM702957 |
| 14060000125628 | L14/dossiers | 14 | 14060000125626 | 14060000125626 | 2 | PA702992 | PM702994 |
| 14060000125629 | L14/dossiers | 14 | 14060000125626 | 14060000125626 | 3 | PA610873 | PM702982 |
| 14060000125743 | L14/dossiers | 14 | 14060000125742 | 14060000125742 | 1 | PA309643 | PM645326 |
| 14060000125750 | L14/dossiers | 14 | 14060000125749 | 14060000125749 | 1 | PA267622 | PM700712 |
| 14060000125751 | L14/dossiers | 14 | 14060000125749 | 14060000125749 | 2 | PA2825 | PM700732 |
| 14060000125752 | L14/dossiers | 14 | 14060000125749 | 14060000125749 | 3 | PA429889 | PM700876 |
| 14060000125865 | L14/dossiers | 14 | 14060000125864 | 14060000125864 | 1 | PA267336 | PM645424 |
| 14060000125872 | L14/dossiers | 14 | 14060000125871 | 14060000125871 | 1 | PA944 | PM415506 |
| 14060000125891 | L14/dossiers | 14 | 14060000125890 | 14060000125890 | 1 | PA606545 | PM645470 |
| 14060000125901 | L14/dossiers | 14 | 14060000125900 | 14060000125900 | 1 | PA267622 | PM702957 |
| 14060000125908 | L14/dossiers | 14 | 14060000125907 | 14060000125907 | 1 | PA304002 | PM430045 |
| 14060000125917 | L14/dossiers | 14 | 14060000125916 | 14060000125916 | 1 | PA2952 | PM645464 |
| 14060000125924 | L14/dossiers | 14 | 14060000125923 | 14060000125923 | 1 | PA607846 | PM645441 |
| 14060000125931 | L14/dossiers | 14 | 14060000125930 | 14060000125930 | 1 | PA610667 | PM645269 |
| 14060000125938 | L14/dossiers | 14 | 14060000125937 | 14060000125937 | 1 | PA605349 | PM645483 |