ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where deaths = 142 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378466 | 2378466 | 2022-04-05 | Weakley | Tennessee | 47183 | 9498 | 142 |
2375212 | 2375212 | 2022-04-04 | Weakley | Tennessee | 47183 | 9498 | 142 |
2371960 | 2371960 | 2022-04-03 | Weakley | Tennessee | 47183 | 9498 | 142 |
2368707 | 2368707 | 2022-04-02 | Weakley | Tennessee | 47183 | 9498 | 142 |
2365454 | 2365454 | 2022-04-01 | Weakley | Tennessee | 47183 | 9498 | 142 |
2362201 | 2362201 | 2022-03-31 | Weakley | Tennessee | 47183 | 9498 | 142 |
2358947 | 2358947 | 2022-03-30 | Weakley | Tennessee | 47183 | 9498 | 142 |
2332882 | 2332882 | 2022-03-22 | Macon | Tennessee | 47111 | 8417 | 142 |
2329629 | 2329629 | 2022-03-21 | Macon | Tennessee | 47111 | 8417 | 142 |
2326377 | 2326377 | 2022-03-20 | Macon | Tennessee | 47111 | 8417 | 142 |
2323124 | 2323124 | 2022-03-19 | Macon | Tennessee | 47111 | 8417 | 142 |
2319870 | 2319870 | 2022-03-18 | Macon | Tennessee | 47111 | 8417 | 142 |
2316616 | 2316616 | 2022-03-17 | Macon | Tennessee | 47111 | 8417 | 142 |
2313363 | 2313363 | 2022-03-16 | Macon | Tennessee | 47111 | 8417 | 142 |
2173496 | 2173496 | 2022-02-01 | Fayette | Tennessee | 47047 | 10366 | 142 |
2170244 | 2170244 | 2022-01-31 | Fayette | Tennessee | 47047 | 10366 | 142 |
2166990 | 2166990 | 2022-01-30 | Fayette | Tennessee | 47047 | 10366 | 142 |
2163735 | 2163735 | 2022-01-29 | Fayette | Tennessee | 47047 | 10366 | 142 |
2160480 | 2160480 | 2022-01-28 | Fayette | Tennessee | 47047 | 10366 | 142 |
2157224 | 2157224 | 2022-01-27 | Fayette | Tennessee | 47047 | 10366 | 142 |
2153971 | 2153971 | 2022-01-26 | Fayette | Tennessee | 47047 | 10366 | 142 |
2020701 | 2020701 | 2021-12-16 | Monroe | Tennessee | 47123 | 10141 | 142 |
2017450 | 2017450 | 2021-12-15 | Monroe | Tennessee | 47123 | 10135 | 142 |
1975190 | 1975190 | 2021-12-02 | McMinn | Tennessee | 47107 | 10782 | 142 |
1968716 | 1968716 | 2021-11-30 | Tipton | Tennessee | 47167 | 11700 | 142 |
1835432 | 1835432 | 2021-10-20 | Jefferson | Tennessee | 47089 | 9853 | 142 |
1832161 | 1832161 | 2021-10-19 | Dyer | Tennessee | 47045 | 8052 | 142 |
1828912 | 1828912 | 2021-10-18 | Dyer | Tennessee | 47045 | 8051 | 142 |
1825663 | 1825663 | 2021-10-17 | Dyer | Tennessee | 47045 | 8045 | 142 |
1822414 | 1822414 | 2021-10-16 | Dyer | Tennessee | 47045 | 8045 | 142 |
1819165 | 1819165 | 2021-10-15 | Dyer | Tennessee | 47045 | 8045 | 142 |
1815916 | 1815916 | 2021-10-14 | Dyer | Tennessee | 47045 | 8041 | 142 |
1812668 | 1812668 | 2021-10-13 | Dyer | Tennessee | 47045 | 8035 | 142 |
1757425 | 1757425 | 2021-09-26 | Coffee | Tennessee | 47031 | 9931 | 142 |
1754177 | 1754177 | 2021-09-25 | Coffee | Tennessee | 47031 | 9931 | 142 |
1750929 | 1750929 | 2021-09-24 | Coffee | Tennessee | 47031 | 9931 | 142 |
1747666 | 1747666 | 2021-09-23 | Bedford | Tennessee | 47003 | 8568 | 142 |
1744416 | 1744416 | 2021-09-22 | Bedford | Tennessee | 47003 | 8539 | 142 |
1741202 | 1741202 | 2021-09-21 | Hawkins | Tennessee | 47073 | 9290 | 142 |
1737953 | 1737953 | 2021-09-20 | Hawkins | Tennessee | 47073 | 9290 | 142 |
1565819 | 1565819 | 2021-07-29 | Robertson | Tennessee | 47147 | 10186 | 142 |
1562571 | 1562571 | 2021-07-28 | Robertson | Tennessee | 47147 | 10164 | 142 |
1559267 | 1559267 | 2021-07-27 | Cumberland | Tennessee | 47035 | 7012 | 142 |
1559323 | 1559323 | 2021-07-27 | Robertson | Tennessee | 47147 | 10141 | 142 |
1556020 | 1556020 | 2021-07-26 | Cumberland | Tennessee | 47035 | 7000 | 142 |
1556076 | 1556076 | 2021-07-26 | Robertson | Tennessee | 47147 | 10127 | 142 |
1552773 | 1552773 | 2021-07-25 | Cumberland | Tennessee | 47035 | 6970 | 142 |
1552829 | 1552829 | 2021-07-25 | Robertson | Tennessee | 47147 | 10103 | 142 |
1549526 | 1549526 | 2021-07-24 | Cumberland | Tennessee | 47035 | 6970 | 142 |
1549582 | 1549582 | 2021-07-24 | Robertson | Tennessee | 47147 | 10103 | 142 |
1546279 | 1546279 | 2021-07-23 | Cumberland | Tennessee | 47035 | 6970 | 142 |
1546335 | 1546335 | 2021-07-23 | Robertson | Tennessee | 47147 | 10103 | 142 |
1543032 | 1543032 | 2021-07-22 | Cumberland | Tennessee | 47035 | 6957 | 142 |
1543088 | 1543088 | 2021-07-22 | Robertson | Tennessee | 47147 | 10099 | 142 |
1539784 | 1539784 | 2021-07-21 | Cumberland | Tennessee | 47035 | 6944 | 142 |
1539840 | 1539840 | 2021-07-21 | Robertson | Tennessee | 47147 | 10084 | 142 |
1156691 | 1156691 | 2021-03-25 | Gibson | Tennessee | 47053 | 6265 | 142 |
1153444 | 1153444 | 2021-03-24 | Gibson | Tennessee | 47053 | 6260 | 142 |
1150176 | 1150176 | 2021-03-23 | Bradley | Tennessee | 47011 | 13779 | 142 |
1146929 | 1146929 | 2021-03-22 | Bradley | Tennessee | 47011 | 13730 | 142 |
1143682 | 1143682 | 2021-03-21 | Bradley | Tennessee | 47011 | 13655 | 142 |
1140435 | 1140435 | 2021-03-20 | Bradley | Tennessee | 47011 | 13655 | 142 |
1137189 | 1137189 | 2021-03-19 | Bradley | Tennessee | 47011 | 13655 | 142 |
1133943 | 1133943 | 2021-03-18 | Bradley | Tennessee | 47011 | 13575 | 142 |
1130695 | 1130695 | 2021-03-17 | Bradley | Tennessee | 47011 | 13557 | 142 |
1120956 | 1120956 | 2021-03-14 | Bradley | Tennessee | 47011 | 13318 | 142 |
1117709 | 1117709 | 2021-03-13 | Bradley | Tennessee | 47011 | 13318 | 142 |
1114462 | 1114462 | 2021-03-12 | Bradley | Tennessee | 47011 | 13318 | 142 |
1111216 | 1111216 | 2021-03-11 | Bradley | Tennessee | 47011 | 13257 | 142 |
1046321 | 1046321 | 2021-02-19 | Greene | Tennessee | 47059 | 7220 | 142 |
1043076 | 1043076 | 2021-02-18 | Greene | Tennessee | 47059 | 7213 | 142 |
1039831 | 1039831 | 2021-02-17 | Greene | Tennessee | 47059 | 7203 | 142 |
1000856 | 1000856 | 2021-02-05 | Anderson | Tennessee | 47001 | 7337 | 142 |
997687 | 997687 | 2021-02-04 | Sevier | Tennessee | 47155 | 11253 | 142 |
987929 | 987929 | 2021-02-01 | Maury | Tennessee | 47119 | 11653 | 142 |
978163 | 978163 | 2021-01-29 | Hamblen | Tennessee | 47063 | 7384 | 142 |
978219 | 978219 | 2021-01-29 | Unknown | Tennessee | 13195 | 142 | |
952266 | 952266 | 2021-01-21 | Williamson | Tennessee | 47187 | 21776 | 142 |
923025 | 923025 | 2021-01-12 | Montgomery | Tennessee | 47125 | 13540 | 142 |
919813 | 919813 | 2021-01-11 | Wilson | Tennessee | 47189 | 13903 | 142 |
851622 | 851622 | 2020-12-21 | Madison | Tennessee | 47113 | 7332 | 142 |
793230 | 793230 | 2020-12-03 | Sumner | Tennessee | 47165 | 10566 | 142 |
321200 | 321200 | 2020-07-10 | Davidson | Tennessee | 47037 | 13802 | 142 |
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);