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)
These facets timed out: election_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TUR | Turkey | parliament | 1983-11-06 | 45.14 | 211 | 399 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 813 | 1334 | ||
TUR | Turkey | parliament | 1983-11-06 | 30.46 | 117 | 399 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 813 | 507 | ||
TUR | Turkey | parliament | 1983-11-06 | 23.2658 | 71 | 399 | MDP | Milliyetçi Demokrasi Partisi | Nationalist Democratic Party | 8.8 | 20 | 813 | 110 | ||
TUR | Turkey | parliament | 1987-10-29 | 36.31 | 292 | 450 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 812 | 813 | 1087 | 1334 |
TUR | Turkey | parliament | 1987-10-29 | 24.74 | 99 | 450 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 812 | 813 | 1087 | 507 |
TUR | Turkey | parliament | 1987-10-29 | 19.135 | 59 | 450 | DYP | Doğru Yol Partisi | Right Path Party | 6.8239 | 20 | 812 | 813 | 1087 | 1141 |
TUR | Turkey | parliament | 1987-10-29 | 8.529 | 0 | 450 | DSP | Demokratik Sol Parti | Democratic Left Party | 3.8377 | 20 | 812 | 813 | 1087 | 329 |
TUR | Turkey | parliament | 1987-10-29 | 7.164 | 0 | 450 | RP | Refah (Fazilet) Partisi | Welfare (Virtue) Party | 8.3333 | 20 | 812 | 813 | 1087 | 1122 |
TUR | Turkey | parliament | 1987-10-29 | 2.927 | 0 | 450 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 812 | 813 | 1087 | 408 |
TUR | Turkey | parliament | 1991-10-20 | 27.03 | 178 | 450 | DYP | Doğru Yol Partisi | Right Path Party | 6.8239 | 20 | 811 | 812 | 1090 | 1141 |
TUR | Turkey | parliament | 1991-10-20 | 24.01 | 115 | 450 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 811 | 812 | 1090 | 1334 |
TUR | Turkey | parliament | 1991-10-20 | 20.75 | 88 | 450 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 811 | 812 | 1090 | 507 |
TUR | Turkey | parliament | 1991-10-20 | 16.879 | 62 | 450 | RP | Refah (Fazilet) Partisi | Welfare (Virtue) Party | 8.3333 | 20 | 811 | 812 | 1090 | 1122 |
TUR | Turkey | parliament | 1991-10-20 | 10.75 | 7 | 450 | DSP | Demokratik Sol Parti | Democratic Left Party | 3.8377 | 20 | 811 | 812 | 1090 | 329 |
TUR | Turkey | parliament | 1991-10-20 | 0.4 | 0 | 450 | no-seat | no seat | no seat | 20 | 811 | 812 | 1090 | 2316 | |
TUR | Turkey | parliament | 1995-12-24 | 21.376 | 158 | 550 | RP | Refah (Fazilet) Partisi | Welfare (Virtue) Party | 8.3333 | 20 | 810 | 811 | 1093 | 1122 |
TUR | Turkey | parliament | 1995-12-24 | 19.184 | 135 | 550 | DYP | Doğru Yol Partisi | Right Path Party | 6.8239 | 20 | 810 | 811 | 1093 | 1141 |
TUR | Turkey | parliament | 1995-12-24 | 19.651 | 132 | 550 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 810 | 811 | 1093 | 1334 |
TUR | Turkey | parliament | 1995-12-24 | 14.64 | 76 | 550 | DSP | Demokratik Sol Parti | Democratic Left Party | 3.8377 | 20 | 810 | 811 | 1093 | 329 |
TUR | Turkey | parliament | 1995-12-24 | 10.705 | 49 | 550 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 810 | 811 | 1093 | 507 |
TUR | Turkey | parliament | 1995-12-24 | 8.18 | 0 | 550 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 810 | 811 | 1093 | 408 |
TUR | Turkey | parliament | 1995-12-24 | 4.165 | 0 | 550 | HADEP | Halkın Demokrasi Partisi | People's Democracy Party | 2.2267 | 20 | 810 | 811 | 1093 | 2305 |
TUR | Turkey | parliament | 1999-04-18 | 22.19 | 136 | 550 | DSP | Demokratik Sol Parti | Democratic Left Party | 3.8377 | 20 | 809 | 810 | 1100 | 329 |
TUR | Turkey | parliament | 1999-04-18 | 17.98 | 129 | 550 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 809 | 810 | 1100 | 408 |
TUR | Turkey | parliament | 1999-04-18 | 15.41 | 111 | 550 | RP | Refah (Fazilet) Partisi | Welfare (Virtue) Party | 8.3333 | 20 | 809 | 810 | 1100 | 1122 |
TUR | Turkey | parliament | 1999-04-18 | 13.22 | 86 | 550 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 809 | 810 | 1100 | 1334 |
TUR | Turkey | parliament | 1999-04-18 | 12.01 | 85 | 550 | DYP | Doğru Yol Partisi | Right Path Party | 6.8239 | 20 | 809 | 810 | 1100 | 1141 |
TUR | Turkey | parliament | 1999-04-18 | 3 | 550 | none | bağımsız | no party affiliation | 20 | 809 | 810 | 1100 | 1399 | ||
TUR | Turkey | parliament | 1999-04-18 | 8.71 | 0 | 550 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 809 | 810 | 1100 | 507 |
TUR | Turkey | parliament | 1999-04-18 | 4.75 | 0 | 550 | HADEP | Halkın Demokrasi Partisi | People's Democracy Party | 2.2267 | 20 | 809 | 810 | 1100 | 2305 |
TUR | Turkey | parliament | 1999-04-18 | 1.46 | 0 | 550 | BBP | Büyük Birlik Partisi | Great Union Party | 8.8 | 20 | 809 | 810 | 1100 | 240 |
TUR | Turkey | parliament | 2002-11-03 | 34.28 | 363 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 808 | 809 | 1101 | 901 |
TUR | Turkey | parliament | 2002-11-03 | 19.39 | 178 | 550 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 808 | 809 | 1101 | 507 |
TUR | Turkey | parliament | 2002-11-03 | 9 | 550 | none | bağımsız | no party affiliation | 20 | 808 | 809 | 1101 | 1399 | ||
TUR | Turkey | parliament | 2002-11-03 | 9.54 | 0 | 550 | DYP | Doğru Yol Partisi | Right Path Party | 6.8239 | 20 | 808 | 809 | 1101 | 1141 |
TUR | Turkey | parliament | 2002-11-03 | 8.36 | 0 | 550 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 808 | 809 | 1101 | 408 |
TUR | Turkey | parliament | 2002-11-03 | 7.25 | 0 | 550 | GP | Genç Parti | Young Party | 8.3821 | 20 | 808 | 809 | 1101 | 1647 |
TUR | Turkey | parliament | 2002-11-03 | 6.22 | 0 | 550 | HADEP | Halkın Demokrasi Partisi | People's Democracy Party | 2.2267 | 20 | 808 | 809 | 1101 | 2305 |
TUR | Turkey | parliament | 2002-11-03 | 5.13 | 0 | 550 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 808 | 809 | 1101 | 1334 |
TUR | Turkey | parliament | 2002-11-03 | 2.49 | 0 | 550 | SP | Saadet Partisi | Felicity Party | 7.4 | 20 | 808 | 809 | 1101 | 1315 |
TUR | Turkey | parliament | 2002-11-03 | 1.22 | 0 | 550 | DSP | Demokratik Sol Parti | Democratic Left Party | 3.8377 | 20 | 808 | 809 | 1101 | 329 |
TUR | Turkey | parliament | 2002-11-03 | 1.15 | 0 | 550 | YTP | Yeni Türkiye Partisi | New Turkey Party | 3.3 | 20 | 808 | 809 | 1101 | 2304 |
TUR | Turkey | parliament | 2002-11-03 | 1.02 | 0 | 550 | BBP | Büyük Birlik Partisi | Great Union Party | 8.8 | 20 | 808 | 809 | 1101 | 240 |
TUR | Turkey | parliament | 2007-07-22 | 46.66 | 341 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 807 | 808 | 1077 | 901 |
TUR | Turkey | parliament | 2007-07-22 | 20.9 | 99 | 550 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 807 | 808 | 1077 | 507 |
TUR | Turkey | parliament | 2007-07-22 | 14.3 | 71 | 550 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 807 | 808 | 1077 | 408 |
TUR | Turkey | parliament | 2007-07-22 | 20 | 550 | HADEP | Halkın Demokrasi Partisi | People's Democracy Party | 2.2267 | 20 | 807 | 808 | 1077 | 2305 | |
TUR | Turkey | parliament | 2007-07-22 | 13 | 550 | DSP | Demokratik Sol Parti | Democratic Left Party | 3.8377 | 20 | 807 | 808 | 1077 | 329 | |
TUR | Turkey | parliament | 2007-07-22 | 5 | 550 | none | bağımsız | no party affiliation | 20 | 807 | 808 | 1077 | 1399 | ||
TUR | Turkey | parliament | 2007-07-22 | 1 | 550 | BBP | Büyük Birlik Partisi | Great Union Party | 8.8 | 20 | 807 | 808 | 1077 | 240 | |
TUR | Turkey | parliament | 2007-07-22 | 5.42 | 0 | 550 | DYP | Doğru Yol Partisi | Right Path Party | 6.8239 | 20 | 807 | 808 | 1077 | 1141 |
TUR | Turkey | parliament | 2007-07-22 | 3.04 | 0 | 550 | GP | Genç Parti | Young Party | 8.3821 | 20 | 807 | 808 | 1077 | 1647 |
TUR | Turkey | parliament | 2007-07-22 | 2.34 | 0 | 550 | SP | Saadet Partisi | Felicity Party | 7.4 | 20 | 807 | 808 | 1077 | 1315 |
TUR | Turkey | parliament | 2011-06-12 | 49.83 | 327 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 806 | 807 | 1076 | 901 |
TUR | Turkey | parliament | 2011-06-12 | 25.98 | 135 | 550 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 806 | 807 | 1076 | 507 |
TUR | Turkey | parliament | 2011-06-12 | 13.01 | 53 | 550 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 806 | 807 | 1076 | 408 |
TUR | Turkey | parliament | 2011-06-12 | 29 | 550 | HADEP | Halkın Demokrasi Partisi | People's Democracy Party | 2.2267 | 20 | 806 | 807 | 1076 | 2305 | |
TUR | Turkey | parliament | 2011-06-12 | 6 | 550 | none | bağımsız | no party affiliation | 20 | 806 | 807 | 1076 | 1399 | ||
TUR | Turkey | parliament | 2011-06-12 | 1.27 | 0 | 550 | SP | Saadet Partisi | Felicity Party | 7.4 | 20 | 806 | 807 | 1076 | 1315 |
TUR | Turkey | parliament | 2015-06-07 | 40.87 | 258 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 975 | 806 | 1143 | 901 |
TUR | Turkey | parliament | 2015-06-07 | 24.95 | 132 | 550 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 975 | 806 | 1143 | 507 |
TUR | Turkey | parliament | 2015-06-07 | 13.12 | 80 | 550 | HDP | Halkların Demokratik Partisi | Peoples' Democratic Party | 1.3 | 20 | 975 | 806 | 1143 | 2572 |
TUR | Turkey | parliament | 2015-06-07 | 16.29 | 80 | 550 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 975 | 806 | 1143 | 408 |
TUR | Turkey | parliament | 2015-06-07 | 2.06 | 0 | 550 | SP | Saadet Partisi | Felicity Party | 7.4 | 20 | 975 | 806 | 1143 | 1315 |
TUR | Turkey | parliament | 2015-06-07 | 1.06 | 0 | 550 | none | bağımsız | no party affiliation | 20 | 975 | 806 | 1143 | 1399 | |
TUR | Turkey | parliament | 2015-11-01 | 49.5 | 317 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 997 | 975 | 1173 | 901 |
TUR | Turkey | parliament | 2015-11-01 | 25.32 | 134 | 550 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 997 | 975 | 1173 | 507 |
TUR | Turkey | parliament | 2015-11-01 | 10.76 | 59 | 550 | HDP | Halkların Demokratik Partisi | Peoples' Democratic Party | 1.3 | 20 | 997 | 975 | 1173 | 2572 |
TUR | Turkey | parliament | 2015-11-01 | 11.9 | 40 | 550 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 997 | 975 | 1173 | 408 |
TUR | Turkey | parliament | 2018-06-24 | 42.62 | 295 | 600 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 1032 | 997 | 1487 | 901 |
TUR | Turkey | parliament | 2018-06-24 | 22.67 | 146 | 600 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 1032 | 997 | 1487 | 507 |
TUR | Turkey | parliament | 2018-06-24 | 11.72 | 67 | 600 | HDP | Halkların Demokratik Partisi | Peoples' Democratic Party | 1.3 | 20 | 1032 | 997 | 1487 | 2572 |
TUR | Turkey | parliament | 2018-06-24 | 11.12 | 49 | 600 | MHP | Milliyetçi Hareket Partisi | National Action Party | 8.6587 | 20 | 1032 | 997 | 1487 | 408 |
TUR | Turkey | parliament | 2018-06-24 | 9.97 | 43 | 600 | IYI | İyi Parti | Iyi Party | 8.8 | 20 | 1032 | 997 | 1487 | 2702 |
TUR | Turkey | parliament | 2018-06-24 | 1.35 | 0 | 600 | SP | Saadet Partisi | Felicity Party | 7.4 | 20 | 1032 | 997 | 1487 | 1315 |
SWE | Sweden | parliament | 1911-09-24 | 40.2 | 102 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 961 | 892 | ||
SWE | Sweden | parliament | 1911-09-24 | 31.2 | 64 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 961 | 657 | ||
SWE | Sweden | parliament | 1911-09-24 | 28.5 | 64 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 961 | 904 | ||
SWE | Sweden | parliament | 1914-04-07 | 37.7 | 86 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 962 | 961 | 1369 | 657 |
SWE | Sweden | parliament | 1914-04-07 | 30.1 | 73 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 962 | 961 | 1369 | 904 |
SWE | Sweden | parliament | 1914-04-07 | 32.2 | 71 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 962 | 961 | 1369 | 892 |
SWE | Sweden | parliament | 1914-09-13 | 36.4 | 87 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 963 | 962 | 1369 | 904 |
SWE | Sweden | parliament | 1914-09-13 | 36.5 | 86 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 963 | 962 | 1369 | 657 |
SWE | Sweden | parliament | 1914-09-13 | 26.9 | 57 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 963 | 962 | 1369 | 892 |
SWE | Sweden | parliament | 1914-09-13 | 0.2 | 0 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 963 | 962 | 1369 | 1461 |
SWE | Sweden | parliament | 1917-09-16 | 31.1 | 86 | 217 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 964 | 963 | 1368 | 904 |
SWE | Sweden | parliament | 1917-09-16 | 27.6 | 62 | 217 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 964 | 963 | 1368 | 892 |
SWE | Sweden | parliament | 1917-09-16 | 24.7 | 57 | 217 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 964 | 963 | 1368 | 657 |
SWE | Sweden | parliament | 1917-09-16 | 5.3 | 9 | 217 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 964 | 963 | 1368 | 1461 |
SWE | Sweden | parliament | 1917-09-16 | 3.1 | 3 | 217 | JR | Jordbrukarnas Riksförbund | National Farmers' Union | 5.3 | 35 | 964 | 963 | 1368 | 2556 |
SWE | Sweden | parliament | 1920-09-17 | 29.6 | 75 | 228 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 965 | 964 | 1193 | 904 |
SWE | Sweden | parliament | 1920-09-17 | 27.8 | 70 | 228 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 965 | 964 | 1193 | 657 |
SWE | Sweden | parliament | 1920-09-17 | 21.8 | 47 | 228 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 965 | 964 | 1193 | 892 |
SWE | Sweden | parliament | 1920-09-17 | 7.9 | 19 | 228 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 965 | 964 | 1193 | 1461 |
SWE | Sweden | parliament | 1920-09-17 | 6.2 | 10 | 228 | JR | Jordbrukarnas Riksförbund | National Farmers' Union | 5.3 | 35 | 965 | 964 | 1193 | 2556 |
SWE | Sweden | parliament | 1920-09-17 | 6.4 | 7 | 228 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 965 | 964 | 1193 | 882 |
SWE | Sweden | parliament | 1921-09-26 | 36.2 | 93 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 966 | 965 | 1191 | 904 |
SWE | Sweden | parliament | 1921-09-26 | 25.8 | 62 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 966 | 965 | 1191 | 657 |
SWE | Sweden | parliament | 1921-09-26 | 18.7 | 41 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 966 | 965 | 1191 | 892 |
SWE | Sweden | parliament | 1921-09-26 | 11.0 | 21 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 966 | 965 | 1191 | 1461 |
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;