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 |
|---|---|---|---|---|---|---|---|
| 15060000145356 | L15/dossiers | 15 | 15060000145355 | 15060000145355 | 1 | PA345619 | PM725692 |
| 15060000145416 | L15/dossiers | 15 | 15060000145415 | 15060000145415 | 1 | PA345619 | PM725692 |
| 15060000145478 | L15/dossiers | 15 | 15060000145477 | 15060000145477 | 1 | PA609726 | PM723426 |
| 15060000145485 | L15/dossiers | 15 | 15060000145484 | 15060000145484 | 1 | PA609726 | PM723426 |
| 15060000145492 | L15/dossiers | 15 | 15060000145491 | 15060000145491 | 1 | PA718850 | PM722478 |
| 15060000145499 | L15/dossiers | 15 | 15060000145498 | 15060000145498 | 1 | PA335999 | PM723480 |
| 15060000145506 | L15/dossiers | 15 | 15060000145505 | 15060000145505 | 1 | PA335999 | PM723480 |
| 15060000145513 | L15/dossiers | 15 | 15060000145512 | 15060000145512 | 1 | PA718838 | PM722474 |
| 15060000145520 | L15/dossiers | 15 | 15060000145519 | 15060000145519 | 1 | PA1874 | PM722598 |
| 15060000145527 | L15/dossiers | 15 | 15060000145526 | 15060000145526 | 1 | PA1874 | PM722598 |
| 15060000145534 | L15/dossiers | 15 | 15060000145533 | 15060000145533 | 1 | PA1874 | PM722598 |
| 15060000145541 | L15/dossiers | 15 | 15060000145540 | 15060000145540 | 1 | PA1874 | PM722598 |
| 15060000145548 | L15/dossiers | 15 | 15060000145547 | 15060000145547 | 1 | PA266808 | PM723264 |
| 15060000145555 | L15/dossiers | 15 | 15060000145554 | 15060000145554 | 1 | PA342935 | PM722856 |
| 15060000145562 | L15/dossiers | 15 | 15060000145561 | 15060000145561 | 1 | PA1874 | PM722598 |
| 15060000145573 | L15/dossiers | 15 | 15060000145572 | 15060000145572 | 1 | PA721466 | PM723284 |
| 15060000145605 | L15/dossiers | 15 | 15060000145604 | 15060000145604 | 1 | PA719740 | PM722748 |
| 15060000145657 | L15/dossiers | 15 | 15060000145656 | 15060000145656 | 1 | PA267233 | PM723500 |
| 15060000145681 | L15/dossiers | 15 | 15060000145680 | 15060000145680 | 1 | PA340343 | PM722470 |
| 15060000145700 | L15/dossiers | 15 | 15060000145699 | 15060000145699 | 1 | PA333285 | PM722906 |
| 15060000145725 | L15/dossiers | 15 | 15060000145724 | 15060000145724 | 1 | PA643145 | PM723130 |
| 15060000145739 | L15/dossiers | 15 | 15060000145738 | 15060000145738 | 1 | PA713448 | PM722452 |
| 15060000145746 | L15/dossiers | 15 | 15060000145745 | 15060000145745 | 1 | PA721062 | PM723158 |
| 15060000145753 | L15/dossiers | 15 | 15060000145752 | 15060000145752 | 1 | PA721062 | PM723158 |
| 15060000145760 | L15/dossiers | 15 | 15060000145759 | 15060000145759 | 1 | PA267429 | PM722818 |
| 15060000145767 | L15/dossiers | 15 | 15060000145766 | 15060000145766 | 1 | PA268019 | PM723092 |
| 15060000145781 | L15/dossiers | 15 | 15060000145780 | 15060000145780 | 1 | PA345619 | PM725692 |
| 15060000145782 | L15/dossiers | 15 | 15060000145780 | 15060000145780 | 2 | PA717169 | PM730074 |
| 15060000145783 | L15/dossiers | 15 | 15060000145780 | 15060000145780 | 3 | PA717153 | PM730062 |
| 15060000145826 | L15/dossiers | 15 | 15060000145825 | 15060000145825 | 1 | PA718926 | PM722502 |
| 15060000145833 | L15/dossiers | 15 | 15060000145832 | 15060000145832 | 1 | PA266797 | PM722884 |
| 15060000145840 | L15/dossiers | 15 | 15060000145839 | 15060000145839 | 1 | PA721062 | PM723158 |
| 15060000145850 | L15/dossiers | 15 | 15060000145849 | 15060000145849 | 1 | PA2150 | PM722506 |
| 15060000145862 | L15/dossiers | 15 | 15060000145861 | 15060000145861 | 1 | PA610667 | PM723146 |
| 15060000145866 | L15/dossiers | 15 | 15060000145865 | 15060000145865 | 1 | PA720286 | PM722918 |
| 15060000145873 | L15/dossiers | 15 | 15060000145872 | 15060000145872 | 1 | PA718860 | PM722482 |
| 15060000145891 | L15/dossiers | 15 | 15060000145890 | 15060000145890 | 1 | PA719578 | PM722702 |
| 15060000145915 | L15/dossiers | 15 | 15060000145914 | 15060000145914 | 1 | PA588884 | PM723226 |
| 15060000145928 | L15/dossiers | 15 | 15060000145927 | 15060000145927 | 1 | PA606098 | PM722642 |
| 15060000145935 | L15/dossiers | 15 | 15060000145934 | 15060000145934 | 1 | PA721932 | PM734586 |
| 15060000145939 | L15/dossiers | 15 | 15060000145938 | 15060000145938 | 1 | PA266788 | PM722914 |
| 15060000145944 | L15/dossiers | 15 | 15060000145943 | 15060000145943 | 1 | PA415454 | PM703689 |
| 15060000145962 | L15/dossiers | 15 | 15060000145961 | 15060000145961 | 1 | PA721816 | PM748964 |
| 15060000145966 | L15/dossiers | 15 | 15060000145965 | 15060000145965 | 1 | PA721932 | PM734586 |
| 15060000145973 | L15/dossiers | 15 | 15060000145972 | 15060000145972 | 1 | PA415454 | PM703689 |
| 15060000145992 | L15/dossiers | 15 | 15060000145991 | 15060000145991 | 1 | PA429842 | PM736373 |
| 15060000146018 | L15/dossiers | 15 | 15060000146017 | 15060000146017 | 1 | PA415486 | PM703623 |
| 15060000146030 | L15/dossiers | 15 | 15060000146029 | 15060000146029 | 1 | PA2150 | PM722506 |
| 15060000146043 | L15/dossiers | 15 | 15060000146042 | 15060000146042 | 1 | PA718868 | PM722484 |
| 15060000146058 | L15/dossiers | 15 | 15060000146057 | 15060000146057 | 1 | PA2774 | PM736307 |