daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
192 rows where confirmed = 3833 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-11-27 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-28 04:21:02 | Webster, Mississippi, US | |
2022-11-26 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-27 04:21:05 | Webster, Mississippi, US | |
2022-11-25 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-26 04:21:11 | Webster, Mississippi, US | |
2022-11-24 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-25 04:21:06 | Webster, Mississippi, US | |
2022-11-23 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-24 04:21:09 | Webster, Mississippi, US | |
2022-11-22 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-23 04:21:06 | Webster, Mississippi, US | |
2022-11-21 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-22 04:20:47 | Webster, Mississippi, US | |
2022-11-20 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-21 04:21:05 | Webster, Mississippi, US | |
2022-11-19 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-20 04:21:08 | Webster, Mississippi, US | |
2022-11-18 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-19 04:21:14 | Webster, Mississippi, US | |
2022-11-17 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-18 04:21:15 | Webster, Mississippi, US | |
2022-11-16 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-17 04:21:11 | Webster, Mississippi, US | |
2022-11-15 | US | Mississippi | Webster | 28155 | 3833 | 73 | 0 | 33.61300486 | -89.28392912 | 2022-11-16 04:21:09 | Webster, Mississippi, US | |
2022-10-12 | China | Shaanxi | 3833 | 3 | 0 | 35.1917 | 108.8701 | 2022-10-13 04:22:39 | Shaanxi, China | |||
2022-10-11 | US | Iowa | Clayton | 19043 | 3833 | 76 | 0 | 42.84443388 | -91.34133693 | 2022-10-12 04:22:51 | Clayton, Iowa, US | |
2022-10-11 | China | Shaanxi | 3833 | 3 | 0 | 35.1917 | 108.8701 | 2022-10-12 04:22:51 | Shaanxi, China | |||
2022-10-10 | US | Iowa | Clayton | 19043 | 3833 | 76 | 0 | 42.84443388 | -91.34133693 | 2022-10-11 04:23:05 | Clayton, Iowa, US | |
2022-10-09 | US | Iowa | Clayton | 19043 | 3833 | 76 | 0 | 42.84443388 | -91.34133693 | 2022-10-10 04:22:32 | Clayton, Iowa, US | |
2022-10-08 | US | Iowa | Clayton | 19043 | 3833 | 76 | 0 | 42.84443388 | -91.34133693 | 2022-10-09 04:21:16 | Clayton, Iowa, US | |
2022-10-07 | US | Iowa | Clayton | 19043 | 3833 | 76 | 0 | 42.84443388 | -91.34133693 | 2022-10-08 04:22:56 | Clayton, Iowa, US | |
2022-10-06 | US | Iowa | Clayton | 19043 | 3833 | 76 | 0 | 42.84443388 | -91.34133693 | 2022-10-07 04:23:08 | Clayton, Iowa, US | |
2022-10-05 | US | Iowa | Clayton | 19043 | 3833 | 76 | 0 | 42.84443388 | -91.34133693 | 2022-10-06 04:21:22 | Clayton, Iowa, US | |
2022-09-26 | US | North Dakota | Walsh | 38099 | 3833 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-09-27 04:23:01 | Walsh, North Dakota, US | |
2022-09-19 | US | Michigan | Gogebic | 26053 | 3833 | 74 | 0 | 46.40862701 | -89.69377193 | 2022-09-20 04:22:48 | Gogebic, Michigan, US | |
2022-09-18 | US | Michigan | Gogebic | 26053 | 3833 | 74 | 0 | 46.40862701 | -89.69377193 | 2022-09-19 04:21:49 | Gogebic, Michigan, US | |
2022-09-17 | US | Michigan | Gogebic | 26053 | 3833 | 74 | 0 | 46.40862701 | -89.69377193 | 2022-09-18 04:22:50 | Gogebic, Michigan, US | |
2022-09-16 | US | Michigan | Gogebic | 26053 | 3833 | 74 | 0 | 46.40862701 | -89.69377193 | 2022-09-17 04:20:19 | Gogebic, Michigan, US | |
2022-09-15 | US | Michigan | Gogebic | 26053 | 3833 | 74 | 0 | 46.40862701 | -89.69377193 | 2022-09-16 04:21:19 | Gogebic, Michigan, US | |
2022-09-14 | US | Michigan | Gogebic | 26053 | 3833 | 74 | 0 | 46.40862701 | -89.69377193 | 2022-09-15 04:21:02 | Gogebic, Michigan, US | |
2022-09-13 | US | Michigan | Gogebic | 26053 | 3833 | 74 | 0 | 46.40862701 | -89.69377193 | 2022-09-14 04:20:44 | Gogebic, Michigan, US | |
2022-09-07 | US | Illinois | Washington | 17189 | 3833 | 36 | 0 | 38.35309213 | -89.40982703 | 2022-09-08 04:21:02 | Washington, Illinois, US | |
2022-09-06 | US | Illinois | Washington | 17189 | 3833 | 36 | 0 | 38.35309213 | -89.40982703 | 2022-09-07 04:20:59 | Washington, Illinois, US | |
2022-08-09 | US | Arkansas | Van Buren | 5141 | 3833 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-08-10 04:20:57 | Van Buren, Arkansas, US | |
2022-08-04 | US | Texas | Comanche | 48093 | 3833 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-08-05 04:20:52 | Comanche, Texas, US | |
2022-07-12 | US | Texas | Bandera | 48019 | 3833 | 77 | 0 | 29.74619598 | -99.24598147 | 2022-07-13 04:20:58 | Bandera, Texas, US | |
2022-07-11 | US | Texas | Leon | 48289 | 3833 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-07-12 04:20:51 | Leon, Texas, US | |
2022-07-05 | US | Washington | Klickitat | 53039 | 3833 | 51 | 0 | 45.87325839 | -120.7913598 | 2022-07-06 04:20:58 | Klickitat, Washington, US | |
2022-07-04 | US | Washington | Klickitat | 53039 | 3833 | 51 | 0 | 45.87325839 | -120.7913598 | 2022-07-05 04:20:45 | Klickitat, Washington, US | |
2022-07-03 | US | Washington | Klickitat | 53039 | 3833 | 51 | 0 | 45.87325839 | -120.7913598 | 2022-07-04 04:20:54 | Klickitat, Washington, US | |
2022-07-02 | US | Washington | Klickitat | 53039 | 3833 | 51 | 0 | 45.87325839 | -120.7913598 | 2022-07-03 04:20:59 | Klickitat, Washington, US | |
2022-07-01 | US | Washington | Klickitat | 53039 | 3833 | 51 | 0 | 45.87325839 | -120.7913598 | 2022-07-02 04:21:16 | Klickitat, Washington, US | |
2022-06-24 | US | Tennessee | Decatur | 47039 | 3833 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-06-25 04:20:57 | Decatur, Tennessee, US | |
2022-06-23 | US | Illinois | Wabash | 17185 | 3833 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-06-24 04:20:58 | Wabash, Illinois, US | |
2022-06-22 | US | Illinois | Wabash | 17185 | 3833 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-06-23 04:20:55 | Wabash, Illinois, US | |
2022-06-21 | US | Iowa | Kossuth | 19109 | 3833 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-06-22 04:20:54 | Kossuth, Iowa, US | |
2022-06-20 | US | Iowa | Kossuth | 19109 | 3833 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-06-21 04:20:56 | Kossuth, Iowa, US | |
2022-06-19 | US | Texas | Falls | 48145 | 3833 | 65 | 0 | 31.25350609 | -96.93630086 | 2022-06-20 04:21:01 | Falls, Texas, US | |
2022-06-19 | US | Iowa | Kossuth | 19109 | 3833 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-06-20 04:21:01 | Kossuth, Iowa, US | |
2022-06-18 | US | Iowa | Kossuth | 19109 | 3833 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-06-19 04:20:51 | Kossuth, Iowa, US | |
2022-06-17 | US | Iowa | Kossuth | 19109 | 3833 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-06-18 04:21:10 | Kossuth, Iowa, US | |
2022-06-16 | US | Iowa | Kossuth | 19109 | 3833 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-06-17 04:20:56 | Kossuth, Iowa, US | |
2022-06-15 | US | Iowa | Kossuth | 19109 | 3833 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-06-16 04:20:55 | Kossuth, Iowa, US | |
2022-06-03 | US | New York | Schuyler | 36097 | 3833 | 28 | 0 | 42.39184015 | -76.8773299 | 2022-06-04 04:20:58 | Schuyler, New York, US | |
2022-05-12 | US | Minnesota | Faribault | 27043 | 3833 | 51 | 0 | 43.67381499 | -93.94787458 | 2022-05-13 04:20:51 | Faribault, Minnesota, US | |
2022-05-10 | US | Alabama | Crenshaw | 1041 | 3833 | 99 | 0 | 31.72941803 | -86.31593104 | 2022-05-11 04:20:48 | Crenshaw, Alabama, US | |
2022-04-19 | US | Puerto Rico | Aguas Buenas | 72007 | 3833 | 0 | 0 | 18.251619 | -66.126806 | 2022-04-20 04:20:45 | Aguas Buenas, Puerto Rico, US | |
2022-03-28 | US | Virginia | Buckingham | 51029 | 3833 | 56 | 0 | 37.57242268 | -78.52518834 | 2022-03-29 04:20:46 | Buckingham, Virginia, US | |
2022-03-27 | US | Virginia | Buckingham | 51029 | 3833 | 56 | 0 | 37.57242268 | -78.52518834 | 2022-03-28 04:20:33 | Buckingham, Virginia, US | |
2022-03-26 | US | Virginia | Buckingham | 51029 | 3833 | 56 | 0 | 37.57242268 | -78.52518834 | 2022-03-27 04:20:47 | Buckingham, Virginia, US | |
2022-03-25 | US | Virginia | Buckingham | 51029 | 3833 | 56 | 0 | 37.57242268 | -78.52518834 | 2022-03-26 04:20:23 | Buckingham, Virginia, US | |
2022-03-06 | US | Illinois | Massac | 17127 | 3833 | 66 | 0 | 37.22078441 | -88.71036614 | 2022-03-07 04:20:47 | Massac, Illinois, US | |
2022-03-05 | US | Illinois | Massac | 17127 | 3833 | 66 | 0 | 37.22078441 | -88.71036614 | 2022-03-06 04:20:49 | Massac, Illinois, US | |
2022-03-04 | US | Illinois | Massac | 17127 | 3833 | 66 | 0 | 37.22078441 | -88.71036614 | 2022-03-05 04:21:10 | Massac, Illinois, US | |
2022-03-03 | US | Texas | Freestone | 48161 | 3833 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-03-04 04:21:09 | Freestone, Texas, US | |
2022-03-01 | US | Kentucky | Washington | 21229 | 3833 | 56 | 0 | 37.75599461 | -85.17407732 | 2022-03-02 04:21:07 | Washington, Kentucky, US | |
2022-02-23 | US | Texas | Llano | 48299 | 3833 | 92 | 0 | 30.70645047 | -98.68475262 | 2022-02-24 04:21:14 | Llano, Texas, US | |
2022-02-13 | US | Georgia | Greene | 13133 | 3833 | 77 | 0 | 33.5769205 | -83.17139104 | 2022-02-14 04:20:51 | Greene, Georgia, US | |
2022-02-12 | US | Georgia | Greene | 13133 | 3833 | 77 | 0 | 33.5769205 | -83.17139104 | 2022-02-13 04:21:00 | Greene, Georgia, US | |
2022-02-11 | US | Georgia | Greene | 13133 | 3833 | 77 | 0 | 33.5769205 | -83.17139104 | 2022-02-12 04:21:06 | Greene, Georgia, US | |
2022-02-10 | US | Texas | Houston | 48225 | 3833 | 98 | 0 | 31.31925973 | -95.42226208 | 2022-02-11 04:21:09 | Houston, Texas, US | |
2022-02-04 | US | Puerto Rico | Yabucoa | 72151 | 3833 | 0 | 0 | 18.070399 | -65.896289 | 2022-02-05 04:21:05 | Yabucoa, Puerto Rico, US | |
2022-02-01 | US | Iowa | Hardin | 19083 | 3833 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-02 04:21:09 | Hardin, Iowa, US | |
2022-02-01 | US | Arkansas | Clay | 5021 | 3833 | 78 | 0 | 36.36826212 | -90.4148172 | 2022-02-02 04:21:09 | Clay, Arkansas, US | |
2022-01-31 | US | Iowa | Hardin | 19083 | 3833 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-02-01 04:21:11 | Hardin, Iowa, US | |
2022-01-30 | US | Iowa | Hardin | 19083 | 3833 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-01-31 04:21:09 | Hardin, Iowa, US | |
2022-01-29 | US | Iowa | Hardin | 19083 | 3833 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-01-30 04:21:26 | Hardin, Iowa, US | |
2022-01-28 | US | Iowa | Hardin | 19083 | 3833 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-01-29 04:21:10 | Hardin, Iowa, US | |
2022-01-27 | US | North Carolina | Warren | 37185 | 3833 | 37 | 0 | 36.39728256 | -78.10652228 | 2022-01-28 04:21:09 | Warren, North Carolina, US | |
2022-01-27 | US | Iowa | Hardin | 19083 | 3833 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-01-28 04:21:09 | Hardin, Iowa, US | |
2022-01-26 | US | Iowa | Hardin | 19083 | 3833 | 57 | 0 | 42.38353877 | -93.23654611 | 2022-01-27 04:21:19 | Hardin, Iowa, US | |
2022-01-16 | US | Texas | Deaf Smith | 48117 | 3833 | 101 | 0 | 34.96522957 | -102.6054267 | 2022-01-17 04:21:08 | Deaf Smith, Texas, US | |
2022-01-14 | US | Puerto Rico | Naranjito | 72105 | 3833 | 0 | 0 | 18.288019 | -66.252703 | 2022-01-15 04:21:07 | Naranjito, Puerto Rico, US | |
2022-01-12 | US | Wisconsin | Sawyer | 55113 | 3833 | 51 | 0 | 45.87931905 | -91.14504927 | 2022-01-13 08:00:09 | Sawyer, Wisconsin, US | |
2022-01-11 | US | Texas | Jones | 48253 | 3833 | 81 | 0 | 32.73997145 | -99.87861576 | 2022-01-12 04:21:44 | Jones, Texas, US | |
2022-01-10 | US | Maine | Franklin | 23007 | 3833 | 45 | 0 | 44.97330019 | -70.44381045 | 2022-01-11 04:22:01 | Franklin, Maine, US | |
2022-01-10 | US | Arizona | La Paz | 4012 | 3833 | 111 | 0 | 33.72854224 | -113.98100290000001 | 2022-01-11 04:22:01 | La Paz, Arizona, US | |
2022-01-09 | US | Maine | Franklin | 23007 | 3833 | 45 | 0 | 44.97330019 | -70.44381045 | 2022-01-10 04:22:07 | Franklin, Maine, US | |
2022-01-08 | US | Maine | Franklin | 23007 | 3833 | 45 | 0 | 44.97330019 | -70.44381045 | 2022-01-09 04:21:46 | Franklin, Maine, US | |
2021-12-19 | US | North Carolina | Martin | 37117 | 3833 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-20 04:21:43 | Martin, North Carolina, US | |
2021-12-18 | US | North Carolina | Martin | 37117 | 3833 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-19 04:21:11 | Martin, North Carolina, US | |
2021-12-17 | US | North Carolina | Martin | 37117 | 3833 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-18 02:22:20 | Martin, North Carolina, US | |
2021-12-14 | US | Kentucky | Harrison | 21097 | 3833 | 53 | 0 | 38.44188174 | -84.32869741 | 2021-12-15 03:22:16 | Harrison, Kentucky, US | |
2021-12-11 | US | California | Del Norte | 6015 | 3833 | 42 | 0 | 41.74228275 | -123.89740630000001 | 2021-12-12 04:22:12 | Del Norte, California, US | |
2021-12-10 | US | California | Del Norte | 6015 | 3833 | 42 | 0 | 41.74228275 | -123.89740630000001 | 2021-12-11 04:22:45 | Del Norte, California, US | |
2021-12-09 | US | California | Del Norte | 6015 | 3833 | 42 | 0 | 41.74228275 | -123.89740630000001 | 2021-12-10 04:22:28 | Del Norte, California, US | |
2021-11-23 | US | Georgia | Haralson | 13143 | 3833 | 125 | 0 | 33.79602175 | -85.21005667 | 2021-11-24 04:22:14 | Haralson, Georgia, US | |
2021-11-22 | US | Georgia | Harris | 13145 | 3833 | 95 | 0 | 32.73709786 | -84.90538572 | 2021-11-23 04:22:39 | Harris, Georgia, US | |
2021-11-18 | US | Virginia | Lee | 51105 | 3833 | 61 | 0 | 36.70586667 | -83.12606515 | 2021-11-19 04:21:40 | Lee, Virginia, US | |
2021-11-17 | US | Ohio | Holmes | 39075 | 3833 | 142 | 0 | 40.56163713 | -81.92635677 | 2021-11-18 04:21:33 | Holmes, Ohio, US | |
2021-11-14 | US | Virginia | Orange | 51137 | 3833 | 60 | 0 | 38.24530219 | -78.01560400000002 | 2021-11-15 04:21:36 | Orange, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;