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 |
|---|---|---|---|---|---|---|---|
| 16060000117140 | L16/dossiers | 16 | 16060000117139 | 16060000117139 | 1 | PA795350 | PM797436 |
| 16060000117147 | L16/dossiers | 16 | 16060000117146 | 16060000117146 | 1 | PA267318 | PM797307 |
| 16060000117154 | L16/dossiers | 16 | 16060000117153 | 16060000117153 | 1 | PA795362 | PM797442 |
| 16060000117161 | L16/dossiers | 16 | 16060000117160 | 16060000117160 | 1 | PA795362 | PM797442 |
| 16060000117174 | L16/dossiers | 16 | 16060000117173 | 16060000117173 | 1 | PA721442 | PM797253 |
| 16060000117181 | L16/dossiers | 16 | 16060000117180 | 16060000117180 | 1 | PA793330 | PM796263 |
| 16060000117188 | L16/dossiers | 16 | 16060000117187 | 16060000117187 | 1 | PA718784 | PM796266 |
| 16060000117195 | L16/dossiers | 16 | 16060000117194 | 16060000117194 | 1 | PA794198 | PM796776 |
| 16060000117202 | L16/dossiers | 16 | 16060000117201 | 16060000117201 | 1 | PA719318 | PM796470 |
| 16060000117209 | L16/dossiers | 16 | 16060000117208 | 16060000117208 | 1 | PA721976 | PM797622 |
| 16060000117216 | L16/dossiers | 16 | 16060000117215 | 16060000117215 | 1 | PA794906 | PM797187 |
| 16060000117223 | L16/dossiers | 16 | 16060000117222 | 16060000117222 | 1 | PA720100 | PM796860 |
| 16060000117230 | L16/dossiers | 16 | 16060000117229 | 16060000117229 | 1 | PA717161 | PM791583 |
| 16060000117247 | L16/dossiers | 16 | 16060000117246 | 16060000117246 | 1 | PA717161 | PM791583 |
| 16060000117248 | L16/dossiers | 16 | 16060000117246 | 16060000117246 | 2 | PA759832 | PM791710 |
| 16060000117263 | L16/dossiers | 16 | 16060000117262 | 16060000117262 | 1 | PA794718 | PM797079 |
| 16060000117280 | L16/dossiers | 16 | 16060000117279 | 16060000117279 | 1 | PA703510 | PM775681 |
| 16060000117287 | L16/dossiers | 16 | 16060000117286 | 16060000117286 | 1 | PA794786 | PM797118 |
| 16060000117294 | L16/dossiers | 16 | 16060000117293 | 16060000117293 | 1 | PA426327 | PM775735 |
| 16060000117301 | L16/dossiers | 16 | 16060000117300 | 16060000117300 | 1 | PA426327 | PM775735 |
| 16060000117308 | L16/dossiers | 16 | 16060000117307 | 16060000117307 | 1 | PA426327 | PM775735 |
| 16060000117315 | L16/dossiers | 16 | 16060000117314 | 16060000117314 | 1 | PA717161 | PM791583 |
| 16060000117323 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 1 | PA736195 | PM829855 |
| 16060000117324 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 2 | PA827930 | PM828544 |
| 16060000117325 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 3 | PA827962 | PM828676 |
| 16060000117326 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 4 | PA757676 | PM829801 |
| 16060000117327 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 5 | PA775172 | PM775474 |
| 16060000117328 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 6 | PA827898 | PM828454 |
| 16060000117329 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 7 | PA429894 | PM829765 |
| 16060000117330 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 8 | PA827912 | PM828488 |
| 16060000117331 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 9 | PA756685 | PM775777 |
| 16060000117332 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 10 | PA268007 | PM829695 |
| 16060000117333 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 11 | PA429886 | PM829757 |
| 16060000117334 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 12 | PA736173 | PM829799 |
| 16060000117335 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 13 | PA775246 | PM775532 |
| 16060000117336 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 14 | PA828002 | PM828856 |
| 16060000117337 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 15 | PA736243 | PM829929 |
| 16060000117338 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 16 | PA736175 | PM829795 |
| 16060000117339 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 17 | PA775296 | PM775596 |
| 16060000117340 | L16/dossiers | 16 | 16060000117322 | 16060000117322 | 18 | PA828020 | PM828864 |
| 16060000117347 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 1 | PA736195 | PM829855 |
| 16060000117348 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 2 | PA827930 | PM828544 |
| 16060000117349 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 3 | PA827962 | PM828676 |
| 16060000117350 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 4 | PA757676 | PM829801 |
| 16060000117351 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 5 | PA775172 | PM775474 |
| 16060000117352 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 6 | PA827898 | PM828454 |
| 16060000117353 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 7 | PA429894 | PM829765 |
| 16060000117354 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 8 | PA827912 | PM828488 |
| 16060000117355 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 9 | PA756685 | PM775777 |
| 16060000117356 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 10 | PA268007 | PM829695 |