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 |
|---|---|---|---|---|---|---|---|
| 15060000137321 | L15/dossiers | 15 | 15060000137320 | 15060000137320 | 1 | PA720386 | PM722948 |
| 15060000137328 | L15/dossiers | 15 | 15060000137327 | 15060000137327 | 1 | PA719464 | PM722670 |
| 15060000137335 | L15/dossiers | 15 | 15060000137334 | 15060000137334 | 1 | PA608016 | PM723024 |
| 15060000137342 | L15/dossiers | 15 | 15060000137341 | 15060000137341 | 1 | PA720606 | PM723014 |
| 15060000137349 | L15/dossiers | 15 | 15060000137348 | 15060000137348 | 1 | PA2792 | PM722870 |
| 15060000137364 | L15/dossiers | 15 | 15060000137363 | 15060000137363 | 1 | PA345619 | PM725692 |
| 15060000137365 | L15/dossiers | 15 | 15060000137363 | 15060000137363 | 2 | PA1872 | PM730104 |
| 15060000137400 | L15/dossiers | 15 | 15060000137399 | 15060000137399 | 1 | PA720170 | PM722880 |
| 15060000137412 | L15/dossiers | 15 | 15060000137411 | 15060000137411 | 1 | PA429858 | PM736268 |
| 15060000137431 | L15/dossiers | 15 | 15060000137430 | 15060000137430 | 1 | PA330909 | PM722548 |
| 15060000137438 | L15/dossiers | 15 | 15060000137437 | 15060000137437 | 1 | PA345619 | PM725692 |
| 15060000137445 | L15/dossiers | 15 | 15060000137444 | 15060000137444 | 1 | PA331582 | PM722646 |
| 15060000137457 | L15/dossiers | 15 | 15060000137456 | 15060000137456 | 1 | PA345619 | PM725692 |
| 15060000137458 | L15/dossiers | 15 | 15060000137456 | 15060000137456 | 2 | PA717153 | PM730062 |
| 15060000137465 | L15/dossiers | 15 | 15060000137464 | 15060000137464 | 1 | PA345619 | PM725692 |
| 15060000137466 | L15/dossiers | 15 | 15060000137464 | 15060000137464 | 2 | PA717161 | PM730070 |
| 15060000137543 | L15/dossiers | 15 | 15060000137542 | 15060000137542 | 1 | PA332523 | PM722792 |
| 15060000137547 | L15/dossiers | 15 | 15060000137546 | 15060000137546 | 1 | PA266788 | PM722914 |
| 15060000137554 | L15/dossiers | 15 | 15060000137553 | 15060000137553 | 1 | PA718850 | PM722478 |
| 15060000137558 | L15/dossiers | 15 | 15060000137557 | 15060000137557 | 1 | PA345619 | PM725692 |
| 15060000137593 | L15/dossiers | 15 | 15060000137592 | 15060000137592 | 1 | PA606171 | PM722632 |
| 15060000137675 | L15/dossiers | 15 | 15060000137674 | 15060000137674 | 1 | PA1206 | PM723354 |
| 15060000137682 | L15/dossiers | 15 | 15060000137681 | 15060000137681 | 1 | PA267450 | PM722586 |
| 15060000137689 | L15/dossiers | 15 | 15060000137688 | 15060000137688 | 1 | PA266797 | PM722884 |
| 15060000137696 | L15/dossiers | 15 | 15060000137695 | 15060000137695 | 1 | PA266808 | PM723264 |
| 15060000137703 | L15/dossiers | 15 | 15060000137702 | 15060000137702 | 1 | PA720092 | PM722858 |
| 15060000137710 | L15/dossiers | 15 | 15060000137709 | 15060000137709 | 1 | PA2377 | PM723550 |
| 15060000137717 | L15/dossiers | 15 | 15060000137716 | 15060000137716 | 1 | PA346218 | PM723348 |
| 15060000137724 | L15/dossiers | 15 | 15060000137723 | 15060000137723 | 1 | PA720386 | PM722948 |
| 15060000137731 | L15/dossiers | 15 | 15060000137730 | 15060000137730 | 1 | PA721118 | PM723176 |
| 15060000137751 | L15/dossiers | 15 | 15060000137750 | 15060000137750 | 1 | PA608826 | PM723276 |
| 15060000137758 | L15/dossiers | 15 | 15060000137757 | 15060000137757 | 1 | PA346054 | PM723510 |
| 15060000137765 | L15/dossiers | 15 | 15060000137764 | 15060000137764 | 1 | PA267324 | PM723292 |
| 15060000137772 | L15/dossiers | 15 | 15060000137771 | 15060000137771 | 1 | PA721932 | PM734586 |
| 15060000137779 | L15/dossiers | 15 | 15060000137778 | 15060000137778 | 1 | PA266788 | PM722914 |
| 15060000137786 | L15/dossiers | 15 | 15060000137785 | 15060000137785 | 1 | PA267429 | PM722818 |
| 15060000137793 | L15/dossiers | 15 | 15060000137792 | 15060000137792 | 1 | PA267801 | PM723320 |
| 15060000137800 | L15/dossiers | 15 | 15060000137799 | 15060000137799 | 1 | PA718784 | PM722456 |
| 15060000137807 | L15/dossiers | 15 | 15060000137806 | 15060000137806 | 1 | PA267318 | PM723260 |
| 15060000137814 | L15/dossiers | 15 | 15060000137813 | 15060000137813 | 1 | PA605036 | PM722444 |
| 15060000137821 | L15/dossiers | 15 | 15060000137820 | 15060000137820 | 1 | PA606171 | PM722632 |
| 15060000137923 | L15/dossiers | 15 | 15060000137922 | 15060000137922 | 1 | PA719364 | PM722638 |
| 15060000137930 | L15/dossiers | 15 | 15060000137929 | 15060000137929 | 1 | PA721734 | PM723368 |
| 15060000137937 | L15/dossiers | 15 | 15060000137936 | 15060000137936 | 1 | PA721046 | PM723154 |
| 15060000137944 | L15/dossiers | 15 | 15060000137943 | 15060000137943 | 1 | PA2377 | PM723550 |
| 15060000137951 | L15/dossiers | 15 | 15060000137950 | 15060000137950 | 1 | PA718868 | PM722484 |
| 15060000137958 | L15/dossiers | 15 | 15060000137957 | 15060000137957 | 1 | PA721678 | PM723352 |
| 15060000137965 | L15/dossiers | 15 | 15060000137964 | 15060000137964 | 1 | PA345619 | PM725692 |
| 15060000137966 | L15/dossiers | 15 | 15060000137964 | 15060000137964 | 2 | PA717163 | PM730100 |
| 15060000138026 | L15/dossiers | 15 | 15060000138025 | 15060000138025 | 1 | PA689 | PM723090 |