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 |
|---|---|---|---|---|---|---|---|
| 15060000153407 | L15/dossiers | 15 | 15060000153406 | 15060000153406 | 1 | PA720210 | PM722892 |
| 15060000153414 | L15/dossiers | 15 | 15060000153413 | 15060000153413 | 1 | PA267233 | PM723500 |
| 15060000153421 | L15/dossiers | 15 | 15060000153420 | 15060000153420 | 1 | PA267233 | PM723500 |
| 15060000153425 | L15/dossiers | 15 | 15060000153424 | 15060000153424 | 1 | PA1874 | PM722598 |
| 15060000153432 | L15/dossiers | 15 | 15060000153431 | 15060000153431 | 1 | PA267260 | PM722476 |
| 15060000153439 | L15/dossiers | 15 | 15060000153438 | 15060000153438 | 1 | PA340853 | PM722534 |
| 15060000153446 | L15/dossiers | 15 | 15060000153445 | 15060000153445 | 1 | PA345619 | PM725692 |
| 15060000153447 | L15/dossiers | 15 | 15060000153445 | 15060000153445 | 2 | PA331481 | PM730094 |
| 15060000153454 | L15/dossiers | 15 | 15060000153453 | 15060000153453 | 1 | PA609726 | PM723426 |
| 15060000153461 | L15/dossiers | 15 | 15060000153460 | 15060000153460 | 1 | PA718884 | PM722488 |
| 15060000153474 | L15/dossiers | 15 | 15060000153473 | 15060000153473 | 1 | PA345619 | PM725692 |
| 15060000153488 | L15/dossiers | 15 | 15060000153487 | 15060000153487 | 1 | PA721816 | PM748964 |
| 15060000153495 | L15/dossiers | 15 | 15060000153494 | 15060000153494 | 1 | PA330240 | PM722492 |
| 15060000153502 | L15/dossiers | 15 | 15060000153501 | 15060000153501 | 1 | PA721984 | PM723440 |
| 15060000153509 | L15/dossiers | 15 | 15060000153508 | 15060000153508 | 1 | PA2197 | PM703640 |
| 15060000153553 | L15/dossiers | 15 | 15060000153552 | 15060000153552 | 1 | PA345619 | PM725692 |
| 15060000153560 | L15/dossiers | 15 | 15060000153559 | 15060000153559 | 1 | PA2197 | PM703640 |
| 15060000153561 | L15/dossiers | 15 | 15060000153559 | 15060000153559 | 2 | PA703515 | PM703592 |
| 15060000153568 | L15/dossiers | 15 | 15060000153567 | 15060000153567 | 1 | PA744079 | PM744082 |
| 15060000153575 | L15/dossiers | 15 | 15060000153574 | 15060000153574 | 1 | PA744079 | PM744082 |
| 15060000153582 | L15/dossiers | 15 | 15060000153581 | 15060000153581 | 1 | PA330240 | PM722492 |
| 15060000153594 | L15/dossiers | 15 | 15060000153593 | 15060000153593 | 1 | PA720684 | PM723040 |
| 15060000153601 | L15/dossiers | 15 | 15060000153600 | 15060000153600 | 1 | PA736196 | PM736370 |
| 15060000153608 | L15/dossiers | 15 | 15060000153607 | 15060000153607 | 1 | PA1874 | PM722598 |
| 15060000153615 | L15/dossiers | 15 | 15060000153614 | 15060000153614 | 1 | PA223837 | PM722458 |
| 15060000153622 | L15/dossiers | 15 | 15060000153621 | 15060000153621 | 1 | PA721968 | PM723436 |
| 15060000153632 | L15/dossiers | 15 | 15060000153631 | 15060000153631 | 1 | PA2116 | PM736339 |
| 15060000153633 | L15/dossiers | 15 | 15060000153631 | 15060000153631 | 2 | PA736236 | PM736341 |
| 15060000153640 | L15/dossiers | 15 | 15060000153639 | 15060000153639 | 1 | PA382672 | PM736263 |
| 15060000153647 | L15/dossiers | 15 | 15060000153646 | 15060000153646 | 1 | PA415476 | PM703653 |
| 15060000153654 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 1 | PA429836 | PM736345 |
| 15060000153655 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 2 | PA757676 | PM757692 |
| 15060000153656 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 3 | PA736173 | PM736369 |
| 15060000153657 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 4 | PA304082 | PM736354 |
| 15060000153658 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 5 | PA429891 | PM736329 |
| 15060000153659 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 6 | PA429894 | PM736364 |
| 15060000153660 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 7 | PA756685 | PM756689 |
| 15060000153661 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 8 | PA304071 | PM703676 |
| 15060000153662 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 9 | PA429886 | PM736385 |
| 15060000153663 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 10 | PA736195 | PM736357 |
| 15060000153664 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 11 | PA736177 | PM736318 |
| 15060000153665 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 12 | PA1978 | PM736337 |
| 15060000153666 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 13 | PA678263 | PM736330 |
| 15060000153667 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 14 | PA736243 | PM736413 |
| 15060000153668 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 15 | PA703499 | PM703641 |
| 15060000153669 | L15/dossiers | 15 | 15060000153653 | 15060000153653 | 16 | PA736175 | PM736344 |
| 15060000153676 | L15/dossiers | 15 | 15060000153675 | 15060000153675 | 1 | PA703541 | PM703644 |
| 15060000153677 | L15/dossiers | 15 | 15060000153675 | 15060000153675 | 2 | PA703525 | PM703688 |
| 15060000153684 | L15/dossiers | 15 | 15060000153683 | 15060000153683 | 1 | PA703541 | PM703644 |
| 15060000153685 | L15/dossiers | 15 | 15060000153683 | 15060000153683 | 2 | PA703525 | PM703688 |