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 |
|---|---|---|---|---|---|---|---|
| 15060000139407 | L15/dossiers | 15 | 15060000139406 | 15060000139406 | 1 | PA2952 | PM722480 |
| 15060000139414 | L15/dossiers | 15 | 15060000139413 | 15060000139413 | 1 | PA606171 | PM722632 |
| 15060000139447 | L15/dossiers | 15 | 15060000139446 | 15060000139446 | 1 | PA606171 | PM722632 |
| 15060000139501 | L15/dossiers | 15 | 15060000139500 | 15060000139500 | 1 | PA722150 | PM723486 |
| 15060000139508 | L15/dossiers | 15 | 15060000139507 | 15060000139507 | 1 | PA608016 | PM723024 |
| 15060000139515 | L15/dossiers | 15 | 15060000139514 | 15060000139514 | 1 | PA605036 | PM722444 |
| 15060000139541 | L15/dossiers | 15 | 15060000139540 | 15060000139540 | 1 | PA345619 | PM725692 |
| 15060000139671 | L15/dossiers | 15 | 15060000139670 | 15060000139670 | 1 | PA345619 | PM725692 |
| 15060000139803 | L15/dossiers | 15 | 15060000139802 | 15060000139802 | 1 | PA266774 | PM723526 |
| 15060000139810 | L15/dossiers | 15 | 15060000139809 | 15060000139809 | 1 | PA713448 | PM722452 |
| 15060000139821 | L15/dossiers | 15 | 15060000139820 | 15060000139820 | 1 | PA722150 | PM723486 |
| 15060000139839 | L15/dossiers | 15 | 15060000139838 | 15060000139838 | 1 | PA721150 | PM723188 |
| 15060000139840 | L15/dossiers | 15 | 15060000139838 | 15060000139838 | 2 | PA267794 | PM722468 |
| 15060000139854 | L15/dossiers | 15 | 15060000139853 | 15060000139853 | 1 | PA345619 | PM725692 |
| 15060000139861 | L15/dossiers | 15 | 15060000139860 | 15060000139860 | 1 | PA330008 | PM722416 |
| 15060000139868 | L15/dossiers | 15 | 15060000139867 | 15060000139867 | 1 | PA345619 | PM725692 |
| 15060000139869 | L15/dossiers | 15 | 15060000139867 | 15060000139867 | 2 | PA906 | PM730043 |
| 15060000139886 | L15/dossiers | 15 | 15060000139885 | 15060000139885 | 1 | PA345619 | PM725692 |
| 15060000139887 | L15/dossiers | 15 | 15060000139885 | 15060000139885 | 2 | PA906 | PM730043 |
| 15060000139907 | L15/dossiers | 15 | 15060000139906 | 15060000139906 | 1 | PA345619 | PM725692 |
| 15060000139908 | L15/dossiers | 15 | 15060000139906 | 15060000139906 | 2 | PA607846 | PM730066 |
| 15060000140016 | L15/dossiers | 15 | 15060000140015 | 15060000140015 | 1 | PA721314 | PM723236 |
| 15060000140023 | L15/dossiers | 15 | 15060000140022 | 15060000140022 | 1 | PA266774 | PM723526 |
| 15060000140030 | L15/dossiers | 15 | 15060000140029 | 15060000140029 | 1 | PA266774 | PM723526 |
| 15060000140037 | L15/dossiers | 15 | 15060000140036 | 15060000140036 | 1 | PA719980 | PM722822 |
| 15060000140047 | L15/dossiers | 15 | 15060000140046 | 15060000140046 | 1 | PA721286 | PM723224 |
| 15060000140054 | L15/dossiers | 15 | 15060000140053 | 15060000140053 | 1 | PA1327 | PM722762 |
| 15060000140061 | L15/dossiers | 15 | 15060000140060 | 15060000140060 | 1 | PA719676 | PM722728 |
| 15060000140065 | L15/dossiers | 15 | 15060000140064 | 15060000140064 | 1 | PA223837 | PM722458 |
| 15060000140072 | L15/dossiers | 15 | 15060000140071 | 15060000140071 | 1 | PA346218 | PM723348 |
| 15060000140079 | L15/dossiers | 15 | 15060000140078 | 15060000140078 | 1 | PA605991 | PM722660 |
| 15060000140086 | L15/dossiers | 15 | 15060000140085 | 15060000140085 | 1 | PA1695 | PM723322 |
| 15060000140105 | L15/dossiers | 15 | 15060000140104 | 15060000140104 | 1 | PA1327 | PM722762 |
| 15060000140112 | L15/dossiers | 15 | 15060000140111 | 15060000140111 | 1 | PA721286 | PM723224 |
| 15060000140119 | L15/dossiers | 15 | 15060000140118 | 15060000140118 | 1 | PA1327 | PM722762 |
| 15060000140126 | L15/dossiers | 15 | 15060000140125 | 15060000140125 | 1 | PA720696 | PM723044 |
| 15060000140133 | L15/dossiers | 15 | 15060000140132 | 15060000140132 | 1 | PA719946 | PM722808 |
| 15060000140140 | L15/dossiers | 15 | 15060000140139 | 15060000140139 | 1 | PA330240 | PM722492 |
| 15060000140147 | L15/dossiers | 15 | 15060000140146 | 15060000140146 | 1 | PA721062 | PM723158 |
| 15060000140154 | L15/dossiers | 15 | 15060000140153 | 15060000140153 | 1 | PA330684 | PM722528 |
| 15060000140161 | L15/dossiers | 15 | 15060000140160 | 15060000140160 | 1 | PA719608 | PM722710 |
| 15060000140171 | L15/dossiers | 15 | 15060000140170 | 15060000140170 | 1 | PA345619 | PM725692 |
| 15060000140172 | L15/dossiers | 15 | 15060000140170 | 15060000140170 | 2 | PA331481 | PM730094 |
| 15060000140188 | L15/dossiers | 15 | 15060000140187 | 15060000140187 | 1 | PA720030 | PM722838 |
| 15060000140189 | L15/dossiers | 15 | 15060000140187 | 15060000140187 | 2 | PA267306 | PM723054 |
| 15060000140206 | L15/dossiers | 15 | 15060000140205 | 15060000140205 | 1 | PA345619 | PM725692 |
| 15060000140241 | L15/dossiers | 15 | 15060000140240 | 15060000140240 | 1 | PA2792 | PM722870 |
| 15060000140248 | L15/dossiers | 15 | 15060000140247 | 15060000140247 | 1 | PA2792 | PM722870 |
| 15060000140255 | L15/dossiers | 15 | 15060000140254 | 15060000140254 | 1 | PA2377 | PM723550 |
| 15060000140262 | L15/dossiers | 15 | 15060000140261 | 15060000140261 | 1 | PA2377 | PM723550 |