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 |
|---|---|---|---|---|---|---|---|
| 16060000098091 | L16/dossiers | 16 | 16060000098016 | 16060000098016 | 75 | PA736217 | PM736384 |
| 16060000098092 | L16/dossiers | 16 | 16060000098016 | 16060000098016 | 76 | PA227096 | PM736342 |
| 16060000098093 | L16/dossiers | 16 | 16060000098016 | 16060000098016 | 77 | PA227096 | PM736342 |
| 16060000098094 | L16/dossiers | 16 | 16060000098016 | 16060000098016 | 78 | PA775294 | PM775580 |
| 16060000098095 | L16/dossiers | 16 | 16060000098016 | 16060000098016 | 79 | PA2870 | PM736316 |
| 16060000098096 | L16/dossiers | 16 | 16060000098016 | 16060000098016 | 80 | PA2870 | PM736316 |
| 16060000098097 | L16/dossiers | 16 | 16060000098016 | 16060000098016 | 81 | PA736162 | PM736320 |
| 16060000098098 | L16/dossiers | 16 | 16060000098016 | 16060000098016 | 82 | PA429852 | PM736275 |
| 16060000098108 | L16/dossiers | 16 | 16060000098107 | 16060000098107 | 1 | PA721314 | PM797151 |
| 16060000098115 | L16/dossiers | 16 | 16060000098114 | 16060000098114 | 1 | PA717161 | PM791583 |
| 16060000098116 | L16/dossiers | 16 | 16060000098114 | 16060000098114 | 2 | PA330357 | PM791696 |
| 16060000098182 | L16/dossiers | 16 | 16060000098181 | 16060000098181 | 1 | PA717161 | PM791583 |
| 16060000098183 | L16/dossiers | 16 | 16060000098181 | 16060000098181 | 2 | PA331481 | PM791666 |
| 16060000098190 | L16/dossiers | 16 | 16060000098189 | 16060000098189 | 1 | PA721816 | PM797571 |
| 16060000098197 | L16/dossiers | 16 | 16060000098196 | 16060000098196 | 1 | PA717161 | PM791583 |
| 16060000098276 | L16/dossiers | 16 | 16060000098275 | 16060000098275 | 1 | PA227089 | PM736372 |
| 16060000098317 | L16/dossiers | 16 | 16060000098316 | 16060000098316 | 1 | PA736184 | PM736272 |
| 16060000098350 | L16/dossiers | 16 | 16060000098349 | 16060000098349 | 1 | PA721932 | PM797361 |
| 16060000098357 | L16/dossiers | 16 | 16060000098356 | 16060000098356 | 1 | PA382672 | PM736263 |
| 16060000098364 | L16/dossiers | 16 | 16060000098363 | 16060000098363 | 1 | PA794670 | PM797049 |
| 16060000098368 | L16/dossiers | 16 | 16060000098367 | 16060000098367 | 1 | PA793852 | PM796566 |
| 16060000098388 | L16/dossiers | 16 | 16060000098387 | 16060000098387 | 1 | PA719608 | PM796593 |
| 16060000098395 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 1 | PA736177 | PM736318 |
| 16060000098396 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 2 | PA775180 | PM775466 |
| 16060000098397 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 3 | PA801838 | PM801842 |
| 16060000098398 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 4 | PA429845 | PM736278 |
| 16060000098399 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 5 | PA775214 | PM775498 |
| 16060000098400 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 6 | PA775224 | PM775512 |
| 16060000098401 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 7 | PA429866 | PM736287 |
| 16060000098402 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 8 | PA775252 | PM775558 |
| 16060000098403 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 9 | PA775262 | PM775548 |
| 16060000098404 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 10 | PA775272 | PM775562 |
| 16060000098405 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 11 | PA775282 | PM775584 |
| 16060000098406 | L16/dossiers | 16 | 16060000098394 | 16060000098394 | 12 | PA785857 | PM785867 |
| 16060000098413 | L16/dossiers | 16 | 16060000098412 | 16060000098412 | 1 | PA722202 | PM797358 |
| 16060000098420 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 1 | PA736173 | PM736369 |
| 16060000098421 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 2 | PA678263 | PM736330 |
| 16060000098422 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 3 | PA757676 | PM757692 |
| 16060000098423 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 4 | PA304082 | PM736354 |
| 16060000098424 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 5 | PA775172 | PM775474 |
| 16060000098425 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 6 | PA429894 | PM736364 |
| 16060000098426 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 7 | PA756685 | PM775777 |
| 16060000098427 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 8 | PA429836 | PM736345 |
| 16060000098428 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 9 | PA429886 | PM736385 |
| 16060000098429 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 10 | PA736195 | PM736357 |
| 16060000098430 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 11 | PA775246 | PM775532 |
| 16060000098431 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 12 | PA1978 | PM736337 |
| 16060000098432 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 13 | PA736243 | PM736413 |
| 16060000098433 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 14 | PA736175 | PM736344 |
| 16060000098434 | L16/dossiers | 16 | 16060000098419 | 16060000098419 | 15 | PA775296 | PM775596 |