daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where confirmed = 19696 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 3
- US 11
- Japan 2
- Timor-Leste 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-06-25 | Japan | Port Quarantine | 19696 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2022-06-24 | Japan | Port Quarantine | 19696 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2022-03-25 | US | Tennessee | Hamblen | 47063 | 19696 | 346 | 0 | 36.21990035 | -83.26586179 | 2022-03-26 04:20:23 | Hamblen, Tennessee, US | |
2022-03-24 | US | Tennessee | Hamblen | 47063 | 19696 | 346 | 0 | 36.21990035 | -83.26586179 | 2022-03-25 04:20:46 | Hamblen, Tennessee, US | |
2022-03-15 | US | Indiana | Kosciusko | 18085 | 19696 | 228 | 0 | 41.24521668 | -85.86312322 | 2022-03-16 04:20:50 | Kosciusko, Indiana, US | |
2022-03-12 | US | Texas | Starr | 48427 | 19696 | 360 | 0 | 26.56150059 | -98.73892358 | 2022-03-13 04:20:49 | Starr, Texas, US | |
2022-02-24 | US | Ohio | Marion | 39101 | 19696 | 264 | 0 | 40.58610662 | -83.15736305 | 2022-02-25 04:21:11 | Marion, Ohio, US | |
2022-01-31 | US | Kentucky | Bullitt | 21029 | 19696 | 174 | 0 | 37.97162523 | -85.68955617 | 2022-02-01 04:21:11 | Bullitt, Kentucky, US | |
2021-10-14 | Timor-Leste | 19696 | 119 | 0 | -8.874217 | 125.727539 | 2021-10-15 04:21:26 | Timor-Leste | ||||
2021-10-05 | US | California | Yolo | 6113 | 19696 | 245 | 0 | 38.68278902 | -121.90182879999999 | 2021-10-06 04:21:33 | Yolo, California, US | |
2021-09-30 | US | Pennsylvania | Centre | 42027 | 19696 | 235 | 0 | 40.92058903 | -77.82200624 | 2021-10-01 04:21:35 | Centre, Pennsylvania, US | |
2021-09-20 | US | Ohio | Trumbull | 39155 | 19696 | 542 | 0 | 41.31735028 | -80.76109643 | 2021-09-21 04:21:26 | Trumbull, Ohio, US | |
2021-04-15 | US | Florida | Bay | 12005 | 19696 | 377 | 0 | 30.26548745 | -85.62122584 | 2021-04-16 04:20:46 | Bay, Florida, US | |
2021-01-11 | US | Michigan | Ottawa | 26139 | 19696 | 297 | 0 | 19399 | 42.95996803 | -85.9969107 | 2021-01-12 05:22:15 | Ottawa, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;