Deploys a Datasette instance with data from the following sources:
The Datasette instance lives at https://covid-19.datasettes.com/ and is updated hourly using a scheduled GitHub Action.
More about this project on my blog: COVID-19 numbers in Datasette.
This repository uses the deployment pattern described in Deploying a data API using GitHub Actions and Cloud Run.
Please do not use this tool to share information about COVID-19 without making absolutely sure you understand how the data is structured and sourced.
Recommended reading:
The database is partly built from the daily report CSV files in the Johns Hopkins CSSE csse_covid_19_data
folder - be sure to consult their README for documentation of the fields.
They are actively making changes to how they report data. You should follow their issues closely for updates - for example this issue about switching from reporting USA data at the county to the state level.
The build script for the database makes one alteration to their data: it attempts to fill any missing latitude
and longitude
columns with values from similar rows.
If you are going to make use of those columns, make sure you understand how that backfill mechanism works in case it affects your calculations in some way.
The New York Times has a comprehensive README describing how their data is sourced. You should read it! They announced their data in We’re Sharing Coronavirus Case Data for Every U.S. County.
They are using the data for their Coronavirus in the U.S.: Latest Map and Case Count article.
The Los Angeles Time comprehensive README describes the data in the latimes_agency_totals, latimes_county_totals, latimes_place_totals and latimes_state_totals tables.
See To aid coronavirus fight, The Times releases database of California cases for background on the release of this data.
The data is used for their Tracking coronavirus in California page, which is constantly updated.
The Economist publish the data behind their ongoing interactive Tracking covid-19 excess deaths across countries. Their README describes the data sources they use for individual countries in detail.
This data is imported into the economist_excess_deaths and economist_historical_deaths tables, with one alteration: a cadence
column is added showing if each row is being collected on either a weekly
or monthly
basis.
Two additional tables contain population data from the US Census.
This repository includes CSV data for both of these tables.
The latest_ny_times_counties_with_populations view uses this data to calculate cases and deaths per million for US counties, based on the latest county figures from the New York Times.
admin2
, fips
, active
and combined_key
. These are not present in older CSV files. #4.country_or_region
set to Italy
(and province_or_state
set to null
). Larger countries such as the United States have multiple rows for each day divided into separate province_or_state
values - example.Santa Clara, CA
in some records and Santa Clara County, CA
in others - example.province_or_state
column - example.county
equal to "New York City" and an empty fips
column. Thus total cases represented in latest_ny_times_counties_with_populations are lower than total cases represented in ny_times_us_states by at least the number of cases in New York City.