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 |
|---|---|---|---|---|---|---|---|
| 16060000109201 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 5 | PA429894 | PM736364 |
| 16060000109202 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 6 | PA756685 | PM775777 |
| 16060000109203 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 7 | PA429886 | PM736385 |
| 16060000109204 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 8 | PA736195 | PM736357 |
| 16060000109205 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 9 | PA736173 | PM736369 |
| 16060000109206 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 10 | PA775246 | PM775532 |
| 16060000109207 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 11 | PA678263 | PM736330 |
| 16060000109208 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 12 | PA1978 | PM736337 |
| 16060000109209 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 13 | PA736243 | PM736413 |
| 16060000109210 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 14 | PA736175 | PM736344 |
| 16060000109211 | L16/dossiers | 16 | 16060000109196 | 16060000109196 | 15 | PA775296 | PM775596 |
| 16060000109218 | L16/dossiers | 16 | 16060000109217 | 16060000109217 | 1 | PA794626 | PM797028 |
| 16060000109231 | L16/dossiers | 16 | 16060000109230 | 16060000109230 | 1 | PA793210 | PM796212 |
| 16060000109238 | L16/dossiers | 16 | 16060000109237 | 16060000109237 | 1 | PA720960 | PM797643 |
| 16060000109263 | L16/dossiers | 16 | 16060000109262 | 16060000109262 | 1 | PA793616 | PM796437 |
| 16060000109270 | L16/dossiers | 16 | 16060000109269 | 16060000109269 | 1 | PA605069 | PM796179 |
| 16060000109277 | L16/dossiers | 16 | 16060000109276 | 16060000109276 | 1 | PA2952 | PM796206 |
| 16060000109332 | L16/dossiers | 16 | 16060000109331 | 16060000109331 | 1 | PA333421 | PM796881 |
| 16060000109339 | L16/dossiers | 16 | 16060000109338 | 16060000109338 | 1 | PA720696 | PM796989 |
| 16060000109347 | L16/dossiers | 16 | 16060000109346 | 16060000109346 | 1 | PA793174 | PM796188 |
| 16060000109354 | L16/dossiers | 16 | 16060000109353 | 16060000109353 | 1 | PA643089 | PM797439 |
| 16060000109361 | L16/dossiers | 16 | 16060000109360 | 16060000109360 | 1 | PA607619 | PM796890 |
| 16060000109375 | L16/dossiers | 16 | 16060000109374 | 16060000109374 | 1 | PA333421 | PM796881 |
| 16060000109392 | L16/dossiers | 16 | 16060000109391 | 16060000109391 | 1 | PA333421 | PM796881 |
| 16060000109399 | L16/dossiers | 16 | 16060000109398 | 16060000109398 | 1 | PA718962 | PM796278 |
| 16060000109450 | L16/dossiers | 16 | 16060000109449 | 16060000109449 | 1 | PA267306 | PM797073 |
| 16060000109457 | L16/dossiers | 16 | 16060000109456 | 16060000109456 | 1 | PA775268 | PM775574 |
| 16060000109464 | L16/dossiers | 16 | 16060000109463 | 16060000109463 | 1 | PA2116 | PM736339 |
| 16060000109471 | L16/dossiers | 16 | 16060000109470 | 16060000109470 | 1 | PA793432 | PM796323 |
| 16060000109478 | L16/dossiers | 16 | 16060000109477 | 16060000109477 | 1 | PA643089 | PM797439 |
| 16060000109486 | L16/dossiers | 16 | 16060000109485 | 16060000109485 | 1 | PA330684 | PM775859 |
| 16060000109493 | L16/dossiers | 16 | 16060000109492 | 16060000109492 | 1 | PA721262 | PM797550 |
| 16060000109501 | L16/dossiers | 16 | 16060000109500 | 16060000109500 | 1 | PA795692 | PM797628 |
| 16060000109518 | L16/dossiers | 16 | 16060000109517 | 16060000109517 | 1 | PA794038 | PM796668 |
| 16060000109522 | L16/dossiers | 16 | 16060000109521 | 16060000109521 | 1 | PA793342 | PM796269 |
| 16060000109526 | L16/dossiers | 16 | 16060000109525 | 16060000109525 | 1 | PA793322 | PM796260 |
| 16060000109539 | L16/dossiers | 16 | 16060000109538 | 16060000109538 | 1 | PA2116 | PM736339 |
| 16060000109546 | L16/dossiers | 16 | 16060000109545 | 16060000109545 | 1 | PA736166 | PM775765 |
| 16060000109547 | L16/dossiers | 16 | 16060000109545 | 16060000109545 | 2 | PA736167 | PM736327 |
| 16060000109565 | L16/dossiers | 16 | 16060000109564 | 16060000109564 | 1 | PA720846 | PM797328 |
| 16060000109572 | L16/dossiers | 16 | 16060000109571 | 16060000109571 | 1 | PA721608 | PM797790 |
| 16060000109603 | L16/dossiers | 16 | 16060000109602 | 16060000109602 | 1 | PA717161 | PM791583 |
| 16060000109604 | L16/dossiers | 16 | 16060000109602 | 16060000109602 | 2 | PA331481 | PM791666 |
| 16060000109611 | L16/dossiers | 16 | 16060000109610 | 16060000109610 | 1 | PA736182 | PM736346 |
| 16060000109637 | L16/dossiers | 16 | 16060000109636 | 16060000109636 | 1 | PA717161 | PM791583 |
| 16060000109644 | L16/dossiers | 16 | 16060000109643 | 16060000109643 | 1 | PA2116 | PM736339 |
| 16060000109651 | L16/dossiers | 16 | 16060000109650 | 16060000109650 | 1 | PA795374 | PM797448 |
| 16060000109659 | L16/dossiers | 16 | 16060000109658 | 16060000109658 | 1 | PA642868 | PM796968 |
| 16060000109666 | L16/dossiers | 16 | 16060000109665 | 16060000109665 | 1 | PA720468 | PM796983 |
| 16060000109673 | L16/dossiers | 16 | 16060000109672 | 16060000109672 | 1 | PA721486 | PM797517 |