ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
263 rows where deaths = 84 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469614 | 2469614 | 2022-05-03 | Smith | Tennessee | 47159 | 6163 | 84 |
2466358 | 2466358 | 2022-05-02 | Smith | Tennessee | 47159 | 6163 | 84 |
2463103 | 2463103 | 2022-05-01 | Smith | Tennessee | 47159 | 6163 | 84 |
2459847 | 2459847 | 2022-04-30 | Smith | Tennessee | 47159 | 6163 | 84 |
2456591 | 2456591 | 2022-04-29 | Smith | Tennessee | 47159 | 6163 | 84 |
2453335 | 2453335 | 2022-04-28 | Smith | Tennessee | 47159 | 6163 | 84 |
2450079 | 2450079 | 2022-04-27 | Smith | Tennessee | 47159 | 6163 | 84 |
2446822 | 2446822 | 2022-04-26 | Smith | Tennessee | 47159 | 6163 | 84 |
2443567 | 2443567 | 2022-04-25 | Smith | Tennessee | 47159 | 6163 | 84 |
2440311 | 2440311 | 2022-04-24 | Smith | Tennessee | 47159 | 6163 | 84 |
2437055 | 2437055 | 2022-04-23 | Smith | Tennessee | 47159 | 6163 | 84 |
2433799 | 2433799 | 2022-04-22 | Smith | Tennessee | 47159 | 6163 | 84 |
2430543 | 2430543 | 2022-04-21 | Smith | Tennessee | 47159 | 6163 | 84 |
2427287 | 2427287 | 2022-04-20 | Smith | Tennessee | 47159 | 6163 | 84 |
2423968 | 2423968 | 2022-04-19 | Crockett | Tennessee | 47033 | 5177 | 84 |
2424031 | 2424031 | 2022-04-19 | Smith | Tennessee | 47159 | 6161 | 84 |
2420712 | 2420712 | 2022-04-18 | Crockett | Tennessee | 47033 | 5177 | 84 |
2420775 | 2420775 | 2022-04-18 | Smith | Tennessee | 47159 | 6161 | 84 |
2417456 | 2417456 | 2022-04-17 | Crockett | Tennessee | 47033 | 5177 | 84 |
2417519 | 2417519 | 2022-04-17 | Smith | Tennessee | 47159 | 6161 | 84 |
2414200 | 2414200 | 2022-04-16 | Crockett | Tennessee | 47033 | 5177 | 84 |
2414263 | 2414263 | 2022-04-16 | Smith | Tennessee | 47159 | 6161 | 84 |
2410944 | 2410944 | 2022-04-15 | Crockett | Tennessee | 47033 | 5177 | 84 |
2411007 | 2411007 | 2022-04-15 | Smith | Tennessee | 47159 | 6161 | 84 |
2407688 | 2407688 | 2022-04-14 | Crockett | Tennessee | 47033 | 5177 | 84 |
2407751 | 2407751 | 2022-04-14 | Smith | Tennessee | 47159 | 6161 | 84 |
2404432 | 2404432 | 2022-04-13 | Crockett | Tennessee | 47033 | 5177 | 84 |
2404495 | 2404495 | 2022-04-13 | Smith | Tennessee | 47159 | 6161 | 84 |
2401177 | 2401177 | 2022-04-12 | Crockett | Tennessee | 47033 | 5177 | 84 |
2397922 | 2397922 | 2022-04-11 | Crockett | Tennessee | 47033 | 5177 | 84 |
2394667 | 2394667 | 2022-04-10 | Crockett | Tennessee | 47033 | 5177 | 84 |
2391411 | 2391411 | 2022-04-09 | Crockett | Tennessee | 47033 | 5177 | 84 |
2388155 | 2388155 | 2022-04-08 | Crockett | Tennessee | 47033 | 5177 | 84 |
2384900 | 2384900 | 2022-04-07 | Crockett | Tennessee | 47033 | 5177 | 84 |
2381645 | 2381645 | 2022-04-06 | Crockett | Tennessee | 47033 | 5177 | 84 |
2378390 | 2378390 | 2022-04-05 | Crockett | Tennessee | 47033 | 5177 | 84 |
2375136 | 2375136 | 2022-04-04 | Crockett | Tennessee | 47033 | 5177 | 84 |
2371884 | 2371884 | 2022-04-03 | Crockett | Tennessee | 47033 | 5177 | 84 |
2368631 | 2368631 | 2022-04-02 | Crockett | Tennessee | 47033 | 5177 | 84 |
2365378 | 2365378 | 2022-04-01 | Crockett | Tennessee | 47033 | 5177 | 84 |
2362125 | 2362125 | 2022-03-31 | Crockett | Tennessee | 47033 | 5177 | 84 |
2358871 | 2358871 | 2022-03-30 | Crockett | Tennessee | 47033 | 5177 | 84 |
2355617 | 2355617 | 2022-03-29 | Crockett | Tennessee | 47033 | 5171 | 84 |
2352364 | 2352364 | 2022-03-28 | Crockett | Tennessee | 47033 | 5171 | 84 |
2349112 | 2349112 | 2022-03-27 | Crockett | Tennessee | 47033 | 5171 | 84 |
2345859 | 2345859 | 2022-03-26 | Crockett | Tennessee | 47033 | 5171 | 84 |
2342606 | 2342606 | 2022-03-25 | Crockett | Tennessee | 47033 | 5171 | 84 |
2339353 | 2339353 | 2022-03-24 | Crockett | Tennessee | 47033 | 5171 | 84 |
2336099 | 2336099 | 2022-03-23 | Crockett | Tennessee | 47033 | 5171 | 84 |
2219014 | 2219014 | 2022-02-15 | Benton | Tennessee | 47005 | 4243 | 84 |
2215763 | 2215763 | 2022-02-14 | Benton | Tennessee | 47005 | 4243 | 84 |
2212512 | 2212512 | 2022-02-13 | Benton | Tennessee | 47005 | 4243 | 84 |
2209259 | 2209259 | 2022-02-12 | Benton | Tennessee | 47005 | 4243 | 84 |
2206006 | 2206006 | 2022-02-11 | Benton | Tennessee | 47005 | 4243 | 84 |
2202753 | 2202753 | 2022-02-10 | Benton | Tennessee | 47005 | 4243 | 84 |
2199499 | 2199499 | 2022-02-09 | Benton | Tennessee | 47005 | 4243 | 84 |
2196245 | 2196245 | 2022-02-08 | Benton | Tennessee | 47005 | 3962 | 84 |
2196280 | 2196280 | 2022-02-08 | Haywood | Tennessee | 47075 | 5698 | 84 |
2192991 | 2192991 | 2022-02-07 | Benton | Tennessee | 47005 | 3962 | 84 |
2193026 | 2193026 | 2022-02-07 | Haywood | Tennessee | 47075 | 5698 | 84 |
2189737 | 2189737 | 2022-02-06 | Benton | Tennessee | 47005 | 3962 | 84 |
2189772 | 2189772 | 2022-02-06 | Haywood | Tennessee | 47075 | 5698 | 84 |
2186484 | 2186484 | 2022-02-05 | Benton | Tennessee | 47005 | 3962 | 84 |
2186519 | 2186519 | 2022-02-05 | Haywood | Tennessee | 47075 | 5698 | 84 |
2183232 | 2183232 | 2022-02-04 | Benton | Tennessee | 47005 | 3962 | 84 |
2183267 | 2183267 | 2022-02-04 | Haywood | Tennessee | 47075 | 5698 | 84 |
2179980 | 2179980 | 2022-02-03 | Benton | Tennessee | 47005 | 3962 | 84 |
2180015 | 2180015 | 2022-02-03 | Haywood | Tennessee | 47075 | 5698 | 84 |
2176729 | 2176729 | 2022-02-02 | Benton | Tennessee | 47005 | 3962 | 84 |
2176764 | 2176764 | 2022-02-02 | Haywood | Tennessee | 47075 | 5698 | 84 |
2173484 | 2173484 | 2022-02-01 | Chester | Tennessee | 47023 | 4929 | 84 |
2170232 | 2170232 | 2022-01-31 | Chester | Tennessee | 47023 | 4929 | 84 |
2166978 | 2166978 | 2022-01-30 | Chester | Tennessee | 47023 | 4929 | 84 |
2163723 | 2163723 | 2022-01-29 | Chester | Tennessee | 47023 | 4929 | 84 |
2160468 | 2160468 | 2022-01-28 | Chester | Tennessee | 47023 | 4929 | 84 |
2157212 | 2157212 | 2022-01-27 | Chester | Tennessee | 47023 | 4929 | 84 |
2153959 | 2153959 | 2022-01-26 | Chester | Tennessee | 47023 | 4929 | 84 |
2062909 | 2062909 | 2021-12-29 | DeKalb | Tennessee | 47041 | 4480 | 84 |
2059659 | 2059659 | 2021-12-28 | DeKalb | Tennessee | 47041 | 4458 | 84 |
2056410 | 2056410 | 2021-12-27 | DeKalb | Tennessee | 47041 | 4451 | 84 |
1975198 | 1975198 | 2021-12-02 | Overton | Tennessee | 47133 | 4932 | 84 |
1971949 | 1971949 | 2021-12-01 | Overton | Tennessee | 47133 | 4922 | 84 |
1968699 | 1968699 | 2021-11-30 | Overton | Tennessee | 47133 | 4912 | 84 |
1939408 | 1939408 | 2021-11-21 | Hardeman | Tennessee | 47069 | 5160 | 84 |
1936158 | 1936158 | 2021-11-20 | Hardeman | Tennessee | 47069 | 5160 | 84 |
1932908 | 1932908 | 2021-11-19 | Hardeman | Tennessee | 47069 | 5160 | 84 |
1929657 | 1929657 | 2021-11-18 | Hardeman | Tennessee | 47069 | 5158 | 84 |
1926407 | 1926407 | 2021-11-17 | Hardeman | Tennessee | 47069 | 5158 | 84 |
1923157 | 1923157 | 2021-11-16 | Hardeman | Tennessee | 47069 | 5157 | 84 |
1919909 | 1919909 | 2021-11-15 | Hardin | Tennessee | 47071 | 5617 | 84 |
1916659 | 1916659 | 2021-11-14 | Hardin | Tennessee | 47071 | 5603 | 84 |
1913409 | 1913409 | 2021-11-13 | Hardin | Tennessee | 47071 | 5603 | 84 |
1910159 | 1910159 | 2021-11-12 | Hardin | Tennessee | 47071 | 5603 | 84 |
1880928 | 1880928 | 2021-11-03 | Lincoln | Tennessee | 47103 | 6721 | 84 |
1877679 | 1877679 | 2021-11-02 | Lincoln | Tennessee | 47103 | 6708 | 84 |
1874430 | 1874430 | 2021-11-01 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1871181 | 1871181 | 2021-10-31 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1867932 | 1867932 | 2021-10-30 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1864683 | 1864683 | 2021-10-29 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1861434 | 1861434 | 2021-10-28 | Lincoln | Tennessee | 47103 | 6685 | 84 |
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);