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 |
|---|---|---|---|---|---|---|---|
| 15060000164602 | L15/dossiers | 15 | 15060000164572 | 15060000164572 | 30 | PA703491 | PM703634 |
| 15060000164603 | L15/dossiers | 15 | 15060000164572 | 15060000164572 | 31 | PA766947 | PM766951 |
| 15060000164604 | L15/dossiers | 15 | 15060000164572 | 15060000164572 | 32 | PA643211 | PM703707 |
| 15060000164605 | L15/dossiers | 15 | 15060000164572 | 15060000164572 | 33 | PA415453 | PM703691 |
| 15060000164606 | L15/dossiers | 15 | 15060000164572 | 15060000164572 | 34 | PA341406 | PM703619 |
| 15060000164613 | L15/dossiers | 15 | 15060000164612 | 15060000164612 | 1 | PA722202 | PM723502 |
| 15060000164617 | L15/dossiers | 15 | 15060000164616 | 15060000164616 | 1 | PA721474 | PM723286 |
| 15060000164624 | L15/dossiers | 15 | 15060000164623 | 15060000164623 | 1 | PA267289 | PM754301 |
| 15060000164631 | L15/dossiers | 15 | 15060000164630 | 15060000164630 | 1 | PA268019 | PM723092 |
| 15060000164638 | L15/dossiers | 15 | 15060000164637 | 15060000164637 | 1 | PA712014 | PM722984 |
| 15060000164646 | L15/dossiers | 15 | 15060000164645 | 15060000164645 | 1 | PA345619 | PM725692 |
| 15060000164647 | L15/dossiers | 15 | 15060000164645 | 15060000164645 | 2 | PA1872 | PM730104 |
| 15060000164678 | L15/dossiers | 15 | 15060000164677 | 15060000164677 | 1 | PA345619 | PM725692 |
| 15060000164679 | L15/dossiers | 15 | 15060000164677 | 15060000164677 | 2 | PA717161 | PM766508 |
| 15060000164686 | L15/dossiers | 15 | 15060000164685 | 15060000164685 | 1 | PA345619 | PM725692 |
| 15060000164687 | L15/dossiers | 15 | 15060000164685 | 15060000164685 | 2 | PA642788 | PM770473 |
| 15060000164688 | L15/dossiers | 15 | 15060000164685 | 15060000164685 | 3 | PA607846 | PM730066 |
| 15060000164769 | L15/dossiers | 15 | 15060000164768 | 15060000164768 | 1 | PA345619 | PM725692 |
| 15060000164770 | L15/dossiers | 15 | 15060000164768 | 15060000164768 | 2 | PA642788 | PM770473 |
| 15060000164771 | L15/dossiers | 15 | 15060000164768 | 15060000164768 | 3 | PA607846 | PM730066 |
| 15060000164847 | L15/dossiers | 15 | 15060000164846 | 15060000164846 | 1 | PA345619 | PM725692 |
| 15060000164848 | L15/dossiers | 15 | 15060000164846 | 15060000164846 | 2 | PA605131 | PM759784 |
| 15060000164900 | L15/dossiers | 15 | 15060000164899 | 15060000164899 | 1 | PA345619 | PM725692 |
| 15060000164934 | L15/dossiers | 15 | 15060000164933 | 15060000164933 | 1 | PA719946 | PM722808 |
| 15060000164941 | L15/dossiers | 15 | 15060000164940 | 15060000164940 | 1 | PA709315 | PM722526 |
| 15060000164948 | L15/dossiers | 15 | 15060000164947 | 15060000164947 | 1 | PA330008 | PM722416 |
| 15060000164974 | L15/dossiers | 15 | 15060000164973 | 15060000164973 | 1 | PA721418 | PM723268 |
| 15060000164992 | L15/dossiers | 15 | 15060000164991 | 15060000164991 | 1 | PA2116 | PM736339 |
| 15060000164999 | L15/dossiers | 15 | 15060000164998 | 15060000164998 | 1 | PA335999 | PM723480 |
| 15060000165010 | L15/dossiers | 15 | 15060000165009 | 15060000165009 | 1 | PA720286 | PM722918 |
| 15060000165017 | L15/dossiers | 15 | 15060000165016 | 15060000165016 | 1 | PA721474 | PM723286 |
| 15060000165032 | L15/dossiers | 15 | 15060000165031 | 15060000165031 | 1 | PA719946 | PM722808 |
| 15060000165039 | L15/dossiers | 15 | 15060000165038 | 15060000165038 | 1 | PA605036 | PM722444 |
| 15060000165043 | L15/dossiers | 15 | 15060000165042 | 15060000165042 | 1 | PA736241 | PM736300 |
| 15060000165044 | L15/dossiers | 15 | 15060000165042 | 15060000165042 | 2 | PA703505 | PM703626 |
| 15060000165045 | L15/dossiers | 15 | 15060000165042 | 15060000165042 | 3 | PA736201 | PM736347 |
| 15060000165046 | L15/dossiers | 15 | 15060000165042 | 15060000165042 | 4 | PA733 | PM703709 |
| 15060000165047 | L15/dossiers | 15 | 15060000165042 | 15060000165042 | 5 | PA736191 | PM736336 |
| 15060000165057 | L15/dossiers | 15 | 15060000165056 | 15060000165056 | 1 | PA721012 | PM755861 |
| 15060000165064 | L15/dossiers | 15 | 15060000165063 | 15060000165063 | 1 | PA267794 | PM722468 |
| 15060000165071 | L15/dossiers | 15 | 15060000165070 | 15060000165070 | 1 | PA266788 | PM722914 |
| 15060000165078 | L15/dossiers | 15 | 15060000165077 | 15060000165077 | 1 | PA607553 | PM722956 |
| 15060000165090 | L15/dossiers | 15 | 15060000165089 | 15060000165089 | 1 | PA712014 | PM722984 |
| 15060000165097 | L15/dossiers | 15 | 15060000165096 | 15060000165096 | 1 | PA718850 | PM722478 |
| 15060000165104 | L15/dossiers | 15 | 15060000165103 | 15060000165103 | 1 | PA345619 | PM725692 |
| 15060000165105 | L15/dossiers | 15 | 15060000165103 | 15060000165103 | 2 | PA331481 | PM730094 |
| 15060000165112 | L15/dossiers | 15 | 15060000165111 | 15060000165111 | 1 | PA345619 | PM725692 |
| 15060000165113 | L15/dossiers | 15 | 15060000165111 | 15060000165111 | 2 | PA1872 | PM730104 |
| 15060000165145 | L15/dossiers | 15 | 15060000165144 | 15060000165144 | 1 | PA345619 | PM725692 |
| 15060000165146 | L15/dossiers | 15 | 15060000165144 | 15060000165144 | 2 | PA335758 | PM759788 |