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 |
|---|---|---|---|---|---|---|---|
| 15060000161702 | L15/dossiers | 15 | 15060000161701 | 15060000161701 | 1 | PA718850 | PM722478 |
| 15060000161709 | L15/dossiers | 15 | 15060000161708 | 15060000161708 | 1 | PA330008 | PM722416 |
| 15060000161716 | L15/dossiers | 15 | 15060000161715 | 15060000161715 | 1 | PA605036 | PM722444 |
| 15060000161720 | L15/dossiers | 15 | 15060000161719 | 15060000161719 | 1 | PA608416 | PM723540 |
| 15060000161727 | L15/dossiers | 15 | 15060000161726 | 15060000161726 | 1 | PA429874 | PM736314 |
| 15060000161734 | L15/dossiers | 15 | 15060000161733 | 15060000161733 | 1 | PA345619 | PM725692 |
| 15060000161741 | L15/dossiers | 15 | 15060000161740 | 15060000161740 | 1 | PA703507 | PM703567 |
| 15060000161742 | L15/dossiers | 15 | 15060000161740 | 15060000161740 | 2 | PA267340 | PM703713 |
| 15060000161749 | L15/dossiers | 15 | 15060000161748 | 15060000161748 | 1 | PA266788 | PM722914 |
| 15060000161759 | L15/dossiers | 15 | 15060000161758 | 15060000161758 | 1 | PA267233 | PM723500 |
| 15060000161766 | L15/dossiers | 15 | 15060000161765 | 15060000161765 | 1 | PA345619 | PM725692 |
| 15060000161777 | L15/dossiers | 15 | 15060000161776 | 15060000161776 | 1 | PA643089 | PM758076 |
| 15060000161784 | L15/dossiers | 15 | 15060000161783 | 15060000161783 | 1 | PA643103 | PM722614 |
| 15060000161791 | L15/dossiers | 15 | 15060000161790 | 15060000161790 | 1 | PA267233 | PM723500 |
| 15060000161806 | L15/dossiers | 15 | 15060000161805 | 15060000161805 | 1 | PA712015 | PM722448 |
| 15060000161822 | L15/dossiers | 15 | 15060000161821 | 15060000161821 | 1 | PA721908 | PM723418 |
| 15060000161879 | L15/dossiers | 15 | 15060000161878 | 15060000161878 | 1 | PA721486 | PM723290 |
| 15060000161886 | L15/dossiers | 15 | 15060000161885 | 15060000161885 | 1 | PA429858 | PM736268 |
| 15060000161887 | L15/dossiers | 15 | 15060000161885 | 15060000161885 | 2 | PA1001 | PM736371 |
| 15060000161888 | L15/dossiers | 15 | 15060000161885 | 15060000161885 | 3 | PA569 | PM703710 |
| 15060000161889 | L15/dossiers | 15 | 15060000161885 | 15060000161885 | 4 | PA732420 | PM763170 |
| 15060000161890 | L15/dossiers | 15 | 15060000161885 | 15060000161885 | 5 | PA732420 | PM763170 |
| 15060000161891 | L15/dossiers | 15 | 15060000161885 | 15060000161885 | 6 | PA1562 | PM736340 |
| 15060000161892 | L15/dossiers | 15 | 15060000161885 | 15060000161885 | 7 | PA736196 | PM736370 |
| 15060000161899 | L15/dossiers | 15 | 15060000161898 | 15060000161898 | 1 | PA2377 | PM723550 |
| 15060000161910 | L15/dossiers | 15 | 15060000161909 | 15060000161909 | 1 | PA722202 | PM723502 |
| 15060000161917 | L15/dossiers | 15 | 15060000161916 | 15060000161916 | 1 | PA689 | PM723090 |
| 15060000161925 | L15/dossiers | 15 | 15060000161924 | 15060000161924 | 1 | PA720210 | PM722892 |
| 15060000161932 | L15/dossiers | 15 | 15060000161931 | 15060000161931 | 1 | PA720546 | PM722996 |
| 15060000161939 | L15/dossiers | 15 | 15060000161938 | 15060000161938 | 1 | PA1206 | PM723354 |
| 15060000161940 | L15/dossiers | 15 | 15060000161938 | 15060000161938 | 2 | PA720664 | PM723032 |
| 15060000161944 | L15/dossiers | 15 | 15060000161943 | 15060000161943 | 1 | PA1206 | PM723354 |
| 15060000161945 | L15/dossiers | 15 | 15060000161943 | 15060000161943 | 2 | PA720664 | PM723032 |
| 15060000161949 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 1 | PA429886 | PM736385 |
| 15060000161950 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 2 | PA304082 | PM736354 |
| 15060000161951 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 3 | PA757676 | PM757692 |
| 15060000161952 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 4 | PA429891 | PM736329 |
| 15060000161953 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 5 | PA429894 | PM736364 |
| 15060000161954 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 6 | PA756685 | PM756689 |
| 15060000161955 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 7 | PA429836 | PM736345 |
| 15060000161956 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 8 | PA304071 | PM703676 |
| 15060000161957 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 9 | PA736195 | PM736357 |
| 15060000161958 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 10 | PA736177 | PM736318 |
| 15060000161959 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 11 | PA736173 | PM736369 |
| 15060000161960 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 12 | PA1978 | PM736337 |
| 15060000161961 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 13 | PA678263 | PM736330 |
| 15060000161962 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 14 | PA736243 | PM736413 |
| 15060000161963 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 15 | PA703499 | PM703641 |
| 15060000161964 | L15/dossiers | 15 | 15060000161948 | 15060000161948 | 16 | PA736175 | PM736344 |
| 15060000161990 | L15/dossiers | 15 | 15060000161989 | 15060000161989 | 1 | PA267907 | PM703591 |