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 |
|---|---|---|---|---|---|---|---|
| 17060000127218 | L17/dossiers | 17 | 17060000127205 | 17060000127205 | 13 | PA775246 | PM775532 |
| 17060000127219 | L17/dossiers | 17 | 17060000127205 | 17060000127205 | 14 | PA827962 | PM828676 |
| 17060000127220 | L17/dossiers | 17 | 17060000127205 | 17060000127205 | 15 | PA736243 | PM829929 |
| 17060000127221 | L17/dossiers | 17 | 17060000127205 | 17060000127205 | 16 | PA736175 | PM829795 |
| 17060000127222 | L17/dossiers | 17 | 17060000127205 | 17060000127205 | 17 | PA775296 | PM775596 |
| 17060000127223 | L17/dossiers | 17 | 17060000127205 | 17060000127205 | 18 | PA828020 | PM828864 |
| 17060000127233 | L17/dossiers | 17 | 17060000127232 | 17060000127232 | 1 | PA794082 | PM842810 |
| 17060000127240 | L17/dossiers | 17 | 17060000127239 | 17060000127239 | 1 | PA791812 | PM840384 |
| 17060000127248 | L17/dossiers | 17 | 17060000127247 | 17060000127247 | 1 | PA791812 | PM840384 |
| 17060000127255 | L17/dossiers | 17 | 17060000127254 | 17060000127254 | 1 | PA346782 | PM840426 |
| 17060000127262 | L17/dossiers | 17 | 17060000127261 | 17060000127261 | 1 | PA718850 | PM842411 |
| 17060000127285 | L17/dossiers | 17 | 17060000127284 | 17060000127284 | 1 | PA720092 | PM842948 |
| 17060000127292 | L17/dossiers | 17 | 17060000127291 | 17060000127291 | 1 | PA720092 | PM842948 |
| 17060000127299 | L17/dossiers | 17 | 17060000127298 | 17060000127298 | 1 | PA720092 | PM842948 |
| 17060000127306 | L17/dossiers | 17 | 17060000127305 | 17060000127305 | 1 | PA840889 | PM842534 |
| 17060000127313 | L17/dossiers | 17 | 17060000127312 | 17060000127312 | 1 | PA841047 | PM842675 |
| 17060000127320 | L17/dossiers | 17 | 17060000127319 | 17060000127319 | 1 | PA842155 | PM843674 |
| 17060000127327 | L17/dossiers | 17 | 17060000127326 | 17060000127326 | 1 | PA722390 | PM843317 |
| 17060000127334 | L17/dossiers | 17 | 17060000127333 | 17060000127333 | 1 | PA795466 | PM843443 |
| 17060000127342 | L17/dossiers | 17 | 17060000127341 | 17060000127341 | 1 | PA720908 | PM843701 |
| 17060000127349 | L17/dossiers | 17 | 17060000127348 | 17060000127348 | 1 | PA721474 | PM843608 |
| 17060000127356 | L17/dossiers | 17 | 17060000127355 | 17060000127355 | 1 | PA721474 | PM843608 |
| 17060000127363 | L17/dossiers | 17 | 17060000127362 | 17060000127362 | 1 | PA642847 | PM843056 |
| 17060000127370 | L17/dossiers | 17 | 17060000127369 | 17060000127369 | 1 | PA642847 | PM843056 |
| 17060000127377 | L17/dossiers | 17 | 17060000127376 | 17060000127376 | 1 | PA642847 | PM843056 |
| 17060000127384 | L17/dossiers | 17 | 17060000127383 | 17060000127383 | 1 | PA795808 | PM843644 |
| 17060000127391 | L17/dossiers | 17 | 17060000127390 | 17060000127390 | 1 | PA721960 | PM840378 |
| 17060000127398 | L17/dossiers | 17 | 17060000127397 | 17060000127397 | 1 | PA840979 | PM842588 |
| 17060000127405 | L17/dossiers | 17 | 17060000127404 | 17060000127404 | 1 | PA840979 | PM842588 |
| 17060000127412 | L17/dossiers | 17 | 17060000127411 | 17060000127411 | 1 | PA840979 | PM842588 |
| 17060000127425 | L17/dossiers | 17 | 17060000127424 | 17060000127424 | 1 | PA840721 | PM842378 |
| 17060000127432 | L17/dossiers | 17 | 17060000127431 | 17060000127431 | 1 | PA722328 | PM849127 |
| 17060000127439 | L17/dossiers | 17 | 17060000127438 | 17060000127438 | 1 | PA794022 | PM842777 |
| 17060000127446 | L17/dossiers | 17 | 17060000127445 | 17060000127445 | 1 | PA841955 | PM843506 |
| 17060000127453 | L17/dossiers | 17 | 17060000127452 | 17060000127452 | 1 | PA791812 | PM840384 |
| 17060000127461 | L17/dossiers | 17 | 17060000127460 | 17060000127460 | 1 | PA840979 | PM842588 |
| 17060000127468 | L17/dossiers | 17 | 17060000127467 | 17060000127467 | 1 | PA840979 | PM842588 |
| 17060000127475 | L17/dossiers | 17 | 17060000127474 | 17060000127474 | 1 | PA796018 | PM843425 |
| 17060000127482 | L17/dossiers | 17 | 17060000127481 | 17060000127481 | 1 | PA794038 | PM842783 |
| 17060000127489 | L17/dossiers | 17 | 17060000127488 | 17060000127488 | 1 | PA841813 | PM843377 |
| 17060000127522 | L17/dossiers | 17 | 17060000127521 | 17060000127521 | 1 | PA794946 | PM843311 |
| 17060000127529 | L17/dossiers | 17 | 17060000127528 | 17060000127528 | 1 | PA794038 | PM842783 |
| 17060000127540 | L17/dossiers | 17 | 17060000127539 | 17060000127539 | 1 | PA794154 | PM842918 |
| 17060000127553 | L17/dossiers | 17 | 17060000127552 | 17060000127552 | 1 | PA794502 | PM840324 |
| 17060000127560 | L17/dossiers | 17 | 17060000127559 | 17060000127559 | 1 | PA793238 | PM842426 |
| 17060000127567 | L17/dossiers | 17 | 17060000127566 | 17060000127566 | 1 | PA827956 | PM828682 |
| 17060000127586 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 1 | PA775296 | PM775596 |
| 17060000127587 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 2 | PA850008 | PM850016 |
| 17060000127588 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 3 | PA268007 | PM829695 |
| 17060000127589 | L17/dossiers | 17 | 17060000127585 | 17060000127585 | 4 | PA757676 | PM829801 |