Filename:	state_g14_mailballot_by_g14_rrprec.dbf, state_g14_mailballot_by_g14_rrprec.csv

File URL:	http://statewidedatabase.org/pub/data/G14/state/state_g14_mailballot_by_g14_rrprec.zip

Dataset:	2014 General Election Precinct Data

Description:	This file contains statewide registration data for registered voters that voted by mail ballot.  

Unit of analysis: RR precincts are derived from consolidated registration precincts and are a geographic unit constructed for statistical merging purposes by the Statewide Database. 

Data source:	Statewide Database - University of California, Berkeley

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

Codebook:	http://statewidedatabase.org/info/metadata/SOR_codebook.html

Date last modified:  Wed,21/Oct/2020

Previous versions:	Mon, 22 Jun 2015; Fri, 01 May 2015
	Tue, 25 Sep 2018

County records unavailable at time of file creation:	none

Errata 1: Counties who reported all of their VBM voters in the absentees file.

003 - Alpine has no mail ballot voters reported
015 - Del Norte has no mail ballot voters reported 
017 - El Dorado has no mail ballot voters reported 
021 - Glenn has no mail ballot voters reported 
025 - Imperial has no mail ballot voters reported 
031 - Kings has no mail ballot voters reported 
035 - Lassen has no mail ballot voters reported 
037 - Los Angeles has no mail ballot voters reported 
041 - Marin has no mail ballot voters reported 
045 - Mendocino has no mail ballot voters reported 
047 - Merced has no mail ballot voters reported 
049 - Modoc has no mail ballot voters reported 
053 - Monterey has no mail ballot voters reported 
055 - Napa has no mail ballot voters reported 
057 - Nevada has no mail ballot voters reported 
071 - San Bernardino has no mail ballot voters reported 
073 - San Diego has no mail ballot voters reported 
079 - San Luis Obispo has no mail ballot voters reported 
091 - Sierra has no mail ballot voters reported 
093 - Siskiyou has no mail ballot voters reported 
103 - Tehama has no mail ballot voters reported 
105 - Trinity has no mail ballot voters reported 
113 - Yolo has no mail ballot voters reported 

Errata 2:
	
005 - Amador has a record of only 31 mail ballot voters. The remainder of the VBM voters are in the absentees file.
089 - Shasta has a record of only 1 mail ballot voter. The remainder of the VBM voters are in the absentees file.

Errata 3:

Tue, 25 Sep 2018, records in the file were updated for the following counties: c077 - San Joaquin and c083 - Santa Barbara.

The current, Tue, 25 Sep 2018 statewide version of this file has 10 more records than the 2015 version. Total voters who cast ballots is the same in both files. 

There is 1 additional rr precinct in c077 - San Joaquin file & 8 additional rr precincts in the c083 - Santa Barbara file.

The 2018 statewide version of c077 - San Joaquin file has 1,354 total records while the 2015 version has 1,353 total records.  The 2018 statewide version of the file has rr precinct, "0092430B" with totreg_r=6 that is not present in the 2015 version of the file. In the 2015 version, rrprec "0092430A" has a totreg_r=156 and in the 2018 version rrprec "0092430A" also has a totreg_r=150. 

The 2018 statewide version of c083 - Santa Barbara file has 236 total records while the 2015 version has 228 total records. The 2018 statewide version of the file has 11 rr precincts that are not present in the 2015 version of the file and that contain a total of 435 mail ballot voters.

rrprec		totreg_r

30-3711		6


30-3712		13


30-3714		44


30-3716		55


30-3718		21


30-3722		1


30-3724		1


30-3726		13


40-4512		68


40-4514		122


40-4516		91


There are 3 rr precincts in the 2015 version the are not in the 2018 version that contain the 435 mail ballot voters that were re-allocated to the above precincts in the 2018 version of the file:

rrprec		totreg_r

30-371	139


30-372	15


40-451	281






