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 ▼ |
---|---|---|---|---|---|
4607 | 4607 | parliament | 1918 | 905 | 0.046703296703296704 |
5401 | 5401 | parliament | 1953 | 272 | 0.046703296703296704 |
7636 | 7636 | parliament | 2014 | 850 | 0.046703296703296704 |
518 | 518 | cabinet | 1928 | 977 | 0.049315068493150684 |
533 | 533 | cabinet | 1928 | 1299 | 0.049315068493150684 |
2312 | 2312 | cabinet | 1984 | 401 | 0.049315068493150684 |
3794 | 3794 | cabinet | 2012 | 1042 | 0.049315068493150684 |
227 | 227 | cabinet | 1917 | 1464 | 0.04945054945054945 |
251 | 251 | cabinet | 1919 | 1011 | 0.04945054945054945 |
467 | 467 | cabinet | 1926 | 1208 | 0.04945054945054945 |
589 | 589 | cabinet | 1930 | 1341 | 0.04945054945054945 |
818 | 818 | cabinet | 1939 | 973 | 0.04945054945054945 |
825 | 825 | cabinet | 1939 | 1179 | 0.04945054945054945 |
1002 | 1002 | cabinet | 1946 | 168 | 0.04945054945054945 |
1184 | 1184 | cabinet | 1951 | 814 | 0.04945054945054945 |
2293 | 2293 | cabinet | 1983 | 1087 | 0.04945054945054945 |
2744 | 2744 | cabinet | 1994 | 26 | 0.04945054945054945 |
2799 | 2799 | cabinet | 1995 | 38 | 0.04945054945054945 |
4086 | 4086 | cabinet | 2017 | 1522 | 0.04945054945054945 |
4193 | 4193 | cabinet | 2019 | 1606 | 0.04945054945054945 |
4314 | 4314 | cabinet | 2021 | 1660 | 0.04945054945054945 |
4616 | 4616 | parliament | 1919 | 723 | 0.04945054945054945 |
6017 | 6017 | parliament | 1975 | 757 | 0.04945054945054945 |
6388 | 6388 | parliament | 1987 | 191 | 0.04945054945054945 |
208 | 208 | cabinet | 1916 | 1403 | 0.052054794520547946 |
296 | 296 | cabinet | 1920 | 1413 | 0.052054794520547946 |
933 | 933 | cabinet | 1944 | 29 | 0.052054794520547946 |
1216 | 1216 | cabinet | 1952 | 826 | 0.052054794520547946 |
1487 | 1487 | cabinet | 1960 | 701 | 0.052054794520547946 |
1732 | 1732 | cabinet | 1968 | 554 | 0.052054794520547946 |
4028 | 4028 | cabinet | 2016 | 1499 | 0.052054794520547946 |
4030 | 4030 | cabinet | 2016 | 1501 | 0.052054794520547946 |
490 | 490 | cabinet | 1926 | 1572 | 0.0521978021978022 |
546 | 546 | cabinet | 1929 | 978 | 0.0521978021978022 |
821 | 821 | cabinet | 1939 | 1019 | 0.0521978021978022 |
1572 | 1572 | cabinet | 1963 | 513 | 0.0521978021978022 |
1960 | 1960 | cabinet | 1975 | 285 | 0.0521978021978022 |
2086 | 2086 | cabinet | 1978 | 669 | 0.0521978021978022 |
2108 | 2108 | cabinet | 1979 | 442 | 0.0521978021978022 |
2810 | 2810 | cabinet | 1995 | 222 | 0.0521978021978022 |
3243 | 3243 | cabinet | 2003 | 103 | 0.0521978021978022 |
3495 | 3495 | cabinet | 2007 | 508 | 0.0521978021978022 |
6187 | 6187 | parliament | 1981 | 136 | 0.0521978021978022 |
6487 | 6487 | parliament | 1990 | 157 | 0.0521978021978022 |
7879 | 7879 | parliament | 2019 | 1086 | 0.0521978021978022 |
1869 | 1869 | cabinet | 1972 | 586 | 0.0547945205479452 |
2677 | 2677 | cabinet | 1992 | 955 | 0.0547945205479452 |
2856 | 2856 | cabinet | 1996 | 73 | 0.0547945205479452 |
7734 | 7734 | parliament | 2016 | 1015 | 0.0547945205479452 |
17 | 17 | cabinet | 1902 | 1456 | 0.054945054945054944 |
163 | 163 | cabinet | 1913 | 1395 | 0.054945054945054944 |
249 | 249 | cabinet | 1919 | 981 | 0.054945054945054944 |
715 | 715 | cabinet | 1935 | 974 | 0.054945054945054944 |
1044 | 1044 | cabinet | 1947 | 556 | 0.054945054945054944 |
1136 | 1136 | cabinet | 1950 | 676 | 0.054945054945054944 |
1390 | 1390 | cabinet | 1957 | 869 | 0.054945054945054944 |
2185 | 2185 | cabinet | 1981 | 259 | 0.054945054945054944 |
2434 | 2434 | cabinet | 1987 | 828 | 0.054945054945054944 |
4089 | 4089 | cabinet | 2017 | 1526 | 0.054945054945054944 |
4198 | 4198 | cabinet | 2019 | 1612 | 0.054945054945054944 |
4560 | 4560 | parliament | 1914 | 953 | 0.054945054945054944 |
535 | 535 | cabinet | 1928 | 1314 | 0.057534246575342465 |
2854 | 2854 | cabinet | 1996 | 47 | 0.057534246575342465 |
2857 | 2857 | cabinet | 1996 | 74 | 0.057534246575342465 |
3129 | 3129 | cabinet | 2000 | 1138 | 0.057534246575342465 |
3569 | 3569 | cabinet | 2008 | 903 | 0.057534246575342465 |
3977 | 3977 | cabinet | 2016 | 1056 | 0.057534246575342465 |
5921 | 5921 | parliament | 1972 | 333 | 0.057534246575342465 |
1025 | 1025 | cabinet | 1947 | 52 | 0.057692307692307696 |
1306 | 1306 | cabinet | 1955 | 545 | 0.057692307692307696 |
1413 | 1413 | cabinet | 1958 | 594 | 0.057692307692307696 |
1414 | 1414 | cabinet | 1958 | 627 | 0.057692307692307696 |
1951 | 1951 | cabinet | 1975 | 20 | 0.057692307692307696 |
3281 | 3281 | cabinet | 2003 | 855 | 0.057692307692307696 |
3864 | 3864 | cabinet | 2014 | 971 | 0.057692307692307696 |
4159 | 4159 | cabinet | 2019 | 1517 | 0.057692307692307696 |
4194 | 4194 | cabinet | 2019 | 1607 | 0.057692307692307696 |
5304 | 5304 | parliament | 1949 | 734 | 0.057692307692307696 |
5470 | 5470 | parliament | 1955 | 742 | 0.057692307692307696 |
6080 | 6080 | parliament | 1977 | 755 | 0.057692307692307696 |
7076 | 7076 | parliament | 2003 | 74 | 0.057692307692307696 |
7564 | 7564 | parliament | 2013 | 721 | 0.057692307692307696 |
414 | 414 | cabinet | 1924 | 1293 | 0.06027397260273973 |
2155 | 2155 | cabinet | 1980 | 521 | 0.06027397260273973 |
5798 | 5798 | parliament | 1968 | 97 | 0.06027397260273973 |
7540 | 7540 | parliament | 2012 | 787 | 0.06027397260273973 |
1289 | 1289 | cabinet | 1954 | 898 | 0.06043956043956044 |
1579 | 1579 | cabinet | 1963 | 649 | 0.06043956043956044 |
1914 | 1914 | cabinet | 1974 | 59 | 0.06043956043956044 |
2080 | 2080 | cabinet | 1978 | 585 | 0.06043956043956044 |
2422 | 2422 | cabinet | 1987 | 426 | 0.06043956043956044 |
3037 | 3037 | cabinet | 1999 | 212 | 0.06043956043956044 |
3970 | 3970 | cabinet | 2015 | 1212 | 0.06043956043956044 |
4138 | 4138 | cabinet | 2018 | 1586 | 0.06043956043956044 |
4180 | 4180 | cabinet | 2019 | 1591 | 0.06043956043956044 |
5302 | 5302 | parliament | 1949 | 696 | 0.06043956043956044 |
5633 | 5633 | parliament | 1961 | 740 | 0.06043956043956044 |
7233 | 7233 | parliament | 2006 | 240 | 0.06043956043956044 |
761 | 761 | cabinet | 1936 | 1328 | 0.06301369863013699 |
1466 | 1466 | cabinet | 1960 | 48 | 0.06301369863013699 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE `viewcalc_country_year_share` ( `id_type` TEXT, `year` INTEGER, `id` INTEGER, `share` REAL );