daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
365 rows where confirmed = 1701 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-15 | US | Montana | Stillwater | 30095 | 1701 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-12-16 04:21:01 | Stillwater, Montana, US | |
2022-12-14 | US | Montana | Stillwater | 30095 | 1701 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-12-15 04:20:58 | Stillwater, Montana, US | |
2022-12-13 | US | Montana | Stillwater | 30095 | 1701 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-12-14 04:21:04 | Stillwater, Montana, US | |
2022-11-21 | US | Wisconsin | Iron | 55051 | 1701 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-11-22 04:20:47 | Iron, Wisconsin, US | |
2022-11-15 | US | Idaho | Lemhi | 16059 | 1701 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-11-16 04:21:09 | Lemhi, Idaho, US | |
2022-11-14 | US | Virginia | Cumberland | 51049 | 1701 | 29 | 0 | 37.51328851 | -78.24398086 | 2022-11-15 04:21:16 | Cumberland, Virginia, US | |
2022-11-14 | US | Idaho | Lemhi | 16059 | 1701 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-11-15 04:21:16 | Lemhi, Idaho, US | |
2022-11-13 | US | Virginia | Cumberland | 51049 | 1701 | 29 | 0 | 37.51328851 | -78.24398086 | 2022-11-14 04:21:09 | Cumberland, Virginia, US | |
2022-11-13 | US | North Dakota | Dickey | 38021 | 1701 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-11-14 04:21:09 | Dickey, North Dakota, US | |
2022-11-13 | US | Idaho | Lemhi | 16059 | 1701 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-11-14 04:21:09 | Lemhi, Idaho, US | |
2022-11-12 | US | Virginia | Cumberland | 51049 | 1701 | 29 | 0 | 37.51328851 | -78.24398086 | 2022-11-13 04:21:14 | Cumberland, Virginia, US | |
2022-11-12 | US | North Dakota | Dickey | 38021 | 1701 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-11-13 04:21:14 | Dickey, North Dakota, US | |
2022-11-12 | US | Idaho | Lemhi | 16059 | 1701 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-11-13 04:21:14 | Lemhi, Idaho, US | |
2022-11-11 | US | Virginia | Cumberland | 51049 | 1701 | 29 | 0 | 37.51328851 | -78.24398086 | 2022-11-12 04:20:41 | Cumberland, Virginia, US | |
2022-11-11 | US | North Dakota | Dickey | 38021 | 1701 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-11-12 04:20:41 | Dickey, North Dakota, US | |
2022-11-11 | US | Idaho | Lemhi | 16059 | 1701 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-11-12 04:20:41 | Lemhi, Idaho, US | |
2022-11-10 | US | Virginia | Cumberland | 51049 | 1701 | 29 | 0 | 37.51328851 | -78.24398086 | 2022-11-11 04:21:22 | Cumberland, Virginia, US | |
2022-11-10 | US | Idaho | Lemhi | 16059 | 1701 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-11-11 04:21:22 | Lemhi, Idaho, US | |
2022-11-09 | US | Idaho | Lemhi | 16059 | 1701 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-11-10 04:21:16 | Lemhi, Idaho, US | |
2022-10-28 | China | Xinjiang | 1701 | 3 | 0 | 41.1129 | 85.2401 | 2022-10-29 04:21:13 | Xinjiang, China | |||
2022-10-27 | US | West Virginia | Wirt | 54105 | 1701 | 26 | 0 | 39.02775007 | -81.37473928 | 2022-10-28 04:22:31 | Wirt, West Virginia, US | |
2022-10-27 | China | Xinjiang | 1701 | 3 | 0 | 41.1129 | 85.2401 | 2022-10-28 04:22:31 | Xinjiang, China | |||
2022-10-26 | US | West Virginia | Wirt | 54105 | 1701 | 26 | 0 | 39.02775007 | -81.37473928 | 2022-10-27 04:22:01 | Wirt, West Virginia, US | |
2022-10-25 | US | West Virginia | Wirt | 54105 | 1701 | 26 | 0 | 39.02775007 | -81.37473928 | 2022-10-26 04:22:19 | Wirt, West Virginia, US | |
2022-10-24 | US | West Virginia | Wirt | 54105 | 1701 | 26 | 0 | 39.02775007 | -81.37473928 | 2022-10-25 04:21:53 | Wirt, West Virginia, US | |
2022-10-04 | US | Georgia | Randolph | 13243 | 1701 | 49 | 0 | 31.76622818 | -84.75732369 | 2022-10-05 04:23:06 | Randolph, Georgia, US | |
2022-10-03 | US | Georgia | Randolph | 13243 | 1701 | 49 | 0 | 31.76622818 | -84.75732369 | 2022-10-04 04:22:55 | Randolph, Georgia, US | |
2022-10-02 | US | Georgia | Randolph | 13243 | 1701 | 49 | 0 | 31.76622818 | -84.75732369 | 2022-10-03 04:23:11 | Randolph, Georgia, US | |
2022-10-01 | US | Georgia | Randolph | 13243 | 1701 | 49 | 0 | 31.76622818 | -84.75732369 | 2022-10-02 04:21:23 | Randolph, Georgia, US | |
2022-09-30 | US | Georgia | Randolph | 13243 | 1701 | 49 | 0 | 31.76622818 | -84.75732369 | 2022-10-01 04:23:01 | Randolph, Georgia, US | |
2022-09-29 | US | Georgia | Randolph | 13243 | 1701 | 49 | 0 | 31.76622818 | -84.75732369 | 2022-09-30 04:23:09 | Randolph, Georgia, US | |
2022-09-28 | US | Georgia | Randolph | 13243 | 1701 | 49 | 0 | 31.76622818 | -84.75732369 | 2022-09-29 04:22:34 | Randolph, Georgia, US | |
2022-09-22 | US | Arkansas | Montgomery | 5097 | 1701 | 59 | 0 | 34.53704874 | -93.65824478 | 2022-09-23 04:23:13 | Montgomery, Arkansas, US | |
2022-09-07 | US | Illinois | Gallatin | 17059 | 1701 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-09-08 04:21:02 | Gallatin, Illinois, US | |
2022-09-06 | US | Illinois | Gallatin | 17059 | 1701 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-09-07 04:20:59 | Gallatin, Illinois, US | |
2022-08-25 | US | North Dakota | Ransom | 38073 | 1701 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-08-26 04:21:02 | Ransom, North Dakota, US | |
2022-07-18 | US | Colorado | Kit Carson | 8063 | 1701 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-07-19 04:20:58 | Kit Carson, Colorado, US | |
2022-06-09 | China | Liaoning | 1701 | 2 | 0 | 41.2956 | 122.6085 | 2022-06-10 04:20:55 | Liaoning, China | |||
2022-05-31 | US | Colorado | Clear Creek | 8019 | 1701 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-06-01 04:20:55 | Clear Creek, Colorado, US | |
2022-05-09 | US | Oregon | Grant | 41023 | 1701 | 21 | 0 | 44.49024544 | -119.0068631 | 2022-05-10 04:20:50 | Grant, Oregon, US | |
2022-05-08 | US | Oregon | Grant | 41023 | 1701 | 21 | 0 | 44.49024544 | -119.0068631 | 2022-05-09 04:20:54 | Grant, Oregon, US | |
2022-05-07 | US | Oregon | Grant | 41023 | 1701 | 21 | 0 | 44.49024544 | -119.0068631 | 2022-05-08 04:20:49 | Grant, Oregon, US | |
2022-05-06 | US | Oregon | Grant | 41023 | 1701 | 21 | 0 | 44.49024544 | -119.0068631 | 2022-05-07 04:21:09 | Grant, Oregon, US | |
2022-05-05 | US | Oregon | Grant | 41023 | 1701 | 21 | 0 | 44.49024544 | -119.0068631 | 2022-05-06 04:21:00 | Grant, Oregon, US | |
2022-04-20 | US | Missouri | Chariton | 29041 | 1701 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-04-21 04:20:46 | Chariton, Missouri, US | |
2022-04-19 | US | Missouri | Chariton | 29041 | 1701 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-04-20 04:20:45 | Chariton, Missouri, US | |
2022-04-18 | US | Missouri | Chariton | 29041 | 1701 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-04-19 04:21:00 | Chariton, Missouri, US | |
2022-04-17 | US | Missouri | Chariton | 29041 | 1701 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-04-18 04:21:12 | Chariton, Missouri, US | |
2022-04-16 | US | Missouri | Chariton | 29041 | 1701 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-04-17 04:20:59 | Chariton, Missouri, US | |
2022-04-15 | US | Missouri | Chariton | 29041 | 1701 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-04-16 04:20:48 | Chariton, Missouri, US | |
2022-04-14 | US | Missouri | Chariton | 29041 | 1701 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-04-15 04:20:57 | Chariton, Missouri, US | |
2022-04-13 | US | Puerto Rico | Arroyo | 72015 | 1701 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-04-13 23:21:06 | Arroyo, Puerto Rico, US | |
2022-03-31 | US | Nebraska | Merrick | 31121 | 1701 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-04-01 04:20:28 | Merrick, Nebraska, US | |
2022-03-28 | US | Georgia | Miller | 13201 | 1701 | 31 | 0 | 31.16568912 | -84.73151117 | 2022-03-29 04:20:46 | Miller, Georgia, US | |
2022-03-24 | US | Puerto Rico | Hormigueros | 72067 | 1701 | 0 | 0 | 18.134532 | -67.113972 | 2022-03-25 04:20:46 | Hormigueros, Puerto Rico, US | |
2022-03-21 | US | Nebraska | Merrick | 31121 | 1701 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-03-22 04:20:54 | Merrick, Nebraska, US | |
2022-03-21 | US | Missouri | Ozark | 29153 | 1701 | 55 | 0 | 36.64916339 | -92.44459066 | 2022-03-22 04:20:54 | Ozark, Missouri, US | |
2022-03-17 | US | Nebraska | Merrick | 31121 | 1701 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-03-18 04:20:55 | Merrick, Nebraska, US | |
2022-03-16 | US | Nebraska | Merrick | 31121 | 1701 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-03-17 04:20:56 | Merrick, Nebraska, US | |
2022-03-07 | US | Minnesota | Mahnomen | 27087 | 1701 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-03-08 04:20:54 | Mahnomen, Minnesota, US | |
2022-03-06 | US | Missouri | Sullivan | 29211 | 1701 | 20 | 0 | 40.2099105 | -93.11150106 | 2022-03-07 04:20:47 | Sullivan, Missouri, US | |
2022-03-05 | US | Missouri | Sullivan | 29211 | 1701 | 20 | 0 | 40.2099105 | -93.11150106 | 2022-03-06 04:20:49 | Sullivan, Missouri, US | |
2022-03-04 | US | Missouri | Sullivan | 29211 | 1701 | 20 | 0 | 40.2099105 | -93.11150106 | 2022-03-05 04:21:10 | Sullivan, Missouri, US | |
2022-03-03 | US | Missouri | Sullivan | 29211 | 1701 | 20 | 0 | 40.2099105 | -93.11150106 | 2022-03-04 04:21:09 | Sullivan, Missouri, US | |
2022-03-02 | US | Missouri | Sullivan | 29211 | 1701 | 20 | 0 | 40.2099105 | -93.11150106 | 2022-03-03 04:21:01 | Sullivan, Missouri, US | |
2022-03-01 | US | Missouri | Sullivan | 29211 | 1701 | 20 | 0 | 40.2099105 | -93.11150106 | 2022-03-02 04:21:07 | Sullivan, Missouri, US | |
2022-02-18 | US | Arkansas | Woodruff | 5147 | 1701 | 25 | 0 | 35.18902527 | -91.2439489 | 2022-02-19 04:21:11 | Woodruff, Arkansas, US | |
2022-02-17 | US | Arkansas | Dallas | 5039 | 1701 | 26 | 0 | 33.97042763 | -92.65167437 | 2022-02-18 04:21:04 | Dallas, Arkansas, US | |
2022-02-15 | US | Virginia | Bland | 51021 | 1701 | 20 | 0 | 37.13128068 | -81.13599391 | 2022-02-16 04:21:10 | Bland, Virginia, US | |
2022-02-13 | US | Michigan | Schoolcraft | 26153 | 1701 | 13 | 0 | 46.19235734 | -86.19972234 | 2022-02-14 04:20:51 | Schoolcraft, Michigan, US | |
2022-02-12 | US | Michigan | Schoolcraft | 26153 | 1701 | 13 | 0 | 46.19235734 | -86.19972234 | 2022-02-13 04:21:00 | Schoolcraft, Michigan, US | |
2022-02-11 | US | Michigan | Schoolcraft | 26153 | 1701 | 13 | 0 | 46.19235734 | -86.19972234 | 2022-02-12 04:21:06 | Schoolcraft, Michigan, US | |
2022-01-29 | US | Missouri | Harrison | 29081 | 1701 | 27 | 0 | 40.35570088 | -93.99222144 | 2022-01-30 04:21:26 | Harrison, Missouri, US | |
2022-01-27 | US | Puerto Rico | Patillas | 72109 | 1701 | 0 | 0 | 18.03174 | -66.012242 | 2022-01-28 04:21:09 | Patillas, Puerto Rico, US | |
2022-01-24 | US | Wyoming | Sublette | 56035 | 1701 | 24 | 0 | 42.76558279 | -109.91309220000001 | 2022-01-25 04:21:05 | Sublette, Wyoming, US | |
2022-01-19 | US | Virginia | Madison | 51113 | 1701 | 25 | 0 | 38.41531222 | -78.28220331 | 2022-01-20 04:21:07 | Madison, Virginia, US | |
2022-01-19 | US | Kentucky | Bracken | 21023 | 1701 | 22 | 0 | 38.69158994 | -84.08532444 | 2022-01-20 04:21:07 | Bracken, Kentucky, US | |
2022-01-18 | US | South Dakota | Custer | 46033 | 1701 | 21 | 0 | 43.67741105 | -103.45345209999999 | 2022-01-19 04:21:23 | Custer, South Dakota, US | |
2022-01-17 | US | South Dakota | Custer | 46033 | 1701 | 21 | 0 | 43.67741105 | -103.45345209999999 | 2022-01-18 04:21:04 | Custer, South Dakota, US | |
2022-01-16 | US | Texas | Hamilton | 48193 | 1701 | 29 | 0 | 31.70470573 | -98.11083887 | 2022-01-17 04:21:08 | Hamilton, Texas, US | |
2022-01-16 | US | South Dakota | Custer | 46033 | 1701 | 21 | 0 | 43.67741105 | -103.45345209999999 | 2022-01-17 04:21:08 | Custer, South Dakota, US | |
2022-01-15 | US | Texas | Floyd | 48153 | 1701 | 42 | 0 | 34.07227468 | -101.3031546 | 2022-01-16 04:21:12 | Floyd, Texas, US | |
2022-01-15 | US | South Dakota | Custer | 46033 | 1701 | 21 | 0 | 43.67741105 | -103.45345209999999 | 2022-01-16 04:21:12 | Custer, South Dakota, US | |
2022-01-14 | US | South Dakota | Custer | 46033 | 1701 | 21 | 0 | 43.67741105 | -103.45345209999999 | 2022-01-15 04:21:07 | Custer, South Dakota, US | |
2022-01-12 | US | Nebraska | Custer | 31041 | 1701 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-01-13 08:00:09 | Custer, Nebraska, US | |
2022-01-10 | US | Louisiana | Red River | 22081 | 1701 | 49 | 0 | 32.09530039 | -93.34213308 | 2022-01-11 04:22:01 | Red River, Louisiana, US | |
2022-01-09 | US | Georgia | Wilkinson | 13319 | 1701 | 47 | 0 | 32.80291082 | -83.17140684 | 2022-01-10 04:22:07 | Wilkinson, Georgia, US | |
2022-01-08 | US | Georgia | Wilkinson | 13319 | 1701 | 47 | 0 | 32.80291082 | -83.17140684 | 2022-01-09 04:21:46 | Wilkinson, Georgia, US | |
2022-01-07 | US | Georgia | Wilkinson | 13319 | 1701 | 47 | 0 | 32.80291082 | -83.17140684 | 2022-01-08 04:21:53 | Wilkinson, Georgia, US | |
2022-01-06 | US | Georgia | Wilkinson | 13319 | 1701 | 47 | 0 | 32.80291082 | -83.17140684 | 2022-01-07 04:22:09 | Wilkinson, Georgia, US | |
2022-01-05 | US | Georgia | Wilkinson | 13319 | 1701 | 47 | 0 | 32.80291082 | -83.17140684 | 2022-01-06 04:22:09 | Wilkinson, Georgia, US | |
2022-01-04 | US | Minnesota | Clearwater | 27029 | 1701 | 25 | 0 | 47.57992111 | -95.37790562 | 2022-01-05 04:21:59 | Clearwater, Minnesota, US | |
2021-12-29 | US | Georgia | Dooly | 13093 | 1701 | 62 | 0 | 32.15630737 | -83.79746561 | 2021-12-30 04:21:25 | Dooly, Georgia, US | |
2021-12-16 | US | Virginia | Galax | 51640 | 1701 | 65 | 0 | 36.66601852 | -80.91703124 | 2021-12-17 04:22:14 | Galax, Virginia, US | |
2021-12-13 | US | Nebraska | Box Butte | 31013 | 1701 | 8 | 0 | 42.22079243 | -103.08788340000001 | 2021-12-14 04:22:38 | Box Butte, Nebraska, US | |
2021-12-01 | US | Idaho | Owyhee | 16073 | 1701 | 41 | 0 | 42.58016894 | -116.16938710000001 | 2021-12-02 04:22:37 | Owyhee, Idaho, US | |
2021-11-30 | US | Wisconsin | Forest | 55041 | 1701 | 33 | 0 | 45.66678019 | -88.77084892 | 2021-12-01 04:22:29 | Forest, Wisconsin, US | |
2021-11-15 | US | Minnesota | Rock | 27133 | 1701 | 27 | 0 | 43.67482683 | -96.25296832 | 2021-11-16 04:21:10 | Rock, Minnesota, US | |
2021-11-04 | US | Texas | Ochiltree | 48357 | 1701 | 37 | 0 | 36.27829105 | -100.8158184 | 2021-11-05 04:21:54 | Ochiltree, Texas, US | |
2021-10-31 | US | Georgia | McIntosh | 13191 | 1701 | 31 | 0 | 31.49683595 | -81.40163426 | 2021-11-01 04:22:01 | McIntosh, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;