dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 16060000097211 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 81 | PA304086 | PM736348 |
| 16060000097212 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 82 | PA736240 | PM736279 |
| 16060000097213 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 83 | PA758431 | PM758701 |
| 16060000097214 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 84 | PA763158 | PM775683 |
| 16060000097215 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 85 | PA775276 | PM775566 |
| 16060000097216 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 86 | PA775280 | PM775586 |
| 16060000097217 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 87 | PA429851 | PM736305 |
| 16060000097218 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 88 | PA429874 | PM736314 |
| 16060000097219 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 89 | PA227094 | PM736386 |
| 16060000097220 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 90 | PA736207 | PM736391 |
| 16060000097221 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 91 | PA775288 | PM775578 |
| 16060000097222 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 92 | PA775292 | PM775582 |
| 16060000097223 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 93 | PA775298 | PM775594 |
| 16060000097224 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 94 | PA775302 | PM775598 |
| 16060000097231 | L16/dossiers | 16 | 16060000097230 | 16060000097230 | 1 | PA775284 | PM775590 |
| 16060000097238 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 1 | PA785857 | PM785867 |
| 16060000097239 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 2 | PA775180 | PM775466 |
| 16060000097240 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 3 | PA801838 | PM801842 |
| 16060000097241 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 4 | PA429845 | PM736278 |
| 16060000097242 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 5 | PA775214 | PM775498 |
| 16060000097243 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 6 | PA775224 | PM775512 |
| 16060000097244 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 7 | PA736177 | PM736318 |
| 16060000097245 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 8 | PA429866 | PM736287 |
| 16060000097246 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 9 | PA775252 | PM775558 |
| 16060000097247 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 10 | PA775262 | PM775548 |
| 16060000097248 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 11 | PA775272 | PM775562 |
| 16060000097249 | L16/dossiers | 16 | 16060000097237 | 16060000097237 | 12 | PA775282 | PM775584 |
| 16060000097256 | L16/dossiers | 16 | 16060000097255 | 16060000097255 | 1 | PA718838 | PM796197 |
| 16060000097263 | L16/dossiers | 16 | 16060000097262 | 16060000097262 | 1 | PA774960 | PM797490 |
| 16060000097270 | L16/dossiers | 16 | 16060000097269 | 16060000097269 | 1 | PA718784 | PM796266 |
| 16060000097277 | L16/dossiers | 16 | 16060000097276 | 16060000097276 | 1 | PA266788 | PM796788 |
| 16060000097284 | L16/dossiers | 16 | 16060000097283 | 16060000097283 | 1 | PA608416 | PM797133 |
| 16060000097291 | L16/dossiers | 16 | 16060000097290 | 16060000097290 | 1 | PA267042 | PM796932 |
| 16060000097298 | L16/dossiers | 16 | 16060000097297 | 16060000097297 | 1 | PA795596 | PM797580 |
| 16060000097305 | L16/dossiers | 16 | 16060000097304 | 16060000097304 | 1 | PA721486 | PM797517 |
| 16060000097312 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 1 | PA736181 | PM736416 |
| 16060000097313 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 2 | PA736219 | PM736387 |
| 16060000097314 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 3 | PA736199 | PM736284 |
| 16060000097315 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 4 | PA775196 | PM775482 |
| 16060000097316 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 5 | PA785855 | PM785869 |
| 16060000097317 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 6 | PA736234 | PM736424 |
| 16060000097318 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 7 | PA775210 | PM775492 |
| 16060000097319 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 8 | PA732419 | PM775647 |
| 16060000097320 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 9 | PA732419 | PM775647 |
| 16060000097321 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 10 | PA703538 | PM775715 |
| 16060000097322 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 11 | PA703509 | PM775687 |
| 16060000097323 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 12 | PA703536 | PM775719 |
| 16060000097324 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 13 | PA415477 | PM775809 |
| 16060000097325 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 14 | PA415477 | PM775809 |
| 16060000097326 | L16/dossiers | 16 | 16060000097311 | 16060000097311 | 15 | PA415449 | PM775793 |