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 |
|---|---|---|---|---|---|---|---|
| 15060000131173 | L15/dossiers | 15 | 15060000131172 | 15060000131172 | 1 | PA718838 | PM722474 |
| 15060000131180 | L15/dossiers | 15 | 15060000131179 | 15060000131179 | 1 | PA713448 | PM722452 |
| 15060000131187 | L15/dossiers | 15 | 15060000131186 | 15060000131186 | 1 | PA345619 | PM725692 |
| 15060000131188 | L15/dossiers | 15 | 15060000131186 | 15060000131186 | 2 | PA1872 | PM730104 |
| 15060000131220 | L15/dossiers | 15 | 15060000131219 | 15060000131219 | 1 | PA719946 | PM722808 |
| 15060000131227 | L15/dossiers | 15 | 15060000131226 | 15060000131226 | 1 | PA709315 | PM722526 |
| 15060000131244 | L15/dossiers | 15 | 15060000131243 | 15060000131243 | 1 | PA345619 | PM725692 |
| 15060000131245 | L15/dossiers | 15 | 15060000131243 | 15060000131243 | 2 | PA1872 | PM730104 |
| 15060000131278 | L15/dossiers | 15 | 15060000131277 | 15060000131277 | 1 | PA1874 | PM722598 |
| 15060000131285 | L15/dossiers | 15 | 15060000131284 | 15060000131284 | 1 | PA608826 | PM723276 |
| 15060000131292 | L15/dossiers | 15 | 15060000131291 | 15060000131291 | 1 | PA608826 | PM723276 |
| 15060000131299 | L15/dossiers | 15 | 15060000131298 | 15060000131298 | 1 | PA713448 | PM722452 |
| 15060000131306 | L15/dossiers | 15 | 15060000131305 | 15060000131305 | 1 | PA2952 | PM722480 |
| 15060000131313 | L15/dossiers | 15 | 15060000131312 | 15060000131312 | 1 | PA2952 | PM722480 |
| 15060000131320 | L15/dossiers | 15 | 15060000131319 | 15060000131319 | 1 | PA2952 | PM722480 |
| 15060000131327 | L15/dossiers | 15 | 15060000131326 | 15060000131326 | 1 | PA2952 | PM722480 |
| 15060000131334 | L15/dossiers | 15 | 15060000131333 | 15060000131333 | 1 | PA2952 | PM722480 |
| 15060000131341 | L15/dossiers | 15 | 15060000131340 | 15060000131340 | 1 | PA2952 | PM722480 |
| 15060000131348 | L15/dossiers | 15 | 15060000131347 | 15060000131347 | 1 | PA2952 | PM722480 |
| 15060000131355 | L15/dossiers | 15 | 15060000131354 | 15060000131354 | 1 | PA606212 | PM722662 |
| 15060000131362 | L15/dossiers | 15 | 15060000131361 | 15060000131361 | 1 | PA334768 | PM723548 |
| 15060000131369 | L15/dossiers | 15 | 15060000131368 | 15060000131368 | 1 | PA721506 | PM723296 |
| 15060000131376 | L15/dossiers | 15 | 15060000131375 | 15060000131375 | 1 | PA718780 | PM722454 |
| 15060000131383 | L15/dossiers | 15 | 15060000131382 | 15060000131382 | 1 | PA718838 | PM722474 |
| 15060000131390 | L15/dossiers | 15 | 15060000131389 | 15060000131389 | 1 | PA713448 | PM722452 |
| 15060000131397 | L15/dossiers | 15 | 15060000131396 | 15060000131396 | 1 | PA713448 | PM722452 |
| 15060000131404 | L15/dossiers | 15 | 15060000131403 | 15060000131403 | 1 | PA713448 | PM722452 |
| 15060000131411 | L15/dossiers | 15 | 15060000131410 | 15060000131410 | 1 | PA713448 | PM722452 |
| 15060000131418 | L15/dossiers | 15 | 15060000131417 | 15060000131417 | 1 | PA713448 | PM722452 |
| 15060000131425 | L15/dossiers | 15 | 15060000131424 | 15060000131424 | 1 | PA713448 | PM722452 |
| 15060000131432 | L15/dossiers | 15 | 15060000131431 | 15060000131431 | 1 | PA713448 | PM722452 |
| 15060000131439 | L15/dossiers | 15 | 15060000131438 | 15060000131438 | 1 | PA608416 | PM723540 |
| 15060000131446 | L15/dossiers | 15 | 15060000131445 | 15060000131445 | 1 | PA608416 | PM723540 |
| 15060000131453 | L15/dossiers | 15 | 15060000131452 | 15060000131452 | 1 | PA267785 | PM723310 |
| 15060000131460 | L15/dossiers | 15 | 15060000131459 | 15060000131459 | 1 | PA713448 | PM722452 |
| 15060000131467 | L15/dossiers | 15 | 15060000131466 | 15060000131466 | 1 | PA330684 | PM722528 |
| 15060000131474 | L15/dossiers | 15 | 15060000131473 | 15060000131473 | 1 | PA330684 | PM722528 |
| 15060000131481 | L15/dossiers | 15 | 15060000131480 | 15060000131480 | 1 | PA345619 | PM725692 |
| 15060000131488 | L15/dossiers | 15 | 15060000131487 | 15060000131487 | 1 | PA330240 | PM722492 |
| 15060000131495 | L15/dossiers | 15 | 15060000131494 | 15060000131494 | 1 | PA2952 | PM722480 |
| 15060000131502 | L15/dossiers | 15 | 15060000131501 | 15060000131501 | 1 | PA345619 | PM725692 |
| 15060000131503 | L15/dossiers | 15 | 15060000131501 | 15060000131501 | 2 | PA717147 | PM730068 |
| 15060000131608 | L15/dossiers | 15 | 15060000131607 | 15060000131607 | 1 | PA720468 | PM722972 |
| 15060000131615 | L15/dossiers | 15 | 15060000131614 | 15060000131614 | 1 | PA720468 | PM722972 |
| 15060000131622 | L15/dossiers | 15 | 15060000131621 | 15060000131621 | 1 | PA718838 | PM722474 |
| 15060000131634 | L15/dossiers | 15 | 15060000131633 | 15060000131633 | 1 | PA345619 | PM725692 |
| 15060000131635 | L15/dossiers | 15 | 15060000131633 | 15060000131633 | 2 | PA717153 | PM730062 |
| 15060000131642 | L15/dossiers | 15 | 15060000131641 | 15060000131641 | 1 | PA712015 | PM722448 |
| 15060000131649 | L15/dossiers | 15 | 15060000131648 | 15060000131648 | 1 | PA267260 | PM722476 |
| 15060000131656 | L15/dossiers | 15 | 15060000131655 | 15060000131655 | 1 | PA267260 | PM722476 |