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 |
|---|---|---|---|---|---|---|---|
| 15060000174293 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 3 | PA775296 | PM775596 |
| 15060000174294 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 4 | PA757676 | PM757692 |
| 15060000174295 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 5 | PA304082 | PM736354 |
| 15060000174296 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 6 | PA775172 | PM775474 |
| 15060000174297 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 7 | PA429894 | PM736364 |
| 15060000174298 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 8 | PA756685 | PM775777 |
| 15060000174299 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 9 | PA429886 | PM736385 |
| 15060000174300 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 10 | PA736195 | PM736357 |
| 15060000174301 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 11 | PA775246 | PM775532 |
| 15060000174302 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 12 | PA678263 | PM736330 |
| 15060000174303 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 13 | PA1978 | PM736337 |
| 15060000174304 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 14 | PA736243 | PM736413 |
| 15060000174305 | L15/dossiers | 15 | 15060000174290 | 15060000174290 | 15 | PA736175 | PM736344 |
| 15060000174312 | L15/dossiers | 15 | 15060000174311 | 15060000174311 | 1 | PA773441 | PM773491 |
| 15060000174334 | L15/dossiers | 15 | 15060000174333 | 15060000174333 | 1 | PA266797 | PM722884 |
| 15060000174341 | L15/dossiers | 15 | 15060000174340 | 15060000174340 | 1 | PA266797 | PM722884 |
| 15060000174348 | L15/dossiers | 15 | 15060000174347 | 15060000174347 | 1 | PA266797 | PM722884 |
| 15060000174355 | L15/dossiers | 15 | 15060000174354 | 15060000174354 | 1 | PA266797 | PM722884 |
| 15060000174362 | L15/dossiers | 15 | 15060000174361 | 15060000174361 | 1 | PA718838 | PM722474 |
| 15060000174369 | L15/dossiers | 15 | 15060000174368 | 15060000174368 | 1 | PA721418 | PM723268 |
| 15060000174376 | L15/dossiers | 15 | 15060000174375 | 15060000174375 | 1 | PA2952 | PM722480 |
| 15060000174384 | L15/dossiers | 15 | 15060000174383 | 15060000174383 | 1 | PA2952 | PM722480 |
| 15060000174391 | L15/dossiers | 15 | 15060000174390 | 15060000174390 | 1 | PA304017 | PM775757 |
| 15060000174398 | L15/dossiers | 15 | 15060000174397 | 15060000174397 | 1 | PA703511 | PM775685 |
| 15060000174441 | L15/dossiers | 15 | 15060000174440 | 15060000174440 | 1 | PA610667 | PM723146 |
| 15060000174448 | L15/dossiers | 15 | 15060000174447 | 15060000174447 | 1 | PA774954 | PM774972 |
| 15060000174455 | L15/dossiers | 15 | 15060000174454 | 15060000174454 | 1 | PA721506 | PM723296 |
| 15060000174462 | L15/dossiers | 15 | 15060000174461 | 15060000174461 | 1 | PA719980 | PM722822 |
| 15060000174469 | L15/dossiers | 15 | 15060000174468 | 15060000174468 | 1 | PA719318 | PM722624 |
| 15060000174476 | L15/dossiers | 15 | 15060000174475 | 15060000174475 | 1 | PA721832 | PM771998 |
| 15060000174483 | L15/dossiers | 15 | 15060000174482 | 15060000174482 | 1 | PA721674 | PM764881 |
| 15060000174491 | L15/dossiers | 15 | 15060000174490 | 15060000174490 | 1 | PA720538 | PM722994 |
| 15060000174498 | L15/dossiers | 15 | 15060000174497 | 15060000174497 | 1 | PA268019 | PM723092 |
| 15060000174509 | L15/dossiers | 15 | 15060000174508 | 15060000174508 | 1 | PA712014 | PM722984 |
| 15060000174516 | L15/dossiers | 15 | 15060000174515 | 15060000174515 | 1 | PA342601 | PM761932 |
| 15060000174534 | L15/dossiers | 15 | 15060000174533 | 15060000174533 | 1 | PA712014 | PM722984 |
| 15060000174541 | L15/dossiers | 15 | 15060000174540 | 15060000174540 | 1 | PA643004 | PM775869 |
| 15060000174548 | L15/dossiers | 15 | 15060000174547 | 15060000174547 | 1 | PA720960 | PM723124 |
| 15060000174555 | L15/dossiers | 15 | 15060000174554 | 15060000174554 | 1 | PA2377 | PM723550 |
| 15060000174562 | L15/dossiers | 15 | 15060000174561 | 15060000174561 | 1 | PA609726 | PM723426 |
| 15060000174569 | L15/dossiers | 15 | 15060000174568 | 15060000174568 | 1 | PA736212 | PM736331 |
| 15060000174576 | L15/dossiers | 15 | 15060000174575 | 15060000174575 | 1 | PA773441 | PM773491 |
| 15060000174583 | L15/dossiers | 15 | 15060000174582 | 15060000174582 | 1 | PA720614 | PM723016 |
| 15060000174598 | L15/dossiers | 15 | 15060000174597 | 15060000174597 | 1 | PA720696 | PM723044 |
| 15060000174630 | L15/dossiers | 15 | 15060000174629 | 15060000174629 | 1 | PA1206 | PM723354 |
| 15060000174637 | L15/dossiers | 15 | 15060000174636 | 15060000174636 | 1 | PA718944 | PM722508 |
| 15060000174644 | L15/dossiers | 15 | 15060000174643 | 15060000174643 | 1 | PA720780 | PM723074 |
| 15060000174706 | L15/dossiers | 15 | 15060000174705 | 15060000174705 | 1 | PA718918 | PM722500 |
| 15060000174713 | L15/dossiers | 15 | 15060000174712 | 15060000174712 | 1 | PA721832 | PM771998 |
| 15060000174720 | L15/dossiers | 15 | 15060000174719 | 15060000174719 | 1 | PA429874 | PM736314 |