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 |
|---|---|---|---|---|---|---|---|
| 14060000121234 | L14/dossiers | 14 | 14060000121233 | 14060000121233 | 1 | PA1874 | PM645474 |
| 14060000121244 | L14/dossiers | 14 | 14060000121243 | 14060000121243 | 1 | PA429862 | PM430005 |
| 14060000121253 | L14/dossiers | 14 | 14060000121252 | 14060000121252 | 1 | PA267785 | PM645359 |
| 14060000121270 | L14/dossiers | 14 | 14060000121269 | 14060000121269 | 1 | PA268019 | PM645116 |
| 14060000121278 | L14/dossiers | 14 | 14060000121277 | 14060000121277 | 1 | PA328 | PM653228 |
| 14060000121279 | L14/dossiers | 14 | 14060000121277 | 14060000121277 | 2 | PA588872 | PM653304 |
| 14060000121280 | L14/dossiers | 14 | 14060000121277 | 14060000121277 | 3 | PA1816 | PM653364 |
| 14060000121355 | L14/dossiers | 14 | 14060000121354 | 14060000121354 | 1 | PA785 | PM715797 |
| 14060000121379 | L14/dossiers | 14 | 14060000121378 | 14060000121378 | 1 | PA1206 | PM645054 |
| 14060000121392 | L14/dossiers | 14 | 14060000121391 | 14060000121391 | 1 | PA266797 | PM645338 |
| 14060000121399 | L14/dossiers | 14 | 14060000121398 | 14060000121398 | 1 | PA266788 | PM645294 |
| 14060000121406 | L14/dossiers | 14 | 14060000121405 | 14060000121405 | 1 | PA1886 | PM645099 |
| 14060000121481 | L14/dossiers | 14 | 14060000121480 | 14060000121480 | 1 | PA2971 | PM645392 |
| 14060000121488 | L14/dossiers | 14 | 14060000121487 | 14060000121487 | 1 | PA608016 | PM645071 |
| 14060000121498 | L14/dossiers | 14 | 14060000121497 | 14060000121497 | 1 | PA606212 | PM645330 |
| 14060000121505 | L14/dossiers | 14 | 14060000121504 | 14060000121504 | 1 | PA267622 | PM702957 |
| 14060000121506 | L14/dossiers | 14 | 14060000121504 | 14060000121504 | 2 | PA2825 | PM702962 |
| 14060000121654 | L14/dossiers | 14 | 14060000121653 | 14060000121653 | 1 | PA606098 | PM645171 |
| 14060000121661 | L14/dossiers | 14 | 14060000121660 | 14060000121660 | 1 | PA267622 | PM702957 |
| 14060000121691 | L14/dossiers | 14 | 14060000121690 | 14060000121690 | 1 | PA785 | PM715797 |
| 14060000121701 | L14/dossiers | 14 | 14060000121700 | 14060000121700 | 1 | PA785 | PM715797 |
| 14060000121708 | L14/dossiers | 14 | 14060000121707 | 14060000121707 | 1 | PA346886 | PM695110 |
| 14060000121712 | L14/dossiers | 14 | 14060000121711 | 14060000121711 | 1 | PA331567 | PM645186 |
| 14060000121719 | L14/dossiers | 14 | 14060000121718 | 14060000121718 | 1 | PA346886 | PM695110 |
| 14060000121726 | L14/dossiers | 14 | 14060000121725 | 14060000121725 | 1 | PA267527 | PM645555 |
| 14060000121733 | L14/dossiers | 14 | 14060000121732 | 14060000121732 | 1 | PA267622 | PM700712 |
| 14060000121734 | L14/dossiers | 14 | 14060000121732 | 14060000121732 | 2 | PA785 | PM700742 |
| 14060000121846 | L14/dossiers | 14 | 14060000121845 | 14060000121845 | 1 | PA2713 | PM645148 |
| 14060000121853 | L14/dossiers | 14 | 14060000121852 | 14060000121852 | 1 | PA2048 | PM693013 |
| 14060000121860 | L14/dossiers | 14 | 14060000121859 | 14060000121859 | 1 | PA330240 | PM645425 |
| 14060000121867 | L14/dossiers | 14 | 14060000121866 | 14060000121866 | 1 | PA610924 | PM645227 |
| 14060000121874 | L14/dossiers | 14 | 14060000121873 | 14060000121873 | 1 | PA328 | PM653228 |
| 14060000121875 | L14/dossiers | 14 | 14060000121873 | 14060000121873 | 2 | PA2240 | PM653295 |
| 14060000121992 | L14/dossiers | 14 | 14060000121991 | 14060000121991 | 1 | PA328 | PM653228 |
| 14060000121993 | L14/dossiers | 14 | 14060000121991 | 14060000121991 | 2 | PA1268 | PM653525 |
| 14060000122024 | L14/dossiers | 14 | 14060000122023 | 14060000122023 | 1 | PA328 | PM653228 |
| 14060000122057 | L14/dossiers | 14 | 14060000122056 | 14060000122056 | 1 | PA2690 | PM645458 |
| 14060000122067 | L14/dossiers | 14 | 14060000122066 | 14060000122066 | 1 | PA267622 | PM702957 |
| 14060000122068 | L14/dossiers | 14 | 14060000122066 | 14060000122066 | 2 | PA1268 | PM702961 |
| 14060000122100 | L14/dossiers | 14 | 14060000122099 | 14060000122099 | 1 | PA266788 | PM645294 |
| 14060000122107 | L14/dossiers | 14 | 14060000122106 | 14060000122106 | 1 | PA328 | PM653228 |
| 14060000122108 | L14/dossiers | 14 | 14060000122106 | 14060000122106 | 2 | PA1268 | PM653525 |
| 14060000122137 | L14/dossiers | 14 | 14060000122136 | 14060000122136 | 1 | PA2690 | PM645458 |
| 14060000122147 | L14/dossiers | 14 | 14060000122146 | 14060000122146 | 1 | PA267622 | PM702957 |
| 14060000122148 | L14/dossiers | 14 | 14060000122146 | 14060000122146 | 2 | PA2825 | PM702962 |
| 14060000122155 | L14/dossiers | 14 | 14060000122154 | 14060000122154 | 1 | PA267622 | PM700712 |
| 14060000122156 | L14/dossiers | 14 | 14060000122154 | 14060000122154 | 2 | PA1268 | PM700715 |
| 14060000122187 | L14/dossiers | 14 | 14060000122186 | 14060000122186 | 1 | PA268019 | PM645116 |
| 14060000122194 | L14/dossiers | 14 | 14060000122193 | 14060000122193 | 1 | PA267622 | PM702957 |
| 14060000122211 | L14/dossiers | 14 | 14060000122210 | 14060000122210 | 1 | PA608186 | PM645202 |