voters_modeling

this is a variety of our core voters docid 3oen1vuistn6yqclc0u9u table, optimized for data science use cases schema column description state state abbreviation voter id unique voter id state county fips state and county fips code, 5 digits dob date of birth formatted as date (yyyy mm dd) dob comes from voter registration data and commercial data 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 age current age as an integer reg date voter registration date formatted as date (yyyy mm dd) in situations where state or county updates reg date when a voter record is updated, reg date is calculated as 30 days prior to earliest recorded vote date years reg number of years since registration date gender female binary if voter is female gender male binary if voter is male eth aapi one hot encoded column based on voterfile ethnicity eth black one hot encoded column based on voterfile ethnicity eth latino one hot encoded column based on voterfile ethnicity eth native american one hot encoded column based on voterfile ethnicity eth other one hot encoded column based on voterfile ethnicity eth white one hot encoded column based on voterfile ethnicity eth voterfile binary flag if ethnicity is on the voterfile modeled race aapi indigo race model, score from 0 1 with the probability that a voter is aapi modeled race black indigo race model, score from 0 1 with the probability that a voter is black modeled race latino indigo race model, score from 0 1 with the probability that a voter is hispanic or latino/a modeled race native american indigo race model, score from 0 1 with the probability that a voter is native american modeled race white indigo race model, score from 0 1 with the probability that a voter is white party dem binary flag if voter is a registered democrat party rep binary flag if voter is a registered republican party voterfile binary flag if voter has party registration on the voterfile reg lat registration address latitude reg long registration address longitude commercial homeowner binary flag if voter is a homeowner based on commercial data commercial homeowner years number of years voter has owned their home based on commercial data commercial homepurchaseprice estimated home purhcase price based on commercial data commercial ispsa index of social position for small areas, mix of education and income data that estimates where a voter lies on a sacle from 0 to 9 on the socio economic ladder commercial gun owner binary if voter is a gun owner based on gun registrations and subscriptions to hunging / gun magazines commercial veteran binary if voter is a veteran based on commercial data fec donor binary flag if voter has donated to a federal candidate in the last four election cycles fec dem donor binary flag if candidate or organization who voter donated the largest amount to over the last four election cycles is a democrat fec rep donor binary flag if candidate or organization who voter donated the largest amount to over the last four election cycles is a republican fec total donation amount total dollar amount donated in federal races over the last four election cycles fec avg donation amount average donation dollar amount in federal races over the last four election cycles modeled turnout midterm primary indigo midterm primary turnout model, score from 0 1 with the probability that a voter will turn out to vote in a midterm primary election modeled turnout midterm general indigo midterm general turnout model, score from 0 1 with the probability that a voter will turn out to vote in a midterm general election modeled turnout presidential primary indigo presidential primary turnout model, score from 0 1 with the probability that a voter will turn out to vote in a presidential primary election modeled turnout presidential general indigo presidential general turnout model, score from 0 1 with the probability that a voter will turn out to vote in a presidential general election modeled dem partisanship indigo partisanship model, score from 0 1 with the probability that a voter indentifies as a democrat census tract 2020 census tract id, 13 digits formatted as a string census tract median income median income in census tract census tract median rent median rent in census tract census blockgroup 2020 census blockgroup id, 16 digits formatted as a string census blockgroup total pop total population in census blockgroup census blockgroup households number of households in census blockgroup census blockgroup n race aapi aapi population in census blockgroup census blockgroup n race black black population in census blockgroup census blockgroup n race hispanic hispanic or latino/a population in census blockgroup census blockgroup n race native american native american population in census blockgroup census blockgroup n race white white population in census blockgroup census blockgroup n age 0 17 age 0 17 population in census blockgroup census blockgroup n age 18 34 age 18 34 population in census blockgroup census blockgroup n age 35 49 age 35 49 population in census blockgroup census blockgroup n age 50 64 age 50 64 population in census blockgroup census blockgroup n age 65 plus age 65+ population in census blockgroup census blockgroup n edu less than high school population in census blockgroup with less than a high school education census blockgroup n edu high school population in census blockgroup with only a high school diploma census blockgroup n edu some college population in census blockgroup with some college education census blockgroup n edu college population in census blockgroup with a four year college degree census blockgroup n edu graduate degree population in census blockgroup with a graduate degree census blockgroup n income less than 25000 population in census blockgroup with a household income less than $25,000 census blockgroup n income 25000 49999 population in census blockgroup with a household income from $25,000 49,999 census blockgroup n income 50000 99999 population in census blockgroup with a household income from $50,000 99,999 census blockgroup n income 100000 150000 population in census blockgroup with a household income from $100,000 149,999 census blockgroup n income 150000 199999 population in census blockgroup with a household income from $159,000 199,999 census blockgroup n income 200000 over population in census blockgroup with a household income $200,000+ census blockgroup n sex male male population in a census blockgroup census blockgroup n sex female female population in a census blockgroup census blockgroup pct race aapi percent of population in census blockgroup that identifies as aapi census blockgroup pct race black percent of population in census blockgroup that identifies as black census blockgroup pct race hispanic percent of population in census blockgroup that identifies as hispanic or latino/a census blockgroup pct race native american percent of population in census blockgroup that identifies as native american census blockgroup pct race white percent of population in census blockgroup that identifies as white census blockgroup pct age 0 17 percent of population in census blockgroup that is 0 17 years old census blockgroup pct age 18 34 percent of population in census blockgroup that is 18 34 years old census blockgroup pct age 35 49 percent of population in census blockgroup that is 35 49 years old census blockgroup pct age 50 64 percent of population in census blockgroup that is 50 64 years old census blockgroup pct age 64 plus percent of population in census blockgroup that is 65+ years old census blockgroup pct edu less than hs percent of population in census blockgroup with less than a high school education census blockgroup pct edu high school percent of population in census blockgroup with only a high school diploma census blockgroup pct edu some college percent of population in census blockgroup with some college education census blockgroup pct edu college percent of population in census blockgroup with a four year college degree census blockgroup pct edu graduate degree percent of population in census blockgroup with a graduate degree census blockgroup pct income 0 25k percent of population in census blockgroup with a household income less than $25,000 census blockgroup pct income 25 50k percent of population in census blockgroup with a household income from $25,000 49,999 census blockgroup pct income 50 100k percent of population in census blockgroup with a household income from $50,000 99,999 census blockgroup pct income 100 150k percent of population in census blockgroup with a household income from $100,000 149,999 census blockgroup pct income 150 200k percent of population in census blockgroup with a household income from $159,000 199,999 census blockgroup pct income 200k plus percent of population in census blockgroup with a household income $200,000+ census blockgroup pct sex male percent of population in a census blockgroup that is male census blockgroup pct sex female percent of population in a census blockgroup that is female census blockgroup median rent median rent in census blockgroup g08 voted 1 if voted, 0 if registered to vote but didn't vote, null if wasn't registered to vote g08 reg 1 if registered to vote during this election, 0 if election occured before this voter registered g08 ballot type early 1 if voted early, 0 if didn't vote or voted with another method g08 ballot type absentee 1 if voted absenee, 0 if didn't vote or voted with another method g08 ballot type poll vote 1 if voted at the polls, 0 if didn't vote or voted with another method g08 ballot type unknown 1 if ballot ype is unknown, 0 if didn't vote or voted with a known method p08 party dem 1 if voted in the democratic primary, 0 if didn't vote or voted in a different party's primary p08 party rep 1 if voted in the republican primary, 0 if didn't vote or voted in a different party's primary