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 |
|---|---|---|---|---|---|---|---|
| 15060000156191 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 24 | PA429867 | PM736298 |
| 15060000156192 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 25 | PA429833 | PM736271 |
| 15060000156193 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 26 | PA736191 | PM736336 |
| 15060000156194 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 27 | PA708633 | PM708642 |
| 15060000156195 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 28 | PA415477 | PM736418 |
| 15060000156196 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 29 | PA736187 | PM736365 |
| 15060000156197 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 30 | PA415468 | PM703648 |
| 15060000156198 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 31 | PA736167 | PM736327 |
| 15060000156199 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 32 | PA736164 | PM736430 |
| 15060000156200 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 33 | PA703508 | PM703601 |
| 15060000156201 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 34 | PA642756 | PM736429 |
| 15060000156202 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 35 | PA736233 | PM736411 |
| 15060000156203 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 36 | PA736241 | PM736300 |
| 15060000156204 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 37 | PA736161 | PM736421 |
| 15060000156205 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 38 | PA703509 | PM703687 |
| 15060000156206 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 39 | PA736181 | PM736416 |
| 15060000156207 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 40 | PA736225 | PM736334 |
| 15060000156208 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 41 | PA703536 | PM703563 |
| 15060000156209 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 42 | PA736229 | PM736389 |
| 15060000156210 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 43 | PA703533 | PM703593 |
| 15060000156211 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 44 | PA429860 | PM736398 |
| 15060000156212 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 45 | PA415453 | PM703691 |
| 15060000156213 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 46 | PA1978 | PM736337 |
| 15060000156214 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 47 | PA415449 | PM703686 |
| 15060000156215 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 48 | PA342564 | PM736388 |
| 15060000156216 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 49 | PA268048 | PM736422 |
| 15060000156217 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 50 | PA429888 | PM736379 |
| 15060000156218 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 51 | PA2047 | PM703606 |
| 15060000156219 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 52 | PA2074 | PM703673 |
| 15060000156220 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 53 | PA415484 | PM703622 |
| 15060000156221 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 54 | PA429844 | PM736276 |
| 15060000156222 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 55 | PA703512 | PM703575 |
| 15060000156223 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 56 | PA643211 | PM703707 |
| 15060000156224 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 57 | PA2371 | PM703712 |
| 15060000156225 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 58 | PA736209 | PM736400 |
| 15060000156226 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 59 | PA703505 | PM703626 |
| 15060000156227 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 60 | PA703511 | PM703635 |
| 15060000156228 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 61 | PA429883 | PM736355 |
| 15060000156229 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 62 | PA2776 | PM703596 |
| 15060000156230 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 63 | PA736201 | PM736347 |
| 15060000156231 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 64 | PA736214 | PM736290 |
| 15060000156232 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 65 | PA736217 | PM736384 |
| 15060000156233 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 66 | PA703481 | PM703670 |
| 15060000156234 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 67 | PA227096 | PM736342 |
| 15060000156235 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 68 | PA703491 | PM703634 |
| 15060000156236 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 69 | PA2870 | PM736316 |
| 15060000156237 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 70 | PA736162 | PM736320 |
| 15060000156238 | L15/dossiers | 15 | 15060000156167 | 15060000156167 | 71 | PA429852 | PM736275 |
| 15060000156245 | L15/dossiers | 15 | 15060000156244 | 15060000156244 | 1 | PA415446 | PM703678 |
| 15060000156252 | L15/dossiers | 15 | 15060000156251 | 15060000156251 | 1 | PA267340 | PM703713 |