ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 278 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
county 9
- Anderson 7
- Cumberland 7
- Sevier 4
- Williamson 4
- Wilson 4
- Blount 3
- Madison 2
- Sullivan 2
- Knox 1
state 1
- Tennessee · 34 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2150696 | 2150696 | 2022-01-25 | Anderson | Tennessee | 47001 | 16649 | 278 |
2147444 | 2147444 | 2022-01-24 | Anderson | Tennessee | 47001 | 16649 | 278 |
2144190 | 2144190 | 2022-01-23 | Anderson | Tennessee | 47001 | 16649 | 278 |
2140935 | 2140935 | 2022-01-22 | Anderson | Tennessee | 47001 | 16649 | 278 |
2137679 | 2137679 | 2022-01-21 | Anderson | Tennessee | 47001 | 16649 | 278 |
2134425 | 2134425 | 2022-01-20 | Anderson | Tennessee | 47001 | 16649 | 278 |
2131173 | 2131173 | 2022-01-19 | Anderson | Tennessee | 47001 | 16649 | 278 |
2127936 | 2127936 | 2022-01-18 | Cumberland | Tennessee | 47035 | 12415 | 278 |
2124684 | 2124684 | 2022-01-17 | Cumberland | Tennessee | 47035 | 12415 | 278 |
2121432 | 2121432 | 2022-01-16 | Cumberland | Tennessee | 47035 | 12415 | 278 |
2118180 | 2118180 | 2022-01-15 | Cumberland | Tennessee | 47035 | 12415 | 278 |
2114929 | 2114929 | 2022-01-14 | Cumberland | Tennessee | 47035 | 12415 | 278 |
2111677 | 2111677 | 2022-01-13 | Cumberland | Tennessee | 47035 | 12415 | 278 |
2108425 | 2108425 | 2022-01-12 | Cumberland | Tennessee | 47035 | 12415 | 278 |
1988226 | 1988226 | 2021-12-06 | Williamson | Tennessee | 47187 | 41377 | 278 |
1984886 | 1984886 | 2021-12-05 | Blount | Tennessee | 47009 | 24629 | 278 |
1984976 | 1984976 | 2021-12-05 | Williamson | Tennessee | 47187 | 41241 | 278 |
1981636 | 1981636 | 2021-12-04 | Blount | Tennessee | 47009 | 24629 | 278 |
1981726 | 1981726 | 2021-12-04 | Williamson | Tennessee | 47187 | 41241 | 278 |
1978386 | 1978386 | 2021-12-03 | Blount | Tennessee | 47009 | 24629 | 278 |
1978476 | 1978476 | 2021-12-03 | Williamson | Tennessee | 47187 | 41241 | 278 |
1919951 | 1919951 | 2021-11-15 | Sevier | Tennessee | 47155 | 20370 | 278 |
1916701 | 1916701 | 2021-11-14 | Sevier | Tennessee | 47155 | 20325 | 278 |
1913451 | 1913451 | 2021-11-13 | Sevier | Tennessee | 47155 | 20325 | 278 |
1910201 | 1910201 | 2021-11-12 | Sevier | Tennessee | 47155 | 20325 | 278 |
1721723 | 1721723 | 2021-09-15 | Madison | Tennessee | 47113 | 16403 | 278 |
1718475 | 1718475 | 2021-09-14 | Madison | Tennessee | 47113 | 16321 | 278 |
1692533 | 1692533 | 2021-09-06 | Wilson | Tennessee | 47189 | 23366 | 278 |
1689284 | 1689284 | 2021-09-05 | Wilson | Tennessee | 47189 | 23366 | 278 |
1686034 | 1686034 | 2021-09-04 | Wilson | Tennessee | 47189 | 23366 | 278 |
1682783 | 1682783 | 2021-09-03 | Wilson | Tennessee | 47189 | 23366 | 278 |
1127524 | 1127524 | 2021-03-16 | Sullivan | Tennessee | 47163 | 14864 | 278 |
1124278 | 1124278 | 2021-03-15 | Sullivan | Tennessee | 47163 | 14832 | 278 |
858104 | 858104 | 2020-12-23 | Knox | Tennessee | 47093 | 30365 | 278 |
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);