dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 16060000115509 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 10 | PA775246 | PM775532 |
| 16060000115510 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 11 | PA678263 | PM736330 |
| 16060000115511 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 12 | PA1978 | PM736337 |
| 16060000115512 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 13 | PA736243 | PM736413 |
| 16060000115513 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 14 | PA736175 | PM736344 |
| 16060000115514 | L16/dossiers | 16 | 16060000115499 | 16060000115499 | 15 | PA775296 | PM775596 |
| 16060000115524 | L16/dossiers | 16 | 16060000115523 | 16060000115523 | 1 | PA267241 | PM778080 |
| 16060000115531 | L16/dossiers | 16 | 16060000115530 | 16060000115530 | 1 | PA795156 | PM797334 |
| 16060000115538 | L16/dossiers | 16 | 16060000115537 | 16060000115537 | 1 | PA720630 | PM797094 |
| 16060000115545 | L16/dossiers | 16 | 16060000115544 | 16060000115544 | 1 | PA795422 | PM797478 |
| 16060000115552 | L16/dossiers | 16 | 16060000115551 | 16060000115551 | 1 | PA720092 | PM796857 |
| 16060000115559 | L16/dossiers | 16 | 16060000115558 | 16060000115558 | 1 | PA793342 | PM796269 |
| 16060000115563 | L16/dossiers | 16 | 16060000115562 | 16060000115562 | 1 | PA793342 | PM796269 |
| 16060000115570 | L16/dossiers | 16 | 16060000115569 | 16060000115569 | 1 | PA794410 | PM796911 |
| 16060000115577 | L16/dossiers | 16 | 16060000115576 | 16060000115576 | 1 | PA793616 | PM796437 |
| 16060000115584 | L16/dossiers | 16 | 16060000115583 | 16060000115583 | 1 | PA793736 | PM796503 |
| 16060000115591 | L16/dossiers | 16 | 16060000115590 | 16060000115590 | 1 | PA795386 | PM797454 |
| 16060000115614 | L16/dossiers | 16 | 16060000115613 | 16060000115613 | 1 | PA794030 | PM796665 |
| 16060000115624 | L16/dossiers | 16 | 16060000115623 | 16060000115623 | 1 | PA795982 | PM797787 |
| 16060000115634 | L16/dossiers | 16 | 16060000115633 | 16060000115633 | 1 | PA717161 | PM791583 |
| 16060000115635 | L16/dossiers | 16 | 16060000115633 | 16060000115633 | 2 | PA331481 | PM791666 |
| 16060000115642 | L16/dossiers | 16 | 16060000115641 | 16060000115641 | 1 | PA335999 | PM797655 |
| 16060000115655 | L16/dossiers | 16 | 16060000115654 | 16060000115654 | 1 | PA717161 | PM791583 |
| 16060000115656 | L16/dossiers | 16 | 16060000115654 | 16060000115654 | 2 | PA331481 | PM791666 |
| 16060000115657 | L16/dossiers | 16 | 16060000115654 | 16060000115654 | 3 | PA429846 | PM801952 |
| 16060000115658 | L16/dossiers | 16 | 16060000115654 | 16060000115654 | 4 | PA774109 | PM801956 |
| 16060000115665 | L16/dossiers | 16 | 16060000115664 | 16060000115664 | 1 | PA643089 | PM797439 |
| 16060000115672 | L16/dossiers | 16 | 16060000115671 | 16060000115671 | 1 | PA718926 | PM796326 |
| 16060000115679 | L16/dossiers | 16 | 16060000115678 | 16060000115678 | 1 | PA608172 | PM797064 |
| 16060000115686 | L16/dossiers | 16 | 16060000115685 | 16060000115685 | 1 | PA794522 | PM796971 |
| 16060000115693 | L16/dossiers | 16 | 16060000115692 | 16060000115692 | 1 | PA643089 | PM797439 |
| 16060000115700 | L16/dossiers | 16 | 16060000115699 | 16060000115699 | 1 | PA775248 | PM775554 |
| 16060000115707 | L16/dossiers | 16 | 16060000115706 | 16060000115706 | 1 | PA1978 | PM736337 |
| 16060000115708 | L16/dossiers | 16 | 16060000115706 | 16060000115706 | 2 | PA703535 | PM793090 |
| 16060000115709 | L16/dossiers | 16 | 16060000115706 | 16060000115706 | 3 | PA736247 | PM736281 |
| 16060000115710 | L16/dossiers | 16 | 16060000115706 | 16060000115706 | 4 | PA643211 | PM775749 |
| 16060000115717 | L16/dossiers | 16 | 16060000115716 | 16060000115716 | 1 | PA718884 | PM796218 |
| 16060000115724 | L16/dossiers | 16 | 16060000115723 | 16060000115723 | 1 | PA793218 | PM796215 |
| 16060000115731 | L16/dossiers | 16 | 16060000115730 | 16060000115730 | 1 | PA304108 | PM736399 |
| 16060000115747 | L16/dossiers | 16 | 16060000115746 | 16060000115746 | 1 | PA717161 | PM791583 |
| 16060000115748 | L16/dossiers | 16 | 16060000115746 | 16060000115746 | 2 | PA331481 | PM791666 |
| 16060000115749 | L16/dossiers | 16 | 16060000115746 | 16060000115746 | 3 | PA721764 | PM801940 |
| 16060000115807 | L16/dossiers | 16 | 16060000115806 | 16060000115806 | 1 | PA717161 | PM791583 |
| 16060000115808 | L16/dossiers | 16 | 16060000115806 | 16060000115806 | 2 | PA331481 | PM791666 |
| 16060000115809 | L16/dossiers | 16 | 16060000115806 | 16060000115806 | 3 | PA826635 | PM826647 |
| 16060000115810 | L16/dossiers | 16 | 16060000115806 | 16060000115806 | 4 | PA793940 | PM826659 |
| 16060000115940 | L16/dossiers | 16 | 16060000115939 | 16060000115939 | 1 | PA717161 | PM791583 |
| 16060000115948 | L16/dossiers | 16 | 16060000115947 | 16060000115947 | 1 | PA795310 | PM797415 |
| 16060000115952 | L16/dossiers | 16 | 16060000115951 | 16060000115951 | 1 | PA736166 | PM775765 |
| 16060000115953 | L16/dossiers | 16 | 16060000115951 | 16060000115951 | 2 | PA775172 | PM775474 |