view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUT | Austria | parliament | 1919-02-16 | 1.49 | 4 | 170 | one-seat | one-seat | one-seat | 59 | 1030 | 2686 | |||
AUT | Austria | parliament | 1919-02-16 | 1.58 | 3 | 170 | SBP | Steirische Bauernpartei | Styrian Farmers' Party | 5.3 | 59 | 1030 | 2677 | ||
AUT | Austria | parliament | 1919-02-16 | 2.16 | 3 | 170 | DD | Deutschdemokraten | German-Democrats | 6.0 | 59 | 1030 | 2675 | ||
AUT | Austria | parliament | 1919-02-16 | 2.02 | 2 | 170 | DVP | Deutsche Volkspartei | German People's Party | 7.4 | 59 | 1030 | 2673 | ||
AUT | Austria | parliament | 1919-02-16 | 1.12 | 2 | 170 | KB | Kärtner Bauernbund | Carinthian Farmers' Association | 5.3 | 59 | 1030 | 2678 | ||
AUT | Austria | parliament | 1919-02-16 | 2.27 | 1 | 170 | T | Tschechoslowaken | Czechoslovakians | 59 | 1030 | 2689 | |||
AUT | Austria | parliament | 1919-02-16 | 1.64 | 1 | 170 | BD | Bürgerliche Demokraten | Centrist Democrats | 6.0 | 59 | 1030 | 2688 | ||
AUT | Austria | parliament | 1919-02-16 | 1.57 | 0 | 170 | NDP | Nationaldemokratische Partei | National Democratic Party | 8.8 | 59 | 1030 | 2679 | ||
AUT | Austria | parliament | 1920-10-17 | 41.79 | 85 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1026 | 1030 | 1537 | 1013 |
AUT | Austria | parliament | 1920-10-17 | 35.99 | 69 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 1026 | 1030 | 1537 | 973 |
AUT | Austria | parliament | 1920-10-17 | 17.25 | 21 | 183 | GDVP | Großdeutsche Volkspartei | Greater German People's Party | 7.4 | 59 | 1026 | 1030 | 1537 | 2674 |
AUT | Austria | parliament | 1920-10-17 | 7 | 183 | L | Landbund für Österreich | Rural Federation | 8.8 | 59 | 1026 | 1030 | 1537 | 2681 | |
AUT | Austria | parliament | 1920-10-17 | 1.44 | 1 | 183 | one-seat | one-seat | one-seat | 59 | 1026 | 1030 | 1537 | 2686 | |
AUT | Austria | parliament | 1920-10-17 | 0 | 183 | KB | Kärtner Bauernbund | Carinthian Farmers' Association | 5.3 | 59 | 1026 | 1030 | 1537 | 2678 | |
AUT | Austria | parliament | 1920-10-17 | 0 | 183 | DNSAP | Nationalsozialistische Arbeiterpartei | National Socialist Workers' Party | 8.8 | 59 | 1026 | 1030 | 1537 | 2684 | |
AUT | Austria | parliament | 1923-10-21 | 44.05 | 82 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1027 | 1026 | 1542 | 1013 |
AUT | Austria | parliament | 1923-10-21 | 39.6 | 68 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 1027 | 1026 | 1542 | 973 |
AUT | Austria | parliament | 1923-10-21 | 10 | 165 | GDVP | Großdeutsche Volkspartei | Greater German People's Party | 7.4 | 59 | 1027 | 1026 | 1542 | 2674 | |
AUT | Austria | parliament | 1923-10-21 | 5 | 165 | L | Landbund für Österreich | Rural Federation | 8.8 | 59 | 1027 | 1026 | 1542 | 2681 | |
AUT | Austria | parliament | 1923-10-21 | 2.88 | 0 | 165 | etc | others | others | 59 | 1027 | 1026 | 1542 | 2687 | |
AUT | Austria | parliament | 1923-10-21 | 10.84 | 165 | WB | Wirtschaftsblock | Economic bloc | 8.8 | 59 | 1027 | 1026 | 1542 | 2699 | |
AUT | Austria | parliament | 1927-04-24 | 48.24 | 73 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1028 | 1027 | 1546 | 1013 |
AUT | Austria | parliament | 1927-04-24 | 42.28 | 71 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 1028 | 1027 | 1546 | 973 |
AUT | Austria | parliament | 1927-04-24 | 12 | 165 | GDVP | Großdeutsche Volkspartei | Greater German People's Party | 7.4 | 59 | 1028 | 1027 | 1546 | 2674 | |
AUT | Austria | parliament | 1927-04-24 | 6.32 | 9 | 165 | L | Landbund für Österreich | Rural Federation | 8.8 | 59 | 1028 | 1027 | 1546 | 2681 |
AUT | Austria | parliament | 1927-04-24 | 1.0 | 0 | 165 | UV | Udeverband, Bund gegen Korruption | Udeverband, Association against Corruption | 6.2 | 59 | 1028 | 1027 | 1546 | 2683 |
AUT | Austria | parliament | 1930-11-09 | 41.14 | 72 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 1029 | 1028 | 1550 | 973 |
AUT | Austria | parliament | 1930-11-09 | 35.65 | 66 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1029 | 1028 | 1550 | 1013 |
AUT | Austria | parliament | 1930-11-09 | 10 | 165 | GDVP | Großdeutsche Volkspartei | Greater German People's Party | 7.4 | 59 | 1029 | 1028 | 1550 | 2674 | |
AUT | Austria | parliament | 1930-11-09 | 9 | 165 | L | Landbund für Österreich | Rural Federation | 8.8 | 59 | 1029 | 1028 | 1550 | 2681 | |
AUT | Austria | parliament | 1930-11-09 | 6.17 | 8 | 165 | HB | Heimatblock | Homeland Block | 8.8 | 59 | 1029 | 1028 | 1550 | 2685 |
AUT | Austria | parliament | 1930-11-09 | 3.03 | 0 | 165 | DNSAP | Nationalsozialistische Arbeiterpartei | National Socialist Workers' Party | 8.8 | 59 | 1029 | 1028 | 1550 | 2684 |
AUT | Austria | parliament | 1930-11-09 | 12.8 | 165 | WB | Wirtschaftsblock | Economic bloc | 8.8 | 59 | 1029 | 1028 | 1550 | 2699 | |
AUT | Austria | parliament | 1945-11-25 | 49.8 | 85 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 402 | 1029 | 452 | 1013 |
AUT | Austria | parliament | 1945-11-25 | 44.6 | 76 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 402 | 1029 | 452 | 973 |
AUT | Austria | parliament | 1945-11-25 | 5.4 | 4 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 402 | 1029 | 452 | 769 |
AUT | Austria | parliament | 1945-11-25 | 0.2 | 0 | 165 | no-seat | no seat | no seat | 59 | 402 | 1029 | 452 | 2055 | |
AUT | Austria | parliament | 1949-10-09 | 44.0 | 77 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 67 | 402 | 884 | 1013 |
AUT | Austria | parliament | 1949-10-09 | 38.7 | 67 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 67 | 402 | 884 | 973 |
AUT | Austria | parliament | 1949-10-09 | 11.7 | 16 | 165 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 67 | 402 | 884 | 50 |
AUT | Austria | parliament | 1949-10-09 | 5.1 | 5 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 67 | 402 | 884 | 769 |
AUT | Austria | parliament | 1949-10-09 | 0.28 | 0 | 165 | no-seat | no seat | no seat | 59 | 67 | 402 | 884 | 2055 | |
AUT | Austria | parliament | 1953-02-22 | 41.3 | 74 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 11 | 67 | 560 | 1013 |
AUT | Austria | parliament | 1953-02-22 | 42.1 | 73 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 11 | 67 | 560 | 973 |
AUT | Austria | parliament | 1953-02-22 | 10.9 | 14 | 165 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 11 | 67 | 560 | 50 |
AUT | Austria | parliament | 1953-02-22 | 5.3 | 4 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 11 | 67 | 560 | 769 |
AUT | Austria | parliament | 1953-02-22 | 0.13 | 0 | 165 | no-seat | no seat | no seat | 59 | 11 | 67 | 560 | 2055 | |
AUT | Austria | parliament | 1956-05-13 | 46.0 | 82 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 169 | 11 | 659 | 1013 |
AUT | Austria | parliament | 1956-05-13 | 43.0 | 74 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 169 | 11 | 659 | 973 |
AUT | Austria | parliament | 1956-05-13 | 6.5 | 6 | 165 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 169 | 11 | 659 | 50 |
AUT | Austria | parliament | 1956-05-13 | 4.4 | 3 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 169 | 11 | 659 | 769 |
AUT | Austria | parliament | 1956-05-13 | 0.04 | 0 | 165 | no-seat | no seat | no seat | 59 | 169 | 11 | 659 | 2055 | |
AUT | Austria | parliament | 1959-05-10 | 44.2 | 79 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 347 | 169 | 105 | 1013 |
AUT | Austria | parliament | 1959-05-10 | 44.8 | 78 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 347 | 169 | 105 | 973 |
AUT | Austria | parliament | 1959-05-10 | 7.7 | 8 | 165 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 347 | 169 | 105 | 50 |
AUT | Austria | parliament | 1959-05-10 | 3.3 | 0 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 347 | 169 | 105 | 769 |
AUT | Austria | parliament | 1962-11-18 | 45.4 | 81 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 495 | 347 | 533 | 1013 |
AUT | Austria | parliament | 1962-11-18 | 44.0 | 76 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 495 | 347 | 533 | 973 |
AUT | Austria | parliament | 1962-11-18 | 7.0 | 8 | 165 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 495 | 347 | 533 | 50 |
AUT | Austria | parliament | 1962-11-18 | 3.0 | 0 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 495 | 347 | 533 | 769 |
AUT | Austria | parliament | 1966-03-06 | 48.35 | 85 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 608 | 495 | 1035 | 1013 |
AUT | Austria | parliament | 1966-03-06 | 42.56 | 74 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 608 | 495 | 1035 | 973 |
AUT | Austria | parliament | 1966-03-06 | 5.35 | 6 | 165 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 608 | 495 | 1035 | 50 |
AUT | Austria | parliament | 1966-03-06 | 3.28 | 0 | 165 | DFP | Demokratische Fortschrittliche Partei | Democratic Progressive Party | 8.8 | 59 | 608 | 495 | 1035 | 1743 |
AUT | Austria | parliament | 1970-03-01 | 48.4 | 81 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 377 | 608 | 561 | 973 |
AUT | Austria | parliament | 1970-03-01 | 44.7 | 78 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 377 | 608 | 561 | 1013 |
AUT | Austria | parliament | 1970-03-01 | 5.5 | 6 | 165 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 377 | 608 | 561 | 50 |
AUT | Austria | parliament | 1970-03-01 | 1.0 | 0 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 377 | 608 | 561 | 769 |
AUT | Austria | parliament | 1971-10-10 | 50.0 | 93 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 185 | 377 | 354 | 973 |
AUT | Austria | parliament | 1971-10-10 | 43.1 | 80 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 185 | 377 | 354 | 1013 |
AUT | Austria | parliament | 1971-10-10 | 5.5 | 10 | 183 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 185 | 377 | 354 | 50 |
AUT | Austria | parliament | 1971-10-10 | 1.4 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 185 | 377 | 354 | 769 |
AUT | Austria | parliament | 1975-10-05 | 50.4 | 93 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 221 | 185 | 365 | 973 |
AUT | Austria | parliament | 1975-10-05 | 42.9 | 80 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 221 | 185 | 365 | 1013 |
AUT | Austria | parliament | 1975-10-05 | 5.4 | 10 | 183 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 221 | 185 | 365 | 50 |
AUT | Austria | parliament | 1975-10-05 | 1.2 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 221 | 185 | 365 | 769 |
AUT | Austria | parliament | 1979-05-06 | 51.0 | 95 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 452 | 221 | 350 | 973 |
AUT | Austria | parliament | 1979-05-06 | 41.9 | 77 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 452 | 221 | 350 | 1013 |
AUT | Austria | parliament | 1979-05-06 | 6.1 | 11 | 183 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 452 | 221 | 350 | 50 |
AUT | Austria | parliament | 1979-05-06 | 1.0 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 452 | 221 | 350 | 769 |
AUT | Austria | parliament | 1983-04-24 | 47.6 | 90 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 456 | 452 | 463 | 973 |
AUT | Austria | parliament | 1983-04-24 | 43.2 | 81 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 456 | 452 | 463 | 1013 |
AUT | Austria | parliament | 1983-04-24 | 5.0 | 12 | 183 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 456 | 452 | 463 | 50 |
AUT | Austria | parliament | 1983-04-24 | 1.4 | 0 | 183 | ALO | Alternative Liste Österreichs | Alternative List Austria | 2.5 | 59 | 456 | 452 | 463 | 1739 |
AUT | Austria | parliament | 1983-04-24 | 2.0 | 0 | 183 | VGO | Vereinte Grüne Österreichs | United Greens Austria | 2.5 | 59 | 456 | 452 | 463 | 1740 |
AUT | Austria | parliament | 1986-11-23 | 43.1 | 80 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 235 | 456 | 828 | 973 |
AUT | Austria | parliament | 1986-11-23 | 41.3 | 77 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 235 | 456 | 828 | 1013 |
AUT | Austria | parliament | 1986-11-23 | 9.7 | 18 | 183 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 235 | 456 | 828 | 50 |
AUT | Austria | parliament | 1986-11-23 | 4.8 | 8 | 183 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 235 | 456 | 828 | 1429 |
AUT | Austria | parliament | 1986-11-23 | 0.7 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 235 | 456 | 828 | 769 |
AUT | Austria | parliament | 1990-10-07 | 42.8 | 80 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 325 | 235 | 873 | 973 |
AUT | Austria | parliament | 1990-10-07 | 32.1 | 60 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 325 | 235 | 873 | 1013 |
AUT | Austria | parliament | 1990-10-07 | 16.6 | 33 | 183 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 325 | 235 | 873 | 50 |
AUT | Austria | parliament | 1990-10-07 | 4.8 | 10 | 183 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 325 | 235 | 873 | 1429 |
AUT | Austria | parliament | 1990-10-07 | 2.0 | 0 | 183 | VGO | Vereinte Grüne Österreichs | United Greens Austria | 2.5 | 59 | 325 | 235 | 873 | 1740 |
AUT | Austria | parliament | 1994-10-09 | 34.9 | 65 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 66 | 325 | 524 | 973 |
AUT | Austria | parliament | 1994-10-09 | 27.7 | 52 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 66 | 325 | 524 | 1013 |
AUT | Austria | parliament | 1994-10-09 | 22.5 | 42 | 183 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 66 | 325 | 524 | 50 |
AUT | Austria | parliament | 1994-10-09 | 7.3 | 13 | 183 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 66 | 325 | 524 | 1429 |
AUT | Austria | parliament | 1994-10-09 | 6.0 | 11 | 183 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 66 | 325 | 524 | 955 |
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;