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 |
|---|---|---|---|---|---|---|---|
| 17060000122774 | L17/dossiers | 17 | 17060000122773 | 17060000122773 | 1 | PA608826 | PM843365 |
| 17060000122781 | L17/dossiers | 17 | 17060000122780 | 17060000122780 | 1 | PA608826 | PM843365 |
| 17060000122788 | L17/dossiers | 17 | 17060000122787 | 17060000122787 | 1 | PA719286 | PM842669 |
| 17060000122821 | L17/dossiers | 17 | 17060000122820 | 17060000122820 | 1 | PA722150 | PM843590 |
| 17060000122828 | L17/dossiers | 17 | 17060000122827 | 17060000122827 | 1 | PA795778 | PM843509 |
| 17060000122835 | L17/dossiers | 17 | 17060000122834 | 17060000122834 | 1 | PA795778 | PM843509 |
| 17060000122842 | L17/dossiers | 17 | 17060000122841 | 17060000122841 | 1 | PA794146 | PM842912 |
| 17060000122849 | L17/dossiers | 17 | 17060000122848 | 17060000122848 | 1 | PA840979 | PM842588 |
| 17060000122856 | L17/dossiers | 17 | 17060000122855 | 17060000122855 | 1 | PA795778 | PM843509 |
| 17060000122863 | L17/dossiers | 17 | 17060000122862 | 17060000122862 | 1 | PA607090 | PM842903 |
| 17060000122870 | L17/dossiers | 17 | 17060000122869 | 17060000122869 | 1 | PA793342 | PM842345 |
| 17060000122877 | L17/dossiers | 17 | 17060000122876 | 17060000122876 | 1 | PA717379 | PM843374 |
| 17060000122884 | L17/dossiers | 17 | 17060000122883 | 17060000122883 | 1 | PA794946 | PM843311 |
| 17060000122891 | L17/dossiers | 17 | 17060000122890 | 17060000122890 | 1 | PA795912 | PM840402 |
| 17060000122898 | L17/dossiers | 17 | 17060000122897 | 17060000122897 | 1 | PA330240 | PM842357 |
| 17060000122905 | L17/dossiers | 17 | 17060000122904 | 17060000122904 | 1 | PA795552 | PM840408 |
| 17060000122912 | L17/dossiers | 17 | 17060000122911 | 17060000122911 | 1 | PA793592 | PM842537 |
| 17060000122919 | L17/dossiers | 17 | 17060000122918 | 17060000122918 | 1 | PA267042 | PM843044 |
| 17060000122926 | L17/dossiers | 17 | 17060000122925 | 17060000122925 | 1 | PA721270 | PM840438 |
| 17060000122933 | L17/dossiers | 17 | 17060000122932 | 17060000122932 | 1 | PA791824 | PM840375 |
| 17060000122946 | L17/dossiers | 17 | 17060000122945 | 17060000122945 | 1 | PA840979 | PM842588 |
| 17060000122953 | L17/dossiers | 17 | 17060000122952 | 17060000122952 | 1 | PA719632 | PM842828 |
| 17060000122960 | L17/dossiers | 17 | 17060000122959 | 17060000122959 | 1 | PA642847 | PM843056 |
| 17060000122967 | L17/dossiers | 17 | 17060000122966 | 17060000122966 | 1 | PA712015 | PM842381 |
| 17060000122974 | L17/dossiers | 17 | 17060000122973 | 17060000122973 | 1 | PA840979 | PM842588 |
| 17060000122981 | L17/dossiers | 17 | 17060000122980 | 17060000122980 | 1 | PA721486 | PM843614 |
| 17060000123003 | L17/dossiers | 17 | 17060000123002 | 17060000123002 | 1 | PA721486 | PM843614 |
| 17060000123010 | L17/dossiers | 17 | 17060000123009 | 17060000123009 | 1 | PA721486 | PM843614 |
| 17060000123017 | L17/dossiers | 17 | 17060000123016 | 17060000123016 | 1 | PA718784 | PM842342 |
| 17060000123024 | L17/dossiers | 17 | 17060000123023 | 17060000123023 | 1 | PA719052 | PM842507 |
| 17060000123063 | L17/dossiers | 17 | 17060000123062 | 17060000123062 | 1 | PA794486 | PM843110 |
| 17060000123070 | L17/dossiers | 17 | 17060000123069 | 17060000123069 | 1 | PA794598 | PM843026 |
| 17060000123077 | L17/dossiers | 17 | 17060000123076 | 17060000123076 | 1 | PA267285 | PM842900 |
| 17060000123084 | L17/dossiers | 17 | 17060000123083 | 17060000123083 | 1 | PA794598 | PM843026 |
| 17060000123091 | L17/dossiers | 17 | 17060000123090 | 17060000123090 | 1 | PA722366 | PM843299 |
| 17060000123124 | L17/dossiers | 17 | 17060000123123 | 17060000123123 | 1 | PA796062 | PM843668 |
| 17060000123131 | L17/dossiers | 17 | 17060000123130 | 17060000123130 | 1 | PA720230 | PM842984 |
| 17060000123138 | L17/dossiers | 17 | 17060000123137 | 17060000123137 | 1 | PA718838 | PM842405 |
| 17060000123145 | L17/dossiers | 17 | 17060000123144 | 17060000123144 | 1 | PA793980 | PM842750 |
| 17060000123160 | L17/dossiers | 17 | 17060000123159 | 17060000123159 | 1 | PA721816 | PM843551 |
| 17060000123167 | L17/dossiers | 17 | 17060000123166 | 17060000123166 | 1 | PA794178 | PM842897 |
| 17060000123174 | L17/dossiers | 17 | 17060000123173 | 17060000123173 | 1 | PA794178 | PM842897 |
| 17060000123181 | L17/dossiers | 17 | 17060000123180 | 17060000123180 | 1 | PA794322 | PM842942 |
| 17060000123197 | L17/dossiers | 17 | 17060000123196 | 17060000123196 | 1 | PA721816 | PM843551 |
| 17060000123204 | L17/dossiers | 17 | 17060000123203 | 17060000123203 | 1 | PA794178 | PM842897 |
| 17060000123211 | L17/dossiers | 17 | 17060000123210 | 17060000123210 | 1 | PA721486 | PM843614 |
| 17060000123218 | L17/dossiers | 17 | 17060000123217 | 17060000123217 | 1 | PA610002 | PM840363 |
| 17060000123225 | L17/dossiers | 17 | 17060000123224 | 17060000123224 | 1 | PA718784 | PM842342 |
| 17060000123232 | L17/dossiers | 17 | 17060000123231 | 17060000123231 | 1 | PA795974 | PM840387 |
| 17060000123239 | L17/dossiers | 17 | 17060000123238 | 17060000123238 | 1 | PA795588 | PM843557 |