Skip to content

Latest commit

 

History

History
96 lines (76 loc) · 4.46 KB

readme.md

File metadata and controls

96 lines (76 loc) · 4.46 KB

US Polling Places 2012-2020

This week we're honoring the legacy of Martin Luther King Jr. by exploring the US Polling Places.

The dataset comes from The Center for Public Integrity. You can read more about the data and how it was collected in their September 2020 article "National data release sheds light on past polling place changes". Thank you Kelsey E Gonzalez for the dataset suggestion back in 2020!

Note: Some states do not have data in this dataset. Several states (Colorado, Hawaii, Oregon, Washington and Utah) vote primarily by mail and have little or no data in this colletion, and others were not available for other reasons.

For states with data for multiple elections, how have polling location counts per county changed over time?

The Data

# Option 1: tidytuesdayR package 
## install.packages("tidytuesdayR")

tuesdata <- tidytuesdayR::tt_load('2024-01-16')
## OR
tuesdata <- tidytuesdayR::tt_load(2024, week = 3)

polling_places <- tuesdata$polling_places

# Option 2: Read directly from GitHub

polling_places <- readr::read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/main/data/2024/2024-01-16/polling_places.csv')

How to Participate

  • Explore the data, watching out for interesting relationships. We would like to emphasize that you should not draw conclusions about causation in the data. There are various moderating variables that affect all data, many of which might not have been captured in these datasets. As such, our suggestion is to use the data provided to practice your data tidying and plotting techniques, and to consider for yourself what nuances might underlie these relationships.
  • Create a visualization, a model, a shiny app, or some other piece of data-science-related output, using R or another programming language.
  • Share your output and the code used to generate it on social media with the #TidyTuesday hashtag.

Data Dictionary

polling_places.csv

variable class description
election_date date date of the election as YYYY-MM-DD
state character 2-letter abbreviation of the state
county_name character county name, if available
jurisdiction character jurisdiction, if available
jurisdiction_type character type of jurisdiction, if available; one of "county", "borough", "town", "municipality", "city", "parish", or "county_municipality"
precinct_id character unique ID of the precinct, if available
precinct_name character name of the precinct, if available
polling_place_id character unique ID of the polling place, if available
location_type character type of polling location, if available; one of "early_vote", "early_vote_site", "election_day", "polling_location", "polling_place", or "vote_center"
name character name of the polling place, if available
address character address of the polling place, if available
notes character optional notes about the polling place
source character source of the polling place data; one of "ORR", "VIP", "website", or "scraper"
source_date date date that the source was compiled
source_notes character optional notes about the source

Cleaning Script

library(tidyverse)
library(here)
library(fs)
library(gh)

working_dir <- here::here("data", "2024", "2024-01-16")

polling_places <- 
  # Get the list of states that have data.
  gh::gh("/repos/PublicI/us-polling-places/contents/data") |> 
  purrr::map_chr("name") |> 
  # For each state, get the list of CSV URLs.
  purrr::map(
    \(state) {
      gh::gh(
        glue::glue("/repos/PublicI/us-polling-places/contents/data/{state}/output")
      ) |> 
        purrr::map_chr("download_url")
    }
  ) |> 
  unlist() |> 
  readr::read_csv(
    col_types = readr::cols(.default = readr::col_character())
  ) |> 
  # Some rows are duplicated.
  dplyr::distinct() |> 
  dplyr::mutate(
    election_date = lubridate::ymd(election_date),
    source_date = lubridate::ymd(source_date)
  )

readr::write_csv(
  polling_places,
  fs::path(working_dir, "polling_places.csv")
)