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 |
|---|---|---|---|---|---|---|---|
| 15060000163719 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 2 | PA736199 | PM736284 |
| 15060000163720 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 3 | PA736215 | PM736324 |
| 15060000163721 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 4 | PA736187 | PM736365 |
| 15060000163722 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 5 | PA766947 | PM766951 |
| 15060000163723 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 6 | PA736248 | PM736269 |
| 15060000163724 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 7 | PA736241 | PM736300 |
| 15060000163725 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 8 | PA643211 | PM703707 |
| 15060000163726 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 9 | PA736209 | PM736400 |
| 15060000163727 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 10 | PA736217 | PM736384 |
| 15060000163737 | L15/dossiers | 15 | 15060000163736 | 15060000163736 | 1 | PA736188 | PM736289 |
| 15060000163744 | L15/dossiers | 15 | 15060000163743 | 15060000163743 | 1 | PA689 | PM723090 |
| 15060000163751 | L15/dossiers | 15 | 15060000163750 | 15060000163750 | 1 | PA720900 | PM723108 |
| 15060000163828 | L15/dossiers | 15 | 15060000163827 | 15060000163827 | 1 | PA606507 | PM722720 |
| 15060000163838 | L15/dossiers | 15 | 15060000163837 | 15060000163837 | 1 | PA721506 | PM723296 |
| 15060000163845 | L15/dossiers | 15 | 15060000163844 | 15060000163844 | 1 | PA607553 | PM722956 |
| 15060000163852 | L15/dossiers | 15 | 15060000163851 | 15060000163851 | 1 | PA609726 | PM723426 |
| 15060000163856 | L15/dossiers | 15 | 15060000163855 | 15060000163855 | 1 | PA608416 | PM723540 |
| 15060000163860 | L15/dossiers | 15 | 15060000163859 | 15060000163859 | 1 | PA608416 | PM723540 |
| 15060000163864 | L15/dossiers | 15 | 15060000163863 | 15060000163863 | 1 | PA722142 | PM723484 |
| 15060000163876 | L15/dossiers | 15 | 15060000163875 | 15060000163875 | 1 | PA721960 | PM723434 |
| 15060000163884 | L15/dossiers | 15 | 15060000163883 | 15060000163883 | 1 | PA2150 | PM722506 |
| 15060000163893 | L15/dossiers | 15 | 15060000163892 | 15060000163892 | 1 | PA720664 | PM723032 |
| 15060000163900 | L15/dossiers | 15 | 15060000163899 | 15060000163899 | 1 | PA2150 | PM722506 |
| 15060000163912 | L15/dossiers | 15 | 15060000163911 | 15060000163911 | 1 | PA2116 | PM736339 |
| 15060000163919 | L15/dossiers | 15 | 15060000163918 | 15060000163918 | 1 | PA718784 | PM722456 |
| 15060000163926 | L15/dossiers | 15 | 15060000163925 | 15060000163925 | 1 | PA608416 | PM723540 |
| 15060000163933 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 1 | PA736161 | PM736421 |
| 15060000163934 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 2 | PA268048 | PM736422 |
| 15060000163935 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 3 | PA415483 | PM703615 |
| 15060000163936 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 4 | PA708633 | PM708642 |
| 15060000163937 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 5 | PA736164 | PM736430 |
| 15060000163938 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 6 | PA736225 | PM736334 |
| 15060000163939 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 7 | PA342564 | PM736388 |
| 15060000163940 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 8 | PA429844 | PM736276 |
| 15060000163941 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 9 | PA429889 | PM736313 |
| 15060000163942 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 10 | PA429889 | PM736313 |
| 15060000163943 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 11 | PA703491 | PM703634 |
| 15060000163944 | L15/dossiers | 15 | 15060000163932 | 15060000163932 | 12 | PA736162 | PM736320 |
| 15060000163954 | L15/dossiers | 15 | 15060000163953 | 15060000163953 | 1 | PA266788 | PM722914 |
| 15060000163961 | L15/dossiers | 15 | 15060000163960 | 15060000163960 | 1 | PA345722 | PM723428 |
| 15060000163968 | L15/dossiers | 15 | 15060000163967 | 15060000163967 | 1 | PA345619 | PM725692 |
| 15060000163969 | L15/dossiers | 15 | 15060000163967 | 15060000163967 | 2 | PA702191 | PM730058 |
| 15060000163976 | L15/dossiers | 15 | 15060000163975 | 15060000163975 | 1 | PA345619 | PM725692 |
| 15060000163977 | L15/dossiers | 15 | 15060000163975 | 15060000163975 | 2 | PA642788 | PM770473 |
| 15060000163984 | L15/dossiers | 15 | 15060000163983 | 15060000163983 | 1 | PA345619 | PM725692 |
| 15060000163985 | L15/dossiers | 15 | 15060000163983 | 15060000163983 | 2 | PA605131 | PM759784 |
| 15060000163992 | L15/dossiers | 15 | 15060000163991 | 15060000163991 | 1 | PA345619 | PM725692 |
| 15060000163993 | L15/dossiers | 15 | 15060000163991 | 15060000163991 | 2 | PA331481 | PM730094 |
| 15060000164000 | L15/dossiers | 15 | 15060000163999 | 15060000163999 | 1 | PA345619 | PM725692 |
| 15060000164001 | L15/dossiers | 15 | 15060000163999 | 15060000163999 | 2 | PA717169 | PM730074 |