view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows
This data as json, CSV (advanced)
election_date (date) 837 ✖
- 2014-05-25 239
- 2019-05-26 234
- 2009-06-07 217
- 2004-06-13 193
- 1999-06-13 148
- 1989-06-18 122
- 1994-06-12 109
- 1984-06-17 87
- 1979-06-10 85
- 1996-10-20 36
- 2014-05-24 36
- 2019-05-25 36
- 1992-06-06 30
- 2011-12-04 30
- 2022-11-01 30
- 2004-06-12 26
- 1991-10-20 25
- 2006-04-09 25
- 2019-05-23 25
- 2007-11-25 24
- 2009-06-04 24
- 2012-06-17 24
- 1993-06-06 23
- 1994-03-27 22
- 1995-10-01 22
- 1990-06-09 21
- 1991-10-27 21
- 1990-04-08 19
- 1996-11-03 19
- 2015-11-08 19
- 2019-11-10 19
- 1946-06-02 18
- 1980-10-05 18
- 1992-12-06 18
- 2000-10-08 18
- 2002-06-16 18
- 2021-03-17 18
- 1924-05-04 17
- 1989-06-15 17
- 1992-04-05 17
- 1992-09-27 17
- 1993-09-19 17
- 1995-01-01 17
- 1998-10-03 17
- 1999-05-17 17
- 2017-06-18 17
- 2022-04-22 17
- 1919-10-26 16
- 1928-05-20 16
- 1930-09-14 16
- 1951-07-30 16
- 1979-10-21 16
- 1983-10-23 16
- 1984-07-23 16
- 1987-07-19 16
- 1987-10-18 16
- 1988-11-01 16
- 1994-10-01 16
- 1995-10-22 16
- 1999-10-24 16
- 2000-01-03 16
- 2001-05-13 16
- 2003-11-23 16
- 2019-06-05 16
- 2019-10-20 16
- 2022-10-01 16
- 1924-12-07 15
- 1933-04-26 15
- 1971-04-28 15
- 1972-11-29 15
- 1981-11-08 15
- 1987-06-14 15
- 1987-09-08 15
- 1998-03-11 15
- 2003-01-28 15
- 2003-10-19 15
- 2007-01-01 15
- 2013-01-22 15
- 2013-02-25 15
- 2018-03-04 15
- 2018-06-03 15
- 2019-04-28 15
- 2022-09-25 15
- 1932-07-31 14
- 1932-11-06 14
- 1965-11-01 14
- 1969-10-28 14
- 1973-12-04 14
- 1977-02-15 14
- 1977-05-17 14
- 1978-03-19 14
- 1978-12-17 14
- 1979-03-01 14
- 1981-10-18 14
- 1983-06-26 14
- 1984-01-10 14
- 1988-05-10 14
- 1989-10-29 14
- 1990-04-12 14
- 1990-12-12 14
- 1991-11-24 14
- 1994-09-21 14
- 1996-04-21 14
- 1996-05-29 14
- 2001-11-20 14
- 2007-06-17 14
- 2008-10-12 14
- 2009-09-27 14
- 2015-06-18 14
- 2015-12-20 14
- 2017-03-15 14
- 2019-04-09 14
- 2020-02-29 14
- 2020-10-11 14
- 2021-03-23 14
- 2021-05-30 14
- 2022-04-03 14
- 2022-06-19 14
- 1918-12-14 13
- 1920-06-06 13
- 1949-01-25 13
- 1949-08-14 13
- 1955-07-26 13
- 1958-05-25 13
- 1959-11-03 13
- 1975-01-09 13
- 1977-06-15 13
- 1979-06-03 13
- 1982-09-08 13
- 1985-10-13 13
- 1986-06-22 13
- 1990-05-20 13
- 1994-05-03 13
- 1996-11-10 13
- 1999-06-10 13
- 2000-03-12 13
- 2005-02-08 13
- 2005-05-05 13
- 2006-03-28 13
- 2007-10-21 13
- 2007-11-13 13
- 2009-02-10 13
- 2010-05-06 13
- 2010-06-13 13
- 2011-09-15 13
- 2011-11-20 13
- 2012-05-06 13
- 2012-10-14 13
- 2013-05-12 13
- 2014-07-13 13
- 2015-05-07 13
- 2015-10-18 13
- 2016-06-26 13
- 2016-09-11 13
- 2016-10-09 13
- 2019-10-13 13
- 1919-02-16 12
- 1925-07-01 12
- 1929-07-03 12
- 1935-10-27 12
- 1945-10-21 12
- 1948-04-18 12
- 1958-06-01 12
- 1961-08-15 12
- 1967-02-15 12
- 1967-10-29 12
- 1973-12-31 12
- 1974-02-28 12
- 1974-10-10 12
- 1975-09-22 12
- 1975-10-26 12
- 1976-06-20 12
- 1977-05-25 12
- 1979-10-23 12
- 1981-12-08 12
- 1983-03-21 12
- 1987-03-16 12
- 1987-06-11 12
- 1987-12-13 12
- 1992-09-20 12
- 1992-11-15 12
- 1993-03-28 12
- 1995-03-19 12
- 1995-05-21 12
- 1996-03-03 12
- 1997-05-01 12
- 2002-09-21 12
- 2002-11-03 12
- 2004-03-14 12
- 2004-06-10 12
- 2004-10-03 12
- 2007-06-10 12
- 2007-10-19 12
- 2010-06-12 12
- 2011-10-23 12
- 2012-03-10 12
- 2012-09-12 12
- 2012-12-16 12
- 2013-04-14 12
- 2013-10-25 12
- 2014-05-22 12
- 2015-03-17 12
- 2016-02-26 12
- 2018-04-08 12
- 2021-09-26 12
- 2022-05-21 12
- 1918-07-03 11
- 1922-07-05 11
- 1933-03-05 11
- 1937-05-26 11
- 1939-10-29 11
- 1943-10-31 11
- 1953-09-06 11
- 1963-04-28 11
- 1963-05-15 11
- 1971-10-31 11
- 1971-11-07 11
- 1974-03-10 11
- 1977-04-17 11
- 1979-05-03 11
- 1979-12-02 11
- 1981-05-26 11
- 1981-06-30 11
- 1982-10-28 11
- 1983-06-09 11
- 1987-06-10 11
- 1991-03-17 11
- 1992-06-23 11
- 1994-05-29 11
- 1995-03-05 11
- 1997-06-01 11
- 1997-09-21 11
- 1999-03-21 11
- 2001-06-07 11
- 2002-05-15 11
- 2002-10-05 11
- 2003-05-18 11
- 2004-10-24 11
- 2005-09-25 11
- 2006-10-07 11
- 2006-11-22 11
- 2008-03-09 11
- 2008-04-13 11
- 2008-09-21 11
- 2010-05-29 11
- 2010-06-09 11
- 2012-12-09 11
- 2013-04-27 11
- 2014-04-06 11
- 2014-05-23 11
- 2015-01-25 11
- 2016-07-02 11
- 2017-03-26 11
- 2017-10-21 11
- 2019-04-14 11
- 2019-12-12 11
- 2020-02-08 11
- 2020-07-05 11
- 2021-04-04 11
- 2021-09-13 11
- 2022-01-30 11
- 1919-01-19 10
- 1922-10-29 10
- 1925-03-01 10
- 1925-10-25 10
- 1931-10-27 10
- 1932-05-08 10
- 1933-10-16 10
- 1934-09-15 10
- 1935-11-14 10
- 1939-04-02 10
- 1939-04-03 10
- 1943-08-21 10
- 1945-07-05 10
- 1947-10-26 10
- 1951-10-28 10
- 1953-06-07 10
- 1955-10-30 10
- 1956-01-02 10
- 1960-11-15 10
- 1962-02-05 10
- 1966-03-21 10
- 1968-05-19 10
- 1970-03-16 10
- 1971-09-21 10
- 1972-01-03 10
- 1972-05-07 10
- 1973-03-11 10
- 1979-03-19 10
- 1986-05-21 10
- 1987-04-25 10
- 1989-09-06 10
- 1991-10-13 10
- 1992-04-09 10
- 1993-07-18 10
- 1994-12-18 10
- 1996-06-01 10
- 1997-06-06 10
- 1998-05-06 10
- 1999-03-07 10
- 1999-11-27 10
- 2000-06-25 10
- 2000-10-15 10
- 2000-11-26 10
- 2001-09-23 10
- 2002-05-17 10
- 2002-07-27 10
- 2003-01-22 10
- 2003-03-16 10
- 2005-06-25 10
- 2007-03-18 10
- 2007-07-22 10
- 2009-06-06 10
- 2009-08-30 10
- 2011-04-17 10
- 2013-09-07 10
- 2014-10-05 10
- 2014-12-14 10
- 2015-04-19 10
- 2016-03-06 10
- 2017-06-08 10
- 2017-09-11 10
- 2018-10-06 10
- 2019-05-18 10
- 2019-09-17 10
- 2019-10-06 10
- 2020-12-06 10
- 2021-10-09 10
- 1910-05-08 9
- 1928-04-29 9
- 1928-06-03 9
- 1928-10-28 9
- 1931-06-07 9
- 1931-10-25 9
- 1933-07-01 9
- 1935-10-22 9
- 1943-03-23 9
- 1945-06-11 9
- 1948-07-07 9
- 1952-06-25 9
- 1953-09-22 9
- 1957-05-14 9
- 1958-07-07 9
- 1958-11-30 9
- 1959-03-12 9
- 1959-10-25 9
- 1962-11-25 9
- 1963-10-27 9
- 1964-09-22 9
- 1966-11-26 9
- 1968-01-23 9
- 1970-06-18 9
- 1973-09-09 9
- 1975-04-25 9
- 1981-06-21 9
- 1985-10-06 9
- 1986-03-16 9
- 1993-09-13 9
- 1994-06-09 9
- 1997-09-16 9
- 1998-05-24 9
- 1998-06-20 9
- 1999-04-18 9
- 2001-09-10 9
- 2003-11-09 9
- 2004-10-09 9
- 2005-09-11 9
- 2005-09-17 9
- 2006-06-17 9
- 2007-05-20 9
- 2010-09-19 9
- 2011-02-25 9
- 2011-11-26 9
- 2013-09-09 9
- 2013-09-22 9
- 2013-10-20 9
- 2014-09-14 9
- 2014-09-20 9
- 2015-09-20 9
- 2015-10-25 9
- 2016-05-22 9
- 2016-12-11 9
- 2017-09-24 9
- 2017-10-22 9
- 2017-10-28 9
- 2019-03-03 9
- 2019-05-24 9
- 2019-07-07 9
- 2020-03-02 9
- 2021-07-11 9
- 2021-09-25 9
- 2021-10-31 9
- 2021-11-14 9
- 2022-09-11 9
- 2022-10-02 9
- 1915-10-21 8
- 1919-10-16 8
- 1919-12-13 8
- 1923-08-27 8
- 1924-10-21 8
- 1924-10-29 8
- 1927-06-09 8
- 1927-09-15 8
- 1927-10-17 8
- 1930-10-01 8
- 1930-10-20 8
- 1932-09-18 8
- 1932-11-16 8
- 1936-05-24 8
- 1936-07-01 8
- 1936-10-19 8
- 1937-06-06 8
- 1937-10-23 8
- 1939-07-01 8
- 1940-09-21 8
- 1945-03-18 8
- 1945-10-30 8
- 1946-05-17 8
- 1946-09-28 8
- 1947-10-28 8
- 1948-02-04 8
- 1948-07-02 8
- 1949-01-23 8
- 1949-06-27 8
- 1950-02-23 8
- 1950-09-05 8
- 1951-07-03 8
- 1951-10-25 8
- 1952-10-01 8
- 1953-04-19 8
- 1953-04-21 8
- 1954-03-08 8
- 1954-04-11 8
- 1956-06-13 8
- 1957-03-05 8
- 1961-03-26 8
- 1961-10-04 8
- 1963-11-30 8
- 1964-09-20 8
- 1965-05-23 8
- 1966-11-22 8
- 1967-03-12 8
- 1968-03-31 8
- 1968-09-15 8
- 1977-09-11 8
- 1977-11-20 8
- 1979-10-07 8
- 1980-06-22 8
- 1981-06-11 8
- 1981-09-14 8
- 1983-04-25 8
- 1983-12-18 8
- 1986-01-01 8
- 1986-07-06 8
- 1987-02-17 8
- 1988-06-12 8
- 1989-09-11 8
- 1990-02-18 8
- 1990-12-02 8
- 1991-09-15 8
- 1991-10-06 8
- 1992-11-25 8
- 1994-09-18 8
- 1995-09-17 8
- 1996-05-26 8
- 1996-10-12 8
- 1998-09-20 8
- 1998-09-26 8
- 1998-09-27 8
- 1999-10-10 8
- 2001-05-27 8
- 2001-11-10 8
- 2002-03-17 8
- 2002-09-15 8
- 2003-03-02 8
- 2004-11-28 8
- 2005-02-20 8
- 2005-09-12 8
- 2006-05-21 8
- 2006-09-17 8
- 2007-03-04 8
- 2007-05-24 8
- 2008-11-08 8
- 2008-11-30 8
- 2009-06-05 8
- 2009-07-05 8
- 2009-09-14 8
- 2010-04-25 8
- 2010-08-21 8
- 2011-10-09 8
- 2013-09-29 8
- 2014-10-04 8
- 2016-10-29 8
- 2018-09-09 8
- 2018-10-14 8
- 1902-05-11 7
- 1906-05-20 7
- 1914-05-10 7
- 1918-10-21 7
- 1919-11-16 7
- 1920-09-21 7
- 1920-10-17 7
- 1921-10-24 7
- 1921-11-20 7
- 1922-05-28 7
- 1922-11-15 7
- 1924-09-21 7
- 1926-12-02 7
- 1927-07-01 7
- 1929-04-02 7
- 1929-07-01 7
- 1930-11-09 7
- 1934-06-03 7
- 1936-09-20 7
- 1943-06-23 7
- 1945-10-08 7
- 1946-02-17 7
- 1946-04-10 7
- 1949-10-10 7
- 1950-09-04 7
- 1951-05-30 7
- 1953-08-10 7
- 1953-10-12 7
- 1954-05-18 7
- 1955-02-27 7
- 1955-05-26 7
- 1957-09-15 7
- 1957-10-07 7
- 1959-10-08 7
- 1961-09-11 7
- 1965-09-12 7
- 1965-11-08 7
- 1966-03-31 7
- 1968-06-30 7
- 1969-09-07 7
- 1972-12-10 7
- 1976-12-05 7
- 1977-12-10 7
- 1981-05-24 7
- 1982-09-19 7
- 1985-09-08 7
- 1985-09-15 7
- 1988-09-18 7
- 1990-03-10 7
- 1990-03-24 7
- 1991-04-20 7
- 1993-10-25 7
- 1994-10-16 7
- 1995-04-08 7
- 1995-12-24 7
- 1996-03-02 7
- 1997-04-19 7
- 1997-06-02 7
- 2001-06-18 7
- 2002-04-21 7
- 2002-06-15 7
- 2002-09-22 7
- 2004-03-07 7
- 2005-09-18 7
- 2006-10-01 7
- 2008-09-28 7
- 2011-05-22 7
- 2011-06-05 7
- 2015-03-01 7
- 2015-10-04 7
- 2017-09-23 7
- 2017-10-15 7
- 2019-10-21 7
- 2020-10-17 7
- 1906-05-29 6
- 1906-12-02 6
- 1909-05-25 6
- 1909-10-25 6
- 1911-10-29 6
- 1912-10-21 6
- 1914-10-25 6
- 1917-10-28 6
- 1918-04-22 6
- 1919-03-03 6
- 1920-04-26 6
- 1920-07-06 6
- 1920-09-17 6
- 1921-09-26 6
- 1921-12-06 6
- 1922-06-22 6
- 1922-07-03 6
- 1922-12-16 6
- 1923-10-21 6
- 1923-12-06 6
- 1924-04-11 6
- 1924-05-25 6
- 1925-08-05 6
- 1925-10-29 6
- 1926-09-14 6
- 1928-09-21 6
- 1928-11-14 6
- 1929-05-25 6
- 1929-05-30 6
- 1929-10-12 6
- 1931-12-02 6
- 1931-12-19 6
- 1932-02-16 6
- 1934-06-24 6
- 1935-10-14 6
- 1935-11-27 6
- 1936-05-03 6
- 1940-03-26 6
- 1940-09-15 6
- 1944-05-30 6
- 1944-09-17 6
- 1946-11-10 6
- 1947-04-25 6
- 1947-10-27 6
- 1948-09-19 6
- 1950-06-04 6
- 1951-06-17 6
- 1952-09-21 6
- 1953-06-28 6
- 1956-09-16 6
- 1957-06-10 6
- 1960-09-18 6
- 1960-11-20 6
- 1961-09-17 6
- 1962-02-19 6
- 1962-06-18 6
- 1964-10-15 6
- 1965-04-07 6
- 1965-09-19 6
- 1967-01-29 6
- 1967-06-11 6
- 1968-06-25 6
- 1969-12-27 6
- 1970-09-20 6
- 1971-06-13 6
- 1972-10-30 6
- 1972-12-02 6
- 1973-09-16 6
- 1974-05-26 6
- 1974-06-30 6
- 1974-07-08 6
- 1975-12-13 6
- 1976-04-25 6
- 1976-09-19 6
- 1979-09-16 6
- 1982-02-18 6
- 1982-11-24 6
- 1983-03-06 6
- 1983-04-23 6
- 1984-12-01 6
- 1987-01-25 6
- 1987-10-29 6
- 1993-03-13 6
- 1994-10-09 6
- 1995-12-17 6
- 1996-09-22 6
- 1996-10-13 6
- 1999-05-08 6
- 1999-10-03 6
- 2000-11-27 6
- 2003-05-10 6
- 2004-06-28 6
- 2006-01-23 6
- 2006-06-03 6
- 2007-05-12 6
- 2007-09-16 6
- 2007-11-24 6
- 2008-10-14 6
- 2009-04-25 6
- 2009-10-04 6
- 2010-10-02 6
- 2011-03-06 6
- 2011-05-02 6
- 2011-06-12 6
- 2011-09-17 6
- 2015-06-07 6
- 2015-10-19 6
- 2018-06-24 6
- 2019-09-29 6
- 2021-09-20 6
- 1900-05-27 5
- 1901-03-30 5
- 1902-10-26 5
- 1903-06-16 5
- 1903-09-16 5
- 1903-12-16 5
- 1904-05-29 5
- 1905-10-29 5
- 1906-05-27 5
- 1908-05-24 5
- 1908-10-25 5
- 1910-05-20 5
- 1910-05-22 5
- 1911-12-19 5
- 1912-06-02 5
- 1913-05-20 5
- 1914-12-11 5
- 1915-05-07 5
- 1917-09-16 5
- 1917-10-02 5
- 1925-11-04 5
- 1927-04-24 5
- 1927-07-09 5
- 1928-11-17 5
- 1930-07-28 5
- 1931-06-12 5
- 1932-11-27 5
- 1933-01-24 5
- 1933-07-16 5
- 1937-06-29 5
- 1942-07-05 5
- 1942-10-19 5
- 1949-06-26 5
- 1949-10-09 5
- 1951-05-06 5
- 1953-02-22 5
- 1953-12-14 5
- 1954-05-30 5
- 1955-12-10 5
- 1956-05-13 5
- 1956-06-24 5
- 1958-03-31 5
- 1958-11-22 5
- 1959-02-01 5
- 1959-06-28 5
- 1959-10-26 5
- 1961-12-09 5
- 1963-04-08 5
- 1963-11-21 5
- 1964-06-07 5
- 1966-03-28 5
- 1968-12-15 5
- 1969-06-18 5
- 1969-09-28 5
- 1969-10-25 5
- 1972-11-19 5
- 1973-02-28 5
- 1974-05-18 5
- 1974-11-17 5
- 1976-09-05 5
- 1976-10-03 5
- 1977-06-16 5
- 1978-06-25 5
- 1979-05-22 5
- 1979-12-03 5
- 1980-02-18 5
- 1980-10-18 5
- 1983-03-05 5
- 1983-04-24 5
- 1984-09-04 5
- 1986-11-23 5
- 1987-07-11 5
- 1989-11-05 5
- 1990-10-07 5
- 1990-10-27 5
- 1991-05-19 5
- 1993-10-10 5
- 1993-11-06 5
- 2000-04-09 5
- 2002-11-24 5
- 1900-07-01 4
- 1901-04-03 4
- 1902-05-25 4
- 1902-11-25 4
- 1905-12-06 4
- 1906-08-27 4
- 1908-12-01 4
- 1910-04-13 4
- 1911-09-21 4
- 1914-05-24 4
- 1914-09-13 4
- 1919-11-15 4
- 1919-12-17 4
- 1922-12-07 4
- 1923-10-27 4
- 1925-11-14 4
- 1937-07-01 4
- 1938-06-17 4
- 1943-09-25 4
- 1945-11-25 4
- 1946-06-30 4
- 1948-06-06 4
- 1949-10-24 4
- 1949-12-10 4
- 1951-04-28 4
- 1951-06-03 4
- 1954-05-29 4
- 1958-05-22 4
- 1959-05-10 4
- 1962-11-18 4
- 1963-06-09 4
- 1966-03-06 4
- 1970-03-01 4
- 1971-10-10 4
- 1972-11-25 4
- 1975-10-05 4
- 1975-11-29 4
- 1978-11-25 4
- 1979-05-06 4
- 1981-01-01 4
- 1981-11-28 4
- 1984-07-14 4
- 1985-06-02 4
- 1985-12-08 4
- 1988-11-21 4
- 2015-11-01 4
- 1900-11-07 3
- 1904-11-03 3
- 1908-10-26 3
- 1911-09-24 3
- 1913-05-31 3
- 1914-04-07 3
- 1914-09-05 3
- 1917-05-05 3
- 1917-12-17 3
- 1938-10-15 3
- 1946-11-27 3
- 1949-11-30 3
- 1951-09-01 3
- 1954-11-13 3
- 1955-02-28 3
- 1957-11-30 3
- 1960-11-26 3
- 1969-11-29 3
- 1971-06-14 3
- 1976-09-18 3
- 1981-12-12 3
- 1983-11-06 3
- 1987-05-09 3
- 1987-08-15 3
- 1990-04-29 3
- 1992-02-22 3
- 1996-10-26 3
- 1998-09-05 3
- 2003-04-12 3
- 2008-03-08 3
- 2013-03-09 3
- 2017-06-03 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | parliament | 1946-09-28 | 49.7 | 43 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 739 | 737 | 574 | 1253 |
AUS | Australia | parliament | 1946-09-28 | 28.6 | 15 | 75 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 739 | 737 | 574 | 1411 |
AUS | Australia | parliament | 1946-09-28 | 10.7 | 12 | 75 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 739 | 737 | 574 | 184 |
AUS | Australia | parliament | 1946-09-28 | 2.3 | 2 | 75 | none | no party affiliation | no party affiliation | 33 | 739 | 737 | 574 | 1396 | |
AUS | Australia | parliament | 1946-09-28 | 4.4 | 2 | 75 | LCL | Liberal and Country League | Liberal and Country League | 3.3 | 33 | 739 | 737 | 574 | 1919 |
AUS | Australia | parliament | 1946-09-28 | 1.6 | 1 | 75 | LLP | Lang Labour Party | Lang Labour Party | 3.3 | 33 | 739 | 737 | 574 | 303 |
AUS | Australia | parliament | 1946-09-28 | 1.2 | 0 | 75 | SPA | Services Party of Australia | Services Party of Australia | 33 | 739 | 737 | 574 | 1897 | |
AUS | Australia | parliament | 1946-09-28 | 1.5 | 0 | 75 | CPA | Communist Party of Australia | Communist Party of Australia | 1.3 | 33 | 739 | 737 | 574 | 1922 |
AUS | Australia | parliament | 1949-12-10 | 39.3 | 55 | 123 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 734 | 739 | 490 | 1411 |
AUS | Australia | parliament | 1949-12-10 | 46.0 | 48 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 734 | 739 | 490 | 1253 |
AUS | Australia | parliament | 1949-12-10 | 10.8 | 19 | 123 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 734 | 739 | 490 | 184 |
AUS | Australia | parliament | 1949-12-10 | 3.9 | 1 | 123 | none | no party affiliation | no party affiliation | 33 | 734 | 739 | 490 | 1396 | |
AUS | Australia | parliament | 1951-04-28 | 47.7 | 54 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 763 | 734 | 450 | 1253 |
AUS | Australia | parliament | 1951-04-28 | 40.5 | 52 | 123 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 763 | 734 | 450 | 1411 |
AUS | Australia | parliament | 1951-04-28 | 9.7 | 17 | 123 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 763 | 734 | 450 | 184 |
AUS | Australia | parliament | 1951-04-28 | 2.1 | 0 | 123 | none | no party affiliation | no party affiliation | 33 | 763 | 734 | 450 | 1396 | |
AUS | Australia | parliament | 1954-05-29 | 50.1 | 59 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 743 | 763 | 566 | 1253 |
AUS | Australia | parliament | 1954-05-29 | 38.5 | 47 | 123 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 743 | 763 | 566 | 1411 |
AUS | Australia | parliament | 1954-05-29 | 8.5 | 17 | 123 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 743 | 763 | 566 | 184 |
AUS | Australia | parliament | 1954-05-29 | 2.9 | 0 | 123 | none | no party affiliation | no party affiliation | 33 | 743 | 763 | 566 | 1396 | |
AUS | Australia | parliament | 1955-12-10 | 39.7 | 57 | 124 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 742 | 743 | 178 | 1411 |
AUS | Australia | parliament | 1955-12-10 | 44.7 | 49 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 742 | 743 | 178 | 1253 |
AUS | Australia | parliament | 1955-12-10 | 7.9 | 18 | 124 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 742 | 743 | 178 | 184 |
AUS | Australia | parliament | 1955-12-10 | 5.1 | 0 | 124 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 742 | 743 | 178 | 1306 |
AUS | Australia | parliament | 1955-12-10 | 2.6 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 742 | 743 | 178 | 1396 | |
AUS | Australia | parliament | 1958-11-22 | 37.1 | 58 | 124 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 749 | 742 | 479 | 1411 |
AUS | Australia | parliament | 1958-11-22 | 42.9 | 47 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 749 | 742 | 479 | 1253 |
AUS | Australia | parliament | 1958-11-22 | 9.3 | 19 | 124 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 749 | 742 | 479 | 184 |
AUS | Australia | parliament | 1958-11-22 | 9.4 | 0 | 124 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 749 | 742 | 479 | 1306 |
AUS | Australia | parliament | 1958-11-22 | 1.3 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 749 | 742 | 479 | 1396 | |
AUS | Australia | parliament | 1961-12-09 | 48.0 | 62 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 740 | 749 | 627 | 1253 |
AUS | Australia | parliament | 1961-12-09 | 33.5 | 45 | 124 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 740 | 749 | 627 | 1411 |
AUS | Australia | parliament | 1961-12-09 | 8.5 | 17 | 124 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 740 | 749 | 627 | 184 |
AUS | Australia | parliament | 1961-12-09 | 8.7 | 0 | 124 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 740 | 749 | 627 | 1306 |
AUS | Australia | parliament | 1961-12-09 | 1.4 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 740 | 749 | 627 | 1396 | |
AUS | Australia | parliament | 1963-11-30 | 37.1 | 52 | 124 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 741 | 740 | 288 | 1411 |
AUS | Australia | parliament | 1963-11-30 | 45.5 | 52 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 741 | 740 | 288 | 1253 |
AUS | Australia | parliament | 1963-11-30 | 8.9 | 20 | 124 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 741 | 740 | 288 | 184 |
AUS | Australia | parliament | 1963-11-30 | 7.4 | 0 | 124 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 741 | 740 | 288 | 1306 |
AUS | Australia | parliament | 1963-11-30 | 1.0 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 741 | 740 | 288 | 1396 | |
AUS | Australia | parliament | 1966-11-26 | 40.1 | 61 | 124 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 764 | 741 | 261 | 1411 |
AUS | Australia | parliament | 1966-11-26 | 40.0 | 41 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 764 | 741 | 261 | 1253 |
AUS | Australia | parliament | 1966-11-26 | 9.8 | 21 | 124 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 764 | 741 | 261 | 184 |
AUS | Australia | parliament | 1966-11-26 | 2.7 | 1 | 124 | none | no party affiliation | no party affiliation | 33 | 764 | 741 | 261 | 1396 | |
AUS | Australia | parliament | 1966-11-26 | 7.3 | 0 | 124 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 764 | 741 | 261 | 1306 |
AUS | Australia | parliament | 1969-10-25 | 47.0 | 59 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 735 | 764 | 795 | 1253 |
AUS | Australia | parliament | 1969-10-25 | 34.8 | 46 | 125 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 735 | 764 | 795 | 1411 |
AUS | Australia | parliament | 1969-10-25 | 8.6 | 20 | 125 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 735 | 764 | 795 | 184 |
AUS | Australia | parliament | 1969-10-25 | 2.8 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 735 | 764 | 795 | 1396 | |
AUS | Australia | parliament | 1969-10-25 | 6.0 | 0 | 125 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 735 | 764 | 795 | 1306 |
AUS | Australia | parliament | 1972-12-02 | 49.6 | 67 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 759 | 735 | 671 | 1253 |
AUS | Australia | parliament | 1972-12-02 | 32.0 | 38 | 125 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 759 | 735 | 671 | 1411 |
AUS | Australia | parliament | 1972-12-02 | 9.4 | 20 | 125 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 759 | 735 | 671 | 184 |
AUS | Australia | parliament | 1972-12-02 | 5.2 | 0 | 125 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 759 | 735 | 671 | 1306 |
AUS | Australia | parliament | 1972-12-02 | 2.4 | 0 | 125 | AP | Australia Party | Australia Party | 6.0 | 33 | 759 | 735 | 671 | 1760 |
AUS | Australia | parliament | 1972-12-02 | 1.3 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 759 | 735 | 671 | 1396 | |
AUS | Australia | parliament | 1974-05-18 | 49.3 | 66 | 127 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 758 | 759 | 507 | 1253 |
AUS | Australia | parliament | 1974-05-18 | 34.9 | 40 | 127 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 758 | 759 | 507 | 1411 |
AUS | Australia | parliament | 1974-05-18 | 10.8 | 21 | 127 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 758 | 759 | 507 | 184 |
AUS | Australia | parliament | 1974-05-18 | 1.4 | 0 | 127 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 758 | 759 | 507 | 1306 |
AUS | Australia | parliament | 1974-05-18 | 2.3 | 0 | 127 | AP | Australia Party | Australia Party | 6.0 | 33 | 758 | 759 | 507 | 1760 |
AUS | Australia | parliament | 1975-12-13 | 41.8 | 68 | 127 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 757 | 758 | 720 | 1411 |
AUS | Australia | parliament | 1975-12-13 | 42.8 | 36 | 127 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 757 | 758 | 720 | 1253 |
AUS | Australia | parliament | 1975-12-13 | 11.0 | 22 | 127 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 757 | 758 | 720 | 184 |
AUS | Australia | parliament | 1975-12-13 | 0.2 | 1 | 127 | CouLP | Country Liberal Party | Country Liberal Party | 6.0 | 33 | 757 | 758 | 720 | 215 |
AUS | Australia | parliament | 1975-12-13 | 1.7 | 0 | 127 | none | no party affiliation | no party affiliation | 33 | 757 | 758 | 720 | 1396 | |
AUS | Australia | parliament | 1975-12-13 | 1.3 | 0 | 127 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 757 | 758 | 720 | 1306 |
AUS | Australia | parliament | 1977-12-10 | 38.1 | 67 | 124 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 755 | 757 | 836 | 1411 |
AUS | Australia | parliament | 1977-12-10 | 39.6 | 38 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 755 | 757 | 836 | 1253 |
AUS | Australia | parliament | 1977-12-10 | 9.8 | 18 | 124 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 755 | 757 | 836 | 184 |
AUS | Australia | parliament | 1977-12-10 | 0.2 | 1 | 124 | CouLP | Country Liberal Party | Country Liberal Party | 6.0 | 33 | 755 | 757 | 836 | 215 |
AUS | Australia | parliament | 1977-12-10 | 1.4 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 755 | 757 | 836 | 1396 | |
AUS | Australia | parliament | 1977-12-10 | 1.4 | 0 | 124 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 755 | 757 | 836 | 1306 |
AUS | Australia | parliament | 1977-12-10 | 9.4 | 0 | 124 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 755 | 757 | 836 | 120 |
AUS | Australia | parliament | 1980-10-18 | 37.4 | 54 | 125 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 736 | 755 | 421 | 1411 |
AUS | Australia | parliament | 1980-10-18 | 45.1 | 51 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 736 | 755 | 421 | 1253 |
AUS | Australia | parliament | 1980-10-18 | 8.9 | 20 | 125 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 736 | 755 | 421 | 184 |
AUS | Australia | parliament | 1980-10-18 | 1.7 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 736 | 755 | 421 | 1396 | |
AUS | Australia | parliament | 1980-10-18 | 6.6 | 0 | 125 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 736 | 755 | 421 | 120 |
AUS | Australia | parliament | 1983-03-05 | 49.5 | 75 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 751 | 736 | 774 | 1253 |
AUS | Australia | parliament | 1983-03-05 | 34.4 | 33 | 125 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 751 | 736 | 774 | 1411 |
AUS | Australia | parliament | 1983-03-05 | 9.0 | 17 | 125 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 751 | 736 | 774 | 184 |
AUS | Australia | parliament | 1983-03-05 | 5.0 | 0 | 125 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 751 | 736 | 774 | 120 |
AUS | Australia | parliament | 1983-03-05 | 1.7 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 751 | 736 | 774 | 1396 | |
AUS | Australia | parliament | 1984-12-01 | 47.5 | 82 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 733 | 751 | 576 | 1253 |
AUS | Australia | parliament | 1984-12-01 | 34.1 | 44 | 148 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 733 | 751 | 576 | 1411 |
AUS | Australia | parliament | 1984-12-01 | 10.6 | 21 | 148 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 733 | 751 | 576 | 184 |
AUS | Australia | parliament | 1984-12-01 | 0.3 | 1 | 148 | CouLP | Country Liberal Party | Country Liberal Party | 6.0 | 33 | 733 | 751 | 576 | 215 |
AUS | Australia | parliament | 1984-12-01 | 1.4 | 0 | 148 | none | no party affiliation | no party affiliation | 33 | 733 | 751 | 576 | 1396 | |
AUS | Australia | parliament | 1984-12-01 | 5.4 | 0 | 148 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 733 | 751 | 576 | 120 |
AUS | Australia | parliament | 1987-07-11 | 45.8 | 86 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 732 | 733 | 401 | 1253 |
AUS | Australia | parliament | 1987-07-11 | 34.3 | 43 | 148 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 732 | 733 | 401 | 1411 |
AUS | Australia | parliament | 1987-07-11 | 11.5 | 19 | 148 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 732 | 733 | 401 | 184 |
AUS | Australia | parliament | 1987-07-11 | 6.0 | 0 | 148 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 732 | 733 | 401 | 120 |
AUS | Australia | parliament | 1987-07-11 | 2.0 | 0 | 148 | none | no party affiliation | no party affiliation | 33 | 732 | 733 | 401 | 1396 | |
AUS | Australia | parliament | 1990-03-24 | 39.4 | 78 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 752 | 732 | 875 | 1253 |
AUS | Australia | parliament | 1990-03-24 | 34.8 | 55 | 148 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 752 | 732 | 875 | 1411 |
AUS | Australia | parliament | 1990-03-24 | 8.4 | 14 | 148 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 752 | 732 | 875 | 184 |
AUS | Australia | parliament | 1990-03-24 | 3.4 | 1 | 148 | none | no party affiliation | no party affiliation | 33 | 752 | 732 | 875 | 1396 | |
AUS | Australia | parliament | 1990-03-24 | 1.4 | 0 | 148 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 752 | 732 | 875 | 751 |
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;