daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where confirmed = 14674 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 8
country_or_region 1
- US · 22 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-07 | US | Wisconsin | Polk | 55095 | 14674 | 124 | 0 | 45.46130348 | -92.44182875 | 2022-12-08 04:21:07 | Polk, Wisconsin, US | |
2022-10-18 | US | Wisconsin | Grant | 55043 | 14674 | 155 | 0 | 42.8671731 | -90.7063218 | 2022-10-19 04:22:26 | Grant, Wisconsin, US | |
2022-08-09 | US | Kansas | Riley | 20161 | 14674 | 93 | 0 | 39.28935726 | -96.73420026 | 2022-08-10 04:20:57 | Riley, Kansas, US | |
2022-08-08 | US | Kansas | Riley | 20161 | 14674 | 93 | 0 | 39.28935726 | -96.73420026 | 2022-08-09 04:20:34 | Riley, Kansas, US | |
2022-08-07 | US | Kansas | Riley | 20161 | 14674 | 93 | 0 | 39.28935726 | -96.73420026 | 2022-08-08 04:21:08 | Riley, Kansas, US | |
2022-08-06 | US | Kansas | Riley | 20161 | 14674 | 93 | 0 | 39.28935726 | -96.73420026 | 2022-08-07 04:20:54 | Riley, Kansas, US | |
2022-08-05 | US | Kansas | Riley | 20161 | 14674 | 93 | 0 | 39.28935726 | -96.73420026 | 2022-08-06 04:20:56 | Riley, Kansas, US | |
2022-08-04 | US | Kansas | Riley | 20161 | 14674 | 93 | 0 | 39.28935726 | -96.73420026 | 2022-08-05 04:20:52 | Riley, Kansas, US | |
2022-08-03 | US | Kansas | Riley | 20161 | 14674 | 93 | 0 | 39.28935726 | -96.73420026 | 2022-08-04 04:20:58 | Riley, Kansas, US | |
2022-06-30 | US | Texas | Val Verde | 48465 | 14674 | 304 | 0 | 29.89149232 | -101.1525205 | 2022-07-01 04:21:10 | Val Verde, Texas, US | |
2022-05-03 | US | California | Tehama | 6103 | 14674 | 201 | 0 | 40.12570935 | -122.2370171 | 2022-05-04 04:20:59 | Tehama, California, US | |
2022-02-05 | US | California | Mendocino | 6045 | 14674 | 117 | 0 | 39.4381191 | -123.39113130000001 | 2022-02-06 04:21:00 | Mendocino, California, US | |
2021-10-12 | US | Virginia | Hampton | 51650 | 14674 | 224 | 0 | 37.03513786 | -76.35879121 | 2021-10-13 04:20:51 | Hampton, Virginia, US | |
2021-10-06 | US | Minnesota | Sherburne | 27141 | 14674 | 110 | 0 | 45.44447208 | -93.77617511 | 2021-10-07 04:21:36 | Sherburne, Minnesota, US | |
2021-07-18 | US | Illinois | Kankakee | 17091 | 14674 | 223 | 0 | 41.13746989 | -87.86205334 | 2021-07-19 04:21:24 | Kankakee, Illinois, US | |
2021-07-17 | US | Illinois | Kankakee | 17091 | 14674 | 223 | 0 | 41.13746989 | -87.86205334 | 2021-07-18 04:22:07 | Kankakee, Illinois, US | |
2021-07-16 | US | Illinois | Kankakee | 17091 | 14674 | 223 | 0 | 41.13746989 | -87.86205334 | 2021-07-17 04:22:22 | Kankakee, Illinois, US | |
2021-03-08 | US | Texas | Smith | 48423 | 14674 | 411 | 0 | 32.37474036 | -95.2717568 | 2021-03-09 05:28:19 | Smith, Texas, US | |
2021-03-07 | US | Texas | Smith | 48423 | 14674 | 411 | 0 | 32.37474036 | -95.2717568 | 2021-03-08 05:24:48 | Smith, Texas, US | |
2021-03-06 | US | Texas | Smith | 48423 | 14674 | 410 | 0 | 18533 | 32.37474036 | -95.2717568 | 2021-03-07 05:21:54 | Smith, Texas, US |
2021-03-05 | US | Texas | Smith | 48423 | 14674 | 410 | 0 | 18533 | 32.37474036 | -95.2717568 | 2021-03-06 04:23:41 | Smith, Texas, US |
2020-09-14 | US | Louisiana | East Baton Rouge | 22033 | 14674 | 432 | 0 | 14242 | 30.53842039 | -91.09777565 | 2020-09-15 03:22:50 | East Baton Rouge, Louisiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;