ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where county = "Upshur" and deaths = 156 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 |
---|---|---|---|---|---|---|---|
2056716 | 2056716 | 2021-12-27 | Upshur | Texas | 48459 | 6054 | 156 |
2053467 | 2053467 | 2021-12-26 | Upshur | Texas | 48459 | 6038 | 156 |
2050217 | 2050217 | 2021-12-25 | Upshur | Texas | 48459 | 6038 | 156 |
2046967 | 2046967 | 2021-12-24 | Upshur | Texas | 48459 | 6038 | 156 |
2043717 | 2043717 | 2021-12-23 | Upshur | Texas | 48459 | 6038 | 156 |
2040468 | 2040468 | 2021-12-22 | Upshur | Texas | 48459 | 6029 | 156 |
2037218 | 2037218 | 2021-12-21 | Upshur | Texas | 48459 | 6024 | 156 |
2033968 | 2033968 | 2021-12-20 | Upshur | Texas | 48459 | 6021 | 156 |
2030718 | 2030718 | 2021-12-19 | Upshur | Texas | 48459 | 6021 | 156 |
2027467 | 2027467 | 2021-12-18 | Upshur | Texas | 48459 | 6018 | 156 |
2024216 | 2024216 | 2021-12-17 | Upshur | Texas | 48459 | 6004 | 156 |
2020965 | 2020965 | 2021-12-16 | Upshur | Texas | 48459 | 5991 | 156 |
2017714 | 2017714 | 2021-12-15 | Upshur | Texas | 48459 | 5985 | 156 |
2014464 | 2014464 | 2021-12-14 | Upshur | Texas | 48459 | 5971 | 156 |
2011213 | 2011213 | 2021-12-13 | Upshur | Texas | 48459 | 5957 | 156 |
2007962 | 2007962 | 2021-12-12 | Upshur | Texas | 48459 | 5957 | 156 |
2004711 | 2004711 | 2021-12-11 | Upshur | Texas | 48459 | 5957 | 156 |
2001460 | 2001460 | 2021-12-10 | Upshur | Texas | 48459 | 5944 | 156 |
1998210 | 1998210 | 2021-12-09 | Upshur | Texas | 48459 | 5939 | 156 |
1994959 | 1994959 | 2021-12-08 | Upshur | Texas | 48459 | 5931 | 156 |
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);