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

27 rows where confirmed = 19378 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 4

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2954363 2954363 2022-12-20 US Tennessee McMinn 47107 19378 282 0   35.42812616 -84.61520715 2022-12-21 04:21:03 McMinn, Tennessee, US
93423 93423 2022-07-23 US New York Wayne 36117 19378 186 0   43.15494365 -77.02976528 2022-07-24 04:20:47 Wayne, New York, US
3272761 3272761 2022-06-19 US Texas Victoria 48469 19378 413 0   28.79780988 -96.96813006 2022-06-20 04:21:01 Victoria, Texas, US
3628751 3628751 2022-03-13 US Georgia Dougherty 13095 19378 478 0   31.53328528 -84.21722377 2022-03-14 04:20:46 Dougherty, Georgia, US
951659 951659 2022-03-12 US Georgia Dougherty 13095 19378 478 0   31.53328528 -84.21722377 2022-03-13 04:20:49 Dougherty, Georgia, US
357120 357120 2022-03-11 US Georgia Dougherty 13095 19378 478 0   31.53328528 -84.21722377 2022-03-12 04:20:50 Dougherty, Georgia, US
289993 289993 2021-10-31 US Montana Flathead 30029 19378 171 0   48.29575866 -114.05205690000001 2021-11-01 04:22:01 Flathead, Montana, US
2722999 2722999 2021-10-30 US Montana Flathead 30029 19378 171 0   48.29575866 -114.05205690000001 2021-10-31 04:22:08 Flathead, Montana, US
569101 569101 2021-10-29 US Montana Flathead 30029 19378 171 0   48.29575866 -114.05205690000001 2021-10-30 04:22:03 Flathead, Montana, US
2044334 2044334 2021-10-18 US Arkansas Faulkner 5045 19378 220 0   35.14719007 -92.33717519 2021-10-19 04:20:54 Faulkner, Arkansas, US
1377687 1377687 2021-09-15 US Texas Potter 48375 19378 516 0   35.40133773 -101.893964 2021-09-16 04:22:19 Potter, Texas, US
3470088 3470088 2021-08-03 US Missouri Jasper 29097 19378 266 0   37.20351921 -94.34050458 2021-08-04 04:21:25 Jasper, Missouri, US
3661173 3661173 2021-07-11 US Maryland Howard 24027 19378 255 0   39.25305293 -76.93126208 2021-07-12 04:21:34 Howard, Maryland, US
2911068 2911068 2021-06-17 France Mayotte     19378 173 2964 16241 -12.8275 45.166244 2021-06-18 04:22:16 Mayotte, France
3030186 3030186 2021-06-16 France Mayotte     19378 173 2964 16241 -12.8275 45.166244 2021-06-17 04:22:36 Mayotte, France
2339292 2339292 2021-06-15 France Mayotte     19378 173 2964 16241 -12.8275 45.166244 2021-06-16 04:22:32 Mayotte, France
1563988 1563988 2021-06-14 France Mayotte     19378 173 2964 16241 -12.8275 45.166244 2021-06-15 04:22:22 Mayotte, France
2285533 2285533 2021-02-14 US Nebraska Sarpy 31153 19378 104 0 19274 41.11314181 -96.11156432 2021-02-15 05:24:49 Sarpy, Nebraska, US
2681082 2681082 2021-02-13 US Utah Bear River   19378 73 0 19305 41.52106798 -113.0832816 2021-02-14 05:23:43 Bear River, Utah, US
3978673 3978673 2021-02-10 Mexico Quintana Roo     19378 2305 0 17073 19.1817 -88.4791 2021-02-11 05:23:55 Quintana Roo, Mexico
14816 14816 2021-01-26 US Ohio Lorain 39093 19378 404 0 18974 41.29553751 -82.15083537 2021-01-27 05:23:41 Lorain, Ohio, US
1818946 1818946 2020-12-08 Peru Huanuco     19378 1003 0 18375 -9.421676 -76.040642 2020-12-09 05:28:01 Huanuco, Peru
2347582 2347582 2020-12-07 Peru Huanuco     19378 1001 0 18377 -9.421676 -76.040642 2020-12-08 05:27:42 Huanuco, Peru
764482 764482 2020-10-18 US New Jersey Union 34039 19378 1363 0 18015 40.65835409 -74.30680092 2020-10-19 04:24:16 Union, New Jersey, US
3801994 3801994 2020-10-05 Mexico Sinaloa     19378 3317 15405 656 25.1721 -107.4795 2020-10-06 04:23:33 Sinaloa, Mexico
3095578 3095578 2020-09-20 US New Jersey Middlesex 34023 19378 1425 0 17953 40.43629879 -74.41426991 2020-09-21 04:23:00 Middlesex, New Jersey, US
2156632 2156632 2020-07-14 US New Jersey Hudson 34017 19378 1487 0 17891 40.73766234 -74.07515667 2020-07-15 04:34:39 Hudson, New Jersey, US

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