daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
525 rows where confirmed = 922 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-20 | US | Iowa | Adams | 19003 | 922 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-21 04:21:03 | Adams, Iowa, US | |
2022-12-19 | US | Iowa | Adams | 19003 | 922 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-20 04:21:04 | Adams, Iowa, US | |
2022-12-18 | US | Iowa | Adams | 19003 | 922 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-19 04:21:03 | Adams, Iowa, US | |
2022-12-17 | US | Iowa | Adams | 19003 | 922 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-18 04:21:03 | Adams, Iowa, US | |
2022-12-16 | US | Iowa | Adams | 19003 | 922 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-17 04:21:04 | Adams, Iowa, US | |
2022-12-15 | US | Iowa | Adams | 19003 | 922 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-16 04:21:01 | Adams, Iowa, US | |
2022-12-14 | US | Iowa | Adams | 19003 | 922 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-12-15 04:20:58 | Adams, Iowa, US | |
2022-12-11 | US | New Mexico | Union | 35059 | 922 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-12 04:21:01 | Union, New Mexico, US | |
2022-12-10 | US | New Mexico | Union | 35059 | 922 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-11 04:20:50 | Union, New Mexico, US | |
2022-12-09 | US | New Mexico | Union | 35059 | 922 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-10 04:21:02 | Union, New Mexico, US | |
2022-12-08 | US | New Mexico | Union | 35059 | 922 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-12-09 04:21:05 | Union, New Mexico, US | |
2022-10-13 | US | North Dakota | Hettinger | 38041 | 922 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-14 04:22:28 | Hettinger, North Dakota, US | |
2022-10-12 | US | North Dakota | Hettinger | 38041 | 922 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-13 04:22:39 | Hettinger, North Dakota, US | |
2022-10-11 | US | North Dakota | Hettinger | 38041 | 922 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-12 04:22:51 | Hettinger, North Dakota, US | |
2022-10-10 | US | North Dakota | Hettinger | 38041 | 922 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-11 04:23:05 | Hettinger, North Dakota, US | |
2022-10-09 | US | North Dakota | Hettinger | 38041 | 922 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-10 04:22:32 | Hettinger, North Dakota, US | |
2022-10-08 | US | North Dakota | Hettinger | 38041 | 922 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-09 04:21:16 | Hettinger, North Dakota, US | |
2022-10-07 | US | North Dakota | Hettinger | 38041 | 922 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-08 04:22:56 | Hettinger, North Dakota, US | |
2022-10-04 | US | New York | Unassigned | 90036 | 922 | 2 | 0 | 44.74530905 | 0.0 | 2022-10-05 04:23:06 | Unassigned, New York, US | |
2022-10-04 | US | Alaska | Yakutat | 2282 | 922 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-10-05 04:23:06 | Yakutat, Alaska, US | |
2022-10-03 | US | New York | Unassigned | 90036 | 922 | 2 | 0 | 44.74530905 | 0.0 | 2022-10-04 04:22:55 | Unassigned, New York, US | |
2022-10-03 | US | Alaska | Yakutat | 2282 | 922 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-10-04 04:22:55 | Yakutat, Alaska, US | |
2022-10-02 | US | Alaska | Yakutat | 2282 | 922 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-10-03 04:23:11 | Yakutat, Alaska, US | |
2022-10-01 | US | Alaska | Yakutat | 2282 | 922 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-10-02 04:21:23 | Yakutat, Alaska, US | |
2022-09-30 | US | Alaska | Yakutat | 2282 | 922 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-10-01 04:23:01 | Yakutat, Alaska, US | |
2022-09-29 | US | Alaska | Yakutat | 2282 | 922 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-09-30 04:23:09 | Yakutat, Alaska, US | |
2022-09-28 | US | Alaska | Yakutat | 2282 | 922 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-09-29 04:22:34 | Yakutat, Alaska, US | |
2022-08-31 | US | Minnesota | Traverse | 27155 | 922 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-09-01 04:21:03 | Traverse, Minnesota, US | |
2022-08-30 | US | Minnesota | Traverse | 27155 | 922 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-31 04:20:57 | Traverse, Minnesota, US | |
2022-08-29 | US | Minnesota | Traverse | 27155 | 922 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-30 04:21:03 | Traverse, Minnesota, US | |
2022-08-28 | US | Minnesota | Traverse | 27155 | 922 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-29 04:21:06 | Traverse, Minnesota, US | |
2022-08-27 | US | Minnesota | Traverse | 27155 | 922 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-28 04:21:02 | Traverse, Minnesota, US | |
2022-08-26 | US | Minnesota | Traverse | 27155 | 922 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-27 04:20:57 | Traverse, Minnesota, US | |
2022-08-25 | US | Minnesota | Traverse | 27155 | 922 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-26 04:21:02 | Traverse, Minnesota, US | |
2022-08-07 | US | Colorado | Baca | 8009 | 922 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-08-08 04:21:08 | Baca, Colorado, US | |
2022-07-20 | US | Oklahoma | Roger Mills | 40129 | 922 | 16 | 0 | 35.68711719 | -99.69666167 | 2022-07-21 04:21:10 | Roger Mills, Oklahoma, US | |
2022-07-19 | US | Oklahoma | Roger Mills | 40129 | 922 | 16 | 0 | 35.68711719 | -99.69666167 | 2022-07-20 04:20:59 | Roger Mills, Oklahoma, US | |
2022-07-18 | US | Oklahoma | Roger Mills | 40129 | 922 | 16 | 0 | 35.68711719 | -99.69666167 | 2022-07-19 04:20:58 | Roger Mills, Oklahoma, US | |
2022-07-17 | US | Oklahoma | Roger Mills | 40129 | 922 | 16 | 0 | 35.68711719 | -99.69666167 | 2022-07-18 04:20:59 | Roger Mills, Oklahoma, US | |
2022-07-16 | US | Oklahoma | Roger Mills | 40129 | 922 | 16 | 0 | 35.68711719 | -99.69666167 | 2022-07-17 04:21:15 | Roger Mills, Oklahoma, US | |
2022-07-15 | US | Oklahoma | Roger Mills | 40129 | 922 | 16 | 0 | 35.68711719 | -99.69666167 | 2022-07-16 04:21:05 | Roger Mills, Oklahoma, US | |
2022-07-14 | US | Oklahoma | Roger Mills | 40129 | 922 | 16 | 0 | 35.68711719 | -99.69666167 | 2022-07-15 04:20:53 | Roger Mills, Oklahoma, US | |
2022-05-21 | US | Idaho | Bear Lake | 16007 | 922 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-22 04:20:52 | Bear Lake, Idaho, US | |
2022-05-20 | US | Idaho | Bear Lake | 16007 | 922 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-21 04:20:58 | Bear Lake, Idaho, US | |
2022-02-24 | US | Minnesota | Red Lake | 27125 | 922 | 12 | 0 | 47.87197525 | -96.09561104 | 2022-02-25 04:21:11 | Red Lake, Minnesota, US | |
2022-02-17 | US | Idaho | Lincoln | 16063 | 922 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-02-18 04:21:04 | Lincoln, Idaho, US | |
2022-02-16 | US | South Dakota | Edmunds | 46045 | 922 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-02-17 04:20:56 | Edmunds, South Dakota, US | |
2022-02-15 | US | South Dakota | Edmunds | 46045 | 922 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-02-16 04:21:10 | Edmunds, South Dakota, US | |
2022-02-14 | US | South Dakota | Edmunds | 46045 | 922 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-02-15 04:21:09 | Edmunds, South Dakota, US | |
2022-02-13 | US | South Dakota | Edmunds | 46045 | 922 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-02-14 04:20:51 | Edmunds, South Dakota, US | |
2022-02-12 | US | South Dakota | Edmunds | 46045 | 922 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-02-13 04:21:00 | Edmunds, South Dakota, US | |
2022-02-11 | US | South Dakota | Edmunds | 46045 | 922 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-02-12 04:21:06 | Edmunds, South Dakota, US | |
2022-02-09 | US | Missouri | Knox | 29103 | 922 | 12 | 0 | 40.12699751 | -92.14780832 | 2022-02-10 04:21:14 | Knox, Missouri, US | |
2022-02-02 | US | Kentucky | Carlisle | 21039 | 922 | 16 | 0 | 36.85372876 | -88.96692220000001 | 2022-02-03 04:21:21 | Carlisle, Kentucky, US | |
2022-02-01 | US | Kentucky | Carlisle | 21039 | 922 | 16 | 0 | 36.85372876 | -88.96692220000001 | 2022-02-02 04:21:09 | Carlisle, Kentucky, US | |
2022-01-28 | US | Texas | Donley | 48129 | 922 | 20 | 0 | 34.96517499 | -100.8140093 | 2022-01-29 04:21:10 | Donley, Texas, US | |
2022-01-28 | US | Puerto Rico | Las Marias | 72083 | 922 | 0 | 0 | 18.23679 | -66.98362 | 2022-01-29 04:21:10 | Las Marias, Puerto Rico, US | |
2022-01-25 | US | Texas | Presidio | 48377 | 922 | 32 | 0 | 29.99954402 | -104.24080790000001 | 2022-01-26 04:21:07 | Presidio, Texas, US | |
2022-01-25 | US | New Mexico | Guadalupe | 35019 | 922 | 16 | 0 | 34.86319296 | -104.790669 | 2022-01-26 04:21:07 | Guadalupe, New Mexico, US | |
2022-01-23 | US | Texas | Crockett | 48105 | 922 | 17 | 0 | 30.72367027 | -101.4134238 | 2022-01-24 04:21:12 | Crockett, Texas, US | |
2022-01-23 | US | Idaho | Boise | 16015 | 922 | 11 | 0 | 43.98829931 | -115.7309284 | 2022-01-24 04:21:12 | Boise, Idaho, US | |
2022-01-22 | US | Idaho | Boise | 16015 | 922 | 11 | 0 | 43.98829931 | -115.7309284 | 2022-01-23 04:21:13 | Boise, Idaho, US | |
2022-01-19 | US | Colorado | Gilpin | 8047 | 922 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-01-20 04:21:07 | Gilpin, Colorado, US | |
2022-01-18 | US | Iowa | Ringgold | 19159 | 922 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-19 04:21:23 | Ringgold, Iowa, US | |
2022-01-17 | US | Texas | San Augustine | 48405 | 922 | 38 | 0 | 31.39457611 | -94.17000399 | 2022-01-18 04:21:04 | San Augustine, Texas, US | |
2022-01-17 | US | Pennsylvania | Sullivan | 42113 | 922 | 32 | 0 | 41.44634738 | -76.51246591 | 2022-01-18 04:21:04 | Sullivan, Pennsylvania, US | |
2022-01-17 | US | Nebraska | Fillmore | 31059 | 922 | 8 | 0 | 40.52458567 | -97.59646937 | 2022-01-18 04:21:04 | Fillmore, Nebraska, US | |
2022-01-17 | US | Iowa | Ringgold | 19159 | 922 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-18 04:21:04 | Ringgold, Iowa, US | |
2022-01-16 | US | Iowa | Ringgold | 19159 | 922 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-17 04:21:08 | Ringgold, Iowa, US | |
2022-01-15 | US | Iowa | Ringgold | 19159 | 922 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-16 04:21:12 | Ringgold, Iowa, US | |
2022-01-14 | US | Iowa | Ringgold | 19159 | 922 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-15 04:21:07 | Ringgold, Iowa, US | |
2022-01-13 | US | Iowa | Ringgold | 19159 | 922 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-14 04:21:54 | Ringgold, Iowa, US | |
2022-01-12 | US | Iowa | Ringgold | 19159 | 922 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-13 08:00:09 | Ringgold, Iowa, US | |
2022-01-11 | US | Alaska | Yukon-Koyukuk | 2290 | 922 | 8 | 0 | 65.50815459 | -151.39073869999999 | 2022-01-12 04:21:44 | Yukon-Koyukuk, Alaska, US | |
2022-01-10 | US | Alaska | Yukon-Koyukuk | 2290 | 922 | 8 | 0 | 65.50815459 | -151.39073869999999 | 2022-01-11 04:22:01 | Yukon-Koyukuk, Alaska, US | |
2022-01-02 | US | Washington | Skamania | 53059 | 922 | 9 | 0 | 46.02408726 | -121.91644029999999 | 2022-01-03 02:22:25 | Skamania, Washington, US | |
2022-01-01 | US | Washington | Skamania | 53059 | 922 | 9 | 0 | 46.02408726 | -121.91644029999999 | 2022-01-02 04:20:52 | Skamania, Washington, US | |
2021-12-31 | US | Washington | Skamania | 53059 | 922 | 9 | 0 | 46.02408726 | -121.91644029999999 | 2022-01-01 04:22:14 | Skamania, Washington, US | |
2021-12-30 | US | Washington | Skamania | 53059 | 922 | 9 | 0 | 46.02408726 | -121.91644029999999 | 2021-12-31 04:21:50 | Skamania, Washington, US | |
2021-12-21 | US | Colorado | Huerfano | 8055 | 922 | 27 | 0 | 37.68473101 | -104.9612585 | 2021-12-22 04:21:54 | Huerfano, Colorado, US | |
2021-12-16 | US | Kansas | Scott | 20171 | 922 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2021-12-17 04:22:14 | Scott, Kansas, US | |
2021-12-15 | US | Kansas | Scott | 20171 | 922 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2021-12-16 04:22:11 | Scott, Kansas, US | |
2021-12-14 | US | Puerto Rico | Comerio | 72045 | 922 | 0 | 0 | 18.224687 | -66.221622 | 2021-12-15 03:22:16 | Comerio, Puerto Rico, US | |
2021-12-06 | US | Kentucky | Menifee | 21165 | 922 | 25 | 0 | 37.94090733 | -83.59985712 | 2021-12-07 04:22:34 | Menifee, Kentucky, US | |
2021-12-01 | US | South Dakota | Tripp | 46123 | 922 | 21 | 0 | 43.34459388 | -99.8854891 | 2021-12-02 04:22:37 | Tripp, South Dakota, US | |
2021-12-01 | US | Colorado | Clear Creek | 8019 | 922 | 7 | 0 | 39.68864463 | -105.6463118 | 2021-12-02 04:22:37 | Clear Creek, Colorado, US | |
2021-11-29 | US | West Virginia | Wirt | 54105 | 922 | 16 | 0 | 39.02775007 | -81.37473928 | 2021-11-30 04:22:53 | Wirt, West Virginia, US | |
2021-11-28 | US | Puerto Rico | Aibonito | 72009 | 922 | 0 | 0 | 18.131361 | -66.264131 | 2021-11-29 04:22:30 | Aibonito, Puerto Rico, US | |
2021-11-27 | US | Puerto Rico | Aibonito | 72009 | 922 | 0 | 0 | 18.131361 | -66.264131 | 2021-11-28 04:22:43 | Aibonito, Puerto Rico, US | |
2021-11-26 | US | Puerto Rico | Aibonito | 72009 | 922 | 0 | 0 | 18.131361 | -66.264131 | 2021-11-27 04:22:45 | Aibonito, Puerto Rico, US | |
2021-11-24 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-25 04:22:33 | South Australia, Australia | |||
2021-11-23 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-24 04:22:14 | South Australia, Australia | |||
2021-11-22 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-23 04:22:39 | South Australia, Australia | |||
2021-11-21 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-22 04:22:20 | South Australia, Australia | |||
2021-11-20 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-21 04:22:13 | South Australia, Australia | |||
2021-11-19 | Australia | South Australia | 922 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-20 04:22:17 | South Australia, Australia | |||
2021-11-16 | US | Minnesota | Grant | 27051 | 922 | 9 | 0 | 45.93424769 | -96.01139609 | 2021-11-17 04:21:48 | Grant, Minnesota, US | |
2021-11-16 | US | Kansas | Republic | 20157 | 922 | 14 | 0 | 39.82799632 | -97.65036709 | 2021-11-17 04:21:48 | Republic, Kansas, US | |
2021-11-15 | US | Kansas | Republic | 20157 | 922 | 14 | 0 | 39.82799632 | -97.65036709 | 2021-11-16 04:21:10 | Republic, Kansas, US | |
2021-11-10 | US | Texas | Brewster | 48043 | 922 | 22 | 0 | 29.81008251 | -103.25203259999999 | 2021-11-11 04:21:45 | Brewster, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;