daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12,797 rows where deaths = 69 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 11,816
- United Kingdom 161
- Japan 152
- Niger 122
- Netherlands 89
- Russia 79
- Estonia 60
- Sweden 40
- Guinea-Bissau 25
- France 22
- Ukraine 21
- Sierra Leone 17
- Chile 16
- Canada 14
- Lithuania 14
- Liechtenstein 11
- Mexico 11
- Saint Vincent and the Grenadines 9
- Sao Tome and Principe 9
- India 8
- Colombia 7
- Malaysia 7
- Australia 6
- Bahamas 4
- Burkina Faso 4
- Peru 4
- San Marino 4
- Tajikistan 4
- Andorra 3
- Congo (Kinshasa) 3
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Texas | Runnels | 48399 | 2699 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-30 04:21:04 | Runnels, Texas, US | |
2022-12-29 | US | Oklahoma | Choctaw | 40023 | 4907 | 69 | 0 | 34.02807439 | -95.54771129 | 2022-12-30 04:21:04 | Choctaw, Oklahoma, US | |
2022-12-29 | US | North Carolina | Yancey | 37199 | 6216 | 69 | 0 | 35.90079156 | -82.31237181 | 2022-12-30 04:21:04 | Yancey, North Carolina, US | |
2022-12-29 | US | North Carolina | Polk | 37149 | 4793 | 69 | 0 | 35.27820615 | -82.16812354 | 2022-12-30 04:21:04 | Polk, North Carolina, US | |
2022-12-29 | US | Michigan | Missaukee | 26113 | 3528 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-30 04:21:04 | Missaukee, Michigan, US | |
2022-12-29 | US | Michigan | Kalkaska | 26079 | 4428 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-30 04:21:04 | Kalkaska, Michigan, US | |
2022-12-29 | US | Kentucky | Washington | 21229 | 4948 | 69 | 0 | 37.75599461 | -85.17407732 | 2022-12-30 04:21:04 | Washington, Kentucky, US | |
2022-12-29 | US | Kentucky | Meade | 21163 | 7260 | 69 | 0 | 37.96163597 | -86.21028219 | 2022-12-30 04:21:04 | Meade, Kentucky, US | |
2022-12-29 | US | Iowa | Hardin | 19083 | 4964 | 69 | 0 | 42.38353877 | -93.23654611 | 2022-12-30 04:21:04 | Hardin, Iowa, US | |
2022-12-29 | US | Indiana | Franklin | 18047 | 5083 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-30 04:21:04 | Franklin, Indiana, US | |
2022-12-29 | US | Idaho | Jefferson | 16051 | 6764 | 69 | 0 | 43.82078483 | -112.3131749 | 2022-12-30 04:21:04 | Jefferson, Idaho, US | |
2022-12-29 | US | Idaho | Boundary | 16021 | 2381 | 69 | 0 | 48.76684761 | -116.4630179 | 2022-12-30 04:21:04 | Boundary, Idaho, US | |
2022-12-29 | US | Georgia | Treutlen | 13283 | 1840 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-30 04:21:04 | Treutlen, Georgia, US | |
2022-12-29 | US | Georgia | Evans | 13109 | 2784 | 69 | 0 | 32.15328841 | -81.8870105 | 2022-12-30 04:21:04 | Evans, Georgia, US | |
2022-12-28 | US | Texas | Runnels | 48399 | 2699 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-29 04:21:01 | Runnels, Texas, US | |
2022-12-28 | US | Oklahoma | Choctaw | 40023 | 4882 | 69 | 0 | 34.02807439 | -95.54771129 | 2022-12-29 04:21:01 | Choctaw, Oklahoma, US | |
2022-12-28 | US | North Carolina | Yancey | 37199 | 6216 | 69 | 0 | 35.90079156 | -82.31237181 | 2022-12-29 04:21:01 | Yancey, North Carolina, US | |
2022-12-28 | US | North Carolina | Polk | 37149 | 4793 | 69 | 0 | 35.27820615 | -82.16812354 | 2022-12-29 04:21:01 | Polk, North Carolina, US | |
2022-12-28 | US | New Mexico | Quay | 35037 | 2497 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-12-29 04:21:01 | Quay, New Mexico, US | |
2022-12-28 | US | Michigan | Missaukee | 26113 | 3528 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-29 04:21:01 | Missaukee, Michigan, US | |
2022-12-28 | US | Michigan | Kalkaska | 26079 | 4428 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-29 04:21:01 | Kalkaska, Michigan, US | |
2022-12-28 | US | Kentucky | Washington | 21229 | 4948 | 69 | 0 | 37.75599461 | -85.17407732 | 2022-12-29 04:21:01 | Washington, Kentucky, US | |
2022-12-28 | US | Kentucky | Meade | 21163 | 7260 | 69 | 0 | 37.96163597 | -86.21028219 | 2022-12-29 04:21:01 | Meade, Kentucky, US | |
2022-12-28 | US | Iowa | Hardin | 19083 | 4964 | 69 | 0 | 42.38353877 | -93.23654611 | 2022-12-29 04:21:01 | Hardin, Iowa, US | |
2022-12-28 | US | Indiana | Franklin | 18047 | 5083 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-29 04:21:01 | Franklin, Indiana, US | |
2022-12-28 | US | Idaho | Jefferson | 16051 | 6764 | 69 | 0 | 43.82078483 | -112.3131749 | 2022-12-29 04:21:01 | Jefferson, Idaho, US | |
2022-12-28 | US | Idaho | Boundary | 16021 | 2381 | 69 | 0 | 48.76684761 | -116.4630179 | 2022-12-29 04:21:01 | Boundary, Idaho, US | |
2022-12-28 | US | Georgia | Treutlen | 13283 | 1840 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-29 04:21:01 | Treutlen, Georgia, US | |
2022-12-28 | US | Georgia | Evans | 13109 | 2784 | 69 | 0 | 32.15328841 | -81.8870105 | 2022-12-29 04:21:01 | Evans, Georgia, US | |
2022-12-27 | US | Wisconsin | Adams | 55001 | 5705 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-28 04:21:04 | Adams, Wisconsin, US | |
2022-12-27 | US | Texas | Runnels | 48399 | 2694 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-28 04:21:04 | Runnels, Texas, US | |
2022-12-27 | US | Oklahoma | Choctaw | 40023 | 4882 | 69 | 0 | 34.02807439 | -95.54771129 | 2022-12-28 04:21:04 | Choctaw, Oklahoma, US | |
2022-12-27 | US | North Carolina | Yancey | 37199 | 6216 | 69 | 0 | 35.90079156 | -82.31237181 | 2022-12-28 04:21:04 | Yancey, North Carolina, US | |
2022-12-27 | US | North Carolina | Polk | 37149 | 4793 | 69 | 0 | 35.27820615 | -82.16812354 | 2022-12-28 04:21:04 | Polk, North Carolina, US | |
2022-12-27 | US | New Mexico | Quay | 35037 | 2496 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-12-28 04:21:04 | Quay, New Mexico, US | |
2022-12-27 | US | Michigan | Missaukee | 26113 | 3528 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-28 04:21:04 | Missaukee, Michigan, US | |
2022-12-27 | US | Michigan | Kalkaska | 26079 | 4428 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-28 04:21:04 | Kalkaska, Michigan, US | |
2022-12-27 | US | Louisiana | Winn | 22127 | 5335 | 69 | 0 | 31.94449367 | -92.63789413 | 2022-12-28 04:21:04 | Winn, Louisiana, US | |
2022-12-27 | US | Kentucky | Washington | 21229 | 4948 | 69 | 0 | 37.75599461 | -85.17407732 | 2022-12-28 04:21:04 | Washington, Kentucky, US | |
2022-12-27 | US | Kentucky | Meade | 21163 | 7260 | 69 | 0 | 37.96163597 | -86.21028219 | 2022-12-28 04:21:04 | Meade, Kentucky, US | |
2022-12-27 | US | Iowa | Wright | 19197 | 3984 | 69 | 0 | 42.73305373 | -93.73515113 | 2022-12-28 04:21:04 | Wright, Iowa, US | |
2022-12-27 | US | Indiana | Franklin | 18047 | 5083 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-28 04:21:04 | Franklin, Indiana, US | |
2022-12-27 | US | Idaho | Jefferson | 16051 | 6753 | 69 | 0 | 43.82078483 | -112.3131749 | 2022-12-28 04:21:04 | Jefferson, Idaho, US | |
2022-12-27 | US | Idaho | Boundary | 16021 | 2369 | 69 | 0 | 48.76684761 | -116.4630179 | 2022-12-28 04:21:04 | Boundary, Idaho, US | |
2022-12-27 | US | Georgia | Treutlen | 13283 | 1835 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-28 04:21:04 | Treutlen, Georgia, US | |
2022-12-27 | US | Georgia | Evans | 13109 | 2775 | 69 | 0 | 32.15328841 | -81.8870105 | 2022-12-28 04:21:04 | Evans, Georgia, US | |
2022-12-26 | US | Wisconsin | Adams | 55001 | 5704 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-27 04:21:07 | Adams, Wisconsin, US | |
2022-12-26 | US | Texas | Runnels | 48399 | 2694 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-27 04:21:07 | Runnels, Texas, US | |
2022-12-26 | US | Oklahoma | Choctaw | 40023 | 4882 | 69 | 0 | 34.02807439 | -95.54771129 | 2022-12-27 04:21:07 | Choctaw, Oklahoma, US | |
2022-12-26 | US | North Carolina | Yancey | 37199 | 6216 | 69 | 0 | 35.90079156 | -82.31237181 | 2022-12-27 04:21:07 | Yancey, North Carolina, US | |
2022-12-26 | US | North Carolina | Polk | 37149 | 4793 | 69 | 0 | 35.27820615 | -82.16812354 | 2022-12-27 04:21:07 | Polk, North Carolina, US | |
2022-12-26 | US | New Mexico | Quay | 35037 | 2494 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-12-27 04:21:07 | Quay, New Mexico, US | |
2022-12-26 | US | Michigan | Missaukee | 26113 | 3515 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-27 04:21:07 | Missaukee, Michigan, US | |
2022-12-26 | US | Michigan | Kalkaska | 26079 | 4406 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-27 04:21:07 | Kalkaska, Michigan, US | |
2022-12-26 | US | Louisiana | Winn | 22127 | 5335 | 69 | 0 | 31.94449367 | -92.63789413 | 2022-12-27 04:21:07 | Winn, Louisiana, US | |
2022-12-26 | US | Kentucky | Washington | 21229 | 4905 | 69 | 0 | 37.75599461 | -85.17407732 | 2022-12-27 04:21:07 | Washington, Kentucky, US | |
2022-12-26 | US | Kentucky | Meade | 21163 | 7223 | 69 | 0 | 37.96163597 | -86.21028219 | 2022-12-27 04:21:07 | Meade, Kentucky, US | |
2022-12-26 | US | Iowa | Wright | 19197 | 3984 | 69 | 0 | 42.73305373 | -93.73515113 | 2022-12-27 04:21:07 | Wright, Iowa, US | |
2022-12-26 | US | Indiana | Franklin | 18047 | 5083 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-27 04:21:07 | Franklin, Indiana, US | |
2022-12-26 | US | Idaho | Jefferson | 16051 | 6753 | 69 | 0 | 43.82078483 | -112.3131749 | 2022-12-27 04:21:07 | Jefferson, Idaho, US | |
2022-12-26 | US | Idaho | Boundary | 16021 | 2369 | 69 | 0 | 48.76684761 | -116.4630179 | 2022-12-27 04:21:07 | Boundary, Idaho, US | |
2022-12-26 | US | Georgia | Treutlen | 13283 | 1835 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-27 04:21:07 | Treutlen, Georgia, US | |
2022-12-26 | US | Georgia | Evans | 13109 | 2775 | 69 | 0 | 32.15328841 | -81.8870105 | 2022-12-27 04:21:07 | Evans, Georgia, US | |
2022-12-25 | US | Wisconsin | Adams | 55001 | 5701 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-26 04:21:06 | Adams, Wisconsin, US | |
2022-12-25 | US | Texas | Runnels | 48399 | 2694 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-26 04:21:06 | Runnels, Texas, US | |
2022-12-25 | US | Oklahoma | Choctaw | 40023 | 4882 | 69 | 0 | 34.02807439 | -95.54771129 | 2022-12-26 04:21:06 | Choctaw, Oklahoma, US | |
2022-12-25 | US | North Carolina | Yancey | 37199 | 6216 | 69 | 0 | 35.90079156 | -82.31237181 | 2022-12-26 04:21:06 | Yancey, North Carolina, US | |
2022-12-25 | US | North Carolina | Polk | 37149 | 4793 | 69 | 0 | 35.27820615 | -82.16812354 | 2022-12-26 04:21:06 | Polk, North Carolina, US | |
2022-12-25 | US | New Mexico | Quay | 35037 | 2494 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-12-26 04:21:06 | Quay, New Mexico, US | |
2022-12-25 | US | Michigan | Missaukee | 26113 | 3515 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-26 04:21:06 | Missaukee, Michigan, US | |
2022-12-25 | US | Michigan | Kalkaska | 26079 | 4406 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-26 04:21:06 | Kalkaska, Michigan, US | |
2022-12-25 | US | Louisiana | Winn | 22127 | 5335 | 69 | 0 | 31.94449367 | -92.63789413 | 2022-12-26 04:21:06 | Winn, Louisiana, US | |
2022-12-25 | US | Kentucky | Washington | 21229 | 4905 | 69 | 0 | 37.75599461 | -85.17407732 | 2022-12-26 04:21:06 | Washington, Kentucky, US | |
2022-12-25 | US | Kentucky | Meade | 21163 | 7223 | 69 | 0 | 37.96163597 | -86.21028219 | 2022-12-26 04:21:06 | Meade, Kentucky, US | |
2022-12-25 | US | Iowa | Wright | 19197 | 3984 | 69 | 0 | 42.73305373 | -93.73515113 | 2022-12-26 04:21:06 | Wright, Iowa, US | |
2022-12-25 | US | Indiana | Franklin | 18047 | 5083 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-26 04:21:06 | Franklin, Indiana, US | |
2022-12-25 | US | Idaho | Jefferson | 16051 | 6753 | 69 | 0 | 43.82078483 | -112.3131749 | 2022-12-26 04:21:06 | Jefferson, Idaho, US | |
2022-12-25 | US | Idaho | Boundary | 16021 | 2369 | 69 | 0 | 48.76684761 | -116.4630179 | 2022-12-26 04:21:06 | Boundary, Idaho, US | |
2022-12-25 | US | Georgia | Treutlen | 13283 | 1835 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-26 04:21:06 | Treutlen, Georgia, US | |
2022-12-25 | US | Georgia | Evans | 13109 | 2775 | 69 | 0 | 32.15328841 | -81.8870105 | 2022-12-26 04:21:06 | Evans, Georgia, US | |
2022-12-24 | US | Wisconsin | Adams | 55001 | 5701 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-25 04:21:04 | Adams, Wisconsin, US | |
2022-12-24 | US | Texas | Runnels | 48399 | 2694 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-25 04:21:04 | Runnels, Texas, US | |
2022-12-24 | US | Oklahoma | Choctaw | 40023 | 4882 | 69 | 0 | 34.02807439 | -95.54771129 | 2022-12-25 04:21:04 | Choctaw, Oklahoma, US | |
2022-12-24 | US | North Carolina | Yancey | 37199 | 6216 | 69 | 0 | 35.90079156 | -82.31237181 | 2022-12-25 04:21:04 | Yancey, North Carolina, US | |
2022-12-24 | US | North Carolina | Polk | 37149 | 4793 | 69 | 0 | 35.27820615 | -82.16812354 | 2022-12-25 04:21:04 | Polk, North Carolina, US | |
2022-12-24 | US | New Mexico | Quay | 35037 | 2494 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-12-25 04:21:04 | Quay, New Mexico, US | |
2022-12-24 | US | Michigan | Missaukee | 26113 | 3515 | 69 | 0 | 44.33772443 | -85.09256478 | 2022-12-25 04:21:04 | Missaukee, Michigan, US | |
2022-12-24 | US | Michigan | Kalkaska | 26079 | 4406 | 69 | 0 | 44.68512729 | -85.09085699 | 2022-12-25 04:21:04 | Kalkaska, Michigan, US | |
2022-12-24 | US | Louisiana | Winn | 22127 | 5335 | 69 | 0 | 31.94449367 | -92.63789413 | 2022-12-25 04:21:04 | Winn, Louisiana, US | |
2022-12-24 | US | Kentucky | Washington | 21229 | 4905 | 69 | 0 | 37.75599461 | -85.17407732 | 2022-12-25 04:21:04 | Washington, Kentucky, US | |
2022-12-24 | US | Kentucky | Meade | 21163 | 7223 | 69 | 0 | 37.96163597 | -86.21028219 | 2022-12-25 04:21:04 | Meade, Kentucky, US | |
2022-12-24 | US | Iowa | Wright | 19197 | 3984 | 69 | 0 | 42.73305373 | -93.73515113 | 2022-12-25 04:21:04 | Wright, Iowa, US | |
2022-12-24 | US | Indiana | Franklin | 18047 | 5083 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-25 04:21:04 | Franklin, Indiana, US | |
2022-12-24 | US | Idaho | Jefferson | 16051 | 6753 | 69 | 0 | 43.82078483 | -112.3131749 | 2022-12-25 04:21:04 | Jefferson, Idaho, US | |
2022-12-24 | US | Idaho | Boundary | 16021 | 2369 | 69 | 0 | 48.76684761 | -116.4630179 | 2022-12-25 04:21:04 | Boundary, Idaho, US | |
2022-12-24 | US | Georgia | Treutlen | 13283 | 1835 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-25 04:21:04 | Treutlen, Georgia, US | |
2022-12-24 | US | Georgia | Evans | 13109 | 2775 | 69 | 0 | 32.15328841 | -81.8870105 | 2022-12-25 04:21:04 | Evans, Georgia, US | |
2022-12-23 | US | Wisconsin | Adams | 55001 | 5701 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-24 04:21:02 | Adams, Wisconsin, US | |
2022-12-23 | US | Texas | Runnels | 48399 | 2694 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-12-24 04:21:02 | Runnels, Texas, US | |
2022-12-23 | US | Oklahoma | Choctaw | 40023 | 4882 | 69 | 0 | 34.02807439 | -95.54771129 | 2022-12-24 04:21:02 | Choctaw, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;