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 |
|---|---|---|---|---|---|---|---|
| 17060000139507 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 35 | PA842155 | PM843674 |
| 17060000139508 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 36 | PA795200 | PM843386 |
| 17060000139509 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 37 | PA841351 | PM842936 |
| 17060000139510 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 38 | PA795844 | PM843515 |
| 17060000139511 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 39 | PA721896 | PM840405 |
| 17060000139512 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 40 | PA841251 | PM842837 |
| 17060000139513 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 41 | PA794786 | PM843242 |
| 17060000139514 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 42 | PA794870 | PM843185 |
| 17060000139515 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 43 | PA793980 | PM842750 |
| 17060000139516 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 44 | PA796070 | PM843746 |
| 17060000139517 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 45 | PA795010 | PM840354 |
| 17060000139518 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 46 | PA795310 | PM840453 |
| 17060000139519 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 47 | PA794478 | PM843107 |
| 17060000139520 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 48 | PA841947 | PM843503 |
| 17060000139521 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 49 | PA794082 | PM842810 |
| 17060000139522 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 50 | PA795998 | PM843737 |
| 17060000139523 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 51 | PA794130 | PM840297 |
| 17060000139524 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 52 | PA720846 | PM840441 |
| 17060000139525 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 53 | PA841729 | PM843287 |
| 17060000139526 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 54 | PA795516 | PM843452 |
| 17060000139527 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 55 | PA774962 | PM843731 |
| 17060000139528 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 56 | PA795672 | PM843752 |
| 17060000139529 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 57 | PA795746 | PM843584 |
| 17060000139530 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 58 | PA795108 | PM843338 |
| 17060000139531 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 59 | PA841515 | PM843089 |
| 17060000139532 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 60 | PA335612 | PM843398 |
| 17060000139533 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 61 | PA795298 | PM843683 |
| 17060000139534 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 62 | PA791824 | PM840375 |
| 17060000139535 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 63 | PA842029 | PM843575 |
| 17060000139536 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 64 | PA793532 | PM842591 |
| 17060000139537 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 65 | PA795636 | PM843476 |
| 17060000139538 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 66 | PA796010 | PM843743 |
| 17060000139539 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 67 | PA342384 | PM842771 |
| 17060000139540 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 68 | PA795422 | PM843599 |
| 17060000139541 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 69 | PA794686 | PM843080 |
| 17060000139542 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 70 | PA841215 | PM842801 |
| 17060000139543 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 71 | PA795482 | PM843605 |
| 17060000139544 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 72 | PA610654 | PM843719 |
| 17060000139545 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 73 | PA841191 | PM842789 |
| 17060000139546 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 74 | PA721960 | PM840378 |
| 17060000139547 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 75 | PA842045 | PM843581 |
| 17060000139548 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 76 | PA793872 | PM840285 |
| 17060000139549 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 77 | PA817211 | PM842600 |
| 17060000139550 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 78 | PA793756 | PM840282 |
| 17060000139551 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 79 | PA793664 | PM842549 |
| 17060000139552 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 80 | PA796062 | PM843668 |
| 17060000139553 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 81 | PA719578 | PM842618 |
| 17060000139554 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 82 | PA721062 | PM843740 |
| 17060000139555 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 83 | PA794154 | PM842918 |
| 17060000139556 | L17/dossiers | 17 | 17060000139472 | 17060000139472 | 84 | PA795240 | PM843785 |