daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
55 rows where confirmed = 14285 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-09-10 | US | New York | Washington | 36115 | 14285 | 126 | 0 | 43.31153794 | -73.43043448 | 2022-09-11 04:20:50 | Washington, New York, US | |
2022-09-07 | US | Oklahoma | Pontotoc | 40123 | 14285 | 158 | 0 | 34.72959848 | -96.68337199 | 2022-09-08 04:21:02 | Pontotoc, Oklahoma, US | |
2022-09-06 | US | Oklahoma | Pontotoc | 40123 | 14285 | 158 | 0 | 34.72959848 | -96.68337199 | 2022-09-07 04:20:59 | Pontotoc, Oklahoma, US | |
2022-09-05 | US | Oklahoma | Pontotoc | 40123 | 14285 | 158 | 0 | 34.72959848 | -96.68337199 | 2022-09-06 04:21:02 | Pontotoc, Oklahoma, US | |
2022-09-04 | US | Oklahoma | Pontotoc | 40123 | 14285 | 158 | 0 | 34.72959848 | -96.68337199 | 2022-09-05 04:21:01 | Pontotoc, Oklahoma, US | |
2022-09-03 | US | Oklahoma | Pontotoc | 40123 | 14285 | 158 | 0 | 34.72959848 | -96.68337199 | 2022-09-04 04:21:22 | Pontotoc, Oklahoma, US | |
2022-09-02 | US | Oklahoma | Pontotoc | 40123 | 14285 | 158 | 0 | 34.72959848 | -96.68337199 | 2022-09-03 04:21:04 | Pontotoc, Oklahoma, US | |
2022-09-01 | US | Oklahoma | Pontotoc | 40123 | 14285 | 158 | 0 | 34.72959848 | -96.68337199 | 2022-09-02 04:21:07 | Pontotoc, Oklahoma, US | |
2022-07-25 | US | New York | Fulton | 36035 | 14285 | 173 | 0 | 43.11363907 | -74.41798804 | 2022-07-26 04:20:58 | Fulton, New York, US | |
2022-06-26 | US | Wisconsin | Waupaca | 55135 | 14285 | 256 | 0 | 44.47068056 | -88.96534501 | 2022-06-27 04:21:00 | Waupaca, Wisconsin, US | |
2022-06-25 | US | Wisconsin | Waupaca | 55135 | 14285 | 256 | 0 | 44.47068056 | -88.96534501 | 2022-06-26 04:21:02 | Waupaca, Wisconsin, US | |
2022-06-24 | US | Wisconsin | Waupaca | 55135 | 14285 | 256 | 0 | 44.47068056 | -88.96534501 | 2022-06-25 04:20:57 | Waupaca, Wisconsin, US | |
2022-06-15 | US | Ohio | Sandusky | 39143 | 14285 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-16 04:20:55 | Sandusky, Ohio, US | |
2022-06-14 | US | Ohio | Sandusky | 39143 | 14285 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-15 04:20:54 | Sandusky, Ohio, US | |
2022-06-13 | US | Ohio | Sandusky | 39143 | 14285 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-14 04:20:52 | Sandusky, Ohio, US | |
2022-06-12 | US | Ohio | Sandusky | 39143 | 14285 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-13 04:21:14 | Sandusky, Ohio, US | |
2022-06-11 | US | Ohio | Sandusky | 39143 | 14285 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-12 04:20:53 | Sandusky, Ohio, US | |
2022-06-10 | US | Ohio | Sandusky | 39143 | 14285 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-11 04:21:01 | Sandusky, Ohio, US | |
2022-06-09 | US | Ohio | Sandusky | 39143 | 14285 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-10 04:20:55 | Sandusky, Ohio, US | |
2022-05-15 | US | Oregon | Klamath | 41035 | 14285 | 222 | 0 | 42.68762984 | -121.6496461 | 2022-05-16 04:20:47 | Klamath, Oregon, US | |
2022-05-15 | US | Illinois | Ogle | 17141 | 14285 | 128 | 0 | 42.04165196 | -89.32184679 | 2022-05-16 04:20:47 | Ogle, Illinois, US | |
2022-05-14 | US | Oregon | Klamath | 41035 | 14285 | 222 | 0 | 42.68762984 | -121.6496461 | 2022-05-15 04:20:53 | Klamath, Oregon, US | |
2022-05-14 | US | Illinois | Ogle | 17141 | 14285 | 128 | 0 | 42.04165196 | -89.32184679 | 2022-05-15 04:20:53 | Ogle, Illinois, US | |
2022-05-13 | US | Oregon | Klamath | 41035 | 14285 | 222 | 0 | 42.68762984 | -121.6496461 | 2022-05-14 04:20:48 | Klamath, Oregon, US | |
2022-05-13 | US | Illinois | Ogle | 17141 | 14285 | 128 | 0 | 42.04165196 | -89.32184679 | 2022-05-14 04:20:48 | Ogle, Illinois, US | |
2022-05-05 | US | Texas | Caldwell | 48055 | 14285 | 176 | 0 | 29.83668859 | -97.61814775 | 2022-05-06 04:21:00 | Caldwell, Texas, US | |
2022-05-01 | US | Colorado | Broomfield | 8014 | 14285 | 117 | 0 | 39.95998787 | -105.0566324 | 2022-05-02 04:21:10 | Broomfield, Colorado, US | |
2022-03-17 | US | Texas | Val Verde | 48465 | 14285 | 294 | 0 | 29.89149232 | -101.1525205 | 2022-03-18 04:20:55 | Val Verde, Texas, US | |
2022-03-16 | US | Texas | Val Verde | 48465 | 14285 | 293 | 0 | 29.89149232 | -101.1525205 | 2022-03-17 04:20:56 | Val Verde, Texas, US | |
2022-03-15 | US | Texas | Val Verde | 48465 | 14285 | 293 | 0 | 29.89149232 | -101.1525205 | 2022-03-16 04:20:50 | Val Verde, Texas, US | |
2022-02-27 | US | Ohio | Athens | 39009 | 14285 | 136 | 0 | 39.33425634 | -82.04278644 | 2022-02-28 04:21:05 | Athens, Ohio, US | |
2021-12-14 | US | Missouri | Christian | 29043 | 14285 | 202 | 0 | 36.9711783 | -93.18537118 | 2021-12-15 03:22:16 | Christian, Missouri, US | |
2021-12-13 | US | Pennsylvania | Crawford | 42039 | 14285 | 234 | 0 | 41.68447709 | -80.10760592 | 2021-12-14 04:22:38 | Crawford, Pennsylvania, US | |
2021-12-13 | US | Missouri | Christian | 29043 | 14285 | 202 | 0 | 36.9711783 | -93.18537118 | 2021-12-14 04:22:38 | Christian, Missouri, US | |
2021-09-23 | US | Kentucky | Madison | 21151 | 14285 | 127 | 0 | 37.71659336 | -84.27220275 | 2021-09-24 04:21:44 | Madison, Kentucky, US | |
2021-09-05 | US | Kentucky | Daviess | 21059 | 14285 | 218 | 0 | 37.73028906 | -87.09019479999998 | 2021-09-06 04:21:22 | Daviess, Kentucky, US | |
2021-07-13 | US | Texas | Taylor | 48441 | 14285 | 416 | 0 | 32.30163422 | -99.89007449 | 2021-07-14 04:21:35 | Taylor, Texas, US | |
2021-07-12 | US | Texas | Taylor | 48441 | 14285 | 416 | 0 | 32.30163422 | -99.89007449 | 2021-07-13 04:21:18 | Taylor, Texas, US | |
2021-07-11 | US | Texas | Taylor | 48441 | 14285 | 416 | 0 | 32.30163422 | -99.89007449 | 2021-07-12 04:21:34 | Taylor, Texas, US | |
2021-07-10 | US | Texas | Taylor | 48441 | 14285 | 416 | 0 | 32.30163422 | -99.89007449 | 2021-07-11 04:21:43 | Taylor, Texas, US | |
2021-07-10 | US | California | Shasta | 6089 | 14285 | 206 | 0 | 40.76391419 | -122.0396884 | 2021-07-11 04:21:43 | Shasta, California, US | |
2021-06-03 | US | Kentucky | Boone | 21015 | 14285 | 147 | 0 | 38.97065142 | -84.72615357 | 2021-06-04 04:23:37 | Boone, Kentucky, US | |
2021-05-20 | US | California | Marin | 6041 | 14285 | 227 | 0 | 38.07122463 | -122.7210631 | 2021-05-21 04:20:43 | Marin, California, US | |
2021-03-02 | Belgium | Unknown | 14285 | 22141 | 0 | 0 | 2021-03-03 05:23:28 | Unknown, Belgium | ||||
2021-02-23 | US | Texas | Smith | 48423 | 14285 | 389 | 0 | 18165 | 32.37474036 | -95.2717568 | 2021-02-24 05:29:16 | Smith, Texas, US |
2021-02-22 | US | Texas | Smith | 48423 | 14285 | 389 | 0 | 18165 | 32.37474036 | -95.2717568 | 2021-02-23 05:23:41 | Smith, Texas, US |
2021-02-21 | US | Texas | Smith | 48423 | 14285 | 388 | 0 | 18166 | 32.37474036 | -95.2717568 | 2021-02-22 05:24:21 | Smith, Texas, US |
2021-02-18 | US | North Carolina | Onslow | 37133 | 14285 | 131 | 0 | 14154 | 34.72607366 | -77.42908179 | 2021-02-19 05:24:16 | Onslow, North Carolina, US |
2021-01-11 | US | Missouri | Boone | 29019 | 14285 | 50 | 0 | 14235 | 38.99186229 | -92.30723575 | 2021-01-12 05:22:15 | Boone, Missouri, US |
2020-12-26 | Russia | Kalmykia Republic | 14285 | 194 | 11957 | 2134 | 46.2313018 | 45.3275745 | 2020-12-27 05:22:55 | Kalmykia Republic, Russia | ||
2020-11-28 | Russia | Karelia Republic | 14285 | 99 | 8287 | 5899 | 62.61940309999999 | 33.4920267 | 2020-11-29 05:25:55 | Karelia Republic, Russia | ||
2020-11-28 | Namibia | 14285 | 150 | 13412 | 723 | -22.9576 | 18.4904 | 2020-11-29 05:25:55 | Namibia | |||
2020-11-22 | US | Florida | Leon | 12073 | 14285 | 128 | 0 | 14157 | 30.45955727 | -84.27491114 | 2020-11-23 05:25:26 | Leon, Florida, US |
2020-11-09 | Sri Lanka | 14285 | 36 | 8880 | 5369 | 7.873054 | 80.77179699999998 | 2020-11-10 05:40:07 | Sri Lanka | |||
2020-06-01 | Brazil | Espirito Santo | 14285 | 628 | 0 | 13455 | -19.1834 | -40.3089 | 2020-06-02 02:33:08 | Espirito Santo, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;