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 |
|---|---|---|---|---|---|---|---|
| 15060000153692 | L15/dossiers | 15 | 15060000153691 | 15060000153691 | 1 | PA2774 | PM736307 |
| 15060000153699 | L15/dossiers | 15 | 15060000153698 | 15060000153698 | 1 | PA2774 | PM736307 |
| 15060000153709 | L15/dossiers | 15 | 15060000153708 | 15060000153708 | 1 | PA345619 | PM725692 |
| 15060000153710 | L15/dossiers | 15 | 15060000153708 | 15060000153708 | 2 | PA331481 | PM730094 |
| 15060000153717 | L15/dossiers | 15 | 15060000153716 | 15060000153716 | 1 | PA345619 | PM725692 |
| 15060000153718 | L15/dossiers | 15 | 15060000153716 | 15060000153716 | 2 | PA717153 | PM730062 |
| 15060000153725 | L15/dossiers | 15 | 15060000153724 | 15060000153724 | 1 | PA720546 | PM722996 |
| 15060000153732 | L15/dossiers | 15 | 15060000153731 | 15060000153731 | 1 | PA721062 | PM723158 |
| 15060000153739 | L15/dossiers | 15 | 15060000153738 | 15060000153738 | 1 | PA345619 | PM725692 |
| 15060000153740 | L15/dossiers | 15 | 15060000153738 | 15060000153738 | 2 | PA607846 | PM730066 |
| 15060000153741 | L15/dossiers | 15 | 15060000153738 | 15060000153738 | 3 | PA717153 | PM730062 |
| 15060000153858 | L15/dossiers | 15 | 15060000153857 | 15060000153857 | 1 | PA736233 | PM736411 |
| 15060000153859 | L15/dossiers | 15 | 15060000153857 | 15060000153857 | 2 | PA736170 | PM736266 |
| 15060000153869 | L15/dossiers | 15 | 15060000153868 | 15060000153868 | 1 | PA719942 | PM760307 |
| 15060000153876 | L15/dossiers | 15 | 15060000153875 | 15060000153875 | 1 | PA721062 | PM723158 |
| 15060000153883 | L15/dossiers | 15 | 15060000153882 | 15060000153882 | 1 | PA736176 | PM736434 |
| 15060000153902 | L15/dossiers | 15 | 15060000153901 | 15060000153901 | 1 | PA267112 | PM703608 |
| 15060000153909 | L15/dossiers | 15 | 15060000153908 | 15060000153908 | 1 | PA345619 | PM725692 |
| 15060000153916 | L15/dossiers | 15 | 15060000153915 | 15060000153915 | 1 | PA345619 | PM725692 |
| 15060000153923 | L15/dossiers | 15 | 15060000153922 | 15060000153922 | 1 | PA345619 | PM725692 |
| 15060000153930 | L15/dossiers | 15 | 15060000153929 | 15060000153929 | 1 | PA703521 | PM703544 |
| 15060000153937 | L15/dossiers | 15 | 15060000153936 | 15060000153936 | 1 | PA429842 | PM736373 |
| 15060000153944 | L15/dossiers | 15 | 15060000153943 | 15060000153943 | 1 | PA429842 | PM736373 |
| 15060000153964 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 1 | PA702993 | PM736362 |
| 15060000153965 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 2 | PA733 | PM703709 |
| 15060000153966 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 3 | PA703505 | PM703626 |
| 15060000153967 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 4 | PA429867 | PM736298 |
| 15060000153968 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 5 | PA703490 | PM703631 |
| 15060000153969 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 6 | PA341272 | PM703643 |
| 15060000153970 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 7 | PA429833 | PM736271 |
| 15060000153971 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 8 | PA736191 | PM736336 |
| 15060000153972 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 9 | PA736181 | PM736416 |
| 15060000153973 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 10 | PA703533 | PM703593 |
| 15060000153974 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 11 | PA268048 | PM736422 |
| 15060000153975 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 12 | PA703511 | PM703635 |
| 15060000153976 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 13 | PA736201 | PM736347 |
| 15060000153977 | L15/dossiers | 15 | 15060000153963 | 15060000153963 | 14 | PA736214 | PM736290 |
| 15060000153996 | L15/dossiers | 15 | 15060000153995 | 15060000153995 | 1 | PA341406 | PM703619 |
| 15060000154015 | L15/dossiers | 15 | 15060000154014 | 15060000154014 | 1 | PA747420 | PM747430 |
| 15060000154016 | L15/dossiers | 15 | 15060000154014 | 15060000154014 | 2 | PA304017 | PM703669 |
| 15060000154017 | L15/dossiers | 15 | 15060000154014 | 15060000154014 | 3 | PA301592 | PM736375 |
| 15060000154073 | L15/dossiers | 15 | 15060000154072 | 15060000154072 | 1 | PA304017 | PM703669 |
| 15060000154119 | L15/dossiers | 15 | 15060000154118 | 15060000154118 | 1 | PA736169 | PM736293 |
| 15060000154138 | L15/dossiers | 15 | 15060000154137 | 15060000154137 | 1 | PA720546 | PM722996 |
| 15060000154142 | L15/dossiers | 15 | 15060000154141 | 15060000154141 | 1 | PA721816 | PM748964 |
| 15060000154146 | L15/dossiers | 15 | 15060000154145 | 15060000154145 | 1 | PA998 | PM723046 |
| 15060000154153 | L15/dossiers | 15 | 15060000154152 | 15060000154152 | 1 | PA720468 | PM722972 |
| 15060000154160 | L15/dossiers | 15 | 15060000154159 | 15060000154159 | 1 | PA719504 | PM722680 |
| 15060000154186 | L15/dossiers | 15 | 15060000154185 | 15060000154185 | 1 | PA717379 | PM723282 |
| 15060000154193 | L15/dossiers | 15 | 15060000154192 | 15060000154192 | 1 | PA722312 | PM723536 |