ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
129 rows where deaths = 140 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2355693 | 2355693 | 2022-03-29 | Weakley | Tennessee | 47183 | 9491 | 140 |
2352440 | 2352440 | 2022-03-28 | Weakley | Tennessee | 47183 | 9491 | 140 |
2349188 | 2349188 | 2022-03-27 | Weakley | Tennessee | 47183 | 9491 | 140 |
2345935 | 2345935 | 2022-03-26 | Weakley | Tennessee | 47183 | 9491 | 140 |
2342682 | 2342682 | 2022-03-25 | Weakley | Tennessee | 47183 | 9491 | 140 |
2339429 | 2339429 | 2022-03-24 | Weakley | Tennessee | 47183 | 9491 | 140 |
2336175 | 2336175 | 2022-03-23 | Weakley | Tennessee | 47183 | 9491 | 140 |
2332864 | 2332864 | 2022-03-22 | Hardin | Tennessee | 47071 | 8717 | 140 |
2332921 | 2332921 | 2022-03-22 | Weakley | Tennessee | 47183 | 9489 | 140 |
2329611 | 2329611 | 2022-03-21 | Hardin | Tennessee | 47071 | 8717 | 140 |
2329668 | 2329668 | 2022-03-21 | Weakley | Tennessee | 47183 | 9489 | 140 |
2326359 | 2326359 | 2022-03-20 | Hardin | Tennessee | 47071 | 8717 | 140 |
2326416 | 2326416 | 2022-03-20 | Weakley | Tennessee | 47183 | 9489 | 140 |
2323106 | 2323106 | 2022-03-19 | Hardin | Tennessee | 47071 | 8717 | 140 |
2323163 | 2323163 | 2022-03-19 | Weakley | Tennessee | 47183 | 9489 | 140 |
2319852 | 2319852 | 2022-03-18 | Hardin | Tennessee | 47071 | 8717 | 140 |
2319909 | 2319909 | 2022-03-18 | Weakley | Tennessee | 47183 | 9489 | 140 |
2316598 | 2316598 | 2022-03-17 | Hardin | Tennessee | 47071 | 8717 | 140 |
2316655 | 2316655 | 2022-03-17 | Weakley | Tennessee | 47183 | 9489 | 140 |
2313345 | 2313345 | 2022-03-16 | Hardin | Tennessee | 47071 | 8717 | 140 |
2313402 | 2313402 | 2022-03-16 | Weakley | Tennessee | 47183 | 9489 | 140 |
2264564 | 2264564 | 2022-03-01 | Henry | Tennessee | 47079 | 8050 | 140 |
2261314 | 2261314 | 2022-02-28 | Henry | Tennessee | 47079 | 8050 | 140 |
2258063 | 2258063 | 2022-02-27 | Henry | Tennessee | 47079 | 8050 | 140 |
2254812 | 2254812 | 2022-02-26 | Henry | Tennessee | 47079 | 8050 | 140 |
2251561 | 2251561 | 2022-02-25 | Henry | Tennessee | 47079 | 8050 | 140 |
2248310 | 2248310 | 2022-02-24 | Henry | Tennessee | 47079 | 8050 | 140 |
2245059 | 2245059 | 2022-02-23 | Henry | Tennessee | 47079 | 8050 | 140 |
2241777 | 2241777 | 2022-02-22 | Carroll | Tennessee | 47017 | 8716 | 140 |
2241820 | 2241820 | 2022-02-22 | Lincoln | Tennessee | 47103 | 9795 | 140 |
2238526 | 2238526 | 2022-02-21 | Carroll | Tennessee | 47017 | 8716 | 140 |
2238569 | 2238569 | 2022-02-21 | Lincoln | Tennessee | 47103 | 9795 | 140 |
2235275 | 2235275 | 2022-02-20 | Carroll | Tennessee | 47017 | 8716 | 140 |
2235318 | 2235318 | 2022-02-20 | Lincoln | Tennessee | 47103 | 9795 | 140 |
2232024 | 2232024 | 2022-02-19 | Carroll | Tennessee | 47017 | 8716 | 140 |
2232067 | 2232067 | 2022-02-19 | Lincoln | Tennessee | 47103 | 9795 | 140 |
2228773 | 2228773 | 2022-02-18 | Carroll | Tennessee | 47017 | 8716 | 140 |
2228816 | 2228816 | 2022-02-18 | Lincoln | Tennessee | 47103 | 9795 | 140 |
2225522 | 2225522 | 2022-02-17 | Carroll | Tennessee | 47017 | 8716 | 140 |
2225565 | 2225565 | 2022-02-17 | Lincoln | Tennessee | 47103 | 9795 | 140 |
2222271 | 2222271 | 2022-02-16 | Carroll | Tennessee | 47017 | 8716 | 140 |
2222314 | 2222314 | 2022-02-16 | Lincoln | Tennessee | 47103 | 9795 | 140 |
2056443 | 2056443 | 2021-12-27 | Loudon | Tennessee | 47105 | 9808 | 140 |
2010949 | 2010949 | 2021-12-13 | Monroe | Tennessee | 47123 | 10110 | 140 |
2007698 | 2007698 | 2021-12-12 | Monroe | Tennessee | 47123 | 10088 | 140 |
2004447 | 2004447 | 2021-12-11 | Monroe | Tennessee | 47123 | 10088 | 140 |
2001196 | 2001196 | 2021-12-10 | Monroe | Tennessee | 47123 | 10088 | 140 |
1997946 | 1997946 | 2021-12-09 | Monroe | Tennessee | 47123 | 10062 | 140 |
1994695 | 1994695 | 2021-12-08 | Monroe | Tennessee | 47123 | 10062 | 140 |
1991444 | 1991444 | 2021-12-07 | Monroe | Tennessee | 47123 | 10037 | 140 |
1988193 | 1988193 | 2021-12-06 | Monroe | Tennessee | 47123 | 10020 | 140 |
1971941 | 1971941 | 2021-12-01 | McMinn | Tennessee | 47107 | 10762 | 140 |
1942707 | 1942707 | 2021-11-22 | Tipton | Tennessee | 47167 | 11625 | 140 |
1939457 | 1939457 | 2021-11-21 | Tipton | Tennessee | 47167 | 11593 | 140 |
1936207 | 1936207 | 2021-11-20 | Tipton | Tennessee | 47167 | 11593 | 140 |
1932957 | 1932957 | 2021-11-19 | Tipton | Tennessee | 47167 | 11593 | 140 |
1929706 | 1929706 | 2021-11-18 | Tipton | Tennessee | 47167 | 11575 | 140 |
1926456 | 1926456 | 2021-11-17 | Tipton | Tennessee | 47167 | 11545 | 140 |
1923206 | 1923206 | 2021-11-16 | Tipton | Tennessee | 47167 | 11528 | 140 |
1812690 | 1812690 | 2021-10-13 | Jefferson | Tennessee | 47089 | 9746 | 140 |
1806169 | 1806169 | 2021-10-11 | Dyer | Tennessee | 47045 | 8013 | 140 |
1802919 | 1802919 | 2021-10-10 | Dyer | Tennessee | 47045 | 8006 | 140 |
1799670 | 1799670 | 2021-10-09 | Dyer | Tennessee | 47045 | 8006 | 140 |
1796421 | 1796421 | 2021-10-08 | Dyer | Tennessee | 47045 | 8006 | 140 |
1741167 | 1741167 | 2021-09-21 | Bedford | Tennessee | 47003 | 8447 | 140 |
1737918 | 1737918 | 2021-09-20 | Bedford | Tennessee | 47003 | 8447 | 140 |
1734668 | 1734668 | 2021-09-19 | Bedford | Tennessee | 47003 | 8370 | 140 |
1731418 | 1731418 | 2021-09-18 | Bedford | Tennessee | 47003 | 8370 | 140 |
1728168 | 1728168 | 2021-09-17 | Bedford | Tennessee | 47003 | 8370 | 140 |
1724919 | 1724919 | 2021-09-16 | Bedford | Tennessee | 47003 | 8342 | 140 |
1718442 | 1718442 | 2021-09-14 | Dickson | Tennessee | 47043 | 9327 | 140 |
1491080 | 1491080 | 2021-07-06 | Cumberland | Tennessee | 47035 | 6886 | 140 |
1487833 | 1487833 | 2021-07-05 | Cumberland | Tennessee | 47035 | 6883 | 140 |
1484586 | 1484586 | 2021-07-04 | Cumberland | Tennessee | 47035 | 6883 | 140 |
1481340 | 1481340 | 2021-07-03 | Cumberland | Tennessee | 47035 | 6883 | 140 |
1478093 | 1478093 | 2021-07-02 | Cumberland | Tennessee | 47035 | 6883 | 140 |
1474847 | 1474847 | 2021-07-01 | Cumberland | Tennessee | 47035 | 6883 | 140 |
1471601 | 1471601 | 2021-06-30 | Cumberland | Tennessee | 47035 | 6883 | 140 |
1468356 | 1468356 | 2021-06-29 | Cumberland | Tennessee | 47035 | 6884 | 140 |
1465111 | 1465111 | 2021-06-28 | Cumberland | Tennessee | 47035 | 6885 | 140 |
1461866 | 1461866 | 2021-06-27 | Cumberland | Tennessee | 47035 | 6887 | 140 |
1458621 | 1458621 | 2021-06-26 | Cumberland | Tennessee | 47035 | 6887 | 140 |
1455376 | 1455376 | 2021-06-25 | Cumberland | Tennessee | 47035 | 6887 | 140 |
1452131 | 1452131 | 2021-06-24 | Cumberland | Tennessee | 47035 | 6888 | 140 |
1452187 | 1452187 | 2021-06-24 | Robertson | Tennessee | 47147 | 9957 | 140 |
1448885 | 1448885 | 2021-06-23 | Cumberland | Tennessee | 47035 | 6888 | 140 |
1448941 | 1448941 | 2021-06-23 | Robertson | Tennessee | 47147 | 9956 | 140 |
1445640 | 1445640 | 2021-06-22 | Cumberland | Tennessee | 47035 | 6886 | 140 |
1445696 | 1445696 | 2021-06-22 | Robertson | Tennessee | 47147 | 9953 | 140 |
1442395 | 1442395 | 2021-06-21 | Cumberland | Tennessee | 47035 | 6886 | 140 |
1442451 | 1442451 | 2021-06-21 | Robertson | Tennessee | 47147 | 9953 | 140 |
1439150 | 1439150 | 2021-06-20 | Cumberland | Tennessee | 47035 | 6884 | 140 |
1439206 | 1439206 | 2021-06-20 | Robertson | Tennessee | 47147 | 9947 | 140 |
1435903 | 1435903 | 2021-06-19 | Cumberland | Tennessee | 47035 | 6884 | 140 |
1435959 | 1435959 | 2021-06-19 | Robertson | Tennessee | 47147 | 9947 | 140 |
1432656 | 1432656 | 2021-06-18 | Cumberland | Tennessee | 47035 | 6884 | 140 |
1432712 | 1432712 | 2021-06-18 | Robertson | Tennessee | 47147 | 9947 | 140 |
1429410 | 1429410 | 2021-06-17 | Cumberland | Tennessee | 47035 | 6885 | 140 |
1426165 | 1426165 | 2021-06-16 | Cumberland | Tennessee | 47035 | 6882 | 140 |
1422918 | 1422918 | 2021-06-15 | Cumberland | Tennessee | 47035 | 6883 | 140 |
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);