ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
227 rows where deaths = 90 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2355603 | 2355603 | 2022-03-29 | Benton | Tennessee | 47005 | 4471 | 90 |
2352350 | 2352350 | 2022-03-28 | Benton | Tennessee | 47005 | 4471 | 90 |
2349098 | 2349098 | 2022-03-27 | Benton | Tennessee | 47005 | 4471 | 90 |
2345845 | 2345845 | 2022-03-26 | Benton | Tennessee | 47005 | 4471 | 90 |
2342592 | 2342592 | 2022-03-25 | Benton | Tennessee | 47005 | 4471 | 90 |
2339339 | 2339339 | 2022-03-24 | Benton | Tennessee | 47005 | 4471 | 90 |
2336085 | 2336085 | 2022-03-23 | Benton | Tennessee | 47005 | 4471 | 90 |
2332831 | 2332831 | 2022-03-22 | Benton | Tennessee | 47005 | 4466 | 90 |
2329578 | 2329578 | 2022-03-21 | Benton | Tennessee | 47005 | 4466 | 90 |
2326326 | 2326326 | 2022-03-20 | Benton | Tennessee | 47005 | 4466 | 90 |
2323073 | 2323073 | 2022-03-19 | Benton | Tennessee | 47005 | 4466 | 90 |
2319819 | 2319819 | 2022-03-18 | Benton | Tennessee | 47005 | 4466 | 90 |
2316565 | 2316565 | 2022-03-17 | Benton | Tennessee | 47005 | 4466 | 90 |
2313312 | 2313312 | 2022-03-16 | Benton | Tennessee | 47005 | 4466 | 90 |
2310059 | 2310059 | 2022-03-15 | Benton | Tennessee | 47005 | 4453 | 90 |
2310142 | 2310142 | 2022-03-15 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2306806 | 2306806 | 2022-03-14 | Benton | Tennessee | 47005 | 4453 | 90 |
2306889 | 2306889 | 2022-03-14 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2303555 | 2303555 | 2022-03-13 | Benton | Tennessee | 47005 | 4453 | 90 |
2303638 | 2303638 | 2022-03-13 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2300303 | 2300303 | 2022-03-12 | Benton | Tennessee | 47005 | 4453 | 90 |
2300386 | 2300386 | 2022-03-12 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2297051 | 2297051 | 2022-03-11 | Benton | Tennessee | 47005 | 4453 | 90 |
2297134 | 2297134 | 2022-03-11 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2293799 | 2293799 | 2022-03-10 | Benton | Tennessee | 47005 | 4453 | 90 |
2293882 | 2293882 | 2022-03-10 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2290547 | 2290547 | 2022-03-09 | Benton | Tennessee | 47005 | 4453 | 90 |
2290630 | 2290630 | 2022-03-09 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2287295 | 2287295 | 2022-03-08 | Benton | Tennessee | 47005 | 4439 | 90 |
2287378 | 2287378 | 2022-03-08 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2284043 | 2284043 | 2022-03-07 | Benton | Tennessee | 47005 | 4439 | 90 |
2284126 | 2284126 | 2022-03-07 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2280791 | 2280791 | 2022-03-06 | Benton | Tennessee | 47005 | 4439 | 90 |
2280874 | 2280874 | 2022-03-06 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2277538 | 2277538 | 2022-03-05 | Benton | Tennessee | 47005 | 4439 | 90 |
2277621 | 2277621 | 2022-03-05 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2274285 | 2274285 | 2022-03-04 | Benton | Tennessee | 47005 | 4439 | 90 |
2274368 | 2274368 | 2022-03-04 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2271032 | 2271032 | 2022-03-03 | Benton | Tennessee | 47005 | 4439 | 90 |
2271115 | 2271115 | 2022-03-03 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2267780 | 2267780 | 2022-03-02 | Benton | Tennessee | 47005 | 4439 | 90 |
2267863 | 2267863 | 2022-03-02 | Unicoi | Tennessee | 47171 | 5116 | 90 |
2264536 | 2264536 | 2022-03-01 | Chester | Tennessee | 47023 | 5685 | 90 |
2261286 | 2261286 | 2022-02-28 | Chester | Tennessee | 47023 | 5685 | 90 |
2258035 | 2258035 | 2022-02-27 | Chester | Tennessee | 47023 | 5685 | 90 |
2254784 | 2254784 | 2022-02-26 | Chester | Tennessee | 47023 | 5685 | 90 |
2251533 | 2251533 | 2022-02-25 | Chester | Tennessee | 47023 | 5685 | 90 |
2248282 | 2248282 | 2022-02-24 | Chester | Tennessee | 47023 | 5685 | 90 |
2245031 | 2245031 | 2022-02-23 | Chester | Tennessee | 47023 | 5685 | 90 |
2241806 | 2241806 | 2022-02-22 | Haywood | Tennessee | 47075 | 6040 | 90 |
2238555 | 2238555 | 2022-02-21 | Haywood | Tennessee | 47075 | 6040 | 90 |
2235304 | 2235304 | 2022-02-20 | Haywood | Tennessee | 47075 | 6040 | 90 |
2232053 | 2232053 | 2022-02-19 | Haywood | Tennessee | 47075 | 6040 | 90 |
2228802 | 2228802 | 2022-02-18 | Haywood | Tennessee | 47075 | 6040 | 90 |
2225551 | 2225551 | 2022-02-17 | Haywood | Tennessee | 47075 | 6040 | 90 |
2222300 | 2222300 | 2022-02-16 | Haywood | Tennessee | 47075 | 6040 | 90 |
2219060 | 2219060 | 2022-02-15 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2215809 | 2215809 | 2022-02-14 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2212558 | 2212558 | 2022-02-13 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2209305 | 2209305 | 2022-02-12 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2206052 | 2206052 | 2022-02-11 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2202799 | 2202799 | 2022-02-10 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2199545 | 2199545 | 2022-02-09 | Lauderdale | Tennessee | 47097 | 7500 | 90 |
2150715 | 2150715 | 2022-01-25 | DeKalb | Tennessee | 47041 | 4989 | 90 |
2147463 | 2147463 | 2022-01-24 | DeKalb | Tennessee | 47041 | 4989 | 90 |
2144209 | 2144209 | 2022-01-23 | DeKalb | Tennessee | 47041 | 4989 | 90 |
2140954 | 2140954 | 2022-01-22 | DeKalb | Tennessee | 47041 | 4989 | 90 |
2137698 | 2137698 | 2022-01-21 | DeKalb | Tennessee | 47041 | 4989 | 90 |
2134444 | 2134444 | 2022-01-20 | DeKalb | Tennessee | 47041 | 4989 | 90 |
2131192 | 2131192 | 2022-01-19 | DeKalb | Tennessee | 47041 | 4989 | 90 |
2127994 | 2127994 | 2022-01-18 | Scott | Tennessee | 47151 | 6289 | 90 |
2124742 | 2124742 | 2022-01-17 | Scott | Tennessee | 47151 | 6289 | 90 |
2121490 | 2121490 | 2022-01-16 | Scott | Tennessee | 47151 | 6289 | 90 |
2118238 | 2118238 | 2022-01-15 | Scott | Tennessee | 47151 | 6289 | 90 |
2114987 | 2114987 | 2022-01-14 | Scott | Tennessee | 47151 | 6289 | 90 |
2111735 | 2111735 | 2022-01-13 | Scott | Tennessee | 47151 | 6289 | 90 |
2108483 | 2108483 | 2022-01-12 | Scott | Tennessee | 47151 | 6289 | 90 |
2105232 | 2105232 | 2022-01-11 | Scott | Tennessee | 47151 | 6147 | 90 |
2101981 | 2101981 | 2022-01-10 | Scott | Tennessee | 47151 | 6147 | 90 |
2098730 | 2098730 | 2022-01-09 | Scott | Tennessee | 47151 | 6147 | 90 |
2095478 | 2095478 | 2022-01-08 | Scott | Tennessee | 47151 | 6147 | 90 |
2092226 | 2092226 | 2022-01-07 | Scott | Tennessee | 47151 | 6147 | 90 |
2088974 | 2088974 | 2022-01-06 | Scott | Tennessee | 47151 | 6147 | 90 |
2085723 | 2085723 | 2022-01-05 | Scott | Tennessee | 47151 | 6147 | 90 |
2082471 | 2082471 | 2022-01-04 | Scott | Tennessee | 47151 | 6147 | 90 |
2079219 | 2079219 | 2022-01-03 | Scott | Tennessee | 47151 | 6136 | 90 |
2075903 | 2075903 | 2022-01-02 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2072652 | 2072652 | 2022-01-01 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2069401 | 2069401 | 2021-12-31 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2066150 | 2066150 | 2021-12-30 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2062900 | 2062900 | 2021-12-29 | Cheatham | Tennessee | 47021 | 7614 | 90 |
2059650 | 2059650 | 2021-12-28 | Cheatham | Tennessee | 47021 | 7535 | 90 |
2056401 | 2056401 | 2021-12-27 | Cheatham | Tennessee | 47021 | 7517 | 90 |
2040209 | 2040209 | 2021-12-22 | Overton | Tennessee | 47133 | 5072 | 90 |
2036959 | 2036959 | 2021-12-21 | Overton | Tennessee | 47133 | 5057 | 90 |
1988167 | 1988167 | 2021-12-06 | Hardin | Tennessee | 47071 | 5732 | 90 |
1984917 | 1984917 | 2021-12-05 | Hardin | Tennessee | 47071 | 5727 | 90 |
1981667 | 1981667 | 2021-12-04 | Hardin | Tennessee | 47071 | 5727 | 90 |
1978417 | 1978417 | 2021-12-03 | Hardin | Tennessee | 47071 | 5727 | 90 |
1975167 | 1975167 | 2021-12-02 | Hardin | Tennessee | 47071 | 5716 | 90 |
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);