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 |
|---|---|---|---|---|---|---|---|
| 15060000147019 | L15/dossiers | 15 | 15060000147018 | 15060000147018 | 1 | PA429869 | PM736350 |
| 15060000147051 | L15/dossiers | 15 | 15060000147050 | 15060000147050 | 1 | PA267429 | PM722818 |
| 15060000147055 | L15/dossiers | 15 | 15060000147054 | 15060000147054 | 1 | PA342601 | PM761932 |
| 15060000147065 | L15/dossiers | 15 | 15060000147064 | 15060000147064 | 1 | PA720210 | PM722892 |
| 15060000147072 | L15/dossiers | 15 | 15060000147071 | 15060000147071 | 1 | PA345619 | PM725692 |
| 15060000147073 | L15/dossiers | 15 | 15060000147071 | 15060000147071 | 2 | PA717153 | PM730062 |
| 15060000147171 | L15/dossiers | 15 | 15060000147170 | 15060000147170 | 1 | PA605518 | PM722518 |
| 15060000147181 | L15/dossiers | 15 | 15060000147180 | 15060000147180 | 1 | PA267260 | PM722476 |
| 15060000147188 | L15/dossiers | 15 | 15060000147187 | 15060000147187 | 1 | PA721314 | PM723236 |
| 15060000147195 | L15/dossiers | 15 | 15060000147194 | 15060000147194 | 1 | PA267306 | PM723054 |
| 15060000147210 | L15/dossiers | 15 | 15060000147209 | 15060000147209 | 1 | PA268019 | PM723092 |
| 15060000147220 | L15/dossiers | 15 | 15060000147219 | 15060000147219 | 1 | PA223837 | PM722458 |
| 15060000147227 | L15/dossiers | 15 | 15060000147226 | 15060000147226 | 1 | PA345619 | PM725692 |
| 15060000147265 | L15/dossiers | 15 | 15060000147264 | 15060000147264 | 1 | PA606098 | PM722642 |
| 15060000147272 | L15/dossiers | 15 | 15060000147271 | 15060000147271 | 1 | PA718884 | PM722488 |
| 15060000147291 | L15/dossiers | 15 | 15060000147290 | 15060000147290 | 1 | PA643089 | PM758076 |
| 15060000147298 | L15/dossiers | 15 | 15060000147297 | 15060000147297 | 1 | PA721474 | PM723286 |
| 15060000147305 | L15/dossiers | 15 | 15060000147304 | 15060000147304 | 1 | PA2150 | PM722506 |
| 15060000147312 | L15/dossiers | 15 | 15060000147311 | 15060000147311 | 1 | PA721474 | PM723286 |
| 15060000147319 | L15/dossiers | 15 | 15060000147318 | 15060000147318 | 1 | PA1327 | PM722762 |
| 15060000147326 | L15/dossiers | 15 | 15060000147325 | 15060000147325 | 1 | PA721474 | PM723286 |
| 15060000147330 | L15/dossiers | 15 | 15060000147329 | 15060000147329 | 1 | PA720846 | PM723094 |
| 15060000147337 | L15/dossiers | 15 | 15060000147336 | 15060000147336 | 1 | PA709315 | PM722526 |
| 15060000147341 | L15/dossiers | 15 | 15060000147340 | 15060000147340 | 1 | PA608826 | PM723276 |
| 15060000147348 | L15/dossiers | 15 | 15060000147347 | 15060000147347 | 1 | PA1695 | PM723322 |
| 15060000147372 | L15/dossiers | 15 | 15060000147371 | 15060000147371 | 1 | PA721466 | PM723284 |
| 15060000147433 | L15/dossiers | 15 | 15060000147432 | 15060000147432 | 1 | PA721968 | PM723436 |
| 15060000147440 | L15/dossiers | 15 | 15060000147439 | 15060000147439 | 1 | PA2952 | PM722480 |
| 15060000147450 | L15/dossiers | 15 | 15060000147449 | 15060000147449 | 1 | PA609726 | PM723426 |
| 15060000147461 | L15/dossiers | 15 | 15060000147460 | 15060000147460 | 1 | PA1206 | PM723354 |
| 15060000147468 | L15/dossiers | 15 | 15060000147467 | 15060000147467 | 1 | PA643134 | PM722824 |
| 15060000147475 | L15/dossiers | 15 | 15060000147474 | 15060000147474 | 1 | PA345619 | PM725692 |
| 15060000147476 | L15/dossiers | 15 | 15060000147474 | 15060000147474 | 2 | PA331481 | PM730094 |
| 15060000147483 | L15/dossiers | 15 | 15060000147482 | 15060000147482 | 1 | PA345619 | PM725692 |
| 15060000147514 | L15/dossiers | 15 | 15060000147513 | 15060000147513 | 1 | PA608826 | PM723276 |
| 15060000147521 | L15/dossiers | 15 | 15060000147520 | 15060000147520 | 1 | PA266797 | PM722884 |
| 15060000147528 | L15/dossiers | 15 | 15060000147527 | 15060000147527 | 1 | PA718784 | PM722456 |
| 15060000147535 | L15/dossiers | 15 | 15060000147534 | 15060000147534 | 1 | PA330240 | PM722492 |
| 15060000147542 | L15/dossiers | 15 | 15060000147541 | 15060000147541 | 1 | PA703512 | PM703575 |
| 15060000147562 | L15/dossiers | 15 | 15060000147561 | 15060000147561 | 1 | PA609726 | PM723426 |
| 15060000147569 | L15/dossiers | 15 | 15060000147568 | 15060000147568 | 1 | PA721194 | PM723200 |
| 15060000147576 | L15/dossiers | 15 | 15060000147575 | 15060000147575 | 1 | PA721194 | PM723200 |
| 15060000147583 | L15/dossiers | 15 | 15060000147582 | 15060000147582 | 1 | PA606212 | PM722662 |
| 15060000147590 | L15/dossiers | 15 | 15060000147589 | 15060000147589 | 1 | PA2774 | PM736307 |
| 15060000147609 | L15/dossiers | 15 | 15060000147608 | 15060000147608 | 1 | PA606171 | PM722632 |
| 15060000147618 | L15/dossiers | 15 | 15060000147617 | 15060000147617 | 1 | PA718780 | PM722454 |
| 15060000147625 | L15/dossiers | 15 | 15060000147624 | 15060000147624 | 1 | PA721174 | PM723194 |
| 15060000147632 | L15/dossiers | 15 | 15060000147631 | 15060000147631 | 1 | PA712015 | PM722448 |
| 15060000147637 | L15/dossiers | 15 | 15060000147636 | 15060000147636 | 1 | PA721486 | PM723290 |
| 15060000147644 | L15/dossiers | 15 | 15060000147643 | 15060000147643 | 1 | PA345619 | PM725692 |