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 |
|---|---|---|---|---|---|---|---|
| 17060000136664 | L17/dossiers | 17 | 17060000136661 | 17060000136661 | 3 | PA828002 | PM828856 |
| 17060000136665 | L17/dossiers | 17 | 17060000136661 | 17060000136661 | 4 | PA785857 | PM785867 |
| 17060000136684 | L17/dossiers | 17 | 17060000136683 | 17060000136683 | 1 | PA721442 | PM843362 |
| 17060000136688 | L17/dossiers | 17 | 17060000136687 | 17060000136687 | 1 | PA341381 | PM775747 |
| 17060000136695 | L17/dossiers | 17 | 17060000136694 | 17060000136694 | 1 | PA827950 | PM828598 |
| 17060000136705 | L17/dossiers | 17 | 17060000136704 | 17060000136704 | 1 | PA827912 | PM828488 |
| 17060000136706 | L17/dossiers | 17 | 17060000136704 | 17060000136704 | 2 | PA827962 | PM828676 |
| 17060000136707 | L17/dossiers | 17 | 17060000136704 | 17060000136704 | 3 | PA827946 | PM828614 |
| 17060000136720 | L17/dossiers | 17 | 17060000136719 | 17060000136719 | 1 | PA721960 | PM840378 |
| 17060000136724 | L17/dossiers | 17 | 17060000136723 | 17060000136723 | 1 | PA794938 | PM843308 |
| 17060000136743 | L17/dossiers | 17 | 17060000136742 | 17060000136742 | 1 | PA720838 | PM843671 |
| 17060000136750 | L17/dossiers | 17 | 17060000136749 | 17060000136749 | 1 | PA842187 | PM843704 |
| 17060000136757 | L17/dossiers | 17 | 17060000136756 | 17060000136756 | 1 | PA794008 | PM842768 |
| 17060000136764 | L17/dossiers | 17 | 17060000136763 | 17060000136763 | 1 | PA330240 | PM842357 |
| 17060000136777 | L17/dossiers | 17 | 17060000136776 | 17060000136776 | 1 | PA330684 | PM775859 |
| 17060000136784 | L17/dossiers | 17 | 17060000136783 | 17060000136783 | 1 | PA775248 | PM775554 |
| 17060000136791 | L17/dossiers | 17 | 17060000136790 | 17060000136790 | 1 | PA410 | PM855580 |
| 17060000136822 | L17/dossiers | 17 | 17060000136821 | 17060000136821 | 1 | PA719408 | PM775520 |
| 17060000136823 | L17/dossiers | 17 | 17060000136821 | 17060000136821 | 2 | PA775252 | PM775558 |
| 17060000136824 | L17/dossiers | 17 | 17060000136821 | 17060000136821 | 3 | PA642982 | PM829146 |
| 17060000136825 | L17/dossiers | 17 | 17060000136821 | 17060000136821 | 4 | PA703512 | PM775665 |
| 17060000136832 | L17/dossiers | 17 | 17060000136831 | 17060000136831 | 1 | PA842187 | PM843704 |
| 17060000136839 | L17/dossiers | 17 | 17060000136838 | 17060000136838 | 1 | PA721202 | PM840435 |
| 17060000136846 | L17/dossiers | 17 | 17060000136845 | 17060000136845 | 1 | PA795552 | PM840408 |
| 17060000136850 | L17/dossiers | 17 | 17060000136849 | 17060000136849 | 1 | PA827922 | PM856930 |
| 17060000136857 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 1 | PA736219 | PM829867 |
| 17060000136858 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 2 | PA702993 | PM829493 |
| 17060000136859 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 3 | PA643211 | PM775749 |
| 17060000136860 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 4 | PA775256 | PM775546 |
| 17060000136861 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 5 | PA775194 | PM775476 |
| 17060000136862 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 6 | PA775206 | PM775506 |
| 17060000136863 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 7 | PA775254 | PM775556 |
| 17060000136864 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 8 | PA775268 | PM775574 |
| 17060000136865 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 9 | PA775274 | PM775560 |
| 17060000136866 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 10 | PA775290 | PM775576 |
| 17060000136867 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 11 | PA736217 | PM829873 |
| 17060000136868 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 12 | PA828022 | PM828870 |
| 17060000136869 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 13 | PA827900 | PM828434 |
| 17060000136870 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 14 | PA775186 | PM775484 |
| 17060000136871 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 15 | PA415488 | PM775641 |
| 17060000136872 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 16 | PA775196 | PM775482 |
| 17060000136873 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 17 | PA775200 | PM775504 |
| 17060000136874 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 18 | PA642982 | PM829146 |
| 17060000136875 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 19 | PA827920 | PM828574 |
| 17060000136876 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 20 | PA590034 | PM775606 |
| 17060000136877 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 21 | PA827924 | PM828550 |
| 17060000136878 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 22 | PA785855 | PM785869 |
| 17060000136879 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 23 | PA736234 | PM829887 |
| 17060000136880 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 24 | PA429835 | PM829719 |
| 17060000136881 | L17/dossiers | 17 | 17060000136856 | 17060000136856 | 25 | PA429835 | PM829719 |