daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13,656 rows where deaths = 59 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 >30
- US 13,016
- Russia 86
- Japan 83
- Thailand 49
- Colombia 37
- Germany 31
- France 28
- Sweden 26
- India 25
- Ukraine 21
- South Sudan 20
- Djibouti 19
- Canada 17
- Central African Republic 16
- Spain 15
- Australia 12
- Chile 11
- Gabon 11
- Netherlands 10
- Monaco 8
- United Kingdom 8
- Malaysia 7
- Burkina Faso 6
- Guinea 6
- Andorra 5
- Peru 5
- Mexico 4
- Pakistan 4
- San Marino 4
- Belize 3
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Washington | Klickitat | 53039 | 4258 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-30 04:21:04 | Klickitat, Washington, US | |
2022-12-29 | US | Virginia | Appomattox | 51011 | 4833 | 59 | 0 | 37.37569884 | -78.81340003 | 2022-12-30 04:21:04 | Appomattox, Virginia, US | |
2022-12-29 | US | Texas | Madison | 48313 | 4188 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-12-30 04:21:04 | Madison, Texas, US | |
2022-12-29 | US | Oklahoma | Washita | 40149 | 3170 | 59 | 0 | 35.29071824 | -98.99180434 | 2022-12-30 04:21:04 | Washita, Oklahoma, US | |
2022-12-29 | US | Ohio | Vinton | 39163 | 3594 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-12-30 04:21:04 | Vinton, Ohio, US | |
2022-12-29 | US | New Mexico | Torrance | 35057 | 3284 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-12-30 04:21:04 | Torrance, New Mexico, US | |
2022-12-29 | US | Montana | Dawson | 30021 | 2738 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-30 04:21:04 | Dawson, Montana, US | |
2022-12-29 | US | Missouri | Madison | 29123 | 4182 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-12-30 04:21:04 | Madison, Missouri, US | |
2022-12-29 | US | Missouri | Hickory | 29085 | 2350 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-30 04:21:04 | Hickory, Missouri, US | |
2022-12-29 | US | Minnesota | Renville | 27129 | 4406 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-12-30 04:21:04 | Renville, Minnesota, US | |
2022-12-29 | US | Minnesota | Faribault | 27043 | 4398 | 59 | 0 | 43.67381499 | -93.94787458 | 2022-12-30 04:21:04 | Faribault, Minnesota, US | |
2022-12-29 | US | Louisiana | Red River | 22081 | 2492 | 59 | 0 | 32.09530039 | -93.34213308 | 2022-12-30 04:21:04 | Red River, Louisiana, US | |
2022-12-29 | US | Kentucky | Woodford | 21239 | 9132 | 59 | 0 | 38.04178222 | -84.7417556 | 2022-12-30 04:21:04 | Woodford, Kentucky, US | |
2022-12-29 | US | Kentucky | McLean | 21149 | 3241 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-30 04:21:04 | McLean, Kentucky, US | |
2022-12-29 | US | Kentucky | Lee | 21129 | 3386 | 59 | 0 | 37.59645942 | -83.71513901 | 2022-12-30 04:21:04 | Lee, Kentucky, US | |
2022-12-29 | US | Indiana | Rush | 18139 | 5851 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-12-30 04:21:04 | Rush, Indiana, US | |
2022-12-28 | US | Washington | Klickitat | 53039 | 4258 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-29 04:21:01 | Klickitat, Washington, US | |
2022-12-28 | US | Virginia | Appomattox | 51011 | 4833 | 59 | 0 | 37.37569884 | -78.81340003 | 2022-12-29 04:21:01 | Appomattox, Virginia, US | |
2022-12-28 | US | Texas | Madison | 48313 | 4188 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-12-29 04:21:01 | Madison, Texas, US | |
2022-12-28 | US | Oklahoma | Washita | 40149 | 3159 | 59 | 0 | 35.29071824 | -98.99180434 | 2022-12-29 04:21:01 | Washita, Oklahoma, US | |
2022-12-28 | US | Ohio | Vinton | 39163 | 3576 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-12-29 04:21:01 | Vinton, Ohio, US | |
2022-12-28 | US | New Mexico | Torrance | 35057 | 3284 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-12-29 04:21:01 | Torrance, New Mexico, US | |
2022-12-28 | US | Montana | Dawson | 30021 | 2738 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-29 04:21:01 | Dawson, Montana, US | |
2022-12-28 | US | Missouri | Madison | 29123 | 4182 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-12-29 04:21:01 | Madison, Missouri, US | |
2022-12-28 | US | Missouri | Hickory | 29085 | 2350 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-29 04:21:01 | Hickory, Missouri, US | |
2022-12-28 | US | Minnesota | Renville | 27129 | 4390 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-12-29 04:21:01 | Renville, Minnesota, US | |
2022-12-28 | US | Minnesota | Faribault | 27043 | 4392 | 59 | 0 | 43.67381499 | -93.94787458 | 2022-12-29 04:21:01 | Faribault, Minnesota, US | |
2022-12-28 | US | Louisiana | Red River | 22081 | 2492 | 59 | 0 | 32.09530039 | -93.34213308 | 2022-12-29 04:21:01 | Red River, Louisiana, US | |
2022-12-28 | US | Kentucky | Woodford | 21239 | 9132 | 59 | 0 | 38.04178222 | -84.7417556 | 2022-12-29 04:21:01 | Woodford, Kentucky, US | |
2022-12-28 | US | Kentucky | McLean | 21149 | 3241 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-29 04:21:01 | McLean, Kentucky, US | |
2022-12-28 | US | Kentucky | Lee | 21129 | 3386 | 59 | 0 | 37.59645942 | -83.71513901 | 2022-12-29 04:21:01 | Lee, Kentucky, US | |
2022-12-28 | US | Indiana | Rush | 18139 | 5851 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-12-29 04:21:01 | Rush, Indiana, US | |
2022-12-27 | US | Washington | Klickitat | 53039 | 4244 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-28 04:21:04 | Klickitat, Washington, US | |
2022-12-27 | US | Virginia | Appomattox | 51011 | 4829 | 59 | 0 | 37.37569884 | -78.81340003 | 2022-12-28 04:21:04 | Appomattox, Virginia, US | |
2022-12-27 | US | Texas | Madison | 48313 | 4173 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-12-28 04:21:04 | Madison, Texas, US | |
2022-12-27 | US | Oklahoma | Washita | 40149 | 3159 | 59 | 0 | 35.29071824 | -98.99180434 | 2022-12-28 04:21:04 | Washita, Oklahoma, US | |
2022-12-27 | US | Ohio | Vinton | 39163 | 3576 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-12-28 04:21:04 | Vinton, Ohio, US | |
2022-12-27 | US | New Mexico | Torrance | 35057 | 3282 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-12-28 04:21:04 | Torrance, New Mexico, US | |
2022-12-27 | US | Montana | Dawson | 30021 | 2738 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-28 04:21:04 | Dawson, Montana, US | |
2022-12-27 | US | Missouri | Madison | 29123 | 4182 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-12-28 04:21:04 | Madison, Missouri, US | |
2022-12-27 | US | Missouri | Hickory | 29085 | 2350 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-28 04:21:04 | Hickory, Missouri, US | |
2022-12-27 | US | Minnesota | Renville | 27129 | 4390 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-12-28 04:21:04 | Renville, Minnesota, US | |
2022-12-27 | US | Minnesota | Faribault | 27043 | 4392 | 59 | 0 | 43.67381499 | -93.94787458 | 2022-12-28 04:21:04 | Faribault, Minnesota, US | |
2022-12-27 | US | Louisiana | Red River | 22081 | 2485 | 59 | 0 | 32.09530039 | -93.34213308 | 2022-12-28 04:21:04 | Red River, Louisiana, US | |
2022-12-27 | US | Louisiana | Catahoula | 22025 | 3068 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-12-28 04:21:04 | Catahoula, Louisiana, US | |
2022-12-27 | US | Kentucky | Woodford | 21239 | 9132 | 59 | 0 | 38.04178222 | -84.7417556 | 2022-12-28 04:21:04 | Woodford, Kentucky, US | |
2022-12-27 | US | Kentucky | McLean | 21149 | 3241 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-28 04:21:04 | McLean, Kentucky, US | |
2022-12-27 | US | Kentucky | Lee | 21129 | 3386 | 59 | 0 | 37.59645942 | -83.71513901 | 2022-12-28 04:21:04 | Lee, Kentucky, US | |
2022-12-27 | US | Iowa | Butler | 19023 | 3747 | 59 | 0 | 42.73172833 | -92.79015971 | 2022-12-28 04:21:04 | Butler, Iowa, US | |
2022-12-27 | US | Indiana | Rush | 18139 | 5851 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-12-28 04:21:04 | Rush, Indiana, US | |
2022-12-26 | US | Washington | Klickitat | 53039 | 4244 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-27 04:21:07 | Klickitat, Washington, US | |
2022-12-26 | US | Virginia | Appomattox | 51011 | 4824 | 59 | 0 | 37.37569884 | -78.81340003 | 2022-12-27 04:21:07 | Appomattox, Virginia, US | |
2022-12-26 | US | Texas | Madison | 48313 | 4173 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-12-27 04:21:07 | Madison, Texas, US | |
2022-12-26 | US | Oklahoma | Washita | 40149 | 3159 | 59 | 0 | 35.29071824 | -98.99180434 | 2022-12-27 04:21:07 | Washita, Oklahoma, US | |
2022-12-26 | US | Ohio | Vinton | 39163 | 3576 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-12-27 04:21:07 | Vinton, Ohio, US | |
2022-12-26 | US | New Mexico | Torrance | 35057 | 3279 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-12-27 04:21:07 | Torrance, New Mexico, US | |
2022-12-26 | US | Montana | Dawson | 30021 | 2738 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-27 04:21:07 | Dawson, Montana, US | |
2022-12-26 | US | Missouri | Madison | 29123 | 4172 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-12-27 04:21:07 | Madison, Missouri, US | |
2022-12-26 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-27 04:21:07 | Hickory, Missouri, US | |
2022-12-26 | US | Minnesota | Renville | 27129 | 4390 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-12-27 04:21:07 | Renville, Minnesota, US | |
2022-12-26 | US | Minnesota | Faribault | 27043 | 4392 | 59 | 0 | 43.67381499 | -93.94787458 | 2022-12-27 04:21:07 | Faribault, Minnesota, US | |
2022-12-26 | US | Louisiana | Red River | 22081 | 2485 | 59 | 0 | 32.09530039 | -93.34213308 | 2022-12-27 04:21:07 | Red River, Louisiana, US | |
2022-12-26 | US | Louisiana | Catahoula | 22025 | 3068 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-12-27 04:21:07 | Catahoula, Louisiana, US | |
2022-12-26 | US | Kentucky | McLean | 21149 | 3214 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-27 04:21:07 | McLean, Kentucky, US | |
2022-12-26 | US | Kentucky | Lee | 21129 | 3375 | 59 | 0 | 37.59645942 | -83.71513901 | 2022-12-27 04:21:07 | Lee, Kentucky, US | |
2022-12-26 | US | Iowa | Butler | 19023 | 3747 | 59 | 0 | 42.73172833 | -92.79015971 | 2022-12-27 04:21:07 | Butler, Iowa, US | |
2022-12-26 | US | Indiana | Rush | 18139 | 5851 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-12-27 04:21:07 | Rush, Indiana, US | |
2022-12-25 | US | Washington | Klickitat | 53039 | 4244 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-26 04:21:06 | Klickitat, Washington, US | |
2022-12-25 | US | Virginia | Appomattox | 51011 | 4817 | 59 | 0 | 37.37569884 | -78.81340003 | 2022-12-26 04:21:06 | Appomattox, Virginia, US | |
2022-12-25 | US | Texas | Madison | 48313 | 4173 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-12-26 04:21:06 | Madison, Texas, US | |
2022-12-25 | US | Oklahoma | Washita | 40149 | 3159 | 59 | 0 | 35.29071824 | -98.99180434 | 2022-12-26 04:21:06 | Washita, Oklahoma, US | |
2022-12-25 | US | Ohio | Vinton | 39163 | 3576 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-12-26 04:21:06 | Vinton, Ohio, US | |
2022-12-25 | US | New Mexico | Torrance | 35057 | 3279 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-12-26 04:21:06 | Torrance, New Mexico, US | |
2022-12-25 | US | Montana | Dawson | 30021 | 2738 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-26 04:21:06 | Dawson, Montana, US | |
2022-12-25 | US | Missouri | Madison | 29123 | 4172 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-12-26 04:21:06 | Madison, Missouri, US | |
2022-12-25 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-26 04:21:06 | Hickory, Missouri, US | |
2022-12-25 | US | Minnesota | Renville | 27129 | 4390 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-12-26 04:21:06 | Renville, Minnesota, US | |
2022-12-25 | US | Minnesota | Faribault | 27043 | 4392 | 59 | 0 | 43.67381499 | -93.94787458 | 2022-12-26 04:21:06 | Faribault, Minnesota, US | |
2022-12-25 | US | Louisiana | Red River | 22081 | 2485 | 59 | 0 | 32.09530039 | -93.34213308 | 2022-12-26 04:21:06 | Red River, Louisiana, US | |
2022-12-25 | US | Louisiana | Catahoula | 22025 | 3068 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-12-26 04:21:06 | Catahoula, Louisiana, US | |
2022-12-25 | US | Kentucky | McLean | 21149 | 3214 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-26 04:21:06 | McLean, Kentucky, US | |
2022-12-25 | US | Kentucky | Lee | 21129 | 3375 | 59 | 0 | 37.59645942 | -83.71513901 | 2022-12-26 04:21:06 | Lee, Kentucky, US | |
2022-12-25 | US | Iowa | Butler | 19023 | 3747 | 59 | 0 | 42.73172833 | -92.79015971 | 2022-12-26 04:21:06 | Butler, Iowa, US | |
2022-12-25 | US | Indiana | Rush | 18139 | 5851 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-12-26 04:21:06 | Rush, Indiana, US | |
2022-12-24 | US | Washington | Klickitat | 53039 | 4244 | 59 | 0 | 45.87325839 | -120.7913598 | 2022-12-25 04:21:04 | Klickitat, Washington, US | |
2022-12-24 | US | Virginia | Appomattox | 51011 | 4817 | 59 | 0 | 37.37569884 | -78.81340003 | 2022-12-25 04:21:04 | Appomattox, Virginia, US | |
2022-12-24 | US | Texas | Madison | 48313 | 4173 | 59 | 0 | 30.96694679 | -95.93003775 | 2022-12-25 04:21:04 | Madison, Texas, US | |
2022-12-24 | US | Oklahoma | Washita | 40149 | 3159 | 59 | 0 | 35.29071824 | -98.99180434 | 2022-12-25 04:21:04 | Washita, Oklahoma, US | |
2022-12-24 | US | Ohio | Vinton | 39163 | 3576 | 59 | 0 | 39.25208988 | -82.4831444 | 2022-12-25 04:21:04 | Vinton, Ohio, US | |
2022-12-24 | US | New Mexico | Torrance | 35057 | 3279 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-12-25 04:21:04 | Torrance, New Mexico, US | |
2022-12-24 | US | Montana | Dawson | 30021 | 2738 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-12-25 04:21:04 | Dawson, Montana, US | |
2022-12-24 | US | Missouri | Madison | 29123 | 4172 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-12-25 04:21:04 | Madison, Missouri, US | |
2022-12-24 | US | Missouri | Hickory | 29085 | 2342 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-25 04:21:04 | Hickory, Missouri, US | |
2022-12-24 | US | Minnesota | Renville | 27129 | 4390 | 59 | 0 | 44.72836381 | -94.94553734 | 2022-12-25 04:21:04 | Renville, Minnesota, US | |
2022-12-24 | US | Minnesota | Faribault | 27043 | 4392 | 59 | 0 | 43.67381499 | -93.94787458 | 2022-12-25 04:21:04 | Faribault, Minnesota, US | |
2022-12-24 | US | Louisiana | Red River | 22081 | 2485 | 59 | 0 | 32.09530039 | -93.34213308 | 2022-12-25 04:21:04 | Red River, Louisiana, US | |
2022-12-24 | US | Louisiana | Catahoula | 22025 | 3068 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-12-25 04:21:04 | Catahoula, Louisiana, US | |
2022-12-24 | US | Kentucky | McLean | 21149 | 3214 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-12-25 04:21:04 | McLean, Kentucky, US | |
2022-12-24 | US | Kentucky | Lee | 21129 | 3375 | 59 | 0 | 37.59645942 | -83.71513901 | 2022-12-25 04:21:04 | Lee, Kentucky, US | |
2022-12-24 | US | Iowa | Butler | 19023 | 3747 | 59 | 0 | 42.73172833 | -92.79015971 | 2022-12-25 04:21:04 | Butler, Iowa, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;