Download L.A. mayoral election data
The Times releases machine-readable results and maps for all mayoral elections since 2001
Last week, Los Angeles elected a new mayor. In the process of covering of the race these past few months, The Data Desk assembled a variety of data sets about mayoral elections, both past and present.
We’ve already released some of it. Today, we are putting out much more with the hope that it will save someone somewhere some hassle in the future.
Currently it’s a bit of a pain to map out mayoral results as we did here. The data files that break down the vote for each precinct are published in an odd format. The map files that plot out each precinct’s shape must be purchased on a compact disc at $20 per election. Once you have the files, you still need to merge them together to make a map.
So let us be the last ones to do it.
Download the data
For each election, we are releasing three files. First, a SHP map file that includes both the shape of each precinct as well as the results for each candidate. Second, a GeoJSON map file with the same. Third, a CSV file with the results for each precinct but without a map.
|2013 runoff||SHP, GeoJSON||CSV|
|2013 primary||SHP, GeoJSON||CSV|
|2009 primary||SHP, GeoJSON||CSV|
|2005 runoff*||SHP, GeoJSON||CSV|
|2005 primary*||SHP, GeoJSON||CSV|
|2001 runoff*||SHP, GeoJSON||CSV|
|2001 primary*||SHP, GeoJSON||CSV|
* Vote-by-mail ballots not included in precinct totals because no rule required it at the time.
Much respect due
While a bit of a pain to acquire and wrangle, none of this data would exist without the work of the public servants at the Los Angeles City Clerk’s office. Thanks to them.