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 |
|---|---|---|---|---|---|---|---|
| 14060000123584 | L14/dossiers | 14 | 14060000123583 | 14060000123583 | 1 | PA2011 | PM645434 |
| 14060000123591 | L14/dossiers | 14 | 14060000123590 | 14060000123590 | 1 | PA2099 | PM645101 |
| 14060000123598 | L14/dossiers | 14 | 14060000123597 | 14060000123597 | 1 | PA267622 | PM700712 |
| 14060000123599 | L14/dossiers | 14 | 14060000123597 | 14060000123597 | 2 | PA2679 | PM700726 |
| 14060000123606 | L14/dossiers | 14 | 14060000123605 | 14060000123605 | 1 | PA702053 | PM702060 |
| 14060000123613 | L14/dossiers | 14 | 14060000123612 | 14060000123612 | 1 | PA2073 | PM645207 |
| 14060000123620 | L14/dossiers | 14 | 14060000123619 | 14060000123619 | 1 | PA1585 | PM645094 |
| 14060000123627 | L14/dossiers | 14 | 14060000123626 | 14060000123626 | 1 | PA267605 | PM645189 |
| 14060000123637 | L14/dossiers | 14 | 14060000123636 | 14060000123636 | 1 | PA267622 | PM702957 |
| 14060000123672 | L14/dossiers | 14 | 14060000123671 | 14060000123671 | 1 | PA2277 | PM645135 |
| 14060000123682 | L14/dossiers | 14 | 14060000123681 | 14060000123681 | 1 | PA328 | PM653228 |
| 14060000123683 | L14/dossiers | 14 | 14060000123681 | 14060000123681 | 2 | PA336175 | PM653267 |
| 14060000123755 | L14/dossiers | 14 | 14060000123754 | 14060000123754 | 1 | PA785 | PM715797 |
| 14060000123762 | L14/dossiers | 14 | 14060000123761 | 14060000123761 | 1 | PA267622 | PM702957 |
| 14060000123769 | L14/dossiers | 14 | 14060000123768 | 14060000123768 | 1 | PA785 | PM715797 |
| 14060000123776 | L14/dossiers | 14 | 14060000123775 | 14060000123775 | 1 | PA340755 | PM645506 |
| 14060000123801 | L14/dossiers | 14 | 14060000123800 | 14060000123800 | 1 | PA267622 | PM702957 |
| 14060000123814 | L14/dossiers | 14 | 14060000123813 | 14060000123813 | 1 | PA785 | PM715797 |
| 14060000123821 | L14/dossiers | 14 | 14060000123820 | 14060000123820 | 1 | PA607310 | PM645297 |
| 14060000123828 | L14/dossiers | 14 | 14060000123827 | 14060000123827 | 1 | PA309643 | PM645326 |
| 14060000123835 | L14/dossiers | 14 | 14060000123834 | 14060000123834 | 1 | PA266788 | PM645294 |
| 14060000123845 | L14/dossiers | 14 | 14060000123844 | 14060000123844 | 1 | PA785 | PM715797 |
| 14060000123846 | L14/dossiers | 14 | 14060000123844 | 14060000123844 | 2 | PA642983 | PM715821 |
| 14060000123881 | L14/dossiers | 14 | 14060000123880 | 14060000123880 | 1 | PA1263 | PM645432 |
| 14060000123888 | L14/dossiers | 14 | 14060000123887 | 14060000123887 | 1 | PA2971 | PM645392 |
| 14060000123895 | L14/dossiers | 14 | 14060000123894 | 14060000123894 | 1 | PA2277 | PM645135 |
| 14060000123905 | L14/dossiers | 14 | 14060000123904 | 14060000123904 | 1 | PA588 | PM645491 |
| 14060000123922 | L14/dossiers | 14 | 14060000123921 | 14060000123921 | 1 | PA267327 | PM645031 |
| 14060000123929 | L14/dossiers | 14 | 14060000123928 | 14060000123928 | 1 | PA1263 | PM645432 |
| 14060000123936 | L14/dossiers | 14 | 14060000123935 | 14060000123935 | 1 | PA2257 | PM645201 |
| 14060000123946 | L14/dossiers | 14 | 14060000123945 | 14060000123945 | 1 | PA267622 | PM702957 |
| 14060000123947 | L14/dossiers | 14 | 14060000123945 | 14060000123945 | 2 | PA2679 | PM702976 |
| 14060000123948 | L14/dossiers | 14 | 14060000123945 | 14060000123945 | 3 | PA1243 | PM702966 |
| 14060000124044 | L14/dossiers | 14 | 14060000124043 | 14060000124043 | 1 | PA785 | PM715797 |
| 14060000124051 | L14/dossiers | 14 | 14060000124050 | 14060000124050 | 1 | PA333134 | PM645341 |
| 14060000124058 | L14/dossiers | 14 | 14060000124057 | 14060000124057 | 1 | PA2538 | PM703570 |
| 14060000124077 | L14/dossiers | 14 | 14060000124076 | 14060000124076 | 1 | PA2952 | PM645464 |
| 14060000124084 | L14/dossiers | 14 | 14060000124083 | 14060000124083 | 1 | PA330240 | PM645425 |
| 14060000124091 | L14/dossiers | 14 | 14060000124090 | 14060000124090 | 1 | PA610775 | PM645309 |
| 14060000124098 | L14/dossiers | 14 | 14060000124097 | 14060000124097 | 1 | PA328 | PM653228 |
| 14060000124099 | L14/dossiers | 14 | 14060000124097 | 14060000124097 | 2 | PA1268 | PM653525 |
| 14060000124136 | L14/dossiers | 14 | 14060000124135 | 14060000124135 | 1 | PA609816 | PM645334 |
| 14060000124154 | L14/dossiers | 14 | 14060000124153 | 14060000124153 | 1 | PA328 | PM653228 |
| 14060000124185 | L14/dossiers | 14 | 14060000124184 | 14060000124184 | 1 | PA267622 | PM702957 |
| 14060000124186 | L14/dossiers | 14 | 14060000124184 | 14060000124184 | 2 | PA2679 | PM714646 |
| 14060000124187 | L14/dossiers | 14 | 14060000124184 | 14060000124184 | 3 | PA1243 | PM714743 |
| 14060000124272 | L14/dossiers | 14 | 14060000124271 | 14060000124271 | 1 | PA268019 | PM645116 |
| 14060000124279 | L14/dossiers | 14 | 14060000124278 | 14060000124278 | 1 | PA2250 | PM645539 |
| 14060000124289 | L14/dossiers | 14 | 14060000124288 | 14060000124288 | 1 | PA267622 | PM702957 |
| 14060000124290 | L14/dossiers | 14 | 14060000124288 | 14060000124288 | 2 | PA588876 | PM702967 |