ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where county = "Upshur" and deaths = 77 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 |
---|---|---|---|---|---|---|---|
2196862 | 2196862 | 2022-02-08 | Upshur | West Virginia | 54097 | 6211 | 77 |
2193607 | 2193607 | 2022-02-07 | Upshur | West Virginia | 54097 | 6191 | 77 |
2190354 | 2190354 | 2022-02-06 | Upshur | West Virginia | 54097 | 6173 | 77 |
2187101 | 2187101 | 2022-02-05 | Upshur | West Virginia | 54097 | 6157 | 77 |
2183848 | 2183848 | 2022-02-04 | Upshur | West Virginia | 54097 | 6073 | 77 |
2180596 | 2180596 | 2022-02-03 | Upshur | West Virginia | 54097 | 6017 | 77 |
2177345 | 2177345 | 2022-02-02 | Upshur | West Virginia | 54097 | 5935 | 77 |
2174092 | 2174092 | 2022-02-01 | Upshur | West Virginia | 54097 | 5898 | 77 |
2170840 | 2170840 | 2022-01-31 | Upshur | West Virginia | 54097 | 5870 | 77 |
2167587 | 2167587 | 2022-01-30 | Upshur | West Virginia | 54097 | 5853 | 77 |
2164332 | 2164332 | 2022-01-29 | Upshur | West Virginia | 54097 | 5836 | 77 |
2161077 | 2161077 | 2022-01-28 | Upshur | West Virginia | 54097 | 5803 | 77 |
2157821 | 2157821 | 2022-01-27 | Upshur | West Virginia | 54097 | 5753 | 77 |
2154568 | 2154568 | 2022-01-26 | Upshur | West Virginia | 54097 | 5706 | 77 |
2151315 | 2151315 | 2022-01-25 | Upshur | West Virginia | 54097 | 5663 | 77 |
2148063 | 2148063 | 2022-01-24 | Upshur | West Virginia | 54097 | 5646 | 77 |
2144811 | 2144811 | 2022-01-23 | Upshur | West Virginia | 54097 | 5624 | 77 |
2141556 | 2141556 | 2022-01-22 | Upshur | West Virginia | 54097 | 5577 | 77 |
2138300 | 2138300 | 2022-01-21 | Upshur | West Virginia | 54097 | 5522 | 77 |
2135045 | 2135045 | 2022-01-20 | Upshur | West Virginia | 54097 | 5463 | 77 |
2131793 | 2131793 | 2022-01-19 | Upshur | West Virginia | 54097 | 5392 | 77 |
2128539 | 2128539 | 2022-01-18 | Upshur | West Virginia | 54097 | 5355 | 77 |
2125286 | 2125286 | 2022-01-17 | Upshur | West Virginia | 54097 | 5331 | 77 |
2122034 | 2122034 | 2022-01-16 | Upshur | West Virginia | 54097 | 5315 | 77 |
2118782 | 2118782 | 2022-01-15 | Upshur | West Virginia | 54097 | 5281 | 77 |
2115530 | 2115530 | 2022-01-14 | Upshur | West Virginia | 54097 | 5240 | 77 |
2112278 | 2112278 | 2022-01-13 | Upshur | West Virginia | 54097 | 5178 | 77 |
2109026 | 2109026 | 2022-01-12 | Upshur | West Virginia | 54097 | 5128 | 77 |
1533597 | 1533597 | 2021-07-19 | Upshur | Texas | 48459 | 3579 | 77 |
1530350 | 1530350 | 2021-07-18 | Upshur | Texas | 48459 | 3579 | 77 |
1527103 | 1527103 | 2021-07-17 | Upshur | Texas | 48459 | 3578 | 77 |
1523856 | 1523856 | 2021-07-16 | Upshur | Texas | 48459 | 3573 | 77 |
1520608 | 1520608 | 2021-07-15 | Upshur | Texas | 48459 | 3570 | 77 |
1517360 | 1517360 | 2021-07-14 | Upshur | Texas | 48459 | 3566 | 77 |
1514113 | 1514113 | 2021-07-13 | Upshur | Texas | 48459 | 3562 | 77 |
1510867 | 1510867 | 2021-07-12 | Upshur | Texas | 48459 | 3557 | 77 |
1507620 | 1507620 | 2021-07-11 | Upshur | Texas | 48459 | 3557 | 77 |
1504374 | 1504374 | 2021-07-10 | Upshur | Texas | 48459 | 3557 | 77 |
1501128 | 1501128 | 2021-07-09 | Upshur | Texas | 48459 | 3555 | 77 |
1497882 | 1497882 | 2021-07-08 | Upshur | Texas | 48459 | 3553 | 77 |
1494635 | 1494635 | 2021-07-07 | Upshur | Texas | 48459 | 3548 | 77 |
1491388 | 1491388 | 2021-07-06 | Upshur | Texas | 48459 | 3545 | 77 |
1488141 | 1488141 | 2021-07-05 | Upshur | Texas | 48459 | 3542 | 77 |
1484894 | 1484894 | 2021-07-04 | Upshur | Texas | 48459 | 3541 | 77 |
1481648 | 1481648 | 2021-07-03 | Upshur | Texas | 48459 | 3539 | 77 |
1478401 | 1478401 | 2021-07-02 | Upshur | Texas | 48459 | 3534 | 77 |
1475155 | 1475155 | 2021-07-01 | Upshur | Texas | 48459 | 3529 | 77 |
1471909 | 1471909 | 2021-06-30 | Upshur | Texas | 48459 | 3525 | 77 |
1468664 | 1468664 | 2021-06-29 | Upshur | Texas | 48459 | 3523 | 77 |
1465419 | 1465419 | 2021-06-28 | Upshur | Texas | 48459 | 3520 | 77 |
1462174 | 1462174 | 2021-06-27 | Upshur | Texas | 48459 | 3519 | 77 |
1458929 | 1458929 | 2021-06-26 | Upshur | Texas | 48459 | 3519 | 77 |
1455684 | 1455684 | 2021-06-25 | Upshur | Texas | 48459 | 3507 | 77 |
1452439 | 1452439 | 2021-06-24 | Upshur | Texas | 48459 | 3463 | 77 |
1449193 | 1449193 | 2021-06-23 | Upshur | Texas | 48459 | 3416 | 77 |
1445948 | 1445948 | 2021-06-22 | Upshur | Texas | 48459 | 3370 | 77 |
1442703 | 1442703 | 2021-06-21 | Upshur | Texas | 48459 | 3373 | 77 |
1439458 | 1439458 | 2021-06-20 | Upshur | Texas | 48459 | 3373 | 77 |
1436211 | 1436211 | 2021-06-19 | Upshur | Texas | 48459 | 3374 | 77 |
1432964 | 1432964 | 2021-06-18 | Upshur | Texas | 48459 | 3322 | 77 |
1429718 | 1429718 | 2021-06-17 | Upshur | Texas | 48459 | 3321 | 77 |
1426473 | 1426473 | 2021-06-16 | Upshur | Texas | 48459 | 3321 | 77 |
1423226 | 1423226 | 2021-06-15 | Upshur | Texas | 48459 | 3319 | 77 |
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);