ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where deaths = 134 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2287385 | 2287385 | 2022-03-08 | Weakley | Tennessee | 47183 | 9440 | 134 |
2284133 | 2284133 | 2022-03-07 | Weakley | Tennessee | 47183 | 9440 | 134 |
2280881 | 2280881 | 2022-03-06 | Weakley | Tennessee | 47183 | 9440 | 134 |
2277628 | 2277628 | 2022-03-05 | Weakley | Tennessee | 47183 | 9440 | 134 |
2274375 | 2274375 | 2022-03-04 | Weakley | Tennessee | 47183 | 9440 | 134 |
2271122 | 2271122 | 2022-03-03 | Weakley | Tennessee | 47183 | 9440 | 134 |
2267870 | 2267870 | 2022-03-02 | Weakley | Tennessee | 47183 | 9440 | 134 |
2173481 | 2173481 | 2022-02-01 | Carroll | Tennessee | 47017 | 7712 | 134 |
2170229 | 2170229 | 2022-01-31 | Carroll | Tennessee | 47017 | 7712 | 134 |
2166975 | 2166975 | 2022-01-30 | Carroll | Tennessee | 47017 | 7712 | 134 |
2163720 | 2163720 | 2022-01-29 | Carroll | Tennessee | 47017 | 7712 | 134 |
2160465 | 2160465 | 2022-01-28 | Carroll | Tennessee | 47017 | 7712 | 134 |
2157209 | 2157209 | 2022-01-27 | Carroll | Tennessee | 47017 | 7712 | 134 |
2153956 | 2153956 | 2022-01-26 | Carroll | Tennessee | 47017 | 7712 | 134 |
2150767 | 2150767 | 2022-01-25 | Rhea | Tennessee | 47143 | 8126 | 134 |
2147515 | 2147515 | 2022-01-24 | Rhea | Tennessee | 47143 | 8126 | 134 |
2144261 | 2144261 | 2022-01-23 | Rhea | Tennessee | 47143 | 8126 | 134 |
2141006 | 2141006 | 2022-01-22 | Rhea | Tennessee | 47143 | 8126 | 134 |
2137750 | 2137750 | 2022-01-21 | Rhea | Tennessee | 47143 | 8126 | 134 |
2134496 | 2134496 | 2022-01-20 | Rhea | Tennessee | 47143 | 8126 | 134 |
2131244 | 2131244 | 2022-01-19 | Rhea | Tennessee | 47143 | 8126 | 134 |
2079167 | 2079167 | 2022-01-03 | Fayette | Tennessee | 47047 | 8695 | 134 |
2079195 | 2079195 | 2022-01-03 | Lincoln | Tennessee | 47103 | 7149 | 134 |
2075944 | 2075944 | 2022-01-02 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2072693 | 2072693 | 2022-01-01 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2069442 | 2069442 | 2021-12-31 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2066191 | 2066191 | 2021-12-30 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2062941 | 2062941 | 2021-12-29 | Lincoln | Tennessee | 47103 | 7017 | 134 |
2053167 | 2053167 | 2021-12-26 | Franklin | Tennessee | 47051 | 8437 | 134 |
2049917 | 2049917 | 2021-12-25 | Franklin | Tennessee | 47051 | 8437 | 134 |
2046667 | 2046667 | 2021-12-24 | Franklin | Tennessee | 47051 | 8437 | 134 |
2043417 | 2043417 | 2021-12-23 | Franklin | Tennessee | 47051 | 8437 | 134 |
2036920 | 2036920 | 2021-12-21 | Giles | Tennessee | 47055 | 6334 | 134 |
2033670 | 2033670 | 2021-12-20 | Giles | Tennessee | 47055 | 6326 | 134 |
2030420 | 2030420 | 2021-12-19 | Giles | Tennessee | 47055 | 6315 | 134 |
2027169 | 2027169 | 2021-12-18 | Giles | Tennessee | 47055 | 6315 | 134 |
2023918 | 2023918 | 2021-12-17 | Giles | Tennessee | 47055 | 6315 | 134 |
2020689 | 2020689 | 2021-12-16 | Lawrence | Tennessee | 47099 | 9911 | 134 |
2017438 | 2017438 | 2021-12-15 | Lawrence | Tennessee | 47099 | 9905 | 134 |
2014188 | 2014188 | 2021-12-14 | Lawrence | Tennessee | 47099 | 9902 | 134 |
2014228 | 2014228 | 2021-12-14 | Warren | Tennessee | 47177 | 8961 | 134 |
2010937 | 2010937 | 2021-12-13 | Lawrence | Tennessee | 47099 | 9891 | 134 |
2007686 | 2007686 | 2021-12-12 | Lawrence | Tennessee | 47099 | 9865 | 134 |
2004435 | 2004435 | 2021-12-11 | Lawrence | Tennessee | 47099 | 9865 | 134 |
2001184 | 2001184 | 2021-12-10 | Lawrence | Tennessee | 47099 | 9865 | 134 |
1975193 | 1975193 | 2021-12-02 | Monroe | Tennessee | 47123 | 9978 | 134 |
1975219 | 1975219 | 2021-12-02 | Unknown | Tennessee | 9460 | 134 | |
1900434 | 1900434 | 2021-11-09 | McMinn | Tennessee | 47107 | 10603 | 134 |
1789923 | 1789923 | 2021-10-06 | Dyer | Tennessee | 47045 | 7987 | 134 |
1786675 | 1786675 | 2021-10-05 | Dyer | Tennessee | 47045 | 7976 | 134 |
1783426 | 1783426 | 2021-10-04 | Dyer | Tennessee | 47045 | 7969 | 134 |
1780177 | 1780177 | 2021-10-03 | Dyer | Tennessee | 47045 | 7944 | 134 |
1776927 | 1776927 | 2021-10-02 | Dyer | Tennessee | 47045 | 7944 | 134 |
1773677 | 1773677 | 2021-10-01 | Dyer | Tennessee | 47045 | 7944 | 134 |
1770427 | 1770427 | 2021-09-30 | Dyer | Tennessee | 47045 | 7926 | 134 |
1767178 | 1767178 | 2021-09-29 | Dyer | Tennessee | 47045 | 7896 | 134 |
1760702 | 1760702 | 2021-09-27 | Jefferson | Tennessee | 47089 | 9388 | 134 |
1757454 | 1757454 | 2021-09-26 | Jefferson | Tennessee | 47089 | 9330 | 134 |
1754206 | 1754206 | 2021-09-25 | Jefferson | Tennessee | 47089 | 9330 | 134 |
1750958 | 1750958 | 2021-09-24 | Jefferson | Tennessee | 47089 | 9330 | 134 |
1747709 | 1747709 | 2021-09-23 | Jefferson | Tennessee | 47089 | 9269 | 134 |
1744459 | 1744459 | 2021-09-22 | Jefferson | Tennessee | 47089 | 9234 | 134 |
1741210 | 1741210 | 2021-09-21 | Jefferson | Tennessee | 47089 | 9133 | 134 |
1741238 | 1741238 | 2021-09-21 | Roane | Tennessee | 47145 | 9124 | 134 |
1737961 | 1737961 | 2021-09-20 | Jefferson | Tennessee | 47089 | 9133 | 134 |
1737989 | 1737989 | 2021-09-20 | Roane | Tennessee | 47145 | 9124 | 134 |
1734711 | 1734711 | 2021-09-19 | Jefferson | Tennessee | 47089 | 9009 | 134 |
1731461 | 1731461 | 2021-09-18 | Jefferson | Tennessee | 47089 | 9009 | 134 |
1728211 | 1728211 | 2021-09-17 | Jefferson | Tennessee | 47089 | 9009 | 134 |
1724962 | 1724962 | 2021-09-16 | Jefferson | Tennessee | 47089 | 8938 | 134 |
1721713 | 1721713 | 2021-09-15 | Jefferson | Tennessee | 47089 | 8897 | 134 |
1711963 | 1711963 | 2021-09-12 | Hawkins | Tennessee | 47073 | 8540 | 134 |
1708716 | 1708716 | 2021-09-11 | Hawkins | Tennessee | 47073 | 8540 | 134 |
1705469 | 1705469 | 2021-09-10 | Hawkins | Tennessee | 47073 | 8540 | 134 |
1702219 | 1702219 | 2021-09-09 | Hawkins | Tennessee | 47073 | 8462 | 134 |
1698949 | 1698949 | 2021-09-08 | Coffee | Tennessee | 47031 | 9002 | 134 |
1698970 | 1698970 | 2021-09-08 | Hawkins | Tennessee | 47073 | 8390 | 134 |
1695722 | 1695722 | 2021-09-07 | Hawkins | Tennessee | 47073 | 8323 | 134 |
1578739 | 1578739 | 2021-08-02 | Bedford | Tennessee | 47003 | 6863 | 134 |
1575491 | 1575491 | 2021-08-01 | Bedford | Tennessee | 47003 | 6837 | 134 |
1572243 | 1572243 | 2021-07-31 | Bedford | Tennessee | 47003 | 6837 | 134 |
1568995 | 1568995 | 2021-07-30 | Bedford | Tennessee | 47003 | 6837 | 134 |
1565747 | 1565747 | 2021-07-29 | Bedford | Tennessee | 47003 | 6828 | 134 |
1562499 | 1562499 | 2021-07-28 | Bedford | Tennessee | 47003 | 6808 | 134 |
1559251 | 1559251 | 2021-07-27 | Bedford | Tennessee | 47003 | 6800 | 134 |
1007377 | 1007377 | 2021-02-07 | Greene | Tennessee | 47059 | 7013 | 134 |
1004131 | 1004131 | 2021-02-06 | Greene | Tennessee | 47059 | 6990 | 134 |
991118 | 991118 | 2021-02-02 | Anderson | Tennessee | 47001 | 7264 | 134 |
987949 | 987949 | 2021-02-01 | Sevier | Tennessee | 47155 | 11137 | 134 |
984702 | 984702 | 2021-01-31 | Sevier | Tennessee | 47155 | 11121 | 134 |
961912 | 961912 | 2021-01-24 | Blount | Tennessee | 47009 | 12366 | 134 |
832185 | 832185 | 2020-12-15 | Washington | Tennessee | 47179 | 8295 | 134 |
764024 | 764024 | 2020-11-24 | Sumner | Tennessee | 47165 | 9163 | 134 |
760779 | 760779 | 2020-11-23 | Sumner | Tennessee | 47165 | 9141 | 134 |
757534 | 757534 | 2020-11-22 | Sumner | Tennessee | 47165 | 9016 | 134 |
754237 | 754237 | 2020-11-21 | Hamilton | Tennessee | 47065 | 16331 | 134 |
750991 | 750991 | 2020-11-20 | Hamilton | Tennessee | 47065 | 16169 | 134 |
747745 | 747745 | 2020-11-19 | Hamilton | Tennessee | 47065 | 15938 | 134 |
741294 | 741294 | 2020-11-17 | Rutherford | Tennessee | 47149 | 15635 | 134 |
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);