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 |
|---|---|---|---|---|---|---|---|
| 15060000176394 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 2 | PA736195 | PM736357 |
| 15060000176395 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 3 | PA757676 | PM757692 |
| 15060000176396 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 4 | PA304082 | PM736354 |
| 15060000176397 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 5 | PA775172 | PM775474 |
| 15060000176398 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 6 | PA429894 | PM736364 |
| 15060000176399 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 7 | PA756685 | PM775777 |
| 15060000176400 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 8 | PA429836 | PM736345 |
| 15060000176401 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 9 | PA429886 | PM736385 |
| 15060000176402 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 10 | PA736173 | PM736369 |
| 15060000176403 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 11 | PA678263 | PM736330 |
| 15060000176404 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 12 | PA775246 | PM775532 |
| 15060000176405 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 13 | PA736243 | PM736413 |
| 15060000176406 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 14 | PA736175 | PM736344 |
| 15060000176407 | L15/dossiers | 15 | 15060000176392 | 15060000176392 | 15 | PA775296 | PM775596 |
| 15060000176414 | L15/dossiers | 15 | 15060000176413 | 15060000176413 | 1 | PA773441 | PM773491 |
| 15060000176415 | L15/dossiers | 15 | 15060000176413 | 15060000176413 | 2 | PA331481 | PM773459 |
| 15060000176422 | L15/dossiers | 15 | 15060000176421 | 15060000176421 | 1 | PA736229 | PM736389 |
| 15060000176429 | L15/dossiers | 15 | 15060000176428 | 15060000176428 | 1 | PA415446 | PM775783 |
| 15060000176436 | L15/dossiers | 15 | 15060000176435 | 15060000176435 | 1 | PA721486 | PM723290 |
| 15060000176443 | L15/dossiers | 15 | 15060000176442 | 15060000176442 | 1 | PA720614 | PM723016 |
| 15060000176450 | L15/dossiers | 15 | 15060000176449 | 15060000176449 | 1 | PA266788 | PM722914 |
| 15060000176457 | L15/dossiers | 15 | 15060000176456 | 15060000176456 | 1 | PA767 | PM723568 |
| 15060000176464 | L15/dossiers | 15 | 15060000176463 | 15060000176463 | 1 | PA719162 | PM722580 |
| 15060000176471 | L15/dossiers | 15 | 15060000176470 | 15060000176470 | 1 | PA719578 | PM722702 |
| 15060000176478 | L15/dossiers | 15 | 15060000176477 | 15060000176477 | 1 | PA609726 | PM723426 |
| 15060000176485 | L15/dossiers | 15 | 15060000176484 | 15060000176484 | 1 | PA719436 | PM770316 |
| 15060000176492 | L15/dossiers | 15 | 15060000176491 | 15060000176491 | 1 | PA2377 | PM723550 |
| 15060000176499 | L15/dossiers | 15 | 15060000176498 | 15060000176498 | 1 | PA718784 | PM722456 |
| 15060000176506 | L15/dossiers | 15 | 15060000176505 | 15060000176505 | 1 | PA719464 | PM722670 |
| 15060000176507 | L15/dossiers | 15 | 15060000176505 | 15060000176505 | 2 | PA336439 | PM723488 |
| 15060000176508 | L15/dossiers | 15 | 15060000176505 | 15060000176505 | 3 | PA333421 | PM722920 |
| 15060000176519 | L15/dossiers | 15 | 15060000176518 | 15060000176518 | 1 | PA703497 | PM775637 |
| 15060000176526 | L15/dossiers | 15 | 15060000176525 | 15060000176525 | 1 | PA643134 | PM722824 |
| 15060000176533 | L15/dossiers | 15 | 15060000176532 | 15060000176532 | 1 | PA721372 | PM723252 |
| 15060000176540 | L15/dossiers | 15 | 15060000176539 | 15060000176539 | 1 | PA719946 | PM722808 |
| 15060000176547 | L15/dossiers | 15 | 15060000176546 | 15060000176546 | 1 | PA718884 | PM722488 |
| 15060000176554 | L15/dossiers | 15 | 15060000176553 | 15060000176553 | 1 | PA721984 | PM723440 |
| 15060000176561 | L15/dossiers | 15 | 15060000176560 | 15060000176560 | 1 | PA720606 | PM723014 |
| 15060000176574 | L15/dossiers | 15 | 15060000176573 | 15060000176573 | 1 | PA774952 | PM774983 |
| 15060000176578 | L15/dossiers | 15 | 15060000176577 | 15060000176577 | 1 | PA719668 | PM722726 |
| 15060000176582 | L15/dossiers | 15 | 15060000176581 | 15060000176581 | 1 | PA267429 | PM722818 |
| 15060000176589 | L15/dossiers | 15 | 15060000176588 | 15060000176588 | 1 | PA773441 | PM773491 |
| 15060000176647 | L15/dossiers | 15 | 15060000176646 | 15060000176646 | 1 | PA773441 | PM773491 |
| 15060000176710 | L15/dossiers | 15 | 15060000176709 | 15060000176709 | 1 | PA2796 | PM722510 |
| 15060000176714 | L15/dossiers | 15 | 15060000176713 | 15060000176713 | 1 | PA775248 | PM775554 |
| 15060000176721 | L15/dossiers | 15 | 15060000176720 | 15060000176720 | 1 | PA736186 | PM736396 |
| 15060000176728 | L15/dossiers | 15 | 15060000176727 | 15060000176727 | 1 | PA720672 | PM774356 |
| 15060000176735 | L15/dossiers | 15 | 15060000176734 | 15060000176734 | 1 | PA609726 | PM723426 |
| 15060000176755 | L15/dossiers | 15 | 15060000176754 | 15060000176754 | 1 | PA605518 | PM722518 |
| 15060000176762 | L15/dossiers | 15 | 15060000176761 | 15060000176761 | 1 | PA718850 | PM722478 |