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 |
|---|---|---|---|---|---|---|---|
| 16060000112154 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 15 | PA775296 | PM775596 |
| 16060000112164 | L16/dossiers | 16 | 16060000112163 | 16060000112163 | 1 | PA267241 | PM778080 |
| 16060000112171 | L16/dossiers | 16 | 16060000112170 | 16060000112170 | 1 | PA736167 | PM736327 |
| 16060000112178 | L16/dossiers | 16 | 16060000112177 | 16060000112177 | 1 | PA717161 | PM791583 |
| 16060000112179 | L16/dossiers | 16 | 16060000112177 | 16060000112177 | 2 | PA331481 | PM791666 |
| 16060000112186 | L16/dossiers | 16 | 16060000112185 | 16060000112185 | 1 | PA795778 | PM797682 |
| 16060000112193 | L16/dossiers | 16 | 16060000112192 | 16060000112192 | 1 | PA793278 | PM796242 |
| 16060000112203 | L16/dossiers | 16 | 16060000112202 | 16060000112202 | 1 | PA720560 | PM797016 |
| 16060000112218 | L16/dossiers | 16 | 16060000112217 | 16060000112217 | 1 | PA793912 | PM796599 |
| 16060000112225 | L16/dossiers | 16 | 16060000112224 | 16060000112224 | 1 | PA267306 | PM797073 |
| 16060000112232 | L16/dossiers | 16 | 16060000112231 | 16060000112231 | 1 | PA795298 | PM797409 |
| 16060000112239 | L16/dossiers | 16 | 16060000112238 | 16060000112238 | 1 | PA643089 | PM797439 |
| 16060000112246 | L16/dossiers | 16 | 16060000112245 | 16060000112245 | 1 | PA774958 | PM797355 |
| 16060000112253 | L16/dossiers | 16 | 16060000112252 | 16060000112252 | 1 | PA642847 | PM796872 |
| 16060000112260 | L16/dossiers | 16 | 16060000112259 | 16060000112259 | 1 | PA642847 | PM796872 |
| 16060000112267 | L16/dossiers | 16 | 16060000112266 | 16060000112266 | 1 | PA642847 | PM796872 |
| 16060000112274 | L16/dossiers | 16 | 16060000112273 | 16060000112273 | 1 | PA346782 | PM797691 |
| 16060000112281 | L16/dossiers | 16 | 16060000112280 | 16060000112280 | 1 | PA721442 | PM797253 |
| 16060000112288 | L16/dossiers | 16 | 16060000112287 | 16060000112287 | 1 | PA720446 | PM797031 |
| 16060000112293 | L16/dossiers | 16 | 16060000112292 | 16060000112292 | 1 | PA793904 | PM796596 |
| 16060000112300 | L16/dossiers | 16 | 16060000112299 | 16060000112299 | 1 | PA795900 | PM797745 |
| 16060000112307 | L16/dossiers | 16 | 16060000112306 | 16060000112306 | 1 | PA607489 | PM736390 |
| 16060000112308 | L16/dossiers | 16 | 16060000112306 | 16060000112306 | 2 | PA736237 | PM736417 |
| 16060000112309 | L16/dossiers | 16 | 16060000112306 | 16060000112306 | 3 | PA703518 | PM775673 |
| 16060000112310 | L16/dossiers | 16 | 16060000112306 | 16060000112306 | 4 | PA267762 | PM736366 |
| 16060000112317 | L16/dossiers | 16 | 16060000112316 | 16060000112316 | 1 | PA608416 | PM797133 |
| 16060000112324 | L16/dossiers | 16 | 16060000112323 | 16060000112323 | 1 | PA794686 | PM797061 |
| 16060000112331 | L16/dossiers | 16 | 16060000112330 | 16060000112330 | 1 | PA720644 | PM797103 |
| 16060000112335 | L16/dossiers | 16 | 16060000112334 | 16060000112334 | 1 | PA794894 | PM797181 |
| 16060000112339 | L16/dossiers | 16 | 16060000112338 | 16060000112338 | 1 | PA608416 | PM797133 |
| 16060000112346 | L16/dossiers | 16 | 16060000112345 | 16060000112345 | 1 | PA794734 | PM797091 |
| 16060000112378 | L16/dossiers | 16 | 16060000112377 | 16060000112377 | 1 | PA717161 | PM791583 |
| 16060000112379 | L16/dossiers | 16 | 16060000112377 | 16060000112377 | 2 | PA312976 | PM791676 |
| 16060000112412 | L16/dossiers | 16 | 16060000112411 | 16060000112411 | 1 | PA719890 | PM796680 |
| 16060000112419 | L16/dossiers | 16 | 16060000112418 | 16060000112418 | 1 | PA426327 | PM775735 |
| 16060000112420 | L16/dossiers | 16 | 16060000112418 | 16060000112418 | 2 | PA775258 | PM775544 |
| 16060000112427 | L16/dossiers | 16 | 16060000112426 | 16060000112426 | 1 | PA2116 | PM736339 |
| 16060000112434 | L16/dossiers | 16 | 16060000112433 | 16060000112433 | 1 | PA793322 | PM796260 |
| 16060000112441 | L16/dossiers | 16 | 16060000112440 | 16060000112440 | 1 | PA793230 | PM796221 |
| 16060000112448 | L16/dossiers | 16 | 16060000112447 | 16060000112447 | 1 | PA794718 | PM797079 |
| 16060000112455 | L16/dossiers | 16 | 16060000112454 | 16060000112454 | 1 | PA1327 | PM796632 |
| 16060000112462 | L16/dossiers | 16 | 16060000112461 | 16060000112461 | 1 | PA796026 | PM797814 |
| 16060000112469 | L16/dossiers | 16 | 16060000112468 | 16060000112468 | 1 | PA795216 | PM797364 |
| 16060000112470 | L16/dossiers | 16 | 16060000112468 | 16060000112468 | 2 | PA795722 | PM797649 |
| 16060000112477 | L16/dossiers | 16 | 16060000112476 | 16060000112476 | 1 | PA793592 | PM796425 |
| 16060000112484 | L16/dossiers | 16 | 16060000112483 | 16060000112483 | 1 | PA793382 | PM796293 |
| 16060000112491 | L16/dossiers | 16 | 16060000112490 | 16060000112490 | 1 | PA608016 | PM797100 |
| 16060000112498 | L16/dossiers | 16 | 16060000112497 | 16060000112497 | 1 | PA720892 | PM797520 |
| 16060000112505 | L16/dossiers | 16 | 16060000112504 | 16060000112504 | 1 | PA721486 | PM797517 |
| 16060000112512 | L16/dossiers | 16 | 16060000112511 | 16060000112511 | 1 | PA736229 | PM736389 |