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 |
|---|---|---|---|---|---|---|---|
| 14060000126718 | L14/dossiers | 14 | 14060000126717 | 14060000126717 | 1 | PA563 | PM645307 |
| 14060000126725 | L14/dossiers | 14 | 14060000126724 | 14060000126724 | 1 | PA2876 | PM645355 |
| 14060000126732 | L14/dossiers | 14 | 14060000126731 | 14060000126731 | 1 | PA330008 | PM645164 |
| 14060000126739 | L14/dossiers | 14 | 14060000126738 | 14060000126738 | 1 | PA328 | PM653228 |
| 14060000126770 | L14/dossiers | 14 | 14060000126769 | 14060000126769 | 1 | PA563 | PM645307 |
| 14060000126777 | L14/dossiers | 14 | 14060000126776 | 14060000126776 | 1 | PA267091 | PM645467 |
| 14060000126792 | L14/dossiers | 14 | 14060000126791 | 14060000126791 | 1 | PA267785 | PM645359 |
| 14060000126799 | L14/dossiers | 14 | 14060000126798 | 14060000126798 | 1 | PA332950 | PM645251 |
| 14060000126804 | L14/dossiers | 14 | 14060000126803 | 14060000126803 | 1 | PA716 | PM429977 |
| 14060000126829 | L14/dossiers | 14 | 14060000126828 | 14060000126828 | 1 | PA267680 | PM645427 |
| 14060000126836 | L14/dossiers | 14 | 14060000126835 | 14060000126835 | 1 | PA785 | PM715797 |
| 14060000126845 | L14/dossiers | 14 | 14060000126844 | 14060000126844 | 1 | PA266788 | PM645294 |
| 14060000126852 | L14/dossiers | 14 | 14060000126851 | 14060000126851 | 1 | PA267622 | PM702957 |
| 14060000126862 | L14/dossiers | 14 | 14060000126861 | 14060000126861 | 1 | PA2792 | PM645308 |
| 14060000126869 | L14/dossiers | 14 | 14060000126868 | 14060000126868 | 1 | PA2073 | PM645207 |
| 14060000126874 | L14/dossiers | 14 | 14060000126873 | 14060000126873 | 1 | PA267306 | PM645210 |
| 14060000126896 | L14/dossiers | 14 | 14060000126895 | 14060000126895 | 1 | PA2377 | PM645591 |
| 14060000126903 | L14/dossiers | 14 | 14060000126902 | 14060000126902 | 1 | PA267743 | PM645058 |
| 14060000126910 | L14/dossiers | 14 | 14060000126909 | 14060000126909 | 1 | PA2048 | PM693013 |
| 14060000126920 | L14/dossiers | 14 | 14060000126919 | 14060000126919 | 1 | PA344492 | PM645300 |
| 14060000126927 | L14/dossiers | 14 | 14060000126926 | 14060000126926 | 1 | PA2971 | PM645392 |
| 14060000126934 | L14/dossiers | 14 | 14060000126933 | 14060000126933 | 1 | PA785 | PM715797 |
| 14060000126941 | L14/dossiers | 14 | 14060000126940 | 14060000126940 | 1 | PA328 | PM653228 |
| 14060000126972 | L14/dossiers | 14 | 14060000126971 | 14060000126971 | 1 | PA1886 | PM645099 |
| 14060000127014 | L14/dossiers | 14 | 14060000127013 | 14060000127013 | 1 | PA2257 | PM645201 |
| 14060000127021 | L14/dossiers | 14 | 14060000127020 | 14060000127020 | 1 | PA267457 | PM687216 |
| 14060000127028 | L14/dossiers | 14 | 14060000127027 | 14060000127027 | 1 | PA2377 | PM645591 |
| 14060000127035 | L14/dossiers | 14 | 14060000127034 | 14060000127034 | 1 | PA267622 | PM702957 |
| 14060000127042 | L14/dossiers | 14 | 14060000127041 | 14060000127041 | 1 | PA267622 | PM700712 |
| 14060000127043 | L14/dossiers | 14 | 14060000127041 | 14060000127041 | 2 | PA1268 | PM700715 |
| 14060000127086 | L14/dossiers | 14 | 14060000127085 | 14060000127085 | 1 | PA266788 | PM645294 |
| 14060000127093 | L14/dossiers | 14 | 14060000127092 | 14060000127092 | 1 | PA266788 | PM645294 |
| 14060000127100 | L14/dossiers | 14 | 14060000127099 | 14060000127099 | 1 | PA735 | PM645089 |
| 14060000127110 | L14/dossiers | 14 | 14060000127109 | 14060000127109 | 1 | PA346886 | PM695110 |
| 14060000127117 | L14/dossiers | 14 | 14060000127116 | 14060000127116 | 1 | PA267576 | PM645073 |
| 14060000127124 | L14/dossiers | 14 | 14060000127123 | 14060000127123 | 1 | PA2792 | PM645308 |
| 14060000127131 | L14/dossiers | 14 | 14060000127130 | 14060000127130 | 1 | PA609332 | PM645147 |
| 14060000127138 | L14/dossiers | 14 | 14060000127137 | 14060000127137 | 1 | PA2775 | PM645461 |
| 14060000127145 | L14/dossiers | 14 | 14060000127144 | 14060000127144 | 1 | PA266788 | PM645294 |
| 14060000127152 | L14/dossiers | 14 | 14060000127151 | 14060000127151 | 1 | PA267622 | PM702957 |
| 14060000127159 | L14/dossiers | 14 | 14060000127158 | 14060000127158 | 1 | PA330240 | PM645425 |
| 14060000127169 | L14/dossiers | 14 | 14060000127168 | 14060000127168 | 1 | PA429858 | PM429958 |
| 14060000127179 | L14/dossiers | 14 | 14060000127178 | 14060000127178 | 1 | PA266788 | PM645294 |
| 14060000127186 | L14/dossiers | 14 | 14060000127185 | 14060000127185 | 1 | PA606212 | PM645330 |
| 14060000127193 | L14/dossiers | 14 | 14060000127192 | 14060000127192 | 1 | PA2792 | PM645308 |
| 14060000127200 | L14/dossiers | 14 | 14060000127199 | 14060000127199 | 1 | PA346886 | PM695110 |
| 14060000127207 | L14/dossiers | 14 | 14060000127206 | 14060000127206 | 1 | PA332523 | PM645550 |
| 14060000127214 | L14/dossiers | 14 | 14060000127213 | 14060000127213 | 1 | PA330240 | PM645425 |
| 14060000127227 | L14/dossiers | 14 | 14060000127226 | 14060000127226 | 1 | PA608186 | PM645202 |
| 14060000127247 | L14/dossiers | 14 | 14060000127246 | 14060000127246 | 1 | PA606495 | PM645463 |