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 |
|---|---|---|---|---|---|---|---|
| 17060000150511 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 35 | PA703509 | PM775687 |
| 17060000150512 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 36 | PA736181 | PM829839 |
| 17060000150513 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 37 | PA736225 | PM829907 |
| 17060000150514 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 38 | PA703536 | PM775719 |
| 17060000150515 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 39 | PA736229 | PM829923 |
| 17060000150516 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 40 | PA605888 | PM775604 |
| 17060000150517 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 41 | PA607761 | PM828556 |
| 17060000150518 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 42 | PA415449 | PM775793 |
| 17060000150519 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 43 | PA342564 | PM829509 |
| 17060000150520 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 44 | PA2074 | PM775677 |
| 17060000150521 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 45 | PA873607 | PM873611 |
| 17060000150522 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 46 | PA775254 | PM775556 |
| 17060000150523 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 47 | PA775256 | PM775546 |
| 17060000150524 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 48 | PA703512 | PM775665 |
| 17060000150525 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 49 | PA643211 | PM775749 |
| 17060000150526 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 50 | PA610850 | PM828634 |
| 17060000150527 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 51 | PA827980 | PM828710 |
| 17060000150528 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 52 | PA827982 | PM828718 |
| 17060000150529 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 53 | PA775268 | PM775574 |
| 17060000150530 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 54 | PA606375 | PM775602 |
| 17060000150531 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 55 | PA703505 | PM775679 |
| 17060000150532 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 56 | PA775274 | PM775560 |
| 17060000150533 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 57 | PA703511 | PM775685 |
| 17060000150534 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 58 | PA827994 | PM828782 |
| 17060000150535 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 59 | PA643028 | PM829316 |
| 17060000150536 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 60 | PA429889 | PM829767 |
| 17060000150537 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 61 | PA429889 | PM829767 |
| 17060000150538 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 62 | PA775290 | PM775576 |
| 17060000150539 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 63 | PA736214 | PM829883 |
| 17060000150540 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 64 | PA736217 | PM829873 |
| 17060000150541 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 65 | PA828010 | PM828832 |
| 17060000150542 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 66 | PA775294 | PM775580 |
| 17060000150543 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 67 | PA828014 | PM828818 |
| 17060000150544 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 68 | PA828018 | PM828882 |
| 17060000150545 | L17/dossiers | 17 | 17060000150476 | 17060000150476 | 69 | PA828022 | PM828870 |
| 17060000150552 | L17/dossiers | 17 | 17060000150551 | 17060000150551 | 1 | PA719890 | PM842855 |
| 17060000150562 | L17/dossiers | 17 | 17060000150561 | 17060000150561 | 1 | PA841595 | PM880895 |
| 17060000150566 | L17/dossiers | 17 | 17060000150565 | 17060000150565 | 1 | PA841151 | PM874938 |
| 17060000150570 | L17/dossiers | 17 | 17060000150569 | 17060000150569 | 1 | PA712014 | PM858454 |
| 17060000150577 | L17/dossiers | 17 | 17060000150576 | 17060000150576 | 1 | PA703497 | PM775637 |
| 17060000150593 | L17/dossiers | 17 | 17060000150592 | 17060000150592 | 1 | PA721816 | PM843551 |
| 17060000150606 | L17/dossiers | 17 | 17060000150605 | 17060000150605 | 1 | PA736182 | PM829837 |
| 17060000150613 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 1 | PA827978 | PM828730 |
| 17060000150614 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 2 | PA775252 | PM775558 |
| 17060000150615 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 3 | PA775180 | PM775466 |
| 17060000150616 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 4 | PA429845 | PM829729 |
| 17060000150617 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 5 | PA775214 | PM775498 |
| 17060000150618 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 6 | PA775224 | PM775512 |
| 17060000150619 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 7 | PA736177 | PM829835 |
| 17060000150620 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 8 | PA827946 | PM828614 |