ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 256 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Tennessee · 16 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453343 | 2453343 | 2022-04-28 | Unknown | Tennessee | 18853 | 256 | |
2401187 | 2401187 | 2022-04-12 | Gibson | Tennessee | 47053 | 17380 | 256 |
2397932 | 2397932 | 2022-04-11 | Gibson | Tennessee | 47053 | 17380 | 256 |
2394677 | 2394677 | 2022-04-10 | Gibson | Tennessee | 47053 | 17380 | 256 |
2391421 | 2391421 | 2022-04-09 | Gibson | Tennessee | 47053 | 17380 | 256 |
2388165 | 2388165 | 2022-04-08 | Gibson | Tennessee | 47053 | 17380 | 256 |
2384910 | 2384910 | 2022-04-07 | Gibson | Tennessee | 47053 | 17380 | 256 |
2381655 | 2381655 | 2022-04-06 | Gibson | Tennessee | 47053 | 17380 | 256 |
2036922 | 2036922 | 2021-12-21 | Greene | Tennessee | 47059 | 14949 | 256 |
1598324 | 1598324 | 2021-08-08 | Washington | Tennessee | 47179 | 15490 | 256 |
1595075 | 1595075 | 2021-08-07 | Washington | Tennessee | 47179 | 15490 | 256 |
1591826 | 1591826 | 2021-08-06 | Washington | Tennessee | 47179 | 15490 | 256 |
1588577 | 1588577 | 2021-08-05 | Washington | Tennessee | 47179 | 15447 | 256 |
1562593 | 1562593 | 2021-07-28 | Wilson | Tennessee | 47189 | 19802 | 256 |
1010675 | 1010675 | 2021-02-08 | Sullivan | Tennessee | 47163 | 13562 | 256 |
981460 | 981460 | 2021-01-30 | Sumner | Tennessee | 47165 | 19210 | 256 |
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);