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 |
|---|---|---|---|---|---|---|---|
| 17060000130024 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 32 | PA732419 | PM775647 |
| 17060000130025 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 33 | PA703538 | PM775715 |
| 17060000130026 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 34 | PA429867 | PM829751 |
| 17060000130027 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 35 | PA429833 | PM829725 |
| 17060000130028 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 36 | PA827940 | PM828622 |
| 17060000130029 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 37 | PA736191 | PM829819 |
| 17060000130030 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 38 | PA708633 | PM775669 |
| 17060000130031 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 39 | PA766947 | PM775799 |
| 17060000130032 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 40 | PA736241 | PM829931 |
| 17060000130033 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 41 | PA703509 | PM775687 |
| 17060000130034 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 42 | PA736225 | PM829907 |
| 17060000130035 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 43 | PA703536 | PM775719 |
| 17060000130036 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 44 | PA607761 | PM828556 |
| 17060000130037 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 45 | PA415449 | PM775793 |
| 17060000130038 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 46 | PA342564 | PM829509 |
| 17060000130039 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 47 | PA268048 | PM829731 |
| 17060000130040 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 48 | PA2074 | PM775677 |
| 17060000130041 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 49 | PA775254 | PM775556 |
| 17060000130042 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 50 | PA775256 | PM775546 |
| 17060000130043 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 51 | PA643211 | PM775749 |
| 17060000130044 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 52 | PA610850 | PM828634 |
| 17060000130045 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 53 | PA827980 | PM828710 |
| 17060000130046 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 54 | PA827982 | PM828718 |
| 17060000130047 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 55 | PA703505 | PM775679 |
| 17060000130048 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 56 | PA775274 | PM775560 |
| 17060000130049 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 57 | PA703511 | PM775685 |
| 17060000130050 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 58 | PA827994 | PM828782 |
| 17060000130051 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 59 | PA775290 | PM775576 |
| 17060000130052 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 60 | PA736214 | PM829883 |
| 17060000130053 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 61 | PA736217 | PM829873 |
| 17060000130054 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 62 | PA828010 | PM828832 |
| 17060000130055 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 63 | PA828014 | PM828818 |
| 17060000130056 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 64 | PA828018 | PM828882 |
| 17060000130057 | L17/dossiers | 17 | 17060000129992 | 17060000129992 | 65 | PA828022 | PM828870 |
| 17060000130064 | L17/dossiers | 17 | 17060000130063 | 17060000130063 | 1 | PA1828 | PM829747 |
| 17060000130065 | L17/dossiers | 17 | 17060000130063 | 17060000130063 | 2 | PA736158 | PM829783 |
| 17060000130072 | L17/dossiers | 17 | 17060000130071 | 17060000130071 | 1 | PA1828 | PM829747 |
| 17060000130073 | L17/dossiers | 17 | 17060000130071 | 17060000130071 | 2 | PA736158 | PM829783 |
| 17060000130080 | L17/dossiers | 17 | 17060000130079 | 17060000130079 | 1 | PA607761 | PM828556 |
| 17060000130087 | L17/dossiers | 17 | 17060000130086 | 17060000130086 | 1 | PA841419 | PM843005 |
| 17060000130091 | L17/dossiers | 17 | 17060000130090 | 17060000130090 | 1 | PA720846 | PM840441 |
| 17060000130099 | L17/dossiers | 17 | 17060000130098 | 17060000130098 | 1 | PA793166 | PM840261 |
| 17060000130106 | L17/dossiers | 17 | 17060000130105 | 17060000130105 | 1 | PA793342 | PM842345 |
| 17060000130113 | L17/dossiers | 17 | 17060000130112 | 17060000130112 | 1 | PA609332 | PM840396 |
| 17060000130137 | L17/dossiers | 17 | 17060000130136 | 17060000130136 | 1 | PA608826 | PM843365 |
| 17060000130144 | L17/dossiers | 17 | 17060000130143 | 17060000130143 | 1 | PA719778 | PM842744 |
| 17060000130151 | L17/dossiers | 17 | 17060000130150 | 17060000130150 | 1 | PA719778 | PM842744 |
| 17060000130158 | L17/dossiers | 17 | 17060000130157 | 17060000130157 | 1 | PA719778 | PM842744 |
| 17060000130165 | L17/dossiers | 17 | 17060000130164 | 17060000130164 | 1 | PA607395 | PM843077 |
| 17060000130219 | L17/dossiers | 17 | 17060000130218 | 17060000130218 | 1 | PA841885 | PM843446 |