Data repository Archive

1

New dataset – Victorian 2014 election

I’ve got a new addition to the data repository – my collection of complete and clean election datasets. I’ve now posted the results of the 2014 Victorian state election. This dataset includes:

  • Candidate lists for both houses
  • Polling place list with latitude/longitude and full address
  • Legislative Assembly primary votes by polling place and electorate
  • Legislative Assembly two-candidate-preferred votes by polling place and electorate
  • Two-party-preferred votes by electorate
  • Legislative Council primary votes by polling place, electorate and region
  • List of electorates and regions including enrolment, and formal and informal votes for both houses.

I’ve put together this dataset to help build my guide to next November’s election, but hopefully others will also find this data useful to do your own analysis. If you find it useful, please consider signing up as a patron.

1

Queensland election dataset – pre-poll voting keeps growing

I’ve just finished pulling together all of the data from the recent Queensland state election and have added it to my data repository.

This dataset includes:

  • List of candidates
  • List of electorates, with data on turnout and formality
  • List of polling places, including full address and latitude/longitude
  • Primary vote by polling place
  • Primary vote by electorate
  • Two-candidate-preferred by electorate

The only thing I couldn’t track down was the two-candidate-preferred vote by polling place. The ECQ has previously not made this data available, although they have now published this data by PDF for the last three elections. I plan to turn those PDFs for 2009 and 2012 into accessible spreadsheets at some point, and I’ll revisit this dataset to add the 2PP figures if the ECQ eventually publish them (if you find them on some dark corner of the ECQ website, please let me know).

I now have this data published for two successive Queensland state elections. The data includes a field which categorises each polling place according to vote type. You can use this to count up how many votes were cast as ordinary votes, pre-poll votes or as other votes.

There’s been a long-term trend of more people choosing to vote early. I previously wrote about this in the context of NSW state elections, after pre-poll made up more than 14% of votes at the 2015 state election. I haven’t found any old posts about this, but the same trend is clear in federal elections – well over 1 million Australians voted early in 2016.

This data can show you that over 26% of votes at the 2017 Queensland state election were cast as pre-poll votes, up from 19.6% in 2015.

Vote type20152017
Ordinary votes62.6%56.4%
Pre-poll19.6%26.2%
Other votes (incl. postal)17.7%17.4%

I’d love to also add in the same figures for the 2009 and 2012 elections, but first I’ll need to add these datasets to the data repository. You could help expedite this work by donating to this website.

0

Data repository update – WA, SA and Tasmania

I’ve made a number of updates to the data repository in preparation for the next round of state elections.

I’ve added to the data from the 2017 WA state election. Originally I had a limited dataset for the Legislative Council election, without below-the-line vote breakdowns by polling place, and without a seat-by-seat breakdown of the special vote for the upper house. This gap has now been filled.

I’ve also posted datasets for the 2010 and 2014 Tasmanian state elections and the 2014 South Australian state election. The only thing missing is booth-level results for the SA upper house, which will be a project for another time.

As usual, these datasets can be accessed from the data page. Each dataset includes a polling place list, a candidate list, and a list of vote breakdowns by polling place and candidate. Unique IDs can be used to match between each table.

0

WA state election data posted

Following on from last month’s Western Australian state election, I’ve finished compiling data from that election and added it to the data repository for your use. The dataset includes polling place-level and seat-level data for the lower house and something similar for the upper house. There’s also complete candidate lists for both houses and a full list of polling places with addresses and lat/long information. There are a few pieces of data which are missing and this information is listed in the folder.

Check out the data.

1

Data update – Tasmanian upper house dataset

A few months ago I published a limited data repository, containing booth lists, candidate lists and election results at the booth level for a variety of state and local elections. At the time I talked about how most state electoral commissions fell short of the AEC when it comes to publishing complete and easy-to-use election datasets.

I’ve been most frustrated by the Tasmanian Electoral Commission, on two fronts. Firstly, they publish the booth-level vote data in a very unfriendly manner: upper house results are published as PNG image files. Lower house primary votes are published as PDF files, and distributions of preferences as image files. The image files look very nice, unless you want to copy them into a spreadsheet and perform deeper analysis.

Secondly, the TEC is terrible at publishing booth lists which can be matched to the results. They publish a list of premises used for each election, including the suburb, but often there are more than one booth in a suburb. The results data contains a unique booth name, but for at least a decade now the TEC has rarely if ever published the booth data in the correct format allowing the matching of those addresses to the actual vote data.

For three years from 2013 to 2015 I published guides to the Tasmanian upper house elections, which are held every May for a small part of the state. This included the tedious task of tracking down the complete data to match addresses to vote data. I’ve decided to finish this task, and have been able to put together a booth list with unique booth names for the last ten years of upper house elections from 2007 to 2016. This can then be matched to the vote data at the booth level. The booth list also includes latitude and longitude for every ordinary booth.

Download the data here.