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 |
|---|---|---|---|---|---|---|---|
| 17060000144114 | L17/dossiers | 17 | 17060000144113 | 17060000144113 | 1 | PA794118 | PM842894 |
| 17060000144121 | L17/dossiers | 17 | 17060000144120 | 17060000144120 | 1 | PA793736 | PM842693 |
| 17060000144128 | L17/dossiers | 17 | 17060000144127 | 17060000144127 | 1 | PA722284 | PM843221 |
| 17060000144135 | L17/dossiers | 17 | 17060000144134 | 17060000144134 | 1 | PA720386 | PM843020 |
| 17060000144148 | L17/dossiers | 17 | 17060000144147 | 17060000144147 | 1 | PA722390 | PM843317 |
| 17060000144155 | L17/dossiers | 17 | 17060000144154 | 17060000144154 | 1 | PA841657 | PM843224 |
| 17060000144162 | L17/dossiers | 17 | 17060000144161 | 17060000144161 | 1 | PA718850 | PM842411 |
| 17060000144169 | L17/dossiers | 17 | 17060000144168 | 17060000144168 | 1 | PA267285 | PM842900 |
| 17060000144176 | L17/dossiers | 17 | 17060000144175 | 17060000144175 | 1 | PA794058 | PM842861 |
| 17060000144183 | L17/dossiers | 17 | 17060000144182 | 17060000144182 | 1 | PA720386 | PM843020 |
| 17060000144197 | L17/dossiers | 17 | 17060000144196 | 17060000144196 | 1 | PA793094 | PM842327 |
| 17060000144204 | L17/dossiers | 17 | 17060000144203 | 17060000144203 | 1 | PA793452 | PM842453 |
| 17060000144211 | L17/dossiers | 17 | 17060000144210 | 17060000144210 | 1 | PA608016 | PM874599 |
| 17060000144215 | L17/dossiers | 17 | 17060000144214 | 17060000144214 | 1 | PA793322 | PM840246 |
| 17060000144222 | L17/dossiers | 17 | 17060000144221 | 17060000144221 | 1 | PA841439 | PM843023 |
| 17060000144226 | L17/dossiers | 17 | 17060000144225 | 17060000144225 | 1 | PA794114 | PM842888 |
| 17060000144233 | L17/dossiers | 17 | 17060000144232 | 17060000144232 | 1 | PA703485 | PM775811 |
| 17060000144240 | L17/dossiers | 17 | 17060000144239 | 17060000144239 | 1 | PA795310 | PM840453 |
| 17060000144247 | L17/dossiers | 17 | 17060000144246 | 17060000144246 | 1 | PA841701 | PM843269 |
| 17060000144251 | L17/dossiers | 17 | 17060000144250 | 17060000144250 | 1 | PA736241 | PM829931 |
| 17060000144258 | L17/dossiers | 17 | 17060000144257 | 17060000144257 | 1 | PA828010 | PM828832 |
| 17060000144259 | L17/dossiers | 17 | 17060000144257 | 17060000144257 | 2 | PA736196 | PM829865 |
| 17060000144266 | L17/dossiers | 17 | 17060000144265 | 17060000144265 | 1 | PA703523 | PM775703 |
| 17060000144296 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 1 | PA827970 | PM828758 |
| 17060000144297 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 2 | PA758716 | PM775771 |
| 17060000144298 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 3 | PA758716 | PM775771 |
| 17060000144299 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 4 | PA775286 | PM775588 |
| 17060000144300 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 5 | PA703492 | PM775657 |
| 17060000144301 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 6 | PA736237 | PM829897 |
| 17060000144302 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 7 | PA736196 | PM829865 |
| 17060000144303 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 8 | PA827910 | PM828508 |
| 17060000144304 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 9 | PA303995 | PM775745 |
| 17060000144305 | L17/dossiers | 17 | 17060000144295 | 17060000144295 | 10 | PA736168 | PM829793 |
| 17060000144325 | L17/dossiers | 17 | 17060000144324 | 17060000144324 | 1 | PA736192 | PM829859 |
| 17060000144326 | L17/dossiers | 17 | 17060000144324 | 17060000144324 | 2 | PA827938 | PM828646 |
| 17060000144327 | L17/dossiers | 17 | 17060000144324 | 17060000144324 | 3 | PA736243 | PM829929 |
| 17060000144328 | L17/dossiers | 17 | 17060000144324 | 17060000144324 | 4 | PA736182 | PM829837 |
| 17060000144329 | L17/dossiers | 17 | 17060000144324 | 17060000144324 | 5 | PA304017 | PM775757 |
| 17060000144330 | L17/dossiers | 17 | 17060000144324 | 17060000144324 | 6 | PA712422 | PM828926 |
| 17060000144354 | L17/dossiers | 17 | 17060000144353 | 17060000144353 | 1 | PA794008 | PM842768 |
| 17060000144366 | L17/dossiers | 17 | 17060000144365 | 17060000144365 | 1 | PA795962 | PM849121 |
| 17060000144373 | L17/dossiers | 17 | 17060000144372 | 17060000144372 | 1 | PA703520 | PM775705 |
| 17060000144380 | L17/dossiers | 17 | 17060000144379 | 17060000144379 | 1 | PA721742 | PM829056 |
| 17060000144396 | L17/dossiers | 17 | 17060000144395 | 17060000144395 | 1 | PA791812 | PM840384 |
| 17060000144403 | L17/dossiers | 17 | 17060000144402 | 17060000144402 | 1 | PA703513 | PM775671 |
| 17060000144439 | L17/dossiers | 17 | 17060000144438 | 17060000144438 | 1 | PA793664 | PM842549 |
| 17060000144446 | L17/dossiers | 17 | 17060000144445 | 17060000144445 | 1 | PA610968 | PM840381 |
| 17060000144453 | L17/dossiers | 17 | 17060000144452 | 17060000144452 | 1 | PA840889 | PM842534 |
| 17060000144457 | L17/dossiers | 17 | 17060000144456 | 17060000144456 | 1 | PA775240 | PM775530 |
| 17060000144464 | L17/dossiers | 17 | 17060000144463 | 17060000144463 | 1 | PA267285 | PM842900 |