ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
547 rows where deaths = 11 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Bledsoe 140
- Decatur 42
- Lawrence 19
- Morgan 18
- Polk 18
- Warren 14
- Robertson 13
- Cocke 12
- Bedford 11
- Cheatham 11
- Hancock 11
- Hardeman 11
- Smith 11
- Claiborne 10
- Williamson 10
- Anderson 9
- Sevier 9
- Rhea 8
- Grundy 7
- Haywood 7
- Maury 7
- Overton 7
- Fentress 6
- Moore 6
- Rutherford 6
- Fayette 5
- Jackson 5
- Lake 5
- Loudon 5
- Montgomery 5
- …
state 1
- Tennessee · 547 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1533275 | 1533275 | 2021-07-19 | Bledsoe | Tennessee | 47007 | 2247 | 11 |
1530028 | 1530028 | 2021-07-18 | Bledsoe | Tennessee | 47007 | 2239 | 11 |
1526781 | 1526781 | 2021-07-17 | Bledsoe | Tennessee | 47007 | 2239 | 11 |
1523534 | 1523534 | 2021-07-16 | Bledsoe | Tennessee | 47007 | 2239 | 11 |
1520286 | 1520286 | 2021-07-15 | Bledsoe | Tennessee | 47007 | 2239 | 11 |
1517038 | 1517038 | 2021-07-14 | Bledsoe | Tennessee | 47007 | 2239 | 11 |
1513791 | 1513791 | 2021-07-13 | Bledsoe | Tennessee | 47007 | 2239 | 11 |
1510545 | 1510545 | 2021-07-12 | Bledsoe | Tennessee | 47007 | 2238 | 11 |
1507298 | 1507298 | 2021-07-11 | Bledsoe | Tennessee | 47007 | 2231 | 11 |
1504052 | 1504052 | 2021-07-10 | Bledsoe | Tennessee | 47007 | 2231 | 11 |
1500806 | 1500806 | 2021-07-09 | Bledsoe | Tennessee | 47007 | 2231 | 11 |
1497560 | 1497560 | 2021-07-08 | Bledsoe | Tennessee | 47007 | 2230 | 11 |
1494313 | 1494313 | 2021-07-07 | Bledsoe | Tennessee | 47007 | 2230 | 11 |
1491066 | 1491066 | 2021-07-06 | Bledsoe | Tennessee | 47007 | 2230 | 11 |
1487819 | 1487819 | 2021-07-05 | Bledsoe | Tennessee | 47007 | 2225 | 11 |
1484572 | 1484572 | 2021-07-04 | Bledsoe | Tennessee | 47007 | 2225 | 11 |
1481326 | 1481326 | 2021-07-03 | Bledsoe | Tennessee | 47007 | 2225 | 11 |
1478079 | 1478079 | 2021-07-02 | Bledsoe | Tennessee | 47007 | 2225 | 11 |
1474833 | 1474833 | 2021-07-01 | Bledsoe | Tennessee | 47007 | 2220 | 11 |
1471587 | 1471587 | 2021-06-30 | Bledsoe | Tennessee | 47007 | 2217 | 11 |
1468342 | 1468342 | 2021-06-29 | Bledsoe | Tennessee | 47007 | 2215 | 11 |
1465097 | 1465097 | 2021-06-28 | Bledsoe | Tennessee | 47007 | 2215 | 11 |
1461852 | 1461852 | 2021-06-27 | Bledsoe | Tennessee | 47007 | 2213 | 11 |
1458607 | 1458607 | 2021-06-26 | Bledsoe | Tennessee | 47007 | 2213 | 11 |
1455362 | 1455362 | 2021-06-25 | Bledsoe | Tennessee | 47007 | 2213 | 11 |
1452117 | 1452117 | 2021-06-24 | Bledsoe | Tennessee | 47007 | 2215 | 11 |
1448871 | 1448871 | 2021-06-23 | Bledsoe | Tennessee | 47007 | 2216 | 11 |
1445626 | 1445626 | 2021-06-22 | Bledsoe | Tennessee | 47007 | 2214 | 11 |
1442381 | 1442381 | 2021-06-21 | Bledsoe | Tennessee | 47007 | 2214 | 11 |
1439136 | 1439136 | 2021-06-20 | Bledsoe | Tennessee | 47007 | 2214 | 11 |
1435889 | 1435889 | 2021-06-19 | Bledsoe | Tennessee | 47007 | 2214 | 11 |
1432642 | 1432642 | 2021-06-18 | Bledsoe | Tennessee | 47007 | 2214 | 11 |
1429396 | 1429396 | 2021-06-17 | Bledsoe | Tennessee | 47007 | 2213 | 11 |
1426151 | 1426151 | 2021-06-16 | Bledsoe | Tennessee | 47007 | 2212 | 11 |
1422904 | 1422904 | 2021-06-15 | Bledsoe | Tennessee | 47007 | 2211 | 11 |
1419658 | 1419658 | 2021-06-14 | Bledsoe | Tennessee | 47007 | 2198 | 11 |
1416413 | 1416413 | 2021-06-13 | Bledsoe | Tennessee | 47007 | 2198 | 11 |
1413167 | 1413167 | 2021-06-12 | Bledsoe | Tennessee | 47007 | 2198 | 11 |
1409922 | 1409922 | 2021-06-11 | Bledsoe | Tennessee | 47007 | 2198 | 11 |
1406677 | 1406677 | 2021-06-10 | Bledsoe | Tennessee | 47007 | 2192 | 11 |
1403431 | 1403431 | 2021-06-09 | Bledsoe | Tennessee | 47007 | 2192 | 11 |
1400186 | 1400186 | 2021-06-08 | Bledsoe | Tennessee | 47007 | 2192 | 11 |
1396941 | 1396941 | 2021-06-07 | Bledsoe | Tennessee | 47007 | 2192 | 11 |
1393694 | 1393694 | 2021-06-06 | Bledsoe | Tennessee | 47007 | 2192 | 11 |
1390449 | 1390449 | 2021-06-05 | Bledsoe | Tennessee | 47007 | 2192 | 11 |
1387204 | 1387204 | 2021-06-04 | Bledsoe | Tennessee | 47007 | 2192 | 11 |
1383959 | 1383959 | 2021-06-03 | Bledsoe | Tennessee | 47007 | 2190 | 11 |
1380713 | 1380713 | 2021-06-02 | Bledsoe | Tennessee | 47007 | 2190 | 11 |
1377468 | 1377468 | 2021-06-01 | Bledsoe | Tennessee | 47007 | 2191 | 11 |
1374222 | 1374222 | 2021-05-31 | Bledsoe | Tennessee | 47007 | 2185 | 11 |
1370977 | 1370977 | 2021-05-30 | Bledsoe | Tennessee | 47007 | 2185 | 11 |
1367731 | 1367731 | 2021-05-29 | Bledsoe | Tennessee | 47007 | 2185 | 11 |
1364485 | 1364485 | 2021-05-28 | Bledsoe | Tennessee | 47007 | 2185 | 11 |
1361239 | 1361239 | 2021-05-27 | Bledsoe | Tennessee | 47007 | 2180 | 11 |
1357993 | 1357993 | 2021-05-26 | Bledsoe | Tennessee | 47007 | 2178 | 11 |
1354747 | 1354747 | 2021-05-25 | Bledsoe | Tennessee | 47007 | 2178 | 11 |
1351501 | 1351501 | 2021-05-24 | Bledsoe | Tennessee | 47007 | 2178 | 11 |
1348255 | 1348255 | 2021-05-23 | Bledsoe | Tennessee | 47007 | 2172 | 11 |
1345007 | 1345007 | 2021-05-22 | Bledsoe | Tennessee | 47007 | 2172 | 11 |
1341759 | 1341759 | 2021-05-21 | Bledsoe | Tennessee | 47007 | 2172 | 11 |
1338511 | 1338511 | 2021-05-20 | Bledsoe | Tennessee | 47007 | 2170 | 11 |
1335264 | 1335264 | 2021-05-19 | Bledsoe | Tennessee | 47007 | 2168 | 11 |
1332017 | 1332017 | 2021-05-18 | Bledsoe | Tennessee | 47007 | 2164 | 11 |
1328770 | 1328770 | 2021-05-17 | Bledsoe | Tennessee | 47007 | 2163 | 11 |
1325524 | 1325524 | 2021-05-16 | Bledsoe | Tennessee | 47007 | 2158 | 11 |
1322278 | 1322278 | 2021-05-15 | Bledsoe | Tennessee | 47007 | 2158 | 11 |
1319032 | 1319032 | 2021-05-14 | Bledsoe | Tennessee | 47007 | 2158 | 11 |
1315784 | 1315784 | 2021-05-13 | Bledsoe | Tennessee | 47007 | 2156 | 11 |
1312538 | 1312538 | 2021-05-12 | Bledsoe | Tennessee | 47007 | 2153 | 11 |
1309291 | 1309291 | 2021-05-11 | Bledsoe | Tennessee | 47007 | 2147 | 11 |
1306045 | 1306045 | 2021-05-10 | Bledsoe | Tennessee | 47007 | 2146 | 11 |
1302799 | 1302799 | 2021-05-09 | Bledsoe | Tennessee | 47007 | 2142 | 11 |
1299552 | 1299552 | 2021-05-08 | Bledsoe | Tennessee | 47007 | 2142 | 11 |
1296305 | 1296305 | 2021-05-07 | Bledsoe | Tennessee | 47007 | 2142 | 11 |
1293059 | 1293059 | 2021-05-06 | Bledsoe | Tennessee | 47007 | 2140 | 11 |
1289813 | 1289813 | 2021-05-05 | Bledsoe | Tennessee | 47007 | 2132 | 11 |
1286567 | 1286567 | 2021-05-04 | Bledsoe | Tennessee | 47007 | 2130 | 11 |
1283321 | 1283321 | 2021-05-03 | Bledsoe | Tennessee | 47007 | 2123 | 11 |
1280074 | 1280074 | 2021-05-02 | Bledsoe | Tennessee | 47007 | 2119 | 11 |
1276827 | 1276827 | 2021-05-01 | Bledsoe | Tennessee | 47007 | 2119 | 11 |
1273580 | 1273580 | 2021-04-30 | Bledsoe | Tennessee | 47007 | 2119 | 11 |
1270333 | 1270333 | 2021-04-29 | Bledsoe | Tennessee | 47007 | 2118 | 11 |
1267086 | 1267086 | 2021-04-28 | Bledsoe | Tennessee | 47007 | 2117 | 11 |
1263839 | 1263839 | 2021-04-27 | Bledsoe | Tennessee | 47007 | 2113 | 11 |
1260592 | 1260592 | 2021-04-26 | Bledsoe | Tennessee | 47007 | 2112 | 11 |
1257345 | 1257345 | 2021-04-25 | Bledsoe | Tennessee | 47007 | 2104 | 11 |
1254098 | 1254098 | 2021-04-24 | Bledsoe | Tennessee | 47007 | 2104 | 11 |
1250851 | 1250851 | 2021-04-23 | Bledsoe | Tennessee | 47007 | 2104 | 11 |
1247604 | 1247604 | 2021-04-22 | Bledsoe | Tennessee | 47007 | 2103 | 11 |
1244357 | 1244357 | 2021-04-21 | Bledsoe | Tennessee | 47007 | 2101 | 11 |
1241110 | 1241110 | 2021-04-20 | Bledsoe | Tennessee | 47007 | 2099 | 11 |
1237863 | 1237863 | 2021-04-19 | Bledsoe | Tennessee | 47007 | 2097 | 11 |
1234616 | 1234616 | 2021-04-18 | Bledsoe | Tennessee | 47007 | 2094 | 11 |
1231368 | 1231368 | 2021-04-17 | Bledsoe | Tennessee | 47007 | 2094 | 11 |
1228120 | 1228120 | 2021-04-16 | Bledsoe | Tennessee | 47007 | 2094 | 11 |
1224872 | 1224872 | 2021-04-15 | Bledsoe | Tennessee | 47007 | 2090 | 11 |
1221625 | 1221625 | 2021-04-14 | Bledsoe | Tennessee | 47007 | 2088 | 11 |
1218377 | 1218377 | 2021-04-13 | Bledsoe | Tennessee | 47007 | 2089 | 11 |
1215129 | 1215129 | 2021-04-12 | Bledsoe | Tennessee | 47007 | 2088 | 11 |
1211882 | 1211882 | 2021-04-11 | Bledsoe | Tennessee | 47007 | 2082 | 11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);