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 |
|---|---|---|---|---|---|---|---|
| 16060000119788 | L16/dossiers | 16 | 16060000119786 | 16060000119786 | 2 | PA267340 | PM775731 |
| 16060000119789 | L16/dossiers | 16 | 16060000119786 | 16060000119786 | 3 | PA303997 | PM775743 |
| 16060000119790 | L16/dossiers | 16 | 16060000119786 | 16060000119786 | 4 | PA2538 | PM775801 |
| 16060000119791 | L16/dossiers | 16 | 16060000119786 | 16060000119786 | 5 | PA429832 | PM829723 |
| 16060000119811 | L16/dossiers | 16 | 16060000119810 | 16060000119810 | 1 | PA719190 | PM826700 |
| 16060000119815 | L16/dossiers | 16 | 16060000119814 | 16060000119814 | 1 | PA796018 | PM797805 |
| 16060000119829 | L16/dossiers | 16 | 16060000119828 | 16060000119828 | 1 | PA793992 | PM796641 |
| 16060000119845 | L16/dossiers | 16 | 16060000119844 | 16060000119844 | 1 | PA785855 | PM785869 |
| 16060000119852 | L16/dossiers | 16 | 16060000119851 | 16060000119851 | 1 | PA1327 | PM796632 |
| 16060000119859 | L16/dossiers | 16 | 16060000119858 | 16060000119858 | 1 | PA774960 | PM797490 |
| 16060000119866 | L16/dossiers | 16 | 16060000119865 | 16060000119865 | 1 | PA1327 | PM796632 |
| 16060000119873 | L16/dossiers | 16 | 16060000119872 | 16060000119872 | 1 | PA722390 | PM797214 |
| 16060000119880 | L16/dossiers | 16 | 16060000119879 | 16060000119879 | 1 | PA793194 | PM796200 |
| 16060000119887 | L16/dossiers | 16 | 16060000119886 | 16060000119886 | 1 | PA793194 | PM796200 |
| 16060000119894 | L16/dossiers | 16 | 16060000119893 | 16060000119893 | 1 | PA721474 | PM797511 |
| 16060000119901 | L16/dossiers | 16 | 16060000119900 | 16060000119900 | 1 | PA794410 | PM796911 |
| 16060000119908 | L16/dossiers | 16 | 16060000119907 | 16060000119907 | 1 | PA794410 | PM796911 |
| 16060000119915 | L16/dossiers | 16 | 16060000119914 | 16060000119914 | 1 | PA794894 | PM797181 |
| 16060000119922 | L16/dossiers | 16 | 16060000119921 | 16060000119921 | 1 | PA794894 | PM797181 |
| 16060000119929 | L16/dossiers | 16 | 16060000119928 | 16060000119928 | 1 | PA719922 | PM796767 |
| 16060000119945 | L16/dossiers | 16 | 16060000119944 | 16060000119944 | 1 | PA793756 | PM796512 |
| 16060000119952 | L16/dossiers | 16 | 16060000119951 | 16060000119951 | 1 | PA783457 | PM796992 |
| 16060000119959 | L16/dossiers | 16 | 16060000119958 | 16060000119958 | 1 | PA793306 | PM796254 |
| 16060000119983 | L16/dossiers | 16 | 16060000119982 | 16060000119982 | 1 | PA793572 | PM796413 |
| 16060000119996 | L16/dossiers | 16 | 16060000119995 | 16060000119995 | 1 | PA793398 | PM796302 |
| 16060000120003 | L16/dossiers | 16 | 16060000120002 | 16060000120002 | 1 | PA794638 | PM797034 |
| 16060000120010 | L16/dossiers | 16 | 16060000120009 | 16060000120009 | 1 | PA794538 | PM796977 |
| 16060000120017 | L16/dossiers | 16 | 16060000120016 | 16060000120016 | 1 | PA794570 | PM796998 |
| 16060000120024 | L16/dossiers | 16 | 16060000120023 | 16060000120023 | 1 | PA722366 | PM797193 |
| 16060000120032 | L16/dossiers | 16 | 16060000120031 | 16060000120031 | 1 | PA719372 | PM796446 |
| 16060000120042 | L16/dossiers | 16 | 16060000120041 | 16060000120041 | 1 | PA795422 | PM797478 |
| 16060000120049 | L16/dossiers | 16 | 16060000120048 | 16060000120048 | 1 | PA793122 | PM796161 |
| 16060000120056 | L16/dossiers | 16 | 16060000120055 | 16060000120055 | 1 | PA718674 | PM796164 |
| 16060000120063 | L16/dossiers | 16 | 16060000120062 | 16060000120062 | 1 | PA758716 | PM775771 |
| 16060000120064 | L16/dossiers | 16 | 16060000120062 | 16060000120062 | 2 | PA758716 | PM775771 |
| 16060000120071 | L16/dossiers | 16 | 16060000120070 | 16060000120070 | 1 | PA795430 | PM797481 |
| 16060000120091 | L16/dossiers | 16 | 16060000120090 | 16060000120090 | 1 | PA736218 | PM829869 |
| 16060000120098 | L16/dossiers | 16 | 16060000120097 | 16060000120097 | 1 | PA331481 | PM833713 |
| 16060000120131 | L16/dossiers | 16 | 16060000120130 | 16060000120130 | 1 | PA721442 | PM797253 |
| 16060000120152 | L16/dossiers | 16 | 16060000120151 | 16060000120151 | 1 | PA793322 | PM796260 |
| 16060000120159 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 1 | PA766947 | PM775799 |
| 16060000120160 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 2 | PA702993 | PM829493 |
| 16060000120161 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 3 | PA775186 | PM775484 |
| 16060000120162 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 4 | PA736241 | PM829931 |
| 16060000120163 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 5 | PA415488 | PM775641 |
| 16060000120164 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 6 | PA827900 | PM828434 |
| 16060000120165 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 7 | PA828018 | PM828882 |
| 16060000120166 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 8 | PA828010 | PM828832 |
| 16060000120167 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 9 | PA827940 | PM828622 |
| 16060000120168 | L16/dossiers | 16 | 16060000120158 | 16060000120158 | 10 | PA827982 | PM828718 |