daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where confirmed = 21916 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 8
- Russia 2
- Azerbaijan 1
- Haiti 1
- Netherlands 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-14 | US | West Virginia | Harrison | 54033 | 21916 | 259 | 0 | 39.2853852 | -80.37919577 | 2022-07-15 04:20:53 | Harrison, West Virginia, US | |
2022-04-11 | US | New Jersey | Cape May | 34009 | 21916 | 297 | 0 | 39.15008829 | -74.80170244 | 2022-04-12 04:20:49 | Cape May, New Jersey, US | |
2022-02-17 | US | Kentucky | Campbell | 21037 | 21916 | 148 | 0 | 38.94384345 | -84.37875208 | 2022-02-18 04:21:04 | Campbell, Kentucky, US | |
2022-01-12 | US | Arizona | Cochise | 4003 | 21916 | 483 | 0 | 31.87934684 | -109.7516088 | 2022-01-13 08:00:09 | Cochise, Arizona, US | |
2021-09-26 | Haiti | 21916 | 611 | 0 | 18.9712 | -72.2852 | 2021-09-27 04:21:16 | Haiti | ||||
2021-04-07 | Netherlands | Zeeland | 21916 | 224 | 0 | 21664 | 51.47936 | 3.861559 | 2021-04-08 04:21:13 | Zeeland, Netherlands | ||
2021-03-22 | US | Oregon | Washington | 41067 | 21916 | 221 | 0 | 45.55972701 | -123.0955257 | 2021-03-23 05:26:18 | Washington, Oregon, US | |
2021-01-24 | US | Louisiana | Caddo | 22017 | 21916 | 591 | 0 | 21325 | 32.57991587 | -93.88375652 | 2021-01-25 05:22:16 | Caddo, Louisiana, US |
2021-01-21 | US | Illinois | McHenry | 17111 | 21916 | 229 | 0 | 21687 | 42.32451172 | -88.45248227 | 2021-01-22 05:22:10 | McHenry, Illinois, US |
2021-01-20 | Russia | Kaliningrad Oblast | 21916 | 211 | 19727 | 1978 | 54.7293041 | 21.1489473 | 2021-01-21 05:22:01 | Kaliningrad Oblast, Russia | ||
2020-11-30 | Russia | Primorsky Krai | 21916 | 234 | 15508 | 6174 | 45.0819456 | 134.726645 | 2020-12-01 05:26:18 | Primorsky Krai, Russia | ||
2020-10-08 | US | New Jersey | Essex | 34013 | 21916 | 2128 | 0 | 19788 | 40.78681335 | -74.24657979 | 2020-10-09 04:23:59 | Essex, New Jersey, US |
2020-07-08 | Azerbaijan | 21916 | 274 | 13100 | 8542 | 40.1431 | 47.5769 | 2020-07-09 04:34:23 | Azerbaijan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;