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 |
|---|---|---|---|---|---|---|---|
| 15060000184179 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 50 | PA736246 | PM775819 |
| 15060000184180 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 51 | PA415451 | PM775787 |
| 15060000184181 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 52 | PA415447 | PM775785 |
| 15060000184182 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 53 | PA343775 | PM736367 |
| 15060000184183 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 54 | PA703537 | PM775721 |
| 15060000184184 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 55 | PA703497 | PM775637 |
| 15060000184185 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 56 | PA785193 | PM785197 |
| 15060000184186 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 57 | PA708632 | PM775667 |
| 15060000184187 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 58 | PA703517 | PM775675 |
| 15060000184188 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 59 | PA2197 | PM775755 |
| 15060000184189 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 60 | PA703518 | PM775673 |
| 15060000184190 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 61 | PA758716 | PM775771 |
| 15060000184191 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 62 | PA758716 | PM775771 |
| 15060000184192 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 63 | PA343988 | PM736310 |
| 15060000184193 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 64 | PA703521 | PM775707 |
| 15060000184194 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 65 | PA703541 | PM775725 |
| 15060000184195 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 66 | PA267328 | PM775729 |
| 15060000184196 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 67 | PA736200 | PM736285 |
| 15060000184197 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 68 | PA313924 | PM775727 |
| 15060000184198 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 69 | PA429842 | PM736373 |
| 15060000184199 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 70 | PA304086 | PM736348 |
| 15060000184200 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 71 | PA736239 | PM736317 |
| 15060000184201 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 72 | PA736240 | PM736279 |
| 15060000184202 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 73 | PA711156 | PM736319 |
| 15060000184203 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 74 | PA426327 | PM775735 |
| 15060000184204 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 75 | PA763158 | PM775683 |
| 15060000184205 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 76 | PA775276 | PM775566 |
| 15060000184206 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 77 | PA736227 | PM736308 |
| 15060000184207 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 78 | PA429851 | PM736305 |
| 15060000184208 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 79 | PA429874 | PM736314 |
| 15060000184209 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 80 | PA227094 | PM736386 |
| 15060000184210 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 81 | PA775298 | PM775594 |
| 15060000184211 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 82 | PA703527 | PM775709 |
| 15060000184212 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 83 | PA345785 | PM736294 |
| 15060000184219 | L15/dossiers | 15 | 15060000184218 | 15060000184218 | 1 | PA2116 | PM736339 |
| 15060000184226 | L15/dossiers | 15 | 15060000184225 | 15060000184225 | 1 | PA773441 | PM773491 |
| 15060000184227 | L15/dossiers | 15 | 15060000184225 | 15060000184225 | 2 | PA331481 | PM773459 |
| 15060000184228 | L15/dossiers | 15 | 15060000184225 | 15060000184225 | 3 | PA729332 | PM773437 |
| 15060000184282 | L15/dossiers | 15 | 15060000184281 | 15060000184281 | 1 | PA720952 | PM723122 |
| 15060000184289 | L15/dossiers | 15 | 15060000184288 | 15060000184288 | 1 | PA643089 | PM758076 |
| 15060000184296 | L15/dossiers | 15 | 15060000184295 | 15060000184295 | 1 | PA643127 | PM722636 |
| 15060000184303 | L15/dossiers | 15 | 15060000184302 | 15060000184302 | 1 | PA643089 | PM758076 |
| 15060000184310 | L15/dossiers | 15 | 15060000184309 | 15060000184309 | 1 | PA1327 | PM722762 |
| 15060000184317 | L15/dossiers | 15 | 15060000184316 | 15060000184316 | 1 | PA721486 | PM723290 |
| 15060000184324 | L15/dossiers | 15 | 15060000184323 | 15060000184323 | 1 | PA1008 | PM722704 |
| 15060000184332 | L15/dossiers | 15 | 15060000184331 | 15060000184331 | 1 | PA774960 | PM774985 |
| 15060000184348 | L15/dossiers | 15 | 15060000184347 | 15060000184347 | 1 | PA333285 | PM722906 |
| 15060000184365 | L15/dossiers | 15 | 15060000184364 | 15060000184364 | 1 | PA334768 | PM723548 |
| 15060000184372 | L15/dossiers | 15 | 15060000184371 | 15060000184371 | 1 | PA1327 | PM722762 |
| 15060000184379 | L15/dossiers | 15 | 15060000184378 | 15060000184378 | 1 | PA774958 | PM774981 |