voters_matching

this is a variety of our core voters docid 3oen1vuistn6yqclc0u9u 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