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 |
|---|---|---|---|---|---|---|---|
| 14060000117767 | L14/dossiers | 14 | 14060000117766 | 14060000117766 | 1 | PA267622 | PM702957 |
| 14060000117768 | L14/dossiers | 14 | 14060000117766 | 14060000117766 | 2 | PA785 | PM702979 |
| 14060000117823 | L14/dossiers | 14 | 14060000117822 | 14060000117822 | 1 | PA1874 | PM645474 |
| 14060000117830 | L14/dossiers | 14 | 14060000117829 | 14060000117829 | 1 | PA2099 | PM645101 |
| 14060000117840 | L14/dossiers | 14 | 14060000117839 | 14060000117839 | 1 | PA1654 | PM703255 |
| 14060000117841 | L14/dossiers | 14 | 14060000117839 | 14060000117839 | 2 | PA2791 | PM653325 |
| 14060000117852 | L14/dossiers | 14 | 14060000117851 | 14060000117851 | 1 | PA267459 | PM645564 |
| 14060000117859 | L14/dossiers | 14 | 14060000117858 | 14060000117858 | 1 | PA328 | PM653228 |
| 14060000117890 | L14/dossiers | 14 | 14060000117889 | 14060000117889 | 1 | PA2713 | PM645148 |
| 14060000117897 | L14/dossiers | 14 | 14060000117896 | 14060000117896 | 1 | PA1886 | PM645099 |
| 14060000117907 | L14/dossiers | 14 | 14060000117906 | 14060000117906 | 1 | PA563 | PM645307 |
| 14060000117914 | L14/dossiers | 14 | 14060000117913 | 14060000117913 | 1 | PA267492 | PM645465 |
| 14060000117921 | L14/dossiers | 14 | 14060000117920 | 14060000117920 | 1 | PA1886 | PM645099 |
| 14060000117955 | L14/dossiers | 14 | 14060000117954 | 14060000117954 | 1 | PA267492 | PM645465 |
| 14060000117959 | L14/dossiers | 14 | 14060000117958 | 14060000117958 | 1 | PA330240 | PM645425 |
| 14060000117976 | L14/dossiers | 14 | 14060000117975 | 14060000117975 | 1 | PA441 | PM645279 |
| 14060000117983 | L14/dossiers | 14 | 14060000117982 | 14060000117982 | 1 | PA785 | PM715797 |
| 14060000117984 | L14/dossiers | 14 | 14060000117982 | 14060000117982 | 2 | PA711558 | PM715833 |
| 14060000117991 | L14/dossiers | 14 | 14060000117990 | 14060000117990 | 1 | PA267336 | PM645424 |
| 14060000118013 | L14/dossiers | 14 | 14060000118012 | 14060000118012 | 1 | PA267151 | PM645165 |
| 14060000118020 | L14/dossiers | 14 | 14060000118019 | 14060000118019 | 1 | PA328 | PM653228 |
| 14060000118021 | L14/dossiers | 14 | 14060000118019 | 14060000118019 | 2 | PA2825 | PM653254 |
| 14060000118028 | L14/dossiers | 14 | 14060000118027 | 14060000118027 | 1 | PA406065 | PM415585 |
| 14060000118052 | L14/dossiers | 14 | 14060000118051 | 14060000118051 | 1 | PA330788 | PM645510 |
| 14060000118059 | L14/dossiers | 14 | 14060000118058 | 14060000118058 | 1 | PA342935 | PM645244 |
| 14060000118066 | L14/dossiers | 14 | 14060000118065 | 14060000118065 | 1 | PA2971 | PM645392 |
| 14060000118073 | L14/dossiers | 14 | 14060000118072 | 14060000118072 | 1 | PA332747 | PM645155 |
| 14060000118084 | L14/dossiers | 14 | 14060000118083 | 14060000118083 | 1 | PA266788 | PM645294 |
| 14060000118091 | L14/dossiers | 14 | 14060000118090 | 14060000118090 | 1 | PA680 | PM645536 |
| 14060000118111 | L14/dossiers | 14 | 14060000118110 | 14060000118110 | 1 | PA267492 | PM645465 |
| 14060000118115 | L14/dossiers | 14 | 14060000118114 | 14060000118114 | 1 | PA267622 | PM702957 |
| 14060000118122 | L14/dossiers | 14 | 14060000118121 | 14060000118121 | 1 | PA267576 | PM645073 |
| 14060000118139 | L14/dossiers | 14 | 14060000118138 | 14060000118138 | 1 | PA1155 | PM645285 |
| 14060000118146 | L14/dossiers | 14 | 14060000118145 | 14060000118145 | 1 | PA328 | PM653228 |
| 14060000118153 | L14/dossiers | 14 | 14060000118152 | 14060000118152 | 1 | PA266788 | PM645294 |
| 14060000118160 | L14/dossiers | 14 | 14060000118159 | 14060000118159 | 1 | PA2048 | PM645036 |
| 14060000118167 | L14/dossiers | 14 | 14060000118166 | 14060000118166 | 1 | PA328 | PM653228 |
| 14060000118263 | L14/dossiers | 14 | 14060000118262 | 14060000118262 | 1 | PA330684 | PM645497 |
| 14060000118270 | L14/dossiers | 14 | 14060000118269 | 14060000118269 | 1 | PA267622 | PM702957 |
| 14060000118271 | L14/dossiers | 14 | 14060000118269 | 14060000118269 | 2 | PA588876 | PM702967 |
| 14060000118324 | L14/dossiers | 14 | 14060000118323 | 14060000118323 | 1 | PA267622 | PM702957 |
| 14060000118353 | L14/dossiers | 14 | 14060000118352 | 14060000118352 | 1 | PA610891 | PM645221 |
| 14060000118354 | L14/dossiers | 14 | 14060000118352 | 14060000118352 | 2 | PA345897 | PM645209 |
| 14060000118364 | L14/dossiers | 14 | 14060000118363 | 14060000118363 | 1 | PA588 | PM645491 |
| 14060000118381 | L14/dossiers | 14 | 14060000118380 | 14060000118380 | 1 | PA608416 | PM645586 |
| 14060000118385 | L14/dossiers | 14 | 14060000118384 | 14060000118384 | 1 | PA588 | PM645491 |
| 14060000118393 | L14/dossiers | 14 | 14060000118392 | 14060000118392 | 1 | PA2377 | PM645591 |
| 14060000118400 | L14/dossiers | 14 | 14060000118399 | 14060000118399 | 1 | PA346886 | PM695110 |
| 14060000118409 | L14/dossiers | 14 | 14060000118408 | 14060000118408 | 1 | PA267622 | PM702957 |
| 14060000118501 | L14/dossiers | 14 | 14060000118500 | 14060000118500 | 1 | PA267622 | PM702957 |