viewcalc_country_year_share
Data source: ParlGov · About: simonw/parlgov-datasette
9,069 rows sorted by id
This data as json, CSV (advanced)
Link | rowid | id_type | year | id ▼ | share |
---|---|---|---|---|---|
8365 | 8365 | ep | 2000 | 16 | 1.0 |
8380 | 8380 | ep | 2001 | 16 | 1.0 |
8395 | 8395 | ep | 2002 | 16 | 1.0 |
8410 | 8410 | ep | 2003 | 16 | 1.0 |
8425 | 8425 | ep | 2004 | 16 | 0.44931506849315067 |
1910 | 1910 | cabinet | 1974 | 17 | 0.24175824175824176 |
6376 | 6376 | parliament | 1987 | 17 | 0.5494505494505495 |
6416 | 6416 | parliament | 1988 | 17 | 1.0 |
6447 | 6447 | parliament | 1989 | 17 | 1.0 |
6481 | 6481 | parliament | 1990 | 17 | 1.0 |
6522 | 6522 | parliament | 1991 | 17 | 1.0 |
6566 | 6566 | parliament | 1992 | 17 | 0.2602739726027397 |
3239 | 3239 | cabinet | 2003 | 18 | 0.8379120879120879 |
3295 | 3295 | cabinet | 2004 | 18 | 0.33424657534246577 |
8426 | 8426 | ep | 2004 | 18 | 0.5506849315068493 |
8465 | 8465 | ep | 2005 | 18 | 1.0 |
8490 | 8490 | ep | 2006 | 18 | 1.0 |
8516 | 8516 | ep | 2007 | 18 | 1.0 |
8544 | 8544 | ep | 2008 | 18 | 1.0 |
8572 | 8572 | ep | 2009 | 18 | 0.43131868131868134 |
3131 | 3131 | cabinet | 2001 | 19 | 0.5686813186813187 |
3181 | 3181 | cabinet | 2002 | 19 | 1.0 |
3240 | 3240 | cabinet | 2003 | 19 | 1.0 |
3296 | 3296 | cabinet | 2004 | 19 | 1.0 |
3353 | 3353 | cabinet | 2005 | 19 | 0.3434065934065934 |
5202 | 5202 | parliament | 1946 | 19 | 0.8708791208791209 |
5228 | 5228 | parliament | 1947 | 19 | 1.0 |
5251 | 5251 | parliament | 1948 | 19 | 1.0 |
5277 | 5277 | parliament | 1949 | 19 | 0.4835164835164835 |
1951 | 1951 | cabinet | 1975 | 20 | 0.057692307692307696 |
1983 | 1983 | cabinet | 1976 | 20 | 1.0 |
2018 | 2018 | cabinet | 1977 | 20 | 1.0 |
2056 | 2056 | cabinet | 1978 | 20 | 1.0 |
2095 | 2095 | cabinet | 1979 | 20 | 0.9285714285714286 |
6180 | 6180 | parliament | 1981 | 20 | 0.5302197802197802 |
6215 | 6215 | parliament | 1982 | 20 | 1.0 |
6245 | 6245 | parliament | 1983 | 20 | 1.0 |
6281 | 6281 | parliament | 1984 | 20 | 1.0 |
6313 | 6313 | parliament | 1985 | 20 | 1.0 |
6345 | 6345 | parliament | 1986 | 20 | 0.2032967032967033 |
1984 | 1984 | cabinet | 1976 | 21 | 0.3726027397260274 |
2019 | 2019 | cabinet | 1977 | 21 | 1.0 |
2057 | 2057 | cabinet | 1978 | 21 | 0.2445054945054945 |
5332 | 5332 | parliament | 1951 | 21 | 0.17582417582417584 |
5363 | 5363 | parliament | 1952 | 21 | 1.0 |
5388 | 5388 | parliament | 1953 | 21 | 1.0 |
5419 | 5419 | parliament | 1954 | 21 | 1.0 |
5446 | 5446 | parliament | 1955 | 21 | 0.8296703296703297 |
8290 | 8290 | ep | 1996 | 22 | 0.21643835616438356 |
8306 | 8306 | ep | 1997 | 22 | 1.0 |
8321 | 8321 | ep | 1998 | 22 | 1.0 |
8337 | 8337 | ep | 1999 | 22 | 0.4478021978021978 |
3078 | 3078 | cabinet | 2000 | 23 | 0.6602739726027397 |
3132 | 3132 | cabinet | 2001 | 23 | 1.0 |
3182 | 3182 | cabinet | 2002 | 23 | 0.8516483516483516 |
8059 | 8059 | ep | 1979 | 23 | 0.5604395604395604 |
8068 | 8068 | ep | 1980 | 23 | 1.0 |
8077 | 8077 | ep | 1981 | 23 | 1.0 |
8088 | 8088 | ep | 1982 | 23 | 1.0 |
8098 | 8098 | ep | 1983 | 23 | 1.0 |
8109 | 8109 | ep | 1984 | 23 | 0.4602739726027397 |
1880 | 1880 | cabinet | 1973 | 24 | 0.48626373626373626 |
1911 | 1911 | cabinet | 1974 | 24 | 0.1978021978021978 |
6704 | 6704 | parliament | 1995 | 24 | 0.7884615384615384 |
6749 | 6749 | parliament | 1996 | 24 | 1.0 |
6798 | 6798 | parliament | 1997 | 24 | 1.0 |
6841 | 6841 | parliament | 1998 | 24 | 1.0 |
6889 | 6889 | parliament | 1999 | 24 | 0.21703296703296704 |
1844 | 1844 | cabinet | 1972 | 25 | 0.09315068493150686 |
1881 | 1881 | cabinet | 1973 | 25 | 1.0 |
1912 | 1912 | cabinet | 1974 | 25 | 0.6016483516483516 |
6482 | 6482 | parliament | 1990 | 25 | 0.8681318681318682 |
6523 | 6523 | parliament | 1991 | 25 | 1.0 |
6567 | 6567 | parliament | 1992 | 25 | 1.0 |
6612 | 6612 | parliament | 1993 | 25 | 0.5439560439560439 |
2744 | 2744 | cabinet | 1994 | 26 | 0.04945054945054945 |
2798 | 2798 | cabinet | 1995 | 26 | 1.0 |
2851 | 2851 | cabinet | 1996 | 26 | 1.0 |
2914 | 2914 | cabinet | 1997 | 26 | 1.0 |
2966 | 2966 | cabinet | 1998 | 26 | 0.8296703296703297 |
2096 | 2096 | cabinet | 1979 | 27 | 0.46153846153846156 |
2136 | 2136 | cabinet | 1980 | 27 | 1.0 |
2174 | 2174 | cabinet | 1981 | 27 | 1.0 |
2218 | 2218 | cabinet | 1982 | 27 | 1.0 |
2256 | 2256 | cabinet | 1983 | 27 | 1.0 |
2296 | 2296 | cabinet | 1984 | 27 | 0.5506849315068493 |
6842 | 6842 | parliament | 1998 | 27 | 0.532967032967033 |
6890 | 6890 | parliament | 1999 | 27 | 1.0 |
6936 | 6936 | parliament | 2000 | 27 | 1.0 |
6980 | 6980 | parliament | 2001 | 27 | 1.0 |
7025 | 7025 | parliament | 2002 | 27 | 0.4532967032967033 |
3405 | 3405 | cabinet | 2006 | 28 | 0.06593406593406594 |
3463 | 3463 | cabinet | 2007 | 28 | 0.25824175824175827 |
8573 | 8573 | ep | 2009 | 28 | 0.5714285714285714 |
8626 | 8626 | ep | 2010 | 28 | 1.0 |
8653 | 8653 | ep | 2011 | 28 | 1.0 |
8680 | 8680 | ep | 2012 | 28 | 1.0 |
8707 | 8707 | ep | 2013 | 28 | 1.0 |
8735 | 8735 | ep | 2014 | 28 | 0.3956043956043956 |
933 | 933 | cabinet | 1944 | 29 | 0.052054794520547946 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE `viewcalc_country_year_share` ( `id_type` TEXT, `year` INTEGER, `id` INTEGER, `share` REAL );