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=sharingState Hospital Chart - Staffed, Used, COVID - HHS Protect
https://docs.google.com/spreadsheets/d/15YbHKtjdHgS8kpZ7JUwluYLcVATvP95ypoGqUBdgcUo/edit?usp=sharingStaffed Inpatient Beds by State
https://docs.google.com/spreadsheets/d/14Fau56PAPljCRzu2JdzCaoqFJ2IYO_TJbXacxyGLHHo/edit?usp=sharingCDC State Vaccinated Population by Age
https://docs.google.com/spreadsheets/d/1xAQOZO7oyu6TPtE6SufKAuSDaF_EFzp7WeL9GPx0Zi8/edit?usp=sharingCDC County Vax Leaderboard
https://docs.google.com/spreadsheets/d/1ubhkBD-TVp1Om1RSiMFPJHNaviFcxvK-THHF-uJxCrU/edit?usp=sharingED Visits, Pos %, Hosps by State
https://docs.google.com/spreadsheets/d/15qjjoECAgKhXUO-DbU2dqS12PghCFWg2k-zbiK3Wq8Y/edit?usp=sharingDC COVID Tracker
https://docs.google.com/spreadsheets/d/1wZxgZpsWVuxTYHAGi7Tl7DRqj0HSVVCM-u4XtmuPkxw/edit?usp=sharingCDC Pediatric Deaths by State
https://docs.google.com/spreadsheets/d/1JR-yCDdav4KV1qmG-qb4t4CD_a1GOGXo95pfWcZfhWA/edit?usp=sharingPediatric Flu vs COVID
https://docs.google.com/spreadsheets/d/1j0GaLppce1gqwVERq1GWebTuowvOEu9wfK9Al8flKpQ/edit?usp=sharingDeaths by Single Year of Age
https://docs.google.com/spreadsheets/d/14PKFZfW3fBt0MibfCZyNYpULNAwJ-L1k446q7Z4QDVs/edit?usp=sharingCOVID age strat
https://docs.google.com/spreadsheets/d/11FdtbKtPJSUNK4gRebs1KzdC-vCTh2ogiVETQRPj9qs/edit?usp=sharingRSV
https://docs.google.com/spreadsheets/d/18rJ2jl-4poNbZtJJlteASdgr_PDU-a8xW1qdO9mwdgI/edit?usp=sharingCDC Flu Testing Archives Auto-Fill
https://docs.google.com/spreadsheets/d/1JXUW_6CF4e04iAWyC_MU23SY6scEYUo4GKEXmQUhHbo/edit?usp=sharingFlu and COV Hosps
https://docs.google.com/spreadsheets/d/1bcejvMzGyzh6ZQ2hIoV7QM-1GYrjRTktQQP5-jdXf3Q/edit?usp=sharing
Are these documents still being updated? The county vax leaderboard has no data.
Thanks for this treasure trove!