ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 143 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401196 | 2401196 | 2022-04-12 | Hardin | Tennessee | 47071 | 8750 | 143 |
2397941 | 2397941 | 2022-04-11 | Hardin | Tennessee | 47071 | 8750 | 143 |
2394686 | 2394686 | 2022-04-10 | Hardin | Tennessee | 47071 | 8750 | 143 |
2391430 | 2391430 | 2022-04-09 | Hardin | Tennessee | 47071 | 8750 | 143 |
2388174 | 2388174 | 2022-04-08 | Hardin | Tennessee | 47071 | 8750 | 143 |
2384919 | 2384919 | 2022-04-07 | Hardin | Tennessee | 47071 | 8750 | 143 |
2381664 | 2381664 | 2022-04-06 | Hardin | Tennessee | 47071 | 8750 | 143 |
2264563 | 2264563 | 2022-03-01 | Henderson | Tennessee | 47077 | 8798 | 143 |
2261313 | 2261313 | 2022-02-28 | Henderson | Tennessee | 47077 | 8798 | 143 |
2258062 | 2258062 | 2022-02-27 | Henderson | Tennessee | 47077 | 8798 | 143 |
2254811 | 2254811 | 2022-02-26 | Henderson | Tennessee | 47077 | 8798 | 143 |
2251560 | 2251560 | 2022-02-25 | Henderson | Tennessee | 47077 | 8798 | 143 |
2248309 | 2248309 | 2022-02-24 | Henderson | Tennessee | 47077 | 8798 | 143 |
2245058 | 2245058 | 2022-02-23 | Henderson | Tennessee | 47077 | 8798 | 143 |
2053154 | 2053154 | 2021-12-26 | Claiborne | Tennessee | 47025 | 6031 | 143 |
2049904 | 2049904 | 2021-12-25 | Claiborne | Tennessee | 47025 | 6031 | 143 |
2046654 | 2046654 | 2021-12-24 | Claiborne | Tennessee | 47025 | 6031 | 143 |
2043404 | 2043404 | 2021-12-23 | Claiborne | Tennessee | 47025 | 6031 | 143 |
1997972 | 1997972 | 2021-12-09 | Unknown | Tennessee | 9097 | 143 | |
1994721 | 1994721 | 2021-12-08 | Unknown | Tennessee | 9490 | 143 | |
1991470 | 1991470 | 2021-12-07 | Unknown | Tennessee | 9389 | 143 | |
1984940 | 1984940 | 2021-12-05 | McMinn | Tennessee | 47107 | 10789 | 143 |
1981690 | 1981690 | 2021-12-04 | McMinn | Tennessee | 47107 | 10789 | 143 |
1978440 | 1978440 | 2021-12-03 | McMinn | Tennessee | 47107 | 10789 | 143 |
1975215 | 1975215 | 2021-12-02 | Tipton | Tennessee | 47167 | 11742 | 143 |
1971966 | 1971966 | 2021-12-01 | Tipton | Tennessee | 47167 | 11723 | 143 |
1835410 | 1835410 | 2021-10-20 | Dyer | Tennessee | 47045 | 8057 | 143 |
1780227 | 1780227 | 2021-10-03 | Roane | Tennessee | 47145 | 9494 | 143 |
1776977 | 1776977 | 2021-10-02 | Roane | Tennessee | 47145 | 9494 | 143 |
1773727 | 1773727 | 2021-10-01 | Roane | Tennessee | 47145 | 9494 | 143 |
1770477 | 1770477 | 2021-09-30 | Roane | Tennessee | 47145 | 9465 | 143 |
1760673 | 1760673 | 2021-09-27 | Coffee | Tennessee | 47031 | 9988 | 143 |
1721690 | 1721690 | 2021-09-15 | Dickson | Tennessee | 47043 | 9396 | 143 |
1588504 | 1588504 | 2021-08-05 | Cumberland | Tennessee | 47035 | 7258 | 143 |
1585254 | 1585254 | 2021-08-04 | Cumberland | Tennessee | 47035 | 7211 | 143 |
1582004 | 1582004 | 2021-08-03 | Cumberland | Tennessee | 47035 | 7185 | 143 |
1578755 | 1578755 | 2021-08-02 | Cumberland | Tennessee | 47035 | 7155 | 143 |
1575507 | 1575507 | 2021-08-01 | Cumberland | Tennessee | 47035 | 7083 | 143 |
1575563 | 1575563 | 2021-08-01 | Robertson | Tennessee | 47147 | 10197 | 143 |
1572259 | 1572259 | 2021-07-31 | Cumberland | Tennessee | 47035 | 7083 | 143 |
1572315 | 1572315 | 2021-07-31 | Robertson | Tennessee | 47147 | 10197 | 143 |
1569011 | 1569011 | 2021-07-30 | Cumberland | Tennessee | 47035 | 7083 | 143 |
1569067 | 1569067 | 2021-07-30 | Robertson | Tennessee | 47147 | 10197 | 143 |
1565763 | 1565763 | 2021-07-29 | Cumberland | Tennessee | 47035 | 7068 | 143 |
1562515 | 1562515 | 2021-07-28 | Cumberland | Tennessee | 47035 | 7040 | 143 |
1192414 | 1192414 | 2021-04-05 | Gibson | Tennessee | 47053 | 6326 | 143 |
1189165 | 1189165 | 2021-04-04 | Gibson | Tennessee | 47053 | 6304 | 143 |
1185918 | 1185918 | 2021-04-03 | Gibson | Tennessee | 47053 | 6304 | 143 |
1182671 | 1182671 | 2021-04-02 | Gibson | Tennessee | 47053 | 6304 | 143 |
1179424 | 1179424 | 2021-04-01 | Gibson | Tennessee | 47053 | 6304 | 143 |
1176177 | 1176177 | 2021-03-31 | Gibson | Tennessee | 47053 | 6289 | 143 |
1172930 | 1172930 | 2021-03-30 | Gibson | Tennessee | 47053 | 6284 | 143 |
1169662 | 1169662 | 2021-03-29 | Bradley | Tennessee | 47011 | 13972 | 143 |
1169683 | 1169683 | 2021-03-29 | Gibson | Tennessee | 47053 | 6283 | 143 |
1166414 | 1166414 | 2021-03-28 | Bradley | Tennessee | 47011 | 13914 | 143 |
1166435 | 1166435 | 2021-03-28 | Gibson | Tennessee | 47053 | 6269 | 143 |
1163166 | 1163166 | 2021-03-27 | Bradley | Tennessee | 47011 | 13914 | 143 |
1163187 | 1163187 | 2021-03-27 | Gibson | Tennessee | 47053 | 6269 | 143 |
1159917 | 1159917 | 2021-03-26 | Bradley | Tennessee | 47011 | 13914 | 143 |
1159938 | 1159938 | 2021-03-26 | Gibson | Tennessee | 47053 | 6269 | 143 |
1156670 | 1156670 | 2021-03-25 | Bradley | Tennessee | 47011 | 13879 | 143 |
1153423 | 1153423 | 2021-03-24 | Bradley | Tennessee | 47011 | 13827 | 143 |
1056061 | 1056061 | 2021-02-22 | Greene | Tennessee | 47059 | 7249 | 143 |
1052815 | 1052815 | 2021-02-21 | Greene | Tennessee | 47059 | 7244 | 143 |
1049568 | 1049568 | 2021-02-20 | Greene | Tennessee | 47059 | 7238 | 143 |
1007348 | 1007348 | 2021-02-07 | Anderson | Tennessee | 47001 | 7377 | 143 |
1004102 | 1004102 | 2021-02-06 | Anderson | Tennessee | 47001 | 7359 | 143 |
991149 | 991149 | 2021-02-02 | Hamblen | Tennessee | 47063 | 7458 | 143 |
984629 | 984629 | 2021-01-31 | Blount | Tennessee | 47009 | 12645 | 143 |
981382 | 981382 | 2021-01-30 | Blount | Tennessee | 47009 | 12622 | 143 |
841922 | 841922 | 2020-12-18 | Washington | Tennessee | 47179 | 8796 | 143 |
747787 | 747787 | 2020-11-19 | Rutherford | Tennessee | 47149 | 16052 | 143 |
327566 | 327566 | 2020-07-12 | Davidson | Tennessee | 47037 | 14538 | 143 |
324381 | 324381 | 2020-07-11 | Davidson | Tennessee | 47037 | 14319 | 143 |
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);