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 |
|---|---|---|---|---|---|---|---|
| 15060000133991 | L15/dossiers | 15 | 15060000133990 | 15060000133990 | 1 | PA1012 | PM722418 |
| 15060000134004 | L15/dossiers | 15 | 15060000134003 | 15060000134003 | 1 | PA345619 | PM725692 |
| 15060000134005 | L15/dossiers | 15 | 15060000134003 | 15060000134003 | 2 | PA1872 | PM730104 |
| 15060000134039 | L15/dossiers | 15 | 15060000134038 | 15060000134038 | 1 | PA345619 | PM725692 |
| 15060000134040 | L15/dossiers | 15 | 15060000134038 | 15060000134038 | 2 | PA717159 | PM730102 |
| 15060000134115 | L15/dossiers | 15 | 15060000134114 | 15060000134114 | 1 | PA605694 | PM722558 |
| 15060000134122 | L15/dossiers | 15 | 15060000134121 | 15060000134121 | 1 | PA719138 | PM722574 |
| 15060000134129 | L15/dossiers | 15 | 15060000134128 | 15060000134128 | 1 | PA719138 | PM722574 |
| 15060000134137 | L15/dossiers | 15 | 15060000134136 | 15060000134136 | 1 | PA1874 | PM722598 |
| 15060000134144 | L15/dossiers | 15 | 15060000134143 | 15060000134143 | 1 | PA1874 | PM722598 |
| 15060000134151 | L15/dossiers | 15 | 15060000134150 | 15060000134150 | 1 | PA767 | PM723568 |
| 15060000134158 | L15/dossiers | 15 | 15060000134157 | 15060000134157 | 1 | PA330684 | PM722528 |
| 15060000134185 | L15/dossiers | 15 | 15060000134184 | 15060000134184 | 1 | PA345619 | PM725692 |
| 15060000134243 | L15/dossiers | 15 | 15060000134242 | 15060000134242 | 1 | PA345619 | PM725692 |
| 15060000134244 | L15/dossiers | 15 | 15060000134242 | 15060000134242 | 2 | PA607846 | PM730066 |
| 15060000134384 | L15/dossiers | 15 | 15060000134383 | 15060000134383 | 1 | PA605036 | PM722444 |
| 15060000134391 | L15/dossiers | 15 | 15060000134390 | 15060000134390 | 1 | PA689 | PM723090 |
| 15060000134398 | L15/dossiers | 15 | 15060000134397 | 15060000134397 | 1 | PA721270 | PM723220 |
| 15060000134405 | L15/dossiers | 15 | 15060000134404 | 15060000134404 | 1 | PA267785 | PM723310 |
| 15060000134412 | L15/dossiers | 15 | 15060000134411 | 15060000134411 | 1 | PA346218 | PM723348 |
| 15060000134419 | L15/dossiers | 15 | 15060000134418 | 15060000134418 | 1 | PA719946 | PM722808 |
| 15060000134426 | L15/dossiers | 15 | 15060000134425 | 15060000134425 | 1 | PA642847 | PM722954 |
| 15060000134433 | L15/dossiers | 15 | 15060000134432 | 15060000134432 | 1 | PA689 | PM723090 |
| 15060000134441 | L15/dossiers | 15 | 15060000134440 | 15060000134440 | 1 | PA720606 | PM723014 |
| 15060000134448 | L15/dossiers | 15 | 15060000134447 | 15060000134447 | 1 | PA1206 | PM723354 |
| 15060000134455 | L15/dossiers | 15 | 15060000134454 | 15060000134454 | 1 | PA266788 | PM722914 |
| 15060000134462 | L15/dossiers | 15 | 15060000134461 | 15060000134461 | 1 | PA266788 | PM722914 |
| 15060000134469 | L15/dossiers | 15 | 15060000134468 | 15060000134468 | 1 | PA266788 | PM722914 |
| 15060000134476 | L15/dossiers | 15 | 15060000134475 | 15060000134475 | 1 | PA266788 | PM722914 |
| 15060000134483 | L15/dossiers | 15 | 15060000134482 | 15060000134482 | 1 | PA266788 | PM722914 |
| 15060000134490 | L15/dossiers | 15 | 15060000134489 | 15060000134489 | 1 | PA266788 | PM722914 |
| 15060000134497 | L15/dossiers | 15 | 15060000134496 | 15060000134496 | 1 | PA266788 | PM722914 |
| 15060000134504 | L15/dossiers | 15 | 15060000134503 | 15060000134503 | 1 | PA266788 | PM722914 |
| 15060000134511 | L15/dossiers | 15 | 15060000134510 | 15060000134510 | 1 | PA266788 | PM722914 |
| 15060000134518 | L15/dossiers | 15 | 15060000134517 | 15060000134517 | 1 | PA266788 | PM722914 |
| 15060000134525 | L15/dossiers | 15 | 15060000134524 | 15060000134524 | 1 | PA330008 | PM722416 |
| 15060000134535 | L15/dossiers | 15 | 15060000134534 | 15060000134534 | 1 | PA267429 | PM722818 |
| 15060000134542 | L15/dossiers | 15 | 15060000134541 | 15060000134541 | 1 | PA336316 | PM723406 |
| 15060000134549 | L15/dossiers | 15 | 15060000134548 | 15060000134548 | 1 | PA267429 | PM722818 |
| 15060000134556 | L15/dossiers | 15 | 15060000134555 | 15060000134555 | 1 | PA722142 | PM723484 |
| 15060000134563 | L15/dossiers | 15 | 15060000134562 | 15060000134562 | 1 | PA722142 | PM723484 |
| 15060000134570 | L15/dossiers | 15 | 15060000134569 | 15060000134569 | 1 | PA609332 | PM723378 |
| 15060000134577 | L15/dossiers | 15 | 15060000134576 | 15060000134576 | 1 | PA609332 | PM723378 |
| 15060000134594 | L15/dossiers | 15 | 15060000134593 | 15060000134593 | 1 | PA609332 | PM723378 |
| 15060000134610 | L15/dossiers | 15 | 15060000134609 | 15060000134609 | 1 | PA718926 | PM722502 |
| 15060000134625 | L15/dossiers | 15 | 15060000134624 | 15060000134624 | 1 | PA267429 | PM722818 |
| 15060000134629 | L15/dossiers | 15 | 15060000134628 | 15060000134628 | 1 | PA609332 | PM723378 |
| 15060000134687 | L15/dossiers | 15 | 15060000134686 | 15060000134686 | 1 | PA642695 | PM722602 |
| 15060000134688 | L15/dossiers | 15 | 15060000134686 | 15060000134686 | 2 | PA345722 | PM723428 |
| 15060000134708 | L15/dossiers | 15 | 15060000134707 | 15060000134707 | 1 | PA345619 | PM725692 |