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 |
|---|---|---|---|---|---|---|---|
| 15060000158422 | L15/dossiers | 15 | 15060000158421 | 15060000158421 | 1 | PA703485 | PM703654 |
| 15060000158429 | L15/dossiers | 15 | 15060000158428 | 15060000158428 | 1 | PA382672 | PM736263 |
| 15060000158436 | L15/dossiers | 15 | 15060000158435 | 15060000158435 | 1 | PA703530 | PM703695 |
| 15060000158437 | L15/dossiers | 15 | 15060000158435 | 15060000158435 | 2 | PA267018 | PM703564 |
| 15060000158438 | L15/dossiers | 15 | 15060000158435 | 15060000158435 | 3 | PA703523 | PM703578 |
| 15060000158439 | L15/dossiers | 15 | 15060000158435 | 15060000158435 | 4 | PA429842 | PM736373 |
| 15060000158465 | L15/dossiers | 15 | 15060000158464 | 15060000158464 | 1 | PA720892 | PM723106 |
| 15060000158469 | L15/dossiers | 15 | 15060000158468 | 15060000158468 | 1 | PA718756 | PM722446 |
| 15060000158484 | L15/dossiers | 15 | 15060000158483 | 15060000158483 | 1 | PA718784 | PM722456 |
| 15060000158491 | L15/dossiers | 15 | 15060000158490 | 15060000158490 | 1 | PA608826 | PM723276 |
| 15060000158498 | L15/dossiers | 15 | 15060000158497 | 15060000158497 | 1 | PA721932 | PM734586 |
| 15060000158505 | L15/dossiers | 15 | 15060000158504 | 15060000158504 | 1 | PA721932 | PM734586 |
| 15060000158512 | L15/dossiers | 15 | 15060000158511 | 15060000158511 | 1 | PA719608 | PM722710 |
| 15060000158519 | L15/dossiers | 15 | 15060000158518 | 15060000158518 | 1 | PA718838 | PM722474 |
| 15060000158526 | L15/dossiers | 15 | 15060000158525 | 15060000158525 | 1 | PA718926 | PM722502 |
| 15060000158533 | L15/dossiers | 15 | 15060000158532 | 15060000158532 | 1 | PA718756 | PM722446 |
| 15060000158540 | L15/dossiers | 15 | 15060000158539 | 15060000158539 | 1 | PA718838 | PM722474 |
| 15060000158547 | L15/dossiers | 15 | 15060000158546 | 15060000158546 | 1 | PA718838 | PM722474 |
| 15060000158554 | L15/dossiers | 15 | 15060000158553 | 15060000158553 | 1 | PA718838 | PM722474 |
| 15060000158561 | L15/dossiers | 15 | 15060000158560 | 15060000158560 | 1 | PA330684 | PM722528 |
| 15060000158568 | L15/dossiers | 15 | 15060000158567 | 15060000158567 | 1 | PA718926 | PM722502 |
| 15060000158575 | L15/dossiers | 15 | 15060000158574 | 15060000158574 | 1 | PA608416 | PM723540 |
| 15060000158579 | L15/dossiers | 15 | 15060000158578 | 15060000158578 | 1 | PA345619 | PM725692 |
| 15060000158580 | L15/dossiers | 15 | 15060000158578 | 15060000158578 | 2 | PA1872 | PM730104 |
| 15060000158617 | L15/dossiers | 15 | 15060000158616 | 15060000158616 | 1 | PA718784 | PM722456 |
| 15060000158624 | L15/dossiers | 15 | 15060000158623 | 15060000158623 | 1 | PA719616 | PM722712 |
| 15060000158648 | L15/dossiers | 15 | 15060000158647 | 15060000158647 | 1 | PA719946 | PM722808 |
| 15060000158655 | L15/dossiers | 15 | 15060000158654 | 15060000158654 | 1 | PA429832 | PM736408 |
| 15060000158673 | L15/dossiers | 15 | 15060000158672 | 15060000158672 | 1 | PA1874 | PM722598 |
| 15060000158680 | L15/dossiers | 15 | 15060000158679 | 15060000158679 | 1 | PA720630 | PM723020 |
| 15060000158687 | L15/dossiers | 15 | 15060000158686 | 15060000158686 | 1 | PA720692 | PM723042 |
| 15060000158694 | L15/dossiers | 15 | 15060000158693 | 15060000158693 | 1 | PA721960 | PM723434 |
| 15060000158701 | L15/dossiers | 15 | 15060000158700 | 15060000158700 | 1 | PA712015 | PM722448 |
| 15060000158708 | L15/dossiers | 15 | 15060000158707 | 15060000158707 | 1 | PA719624 | PM722714 |
| 15060000158763 | L15/dossiers | 15 | 15060000158762 | 15060000158762 | 1 | PA342564 | PM736388 |
| 15060000158764 | L15/dossiers | 15 | 15060000158762 | 15060000158762 | 2 | PA736164 | PM736430 |
| 15060000158765 | L15/dossiers | 15 | 15060000158762 | 15060000158762 | 3 | PA736241 | PM736300 |
| 15060000158766 | L15/dossiers | 15 | 15060000158762 | 15060000158762 | 4 | PA702993 | PM736362 |
| 15060000158767 | L15/dossiers | 15 | 15060000158762 | 15060000158762 | 5 | PA703490 | PM703631 |
| 15060000158777 | L15/dossiers | 15 | 15060000158776 | 15060000158776 | 1 | PA736182 | PM736346 |
| 15060000158784 | L15/dossiers | 15 | 15060000158783 | 15060000158783 | 1 | PA720846 | PM723094 |
| 15060000158791 | L15/dossiers | 15 | 15060000158790 | 15060000158790 | 1 | PA720430 | PM722962 |
| 15060000158803 | L15/dossiers | 15 | 15060000158802 | 15060000158802 | 1 | PA1874 | PM722598 |
| 15060000158810 | L15/dossiers | 15 | 15060000158809 | 15060000158809 | 1 | PA609332 | PM723378 |
| 15060000158814 | L15/dossiers | 15 | 15060000158813 | 15060000158813 | 1 | PA205280 | PM736412 |
| 15060000158821 | L15/dossiers | 15 | 15060000158820 | 15060000158820 | 1 | PA2538 | PM703570 |
| 15060000158840 | L15/dossiers | 15 | 15060000158839 | 15060000158839 | 1 | PA1874 | PM722598 |
| 15060000158850 | L15/dossiers | 15 | 15060000158849 | 15060000158849 | 1 | PA268019 | PM723092 |
| 15060000158869 | L15/dossiers | 15 | 15060000158868 | 15060000158868 | 1 | PA267289 | PM754301 |
| 15060000158873 | L15/dossiers | 15 | 15060000158872 | 15060000158872 | 1 | PA345619 | PM725692 |