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 |
|---|---|---|---|---|---|---|---|
| 15060000148393 | L15/dossiers | 15 | 15060000148392 | 15060000148392 | 1 | PA721932 | PM734586 |
| 15060000148400 | L15/dossiers | 15 | 15060000148399 | 15060000148399 | 1 | PA703500 | PM703574 |
| 15060000148410 | L15/dossiers | 15 | 15060000148409 | 15060000148409 | 1 | PA720576 | PM723004 |
| 15060000148463 | L15/dossiers | 15 | 15060000148462 | 15060000148462 | 1 | PA330684 | PM722528 |
| 15060000148470 | L15/dossiers | 15 | 15060000148469 | 15060000148469 | 1 | PA721466 | PM723284 |
| 15060000148478 | L15/dossiers | 15 | 15060000148477 | 15060000148477 | 1 | PA608416 | PM723540 |
| 15060000148482 | L15/dossiers | 15 | 15060000148481 | 15060000148481 | 1 | PA345619 | PM725692 |
| 15060000148483 | L15/dossiers | 15 | 15060000148481 | 15060000148481 | 2 | PA607846 | PM730066 |
| 15060000148484 | L15/dossiers | 15 | 15060000148481 | 15060000148481 | 3 | PA330357 | PM744089 |
| 15060000148579 | L15/dossiers | 15 | 15060000148578 | 15060000148578 | 1 | PA721270 | PM723220 |
| 15060000148586 | L15/dossiers | 15 | 15060000148585 | 15060000148585 | 1 | PA721270 | PM723220 |
| 15060000148597 | L15/dossiers | 15 | 15060000148596 | 15060000148596 | 1 | PA718780 | PM722454 |
| 15060000148604 | L15/dossiers | 15 | 15060000148603 | 15060000148603 | 1 | PA345619 | PM725692 |
| 15060000148605 | L15/dossiers | 15 | 15060000148603 | 15060000148603 | 2 | PA702191 | PM730058 |
| 15060000148612 | L15/dossiers | 15 | 15060000148611 | 15060000148611 | 1 | PA267440 | PM722522 |
| 15060000148619 | L15/dossiers | 15 | 15060000148618 | 15060000148618 | 1 | PA340853 | PM722534 |
| 15060000148626 | L15/dossiers | 15 | 15060000148625 | 15060000148625 | 1 | PA720846 | PM723094 |
| 15060000148633 | L15/dossiers | 15 | 15060000148632 | 15060000148632 | 1 | PA331567 | PM722644 |
| 15060000148640 | L15/dossiers | 15 | 15060000148639 | 15060000148639 | 1 | PA1327 | PM722762 |
| 15060000148647 | L15/dossiers | 15 | 15060000148646 | 15060000148646 | 1 | PA345619 | PM725692 |
| 15060000148681 | L15/dossiers | 15 | 15060000148680 | 15060000148680 | 1 | PA335054 | PM723254 |
| 15060000148692 | L15/dossiers | 15 | 15060000148691 | 15060000148691 | 1 | PA330788 | PM722570 |
| 15060000148699 | L15/dossiers | 15 | 15060000148698 | 15060000148698 | 1 | PA1874 | PM722598 |
| 15060000148706 | L15/dossiers | 15 | 15060000148705 | 15060000148705 | 1 | PA1206 | PM723354 |
| 15060000148713 | L15/dossiers | 15 | 15060000148712 | 15060000148712 | 1 | PA223837 | PM722458 |
| 15060000148720 | L15/dossiers | 15 | 15060000148719 | 15060000148719 | 1 | PA719318 | PM722624 |
| 15060000148727 | L15/dossiers | 15 | 15060000148726 | 15060000148726 | 1 | PA767 | PM723568 |
| 15060000148734 | L15/dossiers | 15 | 15060000148733 | 15060000148733 | 1 | PA642847 | PM722954 |
| 15060000148741 | L15/dossiers | 15 | 15060000148740 | 15060000148740 | 1 | PA712015 | PM722448 |
| 15060000148748 | L15/dossiers | 15 | 15060000148747 | 15060000148747 | 1 | PA346218 | PM723348 |
| 15060000148752 | L15/dossiers | 15 | 15060000148751 | 15060000148751 | 1 | PA2552 | PM736292 |
| 15060000148799 | L15/dossiers | 15 | 15060000148798 | 15060000148798 | 1 | PA721270 | PM723220 |
| 15060000148806 | L15/dossiers | 15 | 15060000148805 | 15060000148805 | 1 | PA642847 | PM722954 |
| 15060000148813 | L15/dossiers | 15 | 15060000148812 | 15060000148812 | 1 | PA330684 | PM722528 |
| 15060000148820 | L15/dossiers | 15 | 15060000148819 | 15060000148819 | 1 | PA643089 | PM758076 |
| 15060000148827 | L15/dossiers | 15 | 15060000148826 | 15060000148826 | 1 | PA2552 | PM736292 |
| 15060000148873 | L15/dossiers | 15 | 15060000148872 | 15060000148872 | 1 | PA718674 | PM722420 |
| 15060000148893 | L15/dossiers | 15 | 15060000148892 | 15060000148892 | 1 | PA703538 | PM703698 |
| 15060000148903 | L15/dossiers | 15 | 15060000148902 | 15060000148902 | 1 | PA722110 | PM723474 |
| 15060000148907 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 1 | PA719146 | PM722576 |
| 15060000148908 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 2 | PA609726 | PM723426 |
| 15060000148909 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 3 | PA588884 | PM723226 |
| 15060000148910 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 4 | PA642764 | PM753836 |
| 15060000148911 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 5 | PA610681 | PM723150 |
| 15060000148912 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 6 | PA721046 | PM723154 |
| 15060000148913 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 7 | PA342415 | PM722826 |
| 15060000148914 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 8 | PA642847 | PM722954 |
| 15060000148915 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 9 | PA718884 | PM722488 |
| 15060000148916 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 10 | PA720210 | PM722892 |
| 15060000148917 | L15/dossiers | 15 | 15060000148906 | 15060000148906 | 11 | PA441 | PM723152 |