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 |
|---|---|---|---|---|---|---|---|
| 17060000143345 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 9 | PA756685 | PM775777 |
| 17060000143346 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 10 | PA827930 | PM828544 |
| 17060000143347 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 11 | PA268007 | PM829695 |
| 17060000143348 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 12 | PA736195 | PM829855 |
| 17060000143349 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 13 | PA775246 | PM775532 |
| 17060000143350 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 14 | PA827962 | PM828676 |
| 17060000143351 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 15 | PA736243 | PM829929 |
| 17060000143352 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 16 | PA828002 | PM828856 |
| 17060000143353 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 17 | PA775296 | PM775596 |
| 17060000143354 | L17/dossiers | 17 | 17060000143336 | 17060000143336 | 18 | PA828020 | PM828864 |
| 17060000143361 | L17/dossiers | 17 | 17060000143360 | 17060000143360 | 1 | PA795808 | PM843644 |
| 17060000143368 | L17/dossiers | 17 | 17060000143367 | 17060000143367 | 1 | PA747420 | PM775761 |
| 17060000143375 | L17/dossiers | 17 | 17060000143374 | 17060000143374 | 1 | PA643210 | PM873637 |
| 17060000143407 | L17/dossiers | 17 | 17060000143406 | 17060000143406 | 1 | PA795808 | PM843644 |
| 17060000143414 | L17/dossiers | 17 | 17060000143413 | 17060000143413 | 1 | PA841539 | PM843119 |
| 17060000143421 | L17/dossiers | 17 | 17060000143420 | 17060000143420 | 1 | PA827912 | PM828488 |
| 17060000143422 | L17/dossiers | 17 | 17060000143420 | 17060000143420 | 2 | PA827962 | PM828676 |
| 17060000143423 | L17/dossiers | 17 | 17060000143420 | 17060000143420 | 3 | PA827946 | PM828614 |
| 17060000143430 | L17/dossiers | 17 | 17060000143429 | 17060000143429 | 1 | PA607761 | PM828556 |
| 17060000143440 | L17/dossiers | 17 | 17060000143439 | 17060000143439 | 1 | PA643210 | PM873637 |
| 17060000143441 | L17/dossiers | 17 | 17060000143439 | 17060000143439 | 2 | PA721836 | PM873664 |
| 17060000143474 | L17/dossiers | 17 | 17060000143473 | 17060000143473 | 1 | PA840773 | PM842456 |
| 17060000143481 | L17/dossiers | 17 | 17060000143480 | 17060000143480 | 1 | PA720038 | PM842921 |
| 17060000143488 | L17/dossiers | 17 | 17060000143487 | 17060000143487 | 1 | PA793980 | PM842750 |
| 17060000143495 | L17/dossiers | 17 | 17060000143494 | 17060000143494 | 1 | PA721474 | PM843608 |
| 17060000143502 | L17/dossiers | 17 | 17060000143501 | 17060000143501 | 1 | PA643089 | PM858443 |
| 17060000143509 | L17/dossiers | 17 | 17060000143508 | 17060000143508 | 1 | PA795746 | PM843584 |
| 17060000143516 | L17/dossiers | 17 | 17060000143515 | 17060000143515 | 1 | PA795746 | PM843584 |
| 17060000143523 | L17/dossiers | 17 | 17060000143522 | 17060000143522 | 1 | PA794278 | PM842975 |
| 17060000143530 | L17/dossiers | 17 | 17060000143529 | 17060000143529 | 1 | PA795616 | PM840462 |
| 17060000143537 | L17/dossiers | 17 | 17060000143536 | 17060000143536 | 1 | PA840159 | PM840345 |
| 17060000143544 | L17/dossiers | 17 | 17060000143543 | 17060000143543 | 1 | PA793322 | PM840246 |
| 17060000143551 | L17/dossiers | 17 | 17060000143550 | 17060000143550 | 1 | PA267285 | PM842900 |
| 17060000143564 | L17/dossiers | 17 | 17060000143563 | 17060000143563 | 1 | PA722142 | PM843500 |
| 17060000143571 | L17/dossiers | 17 | 17060000143570 | 17060000143570 | 1 | PA841893 | PM843449 |
| 17060000143579 | L17/dossiers | 17 | 17060000143578 | 17060000143578 | 1 | PA842311 | PM843803 |
| 17060000143586 | L17/dossiers | 17 | 17060000143585 | 17060000143585 | 1 | PA793912 | PM842795 |
| 17060000143593 | L17/dossiers | 17 | 17060000143592 | 17060000143592 | 1 | PA795240 | PM843785 |
| 17060000143629 | L17/dossiers | 17 | 17060000143628 | 17060000143628 | 1 | PA722142 | PM843500 |
| 17060000143636 | L17/dossiers | 17 | 17060000143635 | 17060000143635 | 1 | PA841813 | PM843377 |
| 17060000143643 | L17/dossiers | 17 | 17060000143642 | 17060000143642 | 1 | PA642868 | PM858305 |
| 17060000143680 | L17/dossiers | 17 | 17060000143679 | 17060000143679 | 1 | PA794702 | PM843248 |
| 17060000143687 | L17/dossiers | 17 | 17060000143686 | 17060000143686 | 1 | PA840657 | PM842333 |
| 17060000143694 | L17/dossiers | 17 | 17060000143693 | 17060000143693 | 1 | PA2952 | PM842414 |
| 17060000143701 | L17/dossiers | 17 | 17060000143700 | 17060000143700 | 1 | PA267200 | PM843098 |
| 17060000143708 | L17/dossiers | 17 | 17060000143707 | 17060000143707 | 1 | PA795528 | PM843455 |
| 17060000143771 | L17/dossiers | 17 | 17060000143770 | 17060000143770 | 1 | PA607553 | PM843059 |
| 17060000143778 | L17/dossiers | 17 | 17060000143777 | 17060000143777 | 1 | PA794206 | PM842879 |
| 17060000143785 | L17/dossiers | 17 | 17060000143784 | 17060000143784 | 1 | PA795808 | PM843644 |
| 17060000143792 | L17/dossiers | 17 | 17060000143791 | 17060000143791 | 1 | PA840657 | PM842333 |