daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
362 rows where confirmed = 2357 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Iowa | Palo Alto | 19147 | 2357 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-30 04:21:04 | Palo Alto, Iowa, US | |
2022-12-28 | US | Iowa | Palo Alto | 19147 | 2357 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-29 04:21:01 | Palo Alto, Iowa, US | |
2022-12-16 | US | Arkansas | Prairie | 5117 | 2357 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-17 04:21:04 | Prairie, Arkansas, US | |
2022-12-15 | US | Arkansas | Prairie | 5117 | 2357 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-16 04:21:01 | Prairie, Arkansas, US | |
2022-12-06 | US | Kansas | Ellsworth | 20053 | 2357 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-12-07 04:20:58 | Ellsworth, Kansas, US | |
2022-12-05 | US | Kansas | Ellsworth | 20053 | 2357 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-12-06 04:21:03 | Ellsworth, Kansas, US | |
2022-12-04 | US | Kansas | Ellsworth | 20053 | 2357 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-12-05 04:20:58 | Ellsworth, Kansas, US | |
2022-12-03 | US | Kansas | Ellsworth | 20053 | 2357 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-12-04 04:20:56 | Ellsworth, Kansas, US | |
2022-12-02 | US | Kansas | Ellsworth | 20053 | 2357 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-12-03 04:21:02 | Ellsworth, Kansas, US | |
2022-12-01 | US | Kansas | Ellsworth | 20053 | 2357 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-12-02 04:21:07 | Ellsworth, Kansas, US | |
2022-11-30 | US | Kansas | Ellsworth | 20053 | 2357 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-12-01 04:21:03 | Ellsworth, Kansas, US | |
2022-11-21 | China | Guangxi | 2357 | 2 | 0 | 23.8298 | 108.7881 | 2022-11-22 04:20:47 | Guangxi, China | |||
2022-11-20 | China | Guangxi | 2357 | 2 | 0 | 23.8298 | 108.7881 | 2022-11-21 04:21:05 | Guangxi, China | |||
2022-11-19 | China | Guangxi | 2357 | 2 | 0 | 23.8298 | 108.7881 | 2022-11-20 04:21:08 | Guangxi, China | |||
2022-11-15 | US | Texas | Gaines | 48165 | 2357 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-11-16 04:21:09 | Gaines, Texas, US | |
2022-11-15 | US | Idaho | Fremont | 16043 | 2357 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-16 04:21:09 | Fremont, Idaho, US | |
2022-11-14 | US | Texas | Gaines | 48165 | 2357 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-11-15 04:21:16 | Gaines, Texas, US | |
2022-11-14 | US | Idaho | Fremont | 16043 | 2357 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-15 04:21:16 | Fremont, Idaho, US | |
2022-11-13 | US | Idaho | Fremont | 16043 | 2357 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-14 04:21:09 | Fremont, Idaho, US | |
2022-11-12 | US | Idaho | Fremont | 16043 | 2357 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-13 04:21:14 | Fremont, Idaho, US | |
2022-11-11 | US | Idaho | Fremont | 16043 | 2357 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-12 04:20:41 | Fremont, Idaho, US | |
2022-11-10 | US | Idaho | Fremont | 16043 | 2357 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-11 04:21:22 | Fremont, Idaho, US | |
2022-11-10 | US | Colorado | Lincoln | 8073 | 2357 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-11-11 04:21:22 | Lincoln, Colorado, US | |
2022-11-09 | US | Idaho | Fremont | 16043 | 2357 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-10 04:21:16 | Fremont, Idaho, US | |
2022-11-09 | US | Colorado | Lincoln | 8073 | 2357 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-11-10 04:21:16 | Lincoln, Colorado, US | |
2022-11-08 | US | Illinois | Schuyler | 17169 | 2357 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-11-09 04:21:22 | Schuyler, Illinois, US | |
2022-11-07 | US | Illinois | Schuyler | 17169 | 2357 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-11-08 04:21:21 | Schuyler, Illinois, US | |
2022-10-06 | US | Montana | Sanders | 30089 | 2357 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-10-07 04:23:08 | Sanders, Montana, US | |
2022-10-05 | US | Montana | Sanders | 30089 | 2357 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-10-06 04:21:22 | Sanders, Montana, US | |
2022-10-04 | US | Montana | Sanders | 30089 | 2357 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-10-05 04:23:06 | Sanders, Montana, US | |
2022-10-03 | US | Montana | Sanders | 30089 | 2357 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-10-04 04:22:55 | Sanders, Montana, US | |
2022-10-02 | US | Montana | Sanders | 30089 | 2357 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-10-03 04:23:11 | Sanders, Montana, US | |
2022-10-01 | US | Montana | Sanders | 30089 | 2357 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-10-02 04:21:23 | Sanders, Montana, US | |
2022-09-30 | US | Montana | Sanders | 30089 | 2357 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-10-01 04:23:01 | Sanders, Montana, US | |
2022-09-20 | US | Georgia | Seminole | 13253 | 2357 | 33 | 0 | 30.93464824 | -84.86823924 | 2022-09-21 04:23:22 | Seminole, Georgia, US | |
2022-09-19 | US | Georgia | Seminole | 13253 | 2357 | 33 | 0 | 30.93464824 | -84.86823924 | 2022-09-20 04:22:48 | Seminole, Georgia, US | |
2022-09-18 | US | Texas | Clay | 48077 | 2357 | 38 | 0 | 33.78686685 | -98.20771198 | 2022-09-19 04:21:49 | Clay, Texas, US | |
2022-09-18 | US | Georgia | Seminole | 13253 | 2357 | 33 | 0 | 30.93464824 | -84.86823924 | 2022-09-19 04:21:49 | Seminole, Georgia, US | |
2022-09-17 | US | Texas | Clay | 48077 | 2357 | 38 | 0 | 33.78686685 | -98.20771198 | 2022-09-18 04:22:50 | Clay, Texas, US | |
2022-09-17 | US | Georgia | Seminole | 13253 | 2357 | 33 | 0 | 30.93464824 | -84.86823924 | 2022-09-18 04:22:50 | Seminole, Georgia, US | |
2022-09-16 | US | Texas | Clay | 48077 | 2357 | 38 | 0 | 33.78686685 | -98.20771198 | 2022-09-17 04:20:19 | Clay, Texas, US | |
2022-09-16 | US | Georgia | Seminole | 13253 | 2357 | 33 | 0 | 30.93464824 | -84.86823924 | 2022-09-17 04:20:19 | Seminole, Georgia, US | |
2022-09-15 | US | Georgia | Seminole | 13253 | 2357 | 33 | 0 | 30.93464824 | -84.86823924 | 2022-09-16 04:21:19 | Seminole, Georgia, US | |
2022-09-14 | US | Georgia | Seminole | 13253 | 2357 | 33 | 0 | 30.93464824 | -84.86823924 | 2022-09-15 04:21:02 | Seminole, Georgia, US | |
2022-09-04 | US | Virginia | Fairfax City | 51600 | 2357 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-09-05 04:21:01 | Fairfax City, Virginia, US | |
2022-09-03 | US | Virginia | Fairfax City | 51600 | 2357 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-09-04 04:21:22 | Fairfax City, Virginia, US | |
2022-09-02 | US | Virginia | Fairfax City | 51600 | 2357 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-09-03 04:21:04 | Fairfax City, Virginia, US | |
2022-08-25 | US | West Virginia | Gilmer | 54021 | 2357 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-26 04:21:02 | Gilmer, West Virginia, US | |
2022-08-18 | US | Missouri | Gentry | 29075 | 2357 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-08-19 04:20:54 | Gentry, Missouri, US | |
2022-08-17 | US | Missouri | Gentry | 29075 | 2357 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-08-18 04:21:11 | Gentry, Missouri, US | |
2022-08-16 | US | Missouri | Gentry | 29075 | 2357 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-08-17 04:20:59 | Gentry, Missouri, US | |
2022-08-16 | US | Indiana | Martin | 18101 | 2357 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-08-17 04:20:59 | Martin, Indiana, US | |
2022-08-15 | US | Missouri | Gentry | 29075 | 2357 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-08-16 04:20:58 | Gentry, Missouri, US | |
2022-08-15 | US | Indiana | Martin | 18101 | 2357 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-08-16 04:20:58 | Martin, Indiana, US | |
2022-08-14 | US | Missouri | Gentry | 29075 | 2357 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-08-15 04:20:59 | Gentry, Missouri, US | |
2022-08-13 | US | Missouri | Gentry | 29075 | 2357 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-08-14 04:20:55 | Gentry, Missouri, US | |
2022-08-12 | US | Missouri | Gentry | 29075 | 2357 | 32 | 0 | 40.21097916 | -94.40944419 | 2022-08-13 04:20:52 | Gentry, Missouri, US | |
2022-08-11 | US | Missouri | Iron | 29093 | 2357 | 46 | 0 | 37.55487945 | -90.7735296 | 2022-08-12 04:20:54 | Iron, Missouri, US | |
2022-08-10 | US | Missouri | Iron | 29093 | 2357 | 46 | 0 | 37.55487945 | -90.7735296 | 2022-08-11 04:20:49 | Iron, Missouri, US | |
2022-08-09 | US | Missouri | Iron | 29093 | 2357 | 46 | 0 | 37.55487945 | -90.7735296 | 2022-08-10 04:20:57 | Iron, Missouri, US | |
2022-08-08 | US | Missouri | Iron | 29093 | 2357 | 46 | 0 | 37.55487945 | -90.7735296 | 2022-08-09 04:20:34 | Iron, Missouri, US | |
2022-08-07 | US | Missouri | Iron | 29093 | 2357 | 46 | 0 | 37.55487945 | -90.7735296 | 2022-08-08 04:21:08 | Iron, Missouri, US | |
2022-08-06 | US | Missouri | Iron | 29093 | 2357 | 46 | 0 | 37.55487945 | -90.7735296 | 2022-08-07 04:20:54 | Iron, Missouri, US | |
2022-08-05 | US | Missouri | Iron | 29093 | 2357 | 46 | 0 | 37.55487945 | -90.7735296 | 2022-08-06 04:20:56 | Iron, Missouri, US | |
2022-07-24 | US | Indiana | Switzerland | 18155 | 2357 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-07-25 04:20:51 | Switzerland, Indiana, US | |
2022-07-23 | US | Indiana | Switzerland | 18155 | 2357 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-07-24 04:20:47 | Switzerland, Indiana, US | |
2022-07-22 | US | Indiana | Switzerland | 18155 | 2357 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-07-23 04:20:53 | Switzerland, Indiana, US | |
2022-07-21 | US | Virginia | Northumberland | 51133 | 2357 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-07-22 04:21:15 | Northumberland, Virginia, US | |
2022-07-14 | US | Idaho | Owyhee | 16073 | 2357 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-07-15 04:20:53 | Owyhee, Idaho, US | |
2022-07-13 | US | Idaho | Owyhee | 16073 | 2357 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-07-14 04:20:57 | Owyhee, Idaho, US | |
2022-07-07 | US | Tennessee | Clay | 47027 | 2357 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-07-08 04:20:56 | Clay, Tennessee, US | |
2022-06-30 | US | Arkansas | Scott | 5127 | 2357 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-07-01 04:21:10 | Scott, Arkansas, US | |
2022-06-27 | US | West Virginia | Webster | 54101 | 2357 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-06-28 04:20:58 | Webster, West Virginia, US | |
2022-06-21 | US | Idaho | Clearwater | 16035 | 2357 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-22 04:20:54 | Clearwater, Idaho, US | |
2022-06-20 | US | Idaho | Clearwater | 16035 | 2357 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-21 04:20:56 | Clearwater, Idaho, US | |
2022-06-19 | US | Idaho | Clearwater | 16035 | 2357 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-20 04:21:01 | Clearwater, Idaho, US | |
2022-06-18 | US | Idaho | Clearwater | 16035 | 2357 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-19 04:20:51 | Clearwater, Idaho, US | |
2022-06-17 | US | Idaho | Clearwater | 16035 | 2357 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-18 04:21:10 | Clearwater, Idaho, US | |
2022-06-16 | US | Virginia | Essex | 51057 | 2357 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-06-17 04:20:56 | Essex, Virginia, US | |
2022-06-13 | China | Sichuan | 2357 | 3 | 0 | 30.6171 | 102.7103 | 2022-06-14 04:20:52 | Sichuan, China | |||
2022-06-12 | China | Sichuan | 2357 | 3 | 0 | 30.6171 | 102.7103 | 2022-06-13 04:21:14 | Sichuan, China | |||
2022-06-07 | US | Tennessee | Perry | 47135 | 2357 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-06-08 04:20:55 | Perry, Tennessee, US | |
2022-06-05 | US | Minnesota | Rock | 27133 | 2357 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-06-06 04:20:57 | Rock, Minnesota, US | |
2022-06-04 | US | Minnesota | Rock | 27133 | 2357 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-06-05 04:20:55 | Rock, Minnesota, US | |
2022-06-03 | US | Minnesota | Rock | 27133 | 2357 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-06-04 04:20:58 | Rock, Minnesota, US | |
2022-05-19 | US | West Virginia | Clay | 54015 | 2357 | 41 | 0 | 38.46231092 | -81.07652217 | 2022-05-20 04:20:57 | Clay, West Virginia, US | |
2022-05-19 | US | Montana | Dawson | 30021 | 2357 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-05-20 04:20:57 | Dawson, Montana, US | |
2022-05-18 | US | Montana | Dawson | 30021 | 2357 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-05-19 04:20:54 | Dawson, Montana, US | |
2022-05-17 | US | Montana | Dawson | 30021 | 2357 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-05-18 04:20:50 | Dawson, Montana, US | |
2022-05-16 | US | Montana | Dawson | 30021 | 2357 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-05-17 04:20:59 | Dawson, Montana, US | |
2022-05-15 | US | Montana | Dawson | 30021 | 2357 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-05-16 04:20:47 | Dawson, Montana, US | |
2022-05-14 | US | Montana | Dawson | 30021 | 2357 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-05-15 04:20:53 | Dawson, Montana, US | |
2022-05-13 | US | Montana | Dawson | 30021 | 2357 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-05-14 04:20:48 | Dawson, Montana, US | |
2022-05-10 | US | Georgia | Evans | 13109 | 2357 | 65 | 0 | 32.15328841 | -81.8870105 | 2022-05-11 04:20:48 | Evans, Georgia, US | |
2022-05-09 | US | Wyoming | Washakie | 56043 | 2357 | 44 | 0 | 43.90451606 | -107.680187 | 2022-05-10 04:20:50 | Washakie, Wyoming, US | |
2022-05-09 | US | Georgia | Evans | 13109 | 2357 | 65 | 0 | 32.15328841 | -81.8870105 | 2022-05-10 04:20:50 | Evans, Georgia, US | |
2022-05-08 | US | Wyoming | Washakie | 56043 | 2357 | 44 | 0 | 43.90451606 | -107.680187 | 2022-05-09 04:20:54 | Washakie, Wyoming, US | |
2022-05-08 | US | Georgia | Evans | 13109 | 2357 | 65 | 0 | 32.15328841 | -81.8870105 | 2022-05-09 04:20:54 | Evans, Georgia, US | |
2022-05-07 | US | Wyoming | Washakie | 56043 | 2357 | 44 | 0 | 43.90451606 | -107.680187 | 2022-05-08 04:20:49 | Washakie, Wyoming, US | |
2022-05-07 | US | Georgia | Evans | 13109 | 2357 | 65 | 0 | 32.15328841 | -81.8870105 | 2022-05-08 04:20:49 | Evans, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;