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 |
|---|---|---|---|---|---|---|---|
| 15060000170630 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 40 | PA775288 | PM775578 |
| 15060000170631 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 41 | PA775178 | PM775460 |
| 15060000170632 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 42 | PA775228 | PM775516 |
| 15060000170633 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 43 | PA775280 | PM775586 |
| 15060000170634 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 44 | PA775216 | PM775522 |
| 15060000170635 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 45 | PA775302 | PM775598 |
| 15060000170636 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 46 | PA703534 | PM775695 |
| 15060000170637 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 47 | PA227094 | PM736386 |
| 15060000170638 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 48 | PA313924 | PM775727 |
| 15060000170639 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 49 | PA267075 | PM775610 |
| 15060000170640 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 50 | PA763158 | PM775683 |
| 15060000170641 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 51 | PA708632 | PM775667 |
| 15060000170642 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 52 | PA267512 | PM775817 |
| 15060000170643 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 53 | PA736227 | PM736308 |
| 15060000170644 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 54 | PA736194 | PM736291 |
| 15060000170645 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 55 | PA775248 | PM775554 |
| 15060000170646 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 56 | PA394676 | PM775769 |
| 15060000170647 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 57 | PA775286 | PM775588 |
| 15060000170648 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 58 | PA775202 | PM775502 |
| 15060000170649 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 59 | PA747421 | PM775759 |
| 15060000170650 | L15/dossiers | 15 | 15060000170590 | 15060000170590 | 60 | PA736247 | PM736281 |
| 15060000170657 | L15/dossiers | 15 | 15060000170656 | 15060000170656 | 1 | PA736196 | PM736370 |
| 15060000170675 | L15/dossiers | 15 | 15060000170674 | 15060000170674 | 1 | PA608416 | PM723540 |
| 15060000170679 | L15/dossiers | 15 | 15060000170678 | 15060000170678 | 1 | PA608416 | PM723540 |
| 15060000170683 | L15/dossiers | 15 | 15060000170682 | 15060000170682 | 1 | PA2116 | PM736339 |
| 15060000170693 | L15/dossiers | 15 | 15060000170692 | 15060000170692 | 1 | PA719946 | PM722808 |
| 15060000170700 | L15/dossiers | 15 | 15060000170699 | 15060000170699 | 1 | PA335054 | PM723254 |
| 15060000170713 | L15/dossiers | 15 | 15060000170712 | 15060000170712 | 1 | PA703520 | PM775705 |
| 15060000170714 | L15/dossiers | 15 | 15060000170712 | 15060000170712 | 2 | PA736213 | PM775791 |
| 15060000170715 | L15/dossiers | 15 | 15060000170712 | 15060000170712 | 3 | PA720634 | PM736312 |
| 15060000170716 | L15/dossiers | 15 | 15060000170712 | 15060000170712 | 4 | PA2538 | PM775801 |
| 15060000170735 | L15/dossiers | 15 | 15060000170734 | 15060000170734 | 1 | PA736187 | PM736365 |
| 15060000170736 | L15/dossiers | 15 | 15060000170734 | 15060000170734 | 2 | PA732419 | PM775647 |
| 15060000170737 | L15/dossiers | 15 | 15060000170734 | 15060000170734 | 3 | PA766947 | PM775799 |
| 15060000170738 | L15/dossiers | 15 | 15060000170734 | 15060000170734 | 4 | PA736241 | PM736300 |
| 15060000170739 | L15/dossiers | 15 | 15060000170734 | 15060000170734 | 5 | PA736209 | PM736400 |
| 15060000170740 | L15/dossiers | 15 | 15060000170734 | 15060000170734 | 6 | PA736248 | PM736269 |
| 15060000170741 | L15/dossiers | 15 | 15060000170734 | 15060000170734 | 7 | PA736199 | PM736284 |
| 15060000170750 | L15/dossiers | 15 | 15060000170749 | 15060000170749 | 1 | PA773441 | PM773491 |
| 15060000170751 | L15/dossiers | 15 | 15060000170749 | 15060000170749 | 2 | PA1872 | PM773455 |
| 15060000170787 | L15/dossiers | 15 | 15060000170786 | 15060000170786 | 1 | PA606202 | PM722698 |
| 15060000170788 | L15/dossiers | 15 | 15060000170786 | 15060000170786 | 2 | PA719822 | PM722772 |
| 15060000170803 | L15/dossiers | 15 | 15060000170802 | 15060000170802 | 1 | PA720538 | PM722994 |
| 15060000170810 | L15/dossiers | 15 | 15060000170809 | 15060000170809 | 1 | PA266788 | PM722914 |
| 15060000170817 | L15/dossiers | 15 | 15060000170816 | 15060000170816 | 1 | PA718926 | PM722502 |
| 15060000170824 | L15/dossiers | 15 | 15060000170823 | 15060000170823 | 1 | PA721046 | PM723154 |
| 15060000170828 | L15/dossiers | 15 | 15060000170827 | 15060000170827 | 1 | PA1206 | PM723354 |
| 15060000170835 | L15/dossiers | 15 | 15060000170834 | 15060000170834 | 1 | PA267306 | PM723054 |
| 15060000170842 | L15/dossiers | 15 | 15060000170841 | 15060000170841 | 1 | PA713448 | PM722452 |
| 15060000170849 | L15/dossiers | 15 | 15060000170848 | 15060000170848 | 1 | PA721486 | PM723290 |