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

16 rows where confirmed = 50485 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 2

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2954527 2954527 2022-12-20 US Texas Johnson 48251 50485 769 0   32.37877812 -97.36615819 2022-12-21 04:21:03 Johnson, Texas, US
3176929 3176929 2022-12-19 US Texas Johnson 48251 50485 769 0   32.37877812 -97.36615819 2022-12-20 04:21:04 Johnson, Texas, US
1631446 1631446 2022-12-18 US Texas Johnson 48251 50485 769 0   32.37877812 -97.36615819 2022-12-19 04:21:03 Johnson, Texas, US
506825 506825 2022-12-17 US Texas Johnson 48251 50485 769 0   32.37877812 -97.36615819 2022-12-18 04:21:03 Johnson, Texas, US
3327397 3327397 2022-12-16 US Texas Johnson 48251 50485 769 0   32.37877812 -97.36615819 2022-12-17 04:21:04 Johnson, Texas, US
545909 545909 2022-12-15 US Texas Johnson 48251 50485 769 0   32.37877812 -97.36615819 2022-12-16 04:21:01 Johnson, Texas, US
351437 351437 2022-12-14 US Texas Johnson 48251 50485 769 0   32.37877812 -97.36615819 2022-12-15 04:20:58 Johnson, Texas, US
673024 673024 2022-07-21 US Puerto Rico Bayamon 72021 50485 0 0   18.34946 -66.168435 2022-07-22 04:21:15 Bayamon, Puerto Rico, US
1766309 1766309 2022-06-20 US Tennessee Out of TN 80047 50485 270 0   36.55606529 0.0 2022-06-21 04:20:56 Out of TN, Tennessee, US
559717 559717 2022-06-16 US Guam   66 50485 370 0   13.4443 144.7937 2022-06-17 04:20:56 Guam, US
3869894 3869894 2022-04-05 US North Carolina New Hanover 37129 50485 385 0   34.25758282 -77.87075626 2022-04-06 04:20:49 New Hanover, North Carolina, US
449529 449529 2021-11-17 US New Hampshire Hillsborough 33011 50485 701 0   42.91537785 -71.7200253 2021-11-18 04:21:33 Hillsborough, New Hampshire, US
643648 643648 2021-09-07 US Minnesota Dakota 27037 50485 489 0   44.67172617 -93.06299363 2021-09-08 04:21:31 Dakota, Minnesota, US
628051 628051 2021-07-10 US New Jersey Morris 34027 50485 1241 0   40.86095313 -74.54553709999998 2021-07-11 04:21:43 Morris, New Jersey, US
1637909 1637909 2021-04-29 US Massachusetts Hampden 25013 50485 1204 0   42.13440424 -72.63235561 2021-04-30 04:21:03 Hampden, Massachusetts, US
241108 241108 2021-04-02 Colombia Narino     50485 1700 47977 808 1.2892 -77.3579 2021-04-03 04:20:44 Narino, Colombia

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]);