daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,916 rows where deaths = 255 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 1,587
- Sweden 50
- Russia 40
- Colombia 38
- Japan 37
- Netherlands 22
- Norway 17
- France 14
- Canada 11
- Germany 11
- Malaysia 10
- Madagascar 9
- Chile 7
- Peru 6
- India 5
- Brazil 4
- Maldives 4
- Pakistan 3
- Qatar 3
- Saint Lucia 3
- Ukraine 3
- Zimbabwe 3
- Congo (Kinshasa) 2
- Italy 2
- Mexico 2
- Spain 2
- Angola 1
- Australia 1
- Bahrain 1
- Barbados 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Tennessee | Tipton | 47167 | 21337 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-30 04:21:04 | Tipton, Tennessee, US | |
2022-12-28 | US | Tennessee | Tipton | 47167 | 21337 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-29 04:21:01 | Tipton, Tennessee, US | |
2022-12-27 | US | Tennessee | Tipton | 47167 | 21337 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-28 04:21:04 | Tipton, Tennessee, US | |
2022-12-26 | US | Tennessee | Tipton | 47167 | 21337 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-27 04:21:07 | Tipton, Tennessee, US | |
2022-12-26 | US | Michigan | Shiawassee | 26155 | 21584 | 255 | 0 | 42.953928 | -84.14585902 | 2022-12-27 04:21:07 | Shiawassee, Michigan, US | |
2022-12-25 | US | Tennessee | Tipton | 47167 | 21337 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-26 04:21:06 | Tipton, Tennessee, US | |
2022-12-25 | US | Michigan | Shiawassee | 26155 | 21584 | 255 | 0 | 42.953928 | -84.14585902 | 2022-12-26 04:21:06 | Shiawassee, Michigan, US | |
2022-12-24 | US | Tennessee | Tipton | 47167 | 21337 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-25 04:21:04 | Tipton, Tennessee, US | |
2022-12-24 | US | Michigan | Shiawassee | 26155 | 21584 | 255 | 0 | 42.953928 | -84.14585902 | 2022-12-25 04:21:04 | Shiawassee, Michigan, US | |
2022-12-23 | US | Tennessee | Tipton | 47167 | 21334 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-24 04:21:02 | Tipton, Tennessee, US | |
2022-12-23 | US | Michigan | Shiawassee | 26155 | 21584 | 255 | 0 | 42.953928 | -84.14585902 | 2022-12-24 04:21:02 | Shiawassee, Michigan, US | |
2022-12-22 | US | Tennessee | Tipton | 47167 | 21329 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-23 04:21:04 | Tipton, Tennessee, US | |
2022-12-22 | US | Michigan | Shiawassee | 26155 | 21584 | 255 | 0 | 42.953928 | -84.14585902 | 2022-12-23 04:21:04 | Shiawassee, Michigan, US | |
2022-12-21 | US | Tennessee | Tipton | 47167 | 21314 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-22 04:20:56 | Tipton, Tennessee, US | |
2022-12-21 | US | Michigan | Shiawassee | 26155 | 21584 | 255 | 0 | 42.953928 | -84.14585902 | 2022-12-22 04:20:56 | Shiawassee, Michigan, US | |
2022-12-20 | US | Tennessee | Tipton | 47167 | 21296 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-21 04:21:03 | Tipton, Tennessee, US | |
2022-12-20 | US | Michigan | Shiawassee | 26155 | 21584 | 255 | 0 | 42.953928 | -84.14585902 | 2022-12-21 04:21:03 | Shiawassee, Michigan, US | |
2022-12-19 | US | Tennessee | Tipton | 47167 | 21270 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-20 04:21:04 | Tipton, Tennessee, US | |
2022-12-18 | US | Tennessee | Tipton | 47167 | 21250 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-19 04:21:03 | Tipton, Tennessee, US | |
2022-12-17 | US | Tennessee | Tipton | 47167 | 21248 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-18 04:21:03 | Tipton, Tennessee, US | |
2022-12-16 | US | Tennessee | Tipton | 47167 | 21237 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-17 04:21:04 | Tipton, Tennessee, US | |
2022-12-15 | US | Tennessee | Tipton | 47167 | 21210 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-16 04:21:01 | Tipton, Tennessee, US | |
2022-12-14 | US | Tennessee | Tipton | 47167 | 21187 | 255 | 0 | 35.501942 | -89.73694895 | 2022-12-15 04:20:58 | Tipton, Tennessee, US | |
2022-12-13 | US | Alabama | Covington | 1039 | 11183 | 255 | 0 | 31.2477854 | -86.45050893 | 2022-12-14 04:21:04 | Covington, Alabama, US | |
2022-12-12 | US | New York | Chemung | 36015 | 26026 | 255 | 0 | 42.13891056 | -76.7638805 | 2022-12-13 04:21:01 | Chemung, New York, US | |
2022-12-12 | US | Missouri | Phelps | 29161 | 12440 | 255 | 0 | 37.87736118 | -91.79351727 | 2022-12-13 04:21:01 | Phelps, Missouri, US | |
2022-12-12 | US | Alabama | Covington | 1039 | 11183 | 255 | 0 | 31.2477854 | -86.45050893 | 2022-12-13 04:21:01 | Covington, Alabama, US | |
2022-12-11 | US | New York | Chemung | 36015 | 26022 | 255 | 0 | 42.13891056 | -76.7638805 | 2022-12-12 04:21:01 | Chemung, New York, US | |
2022-12-11 | US | Missouri | Phelps | 29161 | 12440 | 255 | 0 | 37.87736118 | -91.79351727 | 2022-12-12 04:21:01 | Phelps, Missouri, US | |
2022-12-11 | US | Alabama | Covington | 1039 | 11183 | 255 | 0 | 31.2477854 | -86.45050893 | 2022-12-12 04:21:01 | Covington, Alabama, US | |
2022-12-10 | US | New York | Chemung | 36015 | 26004 | 255 | 0 | 42.13891056 | -76.7638805 | 2022-12-11 04:20:50 | Chemung, New York, US | |
2022-12-10 | US | Missouri | Phelps | 29161 | 12440 | 255 | 0 | 37.87736118 | -91.79351727 | 2022-12-11 04:20:50 | Phelps, Missouri, US | |
2022-12-10 | US | Alabama | Covington | 1039 | 11183 | 255 | 0 | 31.2477854 | -86.45050893 | 2022-12-11 04:20:50 | Covington, Alabama, US | |
2022-12-09 | US | New York | Chemung | 36015 | 25985 | 255 | 0 | 42.13891056 | -76.7638805 | 2022-12-10 04:21:02 | Chemung, New York, US | |
2022-12-09 | US | Missouri | Phelps | 29161 | 12440 | 255 | 0 | 37.87736118 | -91.79351727 | 2022-12-10 04:21:02 | Phelps, Missouri, US | |
2022-12-09 | US | Alabama | Covington | 1039 | 11183 | 255 | 0 | 31.2477854 | -86.45050893 | 2022-12-10 04:21:02 | Covington, Alabama, US | |
2022-12-08 | US | New York | Chemung | 36015 | 25970 | 255 | 0 | 42.13891056 | -76.7638805 | 2022-12-09 04:21:05 | Chemung, New York, US | |
2022-12-08 | US | Missouri | Phelps | 29161 | 12440 | 255 | 0 | 37.87736118 | -91.79351727 | 2022-12-09 04:21:05 | Phelps, Missouri, US | |
2022-12-08 | US | Alabama | Covington | 1039 | 11183 | 255 | 0 | 31.2477854 | -86.45050893 | 2022-12-09 04:21:05 | Covington, Alabama, US | |
2022-12-07 | US | New York | Chemung | 36015 | 25955 | 255 | 0 | 42.13891056 | -76.7638805 | 2022-12-08 04:21:07 | Chemung, New York, US | |
2022-12-07 | US | Missouri | Phelps | 29161 | 12440 | 255 | 0 | 37.87736118 | -91.79351727 | 2022-12-08 04:21:07 | Phelps, Missouri, US | |
2022-12-07 | US | Alabama | Covington | 1039 | 11183 | 255 | 0 | 31.2477854 | -86.45050893 | 2022-12-08 04:21:07 | Covington, Alabama, US | |
2022-12-06 | US | New York | Chemung | 36015 | 25936 | 255 | 0 | 42.13891056 | -76.7638805 | 2022-12-07 04:20:58 | Chemung, New York, US | |
2022-12-06 | US | Missouri | Phelps | 29161 | 12440 | 255 | 0 | 37.87736118 | -91.79351727 | 2022-12-07 04:20:58 | Phelps, Missouri, US | |
2022-12-01 | US | Ohio | Sandusky | 39143 | 16659 | 255 | 0 | 41.35624126 | -83.137872 | 2022-12-02 04:21:07 | Sandusky, Ohio, US | |
2022-11-30 | US | Ohio | Sandusky | 39143 | 16576 | 255 | 0 | 41.35624126 | -83.137872 | 2022-12-01 04:21:03 | Sandusky, Ohio, US | |
2022-11-29 | US | Ohio | Sandusky | 39143 | 16576 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-30 04:21:07 | Sandusky, Ohio, US | |
2022-11-29 | US | Alabama | Dallas | 1047 | 10195 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-30 04:21:07 | Dallas, Alabama, US | |
2022-11-29 | Japan | Yamagata | 162237 | 255 | 0 | 38.448396 | 140.102154 | 2022-11-30 04:21:07 | Yamagata, Japan | |||
2022-11-28 | US | Wisconsin | Wood | 55141 | 25815 | 255 | 0 | 44.45537896 | -90.04158336 | 2022-11-29 04:21:05 | Wood, Wisconsin, US | |
2022-11-28 | US | Ohio | Sandusky | 39143 | 16576 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-29 04:21:05 | Sandusky, Ohio, US | |
2022-11-28 | US | Alabama | Dallas | 1047 | 10195 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-29 04:21:05 | Dallas, Alabama, US | |
2022-11-27 | US | Wisconsin | Wood | 55141 | 25788 | 255 | 0 | 44.45537896 | -90.04158336 | 2022-11-28 04:21:02 | Wood, Wisconsin, US | |
2022-11-27 | US | Ohio | Sandusky | 39143 | 16576 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-28 04:21:02 | Sandusky, Ohio, US | |
2022-11-27 | US | Alabama | Dallas | 1047 | 10195 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-28 04:21:02 | Dallas, Alabama, US | |
2022-11-26 | US | Wisconsin | Wood | 55141 | 25788 | 255 | 0 | 44.45537896 | -90.04158336 | 2022-11-27 04:21:05 | Wood, Wisconsin, US | |
2022-11-26 | US | Ohio | Sandusky | 39143 | 16576 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-27 04:21:05 | Sandusky, Ohio, US | |
2022-11-26 | US | Alabama | Dallas | 1047 | 10195 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-27 04:21:05 | Dallas, Alabama, US | |
2022-11-26 | Japan | Iwate | 149276 | 255 | 0 | 39.593287 | 141.361777 | 2022-11-27 04:21:05 | Iwate, Japan | |||
2022-11-25 | US | Wisconsin | Wood | 55141 | 25788 | 255 | 0 | 44.45537896 | -90.04158336 | 2022-11-26 04:21:11 | Wood, Wisconsin, US | |
2022-11-25 | US | Ohio | Sandusky | 39143 | 16576 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-26 04:21:11 | Sandusky, Ohio, US | |
2022-11-25 | US | Alabama | Dallas | 1047 | 10195 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-26 04:21:11 | Dallas, Alabama, US | |
2022-11-24 | US | Wisconsin | Wood | 55141 | 25782 | 255 | 0 | 44.45537896 | -90.04158336 | 2022-11-25 04:21:06 | Wood, Wisconsin, US | |
2022-11-24 | US | Ohio | Sandusky | 39143 | 16576 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-25 04:21:06 | Sandusky, Ohio, US | |
2022-11-24 | US | Alabama | Dallas | 1047 | 10195 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-25 04:21:06 | Dallas, Alabama, US | |
2022-11-23 | US | Wisconsin | Wood | 55141 | 25767 | 255 | 0 | 44.45537896 | -90.04158336 | 2022-11-24 04:21:09 | Wood, Wisconsin, US | |
2022-11-23 | US | Ohio | Sandusky | 39143 | 16576 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-24 04:21:09 | Sandusky, Ohio, US | |
2022-11-23 | US | Alabama | Dallas | 1047 | 10195 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-24 04:21:09 | Dallas, Alabama, US | |
2022-11-22 | US | Wisconsin | Wood | 55141 | 25764 | 255 | 0 | 44.45537896 | -90.04158336 | 2022-11-23 04:21:06 | Wood, Wisconsin, US | |
2022-11-22 | US | Ohio | Sandusky | 39143 | 16536 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-23 04:21:06 | Sandusky, Ohio, US | |
2022-11-22 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-23 04:21:06 | Dallas, Alabama, US | |
2022-11-21 | US | Wisconsin | Wood | 55141 | 25748 | 255 | 0 | 44.45537896 | -90.04158336 | 2022-11-22 04:20:47 | Wood, Wisconsin, US | |
2022-11-21 | US | Ohio | Sandusky | 39143 | 16536 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-22 04:20:47 | Sandusky, Ohio, US | |
2022-11-21 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-22 04:20:47 | Dallas, Alabama, US | |
2022-11-20 | US | Ohio | Sandusky | 39143 | 16536 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-21 04:21:05 | Sandusky, Ohio, US | |
2022-11-20 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-21 04:21:05 | Dallas, Alabama, US | |
2022-11-19 | US | Ohio | Sandusky | 39143 | 16536 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-20 04:21:08 | Sandusky, Ohio, US | |
2022-11-19 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-20 04:21:08 | Dallas, Alabama, US | |
2022-11-18 | US | Ohio | Sandusky | 39143 | 16536 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-19 04:21:14 | Sandusky, Ohio, US | |
2022-11-18 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-19 04:21:14 | Dallas, Alabama, US | |
2022-11-17 | US | Ohio | Sandusky | 39143 | 16536 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-18 04:21:15 | Sandusky, Ohio, US | |
2022-11-17 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-18 04:21:15 | Dallas, Alabama, US | |
2022-11-16 | US | Ohio | Sandusky | 39143 | 16490 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-17 04:21:11 | Sandusky, Ohio, US | |
2022-11-16 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-17 04:21:11 | Dallas, Alabama, US | |
2022-11-15 | US | Texas | Hardin | 48199 | 14155 | 255 | 0 | 30.33364686 | -94.38931817 | 2022-11-16 04:21:09 | Hardin, Texas, US | |
2022-11-15 | US | Ohio | Sandusky | 39143 | 16490 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-16 04:21:09 | Sandusky, Ohio, US | |
2022-11-15 | US | Alabama | Dallas | 1047 | 10182 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-16 04:21:09 | Dallas, Alabama, US | |
2022-11-14 | US | Texas | Hardin | 48199 | 14155 | 255 | 0 | 30.33364686 | -94.38931817 | 2022-11-15 04:21:16 | Hardin, Texas, US | |
2022-11-14 | US | Ohio | Sandusky | 39143 | 16490 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-15 04:21:16 | Sandusky, Ohio, US | |
2022-11-14 | US | Alabama | Dallas | 1047 | 10182 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-15 04:21:16 | Dallas, Alabama, US | |
2022-11-13 | US | Ohio | Sandusky | 39143 | 16490 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-14 04:21:09 | Sandusky, Ohio, US | |
2022-11-13 | US | Alabama | Dallas | 1047 | 10182 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-14 04:21:09 | Dallas, Alabama, US | |
2022-11-12 | US | Ohio | Sandusky | 39143 | 16490 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-13 04:21:14 | Sandusky, Ohio, US | |
2022-11-12 | US | Alabama | Dallas | 1047 | 10182 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-13 04:21:14 | Dallas, Alabama, US | |
2022-11-11 | US | Ohio | Sandusky | 39143 | 16490 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-12 04:20:41 | Sandusky, Ohio, US | |
2022-11-11 | US | Alabama | Dallas | 1047 | 10182 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-12 04:20:41 | Dallas, Alabama, US | |
2022-11-10 | US | Ohio | Sandusky | 39143 | 16490 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-11 04:21:22 | Sandusky, Ohio, US | |
2022-11-10 | US | Alabama | Dallas | 1047 | 10182 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-11 04:21:22 | Dallas, Alabama, US | |
2022-11-09 | US | Ohio | Sandusky | 39143 | 16437 | 255 | 0 | 41.35624126 | -83.137872 | 2022-11-10 04:21:16 | Sandusky, Ohio, US | |
2022-11-09 | US | Alabama | Dallas | 1047 | 10160 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-10 04:21:16 | Dallas, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;