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 |
|---|---|---|---|---|---|---|---|
| 17060000112156 | L17/dossiers | 17 | 17060000112155 | 17060000112155 | 1 | PA294 | PM58570 |
| 17060000112218 | L17/dossiers | 17 | 17060000112217 | 17060000112217 | 1 | PA2607 | PM87228 |
| 17060000112266 | L17/dossiers | 17 | 17060000112265 | 17060000112265 | 1 | PA2227 | PM89545 |
| 17060000112314 | L17/dossiers | 17 | 17060000112313 | 17060000112313 | 1 | PA1597 | PM88798 |
| 17060000112362 | L17/dossiers | 17 | 17060000112361 | 17060000112361 | 1 | PA592 | PM88780 |
| 17060000112415 | L17/dossiers | 17 | 17060000112414 | 17060000112414 | 1 | PA228 | PM303901 |
| 17060000112459 | L17/dossiers | 17 | 17060000112458 | 17060000112458 | 1 | PA227018 | PM227152 |
| 17060000112503 | L17/dossiers | 17 | 17060000112502 | 17060000112502 | 1 | PA875 | PM303910 |
| 17060000112542 | L17/dossiers | 17 | 17060000112541 | 17060000112541 | 1 | PA303997 | PM304120 |
| 17060000112581 | L17/dossiers | 17 | 17060000112580 | 17060000112580 | 1 | PA905 | PM303952 |
| 17060000112622 | L17/dossiers | 17 | 17060000112621 | 17060000112621 | 1 | PA228 | PM303901 |
| 17060000112661 | L17/dossiers | 17 | 17060000112660 | 17060000112660 | 1 | PA2295 | PM386444 |
| 17060000112716 | L17/dossiers | 17 | 17060000112715 | 17060000112715 | 1 | PA415482 | PM415579 |
| 17060000112755 | L17/dossiers | 17 | 17060000112754 | 17060000112754 | 1 | PA2538 | PM303971 |
| 17060000112799 | L17/dossiers | 17 | 17060000112798 | 17060000112798 | 1 | PA415497 | PM415612 |
| 17060000112838 | L17/dossiers | 17 | 17060000112837 | 17060000112837 | 1 | PA429896 | PM429966 |
| 17060000112872 | L17/dossiers | 17 | 17060000112871 | 17060000112871 | 1 | PA429890 | PM543935 |
| 17060000112906 | L17/dossiers | 17 | 17060000112905 | 17060000112905 | 1 | PA2774 | PM429910 |
| 17060000112945 | L17/dossiers | 17 | 17060000112944 | 17060000112944 | 1 | PA227024 | PM430029 |
| 17060000112946 | L17/dossiers | 17 | 17060000112944 | 17060000112944 | 2 | PA304082 | PM430056 |
| 17060000112990 | L17/dossiers | 17 | 17060000112989 | 17060000112989 | 1 | PA2774 | PM429910 |
| 17060000113024 | L17/dossiers | 17 | 17060000113023 | 17060000113023 | 1 | PA227076 | PM429906 |
| 17060000113025 | L17/dossiers | 17 | 17060000113023 | 17060000113023 | 2 | PA2774 | PM429910 |
| 17060000113066 | L17/dossiers | 17 | 17060000113065 | 17060000113065 | 1 | PA415453 | PM415533 |
| 17060000113100 | L17/dossiers | 17 | 17060000113099 | 17060000113099 | 1 | PA304071 | PM304244 |
| 17060000113134 | L17/dossiers | 17 | 17060000113133 | 17060000113133 | 1 | PA528 | PM429957 |
| 17060000113173 | L17/dossiers | 17 | 17060000113172 | 17060000113172 | 1 | PA2774 | PM429910 |
| 17060000113207 | L17/dossiers | 17 | 17060000113206 | 17060000113206 | 1 | PA406065 | PM415585 |
| 17060000113241 | L17/dossiers | 17 | 17060000113240 | 17060000113240 | 1 | PA737 | PM303909 |
| 17060000113275 | L17/dossiers | 17 | 17060000113274 | 17060000113274 | 1 | PA426327 | PM426337 |
| 17060000113310 | L17/dossiers | 17 | 17060000113309 | 17060000113309 | 1 | PA429848 | PM429951 |
| 17060000113346 | L17/dossiers | 17 | 17060000113345 | 17060000113345 | 1 | PA1886 | PM645099 |
| 17060000113390 | L17/dossiers | 17 | 17060000113389 | 17060000113389 | 1 | PA1828 | PM430036 |
| 17060000113391 | L17/dossiers | 17 | 17060000113389 | 17060000113389 | 2 | PA429858 | PM429958 |
| 17060000113425 | L17/dossiers | 17 | 17060000113424 | 17060000113424 | 1 | PA906 | PM303911 |
| 17060000113459 | L17/dossiers | 17 | 17060000113458 | 17060000113458 | 1 | PA415483 | PM703615 |
| 17060000113493 | L17/dossiers | 17 | 17060000113492 | 17060000113492 | 1 | PA304015 | PM430030 |
| 17060000113527 | L17/dossiers | 17 | 17060000113526 | 17060000113526 | 1 | PA605922 | PM645493 |
| 17060000113576 | L17/dossiers | 17 | 17060000113575 | 17060000113575 | 1 | PA313924 | PM703546 |
| 17060000113610 | L17/dossiers | 17 | 17060000113609 | 17060000113609 | 1 | PA429858 | PM429958 |
| 17060000113644 | L17/dossiers | 17 | 17060000113643 | 17060000113643 | 1 | PA415482 | PM703556 |
| 17060000113678 | L17/dossiers | 17 | 17060000113677 | 17060000113677 | 1 | PA227076 | PM429906 |
| 17060000113712 | L17/dossiers | 17 | 17060000113711 | 17060000113711 | 1 | PA227094 | PM429960 |
| 17060000113746 | L17/dossiers | 17 | 17060000113745 | 17060000113745 | 1 | PA303997 | PM703603 |
| 17060000113780 | L17/dossiers | 17 | 17060000113779 | 17060000113779 | 1 | PA2538 | PM703570 |
| 17060000113823 | L17/dossiers | 17 | 17060000113822 | 17060000113822 | 1 | PA415488 | PM703558 |
| 17060000113860 | L17/dossiers | 17 | 17060000113859 | 17060000113859 | 1 | PA429858 | PM429958 |
| 17060000113890 | L17/dossiers | 17 | 17060000113889 | 17060000113889 | 1 | PA429858 | PM429958 |
| 17060000113919 | L17/dossiers | 17 | 17060000113918 | 17060000113918 | 1 | PA709298 | PM709304 |
| 17060000113948 | L17/dossiers | 17 | 17060000113947 | 17060000113947 | 1 | PA703482 | PM703642 |