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 |
|---|---|---|---|---|---|---|---|
| 15060000155965 | L15/dossiers | 15 | 15060000155964 | 15060000155964 | 1 | PA736207 | PM736391 |
| 15060000155972 | L15/dossiers | 15 | 15060000155971 | 15060000155971 | 1 | PA744079 | PM744082 |
| 15060000155979 | L15/dossiers | 15 | 15060000155978 | 15060000155978 | 1 | PA415448 | PM703610 |
| 15060000155986 | L15/dossiers | 15 | 15060000155985 | 15060000155985 | 1 | PA720634 | PM736312 |
| 15060000155993 | L15/dossiers | 15 | 15060000155992 | 15060000155992 | 1 | PA267328 | PM703547 |
| 15060000155994 | L15/dossiers | 15 | 15060000155992 | 15060000155992 | 2 | PA267018 | PM703564 |
| 15060000156001 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 1 | PA703517 | PM703625 |
| 15060000156002 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 2 | PA703494 | PM703602 |
| 15060000156003 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 3 | PA736186 | PM736396 |
| 15060000156004 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 4 | PA703518 | PM703704 |
| 15060000156005 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 5 | PA415447 | PM703616 |
| 15060000156006 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 6 | PA304108 | PM736399 |
| 15060000156007 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 7 | PA736192 | PM736353 |
| 15060000156008 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 8 | PA301592 | PM736375 |
| 15060000156009 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 9 | PA703483 | PM703613 |
| 15060000156010 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 10 | PA703539 | PM703693 |
| 15060000156011 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 11 | PA703501 | PM703629 |
| 15060000156012 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 12 | PA736160 | PM736359 |
| 15060000156013 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 13 | PA736237 | PM736417 |
| 15060000156014 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 14 | PA703521 | PM703544 |
| 15060000156015 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 15 | PA736226 | PM736280 |
| 15060000156016 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 16 | PA736223 | PM736368 |
| 15060000156017 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 17 | PA736235 | PM736426 |
| 15060000156018 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 18 | PA1993 | PM736402 |
| 15060000156019 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 19 | PA304085 | PM736343 |
| 15060000156020 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 20 | PA980 | PM736356 |
| 15060000156021 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 21 | PA425322 | PM736282 |
| 15060000156022 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 22 | PA736222 | PM736436 |
| 15060000156023 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 23 | PA304086 | PM736348 |
| 15060000156024 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 24 | PA703534 | PM703549 |
| 15060000156025 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 25 | PA415486 | PM703623 |
| 15060000156026 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 26 | PA267512 | PM703703 |
| 15060000156027 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 27 | PA703527 | PM703580 |
| 15060000156028 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 28 | PA415446 | PM703678 |
| 15060000156029 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 29 | PA429874 | PM736314 |
| 15060000156030 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 30 | PA703497 | PM703569 |
| 15060000156031 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 31 | PA429854 | PM736335 |
| 15060000156032 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 32 | PA267762 | PM736366 |
| 15060000156033 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 33 | PA1122 | PM736304 |
| 15060000156034 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 34 | PA736202 | PM736392 |
| 15060000156035 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 35 | PA394676 | PM703550 |
| 15060000156036 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 36 | PA703529 | PM703650 |
| 15060000156037 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 37 | PA342665 | PM736382 |
| 15060000156038 | L15/dossiers | 15 | 15060000156000 | 15060000156000 | 38 | PA227094 | PM736386 |
| 15060000156045 | L15/dossiers | 15 | 15060000156044 | 15060000156044 | 1 | PA303996 | PM703614 |
| 15060000156046 | L15/dossiers | 15 | 15060000156044 | 15060000156044 | 2 | PA2197 | PM703640 |
| 15060000156053 | L15/dossiers | 15 | 15060000156052 | 15060000156052 | 1 | PA429895 | PM736262 |
| 15060000156054 | L15/dossiers | 15 | 15060000156052 | 15060000156052 | 2 | PA905 | PM703566 |
| 15060000156061 | L15/dossiers | 15 | 15060000156060 | 15060000156060 | 1 | PA703539 | PM703693 |
| 15060000156068 | L15/dossiers | 15 | 15060000156067 | 15060000156067 | 1 | PA703537 | PM703595 |