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 |
|---|---|---|---|---|---|---|---|
| 17060000124935 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 2 | PA775224 | PM775512 |
| 17060000124936 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 3 | PA775180 | PM775466 |
| 17060000124937 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 4 | PA827904 | PM828514 |
| 17060000124938 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 5 | PA429845 | PM829729 |
| 17060000124939 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 6 | PA775214 | PM775498 |
| 17060000124940 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 7 | PA736177 | PM829835 |
| 17060000124941 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 8 | PA827950 | PM828598 |
| 17060000124942 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 9 | PA775252 | PM775558 |
| 17060000124943 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 10 | PA827968 | PM828750 |
| 17060000124944 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 11 | PA827978 | PM828730 |
| 17060000124945 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 12 | PA775272 | PM775562 |
| 17060000124946 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 13 | PA775282 | PM775584 |
| 17060000124947 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 14 | PA828000 | PM828850 |
| 17060000124948 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 15 | PA828004 | PM828838 |
| 17060000124949 | L17/dossiers | 17 | 17060000124933 | 17060000124933 | 16 | PA785857 | PM785867 |
| 17060000124956 | L17/dossiers | 17 | 17060000124955 | 17060000124955 | 1 | PA368 | PM847741 |
| 17060000124957 | L17/dossiers | 17 | 17060000124955 | 17060000124955 | 2 | PA795144 | PM847769 |
| 17060000125032 | L17/dossiers | 17 | 17060000125031 | 17060000125031 | 1 | PA775300 | PM775600 |
| 17060000125039 | L17/dossiers | 17 | 17060000125038 | 17060000125038 | 1 | PA817211 | PM842600 |
| 17060000125046 | L17/dossiers | 17 | 17060000125045 | 17060000125045 | 1 | PA775252 | PM775558 |
| 17060000125056 | L17/dossiers | 17 | 17060000125055 | 17060000125055 | 1 | PA827960 | PM828664 |
| 17060000125063 | L17/dossiers | 17 | 17060000125062 | 17060000125062 | 1 | PA736218 | PM829869 |
| 17060000125064 | L17/dossiers | 17 | 17060000125062 | 17060000125062 | 2 | PA736224 | PM829913 |
| 17060000125132 | L17/dossiers | 17 | 17060000125131 | 17060000125131 | 1 | PA774954 | PM842843 |
| 17060000125175 | L17/dossiers | 17 | 17060000125174 | 17060000125174 | 1 | PA368 | PM847741 |
| 17060000125176 | L17/dossiers | 17 | 17060000125174 | 17060000125174 | 2 | PA795144 | PM847769 |
| 17060000125177 | L17/dossiers | 17 | 17060000125174 | 17060000125174 | 3 | PA720878 | PM847701 |
| 17060000125226 | L17/dossiers | 17 | 17060000125225 | 17060000125225 | 1 | PA774962 | PM843731 |
| 17060000125242 | L17/dossiers | 17 | 17060000125241 | 17060000125241 | 1 | PA720386 | PM843020 |
| 17060000125246 | L17/dossiers | 17 | 17060000125245 | 17060000125245 | 1 | PA793464 | PM840273 |
| 17060000125253 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 1 | PA736195 | PM829855 |
| 17060000125254 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 2 | PA757676 | PM829801 |
| 17060000125255 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 3 | PA775172 | PM775474 |
| 17060000125256 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 4 | PA827898 | PM828454 |
| 17060000125257 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 5 | PA827912 | PM828488 |
| 17060000125258 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 6 | PA756685 | PM775777 |
| 17060000125259 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 7 | PA827930 | PM828544 |
| 17060000125260 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 8 | PA268007 | PM829695 |
| 17060000125261 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 9 | PA429886 | PM829757 |
| 17060000125262 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 10 | PA736173 | PM829799 |
| 17060000125263 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 11 | PA775246 | PM775532 |
| 17060000125264 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 12 | PA827962 | PM828676 |
| 17060000125265 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 13 | PA828002 | PM828856 |
| 17060000125266 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 14 | PA736243 | PM829929 |
| 17060000125267 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 15 | PA736175 | PM829795 |
| 17060000125268 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 16 | PA775296 | PM775596 |
| 17060000125269 | L17/dossiers | 17 | 17060000125252 | 17060000125252 | 17 | PA828020 | PM828864 |
| 17060000125276 | L17/dossiers | 17 | 17060000125275 | 17060000125275 | 1 | PA827918 | PM828482 |
| 17060000125277 | L17/dossiers | 17 | 17060000125275 | 17060000125275 | 2 | PA775184 | PM775486 |
| 17060000125298 | L17/dossiers | 17 | 17060000125297 | 17060000125297 | 1 | PA827978 | PM828730 |