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 |
|---|---|---|---|---|---|---|---|
| 17060000126329 | L17/dossiers | 17 | 17060000126328 | 17060000126328 | 1 | PA794118 | PM842894 |
| 17060000126342 | L17/dossiers | 17 | 17060000126341 | 17060000126341 | 1 | PA794118 | PM842894 |
| 17060000126349 | L17/dossiers | 17 | 17060000126348 | 17060000126348 | 1 | PA794118 | PM842894 |
| 17060000126356 | L17/dossiers | 17 | 17060000126355 | 17060000126355 | 1 | PA794118 | PM842894 |
| 17060000126363 | L17/dossiers | 17 | 17060000126362 | 17060000126362 | 1 | PA795982 | PM840432 |
| 17060000126371 | L17/dossiers | 17 | 17060000126370 | 17060000126370 | 1 | PA840979 | PM842588 |
| 17060000126378 | L17/dossiers | 17 | 17060000126377 | 17060000126377 | 1 | PA720892 | PM840420 |
| 17060000126385 | L17/dossiers | 17 | 17060000126384 | 17060000126384 | 1 | PA267780 | PM843395 |
| 17060000126408 | L17/dossiers | 17 | 17060000126407 | 17060000126407 | 1 | PA718784 | PM842342 |
| 17060000126415 | L17/dossiers | 17 | 17060000126414 | 17060000126414 | 1 | PA794486 | PM843110 |
| 17060000126422 | L17/dossiers | 17 | 17060000126421 | 17060000126421 | 1 | PA722046 | PM843482 |
| 17060000126459 | L17/dossiers | 17 | 17060000126458 | 17060000126458 | 1 | PA794178 | PM842897 |
| 17060000126466 | L17/dossiers | 17 | 17060000126465 | 17060000126465 | 1 | PA720386 | PM843020 |
| 17060000126473 | L17/dossiers | 17 | 17060000126472 | 17060000126472 | 1 | PA718850 | PM842411 |
| 17060000126480 | L17/dossiers | 17 | 17060000126479 | 17060000126479 | 1 | PA342240 | PM842819 |
| 17060000126487 | L17/dossiers | 17 | 17060000126486 | 17060000126486 | 1 | PA608826 | PM843365 |
| 17060000126494 | L17/dossiers | 17 | 17060000126493 | 17060000126493 | 1 | PA774962 | PM843731 |
| 17060000126501 | L17/dossiers | 17 | 17060000126500 | 17060000126500 | 1 | PA774954 | PM842843 |
| 17060000126508 | L17/dossiers | 17 | 17060000126507 | 17060000126507 | 1 | PA267794 | PM842348 |
| 17060000126518 | L17/dossiers | 17 | 17060000126517 | 17060000126517 | 1 | PA793780 | PM842714 |
| 17060000126525 | L17/dossiers | 17 | 17060000126524 | 17060000126524 | 1 | PA720370 | PM843014 |
| 17060000126532 | L17/dossiers | 17 | 17060000126531 | 17060000126531 | 1 | PA720386 | PM843020 |
| 17060000126543 | L17/dossiers | 17 | 17060000126542 | 17060000126542 | 1 | PA333285 | PM843038 |
| 17060000126550 | L17/dossiers | 17 | 17060000126549 | 17060000126549 | 1 | PA793736 | PM842693 |
| 17060000126557 | L17/dossiers | 17 | 17060000126556 | 17060000126556 | 1 | PA722390 | PM843317 |
| 17060000126564 | L17/dossiers | 17 | 17060000126563 | 17060000126563 | 1 | PA695512 | PM842963 |
| 17060000126571 | L17/dossiers | 17 | 17060000126570 | 17060000126570 | 1 | PA642847 | PM843056 |
| 17060000126586 | L17/dossiers | 17 | 17060000126585 | 17060000126585 | 1 | PA794486 | PM843110 |
| 17060000126593 | L17/dossiers | 17 | 17060000126592 | 17060000126592 | 1 | PA608016 | PM843155 |
| 17060000126606 | L17/dossiers | 17 | 17060000126605 | 17060000126605 | 1 | PA722390 | PM843317 |
| 17060000126613 | L17/dossiers | 17 | 17060000126612 | 17060000126612 | 1 | PA718784 | PM842342 |
| 17060000126638 | L17/dossiers | 17 | 17060000126637 | 17060000126637 | 1 | PA794038 | PM842783 |
| 17060000126645 | L17/dossiers | 17 | 17060000126644 | 17060000126644 | 1 | PA266797 | PM843071 |
| 17060000126701 | L17/dossiers | 17 | 17060000126700 | 17060000126700 | 1 | PA793174 | PM842384 |
| 17060000126708 | L17/dossiers | 17 | 17060000126707 | 17060000126707 | 1 | PA266797 | PM843071 |
| 17060000126715 | L17/dossiers | 17 | 17060000126714 | 17060000126714 | 1 | PA795636 | PM843476 |
| 17060000126722 | L17/dossiers | 17 | 17060000126721 | 17060000126721 | 1 | PA794906 | PM843284 |
| 17060000126732 | L17/dossiers | 17 | 17060000126731 | 17060000126731 | 1 | PA703538 | PM775715 |
| 17060000126749 | L17/dossiers | 17 | 17060000126748 | 17060000126748 | 1 | PA720908 | PM843701 |
| 17060000126774 | L17/dossiers | 17 | 17060000126773 | 17060000126773 | 1 | PA736192 | PM829859 |
| 17060000126810 | L17/dossiers | 17 | 17060000126809 | 17060000126809 | 1 | PA642847 | PM843056 |
| 17060000126817 | L17/dossiers | 17 | 17060000126816 | 17060000126816 | 1 | PA721474 | PM843608 |
| 17060000126824 | L17/dossiers | 17 | 17060000126823 | 17060000126823 | 1 | PA827926 | PM828562 |
| 17060000126825 | L17/dossiers | 17 | 17060000126823 | 17060000126823 | 2 | PA267512 | PM775817 |
| 17060000126826 | L17/dossiers | 17 | 17060000126823 | 17060000126823 | 3 | PA775300 | PM775600 |
| 17060000126827 | L17/dossiers | 17 | 17060000126823 | 17060000126823 | 4 | PA736174 | PM829797 |
| 17060000126828 | L17/dossiers | 17 | 17060000126823 | 17060000126823 | 5 | PA827960 | PM828664 |
| 17060000126829 | L17/dossiers | 17 | 17060000126823 | 17060000126823 | 6 | PA736196 | PM829865 |
| 17060000126830 | L17/dossiers | 17 | 17060000126823 | 17060000126823 | 7 | PA827910 | PM828508 |
| 17060000126837 | L17/dossiers | 17 | 17060000126836 | 17060000126836 | 1 | PA775300 | PM775600 |