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 |
|---|---|---|---|---|---|---|---|
| 14060000113683 | L14/dossiers | 14 | 14060000113682 | 14060000113682 | 1 | PA266788 | PM645294 |
| 14060000113690 | L14/dossiers | 14 | 14060000113689 | 14060000113689 | 1 | PA333134 | PM645341 |
| 14060000113697 | L14/dossiers | 14 | 14060000113696 | 14060000113696 | 1 | PA330240 | PM645425 |
| 14060000113704 | L14/dossiers | 14 | 14060000113703 | 14060000113703 | 1 | PA2971 | PM645392 |
| 14060000113711 | L14/dossiers | 14 | 14060000113710 | 14060000113710 | 1 | PA1515 | PM429913 |
| 14060000113735 | L14/dossiers | 14 | 14060000113734 | 14060000113734 | 1 | PA609016 | PM645074 |
| 14060000113742 | L14/dossiers | 14 | 14060000113741 | 14060000113741 | 1 | PA267743 | PM645058 |
| 14060000113749 | L14/dossiers | 14 | 14060000113748 | 14060000113748 | 1 | PA330684 | PM645497 |
| 14060000113756 | L14/dossiers | 14 | 14060000113755 | 14060000113755 | 1 | PA2048 | PM693013 |
| 14060000113763 | L14/dossiers | 14 | 14060000113762 | 14060000113762 | 1 | PA346886 | PM695110 |
| 14060000113770 | L14/dossiers | 14 | 14060000113769 | 14060000113769 | 1 | PA2971 | PM645392 |
| 14060000113780 | L14/dossiers | 14 | 14060000113779 | 14060000113779 | 1 | PA1946 | PM645437 |
| 14060000113797 | L14/dossiers | 14 | 14060000113796 | 14060000113796 | 1 | PA610313 | PM645122 |
| 14060000113798 | L14/dossiers | 14 | 14060000113796 | 14060000113796 | 2 | PA2952 | PM645464 |
| 14060000113854 | L14/dossiers | 14 | 14060000113853 | 14060000113853 | 1 | PA267622 | PM702957 |
| 14060000113855 | L14/dossiers | 14 | 14060000113853 | 14060000113853 | 2 | PA702993 | PM709263 |
| 14060000113863 | L14/dossiers | 14 | 14060000113862 | 14060000113862 | 1 | PA1874 | PM645474 |
| 14060000113870 | L14/dossiers | 14 | 14060000113869 | 14060000113869 | 1 | PA267622 | PM702957 |
| 14060000113877 | L14/dossiers | 14 | 14060000113876 | 14060000113876 | 1 | PA267622 | PM702957 |
| 14060000113878 | L14/dossiers | 14 | 14060000113876 | 14060000113876 | 2 | PA2679 | PM702976 |
| 14060000113879 | L14/dossiers | 14 | 14060000113876 | 14060000113876 | 3 | PA785 | PM702979 |
| 14060000113880 | L14/dossiers | 14 | 14060000113876 | 14060000113876 | 4 | PA702992 | PM702994 |
| 14060000114021 | L14/dossiers | 14 | 14060000114020 | 14060000114020 | 1 | PA328 | PM653228 |
| 14060000114022 | L14/dossiers | 14 | 14060000114020 | 14060000114020 | 2 | PA1268 | PM653525 |
| 14060000114053 | L14/dossiers | 14 | 14060000114052 | 14060000114052 | 1 | PA267622 | PM702957 |
| 14060000114054 | L14/dossiers | 14 | 14060000114052 | 14060000114052 | 2 | PA2679 | PM702976 |
| 14060000114061 | L14/dossiers | 14 | 14060000114060 | 14060000114060 | 1 | PA606212 | PM645330 |
| 14060000114068 | L14/dossiers | 14 | 14060000114067 | 14060000114067 | 1 | PA304071 | PM304244 |
| 14060000114092 | L14/dossiers | 14 | 14060000114091 | 14060000114091 | 1 | PA330684 | PM645497 |
| 14060000114103 | L14/dossiers | 14 | 14060000114102 | 14060000114102 | 1 | PA2664 | PM645139 |
| 14060000114110 | L14/dossiers | 14 | 14060000114109 | 14060000114109 | 1 | PA335567 | PM645104 |
| 14060000114117 | L14/dossiers | 14 | 14060000114116 | 14060000114116 | 1 | PA266797 | PM645338 |
| 14060000114124 | L14/dossiers | 14 | 14060000114123 | 14060000114123 | 1 | PA607846 | PM645441 |
| 14060000114132 | L14/dossiers | 14 | 14060000114131 | 14060000114131 | 1 | PA1874 | PM645474 |
| 14060000114142 | L14/dossiers | 14 | 14060000114141 | 14060000114141 | 1 | PA266797 | PM645338 |
| 14060000114149 | L14/dossiers | 14 | 14060000114148 | 14060000114148 | 1 | PA330788 | PM645510 |
| 14060000114156 | L14/dossiers | 14 | 14060000114155 | 14060000114155 | 1 | PA328 | PM653228 |
| 14060000114163 | L14/dossiers | 14 | 14060000114162 | 14060000114162 | 1 | PA2690 | PM645458 |
| 14060000114170 | L14/dossiers | 14 | 14060000114169 | 14060000114169 | 1 | PA606212 | PM645330 |
| 14060000114177 | L14/dossiers | 14 | 14060000114176 | 14060000114176 | 1 | PA429840 | PM429983 |
| 14060000114189 | L14/dossiers | 14 | 14060000114188 | 14060000114188 | 1 | PA334149 | PM645127 |
| 14060000114202 | L14/dossiers | 14 | 14060000114201 | 14060000114201 | 1 | PA328 | PM653228 |
| 14060000114203 | L14/dossiers | 14 | 14060000114201 | 14060000114201 | 2 | PA268048 | PM653328 |
| 14060000114210 | L14/dossiers | 14 | 14060000114209 | 14060000114209 | 1 | PA267622 | PM700712 |
| 14060000114220 | L14/dossiers | 14 | 14060000114219 | 14060000114219 | 1 | PA2971 | PM645392 |
| 14060000114227 | L14/dossiers | 14 | 14060000114226 | 14060000114226 | 1 | PA328 | PM653228 |
| 14060000114228 | L14/dossiers | 14 | 14060000114226 | 14060000114226 | 2 | PA588886 | PM653258 |
| 14060000114368 | L14/dossiers | 14 | 14060000114367 | 14060000114367 | 1 | PA1886 | PM645099 |
| 14060000114392 | L14/dossiers | 14 | 14060000114391 | 14060000114391 | 1 | PA267285 | PM645140 |
| 14060000114399 | L14/dossiers | 14 | 14060000114398 | 14060000114398 | 1 | PA267622 | PM702957 |