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 |
|---|---|---|---|---|---|---|---|
| 15060000152639 | L15/dossiers | 15 | 15060000152638 | 15060000152638 | 1 | PA332523 | PM722792 |
| 15060000152646 | L15/dossiers | 15 | 15060000152645 | 15060000152645 | 1 | PA713448 | PM722452 |
| 15060000152653 | L15/dossiers | 15 | 15060000152652 | 15060000152652 | 1 | PA330684 | PM722528 |
| 15060000152660 | L15/dossiers | 15 | 15060000152659 | 15060000152659 | 1 | PA267785 | PM723310 |
| 15060000152667 | L15/dossiers | 15 | 15060000152666 | 15060000152666 | 1 | PA330684 | PM722528 |
| 15060000152684 | L15/dossiers | 15 | 15060000152683 | 15060000152683 | 1 | PA721262 | PM723218 |
| 15060000152691 | L15/dossiers | 15 | 15060000152690 | 15060000152690 | 1 | PA720822 | PM723086 |
| 15060000152698 | L15/dossiers | 15 | 15060000152697 | 15060000152697 | 1 | PA722374 | PM723556 |
| 15060000152744 | L15/dossiers | 15 | 15060000152743 | 15060000152743 | 1 | PA721474 | PM723286 |
| 15060000152751 | L15/dossiers | 15 | 15060000152750 | 15060000152750 | 1 | PA721474 | PM723286 |
| 15060000152758 | L15/dossiers | 15 | 15060000152757 | 15060000152757 | 1 | PA643134 | PM722824 |
| 15060000152765 | L15/dossiers | 15 | 15060000152764 | 15060000152764 | 1 | PA720100 | PM722860 |
| 15060000152824 | L15/dossiers | 15 | 15060000152823 | 15060000152823 | 1 | PA721816 | PM748964 |
| 15060000152831 | L15/dossiers | 15 | 15060000152830 | 15060000152830 | 1 | PA695100 | PM723198 |
| 15060000152838 | L15/dossiers | 15 | 15060000152837 | 15060000152837 | 1 | PA721984 | PM723440 |
| 15060000152845 | L15/dossiers | 15 | 15060000152844 | 15060000152844 | 1 | PA345619 | PM725692 |
| 15060000152846 | L15/dossiers | 15 | 15060000152844 | 15060000152844 | 2 | PA331481 | PM730094 |
| 15060000152847 | L15/dossiers | 15 | 15060000152844 | 15060000152844 | 3 | PA717161 | PM766508 |
| 15060000152854 | L15/dossiers | 15 | 15060000152853 | 15060000152853 | 1 | PA334149 | PM723034 |
| 15060000152861 | L15/dossiers | 15 | 15060000152860 | 15060000152860 | 1 | PA345619 | PM725692 |
| 15060000152862 | L15/dossiers | 15 | 15060000152860 | 15060000152860 | 2 | PA331481 | PM730094 |
| 15060000152869 | L15/dossiers | 15 | 15060000152868 | 15060000152868 | 1 | PA702992 | PM717139 |
| 15060000152870 | L15/dossiers | 15 | 15060000152868 | 15060000152868 | 2 | PA702191 | PM730058 |
| 15060000152878 | L15/dossiers | 15 | 15060000152877 | 15060000152877 | 1 | PA345619 | PM725692 |
| 15060000152879 | L15/dossiers | 15 | 15060000152877 | 15060000152877 | 2 | PA605131 | PM759784 |
| 15060000152888 | L15/dossiers | 15 | 15060000152887 | 15060000152887 | 1 | PA345619 | PM725692 |
| 15060000152889 | L15/dossiers | 15 | 15060000152887 | 15060000152887 | 2 | PA605131 | PM759784 |
| 15060000152898 | L15/dossiers | 15 | 15060000152897 | 15060000152897 | 1 | PA345619 | PM725692 |
| 15060000152927 | L15/dossiers | 15 | 15060000152926 | 15060000152926 | 1 | PA721932 | PM734586 |
| 15060000152934 | L15/dossiers | 15 | 15060000152933 | 15060000152933 | 1 | PA713448 | PM722452 |
| 15060000152941 | L15/dossiers | 15 | 15060000152940 | 15060000152940 | 1 | PA713448 | PM722452 |
| 15060000152948 | L15/dossiers | 15 | 15060000152947 | 15060000152947 | 1 | PA334149 | PM723034 |
| 15060000152955 | L15/dossiers | 15 | 15060000152954 | 15060000152954 | 1 | PA1874 | PM722598 |
| 15060000152962 | L15/dossiers | 15 | 15060000152961 | 15060000152961 | 1 | PA345619 | PM725692 |
| 15060000152969 | L15/dossiers | 15 | 15060000152968 | 15060000152968 | 1 | PA721968 | PM723436 |
| 15060000152976 | L15/dossiers | 15 | 15060000152975 | 15060000152975 | 1 | PA2377 | PM723550 |
| 15060000152983 | L15/dossiers | 15 | 15060000152982 | 15060000152982 | 1 | PA345619 | PM725692 |
| 15060000153012 | L15/dossiers | 15 | 15060000153011 | 15060000153011 | 1 | PA267901 | PM723166 |
| 15060000153019 | L15/dossiers | 15 | 15060000153018 | 15060000153018 | 1 | PA2377 | PM723550 |
| 15060000153026 | L15/dossiers | 15 | 15060000153025 | 15060000153025 | 1 | PA720798 | PM723080 |
| 15060000153036 | L15/dossiers | 15 | 15060000153035 | 15060000153035 | 1 | PA345619 | PM725692 |
| 15060000153037 | L15/dossiers | 15 | 15060000153035 | 15060000153035 | 2 | PA205600 | PM730080 |
| 15060000153038 | L15/dossiers | 15 | 15060000153035 | 15060000153035 | 3 | PA702191 | PM730058 |
| 15060000153039 | L15/dossiers | 15 | 15060000153035 | 15060000153035 | 4 | PA605131 | PM759784 |
| 15060000153049 | L15/dossiers | 15 | 15060000153048 | 15060000153048 | 1 | PA345619 | PM725692 |
| 15060000153056 | L15/dossiers | 15 | 15060000153055 | 15060000153055 | 1 | PA609590 | PM723326 |
| 15060000153066 | L15/dossiers | 15 | 15060000153065 | 15060000153065 | 1 | PA642868 | PM722992 |
| 15060000153075 | L15/dossiers | 15 | 15060000153074 | 15060000153074 | 1 | PA719946 | PM722808 |
| 15060000153082 | L15/dossiers | 15 | 15060000153081 | 15060000153081 | 1 | PA718850 | PM722478 |
| 15060000153089 | L15/dossiers | 15 | 15060000153088 | 15060000153088 | 1 | PA720798 | PM723080 |