dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 15060000186123 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 110 | PA703527 | PM775709 |
| 15060000186130 | L15/dossiers | 15 | 15060000186129 | 15060000186129 | 1 | PA736227 | PM736308 |
| 15060000186140 | L15/dossiers | 15 | 15060000186139 | 15060000186139 | 1 | PA773441 | PM773491 |
| 15060000186141 | L15/dossiers | 15 | 15060000186139 | 15060000186139 | 2 | PA609520 | PM773503 |
| 15060000186142 | L15/dossiers | 15 | 15060000186139 | 15060000186139 | 3 | PA722236 | PM773501 |
| 15060000186149 | L15/dossiers | 15 | 15060000186148 | 15060000186148 | 1 | PA608172 | PM723048 |
| 15060000186156 | L15/dossiers | 15 | 15060000186155 | 15060000186155 | 1 | PA713448 | PM722452 |
| 15060000186160 | L15/dossiers | 15 | 15060000186159 | 15060000186159 | 1 | PA266808 | PM723264 |
| 15060000186167 | L15/dossiers | 15 | 15060000186166 | 15060000186166 | 1 | PA773441 | PM773491 |
| 15060000186174 | L15/dossiers | 15 | 15060000186173 | 15060000186173 | 1 | PA773441 | PM773491 |
| 15060000186181 | L15/dossiers | 15 | 15060000186180 | 15060000186180 | 1 | PA606098 | PM722642 |
| 15060000186188 | L15/dossiers | 15 | 15060000186187 | 15060000186187 | 1 | PA266797 | PM722884 |
| 15060000186204 | L15/dossiers | 15 | 15060000186203 | 15060000186203 | 1 | PA721678 | PM723352 |
| 15060000186211 | L15/dossiers | 15 | 15060000186210 | 15060000186210 | 1 | PA267306 | PM723054 |
| 15060000186218 | L15/dossiers | 15 | 15060000186217 | 15060000186217 | 1 | PA718926 | PM722502 |
| 15060000186225 | L15/dossiers | 15 | 15060000186224 | 15060000186224 | 1 | PA2377 | PM723550 |
| 15060000186232 | L15/dossiers | 15 | 15060000186231 | 15060000186231 | 1 | PA2952 | PM722480 |
| 15060000186239 | L15/dossiers | 15 | 15060000186238 | 15060000186238 | 1 | PA2116 | PM736339 |
| 15060000186246 | L15/dossiers | 15 | 15060000186245 | 15060000186245 | 1 | PA415488 | PM775641 |
| 15060000186253 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 1 | PA736177 | PM736318 |
| 15060000186254 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 2 | PA775282 | PM775584 |
| 15060000186255 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 3 | PA775180 | PM775466 |
| 15060000186256 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 4 | PA429845 | PM736278 |
| 15060000186257 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 5 | PA775252 | PM775558 |
| 15060000186258 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 6 | PA775214 | PM775498 |
| 15060000186259 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 7 | PA775224 | PM775512 |
| 15060000186260 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 8 | PA429866 | PM736287 |
| 15060000186261 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 9 | PA775262 | PM775548 |
| 15060000186262 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 10 | PA775272 | PM775562 |
| 15060000186263 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 11 | PA736201 | PM736347 |
| 15060000186264 | L15/dossiers | 15 | 15060000186252 | 15060000186252 | 12 | PA785857 | PM785867 |
| 15060000186271 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 1 | PA702993 | PM736362 |
| 15060000186272 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 2 | PA429855 | PM736425 |
| 15060000186273 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 3 | PA736219 | PM736387 |
| 15060000186274 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 4 | PA304002 | PM736326 |
| 15060000186275 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 5 | PA736199 | PM736284 |
| 15060000186276 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 6 | PA775186 | PM775484 |
| 15060000186277 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 7 | PA415488 | PM775641 |
| 15060000186278 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 8 | PA775194 | PM775476 |
| 15060000186279 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 9 | PA775196 | PM775482 |
| 15060000186280 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 10 | PA775200 | PM775504 |
| 15060000186281 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 11 | PA775206 | PM775506 |
| 15060000186282 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 12 | PA590034 | PM775606 |
| 15060000186283 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 13 | PA785855 | PM785869 |
| 15060000186284 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 14 | PA736234 | PM736424 |
| 15060000186285 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 15 | PA429835 | PM736397 |
| 15060000186286 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 16 | PA429835 | PM736397 |
| 15060000186287 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 17 | PA775210 | PM775492 |
| 15060000186288 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 18 | PA732419 | PM775647 |
| 15060000186289 | L15/dossiers | 15 | 15060000186270 | 15060000186270 | 19 | PA732419 | PM775647 |