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 |
|---|---|---|---|---|---|---|---|
| 15060000169315 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 24 | PA736206 | PM736351 |
| 15060000169316 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 25 | PA736238 | PM736352 |
| 15060000169317 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 26 | PA736246 | PM736428 |
| 15060000169318 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 27 | PA429854 | PM736335 |
| 15060000169319 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 28 | PA415467 | PM703636 |
| 15060000169320 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 29 | PA703539 | PM703693 |
| 15060000169321 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 30 | PA767418 | PM767422 |
| 15060000169322 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 31 | PA703494 | PM703602 |
| 15060000169323 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 32 | PA736200 | PM736285 |
| 15060000169324 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 33 | PA607489 | PM736390 |
| 15060000169325 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 34 | PA227094 | PM736386 |
| 15060000169326 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 35 | PA404656 | PM736328 |
| 15060000169327 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 36 | PA267328 | PM703547 |
| 15060000169328 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 37 | PA345785 | PM736294 |
| 15060000169329 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 38 | PA313924 | PM703546 |
| 15060000169330 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 39 | PA569 | PM703710 |
| 15060000169331 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 40 | PA711156 | PM736319 |
| 15060000169332 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 41 | PA736213 | PM736431 |
| 15060000169333 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 42 | PA703527 | PM703580 |
| 15060000169334 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 43 | PA736218 | PM736257 |
| 15060000169335 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 44 | PA2197 | PM703640 |
| 15060000169336 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 45 | PA703513 | PM703621 |
| 15060000169337 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 46 | PA1344 | PM736383 |
| 15060000169338 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 47 | PA703521 | PM703544 |
| 15060000169339 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 48 | PA736205 | PM736288 |
| 15060000169340 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 49 | PA758431 | PM758701 |
| 15060000169341 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 50 | PA736166 | PM736435 |
| 15060000169342 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 51 | PA736167 | PM736327 |
| 15060000169343 | L15/dossiers | 15 | 15060000169291 | 15060000169291 | 52 | PA415462 | PM703628 |
| 15060000169361 | L15/dossiers | 15 | 15060000169360 | 15060000169360 | 1 | PA722142 | PM723484 |
| 15060000169368 | L15/dossiers | 15 | 15060000169367 | 15060000169367 | 1 | PA720892 | PM723106 |
| 15060000169375 | L15/dossiers | 15 | 15060000169374 | 15060000169374 | 1 | PA721474 | PM723286 |
| 15060000169379 | L15/dossiers | 15 | 15060000169378 | 15060000169378 | 1 | PA721474 | PM723286 |
| 15060000169383 | L15/dossiers | 15 | 15060000169382 | 15060000169382 | 1 | PA605518 | PM722518 |
| 15060000169393 | L15/dossiers | 15 | 15060000169392 | 15060000169392 | 1 | PA718884 | PM722488 |
| 15060000169400 | L15/dossiers | 15 | 15060000169399 | 15060000169399 | 1 | PA720846 | PM723094 |
| 15060000169407 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 1 | PA304000 | PM703599 |
| 15060000169408 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 2 | PA1883 | PM736286 |
| 15060000169409 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 3 | PA736202 | PM736392 |
| 15060000169410 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 4 | PA703532 | PM703568 |
| 15060000169411 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 5 | PA703500 | PM703574 |
| 15060000169412 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 6 | PA703539 | PM703693 |
| 15060000169413 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 7 | PA267081 | PM703617 |
| 15060000169414 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 8 | PA415451 | PM703594 |
| 15060000169415 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 9 | PA703523 | PM703578 |
| 15060000169416 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 10 | PA703493 | PM703683 |
| 15060000169417 | L15/dossiers | 15 | 15060000169406 | 15060000169406 | 11 | PA304076 | PM703694 |
| 15060000169424 | L15/dossiers | 15 | 15060000169423 | 15060000169423 | 1 | PA736216 | PM736273 |
| 15060000169434 | L15/dossiers | 15 | 15060000169433 | 15060000169433 | 1 | PA2116 | PM736339 |
| 15060000169441 | L15/dossiers | 15 | 15060000169440 | 15060000169440 | 1 | PA773441 | PM773491 |