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 |
|---|---|---|---|---|---|---|---|
| 17060000139723 | L17/dossiers | 17 | 17060000139722 | 17060000139722 | 1 | PA720066 | PM842933 |
| 17060000139730 | L17/dossiers | 17 | 17060000139729 | 17060000139729 | 1 | PA840979 | PM842588 |
| 17060000139737 | L17/dossiers | 17 | 17060000139736 | 17060000139736 | 1 | PA817203 | PM842978 |
| 17060000139762 | L17/dossiers | 17 | 17060000139761 | 17060000139761 | 1 | PA841471 | PM843050 |
| 17060000139784 | L17/dossiers | 17 | 17060000139783 | 17060000139783 | 1 | PA794494 | PM843116 |
| 17060000139791 | L17/dossiers | 17 | 17060000139790 | 17060000139790 | 1 | PA793940 | PM842726 |
| 17060000139846 | L17/dossiers | 17 | 17060000139845 | 17060000139845 | 1 | PA817211 | PM842600 |
| 17060000139853 | L17/dossiers | 17 | 17060000139852 | 17060000139852 | 1 | PA720892 | PM840420 |
| 17060000139860 | L17/dossiers | 17 | 17060000139859 | 17060000139859 | 1 | PA795156 | PM843680 |
| 17060000139885 | L17/dossiers | 17 | 17060000139884 | 17060000139884 | 1 | PA643184 | PM843206 |
| 17060000139910 | L17/dossiers | 17 | 17060000139909 | 17060000139909 | 1 | PA346782 | PM840426 |
| 17060000139917 | L17/dossiers | 17 | 17060000139916 | 17060000139916 | 1 | PA687214 | PM843686 |
| 17060000139924 | L17/dossiers | 17 | 17060000139923 | 17060000139923 | 1 | PA796018 | PM843425 |
| 17060000139931 | L17/dossiers | 17 | 17060000139930 | 17060000139930 | 1 | PA793548 | PM842606 |
| 17060000139938 | L17/dossiers | 17 | 17060000139937 | 17060000139937 | 1 | PA719436 | PM840279 |
| 17060000139945 | L17/dossiers | 17 | 17060000139944 | 17060000139944 | 1 | PA721202 | PM840435 |
| 17060000139952 | L17/dossiers | 17 | 17060000139951 | 17060000139951 | 1 | PA719024 | PM842390 |
| 17060000139959 | L17/dossiers | 17 | 17060000139958 | 17060000139958 | 1 | PA721474 | PM843608 |
| 17060000139966 | L17/dossiers | 17 | 17060000139965 | 17060000139965 | 1 | PA607395 | PM843077 |
| 17060000139973 | L17/dossiers | 17 | 17060000139972 | 17060000139972 | 1 | PA267042 | PM843044 |
| 17060000139980 | L17/dossiers | 17 | 17060000139979 | 17060000139979 | 1 | PA794486 | PM843110 |
| 17060000139987 | L17/dossiers | 17 | 17060000139986 | 17060000139986 | 1 | PA795430 | PM843602 |
| 17060000139994 | L17/dossiers | 17 | 17060000139993 | 17060000139993 | 1 | PA330240 | PM842357 |
| 17060000140001 | L17/dossiers | 17 | 17060000140000 | 17060000140000 | 1 | PA719778 | PM842744 |
| 17060000140008 | L17/dossiers | 17 | 17060000140007 | 17060000140007 | 1 | PA642847 | PM843056 |
| 17060000140015 | L17/dossiers | 17 | 17060000140014 | 17060000140014 | 1 | PA795722 | PM843488 |
| 17060000140022 | L17/dossiers | 17 | 17060000140021 | 17060000140021 | 1 | PA720976 | PM843764 |
| 17060000140045 | L17/dossiers | 17 | 17060000140044 | 17060000140044 | 1 | PA719798 | PM842753 |
| 17060000140052 | L17/dossiers | 17 | 17060000140051 | 17060000140051 | 1 | PA793342 | PM842345 |
| 17060000140059 | L17/dossiers | 17 | 17060000140058 | 17060000140058 | 1 | PA840657 | PM842333 |
| 17060000140066 | L17/dossiers | 17 | 17060000140065 | 17060000140065 | 1 | PA840657 | PM842333 |
| 17060000140073 | L17/dossiers | 17 | 17060000140072 | 17060000140072 | 1 | PA340343 | PM842351 |
| 17060000140080 | L17/dossiers | 17 | 17060000140079 | 17060000140079 | 1 | PA721486 | PM843614 |
| 17060000140087 | L17/dossiers | 17 | 17060000140086 | 17060000140086 | 1 | PA718884 | PM842420 |
| 17060000140094 | L17/dossiers | 17 | 17060000140093 | 17060000140093 | 1 | PA718884 | PM842420 |
| 17060000140101 | L17/dossiers | 17 | 17060000140100 | 17060000140100 | 1 | PA794678 | PM840312 |
| 17060000140115 | L17/dossiers | 17 | 17060000140114 | 17060000140114 | 1 | PA840159 | PM840345 |
| 17060000140128 | L17/dossiers | 17 | 17060000140127 | 17060000140127 | 1 | PA722142 | PM843500 |
| 17060000140135 | L17/dossiers | 17 | 17060000140134 | 17060000140134 | 1 | PA722150 | PM843590 |
| 17060000140142 | L17/dossiers | 17 | 17060000140141 | 17060000140141 | 1 | PA718784 | PM842342 |
| 17060000140149 | L17/dossiers | 17 | 17060000140148 | 17060000140148 | 1 | PA842263 | PM843773 |
| 17060000140193 | L17/dossiers | 17 | 17060000140192 | 17060000140192 | 1 | PA774960 | PM840417 |
| 17060000140201 | L17/dossiers | 17 | 17060000140200 | 17060000140200 | 1 | PA841681 | PM843245 |
| 17060000140209 | L17/dossiers | 17 | 17060000140208 | 17060000140208 | 1 | PA793736 | PM842693 |
| 17060000140216 | L17/dossiers | 17 | 17060000140215 | 17060000140215 | 1 | PA610654 | PM843719 |
| 17060000140224 | L17/dossiers | 17 | 17060000140223 | 17060000140223 | 1 | PA793736 | PM842693 |
| 17060000140231 | L17/dossiers | 17 | 17060000140230 | 17060000140230 | 1 | PA794354 | PM842960 |
| 17060000140249 | L17/dossiers | 17 | 17060000140248 | 17060000140248 | 1 | PA794042 | PM858577 |
| 17060000140256 | L17/dossiers | 17 | 17060000140255 | 17060000140255 | 1 | PA774962 | PM843731 |
| 17060000140263 | L17/dossiers | 17 | 17060000140262 | 17060000140262 | 1 | PA840903 | PM842543 |