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 |
|---|---|---|---|---|---|---|---|
| 15060000169448 | L15/dossiers | 15 | 15060000169447 | 15060000169447 | 1 | PA712015 | PM722448 |
| 15060000169455 | L15/dossiers | 15 | 15060000169454 | 15060000169454 | 1 | PA720386 | PM722948 |
| 15060000169462 | L15/dossiers | 15 | 15060000169461 | 15060000169461 | 1 | PA267330 | PM723392 |
| 15060000169495 | L15/dossiers | 15 | 15060000169494 | 15060000169494 | 1 | PA722142 | PM723484 |
| 15060000169502 | L15/dossiers | 15 | 15060000169501 | 15060000169501 | 1 | PA429840 | PM736360 |
| 15060000169509 | L15/dossiers | 15 | 15060000169508 | 15060000169508 | 1 | PA267440 | PM722522 |
| 15060000169516 | L15/dossiers | 15 | 15060000169515 | 15060000169515 | 1 | PA998 | PM723046 |
| 15060000169523 | L15/dossiers | 15 | 15060000169522 | 15060000169522 | 1 | PA223837 | PM722458 |
| 15060000169530 | L15/dossiers | 15 | 15060000169529 | 15060000169529 | 1 | PA695100 | PM723198 |
| 15060000169537 | L15/dossiers | 15 | 15060000169536 | 15060000169536 | 1 | PA718884 | PM722488 |
| 15060000169544 | L15/dossiers | 15 | 15060000169543 | 15060000169543 | 1 | PA718884 | PM722488 |
| 15060000169551 | L15/dossiers | 15 | 15060000169550 | 15060000169550 | 1 | PA2952 | PM722480 |
| 15060000169558 | L15/dossiers | 15 | 15060000169557 | 15060000169557 | 1 | PA642868 | PM722992 |
| 15060000169589 | L15/dossiers | 15 | 15060000169588 | 15060000169588 | 1 | PA2116 | PM736339 |
| 15060000169599 | L15/dossiers | 15 | 15060000169598 | 15060000169598 | 1 | PA720342 | PM722934 |
| 15060000169600 | L15/dossiers | 15 | 15060000169598 | 15060000169598 | 2 | PA1029 | PM722516 |
| 15060000169615 | L15/dossiers | 15 | 15060000169614 | 15060000169614 | 1 | PA773441 | PM773491 |
| 15060000169616 | L15/dossiers | 15 | 15060000169614 | 15060000169614 | 2 | PA331481 | PM773459 |
| 15060000169617 | L15/dossiers | 15 | 15060000169614 | 15060000169614 | 3 | PA642788 | PM773495 |
| 15060000169618 | L15/dossiers | 15 | 15060000169614 | 15060000169614 | 4 | PA330357 | PM773447 |
| 15060000169727 | L15/dossiers | 15 | 15060000169726 | 15060000169726 | 1 | PA736223 | PM736368 |
| 15060000169734 | L15/dossiers | 15 | 15060000169733 | 15060000169733 | 1 | PA773441 | PM773491 |
| 15060000169741 | L15/dossiers | 15 | 15060000169740 | 15060000169740 | 1 | PA719946 | PM722808 |
| 15060000169748 | L15/dossiers | 15 | 15060000169747 | 15060000169747 | 1 | PA721932 | PM734586 |
| 15060000169755 | L15/dossiers | 15 | 15060000169754 | 15060000169754 | 1 | PA719798 | PM722766 |
| 15060000169763 | L15/dossiers | 15 | 15060000169762 | 15060000169762 | 1 | PA720454 | PM722968 |
| 15060000169817 | L15/dossiers | 15 | 15060000169816 | 15060000169816 | 1 | PA2150 | PM722506 |
| 15060000169824 | L15/dossiers | 15 | 15060000169823 | 15060000169823 | 1 | PA720210 | PM722892 |
| 15060000169828 | L15/dossiers | 15 | 15060000169827 | 15060000169827 | 1 | PA266788 | PM722914 |
| 15060000169835 | L15/dossiers | 15 | 15060000169834 | 15060000169834 | 1 | PA721888 | PM723412 |
| 15060000169842 | L15/dossiers | 15 | 15060000169841 | 15060000169841 | 1 | PA721036 | PM753260 |
| 15060000169874 | L15/dossiers | 15 | 15060000169873 | 15060000169873 | 1 | PA330240 | PM722492 |
| 15060000169881 | L15/dossiers | 15 | 15060000169880 | 15060000169880 | 1 | PA720634 | PM736312 |
| 15060000169888 | L15/dossiers | 15 | 15060000169887 | 15060000169887 | 1 | PA720634 | PM736312 |
| 15060000169895 | L15/dossiers | 15 | 15060000169894 | 15060000169894 | 1 | PA267328 | PM775729 |
| 15060000169902 | L15/dossiers | 15 | 15060000169901 | 15060000169901 | 1 | PA608826 | PM723276 |
| 15060000169909 | L15/dossiers | 15 | 15060000169908 | 15060000169908 | 1 | PA2042 | PM775815 |
| 15060000169927 | L15/dossiers | 15 | 15060000169926 | 15060000169926 | 1 | PA720634 | PM736312 |
| 15060000169934 | L15/dossiers | 15 | 15060000169933 | 15060000169933 | 1 | PA404656 | PM736328 |
| 15060000169941 | L15/dossiers | 15 | 15060000169940 | 15060000169940 | 1 | PA703500 | PM775643 |
| 15060000169948 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 1 | PA266795 | PM775711 |
| 15060000169949 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 2 | PA429832 | PM736408 |
| 15060000169950 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 3 | PA569 | PM775717 |
| 15060000169951 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 4 | PA703514 | PM775661 |
| 15060000169952 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 5 | PA709298 | PM775773 |
| 15060000169953 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 6 | PA1122 | PM736304 |
| 15060000169954 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 7 | PA703498 | PM736260 |
| 15060000169955 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 8 | PA227029 | PM736306 |
| 15060000169956 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 9 | PA382672 | PM736263 |
| 15060000169957 | L15/dossiers | 15 | 15060000169947 | 15060000169947 | 10 | PA736206 | PM736351 |