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 |
|---|---|---|---|---|---|---|---|
| 17060000152818 | L17/dossiers | 17 | 17060000152817 | 17060000152817 | 1 | PA610968 | PM840381 |
| 17060000152825 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 1 | PA775248 | PM775554 |
| 17060000152826 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 2 | PA775202 | PM775502 |
| 17060000152827 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 3 | PA736216 | PM829875 |
| 17060000152828 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 4 | PA736235 | PM874830 |
| 17060000152829 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 5 | PA736235 | PM874830 |
| 17060000152830 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 6 | PA703537 | PM775721 |
| 17060000152831 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 7 | PA703480 | PM775807 |
| 17060000152832 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 8 | PA267907 | PM775751 |
| 17060000152833 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 9 | PA736184 | PM829817 |
| 17060000152834 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 10 | PA827952 | PM828698 |
| 17060000152835 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 11 | PA703529 | PM836349 |
| 17060000152836 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 12 | PA703529 | PM836349 |
| 17060000152837 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 13 | PA703528 | PM775693 |
| 17060000152838 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 14 | PA775172 | PM775474 |
| 17060000152839 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 15 | PA590034 | PM775606 |
| 17060000152840 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 16 | PA760322 | PM775649 |
| 17060000152841 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 17 | PA2197 | PM775755 |
| 17060000152842 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 18 | PA775194 | PM775476 |
| 17060000152843 | L17/dossiers | 17 | 17060000152824 | 17060000152824 | 19 | PA775196 | PM775482 |
| 17060000152850 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 1 | PA736195 | PM829855 |
| 17060000152851 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 2 | PA775246 | PM775532 |
| 17060000152852 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 3 | PA827962 | PM828676 |
| 17060000152853 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 4 | PA757676 | PM829801 |
| 17060000152854 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 5 | PA775172 | PM775474 |
| 17060000152855 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 6 | PA827898 | PM828454 |
| 17060000152856 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 7 | PA850008 | PM850016 |
| 17060000152857 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 8 | PA827912 | PM828488 |
| 17060000152858 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 9 | PA756685 | PM775777 |
| 17060000152859 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 10 | PA827930 | PM828544 |
| 17060000152860 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 11 | PA268007 | PM829695 |
| 17060000152861 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 12 | PA429886 | PM829757 |
| 17060000152862 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 13 | PA736173 | PM829799 |
| 17060000152863 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 14 | PA736243 | PM829929 |
| 17060000152864 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 15 | PA736175 | PM829795 |
| 17060000152865 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 16 | PA828002 | PM828856 |
| 17060000152866 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 17 | PA775296 | PM775596 |
| 17060000152867 | L17/dossiers | 17 | 17060000152849 | 17060000152849 | 18 | PA828020 | PM828864 |
| 17060000152874 | L17/dossiers | 17 | 17060000152873 | 17060000152873 | 1 | PA841067 | PM842687 |
| 17060000152881 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 1 | PA343988 | PM829809 |
| 17060000152882 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 2 | PA827894 | PM828460 |
| 17060000152883 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 3 | PA703540 | PM775723 |
| 17060000152884 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 4 | PA775178 | PM775460 |
| 17060000152885 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 5 | PA773891 | PM829713 |
| 17060000152886 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 6 | PA881045 | PM881048 |
| 17060000152887 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 7 | PA736198 | PM829861 |
| 17060000152888 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 8 | PA736216 | PM829875 |
| 17060000152889 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 9 | PA827914 | PM828494 |
| 17060000152890 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 10 | PA775202 | PM775502 |
| 17060000152891 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 11 | PA775204 | PM775508 |