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 |
|---|---|---|---|---|---|---|---|
| 15060000178481 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 15 | PA775296 | PM775596 |
| 15060000178488 | L15/dossiers | 15 | 15060000178487 | 15060000178487 | 1 | PA382672 | PM736263 |
| 15060000178495 | L15/dossiers | 15 | 15060000178494 | 15060000178494 | 1 | PA776985 | PM777700 |
| 15060000178502 | L15/dossiers | 15 | 15060000178501 | 15060000178501 | 1 | PA773441 | PM773491 |
| 15060000178509 | L15/dossiers | 15 | 15060000178508 | 15060000178508 | 1 | PA643089 | PM758076 |
| 15060000178516 | L15/dossiers | 15 | 15060000178515 | 15060000178515 | 1 | PA720952 | PM723122 |
| 15060000178523 | L15/dossiers | 15 | 15060000178522 | 15060000178522 | 1 | PA719448 | PM722666 |
| 15060000178530 | L15/dossiers | 15 | 15060000178529 | 15060000178529 | 1 | PA712015 | PM722448 |
| 15060000178540 | L15/dossiers | 15 | 15060000178539 | 15060000178539 | 1 | PA721896 | PM723414 |
| 15060000178547 | L15/dossiers | 15 | 15060000178546 | 15060000178546 | 1 | PA736187 | PM736365 |
| 15060000178554 | L15/dossiers | 15 | 15060000178553 | 15060000178553 | 1 | PA643211 | PM775749 |
| 15060000178561 | L15/dossiers | 15 | 15060000178560 | 15060000178560 | 1 | PA703530 | PM775689 |
| 15060000178574 | L15/dossiers | 15 | 15060000178573 | 15060000178573 | 1 | PA773441 | PM773491 |
| 15060000178575 | L15/dossiers | 15 | 15060000178573 | 15060000178573 | 2 | PA331481 | PM773459 |
| 15060000178576 | L15/dossiers | 15 | 15060000178573 | 15060000178573 | 3 | PA330357 | PM773447 |
| 15060000178626 | L15/dossiers | 15 | 15060000178625 | 15060000178625 | 1 | PA773441 | PM773491 |
| 15060000178627 | L15/dossiers | 15 | 15060000178625 | 15060000178625 | 2 | PA1872 | PM773455 |
| 15060000178659 | L15/dossiers | 15 | 15060000178658 | 15060000178658 | 1 | PA773441 | PM773491 |
| 15060000178666 | L15/dossiers | 15 | 15060000178665 | 15060000178665 | 1 | PA773441 | PM773491 |
| 15060000178676 | L15/dossiers | 15 | 15060000178675 | 15060000178675 | 1 | PA719822 | PM722772 |
| 15060000178686 | L15/dossiers | 15 | 15060000178685 | 15060000178685 | 1 | PA266788 | PM722914 |
| 15060000178693 | L15/dossiers | 15 | 15060000178692 | 15060000178692 | 1 | PA721486 | PM723290 |
| 15060000178700 | L15/dossiers | 15 | 15060000178699 | 15060000178699 | 1 | PA721816 | PM748964 |
| 15060000178710 | L15/dossiers | 15 | 15060000178709 | 15060000178709 | 1 | PA719024 | PM722536 |
| 15060000178717 | L15/dossiers | 15 | 15060000178716 | 15060000178716 | 1 | PA718838 | PM722474 |
| 15060000178725 | L15/dossiers | 15 | 15060000178724 | 15060000178724 | 1 | PA643134 | PM722824 |
| 15060000178729 | L15/dossiers | 15 | 15060000178728 | 15060000178728 | 1 | PA382672 | PM736263 |
| 15060000178760 | L15/dossiers | 15 | 15060000178759 | 15060000178759 | 1 | PA223837 | PM722458 |
| 15060000178764 | L15/dossiers | 15 | 15060000178763 | 15060000178763 | 1 | PA720214 | PM722894 |
| 15060000178771 | L15/dossiers | 15 | 15060000178770 | 15060000178770 | 1 | PA773441 | PM773491 |
| 15060000178772 | L15/dossiers | 15 | 15060000178770 | 15060000178770 | 2 | PA1872 | PM773455 |
| 15060000178794 | L15/dossiers | 15 | 15060000178793 | 15060000178793 | 1 | PA719318 | PM722624 |
| 15060000178801 | L15/dossiers | 15 | 15060000178800 | 15060000178800 | 1 | PA773441 | PM773491 |
| 15060000178824 | L15/dossiers | 15 | 15060000178823 | 15060000178823 | 1 | PA775284 | PM775590 |
| 15060000178831 | L15/dossiers | 15 | 15060000178830 | 15060000178830 | 1 | PA709315 | PM722526 |
| 15060000178838 | L15/dossiers | 15 | 15060000178837 | 15060000178837 | 1 | PA709315 | PM722526 |
| 15060000178845 | L15/dossiers | 15 | 15060000178844 | 15060000178844 | 1 | PA718884 | PM722488 |
| 15060000178852 | L15/dossiers | 15 | 15060000178851 | 15060000178851 | 1 | PA709315 | PM722526 |
| 15060000178859 | L15/dossiers | 15 | 15060000178858 | 15060000178858 | 1 | PA722046 | PM723458 |
| 15060000178869 | L15/dossiers | 15 | 15060000178868 | 15060000178868 | 1 | PA331835 | PM722688 |
| 15060000178876 | L15/dossiers | 15 | 15060000178875 | 15060000178875 | 1 | PA718926 | PM722502 |
| 15060000178883 | L15/dossiers | 15 | 15060000178882 | 15060000178882 | 1 | PA720916 | PM723112 |
| 15060000178890 | L15/dossiers | 15 | 15060000178889 | 15060000178889 | 1 | PA720916 | PM723112 |
| 15060000178897 | L15/dossiers | 15 | 15060000178896 | 15060000178896 | 1 | PA2377 | PM723550 |
| 15060000178904 | L15/dossiers | 15 | 15060000178903 | 15060000178903 | 1 | PA720468 | PM722972 |
| 15060000178911 | L15/dossiers | 15 | 15060000178910 | 15060000178910 | 1 | PA721932 | PM734586 |
| 15060000178915 | L15/dossiers | 15 | 15060000178914 | 15060000178914 | 1 | PA267673 | PM775865 |
| 15060000178922 | L15/dossiers | 15 | 15060000178921 | 15060000178921 | 1 | PA773441 | PM773491 |
| 15060000178923 | L15/dossiers | 15 | 15060000178921 | 15060000178921 | 2 | PA642788 | PM773495 |
| 15060000178924 | L15/dossiers | 15 | 15060000178921 | 15060000178921 | 3 | PA722086 | PM774107 |