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 |
|---|---|---|---|---|---|---|---|
| 15060000147708 | L15/dossiers | 15 | 15060000147707 | 15060000147707 | 1 | PA345619 | PM725692 |
| 15060000147715 | L15/dossiers | 15 | 15060000147714 | 15060000147714 | 1 | PA721466 | PM723284 |
| 15060000147731 | L15/dossiers | 15 | 15060000147730 | 15060000147730 | 1 | PA721174 | PM723194 |
| 15060000147738 | L15/dossiers | 15 | 15060000147737 | 15060000147737 | 1 | PA721896 | PM723414 |
| 15060000147745 | L15/dossiers | 15 | 15060000147744 | 15060000147744 | 1 | PA722110 | PM723474 |
| 15060000147752 | L15/dossiers | 15 | 15060000147751 | 15060000147751 | 1 | PA330684 | PM722528 |
| 15060000147759 | L15/dossiers | 15 | 15060000147758 | 15060000147758 | 1 | PA1327 | PM722762 |
| 15060000147766 | L15/dossiers | 15 | 15060000147765 | 15060000147765 | 1 | PA345619 | PM725692 |
| 15060000147767 | L15/dossiers | 15 | 15060000147765 | 15060000147765 | 2 | PA331481 | PM730094 |
| 15060000147774 | L15/dossiers | 15 | 15060000147773 | 15060000147773 | 1 | PA345619 | PM725692 |
| 15060000147775 | L15/dossiers | 15 | 15060000147773 | 15060000147773 | 2 | PA205600 | PM730080 |
| 15060000147782 | L15/dossiers | 15 | 15060000147781 | 15060000147781 | 1 | PA720798 | PM723080 |
| 15060000147789 | L15/dossiers | 15 | 15060000147788 | 15060000147788 | 1 | PA720286 | PM722918 |
| 15060000147796 | L15/dossiers | 15 | 15060000147795 | 15060000147795 | 1 | PA720798 | PM723080 |
| 15060000147821 | L15/dossiers | 15 | 15060000147820 | 15060000147820 | 1 | PA1206 | PM723354 |
| 15060000147828 | L15/dossiers | 15 | 15060000147827 | 15060000147827 | 1 | PA345619 | PM725692 |
| 15060000147829 | L15/dossiers | 15 | 15060000147827 | 15060000147827 | 2 | PA729330 | PM730072 |
| 15060000147865 | L15/dossiers | 15 | 15060000147864 | 15060000147864 | 1 | PA345619 | PM725692 |
| 15060000147866 | L15/dossiers | 15 | 15060000147864 | 15060000147864 | 2 | PA331481 | PM730094 |
| 15060000147936 | L15/dossiers | 15 | 15060000147935 | 15060000147935 | 1 | PA345619 | PM725692 |
| 15060000147937 | L15/dossiers | 15 | 15060000147935 | 15060000147935 | 2 | PA758792 | PM758794 |
| 15060000147946 | L15/dossiers | 15 | 15060000147945 | 15060000147945 | 1 | PA335054 | PM723254 |
| 15060000147954 | L15/dossiers | 15 | 15060000147953 | 15060000147953 | 1 | PA642847 | PM722954 |
| 15060000147961 | L15/dossiers | 15 | 15060000147960 | 15060000147960 | 1 | PA718884 | PM722488 |
| 15060000147968 | L15/dossiers | 15 | 15060000147967 | 15060000147967 | 1 | PA722252 | PM723518 |
| 15060000147975 | L15/dossiers | 15 | 15060000147974 | 15060000147974 | 1 | PA998 | PM723046 |
| 15060000147982 | L15/dossiers | 15 | 15060000147981 | 15060000147981 | 1 | PA720846 | PM723094 |
| 15060000147989 | L15/dossiers | 15 | 15060000147988 | 15060000147988 | 1 | PA429832 | PM736408 |
| 15060000148020 | L15/dossiers | 15 | 15060000148019 | 15060000148019 | 1 | PA227029 | PM736306 |
| 15060000148039 | L15/dossiers | 15 | 15060000148038 | 15060000148038 | 1 | PA720286 | PM722918 |
| 15060000148046 | L15/dossiers | 15 | 15060000148045 | 15060000148045 | 1 | PA709315 | PM722526 |
| 15060000148053 | L15/dossiers | 15 | 15060000148052 | 15060000148052 | 1 | PA721506 | PM723296 |
| 15060000148063 | L15/dossiers | 15 | 15060000148062 | 15060000148062 | 1 | PA223837 | PM722458 |
| 15060000148070 | L15/dossiers | 15 | 15060000148069 | 15060000148069 | 1 | PA267306 | PM723054 |
| 15060000148077 | L15/dossiers | 15 | 15060000148076 | 15060000148076 | 1 | PA609726 | PM723426 |
| 15060000148087 | L15/dossiers | 15 | 15060000148086 | 15060000148086 | 1 | PA721624 | PM723336 |
| 15060000148184 | L15/dossiers | 15 | 15060000148183 | 15060000148183 | 1 | PA721466 | PM723284 |
| 15060000148229 | L15/dossiers | 15 | 15060000148228 | 15060000148228 | 1 | PA721506 | PM723296 |
| 15060000148236 | L15/dossiers | 15 | 15060000148235 | 15060000148235 | 1 | PA332228 | PM722754 |
| 15060000148260 | L15/dossiers | 15 | 15060000148259 | 15060000148259 | 1 | PA720170 | PM722880 |
| 15060000148261 | L15/dossiers | 15 | 15060000148259 | 15060000148259 | 2 | PA720598 | PM723012 |
| 15060000148274 | L15/dossiers | 15 | 15060000148273 | 15060000148273 | 1 | PA267330 | PM723392 |
| 15060000148293 | L15/dossiers | 15 | 15060000148292 | 15060000148292 | 1 | PA345619 | PM725692 |
| 15060000148323 | L15/dossiers | 15 | 15060000148322 | 15060000148322 | 1 | PA2377 | PM723550 |
| 15060000148330 | L15/dossiers | 15 | 15060000148329 | 15060000148329 | 1 | PA608826 | PM723276 |
| 15060000148337 | L15/dossiers | 15 | 15060000148336 | 15060000148336 | 1 | PA719558 | PM722696 |
| 15060000148360 | L15/dossiers | 15 | 15060000148359 | 15060000148359 | 1 | PA720630 | PM723020 |
| 15060000148367 | L15/dossiers | 15 | 15060000148366 | 15060000148366 | 1 | PA720354 | PM722940 |
| 15060000148379 | L15/dossiers | 15 | 15060000148378 | 15060000148378 | 1 | PA332228 | PM722754 |
| 15060000148386 | L15/dossiers | 15 | 15060000148385 | 15060000148385 | 1 | PA721678 | PM723352 |