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 |
|---|---|---|---|---|---|---|---|
| 15060000158019 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 24 | PA736214 | PM736290 |
| 15060000158020 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 25 | PA341381 | PM703618 |
| 15060000158021 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 26 | PA736235 | PM736426 |
| 15060000158022 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 27 | PA1122 | PM736304 |
| 15060000158023 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 28 | PA736158 | PM736414 |
| 15060000158024 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 29 | PA703521 | PM703544 |
| 15060000158025 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 30 | PA415447 | PM703616 |
| 15060000158026 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 31 | PA1883 | PM736286 |
| 15060000158027 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 32 | PA1344 | PM736383 |
| 15060000158028 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 33 | PA703483 | PM703613 |
| 15060000158029 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 34 | PA415486 | PM703623 |
| 15060000158030 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 35 | PA703490 | PM703631 |
| 15060000158031 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 36 | PA703509 | PM703687 |
| 15060000158032 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 37 | PA736217 | PM736384 |
| 15060000158033 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 38 | PA736226 | PM736280 |
| 15060000158034 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 39 | PA703533 | PM703593 |
| 15060000158035 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 40 | PA736203 | PM736432 |
| 15060000158036 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 41 | PA394676 | PM703550 |
| 15060000158037 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 42 | PA404656 | PM736328 |
| 15060000158038 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 43 | PA736242 | PM736349 |
| 15060000158039 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 44 | PA736194 | PM736291 |
| 15060000158040 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 45 | PA267907 | PM703591 |
| 15060000158041 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 46 | PA736227 | PM736308 |
| 15060000158042 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 47 | PA736228 | PM736380 |
| 15060000158043 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 48 | PA235 | PM703560 |
| 15060000158044 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 49 | PA429852 | PM736275 |
| 15060000158045 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 50 | PA703529 | PM703650 |
| 15060000158046 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 51 | PA706108 | PM736256 |
| 15060000158047 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 52 | PA703480 | PM703624 |
| 15060000158048 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 53 | PA343775 | PM736367 |
| 15060000158049 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 54 | PA736238 | PM736352 |
| 15060000158050 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 55 | PA736183 | PM736405 |
| 15060000158051 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 56 | PA736163 | PM736253 |
| 15060000158052 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 57 | PA429870 | PM736309 |
| 15060000158053 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 58 | PA227029 | PM736306 |
| 15060000158054 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 59 | PA703523 | PM703578 |
| 15060000158055 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 60 | PA736168 | PM736301 |
| 15060000158056 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 61 | PA227098 | PM736321 |
| 15060000158057 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 62 | PA1573 | PM703652 |
| 15060000158058 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 63 | PA415489 | PM703714 |
| 15060000158059 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 64 | PA703501 | PM703629 |
| 15060000158060 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 65 | PA415480 | PM709303 |
| 15060000158061 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 66 | PA415480 | PM709303 |
| 15060000158062 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 67 | PA268007 | PM736325 |
| 15060000158063 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 68 | PA732419 | PM760862 |
| 15060000158064 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 69 | PA732419 | PM760862 |
| 15060000158065 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 70 | PA703515 | PM703592 |
| 15060000158066 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 71 | PA736240 | PM736279 |
| 15060000158067 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 72 | PA345785 | PM736294 |
| 15060000158068 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 73 | PA267081 | PM703617 |