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 |
|---|---|---|---|---|---|---|---|
| 14060000118502 | L14/dossiers | 14 | 14060000118500 | 14060000118500 | 2 | PA2825 | PM702962 |
| 14060000118512 | L14/dossiers | 14 | 14060000118511 | 14060000118511 | 1 | PA607846 | PM645441 |
| 14060000118522 | L14/dossiers | 14 | 14060000118521 | 14060000118521 | 1 | PA328 | PM653228 |
| 14060000118551 | L14/dossiers | 14 | 14060000118550 | 14060000118550 | 1 | PA610002 | PM645053 |
| 14060000118558 | L14/dossiers | 14 | 14060000118557 | 14060000118557 | 1 | PA330684 | PM645497 |
| 14060000118565 | L14/dossiers | 14 | 14060000118564 | 14060000118564 | 1 | PA609764 | PM645323 |
| 14060000118569 | L14/dossiers | 14 | 14060000118568 | 14060000118568 | 1 | PA267605 | PM645189 |
| 14060000118576 | L14/dossiers | 14 | 14060000118575 | 14060000118575 | 1 | PA1886 | PM645099 |
| 14060000118583 | L14/dossiers | 14 | 14060000118582 | 14060000118582 | 1 | PA267622 | PM700712 |
| 14060000118584 | L14/dossiers | 14 | 14060000118582 | 14060000118582 | 2 | PA785 | PM700742 |
| 14060000118645 | L14/dossiers | 14 | 14060000118644 | 14060000118644 | 1 | PA1466 | PM645240 |
| 14060000118656 | L14/dossiers | 14 | 14060000118655 | 14060000118655 | 1 | PA267801 | PM645153 |
| 14060000118663 | L14/dossiers | 14 | 14060000118662 | 14060000118662 | 1 | PA2011 | PM645434 |
| 14060000118673 | L14/dossiers | 14 | 14060000118672 | 14060000118672 | 1 | PA230329 | PM645079 |
| 14060000118677 | L14/dossiers | 14 | 14060000118676 | 14060000118676 | 1 | PA606098 | PM645171 |
| 14060000118684 | L14/dossiers | 14 | 14060000118683 | 14060000118683 | 1 | PA2377 | PM645591 |
| 14060000118691 | L14/dossiers | 14 | 14060000118690 | 14060000118690 | 1 | PA2048 | PM693013 |
| 14060000118701 | L14/dossiers | 14 | 14060000118700 | 14060000118700 | 1 | PA2552 | PM429997 |
| 14060000118742 | L14/dossiers | 14 | 14060000118741 | 14060000118741 | 1 | PA346886 | PM695110 |
| 14060000118749 | L14/dossiers | 14 | 14060000118748 | 14060000118748 | 1 | PA267785 | PM645359 |
| 14060000118756 | L14/dossiers | 14 | 14060000118755 | 14060000118755 | 1 | PA2048 | PM645036 |
| 14060000118763 | L14/dossiers | 14 | 14060000118762 | 14060000118762 | 1 | PA345619 | PM717221 |
| 14060000118846 | L14/dossiers | 14 | 14060000118845 | 14060000118845 | 1 | PA687214 | PM687217 |
| 14060000118853 | L14/dossiers | 14 | 14060000118852 | 14060000118852 | 1 | PA328 | PM653228 |
| 14060000118854 | L14/dossiers | 14 | 14060000118852 | 14060000118852 | 2 | PA1268 | PM653525 |
| 14060000118894 | L14/dossiers | 14 | 14060000118893 | 14060000118893 | 1 | PA2796 | PM645520 |
| 14060000118901 | L14/dossiers | 14 | 14060000118900 | 14060000118900 | 1 | PA2952 | PM645464 |
| 14060000118908 | L14/dossiers | 14 | 14060000118907 | 14060000118907 | 1 | PA610634 | PM645262 |
| 14060000118912 | L14/dossiers | 14 | 14060000118911 | 14060000118911 | 1 | PA2229 | PM645205 |
| 14060000118919 | L14/dossiers | 14 | 14060000118918 | 14060000118918 | 1 | PA266788 | PM645294 |
| 14060000118926 | L14/dossiers | 14 | 14060000118925 | 14060000118925 | 1 | PA563 | PM645307 |
| 14060000118933 | L14/dossiers | 14 | 14060000118932 | 14060000118932 | 1 | PA687214 | PM687217 |
| 14060000118940 | L14/dossiers | 14 | 14060000118939 | 14060000118939 | 1 | PA267785 | PM645359 |
| 14060000118947 | L14/dossiers | 14 | 14060000118946 | 14060000118946 | 1 | PA267622 | PM702957 |
| 14060000118948 | L14/dossiers | 14 | 14060000118946 | 14060000118946 | 2 | PA2825 | PM702962 |
| 14060000118955 | L14/dossiers | 14 | 14060000118954 | 14060000118954 | 1 | PA345619 | PM717221 |
| 14060000119060 | L14/dossiers | 14 | 14060000119059 | 14060000119059 | 1 | PA334906 | PM645577 |
| 14060000119067 | L14/dossiers | 14 | 14060000119066 | 14060000119066 | 1 | PA346886 | PM695110 |
| 14060000119074 | L14/dossiers | 14 | 14060000119073 | 14060000119073 | 1 | PA415482 | PM703556 |
| 14060000119093 | L14/dossiers | 14 | 14060000119092 | 14060000119092 | 1 | PA610905 | PM645225 |
| 14060000119107 | L14/dossiers | 14 | 14060000119106 | 14060000119106 | 1 | PA2492 | PM645431 |
| 14060000119124 | L14/dossiers | 14 | 14060000119123 | 14060000119123 | 1 | PA607619 | PM645383 |
| 14060000119131 | L14/dossiers | 14 | 14060000119130 | 14060000119130 | 1 | PA703530 | PM703695 |
| 14060000119146 | L14/dossiers | 14 | 14060000119145 | 14060000119145 | 1 | PA2343 | PM645498 |
| 14060000119150 | L14/dossiers | 14 | 14060000119149 | 14060000119149 | 1 | PA1946 | PM645437 |
| 14060000119171 | L14/dossiers | 14 | 14060000119170 | 14060000119170 | 1 | PA267285 | PM645140 |
| 14060000119178 | L14/dossiers | 14 | 14060000119177 | 14060000119177 | 1 | PA267204 | PM645551 |
| 14060000119185 | L14/dossiers | 14 | 14060000119184 | 14060000119184 | 1 | PA1886 | PM645099 |
| 14060000119199 | L14/dossiers | 14 | 14060000119198 | 14060000119198 | 1 | PA267492 | PM645465 |
| 14060000119216 | L14/dossiers | 14 | 14060000119215 | 14060000119215 | 1 | PA330240 | PM645425 |