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 |
|---|---|---|---|---|---|---|---|
| 17060000135705 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 21 | PA775180 | PM775466 |
| 17060000135706 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 22 | PA429845 | PM829729 |
| 17060000135707 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 23 | PA775214 | PM775498 |
| 17060000135708 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 24 | PA775224 | PM775512 |
| 17060000135709 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 25 | PA827946 | PM828614 |
| 17060000135710 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 26 | PA827950 | PM828598 |
| 17060000135711 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 27 | PA775252 | PM775558 |
| 17060000135712 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 28 | PA827968 | PM828750 |
| 17060000135713 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 29 | PA827978 | PM828730 |
| 17060000135714 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 30 | PA775272 | PM775562 |
| 17060000135715 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 31 | PA775282 | PM775584 |
| 17060000135716 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 32 | PA828000 | PM828850 |
| 17060000135717 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 33 | PA828004 | PM828838 |
| 17060000135718 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 34 | PA785857 | PM785867 |
| 17060000135719 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 35 | PA415462 | PM775797 |
| 17060000135720 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 36 | PA643211 | PM775749 |
| 17060000135721 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 37 | PA775274 | PM775560 |
| 17060000135722 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 38 | PA775254 | PM775556 |
| 17060000135723 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 39 | PA775256 | PM775546 |
| 17060000135724 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 40 | PA775290 | PM775576 |
| 17060000135725 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 41 | PA775268 | PM775574 |
| 17060000135726 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 42 | PA610850 | PM828634 |
| 17060000135727 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 43 | PA828022 | PM828870 |
| 17060000135728 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 44 | PA607761 | PM828556 |
| 17060000135729 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 45 | PA827932 | PM828526 |
| 17060000135730 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 46 | PA775206 | PM775506 |
| 17060000135731 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 47 | PA828018 | PM828882 |
| 17060000135732 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 48 | PA827982 | PM828718 |
| 17060000135733 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 49 | PA736217 | PM829873 |
| 17060000135734 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 50 | PA736219 | PM829867 |
| 17060000135735 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 51 | PA775194 | PM775476 |
| 17060000135736 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 52 | PA712422 | PM828926 |
| 17060000135746 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 1 | PA736233 | PM829889 |
| 17060000135747 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 2 | PA2337 | PM775691 |
| 17060000135748 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 3 | PA303995 | PM775745 |
| 17060000135749 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 4 | PA827916 | PM828476 |
| 17060000135750 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 5 | PA703506 | PM777126 |
| 17060000135751 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 6 | PA719408 | PM775520 |
| 17060000135752 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 7 | PA736179 | PM829833 |
| 17060000135753 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 8 | PA760322 | PM775649 |
| 17060000135754 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 9 | PA721166 | PM785865 |
| 17060000135755 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 10 | PA775266 | PM775568 |
| 17060000135756 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 11 | PA736165 | PM829805 |
| 17060000135757 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 12 | PA267387 | PM832620 |
| 17060000135758 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 13 | PA775278 | PM775564 |
| 17060000135759 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 14 | PA849532 | PM849584 |
| 17060000135760 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 15 | PA827972 | PM828738 |
| 17060000135761 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 16 | PA775244 | PM775534 |
| 17060000135762 | L17/dossiers | 17 | 17060000135745 | 17060000135745 | 17 | PA736208 | PM829881 |
| 17060000135769 | L17/dossiers | 17 | 17060000135768 | 17060000135768 | 1 | PA795386 | PM843695 |