dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 16060000113098 | L16/dossiers | 16 | 16060000113096 | 16060000113096 | 2 | PA429844 | PM736276 |
| 16060000113099 | L16/dossiers | 16 | 16060000113096 | 16060000113096 | 3 | PA429894 | PM736364 |
| 16060000113100 | L16/dossiers | 16 | 16060000113096 | 16060000113096 | 4 | PA706108 | PM736256 |
| 16060000113101 | L16/dossiers | 16 | 16060000113096 | 16060000113096 | 5 | PA703494 | PM775651 |
| 16060000113102 | L16/dossiers | 16 | 16060000113096 | 16060000113096 | 6 | PA429840 | PM736360 |
| 16060000113103 | L16/dossiers | 16 | 16060000113096 | 16060000113096 | 7 | PA736190 | PM736255 |
| 16060000113110 | L16/dossiers | 16 | 16060000113109 | 16060000113109 | 1 | PA717161 | PM791583 |
| 16060000113111 | L16/dossiers | 16 | 16060000113109 | 16060000113109 | 2 | PA312976 | PM791676 |
| 16060000113142 | L16/dossiers | 16 | 16060000113141 | 16060000113141 | 1 | PA775302 | PM775598 |
| 16060000113183 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 1 | PA775282 | PM775584 |
| 16060000113184 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 2 | PA429866 | PM736287 |
| 16060000113185 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 3 | PA775180 | PM775466 |
| 16060000113186 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 4 | PA801838 | PM801842 |
| 16060000113187 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 5 | PA429845 | PM736278 |
| 16060000113188 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 6 | PA775214 | PM775498 |
| 16060000113189 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 7 | PA775224 | PM775512 |
| 16060000113190 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 8 | PA736177 | PM736318 |
| 16060000113191 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 9 | PA775252 | PM775558 |
| 16060000113192 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 10 | PA775262 | PM775548 |
| 16060000113193 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 11 | PA775272 | PM775562 |
| 16060000113194 | L16/dossiers | 16 | 16060000113182 | 16060000113182 | 12 | PA785857 | PM785867 |
| 16060000113201 | L16/dossiers | 16 | 16060000113200 | 16060000113200 | 1 | PA717161 | PM791583 |
| 16060000113216 | L16/dossiers | 16 | 16060000113215 | 16060000113215 | 1 | PA719318 | PM796470 |
| 16060000113223 | L16/dossiers | 16 | 16060000113222 | 16060000113222 | 1 | PA793122 | PM796161 |
| 16060000113230 | L16/dossiers | 16 | 16060000113229 | 16060000113229 | 1 | PA610002 | PM797286 |
| 16060000113237 | L16/dossiers | 16 | 16060000113236 | 16060000113236 | 1 | PA720892 | PM797520 |
| 16060000113251 | L16/dossiers | 16 | 16060000113250 | 16060000113250 | 1 | PA330240 | PM796155 |
| 16060000113258 | L16/dossiers | 16 | 16060000113257 | 16060000113257 | 1 | PA1327 | PM796632 |
| 16060000113265 | L16/dossiers | 16 | 16060000113264 | 16060000113264 | 1 | PA793342 | PM796269 |
| 16060000113269 | L16/dossiers | 16 | 16060000113268 | 16060000113268 | 1 | PA719608 | PM796593 |
| 16060000113276 | L16/dossiers | 16 | 16060000113275 | 16060000113275 | 1 | PA720614 | PM797055 |
| 16060000113280 | L16/dossiers | 16 | 16060000113279 | 16060000113279 | 1 | PA643089 | PM797439 |
| 16060000113287 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 1 | PA736191 | PM736336 |
| 16060000113288 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 2 | PA703505 | PM775679 |
| 16060000113289 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 3 | PA775200 | PM775504 |
| 16060000113290 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 4 | PA775210 | PM775492 |
| 16060000113291 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 5 | PA429867 | PM736298 |
| 16060000113292 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 6 | PA429833 | PM736271 |
| 16060000113293 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 7 | PA703509 | PM775687 |
| 16060000113294 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 8 | PA736181 | PM736416 |
| 16060000113295 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 9 | PA268048 | PM736422 |
| 16060000113296 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 10 | PA702993 | PM736362 |
| 16060000113297 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 11 | PA736219 | PM736387 |
| 16060000113298 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 12 | PA775186 | PM775484 |
| 16060000113299 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 13 | PA415488 | PM775641 |
| 16060000113300 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 14 | PA775194 | PM775476 |
| 16060000113301 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 15 | PA775196 | PM775482 |
| 16060000113302 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 16 | PA775206 | PM775506 |
| 16060000113303 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 17 | PA590034 | PM775606 |
| 16060000113304 | L16/dossiers | 16 | 16060000113286 | 16060000113286 | 18 | PA785855 | PM785869 |