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 |
|---|---|---|---|---|---|---|---|
| 15060000161220 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 13 | PA703487 | PM703711 |
| 15060000161221 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 14 | PA736228 | PM736380 |
| 15060000161222 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 15 | PA1573 | PM703652 |
| 15060000161223 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 16 | PA736168 | PM736301 |
| 15060000161224 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 17 | PA703509 | PM703687 |
| 15060000161225 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 18 | PA703529 | PM703650 |
| 15060000161226 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 19 | PA415464 | PM703627 |
| 15060000161227 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 20 | PA736242 | PM736349 |
| 15060000161228 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 21 | PA703495 | PM703708 |
| 15060000161229 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 22 | PA415480 | PM709303 |
| 15060000161247 | L15/dossiers | 15 | 15060000161246 | 15060000161246 | 1 | PA736186 | PM736396 |
| 15060000161248 | L15/dossiers | 15 | 15060000161246 | 15060000161246 | 2 | PA415454 | PM703689 |
| 15060000161267 | L15/dossiers | 15 | 15060000161266 | 15060000161266 | 1 | PA610667 | PM723146 |
| 15060000161274 | L15/dossiers | 15 | 15060000161273 | 15060000161273 | 1 | PA330240 | PM722492 |
| 15060000161288 | L15/dossiers | 15 | 15060000161287 | 15060000161287 | 1 | PA345619 | PM725692 |
| 15060000161289 | L15/dossiers | 15 | 15060000161287 | 15060000161287 | 2 | PA331481 | PM730094 |
| 15060000161299 | L15/dossiers | 15 | 15060000161298 | 15060000161298 | 1 | PA345619 | PM725692 |
| 15060000161329 | L15/dossiers | 15 | 15060000161328 | 15060000161328 | 1 | PA345619 | PM725692 |
| 15060000161432 | L15/dossiers | 15 | 15060000161431 | 15060000161431 | 1 | PA736164 | PM736430 |
| 15060000161439 | L15/dossiers | 15 | 15060000161438 | 15060000161438 | 1 | PA223837 | PM722458 |
| 15060000161446 | L15/dossiers | 15 | 15060000161445 | 15060000161445 | 1 | PA608016 | PM723024 |
| 15060000161453 | L15/dossiers | 15 | 15060000161452 | 15060000161452 | 1 | PA719946 | PM722808 |
| 15060000161457 | L15/dossiers | 15 | 15060000161456 | 15060000161456 | 1 | PA720916 | PM723112 |
| 15060000161461 | L15/dossiers | 15 | 15060000161460 | 15060000161460 | 1 | PA736225 | PM736334 |
| 15060000161478 | L15/dossiers | 15 | 15060000161477 | 15060000161477 | 1 | PA330240 | PM722492 |
| 15060000161485 | L15/dossiers | 15 | 15060000161484 | 15060000161484 | 1 | PA345619 | PM725692 |
| 15060000161486 | L15/dossiers | 15 | 15060000161484 | 15060000161484 | 2 | PA758792 | PM758794 |
| 15060000161520 | L15/dossiers | 15 | 15060000161519 | 15060000161519 | 1 | PA345619 | PM725692 |
| 15060000161521 | L15/dossiers | 15 | 15060000161519 | 15060000161519 | 2 | PA331481 | PM730094 |
| 15060000161528 | L15/dossiers | 15 | 15060000161527 | 15060000161527 | 1 | PA345619 | PM725692 |
| 15060000161565 | L15/dossiers | 15 | 15060000161564 | 15060000161564 | 1 | PA736213 | PM736431 |
| 15060000161572 | L15/dossiers | 15 | 15060000161571 | 15060000161571 | 1 | PA702993 | PM736362 |
| 15060000161573 | L15/dossiers | 15 | 15060000161571 | 15060000161571 | 2 | PA703505 | PM703626 |
| 15060000161574 | L15/dossiers | 15 | 15060000161571 | 15060000161571 | 3 | PA429867 | PM736298 |
| 15060000161575 | L15/dossiers | 15 | 15060000161571 | 15060000161571 | 4 | PA429889 | PM736313 |
| 15060000161576 | L15/dossiers | 15 | 15060000161571 | 15060000161571 | 5 | PA429889 | PM736313 |
| 15060000161577 | L15/dossiers | 15 | 15060000161571 | 15060000161571 | 6 | PA703490 | PM703631 |
| 15060000161598 | L15/dossiers | 15 | 15060000161597 | 15060000161597 | 1 | PA267440 | PM722522 |
| 15060000161615 | L15/dossiers | 15 | 15060000161614 | 15060000161614 | 1 | PA718838 | PM722474 |
| 15060000161622 | L15/dossiers | 15 | 15060000161621 | 15060000161621 | 1 | PA719946 | PM722808 |
| 15060000161629 | L15/dossiers | 15 | 15060000161628 | 15060000161628 | 1 | PA719946 | PM722808 |
| 15060000161636 | L15/dossiers | 15 | 15060000161635 | 15060000161635 | 1 | PA719272 | PM722612 |
| 15060000161643 | L15/dossiers | 15 | 15060000161642 | 15060000161642 | 1 | PA2792 | PM722870 |
| 15060000161650 | L15/dossiers | 15 | 15060000161649 | 15060000161649 | 1 | PA718784 | PM722456 |
| 15060000161657 | L15/dossiers | 15 | 15060000161656 | 15060000161656 | 1 | PA719272 | PM722612 |
| 15060000161664 | L15/dossiers | 15 | 15060000161663 | 15060000161663 | 1 | PA720644 | PM723026 |
| 15060000161671 | L15/dossiers | 15 | 15060000161670 | 15060000161670 | 1 | PA1874 | PM722598 |
| 15060000161678 | L15/dossiers | 15 | 15060000161677 | 15060000161677 | 1 | PA2792 | PM722870 |
| 15060000161685 | L15/dossiers | 15 | 15060000161684 | 15060000161684 | 1 | PA267440 | PM722522 |
| 15060000161692 | L15/dossiers | 15 | 15060000161691 | 15060000161691 | 1 | PA718926 | PM722502 |