daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where confirmed = 23606 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Tennessee | Hamblen | 47063 | 23606 | 382 | 0 | 36.21990035 | -83.26586179 | 2022-12-30 04:21:04 | Hamblen, Tennessee, US | |
2022-12-28 | US | Tennessee | Hamblen | 47063 | 23606 | 382 | 0 | 36.21990035 | -83.26586179 | 2022-12-29 04:21:01 | Hamblen, Tennessee, US | |
2022-12-27 | US | Tennessee | Hamblen | 47063 | 23606 | 382 | 0 | 36.21990035 | -83.26586179 | 2022-12-28 04:21:04 | Hamblen, Tennessee, US | |
2022-12-26 | US | Tennessee | Hamblen | 47063 | 23606 | 382 | 0 | 36.21990035 | -83.26586179 | 2022-12-27 04:21:07 | Hamblen, Tennessee, US | |
2022-12-25 | US | Tennessee | Hamblen | 47063 | 23606 | 382 | 0 | 36.21990035 | -83.26586179 | 2022-12-26 04:21:06 | Hamblen, Tennessee, US | |
2022-12-24 | US | Tennessee | Hamblen | 47063 | 23606 | 382 | 0 | 36.21990035 | -83.26586179 | 2022-12-25 04:21:04 | Hamblen, Tennessee, US | |
2022-11-20 | US | Kentucky | Pike | 21195 | 23606 | 355 | 0 | 37.47088263 | -82.39487445 | 2022-11-21 04:21:05 | Pike, Kentucky, US | |
2022-11-19 | US | Kentucky | Pike | 21195 | 23606 | 355 | 0 | 37.47088263 | -82.39487445 | 2022-11-20 04:21:08 | Pike, Kentucky, US | |
2022-11-18 | US | Kentucky | Pike | 21195 | 23606 | 355 | 0 | 37.47088263 | -82.39487445 | 2022-11-19 04:21:14 | Pike, Kentucky, US | |
2022-11-17 | US | Kentucky | Pike | 21195 | 23606 | 355 | 0 | 37.47088263 | -82.39487445 | 2022-11-18 04:21:15 | Pike, Kentucky, US | |
2022-11-16 | US | Kentucky | Pike | 21195 | 23606 | 355 | 0 | 37.47088263 | -82.39487445 | 2022-11-17 04:21:11 | Pike, Kentucky, US | |
2022-11-15 | US | Kentucky | Pike | 21195 | 23606 | 355 | 0 | 37.47088263 | -82.39487445 | 2022-11-16 04:21:09 | Pike, Kentucky, US | |
2022-11-14 | US | Kentucky | Pike | 21195 | 23606 | 355 | 0 | 37.47088263 | -82.39487445 | 2022-11-15 04:21:16 | Pike, Kentucky, US | |
2022-04-28 | US | Maine | Kennebec | 23011 | 23606 | 236 | 0 | 44.40759555 | -69.76738544 | 2022-04-29 04:20:59 | Kennebec, Maine, US | |
2022-03-10 | US | Georgia | Carroll | 13045 | 23606 | 431 | 0 | 33.58138199 | -85.07976677 | 2022-03-11 04:20:50 | Carroll, Georgia, US | |
2022-02-01 | US | Hawaii | Hawaii | 15001 | 23606 | 164 | 0 | 19.60121157 | -155.5210167 | 2022-02-02 04:21:09 | Hawaii, Hawaii, US | |
2022-01-10 | US | Idaho | Bonneville | 16019 | 23606 | 252 | 0 | 43.38713372 | -111.6161537 | 2022-01-11 04:22:01 | Bonneville, Idaho, US | |
2021-12-24 | Mexico | Chiapas | 23606 | 2296 | 0 | 16.7569 | -93.1292 | 2021-12-25 04:21:37 | Chiapas, Mexico | |||
2021-12-19 | US | Ohio | Portage | 39133 | 23606 | 355 | 0 | 41.16793482 | -81.19735782 | 2021-12-20 04:21:43 | Portage, Ohio, US | |
2021-10-19 | Sweden | Kronoberg | 23606 | 325 | 0 | 56.7183 | 14.4115 | 2021-10-20 04:21:00 | Kronoberg, Sweden | |||
2021-05-07 | Peru | Tacna | 23606 | 1599 | 0 | 22007 | -17.644160999999997 | -70.27756 | 2021-05-08 04:21:04 | Tacna, Peru | ||
2021-05-06 | Peru | Tacna | 23606 | 1595 | 0 | 22011 | -17.644160999999997 | -70.27756 | 2021-05-07 04:20:40 | Tacna, Peru | ||
2021-03-27 | US | Delaware | Sussex | 10005 | 23606 | 455 | 0 | 38.66143781 | -75.39031349 | 2021-03-28 05:28:10 | Sussex, Delaware, US | |
2021-01-26 | Russia | Astrakhan Oblast | 23606 | 470 | 14793 | 8343 | 47.1878186 | 47.608851 | 2021-01-27 05:23:41 | Astrakhan Oblast, Russia | ||
2021-01-06 | US | Florida | Pasco | 12101 | 23606 | 397 | 0 | 23209 | 28.30810945 | -82.40227529 | 2021-01-07 05:22:03 | Pasco, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;