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 |
|---|---|---|---|---|---|---|---|
| 17060000120760 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 63 | PA736214 | PM829883 |
| 17060000120761 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 64 | PA736217 | PM829873 |
| 17060000120762 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 65 | PA828010 | PM828832 |
| 17060000120763 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 66 | PA775294 | PM775580 |
| 17060000120764 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 67 | PA828014 | PM828818 |
| 17060000120765 | L17/dossiers | 17 | 17060000120697 | 17060000120697 | 68 | PA828018 | PM828882 |
| 17060000120780 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 1 | PA429886 | PM829757 |
| 17060000120781 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 2 | PA827912 | PM828488 |
| 17060000120782 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 3 | PA757676 | PM829801 |
| 17060000120783 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 4 | PA775172 | PM775474 |
| 17060000120784 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 5 | PA827898 | PM828454 |
| 17060000120785 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 6 | PA429894 | PM829765 |
| 17060000120786 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 7 | PA756685 | PM775777 |
| 17060000120787 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 8 | PA827930 | PM828544 |
| 17060000120788 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 9 | PA268007 | PM829695 |
| 17060000120789 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 10 | PA736195 | PM829855 |
| 17060000120790 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 11 | PA736173 | PM829799 |
| 17060000120791 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 12 | PA775246 | PM775532 |
| 17060000120792 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 13 | PA827962 | PM828676 |
| 17060000120793 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 14 | PA736243 | PM829929 |
| 17060000120794 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 15 | PA736175 | PM829795 |
| 17060000120795 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 16 | PA828002 | PM828856 |
| 17060000120796 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 17 | PA775296 | PM775596 |
| 17060000120797 | L17/dossiers | 17 | 17060000120779 | 17060000120779 | 18 | PA828020 | PM828864 |
| 17060000120804 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 1 | PA703511 | PM775685 |
| 17060000120805 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 2 | PA702993 | PM829493 |
| 17060000120806 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 3 | PA703512 | PM775665 |
| 17060000120807 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 4 | PA642982 | PM829146 |
| 17060000120808 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 5 | PA785855 | PM785869 |
| 17060000120809 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 6 | PA712422 | PM828926 |
| 17060000120810 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 7 | PA415449 | PM775793 |
| 17060000120811 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 8 | PA643028 | PM829316 |
| 17060000120812 | L17/dossiers | 17 | 17060000120803 | 17060000120803 | 9 | PA828022 | PM828870 |
| 17060000120831 | L17/dossiers | 17 | 17060000120830 | 17060000120830 | 1 | PA721742 | PM829056 |
| 17060000120849 | L17/dossiers | 17 | 17060000120848 | 17060000120848 | 1 | PA330684 | PM775859 |
| 17060000120856 | L17/dossiers | 17 | 17060000120855 | 17060000120855 | 1 | PA736241 | PM829931 |
| 17060000120863 | L17/dossiers | 17 | 17060000120862 | 17060000120862 | 1 | PA795808 | PM843644 |
| 17060000120867 | L17/dossiers | 17 | 17060000120866 | 17060000120866 | 1 | PA719968 | PM842891 |
| 17060000120874 | L17/dossiers | 17 | 17060000120873 | 17060000120873 | 1 | PA795176 | PM843788 |
| 17060000120881 | L17/dossiers | 17 | 17060000120880 | 17060000120880 | 1 | PA719558 | PM842663 |
| 17060000120896 | L17/dossiers | 17 | 17060000120895 | 17060000120895 | 1 | PA426327 | PM775735 |
| 17060000120903 | L17/dossiers | 17 | 17060000120902 | 17060000120902 | 1 | PA775192 | PM775478 |
| 17060000120910 | L17/dossiers | 17 | 17060000120909 | 17060000120909 | 1 | PA718838 | PM842405 |
| 17060000120914 | L17/dossiers | 17 | 17060000120913 | 17060000120913 | 1 | PA2952 | PM842414 |
| 17060000120921 | L17/dossiers | 17 | 17060000120920 | 17060000120920 | 1 | PA2952 | PM842414 |
| 17060000120928 | L17/dossiers | 17 | 17060000120927 | 17060000120927 | 1 | PA793342 | PM842345 |
| 17060000120932 | L17/dossiers | 17 | 17060000120931 | 17060000120931 | 1 | PA346782 | PM840426 |
| 17060000120936 | L17/dossiers | 17 | 17060000120935 | 17060000120935 | 1 | PA346782 | PM840426 |
| 17060000120943 | L17/dossiers | 17 | 17060000120942 | 17060000120942 | 1 | PA721442 | PM843362 |
| 17060000120947 | L17/dossiers | 17 | 17060000120946 | 17060000120946 | 1 | PA721442 | PM843362 |