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 |
|---|---|---|---|---|---|---|---|
| 14060000095795 | L14/dossiers | 14 | 14060000095794 | 14060000095794 | 1 | PA2048 | PM693013 |
| 14060000095802 | L14/dossiers | 14 | 14060000095801 | 14060000095801 | 1 | PA713448 | PM713451 |
| 14060000095816 | L14/dossiers | 14 | 14060000095815 | 14060000095815 | 1 | PA1886 | PM645099 |
| 14060000095821 | L14/dossiers | 14 | 14060000095820 | 14060000095820 | 1 | PA1886 | PM645099 |
| 14060000095851 | L14/dossiers | 14 | 14060000095850 | 14060000095850 | 1 | PA267327 | PM645031 |
| 14060000095862 | L14/dossiers | 14 | 14060000095861 | 14060000095861 | 1 | PA346886 | PM695110 |
| 14060000095869 | L14/dossiers | 14 | 14060000095868 | 14060000095868 | 1 | PA608120 | PM645159 |
| 14060000095876 | L14/dossiers | 14 | 14060000095875 | 14060000095875 | 1 | PA345937 | PM645177 |
| 14060000095883 | L14/dossiers | 14 | 14060000095882 | 14060000095882 | 1 | PA607846 | PM645441 |
| 14060000095890 | L14/dossiers | 14 | 14060000095889 | 14060000095889 | 1 | PA339 | PM645511 |
| 14060000095945 | L14/dossiers | 14 | 14060000095944 | 14060000095944 | 1 | PA1886 | PM645099 |
| 14060000095952 | L14/dossiers | 14 | 14060000095951 | 14060000095951 | 1 | PA2124 | PM645475 |
| 14060000095959 | L14/dossiers | 14 | 14060000095958 | 14060000095958 | 1 | PA267492 | PM645465 |
| 14060000095966 | L14/dossiers | 14 | 14060000095965 | 14060000095965 | 1 | PA2277 | PM645135 |
| 14060000095973 | L14/dossiers | 14 | 14060000095972 | 14060000095972 | 1 | PA2952 | PM645464 |
| 14060000095980 | L14/dossiers | 14 | 14060000095979 | 14060000095979 | 1 | PA346 | PM645086 |
| 14060000095987 | L14/dossiers | 14 | 14060000095986 | 14060000095986 | 1 | PA2277 | PM645135 |
| 14060000095994 | L14/dossiers | 14 | 14060000095993 | 14060000095993 | 1 | PA346886 | PM695110 |
| 14060000096001 | L14/dossiers | 14 | 14060000096000 | 14060000096000 | 1 | PA267622 | PM702957 |
| 14060000096002 | L14/dossiers | 14 | 14060000096000 | 14060000096000 | 2 | PA2679 | PM714646 |
| 14060000096003 | L14/dossiers | 14 | 14060000096000 | 14060000096000 | 3 | PA1243 | PM714743 |
| 14060000096754 | L14/dossiers | 14 | 14060000096753 | 14060000096753 | 1 | PA335054 | PM645614 |
| 14060000096764 | L14/dossiers | 14 | 14060000096763 | 14060000096763 | 1 | PA266774 | PM645583 |
| 14060000096774 | L14/dossiers | 14 | 14060000096773 | 14060000096773 | 1 | PA267622 | PM702957 |
| 14060000096806 | L14/dossiers | 14 | 14060000096805 | 14060000096805 | 1 | PA1874 | PM645474 |
| 14060000096816 | L14/dossiers | 14 | 14060000096815 | 14060000096815 | 1 | PA332228 | PM645546 |
| 14060000096834 | L14/dossiers | 14 | 14060000096833 | 14060000096833 | 1 | PA230 | PM645553 |
| 14060000096841 | L14/dossiers | 14 | 14060000096840 | 14060000096840 | 1 | PA422119 | PM645183 |
| 14060000096848 | L14/dossiers | 14 | 14060000096847 | 14060000096847 | 1 | PA605349 | PM645483 |
| 14060000096855 | L14/dossiers | 14 | 14060000096854 | 14060000096854 | 1 | PA551 | PM645487 |
| 14060000096871 | L14/dossiers | 14 | 14060000096870 | 14060000096870 | 1 | PA2277 | PM645135 |
| 14060000096878 | L14/dossiers | 14 | 14060000096877 | 14060000096877 | 1 | PA344492 | PM645300 |
| 14060000096885 | L14/dossiers | 14 | 14060000096884 | 14060000096884 | 1 | PA605782 | PM645291 |
| 14060000096892 | L14/dossiers | 14 | 14060000096891 | 14060000096891 | 1 | PA785 | PM715797 |
| 14060000096899 | L14/dossiers | 14 | 14060000096898 | 14060000096898 | 1 | PA328 | PM653228 |
| 14060000096900 | L14/dossiers | 14 | 14060000096898 | 14060000096898 | 2 | PA1268 | PM653525 |
| 14060000096929 | L14/dossiers | 14 | 14060000096928 | 14060000096928 | 1 | PA309643 | PM645326 |
| 14060000096936 | L14/dossiers | 14 | 14060000096935 | 14060000096935 | 1 | PA606212 | PM645330 |
| 14060000096949 | L14/dossiers | 14 | 14060000096948 | 14060000096948 | 1 | PA266788 | PM645294 |
| 14060000096956 | L14/dossiers | 14 | 14060000096955 | 14060000096955 | 1 | PA2236 | PM645149 |
| 14060000096963 | L14/dossiers | 14 | 14060000096962 | 14060000096962 | 1 | PA346886 | PM695110 |
| 14060000096970 | L14/dossiers | 14 | 14060000096969 | 14060000096969 | 1 | PA330684 | PM645497 |
| 14060000096977 | L14/dossiers | 14 | 14060000096976 | 14060000096976 | 1 | PA267622 | PM702957 |
| 14060000096978 | L14/dossiers | 14 | 14060000096976 | 14060000096976 | 2 | PA328 | PM711554 |
| 14060000097011 | L14/dossiers | 14 | 14060000097010 | 14060000097010 | 1 | PA267622 | PM702957 |
| 14060000097041 | L14/dossiers | 14 | 14060000097040 | 14060000097040 | 1 | PA328 | PM653228 |
| 14060000097042 | L14/dossiers | 14 | 14060000097040 | 14060000097040 | 2 | PA335999 | PM653292 |
| 14060000097049 | L14/dossiers | 14 | 14060000097048 | 14060000097048 | 1 | PA608826 | PM645556 |
| 14060000097066 | L14/dossiers | 14 | 14060000097065 | 14060000097065 | 1 | PA267227 | PM645618 |
| 14060000097073 | L14/dossiers | 14 | 14060000097072 | 14060000097072 | 1 | PA2257 | PM645201 |