Filename: state_g18_sov_data_by_g18_srprec.csv

File URL: http://statewidedatabase.org/pub/data/G18/state/state_g18_sov_data_by_g18_srprec.zip

Dataset: 2018 General Election Precinct Data

Description: Statewide Statement of Vote data file containing precinct level voting results for statewide races. 

Unit of analysis:  SR precincts are the original voting Precincts designated by the County Registrar of Voters.

Data source:	Statewide Database - University of California, Berkeley

Technical documentation:	http://statewidedatabase.org/d10/Creating%20CA%20Official%20Redistricting%20Database.pdf

Codebooks:	The 58 Statement of Vote data county codebooks can be accessed from the election's precinct data page,
http://statewidedatabase.org/d10/g18.html

County records unavailable at time of file creation:	none

Date last modified:  Tue,16/Jul/2019
Previous versions:	
  Tue,16/Jul/2019
  Tue,16/Jul/2019
  Tue,16/Jul/2019
  Tue,16/Jul/2019
07/16/19 

Note 1. How to use the SOV codebooks to determine the names of the candidates that were on the ballot in a specific precinct.

The SOV data file codebooks are county and election specific. The names of the candidates that ran in the Assembly, Senate, Congressional and Board of Equalization 
district based races vary by county for each election depending on which Assembly, Senate, Congressional and Board of Equalization districts are within the county.

The specific Assembly, Congressional, Senate and Board of Equalization districts that each precinct are in can be located in the SOV data file fields labeled 
'ADDIST,' 'CDDIST,' 'SDDIST' and 'BOEDIST.'

In order to determine the names of the candidates that were on a ballot this election in a given precinct, retrieve the district number from the SOV data table for that precinct record 
and then look up the candidate's name in the sov data codebook for that county.
 
