daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
627 rows where deaths = 31 and province_or_state = "Tennessee" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-03-08 | US | Tennessee | Pickett | 47137 | 1774 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-09 04:20:59 | Pickett, Tennessee, US | |
2022-03-07 | US | Tennessee | Pickett | 47137 | 1774 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-08 04:20:54 | Pickett, Tennessee, US | |
2022-03-06 | US | Tennessee | Pickett | 47137 | 1774 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-07 04:20:47 | Pickett, Tennessee, US | |
2022-03-05 | US | Tennessee | Pickett | 47137 | 1774 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-06 04:20:49 | Pickett, Tennessee, US | |
2022-03-04 | US | Tennessee | Pickett | 47137 | 1774 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-05 04:21:10 | Pickett, Tennessee, US | |
2022-03-03 | US | Tennessee | Pickett | 47137 | 1774 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-04 04:21:09 | Pickett, Tennessee, US | |
2022-03-02 | US | Tennessee | Pickett | 47137 | 1774 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-03 04:21:01 | Pickett, Tennessee, US | |
2022-03-01 | US | Tennessee | Pickett | 47137 | 1773 | 31 | 0 | 36.55606529 | -85.07763299999998 | 2022-03-02 04:21:07 | Pickett, Tennessee, US | |
2022-02-26 | US | Tennessee | Hancock | 47067 | 1989 | 31 | 0 | 36.52692871 | -83.22375847 | 2022-02-27 04:21:04 | Hancock, Tennessee, US | |
2022-02-25 | US | Tennessee | Hancock | 47067 | 1989 | 31 | 0 | 36.52692871 | -83.22375847 | 2022-02-26 04:21:12 | Hancock, Tennessee, US | |
2022-02-24 | US | Tennessee | Hancock | 47067 | 1988 | 31 | 0 | 36.52692871 | -83.22375847 | 2022-02-25 04:21:11 | Hancock, Tennessee, US | |
2022-02-23 | US | Tennessee | Hancock | 47067 | 1984 | 31 | 0 | 36.52692871 | -83.22375847 | 2022-02-24 04:21:14 | Hancock, Tennessee, US | |
2022-02-22 | US | Tennessee | Hancock | 47067 | 1979 | 31 | 0 | 36.52692871 | -83.22375847 | 2022-02-23 04:21:09 | Hancock, Tennessee, US | |
2021-12-29 | US | Tennessee | Moore | 47127 | 1524 | 31 | 0 | 35.27724699 | -86.36230578 | 2021-12-30 04:21:25 | Moore, Tennessee, US | |
2021-12-05 | US | Tennessee | Lake | 47095 | 2024 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-12-06 04:22:34 | Lake, Tennessee, US | |
2021-12-04 | US | Tennessee | Lake | 47095 | 2023 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-12-05 04:22:25 | Lake, Tennessee, US | |
2021-12-03 | US | Tennessee | Lake | 47095 | 2022 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-12-04 04:22:18 | Lake, Tennessee, US | |
2021-12-02 | US | Tennessee | Lake | 47095 | 2022 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-12-03 04:23:05 | Lake, Tennessee, US | |
2021-12-01 | US | Tennessee | Lake | 47095 | 2022 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-12-02 04:22:37 | Lake, Tennessee, US | |
2021-11-30 | US | Tennessee | Lake | 47095 | 2022 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-12-01 04:22:29 | Lake, Tennessee, US | |
2021-11-30 | US | Tennessee | Meigs | 47121 | 2244 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-12-01 04:22:29 | Meigs, Tennessee, US | |
2021-11-29 | US | Tennessee | Lake | 47095 | 2021 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-30 04:22:53 | Lake, Tennessee, US | |
2021-11-29 | US | Tennessee | Meigs | 47121 | 2243 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-11-30 04:22:53 | Meigs, Tennessee, US | |
2021-11-28 | US | Tennessee | Lake | 47095 | 2019 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-29 04:22:30 | Lake, Tennessee, US | |
2021-11-28 | US | Tennessee | Meigs | 47121 | 2240 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-11-29 04:22:30 | Meigs, Tennessee, US | |
2021-11-27 | US | Tennessee | Lake | 47095 | 2019 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-28 04:22:43 | Lake, Tennessee, US | |
2021-11-27 | US | Tennessee | Meigs | 47121 | 2239 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-11-28 04:22:43 | Meigs, Tennessee, US | |
2021-11-26 | US | Tennessee | Lake | 47095 | 2019 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-27 04:22:45 | Lake, Tennessee, US | |
2021-11-26 | US | Tennessee | Meigs | 47121 | 2239 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-11-27 04:22:45 | Meigs, Tennessee, US | |
2021-11-25 | US | Tennessee | Lake | 47095 | 2019 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-26 04:22:33 | Lake, Tennessee, US | |
2021-11-25 | US | Tennessee | Meigs | 47121 | 2239 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-11-26 04:22:33 | Meigs, Tennessee, US | |
2021-11-24 | US | Tennessee | Lake | 47095 | 2019 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-25 04:22:33 | Lake, Tennessee, US | |
2021-11-24 | US | Tennessee | Meigs | 47121 | 2238 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-11-25 04:22:33 | Meigs, Tennessee, US | |
2021-11-23 | US | Tennessee | Lake | 47095 | 2019 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-24 04:22:14 | Lake, Tennessee, US | |
2021-11-23 | US | Tennessee | Meigs | 47121 | 2236 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-11-24 04:22:14 | Meigs, Tennessee, US | |
2021-11-22 | US | Tennessee | Lake | 47095 | 2018 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-23 04:22:39 | Lake, Tennessee, US | |
2021-11-22 | US | Tennessee | Meigs | 47121 | 2234 | 31 | 0 | 35.51558739 | -84.81482914 | 2021-11-23 04:22:39 | Meigs, Tennessee, US | |
2021-11-21 | US | Tennessee | Lake | 47095 | 2018 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-22 04:22:20 | Lake, Tennessee, US | |
2021-11-20 | US | Tennessee | Lake | 47095 | 2018 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-21 04:22:13 | Lake, Tennessee, US | |
2021-11-19 | US | Tennessee | Lake | 47095 | 2018 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-20 04:22:17 | Lake, Tennessee, US | |
2021-11-18 | US | Tennessee | Lake | 47095 | 2018 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-19 04:21:40 | Lake, Tennessee, US | |
2021-11-18 | US | Tennessee | Polk | 47139 | 3227 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-19 04:21:40 | Polk, Tennessee, US | |
2021-11-17 | US | Tennessee | Lake | 47095 | 2018 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-18 04:21:33 | Lake, Tennessee, US | |
2021-11-17 | US | Tennessee | Polk | 47139 | 3226 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-18 04:21:33 | Polk, Tennessee, US | |
2021-11-16 | US | Tennessee | Lake | 47095 | 2018 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-17 04:21:48 | Lake, Tennessee, US | |
2021-11-16 | US | Tennessee | Polk | 47139 | 3223 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-17 04:21:48 | Polk, Tennessee, US | |
2021-11-15 | US | Tennessee | Lake | 47095 | 2017 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-16 04:21:10 | Lake, Tennessee, US | |
2021-11-15 | US | Tennessee | Polk | 47139 | 3221 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-16 04:21:10 | Polk, Tennessee, US | |
2021-11-14 | US | Tennessee | Lake | 47095 | 2017 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-15 04:21:36 | Lake, Tennessee, US | |
2021-11-14 | US | Tennessee | Polk | 47139 | 3214 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-15 04:21:36 | Polk, Tennessee, US | |
2021-11-13 | US | Tennessee | Lake | 47095 | 2017 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-14 04:21:31 | Lake, Tennessee, US | |
2021-11-13 | US | Tennessee | Polk | 47139 | 3212 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-14 04:21:31 | Polk, Tennessee, US | |
2021-11-12 | US | Tennessee | Lake | 47095 | 2017 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-13 04:21:38 | Lake, Tennessee, US | |
2021-11-12 | US | Tennessee | Polk | 47139 | 3209 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-13 04:21:38 | Polk, Tennessee, US | |
2021-11-11 | US | Tennessee | Lake | 47095 | 2017 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-12 04:22:01 | Lake, Tennessee, US | |
2021-11-11 | US | Tennessee | Polk | 47139 | 3208 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-12 04:22:01 | Polk, Tennessee, US | |
2021-11-10 | US | Tennessee | Lake | 47095 | 2017 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-11 04:21:45 | Lake, Tennessee, US | |
2021-11-10 | US | Tennessee | Polk | 47139 | 3208 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-11 04:21:45 | Polk, Tennessee, US | |
2021-11-09 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-10 04:21:38 | Lake, Tennessee, US | |
2021-11-09 | US | Tennessee | Polk | 47139 | 3204 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-10 04:21:38 | Polk, Tennessee, US | |
2021-11-08 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-09 04:21:36 | Lake, Tennessee, US | |
2021-11-08 | US | Tennessee | Polk | 47139 | 3203 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-09 04:21:36 | Polk, Tennessee, US | |
2021-11-07 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-08 04:21:43 | Lake, Tennessee, US | |
2021-11-07 | US | Tennessee | Polk | 47139 | 3201 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-08 04:21:43 | Polk, Tennessee, US | |
2021-11-06 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-07 04:21:53 | Lake, Tennessee, US | |
2021-11-06 | US | Tennessee | Polk | 47139 | 3200 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-07 04:21:53 | Polk, Tennessee, US | |
2021-11-05 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-06 04:21:51 | Lake, Tennessee, US | |
2021-11-05 | US | Tennessee | Polk | 47139 | 3199 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-06 04:21:51 | Polk, Tennessee, US | |
2021-11-04 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-05 04:21:54 | Lake, Tennessee, US | |
2021-11-04 | US | Tennessee | Polk | 47139 | 3197 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-05 04:21:54 | Polk, Tennessee, US | |
2021-11-03 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-04 04:22:20 | Lake, Tennessee, US | |
2021-11-03 | US | Tennessee | Polk | 47139 | 3195 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-04 04:22:20 | Polk, Tennessee, US | |
2021-11-02 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-03 06:22:09 | Lake, Tennessee, US | |
2021-11-02 | US | Tennessee | Polk | 47139 | 3190 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-03 06:22:09 | Polk, Tennessee, US | |
2021-11-01 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-02 04:22:03 | Lake, Tennessee, US | |
2021-11-01 | US | Tennessee | Polk | 47139 | 3189 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-02 04:22:03 | Polk, Tennessee, US | |
2021-10-31 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-11-01 04:22:01 | Lake, Tennessee, US | |
2021-10-31 | US | Tennessee | Polk | 47139 | 3185 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-01 04:22:01 | Polk, Tennessee, US | |
2021-10-30 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-31 04:22:08 | Lake, Tennessee, US | |
2021-10-30 | US | Tennessee | Polk | 47139 | 3185 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-10-31 04:22:08 | Polk, Tennessee, US | |
2021-10-29 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-30 04:22:03 | Lake, Tennessee, US | |
2021-10-29 | US | Tennessee | Polk | 47139 | 3185 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-10-30 04:22:03 | Polk, Tennessee, US | |
2021-10-28 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-29 04:22:03 | Lake, Tennessee, US | |
2021-10-28 | US | Tennessee | Polk | 47139 | 3184 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-10-29 04:22:03 | Polk, Tennessee, US | |
2021-10-27 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-28 04:22:08 | Lake, Tennessee, US | |
2021-10-27 | US | Tennessee | Polk | 47139 | 3181 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-10-28 04:22:08 | Polk, Tennessee, US | |
2021-10-26 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-27 04:22:32 | Lake, Tennessee, US | |
2021-10-26 | US | Tennessee | Polk | 47139 | 3180 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-10-27 04:22:32 | Polk, Tennessee, US | |
2021-10-25 | US | Tennessee | Lake | 47095 | 2016 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-26 04:22:09 | Lake, Tennessee, US | |
2021-10-24 | US | Tennessee | Lake | 47095 | 2013 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-25 04:22:31 | Lake, Tennessee, US | |
2021-10-23 | US | Tennessee | Lake | 47095 | 2013 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-24 04:21:22 | Lake, Tennessee, US | |
2021-10-22 | US | Tennessee | Lake | 47095 | 2013 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-23 04:21:32 | Lake, Tennessee, US | |
2021-10-21 | US | Tennessee | Lake | 47095 | 2012 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-22 04:21:14 | Lake, Tennessee, US | |
2021-10-20 | US | Tennessee | Lake | 47095 | 2012 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-21 04:21:18 | Lake, Tennessee, US | |
2021-10-19 | US | Tennessee | Lake | 47095 | 2009 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-20 04:21:00 | Lake, Tennessee, US | |
2021-10-18 | US | Tennessee | Lake | 47095 | 2008 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-19 04:20:54 | Lake, Tennessee, US | |
2021-10-17 | US | Tennessee | Lake | 47095 | 2004 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-18 04:21:10 | Lake, Tennessee, US | |
2021-10-16 | US | Tennessee | Lake | 47095 | 2004 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-17 04:21:29 | Lake, Tennessee, US | |
2021-10-15 | US | Tennessee | Lake | 47095 | 2003 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-16 04:21:15 | Lake, Tennessee, US | |
2021-10-14 | US | Tennessee | Lake | 47095 | 2001 | 31 | 0 | 36.34180170000001 | -89.48921915 | 2021-10-15 04:21:26 | Lake, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;