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 |
|---|---|---|---|---|---|---|---|
| 14060000103273 | L14/dossiers | 14 | 14060000103272 | 14060000103272 | 1 | PA1886 | PM645099 |
| 14060000103278 | L14/dossiers | 14 | 14060000103277 | 14060000103277 | 1 | PA785 | PM715797 |
| 14060000103285 | L14/dossiers | 14 | 14060000103284 | 14060000103284 | 1 | PA605922 | PM645493 |
| 14060000103295 | L14/dossiers | 14 | 14060000103294 | 14060000103294 | 1 | PA1152 | PM645561 |
| 14060000103302 | L14/dossiers | 14 | 14060000103301 | 14060000103301 | 1 | PA328 | PM653228 |
| 14060000103303 | L14/dossiers | 14 | 14060000103301 | 14060000103301 | 2 | PA1268 | PM653525 |
| 14060000103335 | L14/dossiers | 14 | 14060000103334 | 14060000103334 | 1 | PA267246 | PM645340 |
| 14060000103342 | L14/dossiers | 14 | 14060000103341 | 14060000103341 | 1 | PA785 | PM715797 |
| 14060000103352 | L14/dossiers | 14 | 14060000103351 | 14060000103351 | 1 | PA2971 | PM645392 |
| 14060000103359 | L14/dossiers | 14 | 14060000103358 | 14060000103358 | 1 | PA267622 | PM702957 |
| 14060000103360 | L14/dossiers | 14 | 14060000103358 | 14060000103358 | 2 | PA2791 | PM702981 |
| 14060000103361 | L14/dossiers | 14 | 14060000103358 | 14060000103358 | 3 | PA1872 | PM702970 |
| 14060000103362 | L14/dossiers | 14 | 14060000103358 | 14060000103358 | 4 | PA785 | PM702979 |
| 14060000103443 | L14/dossiers | 14 | 14060000103442 | 14060000103442 | 1 | PA609245 | PM645150 |
| 14060000103450 | L14/dossiers | 14 | 14060000103449 | 14060000103449 | 1 | PA643069 | PM701218 |
| 14060000103457 | L14/dossiers | 14 | 14060000103456 | 14060000103456 | 1 | PA335159 | PM645554 |
| 14060000103464 | L14/dossiers | 14 | 14060000103463 | 14060000103463 | 1 | PA267622 | PM700712 |
| 14060000103651 | L14/dossiers | 14 | 14060000103650 | 14060000103650 | 1 | PA335159 | PM645554 |
| 14060000103658 | L14/dossiers | 14 | 14060000103657 | 14060000103657 | 1 | PA332747 | PM645155 |
| 14060000103671 | L14/dossiers | 14 | 14060000103670 | 14060000103670 | 1 | PA268019 | PM645116 |
| 14060000103678 | L14/dossiers | 14 | 14060000103677 | 14060000103677 | 1 | PA230 | PM645553 |
| 14060000103685 | L14/dossiers | 14 | 14060000103684 | 14060000103684 | 1 | PA2045 | PM645421 |
| 14060000103701 | L14/dossiers | 14 | 14060000103700 | 14060000103700 | 1 | PA1886 | PM645099 |
| 14060000103702 | L14/dossiers | 14 | 14060000103700 | 14060000103700 | 2 | PA605349 | PM645483 |
| 14060000103723 | L14/dossiers | 14 | 14060000103722 | 14060000103722 | 1 | PA328 | PM653228 |
| 14060000103753 | L14/dossiers | 14 | 14060000103752 | 14060000103752 | 1 | PA689 | PM645113 |
| 14060000103760 | L14/dossiers | 14 | 14060000103759 | 14060000103759 | 1 | PA266774 | PM645583 |
| 14060000103767 | L14/dossiers | 14 | 14060000103766 | 14060000103766 | 1 | PA267622 | PM702957 |
| 14060000103774 | L14/dossiers | 14 | 14060000103773 | 14060000103773 | 1 | PA267622 | PM702957 |
| 14060000103806 | L14/dossiers | 14 | 14060000103805 | 14060000103805 | 1 | PA2971 | PM645392 |
| 14060000103813 | L14/dossiers | 14 | 14060000103812 | 14060000103812 | 1 | PA267622 | PM702957 |
| 14060000103820 | L14/dossiers | 14 | 14060000103819 | 14060000103819 | 1 | PA346886 | PM695110 |
| 14060000103830 | L14/dossiers | 14 | 14060000103829 | 14060000103829 | 1 | PA267622 | PM702957 |
| 14060000103831 | L14/dossiers | 14 | 14060000103829 | 14060000103829 | 2 | PA2791 | PM702981 |
| 14060000103838 | L14/dossiers | 14 | 14060000103837 | 14060000103837 | 1 | PA335054 | PM645614 |
| 14060000103851 | L14/dossiers | 14 | 14060000103850 | 14060000103850 | 1 | PA429844 | PM430022 |
| 14060000103971 | L14/dossiers | 14 | 14060000103970 | 14060000103970 | 1 | PA309643 | PM645326 |
| 14060000103978 | L14/dossiers | 14 | 14060000103977 | 14060000103977 | 1 | PA267075 | PM645258 |
| 14060000103985 | L14/dossiers | 14 | 14060000103984 | 14060000103984 | 1 | PA605131 | PM645420 |
| 14060000103992 | L14/dossiers | 14 | 14060000103991 | 14060000103991 | 1 | PA267762 | PM645455 |
| 14060000103999 | L14/dossiers | 14 | 14060000103998 | 14060000103998 | 1 | PA607155 | PM645200 |
| 14060000104019 | L14/dossiers | 14 | 14060000104018 | 14060000104018 | 1 | PA605518 | PM645500 |
| 14060000104026 | L14/dossiers | 14 | 14060000104025 | 14060000104025 | 1 | PA267260 | PM645459 |
| 14060000104033 | L14/dossiers | 14 | 14060000104032 | 14060000104032 | 1 | PA608662 | PM645592 |
| 14060000104040 | L14/dossiers | 14 | 14060000104039 | 14060000104039 | 1 | PA267622 | PM702957 |
| 14060000104082 | L14/dossiers | 14 | 14060000104081 | 14060000104081 | 1 | PA267622 | PM702957 |
| 14060000104083 | L14/dossiers | 14 | 14060000104081 | 14060000104081 | 2 | PA2679 | PM702976 |
| 14060000104092 | L14/dossiers | 14 | 14060000104091 | 14060000104091 | 1 | PA785 | PM715797 |
| 14060000104093 | L14/dossiers | 14 | 14060000104091 | 14060000104091 | 2 | PA331594 | PM715818 |
| 14060000104100 | L14/dossiers | 14 | 14060000104099 | 14060000104099 | 1 | PA1483 | PM645274 |