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 |
|---|---|---|---|---|---|---|---|
| 15060000181791 | L15/dossiers | 15 | 15060000181790 | 15060000181790 | 1 | PA721506 | PM723296 |
| 15060000181798 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 1 | PA775282 | PM775584 |
| 15060000181799 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 2 | PA775180 | PM775466 |
| 15060000181800 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 3 | PA429845 | PM736278 |
| 15060000181801 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 4 | PA775214 | PM775498 |
| 15060000181802 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 5 | PA775224 | PM775512 |
| 15060000181803 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 6 | PA736177 | PM736318 |
| 15060000181804 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 7 | PA429866 | PM736287 |
| 15060000181805 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 8 | PA775252 | PM775558 |
| 15060000181806 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 9 | PA775262 | PM775548 |
| 15060000181807 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 10 | PA775272 | PM775562 |
| 15060000181808 | L15/dossiers | 15 | 15060000181797 | 15060000181797 | 11 | PA736201 | PM736347 |
| 15060000181818 | L15/dossiers | 15 | 15060000181817 | 15060000181817 | 1 | PA773441 | PM773491 |
| 15060000181872 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 1 | PA775282 | PM775584 |
| 15060000181873 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 2 | PA775180 | PM775466 |
| 15060000181874 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 3 | PA429845 | PM736278 |
| 15060000181875 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 4 | PA775214 | PM775498 |
| 15060000181876 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 5 | PA775224 | PM775512 |
| 15060000181877 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 6 | PA736177 | PM736318 |
| 15060000181878 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 7 | PA429866 | PM736287 |
| 15060000181879 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 8 | PA775252 | PM775558 |
| 15060000181880 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 9 | PA775262 | PM775548 |
| 15060000181881 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 10 | PA775272 | PM775562 |
| 15060000181882 | L15/dossiers | 15 | 15060000181871 | 15060000181871 | 11 | PA736201 | PM736347 |
| 15060000181889 | L15/dossiers | 15 | 15060000181888 | 15060000181888 | 1 | PA268019 | PM723092 |
| 15060000181896 | L15/dossiers | 15 | 15060000181895 | 15060000181895 | 1 | PA773441 | PM773491 |
| 15060000181903 | L15/dossiers | 15 | 15060000181902 | 15060000181902 | 1 | PA2116 | PM736339 |
| 15060000181910 | L15/dossiers | 15 | 15060000181909 | 15060000181909 | 1 | PA775202 | PM775502 |
| 15060000181917 | L15/dossiers | 15 | 15060000181916 | 15060000181916 | 1 | PA346054 | PM723510 |
| 15060000181924 | L15/dossiers | 15 | 15060000181923 | 15060000181923 | 1 | PA2116 | PM736339 |
| 15060000181931 | L15/dossiers | 15 | 15060000181930 | 15060000181930 | 1 | PA2116 | PM736339 |
| 15060000181938 | L15/dossiers | 15 | 15060000181937 | 15060000181937 | 1 | PA268019 | PM723092 |
| 15060000181944 | L15/dossiers | 15 | 15060000181943 | 15060000181943 | 1 | PA720802 | PM774333 |
| 15060000181951 | L15/dossiers | 15 | 15060000181950 | 15060000181950 | 1 | PA720586 | PM723008 |
| 15060000181955 | L15/dossiers | 15 | 15060000181954 | 15060000181954 | 1 | PA720586 | PM723008 |
| 15060000181962 | L15/dossiers | 15 | 15060000181961 | 15060000181961 | 1 | PA342601 | PM761932 |
| 15060000181969 | L15/dossiers | 15 | 15060000181968 | 15060000181968 | 1 | PA330240 | PM722492 |
| 15060000181976 | L15/dossiers | 15 | 15060000181975 | 15060000181975 | 1 | PA1838 | PM723068 |
| 15060000181986 | L15/dossiers | 15 | 15060000181985 | 15060000181985 | 1 | PA346054 | PM723510 |
| 15060000181993 | L15/dossiers | 15 | 15060000181992 | 15060000181992 | 1 | PA720468 | PM722972 |
| 15060000182000 | L15/dossiers | 15 | 15060000181999 | 15060000181999 | 1 | PA266788 | PM722914 |
| 15060000182007 | L15/dossiers | 15 | 15060000182006 | 15060000182006 | 1 | PA267766 | PM722970 |
| 15060000182014 | L15/dossiers | 15 | 15060000182013 | 15060000182013 | 1 | PA643089 | PM758076 |
| 15060000182021 | L15/dossiers | 15 | 15060000182020 | 15060000182020 | 1 | PA227029 | PM736306 |
| 15060000182028 | L15/dossiers | 15 | 15060000182027 | 15060000182027 | 1 | PA227029 | PM736306 |
| 15060000182035 | L15/dossiers | 15 | 15060000182034 | 15060000182034 | 1 | PA719946 | PM722808 |
| 15060000182042 | L15/dossiers | 15 | 15060000182041 | 15060000182041 | 1 | PA721110 | PM723174 |
| 15060000182063 | L15/dossiers | 15 | 15060000182062 | 15060000182062 | 1 | PA722094 | PM723470 |
| 15060000182073 | L15/dossiers | 15 | 15060000182072 | 15060000182072 | 1 | PA773441 | PM773491 |
| 15060000182074 | L15/dossiers | 15 | 15060000182072 | 15060000182072 | 2 | PA642788 | PM773495 |