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 |
|---|---|---|---|---|---|---|---|
| 15060000143540 | L15/dossiers | 15 | 15060000143539 | 15060000143539 | 1 | PA267260 | PM722476 |
| 15060000143547 | L15/dossiers | 15 | 15060000143546 | 15060000143546 | 1 | PA718926 | PM722502 |
| 15060000143555 | L15/dossiers | 15 | 15060000143554 | 15060000143554 | 1 | PA330684 | PM722528 |
| 15060000143562 | L15/dossiers | 15 | 15060000143561 | 15060000143561 | 1 | PA720704 | PM723050 |
| 15060000143569 | L15/dossiers | 15 | 15060000143568 | 15060000143568 | 1 | PA720924 | PM723114 |
| 15060000143604 | L15/dossiers | 15 | 15060000143603 | 15060000143603 | 1 | PA605036 | PM722444 |
| 15060000143621 | L15/dossiers | 15 | 15060000143620 | 15060000143620 | 1 | PA345619 | PM725692 |
| 15060000143628 | L15/dossiers | 15 | 15060000143627 | 15060000143627 | 1 | PA415446 | PM703678 |
| 15060000143629 | L15/dossiers | 15 | 15060000143627 | 15060000143627 | 2 | PA429895 | PM736262 |
| 15060000143697 | L15/dossiers | 15 | 15060000143696 | 15060000143696 | 1 | PA267204 | PM722794 |
| 15060000143704 | L15/dossiers | 15 | 15060000143703 | 15060000143703 | 1 | PA268019 | PM723092 |
| 15060000143711 | L15/dossiers | 15 | 15060000143710 | 15060000143710 | 1 | PA719286 | PM722616 |
| 15060000143718 | L15/dossiers | 15 | 15060000143717 | 15060000143717 | 1 | PA304017 | PM703669 |
| 15060000143737 | L15/dossiers | 15 | 15060000143736 | 15060000143736 | 1 | PA736228 | PM736380 |
| 15060000143756 | L15/dossiers | 15 | 15060000143755 | 15060000143755 | 1 | PA268019 | PM723092 |
| 15060000143764 | L15/dossiers | 15 | 15060000143763 | 15060000143763 | 1 | PA429837 | PM736407 |
| 15060000143776 | L15/dossiers | 15 | 15060000143775 | 15060000143775 | 1 | PA415459 | PM703660 |
| 15060000143795 | L15/dossiers | 15 | 15060000143794 | 15060000143794 | 1 | PA720684 | PM723040 |
| 15060000143802 | L15/dossiers | 15 | 15060000143801 | 15060000143801 | 1 | PA720798 | PM723080 |
| 15060000143809 | L15/dossiers | 15 | 15060000143808 | 15060000143808 | 1 | PA718850 | PM722478 |
| 15060000143816 | L15/dossiers | 15 | 15060000143815 | 15060000143815 | 1 | PA2086 | PM723450 |
| 15060000143823 | L15/dossiers | 15 | 15060000143822 | 15060000143822 | 1 | PA712015 | PM722448 |
| 15060000143830 | L15/dossiers | 15 | 15060000143829 | 15060000143829 | 1 | PA330240 | PM722492 |
| 15060000143837 | L15/dossiers | 15 | 15060000143836 | 15060000143836 | 1 | PA345619 | PM725692 |
| 15060000143838 | L15/dossiers | 15 | 15060000143836 | 15060000143836 | 2 | PA702191 | PM730058 |
| 15060000143845 | L15/dossiers | 15 | 15060000143844 | 15060000143844 | 1 | PA605036 | PM722444 |
| 15060000143855 | L15/dossiers | 15 | 15060000143854 | 15060000143854 | 1 | PA330240 | PM722492 |
| 15060000143862 | L15/dossiers | 15 | 15060000143861 | 15060000143861 | 1 | PA346218 | PM723348 |
| 15060000143869 | L15/dossiers | 15 | 15060000143868 | 15060000143868 | 1 | PA345619 | PM725692 |
| 15060000143906 | L15/dossiers | 15 | 15060000143905 | 15060000143905 | 1 | PA345619 | PM725692 |
| 15060000143907 | L15/dossiers | 15 | 15060000143905 | 15060000143905 | 2 | PA1872 | PM730104 |
| 15060000143940 | L15/dossiers | 15 | 15060000143939 | 15060000143939 | 1 | PA719364 | PM722638 |
| 15060000143947 | L15/dossiers | 15 | 15060000143946 | 15060000143946 | 1 | PA722142 | PM723484 |
| 15060000143954 | L15/dossiers | 15 | 15060000143953 | 15060000143953 | 1 | PA720468 | PM722972 |
| 15060000143961 | L15/dossiers | 15 | 15060000143960 | 15060000143960 | 1 | PA719318 | PM722624 |
| 15060000143968 | L15/dossiers | 15 | 15060000143967 | 15060000143967 | 1 | PA719668 | PM722726 |
| 15060000143975 | L15/dossiers | 15 | 15060000143974 | 15060000143974 | 1 | PA330008 | PM722416 |
| 15060000143988 | L15/dossiers | 15 | 15060000143987 | 15060000143987 | 1 | PA720210 | PM722892 |
| 15060000143995 | L15/dossiers | 15 | 15060000143994 | 15060000143994 | 1 | PA1327 | PM722762 |
| 15060000144002 | L15/dossiers | 15 | 15060000144001 | 15060000144001 | 1 | PA720468 | PM722972 |
| 15060000144009 | L15/dossiers | 15 | 15060000144008 | 15060000144008 | 1 | PA2086 | PM723450 |
| 15060000144019 | L15/dossiers | 15 | 15060000144018 | 15060000144018 | 1 | PA345619 | PM725692 |
| 15060000144026 | L15/dossiers | 15 | 15060000144025 | 15060000144025 | 1 | PA266797 | PM722884 |
| 15060000144030 | L15/dossiers | 15 | 15060000144029 | 15060000144029 | 1 | PA334149 | PM723034 |
| 15060000144037 | L15/dossiers | 15 | 15060000144036 | 15060000144036 | 1 | PA334149 | PM723034 |
| 15060000144044 | L15/dossiers | 15 | 15060000144043 | 15060000144043 | 1 | PA719980 | PM722822 |
| 15060000144100 | L15/dossiers | 15 | 15060000144099 | 15060000144099 | 1 | PA718926 | PM722502 |
| 15060000144107 | L15/dossiers | 15 | 15060000144106 | 15060000144106 | 1 | PA713448 | PM722452 |
| 15060000144115 | L15/dossiers | 15 | 15060000144114 | 15060000144114 | 1 | PA334149 | PM723034 |
| 15060000144119 | L15/dossiers | 15 | 15060000144118 | 15060000144118 | 1 | PA606212 | PM722662 |