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 |
|---|---|---|---|---|---|---|---|
| 17060000140270 | L17/dossiers | 17 | 17060000140269 | 17060000140269 | 1 | PA335999 | PM843494 |
| 17060000140277 | L17/dossiers | 17 | 17060000140276 | 17060000140276 | 1 | PA795084 | PM840369 |
| 17060000140285 | L17/dossiers | 17 | 17060000140284 | 17060000140284 | 1 | PA720386 | PM843020 |
| 17060000140292 | L17/dossiers | 17 | 17060000140291 | 17060000140291 | 1 | PA340343 | PM842351 |
| 17060000140299 | L17/dossiers | 17 | 17060000140298 | 17060000140298 | 1 | PA793416 | PM858452 |
| 17060000140306 | L17/dossiers | 17 | 17060000140305 | 17060000140305 | 1 | PA610002 | PM840363 |
| 17060000140313 | L17/dossiers | 17 | 17060000140312 | 17060000140312 | 1 | PA841717 | PM843278 |
| 17060000140320 | L17/dossiers | 17 | 17060000140319 | 17060000140319 | 1 | PA793322 | PM840246 |
| 17060000140327 | L17/dossiers | 17 | 17060000140326 | 17060000140326 | 1 | PA793322 | PM840246 |
| 17060000140334 | L17/dossiers | 17 | 17060000140333 | 17060000140333 | 1 | PA795778 | PM843509 |
| 17060000140348 | L17/dossiers | 17 | 17060000140347 | 17060000140347 | 1 | PA841075 | PM842690 |
| 17060000140365 | L17/dossiers | 17 | 17060000140364 | 17060000140364 | 1 | PA841729 | PM843287 |
| 17060000140372 | L17/dossiers | 17 | 17060000140371 | 17060000140371 | 1 | PA736201 | PM840423 |
| 17060000140393 | L17/dossiers | 17 | 17060000140392 | 17060000140392 | 1 | PA785857 | PM785867 |
| 17060000140394 | L17/dossiers | 17 | 17060000140392 | 17060000140392 | 2 | PA827978 | PM828730 |
| 17060000140401 | L17/dossiers | 17 | 17060000140400 | 17060000140400 | 1 | PA736233 | PM829889 |
| 17060000140408 | L17/dossiers | 17 | 17060000140407 | 17060000140407 | 1 | PA794702 | PM843248 |
| 17060000140412 | L17/dossiers | 17 | 17060000140411 | 17060000140411 | 1 | PA569 | PM843512 |
| 17060000140419 | L17/dossiers | 17 | 17060000140418 | 17060000140418 | 1 | PA842187 | PM843704 |
| 17060000140423 | L17/dossiers | 17 | 17060000140422 | 17060000140422 | 1 | PA703518 | PM775673 |
| 17060000140430 | L17/dossiers | 17 | 17060000140429 | 17060000140429 | 1 | PA408578 | PM843662 |
| 17060000140437 | L17/dossiers | 17 | 17060000140436 | 17060000140436 | 1 | PA720552 | PM843029 |
| 17060000140447 | L17/dossiers | 17 | 17060000140446 | 17060000140446 | 1 | PA345722 | PM843650 |
| 17060000140479 | L17/dossiers | 17 | 17060000140478 | 17060000140478 | 1 | PA715322 | PM775713 |
| 17060000140486 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 1 | PA736195 | PM829855 |
| 17060000140487 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 2 | PA775246 | PM775532 |
| 17060000140488 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 3 | PA827962 | PM828676 |
| 17060000140489 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 4 | PA757676 | PM829801 |
| 17060000140490 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 5 | PA775172 | PM775474 |
| 17060000140491 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 6 | PA827898 | PM828454 |
| 17060000140492 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 7 | PA850008 | PM850016 |
| 17060000140493 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 8 | PA827912 | PM828488 |
| 17060000140494 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 9 | PA756685 | PM775777 |
| 17060000140495 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 10 | PA827930 | PM828544 |
| 17060000140496 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 11 | PA268007 | PM829695 |
| 17060000140497 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 12 | PA429886 | PM829757 |
| 17060000140498 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 13 | PA736173 | PM829799 |
| 17060000140499 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 14 | PA736243 | PM829929 |
| 17060000140500 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 15 | PA736175 | PM829795 |
| 17060000140501 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 16 | PA828002 | PM828856 |
| 17060000140502 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 17 | PA775296 | PM775596 |
| 17060000140503 | L17/dossiers | 17 | 17060000140485 | 17060000140485 | 18 | PA828020 | PM828864 |
| 17060000140510 | L17/dossiers | 17 | 17060000140509 | 17060000140509 | 1 | PA775294 | PM775580 |
| 17060000140520 | L17/dossiers | 17 | 17060000140519 | 17060000140519 | 1 | PA795422 | PM843599 |
| 17060000140524 | L17/dossiers | 17 | 17060000140523 | 17060000140523 | 1 | PA330240 | PM842357 |
| 17060000140534 | L17/dossiers | 17 | 17060000140533 | 17060000140533 | 1 | PA827934 | PM828532 |
| 17060000140553 | L17/dossiers | 17 | 17060000140552 | 17060000140552 | 1 | PA841351 | PM842936 |
| 17060000140560 | L17/dossiers | 17 | 17060000140559 | 17060000140559 | 1 | PA415486 | PM775813 |
| 17060000140567 | L17/dossiers | 17 | 17060000140566 | 17060000140566 | 1 | PA795374 | PM843593 |
| 17060000140571 | L17/dossiers | 17 | 17060000140570 | 17060000140570 | 1 | PA793322 | PM840246 |