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 |
|---|---|---|---|---|---|---|---|
| 16060000095050 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 36 | PA736248 | PM736269 |
| 16060000095051 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 37 | PA736241 | PM736300 |
| 16060000095052 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 38 | PA703509 | PM775687 |
| 16060000095053 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 39 | PA736181 | PM736416 |
| 16060000095054 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 40 | PA736225 | PM736334 |
| 16060000095055 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 41 | PA703536 | PM775719 |
| 16060000095056 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 42 | PA736229 | PM736389 |
| 16060000095057 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 43 | PA429860 | PM736398 |
| 16060000095058 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 44 | PA605888 | PM775604 |
| 16060000095059 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 45 | PA415449 | PM775793 |
| 16060000095060 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 46 | PA342564 | PM736388 |
| 16060000095061 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 47 | PA268048 | PM736422 |
| 16060000095062 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 48 | PA429888 | PM736379 |
| 16060000095063 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 49 | PA2074 | PM775677 |
| 16060000095064 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 50 | PA775254 | PM775556 |
| 16060000095065 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 51 | PA775256 | PM775546 |
| 16060000095066 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 52 | PA643211 | PM775749 |
| 16060000095067 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 53 | PA775268 | PM775574 |
| 16060000095068 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 54 | PA606375 | PM775602 |
| 16060000095069 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 55 | PA736209 | PM736400 |
| 16060000095070 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 56 | PA703505 | PM775679 |
| 16060000095071 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 57 | PA775274 | PM775560 |
| 16060000095072 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 58 | PA703511 | PM775685 |
| 16060000095073 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 59 | PA429883 | PM736355 |
| 16060000095074 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 60 | PA775290 | PM775576 |
| 16060000095075 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 61 | PA2774 | PM736307 |
| 16060000095076 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 62 | PA736214 | PM736290 |
| 16060000095077 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 63 | PA736217 | PM736384 |
| 16060000095078 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 64 | PA227096 | PM736342 |
| 16060000095079 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 65 | PA227096 | PM736342 |
| 16060000095080 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 66 | PA775294 | PM775580 |
| 16060000095081 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 67 | PA2870 | PM736316 |
| 16060000095082 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 68 | PA2870 | PM736316 |
| 16060000095083 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 69 | PA736162 | PM736320 |
| 16060000095084 | L16/dossiers | 16 | 16060000095014 | 16060000095014 | 70 | PA429852 | PM736275 |
| 16060000095091 | L16/dossiers | 16 | 16060000095090 | 16060000095090 | 1 | PA415446 | PM775783 |
| 16060000095092 | L16/dossiers | 16 | 16060000095090 | 16060000095090 | 2 | PA643211 | PM775749 |
| 16060000095099 | L16/dossiers | 16 | 16060000095098 | 16060000095098 | 1 | PA793362 | PM796284 |
| 16060000095103 | L16/dossiers | 16 | 16060000095102 | 16060000095102 | 1 | PA721908 | PM797568 |
| 16060000095107 | L16/dossiers | 16 | 16060000095106 | 16060000095106 | 1 | PA775168 | PM775470 |
| 16060000095114 | L16/dossiers | 16 | 16060000095113 | 16060000095113 | 1 | PA775286 | PM775588 |
| 16060000095115 | L16/dossiers | 16 | 16060000095113 | 16060000095113 | 2 | PA703501 | PM775645 |
| 16060000095122 | L16/dossiers | 16 | 16060000095121 | 16060000095121 | 1 | PA736236 | PM736341 |
| 16060000095129 | L16/dossiers | 16 | 16060000095128 | 16060000095128 | 1 | PA717161 | PM791583 |
| 16060000095161 | L16/dossiers | 16 | 16060000095160 | 16060000095160 | 1 | PA722046 | PM797625 |
| 16060000095168 | L16/dossiers | 16 | 16060000095167 | 16060000095167 | 1 | PA720100 | PM796860 |
| 16060000095175 | L16/dossiers | 16 | 16060000095174 | 16060000095174 | 1 | PA720100 | PM796860 |
| 16060000095182 | L16/dossiers | 16 | 16060000095181 | 16060000095181 | 1 | PA720100 | PM796860 |
| 16060000095189 | L16/dossiers | 16 | 16060000095188 | 16060000095188 | 1 | PA267042 | PM796932 |
| 16060000095196 | L16/dossiers | 16 | 16060000095195 | 16060000095195 | 1 | PA722252 | PM797610 |