daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25,488 rows where deaths = 24 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
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-29 | US | Virginia | Williamsburg | 51830 | 2209 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-30 04:21:04 | Williamsburg, Virginia, US | |
2022-12-29 | US | Virginia | Craig | 51045 | 1409 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-30 04:21:04 | Craig, Virginia, US | |
2022-12-29 | US | Virginia | Bland | 51021 | 2307 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-12-30 04:21:04 | Bland, Virginia, US | |
2022-12-29 | US | Texas | Wheeler | 48483 | 1304 | 24 | 0 | 35.40114335 | -100.2699514 | 2022-12-30 04:21:04 | Wheeler, Texas, US | |
2022-12-29 | US | Texas | Hall | 48191 | 1268 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-12-30 04:21:04 | Hall, Texas, US | |
2022-12-29 | US | Texas | Crane | 48103 | 1508 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-30 04:21:04 | Crane, Texas, US | |
2022-12-29 | US | South Carolina | Allendale | 45005 | 2378 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-12-30 04:21:04 | Allendale, South Carolina, US | |
2022-12-29 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-30 04:21:04 | Mercer, North Dakota, US | |
2022-12-29 | US | Nebraska | Holt | 31089 | 2472 | 24 | 0 | 42.45522056 | -98.78402558 | 2022-12-30 04:21:04 | Holt, Nebraska, US | |
2022-12-29 | US | Missouri | Carter | 29035 | 1691 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-30 04:21:04 | Carter, Missouri, US | |
2022-12-29 | US | Missouri | Atchison | 29005 | 1791 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-30 04:21:04 | Atchison, Missouri, US | |
2022-12-29 | US | Minnesota | Wilkin | 27167 | 1898 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-30 04:21:04 | Wilkin, Minnesota, US | |
2022-12-29 | US | Minnesota | Marshall | 27089 | 2464 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-30 04:21:04 | Marshall, Minnesota, US | |
2022-12-29 | US | Minnesota | Dodge | 27039 | 6607 | 24 | 0 | 44.02238415 | -92.86244324 | 2022-12-30 04:21:04 | Dodge, Minnesota, US | |
2022-12-29 | US | Massachusetts | Dukes and Nantucket | 8167 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-30 04:21:04 | Dukes and Nantucket, Massachusetts, US | ||
2022-12-29 | US | Kansas | Wabaunsee | 20197 | 1947 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-30 04:21:04 | Wabaunsee, Kansas, US | |
2022-12-29 | US | Kansas | Ottawa | 20143 | 1429 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-12-30 04:21:04 | Ottawa, Kansas, US | |
2022-12-29 | US | Kansas | Meade | 20119 | 1347 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-30 04:21:04 | Meade, Kansas, US | |
2022-12-29 | US | Iowa | Taylor | 19173 | 1502 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-30 04:21:04 | Taylor, Iowa, US | |
2022-12-29 | US | Illinois | Pulaski | 17153 | 2014 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-12-30 04:21:04 | Pulaski, Illinois, US | |
2022-12-28 | US | Virginia | Williamsburg | 51830 | 2209 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-29 04:21:01 | Williamsburg, Virginia, US | |
2022-12-28 | US | Virginia | Craig | 51045 | 1409 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-29 04:21:01 | Craig, Virginia, US | |
2022-12-28 | US | Virginia | Bland | 51021 | 2307 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-12-29 04:21:01 | Bland, Virginia, US | |
2022-12-28 | US | Texas | Wheeler | 48483 | 1304 | 24 | 0 | 35.40114335 | -100.2699514 | 2022-12-29 04:21:01 | Wheeler, Texas, US | |
2022-12-28 | US | Texas | Hall | 48191 | 1268 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-12-29 04:21:01 | Hall, Texas, US | |
2022-12-28 | US | Texas | Crane | 48103 | 1508 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-29 04:21:01 | Crane, Texas, US | |
2022-12-28 | US | South Carolina | Allendale | 45005 | 2378 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-12-29 04:21:01 | Allendale, South Carolina, US | |
2022-12-28 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-29 04:21:01 | Mercer, North Dakota, US | |
2022-12-28 | US | Nebraska | Holt | 31089 | 2472 | 24 | 0 | 42.45522056 | -98.78402558 | 2022-12-29 04:21:01 | Holt, Nebraska, US | |
2022-12-28 | US | Missouri | Carter | 29035 | 1691 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-29 04:21:01 | Carter, Missouri, US | |
2022-12-28 | US | Missouri | Atchison | 29005 | 1791 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-29 04:21:01 | Atchison, Missouri, US | |
2022-12-28 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-29 04:21:01 | Wilkin, Minnesota, US | |
2022-12-28 | US | Minnesota | Marshall | 27089 | 2459 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-29 04:21:01 | Marshall, Minnesota, US | |
2022-12-28 | US | Minnesota | Dodge | 27039 | 6595 | 24 | 0 | 44.02238415 | -92.86244324 | 2022-12-29 04:21:01 | Dodge, Minnesota, US | |
2022-12-28 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-29 04:21:01 | Dukes and Nantucket, Massachusetts, US | ||
2022-12-28 | US | Kansas | Wabaunsee | 20197 | 1947 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-29 04:21:01 | Wabaunsee, Kansas, US | |
2022-12-28 | US | Kansas | Ottawa | 20143 | 1429 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-12-29 04:21:01 | Ottawa, Kansas, US | |
2022-12-28 | US | Kansas | Meade | 20119 | 1347 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-29 04:21:01 | Meade, Kansas, US | |
2022-12-28 | US | Iowa | Taylor | 19173 | 1502 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-29 04:21:01 | Taylor, Iowa, US | |
2022-12-28 | US | Illinois | Pulaski | 17153 | 2007 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-12-29 04:21:01 | Pulaski, Illinois, US | |
2022-12-27 | US | Virginia | Williamsburg | 51830 | 2207 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-28 04:21:04 | Williamsburg, Virginia, US | |
2022-12-27 | US | Virginia | Craig | 51045 | 1405 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-28 04:21:04 | Craig, Virginia, US | |
2022-12-27 | US | Virginia | Bland | 51021 | 2306 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-12-28 04:21:04 | Bland, Virginia, US | |
2022-12-27 | US | Texas | Hall | 48191 | 1260 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-12-28 04:21:04 | Hall, Texas, US | |
2022-12-27 | US | Texas | Crane | 48103 | 1498 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-28 04:21:04 | Crane, Texas, US | |
2022-12-27 | US | South Carolina | Allendale | 45005 | 2378 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-12-28 04:21:04 | Allendale, South Carolina, US | |
2022-12-27 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-28 04:21:04 | Mercer, North Dakota, US | |
2022-12-27 | US | Nebraska | Holt | 31089 | 2472 | 24 | 0 | 42.45522056 | -98.78402558 | 2022-12-28 04:21:04 | Holt, Nebraska, US | |
2022-12-27 | US | Missouri | Carter | 29035 | 1691 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-28 04:21:04 | Carter, Missouri, US | |
2022-12-27 | US | Missouri | Atchison | 29005 | 1791 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-28 04:21:04 | Atchison, Missouri, US | |
2022-12-27 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-28 04:21:04 | Wilkin, Minnesota, US | |
2022-12-27 | US | Minnesota | Marshall | 27089 | 2459 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-28 04:21:04 | Marshall, Minnesota, US | |
2022-12-27 | US | Minnesota | Dodge | 27039 | 6595 | 24 | 0 | 44.02238415 | -92.86244324 | 2022-12-28 04:21:04 | Dodge, Minnesota, US | |
2022-12-27 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-28 04:21:04 | Dukes and Nantucket, Massachusetts, US | ||
2022-12-27 | US | Kansas | Wabaunsee | 20197 | 1938 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-28 04:21:04 | Wabaunsee, Kansas, US | |
2022-12-27 | US | Kansas | Ottawa | 20143 | 1424 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-12-28 04:21:04 | Ottawa, Kansas, US | |
2022-12-27 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-28 04:21:04 | Meade, Kansas, US | |
2022-12-27 | US | Iowa | Taylor | 19173 | 1498 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-28 04:21:04 | Taylor, Iowa, US | |
2022-12-27 | US | Illinois | Pulaski | 17153 | 2005 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-12-28 04:21:04 | Pulaski, Illinois, US | |
2022-12-26 | US | Virginia | Williamsburg | 51830 | 2206 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-27 04:21:07 | Williamsburg, Virginia, US | |
2022-12-26 | US | Virginia | Craig | 51045 | 1404 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-27 04:21:07 | Craig, Virginia, US | |
2022-12-26 | US | Virginia | Bland | 51021 | 2305 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-12-27 04:21:07 | Bland, Virginia, US | |
2022-12-26 | US | Texas | Hall | 48191 | 1260 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-12-27 04:21:07 | Hall, Texas, US | |
2022-12-26 | US | Texas | Crane | 48103 | 1498 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-27 04:21:07 | Crane, Texas, US | |
2022-12-26 | US | South Carolina | Allendale | 45005 | 2369 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-12-27 04:21:07 | Allendale, South Carolina, US | |
2022-12-26 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-27 04:21:07 | Mercer, North Dakota, US | |
2022-12-26 | US | Nebraska | Holt | 31089 | 2472 | 24 | 0 | 42.45522056 | -98.78402558 | 2022-12-27 04:21:07 | Holt, Nebraska, US | |
2022-12-26 | US | Missouri | Carter | 29035 | 1685 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-27 04:21:07 | Carter, Missouri, US | |
2022-12-26 | US | Missouri | Atchison | 29005 | 1785 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-27 04:21:07 | Atchison, Missouri, US | |
2022-12-26 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-27 04:21:07 | Wilkin, Minnesota, US | |
2022-12-26 | US | Minnesota | Marshall | 27089 | 2459 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-27 04:21:07 | Marshall, Minnesota, US | |
2022-12-26 | US | Minnesota | Dodge | 27039 | 6595 | 24 | 0 | 44.02238415 | -92.86244324 | 2022-12-27 04:21:07 | Dodge, Minnesota, US | |
2022-12-26 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-27 04:21:07 | Dukes and Nantucket, Massachusetts, US | ||
2022-12-26 | US | Kansas | Wabaunsee | 20197 | 1938 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-27 04:21:07 | Wabaunsee, Kansas, US | |
2022-12-26 | US | Kansas | Ottawa | 20143 | 1424 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-12-27 04:21:07 | Ottawa, Kansas, US | |
2022-12-26 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-27 04:21:07 | Meade, Kansas, US | |
2022-12-26 | US | Iowa | Taylor | 19173 | 1498 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-27 04:21:07 | Taylor, Iowa, US | |
2022-12-26 | US | Illinois | Pulaski | 17153 | 2005 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-12-27 04:21:07 | Pulaski, Illinois, US | |
2022-12-25 | US | Virginia | Williamsburg | 51830 | 2206 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-26 04:21:06 | Williamsburg, Virginia, US | |
2022-12-25 | US | Virginia | Craig | 51045 | 1404 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-26 04:21:06 | Craig, Virginia, US | |
2022-12-25 | US | Virginia | Bland | 51021 | 2303 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-12-26 04:21:06 | Bland, Virginia, US | |
2022-12-25 | US | Texas | Hall | 48191 | 1260 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-12-26 04:21:06 | Hall, Texas, US | |
2022-12-25 | US | Texas | Crane | 48103 | 1498 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-26 04:21:06 | Crane, Texas, US | |
2022-12-25 | US | South Carolina | Allendale | 45005 | 2369 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-12-26 04:21:06 | Allendale, South Carolina, US | |
2022-12-25 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-26 04:21:06 | Mercer, North Dakota, US | |
2022-12-25 | US | Nebraska | Holt | 31089 | 2472 | 24 | 0 | 42.45522056 | -98.78402558 | 2022-12-26 04:21:06 | Holt, Nebraska, US | |
2022-12-25 | US | Missouri | Carter | 29035 | 1685 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-26 04:21:06 | Carter, Missouri, US | |
2022-12-25 | US | Missouri | Atchison | 29005 | 1785 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-26 04:21:06 | Atchison, Missouri, US | |
2022-12-25 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-26 04:21:06 | Wilkin, Minnesota, US | |
2022-12-25 | US | Minnesota | Marshall | 27089 | 2459 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-26 04:21:06 | Marshall, Minnesota, US | |
2022-12-25 | US | Minnesota | Dodge | 27039 | 6595 | 24 | 0 | 44.02238415 | -92.86244324 | 2022-12-26 04:21:06 | Dodge, Minnesota, US | |
2022-12-25 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-26 04:21:06 | Dukes and Nantucket, Massachusetts, US | ||
2022-12-25 | US | Kansas | Wabaunsee | 20197 | 1938 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-26 04:21:06 | Wabaunsee, Kansas, US | |
2022-12-25 | US | Kansas | Ottawa | 20143 | 1424 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-12-26 04:21:06 | Ottawa, Kansas, US | |
2022-12-25 | US | Kansas | Meade | 20119 | 1345 | 24 | 0 | 37.23859987 | -100.364831 | 2022-12-26 04:21:06 | Meade, Kansas, US | |
2022-12-25 | US | Iowa | Taylor | 19173 | 1498 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-26 04:21:06 | Taylor, Iowa, US | |
2022-12-25 | US | Illinois | Pulaski | 17153 | 2005 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-12-26 04:21:06 | Pulaski, Illinois, US | |
2022-12-24 | US | Virginia | Williamsburg | 51830 | 2206 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-25 04:21:04 | Williamsburg, Virginia, US | |
2022-12-24 | US | Virginia | Craig | 51045 | 1404 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-25 04:21:04 | Craig, Virginia, US | |
2022-12-24 | US | Virginia | Bland | 51021 | 2303 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-12-25 04:21:04 | Bland, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;