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 |
|---|---|---|---|---|---|---|---|
| 16060000122887 | L16/dossiers | 16 | 16060000122886 | 16060000122886 | 1 | PA794870 | PM797172 |
| 16060000122897 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 1 | PA785857 | PM785867 |
| 16060000122898 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 2 | PA828004 | PM828838 |
| 16060000122899 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 3 | PA775180 | PM775466 |
| 16060000122900 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 4 | PA827904 | PM828514 |
| 16060000122901 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 5 | PA429845 | PM829729 |
| 16060000122902 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 6 | PA775214 | PM775498 |
| 16060000122903 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 7 | PA775224 | PM775512 |
| 16060000122904 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 8 | PA736177 | PM829835 |
| 16060000122905 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 9 | PA827946 | PM828614 |
| 16060000122906 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 10 | PA827950 | PM828598 |
| 16060000122907 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 11 | PA775252 | PM775558 |
| 16060000122908 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 12 | PA827968 | PM828750 |
| 16060000122909 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 13 | PA827978 | PM828730 |
| 16060000122910 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 14 | PA775272 | PM775562 |
| 16060000122911 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 15 | PA775282 | PM775584 |
| 16060000122912 | L16/dossiers | 16 | 16060000122896 | 16060000122896 | 16 | PA828000 | PM828850 |
| 16060000122922 | L16/dossiers | 16 | 16060000122921 | 16060000122921 | 1 | PA794530 | PM796974 |
| 16060000122932 | L16/dossiers | 16 | 16060000122931 | 16060000122931 | 1 | PA606098 | PM796449 |
| 16060000122949 | L16/dossiers | 16 | 16060000122948 | 16060000122948 | 1 | PA330684 | PM775859 |
| 16060000122956 | L16/dossiers | 16 | 16060000122955 | 16060000122955 | 1 | PA722190 | PM833697 |
| 16060000122957 | L16/dossiers | 16 | 16060000122955 | 16060000122955 | 2 | PA719938 | PM833702 |
| 16060000123023 | L16/dossiers | 16 | 16060000123022 | 16060000123022 | 1 | PA784534 | PM784544 |
| 16060000123030 | L16/dossiers | 16 | 16060000123029 | 16060000123029 | 1 | PA266788 | PM796788 |
| 16060000123034 | L16/dossiers | 16 | 16060000123033 | 16060000123033 | 1 | PA775248 | PM775554 |
| 16060000123035 | L16/dossiers | 16 | 16060000123033 | 16060000123033 | 2 | PA784534 | PM784544 |
| 16060000123042 | L16/dossiers | 16 | 16060000123041 | 16060000123041 | 1 | PA330008 | PM796158 |
| 16060000123049 | L16/dossiers | 16 | 16060000123048 | 16060000123048 | 1 | PA721896 | PM797664 |
| 16060000123059 | L16/dossiers | 16 | 16060000123058 | 16060000123058 | 1 | PA794038 | PM796668 |
| 16060000123063 | L16/dossiers | 16 | 16060000123062 | 16060000123062 | 1 | PA736233 | PM829889 |
| 16060000123082 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 1 | PA828004 | PM828838 |
| 16060000123083 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 2 | PA775180 | PM775466 |
| 16060000123084 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 3 | PA827904 | PM828514 |
| 16060000123085 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 4 | PA429845 | PM829729 |
| 16060000123086 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 5 | PA775214 | PM775498 |
| 16060000123087 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 6 | PA775224 | PM775512 |
| 16060000123088 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 7 | PA736177 | PM829835 |
| 16060000123089 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 8 | PA827946 | PM828614 |
| 16060000123090 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 9 | PA827950 | PM828598 |
| 16060000123091 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 10 | PA775252 | PM775558 |
| 16060000123092 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 11 | PA827968 | PM828750 |
| 16060000123093 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 12 | PA827978 | PM828730 |
| 16060000123094 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 13 | PA775272 | PM775562 |
| 16060000123095 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 14 | PA775282 | PM775584 |
| 16060000123096 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 15 | PA828000 | PM828850 |
| 16060000123097 | L16/dossiers | 16 | 16060000123081 | 16060000123081 | 16 | PA785857 | PM785867 |
| 16060000123104 | L16/dossiers | 16 | 16060000123103 | 16060000123103 | 1 | PA795746 | PM797661 |
| 16060000123111 | L16/dossiers | 16 | 16060000123110 | 16060000123110 | 1 | PA774962 | PM797766 |
| 16060000123135 | L16/dossiers | 16 | 16060000123134 | 16060000123134 | 1 | PA722190 | PM833697 |
| 16060000123136 | L16/dossiers | 16 | 16060000123134 | 16060000123134 | 2 | PA267797 | PM833731 |