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 |
|---|---|---|---|---|---|---|---|
| 17060000130785 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 39 | PA736246 | PM775819 |
| 17060000130786 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 40 | PA267112 | PM775737 |
| 17060000130787 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 41 | PA736202 | PM775775 |
| 17060000130788 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 42 | PA304085 | PM829871 |
| 17060000130789 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 43 | PA736200 | PM829845 |
| 17060000130790 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 44 | PA415447 | PM775785 |
| 17060000130791 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 45 | PA775270 | PM775572 |
| 17060000130792 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 46 | PA703493 | PM775659 |
| 17060000130793 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 47 | PA775228 | PM775516 |
| 17060000130794 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 48 | PA313924 | PM775727 |
| 17060000130795 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 49 | PA775248 | PM775554 |
| 17060000130796 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 50 | PA775240 | PM775530 |
| 17060000130797 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 51 | PA827984 | PM828800 |
| 17060000130798 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 52 | PA775286 | PM775588 |
| 17060000130799 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 53 | PA736169 | PM829791 |
| 17060000130800 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 54 | PA703522 | PM775701 |
| 17060000130801 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 55 | PA775302 | PM775598 |
| 17060000130802 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 56 | PA836345 | PM836353 |
| 17060000130803 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 57 | PA775168 | PM775470 |
| 17060000130804 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 58 | PA703517 | PM775675 |
| 17060000130805 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 59 | PA827976 | PM828724 |
| 17060000130806 | L17/dossiers | 17 | 17060000130746 | 17060000130746 | 60 | PA736218 | PM829869 |
| 17060000130813 | L17/dossiers | 17 | 17060000130812 | 17060000130812 | 1 | PA267285 | PM842900 |
| 17060000130818 | L17/dossiers | 17 | 17060000130817 | 17060000130817 | 1 | PA719408 | PM775520 |
| 17060000130819 | L17/dossiers | 17 | 17060000130817 | 17060000130817 | 2 | PA703514 | PM775661 |
| 17060000130820 | L17/dossiers | 17 | 17060000130817 | 17060000130817 | 3 | PA827906 | PM828520 |
| 17060000130851 | L17/dossiers | 17 | 17060000130850 | 17060000130850 | 1 | PA643211 | PM775749 |
| 17060000130858 | L17/dossiers | 17 | 17060000130857 | 17060000130857 | 1 | PA840829 | PM842492 |
| 17060000130865 | L17/dossiers | 17 | 17060000130864 | 17060000130864 | 1 | PA720162 | PM843068 |
| 17060000130883 | L17/dossiers | 17 | 17060000130882 | 17060000130882 | 1 | PA2197 | PM775755 |
| 17060000130904 | L17/dossiers | 17 | 17060000130903 | 17060000130903 | 1 | PA410 | PM855580 |
| 17060000130905 | L17/dossiers | 17 | 17060000130903 | 17060000130903 | 2 | PA721836 | PM855144 |
| 17060000130937 | L17/dossiers | 17 | 17060000130936 | 17060000130936 | 1 | PA736225 | PM829907 |
| 17060000130938 | L17/dossiers | 17 | 17060000130936 | 17060000130936 | 2 | PA736191 | PM829819 |
| 17060000130945 | L17/dossiers | 17 | 17060000130944 | 17060000130944 | 1 | PA827910 | PM828508 |
| 17060000130952 | L17/dossiers | 17 | 17060000130951 | 17060000130951 | 1 | PA736229 | PM829923 |
| 17060000130959 | L17/dossiers | 17 | 17060000130958 | 17060000130958 | 1 | PA795746 | PM843584 |
| 17060000130966 | L17/dossiers | 17 | 17060000130965 | 17060000130965 | 1 | PA795046 | PM843818 |
| 17060000130974 | L17/dossiers | 17 | 17060000130973 | 17060000130973 | 1 | PA849534 | PM849592 |
| 17060000130975 | L17/dossiers | 17 | 17060000130973 | 17060000130973 | 2 | PA343988 | PM829809 |
| 17060000130982 | L17/dossiers | 17 | 17060000130981 | 17060000130981 | 1 | PA793780 | PM842714 |
| 17060000130986 | L17/dossiers | 17 | 17060000130985 | 17060000130985 | 1 | PA795076 | PM840366 |
| 17060000131008 | L17/dossiers | 17 | 17060000131007 | 17060000131007 | 1 | PA795350 | PM843410 |
| 17060000131029 | L17/dossiers | 17 | 17060000131028 | 17060000131028 | 1 | PA841701 | PM843269 |
| 17060000131036 | L17/dossiers | 17 | 17060000131035 | 17060000131035 | 1 | PA791812 | PM840384 |
| 17060000131043 | L17/dossiers | 17 | 17060000131042 | 17060000131042 | 1 | PA774962 | PM843731 |
| 17060000131050 | L17/dossiers | 17 | 17060000131049 | 17060000131049 | 1 | PA795876 | PM843725 |
| 17060000131067 | L17/dossiers | 17 | 17060000131066 | 17060000131066 | 1 | PA775206 | PM775506 |
| 17060000131074 | L17/dossiers | 17 | 17060000131073 | 17060000131073 | 1 | PA841761 | PM843320 |
| 17060000131078 | L17/dossiers | 17 | 17060000131077 | 17060000131077 | 1 | PA795076 | PM840366 |