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 |
|---|---|---|---|---|---|---|---|
| 15060000168590 | L15/dossiers | 15 | 15060000168589 | 15060000168589 | 1 | PA721194 | PM723200 |
| 15060000168608 | L15/dossiers | 15 | 15060000168607 | 15060000168607 | 1 | PA720538 | PM722994 |
| 15060000168615 | L15/dossiers | 15 | 15060000168614 | 15060000168614 | 1 | PA415446 | PM703678 |
| 15060000168622 | L15/dossiers | 15 | 15060000168621 | 15060000168621 | 1 | PA415446 | PM703678 |
| 15060000168640 | L15/dossiers | 15 | 15060000168639 | 15060000168639 | 1 | PA266788 | PM722914 |
| 15060000168645 | L15/dossiers | 15 | 15060000168644 | 15060000168644 | 1 | PA721968 | PM723436 |
| 15060000168653 | L15/dossiers | 15 | 15060000168652 | 15060000168652 | 1 | PA703485 | PM703654 |
| 15060000168660 | L15/dossiers | 15 | 15060000168659 | 15060000168659 | 1 | PA998 | PM723046 |
| 15060000168667 | L15/dossiers | 15 | 15060000168666 | 15060000168666 | 1 | PA998 | PM723046 |
| 15060000168674 | L15/dossiers | 15 | 15060000168673 | 15060000168673 | 1 | PA773441 | PM773491 |
| 15060000168675 | L15/dossiers | 15 | 15060000168673 | 15060000168673 | 2 | PA609520 | PM773503 |
| 15060000168676 | L15/dossiers | 15 | 15060000168673 | 15060000168673 | 3 | PA729332 | PM773437 |
| 15060000168743 | L15/dossiers | 15 | 15060000168742 | 15060000168742 | 1 | PA773441 | PM773491 |
| 15060000168750 | L15/dossiers | 15 | 15060000168749 | 15060000168749 | 1 | PA773441 | PM773491 |
| 15060000168780 | L15/dossiers | 15 | 15060000168779 | 15060000168779 | 1 | PA719318 | PM722624 |
| 15060000168787 | L15/dossiers | 15 | 15060000168786 | 15060000168786 | 1 | PA266797 | PM722884 |
| 15060000168791 | L15/dossiers | 15 | 15060000168790 | 15060000168790 | 1 | PA773441 | PM773491 |
| 15060000168798 | L15/dossiers | 15 | 15060000168797 | 15060000168797 | 1 | PA2116 | PM736339 |
| 15060000168799 | L15/dossiers | 15 | 15060000168797 | 15060000168797 | 2 | PA736236 | PM736341 |
| 15060000168800 | L15/dossiers | 15 | 15060000168797 | 15060000168797 | 3 | PA736203 | PM736432 |
| 15060000168807 | L15/dossiers | 15 | 15060000168806 | 15060000168806 | 1 | PA426327 | PM703630 |
| 15060000168814 | L15/dossiers | 15 | 15060000168813 | 15060000168813 | 1 | PA426327 | PM703630 |
| 15060000168821 | L15/dossiers | 15 | 15060000168820 | 15060000168820 | 1 | PA720454 | PM722968 |
| 15060000168828 | L15/dossiers | 15 | 15060000168827 | 15060000168827 | 1 | PA345722 | PM723428 |
| 15060000168835 | L15/dossiers | 15 | 15060000168834 | 15060000168834 | 1 | PA267260 | PM722476 |
| 15060000168842 | L15/dossiers | 15 | 15060000168841 | 15060000168841 | 1 | PA712015 | PM722448 |
| 15060000168849 | L15/dossiers | 15 | 15060000168848 | 15060000168848 | 1 | PA721474 | PM723286 |
| 15060000168853 | L15/dossiers | 15 | 15060000168852 | 15060000168852 | 1 | PA267780 | PM723504 |
| 15060000168857 | L15/dossiers | 15 | 15060000168856 | 15060000168856 | 1 | PA719946 | PM722808 |
| 15060000168864 | L15/dossiers | 15 | 15060000168863 | 15060000168863 | 1 | PA719946 | PM722808 |
| 15060000168871 | L15/dossiers | 15 | 15060000168870 | 15060000168870 | 1 | PA713448 | PM722452 |
| 15060000168878 | L15/dossiers | 15 | 15060000168877 | 15060000168877 | 1 | PA718780 | PM722454 |
| 15060000168885 | L15/dossiers | 15 | 15060000168884 | 15060000168884 | 1 | PA720704 | PM723050 |
| 15060000168886 | L15/dossiers | 15 | 15060000168884 | 15060000168884 | 2 | PA266797 | PM722884 |
| 15060000168893 | L15/dossiers | 15 | 15060000168892 | 15060000168892 | 1 | PA607090 | PM722796 |
| 15060000168900 | L15/dossiers | 15 | 15060000168899 | 15060000168899 | 1 | PA608172 | PM723048 |
| 15060000168919 | L15/dossiers | 15 | 15060000168918 | 15060000168918 | 1 | PA266788 | PM722914 |
| 15060000168926 | L15/dossiers | 15 | 15060000168925 | 15060000168925 | 1 | PA722390 | PM723560 |
| 15060000168933 | L15/dossiers | 15 | 15060000168932 | 15060000168932 | 1 | PA330240 | PM722492 |
| 15060000168940 | L15/dossiers | 15 | 15060000168939 | 15060000168939 | 1 | PA773441 | PM773491 |
| 15060000168969 | L15/dossiers | 15 | 15060000168968 | 15060000168968 | 1 | PA703485 | PM703654 |
| 15060000168976 | L15/dossiers | 15 | 15060000168975 | 15060000168975 | 1 | PA773441 | PM773491 |
| 15060000168983 | L15/dossiers | 15 | 15060000168982 | 15060000168982 | 1 | PA267780 | PM723504 |
| 15060000168990 | L15/dossiers | 15 | 15060000168989 | 15060000168989 | 1 | PA609726 | PM723426 |
| 15060000168997 | L15/dossiers | 15 | 15060000168996 | 15060000168996 | 1 | PA719480 | PM722674 |
| 15060000169004 | L15/dossiers | 15 | 15060000169003 | 15060000169003 | 1 | PA719480 | PM722674 |
| 15060000169011 | L15/dossiers | 15 | 15060000169010 | 15060000169010 | 1 | PA2960 | PM723006 |
| 15060000169018 | L15/dossiers | 15 | 15060000169017 | 15060000169017 | 1 | PA720500 | PM722982 |
| 15060000169022 | L15/dossiers | 15 | 15060000169021 | 15060000169021 | 1 | PA426327 | PM703630 |
| 15060000169029 | L15/dossiers | 15 | 15060000169028 | 15060000169028 | 1 | PA382672 | PM736263 |