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 |
|---|---|---|---|---|---|---|---|
| 17060000145982 | L17/dossiers | 17 | 17060000145981 | 17060000145981 | 1 | PA841587 | PM843149 |
| 17060000145989 | L17/dossiers | 17 | 17060000145988 | 17060000145988 | 1 | PA794830 | PM843209 |
| 17060000146013 | L17/dossiers | 17 | 17060000146012 | 17060000146012 | 1 | PA841359 | PM842939 |
| 17060000146020 | L17/dossiers | 17 | 17060000146019 | 17060000146019 | 1 | PA722374 | PM843302 |
| 17060000146041 | L17/dossiers | 17 | 17060000146040 | 17060000146040 | 1 | PA793322 | PM840246 |
| 17060000146048 | L17/dossiers | 17 | 17060000146047 | 17060000146047 | 1 | PA793322 | PM840246 |
| 17060000146055 | L17/dossiers | 17 | 17060000146054 | 17060000146054 | 1 | PA720728 | PM843257 |
| 17060000146078 | L17/dossiers | 17 | 17060000146077 | 17060000146077 | 1 | PA793520 | PM842582 |
| 17060000146085 | L17/dossiers | 17 | 17060000146084 | 17060000146084 | 1 | PA643089 | PM858443 |
| 17060000146092 | L17/dossiers | 17 | 17060000146091 | 17060000146091 | 1 | PA794486 | PM843110 |
| 17060000146093 | L17/dossiers | 17 | 17060000146091 | 17060000146091 | 2 | PA795596 | PM840456 |
| 17060000146100 | L17/dossiers | 17 | 17060000146099 | 17060000146099 | 1 | PA794562 | PM840339 |
| 17060000146107 | L17/dossiers | 17 | 17060000146106 | 17060000146106 | 1 | PA840171 | PM840360 |
| 17060000146114 | L17/dossiers | 17 | 17060000146113 | 17060000146113 | 1 | PA793852 | PM842684 |
| 17060000146128 | L17/dossiers | 17 | 17060000146127 | 17060000146127 | 1 | PA827924 | PM828550 |
| 17060000146135 | L17/dossiers | 17 | 17060000146134 | 17060000146134 | 1 | PA795746 | PM843584 |
| 17060000146142 | L17/dossiers | 17 | 17060000146141 | 17060000146141 | 1 | PA643210 | PM873637 |
| 17060000146172 | L17/dossiers | 17 | 17060000146171 | 17060000146171 | 1 | PA873607 | PM873611 |
| 17060000146179 | L17/dossiers | 17 | 17060000146178 | 17060000146178 | 1 | PA866550 | PM866552 |
| 17060000146186 | L17/dossiers | 17 | 17060000146185 | 17060000146185 | 1 | PA608016 | PM874599 |
| 17060000146193 | L17/dossiers | 17 | 17060000146192 | 17060000146192 | 1 | PA719822 | PM842762 |
| 17060000146209 | L17/dossiers | 17 | 17060000146208 | 17060000146208 | 1 | PA794008 | PM842768 |
| 17060000146216 | L17/dossiers | 17 | 17060000146215 | 17060000146215 | 1 | PA841381 | PM842966 |
| 17060000146233 | L17/dossiers | 17 | 17060000146232 | 17060000146232 | 1 | PA643210 | PM873637 |
| 17060000146234 | L17/dossiers | 17 | 17060000146232 | 17060000146232 | 2 | PA721836 | PM873664 |
| 17060000146254 | L17/dossiers | 17 | 17060000146253 | 17060000146253 | 1 | PA795318 | PM843689 |
| 17060000146258 | L17/dossiers | 17 | 17060000146257 | 17060000146257 | 1 | PA736235 | PM874830 |
| 17060000146265 | L17/dossiers | 17 | 17060000146264 | 17060000146264 | 1 | PA736235 | PM874830 |
| 17060000146266 | L17/dossiers | 17 | 17060000146264 | 17060000146264 | 2 | PA736235 | PM874830 |
| 17060000146273 | L17/dossiers | 17 | 17060000146272 | 17060000146272 | 1 | PA785857 | PM785867 |
| 17060000146274 | L17/dossiers | 17 | 17060000146272 | 17060000146272 | 2 | PA827978 | PM828730 |
| 17060000146281 | L17/dossiers | 17 | 17060000146280 | 17060000146280 | 1 | PA268048 | PM829731 |
| 17060000146288 | L17/dossiers | 17 | 17060000146287 | 17060000146287 | 1 | PA736235 | PM874830 |
| 17060000146295 | L17/dossiers | 17 | 17060000146294 | 17060000146294 | 1 | PA859244 | PM859246 |
| 17060000146302 | L17/dossiers | 17 | 17060000146301 | 17060000146301 | 1 | PA720846 | PM840441 |
| 17060000146309 | L17/dossiers | 17 | 17060000146308 | 17060000146308 | 1 | PA721182 | PM843815 |
| 17060000146313 | L17/dossiers | 17 | 17060000146312 | 17060000146312 | 1 | PA721474 | PM843608 |
| 17060000146320 | L17/dossiers | 17 | 17060000146319 | 17060000146319 | 1 | PA736229 | PM829923 |
| 17060000146321 | L17/dossiers | 17 | 17060000146319 | 17060000146319 | 2 | PA785857 | PM785867 |
| 17060000146322 | L17/dossiers | 17 | 17060000146319 | 17060000146319 | 3 | PA760322 | PM775649 |
| 17060000146323 | L17/dossiers | 17 | 17060000146319 | 17060000146319 | 4 | PA703528 | PM775693 |
| 17060000146324 | L17/dossiers | 17 | 17060000146319 | 17060000146319 | 5 | PA721742 | PM829056 |
| 17060000146331 | L17/dossiers | 17 | 17060000146330 | 17060000146330 | 1 | PA736229 | PM829923 |
| 17060000146332 | L17/dossiers | 17 | 17060000146330 | 17060000146330 | 2 | PA785857 | PM785867 |
| 17060000146333 | L17/dossiers | 17 | 17060000146330 | 17060000146330 | 3 | PA760322 | PM775649 |
| 17060000146334 | L17/dossiers | 17 | 17060000146330 | 17060000146330 | 4 | PA703528 | PM775693 |
| 17060000146335 | L17/dossiers | 17 | 17060000146330 | 17060000146330 | 5 | PA721742 | PM829056 |
| 17060000146342 | L17/dossiers | 17 | 17060000146341 | 17060000146341 | 1 | PA643210 | PM873637 |
| 17060000146349 | L17/dossiers | 17 | 17060000146348 | 17060000146348 | 1 | PA736233 | PM829889 |
| 17060000146356 | L17/dossiers | 17 | 17060000146355 | 17060000146355 | 1 | PA643210 | PM873637 |