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 |
|---|---|---|---|---|---|---|---|
| 15060000165736 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 22 | PA736234 | PM736424 |
| 15060000165737 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 23 | PA708633 | PM708642 |
| 15060000165738 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 24 | PA736199 | PM736284 |
| 15060000165739 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 25 | PA736217 | PM736384 |
| 15060000165740 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 26 | PA429835 | PM736397 |
| 15060000165741 | L15/dossiers | 15 | 15060000165714 | 15060000165714 | 27 | PA703481 | PM703670 |
| 15060000165748 | L15/dossiers | 15 | 15060000165747 | 15060000165747 | 1 | PA718926 | PM722502 |
| 15060000165752 | L15/dossiers | 15 | 15060000165751 | 15060000165751 | 1 | PA609590 | PM723326 |
| 15060000165756 | L15/dossiers | 15 | 15060000165755 | 15060000165755 | 1 | PA345619 | PM725692 |
| 15060000165757 | L15/dossiers | 15 | 15060000165755 | 15060000165755 | 2 | PA605131 | PM759784 |
| 15060000165839 | L15/dossiers | 15 | 15060000165838 | 15060000165838 | 1 | PA721474 | PM723286 |
| 15060000165843 | L15/dossiers | 15 | 15060000165842 | 15060000165842 | 1 | PA643089 | PM758076 |
| 15060000165850 | L15/dossiers | 15 | 15060000165849 | 15060000165849 | 1 | PA722142 | PM723484 |
| 15060000165857 | L15/dossiers | 15 | 15060000165856 | 15060000165856 | 1 | PA718780 | PM722454 |
| 15060000165864 | L15/dossiers | 15 | 15060000165863 | 15060000165863 | 1 | PA720386 | PM722948 |
| 15060000165871 | L15/dossiers | 15 | 15060000165870 | 15060000165870 | 1 | PA429874 | PM736314 |
| 15060000165878 | L15/dossiers | 15 | 15060000165877 | 15060000165877 | 1 | PA608016 | PM723024 |
| 15060000165885 | L15/dossiers | 15 | 15060000165884 | 15060000165884 | 1 | PA608016 | PM723024 |
| 15060000165892 | L15/dossiers | 15 | 15060000165891 | 15060000165891 | 1 | PA608016 | PM723024 |
| 15060000165907 | L15/dossiers | 15 | 15060000165906 | 15060000165906 | 1 | PA703537 | PM703595 |
| 15060000165908 | L15/dossiers | 15 | 15060000165906 | 15060000165906 | 2 | PA736163 | PM736253 |
| 15060000165915 | L15/dossiers | 15 | 15060000165914 | 15060000165914 | 1 | PA718838 | PM722474 |
| 15060000165933 | L15/dossiers | 15 | 15060000165932 | 15060000165932 | 1 | PA2377 | PM723550 |
| 15060000165940 | L15/dossiers | 15 | 15060000165939 | 15060000165939 | 1 | PA718926 | PM722502 |
| 15060000165947 | L15/dossiers | 15 | 15060000165946 | 15060000165946 | 1 | PA718876 | PM722486 |
| 15060000165954 | L15/dossiers | 15 | 15060000165953 | 15060000165953 | 1 | PA268019 | PM723092 |
| 15060000165967 | L15/dossiers | 15 | 15060000165966 | 15060000165966 | 1 | PA719946 | PM722808 |
| 15060000165974 | L15/dossiers | 15 | 15060000165973 | 15060000165973 | 1 | PA345619 | PM725692 |
| 15060000165975 | L15/dossiers | 15 | 15060000165973 | 15060000165973 | 2 | PA702191 | PM730058 |
| 15060000165982 | L15/dossiers | 15 | 15060000165981 | 15060000165981 | 1 | PA268019 | PM723092 |
| 15060000165989 | L15/dossiers | 15 | 15060000165988 | 15060000165988 | 1 | PA720454 | PM722968 |
| 15060000165999 | L15/dossiers | 15 | 15060000165998 | 15060000165998 | 1 | PA721474 | PM723286 |
| 15060000166006 | L15/dossiers | 15 | 15060000166005 | 15060000166005 | 1 | PA719946 | PM722808 |
| 15060000166013 | L15/dossiers | 15 | 15060000166012 | 15060000166012 | 1 | PA721384 | PM723256 |
| 15060000166020 | L15/dossiers | 15 | 15060000166019 | 15060000166019 | 1 | PA720386 | PM722948 |
| 15060000166027 | L15/dossiers | 15 | 15060000166026 | 15060000166026 | 1 | PA267527 | PM723274 |
| 15060000166034 | L15/dossiers | 15 | 15060000166033 | 15060000166033 | 1 | PA712014 | PM722984 |
| 15060000166041 | L15/dossiers | 15 | 15060000166040 | 15060000166040 | 1 | PA722022 | PM723452 |
| 15060000166051 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 1 | PA703503 | PM703582 |
| 15060000166052 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 2 | PA313924 | PM703546 |
| 15060000166053 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 3 | PA415446 | PM703678 |
| 15060000166054 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 4 | PA303996 | PM703614 |
| 15060000166055 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 5 | PA736224 | PM736403 |
| 15060000166056 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 6 | PA703482 | PM703642 |
| 15060000166057 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 7 | PA429887 | PM736274 |
| 15060000166058 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 8 | PA703497 | PM703569 |
| 15060000166059 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 9 | PA1993 | PM736402 |
| 15060000166060 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 10 | PA720634 | PM736312 |
| 15060000166061 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 11 | PA703517 | PM703625 |
| 15060000166062 | L15/dossiers | 15 | 15060000166050 | 15060000166050 | 12 | PA715745 | PM736297 |