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 |
|---|---|---|---|---|---|---|---|
| 15060000129629 | L15/dossiers | 15 | 15060000129627 | 15060000129627 | 2 | PA717169 | PM730074 |
| 15060000129712 | L15/dossiers | 15 | 15060000129711 | 15060000129711 | 1 | PA345619 | PM725692 |
| 15060000129713 | L15/dossiers | 15 | 15060000129711 | 15060000129711 | 2 | PA607846 | PM730066 |
| 15060000129743 | L15/dossiers | 15 | 15060000129742 | 15060000129742 | 1 | PA345619 | PM725692 |
| 15060000129744 | L15/dossiers | 15 | 15060000129742 | 15060000129742 | 2 | PA729330 | PM730072 |
| 15060000129777 | L15/dossiers | 15 | 15060000129776 | 15060000129776 | 1 | PA345619 | PM725692 |
| 15060000129778 | L15/dossiers | 15 | 15060000129776 | 15060000129776 | 2 | PA717147 | PM730068 |
| 15060000129831 | L15/dossiers | 15 | 15060000129830 | 15060000129830 | 1 | PA345619 | PM725692 |
| 15060000129832 | L15/dossiers | 15 | 15060000129830 | 15060000129830 | 2 | PA1872 | PM730104 |
| 15060000129867 | L15/dossiers | 15 | 15060000129866 | 15060000129866 | 1 | PA345619 | PM725692 |
| 15060000129868 | L15/dossiers | 15 | 15060000129866 | 15060000129866 | 2 | PA1872 | PM730104 |
| 15060000129901 | L15/dossiers | 15 | 15060000129900 | 15060000129900 | 1 | PA345619 | PM725692 |
| 15060000129902 | L15/dossiers | 15 | 15060000129900 | 15060000129900 | 2 | PA717153 | PM730062 |
| 15060000129978 | L15/dossiers | 15 | 15060000129977 | 15060000129977 | 1 | PA345619 | PM725692 |
| 15060000129979 | L15/dossiers | 15 | 15060000129977 | 15060000129977 | 2 | PA717153 | PM730062 |
| 15060000130033 | L15/dossiers | 15 | 15060000130032 | 15060000130032 | 1 | PA345619 | PM725692 |
| 15060000130034 | L15/dossiers | 15 | 15060000130032 | 15060000130032 | 2 | PA717153 | PM730062 |
| 15060000130067 | L15/dossiers | 15 | 15060000130066 | 15060000130066 | 1 | PA713448 | PM722452 |
| 15060000130074 | L15/dossiers | 15 | 15060000130073 | 15060000130073 | 1 | PA345619 | PM725692 |
| 15060000130105 | L15/dossiers | 15 | 15060000130104 | 15060000130104 | 1 | PA345619 | PM725692 |
| 15060000130136 | L15/dossiers | 15 | 15060000130135 | 15060000130135 | 1 | PA345619 | PM725692 |
| 15060000130137 | L15/dossiers | 15 | 15060000130135 | 15060000130135 | 2 | PA607846 | PM730066 |
| 15060000130147 | L15/dossiers | 15 | 15060000130146 | 15060000130146 | 1 | PA345619 | PM725692 |
| 15060000130148 | L15/dossiers | 15 | 15060000130146 | 15060000130146 | 2 | PA607846 | PM730066 |
| 15060000130873 | L15/dossiers | 15 | 15060000130872 | 15060000130872 | 1 | PA267306 | PM723054 |
| 15060000130880 | L15/dossiers | 15 | 15060000130879 | 15060000130879 | 1 | PA718850 | PM722478 |
| 15060000130898 | L15/dossiers | 15 | 15060000130897 | 15060000130897 | 1 | PA345619 | PM725692 |
| 15060000130982 | L15/dossiers | 15 | 15060000130981 | 15060000130981 | 1 | PA718850 | PM722478 |
| 15060000131001 | L15/dossiers | 15 | 15060000131000 | 15060000131000 | 1 | PA345619 | PM725692 |
| 15060000131019 | L15/dossiers | 15 | 15060000131018 | 15060000131018 | 1 | PA345619 | PM725692 |
| 15060000131026 | L15/dossiers | 15 | 15060000131025 | 15060000131025 | 1 | PA1874 | PM722598 |
| 15060000131033 | L15/dossiers | 15 | 15060000131032 | 15060000131032 | 1 | PA712015 | PM722448 |
| 15060000131040 | L15/dossiers | 15 | 15060000131039 | 15060000131039 | 1 | PA606098 | PM722642 |
| 15060000131047 | L15/dossiers | 15 | 15060000131046 | 15060000131046 | 1 | PA2952 | PM722480 |
| 15060000131054 | L15/dossiers | 15 | 15060000131053 | 15060000131053 | 1 | PA606212 | PM722662 |
| 15060000131067 | L15/dossiers | 15 | 15060000131066 | 15060000131066 | 1 | PA606212 | PM722662 |
| 15060000131074 | L15/dossiers | 15 | 15060000131073 | 15060000131073 | 1 | PA606212 | PM722662 |
| 15060000131081 | L15/dossiers | 15 | 15060000131080 | 15060000131080 | 1 | PA718838 | PM722474 |
| 15060000131088 | L15/dossiers | 15 | 15060000131087 | 15060000131087 | 1 | PA1874 | PM722598 |
| 15060000131095 | L15/dossiers | 15 | 15060000131094 | 15060000131094 | 1 | PA1874 | PM722598 |
| 15060000131102 | L15/dossiers | 15 | 15060000131101 | 15060000131101 | 1 | PA642868 | PM722992 |
| 15060000131109 | L15/dossiers | 15 | 15060000131108 | 15060000131108 | 1 | PA267260 | PM722476 |
| 15060000131116 | L15/dossiers | 15 | 15060000131115 | 15060000131115 | 1 | PA1874 | PM722598 |
| 15060000131123 | L15/dossiers | 15 | 15060000131122 | 15060000131122 | 1 | PA718838 | PM722474 |
| 15060000131130 | L15/dossiers | 15 | 15060000131129 | 15060000131129 | 1 | PA1874 | PM722598 |
| 15060000131137 | L15/dossiers | 15 | 15060000131136 | 15060000131136 | 1 | PA267673 | PM723306 |
| 15060000131144 | L15/dossiers | 15 | 15060000131143 | 15060000131143 | 1 | PA719946 | PM722808 |
| 15060000131152 | L15/dossiers | 15 | 15060000131151 | 15060000131151 | 1 | PA1874 | PM722598 |
| 15060000131159 | L15/dossiers | 15 | 15060000131158 | 15060000131158 | 1 | PA1874 | PM722598 |
| 15060000131166 | L15/dossiers | 15 | 15060000131165 | 15060000131165 | 1 | PA1874 | PM722598 |