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 |
|---|---|---|---|---|---|---|---|
| 17060000132662 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 2 | PA775180 | PM775466 |
| 17060000132663 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 3 | PA827904 | PM828514 |
| 17060000132664 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 4 | PA429845 | PM829729 |
| 17060000132665 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 5 | PA775214 | PM775498 |
| 17060000132666 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 6 | PA775224 | PM775512 |
| 17060000132667 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 7 | PA736177 | PM829835 |
| 17060000132668 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 8 | PA827946 | PM828614 |
| 17060000132669 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 9 | PA827950 | PM828598 |
| 17060000132670 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 10 | PA775252 | PM775558 |
| 17060000132671 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 11 | PA827968 | PM828750 |
| 17060000132672 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 12 | PA775272 | PM775562 |
| 17060000132673 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 13 | PA775282 | PM775584 |
| 17060000132674 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 14 | PA828000 | PM828850 |
| 17060000132675 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 15 | PA828004 | PM828838 |
| 17060000132676 | L17/dossiers | 17 | 17060000132660 | 17060000132660 | 16 | PA785857 | PM785867 |
| 17060000132686 | L17/dossiers | 17 | 17060000132685 | 17060000132685 | 1 | PA410 | PM855580 |
| 17060000132724 | L17/dossiers | 17 | 17060000132723 | 17060000132723 | 1 | PA267743 | PM829699 |
| 17060000132731 | L17/dossiers | 17 | 17060000132730 | 17060000132730 | 1 | PA719408 | PM775520 |
| 17060000132762 | L17/dossiers | 17 | 17060000132761 | 17060000132761 | 1 | PA721960 | PM840378 |
| 17060000132778 | L17/dossiers | 17 | 17060000132777 | 17060000132777 | 1 | PA795108 | PM843338 |
| 17060000132785 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 1 | PA736229 | PM829923 |
| 17060000132786 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 2 | PA775268 | PM775574 |
| 17060000132787 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 3 | PA702993 | PM829493 |
| 17060000132788 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 4 | PA736219 | PM829867 |
| 17060000132789 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 5 | PA827900 | PM828434 |
| 17060000132790 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 6 | PA775186 | PM775484 |
| 17060000132791 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 7 | PA415488 | PM775641 |
| 17060000132792 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 8 | PA775194 | PM775476 |
| 17060000132793 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 9 | PA775196 | PM775482 |
| 17060000132794 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 10 | PA775200 | PM775504 |
| 17060000132795 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 11 | PA642982 | PM829146 |
| 17060000132796 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 12 | PA827920 | PM828574 |
| 17060000132797 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 13 | PA775206 | PM775506 |
| 17060000132798 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 14 | PA590034 | PM775606 |
| 17060000132799 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 15 | PA827924 | PM828550 |
| 17060000132800 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 16 | PA785855 | PM785869 |
| 17060000132801 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 17 | PA736234 | PM829887 |
| 17060000132802 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 18 | PA429835 | PM829719 |
| 17060000132803 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 19 | PA775210 | PM775492 |
| 17060000132804 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 20 | PA712422 | PM828926 |
| 17060000132805 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 21 | PA827932 | PM828526 |
| 17060000132806 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 22 | PA736167 | PM829803 |
| 17060000132807 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 23 | PA732419 | PM775647 |
| 17060000132808 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 24 | PA703538 | PM775715 |
| 17060000132809 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 25 | PA429867 | PM829751 |
| 17060000132810 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 26 | PA429833 | PM829725 |
| 17060000132811 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 27 | PA827940 | PM828622 |
| 17060000132812 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 28 | PA736191 | PM829819 |
| 17060000132813 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 29 | PA708633 | PM775669 |
| 17060000132814 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 30 | PA415477 | PM775809 |