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 |
|---|---|---|---|---|---|---|---|
| 15060000170856 | L15/dossiers | 15 | 15060000170855 | 15060000170855 | 1 | PA609726 | PM723426 |
| 15060000170863 | L15/dossiers | 15 | 15060000170862 | 15060000170862 | 1 | PA722390 | PM723560 |
| 15060000170870 | L15/dossiers | 15 | 15060000170869 | 15060000170869 | 1 | PA1206 | PM723354 |
| 15060000170877 | L15/dossiers | 15 | 15060000170876 | 15060000170876 | 1 | PA720614 | PM723016 |
| 15060000170884 | L15/dossiers | 15 | 15060000170883 | 15060000170883 | 1 | PA720606 | PM723014 |
| 15060000170891 | L15/dossiers | 15 | 15060000170890 | 15060000170890 | 1 | PA719946 | PM722808 |
| 15060000170898 | L15/dossiers | 15 | 15060000170897 | 15060000170897 | 1 | PA720916 | PM723112 |
| 15060000170905 | L15/dossiers | 15 | 15060000170904 | 15060000170904 | 1 | PA608416 | PM723540 |
| 15060000170909 | L15/dossiers | 15 | 15060000170908 | 15060000170908 | 1 | PA2116 | PM736339 |
| 15060000170916 | L15/dossiers | 15 | 15060000170915 | 15060000170915 | 1 | PA266788 | PM722914 |
| 15060000170920 | L15/dossiers | 15 | 15060000170919 | 15060000170919 | 1 | PA736233 | PM736411 |
| 15060000170927 | L15/dossiers | 15 | 15060000170926 | 15060000170926 | 1 | PA609590 | PM723326 |
| 15060000170931 | L15/dossiers | 15 | 15060000170930 | 15060000170930 | 1 | PA718978 | PM722520 |
| 15060000170938 | L15/dossiers | 15 | 15060000170937 | 15060000170937 | 1 | PA2116 | PM736339 |
| 15060000170945 | L15/dossiers | 15 | 15060000170944 | 15060000170944 | 1 | PA605036 | PM722444 |
| 15060000170952 | L15/dossiers | 15 | 15060000170951 | 15060000170951 | 1 | PA736186 | PM736396 |
| 15060000170959 | L15/dossiers | 15 | 15060000170958 | 15060000170958 | 1 | PA736186 | PM736396 |
| 15060000170966 | L15/dossiers | 15 | 15060000170965 | 15060000170965 | 1 | PA719946 | PM722808 |
| 15060000170970 | L15/dossiers | 15 | 15060000170969 | 15060000170969 | 1 | PA719946 | PM722808 |
| 15060000170977 | L15/dossiers | 15 | 15060000170976 | 15060000170976 | 1 | PA773441 | PM773491 |
| 15060000170978 | L15/dossiers | 15 | 15060000170976 | 15060000170976 | 2 | PA331481 | PM773459 |
| 15060000170979 | L15/dossiers | 15 | 15060000170976 | 15060000170976 | 3 | PA330357 | PM773447 |
| 15060000171031 | L15/dossiers | 15 | 15060000171030 | 15060000171030 | 1 | PA736233 | PM736411 |
| 15060000171041 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 1 | PA429886 | PM736385 |
| 15060000171042 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 2 | PA304082 | PM736354 |
| 15060000171043 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 3 | PA757676 | PM757692 |
| 15060000171044 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 4 | PA429894 | PM736364 |
| 15060000171045 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 5 | PA756685 | PM775777 |
| 15060000171046 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 6 | PA429836 | PM736345 |
| 15060000171047 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 7 | PA736195 | PM736357 |
| 15060000171048 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 8 | PA736173 | PM736369 |
| 15060000171049 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 9 | PA775246 | PM775532 |
| 15060000171050 | L15/dossiers | 15 | 15060000171040 | 15060000171040 | 10 | PA775296 | PM775596 |
| 15060000171057 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 1 | PA304082 | PM736354 |
| 15060000171058 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 2 | PA736243 | PM736413 |
| 15060000171059 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 3 | PA757676 | PM757692 |
| 15060000171060 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 4 | PA775172 | PM775474 |
| 15060000171061 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 5 | PA429894 | PM736364 |
| 15060000171062 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 6 | PA756685 | PM775777 |
| 15060000171063 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 7 | PA429836 | PM736345 |
| 15060000171064 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 8 | PA429886 | PM736385 |
| 15060000171065 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 9 | PA736195 | PM736357 |
| 15060000171066 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 10 | PA736173 | PM736369 |
| 15060000171067 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 11 | PA775246 | PM775532 |
| 15060000171068 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 12 | PA678263 | PM736330 |
| 15060000171069 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 13 | PA1978 | PM736337 |
| 15060000171070 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 14 | PA736175 | PM736344 |
| 15060000171071 | L15/dossiers | 15 | 15060000171056 | 15060000171056 | 15 | PA775296 | PM775596 |
| 15060000171078 | L15/dossiers | 15 | 15060000171077 | 15060000171077 | 1 | PA736191 | PM736336 |
| 15060000171079 | L15/dossiers | 15 | 15060000171077 | 15060000171077 | 2 | PA736167 | PM736327 |