dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 16060000094667 | L16/dossiers | 16 | 16060000094557 | 16060000094557 | 110 | PA703527 | PM775709 |
| 16060000094685 | L16/dossiers | 16 | 16060000094684 | 16060000094684 | 1 | PA773441 | PM773491 |
| 16060000094716 | L16/dossiers | 16 | 16060000094715 | 16060000094715 | 1 | PA429875 | PM736302 |
| 16060000094717 | L16/dossiers | 16 | 16060000094715 | 16060000094715 | 2 | PA415448 | PM775789 |
| 16060000094737 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 1 | PA756685 | PM775777 |
| 16060000094738 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 2 | PA429886 | PM736385 |
| 16060000094739 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 3 | PA736173 | PM736369 |
| 16060000094740 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 4 | PA775296 | PM775596 |
| 16060000094741 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 5 | PA304082 | PM736354 |
| 16060000094742 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 6 | PA757676 | PM757692 |
| 16060000094743 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 7 | PA775172 | PM775474 |
| 16060000094744 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 8 | PA429894 | PM736364 |
| 16060000094745 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 9 | PA429836 | PM736345 |
| 16060000094746 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 10 | PA775246 | PM775532 |
| 16060000094747 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 11 | PA678263 | PM736330 |
| 16060000094748 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 12 | PA1978 | PM736337 |
| 16060000094749 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 13 | PA736243 | PM736413 |
| 16060000094750 | L16/dossiers | 16 | 16060000094736 | 16060000094736 | 14 | PA736175 | PM736344 |
| 16060000094769 | L16/dossiers | 16 | 16060000094768 | 16060000094768 | 1 | PA773441 | PM773491 |
| 16060000094798 | L16/dossiers | 16 | 16060000094797 | 16060000094797 | 1 | PA736235 | PM775795 |
| 16060000094830 | L16/dossiers | 16 | 16060000094829 | 16060000094829 | 1 | PA429895 | PM736262 |
| 16060000094848 | L16/dossiers | 16 | 16060000094847 | 16060000094847 | 1 | PA717161 | PM791583 |
| 16060000094856 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 1 | PA304082 | PM736354 |
| 16060000094857 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 2 | PA736188 | PM736289 |
| 16060000094858 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 3 | PA744079 | PM744082 |
| 16060000094859 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 4 | PA330684 | PM775859 |
| 16060000094860 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 5 | PA775202 | PM775502 |
| 16060000094861 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 6 | PA268007 | PM736325 |
| 16060000094862 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 7 | PA775222 | PM775524 |
| 16060000094863 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 8 | PA382672 | PM736263 |
| 16060000094864 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 9 | PA736232 | PM736401 |
| 16060000094865 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 10 | PA736181 | PM736416 |
| 16060000094866 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 11 | PA736211 | PM736410 |
| 16060000094867 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 12 | PA736194 | PM736291 |
| 16060000094868 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 13 | PA643211 | PM775749 |
| 16060000094869 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 14 | PA775284 | PM775590 |
| 16060000094870 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 15 | PA775294 | PM775580 |
| 16060000094871 | L16/dossiers | 16 | 16060000094855 | 16060000094855 | 16 | PA736196 | PM736370 |
| 16060000094918 | L16/dossiers | 16 | 16060000094917 | 16060000094917 | 1 | PA717161 | PM791583 |
| 16060000094942 | L16/dossiers | 16 | 16060000094941 | 16060000094941 | 1 | PA429891 | PM736329 |
| 16060000094949 | L16/dossiers | 16 | 16060000094948 | 16060000094948 | 1 | PA736218 | PM736257 |
| 16060000094956 | L16/dossiers | 16 | 16060000094955 | 16060000094955 | 1 | PA267762 | PM736366 |
| 16060000094957 | L16/dossiers | 16 | 16060000094955 | 16060000094955 | 2 | PA775300 | PM775600 |
| 16060000094958 | L16/dossiers | 16 | 16060000094955 | 16060000094955 | 3 | PA703480 | PM775807 |
| 16060000094959 | L16/dossiers | 16 | 16060000094955 | 16060000094955 | 4 | PA703534 | PM775695 |
| 16060000094960 | L16/dossiers | 16 | 16060000094955 | 16060000094955 | 5 | PA775260 | PM775550 |
| 16060000094978 | L16/dossiers | 16 | 16060000094977 | 16060000094977 | 1 | PA267340 | PM775731 |
| 16060000094979 | L16/dossiers | 16 | 16060000094977 | 16060000094977 | 2 | PA775298 | PM775594 |
| 16060000094980 | L16/dossiers | 16 | 16060000094977 | 16060000094977 | 3 | PA775276 | PM775566 |
| 16060000094987 | L16/dossiers | 16 | 16060000094986 | 16060000094986 | 1 | PA304082 | PM736354 |