johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where active = 8585 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2585761 | 2585761 | 2021-06-05 | Canada | Ontario | 540305 | 8844 | 525521 | 8585 | 51.2538 | -85.3232 | 2021-06-06 04:24:03 | Ontario, Canada | ||
2020869 | 2020869 | 2021-04-20 | Pakistan | Sindh | 274196 | 4559 | 261052 | 8585 | 26.009446 | 68.77680699999999 | 2021-04-21 04:21:14 | Sindh, Pakistan | ||
3003232 | 3003232 | 2021-04-06 | Guatemala | 197020 | 6903 | 181532 | 8585 | 15.7835 | -90.2308 | 2021-04-07 04:20:53 | Guatemala | |||
975063 | 975063 | 2021-02-06 | Pakistan | Punjab | 160580 | 4880 | 147115 | 8585 | 30.811346 | 72.13913199999998 | 2021-02-07 05:23:00 | Punjab, Pakistan | ||
1685885 | 1685885 | 2021-02-02 | US | Kentucky | Daviess | 21059 | 8730 | 145 | 0 | 8585 | 37.73028906 | -87.09019479999998 | 2021-02-03 05:22:52 | Daviess, Kentucky, US |
1136573 | 1136573 | 2021-01-01 | Afghanistan | 52513 | 2201 | 41727 | 8585 | 33.93911 | 67.709953 | 2021-01-02 05:22:33 | Afghanistan | |||
2123343 | 2123343 | 2020-12-20 | Ukraine | Poltava Oblast | 31577 | 665 | 22327 | 8585 | 49.5883 | 34.5514 | 2020-12-21 05:27:58 | Poltava Oblast, Ukraine | ||
1753063 | 1753063 | 2020-12-14 | US | Mississippi | Harrison | 28047 | 8709 | 124 | 0 | 8585 | 30.51359752 | -89.12467576 | 2020-12-15 05:26:38 | Harrison, Mississippi, US |
3190610 | 3190610 | 2020-11-22 | US | Colorado | Larimer | 8069 | 9724 | 86 | 0 | 8585 | 40.66671597 | -105.4625784 | 2020-11-23 05:25:26 | Larimer, Colorado, US |
274801 | 274801 | 2020-11-10 | US | Pennsylvania | Chester | 42029 | 8967 | 382 | 0 | 8585 | 39.97291773 | -75.74768357 | 2020-11-11 05:25:30 | Chester, Pennsylvania, US |
1121880 | 1121880 | 2020-09-17 | Spain | Galicia | 18487 | 698 | 9204 | 8585 | 42.5751 | -8.1339 | 2020-09-18 05:05:00 | Galicia, Spain | ||
345771 | 345771 | 2020-09-14 | US | Louisiana | Lafayette | 22055 | 8706 | 121 | 0 | 8585 | 30.2049055 | -92.06959876 | 2020-09-15 03:22:50 | Lafayette, Louisiana, US |
3922715 | 3922715 | 2020-08-09 | US | California | Ventura | 6111 | 8679 | 85 | 0 | 8585 | 34.44465746 | -119.0910613 | 2020-08-10 04:34:55 | Ventura, California, US |
2437022 | 2437022 | 2020-06-20 | US | Utah | Salt Lake | 49035 | 8687 | 102 | 0 | 8585 | 40.66616532 | -111.92160109999999 | 2020-06-21 04:33:19 | Salt Lake, Utah, US |
1691846 | 1691846 | 2020-06-19 | Ghana | 13203 | 70 | 4548 | 8585 | 7.9465 | -1.0232 | 2020-06-20 04:33:19 | Ghana |
Advanced export
JSON shape: default, array, newline-delimited
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]);