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 |
|---|---|---|---|---|---|---|---|
| 17060000141736 | L17/dossiers | 17 | 17060000141735 | 17060000141735 | 1 | PA827958 | PM828690 |
| 17060000141743 | L17/dossiers | 17 | 17060000141742 | 17060000141742 | 1 | PA712014 | PM858454 |
| 17060000141750 | L17/dossiers | 17 | 17060000141749 | 17060000141749 | 1 | PA712014 | PM858454 |
| 17060000141757 | L17/dossiers | 17 | 17060000141756 | 17060000141756 | 1 | PA712014 | PM858454 |
| 17060000141764 | L17/dossiers | 17 | 17060000141763 | 17060000141763 | 1 | PA719890 | PM842855 |
| 17060000141771 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 1 | PA756685 | PM775777 |
| 17060000141772 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 2 | PA757676 | PM829801 |
| 17060000141773 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 3 | PA828002 | PM828856 |
| 17060000141774 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 4 | PA429886 | PM829757 |
| 17060000141775 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 5 | PA775172 | PM775474 |
| 17060000141776 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 6 | PA827898 | PM828454 |
| 17060000141777 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 7 | PA850008 | PM850016 |
| 17060000141778 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 8 | PA827912 | PM828488 |
| 17060000141779 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 9 | PA827930 | PM828544 |
| 17060000141780 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 10 | PA268007 | PM829695 |
| 17060000141781 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 11 | PA736195 | PM829855 |
| 17060000141782 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 12 | PA736173 | PM829799 |
| 17060000141783 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 13 | PA775246 | PM775532 |
| 17060000141784 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 14 | PA827962 | PM828676 |
| 17060000141785 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 15 | PA736243 | PM829929 |
| 17060000141786 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 16 | PA736175 | PM829795 |
| 17060000141787 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 17 | PA775296 | PM775596 |
| 17060000141788 | L17/dossiers | 17 | 17060000141770 | 17060000141770 | 18 | PA828020 | PM828864 |
| 17060000141795 | L17/dossiers | 17 | 17060000141794 | 17060000141794 | 1 | PA643143 | PM843761 |
| 17060000141812 | L17/dossiers | 17 | 17060000141811 | 17060000141811 | 1 | PA330240 | PM842357 |
| 17060000141819 | L17/dossiers | 17 | 17060000141818 | 17060000141818 | 1 | PA794166 | PM842924 |
| 17060000141829 | L17/dossiers | 17 | 17060000141828 | 17060000141828 | 1 | PA335054 | PM843332 |
| 17060000141842 | L17/dossiers | 17 | 17060000141841 | 17060000141841 | 1 | PA1567 | PM843572 |
| 17060000141855 | L17/dossiers | 17 | 17060000141854 | 17060000141854 | 1 | PA335054 | PM843332 |
| 17060000141862 | L17/dossiers | 17 | 17060000141861 | 17060000141861 | 1 | PA794146 | PM842912 |
| 17060000141886 | L17/dossiers | 17 | 17060000141885 | 17060000141885 | 1 | PA736241 | PM829931 |
| 17060000141893 | L17/dossiers | 17 | 17060000141892 | 17060000141892 | 1 | PA827942 | PM828628 |
| 17060000141900 | L17/dossiers | 17 | 17060000141899 | 17060000141899 | 1 | PA775248 | PM775554 |
| 17060000141907 | L17/dossiers | 17 | 17060000141906 | 17060000141906 | 1 | PA827992 | PM828776 |
| 17060000141927 | L17/dossiers | 17 | 17060000141926 | 17060000141926 | 1 | PA774954 | PM842843 |
| 17060000141931 | L17/dossiers | 17 | 17060000141930 | 17060000141930 | 1 | PA2940 | PM842531 |
| 17060000141938 | L17/dossiers | 17 | 17060000141937 | 17060000141937 | 1 | PA643211 | PM775749 |
| 17060000141945 | L17/dossiers | 17 | 17060000141944 | 17060000141944 | 1 | PA794138 | PM842909 |
| 17060000141952 | L17/dossiers | 17 | 17060000141951 | 17060000141951 | 1 | PA795808 | PM843644 |
| 17060000141959 | L17/dossiers | 17 | 17060000141958 | 17060000141958 | 1 | PA841931 | PM843485 |
| 17060000141966 | L17/dossiers | 17 | 17060000141965 | 17060000141965 | 1 | PA719558 | PM842663 |
| 17060000141973 | L17/dossiers | 17 | 17060000141972 | 17060000141972 | 1 | PA840721 | PM842378 |
| 17060000141980 | L17/dossiers | 17 | 17060000141979 | 17060000141979 | 1 | PA840721 | PM842378 |
| 17060000141987 | L17/dossiers | 17 | 17060000141986 | 17060000141986 | 1 | PA795084 | PM840369 |
| 17060000141994 | L17/dossiers | 17 | 17060000141993 | 17060000141993 | 1 | PA721984 | PM843536 |
| 17060000142001 | L17/dossiers | 17 | 17060000142000 | 17060000142000 | 1 | PA309643 | PM843545 |
| 17060000142008 | L17/dossiers | 17 | 17060000142007 | 17060000142007 | 1 | PA841681 | PM843245 |
| 17060000142015 | L17/dossiers | 17 | 17060000142014 | 17060000142014 | 1 | PA793464 | PM840273 |
| 17060000142022 | L17/dossiers | 17 | 17060000142021 | 17060000142021 | 1 | PA793736 | PM842693 |
| 17060000142029 | L17/dossiers | 17 | 17060000142028 | 17060000142028 | 1 | PA266808 | PM843347 |