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 |
|---|---|---|---|---|---|---|---|
| 17060000145423 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 4 | PA775172 | PM775474 |
| 17060000145424 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 5 | PA827898 | PM828454 |
| 17060000145425 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 6 | PA850008 | PM850016 |
| 17060000145426 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 7 | PA827912 | PM828488 |
| 17060000145427 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 8 | PA827930 | PM828544 |
| 17060000145428 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 9 | PA268007 | PM829695 |
| 17060000145429 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 10 | PA736195 | PM829855 |
| 17060000145430 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 11 | PA736173 | PM829799 |
| 17060000145431 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 12 | PA775246 | PM775532 |
| 17060000145432 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 13 | PA827962 | PM828676 |
| 17060000145433 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 14 | PA736243 | PM829929 |
| 17060000145434 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 15 | PA736175 | PM829795 |
| 17060000145435 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 16 | PA828002 | PM828856 |
| 17060000145436 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 17 | PA775296 | PM775596 |
| 17060000145437 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 18 | PA828020 | PM828864 |
| 17060000145444 | L17/dossiers | 17 | 17060000145443 | 17060000145443 | 1 | PA828008 | PM828826 |
| 17060000145451 | L17/dossiers | 17 | 17060000145450 | 17060000145450 | 1 | PA345722 | PM843650 |
| 17060000145461 | L17/dossiers | 17 | 17060000145460 | 17060000145460 | 1 | PA643210 | PM873637 |
| 17060000145472 | L17/dossiers | 17 | 17060000145471 | 17060000145471 | 1 | PA775234 | PM775536 |
| 17060000145482 | L17/dossiers | 17 | 17060000145481 | 17060000145481 | 1 | PA721474 | PM843608 |
| 17060000145489 | L17/dossiers | 17 | 17060000145488 | 17060000145488 | 1 | PA775228 | PM775516 |
| 17060000145496 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 1 | PA775282 | PM775584 |
| 17060000145497 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 2 | PA827946 | PM828614 |
| 17060000145498 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 3 | PA827950 | PM828598 |
| 17060000145499 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 4 | PA736177 | PM829835 |
| 17060000145500 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 5 | PA775180 | PM775466 |
| 17060000145501 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 6 | PA827904 | PM828514 |
| 17060000145502 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 7 | PA429845 | PM829729 |
| 17060000145503 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 8 | PA775214 | PM775498 |
| 17060000145504 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 9 | PA775224 | PM775512 |
| 17060000145505 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 10 | PA775252 | PM775558 |
| 17060000145506 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 11 | PA827968 | PM828750 |
| 17060000145507 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 12 | PA827978 | PM828730 |
| 17060000145508 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 13 | PA775272 | PM775562 |
| 17060000145509 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 14 | PA828000 | PM828850 |
| 17060000145510 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 15 | PA828004 | PM828838 |
| 17060000145511 | L17/dossiers | 17 | 17060000145495 | 17060000145495 | 16 | PA785857 | PM785867 |
| 17060000145518 | L17/dossiers | 17 | 17060000145517 | 17060000145517 | 1 | PA313924 | PM775727 |
| 17060000145519 | L17/dossiers | 17 | 17060000145517 | 17060000145517 | 2 | PA766947 | PM775799 |
| 17060000145520 | L17/dossiers | 17 | 17060000145517 | 17060000145517 | 3 | PA703495 | PM775653 |
| 17060000145542 | L17/dossiers | 17 | 17060000145541 | 17060000145541 | 1 | PA794710 | PM867916 |
| 17060000145549 | L17/dossiers | 17 | 17060000145548 | 17060000145548 | 1 | PA795156 | PM843680 |
| 17060000145556 | L17/dossiers | 17 | 17060000145555 | 17060000145555 | 1 | PA720668 | PM840342 |
| 17060000145564 | L17/dossiers | 17 | 17060000145563 | 17060000145563 | 1 | PA840889 | PM842534 |
| 17060000145571 | L17/dossiers | 17 | 17060000145570 | 17060000145570 | 1 | PA840889 | PM842534 |
| 17060000145578 | L17/dossiers | 17 | 17060000145577 | 17060000145577 | 1 | PA840889 | PM842534 |
| 17060000145585 | L17/dossiers | 17 | 17060000145584 | 17060000145584 | 1 | PA840889 | PM842534 |
| 17060000145592 | L17/dossiers | 17 | 17060000145591 | 17060000145591 | 1 | PA840889 | PM842534 |
| 17060000145599 | L17/dossiers | 17 | 17060000145598 | 17060000145598 | 1 | PA840889 | PM842534 |
| 17060000145606 | L17/dossiers | 17 | 17060000145605 | 17060000145605 | 1 | PA840889 | PM842534 |