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 |
|---|---|---|---|---|---|---|---|
| 15060000184716 | L15/dossiers | 15 | 15060000184715 | 15060000184715 | 1 | PA719946 | PM722808 |
| 15060000184726 | L15/dossiers | 15 | 15060000184725 | 15060000184725 | 1 | PA719294 | PM722618 |
| 15060000184727 | L15/dossiers | 15 | 15060000184725 | 15060000184725 | 2 | PA607553 | PM722956 |
| 15060000184744 | L15/dossiers | 15 | 15060000184743 | 15060000184743 | 1 | PA719946 | PM722808 |
| 15060000184751 | L15/dossiers | 15 | 15060000184750 | 15060000184750 | 1 | PA2952 | PM722480 |
| 15060000184758 | L15/dossiers | 15 | 15060000184757 | 15060000184757 | 1 | PA720362 | PM722942 |
| 15060000184765 | L15/dossiers | 15 | 15060000184764 | 15060000184764 | 1 | PA720892 | PM723106 |
| 15060000184772 | L15/dossiers | 15 | 15060000184771 | 15060000184771 | 1 | PA719448 | PM722666 |
| 15060000184779 | L15/dossiers | 15 | 15060000184778 | 15060000184778 | 1 | PA609726 | PM723426 |
| 15060000184786 | L15/dossiers | 15 | 15060000184785 | 15060000184785 | 1 | PA720286 | PM722918 |
| 15060000184793 | L15/dossiers | 15 | 15060000184792 | 15060000184792 | 1 | PA722366 | PM723554 |
| 15060000184800 | L15/dossiers | 15 | 15060000184799 | 15060000184799 | 1 | PA721474 | PM723286 |
| 15060000184807 | L15/dossiers | 15 | 15060000184806 | 15060000184806 | 1 | PA721486 | PM723290 |
| 15060000184814 | L15/dossiers | 15 | 15060000184813 | 15060000184813 | 1 | PA719092 | PM722560 |
| 15060000184822 | L15/dossiers | 15 | 15060000184821 | 15060000184821 | 1 | PA718894 | PM722494 |
| 15060000184829 | L15/dossiers | 15 | 15060000184828 | 15060000184828 | 1 | PA2952 | PM722480 |
| 15060000184839 | L15/dossiers | 15 | 15060000184838 | 15060000184838 | 1 | PA2952 | PM722480 |
| 15060000184846 | L15/dossiers | 15 | 15060000184845 | 15060000184845 | 1 | PA267440 | PM722522 |
| 15060000184850 | L15/dossiers | 15 | 15060000184849 | 15060000184849 | 1 | PA703498 | PM736260 |
| 15060000184857 | L15/dossiers | 15 | 15060000184856 | 15060000184856 | 1 | PA266788 | PM722914 |
| 15060000184865 | L15/dossiers | 15 | 15060000184864 | 15060000184864 | 1 | PA2952 | PM722480 |
| 15060000184872 | L15/dossiers | 15 | 15060000184871 | 15060000184871 | 1 | PA333421 | PM722920 |
| 15060000184889 | L15/dossiers | 15 | 15060000184888 | 15060000184888 | 1 | PA721418 | PM723268 |
| 15060000184912 | L15/dossiers | 15 | 15060000184911 | 15060000184911 | 1 | PA722252 | PM723518 |
| 15060000184919 | L15/dossiers | 15 | 15060000184918 | 15060000184918 | 1 | PA721418 | PM723268 |
| 15060000184969 | L15/dossiers | 15 | 15060000184968 | 15060000184968 | 1 | PA720802 | PM774333 |
| 15060000184976 | L15/dossiers | 15 | 15060000184975 | 15060000184975 | 1 | PA721174 | PM723194 |
| 15060000184983 | L15/dossiers | 15 | 15060000184982 | 15060000184982 | 1 | PA718894 | PM722494 |
| 15060000184990 | L15/dossiers | 15 | 15060000184989 | 15060000184989 | 1 | PA722308 | PM772707 |
| 15060000184994 | L15/dossiers | 15 | 15060000184993 | 15060000184993 | 1 | PA606639 | PM722776 |
| 15060000185070 | L15/dossiers | 15 | 15060000185069 | 15060000185069 | 1 | PA720870 | PM723100 |
| 15060000185078 | L15/dossiers | 15 | 15060000185077 | 15060000185077 | 1 | PA775168 | PM775470 |
| 15060000185085 | L15/dossiers | 15 | 15060000185084 | 15060000185084 | 1 | PA773441 | PM773491 |
| 15060000185092 | L15/dossiers | 15 | 15060000185091 | 15060000185091 | 1 | PA703514 | PM775661 |
| 15060000185099 | L15/dossiers | 15 | 15060000185098 | 15060000185098 | 1 | PA721486 | PM723290 |
| 15060000185106 | L15/dossiers | 15 | 15060000185105 | 15060000185105 | 1 | PA722202 | PM723502 |
| 15060000185110 | L15/dossiers | 15 | 15060000185109 | 15060000185109 | 1 | PA336316 | PM723406 |
| 15060000185117 | L15/dossiers | 15 | 15060000185116 | 15060000185116 | 1 | PA719608 | PM722710 |
| 15060000185124 | L15/dossiers | 15 | 15060000185123 | 15060000185123 | 1 | PA722374 | PM723556 |
| 15060000185128 | L15/dossiers | 15 | 15060000185127 | 15060000185127 | 1 | PA773441 | PM773491 |
| 15060000185217 | L15/dossiers | 15 | 15060000185216 | 15060000185216 | 1 | PA719814 | PM722770 |
| 15060000185224 | L15/dossiers | 15 | 15060000185223 | 15060000185223 | 1 | PA266788 | PM722914 |
| 15060000185231 | L15/dossiers | 15 | 15060000185230 | 15060000185230 | 1 | PA718756 | PM722446 |
| 15060000185255 | L15/dossiers | 15 | 15060000185254 | 15060000185254 | 1 | PA720538 | PM722994 |
| 15060000185263 | L15/dossiers | 15 | 15060000185262 | 15060000185262 | 1 | PA773441 | PM773491 |
| 15060000185264 | L15/dossiers | 15 | 15060000185262 | 15060000185262 | 2 | PA1872 | PM773455 |
| 15060000185289 | L15/dossiers | 15 | 15060000185288 | 15060000185288 | 1 | PA773441 | PM773491 |
| 15060000185296 | L15/dossiers | 15 | 15060000185295 | 15060000185295 | 1 | PA773441 | PM773491 |
| 15060000185316 | L15/dossiers | 15 | 15060000185315 | 15060000185315 | 1 | PA415446 | PM775783 |
| 15060000185326 | L15/dossiers | 15 | 15060000185325 | 15060000185325 | 1 | PA331582 | PM722646 |