ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where cases = 29 and county = "Haywood" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
180894 | 180894 | 2020-05-26 | Haywood | Tennessee | 47075 | 29 | 2 |
177851 | 177851 | 2020-05-25 | Haywood | Tennessee | 47075 | 29 | 2 |
174807 | 174807 | 2020-05-24 | Haywood | Tennessee | 47075 | 29 | 2 |
171764 | 171764 | 2020-05-23 | Haywood | Tennessee | 47075 | 29 | 2 |
168725 | 168725 | 2020-05-22 | Haywood | Tennessee | 47075 | 29 | 1 |
165689 | 165689 | 2020-05-21 | Haywood | Tennessee | 47075 | 29 | 1 |
162660 | 162660 | 2020-05-20 | Haywood | Tennessee | 47075 | 29 | 1 |
159633 | 159633 | 2020-05-19 | Haywood | Tennessee | 47075 | 29 | 1 |
156611 | 156611 | 2020-05-18 | Haywood | Tennessee | 47075 | 29 | 1 |
153594 | 153594 | 2020-05-17 | Haywood | Tennessee | 47075 | 29 | 1 |
150583 | 150583 | 2020-05-16 | Haywood | Tennessee | 47075 | 29 | 1 |
147575 | 147575 | 2020-05-15 | Haywood | Tennessee | 47075 | 29 | 1 |
144574 | 144574 | 2020-05-14 | Haywood | Tennessee | 47075 | 29 | 1 |
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);