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 |
|---|---|---|---|---|---|---|---|
| 17060000145613 | L17/dossiers | 17 | 17060000145612 | 17060000145612 | 1 | PA840889 | PM842534 |
| 17060000145620 | L17/dossiers | 17 | 17060000145619 | 17060000145619 | 1 | PA840889 | PM842534 |
| 17060000145627 | L17/dossiers | 17 | 17060000145626 | 17060000145626 | 1 | PA840889 | PM842534 |
| 17060000145634 | L17/dossiers | 17 | 17060000145633 | 17060000145633 | 1 | PA840889 | PM842534 |
| 17060000145641 | L17/dossiers | 17 | 17060000145640 | 17060000145640 | 1 | PA719024 | PM842390 |
| 17060000145664 | L17/dossiers | 17 | 17060000145663 | 17060000145663 | 1 | PA721486 | PM843614 |
| 17060000145671 | L17/dossiers | 17 | 17060000145670 | 17060000145670 | 1 | PA721486 | PM843614 |
| 17060000145678 | L17/dossiers | 17 | 17060000145677 | 17060000145677 | 1 | PA841327 | PM842915 |
| 17060000145685 | L17/dossiers | 17 | 17060000145684 | 17060000145684 | 1 | PA793322 | PM840246 |
| 17060000145693 | L17/dossiers | 17 | 17060000145692 | 17060000145692 | 1 | PA608016 | PM874599 |
| 17060000145700 | L17/dossiers | 17 | 17060000145699 | 17060000145699 | 1 | PA608826 | PM843365 |
| 17060000145707 | L17/dossiers | 17 | 17060000145706 | 17060000145706 | 1 | PA841769 | PM843323 |
| 17060000145714 | L17/dossiers | 17 | 17060000145713 | 17060000145713 | 1 | PA841243 | PM842825 |
| 17060000145721 | L17/dossiers | 17 | 17060000145720 | 17060000145720 | 1 | PA841451 | PM843035 |
| 17060000145728 | L17/dossiers | 17 | 17060000145727 | 17060000145727 | 1 | PA793736 | PM842693 |
| 17060000145735 | L17/dossiers | 17 | 17060000145734 | 17060000145734 | 1 | PA793322 | PM840246 |
| 17060000145745 | L17/dossiers | 17 | 17060000145744 | 17060000145744 | 1 | PA840721 | PM842378 |
| 17060000145749 | L17/dossiers | 17 | 17060000145748 | 17060000145748 | 1 | PA643210 | PM873637 |
| 17060000145760 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 1 | PA736205 | PM829851 |
| 17060000145761 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 2 | PA267340 | PM775731 |
| 17060000145762 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 3 | PA702993 | PM829493 |
| 17060000145763 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 4 | PA429832 | PM829723 |
| 17060000145764 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 5 | PA2042 | PM775815 |
| 17060000145765 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 6 | PA2337 | PM775691 |
| 17060000145766 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 7 | PA429886 | PM829757 |
| 17060000145767 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 8 | PA736190 | PM829825 |
| 17060000145768 | L17/dossiers | 17 | 17060000145759 | 17060000145759 | 9 | PA736177 | PM829835 |
| 17060000145798 | L17/dossiers | 17 | 17060000145797 | 17060000145797 | 1 | PA736179 | PM829833 |
| 17060000145805 | L17/dossiers | 17 | 17060000145804 | 17060000145804 | 1 | PA720952 | PM843755 |
| 17060000145824 | L17/dossiers | 17 | 17060000145823 | 17060000145823 | 1 | PA942 | PM842987 |
| 17060000145836 | L17/dossiers | 17 | 17060000145835 | 17060000145835 | 1 | PA736218 | PM829869 |
| 17060000145837 | L17/dossiers | 17 | 17060000145835 | 17060000145835 | 2 | PA736224 | PM829913 |
| 17060000145838 | L17/dossiers | 17 | 17060000145835 | 17060000145835 | 3 | PA827960 | PM828664 |
| 17060000145839 | L17/dossiers | 17 | 17060000145835 | 17060000145835 | 4 | PA760322 | PM775649 |
| 17060000145840 | L17/dossiers | 17 | 17060000145835 | 17060000145835 | 5 | PA703528 | PM775693 |
| 17060000145847 | L17/dossiers | 17 | 17060000145846 | 17060000145846 | 1 | PA775276 | PM775566 |
| 17060000145848 | L17/dossiers | 17 | 17060000145846 | 17060000145846 | 2 | PA267340 | PM775731 |
| 17060000145849 | L17/dossiers | 17 | 17060000145846 | 17060000145846 | 3 | PA736211 | PM829879 |
| 17060000145869 | L17/dossiers | 17 | 17060000145868 | 17060000145868 | 1 | PA720154 | PM842852 |
| 17060000145873 | L17/dossiers | 17 | 17060000145872 | 17060000145872 | 1 | PA793322 | PM840246 |
| 17060000145880 | L17/dossiers | 17 | 17060000145879 | 17060000145879 | 1 | PA642988 | PM840414 |
| 17060000145887 | L17/dossiers | 17 | 17060000145886 | 17060000145886 | 1 | PA794082 | PM842810 |
| 17060000145908 | L17/dossiers | 17 | 17060000145907 | 17060000145907 | 1 | PA643210 | PM873637 |
| 17060000145933 | L17/dossiers | 17 | 17060000145932 | 17060000145932 | 1 | PA719640 | PM842831 |
| 17060000145940 | L17/dossiers | 17 | 17060000145939 | 17060000145939 | 1 | PA795900 | PM843524 |
| 17060000145947 | L17/dossiers | 17 | 17060000145946 | 17060000145946 | 1 | PA795900 | PM843524 |
| 17060000145954 | L17/dossiers | 17 | 17060000145953 | 17060000145953 | 1 | PA795362 | PM843587 |
| 17060000145961 | L17/dossiers | 17 | 17060000145960 | 17060000145960 | 1 | PA721474 | PM843608 |
| 17060000145968 | L17/dossiers | 17 | 17060000145967 | 17060000145967 | 1 | PA721474 | PM843608 |
| 17060000145975 | L17/dossiers | 17 | 17060000145974 | 17060000145974 | 1 | PA721474 | PM843608 |