view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by country_name_short descending
This data as json, CSV (advanced)
country_name_short ▲ | country_name | election_type | election_date | vote_share | seats | seats_total | party_name_short | party_name | party_name_english | left_right | country_id | election_id | previous_parliament_election_id | previous_cabinet_id | party_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SWE | Sweden | parliament | 1921-09-26 | 4.6 | 7 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 966 | 965 | 1191 | 882 |
SWE | Sweden | parliament | 1921-09-26 | 3.2 | 6 | 230 | SSV-21 | Sverges Socialdemokratiska Vänsterparti – 1921 | Social Democratic Left Party of Sweden -- 1921 | 1.3 | 35 | 966 | 965 | 1191 | 2557 |
SWE | Sweden | parliament | 1924-09-21 | 41.1 | 104 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 967 | 966 | 1189 | 904 |
SWE | Sweden | parliament | 1924-09-21 | 26.1 | 65 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 967 | 966 | 1189 | 657 |
SWE | Sweden | parliament | 1924-09-21 | 13.0 | 28 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 967 | 966 | 1189 | 892 |
SWE | Sweden | parliament | 1924-09-21 | 10.8 | 23 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 967 | 966 | 1189 | 1461 |
SWE | Sweden | parliament | 1924-09-21 | 3.9 | 5 | 230 | SLP | Sveriges Liberala Parti | Liberal Party of Sweden | 6.0 | 35 | 967 | 966 | 1189 | 2477 |
SWE | Sweden | parliament | 1924-09-21 | 3.6 | 4 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 967 | 966 | 1189 | 882 |
SWE | Sweden | parliament | 1924-09-21 | 1.5 | 1 | 230 | SKP-H | Sveriges Kommunistiska Parti [Höglund] | Communist Party of Sweden [Hoglund] | 1.3 | 35 | 967 | 966 | 1189 | 2475 |
SWE | Sweden | parliament | 1928-09-21 | 37.0 | 90 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 968 | 967 | 1186 | 904 |
SWE | Sweden | parliament | 1928-09-21 | 29.4 | 73 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 968 | 967 | 1186 | 657 |
SWE | Sweden | parliament | 1928-09-21 | 12.9 | 28 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 968 | 967 | 1186 | 892 |
SWE | Sweden | parliament | 1928-09-21 | 11.2 | 27 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 968 | 967 | 1186 | 1461 |
SWE | Sweden | parliament | 1928-09-21 | 6.4 | 8 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 968 | 967 | 1186 | 882 |
SWE | Sweden | parliament | 1928-09-21 | 3.0 | 4 | 230 | SLP | Sveriges Liberala Parti | Liberal Party of Sweden | 6.0 | 35 | 968 | 967 | 1186 | 2477 |
SWE | Sweden | parliament | 1932-09-18 | 41.7 | 104 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 969 | 968 | 1184 | 904 |
SWE | Sweden | parliament | 1932-09-18 | 23.5 | 58 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 969 | 968 | 1184 | 657 |
SWE | Sweden | parliament | 1932-09-18 | 14.1 | 36 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 969 | 968 | 1184 | 1461 |
SWE | Sweden | parliament | 1932-09-18 | 9.8 | 20 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 969 | 968 | 1184 | 892 |
SWE | Sweden | parliament | 1932-09-18 | 5.3 | 6 | 230 | SP | Socialistiska partiet | Socialist Party | 1.3 | 35 | 969 | 968 | 1184 | 2478 |
SWE | Sweden | parliament | 1932-09-18 | 2.0 | 4 | 230 | SLP | Sveriges Liberala Parti | Liberal Party of Sweden | 6.0 | 35 | 969 | 968 | 1184 | 2477 |
SWE | Sweden | parliament | 1932-09-18 | 3.0 | 2 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 969 | 968 | 1184 | 882 |
SWE | Sweden | parliament | 1932-09-18 | 0.6 | 0 | 230 | no-seat | no seat | no seat | 35 | 969 | 968 | 1184 | 2405 | |
SWE | Sweden | parliament | 1936-09-20 | 45.9 | 112 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 970 | 969 | 1182 | 904 |
SWE | Sweden | parliament | 1936-09-20 | 17.6 | 44 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 970 | 969 | 1182 | 657 |
SWE | Sweden | parliament | 1936-09-20 | 14.4 | 36 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 970 | 969 | 1182 | 1461 |
SWE | Sweden | parliament | 1936-09-20 | 12.9 | 27 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 970 | 969 | 1182 | 892 |
SWE | Sweden | parliament | 1936-09-20 | 4.4 | 6 | 230 | SP | Socialistiska partiet | Socialist Party | 1.3 | 35 | 970 | 969 | 1182 | 2478 |
SWE | Sweden | parliament | 1936-09-20 | 3.3 | 5 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 970 | 969 | 1182 | 882 |
SWE | Sweden | parliament | 1936-09-20 | 0.9 | 0 | 230 | no-seat | no seat | no seat | 35 | 970 | 969 | 1182 | 2405 | |
SWE | Sweden | parliament | 1940-09-15 | 53.8 | 134 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 971 | 970 | 1179 | 904 |
SWE | Sweden | parliament | 1940-09-15 | 18.0 | 42 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 971 | 970 | 1179 | 657 |
SWE | Sweden | parliament | 1940-09-15 | 12.0 | 28 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 971 | 970 | 1179 | 1461 |
SWE | Sweden | parliament | 1940-09-15 | 12.0 | 23 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 971 | 970 | 1179 | 892 |
SWE | Sweden | parliament | 1940-09-15 | 3.5 | 3 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 971 | 970 | 1179 | 882 |
SWE | Sweden | parliament | 1940-09-15 | 0.6 | 0 | 230 | SP | Socialistiska partiet | Socialist Party | 1.3 | 35 | 971 | 970 | 1179 | 2478 |
SWE | Sweden | parliament | 1944-09-17 | 46.5 | 115 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 485 | 971 | 1180 | 904 |
SWE | Sweden | parliament | 1944-09-17 | 15.8 | 39 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 485 | 971 | 1180 | 657 |
SWE | Sweden | parliament | 1944-09-17 | 13.6 | 35 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 485 | 971 | 1180 | 1461 |
SWE | Sweden | parliament | 1944-09-17 | 12.9 | 26 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 485 | 971 | 1180 | 892 |
SWE | Sweden | parliament | 1944-09-17 | 10.3 | 15 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 485 | 971 | 1180 | 882 |
SWE | Sweden | parliament | 1944-09-17 | 0.2 | 0 | 230 | SP | Socialistiska partiet | Socialist Party | 1.3 | 35 | 485 | 971 | 1180 | 2478 |
SWE | Sweden | parliament | 1948-09-19 | 46.1 | 112 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 431 | 485 | 628 | 904 |
SWE | Sweden | parliament | 1948-09-19 | 22.7 | 57 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 431 | 485 | 628 | 892 |
SWE | Sweden | parliament | 1948-09-19 | 12.4 | 30 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 431 | 485 | 628 | 1461 |
SWE | Sweden | parliament | 1948-09-19 | 12.3 | 23 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 431 | 485 | 628 | 657 |
SWE | Sweden | parliament | 1948-09-19 | 6.3 | 8 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 431 | 485 | 628 | 882 |
SWE | Sweden | parliament | 1948-09-19 | 0.1 | 0 | 230 | VSP | Vänstersocialistiska Partiet | Left Socialist Party | 3.3 | 35 | 431 | 485 | 628 | 2406 |
SWE | Sweden | parliament | 1952-09-21 | 46.0 | 110 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 234 | 431 | 361 | 904 |
SWE | Sweden | parliament | 1952-09-21 | 24.4 | 58 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 234 | 431 | 361 | 892 |
SWE | Sweden | parliament | 1952-09-21 | 14.4 | 31 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 234 | 431 | 361 | 657 |
SWE | Sweden | parliament | 1952-09-21 | 10.7 | 26 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 234 | 431 | 361 | 1461 |
SWE | Sweden | parliament | 1952-09-21 | 4.3 | 5 | 230 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 234 | 431 | 361 | 882 |
SWE | Sweden | parliament | 1952-09-21 | 0.1 | 0 | 230 | VSP | Vänstersocialistiska Partiet | Left Socialist Party | 3.3 | 35 | 234 | 431 | 361 | 2406 |
SWE | Sweden | parliament | 1956-09-16 | 44.6 | 106 | 231 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 450 | 234 | 781 | 904 |
SWE | Sweden | parliament | 1956-09-16 | 23.8 | 58 | 231 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 450 | 234 | 781 | 892 |
SWE | Sweden | parliament | 1956-09-16 | 17.1 | 42 | 231 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 450 | 234 | 781 | 657 |
SWE | Sweden | parliament | 1956-09-16 | 9.5 | 19 | 231 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 450 | 234 | 781 | 1461 |
SWE | Sweden | parliament | 1956-09-16 | 5.0 | 6 | 231 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 450 | 234 | 781 | 882 |
SWE | Sweden | parliament | 1956-09-16 | 0.0 | 0 | 231 | VSP | Vänstersocialistiska Partiet | Left Socialist Party | 3.3 | 35 | 450 | 234 | 781 | 2406 |
SWE | Sweden | parliament | 1958-06-01 | 46.2 | 111 | 231 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 251 | 450 | 380 | 904 |
SWE | Sweden | parliament | 1958-06-01 | 19.5 | 45 | 231 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 251 | 450 | 380 | 657 |
SWE | Sweden | parliament | 1958-06-01 | 18.2 | 38 | 231 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 251 | 450 | 380 | 892 |
SWE | Sweden | parliament | 1958-06-01 | 12.7 | 32 | 231 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 251 | 450 | 380 | 1461 |
SWE | Sweden | parliament | 1958-06-01 | 3.4 | 5 | 231 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 251 | 450 | 380 | 882 |
SWE | Sweden | parliament | 1958-06-01 | 0.0 | 0 | 231 | VSP | Vänstersocialistiska Partiet | Left Socialist Party | 3.3 | 35 | 251 | 450 | 380 | 2406 |
SWE | Sweden | parliament | 1960-09-18 | 47.8 | 114 | 232 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 295 | 251 | 208 | 904 |
SWE | Sweden | parliament | 1960-09-18 | 17.5 | 40 | 232 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 295 | 251 | 208 | 892 |
SWE | Sweden | parliament | 1960-09-18 | 16.6 | 39 | 232 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 295 | 251 | 208 | 657 |
SWE | Sweden | parliament | 1960-09-18 | 13.6 | 34 | 232 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 295 | 251 | 208 | 1461 |
SWE | Sweden | parliament | 1960-09-18 | 4.5 | 5 | 232 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 295 | 251 | 208 | 882 |
SWE | Sweden | parliament | 1960-09-18 | 0.0 | 0 | 232 | no-seat | no seat | no seat | 35 | 295 | 251 | 208 | 2405 | |
SWE | Sweden | parliament | 1964-09-20 | 47.3 | 113 | 233 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 41 | 295 | 424 | 904 |
SWE | Sweden | parliament | 1964-09-20 | 17.0 | 42 | 233 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 41 | 295 | 424 | 892 |
SWE | Sweden | parliament | 1964-09-20 | 13.2 | 33 | 233 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 41 | 295 | 424 | 1461 |
SWE | Sweden | parliament | 1964-09-20 | 13.7 | 32 | 233 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 41 | 295 | 424 | 657 |
SWE | Sweden | parliament | 1964-09-20 | 5.2 | 8 | 233 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 41 | 295 | 424 | 882 |
SWE | Sweden | parliament | 1964-09-20 | 1.5 | 3 | 233 | MbS | Medborgerlig samling | Citizens Coalition | 7.4 | 35 | 41 | 295 | 424 | 802 |
SWE | Sweden | parliament | 1964-09-20 | 0.3 | 2 | 233 | Mi | Mittenpartierna | Middle Parties | 6.0 | 35 | 41 | 295 | 424 | 1010 |
SWE | Sweden | parliament | 1964-09-20 | 1.8 | 0 | 233 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 41 | 295 | 424 | 282 |
SWE | Sweden | parliament | 1968-09-15 | 50.1 | 125 | 233 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 655 | 41 | 506 | 904 |
SWE | Sweden | parliament | 1968-09-15 | 15.7 | 37 | 233 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 655 | 41 | 506 | 1461 |
SWE | Sweden | parliament | 1968-09-15 | 14.3 | 32 | 233 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 655 | 41 | 506 | 892 |
SWE | Sweden | parliament | 1968-09-15 | 12.9 | 29 | 233 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 655 | 41 | 506 | 657 |
SWE | Sweden | parliament | 1968-09-15 | 1.7 | 4 | 233 | MbS | Medborgerlig samling | Citizens Coalition | 7.4 | 35 | 655 | 41 | 506 | 802 |
SWE | Sweden | parliament | 1968-09-15 | 0.9 | 3 | 233 | Mi | Mittenpartierna | Middle Parties | 6.0 | 35 | 655 | 41 | 506 | 1010 |
SWE | Sweden | parliament | 1968-09-15 | 3.0 | 3 | 233 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 655 | 41 | 506 | 882 |
SWE | Sweden | parliament | 1968-09-15 | 1.5 | 0 | 233 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 655 | 41 | 506 | 282 |
SWE | Sweden | parliament | 1970-09-20 | 45.3 | 163 | 350 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 258 | 655 | 219 | 904 |
SWE | Sweden | parliament | 1970-09-20 | 19.9 | 71 | 350 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 258 | 655 | 219 | 1461 |
SWE | Sweden | parliament | 1970-09-20 | 16.2 | 58 | 350 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 258 | 655 | 219 | 892 |
SWE | Sweden | parliament | 1970-09-20 | 11.5 | 41 | 350 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 258 | 655 | 219 | 657 |
SWE | Sweden | parliament | 1970-09-20 | 4.8 | 17 | 350 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 258 | 655 | 219 | 882 |
SWE | Sweden | parliament | 1970-09-20 | 1.8 | 0 | 350 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 258 | 655 | 219 | 282 |
SWE | Sweden | parliament | 1973-09-16 | 43.6 | 156 | 350 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 215 | 258 | 577 | 904 |
SWE | Sweden | parliament | 1973-09-16 | 25.1 | 90 | 350 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 215 | 258 | 577 | 1461 |
SWE | Sweden | parliament | 1973-09-16 | 14.3 | 51 | 350 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 215 | 258 | 577 | 657 |
SWE | Sweden | parliament | 1973-09-16 | 9.4 | 34 | 350 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 215 | 258 | 577 | 892 |
SWE | Sweden | parliament | 1973-09-16 | 5.3 | 19 | 350 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 215 | 258 | 577 | 882 |
SWE | Sweden | parliament | 1973-09-16 | 1.8 | 0 | 350 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 215 | 258 | 577 | 282 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_election AS SELECT c.name_short AS country_name_short, c.name AS country_name, ii.short AS election_type, e.date AS election_date, vote_share, seats, seats_total, p.name_short AS party_name_short, p.name AS party_name, p.name_english AS party_name_english, vpp.left_right AS left_right, e.country_id AS country_id, er.election_id AS election_id, e.previous_parliament_election_id AS previous_parliament_election_id, e.previous_cabinet_id AS previous_cabinet_id, er.party_id AS party_id FROM (SELECT * FROM election_result WHERE vote_share NOT NULL OR seats NOT NULL) er LEFT OUTER JOIN election e ON er.election_id = e.id LEFT OUTER JOIN party p ON er.party_id = p.id LEFT OUTER JOIN viewcalc_party_position AS vpp ON er.party_id = vpp.party_id LEFT OUTER JOIN country c ON e.country_id = c.id LEFT OUTER JOIN info_id ii ON e.type_id = ii.id ORDER BY c.name_short, e.date, er.seats DESC;