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 |
|---|---|---|---|---|---|---|---|
| 15060000181154 | L15/dossiers | 15 | 15060000181153 | 15060000181153 | 1 | PA720988 | PM723132 |
| 15060000181161 | L15/dossiers | 15 | 15060000181160 | 15060000181160 | 1 | PA330008 | PM722416 |
| 15060000181168 | L15/dossiers | 15 | 15060000181167 | 15060000181167 | 1 | PA722194 | PM760311 |
| 15060000181175 | L15/dossiers | 15 | 15060000181174 | 15060000181174 | 1 | PA608695 | PM723564 |
| 15060000181182 | L15/dossiers | 15 | 15060000181181 | 15060000181181 | 1 | PA713448 | PM722452 |
| 15060000181189 | L15/dossiers | 15 | 15060000181188 | 15060000181188 | 1 | PA720988 | PM723132 |
| 15060000181196 | L15/dossiers | 15 | 15060000181195 | 15060000181195 | 1 | PA268019 | PM723092 |
| 15060000181203 | L15/dossiers | 15 | 15060000181202 | 15060000181202 | 1 | PA722312 | PM723536 |
| 15060000181210 | L15/dossiers | 15 | 15060000181209 | 15060000181209 | 1 | PA719448 | PM722666 |
| 15060000181217 | L15/dossiers | 15 | 15060000181216 | 15060000181216 | 1 | PA304108 | PM736399 |
| 15060000181224 | L15/dossiers | 15 | 15060000181223 | 15060000181223 | 1 | PA382672 | PM736263 |
| 15060000181225 | L15/dossiers | 15 | 15060000181223 | 15060000181223 | 2 | PA227029 | PM736306 |
| 15060000181226 | L15/dossiers | 15 | 15060000181223 | 15060000181223 | 3 | PA784534 | PM784544 |
| 15060000181227 | L15/dossiers | 15 | 15060000181223 | 15060000181223 | 4 | PA775250 | PM775552 |
| 15060000181228 | L15/dossiers | 15 | 15060000181223 | 15060000181223 | 5 | PA775188 | PM775490 |
| 15060000181229 | L15/dossiers | 15 | 15060000181223 | 15060000181223 | 6 | PA707706 | PM775741 |
| 15060000181230 | L15/dossiers | 15 | 15060000181223 | 15060000181223 | 7 | PA1883 | PM736286 |
| 15060000181231 | L15/dossiers | 15 | 15060000181223 | 15060000181223 | 8 | PA703501 | PM775645 |
| 15060000181238 | L15/dossiers | 15 | 15060000181237 | 15060000181237 | 1 | PA267330 | PM723392 |
| 15060000181245 | L15/dossiers | 15 | 15060000181244 | 15060000181244 | 1 | PA720100 | PM722860 |
| 15060000181262 | L15/dossiers | 15 | 15060000181261 | 15060000181261 | 1 | PA267794 | PM722468 |
| 15060000181269 | L15/dossiers | 15 | 15060000181268 | 15060000181268 | 1 | PA773441 | PM773491 |
| 15060000181270 | L15/dossiers | 15 | 15060000181268 | 15060000181268 | 2 | PA1872 | PM773455 |
| 15060000181292 | L15/dossiers | 15 | 15060000181291 | 15060000181291 | 1 | PA773441 | PM773491 |
| 15060000181293 | L15/dossiers | 15 | 15060000181291 | 15060000181291 | 2 | PA332 | PM773507 |
| 15060000181300 | L15/dossiers | 15 | 15060000181299 | 15060000181299 | 1 | PA721486 | PM723290 |
| 15060000181307 | L15/dossiers | 15 | 15060000181306 | 15060000181306 | 1 | PA713448 | PM722452 |
| 15060000181311 | L15/dossiers | 15 | 15060000181310 | 15060000181310 | 1 | PA773441 | PM773491 |
| 15060000181344 | L15/dossiers | 15 | 15060000181343 | 15060000181343 | 1 | PA773441 | PM773491 |
| 15060000181345 | L15/dossiers | 15 | 15060000181343 | 15060000181343 | 2 | PA331481 | PM773459 |
| 15060000181352 | L15/dossiers | 15 | 15060000181351 | 15060000181351 | 1 | PA773441 | PM773491 |
| 15060000181353 | L15/dossiers | 15 | 15060000181351 | 15060000181351 | 2 | PA331481 | PM773459 |
| 15060000181360 | L15/dossiers | 15 | 15060000181359 | 15060000181359 | 1 | PA721486 | PM723290 |
| 15060000181367 | L15/dossiers | 15 | 15060000181366 | 15060000181366 | 1 | PA643134 | PM722824 |
| 15060000181372 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 1 | PA702993 | PM736362 |
| 15060000181373 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 2 | PA736225 | PM736334 |
| 15060000181374 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 3 | PA736167 | PM736327 |
| 15060000181375 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 4 | PA342564 | PM736388 |
| 15060000181376 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 5 | PA736219 | PM736387 |
| 15060000181377 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 6 | PA304002 | PM736326 |
| 15060000181378 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 7 | PA736199 | PM736284 |
| 15060000181379 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 8 | PA775186 | PM775484 |
| 15060000181380 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 9 | PA415488 | PM775641 |
| 15060000181381 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 10 | PA775194 | PM775476 |
| 15060000181382 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 11 | PA775196 | PM775482 |
| 15060000181383 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 12 | PA775200 | PM775504 |
| 15060000181384 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 13 | PA775206 | PM775506 |
| 15060000181385 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 14 | PA590034 | PM775606 |
| 15060000181386 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 15 | PA736234 | PM736424 |
| 15060000181387 | L15/dossiers | 15 | 15060000181371 | 15060000181371 | 16 | PA775210 | PM775492 |