dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 17060000119872 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 7 | PA736177 | PM829835 |
| 17060000119873 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 8 | PA827946 | PM828614 |
| 17060000119874 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 9 | PA827950 | PM828598 |
| 17060000119875 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 10 | PA775252 | PM775558 |
| 17060000119876 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 11 | PA827968 | PM828750 |
| 17060000119877 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 12 | PA827978 | PM828730 |
| 17060000119878 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 13 | PA775272 | PM775562 |
| 17060000119879 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 14 | PA775282 | PM775584 |
| 17060000119880 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 15 | PA828000 | PM828850 |
| 17060000119881 | L17/dossiers | 17 | 17060000119865 | 17060000119865 | 16 | PA828004 | PM828838 |
| 17060000119888 | L17/dossiers | 17 | 17060000119887 | 17060000119887 | 1 | PA828008 | PM828826 |
| 17060000119895 | L17/dossiers | 17 | 17060000119894 | 17060000119894 | 1 | PA827900 | PM828434 |
| 17060000119902 | L17/dossiers | 17 | 17060000119901 | 17060000119901 | 1 | PA827900 | PM828434 |
| 17060000119909 | L17/dossiers | 17 | 17060000119908 | 17060000119908 | 1 | PA827964 | PM828652 |
| 17060000119916 | L17/dossiers | 17 | 17060000119915 | 17060000119915 | 1 | PA382672 | PM829681 |
| 17060000119923 | L17/dossiers | 17 | 17060000119922 | 17060000119922 | 1 | PA775302 | PM775598 |
| 17060000119924 | L17/dossiers | 17 | 17060000119922 | 17060000119922 | 2 | PA304017 | PM775757 |
| 17060000119925 | L17/dossiers | 17 | 17060000119922 | 17060000119922 | 3 | PA205280 | PM829891 |
| 17060000119926 | L17/dossiers | 17 | 17060000119922 | 17060000119922 | 4 | PA736182 | PM829837 |
| 17060000119965 | L17/dossiers | 17 | 17060000119964 | 17060000119964 | 1 | PA267075 | PM775610 |
| 17060000119966 | L17/dossiers | 17 | 17060000119964 | 17060000119964 | 2 | PA703538 | PM775715 |
| 17060000120048 | L17/dossiers | 17 | 17060000120047 | 17060000120047 | 1 | PA827894 | PM828460 |
| 17060000120055 | L17/dossiers | 17 | 17060000120054 | 17060000120054 | 1 | PA643211 | PM775749 |
| 17060000120056 | L17/dossiers | 17 | 17060000120054 | 17060000120054 | 2 | PA703511 | PM775685 |
| 17060000120063 | L17/dossiers | 17 | 17060000120062 | 17060000120062 | 1 | PA722190 | PM833697 |
| 17060000120064 | L17/dossiers | 17 | 17060000120062 | 17060000120062 | 2 | PA331481 | PM833713 |
| 17060000120065 | L17/dossiers | 17 | 17060000120062 | 17060000120062 | 3 | PA793940 | PM834771 |
| 17060000120139 | L17/dossiers | 17 | 17060000120138 | 17060000120138 | 1 | PA722190 | PM833697 |
| 17060000120140 | L17/dossiers | 17 | 17060000120138 | 17060000120138 | 2 | PA793940 | PM834771 |
| 17060000120141 | L17/dossiers | 17 | 17060000120138 | 17060000120138 | 3 | PA331481 | PM833713 |
| 17060000120175 | L17/dossiers | 17 | 17060000120174 | 17060000120174 | 1 | PA827904 | PM828514 |
| 17060000120182 | L17/dossiers | 17 | 17060000120181 | 17060000120181 | 1 | PA345722 | PM843650 |
| 17060000120189 | L17/dossiers | 17 | 17060000120188 | 17060000120188 | 1 | PA795050 | PM843272 |
| 17060000120193 | L17/dossiers | 17 | 17060000120192 | 17060000120192 | 1 | PA703528 | PM775693 |
| 17060000120200 | L17/dossiers | 17 | 17060000120199 | 17060000120199 | 1 | PA429869 | PM829749 |
| 17060000120207 | L17/dossiers | 17 | 17060000120206 | 17060000120206 | 1 | PA368 | PM847741 |
| 17060000120208 | L17/dossiers | 17 | 17060000120206 | 17060000120206 | 2 | PA795144 | PM847769 |
| 17060000120209 | L17/dossiers | 17 | 17060000120206 | 17060000120206 | 3 | PA720878 | PM847701 |
| 17060000120698 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 1 | PA703511 | PM775685 |
| 17060000120699 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 2 | PA736191 | PM829819 |
| 17060000120700 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 3 | PA702993 | PM829493 |
| 17060000120701 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 4 | PA775210 | PM775492 |
| 17060000120702 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 5 | PA703512 | PM775665 |
| 17060000120703 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 6 | PA703505 | PM775679 |
| 17060000120704 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 7 | PA775186 | PM775484 |
| 17060000120705 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 8 | PA642982 | PM829146 |
| 17060000120706 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 9 | PA775200 | PM775504 |
| 17060000120707 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 10 | PA785855 | PM785869 |
| 17060000120708 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 11 | PA712422 | PM828926 |
| 17060000120709 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 12 | PA429867 | PM829751 |