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 |
|---|---|---|---|---|---|---|---|
| 15060000156345 | L15/dossiers | 15 | 15060000156343 | 15060000156343 | 2 | PA736231 | PM736381 |
| 15060000156352 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 1 | PA304000 | PM703599 |
| 15060000156353 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 2 | PA703525 | PM703688 |
| 15060000156354 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 3 | PA703532 | PM703568 |
| 15060000156355 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 4 | PA703500 | PM703574 |
| 15060000156356 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 5 | PA703483 | PM703613 |
| 15060000156357 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 6 | PA703504 | PM703598 |
| 15060000156358 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 7 | PA703526 | PM703719 |
| 15060000156359 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 8 | PA703488 | PM703632 |
| 15060000156360 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 9 | PA703523 | PM703578 |
| 15060000156361 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 10 | PA705750 | PM705821 |
| 15060000156362 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 11 | PA703493 | PM703683 |
| 15060000156363 | L15/dossiers | 15 | 15060000156351 | 15060000156351 | 12 | PA703482 | PM703642 |
| 15060000156370 | L15/dossiers | 15 | 15060000156369 | 15060000156369 | 1 | PA2116 | PM736339 |
| 15060000156371 | L15/dossiers | 15 | 15060000156369 | 15060000156369 | 2 | PA736236 | PM736341 |
| 15060000156384 | L15/dossiers | 15 | 15060000156383 | 15060000156383 | 1 | PA426327 | PM703630 |
| 15060000156391 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 1 | PA304000 | PM703599 |
| 15060000156392 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 2 | PA703525 | PM703688 |
| 15060000156393 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 3 | PA235 | PM703560 |
| 15060000156394 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 4 | PA703532 | PM703568 |
| 15060000156395 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 5 | PA703500 | PM703574 |
| 15060000156396 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 6 | PA703483 | PM703613 |
| 15060000156397 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 7 | PA703504 | PM703598 |
| 15060000156398 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 8 | PA703487 | PM703711 |
| 15060000156399 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 9 | PA703526 | PM703719 |
| 15060000156400 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 10 | PA703488 | PM703632 |
| 15060000156401 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 11 | PA703523 | PM703578 |
| 15060000156402 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 12 | PA705750 | PM705821 |
| 15060000156403 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 13 | PA703493 | PM703683 |
| 15060000156404 | L15/dossiers | 15 | 15060000156390 | 15060000156390 | 14 | PA703482 | PM703642 |
| 15060000156411 | L15/dossiers | 15 | 15060000156410 | 15060000156410 | 1 | PA304108 | PM736399 |
| 15060000156418 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 1 | PA304000 | PM703599 |
| 15060000156419 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 2 | PA703525 | PM703688 |
| 15060000156420 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 3 | PA703532 | PM703568 |
| 15060000156421 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 4 | PA703500 | PM703574 |
| 15060000156422 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 5 | PA703483 | PM703613 |
| 15060000156423 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 6 | PA703504 | PM703598 |
| 15060000156424 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 7 | PA703487 | PM703711 |
| 15060000156425 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 8 | PA703526 | PM703719 |
| 15060000156426 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 9 | PA703488 | PM703632 |
| 15060000156427 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 10 | PA703523 | PM703578 |
| 15060000156428 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 11 | PA705750 | PM705821 |
| 15060000156429 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 12 | PA703493 | PM703683 |
| 15060000156430 | L15/dossiers | 15 | 15060000156417 | 15060000156417 | 13 | PA703482 | PM703642 |
| 15060000156437 | L15/dossiers | 15 | 15060000156436 | 15060000156436 | 1 | PA415473 | PM703666 |
| 15060000156444 | L15/dossiers | 15 | 15060000156443 | 15060000156443 | 1 | PA415476 | PM703653 |
| 15060000156451 | L15/dossiers | 15 | 15060000156450 | 15060000156450 | 1 | PA425322 | PM736282 |
| 15060000156452 | L15/dossiers | 15 | 15060000156450 | 15060000156450 | 2 | PA415495 | PM703579 |
| 15060000156459 | L15/dossiers | 15 | 15060000156458 | 15060000156458 | 1 | PA426327 | PM703630 |
| 15060000156466 | L15/dossiers | 15 | 15060000156465 | 15060000156465 | 1 | PA429836 | PM736345 |