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 |
|---|---|---|---|---|---|---|---|
| 17060000137183 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 24 | PA736238 | PM829895 |
| 17060000137184 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 25 | PA775238 | PM775540 |
| 17060000137185 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 26 | PA703529 | PM836349 |
| 17060000137186 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 27 | PA703501 | PM775645 |
| 17060000137187 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 28 | PA827954 | PM828704 |
| 17060000137188 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 29 | PA394676 | PM775769 |
| 17060000137189 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 30 | PA736246 | PM775819 |
| 17060000137190 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 31 | PA736213 | PM775791 |
| 17060000137191 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 32 | PA775250 | PM775552 |
| 17060000137192 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 33 | PA703523 | PM775703 |
| 17060000137193 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 34 | PA341381 | PM775747 |
| 17060000137194 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 35 | PA703497 | PM775637 |
| 17060000137195 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 36 | PA267512 | PM775817 |
| 17060000137196 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 37 | PA703480 | PM775807 |
| 17060000137197 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 38 | PA2197 | PM775755 |
| 17060000137198 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 39 | PA736204 | PM829853 |
| 17060000137199 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 40 | PA827974 | PM828744 |
| 17060000137200 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 41 | PA711156 | PM829933 |
| 17060000137201 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 42 | PA827992 | PM828776 |
| 17060000137202 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 43 | PA827996 | PM828764 |
| 17060000137203 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 44 | PA227094 | PM829735 |
| 17060000137204 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 45 | PA736207 | PM829847 |
| 17060000137205 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 46 | PA736237 | PM829897 |
| 17060000137206 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 47 | PA227098 | PM829739 |
| 17060000137207 | L17/dossiers | 17 | 17060000137159 | 17060000137159 | 48 | PA775298 | PM775594 |
| 17060000137238 | L17/dossiers | 17 | 17060000137237 | 17060000137237 | 1 | PA775196 | PM775482 |
| 17060000137245 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 1 | PA775282 | PM775584 |
| 17060000137246 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 2 | PA775180 | PM775466 |
| 17060000137247 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 3 | PA827904 | PM828514 |
| 17060000137248 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 4 | PA429845 | PM829729 |
| 17060000137249 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 5 | PA775214 | PM775498 |
| 17060000137250 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 6 | PA775224 | PM775512 |
| 17060000137251 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 7 | PA736177 | PM829835 |
| 17060000137252 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 8 | PA827946 | PM828614 |
| 17060000137253 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 9 | PA827950 | PM828598 |
| 17060000137254 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 10 | PA775252 | PM775558 |
| 17060000137255 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 11 | PA827968 | PM828750 |
| 17060000137256 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 12 | PA827978 | PM828730 |
| 17060000137257 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 13 | PA775272 | PM775562 |
| 17060000137258 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 14 | PA828000 | PM828850 |
| 17060000137259 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 15 | PA828004 | PM828838 |
| 17060000137260 | L17/dossiers | 17 | 17060000137244 | 17060000137244 | 16 | PA785857 | PM785867 |
| 17060000137267 | L17/dossiers | 17 | 17060000137266 | 17060000137266 | 1 | PA788192 | PM829697 |
| 17060000137274 | L17/dossiers | 17 | 17060000137273 | 17060000137273 | 1 | PA721004 | PM843824 |
| 17060000137281 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 1 | PA736195 | PM829855 |
| 17060000137282 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 2 | PA827962 | PM828676 |
| 17060000137283 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 3 | PA775246 | PM775532 |
| 17060000137284 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 4 | PA757676 | PM829801 |
| 17060000137285 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 5 | PA775172 | PM775474 |
| 17060000137286 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 6 | PA827898 | PM828454 |