daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
391 rows where confirmed = 1738 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-27 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-28 04:21:04 | Morris, Kansas, US | |
2022-12-26 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-27 04:21:07 | Morris, Kansas, US | |
2022-12-25 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-26 04:21:06 | Morris, Kansas, US | |
2022-12-24 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-25 04:21:04 | Morris, Kansas, US | |
2022-12-23 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-24 04:21:02 | Morris, Kansas, US | |
2022-12-22 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-23 04:21:04 | Morris, Kansas, US | |
2022-12-21 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-22 04:20:56 | Morris, Kansas, US | |
2022-12-20 | US | South Dakota | Hamlin | 46057 | 1738 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-21 04:21:03 | Hamlin, South Dakota, US | |
2022-12-20 | US | North Dakota | Dickey | 38021 | 1738 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-12-21 04:21:03 | Dickey, North Dakota, US | |
2022-12-19 | US | South Dakota | Hamlin | 46057 | 1738 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-20 04:21:04 | Hamlin, South Dakota, US | |
2022-12-18 | US | South Dakota | Hamlin | 46057 | 1738 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-19 04:21:03 | Hamlin, South Dakota, US | |
2022-12-17 | US | South Dakota | Hamlin | 46057 | 1738 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-18 04:21:03 | Hamlin, South Dakota, US | |
2022-12-16 | US | South Dakota | Hamlin | 46057 | 1738 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-17 04:21:04 | Hamlin, South Dakota, US | |
2022-12-15 | US | South Dakota | Hamlin | 46057 | 1738 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-16 04:21:01 | Hamlin, South Dakota, US | |
2022-12-14 | US | South Dakota | Hamlin | 46057 | 1738 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-15 04:20:58 | Hamlin, South Dakota, US | |
2022-12-07 | US | Arkansas | Montgomery | 5097 | 1738 | 64 | 0 | 34.53704874 | -93.65824478 | 2022-12-08 04:21:07 | Montgomery, Arkansas, US | |
2022-11-14 | US | Illinois | Gallatin | 17059 | 1738 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-15 04:21:16 | Gallatin, Illinois, US | |
2022-11-13 | US | Illinois | Gallatin | 17059 | 1738 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-14 04:21:09 | Gallatin, Illinois, US | |
2022-11-12 | US | Illinois | Gallatin | 17059 | 1738 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-13 04:21:14 | Gallatin, Illinois, US | |
2022-11-11 | US | Illinois | Gallatin | 17059 | 1738 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-12 04:20:41 | Gallatin, Illinois, US | |
2022-11-10 | US | Illinois | Gallatin | 17059 | 1738 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-11 04:21:22 | Gallatin, Illinois, US | |
2022-11-09 | US | Illinois | Gallatin | 17059 | 1738 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-10 04:21:16 | Gallatin, Illinois, US | |
2022-10-04 | US | Illinois | Stark | 17175 | 1738 | 39 | 0 | 41.09309773 | -89.79745866 | 2022-10-05 04:23:06 | Stark, Illinois, US | |
2022-09-13 | US | North Dakota | Ransom | 38073 | 1738 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-09-14 04:20:44 | Ransom, North Dakota, US | |
2022-09-01 | US | Missouri | Shannon | 29203 | 1738 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-02 04:21:07 | Shannon, Missouri, US | |
2022-08-31 | US | Missouri | Shannon | 29203 | 1738 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-09-01 04:21:03 | Shannon, Missouri, US | |
2022-08-30 | US | Missouri | Shannon | 29203 | 1738 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-08-31 04:20:57 | Shannon, Missouri, US | |
2022-08-29 | US | Missouri | Shannon | 29203 | 1738 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-08-30 04:21:03 | Shannon, Missouri, US | |
2022-08-28 | US | Missouri | Shannon | 29203 | 1738 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-08-29 04:21:06 | Shannon, Missouri, US | |
2022-08-27 | US | Missouri | Shannon | 29203 | 1738 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-08-28 04:21:02 | Shannon, Missouri, US | |
2022-08-27 | US | California | Trinity | 6105 | 1738 | 20 | 0 | 40.6491767 | -123.114713 | 2022-08-28 04:21:02 | Trinity, California, US | |
2022-08-26 | US | Missouri | Shannon | 29203 | 1738 | 41 | 0 | 37.15772072 | -91.40190382 | 2022-08-27 04:20:57 | Shannon, Missouri, US | |
2022-08-26 | US | California | Trinity | 6105 | 1738 | 20 | 0 | 40.6491767 | -123.114713 | 2022-08-27 04:20:57 | Trinity, California, US | |
2022-08-12 | US | North Dakota | Bottineau | 38009 | 1738 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-08-13 04:20:52 | Bottineau, North Dakota, US | |
2022-08-09 | US | Nebraska | Knox | 31107 | 1738 | 11 | 0 | 42.63758421 | -97.89178836 | 2022-08-10 04:20:57 | Knox, Nebraska, US | |
2022-08-09 | US | Kansas | Wabaunsee | 20197 | 1738 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-08-10 04:20:57 | Wabaunsee, Kansas, US | |
2022-08-08 | US | Nebraska | Knox | 31107 | 1738 | 11 | 0 | 42.63758421 | -97.89178836 | 2022-08-09 04:20:34 | Knox, Nebraska, US | |
2022-08-08 | US | Kansas | Wabaunsee | 20197 | 1738 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-08-09 04:20:34 | Wabaunsee, Kansas, US | |
2022-08-07 | US | Kansas | Wabaunsee | 20197 | 1738 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-08-08 04:21:08 | Wabaunsee, Kansas, US | |
2022-08-07 | US | Colorado | Kit Carson | 8063 | 1738 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-08-08 04:21:08 | Kit Carson, Colorado, US | |
2022-08-06 | US | Kansas | Wabaunsee | 20197 | 1738 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-08-07 04:20:54 | Wabaunsee, Kansas, US | |
2022-08-06 | US | Colorado | Kit Carson | 8063 | 1738 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-08-07 04:20:54 | Kit Carson, Colorado, US | |
2022-08-05 | US | Kansas | Wabaunsee | 20197 | 1738 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-08-06 04:20:56 | Wabaunsee, Kansas, US | |
2022-08-04 | US | Kansas | Wabaunsee | 20197 | 1738 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-08-05 04:20:52 | Wabaunsee, Kansas, US | |
2022-08-03 | US | Kansas | Wabaunsee | 20197 | 1738 | 23 | 0 | 38.95471985 | -96.20350509 | 2022-08-04 04:20:58 | Wabaunsee, Kansas, US | |
2022-07-29 | China | Liaoning | 1738 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-30 04:20:42 | Liaoning, China | |||
2022-07-09 | US | Texas | Brooks | 48047 | 1738 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-07-10 04:20:54 | Brooks, Texas, US | |
2022-06-21 | US | Arkansas | Newton | 5101 | 1738 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-22 04:20:54 | Newton, Arkansas, US | |
2022-06-20 | US | Arkansas | Newton | 5101 | 1738 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-21 04:20:56 | Newton, Arkansas, US | |
2022-06-19 | US | Arkansas | Newton | 5101 | 1738 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-20 04:21:01 | Newton, Arkansas, US | |
2022-06-18 | US | Arkansas | Newton | 5101 | 1738 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-19 04:20:51 | Newton, Arkansas, US | |
2022-06-17 | US | Arkansas | Newton | 5101 | 1738 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-18 04:21:10 | Newton, Arkansas, US | |
2022-06-16 | US | Arkansas | Newton | 5101 | 1738 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-17 04:20:56 | Newton, Arkansas, US | |
2022-06-13 | US | Nebraska | Merrick | 31121 | 1738 | 17 | 0 | 41.16624273 | -98.0374887 | 2022-06-14 04:20:52 | Merrick, Nebraska, US | |
2022-06-12 | US | Nebraska | Merrick | 31121 | 1738 | 17 | 0 | 41.16624273 | -98.0374887 | 2022-06-13 04:21:14 | Merrick, Nebraska, US | |
2022-06-11 | US | Nebraska | Merrick | 31121 | 1738 | 17 | 0 | 41.16624273 | -98.0374887 | 2022-06-12 04:20:53 | Merrick, Nebraska, US | |
2022-06-10 | US | Nebraska | Merrick | 31121 | 1738 | 17 | 0 | 41.16624273 | -98.0374887 | 2022-06-11 04:21:01 | Merrick, Nebraska, US | |
2022-06-02 | US | Missouri | Daviess | 29061 | 1738 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-06-03 04:20:58 | Daviess, Missouri, US | |
2022-06-02 | US | Illinois | Pulaski | 17153 | 1738 | 20 | 0 | 37.22631423 | -89.13085001 | 2022-06-03 04:20:58 | Pulaski, Illinois, US | |
2022-06-01 | US | Missouri | Daviess | 29061 | 1738 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-06-02 05:20:39 | Daviess, Missouri, US | |
2022-06-01 | US | Illinois | Pulaski | 17153 | 1738 | 20 | 0 | 37.22631423 | -89.13085001 | 2022-06-02 05:20:39 | Pulaski, Illinois, US | |
2022-05-31 | US | Missouri | Daviess | 29061 | 1738 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-06-01 04:20:55 | Daviess, Missouri, US | |
2022-05-31 | US | Illinois | Pulaski | 17153 | 1738 | 20 | 0 | 37.22631423 | -89.13085001 | 2022-06-01 04:20:55 | Pulaski, Illinois, US | |
2022-05-30 | US | Missouri | Daviess | 29061 | 1738 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-05-31 04:20:51 | Daviess, Missouri, US | |
2022-05-29 | US | Missouri | Daviess | 29061 | 1738 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-05-30 04:20:50 | Daviess, Missouri, US | |
2022-05-28 | US | Missouri | Daviess | 29061 | 1738 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-05-29 04:20:53 | Daviess, Missouri, US | |
2022-05-28 | US | Arkansas | Woodruff | 5147 | 1738 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-05-29 04:20:53 | Woodruff, Arkansas, US | |
2022-05-27 | US | Missouri | Daviess | 29061 | 1738 | 30 | 0 | 39.96145298 | -93.98519678 | 2022-05-28 04:21:07 | Daviess, Missouri, US | |
2022-05-18 | US | Colorado | Rio Blanco | 8103 | 1738 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-05-19 04:20:54 | Rio Blanco, Colorado, US | |
2022-05-10 | US | Michigan | Alcona | 26001 | 1738 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-05-11 04:20:48 | Alcona, Michigan, US | |
2022-05-09 | US | Michigan | Alcona | 26001 | 1738 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-05-10 04:20:50 | Alcona, Michigan, US | |
2022-05-08 | US | Michigan | Alcona | 26001 | 1738 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-05-09 04:20:54 | Alcona, Michigan, US | |
2022-05-07 | US | Michigan | Alcona | 26001 | 1738 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-05-08 04:20:49 | Alcona, Michigan, US | |
2022-05-06 | US | Michigan | Alcona | 26001 | 1738 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-05-07 04:21:09 | Alcona, Michigan, US | |
2022-05-05 | US | Michigan | Alcona | 26001 | 1738 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-05-06 04:21:00 | Alcona, Michigan, US | |
2022-05-04 | US | Michigan | Alcona | 26001 | 1738 | 71 | 0 | 44.6846864 | -83.59507875 | 2022-05-05 04:20:55 | Alcona, Michigan, US | |
2022-04-06 | US | Arkansas | Dallas | 5039 | 1738 | 31 | 0 | 33.97042763 | -92.65167437 | 2022-04-07 04:20:53 | Dallas, Arkansas, US | |
2022-04-05 | US | Arkansas | Dallas | 5039 | 1738 | 31 | 0 | 33.97042763 | -92.65167437 | 2022-04-06 04:20:49 | Dallas, Arkansas, US | |
2022-03-22 | China | Beijing | 1738 | 9 | 0 | 40.1824 | 116.4142 | 2022-03-23 04:20:48 | Beijing, China | |||
2022-02-14 | US | Kansas | Greenwood | 20073 | 1738 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-15 04:21:09 | Greenwood, Kansas, US | |
2022-02-13 | US | West Virginia | Calhoun | 54013 | 1738 | 11 | 0 | 38.84315422 | -81.11934872 | 2022-02-14 04:20:51 | Calhoun, West Virginia, US | |
2022-02-13 | US | Kansas | Greenwood | 20073 | 1738 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-14 04:20:51 | Greenwood, Kansas, US | |
2022-02-12 | US | Kansas | Greenwood | 20073 | 1738 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-13 04:21:00 | Greenwood, Kansas, US | |
2022-02-11 | US | Kansas | Greenwood | 20073 | 1738 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-12 04:21:06 | Greenwood, Kansas, US | |
2022-02-10 | US | Kansas | Greenwood | 20073 | 1738 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-11 04:21:09 | Greenwood, Kansas, US | |
2022-02-09 | US | Kansas | Greenwood | 20073 | 1738 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-10 04:21:14 | Greenwood, Kansas, US | |
2022-02-08 | US | Kansas | Greenwood | 20073 | 1738 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-09 04:21:04 | Greenwood, Kansas, US | |
2022-02-07 | US | Texas | Gaines | 48165 | 1738 | 78 | 0 | 32.74055318 | -102.6353295 | 2022-02-08 04:21:15 | Gaines, Texas, US | |
2022-02-07 | US | Nebraska | Cuming | 31039 | 1738 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-02-08 04:21:15 | Cuming, Nebraska, US | |
2022-02-07 | US | Kansas | Greenwood | 20073 | 1738 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-08 04:21:15 | Greenwood, Kansas, US | |
2022-02-07 | US | Illinois | Edwards | 17047 | 1738 | 25 | 0 | 38.41353228 | -88.05720863 | 2022-02-08 04:21:15 | Edwards, Illinois, US | |
2022-02-04 | US | Puerto Rico | Guayanilla | 72059 | 1738 | 0 | 0 | 18.039942 | -66.79186 | 2022-02-05 04:21:05 | Guayanilla, Puerto Rico, US | |
2022-02-04 | US | Missouri | Hickory | 29085 | 1738 | 50 | 0 | 37.94163617 | -93.3203037 | 2022-02-05 04:21:05 | Hickory, Missouri, US | |
2022-02-01 | US | Nebraska | Butler | 31023 | 1738 | 11 | 0 | 41.22703692 | -97.13106306 | 2022-02-02 04:21:09 | Butler, Nebraska, US | |
2022-01-31 | US | Nebraska | Butler | 31023 | 1738 | 11 | 0 | 41.22703692 | -97.13106306 | 2022-02-01 04:21:11 | Butler, Nebraska, US | |
2022-01-30 | US | Virginia | Falls Church | 51610 | 1738 | 14 | 0 | 38.88485255 | -77.17560759 | 2022-01-31 04:21:09 | Falls Church, Virginia, US | |
2022-01-29 | US | Virginia | Falls Church | 51610 | 1738 | 14 | 0 | 38.88485255 | -77.17560759 | 2022-01-30 04:21:26 | Falls Church, Virginia, US | |
2022-01-28 | US | Virginia | Falls Church | 51610 | 1738 | 14 | 0 | 38.88485255 | -77.17560759 | 2022-01-29 04:21:10 | Falls Church, Virginia, US | |
2022-01-24 | US | Wyoming | Platte | 56031 | 1738 | 37 | 0 | 42.13299116 | -104.96633100000001 | 2022-01-25 04:21:05 | Platte, Wyoming, US | |
2022-01-18 | US | Puerto Rico | Rincon | 72117 | 1738 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-01-19 04:21:23 | Rincon, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;