ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where county = "McDowell", deaths = 27 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1673539 | 1673539 | 2021-08-31 | McDowell | West Virginia | 54047 | 1936 | 27 |
1670291 | 1670291 | 2021-08-30 | McDowell | West Virginia | 54047 | 1929 | 27 |
1667044 | 1667044 | 2021-08-29 | McDowell | West Virginia | 54047 | 1915 | 27 |
1663796 | 1663796 | 2021-08-28 | McDowell | West Virginia | 54047 | 1877 | 27 |
1660548 | 1660548 | 2021-08-27 | McDowell | West Virginia | 54047 | 1877 | 27 |
1657300 | 1657300 | 2021-08-26 | McDowell | West Virginia | 54047 | 1856 | 27 |
1654052 | 1654052 | 2021-08-25 | McDowell | West Virginia | 54047 | 1847 | 27 |
1650806 | 1650806 | 2021-08-24 | McDowell | West Virginia | 54047 | 1833 | 27 |
1647557 | 1647557 | 2021-08-23 | McDowell | West Virginia | 54047 | 1829 | 27 |
1644308 | 1644308 | 2021-08-22 | McDowell | West Virginia | 54047 | 1786 | 27 |
1641058 | 1641058 | 2021-08-21 | McDowell | West Virginia | 54047 | 1786 | 27 |
1637808 | 1637808 | 2021-08-20 | McDowell | West Virginia | 54047 | 1786 | 27 |
1634558 | 1634558 | 2021-08-19 | McDowell | West Virginia | 54047 | 1778 | 27 |
1631310 | 1631310 | 2021-08-18 | McDowell | West Virginia | 54047 | 1761 | 27 |
1628063 | 1628063 | 2021-08-17 | McDowell | West Virginia | 54047 | 1746 | 27 |
1624816 | 1624816 | 2021-08-16 | McDowell | West Virginia | 54047 | 1740 | 27 |
1621569 | 1621569 | 2021-08-15 | McDowell | West Virginia | 54047 | 1732 | 27 |
1618321 | 1618321 | 2021-08-14 | McDowell | West Virginia | 54047 | 1732 | 27 |
1615073 | 1615073 | 2021-08-13 | McDowell | West Virginia | 54047 | 1732 | 27 |
1611824 | 1611824 | 2021-08-12 | McDowell | West Virginia | 54047 | 1732 | 27 |
1608577 | 1608577 | 2021-08-11 | McDowell | West Virginia | 54047 | 1720 | 27 |
1605328 | 1605328 | 2021-08-10 | McDowell | West Virginia | 54047 | 1715 | 27 |
1602078 | 1602078 | 2021-08-09 | McDowell | West Virginia | 54047 | 1711 | 27 |
1598830 | 1598830 | 2021-08-08 | McDowell | West Virginia | 54047 | 1704 | 27 |
1595581 | 1595581 | 2021-08-07 | McDowell | West Virginia | 54047 | 1704 | 27 |
1592332 | 1592332 | 2021-08-06 | McDowell | West Virginia | 54047 | 1704 | 27 |
1589083 | 1589083 | 2021-08-05 | McDowell | West Virginia | 54047 | 1696 | 27 |
1585834 | 1585834 | 2021-08-04 | McDowell | West Virginia | 54047 | 1676 | 27 |
1582584 | 1582584 | 2021-08-03 | McDowell | West Virginia | 54047 | 1673 | 27 |
1579334 | 1579334 | 2021-08-02 | McDowell | West Virginia | 54047 | 1672 | 27 |
1576086 | 1576086 | 2021-08-01 | McDowell | West Virginia | 54047 | 1670 | 27 |
1572838 | 1572838 | 2021-07-31 | McDowell | West Virginia | 54047 | 1670 | 27 |
1569590 | 1569590 | 2021-07-30 | McDowell | West Virginia | 54047 | 1670 | 27 |
1566342 | 1566342 | 2021-07-29 | McDowell | West Virginia | 54047 | 1663 | 27 |
1563094 | 1563094 | 2021-07-28 | McDowell | West Virginia | 54047 | 1661 | 27 |
1559846 | 1559846 | 2021-07-27 | McDowell | West Virginia | 54047 | 1658 | 27 |
1556599 | 1556599 | 2021-07-26 | McDowell | West Virginia | 54047 | 1657 | 27 |
1553352 | 1553352 | 2021-07-25 | McDowell | West Virginia | 54047 | 1656 | 27 |
1550105 | 1550105 | 2021-07-24 | McDowell | West Virginia | 54047 | 1656 | 27 |
1546858 | 1546858 | 2021-07-23 | McDowell | West Virginia | 54047 | 1656 | 27 |
1543611 | 1543611 | 2021-07-22 | McDowell | West Virginia | 54047 | 1655 | 27 |
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);