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 |
|---|---|---|---|---|---|---|---|
| 15060000187022 | L15/dossiers | 15 | 15060000187021 | 15060000187021 | 1 | PA702992 | PM717139 |
| 15060000187026 | L15/dossiers | 15 | 15060000187025 | 15060000187025 | 1 | PA774962 | PM774987 |
| 15060000187030 | L15/dossiers | 15 | 15060000187029 | 15060000187029 | 1 | PA719020 | PM774184 |
| 15060000187037 | L15/dossiers | 15 | 15060000187036 | 15060000187036 | 1 | PA721960 | PM723434 |
| 15060000187044 | L15/dossiers | 15 | 15060000187043 | 15060000187043 | 1 | PA267785 | PM723310 |
| 15060000187051 | L15/dossiers | 15 | 15060000187050 | 15060000187050 | 1 | PA267785 | PM723310 |
| 15060000187058 | L15/dossiers | 15 | 15060000187057 | 15060000187057 | 1 | PA719436 | PM770316 |
| 15060000187062 | L15/dossiers | 15 | 15060000187061 | 15060000187061 | 1 | PA719952 | PM722814 |
| 15060000187069 | L15/dossiers | 15 | 15060000187068 | 15060000187068 | 1 | PA720892 | PM723106 |
| 15060000187076 | L15/dossiers | 15 | 15060000187075 | 15060000187075 | 1 | PA643089 | PM758076 |
| 15060000187083 | L15/dossiers | 15 | 15060000187082 | 15060000187082 | 1 | PA719710 | PM722738 |
| 15060000187090 | L15/dossiers | 15 | 15060000187089 | 15060000187089 | 1 | PA643089 | PM758076 |
| 15060000187097 | L15/dossiers | 15 | 15060000187096 | 15060000187096 | 1 | PA1592 | PM723060 |
| 15060000187104 | L15/dossiers | 15 | 15060000187103 | 15060000187103 | 1 | PA783457 | PM783488 |
| 15060000187111 | L15/dossiers | 15 | 15060000187110 | 15060000187110 | 1 | PA783457 | PM783488 |
| 15060000187118 | L15/dossiers | 15 | 15060000187117 | 15060000187117 | 1 | PA721194 | PM723200 |
| 15060000187122 | L15/dossiers | 15 | 15060000187121 | 15060000187121 | 1 | PA773441 | PM773491 |
| 15060000187129 | L15/dossiers | 15 | 15060000187128 | 15060000187128 | 1 | PA721726 | PM723366 |
| 15060000187142 | L15/dossiers | 15 | 15060000187141 | 15060000187141 | 1 | PA720488 | PM772842 |
| 15060000187149 | L15/dossiers | 15 | 15060000187148 | 15060000187148 | 1 | PA343988 | PM736310 |
| 15060000187156 | L15/dossiers | 15 | 15060000187155 | 15060000187155 | 1 | PA426327 | PM775735 |
| 15060000187163 | L15/dossiers | 15 | 15060000187162 | 15060000187162 | 1 | PA382672 | PM736263 |
| 15060000187170 | L15/dossiers | 15 | 15060000187169 | 15060000187169 | 1 | PA719464 | PM722670 |
| 15060000187174 | L15/dossiers | 15 | 15060000187173 | 15060000187173 | 1 | PA721760 | PM779695 |
| 15060000187178 | L15/dossiers | 15 | 15060000187177 | 15060000187177 | 1 | PA773441 | PM773491 |
| 15060000187179 | L15/dossiers | 15 | 15060000187177 | 15060000187177 | 2 | PA331481 | PM773459 |
| 15060000187180 | L15/dossiers | 15 | 15060000187177 | 15060000187177 | 3 | PA643210 | PM773481 |
| 15060000187193 | L15/dossiers | 15 | 15060000187192 | 15060000187192 | 1 | PA703513 | PM775671 |
| 15060000187206 | L15/dossiers | 15 | 15060000187205 | 15060000187205 | 1 | PA773441 | PM773491 |
| 15060000187207 | L15/dossiers | 15 | 15060000187205 | 15060000187205 | 2 | PA717161 | PM773483 |
| 15060000187208 | L15/dossiers | 15 | 15060000187205 | 15060000187205 | 3 | PA642788 | PM773495 |
| 15060000187215 | L15/dossiers | 15 | 15060000187214 | 15060000187214 | 1 | PA773441 | PM773491 |
| 15060000187222 | L15/dossiers | 15 | 15060000187221 | 15060000187221 | 1 | PA382672 | PM736263 |
| 15060000187229 | L15/dossiers | 15 | 15060000187228 | 15060000187228 | 1 | PA720634 | PM736312 |
| 15060000187236 | L15/dossiers | 15 | 15060000187235 | 15060000187235 | 1 | PA721194 | PM723200 |
| 15060000187243 | L15/dossiers | 15 | 15060000187242 | 15060000187242 | 1 | PA2150 | PM722506 |
| 15060000187250 | L15/dossiers | 15 | 15060000187249 | 15060000187249 | 1 | PA266788 | PM722914 |
| 15060000187260 | L15/dossiers | 15 | 15060000187259 | 15060000187259 | 1 | PA720802 | PM774333 |
| 15060000187267 | L15/dossiers | 15 | 15060000187266 | 15060000187266 | 1 | PA721246 | PM723214 |
| 15060000187274 | L15/dossiers | 15 | 15060000187273 | 15060000187273 | 1 | PA719946 | PM722808 |
| 15060000187281 | L15/dossiers | 15 | 15060000187280 | 15060000187280 | 1 | PA205280 | PM736412 |
| 15060000187282 | L15/dossiers | 15 | 15060000187280 | 15060000187280 | 2 | PA267872 | PM736409 |
| 15060000187289 | L15/dossiers | 15 | 15060000187288 | 15060000187288 | 1 | PA719946 | PM722808 |
| 15060000187296 | L15/dossiers | 15 | 15060000187295 | 15060000187295 | 1 | PA719946 | PM722808 |
| 15060000187303 | L15/dossiers | 15 | 15060000187302 | 15060000187302 | 1 | PA719946 | PM722808 |
| 15060000187310 | L15/dossiers | 15 | 15060000187309 | 15060000187309 | 1 | PA718780 | PM722454 |
| 15060000187317 | L15/dossiers | 15 | 15060000187316 | 15060000187316 | 1 | PA719946 | PM722808 |
| 15060000187324 | L15/dossiers | 15 | 15060000187323 | 15060000187323 | 1 | PA346054 | PM723510 |
| 15060000187331 | L15/dossiers | 15 | 15060000187330 | 15060000187330 | 1 | PA721174 | PM723194 |
| 15060000187338 | L15/dossiers | 15 | 15060000187337 | 15060000187337 | 1 | PA720402 | PM722952 |