viewcalc_country_year_share
Data source: ParlGov · About: simonw/parlgov-datasette
9,069 rows sorted by share
This data as json, CSV (advanced)
Link | rowid | id_type | year | id | share ▼ |
---|---|---|---|---|---|
2613 | 2613 | cabinet | 1991 | 725 | 0.03021978021978022 |
2614 | 2614 | cabinet | 1991 | 728 | 0.03021978021978022 |
2681 | 2681 | cabinet | 1993 | 9 | 0.03021978021978022 |
2718 | 2718 | cabinet | 1993 | 690 | 0.03021978021978022 |
2735 | 2735 | cabinet | 1993 | 870 | 0.03021978021978022 |
3464 | 3464 | cabinet | 2007 | 42 | 0.03021978021978022 |
3971 | 3971 | cabinet | 2015 | 1421 | 0.03021978021978022 |
7687 | 7687 | parliament | 2015 | 998 | 0.03021978021978022 |
85 | 85 | cabinet | 1908 | 1323 | 0.03287671232876712 |
1866 | 1866 | cabinet | 1972 | 507 | 0.03287671232876712 |
4209 | 4209 | cabinet | 2020 | 1504 | 0.03287671232876712 |
128 | 128 | cabinet | 1911 | 1324 | 0.03296703296703297 |
1099 | 1099 | cabinet | 1949 | 450 | 0.03296703296703297 |
1449 | 1449 | cabinet | 1959 | 552 | 0.03296703296703297 |
1708 | 1708 | cabinet | 1967 | 634 | 0.03296703296703297 |
1901 | 1901 | cabinet | 1973 | 744 | 0.03296703296703297 |
2037 | 2037 | cabinet | 1977 | 563 | 0.03296703296703297 |
3190 | 3190 | cabinet | 2002 | 187 | 0.03296703296703297 |
4146 | 4146 | cabinet | 2019 | 1175 | 0.03296703296703297 |
4524 | 4524 | parliament | 1911 | 952 | 0.03296703296703297 |
4886 | 4886 | parliament | 1931 | 744 | 0.03296703296703297 |
150 | 150 | cabinet | 1912 | 1394 | 0.03561643835616438 |
647 | 647 | cabinet | 1932 | 1336 | 0.03561643835616438 |
650 | 650 | cabinet | 1932 | 1340 | 0.03561643835616438 |
4264 | 4264 | cabinet | 2020 | 1668 | 0.03561643835616438 |
47 | 47 | cabinet | 1905 | 1366 | 0.03571428571428571 |
1567 | 1567 | cabinet | 1963 | 332 | 0.03571428571428571 |
1586 | 1586 | cabinet | 1963 | 786 | 0.03571428571428571 |
1633 | 1633 | cabinet | 1965 | 415 | 0.03571428571428571 |
1806 | 1806 | cabinet | 1970 | 787 | 0.03571428571428571 |
2178 | 2178 | cabinet | 1981 | 83 | 0.03571428571428571 |
2523 | 2523 | cabinet | 1990 | 11 | 0.03571428571428571 |
3068 | 3068 | cabinet | 1999 | 915 | 0.03571428571428571 |
4085 | 4085 | cabinet | 2017 | 1521 | 0.03571428571428571 |
6255 | 6255 | parliament | 1983 | 138 | 0.03571428571428571 |
6675 | 6675 | parliament | 1994 | 355 | 0.03571428571428571 |
1210 | 1210 | cabinet | 1952 | 700 | 0.038356164383561646 |
229 | 229 | cabinet | 1917 | 1469 | 0.038461538461538464 |
263 | 263 | cabinet | 1919 | 1321 | 0.038461538461538464 |
356 | 356 | cabinet | 1922 | 1355 | 0.038461538461538464 |
429 | 429 | cabinet | 1925 | 979 | 0.038461538461538464 |
487 | 487 | cabinet | 1926 | 1544 | 0.038461538461538464 |
497 | 497 | cabinet | 1927 | 1207 | 0.038461538461538464 |
603 | 603 | cabinet | 1931 | 976 | 0.038461538461538464 |
1450 | 1450 | cabinet | 1959 | 623 | 0.038461538461538464 |
1463 | 1463 | cabinet | 1959 | 932 | 0.038461538461538464 |
2209 | 2209 | cabinet | 1981 | 724 | 0.038461538461538464 |
2549 | 2549 | cabinet | 1990 | 524 | 0.038461538461538464 |
3851 | 3851 | cabinet | 2013 | 1071 | 0.038461538461538464 |
4268 | 4268 | cabinet | 2021 | 1530 | 0.038461538461538464 |
4304 | 4304 | cabinet | 2021 | 1649 | 0.038461538461538464 |
4590 | 4590 | parliament | 1917 | 862 | 0.038461538461538464 |
4631 | 4631 | parliament | 1919 | 954 | 0.038461538461538464 |
6108 | 6108 | parliament | 1978 | 663 | 0.038461538461538464 |
6714 | 6714 | parliament | 1995 | 162 | 0.038461538461538464 |
2892 | 2892 | cabinet | 1996 | 620 | 0.0410958904109589 |
7541 | 7541 | parliament | 2012 | 788 | 0.0410958904109589 |
323 | 323 | cabinet | 1921 | 1278 | 0.04120879120879121 |
328 | 328 | cabinet | 1921 | 1356 | 0.04120879120879121 |
458 | 458 | cabinet | 1925 | 1570 | 0.04120879120879121 |
895 | 895 | cabinet | 1942 | 1025 | 0.04120879120879121 |
994 | 994 | cabinet | 1946 | 52 | 0.04120879120879121 |
3850 | 3850 | cabinet | 2013 | 1070 | 0.04120879120879121 |
4432 | 4432 | parliament | 1903 | 730 | 0.04120879120879121 |
4681 | 4681 | parliament | 1922 | 726 | 0.04120879120879121 |
1878 | 1878 | cabinet | 1972 | 871 | 0.043835616438356165 |
1998 | 1998 | cabinet | 1976 | 459 | 0.043835616438356165 |
5800 | 5800 | parliament | 1968 | 166 | 0.043835616438356165 |
446 | 446 | cabinet | 1925 | 1312 | 0.04395604395604396 |
836 | 836 | cabinet | 1939 | 1297 | 0.04395604395604396 |
912 | 912 | cabinet | 1943 | 972 | 0.04395604395604396 |
1186 | 1186 | cabinet | 1951 | 872 | 0.04395604395604396 |
1308 | 1308 | cabinet | 1955 | 635 | 0.04395604395604396 |
1779 | 1779 | cabinet | 1969 | 939 | 0.04395604395604396 |
2771 | 2771 | cabinet | 1994 | 573 | 0.04395604395604396 |
2836 | 2836 | cabinet | 1995 | 672 | 0.04395604395604396 |
3036 | 3036 | cabinet | 1999 | 198 | 0.04395604395604396 |
3742 | 3742 | cabinet | 2011 | 1031 | 0.04395604395604396 |
3882 | 3882 | cabinet | 2014 | 1062 | 0.04395604395604396 |
3915 | 3915 | cabinet | 2014 | 1154 | 0.04395604395604396 |
4120 | 4120 | cabinet | 2018 | 1516 | 0.04395604395604396 |
4375 | 4375 | cabinet | 2022 | 1684 | 0.04395604395604396 |
404 | 404 | cabinet | 1924 | 1214 | 0.04657534246575343 |
636 | 636 | cabinet | 1932 | 1202 | 0.04657534246575343 |
3312 | 3312 | cabinet | 2004 | 287 | 0.04657534246575343 |
3574 | 3574 | cabinet | 2008 | 1132 | 0.04657534246575343 |
137 | 137 | cabinet | 1911 | 1459 | 0.046703296703296704 |
337 | 337 | cabinet | 1922 | 980 | 0.046703296703296704 |
471 | 471 | cabinet | 1926 | 1245 | 0.046703296703296704 |
1259 | 1259 | cabinet | 1953 | 1473 | 0.046703296703296704 |
1285 | 1285 | cabinet | 1954 | 798 | 0.046703296703296704 |
1655 | 1655 | cabinet | 1966 | 67 | 0.046703296703296704 |
1712 | 1712 | cabinet | 1967 | 777 | 0.046703296703296704 |
2252 | 2252 | cabinet | 1982 | 867 | 0.046703296703296704 |
2589 | 2589 | cabinet | 1991 | 286 | 0.046703296703296704 |
3458 | 3458 | cabinet | 2006 | 1128 | 0.046703296703296704 |
3737 | 3737 | cabinet | 2011 | 986 | 0.046703296703296704 |
3740 | 3740 | cabinet | 2011 | 989 | 0.046703296703296704 |
4176 | 4176 | cabinet | 2019 | 1587 | 0.046703296703296704 |
4376 | 4376 | cabinet | 2022 | 1685 | 0.046703296703296704 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE `viewcalc_country_year_share` ( `id_type` TEXT, `year` INTEGER, `id` INTEGER, `share` REAL );