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 |
|---|---|---|---|---|---|---|---|
| 15060000154558 | L15/dossiers | 15 | 15060000154553 | 15060000154553 | 5 | PA268019 | PM723092 |
| 15060000154559 | L15/dossiers | 15 | 15060000154553 | 15060000154553 | 6 | PA331582 | PM722646 |
| 15060000154560 | L15/dossiers | 15 | 15060000154553 | 15060000154553 | 7 | PA2150 | PM722506 |
| 15060000154561 | L15/dossiers | 15 | 15060000154553 | 15060000154553 | 8 | PA267306 | PM723054 |
| 15060000154569 | L15/dossiers | 15 | 15060000154568 | 15060000154568 | 1 | PA2116 | PM736339 |
| 15060000154576 | L15/dossiers | 15 | 15060000154575 | 15060000154575 | 1 | PA703518 | PM703704 |
| 15060000154577 | L15/dossiers | 15 | 15060000154575 | 15060000154575 | 2 | PA2538 | PM703570 |
| 15060000154578 | L15/dossiers | 15 | 15060000154575 | 15060000154575 | 3 | PA2197 | PM703640 |
| 15060000154612 | L15/dossiers | 15 | 15060000154611 | 15060000154611 | 1 | PA267429 | PM722818 |
| 15060000154619 | L15/dossiers | 15 | 15060000154618 | 15060000154618 | 1 | PA304082 | PM736354 |
| 15060000154631 | L15/dossiers | 15 | 15060000154630 | 15060000154630 | 1 | PA513 | PM703605 |
| 15060000154650 | L15/dossiers | 15 | 15060000154649 | 15060000154649 | 1 | PA267762 | PM736366 |
| 15060000154665 | L15/dossiers | 15 | 15060000154664 | 15060000154664 | 1 | PA718784 | PM722456 |
| 15060000154672 | L15/dossiers | 15 | 15060000154671 | 15060000154671 | 1 | PA608292 | PM723076 |
| 15060000154700 | L15/dossiers | 15 | 15060000154699 | 15060000154699 | 1 | PA342935 | PM722856 |
| 15060000154707 | L15/dossiers | 15 | 15060000154706 | 15060000154706 | 1 | PA342935 | PM722856 |
| 15060000154714 | L15/dossiers | 15 | 15060000154713 | 15060000154713 | 1 | PA1327 | PM722762 |
| 15060000154721 | L15/dossiers | 15 | 15060000154720 | 15060000154720 | 1 | PA720822 | PM723086 |
| 15060000154728 | L15/dossiers | 15 | 15060000154727 | 15060000154727 | 1 | PA722030 | PM723454 |
| 15060000154735 | L15/dossiers | 15 | 15060000154734 | 15060000154734 | 1 | PA2952 | PM722480 |
| 15060000154742 | L15/dossiers | 15 | 15060000154741 | 15060000154741 | 1 | PA721054 | PM723156 |
| 15060000154749 | L15/dossiers | 15 | 15060000154748 | 15060000154748 | 1 | PA2952 | PM722480 |
| 15060000154756 | L15/dossiers | 15 | 15060000154755 | 15060000154755 | 1 | PA266797 | PM722884 |
| 15060000154763 | L15/dossiers | 15 | 15060000154762 | 15060000154762 | 1 | PA605518 | PM722518 |
| 15060000154770 | L15/dossiers | 15 | 15060000154769 | 15060000154769 | 1 | PA267429 | PM722818 |
| 15060000154777 | L15/dossiers | 15 | 15060000154776 | 15060000154776 | 1 | PA340853 | PM722534 |
| 15060000154784 | L15/dossiers | 15 | 15060000154783 | 15060000154783 | 1 | PA998 | PM723046 |
| 15060000154791 | L15/dossiers | 15 | 15060000154790 | 15060000154790 | 1 | PA2796 | PM722510 |
| 15060000154798 | L15/dossiers | 15 | 15060000154797 | 15060000154797 | 1 | PA345619 | PM725692 |
| 15060000154799 | L15/dossiers | 15 | 15060000154797 | 15060000154797 | 2 | PA702191 | PM730058 |
| 15060000154860 | L15/dossiers | 15 | 15060000154859 | 15060000154859 | 1 | PA345619 | PM725692 |
| 15060000154861 | L15/dossiers | 15 | 15060000154859 | 15060000154859 | 2 | PA607846 | PM730066 |
| 15060000154892 | L15/dossiers | 15 | 15060000154891 | 15060000154891 | 1 | PA722142 | PM723484 |
| 15060000154899 | L15/dossiers | 15 | 15060000154898 | 15060000154898 | 1 | PA722142 | PM723484 |
| 15060000154906 | L15/dossiers | 15 | 15060000154905 | 15060000154905 | 1 | PA267233 | PM723500 |
| 15060000154913 | L15/dossiers | 15 | 15060000154912 | 15060000154912 | 1 | PA718838 | PM722474 |
| 15060000154929 | L15/dossiers | 15 | 15060000154928 | 15060000154928 | 1 | PA267450 | PM722586 |
| 15060000154936 | L15/dossiers | 15 | 15060000154935 | 15060000154935 | 1 | PA722194 | PM760311 |
| 15060000154945 | L15/dossiers | 15 | 15060000154944 | 15060000154944 | 1 | PA721960 | PM723434 |
| 15060000154955 | L15/dossiers | 15 | 15060000154954 | 15060000154954 | 1 | PA608416 | PM723540 |
| 15060000154959 | L15/dossiers | 15 | 15060000154958 | 15060000154958 | 1 | PA703541 | PM703644 |
| 15060000154966 | L15/dossiers | 15 | 15060000154965 | 15060000154965 | 1 | PA703541 | PM703644 |
| 15060000154973 | L15/dossiers | 15 | 15060000154972 | 15060000154972 | 1 | PA703541 | PM703644 |
| 15060000154980 | L15/dossiers | 15 | 15060000154979 | 15060000154979 | 1 | PA2960 | PM723006 |
| 15060000154988 | L15/dossiers | 15 | 15060000154987 | 15060000154987 | 1 | PA345619 | PM725692 |
| 15060000154989 | L15/dossiers | 15 | 15060000154987 | 15060000154987 | 2 | PA331481 | PM730094 |
| 15060000154990 | L15/dossiers | 15 | 15060000154987 | 15060000154987 | 3 | PA607846 | PM730066 |
| 15060000155041 | L15/dossiers | 15 | 15060000155040 | 15060000155040 | 1 | PA425322 | PM736282 |
| 15060000155042 | L15/dossiers | 15 | 15060000155040 | 15060000155040 | 2 | PA415483 | PM703615 |
| 15060000155043 | L15/dossiers | 15 | 15060000155040 | 15060000155040 | 3 | PA736168 | PM736301 |