People

voters_matching

This is a variety of our core voters﻿ table, optimized for matching use cases.
Schema
Column
Description
voterbase_id
Unique voter ID
state_voter_id
State supplied voter ID, format differs from state to state
county_voter_id
County supplied voter ID, format differs by county and state
first_name
First name in uppercase with spaces, numbers, and special characters removed. Accented characters have been replaced with non-accented versions
middle_name
Middle name in uppercase with spaces, numbers, and special characters removed. Accented characters have been replaced with non-accented versions
middle_init
Middle initial in uppercase
last_name
Last name in uppercase with spaces, numbers, and special characters removed. Accented characters have been replaced with non-accented versions
dob
Date of birth formatted as date (YYYY-MM-DD). DOB comes from voter registration data and commercial data
myob
Month and year of birth formatted as 6 digit integer (YYYYMM). MYOB comes from voter registration data and commercial data. Some states truncate DOB to the first of the month making MYOB better for matching in those cases
yob
Month and year of birth formatted as 4 digit integer (YYYY). YOB comes from voter registration data and commercial data. Some states truncate DOB to the first of the year making YOB better for matching in those cases.
gender
Voter gender from voter registration data. M, F, or NULL
state
State abbreviation
state_fips
Registration state fips code, two digit fips as determined by the census formatted as a string
county
Registration address county name in uppercase
county_fips
Registration address county fips code, three digit fips as determined by the census formatted as a string
precinct
Registration precinct name
census_block_2020
Census block ID, 15 digits formatted as a string
street_number
Registration address street number
street_name
Registration address street name
unit_number
Registration address unit number
city
Registration city name
zip
Registration address zip5 as string
phone
Best phone number for voter, prioritizing cell phones over landlines, 9 digits formatted as a string
area_code
Area code of best phone number for voter, 3 digits formatted as a string
party
Party identification, based on voterfile and modeled data
party_3way
Party identification grouped into DEM, REP, and IND based on voterfile and modeled data
stleg_lower
Lower state legislative district, including state house or state assembly depending on the state. For numeric districts, district names are three digits and zero padded, i.e. 003, 021, 041B. For non-numeric district names, strings are uppercase.
stleg_upper
Upper state legislative district, state senate. For numeric districts, district names are three digits and zero padded, i.e. 003, 021, 041B. For non-numeric district names, strings are uppercase.
congressional
Congressional district, three digits zero padded, i.e. 002, 011, 024
﻿

Column	Description
voterbase_id	Unique voter ID
state_voter_id	State supplied voter ID, format differs from state to state
county_voter_id	County supplied voter ID, format differs by county and state
first_name	First name in uppercase with spaces, numbers, and special characters removed. Accented characters have been replaced with non-accented versions
middle_name	Middle name in uppercase with spaces, numbers, and special characters removed. Accented characters have been replaced with non-accented versions
middle_init	Middle initial in uppercase
last_name	Last name in uppercase with spaces, numbers, and special characters removed. Accented characters have been replaced with non-accented versions
dob	Date of birth formatted as date (YYYY-MM-DD). DOB comes from voter registration data and commercial data
myob	Month and year of birth formatted as 6 digit integer (YYYYMM). MYOB comes from voter registration data and commercial data. Some states truncate DOB to the first of the month making MYOB better for matching in those cases
yob	Month and year of birth formatted as 4 digit integer (YYYY). YOB comes from voter registration data and commercial data. Some states truncate DOB to the first of the year making YOB better for matching in those cases.
gender	Voter gender from voter registration data. M, F, or NULL
state	State abbreviation
state_fips	Registration state fips code, two digit fips as determined by the census formatted as a string
county	Registration address county name in uppercase
county_fips	Registration address county fips code, three digit fips as determined by the census formatted as a string
precinct	Registration precinct name
census_block_2020	Census block ID, 15 digits formatted as a string
street_number	Registration address street number
street_name	Registration address street name
unit_number	Registration address unit number
city	Registration city name
zip	Registration address zip5 as string
phone	Best phone number for voter, prioritizing cell phones over landlines, 9 digits formatted as a string
area_code	Area code of best phone number for voter, 3 digits formatted as a string
party	Party identification, based on voterfile and modeled data
party_3way	Party identification grouped into DEM, REP, and IND based on voterfile and modeled data
stleg_lower	Lower state legislative district, including state house or state assembly depending on the state. For numeric districts, district names are three digits and zero padded, i.e. 003, 021, 041B. For non-numeric district names, strings are uppercase.
stleg_upper	Upper state legislative district, state senate. For numeric districts, district names are three digits and zero padded, i.e. 003, 021, 041B. For non-numeric district names, strings are uppercase.
congressional	Congressional district, three digits zero padded, i.e. 002, 011, 024

voters

voters_modeling