Data repository Archive

0

New year, new data

Over the break I’ve been working to expand the size of this website’s data repository. If you’re new to this, the repository publishes state and local election results that may not otherwise be available in an easy-to-access format.

I’ve added five more datasets over the new year:

This is in addition to other datasets added in late 2017, including the results of the 2014 state elections in Victoria, South Australia and Tasmania.

This data is all available on the internet but in a bunch of different places. Each dataset includes a list of all polling places with addresses and coordinates, which is often not otherwise available on the internet. It also includes full lists of candidates, and results at the polling place level.

In the case of the NSW 2015 dataset, the NSWEC publishes a single spreadsheet with the primary vote totals for each candidate at the booth level, but doesn’t do the same for two-party-preferred and two-candidate-preferred (the NSWEC does publish very impressive datasets of two-candidate-preferred distributions at the booth level between every possible combination of candidates, but it’s a hassle to, say, pull out the data for Coalition vs Labor in all 93 seats). The NSWEC doesn’t easily publish a spreadsheet of Legislative Council totals by seat, and the Legislative Council booth totals spreadsheet doesn’t break down below-the-line votes between groups.

All of that is now available in my repository.

The repository now includes the datasets for the last election in every Australian state and territory (and the one before that in Queensland, WA, ACT and NT), as well as council election results from New South Wales and Brisbane City Council (although I haven’t yet added the last election from each of these jurisdictions), and by-election results from the last term in New South Wales and Victoria.

I plan to keep adding the latest data and slowly progress backwards in time. I also would like to at some point look at adding old booth data at the federal level (the most recent elections are published in a very useful format anyway).

If you’d like to support this work, and find it useful, pleaseĀ sign up as a patron. Patrons who give $5 or more get a heads-up about this kind of stuff before I publish it on the website, and other updates about my work.

Become a Patron!

Hopefully this data is useful – please let me know if you do something cool with it!

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.