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 |
|---|---|---|---|---|---|---|---|
| 15060000182747 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 29 | PA736217 | PM736384 |
| 15060000182748 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 30 | PA429855 | PM736425 |
| 15060000182758 | L15/dossiers | 15 | 15060000182757 | 15060000182757 | 1 | PA429870 | PM736309 |
| 15060000182776 | L15/dossiers | 15 | 15060000182775 | 15060000182775 | 1 | PA703497 | PM775637 |
| 15060000182795 | L15/dossiers | 15 | 15060000182794 | 15060000182794 | 1 | PA720692 | PM723042 |
| 15060000182800 | L15/dossiers | 15 | 15060000182799 | 15060000182799 | 1 | PA718926 | PM722502 |
| 15060000182815 | L15/dossiers | 15 | 15060000182814 | 15060000182814 | 1 | PA721924 | PM723422 |
| 15060000182819 | L15/dossiers | 15 | 15060000182818 | 15060000182818 | 1 | PA720162 | PM722878 |
| 15060000182828 | L15/dossiers | 15 | 15060000182827 | 15060000182827 | 1 | PA720022 | PM722836 |
| 15060000182835 | L15/dossiers | 15 | 15060000182834 | 15060000182834 | 1 | PA774956 | PM774979 |
| 15060000182842 | L15/dossiers | 15 | 15060000182841 | 15060000182841 | 1 | PA774958 | PM774981 |
| 15060000182855 | L15/dossiers | 15 | 15060000182854 | 15060000182854 | 1 | PA773441 | PM773491 |
| 15060000182865 | L15/dossiers | 15 | 15060000182864 | 15060000182864 | 1 | PA205280 | PM736412 |
| 15060000182872 | L15/dossiers | 15 | 15060000182871 | 15060000182871 | 1 | PA267328 | PM775729 |
| 15060000182879 | L15/dossiers | 15 | 15060000182878 | 15060000182878 | 1 | PA267328 | PM775729 |
| 15060000182886 | L15/dossiers | 15 | 15060000182885 | 15060000182885 | 1 | PA205280 | PM736412 |
| 15060000182893 | L15/dossiers | 15 | 15060000182892 | 15060000182892 | 1 | PA205280 | PM736412 |
| 15060000182900 | L15/dossiers | 15 | 15060000182899 | 15060000182899 | 1 | PA205280 | PM736412 |
| 15060000182907 | L15/dossiers | 15 | 15060000182906 | 15060000182906 | 1 | PA205280 | PM736412 |
| 15060000182914 | L15/dossiers | 15 | 15060000182913 | 15060000182913 | 1 | PA429854 | PM736335 |
| 15060000182921 | L15/dossiers | 15 | 15060000182920 | 15060000182920 | 1 | PA736206 | PM736351 |
| 15060000182931 | L15/dossiers | 15 | 15060000182930 | 15060000182930 | 1 | PA721398 | PM723262 |
| 15060000182938 | L15/dossiers | 15 | 15060000182937 | 15060000182937 | 1 | PA719778 | PM722760 |
| 15060000182945 | L15/dossiers | 15 | 15060000182944 | 15060000182944 | 1 | PA722142 | PM723484 |
| 15060000182949 | L15/dossiers | 15 | 15060000182948 | 15060000182948 | 1 | PA774962 | PM774987 |
| 15060000182959 | L15/dossiers | 15 | 15060000182958 | 15060000182958 | 1 | PA2116 | PM736339 |
| 15060000182966 | L15/dossiers | 15 | 15060000182965 | 15060000182965 | 1 | PA703521 | PM775707 |
| 15060000182973 | L15/dossiers | 15 | 15060000182972 | 15060000182972 | 1 | PA719946 | PM722808 |
| 15060000182980 | L15/dossiers | 15 | 15060000182979 | 15060000182979 | 1 | PA609726 | PM723426 |
| 15060000182995 | L15/dossiers | 15 | 15060000182994 | 15060000182994 | 1 | PA405480 | PM723118 |
| 15060000183002 | L15/dossiers | 15 | 15060000183001 | 15060000183001 | 1 | PA722260 | PM723520 |
| 15060000183009 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 1 | PA415447 | PM775785 |
| 15060000183010 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 2 | PA736211 | PM736410 |
| 15060000183011 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 3 | PA304108 | PM736399 |
| 15060000183012 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 4 | PA267081 | PM775733 |
| 15060000183013 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 5 | PA736246 | PM775819 |
| 15060000183014 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 6 | PA744079 | PM744082 |
| 15060000183015 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 7 | PA703515 | PM775663 |
| 15060000183016 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 8 | PA703497 | PM775637 |
| 15060000183017 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 9 | PA736188 | PM736289 |
| 15060000183018 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 10 | PA703527 | PM775709 |
| 15060000183019 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 11 | PA736192 | PM736353 |
| 15060000183020 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 12 | PA703541 | PM775725 |
| 15060000183021 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 13 | PA736218 | PM736257 |
| 15060000183022 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 14 | PA415467 | PM775803 |
| 15060000183023 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 15 | PA227094 | PM736386 |
| 15060000183024 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 16 | PA429854 | PM736335 |
| 15060000183025 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 17 | PA343775 | PM736367 |
| 15060000183026 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 18 | PA1344 | PM736383 |
| 15060000183027 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 19 | PA343988 | PM736310 |