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 |
|---|---|---|---|---|---|---|---|
| 17060000131079 | L17/dossiers | 17 | 17060000131077 | 17060000131077 | 2 | PA720154 | PM842852 |
| 17060000131083 | L17/dossiers | 17 | 17060000131082 | 17060000131082 | 1 | PA605745 | PM842504 |
| 17060000131090 | L17/dossiers | 17 | 17060000131089 | 17060000131089 | 1 | PA794418 | PM840309 |
| 17060000131097 | L17/dossiers | 17 | 17060000131096 | 17060000131096 | 1 | PA794418 | PM840309 |
| 17060000131104 | L17/dossiers | 17 | 17060000131103 | 17060000131103 | 1 | PA720370 | PM843014 |
| 17060000131111 | L17/dossiers | 17 | 17060000131110 | 17060000131110 | 1 | PA793912 | PM842795 |
| 17060000131118 | L17/dossiers | 17 | 17060000131117 | 17060000131117 | 1 | PA719436 | PM840279 |
| 17060000131125 | L17/dossiers | 17 | 17060000131124 | 17060000131124 | 1 | PA721486 | PM843614 |
| 17060000131132 | L17/dossiers | 17 | 17060000131131 | 17060000131131 | 1 | PA793322 | PM840246 |
| 17060000131139 | L17/dossiers | 17 | 17060000131138 | 17060000131138 | 1 | PA719890 | PM842855 |
| 17060000131147 | L17/dossiers | 17 | 17060000131146 | 17060000131146 | 1 | PA719890 | PM842855 |
| 17060000131154 | L17/dossiers | 17 | 17060000131153 | 17060000131153 | 1 | PA719890 | PM842855 |
| 17060000131161 | L17/dossiers | 17 | 17060000131160 | 17060000131160 | 1 | PA719890 | PM842855 |
| 17060000131168 | L17/dossiers | 17 | 17060000131167 | 17060000131167 | 1 | PA719890 | PM842855 |
| 17060000131175 | L17/dossiers | 17 | 17060000131174 | 17060000131174 | 1 | PA841183 | PM842786 |
| 17060000131182 | L17/dossiers | 17 | 17060000131181 | 17060000131181 | 1 | PA794686 | PM843080 |
| 17060000131189 | L17/dossiers | 17 | 17060000131188 | 17060000131188 | 1 | PA840701 | PM842363 |
| 17060000131196 | L17/dossiers | 17 | 17060000131195 | 17060000131195 | 1 | PA720892 | PM840420 |
| 17060000131203 | L17/dossiers | 17 | 17060000131202 | 17060000131202 | 1 | PA840765 | PM842447 |
| 17060000131210 | L17/dossiers | 17 | 17060000131209 | 17060000131209 | 1 | PA793322 | PM840246 |
| 17060000131217 | L17/dossiers | 17 | 17060000131216 | 17060000131216 | 1 | PA841873 | PM843434 |
| 17060000131224 | L17/dossiers | 17 | 17060000131223 | 17060000131223 | 1 | PA346782 | PM840426 |
| 17060000131231 | L17/dossiers | 17 | 17060000131230 | 17060000131230 | 1 | PA794118 | PM842894 |
| 17060000131238 | L17/dossiers | 17 | 17060000131237 | 17060000131237 | 1 | PA841439 | PM843023 |
| 17060000131245 | L17/dossiers | 17 | 17060000131244 | 17060000131244 | 1 | PA840979 | PM842588 |
| 17060000131252 | L17/dossiers | 17 | 17060000131251 | 17060000131251 | 1 | PA841717 | PM843278 |
| 17060000131259 | L17/dossiers | 17 | 17060000131258 | 17060000131258 | 1 | PA720092 | PM842948 |
| 17060000131267 | L17/dossiers | 17 | 17060000131266 | 17060000131266 | 1 | PA793322 | PM840246 |
| 17060000131274 | L17/dossiers | 17 | 17060000131273 | 17060000131273 | 1 | PA842125 | PM843641 |
| 17060000131281 | L17/dossiers | 17 | 17060000131280 | 17060000131280 | 1 | PA795820 | PM843713 |
| 17060000131288 | L17/dossiers | 17 | 17060000131287 | 17060000131287 | 1 | PA817211 | PM842600 |
| 17060000131295 | L17/dossiers | 17 | 17060000131294 | 17060000131294 | 1 | PA793756 | PM840282 |
| 17060000131302 | L17/dossiers | 17 | 17060000131301 | 17060000131301 | 1 | PA795552 | PM840408 |
| 17060000131309 | L17/dossiers | 17 | 17060000131308 | 17060000131308 | 1 | PA720560 | PM843032 |
| 17060000131333 | L17/dossiers | 17 | 17060000131332 | 17060000131332 | 1 | PA721474 | PM843608 |
| 17060000131340 | L17/dossiers | 17 | 17060000131339 | 17060000131339 | 1 | PA841693 | PM843266 |
| 17060000131348 | L17/dossiers | 17 | 17060000131347 | 17060000131347 | 1 | PA793342 | PM842345 |
| 17060000131355 | L17/dossiers | 17 | 17060000131354 | 17060000131354 | 1 | PA795010 | PM840354 |
| 17060000131362 | L17/dossiers | 17 | 17060000131361 | 17060000131361 | 1 | PA841931 | PM843485 |
| 17060000131369 | L17/dossiers | 17 | 17060000131368 | 17060000131368 | 1 | PA794494 | PM843116 |
| 17060000131376 | L17/dossiers | 17 | 17060000131375 | 17060000131375 | 1 | PA793464 | PM840273 |
| 17060000131383 | L17/dossiers | 17 | 17060000131382 | 17060000131382 | 1 | PA791824 | PM840375 |
| 17060000131390 | L17/dossiers | 17 | 17060000131389 | 17060000131389 | 1 | PA791824 | PM840375 |
| 17060000131397 | L17/dossiers | 17 | 17060000131396 | 17060000131396 | 1 | PA795844 | PM843515 |
| 17060000131404 | L17/dossiers | 17 | 17060000131403 | 17060000131403 | 1 | PA841931 | PM843485 |
| 17060000131411 | L17/dossiers | 17 | 17060000131410 | 17060000131410 | 1 | PA841931 | PM843485 |
| 17060000131418 | L17/dossiers | 17 | 17060000131417 | 17060000131417 | 1 | PA842037 | PM843578 |
| 17060000131425 | L17/dossiers | 17 | 17060000131424 | 17060000131424 | 1 | PA335999 | PM843494 |
| 17060000131432 | L17/dossiers | 17 | 17060000131431 | 17060000131431 | 1 | PA605694 | PM842609 |
| 17060000131617 | L17/dossiers | 17 | 17060000131616 | 17060000131616 | 1 | PA791824 | PM840375 |