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 |
|---|---|---|---|---|---|---|---|
| 16060000115246 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 14 | PA267673 | PM775865 |
| 16060000115247 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 15 | PA703530 | PM775689 |
| 16060000115248 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 16 | PA429887 | PM736274 |
| 16060000115249 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 17 | PA736206 | PM736351 |
| 16060000115250 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 18 | PA775234 | PM775536 |
| 16060000115251 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 19 | PA775236 | PM775542 |
| 16060000115252 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 20 | PA736238 | PM736352 |
| 16060000115253 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 21 | PA775242 | PM775528 |
| 16060000115254 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 22 | PA415451 | PM775787 |
| 16060000115255 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 23 | PA2337 | PM775691 |
| 16060000115256 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 24 | PA736239 | PM736317 |
| 16060000115257 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 25 | PA736237 | PM736417 |
| 16060000115258 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 26 | PA736214 | PM736290 |
| 16060000115276 | L16/dossiers | 16 | 16060000115275 | 16060000115275 | 1 | PA719890 | PM796680 |
| 16060000115283 | L16/dossiers | 16 | 16060000115282 | 16060000115282 | 1 | PA719890 | PM796680 |
| 16060000115290 | L16/dossiers | 16 | 16060000115289 | 16060000115289 | 1 | PA719024 | PM796305 |
| 16060000115297 | L16/dossiers | 16 | 16060000115296 | 16060000115296 | 1 | PA719024 | PM796305 |
| 16060000115304 | L16/dossiers | 16 | 16060000115303 | 16060000115303 | 1 | PA794778 | PM797115 |
| 16060000115311 | L16/dossiers | 16 | 16060000115310 | 16060000115310 | 1 | PA795912 | PM797751 |
| 16060000115315 | L16/dossiers | 16 | 16060000115314 | 16060000115314 | 1 | PA267794 | PM796272 |
| 16060000115347 | L16/dossiers | 16 | 16060000115346 | 16060000115346 | 1 | PA719118 | PM796416 |
| 16060000115354 | L16/dossiers | 16 | 16060000115353 | 16060000115353 | 1 | PA2116 | PM736339 |
| 16060000115361 | L16/dossiers | 16 | 16060000115360 | 16060000115360 | 1 | PA795588 | PM797577 |
| 16060000115372 | L16/dossiers | 16 | 16060000115371 | 16060000115371 | 1 | PA793616 | PM796437 |
| 16060000115379 | L16/dossiers | 16 | 16060000115378 | 16060000115378 | 1 | PA775260 | PM775550 |
| 16060000115397 | L16/dossiers | 16 | 16060000115396 | 16060000115396 | 1 | PA719408 | PM775520 |
| 16060000115398 | L16/dossiers | 16 | 16060000115396 | 16060000115396 | 2 | PA736204 | PM736338 |
| 16060000115429 | L16/dossiers | 16 | 16060000115428 | 16060000115428 | 1 | PA793218 | PM796215 |
| 16060000115436 | L16/dossiers | 16 | 16060000115435 | 16060000115435 | 1 | PA703485 | PM775811 |
| 16060000115443 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 1 | PA736177 | PM736318 |
| 16060000115444 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 2 | PA775224 | PM775512 |
| 16060000115445 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 3 | PA775180 | PM775466 |
| 16060000115446 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 4 | PA429845 | PM736278 |
| 16060000115447 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 5 | PA775214 | PM775498 |
| 16060000115448 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 6 | PA775252 | PM775558 |
| 16060000115449 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 7 | PA775262 | PM775548 |
| 16060000115450 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 8 | PA775272 | PM775562 |
| 16060000115451 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 9 | PA775282 | PM775584 |
| 16060000115452 | L16/dossiers | 16 | 16060000115442 | 16060000115442 | 10 | PA785857 | PM785867 |
| 16060000115486 | L16/dossiers | 16 | 16060000115485 | 16060000115485 | 1 | PA794178 | PM796755 |
| 16060000115493 | L16/dossiers | 16 | 16060000115492 | 16060000115492 | 1 | PA607090 | PM796761 |
| 16060000115500 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 1 | PA757676 | PM757692 |
| 16060000115501 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 2 | PA304082 | PM736354 |
| 16060000115502 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 3 | PA429836 | PM736345 |
| 16060000115503 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 4 | PA775172 | PM775474 |
| 16060000115504 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 5 | PA429894 | PM736364 |
| 16060000115505 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 6 | PA756685 | PM775777 |
| 16060000115506 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 7 | PA429886 | PM736385 |
| 16060000115507 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 8 | PA736195 | PM736357 |
| 16060000115508 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 9 | PA736173 | PM736369 |