ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where county = "Haywood", deaths = 30 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
822392 | 822392 | 2020-12-12 | Haywood | Tennessee | 47075 | 1845 | 30 |
819146 | 819146 | 2020-12-11 | Haywood | Tennessee | 47075 | 1822 | 30 |
815900 | 815900 | 2020-12-10 | Haywood | Tennessee | 47075 | 1797 | 30 |
812654 | 812654 | 2020-12-09 | Haywood | Tennessee | 47075 | 1789 | 30 |
809410 | 809410 | 2020-12-08 | Haywood | Tennessee | 47075 | 1758 | 30 |
806165 | 806165 | 2020-12-07 | Haywood | Tennessee | 47075 | 1737 | 30 |
802920 | 802920 | 2020-12-06 | Haywood | Tennessee | 47075 | 1717 | 30 |
799675 | 799675 | 2020-12-05 | Haywood | Tennessee | 47075 | 1704 | 30 |
796430 | 796430 | 2020-12-04 | Haywood | Tennessee | 47075 | 1695 | 30 |
793185 | 793185 | 2020-12-03 | Haywood | Tennessee | 47075 | 1688 | 30 |
789940 | 789940 | 2020-12-02 | Haywood | Tennessee | 47075 | 1685 | 30 |
786695 | 786695 | 2020-12-01 | Haywood | Tennessee | 47075 | 1665 | 30 |
783451 | 783451 | 2020-11-30 | Haywood | Tennessee | 47075 | 1658 | 30 |
780206 | 780206 | 2020-11-29 | Haywood | Tennessee | 47075 | 1633 | 30 |
776960 | 776960 | 2020-11-28 | Haywood | Tennessee | 47075 | 1629 | 30 |
773715 | 773715 | 2020-11-27 | Haywood | Tennessee | 47075 | 1608 | 30 |
770470 | 770470 | 2020-11-26 | Haywood | Tennessee | 47075 | 1602 | 30 |
767224 | 767224 | 2020-11-25 | Haywood | Tennessee | 47075 | 1600 | 30 |
763979 | 763979 | 2020-11-24 | Haywood | Tennessee | 47075 | 1595 | 30 |
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);