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 |
|---|---|---|---|---|---|---|---|
| 15060000182480 | L15/dossiers | 15 | 15060000182478 | 15060000182478 | 2 | PA227096 | PM736342 |
| 15060000182481 | L15/dossiers | 15 | 15060000182478 | 15060000182478 | 3 | PA304002 | PM736326 |
| 15060000182482 | L15/dossiers | 15 | 15060000182478 | 15060000182478 | 4 | PA775196 | PM775482 |
| 15060000182492 | L15/dossiers | 15 | 15060000182491 | 15060000182491 | 1 | PA719946 | PM722808 |
| 15060000182499 | L15/dossiers | 15 | 15060000182498 | 15060000182498 | 1 | PA405480 | PM723118 |
| 15060000182506 | L15/dossiers | 15 | 15060000182505 | 15060000182505 | 1 | PA720500 | PM722982 |
| 15060000182515 | L15/dossiers | 15 | 15060000182514 | 15060000182514 | 1 | PA720298 | PM722922 |
| 15060000182522 | L15/dossiers | 15 | 15060000182521 | 15060000182521 | 1 | PA267306 | PM723054 |
| 15060000182545 | L15/dossiers | 15 | 15060000182544 | 15060000182544 | 1 | PA718926 | PM722502 |
| 15060000182553 | L15/dossiers | 15 | 15060000182552 | 15060000182552 | 1 | PA689 | PM723090 |
| 15060000182571 | L15/dossiers | 15 | 15060000182570 | 15060000182570 | 1 | PA718926 | PM722502 |
| 15060000182586 | L15/dossiers | 15 | 15060000182585 | 15060000182585 | 1 | PA718926 | PM722502 |
| 15060000182593 | L15/dossiers | 15 | 15060000182592 | 15060000182592 | 1 | PA722202 | PM723502 |
| 15060000182610 | L15/dossiers | 15 | 15060000182609 | 15060000182609 | 1 | PA718720 | PM722436 |
| 15060000182625 | L15/dossiers | 15 | 15060000182624 | 15060000182624 | 1 | PA722110 | PM723474 |
| 15060000182632 | L15/dossiers | 15 | 15060000182631 | 15060000182631 | 1 | PA722110 | PM723474 |
| 15060000182639 | L15/dossiers | 15 | 15060000182638 | 15060000182638 | 1 | PA775204 | PM775508 |
| 15060000182646 | L15/dossiers | 15 | 15060000182645 | 15060000182645 | 1 | PA773441 | PM773491 |
| 15060000182674 | L15/dossiers | 15 | 15060000182673 | 15060000182673 | 1 | PA718926 | PM722502 |
| 15060000182681 | L15/dossiers | 15 | 15060000182680 | 15060000182680 | 1 | PA721364 | PM723250 |
| 15060000182688 | L15/dossiers | 15 | 15060000182687 | 15060000182687 | 1 | PA719874 | PM722786 |
| 15060000182712 | L15/dossiers | 15 | 15060000182711 | 15060000182711 | 1 | PA775204 | PM775508 |
| 15060000182719 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 1 | PA429889 | PM736313 |
| 15060000182720 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 2 | PA429889 | PM736313 |
| 15060000182721 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 3 | PA429844 | PM736276 |
| 15060000182722 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 4 | PA703512 | PM775665 |
| 15060000182723 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 5 | PA775196 | PM775482 |
| 15060000182724 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 6 | PA642756 | PM775779 |
| 15060000182725 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 7 | PA703538 | PM775715 |
| 15060000182726 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 8 | PA775186 | PM775484 |
| 15060000182727 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 9 | PA605888 | PM775604 |
| 15060000182728 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 10 | PA736162 | PM736320 |
| 15060000182729 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 11 | PA606375 | PM775602 |
| 15060000182730 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 12 | PA775254 | PM775556 |
| 15060000182731 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 13 | PA736209 | PM736400 |
| 15060000182732 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 14 | PA736214 | PM736290 |
| 15060000182733 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 15 | PA736234 | PM736424 |
| 15060000182734 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 16 | PA342564 | PM736388 |
| 15060000182735 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 17 | PA415488 | PM775641 |
| 15060000182736 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 18 | PA429835 | PM736397 |
| 15060000182737 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 19 | PA429835 | PM736397 |
| 15060000182738 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 20 | PA775274 | PM775560 |
| 15060000182739 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 21 | PA590034 | PM775606 |
| 15060000182740 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 22 | PA736199 | PM736284 |
| 15060000182741 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 23 | PA736187 | PM736365 |
| 15060000182742 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 24 | PA736219 | PM736387 |
| 15060000182743 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 25 | PA775206 | PM775506 |
| 15060000182744 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 26 | PA415477 | PM775809 |
| 15060000182745 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 27 | PA415477 | PM775809 |
| 15060000182746 | L15/dossiers | 15 | 15060000182718 | 15060000182718 | 28 | PA736191 | PM736336 |