County

Unemployment in Ohio's Counties

It has been a while since I created a new post and although there have been a few in the pipeline, I cannot find the peace of mind to sit down and work through them to create something worthwhile. To assuage the feeling of falling behind, here is a quick post tracking unemployment rates in our counties. The data are from the Bureau of Labor Statistics. library(tidyverse) read_delim("https://www.bls.gov/web/metro/laucntycur14.txt", "|", escape_double = FALSE, col_names = FALSE, trim_ws = TRUE, skip = 6) -> laucnty colnames(laucnty) = c("laus_area_code", "statefips", "countyfips", "areaname", "period", "civ_laborforce", "employed", "unemployed", "urate") The July 2020 data are provisional estimates and should be discounted for good reason (some counties, Van Wert for example, shows implausible month-on-month swings from an unemployment rate of 13.

Tracking COVID-19 in Ohio's Counties

The New York Times is releasing a series of data files with cumulative counts of coronavirus cases in the United States, at the state and county level, over time. They are compiling this time series data from state and local governments and health departments in an attempt to provide a complete record of the ongoing outbreak. This is a map built with their data and updated (almost) daily to track progress in Ohio’s counties.

Initial Unemployment Insurance Claims Filed in Ohio's Counties

A few weeks ago I was bemoaning the fact that the state was not releasing the weekly county-level initial and continued unemployment insurance claims data in anything but an old pdf format. How old you ask? You know, the kind the Census Bureau gave up in the 1990s. Anyhow, turns out the PDFs could be scraped with relatively little pain; thank you {tabulizer}!! So here are the data, only the weeks in 2020 for now but the plan is to update this weekly through the crisis, and to go back over the years as well, at least until September/October 2017, the earliest data releases I can find.

Opioid Encounters in Ohio Counties

The opioid crisis is an issue in most parts of the country and Ohio is no exception, with some of the highest numbers of Fentanyl encounters reported by law enforcement. Although one could, I suppose, try to identify county-level deaths due to drug overdoses via CDC Wonder, this is a quick look at the data provided by the Ohio Hospital Association’s Overdose Data Sharing Program.