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 |
|---|---|---|---|---|---|---|---|
| 17060000133750 | L17/dossiers | 17 | 17060000133749 | 17060000133749 | 1 | PA840979 | PM842588 |
| 17060000133757 | L17/dossiers | 17 | 17060000133756 | 17060000133756 | 1 | PA840979 | PM842588 |
| 17060000133764 | L17/dossiers | 17 | 17060000133763 | 17060000133763 | 1 | PA794118 | PM842894 |
| 17060000133771 | L17/dossiers | 17 | 17060000133770 | 17060000133770 | 1 | PA796090 | PM840372 |
| 17060000133778 | L17/dossiers | 17 | 17060000133777 | 17060000133777 | 1 | PA796090 | PM840372 |
| 17060000133785 | L17/dossiers | 17 | 17060000133784 | 17060000133784 | 1 | PA796090 | PM840372 |
| 17060000133792 | L17/dossiers | 17 | 17060000133791 | 17060000133791 | 1 | PA840979 | PM842588 |
| 17060000133799 | L17/dossiers | 17 | 17060000133798 | 17060000133798 | 1 | PA840979 | PM842588 |
| 17060000133806 | L17/dossiers | 17 | 17060000133805 | 17060000133805 | 1 | PA2952 | PM842414 |
| 17060000133813 | L17/dossiers | 17 | 17060000133812 | 17060000133812 | 1 | PA642847 | PM843056 |
| 17060000133821 | L17/dossiers | 17 | 17060000133820 | 17060000133820 | 1 | PA796090 | PM840372 |
| 17060000133828 | L17/dossiers | 17 | 17060000133827 | 17060000133827 | 1 | PA796090 | PM840372 |
| 17060000133835 | L17/dossiers | 17 | 17060000133834 | 17060000133834 | 1 | PA721202 | PM840435 |
| 17060000133842 | L17/dossiers | 17 | 17060000133841 | 17060000133841 | 1 | PA795422 | PM843599 |
| 17060000133849 | L17/dossiers | 17 | 17060000133848 | 17060000133848 | 1 | PA795310 | PM840453 |
| 17060000133856 | L17/dossiers | 17 | 17060000133855 | 17060000133855 | 1 | PA794906 | PM843284 |
| 17060000133863 | L17/dossiers | 17 | 17060000133862 | 17060000133862 | 1 | PA2952 | PM842414 |
| 17060000133870 | L17/dossiers | 17 | 17060000133869 | 17060000133869 | 1 | PA2952 | PM842414 |
| 17060000133877 | L17/dossiers | 17 | 17060000133876 | 17060000133876 | 1 | PA841769 | PM843323 |
| 17060000133884 | L17/dossiers | 17 | 17060000133883 | 17060000133883 | 1 | PA842195 | PM843707 |
| 17060000133891 | L17/dossiers | 17 | 17060000133890 | 17060000133890 | 1 | PA841769 | PM843323 |
| 17060000133898 | L17/dossiers | 17 | 17060000133897 | 17060000133897 | 1 | PA840979 | PM842588 |
| 17060000133905 | L17/dossiers | 17 | 17060000133904 | 17060000133904 | 1 | PA793736 | PM842693 |
| 17060000133912 | L17/dossiers | 17 | 17060000133911 | 17060000133911 | 1 | PA606098 | PM842633 |
| 17060000133919 | L17/dossiers | 17 | 17060000133918 | 17060000133918 | 1 | PA793572 | PM842498 |
| 17060000133926 | L17/dossiers | 17 | 17060000133925 | 17060000133925 | 1 | PA720354 | PM843008 |
| 17060000133933 | L17/dossiers | 17 | 17060000133932 | 17060000133932 | 1 | PA795430 | PM843602 |
| 17060000133940 | L17/dossiers | 17 | 17060000133939 | 17060000133939 | 1 | PA793322 | PM840246 |
| 17060000133947 | L17/dossiers | 17 | 17060000133946 | 17060000133946 | 1 | PA342384 | PM842771 |
| 17060000133954 | L17/dossiers | 17 | 17060000133953 | 17060000133953 | 1 | PA841717 | PM843278 |
| 17060000133961 | L17/dossiers | 17 | 17060000133960 | 17060000133960 | 1 | PA794710 | PM867916 |
| 17060000133982 | L17/dossiers | 17 | 17060000133981 | 17060000133981 | 1 | PA794778 | PM843239 |
| 17060000133989 | L17/dossiers | 17 | 17060000133988 | 17060000133988 | 1 | PA607553 | PM843059 |
| 17060000133996 | L17/dossiers | 17 | 17060000133995 | 17060000133995 | 1 | PA794710 | PM867916 |
| 17060000134003 | L17/dossiers | 17 | 17060000134002 | 17060000134002 | 1 | PA794146 | PM842912 |
| 17060000134010 | L17/dossiers | 17 | 17060000134009 | 17060000134009 | 1 | PA794906 | PM843284 |
| 17060000134017 | L17/dossiers | 17 | 17060000134016 | 17060000134016 | 1 | PA794270 | PM842972 |
| 17060000134024 | L17/dossiers | 17 | 17060000134023 | 17060000134023 | 1 | PA721474 | PM843608 |
| 17060000134059 | L17/dossiers | 17 | 17060000134058 | 17060000134058 | 1 | PA791812 | PM840384 |
| 17060000134066 | L17/dossiers | 17 | 17060000134065 | 17060000134065 | 1 | PA720022 | PM842957 |
| 17060000134073 | L17/dossiers | 17 | 17060000134072 | 17060000134072 | 1 | PA795430 | PM843602 |
| 17060000134080 | L17/dossiers | 17 | 17060000134079 | 17060000134079 | 1 | PA841947 | PM843503 |
| 17060000134087 | L17/dossiers | 17 | 17060000134086 | 17060000134086 | 1 | PA642764 | PM842711 |
| 17060000134094 | L17/dossiers | 17 | 17060000134093 | 17060000134093 | 1 | PA795950 | PM843419 |
| 17060000134148 | L17/dossiers | 17 | 17060000134147 | 17060000134147 | 1 | PA794094 | PM840291 |
| 17060000134155 | L17/dossiers | 17 | 17060000134154 | 17060000134154 | 1 | PA607553 | PM843059 |
| 17060000134163 | L17/dossiers | 17 | 17060000134162 | 17060000134162 | 1 | PA720908 | PM843701 |
| 17060000134170 | L17/dossiers | 17 | 17060000134169 | 17060000134169 | 1 | PA719922 | PM842867 |
| 17060000134177 | L17/dossiers | 17 | 17060000134176 | 17060000134176 | 1 | PA795664 | PM843569 |
| 17060000134208 | L17/dossiers | 17 | 17060000134207 | 17060000134207 | 1 | PA1654 | PM842510 |