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 |
|---|---|---|---|---|---|---|---|
| 17060000142515 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 5 | PA775180 | PM775466 |
| 17060000142516 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 6 | PA827904 | PM828514 |
| 17060000142517 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 7 | PA429845 | PM829729 |
| 17060000142518 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 8 | PA775214 | PM775498 |
| 17060000142519 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 9 | PA775224 | PM775512 |
| 17060000142520 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 10 | PA775252 | PM775558 |
| 17060000142521 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 11 | PA827968 | PM828750 |
| 17060000142522 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 12 | PA827978 | PM828730 |
| 17060000142523 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 13 | PA775272 | PM775562 |
| 17060000142524 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 14 | PA828000 | PM828850 |
| 17060000142525 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 15 | PA828004 | PM828838 |
| 17060000142526 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 16 | PA785857 | PM785867 |
| 17060000142536 | L17/dossiers | 17 | 17060000142535 | 17060000142535 | 1 | PA721166 | PM785865 |
| 17060000142543 | L17/dossiers | 17 | 17060000142542 | 17060000142542 | 1 | PA795310 | PM840453 |
| 17060000142550 | L17/dossiers | 17 | 17060000142549 | 17060000142549 | 1 | PA793354 | PM842462 |
| 17060000142561 | L17/dossiers | 17 | 17060000142560 | 17060000142560 | 1 | PA828004 | PM828838 |
| 17060000142568 | L17/dossiers | 17 | 17060000142567 | 17060000142567 | 1 | PA703513 | PM775671 |
| 17060000142575 | L17/dossiers | 17 | 17060000142574 | 17060000142574 | 1 | PA827946 | PM828614 |
| 17060000142582 | L17/dossiers | 17 | 17060000142581 | 17060000142581 | 1 | PA643210 | PM873637 |
| 17060000142583 | L17/dossiers | 17 | 17060000142581 | 17060000142581 | 2 | PA721134 | PM873687 |
| 17060000142584 | L17/dossiers | 17 | 17060000142581 | 17060000142581 | 3 | PA721670 | PM873693 |
| 17060000142645 | L17/dossiers | 17 | 17060000142644 | 17060000142644 | 1 | PA720038 | PM842921 |
| 17060000142652 | L17/dossiers | 17 | 17060000142651 | 17060000142651 | 1 | PA643210 | PM873637 |
| 17060000142696 | L17/dossiers | 17 | 17060000142695 | 17060000142695 | 1 | PA793664 | PM842549 |
| 17060000142706 | L17/dossiers | 17 | 17060000142705 | 17060000142705 | 1 | PA721764 | PM843416 |
| 17060000142721 | L17/dossiers | 17 | 17060000142720 | 17060000142720 | 1 | PA827912 | PM828488 |
| 17060000142722 | L17/dossiers | 17 | 17060000142720 | 17060000142720 | 2 | PA827962 | PM828676 |
| 17060000142723 | L17/dossiers | 17 | 17060000142720 | 17060000142720 | 3 | PA642982 | PM829146 |
| 17060000142724 | L17/dossiers | 17 | 17060000142720 | 17060000142720 | 4 | PA736191 | PM829819 |
| 17060000142725 | L17/dossiers | 17 | 17060000142720 | 17060000142720 | 5 | PA827946 | PM828614 |
| 17060000142732 | L17/dossiers | 17 | 17060000142731 | 17060000142731 | 1 | PA842013 | PM843563 |
| 17060000142736 | L17/dossiers | 17 | 17060000142735 | 17060000142735 | 1 | PA795164 | PM840444 |
| 17060000142748 | L17/dossiers | 17 | 17060000142747 | 17060000142747 | 1 | PA775182 | PM775464 |
| 17060000142755 | L17/dossiers | 17 | 17060000142754 | 17060000142754 | 1 | PA415447 | PM775785 |
| 17060000142762 | L17/dossiers | 17 | 17060000142761 | 17060000142761 | 1 | PA415447 | PM775785 |
| 17060000142797 | L17/dossiers | 17 | 17060000142796 | 17060000142796 | 1 | PA827920 | PM828574 |
| 17060000142815 | L17/dossiers | 17 | 17060000142814 | 17060000142814 | 1 | PA827994 | PM828782 |
| 17060000142822 | L17/dossiers | 17 | 17060000142821 | 17060000142821 | 1 | PA795482 | PM843605 |
| 17060000142829 | L17/dossiers | 17 | 17060000142828 | 17060000142828 | 1 | PA774954 | PM842843 |
| 17060000142836 | L17/dossiers | 17 | 17060000142835 | 17060000142835 | 1 | PA774954 | PM842843 |
| 17060000142843 | L17/dossiers | 17 | 17060000142842 | 17060000142842 | 1 | PA722000 | PM843542 |
| 17060000142850 | L17/dossiers | 17 | 17060000142849 | 17060000142849 | 1 | PA840657 | PM842333 |
| 17060000142857 | L17/dossiers | 17 | 17060000142856 | 17060000142856 | 1 | PA840673 | PM842339 |
| 17060000142864 | L17/dossiers | 17 | 17060000142863 | 17060000142863 | 1 | PA840657 | PM842333 |
| 17060000142872 | L17/dossiers | 17 | 17060000142871 | 17060000142871 | 1 | PA840657 | PM842333 |
| 17060000142879 | L17/dossiers | 17 | 17060000142878 | 17060000142878 | 1 | PA794718 | PM840348 |
| 17060000142886 | L17/dossiers | 17 | 17060000142885 | 17060000142885 | 1 | PA721764 | PM843416 |
| 17060000142908 | L17/dossiers | 17 | 17060000142907 | 17060000142907 | 1 | PA841131 | PM842735 |
| 17060000142915 | L17/dossiers | 17 | 17060000142914 | 17060000142914 | 1 | PA793532 | PM842591 |
| 17060000142922 | L17/dossiers | 17 | 17060000142921 | 17060000142921 | 1 | PA720342 | PM842999 |