The Kerpen Toolbelt: Data at Your Fingertips

Phil Kerpen has a list of Google Docs and links to make even the most robust data person cry for joy

Phil Kerpen is a longtime friend and ally in the fight against stupid Covid policies. You can find him online on Twitter @Kerpen. Phil graciously publishes some of the best and most accessible data out there.

Browse through the tabs at the bottom of choose File > download to get yourself a copy!

---

Here the links and docs he’s produced:

• Age-adjusted COVID-19 mortality by state
  https://docs.google.com/spreadsheets/d/13M1Lzxg_oddsxPMm3AgjxNjtplfFJj6xLpJ3scqVbC8/edit?usp=sharing

• State Hospital Chart - Staffed, Used, COVID - HHS Protect
  https://docs.google.com/spreadsheets/d/15YbHKtjdHgS8kpZ7JUwluYLcVATvP95ypoGqUBdgcUo/edit?usp=sharing

• Staffed Inpatient Beds by State
  https://docs.google.com/spreadsheets/d/14Fau56PAPljCRzu2JdzCaoqFJ2IYO_TJbXacxyGLHHo/edit?usp=sharing

• CDC State Vaccinated Population by Age
  https://docs.google.com/spreadsheets/d/1xAQOZO7oyu6TPtE6SufKAuSDaF_EFzp7WeL9GPx0Zi8/edit?usp=sharing

• CDC County Vax Leaderboard
  https://docs.google.com/spreadsheets/d/1ubhkBD-TVp1Om1RSiMFPJHNaviFcxvK-THHF-uJxCrU/edit?usp=sharing

• ED Visits, Pos %, Hosps by State
  https://docs.google.com/spreadsheets/d/15qjjoECAgKhXUO-DbU2dqS12PghCFWg2k-zbiK3Wq8Y/edit?usp=sharing

• DC COVID Tracker
  https://docs.google.com/spreadsheets/d/1wZxgZpsWVuxTYHAGi7Tl7DRqj0HSVVCM-u4XtmuPkxw/edit?usp=sharing

• CDC Pediatric Deaths by State
  https://docs.google.com/spreadsheets/d/1JR-yCDdav4KV1qmG-qb4t4CD_a1GOGXo95pfWcZfhWA/edit?usp=sharing

• Pediatric Flu vs COVID
  https://docs.google.com/spreadsheets/d/1j0GaLppce1gqwVERq1GWebTuowvOEu9wfK9Al8flKpQ/edit?usp=sharing

• Deaths by Single Year of Age
  https://docs.google.com/spreadsheets/d/14PKFZfW3fBt0MibfCZyNYpULNAwJ-L1k446q7Z4QDVs/edit?usp=sharing

• COVID age strat
  https://docs.google.com/spreadsheets/d/11FdtbKtPJSUNK4gRebs1KzdC-vCTh2ogiVETQRPj9qs/edit?usp=sharing

• RSV
  https://docs.google.com/spreadsheets/d/18rJ2jl-4poNbZtJJlteASdgr_PDU-a8xW1qdO9mwdgI/edit?usp=sharing

• CDC Flu Testing Archives Auto-Fill
  https://docs.google.com/spreadsheets/d/1JXUW_6CF4e04iAWyC_MU23SY6scEYUo4GKEXmQUhHbo/edit?usp=sharing

• Flu and COV Hosps
  https://docs.google.com/spreadsheets/d/1bcejvMzGyzh6ZQ2hIoV7QM-1GYrjRTktQQP5-jdXf3Q/edit?usp=sharing