daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
265 rows where confirmed = 2936 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-27 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-28 04:21:04 | Thomas, Kansas, US | |
2022-12-26 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-27 04:21:07 | Thomas, Kansas, US | |
2022-12-25 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-26 04:21:06 | Thomas, Kansas, US | |
2022-12-24 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-25 04:21:04 | Thomas, Kansas, US | |
2022-12-23 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-24 04:21:02 | Thomas, Kansas, US | |
2022-12-22 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-23 04:21:04 | Thomas, Kansas, US | |
2022-12-21 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-22 04:20:56 | Thomas, Kansas, US | |
2022-12-17 | US | Arkansas | Perry | 5105 | 2936 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-18 04:21:03 | Perry, Arkansas, US | |
2022-11-29 | US | Indiana | Crawford | 18025 | 2936 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-11-30 04:21:07 | Crawford, Indiana, US | |
2022-11-28 | US | Indiana | Crawford | 18025 | 2936 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-11-29 04:21:05 | Crawford, Indiana, US | |
2022-11-27 | US | Indiana | Crawford | 18025 | 2936 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-11-28 04:21:02 | Crawford, Indiana, US | |
2022-11-26 | US | Indiana | Crawford | 18025 | 2936 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-11-27 04:21:05 | Crawford, Indiana, US | |
2022-11-25 | US | Indiana | Crawford | 18025 | 2936 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-11-26 04:21:11 | Crawford, Indiana, US | |
2022-11-24 | US | Indiana | Crawford | 18025 | 2936 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-11-25 04:21:06 | Crawford, Indiana, US | |
2022-11-23 | US | Indiana | Crawford | 18025 | 2936 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-11-24 04:21:09 | Crawford, Indiana, US | |
2022-11-09 | US | Minnesota | Yellow Medicine | 27173 | 2936 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-11-10 04:21:16 | Yellow Medicine, Minnesota, US | |
2022-11-08 | US | Minnesota | Yellow Medicine | 27173 | 2936 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-11-09 04:21:22 | Yellow Medicine, Minnesota, US | |
2022-11-08 | US | Iowa | Humboldt | 19091 | 2936 | 41 | 0 | 42.7764426 | -94.20722537 | 2022-11-09 04:21:22 | Humboldt, Iowa, US | |
2022-11-07 | US | Minnesota | Yellow Medicine | 27173 | 2936 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-11-08 04:21:21 | Yellow Medicine, Minnesota, US | |
2022-11-07 | US | Iowa | Humboldt | 19091 | 2936 | 41 | 0 | 42.7764426 | -94.20722537 | 2022-11-08 04:21:21 | Humboldt, Iowa, US | |
2022-11-06 | US | Minnesota | Yellow Medicine | 27173 | 2936 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-11-07 04:21:26 | Yellow Medicine, Minnesota, US | |
2022-11-06 | US | Iowa | Humboldt | 19091 | 2936 | 41 | 0 | 42.7764426 | -94.20722537 | 2022-11-07 04:21:26 | Humboldt, Iowa, US | |
2022-11-05 | US | Minnesota | Yellow Medicine | 27173 | 2936 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-11-06 04:21:24 | Yellow Medicine, Minnesota, US | |
2022-11-05 | US | Iowa | Humboldt | 19091 | 2936 | 41 | 0 | 42.7764426 | -94.20722537 | 2022-11-06 04:21:24 | Humboldt, Iowa, US | |
2022-11-04 | US | Minnesota | Yellow Medicine | 27173 | 2936 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-11-05 04:21:52 | Yellow Medicine, Minnesota, US | |
2022-11-04 | US | Iowa | Humboldt | 19091 | 2936 | 41 | 0 | 42.7764426 | -94.20722537 | 2022-11-05 04:21:52 | Humboldt, Iowa, US | |
2022-11-03 | US | Minnesota | Yellow Medicine | 27173 | 2936 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-11-04 04:22:11 | Yellow Medicine, Minnesota, US | |
2022-11-03 | US | Iowa | Humboldt | 19091 | 2936 | 41 | 0 | 42.7764426 | -94.20722537 | 2022-11-04 04:22:11 | Humboldt, Iowa, US | |
2022-11-02 | US | Puerto Rico | Maunabo | 72095 | 2936 | 0 | 0 | 18.017889 | -65.922235 | 2022-11-03 04:22:05 | Maunabo, Puerto Rico, US | |
2022-11-02 | US | Iowa | Humboldt | 19091 | 2936 | 41 | 0 | 42.7764426 | -94.20722537 | 2022-11-03 04:22:05 | Humboldt, Iowa, US | |
2022-10-08 | US | Connecticut | Unassigned | 90009 | 2936 | 8 | 0 | 41.85853803 | 0.0 | 2022-10-09 04:21:16 | Unassigned, Connecticut, US | |
2022-09-28 | US | Colorado | Prowers | 8099 | 2936 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-09-29 04:22:34 | Prowers, Colorado, US | |
2022-09-20 | US | Iowa | Lyon | 19119 | 2936 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-09-21 04:23:22 | Lyon, Iowa, US | |
2022-09-19 | US | Iowa | Lyon | 19119 | 2936 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-09-20 04:22:48 | Lyon, Iowa, US | |
2022-09-18 | US | Iowa | Lyon | 19119 | 2936 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-09-19 04:21:49 | Lyon, Iowa, US | |
2022-09-17 | US | Iowa | Lyon | 19119 | 2936 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-09-18 04:22:50 | Lyon, Iowa, US | |
2022-09-16 | US | Iowa | Lyon | 19119 | 2936 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-09-17 04:20:19 | Lyon, Iowa, US | |
2022-09-15 | US | Iowa | Lyon | 19119 | 2936 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-09-16 04:21:19 | Lyon, Iowa, US | |
2022-09-14 | US | Iowa | Lyon | 19119 | 2936 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-09-15 04:21:02 | Lyon, Iowa, US | |
2022-09-13 | US | Idaho | Valley | 16085 | 2936 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-09-14 04:20:44 | Valley, Idaho, US | |
2022-09-12 | US | Idaho | Valley | 16085 | 2936 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-09-13 04:20:57 | Valley, Idaho, US | |
2022-08-30 | US | Georgia | Turner | 13287 | 2936 | 63 | 0 | 31.71612656 | -83.62069378 | 2022-08-31 04:20:57 | Turner, Georgia, US | |
2022-08-29 | US | Georgia | Turner | 13287 | 2936 | 63 | 0 | 31.71612656 | -83.62069378 | 2022-08-30 04:21:03 | Turner, Georgia, US | |
2022-08-28 | US | Louisiana | Catahoula | 22025 | 2936 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-08-29 04:21:06 | Catahoula, Louisiana, US | |
2022-08-28 | US | Georgia | Turner | 13287 | 2936 | 63 | 0 | 31.71612656 | -83.62069378 | 2022-08-29 04:21:06 | Turner, Georgia, US | |
2022-08-27 | US | Louisiana | Catahoula | 22025 | 2936 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-08-28 04:21:02 | Catahoula, Louisiana, US | |
2022-08-27 | US | Georgia | Turner | 13287 | 2936 | 63 | 0 | 31.71612656 | -83.62069378 | 2022-08-28 04:21:02 | Turner, Georgia, US | |
2022-08-26 | US | Louisiana | Catahoula | 22025 | 2936 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-08-27 04:20:57 | Catahoula, Louisiana, US | |
2022-08-26 | US | Georgia | Turner | 13287 | 2936 | 63 | 0 | 31.71612656 | -83.62069378 | 2022-08-27 04:20:57 | Turner, Georgia, US | |
2022-08-25 | US | Georgia | Turner | 13287 | 2936 | 63 | 0 | 31.71612656 | -83.62069378 | 2022-08-26 04:21:02 | Turner, Georgia, US | |
2022-08-24 | US | Georgia | Turner | 13287 | 2936 | 63 | 0 | 31.71612656 | -83.62069378 | 2022-08-25 04:21:13 | Turner, Georgia, US | |
2022-08-10 | US | Texas | Trinity | 48455 | 2936 | 73 | 0 | 31.0879489 | -95.1367187 | 2022-08-11 04:20:49 | Trinity, Texas, US | |
2022-08-09 | US | Virginia | Falls Church | 51610 | 2936 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-08-10 04:20:57 | Falls Church, Virginia, US | |
2022-07-26 | US | Wisconsin | Forest | 55041 | 2936 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-07-27 04:21:04 | Forest, Wisconsin, US | |
2022-07-25 | US | Virginia | Amelia | 51007 | 2936 | 59 | 0 | 37.34081025 | -77.98584649 | 2022-07-26 04:20:58 | Amelia, Virginia, US | |
2022-07-05 | US | Texas | Camp | 48063 | 2936 | 75 | 0 | 32.97195142 | -94.97790104 | 2022-07-06 04:20:58 | Camp, Texas, US | |
2022-06-28 | US | Iowa | Hancock | 19081 | 2936 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-29 04:20:59 | Hancock, Iowa, US | |
2022-06-27 | US | Iowa | Hancock | 19081 | 2936 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-28 04:20:58 | Hancock, Iowa, US | |
2022-06-26 | US | Iowa | Hancock | 19081 | 2936 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-27 04:21:00 | Hancock, Iowa, US | |
2022-06-25 | US | Iowa | Hancock | 19081 | 2936 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-26 04:21:02 | Hancock, Iowa, US | |
2022-06-24 | US | Iowa | Hancock | 19081 | 2936 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-25 04:20:57 | Hancock, Iowa, US | |
2022-06-23 | US | Iowa | Hancock | 19081 | 2936 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-24 04:20:58 | Hancock, Iowa, US | |
2022-06-22 | US | Iowa | Hancock | 19081 | 2936 | 48 | 0 | 43.08178477 | -93.73454884 | 2022-06-23 04:20:55 | Hancock, Iowa, US | |
2022-06-22 | US | Alabama | Wilcox | 1131 | 2936 | 46 | 0 | 31.98773215 | -87.30891118 | 2022-06-23 04:20:55 | Wilcox, Alabama, US | |
2022-06-09 | US | Arkansas | Lee | 5077 | 2936 | 59 | 0 | 34.78498904 | -90.78383866 | 2022-06-10 04:20:55 | Lee, Arkansas, US | |
2022-05-19 | US | Missouri | Cedar | 29039 | 2936 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-20 04:20:57 | Cedar, Missouri, US | |
2022-05-18 | US | Missouri | Cedar | 29039 | 2936 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-19 04:20:54 | Cedar, Missouri, US | |
2022-05-17 | US | Missouri | Cedar | 29039 | 2936 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-18 04:20:50 | Cedar, Missouri, US | |
2022-05-16 | US | Missouri | Cedar | 29039 | 2936 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-17 04:20:59 | Cedar, Missouri, US | |
2022-05-15 | US | Missouri | Cedar | 29039 | 2936 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-16 04:20:47 | Cedar, Missouri, US | |
2022-05-14 | US | Missouri | Cedar | 29039 | 2936 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-15 04:20:53 | Cedar, Missouri, US | |
2022-05-13 | US | Missouri | Cedar | 29039 | 2936 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-14 04:20:48 | Cedar, Missouri, US | |
2022-05-07 | US | Puerto Rico | Santa Isabel | 72133 | 2936 | 0 | 0 | 17.994525 | -66.388913 | 2022-05-08 04:20:49 | Santa Isabel, Puerto Rico, US | |
2022-04-28 | China | Heilongjiang | 2936 | 13 | 0 | 47.862 | 127.7615 | 2022-04-29 04:20:59 | Heilongjiang, China | |||
2022-03-22 | US | Minnesota | Aitkin | 27001 | 2936 | 60 | 0 | 46.60962049 | -93.41168259999999 | 2022-03-23 04:20:48 | Aitkin, Minnesota, US | |
2022-02-27 | US | Mississippi | Montgomery | 28097 | 2936 | 71 | 0 | 33.49419589 | -89.61729103 | 2022-02-28 04:21:05 | Montgomery, Mississippi, US | |
2022-02-26 | US | Mississippi | Montgomery | 28097 | 2936 | 71 | 0 | 33.49419589 | -89.61729103 | 2022-02-27 04:21:04 | Montgomery, Mississippi, US | |
2022-02-25 | US | Mississippi | Montgomery | 28097 | 2936 | 71 | 0 | 33.49419589 | -89.61729103 | 2022-02-26 04:21:12 | Montgomery, Mississippi, US | |
2022-02-22 | US | North Dakota | Barnes | 38003 | 2936 | 46 | 0 | 46.93579637 | -98.06605978 | 2022-02-23 04:21:09 | Barnes, North Dakota, US | |
2022-02-15 | US | Puerto Rico | Loiza | 72087 | 2936 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-02-16 04:21:10 | Loiza, Puerto Rico, US | |
2022-02-02 | US | Virginia | Martinsville | 51690 | 2936 | 103 | 0 | 36.68212094 | -79.86352771 | 2022-02-03 04:21:21 | Martinsville, Virginia, US | |
2022-01-30 | US | Wisconsin | Bayfield | 55007 | 2936 | 36 | 0 | 46.52868768 | -91.19716729 | 2022-01-31 04:21:09 | Bayfield, Wisconsin, US | |
2022-01-29 | US | Wisconsin | Bayfield | 55007 | 2936 | 36 | 0 | 46.52868768 | -91.19716729 | 2022-01-30 04:21:26 | Bayfield, Wisconsin, US | |
2022-01-28 | US | Wisconsin | Bayfield | 55007 | 2936 | 36 | 0 | 46.52868768 | -91.19716729 | 2022-01-29 04:21:10 | Bayfield, Wisconsin, US | |
2022-01-26 | US | Missouri | Dent | 29065 | 2936 | 66 | 0 | 37.60663134 | -91.50790473 | 2022-01-27 04:21:19 | Dent, Missouri, US | |
2022-01-17 | US | Kentucky | Caldwell | 21033 | 2936 | 55 | 0 | 37.14749129 | -87.86948214 | 2022-01-18 04:21:04 | Caldwell, Kentucky, US | |
2022-01-16 | US | Kentucky | Caldwell | 21033 | 2936 | 55 | 0 | 37.14749129 | -87.86948214 | 2022-01-17 04:21:08 | Caldwell, Kentucky, US | |
2022-01-15 | US | Kentucky | Caldwell | 21033 | 2936 | 55 | 0 | 37.14749129 | -87.86948214 | 2022-01-16 04:21:12 | Caldwell, Kentucky, US | |
2022-01-14 | US | Kentucky | Caldwell | 21033 | 2936 | 55 | 0 | 37.14749129 | -87.86948214 | 2022-01-15 04:21:07 | Caldwell, Kentucky, US | |
2022-01-13 | US | Minnesota | Kanabec | 27065 | 2936 | 48 | 0 | 45.9459309 | -93.29275192 | 2022-01-14 04:21:54 | Kanabec, Minnesota, US | |
2022-01-11 | US | Texas | Jackson | 48239 | 2936 | 52 | 0 | 28.95472367 | -96.57749563 | 2022-01-12 04:21:44 | Jackson, Texas, US | |
2022-01-10 | US | Illinois | Johnson | 17087 | 2936 | 35 | 0 | 37.45939802 | -88.88165419 | 2022-01-11 04:22:01 | Johnson, Illinois, US | |
2022-01-04 | US | California | Inyo | 6027 | 2936 | 49 | 0 | 36.51112084 | -117.41119779999998 | 2022-01-05 04:21:59 | Inyo, California, US | |
2021-12-30 | US | Georgia | Banks | 13011 | 2936 | 71 | 0 | 34.35607081 | -83.49644388 | 2021-12-31 04:21:50 | Banks, Georgia, US | |
2021-12-21 | Russia | Chukotka Autonomous Okrug | 2936 | 32 | 0 | 66.0006475 | 169.4900869 | 2021-12-22 04:21:54 | Chukotka Autonomous Okrug, Russia | |||
2021-12-12 | US | Texas | Houston | 48225 | 2936 | 88 | 0 | 31.31925973 | -95.42226208 | 2021-12-13 04:22:02 | Houston, Texas, US | |
2021-12-11 | US | Texas | Houston | 48225 | 2936 | 88 | 0 | 31.31925973 | -95.42226208 | 2021-12-12 04:22:12 | Houston, Texas, US | |
2021-12-10 | US | Kentucky | Jackson | 21109 | 2936 | 55 | 0 | 37.41866422 | -83.99825483 | 2021-12-11 04:22:45 | Jackson, Kentucky, US | |
2021-12-08 | US | South Dakota | Union | 46127 | 2936 | 46 | 0 | 42.83112163 | -96.6557828 | 2021-12-09 04:22:49 | Union, South Dakota, US | |
2021-12-08 | US | Puerto Rico | Rio Grande | 72119 | 2936 | 0 | 0 | 18.346329 | -65.813742 | 2021-12-09 04:22:49 | Rio Grande, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;