daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
197 rows where confirmed = 3100 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-12 | US | North Dakota | McLean | 38055 | 3100 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-12-13 04:21:01 | McLean, North Dakota, US | |
2022-12-12 | US | Missouri | Ripley | 29181 | 3100 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-13 04:21:01 | Ripley, Missouri, US | |
2022-12-11 | US | Missouri | Ripley | 29181 | 3100 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-12 04:21:01 | Ripley, Missouri, US | |
2022-12-10 | US | Missouri | Ripley | 29181 | 3100 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-11 04:20:50 | Ripley, Missouri, US | |
2022-12-09 | US | Missouri | Ripley | 29181 | 3100 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-10 04:21:02 | Ripley, Missouri, US | |
2022-12-08 | US | Missouri | Ripley | 29181 | 3100 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-09 04:21:05 | Ripley, Missouri, US | |
2022-12-07 | US | Missouri | Ripley | 29181 | 3100 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-08 04:21:07 | Ripley, Missouri, US | |
2022-12-06 | US | Missouri | Ripley | 29181 | 3100 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-07 04:20:58 | Ripley, Missouri, US | |
2022-11-21 | US | Illinois | Jasper | 17079 | 3100 | 32 | 0 | 39.01054275 | -88.15437049 | 2022-11-22 04:20:47 | Jasper, Illinois, US | |
2022-10-11 | US | Iowa | Allamakee | 19005 | 3100 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-12 04:22:51 | Allamakee, Iowa, US | |
2022-10-10 | US | Iowa | Allamakee | 19005 | 3100 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-11 04:23:05 | Allamakee, Iowa, US | |
2022-10-09 | US | Iowa | Allamakee | 19005 | 3100 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-10 04:22:32 | Allamakee, Iowa, US | |
2022-10-08 | US | Iowa | Allamakee | 19005 | 3100 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-09 04:21:16 | Allamakee, Iowa, US | |
2022-10-07 | US | Iowa | Allamakee | 19005 | 3100 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-08 04:22:56 | Allamakee, Iowa, US | |
2022-10-06 | US | Iowa | Allamakee | 19005 | 3100 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-07 04:23:08 | Allamakee, Iowa, US | |
2022-10-05 | US | Iowa | Allamakee | 19005 | 3100 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-06 04:21:22 | Allamakee, Iowa, US | |
2022-09-13 | US | Wisconsin | Forest | 55041 | 3100 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-09-14 04:20:44 | Forest, Wisconsin, US | |
2022-09-11 | US | Texas | Ward | 48475 | 3100 | 48 | 0 | 31.50999644 | -103.0927909 | 2022-09-12 04:20:58 | Ward, Texas, US | |
2022-09-10 | US | Texas | Ward | 48475 | 3100 | 48 | 0 | 31.50999644 | -103.0927909 | 2022-09-11 04:20:50 | Ward, Texas, US | |
2022-09-09 | US | Texas | Ward | 48475 | 3100 | 48 | 0 | 31.50999644 | -103.0927909 | 2022-09-10 04:21:10 | Ward, Texas, US | |
2022-08-30 | US | Michigan | Iron | 26071 | 3100 | 88 | 0 | 46.20974132 | -88.53136251 | 2022-08-31 04:20:57 | Iron, Michigan, US | |
2022-08-29 | US | Michigan | Iron | 26071 | 3100 | 88 | 0 | 46.20974132 | -88.53136251 | 2022-08-30 04:21:03 | Iron, Michigan, US | |
2022-08-28 | US | Michigan | Iron | 26071 | 3100 | 88 | 0 | 46.20974132 | -88.53136251 | 2022-08-29 04:21:06 | Iron, Michigan, US | |
2022-08-27 | US | Michigan | Iron | 26071 | 3100 | 88 | 0 | 46.20974132 | -88.53136251 | 2022-08-28 04:21:02 | Iron, Michigan, US | |
2022-08-26 | US | Michigan | Iron | 26071 | 3100 | 88 | 0 | 46.20974132 | -88.53136251 | 2022-08-27 04:20:57 | Iron, Michigan, US | |
2022-08-25 | US | Michigan | Iron | 26071 | 3100 | 88 | 0 | 46.20974132 | -88.53136251 | 2022-08-26 04:21:02 | Iron, Michigan, US | |
2022-08-24 | US | Michigan | Iron | 26071 | 3100 | 88 | 0 | 46.20974132 | -88.53136251 | 2022-08-25 04:21:13 | Iron, Michigan, US | |
2022-08-23 | US | Michigan | Iron | 26071 | 3100 | 88 | 0 | 46.20974132 | -88.53136251 | 2022-08-24 04:20:46 | Iron, Michigan, US | |
2022-07-18 | US | Texas | Callahan | 48059 | 3100 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-07-19 04:20:58 | Callahan, Texas, US | |
2022-05-31 | US | Minnesota | Aitkin | 27001 | 3100 | 62 | 0 | 46.60962049 | -93.4116826 | 2022-06-01 04:20:55 | Aitkin, Minnesota, US | |
2022-05-21 | US | New Jersey | Unassigned | 90034 | 3100 | 0 | 0 | 41.13891592 | 0.0 | 2022-05-22 04:20:52 | Unassigned, New Jersey, US | |
2022-05-20 | US | New Jersey | Unassigned | 90034 | 3100 | 0 | 0 | 41.13891592 | 0.0 | 2022-05-21 04:20:58 | Unassigned, New Jersey, US | |
2022-05-15 | US | Colorado | Moffat | 8081 | 3100 | 52 | 0 | 40.61810999 | -108.2070876 | 2022-05-16 04:20:47 | Moffat, Colorado, US | |
2022-02-10 | US | Minnesota | Cottonwood | 27033 | 3100 | 39 | 0 | 44.00715262 | -95.18138802 | 2022-02-11 04:21:09 | Cottonwood, Minnesota, US | |
2022-02-09 | US | Missouri | Osage | 29151 | 3100 | 39 | 0 | 38.46036182 | -91.8613635 | 2022-02-10 04:21:14 | Osage, Missouri, US | |
2022-01-29 | US | Vermont | Lamoille | 50015 | 3100 | 12 | 0 | 44.60353043 | -72.64356694 | 2022-01-30 04:21:26 | Lamoille, Vermont, US | |
2022-01-18 | US | Virginia | King William | 51101 | 3100 | 27 | 0 | 37.70965316 | -77.09384941 | 2022-01-19 04:21:23 | King William, Virginia, US | |
2022-01-10 | US | Puerto Rico | Camuy | 72027 | 3100 | 0 | 0 | 18.418578 | -66.860206 | 2022-01-11 04:22:01 | Camuy, Puerto Rico, US | |
2022-01-02 | US | Indiana | Vermillion | 18165 | 3100 | 61 | 0 | 39.8523352 | -87.46160542 | 2022-01-03 02:22:25 | Vermillion, Indiana, US | |
2022-01-01 | US | Texas | Young | 48503 | 3100 | 74 | 0 | 33.17659707 | -98.68790885 | 2022-01-02 04:20:52 | Young, Texas, US | |
2022-01-01 | US | Indiana | Vermillion | 18165 | 3100 | 61 | 0 | 39.8523352 | -87.46160542 | 2022-01-02 04:20:52 | Vermillion, Indiana, US | |
2021-12-31 | US | Indiana | Vermillion | 18165 | 3100 | 61 | 0 | 39.8523352 | -87.46160542 | 2022-01-01 04:22:14 | Vermillion, Indiana, US | |
2021-12-31 | US | Colorado | Chaffee | 8015 | 3100 | 38 | 0 | 38.74745778 | -106.19265729999998 | 2022-01-01 04:22:14 | Chaffee, Colorado, US | |
2021-12-30 | US | Indiana | Vermillion | 18165 | 3100 | 61 | 0 | 39.8523352 | -87.46160542 | 2021-12-31 04:21:50 | Vermillion, Indiana, US | |
2021-12-28 | US | Pennsylvania | Fulton | 42057 | 3100 | 45 | 0 | 39.92913544 | -78.11163677 | 2021-12-29 03:21:43 | Fulton, Pennsylvania, US | |
2021-12-22 | US | Texas | Shelby | 48419 | 3100 | 114 | 0 | 31.79211404 | -94.14550696 | 2021-12-23 04:21:21 | Shelby, Texas, US | |
2021-12-21 | US | Georgia | Meriwether | 13199 | 3100 | 121 | 0 | 33.04163534 | -84.68859732 | 2021-12-22 04:21:54 | Meriwether, Georgia, US | |
2021-12-18 | US | Kentucky | Lawrence | 21127 | 3100 | 47 | 0 | 38.07136018 | -82.72882223 | 2021-12-19 04:21:11 | Lawrence, Kentucky, US | |
2021-12-16 | US | Indiana | Franklin | 18047 | 3100 | 45 | 0 | 39.4142482 | -85.06062647 | 2021-12-17 04:22:14 | Franklin, Indiana, US | |
2021-12-10 | US | Vermont | Windham | 50025 | 3100 | 27 | 0 | 42.986982 | -72.71268875 | 2021-12-11 04:22:45 | Windham, Vermont, US | |
2021-12-07 | US | Kansas | Neosho | 20133 | 3100 | 54 | 0 | 37.55862897 | -95.30670046 | 2021-12-08 04:22:46 | Neosho, Kansas, US | |
2021-12-06 | US | Virginia | Radford | 51750 | 3100 | 36 | 0 | 37.12222899 | -80.56027320000003 | 2021-12-07 04:22:34 | Radford, Virginia, US | |
2021-12-06 | US | Kansas | Neosho | 20133 | 3100 | 54 | 0 | 37.55862897 | -95.30670046 | 2021-12-07 04:22:34 | Neosho, Kansas, US | |
2021-11-29 | US | Kentucky | Spencer | 21215 | 3100 | 40 | 0 | 38.03223971 | -85.32749335 | 2021-11-30 04:22:53 | Spencer, Kentucky, US | |
2021-11-21 | US | Ohio | Paulding | 39125 | 3100 | 51 | 0 | 41.11676341 | -84.5801017 | 2021-11-22 04:22:20 | Paulding, Ohio, US | |
2021-11-16 | US | South Carolina | Hampton | 45049 | 3100 | 74 | 0 | 32.77419582 | -81.13845571 | 2021-11-17 04:21:48 | Hampton, South Carolina, US | |
2021-11-16 | US | Missouri | Texas | 29215 | 3100 | 43 | 0 | 37.31728859 | -91.96564727 | 2021-11-17 04:21:48 | Texas, Missouri, US | |
2021-11-15 | US | South Carolina | Hampton | 45049 | 3100 | 74 | 0 | 32.77419582 | -81.13845571 | 2021-11-16 04:21:10 | Hampton, South Carolina, US | |
2021-11-09 | US | Mississippi | Clay | 28025 | 3100 | 77 | 0 | 33.65358105 | -88.77784255 | 2021-11-10 04:21:38 | Clay, Mississippi, US | |
2021-11-08 | US | Mississippi | Clay | 28025 | 3100 | 77 | 0 | 33.65358105 | -88.77784255 | 2021-11-09 04:21:36 | Clay, Mississippi, US | |
2021-10-31 | US | Oklahoma | Unassigned | 90040 | 3100 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-01 04:22:01 | Unassigned, Oklahoma, US | |
2021-10-30 | US | Oklahoma | Unassigned | 90040 | 3100 | 0 | 0 | 36.83532655 | 0.0 | 2021-10-31 04:22:08 | Unassigned, Oklahoma, US | |
2021-10-29 | US | Oklahoma | Unassigned | 90040 | 3100 | 0 | 0 | 36.83532655 | 0.0 | 2021-10-30 04:22:03 | Unassigned, Oklahoma, US | |
2021-10-21 | US | Virginia | Dinwiddie | 51053 | 3100 | 51 | 0 | 37.07544585 | -77.63451754 | 2021-10-22 04:21:14 | Dinwiddie, Virginia, US | |
2021-10-12 | US | Ohio | Wyandot | 39175 | 3100 | 65 | 0 | 40.84339621 | -83.30734173 | 2021-10-13 04:20:51 | Wyandot, Ohio, US | |
2021-10-07 | US | Tennessee | Humphreys | 47085 | 3100 | 44 | 0 | 36.03958805 | -87.77992872 | 2021-10-08 04:21:25 | Humphreys, Tennessee, US | |
2021-10-06 | US | Arkansas | Conway | 5029 | 3100 | 42 | 0 | 35.26205537 | -92.70506566 | 2021-10-07 04:21:36 | Conway, Arkansas, US | |
2021-09-27 | US | Louisiana | Concordia | 22029 | 3100 | 74 | 0 | 31.44817835 | -91.63814433 | 2021-09-28 04:21:28 | Concordia, Louisiana, US | |
2021-09-22 | US | North Carolina | Ashe | 37009 | 3100 | 46 | 0 | 36.43296207 | -81.49862729 | 2021-09-23 04:21:43 | Ashe, North Carolina, US | |
2021-09-22 | US | Georgia | Washington | 13303 | 3100 | 103 | 0 | 32.96711864 | -82.79357039 | 2021-09-23 04:21:43 | Washington, Georgia, US | |
2021-09-17 | US | Colorado | Morgan | 8087 | 3100 | 99 | 0 | 40.26279810000001 | -103.8093302 | 2021-09-18 04:21:24 | Morgan, Colorado, US | |
2021-09-07 | US | Wisconsin | Door | 55029 | 3100 | 37 | 0 | 44.95856458 | -87.30002707 | 2021-09-08 04:21:31 | Door, Wisconsin, US | |
2021-09-07 | China | Guangdong | 3100 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-08 04:21:31 | Guangdong, China | |||
2021-09-04 | US | Ohio | Coshocton | 39031 | 3100 | 66 | 0 | 40.30096166 | -81.91729018 | 2021-09-05 04:21:33 | Coshocton, Ohio, US | |
2021-09-02 | US | Alabama | Barbour | 1005 | 3100 | 65 | 0 | 31.868263 | -85.3871286 | 2021-09-03 04:21:20 | Barbour, Alabama, US | |
2021-08-28 | US | Arkansas | Cleburne | 5023 | 3100 | 81 | 0 | 35.53864922 | -92.02640019 | 2021-08-29 04:21:14 | Cleburne, Arkansas, US | |
2021-08-23 | US | West Virginia | Preston | 54077 | 3100 | 48 | 0 | 39.46770987 | -79.66712803 | 2021-08-24 04:21:19 | Preston, West Virginia, US | |
2021-08-22 | US | Virginia | Winchester | 51840 | 3100 | 49 | 0 | 39.17054517 | -78.17325058 | 2021-08-23 04:21:27 | Winchester, Virginia, US | |
2021-08-21 | US | Virginia | Winchester | 51840 | 3100 | 49 | 0 | 39.17054517 | -78.17325058 | 2021-08-22 04:21:29 | Winchester, Virginia, US | |
2021-08-20 | US | Virginia | Winchester | 51840 | 3100 | 49 | 0 | 39.17054517 | -78.17325058 | 2021-08-21 04:21:38 | Winchester, Virginia, US | |
2021-08-19 | US | Louisiana | Assumption | 22007 | 3100 | 40 | 0 | 29.89946234 | -91.06461642 | 2021-08-20 04:21:33 | Assumption, Louisiana, US | |
2021-08-17 | US | Minnesota | Le Sueur | 27079 | 3100 | 28 | 0 | 44.37136597 | -93.72844721 | 2021-08-18 04:21:35 | Le Sueur, Minnesota, US | |
2021-08-10 | US | Kansas | Labette | 20099 | 3100 | 51 | 0 | 37.19113093 | -95.29849679 | 2021-08-11 04:21:58 | Labette, Kansas, US | |
2021-08-09 | US | Texas | Fayette | 48149 | 3100 | 70 | 0 | 29.87788372 | -96.92076062 | 2021-08-10 04:21:27 | Fayette, Texas, US | |
2021-08-09 | US | Tennessee | Wayne | 47181 | 3100 | 36 | 0 | 35.23868267 | -87.78644456 | 2021-08-10 04:21:27 | Wayne, Tennessee, US | |
2021-08-09 | US | Kansas | Labette | 20099 | 3100 | 51 | 0 | 37.19113093 | -95.29849679 | 2021-08-10 04:21:27 | Labette, Kansas, US | |
2021-08-08 | US | Kentucky | Montgomery | 21173 | 3100 | 30 | 0 | 38.03253032 | -83.9145241 | 2021-08-09 04:21:24 | Montgomery, Kentucky, US | |
2021-08-03 | US | Minnesota | Brown | 27015 | 3100 | 40 | 0 | 44.24205652 | -94.72562874 | 2021-08-04 04:21:25 | Brown, Minnesota, US | |
2021-07-28 | US | Georgia | Decatur | 13087 | 3100 | 75 | 0 | 30.87967778 | -84.57619536 | 2021-07-29 04:21:33 | Decatur, Georgia, US | |
2021-07-19 | US | Louisiana | West Baton Rouge | 22121 | 3100 | 63 | 0 | 30.46058217 | -91.30989571 | 2021-07-20 04:21:48 | West Baton Rouge, Louisiana, US | |
2021-07-19 | US | Colorado | Delta | 8029 | 3100 | 71 | 0 | 38.86246243 | -107.8631342 | 2021-07-20 04:21:48 | Delta, Colorado, US | |
2021-07-09 | Japan | Miyazaki | 3100 | 27 | 3048 | 25 | 32.193203999999994 | 131.299374 | 2021-07-10 04:21:25 | Miyazaki, Japan | ||
2021-07-08 | Japan | Miyazaki | 3100 | 27 | 3046 | 27 | 32.193203999999994 | 131.299374 | 2021-07-09 04:21:21 | Miyazaki, Japan | ||
2021-06-22 | US | Georgia | Dawson | 13085 | 3100 | 50 | 0 | 34.44244079 | -84.16964071 | 2021-06-23 04:21:46 | Dawson, Georgia, US | |
2021-06-21 | US | Georgia | Dawson | 13085 | 3100 | 50 | 0 | 34.44244079 | -84.16964071 | 2021-06-22 04:21:34 | Dawson, Georgia, US | |
2021-06-20 | US | Georgia | Dawson | 13085 | 3100 | 50 | 0 | 34.44244079 | -84.16964071 | 2021-06-21 04:21:41 | Dawson, Georgia, US | |
2021-06-13 | US | Tennessee | Overton | 47133 | 3100 | 62 | 0 | 36.34117832 | -85.28989535 | 2021-06-14 04:22:46 | Overton, Tennessee, US | |
2021-06-12 | US | Tennessee | Overton | 47133 | 3100 | 62 | 0 | 36.34117832 | -85.28989535 | 2021-06-13 04:22:44 | Overton, Tennessee, US | |
2021-06-11 | US | Tennessee | Overton | 47133 | 3100 | 61 | 0 | 36.34117832 | -85.28989535 | 2021-06-12 04:22:22 | Overton, Tennessee, US | |
2021-06-09 | US | Georgia | Dawson | 13085 | 3100 | 49 | 0 | 34.44244079 | -84.16964071 | 2021-06-10 04:23:17 | Dawson, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;