TSA Throughput with Scraping html Tables

I saw one of the smartest people I e-know (the one and only @hrbrmstr) post TSA’s daily airline passenger traffic numbers circa March 01, 2020 and later, and the corresponding numbers for the same dates albeit in 2019. The data source is an html table, and since I haven’t scraped html tables in a while, I wanted to get rid of the cobwebs. Surprisingly easy but then the TSA data source-page is a very clean setup.

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.

Resident Population Change in Ohio

Now that the population change estimates are out, here is a quick peek at Ohio’s estimates. First up – the extent of gains and losses in our counties. No surprises here; Most of the Appalachian counties have seen population losses. Specifically, Appalachia lost 48,211 persons while the rest of the state gained 200,896 persons. The largest gains were in Franklin (146,768), Delaware (30,654), Warren (19,353), Hamilton (14,312) and Butler (14,243).

Monitoring the Hocking River

It is yet another rainy day but not really since the Hocking River that meanders through our town is under flood-watch. Things must be bad enough else why would the University cancel all classes for Monday. To whit: “A forecast for heavy rains and high winds have resulted in a flood warning for Athens County beginning this weekend into Monday. Based on current forecasts, specific areas on campus may be impacted by flooding Sunday evening into Monday morning.