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 |
|---|---|---|---|---|---|---|---|
| 17060000135001 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 15 | PA736243 | PM829929 |
| 17060000135002 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 16 | PA736175 | PM829795 |
| 17060000135003 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 17 | PA775296 | PM775596 |
| 17060000135004 | L17/dossiers | 17 | 17060000134986 | 17060000134986 | 18 | PA828020 | PM828864 |
| 17060000135011 | L17/dossiers | 17 | 17060000135010 | 17060000135010 | 1 | PA794702 | PM843248 |
| 17060000135015 | L17/dossiers | 17 | 17060000135014 | 17060000135014 | 1 | PA720908 | PM843701 |
| 17060000135022 | L17/dossiers | 17 | 17060000135021 | 17060000135021 | 1 | PA721296 | PM843698 |
| 17060000135029 | L17/dossiers | 17 | 17060000135028 | 17060000135028 | 1 | PA793122 | PM842369 |
| 17060000135036 | L17/dossiers | 17 | 17060000135035 | 17060000135035 | 1 | PA841713 | PM843275 |
| 17060000135043 | L17/dossiers | 17 | 17060000135042 | 17060000135042 | 1 | PA720370 | PM843014 |
| 17060000135050 | L17/dossiers | 17 | 17060000135049 | 17060000135049 | 1 | PA794178 | PM842897 |
| 17060000135057 | L17/dossiers | 17 | 17060000135056 | 17060000135056 | 1 | PA840939 | PM842567 |
| 17060000135064 | L17/dossiers | 17 | 17060000135063 | 17060000135063 | 1 | PA642847 | PM843056 |
| 17060000135071 | L17/dossiers | 17 | 17060000135070 | 17060000135070 | 1 | PA794954 | PM840357 |
| 17060000135078 | L17/dossiers | 17 | 17060000135077 | 17060000135077 | 1 | PA606098 | PM842633 |
| 17060000135085 | L17/dossiers | 17 | 17060000135084 | 17060000135084 | 1 | PA712015 | PM842381 |
| 17060000135092 | L17/dossiers | 17 | 17060000135091 | 17060000135091 | 1 | PA408578 | PM843662 |
| 17060000135099 | L17/dossiers | 17 | 17060000135098 | 17060000135098 | 1 | PA840721 | PM842378 |
| 17060000135106 | L17/dossiers | 17 | 17060000135105 | 17060000135105 | 1 | PA840721 | PM842378 |
| 17060000135113 | L17/dossiers | 17 | 17060000135112 | 17060000135112 | 1 | PA795966 | PM843530 |
| 17060000135120 | L17/dossiers | 17 | 17060000135119 | 17060000135119 | 1 | PA794734 | PM843146 |
| 17060000135127 | L17/dossiers | 17 | 17060000135126 | 17060000135126 | 1 | PA793322 | PM840246 |
| 17060000135134 | L17/dossiers | 17 | 17060000135133 | 17060000135133 | 1 | PA722374 | PM843302 |
| 17060000135141 | L17/dossiers | 17 | 17060000135140 | 17060000135140 | 1 | PA793122 | PM842369 |
| 17060000135148 | L17/dossiers | 17 | 17060000135147 | 17060000135147 | 1 | PA793122 | PM842369 |
| 17060000135155 | L17/dossiers | 17 | 17060000135154 | 17060000135154 | 1 | PA2952 | PM842414 |
| 17060000135162 | L17/dossiers | 17 | 17060000135161 | 17060000135161 | 1 | PA2952 | PM842414 |
| 17060000135169 | L17/dossiers | 17 | 17060000135168 | 17060000135168 | 1 | PA2952 | PM842414 |
| 17060000135176 | L17/dossiers | 17 | 17060000135175 | 17060000135175 | 1 | PA330240 | PM842357 |
| 17060000135189 | L17/dossiers | 17 | 17060000135188 | 17060000135188 | 1 | PA330240 | PM842357 |
| 17060000135203 | L17/dossiers | 17 | 17060000135202 | 17060000135202 | 1 | PA330240 | PM842357 |
| 17060000135216 | L17/dossiers | 17 | 17060000135215 | 17060000135215 | 1 | PA330240 | PM842357 |
| 17060000135227 | L17/dossiers | 17 | 17060000135226 | 17060000135226 | 1 | PA718784 | PM842342 |
| 17060000135234 | L17/dossiers | 17 | 17060000135233 | 17060000135233 | 1 | PA842085 | PM843617 |
| 17060000135241 | L17/dossiers | 17 | 17060000135240 | 17060000135240 | 1 | PA330240 | PM842357 |
| 17060000135257 | L17/dossiers | 17 | 17060000135256 | 17060000135256 | 1 | PA330240 | PM842357 |
| 17060000135264 | L17/dossiers | 17 | 17060000135263 | 17060000135263 | 1 | PA841439 | PM843023 |
| 17060000135271 | L17/dossiers | 17 | 17060000135270 | 17060000135270 | 1 | PA2952 | PM842414 |
| 17060000135278 | L17/dossiers | 17 | 17060000135277 | 17060000135277 | 1 | PA842037 | PM843578 |
| 17060000135285 | L17/dossiers | 17 | 17060000135284 | 17060000135284 | 1 | PA841315 | PM842906 |
| 17060000135304 | L17/dossiers | 17 | 17060000135303 | 17060000135303 | 1 | PA795410 | PM843440 |
| 17060000135311 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 1 | PA1744 | PM775781 |
| 17060000135312 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 2 | PA267743 | PM829699 |
| 17060000135313 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 3 | PA827958 | PM828690 |
| 17060000135314 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 4 | PA415451 | PM775787 |
| 17060000135315 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 5 | PA703500 | PM775643 |
| 17060000135316 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 6 | PA827926 | PM828562 |
| 17060000135317 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 7 | PA775178 | PM775460 |
| 17060000135318 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 8 | PA775284 | PM775590 |
| 17060000135319 | L17/dossiers | 17 | 17060000135310 | 17060000135310 | 9 | PA827996 | PM828764 |