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 |
|---|---|---|---|---|---|---|---|
| 15060000159619 | L15/dossiers | 15 | 15060000159618 | 15060000159618 | 1 | PA608292 | PM723076 |
| 15060000159693 | L15/dossiers | 15 | 15060000159692 | 15060000159692 | 1 | PA722390 | PM723560 |
| 15060000159700 | L15/dossiers | 15 | 15060000159699 | 15060000159699 | 1 | PA345619 | PM725692 |
| 15060000159701 | L15/dossiers | 15 | 15060000159699 | 15060000159699 | 2 | PA1872 | PM730104 |
| 15060000159733 | L15/dossiers | 15 | 15060000159732 | 15060000159732 | 1 | PA345619 | PM725692 |
| 15060000159734 | L15/dossiers | 15 | 15060000159732 | 15060000159732 | 2 | PA415452 | PM759792 |
| 15060000159741 | L15/dossiers | 15 | 15060000159740 | 15060000159740 | 1 | PA720454 | PM722968 |
| 15060000159748 | L15/dossiers | 15 | 15060000159747 | 15060000159747 | 1 | PA720454 | PM722968 |
| 15060000159755 | L15/dossiers | 15 | 15060000159754 | 15060000159754 | 1 | PA718838 | PM722474 |
| 15060000159762 | L15/dossiers | 15 | 15060000159761 | 15060000159761 | 1 | PA267318 | PM723260 |
| 15060000159769 | L15/dossiers | 15 | 15060000159768 | 15060000159768 | 1 | PA709315 | PM722526 |
| 15060000159776 | L15/dossiers | 15 | 15060000159775 | 15060000159775 | 1 | PA721062 | PM723158 |
| 15060000159783 | L15/dossiers | 15 | 15060000159782 | 15060000159782 | 1 | PA713448 | PM722452 |
| 15060000159790 | L15/dossiers | 15 | 15060000159789 | 15060000159789 | 1 | PA720286 | PM722918 |
| 15060000159797 | L15/dossiers | 15 | 15060000159796 | 15060000159796 | 1 | PA335612 | PM723506 |
| 15060000159805 | L15/dossiers | 15 | 15060000159804 | 15060000159804 | 1 | PA345619 | PM725692 |
| 15060000159837 | L15/dossiers | 15 | 15060000159836 | 15060000159836 | 1 | PA345619 | PM725692 |
| 15060000159844 | L15/dossiers | 15 | 15060000159843 | 15060000159843 | 1 | PA720430 | PM722962 |
| 15060000159852 | L15/dossiers | 15 | 15060000159851 | 15060000159851 | 1 | PA610681 | PM723150 |
| 15060000159860 | L15/dossiers | 15 | 15060000159859 | 15060000159859 | 1 | PA588884 | PM723226 |
| 15060000159872 | L15/dossiers | 15 | 15060000159871 | 15060000159871 | 1 | PA721718 | PM723364 |
| 15060000159880 | L15/dossiers | 15 | 15060000159879 | 15060000159879 | 1 | PA382672 | PM736263 |
| 15060000159889 | L15/dossiers | 15 | 15060000159888 | 15060000159888 | 1 | PA719302 | PM722620 |
| 15060000159896 | L15/dossiers | 15 | 15060000159895 | 15060000159895 | 1 | PA267440 | PM722522 |
| 15060000159903 | L15/dossiers | 15 | 15060000159902 | 15060000159902 | 1 | PA267440 | PM722522 |
| 15060000159910 | L15/dossiers | 15 | 15060000159909 | 15060000159909 | 1 | PA608416 | PM723540 |
| 15060000159917 | L15/dossiers | 15 | 15060000159916 | 15060000159916 | 1 | PA721210 | PM723204 |
| 15060000159924 | L15/dossiers | 15 | 15060000159923 | 15060000159923 | 1 | PA346218 | PM723348 |
| 15060000159931 | L15/dossiers | 15 | 15060000159930 | 15060000159930 | 1 | PA346054 | PM723510 |
| 15060000159938 | L15/dossiers | 15 | 15060000159937 | 15060000159937 | 1 | PA722390 | PM723560 |
| 15060000159945 | L15/dossiers | 15 | 15060000159944 | 15060000159944 | 1 | PA330684 | PM722528 |
| 15060000159952 | L15/dossiers | 15 | 15060000159951 | 15060000159951 | 1 | PA719608 | PM722710 |
| 15060000159959 | L15/dossiers | 15 | 15060000159958 | 15060000159958 | 1 | PA719960 | PM722816 |
| 15060000160011 | L15/dossiers | 15 | 15060000160010 | 15060000160010 | 1 | PA2150 | PM722506 |
| 15060000160021 | L15/dossiers | 15 | 15060000160020 | 15060000160020 | 1 | PA721226 | PM723208 |
| 15060000160033 | L15/dossiers | 15 | 15060000160032 | 15060000160032 | 1 | PA721210 | PM723204 |
| 15060000160050 | L15/dossiers | 15 | 15060000160049 | 15060000160049 | 1 | PA718838 | PM722474 |
| 15060000160072 | L15/dossiers | 15 | 15060000160071 | 15060000160071 | 1 | PA718884 | PM722488 |
| 15060000160076 | L15/dossiers | 15 | 15060000160075 | 15060000160075 | 1 | PA721888 | PM723412 |
| 15060000160083 | L15/dossiers | 15 | 15060000160082 | 15060000160082 | 1 | PA345619 | PM725692 |
| 15060000160084 | L15/dossiers | 15 | 15060000160082 | 15060000160082 | 2 | PA607846 | PM730066 |
| 15060000160091 | L15/dossiers | 15 | 15060000160090 | 15060000160090 | 1 | PA718838 | PM722474 |
| 15060000160098 | L15/dossiers | 15 | 15060000160097 | 15060000160097 | 1 | PA718838 | PM722474 |
| 15060000160105 | L15/dossiers | 15 | 15060000160104 | 15060000160104 | 1 | PA266788 | PM722914 |
| 15060000160112 | L15/dossiers | 15 | 15060000160111 | 15060000160111 | 1 | PA268019 | PM723092 |
| 15060000160122 | L15/dossiers | 15 | 15060000160121 | 15060000160121 | 1 | PA736206 | PM736351 |
| 15060000160162 | L15/dossiers | 15 | 15060000160161 | 15060000160161 | 1 | PA345619 | PM725692 |
| 15060000160169 | L15/dossiers | 15 | 15060000160168 | 15060000160168 | 1 | PA345619 | PM725692 |
| 15060000160183 | L15/dossiers | 15 | 15060000160182 | 15060000160182 | 1 | PA720430 | PM722962 |
| 15060000160195 | L15/dossiers | 15 | 15060000160194 | 15060000160194 | 1 | PA721960 | PM723434 |