daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 36079 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- US 20
- Guyana 2
- Mauritania 1
- Netherlands 1
- Russia 1
- Ukraine 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-04-21 | US | Florida | Charlotte | 12015 | 36079 | 806 | 0 | 26.90131002 | -81.92949121 | 2022-04-22 04:20:45 | Charlotte, Florida, US | |
2022-04-20 | US | Florida | Charlotte | 12015 | 36079 | 806 | 0 | 26.90131002 | -81.92949121 | 2022-04-21 04:20:46 | Charlotte, Florida, US | |
2022-04-19 | US | Florida | Charlotte | 12015 | 36079 | 806 | 0 | 26.90131002 | -81.92949121 | 2022-04-20 04:20:45 | Charlotte, Florida, US | |
2022-04-18 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-19 04:21:00 | Charlotte, Florida, US | |
2022-04-17 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-18 04:21:12 | Charlotte, Florida, US | |
2022-04-16 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-17 04:20:59 | Charlotte, Florida, US | |
2022-04-15 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-16 04:20:48 | Charlotte, Florida, US | |
2022-04-14 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-15 04:20:57 | Charlotte, Florida, US | |
2022-04-13 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-13 23:21:06 | Charlotte, Florida, US | |
2022-04-12 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-13 04:21:03 | Charlotte, Florida, US | |
2022-04-11 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-12 04:20:49 | Charlotte, Florida, US | |
2022-04-10 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-11 04:21:02 | Charlotte, Florida, US | |
2022-04-09 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-10 04:20:52 | Charlotte, Florida, US | |
2022-04-08 | US | Florida | Charlotte | 12015 | 36079 | 803 | 0 | 26.90131002 | -81.92949121 | 2022-04-09 04:20:42 | Charlotte, Florida, US | |
2022-02-28 | US | Minnesota | Wright | 27171 | 36079 | 299 | 0 | 45.17297924 | -93.96234781 | 2022-03-01 04:21:09 | Wright, Minnesota, US | |
2022-01-26 | US | Georgia | Houston | 13153 | 36079 | 436 | 0 | 32.45802497 | -83.66879087 | 2022-01-27 04:21:19 | Houston, Georgia, US | |
2021-12-23 | US | California | Kings | 6031 | 36079 | 376 | 0 | 36.07409056 | -119.8159973 | 2021-12-24 04:21:34 | Kings, California, US | |
2021-11-07 | Guyana | 36079 | 941 | 0 | 4.860416000000002 | -58.93018000000001 | 2021-11-08 04:21:43 | Guyana | ||||
2021-11-06 | Guyana | 36079 | 941 | 0 | 4.860416000000002 | -58.93018000000001 | 2021-11-07 04:21:53 | Guyana | ||||
2021-10-23 | Netherlands | Zeeland | 36079 | 260 | 0 | 51.47936 | 3.8615589999999997 | 2021-10-24 04:21:22 | Zeeland, Netherlands | |||
2021-10-01 | Mauritania | 36079 | 776 | 0 | 21.0079 | -10.9408 | 2021-10-02 04:21:25 | Mauritania | ||||
2021-09-06 | Russia | Khakassia Republic | 36079 | 990 | 0 | 53.72258845 | 91.44293627 | 2021-09-07 04:21:35 | Khakassia Republic, Russia | |||
2021-06-21 | US | Pennsylvania | Northampton | 42095 | 36079 | 716 | 0 | 40.75182733 | -75.30471829 | 2021-06-22 04:21:34 | Northampton, Pennsylvania, US | |
2021-03-19 | US | California | San Francisco | 6075 | 36079 | 461 | 0 | 37.75215114 | -122.4385672 | 2021-03-20 05:25:46 | San Francisco, California, US | |
2020-12-31 | Ukraine | Poltava Oblast | 36079 | 744 | 28021 | 7314 | 49.5883 | 34.5514 | 2021-01-01 05:23:07 | Poltava Oblast, Ukraine | ||
2020-12-27 | US | Wisconsin | Waukesha | 55133 | 36079 | 351 | 0 | 35728 | 43.01833055 | -88.30431188 | 2020-12-28 05:22:06 | Waukesha, Wisconsin, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;