ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where deaths = 194 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446808 | 2446808 | 2022-04-26 | Obion | Tennessee | 47131 | 10765 | 194 |
2443553 | 2443553 | 2022-04-25 | Obion | Tennessee | 47131 | 10765 | 194 |
2440297 | 2440297 | 2022-04-24 | Obion | Tennessee | 47131 | 10765 | 194 |
2437041 | 2437041 | 2022-04-23 | Obion | Tennessee | 47131 | 10765 | 194 |
2433785 | 2433785 | 2022-04-22 | Obion | Tennessee | 47131 | 10765 | 194 |
2430529 | 2430529 | 2022-04-21 | Obion | Tennessee | 47131 | 10765 | 194 |
2427273 | 2427273 | 2022-04-20 | Obion | Tennessee | 47131 | 10765 | 194 |
2059701 | 2059701 | 2021-12-28 | Monroe | Tennessee | 47123 | 10290 | 194 |
2030429 | 2030429 | 2021-12-19 | Hawkins | Tennessee | 47073 | 11167 | 194 |
2027178 | 2027178 | 2021-12-18 | Hawkins | Tennessee | 47073 | 11167 | 194 |
2023927 | 2023927 | 2021-12-17 | Hawkins | Tennessee | 47073 | 11167 | 194 |
2020676 | 2020676 | 2021-12-16 | Hawkins | Tennessee | 47073 | 11155 | 194 |
2017425 | 2017425 | 2021-12-15 | Hawkins | Tennessee | 47073 | 11132 | 194 |
1988158 | 1988158 | 2021-12-06 | Gibson | Tennessee | 47053 | 10865 | 194 |
1832170 | 1832170 | 2021-10-19 | Hamblen | Tennessee | 47063 | 12920 | 194 |
1757410 | 1757410 | 2021-09-26 | Anderson | Tennessee | 47001 | 12065 | 194 |
1754162 | 1754162 | 2021-09-25 | Anderson | Tennessee | 47001 | 12065 | 194 |
1750914 | 1750914 | 2021-09-24 | Anderson | Tennessee | 47001 | 12065 | 194 |
1734676 | 1734676 | 2021-09-19 | Carter | Tennessee | 47019 | 9513 | 194 |
1731426 | 1731426 | 2021-09-18 | Carter | Tennessee | 47019 | 9513 | 194 |
1728176 | 1728176 | 2021-09-17 | Carter | Tennessee | 47019 | 9513 | 194 |
1656780 | 1656780 | 2021-08-26 | Sevier | Tennessee | 47155 | 15821 | 194 |
1247605 | 1247605 | 2021-04-22 | Blount | Tennessee | 47009 | 15240 | 194 |
1244358 | 1244358 | 2021-04-21 | Blount | Tennessee | 47009 | 15213 | 194 |
1241111 | 1241111 | 2021-04-20 | Blount | Tennessee | 47009 | 15194 | 194 |
1237864 | 1237864 | 2021-04-19 | Blount | Tennessee | 47009 | 15180 | 194 |
1234617 | 1234617 | 2021-04-18 | Blount | Tennessee | 47009 | 14963 | 194 |
1231369 | 1231369 | 2021-04-17 | Blount | Tennessee | 47009 | 14963 | 194 |
1228121 | 1228121 | 2021-04-16 | Blount | Tennessee | 47009 | 14963 | 194 |
1224873 | 1224873 | 2021-04-15 | Blount | Tennessee | 47009 | 14940 | 194 |
1221626 | 1221626 | 2021-04-14 | Blount | Tennessee | 47009 | 14917 | 194 |
1218378 | 1218378 | 2021-04-13 | Blount | Tennessee | 47009 | 14894 | 194 |
1215130 | 1215130 | 2021-04-12 | Blount | Tennessee | 47009 | 14882 | 194 |
1211883 | 1211883 | 2021-04-11 | Blount | Tennessee | 47009 | 14839 | 194 |
1208634 | 1208634 | 2021-04-10 | Blount | Tennessee | 47009 | 14839 | 194 |
1205386 | 1205386 | 2021-04-09 | Blount | Tennessee | 47009 | 14839 | 194 |
1198889 | 1198889 | 2021-04-07 | Blount | Tennessee | 47009 | 14798 | 194 |
1195640 | 1195640 | 2021-04-06 | Blount | Tennessee | 47009 | 14770 | 194 |
1192392 | 1192392 | 2021-04-05 | Blount | Tennessee | 47009 | 14762 | 194 |
1189143 | 1189143 | 2021-04-04 | Blount | Tennessee | 47009 | 14717 | 194 |
1185896 | 1185896 | 2021-04-03 | Blount | Tennessee | 47009 | 14717 | 194 |
1182649 | 1182649 | 2021-04-02 | Blount | Tennessee | 47009 | 14717 | 194 |
1179402 | 1179402 | 2021-04-01 | Blount | Tennessee | 47009 | 14717 | 194 |
1176155 | 1176155 | 2021-03-31 | Blount | Tennessee | 47009 | 14698 | 194 |
1020423 | 1020423 | 2021-02-11 | Williamson | Tennessee | 47187 | 24084 | 194 |
1013934 | 1013934 | 2021-02-09 | Wilson | Tennessee | 47189 | 15640 | 194 |
809405 | 809405 | 2020-12-08 | Hamilton | Tennessee | 47065 | 21036 | 194 |
809419 | 809419 | 2020-12-08 | Knox | Tennessee | 47093 | 22414 | 194 |
382023 | 382023 | 2020-07-29 | Davidson | Tennessee | 47037 | 20517 | 194 |
378806 | 378806 | 2020-07-28 | Davidson | Tennessee | 47037 | 20517 | 194 |
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);