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 |
|---|---|---|---|---|---|---|---|
| 15060000173472 | L15/dossiers | 15 | 15060000173471 | 15060000173471 | 1 | PA713448 | PM722452 |
| 15060000173479 | L15/dossiers | 15 | 15060000173478 | 15060000173478 | 1 | PA720286 | PM722918 |
| 15060000173486 | L15/dossiers | 15 | 15060000173485 | 15060000173485 | 1 | PA719946 | PM722808 |
| 15060000173490 | L15/dossiers | 15 | 15060000173489 | 15060000173489 | 1 | PA332614 | PM722812 |
| 15060000173500 | L15/dossiers | 15 | 15060000173499 | 15060000173499 | 1 | PA719946 | PM722808 |
| 15060000173507 | L15/dossiers | 15 | 15060000173506 | 15060000173506 | 1 | PA718784 | PM722456 |
| 15060000173514 | L15/dossiers | 15 | 15060000173513 | 15060000173513 | 1 | PA773441 | PM773491 |
| 15060000173594 | L15/dossiers | 15 | 15060000173593 | 15060000173593 | 1 | PA719946 | PM722808 |
| 15060000173601 | L15/dossiers | 15 | 15060000173600 | 15060000173600 | 1 | PA773441 | PM773491 |
| 15060000173602 | L15/dossiers | 15 | 15060000173600 | 15060000173600 | 2 | PA1872 | PM773455 |
| 15060000173603 | L15/dossiers | 15 | 15060000173600 | 15060000173600 | 3 | PA774109 | PM774111 |
| 15060000173641 | L15/dossiers | 15 | 15060000173640 | 15060000173640 | 1 | PA773441 | PM773491 |
| 15060000173642 | L15/dossiers | 15 | 15060000173640 | 15060000173640 | 2 | PA717161 | PM773483 |
| 15060000173649 | L15/dossiers | 15 | 15060000173648 | 15060000173648 | 1 | PA643134 | PM722824 |
| 15060000173656 | L15/dossiers | 15 | 15060000173655 | 15060000173655 | 1 | PA773441 | PM773491 |
| 15060000173657 | L15/dossiers | 15 | 15060000173655 | 15060000173655 | 2 | PA717159 | PM773461 |
| 15060000173658 | L15/dossiers | 15 | 15060000173655 | 15060000173655 | 3 | PA721670 | PM773499 |
| 15060000173665 | L15/dossiers | 15 | 15060000173664 | 15060000173664 | 1 | PA266788 | PM722914 |
| 15060000173672 | L15/dossiers | 15 | 15060000173671 | 15060000173671 | 1 | PA720862 | PM723098 |
| 15060000173679 | L15/dossiers | 15 | 15060000173678 | 15060000173678 | 1 | PA719608 | PM722710 |
| 15060000173697 | L15/dossiers | 15 | 15060000173696 | 15060000173696 | 1 | PA267450 | PM722586 |
| 15060000173704 | L15/dossiers | 15 | 15060000173703 | 15060000173703 | 1 | PA718884 | PM722488 |
| 15060000173714 | L15/dossiers | 15 | 15060000173713 | 15060000173713 | 1 | PA722110 | PM723474 |
| 15060000173721 | L15/dossiers | 15 | 15060000173720 | 15060000173720 | 1 | PA2952 | PM722480 |
| 15060000173728 | L15/dossiers | 15 | 15060000173727 | 15060000173727 | 1 | PA720386 | PM722948 |
| 15060000173735 | L15/dossiers | 15 | 15060000173734 | 15060000173734 | 1 | PA773441 | PM773491 |
| 15060000173742 | L15/dossiers | 15 | 15060000173741 | 15060000173741 | 1 | PA773441 | PM773491 |
| 15060000173772 | L15/dossiers | 15 | 15060000173771 | 15060000173771 | 1 | PA773441 | PM773491 |
| 15060000173779 | L15/dossiers | 15 | 15060000173778 | 15060000173778 | 1 | PA773441 | PM773491 |
| 15060000173789 | L15/dossiers | 15 | 15060000173788 | 15060000173788 | 1 | PA721932 | PM734586 |
| 15060000173793 | L15/dossiers | 15 | 15060000173792 | 15060000173792 | 1 | PA719448 | PM722666 |
| 15060000173800 | L15/dossiers | 15 | 15060000173799 | 15060000173799 | 1 | PA2377 | PM723550 |
| 15060000173804 | L15/dossiers | 15 | 15060000173803 | 15060000173803 | 1 | PA722202 | PM723502 |
| 15060000173808 | L15/dossiers | 15 | 15060000173807 | 15060000173807 | 1 | PA721262 | PM723218 |
| 15060000173815 | L15/dossiers | 15 | 15060000173814 | 15060000173814 | 1 | PA719930 | PM722804 |
| 15060000173822 | L15/dossiers | 15 | 15060000173821 | 15060000173821 | 1 | PA2116 | PM736339 |
| 15060000173829 | L15/dossiers | 15 | 15060000173828 | 15060000173828 | 1 | PA720892 | PM723106 |
| 15060000173841 | L15/dossiers | 15 | 15060000173840 | 15060000173840 | 1 | PA721816 | PM748964 |
| 15060000173848 | L15/dossiers | 15 | 15060000173847 | 15060000173847 | 1 | PA718784 | PM722456 |
| 15060000173855 | L15/dossiers | 15 | 15060000173854 | 15060000173854 | 1 | PA330684 | PM775859 |
| 15060000173862 | L15/dossiers | 15 | 15060000173861 | 15060000173861 | 1 | PA268007 | PM736325 |
| 15060000173869 | L15/dossiers | 15 | 15060000173868 | 15060000173868 | 1 | PA330240 | PM722492 |
| 15060000173879 | L15/dossiers | 15 | 15060000173878 | 15060000173878 | 1 | PA721474 | PM723286 |
| 15060000173883 | L15/dossiers | 15 | 15060000173882 | 15060000173882 | 1 | PA773441 | PM773491 |
| 15060000173884 | L15/dossiers | 15 | 15060000173882 | 15060000173882 | 2 | PA722236 | PM773501 |
| 15060000173891 | L15/dossiers | 15 | 15060000173890 | 15060000173890 | 1 | PA702992 | PM717139 |
| 15060000173892 | L15/dossiers | 15 | 15060000173890 | 15060000173890 | 2 | PA773443 | PM773510 |
| 15060000173893 | L15/dossiers | 15 | 15060000173890 | 15060000173890 | 3 | PA773441 | PM773491 |
| 15060000173957 | L15/dossiers | 15 | 15060000173956 | 15060000173956 | 1 | PA719448 | PM722666 |
| 15060000173964 | L15/dossiers | 15 | 15060000173963 | 15060000173963 | 1 | PA712015 | PM722448 |