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 |
|---|---|---|---|---|---|---|---|
| 15060000158874 | L15/dossiers | 15 | 15060000158872 | 15060000158872 | 2 | PA1872 | PM730104 |
| 15060000158906 | L15/dossiers | 15 | 15060000158905 | 15060000158905 | 1 | PA345619 | PM725692 |
| 15060000158907 | L15/dossiers | 15 | 15060000158905 | 15060000158905 | 2 | PA335758 | PM759788 |
| 15060000158944 | L15/dossiers | 15 | 15060000158943 | 15060000158943 | 1 | PA345619 | PM725692 |
| 15060000158945 | L15/dossiers | 15 | 15060000158943 | 15060000158943 | 2 | PA335758 | PM759788 |
| 15060000158972 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 1 | PA2538 | PM703570 |
| 15060000158973 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 2 | PA703539 | PM703693 |
| 15060000158974 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 3 | PA415454 | PM703689 |
| 15060000158975 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 4 | PA736186 | PM736396 |
| 15060000158976 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 5 | PA304108 | PM736399 |
| 15060000158977 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 6 | PA758431 | PM758701 |
| 15060000158978 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 7 | PA415451 | PM703594 |
| 15060000158979 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 8 | PA267907 | PM703591 |
| 15060000158980 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 9 | PA736211 | PM736410 |
| 15060000158981 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 10 | PA736202 | PM736392 |
| 15060000158982 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 11 | PA708632 | PM708643 |
| 15060000158983 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 12 | PA716 | PM736261 |
| 15060000158984 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 13 | PA703483 | PM703613 |
| 15060000158985 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 14 | PA415456 | PM736433 |
| 15060000158986 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 15 | PA415456 | PM736433 |
| 15060000158987 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 16 | PA1344 | PM736383 |
| 15060000158988 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 17 | PA415495 | PM703579 |
| 15060000158989 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 18 | PA703488 | PM703632 |
| 15060000158990 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 19 | PA415447 | PM703616 |
| 15060000158991 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 20 | PA429851 | PM736305 |
| 15060000158992 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 21 | PA343775 | PM736367 |
| 15060000158993 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 22 | PA267081 | PM703617 |
| 15060000158994 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 23 | PA429854 | PM736335 |
| 15060000158995 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 24 | PA711156 | PM736319 |
| 15060000158996 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 25 | PA715745 | PM736297 |
| 15060000158997 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 26 | PA736185 | PM736264 |
| 15060000158998 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 27 | PA703510 | PM703672 |
| 15060000158999 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 28 | PA703500 | PM703574 |
| 15060000159000 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 29 | PA304000 | PM703599 |
| 15060000159001 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 30 | PA425322 | PM736282 |
| 15060000159002 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 31 | PA415473 | PM703666 |
| 15060000159003 | L15/dossiers | 15 | 15060000158971 | 15060000158971 | 32 | PA703518 | PM703704 |
| 15060000159021 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 1 | PA415488 | PM703558 |
| 15060000159022 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 2 | PA703536 | PM703563 |
| 15060000159023 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 3 | PA415471 | PM703663 |
| 15060000159024 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 4 | PA703481 | PM703670 |
| 15060000159025 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 5 | PA702993 | PM736362 |
| 15060000159026 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 6 | PA703490 | PM703631 |
| 15060000159027 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 7 | PA415485 | PM703685 |
| 15060000159028 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 8 | PA736199 | PM736284 |
| 15060000159029 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 9 | PA736215 | PM736324 |
| 15060000159030 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 10 | PA736187 | PM736365 |
| 15060000159031 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 11 | PA766947 | PM766951 |
| 15060000159032 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 12 | PA736248 | PM736269 |
| 15060000159033 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 13 | PA736241 | PM736300 |