.libPaths('R:/Project/UWED/html/_site/site_libs/')
library(tools)

knitr::opts_chunk$set(warning = FALSE, message = FALSE)

# db connection
# source("../code/dbconnect.R")
# U <- uwed <- connectdb(dbname = "uwed", host = "doyenne.csde.washington.edu", user = "uwed_user", password = Sys.getenv("uwed_user_pgpassword"))

Citizen Voting Age Population by Year, Election, and Race/Ethnicity

Precinct: CVAP_by_Precinct_Race_2010-2025 Legislative District: CVAP_by_LD_Race_2010-2025 County: CVAP_by_County_Race_2020-2025

These data set contains racial group count and proportion estimates by geographic level for each year listed in Washington State. For precincts, we use census data on tract-level (2009-2012) or block group-level (all other years) citizen voting age population (CVAP) by race and ethnicity to estimate the same value at a precinct level. Legislative Districts and counties are reported by the Census.

We do the aggregation from tracts or block groups to precincts by using an area weighting factor derived by intersecting precinct polygons (that may vary by year) and Census unit polygons. For more information on methodology, please visit technical documentation.

Registrants by Year and Race/Ethnicity

Precinct: Registrant_Population_by_Precinct_Race_Year Legislative District: Registrant_Population_by_LD_Race_Year County: Registrant_Population_by_County_Race_Year

Voter registration data is geolocated by address and then race is imputed using Bayesian Improved Surname Geocoding. This individual-level data is then aggregated to precincts to create demographic estimates of the precinct-level registered population by race for years 2007-2025.

Voters by Year, Election, and Race/Ethnicity

Precinct: Voter_Population_by_Precinct_Race Legislative District: Voter_Population_by_LD_Race County: Voter_Population_by_County_Race

Similar to registrant data, voter data is geolocated by address and then race is imputed using Bayesian Improved Surname Geocoding. This individual-level data is then aggregated to precincts to create demographic estimates of the precinct-level voting population by race for years 2020-2025 for each election. A person is considered a voter in a given election if their ballot is of Accepted status.

Language Minority Population by Year

County: language_minority_groups.zip

This dataset contains population counts and proportions for each language minority group in each county in Washington State, and designations of which counties are required to provide language assistance during elections for certain language minority groups who are unable to speak or understand English adequately enough to participate in the electoral process. The dataset covers all 39 counties in Washington State for the years 2011, 2016, and 2021.

There are two data files:

sec203_counties_only.csv provides details on the counties required to provide language assistance.

all_counties.csv provides language minority population data for all counties in Washington State.