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 |
|---|---|---|---|---|---|---|---|
| 14060000132431 | L14/dossiers | 14 | 14060000132430 | 14060000132430 | 1 | PA346886 | PM695110 |
| 14060000132438 | L14/dossiers | 14 | 14060000132437 | 14060000132437 | 1 | PA331567 | PM645186 |
| 14060000132448 | L14/dossiers | 14 | 14060000132447 | 14060000132447 | 1 | PA785 | PM715797 |
| 14060000132455 | L14/dossiers | 14 | 14060000132454 | 14060000132454 | 1 | PA267622 | PM702957 |
| 14060000132456 | L14/dossiers | 14 | 14060000132454 | 14060000132454 | 2 | PA328 | PM711554 |
| 14060000132489 | L14/dossiers | 14 | 14060000132488 | 14060000132488 | 1 | PA328 | PM653228 |
| 14060000132490 | L14/dossiers | 14 | 14060000132488 | 14060000132488 | 2 | PA1268 | PM653525 |
| 14060000132520 | L14/dossiers | 14 | 14060000132519 | 14060000132519 | 1 | PA267492 | PM645465 |
| 14060000132527 | L14/dossiers | 14 | 14060000132526 | 14060000132526 | 1 | PA337633 | PM645317 |
| 14060000132541 | L14/dossiers | 14 | 14060000132540 | 14060000132540 | 1 | PA689 | PM645113 |
| 14060000132548 | L14/dossiers | 14 | 14060000132547 | 14060000132547 | 1 | PA1886 | PM645099 |
| 14060000132549 | L14/dossiers | 14 | 14060000132547 | 14060000132547 | 2 | PA810 | PM645557 |
| 14060000132553 | L14/dossiers | 14 | 14060000132552 | 14060000132552 | 1 | PA1886 | PM645099 |
| 14060000132568 | L14/dossiers | 14 | 14060000132567 | 14060000132567 | 1 | PA429891 | PM430051 |
| 14060000132578 | L14/dossiers | 14 | 14060000132577 | 14060000132577 | 1 | PA606212 | PM645330 |
| 14060000132588 | L14/dossiers | 14 | 14060000132587 | 14060000132587 | 1 | PA267622 | PM702957 |
| 14060000132622 | L14/dossiers | 14 | 14060000132621 | 14060000132621 | 1 | PA336421 | PM645332 |
| 14060000132630 | L14/dossiers | 14 | 14060000132629 | 14060000132629 | 1 | PA737 | PM303909 |
| 14060000132667 | L14/dossiers | 14 | 14060000132666 | 14060000132666 | 1 | PA267330 | PM645032 |
| 14060000132674 | L14/dossiers | 14 | 14060000132673 | 14060000132673 | 1 | PA608011 | PM645066 |
| 14060000132685 | L14/dossiers | 14 | 14060000132684 | 14060000132684 | 1 | PA2277 | PM645135 |
| 14060000132692 | L14/dossiers | 14 | 14060000132691 | 14060000132691 | 1 | PA267492 | PM645465 |
| 14060000132699 | L14/dossiers | 14 | 14060000132698 | 14060000132698 | 1 | PA1886 | PM645099 |
| 14060000132721 | L14/dossiers | 14 | 14060000132720 | 14060000132720 | 1 | PA267622 | PM700712 |
| 14060000132722 | L14/dossiers | 14 | 14060000132720 | 14060000132720 | 2 | PA1268 | PM700715 |
| 14060000132754 | L14/dossiers | 14 | 14060000132753 | 14060000132753 | 1 | PA2971 | PM645392 |
| 14060000132761 | L14/dossiers | 14 | 14060000132760 | 14060000132760 | 1 | PA429858 | PM429958 |
| 14060000132785 | L14/dossiers | 14 | 14060000132784 | 14060000132784 | 1 | PA689 | PM645113 |
| 14060000132792 | L14/dossiers | 14 | 14060000132791 | 14060000132791 | 1 | PA2876 | PM645355 |
| 14060000132799 | L14/dossiers | 14 | 14060000132798 | 14060000132798 | 1 | PA1886 | PM645099 |
| 14060000132806 | L14/dossiers | 14 | 14060000132805 | 14060000132805 | 1 | PA689 | PM645113 |
| 14060000132816 | L14/dossiers | 14 | 14060000132815 | 14060000132815 | 1 | PA2098 | PM645351 |
| 14060000132823 | L14/dossiers | 14 | 14060000132822 | 14060000132822 | 1 | PA689 | PM645113 |
| 14060000132830 | L14/dossiers | 14 | 14060000132829 | 14060000132829 | 1 | PA610521 | PM645190 |
| 14060000132837 | L14/dossiers | 14 | 14060000132836 | 14060000132836 | 1 | PA230 | PM645553 |
| 14060000132844 | L14/dossiers | 14 | 14060000132843 | 14060000132843 | 1 | PA230 | PM645553 |
| 14060000132851 | L14/dossiers | 14 | 14060000132850 | 14060000132850 | 1 | PA1695 | PM645157 |
| 14060000132868 | L14/dossiers | 14 | 14060000132867 | 14060000132867 | 1 | PA2796 | PM645520 |
| 14060000132873 | L14/dossiers | 14 | 14060000132872 | 14060000132872 | 1 | PA2792 | PM645308 |
| 14060000132880 | L14/dossiers | 14 | 14060000132879 | 14060000132879 | 1 | PA687214 | PM687217 |
| 14060000132887 | L14/dossiers | 14 | 14060000132886 | 14060000132886 | 1 | PA267622 | PM702957 |
| 14060000132918 | L14/dossiers | 14 | 14060000132917 | 14060000132917 | 1 | PA609442 | PM645214 |
| 14060000132938 | L14/dossiers | 14 | 14060000132937 | 14060000132937 | 1 | PA2774 | PM429910 |
| 14060000132971 | L14/dossiers | 14 | 14060000132970 | 14060000132970 | 1 | PA1020 | PM645057 |
| 14060000132978 | L14/dossiers | 14 | 14060000132977 | 14060000132977 | 1 | PA267622 | PM702957 |
| 14060000132979 | L14/dossiers | 14 | 14060000132977 | 14060000132977 | 2 | PA1268 | PM702961 |
| 14060000132991 | L14/dossiers | 14 | 14060000132990 | 14060000132990 | 1 | PA2073 | PM645207 |
| 14060000133001 | L14/dossiers | 14 | 14060000133000 | 14060000133000 | 1 | PA267306 | PM645210 |
| 14060000133008 | L14/dossiers | 14 | 14060000133007 | 14060000133007 | 1 | PA1886 | PM645099 |
| 14060000133062 | L14/dossiers | 14 | 14060000133061 | 14060000133061 | 1 | PA267622 | PM702957 |