daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
99 rows where confirmed = 8722 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-19 | US | California | Siskiyou | 6093 | 8722 | 94 | 0 | 41.59198861 | -122.5407434 | 2022-12-20 04:21:04 | Siskiyou, California, US | |
2022-12-18 | US | California | Siskiyou | 6093 | 8722 | 94 | 0 | 41.59198861 | -122.5407434 | 2022-12-19 04:21:03 | Siskiyou, California, US | |
2022-12-17 | US | California | Siskiyou | 6093 | 8722 | 94 | 0 | 41.59198861 | -122.5407434 | 2022-12-18 04:21:03 | Siskiyou, California, US | |
2022-12-16 | US | California | Siskiyou | 6093 | 8722 | 94 | 0 | 41.59198861 | -122.5407434 | 2022-12-17 04:21:04 | Siskiyou, California, US | |
2022-12-15 | US | California | Siskiyou | 6093 | 8722 | 94 | 0 | 41.59198861 | -122.5407434 | 2022-12-16 04:21:01 | Siskiyou, California, US | |
2022-12-04 | US | Virginia | Isle of Wight | 51093 | 8722 | 125 | 0 | 36.90579348 | -76.70842863 | 2022-12-05 04:20:58 | Isle of Wight, Virginia, US | |
2022-12-04 | US | Kentucky | Ohio | 21183 | 8722 | 118 | 0 | 37.47751843 | -86.85368087 | 2022-12-05 04:20:58 | Ohio, Kentucky, US | |
2022-12-03 | US | Virginia | Isle of Wight | 51093 | 8722 | 125 | 0 | 36.90579348 | -76.70842863 | 2022-12-04 04:20:56 | Isle of Wight, Virginia, US | |
2022-12-03 | US | Kentucky | Ohio | 21183 | 8722 | 118 | 0 | 37.47751843 | -86.85368087 | 2022-12-04 04:20:56 | Ohio, Kentucky, US | |
2022-12-02 | US | Virginia | Isle of Wight | 51093 | 8722 | 125 | 0 | 36.90579348 | -76.70842863 | 2022-12-03 04:21:02 | Isle of Wight, Virginia, US | |
2022-12-02 | US | Kentucky | Ohio | 21183 | 8722 | 118 | 0 | 37.47751843 | -86.85368087 | 2022-12-03 04:21:02 | Ohio, Kentucky, US | |
2022-12-01 | US | Kentucky | Ohio | 21183 | 8722 | 118 | 0 | 37.47751843 | -86.85368087 | 2022-12-02 04:21:07 | Ohio, Kentucky, US | |
2022-11-30 | US | Kentucky | Ohio | 21183 | 8722 | 118 | 0 | 37.47751843 | -86.85368087 | 2022-12-01 04:21:03 | Ohio, Kentucky, US | |
2022-11-29 | US | Kentucky | Ohio | 21183 | 8722 | 118 | 0 | 37.47751843 | -86.85368087 | 2022-11-30 04:21:07 | Ohio, Kentucky, US | |
2022-11-28 | US | Kentucky | Ohio | 21183 | 8722 | 118 | 0 | 37.47751843 | -86.85368087 | 2022-11-29 04:21:05 | Ohio, Kentucky, US | |
2022-10-25 | US | Hawaii | Out of HI | 80015 | 8722 | 12 | 0 | 22.03935037 | 0.0 | 2022-10-26 04:22:19 | Out of HI, Hawaii, US | |
2022-10-24 | US | Hawaii | Out of HI | 80015 | 8722 | 12 | 0 | 22.03935037 | 0.0 | 2022-10-25 04:21:53 | Out of HI, Hawaii, US | |
2022-10-23 | US | Hawaii | Out of HI | 80015 | 8722 | 12 | 0 | 22.03935037 | 0.0 | 2022-10-24 04:22:29 | Out of HI, Hawaii, US | |
2022-10-22 | US | Hawaii | Out of HI | 80015 | 8722 | 12 | 0 | 22.03935037 | 0.0 | 2022-10-23 04:22:46 | Out of HI, Hawaii, US | |
2022-10-21 | US | Hawaii | Out of HI | 80015 | 8722 | 12 | 0 | 22.03935037 | 0.0 | 2022-10-22 04:22:53 | Out of HI, Hawaii, US | |
2022-10-20 | US | Hawaii | Out of HI | 80015 | 8722 | 12 | 0 | 22.03935037 | 0.0 | 2022-10-21 04:22:23 | Out of HI, Hawaii, US | |
2022-10-19 | US | Hawaii | Out of HI | 80015 | 8722 | 12 | 0 | 22.03935037 | 0.0 | 2022-10-20 04:22:59 | Out of HI, Hawaii, US | |
2022-09-26 | US | Tennessee | Lauderdale | 47097 | 8722 | 110 | 0 | 35.75893438 | -89.6301591 | 2022-09-27 04:23:01 | Lauderdale, Tennessee, US | |
2022-09-12 | US | Puerto Rico | Lares | 72081 | 8722 | 0 | 0 | 18.269035 | -66.867236 | 2022-09-13 04:20:57 | Lares, Puerto Rico, US | |
2022-08-31 | US | Texas | Polk | 48373 | 8722 | 255 | 0 | 30.79472531 | -94.8276624 | 2022-09-01 04:21:03 | Polk, Texas, US | |
2022-07-27 | US | Oregon | Malheur | 41045 | 8722 | 109 | 0 | 43.1937027 | -117.6227395 | 2022-07-28 04:20:56 | Malheur, Oregon, US | |
2022-06-30 | US | Tennessee | Macon | 47111 | 8722 | 146 | 0 | 36.53157855 | -86.00778595 | 2022-07-01 04:21:10 | Macon, Tennessee, US | |
2022-06-26 | US | Illinois | Bureau | 17011 | 8722 | 127 | 0 | 41.40385234 | -89.5283051 | 2022-06-27 04:21:00 | Bureau, Illinois, US | |
2022-06-25 | US | Illinois | Bureau | 17011 | 8722 | 127 | 0 | 41.40385234 | -89.5283051 | 2022-06-26 04:21:02 | Bureau, Illinois, US | |
2022-06-24 | US | Illinois | Bureau | 17011 | 8722 | 127 | 0 | 41.40385234 | -89.5283051 | 2022-06-25 04:20:57 | Bureau, Illinois, US | |
2022-05-17 | US | Michigan | Chippewa | 26033 | 8722 | 104 | 0 | 46.29552653 | -84.54353449 | 2022-05-18 04:20:50 | Chippewa, Michigan, US | |
2022-05-16 | US | Michigan | Chippewa | 26033 | 8722 | 104 | 0 | 46.29552653 | -84.54353449 | 2022-05-17 04:20:59 | Chippewa, Michigan, US | |
2022-05-15 | US | Michigan | Chippewa | 26033 | 8722 | 104 | 0 | 46.29552653 | -84.54353449 | 2022-05-16 04:20:47 | Chippewa, Michigan, US | |
2022-05-14 | US | Michigan | Chippewa | 26033 | 8722 | 104 | 0 | 46.29552653 | -84.54353449 | 2022-05-15 04:20:53 | Chippewa, Michigan, US | |
2022-05-13 | US | Michigan | Chippewa | 26033 | 8722 | 104 | 0 | 46.29552653 | -84.54353449 | 2022-05-14 04:20:48 | Chippewa, Michigan, US | |
2022-05-12 | US | Michigan | Chippewa | 26033 | 8722 | 104 | 0 | 46.29552653 | -84.54353449 | 2022-05-13 04:20:51 | Chippewa, Michigan, US | |
2022-05-11 | US | Michigan | Chippewa | 26033 | 8722 | 104 | 0 | 46.29552653 | -84.54353449 | 2022-05-12 04:20:54 | Chippewa, Michigan, US | |
2022-05-02 | US | Nebraska | Lincoln | 31111 | 8722 | 110 | 0 | 41.04658298 | -100.7475374 | 2022-05-03 04:21:00 | Lincoln, Nebraska, US | |
2022-05-01 | US | Nebraska | Lincoln | 31111 | 8722 | 110 | 0 | 41.04658298 | -100.7475374 | 2022-05-02 04:21:10 | Lincoln, Nebraska, US | |
2022-04-30 | US | Nebraska | Lincoln | 31111 | 8722 | 110 | 0 | 41.04658298 | -100.7475374 | 2022-05-01 04:20:57 | Lincoln, Nebraska, US | |
2022-04-28 | US | Texas | Erath | 48143 | 8722 | 123 | 0 | 32.23602653 | -98.21773417 | 2022-04-29 04:20:59 | Erath, Texas, US | |
2022-04-27 | US | Texas | Erath | 48143 | 8722 | 123 | 0 | 32.23602653 | -98.21773417 | 2022-04-28 04:20:47 | Erath, Texas, US | |
2022-03-10 | US | Illinois | Lee | 17103 | 8722 | 78 | 0 | 41.74583951 | -89.29977132 | 2022-03-11 04:20:50 | Lee, Illinois, US | |
2022-03-01 | US | Kentucky | Taylor | 21217 | 8722 | 113 | 0 | 37.3677562 | -85.3329931 | 2022-03-02 04:21:07 | Taylor, Kentucky, US | |
2022-02-16 | US | Tennessee | Claiborne | 47025 | 8722 | 158 | 0 | 36.48319149 | -83.65947309 | 2022-02-17 04:20:56 | Claiborne, Tennessee, US | |
2022-02-12 | US | Tennessee | Carroll | 47017 | 8722 | 136 | 0 | 35.97366108 | -88.45189331 | 2022-02-13 04:21:00 | Carroll, Tennessee, US | |
2022-01-31 | US | North Carolina | Bladen | 37017 | 8722 | 107 | 0 | 34.61296243 | -78.56180059 | 2022-02-01 04:21:11 | Bladen, North Carolina, US | |
2022-01-23 | US | Minnesota | Isanti | 27059 | 8722 | 103 | 0 | 45.56181234 | -93.29487636 | 2022-01-24 04:21:12 | Isanti, Minnesota, US | |
2022-01-22 | US | Minnesota | Isanti | 27059 | 8722 | 103 | 0 | 45.56181234 | -93.29487636 | 2022-01-23 04:21:13 | Isanti, Minnesota, US | |
2022-01-21 | US | Minnesota | Isanti | 27059 | 8722 | 103 | 0 | 45.56181234 | -93.29487636 | 2022-01-22 04:21:13 | Isanti, Minnesota, US | |
2022-01-02 | US | Tennessee | Dyer | 47045 | 8722 | 165 | 0 | 36.05931946 | -89.41542855 | 2022-01-03 02:22:25 | Dyer, Tennessee, US | |
2021-12-28 | US | Iowa | Cerro Gordo | 19033 | 8722 | 133 | 0 | 43.08177563 | -93.2612239 | 2021-12-29 03:21:43 | Cerro Gordo, Iowa, US | |
2021-12-27 | US | Iowa | Cerro Gordo | 19033 | 8722 | 133 | 0 | 43.08177563 | -93.2612239 | 2021-12-28 04:21:47 | Cerro Gordo, Iowa, US | |
2021-12-26 | US | Iowa | Cerro Gordo | 19033 | 8722 | 133 | 0 | 43.08177563 | -93.2612239 | 2021-12-27 04:21:58 | Cerro Gordo, Iowa, US | |
2021-12-25 | US | Iowa | Cerro Gordo | 19033 | 8722 | 133 | 0 | 43.08177563 | -93.2612239 | 2021-12-26 04:21:50 | Cerro Gordo, Iowa, US | |
2021-12-24 | US | Iowa | Cerro Gordo | 19033 | 8722 | 133 | 0 | 43.08177563 | -93.2612239 | 2021-12-25 04:21:37 | Cerro Gordo, Iowa, US | |
2021-12-23 | US | Iowa | Cerro Gordo | 19033 | 8722 | 133 | 0 | 43.08177563 | -93.2612239 | 2021-12-24 04:21:34 | Cerro Gordo, Iowa, US | |
2021-12-22 | US | Iowa | Cerro Gordo | 19033 | 8722 | 133 | 0 | 43.08177563 | -93.2612239 | 2021-12-23 04:21:21 | Cerro Gordo, Iowa, US | |
2021-12-09 | US | Wisconsin | Polk | 55095 | 8722 | 101 | 0 | 45.46130348 | -92.44182875 | 2021-12-10 04:22:28 | Polk, Wisconsin, US | |
2021-12-06 | US | Kentucky | Barren | 21009 | 8722 | 165 | 0 | 36.96469836 | -85.93338945 | 2021-12-07 04:22:34 | Barren, Kentucky, US | |
2021-10-24 | US | New York | Cayuga | 36011 | 8722 | 107 | 0 | 42.91261714 | -76.55731592 | 2021-10-25 04:22:31 | Cayuga, New York, US | |
2021-10-05 | US | Texas | Caldwell | 48055 | 8722 | 140 | 0 | 29.83668859 | -97.61814775 | 2021-10-06 04:21:33 | Caldwell, Texas, US | |
2021-10-03 | US | Louisiana | St. Charles | 22089 | 8722 | 122 | 0 | 29.90709658 | -90.35555967 | 2021-10-04 04:21:31 | St. Charles, Louisiana, US | |
2021-10-02 | US | Louisiana | St. Charles | 22089 | 8722 | 122 | 0 | 29.90709658 | -90.35555967 | 2021-10-03 04:21:24 | St. Charles, Louisiana, US | |
2021-10-01 | US | Louisiana | St. Charles | 22089 | 8722 | 122 | 0 | 29.90709658 | -90.35555967 | 2021-10-02 04:21:25 | St. Charles, Louisiana, US | |
2021-08-26 | US | Vermont | Chittenden | 50007 | 8722 | 111 | 0 | 44.46322849 | -73.08359212 | 2021-08-27 04:21:37 | Chittenden, Vermont, US | |
2021-08-26 | US | Maine | Androscoggin | 23001 | 8722 | 88 | 0 | 44.1664747 | -70.20380627 | 2021-08-27 04:21:37 | Androscoggin, Maine, US | |
2021-08-13 | US | Tennessee | Greene | 47059 | 8722 | 163 | 0 | 36.17470125 | -82.84691273 | 2021-08-14 04:21:25 | Greene, Tennessee, US | |
2021-08-04 | US | Virginia | Hanover | 51085 | 8722 | 168 | 0 | 37.7583355 | -77.49464673 | 2021-08-05 04:21:51 | Hanover, Virginia, US | |
2021-07-12 | US | Pennsylvania | Clearfield | 42033 | 8722 | 156 | 0 | 41.00110782 | -78.47592663 | 2021-07-13 04:21:18 | Clearfield, Pennsylvania, US | |
2021-07-06 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-07-07 04:21:20 | Lincoln, South Dakota, US | |
2021-07-05 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-07-06 04:21:32 | Lincoln, South Dakota, US | |
2021-07-04 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-07-05 04:21:28 | Lincoln, South Dakota, US | |
2021-07-03 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-07-04 04:21:38 | Lincoln, South Dakota, US | |
2021-07-02 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-07-03 04:21:37 | Lincoln, South Dakota, US | |
2021-07-01 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-07-02 04:21:47 | Lincoln, South Dakota, US | |
2021-06-30 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-07-01 04:21:19 | Lincoln, South Dakota, US | |
2021-06-29 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-06-30 04:21:41 | Lincoln, South Dakota, US | |
2021-06-28 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-06-29 04:21:28 | Lincoln, South Dakota, US | |
2021-06-27 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-06-28 04:21:29 | Lincoln, South Dakota, US | |
2021-06-26 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-06-27 04:21:39 | Lincoln, South Dakota, US | |
2021-06-25 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-06-26 04:21:43 | Lincoln, South Dakota, US | |
2021-06-24 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-06-25 04:21:33 | Lincoln, South Dakota, US | |
2021-06-23 | US | South Dakota | Lincoln | 46083 | 8722 | 78 | 0 | 43.27841182 | -96.7203905 | 2021-06-24 04:21:55 | Lincoln, South Dakota, US | |
2021-05-06 | US | Washington | Grant | 53025 | 8722 | 73 | 0 | 47.20753737 | -119.4500749 | 2021-05-07 04:20:40 | Grant, Washington, US | |
2021-04-20 | US | Virginia | Portsmouth | 51740 | 8722 | 185 | 0 | 36.85914825 | -76.35971629 | 2021-04-21 04:21:14 | Portsmouth, Virginia, US | |
2021-04-19 | US | Montana | Cascade | 30013 | 8722 | 166 | 0 | 47.30797024 | -111.3467922 | 2021-04-20 04:20:41 | Cascade, Montana, US | |
2021-04-19 | US | Missouri | Cape Girardeau | 29031 | 8722 | 134 | 0 | 37.38489388 | -89.6843587 | 2021-04-20 04:20:41 | Cape Girardeau, Missouri, US | |
2021-04-18 | US | Missouri | Cape Girardeau | 29031 | 8722 | 134 | 0 | 37.38489388 | -89.6843587 | 2021-04-19 04:20:57 | Cape Girardeau, Missouri, US | |
2021-04-17 | US | New Jersey | Cape May | 34009 | 8722 | 199 | 0 | 39.15008829 | -74.80170244 | 2021-04-18 04:20:41 | Cape May, New Jersey, US | |
2020-12-22 | Russia | Mari El Republic | 8722 | 113 | 7740 | 869 | 56.5767504 | 47.8817512 | 2020-12-23 05:22:03 | Mari El Republic, Russia | ||
2020-10-28 | Peru | Madre de Dios | 8722 | 145 | 0 | 8577 | -11.972699 | -70.53171999999998 | 2020-10-29 04:24:49 | Madre de Dios, Peru | ||
2020-10-25 | US | Nebraska | Lancaster | 31109 | 8722 | 43 | 0 | 8679 | 40.78416049 | -96.68777155 | 2020-10-26 04:25:02 | Lancaster, Nebraska, US |
2020-10-25 | Russia | Tver Oblast | 8722 | 302 | 5100 | 3320 | 57.1134475 | 35.174442799999994 | 2020-10-26 04:25:02 | Tver Oblast, Russia | ||
2020-10-24 | US | South Carolina | Lexington | 45063 | 8722 | 203 | 0 | 8519 | 33.89665987 | -81.27146426 | 2020-10-25 04:24:36 | Lexington, South Carolina, US |
2020-09-14 | US | Tennessee | Hamilton | 47065 | 8722 | 85 | 0 | 8775 | 35.17670231 | -85.16652245 | 2020-09-15 03:22:50 | Hamilton, Tennessee, US |
2020-07-03 | US | Massachusetts | Plymouth | 25023 | 8722 | 665 | 0 | 8057 | 41.94070556 | -70.80802823 | 2020-07-04 04:33:51 | Plymouth, Massachusetts, US |
2020-06-28 | Mexico | Baja California | 8722 | 1883 | 6236 | 603 | 30.8406 | -115.2838 | 2020-06-29 04:33:44 | Baja California, Mexico | ||
2020-05-29 | Brazil | Distrito Federal | 8722 | 154 | 0 | 8568 | -15.7998 | -47.8645 | 2020-05-30 02:32:48 | Distrito Federal, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;