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 |
|---|---|---|---|---|---|---|---|
| 15060000180913 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 21 | PA642756 | PM775779 |
| 15060000180914 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 22 | PA736241 | PM736300 |
| 15060000180915 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 23 | PA703536 | PM775719 |
| 15060000180916 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 24 | PA736229 | PM736389 |
| 15060000180917 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 25 | PA605888 | PM775604 |
| 15060000180918 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 26 | PA268048 | PM736422 |
| 15060000180919 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 27 | PA429888 | PM736379 |
| 15060000180920 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 28 | PA775254 | PM775556 |
| 15060000180921 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 29 | PA775256 | PM775546 |
| 15060000180922 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 30 | PA703512 | PM775665 |
| 15060000180923 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 31 | PA643211 | PM775749 |
| 15060000180924 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 32 | PA775268 | PM775574 |
| 15060000180925 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 33 | PA703505 | PM775679 |
| 15060000180926 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 34 | PA775274 | PM775560 |
| 15060000180927 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 35 | PA703511 | PM775685 |
| 15060000180928 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 36 | PA429883 | PM736355 |
| 15060000180929 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 37 | PA736217 | PM736384 |
| 15060000180930 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 38 | PA227096 | PM736342 |
| 15060000180931 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 39 | PA227096 | PM736342 |
| 15060000180932 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 40 | PA775294 | PM775580 |
| 15060000180933 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 41 | PA2870 | PM736316 |
| 15060000180934 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 42 | PA2870 | PM736316 |
| 15060000180935 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 43 | PA736162 | PM736320 |
| 15060000180936 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 44 | PA429852 | PM736275 |
| 15060000180954 | L15/dossiers | 15 | 15060000180953 | 15060000180953 | 1 | PA736218 | PM736257 |
| 15060000180961 | L15/dossiers | 15 | 15060000180960 | 15060000180960 | 1 | PA775202 | PM775502 |
| 15060000180968 | L15/dossiers | 15 | 15060000180967 | 15060000180967 | 1 | PA719946 | PM722808 |
| 15060000180975 | L15/dossiers | 15 | 15060000180974 | 15060000180974 | 1 | PA607090 | PM722796 |
| 15060000180987 | L15/dossiers | 15 | 15060000180986 | 15060000180986 | 1 | PA345722 | PM723428 |
| 15060000180994 | L15/dossiers | 15 | 15060000180993 | 15060000180993 | 1 | PA268019 | PM723092 |
| 15060000181001 | L15/dossiers | 15 | 15060000181000 | 15060000181000 | 1 | PA718784 | PM722456 |
| 15060000181008 | L15/dossiers | 15 | 15060000181007 | 15060000181007 | 1 | PA643089 | PM758076 |
| 15060000181012 | L15/dossiers | 15 | 15060000181011 | 15060000181011 | 1 | PA774954 | PM774972 |
| 15060000181019 | L15/dossiers | 15 | 15060000181018 | 15060000181018 | 1 | PA429832 | PM736408 |
| 15060000181061 | L15/dossiers | 15 | 15060000181060 | 15060000181060 | 1 | PA773441 | PM773491 |
| 15060000181062 | L15/dossiers | 15 | 15060000181060 | 15060000181060 | 2 | PA331481 | PM773459 |
| 15060000181069 | L15/dossiers | 15 | 15060000181068 | 15060000181068 | 1 | PA773441 | PM773491 |
| 15060000181070 | L15/dossiers | 15 | 15060000181068 | 15060000181068 | 2 | PA721670 | PM773499 |
| 15060000181077 | L15/dossiers | 15 | 15060000181076 | 15060000181076 | 1 | PA773441 | PM773491 |
| 15060000181107 | L15/dossiers | 15 | 15060000181106 | 15060000181106 | 1 | PA720210 | PM722892 |
| 15060000181111 | L15/dossiers | 15 | 15060000181110 | 15060000181110 | 1 | PA642868 | PM722992 |
| 15060000181118 | L15/dossiers | 15 | 15060000181117 | 15060000181117 | 1 | PA330240 | PM722492 |
| 15060000181125 | L15/dossiers | 15 | 15060000181124 | 15060000181124 | 1 | PA783457 | PM783488 |
| 15060000181132 | L15/dossiers | 15 | 15060000181131 | 15060000181131 | 1 | PA2538 | PM775801 |
| 15060000181133 | L15/dossiers | 15 | 15060000181131 | 15060000181131 | 2 | PA702993 | PM736362 |
| 15060000181134 | L15/dossiers | 15 | 15060000181131 | 15060000181131 | 3 | PA429832 | PM736408 |
| 15060000181135 | L15/dossiers | 15 | 15060000181131 | 15060000181131 | 4 | PA736177 | PM736318 |
| 15060000181136 | L15/dossiers | 15 | 15060000181131 | 15060000181131 | 5 | PA2774 | PM736307 |
| 15060000181137 | L15/dossiers | 15 | 15060000181131 | 15060000181131 | 6 | PA303997 | PM775743 |
| 15060000181147 | L15/dossiers | 15 | 15060000181146 | 15060000181146 | 1 | PA712015 | PM722448 |