daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,557 rows where deaths = 202 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 2,205
- Japan 100
- Russia 61
- Sweden 33
- Spain 27
- India 18
- Chile 16
- Colombia 13
- Pakistan 10
- Nicaragua 7
- China 5
- Germany 5
- Italy 5
- Ukraine 5
- Botswana 4
- Canada 4
- Morocco 4
- Netherlands 4
- Peru 3
- Brazil 2
- Brunei 2
- Greece 2
- Mexico 2
- Bahrain 1
- Cote d'Ivoire 1
- El Salvador 1
- Estonia 1
- Grenada 1
- Guinea 1
- Israel 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Texas | Hill | 48217 | 9931 | 202 | 0 | 31.99045053 | -97.13423143 | 2022-12-30 04:21:04 | Hill, Texas, US | |
2022-12-29 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-30 04:21:04 | Halifax, North Carolina, US | |
2022-12-29 | US | Michigan | Ionia | 26067 | 19552 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-30 04:21:04 | Ionia, Michigan, US | |
2022-12-29 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Indiana, US | |
2022-12-29 | Sweden | Blekinge | 31930 | 202 | 0 | 56.2784 | 15.018 | 2022-12-30 04:21:04 | Blekinge, Sweden | |||
2022-12-28 | US | Texas | Hill | 48217 | 9931 | 202 | 0 | 31.99045053 | -97.13423143 | 2022-12-29 04:21:01 | Hill, Texas, US | |
2022-12-28 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-29 04:21:01 | Halifax, North Carolina, US | |
2022-12-28 | US | Michigan | Ionia | 26067 | 19552 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-29 04:21:01 | Ionia, Michigan, US | |
2022-12-28 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Indiana, US | |
2022-12-27 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-28 04:21:04 | Halifax, North Carolina, US | |
2022-12-27 | US | Michigan | Ionia | 26067 | 19552 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-28 04:21:04 | Ionia, Michigan, US | |
2022-12-27 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Indiana, US | |
2022-12-27 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-28 04:21:04 | Murray, Georgia, US | |
2022-12-26 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-27 04:21:07 | Halifax, North Carolina, US | |
2022-12-26 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-27 04:21:07 | Ionia, Michigan, US | |
2022-12-26 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-27 04:21:07 | Boyd, Kentucky, US | |
2022-12-26 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Indiana, US | |
2022-12-26 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-27 04:21:07 | Murray, Georgia, US | |
2022-12-25 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-26 04:21:06 | Halifax, North Carolina, US | |
2022-12-25 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-26 04:21:06 | Ionia, Michigan, US | |
2022-12-25 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-26 04:21:06 | Boyd, Kentucky, US | |
2022-12-25 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Indiana, US | |
2022-12-25 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-26 04:21:06 | Murray, Georgia, US | |
2022-12-24 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-25 04:21:04 | Halifax, North Carolina, US | |
2022-12-24 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-25 04:21:04 | Ionia, Michigan, US | |
2022-12-24 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-25 04:21:04 | Boyd, Kentucky, US | |
2022-12-24 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-25 04:21:04 | Unassigned, Indiana, US | |
2022-12-24 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-25 04:21:04 | Murray, Georgia, US | |
2022-12-23 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-24 04:21:02 | Halifax, North Carolina, US | |
2022-12-23 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-24 04:21:02 | Ionia, Michigan, US | |
2022-12-23 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-24 04:21:02 | Boyd, Kentucky, US | |
2022-12-23 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-24 04:21:02 | Unassigned, Indiana, US | |
2022-12-23 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-24 04:21:02 | Murray, Georgia, US | |
2022-12-22 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-23 04:21:04 | Halifax, North Carolina, US | |
2022-12-22 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-23 04:21:04 | Ionia, Michigan, US | |
2022-12-22 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-23 04:21:04 | Boyd, Kentucky, US | |
2022-12-22 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-23 04:21:04 | Unassigned, Indiana, US | |
2022-12-22 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-23 04:21:04 | Murray, Georgia, US | |
2022-12-21 | US | North Carolina | Halifax | 37083 | 17805 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-22 04:20:56 | Halifax, North Carolina, US | |
2022-12-21 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-22 04:20:56 | Rice, Minnesota, US | |
2022-12-21 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-22 04:20:56 | Ionia, Michigan, US | |
2022-12-21 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-22 04:20:56 | Boyd, Kentucky, US | |
2022-12-21 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-22 04:20:56 | Unassigned, Indiana, US | |
2022-12-21 | US | Georgia | Murray | 13213 | 13180 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-22 04:20:56 | Murray, Georgia, US | |
2022-12-20 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-21 04:21:03 | Halifax, North Carolina, US | |
2022-12-20 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-21 04:21:03 | Rice, Minnesota, US | |
2022-12-20 | US | Michigan | Ionia | 26067 | 19468 | 202 | 0 | 42.94502238 | -85.07413319 | 2022-12-21 04:21:03 | Ionia, Michigan, US | |
2022-12-20 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-21 04:21:03 | Boyd, Kentucky, US | |
2022-12-20 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-21 04:21:03 | Unassigned, Indiana, US | |
2022-12-20 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-21 04:21:03 | Murray, Georgia, US | |
2022-12-19 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-20 04:21:04 | Halifax, North Carolina, US | |
2022-12-19 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-20 04:21:04 | Rice, Minnesota, US | |
2022-12-19 | US | Kentucky | Boyd | 21019 | 21608 | 202 | 0 | 38.36176608 | -82.68652187 | 2022-12-20 04:21:04 | Boyd, Kentucky, US | |
2022-12-19 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-20 04:21:04 | Unassigned, Indiana, US | |
2022-12-19 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-20 04:21:04 | Murray, Georgia, US | |
2022-12-18 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-19 04:21:03 | Halifax, North Carolina, US | |
2022-12-18 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-19 04:21:03 | Rice, Minnesota, US | |
2022-12-18 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-19 04:21:03 | Unassigned, Indiana, US | |
2022-12-18 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-19 04:21:03 | Murray, Georgia, US | |
2022-12-17 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-18 04:21:03 | Halifax, North Carolina, US | |
2022-12-17 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-18 04:21:03 | Rice, Minnesota, US | |
2022-12-17 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-18 04:21:03 | Unassigned, Indiana, US | |
2022-12-17 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-18 04:21:03 | Murray, Georgia, US | |
2022-12-16 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-17 04:21:04 | Halifax, North Carolina, US | |
2022-12-16 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-17 04:21:04 | Rice, Minnesota, US | |
2022-12-16 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-17 04:21:04 | Unassigned, Indiana, US | |
2022-12-16 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-17 04:21:04 | Murray, Georgia, US | |
2022-12-15 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-16 04:21:01 | Halifax, North Carolina, US | |
2022-12-15 | US | New Hampshire | Belknap | 33001 | 16755 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-16 04:21:01 | Belknap, New Hampshire, US | |
2022-12-15 | US | Minnesota | Rice | 27131 | 20294 | 202 | 0 | 44.3543376 | -93.29658715 | 2022-12-16 04:21:01 | Rice, Minnesota, US | |
2022-12-15 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-16 04:21:01 | Unassigned, Indiana, US | |
2022-12-15 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-16 04:21:01 | Murray, Georgia, US | |
2022-12-14 | US | North Carolina | Halifax | 37083 | 17719 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-15 04:20:58 | Halifax, North Carolina, US | |
2022-12-14 | US | New Hampshire | Belknap | 33001 | 16741 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-15 04:20:58 | Belknap, New Hampshire, US | |
2022-12-14 | US | Indiana | Unassigned | 90018 | 0 | 202 | 0 | 41.64423868 | 0.0 | 2022-12-15 04:20:58 | Unassigned, Indiana, US | |
2022-12-14 | US | Georgia | Murray | 13213 | 13124 | 202 | 0 | 34.78897608 | -84.74993177 | 2022-12-15 04:20:58 | Murray, Georgia, US | |
2022-12-13 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-14 04:21:04 | Lincoln, North Carolina, US | |
2022-12-13 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-14 04:21:04 | Halifax, North Carolina, US | |
2022-12-13 | US | New Hampshire | Belknap | 33001 | 16725 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-14 04:21:04 | Belknap, New Hampshire, US | |
2022-12-12 | US | Tennessee | Franklin | 47051 | 15404 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-13 04:21:01 | Franklin, Tennessee, US | |
2022-12-12 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-13 04:21:01 | Lincoln, North Carolina, US | |
2022-12-12 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-13 04:21:01 | Halifax, North Carolina, US | |
2022-12-12 | US | New Hampshire | Belknap | 33001 | 16716 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-13 04:21:01 | Belknap, New Hampshire, US | |
2022-12-11 | US | Tennessee | Franklin | 47051 | 15402 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-12 04:21:01 | Franklin, Tennessee, US | |
2022-12-11 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-12 04:21:01 | Lincoln, North Carolina, US | |
2022-12-11 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-12 04:21:01 | Halifax, North Carolina, US | |
2022-12-11 | US | New Hampshire | Belknap | 33001 | 16699 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-12 04:21:01 | Belknap, New Hampshire, US | |
2022-12-10 | US | Tennessee | Franklin | 47051 | 15402 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-11 04:20:50 | Franklin, Tennessee, US | |
2022-12-10 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-11 04:20:50 | Lincoln, North Carolina, US | |
2022-12-10 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-11 04:20:50 | Halifax, North Carolina, US | |
2022-12-10 | US | New Hampshire | Belknap | 33001 | 16699 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-11 04:20:50 | Belknap, New Hampshire, US | |
2022-12-09 | US | Tennessee | Franklin | 47051 | 15399 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-10 04:21:02 | Franklin, Tennessee, US | |
2022-12-09 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-10 04:21:02 | Lincoln, North Carolina, US | |
2022-12-09 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-10 04:21:02 | Halifax, North Carolina, US | |
2022-12-09 | US | New Hampshire | Belknap | 33001 | 16699 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-10 04:21:02 | Belknap, New Hampshire, US | |
2022-12-08 | US | Tennessee | Franklin | 47051 | 15380 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-09 04:21:05 | Franklin, Tennessee, US | |
2022-12-08 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-09 04:21:05 | Lincoln, North Carolina, US | |
2022-12-08 | US | North Carolina | Halifax | 37083 | 17637 | 202 | 0 | 36.25669272 | -77.6556109 | 2022-12-09 04:21:05 | Halifax, North Carolina, US | |
2022-12-07 | US | Tennessee | Franklin | 47051 | 15371 | 202 | 0 | 35.15634626 | -86.09201039 | 2022-12-08 04:21:07 | Franklin, Tennessee, US | |
2022-12-07 | US | North Carolina | Lincoln | 37109 | 28890 | 202 | 0 | 35.48508185 | -81.21740317 | 2022-12-08 04:21:07 | Lincoln, North Carolina, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;