ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where county = "Upshur" and deaths = 78 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 |
---|---|---|---|---|---|---|---|
2219630 | 2219630 | 2022-02-15 | Upshur | West Virginia | 54097 | 6452 | 78 |
2216380 | 2216380 | 2022-02-14 | Upshur | West Virginia | 54097 | 6437 | 78 |
2213129 | 2213129 | 2022-02-13 | Upshur | West Virginia | 54097 | 6409 | 78 |
2209876 | 2209876 | 2022-02-12 | Upshur | West Virginia | 54097 | 6388 | 78 |
2206623 | 2206623 | 2022-02-11 | Upshur | West Virginia | 54097 | 6354 | 78 |
2203370 | 2203370 | 2022-02-10 | Upshur | West Virginia | 54097 | 6283 | 78 |
2200116 | 2200116 | 2022-02-09 | Upshur | West Virginia | 54097 | 6228 | 78 |
1624545 | 1624545 | 2021-08-16 | Upshur | Texas | 48459 | 4121 | 78 |
1621298 | 1621298 | 2021-08-15 | Upshur | Texas | 48459 | 4121 | 78 |
1618050 | 1618050 | 2021-08-14 | Upshur | Texas | 48459 | 4106 | 78 |
1614802 | 1614802 | 2021-08-13 | Upshur | Texas | 48459 | 4068 | 78 |
1611553 | 1611553 | 2021-08-12 | Upshur | Texas | 48459 | 4015 | 78 |
1608305 | 1608305 | 2021-08-11 | Upshur | Texas | 48459 | 3988 | 78 |
1605056 | 1605056 | 2021-08-10 | Upshur | Texas | 48459 | 3952 | 78 |
1601807 | 1601807 | 2021-08-09 | Upshur | Texas | 48459 | 3882 | 78 |
1598559 | 1598559 | 2021-08-08 | Upshur | Texas | 48459 | 3867 | 78 |
1595310 | 1595310 | 2021-08-07 | Upshur | Texas | 48459 | 3865 | 78 |
1592061 | 1592061 | 2021-08-06 | Upshur | Texas | 48459 | 3840 | 78 |
1588812 | 1588812 | 2021-08-05 | Upshur | Texas | 48459 | 3828 | 78 |
1585562 | 1585562 | 2021-08-04 | Upshur | Texas | 48459 | 3806 | 78 |
1582312 | 1582312 | 2021-08-03 | Upshur | Texas | 48459 | 3785 | 78 |
1579063 | 1579063 | 2021-08-02 | Upshur | Texas | 48459 | 3776 | 78 |
1575815 | 1575815 | 2021-08-01 | Upshur | Texas | 48459 | 3757 | 78 |
1572567 | 1572567 | 2021-07-31 | Upshur | Texas | 48459 | 3740 | 78 |
1569319 | 1569319 | 2021-07-30 | Upshur | Texas | 48459 | 3718 | 78 |
1566071 | 1566071 | 2021-07-29 | Upshur | Texas | 48459 | 3698 | 78 |
1562823 | 1562823 | 2021-07-28 | Upshur | Texas | 48459 | 3674 | 78 |
1559575 | 1559575 | 2021-07-27 | Upshur | Texas | 48459 | 3652 | 78 |
1556328 | 1556328 | 2021-07-26 | Upshur | Texas | 48459 | 3645 | 78 |
1553081 | 1553081 | 2021-07-25 | Upshur | Texas | 48459 | 3636 | 78 |
1549834 | 1549834 | 2021-07-24 | Upshur | Texas | 48459 | 3626 | 78 |
1546587 | 1546587 | 2021-07-23 | Upshur | Texas | 48459 | 3611 | 78 |
1543340 | 1543340 | 2021-07-22 | Upshur | Texas | 48459 | 3608 | 78 |
1540092 | 1540092 | 2021-07-21 | Upshur | Texas | 48459 | 3603 | 78 |
1536845 | 1536845 | 2021-07-20 | Upshur | Texas | 48459 | 3592 | 78 |
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);