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 |
|---|---|---|---|---|---|---|---|
| 15060000171566 | L15/dossiers | 15 | 15060000171565 | 15060000171565 | 1 | PA773441 | PM773491 |
| 15060000171567 | L15/dossiers | 15 | 15060000171565 | 15060000171565 | 2 | PA1872 | PM773455 |
| 15060000171600 | L15/dossiers | 15 | 15060000171599 | 15060000171599 | 1 | PA267318 | PM723260 |
| 15060000171607 | L15/dossiers | 15 | 15060000171606 | 15060000171606 | 1 | PA267318 | PM723260 |
| 15060000171614 | L15/dossiers | 15 | 15060000171613 | 15060000171613 | 1 | PA718838 | PM722474 |
| 15060000171621 | L15/dossiers | 15 | 15060000171620 | 15060000171620 | 1 | PA1874 | PM722598 |
| 15060000171628 | L15/dossiers | 15 | 15060000171627 | 15060000171627 | 1 | PA1874 | PM722598 |
| 15060000171635 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 1 | PA429889 | PM736313 |
| 15060000171636 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 2 | PA736167 | PM736327 |
| 15060000171637 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 3 | PA605888 | PM775604 |
| 15060000171638 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 4 | PA775196 | PM775482 |
| 15060000171639 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 5 | PA703538 | PM775715 |
| 15060000171640 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 6 | PA415453 | PM703691 |
| 15060000171641 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 7 | PA703511 | PM775685 |
| 15060000171642 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 8 | PA736191 | PM736336 |
| 15060000171643 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 9 | PA1978 | PM736337 |
| 15060000171644 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 10 | PA2074 | PM775677 |
| 15060000171645 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 11 | PA736225 | PM736334 |
| 15060000171646 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 12 | PA775180 | PM775466 |
| 15060000171647 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 13 | PA775214 | PM775498 |
| 15060000171648 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 14 | PA429844 | PM736276 |
| 15060000171649 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 15 | PA736187 | PM736365 |
| 15060000171650 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 16 | PA2870 | PM736316 |
| 15060000171651 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 17 | PA775224 | PM775512 |
| 15060000171652 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 18 | PA429845 | PM736278 |
| 15060000171653 | L15/dossiers | 15 | 15060000171634 | 15060000171634 | 19 | PA429866 | PM736287 |
| 15060000171660 | L15/dossiers | 15 | 15060000171659 | 15060000171659 | 1 | PA998 | PM723046 |
| 15060000171667 | L15/dossiers | 15 | 15060000171666 | 15060000171666 | 1 | PA605131 | PM774339 |
| 15060000171671 | L15/dossiers | 15 | 15060000171670 | 15060000171670 | 1 | PA719020 | PM774184 |
| 15060000171678 | L15/dossiers | 15 | 15060000171677 | 15060000171677 | 1 | PA331567 | PM722644 |
| 15060000171685 | L15/dossiers | 15 | 15060000171684 | 15060000171684 | 1 | PA1874 | PM722598 |
| 15060000171692 | L15/dossiers | 15 | 15060000171691 | 15060000171691 | 1 | PA703532 | PM775699 |
| 15060000171745 | L15/dossiers | 15 | 15060000171744 | 15060000171744 | 1 | PA721474 | PM723286 |
| 15060000171752 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 1 | PA330684 | PM775859 |
| 15060000171753 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 2 | PA775240 | PM775530 |
| 15060000171754 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 3 | PA736192 | PM736353 |
| 15060000171755 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 4 | PA703527 | PM775709 |
| 15060000171756 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 5 | PA415447 | PM775785 |
| 15060000171757 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 6 | PA703500 | PM775643 |
| 15060000171758 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 7 | PA703518 | PM775673 |
| 15060000171759 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 8 | PA716 | PM736261 |
| 15060000171760 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 9 | PA227078 | PM736258 |
| 15060000171761 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 10 | PA1344 | PM736383 |
| 15060000171762 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 11 | PA703530 | PM775689 |
| 15060000171763 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 12 | PA736247 | PM736281 |
| 15060000171764 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 13 | PA267907 | PM775751 |
| 15060000171765 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 14 | PA736198 | PM736406 |
| 15060000171766 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 15 | PA703520 | PM775705 |
| 15060000171767 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 16 | PA775228 | PM775516 |
| 15060000171768 | L15/dossiers | 15 | 15060000171751 | 15060000171751 | 17 | PA775280 | PM775586 |