ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 66 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
440014 | 440014 | 2020-08-16 | Houston | Tennessee | 47083 | 66 | 0 |
404536 | 404536 | 2020-08-05 | Clay | Tennessee | 47027 | 66 | 0 |
385247 | 385247 | 2020-07-30 | Fentress | Tennessee | 47049 | 66 | 0 |
369207 | 369207 | 2020-07-25 | Meigs | Tennessee | 47121 | 66 | 0 |
350000 | 350000 | 2020-07-19 | Unicoi | Tennessee | 47171 | 66 | 0 |
346800 | 346800 | 2020-07-18 | Unicoi | Tennessee | 47171 | 66 | 0 |
340324 | 340324 | 2020-07-16 | Cannon | Tennessee | 47015 | 66 | 0 |
314867 | 314867 | 2020-07-08 | Hawkins | Tennessee | 47073 | 66 | 2 |
311749 | 311749 | 2020-07-07 | Weakley | Tennessee | 47183 | 66 | 1 |
302176 | 302176 | 2020-07-04 | DeKalb | Tennessee | 47041 | 66 | 0 |
273817 | 273817 | 2020-06-25 | Greene | Tennessee | 47059 | 66 | 2 |
270689 | 270689 | 2020-06-24 | Hickman | Tennessee | 47081 | 66 | 0 |
248776 | 248776 | 2020-06-17 | Anderson | Tennessee | 47001 | 66 | 2 |
223999 | 223999 | 2020-06-09 | Sullivan | Tennessee | 47163 | 66 | 2 |
202372 | 202372 | 2020-06-02 | Monroe | Tennessee | 47123 | 66 | 2 |
183922 | 183922 | 2020-05-27 | Coffee | Tennessee | 47031 | 66 | 0 |
180872 | 180872 | 2020-05-26 | Coffee | Tennessee | 47031 | 66 | 0 |
177829 | 177829 | 2020-05-25 | Coffee | Tennessee | 47031 | 66 | 0 |
156664 | 156664 | 2020-05-18 | Washington | Tennessee | 47179 | 66 | 0 |
153647 | 153647 | 2020-05-17 | Washington | Tennessee | 47179 | 66 | 0 |
150636 | 150636 | 2020-05-16 | Washington | Tennessee | 47179 | 66 | 0 |
147615 | 147615 | 2020-05-15 | Sevier | Tennessee | 47155 | 66 | 2 |
147628 | 147628 | 2020-05-15 | Washington | Tennessee | 47179 | 66 | 0 |
144627 | 144627 | 2020-05-14 | Washington | Tennessee | 47179 | 66 | 0 |
135565 | 135565 | 2020-05-11 | Cheatham | Tennessee | 47021 | 66 | 0 |
91869 | 91869 | 2020-04-26 | Dickson | Tennessee | 47043 | 66 | 0 |
23465 | 23465 | 2020-03-31 | Knox | Tennessee | 47093 | 66 | 1 |
12109 | 12109 | 2020-03-25 | Williamson | Tennessee | 47187 | 66 | 0 |
9289 | 9289 | 2020-03-23 | Shelby | Tennessee | 47157 | 66 | 0 |
8071 | 8071 | 2020-03-22 | Shelby | Tennessee | 47157 | 66 | 0 |
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);