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 |