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 |
|---|---|---|---|---|---|---|---|
| 15060000157078 | L15/dossiers | 15 | 15060000157068 | 15060000157068 | 10 | PA736201 | PM736347 |
| 15060000157079 | L15/dossiers | 15 | 15060000157068 | 15060000157068 | 11 | PA2870 | PM736316 |
| 15060000157080 | L15/dossiers | 15 | 15060000157068 | 15060000157068 | 12 | PA2870 | PM736316 |
| 15060000157081 | L15/dossiers | 15 | 15060000157068 | 15060000157068 | 13 | PA703511 | PM703635 |
| 15060000157082 | L15/dossiers | 15 | 15060000157068 | 15060000157068 | 14 | PA736187 | PM736365 |
| 15060000157083 | L15/dossiers | 15 | 15060000157068 | 15060000157068 | 15 | PA736215 | PM736324 |
| 15060000157084 | L15/dossiers | 15 | 15060000157068 | 15060000157068 | 16 | PA429844 | PM736276 |
| 15060000157091 | L15/dossiers | 15 | 15060000157090 | 15060000157090 | 1 | PA415456 | PM736433 |
| 15060000157092 | L15/dossiers | 15 | 15060000157090 | 15060000157090 | 2 | PA415456 | PM736433 |
| 15060000157099 | L15/dossiers | 15 | 15060000157098 | 15060000157098 | 1 | PA415446 | PM703678 |
| 15060000157106 | L15/dossiers | 15 | 15060000157105 | 15060000157105 | 1 | PA341381 | PM703618 |
| 15060000157113 | L15/dossiers | 15 | 15060000157112 | 15060000157112 | 1 | PA709750 | PM736295 |
| 15060000157120 | L15/dossiers | 15 | 15060000157119 | 15060000157119 | 1 | PA429855 | PM736425 |
| 15060000157127 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 1 | PA736238 | PM736352 |
| 15060000157128 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 2 | PA736192 | PM736353 |
| 15060000157129 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 3 | PA744079 | PM744082 |
| 15060000157130 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 4 | PA736198 | PM736406 |
| 15060000157131 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 5 | PA736231 | PM736381 |
| 15060000157132 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 6 | PA736216 | PM736273 |
| 15060000157133 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 7 | PA736176 | PM736434 |
| 15060000157134 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 8 | PA267340 | PM703713 |
| 15060000157135 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 9 | PA1001 | PM736371 |
| 15060000157136 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 10 | PA703539 | PM703693 |
| 15060000157137 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 11 | PA736218 | PM736257 |
| 15060000157138 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 12 | PA736169 | PM736293 |
| 15060000157139 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 13 | PA1344 | PM736383 |
| 15060000157140 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 14 | PA304108 | PM736399 |
| 15060000157141 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 15 | PA703507 | PM703567 |
| 15060000157142 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 16 | PA736205 | PM736288 |
| 15060000157143 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 17 | PA394676 | PM703550 |
| 15060000157144 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 18 | PA304000 | PM703599 |
| 15060000157145 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 19 | PA736246 | PM736428 |
| 15060000157146 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 20 | PA415451 | PM703594 |
| 15060000157147 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 21 | PA429875 | PM736302 |
| 15060000157148 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 22 | PA703488 | PM703632 |
| 15060000157149 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 23 | PA703517 | PM703625 |
| 15060000157150 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 24 | PA343988 | PM736310 |
| 15060000157151 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 25 | PA267328 | PM703547 |
| 15060000157152 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 26 | PA2447 | PM703679 |
| 15060000157153 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 27 | PA429842 | PM736373 |
| 15060000157154 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 28 | PA267018 | PM703564 |
| 15060000157155 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 29 | PA736213 | PM736431 |
| 15060000157156 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 30 | PA1993 | PM736402 |
| 15060000157157 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 31 | PA2237 | PM703705 |
| 15060000157158 | L15/dossiers | 15 | 15060000157126 | 15060000157126 | 32 | PA703527 | PM703580 |
| 15060000157165 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 1 | PA736238 | PM736352 |
| 15060000157166 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 2 | PA736198 | PM736406 |
| 15060000157167 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 3 | PA342665 | PM736382 |
| 15060000157168 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 4 | PA736231 | PM736381 |
| 15060000157169 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 5 | PA736216 | PM736273 |