ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 1070 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 11
state 1
- Tennessee · 21 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1828958 | 1828958 | 2021-10-18 | Pickett | Tennessee | 47137 | 1070 | 24 |
1575553 | 1575553 | 2021-08-01 | Moore | Tennessee | 47127 | 1070 | 17 |
1572305 | 1572305 | 2021-07-31 | Moore | Tennessee | 47127 | 1070 | 17 |
1569057 | 1569057 | 2021-07-30 | Moore | Tennessee | 47127 | 1070 | 17 |
1471651 | 1471651 | 2021-06-30 | Perry | Tennessee | 47135 | 1070 | 29 |
1468406 | 1468406 | 2021-06-29 | Perry | Tennessee | 47135 | 1070 | 29 |
1465161 | 1465161 | 2021-06-28 | Perry | Tennessee | 47135 | 1070 | 29 |
1461916 | 1461916 | 2021-06-27 | Perry | Tennessee | 47135 | 1070 | 29 |
1458671 | 1458671 | 2021-06-26 | Perry | Tennessee | 47135 | 1070 | 29 |
1455426 | 1455426 | 2021-06-25 | Perry | Tennessee | 47135 | 1070 | 29 |
1452181 | 1452181 | 2021-06-24 | Perry | Tennessee | 47135 | 1070 | 29 |
1377532 | 1377532 | 2021-06-01 | Perry | Tennessee | 47135 | 1070 | 28 |
1312602 | 1312602 | 2021-05-12 | Perry | Tennessee | 47135 | 1070 | 28 |
1195677 | 1195677 | 2021-04-06 | Houston | Tennessee | 47083 | 1070 | 33 |
968440 | 968440 | 2021-01-26 | Jackson | Tennessee | 47087 | 1070 | 24 |
949007 | 949007 | 2021-01-20 | Stewart | Tennessee | 47161 | 1070 | 20 |
916533 | 916533 | 2021-01-10 | Meigs | Tennessee | 47121 | 1070 | 16 |
712026 | 712026 | 2020-11-08 | Bledsoe | Tennessee | 47007 | 1070 | 4 |
643997 | 643997 | 2020-10-18 | White | Tennessee | 47185 | 1070 | 14 |
585582 | 585582 | 2020-09-30 | Macon | Tennessee | 47111 | 1070 | 21 |
533722 | 533722 | 2020-09-14 | Cumberland | Tennessee | 47035 | 1070 | 12 |
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);