johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

7 rows where confirmed = 48788 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 3

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
673523 673523 2022-07-21 US Texas Smith 48423 48788 974 0   32.37474036 -95.2717568 2022-07-22 04:21:15 Smith, Texas, US
3727799 3727799 2022-06-07 US Maryland Frederick 24021 48788 528 0   39.47296601 -77.39999394 2022-06-08 04:20:55 Frederick, Maryland, US
3883877 3883877 2021-04-11 Spain Canarias     48788 693 1537 46558 28.2916 -16.6291 2021-04-12 04:21:00 Canarias, Spain
2983545 2983545 2021-04-10 Spain Canarias     48788 693 1537 46558 28.2916 -16.6291 2021-04-11 04:20:56 Canarias, Spain
605977 605977 2021-04-09 Spain Canarias     48788 693 1537 46558 28.2916 -16.6291 2021-04-10 04:20:59 Canarias, Spain
376106 376106 2020-11-06 Ghana       48788 320 47521 947 7.9465 -1.0232 2020-11-07 05:24:52 Ghana
892044 892044 2020-11-05 Ghana       48788 320 47521 947 7.9465 -1.0232 2020-11-06 05:24:55 Ghana

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);