daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12,150 rows where deaths = 70 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 | Wisconsin | Adams | 55001 | 5715 | 70 | 0 | 43.96974651 | -89.76782777 | 2022-12-30 04:21:04 | Adams, Wisconsin, US | |
2022-12-29 | US | Texas | Zavala | 48507 | 4473 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-30 04:21:04 | Zavala, Texas, US | |
2022-12-29 | US | Tennessee | Stewart | 47161 | 3710 | 70 | 0 | 36.50235092 | -87.83920548 | 2022-12-30 04:21:04 | Stewart, Tennessee, US | |
2022-12-29 | US | Pennsylvania | Fulton | 42057 | 4957 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-30 04:21:04 | Fulton, Pennsylvania, US | |
2022-12-29 | US | New Mexico | Quay | 35037 | 2497 | 70 | 0 | 35.10403332 | -103.5481727 | 2022-12-30 04:21:04 | Quay, New Mexico, US | |
2022-12-29 | US | Missouri | Linn | 29115 | 3032 | 70 | 0 | 39.87001769 | -93.10704106 | 2022-12-30 04:21:04 | Linn, Missouri, US | |
2022-12-29 | US | Missouri | Adair | 29001 | 6567 | 70 | 0 | 40.19058551 | -92.60078167 | 2022-12-30 04:21:04 | Adair, Missouri, US | |
2022-12-29 | US | Mississippi | Amite | 28005 | 3787 | 70 | 0 | 31.17467303 | -90.80501621 | 2022-12-30 04:21:04 | Amite, Mississippi, US | |
2022-12-29 | US | Kentucky | Grant | 21081 | 9663 | 70 | 0 | 38.64962758 | -84.62415957 | 2022-12-30 04:21:04 | Grant, Kentucky, US | |
2022-12-29 | US | Kentucky | Breathitt | 21025 | 5141 | 70 | 0 | 37.52333168 | -83.31959161 | 2022-12-30 04:21:04 | Breathitt, Kentucky, US | |
2022-12-29 | US | Kansas | Pottawatomie | 20149 | 6964 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-30 04:21:04 | Pottawatomie, Kansas, US | |
2022-12-29 | US | Kansas | Jefferson | 20087 | 5611 | 70 | 0 | 39.2347941 | -95.38289232 | 2022-12-30 04:21:04 | Jefferson, Kansas, US | |
2022-12-29 | US | Iowa | Wright | 19197 | 3988 | 70 | 0 | 42.73305373 | -93.73515113 | 2022-12-30 04:21:04 | Wright, Iowa, US | |
2022-12-29 | US | Illinois | Pike | 17149 | 6061 | 70 | 0 | 39.62265059 | -90.8877017 | 2022-12-30 04:21:04 | Pike, Illinois, US | |
2022-12-29 | US | Illinois | Ford | 17053 | 5363 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-30 04:21:04 | Ford, Illinois, US | |
2022-12-29 | US | Georgia | Terrell | 13273 | 2427 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-12-30 04:21:04 | Terrell, Georgia, US | |
2022-12-29 | US | Arkansas | Lincoln | 5079 | 5378 | 70 | 0 | 33.95317155 | -91.74002806 | 2022-12-30 04:21:04 | Lincoln, Arkansas, US | |
2022-12-28 | US | Wisconsin | Adams | 55001 | 5708 | 70 | 0 | 43.96974651 | -89.76782777 | 2022-12-29 04:21:01 | Adams, Wisconsin, US | |
2022-12-28 | US | Texas | Zavala | 48507 | 4473 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-29 04:21:01 | Zavala, Texas, US | |
2022-12-28 | US | Tennessee | Stewart | 47161 | 3710 | 70 | 0 | 36.50235092 | -87.83920548 | 2022-12-29 04:21:01 | Stewart, Tennessee, US | |
2022-12-28 | US | Pennsylvania | Fulton | 42057 | 4957 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-29 04:21:01 | Fulton, Pennsylvania, US | |
2022-12-28 | US | Missouri | Linn | 29115 | 3032 | 70 | 0 | 39.87001769 | -93.10704106 | 2022-12-29 04:21:01 | Linn, Missouri, US | |
2022-12-28 | US | Missouri | Adair | 29001 | 6567 | 70 | 0 | 40.19058551 | -92.60078167 | 2022-12-29 04:21:01 | Adair, Missouri, US | |
2022-12-28 | US | Mississippi | Amite | 28005 | 3787 | 70 | 0 | 31.17467303 | -90.80501621 | 2022-12-29 04:21:01 | Amite, Mississippi, US | |
2022-12-28 | US | Kentucky | Grant | 21081 | 9663 | 70 | 0 | 38.64962758 | -84.62415957 | 2022-12-29 04:21:01 | Grant, Kentucky, US | |
2022-12-28 | US | Kentucky | Breathitt | 21025 | 5141 | 70 | 0 | 37.52333168 | -83.31959161 | 2022-12-29 04:21:01 | Breathitt, Kentucky, US | |
2022-12-28 | US | Kansas | Pottawatomie | 20149 | 6964 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-29 04:21:01 | Pottawatomie, Kansas, US | |
2022-12-28 | US | Kansas | Jefferson | 20087 | 5611 | 70 | 0 | 39.2347941 | -95.38289232 | 2022-12-29 04:21:01 | Jefferson, Kansas, US | |
2022-12-28 | US | Iowa | Wright | 19197 | 3988 | 70 | 0 | 42.73305373 | -93.73515113 | 2022-12-29 04:21:01 | Wright, Iowa, US | |
2022-12-28 | US | Illinois | Pike | 17149 | 6059 | 70 | 0 | 39.62265059 | -90.8877017 | 2022-12-29 04:21:01 | Pike, Illinois, US | |
2022-12-28 | US | Illinois | Ford | 17053 | 5359 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-29 04:21:01 | Ford, Illinois, US | |
2022-12-28 | US | Georgia | Terrell | 13273 | 2427 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-12-29 04:21:01 | Terrell, Georgia, US | |
2022-12-28 | US | Arkansas | Lincoln | 5079 | 5378 | 70 | 0 | 33.95317155 | -91.74002806 | 2022-12-29 04:21:01 | Lincoln, Arkansas, US | |
2022-12-27 | US | Texas | Zavala | 48507 | 4466 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-28 04:21:04 | Zavala, Texas, US | |
2022-12-27 | US | Tennessee | Stewart | 47161 | 3710 | 70 | 0 | 36.50235092 | -87.83920548 | 2022-12-28 04:21:04 | Stewart, Tennessee, US | |
2022-12-27 | US | Pennsylvania | Fulton | 42057 | 4936 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-28 04:21:04 | Fulton, Pennsylvania, US | |
2022-12-27 | US | Missouri | Linn | 29115 | 3032 | 70 | 0 | 39.87001769 | -93.10704106 | 2022-12-28 04:21:04 | Linn, Missouri, US | |
2022-12-27 | US | Missouri | Adair | 29001 | 6567 | 70 | 0 | 40.19058551 | -92.60078167 | 2022-12-28 04:21:04 | Adair, Missouri, US | |
2022-12-27 | US | Mississippi | Amite | 28005 | 3787 | 70 | 0 | 31.17467303 | -90.80501621 | 2022-12-28 04:21:04 | Amite, Mississippi, US | |
2022-12-27 | US | Kentucky | Grant | 21081 | 9663 | 70 | 0 | 38.64962758 | -84.62415957 | 2022-12-28 04:21:04 | Grant, Kentucky, US | |
2022-12-27 | US | Kentucky | Breathitt | 21025 | 5141 | 70 | 0 | 37.52333168 | -83.31959161 | 2022-12-28 04:21:04 | Breathitt, Kentucky, US | |
2022-12-27 | US | Kansas | Pottawatomie | 20149 | 6942 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-28 04:21:04 | Pottawatomie, Kansas, US | |
2022-12-27 | US | Kansas | Jefferson | 20087 | 5593 | 70 | 0 | 39.2347941 | -95.38289232 | 2022-12-28 04:21:04 | Jefferson, Kansas, US | |
2022-12-27 | US | Iowa | Delaware | 19055 | 4683 | 70 | 0 | 42.47104597 | -91.3664492 | 2022-12-28 04:21:04 | Delaware, Iowa, US | |
2022-12-27 | US | Illinois | Pike | 17149 | 6056 | 70 | 0 | 39.62265059 | -90.8877017 | 2022-12-28 04:21:04 | Pike, Illinois, US | |
2022-12-27 | US | Illinois | Ford | 17053 | 5359 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-28 04:21:04 | Ford, Illinois, US | |
2022-12-27 | US | Georgia | Terrell | 13273 | 2416 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-12-28 04:21:04 | Terrell, Georgia, US | |
2022-12-27 | US | Arkansas | Lincoln | 5079 | 5377 | 70 | 0 | 33.95317155 | -91.74002806 | 2022-12-28 04:21:04 | Lincoln, Arkansas, US | |
2022-12-26 | US | Texas | Zavala | 48507 | 4466 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-27 04:21:07 | Zavala, Texas, US | |
2022-12-26 | US | Tennessee | Stewart | 47161 | 3710 | 70 | 0 | 36.50235092 | -87.83920548 | 2022-12-27 04:21:07 | Stewart, Tennessee, US | |
2022-12-26 | US | Pennsylvania | Fulton | 42057 | 4936 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-27 04:21:07 | Fulton, Pennsylvania, US | |
2022-12-26 | US | Missouri | Linn | 29115 | 3009 | 70 | 0 | 39.87001769 | -93.10704106 | 2022-12-27 04:21:07 | Linn, Missouri, US | |
2022-12-26 | US | Missouri | Adair | 29001 | 6519 | 70 | 0 | 40.19058551 | -92.60078167 | 2022-12-27 04:21:07 | Adair, Missouri, US | |
2022-12-26 | US | Mississippi | Amite | 28005 | 3779 | 70 | 0 | 31.17467303 | -90.80501621 | 2022-12-27 04:21:07 | Amite, Mississippi, US | |
2022-12-26 | US | Kentucky | Grant | 21081 | 9586 | 70 | 0 | 38.64962758 | -84.62415957 | 2022-12-27 04:21:07 | Grant, Kentucky, US | |
2022-12-26 | US | Kentucky | Breathitt | 21025 | 5123 | 70 | 0 | 37.52333168 | -83.31959161 | 2022-12-27 04:21:07 | Breathitt, Kentucky, US | |
2022-12-26 | US | Kentucky | Bourbon | 21017 | 7551 | 70 | 0 | 38.2054607 | -84.21827874 | 2022-12-27 04:21:07 | Bourbon, Kentucky, US | |
2022-12-26 | US | Kansas | Pottawatomie | 20149 | 6942 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-27 04:21:07 | Pottawatomie, Kansas, US | |
2022-12-26 | US | Kansas | Jefferson | 20087 | 5593 | 70 | 0 | 39.2347941 | -95.38289232 | 2022-12-27 04:21:07 | Jefferson, Kansas, US | |
2022-12-26 | US | Iowa | Delaware | 19055 | 4683 | 70 | 0 | 42.47104597 | -91.3664492 | 2022-12-27 04:21:07 | Delaware, Iowa, US | |
2022-12-26 | US | Illinois | Pike | 17149 | 6050 | 70 | 0 | 39.62265059 | -90.8877017 | 2022-12-27 04:21:07 | Pike, Illinois, US | |
2022-12-26 | US | Illinois | Ford | 17053 | 5355 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-27 04:21:07 | Ford, Illinois, US | |
2022-12-26 | US | Georgia | Terrell | 13273 | 2416 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-12-27 04:21:07 | Terrell, Georgia, US | |
2022-12-26 | US | Arkansas | Lincoln | 5079 | 5376 | 70 | 0 | 33.95317155 | -91.74002806 | 2022-12-27 04:21:07 | Lincoln, Arkansas, US | |
2022-12-25 | US | Texas | Zavala | 48507 | 4466 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-26 04:21:06 | Zavala, Texas, US | |
2022-12-25 | US | Tennessee | Stewart | 47161 | 3710 | 70 | 0 | 36.50235092 | -87.83920548 | 2022-12-26 04:21:06 | Stewart, Tennessee, US | |
2022-12-25 | US | Pennsylvania | Fulton | 42057 | 4936 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-26 04:21:06 | Fulton, Pennsylvania, US | |
2022-12-25 | US | Missouri | Linn | 29115 | 3009 | 70 | 0 | 39.87001769 | -93.10704106 | 2022-12-26 04:21:06 | Linn, Missouri, US | |
2022-12-25 | US | Missouri | Adair | 29001 | 6519 | 70 | 0 | 40.19058551 | -92.60078167 | 2022-12-26 04:21:06 | Adair, Missouri, US | |
2022-12-25 | US | Mississippi | Amite | 28005 | 3779 | 70 | 0 | 31.17467303 | -90.80501621 | 2022-12-26 04:21:06 | Amite, Mississippi, US | |
2022-12-25 | US | Kentucky | Grant | 21081 | 9586 | 70 | 0 | 38.64962758 | -84.62415957 | 2022-12-26 04:21:06 | Grant, Kentucky, US | |
2022-12-25 | US | Kentucky | Breathitt | 21025 | 5123 | 70 | 0 | 37.52333168 | -83.31959161 | 2022-12-26 04:21:06 | Breathitt, Kentucky, US | |
2022-12-25 | US | Kentucky | Bourbon | 21017 | 7551 | 70 | 0 | 38.2054607 | -84.21827874 | 2022-12-26 04:21:06 | Bourbon, Kentucky, US | |
2022-12-25 | US | Kansas | Pottawatomie | 20149 | 6942 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-26 04:21:06 | Pottawatomie, Kansas, US | |
2022-12-25 | US | Kansas | Jefferson | 20087 | 5593 | 70 | 0 | 39.2347941 | -95.38289232 | 2022-12-26 04:21:06 | Jefferson, Kansas, US | |
2022-12-25 | US | Iowa | Delaware | 19055 | 4683 | 70 | 0 | 42.47104597 | -91.3664492 | 2022-12-26 04:21:06 | Delaware, Iowa, US | |
2022-12-25 | US | Illinois | Pike | 17149 | 6050 | 70 | 0 | 39.62265059 | -90.8877017 | 2022-12-26 04:21:06 | Pike, Illinois, US | |
2022-12-25 | US | Illinois | Ford | 17053 | 5355 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-26 04:21:06 | Ford, Illinois, US | |
2022-12-25 | US | Georgia | Terrell | 13273 | 2416 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-12-26 04:21:06 | Terrell, Georgia, US | |
2022-12-25 | US | Arkansas | Lincoln | 5079 | 5375 | 70 | 0 | 33.95317155 | -91.74002806 | 2022-12-26 04:21:06 | Lincoln, Arkansas, US | |
2022-12-24 | US | Texas | Zavala | 48507 | 4466 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-25 04:21:04 | Zavala, Texas, US | |
2022-12-24 | US | Tennessee | Stewart | 47161 | 3710 | 70 | 0 | 36.50235092 | -87.83920548 | 2022-12-25 04:21:04 | Stewart, Tennessee, US | |
2022-12-24 | US | Pennsylvania | Fulton | 42057 | 4936 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-25 04:21:04 | Fulton, Pennsylvania, US | |
2022-12-24 | US | Missouri | Linn | 29115 | 3009 | 70 | 0 | 39.87001769 | -93.10704106 | 2022-12-25 04:21:04 | Linn, Missouri, US | |
2022-12-24 | US | Missouri | Adair | 29001 | 6519 | 70 | 0 | 40.19058551 | -92.60078167 | 2022-12-25 04:21:04 | Adair, Missouri, US | |
2022-12-24 | US | Mississippi | Amite | 28005 | 3779 | 70 | 0 | 31.17467303 | -90.80501621 | 2022-12-25 04:21:04 | Amite, Mississippi, US | |
2022-12-24 | US | Kentucky | Grant | 21081 | 9586 | 70 | 0 | 38.64962758 | -84.62415957 | 2022-12-25 04:21:04 | Grant, Kentucky, US | |
2022-12-24 | US | Kentucky | Breathitt | 21025 | 5123 | 70 | 0 | 37.52333168 | -83.31959161 | 2022-12-25 04:21:04 | Breathitt, Kentucky, US | |
2022-12-24 | US | Kentucky | Bourbon | 21017 | 7551 | 70 | 0 | 38.2054607 | -84.21827874 | 2022-12-25 04:21:04 | Bourbon, Kentucky, US | |
2022-12-24 | US | Kansas | Pottawatomie | 20149 | 6942 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-25 04:21:04 | Pottawatomie, Kansas, US | |
2022-12-24 | US | Kansas | Jefferson | 20087 | 5593 | 70 | 0 | 39.2347941 | -95.38289232 | 2022-12-25 04:21:04 | Jefferson, Kansas, US | |
2022-12-24 | US | Iowa | Delaware | 19055 | 4683 | 70 | 0 | 42.47104597 | -91.3664492 | 2022-12-25 04:21:04 | Delaware, Iowa, US | |
2022-12-24 | US | Illinois | Pike | 17149 | 6050 | 70 | 0 | 39.62265059 | -90.8877017 | 2022-12-25 04:21:04 | Pike, Illinois, US | |
2022-12-24 | US | Illinois | Ford | 17053 | 5355 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-25 04:21:04 | Ford, Illinois, US | |
2022-12-24 | US | Georgia | Terrell | 13273 | 2416 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-12-25 04:21:04 | Terrell, Georgia, US | |
2022-12-24 | US | Arkansas | Lincoln | 5079 | 5375 | 70 | 0 | 33.95317155 | -91.74002806 | 2022-12-25 04:21:04 | Lincoln, Arkansas, US | |
2022-12-23 | US | Texas | Zavala | 48507 | 4466 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-24 04:21:02 | Zavala, Texas, US | |
2022-12-23 | US | Tennessee | Stewart | 47161 | 3710 | 70 | 0 | 36.50235092 | -87.83920548 | 2022-12-24 04:21:02 | Stewart, Tennessee, US | |
2022-12-23 | US | Pennsylvania | Fulton | 42057 | 4936 | 70 | 0 | 39.92913544 | -78.11163677 | 2022-12-24 04:21:02 | Fulton, Pennsylvania, US | |
2022-12-23 | US | Missouri | Linn | 29115 | 3009 | 70 | 0 | 39.87001769 | -93.10704106 | 2022-12-24 04:21:02 | Linn, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;