ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
159 rows where deaths = 127 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423976 | 2423976 | 2022-04-19 | Fentress | Tennessee | 47049 | 5697 | 127 |
2420720 | 2420720 | 2022-04-18 | Fentress | Tennessee | 47049 | 5697 | 127 |
2417464 | 2417464 | 2022-04-17 | Fentress | Tennessee | 47049 | 5697 | 127 |
2414208 | 2414208 | 2022-04-16 | Fentress | Tennessee | 47049 | 5697 | 127 |
2410952 | 2410952 | 2022-04-15 | Fentress | Tennessee | 47049 | 5697 | 127 |
2407696 | 2407696 | 2022-04-14 | Fentress | Tennessee | 47049 | 5697 | 127 |
2404440 | 2404440 | 2022-04-13 | Fentress | Tennessee | 47049 | 5697 | 127 |
2401185 | 2401185 | 2022-04-12 | Fentress | Tennessee | 47049 | 5696 | 127 |
2397930 | 2397930 | 2022-04-11 | Fentress | Tennessee | 47049 | 5696 | 127 |
2394675 | 2394675 | 2022-04-10 | Fentress | Tennessee | 47049 | 5696 | 127 |
2391419 | 2391419 | 2022-04-09 | Fentress | Tennessee | 47049 | 5696 | 127 |
2388163 | 2388163 | 2022-04-08 | Fentress | Tennessee | 47049 | 5696 | 127 |
2384908 | 2384908 | 2022-04-07 | Fentress | Tennessee | 47049 | 5696 | 127 |
2381653 | 2381653 | 2022-04-06 | Fentress | Tennessee | 47049 | 5696 | 127 |
2378429 | 2378429 | 2022-04-05 | Marion | Tennessee | 47115 | 8840 | 127 |
2378467 | 2378467 | 2022-04-05 | White | Tennessee | 47185 | 8224 | 127 |
2375175 | 2375175 | 2022-04-04 | Marion | Tennessee | 47115 | 8840 | 127 |
2375213 | 2375213 | 2022-04-04 | White | Tennessee | 47185 | 8224 | 127 |
2371923 | 2371923 | 2022-04-03 | Marion | Tennessee | 47115 | 8840 | 127 |
2371961 | 2371961 | 2022-04-03 | White | Tennessee | 47185 | 8224 | 127 |
2368670 | 2368670 | 2022-04-02 | Marion | Tennessee | 47115 | 8840 | 127 |
2368708 | 2368708 | 2022-04-02 | White | Tennessee | 47185 | 8224 | 127 |
2365417 | 2365417 | 2022-04-01 | Marion | Tennessee | 47115 | 8840 | 127 |
2365455 | 2365455 | 2022-04-01 | White | Tennessee | 47185 | 8224 | 127 |
2362164 | 2362164 | 2022-03-31 | Marion | Tennessee | 47115 | 8840 | 127 |
2362202 | 2362202 | 2022-03-31 | White | Tennessee | 47185 | 8224 | 127 |
2358910 | 2358910 | 2022-03-30 | Marion | Tennessee | 47115 | 8840 | 127 |
2358948 | 2358948 | 2022-03-30 | White | Tennessee | 47185 | 8224 | 127 |
2355656 | 2355656 | 2022-03-29 | Marion | Tennessee | 47115 | 8833 | 127 |
2355694 | 2355694 | 2022-03-29 | White | Tennessee | 47185 | 8224 | 127 |
2352403 | 2352403 | 2022-03-28 | Marion | Tennessee | 47115 | 8833 | 127 |
2352441 | 2352441 | 2022-03-28 | White | Tennessee | 47185 | 8224 | 127 |
2349151 | 2349151 | 2022-03-27 | Marion | Tennessee | 47115 | 8833 | 127 |
2349189 | 2349189 | 2022-03-27 | White | Tennessee | 47185 | 8224 | 127 |
2345898 | 2345898 | 2022-03-26 | Marion | Tennessee | 47115 | 8833 | 127 |
2345936 | 2345936 | 2022-03-26 | White | Tennessee | 47185 | 8224 | 127 |
2342645 | 2342645 | 2022-03-25 | Marion | Tennessee | 47115 | 8833 | 127 |
2342683 | 2342683 | 2022-03-25 | White | Tennessee | 47185 | 8224 | 127 |
2339392 | 2339392 | 2022-03-24 | Marion | Tennessee | 47115 | 8833 | 127 |
2339430 | 2339430 | 2022-03-24 | White | Tennessee | 47185 | 8224 | 127 |
2336138 | 2336138 | 2022-03-23 | Marion | Tennessee | 47115 | 8833 | 127 |
2336176 | 2336176 | 2022-03-23 | White | Tennessee | 47185 | 8224 | 127 |
2332884 | 2332884 | 2022-03-22 | Marion | Tennessee | 47115 | 8821 | 127 |
2329631 | 2329631 | 2022-03-21 | Marion | Tennessee | 47115 | 8821 | 127 |
2326379 | 2326379 | 2022-03-20 | Marion | Tennessee | 47115 | 8821 | 127 |
2323126 | 2323126 | 2022-03-19 | Marion | Tennessee | 47115 | 8821 | 127 |
2319872 | 2319872 | 2022-03-18 | Marion | Tennessee | 47115 | 8821 | 127 |
2316618 | 2316618 | 2022-03-17 | Marion | Tennessee | 47115 | 8821 | 127 |
2313365 | 2313365 | 2022-03-16 | Marion | Tennessee | 47115 | 8821 | 127 |
2173512 | 2173512 | 2022-02-01 | Henry | Tennessee | 47079 | 6999 | 127 |
2170260 | 2170260 | 2022-01-31 | Henry | Tennessee | 47079 | 6999 | 127 |
2167006 | 2167006 | 2022-01-30 | Henry | Tennessee | 47079 | 6999 | 127 |
2163751 | 2163751 | 2022-01-29 | Henry | Tennessee | 47079 | 6999 | 127 |
2160496 | 2160496 | 2022-01-28 | Henry | Tennessee | 47079 | 6999 | 127 |
2157240 | 2157240 | 2022-01-27 | Henry | Tennessee | 47079 | 6999 | 127 |
2153987 | 2153987 | 2022-01-26 | Henry | Tennessee | 47079 | 6999 | 127 |
2075901 | 2075901 | 2022-01-02 | Carroll | Tennessee | 47017 | 6129 | 127 |
2072650 | 2072650 | 2022-01-01 | Carroll | Tennessee | 47017 | 6129 | 127 |
2069399 | 2069399 | 2021-12-31 | Carroll | Tennessee | 47017 | 6129 | 127 |
2066148 | 2066148 | 2021-12-30 | Carroll | Tennessee | 47017 | 6129 | 127 |
2062898 | 2062898 | 2021-12-29 | Carroll | Tennessee | 47017 | 6109 | 127 |
2059648 | 2059648 | 2021-12-28 | Carroll | Tennessee | 47017 | 6085 | 127 |
2056399 | 2056399 | 2021-12-27 | Carroll | Tennessee | 47017 | 6067 | 127 |
2056462 | 2056462 | 2021-12-27 | Rhea | Tennessee | 47143 | 7361 | 127 |
2053150 | 2053150 | 2021-12-26 | Carroll | Tennessee | 47017 | 6048 | 127 |
2049900 | 2049900 | 2021-12-25 | Carroll | Tennessee | 47017 | 6048 | 127 |
2046650 | 2046650 | 2021-12-24 | Carroll | Tennessee | 47017 | 6048 | 127 |
2043400 | 2043400 | 2021-12-23 | Carroll | Tennessee | 47017 | 6048 | 127 |
2036958 | 2036958 | 2021-12-21 | Obion | Tennessee | 47131 | 7149 | 127 |
1968660 | 1968660 | 2021-11-30 | Giles | Tennessee | 47055 | 6183 | 127 |
1965409 | 1965409 | 2021-11-29 | Giles | Tennessee | 47055 | 6177 | 127 |
1965431 | 1965431 | 2021-11-29 | Lawrence | Tennessee | 47099 | 9754 | 127 |
1962157 | 1962157 | 2021-11-28 | Giles | Tennessee | 47055 | 6160 | 127 |
1962179 | 1962179 | 2021-11-28 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1958906 | 1958906 | 2021-11-27 | Giles | Tennessee | 47055 | 6160 | 127 |
1958928 | 1958928 | 2021-11-27 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1955655 | 1955655 | 2021-11-26 | Giles | Tennessee | 47055 | 6160 | 127 |
1955677 | 1955677 | 2021-11-26 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1952404 | 1952404 | 2021-11-25 | Giles | Tennessee | 47055 | 6160 | 127 |
1952426 | 1952426 | 2021-11-25 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1949153 | 1949153 | 2021-11-24 | Giles | Tennessee | 47055 | 6160 | 127 |
1949175 | 1949175 | 2021-11-24 | Lawrence | Tennessee | 47099 | 9733 | 127 |
1945902 | 1945902 | 2021-11-23 | Giles | Tennessee | 47055 | 6157 | 127 |
1942651 | 1942651 | 2021-11-22 | Giles | Tennessee | 47055 | 6151 | 127 |
1942685 | 1942685 | 2021-11-22 | Monroe | Tennessee | 47123 | 9900 | 127 |
1939401 | 1939401 | 2021-11-21 | Giles | Tennessee | 47055 | 6140 | 127 |
1936151 | 1936151 | 2021-11-20 | Giles | Tennessee | 47055 | 6140 | 127 |
1932901 | 1932901 | 2021-11-19 | Giles | Tennessee | 47055 | 6140 | 127 |
1929650 | 1929650 | 2021-11-18 | Giles | Tennessee | 47055 | 6134 | 127 |
1926400 | 1926400 | 2021-11-17 | Giles | Tennessee | 47055 | 6128 | 127 |
1923150 | 1923150 | 2021-11-16 | Giles | Tennessee | 47055 | 6120 | 127 |
1919901 | 1919901 | 2021-11-15 | Giles | Tennessee | 47055 | 6119 | 127 |
1916651 | 1916651 | 2021-11-14 | Giles | Tennessee | 47055 | 6112 | 127 |
1913401 | 1913401 | 2021-11-13 | Giles | Tennessee | 47055 | 6112 | 127 |
1910151 | 1910151 | 2021-11-12 | Giles | Tennessee | 47055 | 6112 | 127 |
1835471 | 1835471 | 2021-10-20 | Tipton | Tennessee | 47167 | 11269 | 127 |
1832197 | 1832197 | 2021-10-19 | McMinn | Tennessee | 47107 | 10403 | 127 |
1828948 | 1828948 | 2021-10-18 | McMinn | Tennessee | 47107 | 10387 | 127 |
1672958 | 1672958 | 2021-08-31 | Coffee | Tennessee | 47031 | 8504 | 127 |
1669710 | 1669710 | 2021-08-30 | Coffee | Tennessee | 47031 | 8387 | 127 |
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);