ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Washington" and fips = 37187 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176195 | 2176195 | 2022-02-02 | Washington | North Carolina | 37187 | 2810 | 42 |
2172942 | 2172942 | 2022-02-01 | Washington | North Carolina | 37187 | 2798 | 42 |
2169689 | 2169689 | 2022-01-31 | Washington | North Carolina | 37187 | 2782 | 42 |
2166434 | 2166434 | 2022-01-30 | Washington | North Carolina | 37187 | 2743 | 41 |
2163179 | 2163179 | 2022-01-29 | Washington | North Carolina | 37187 | 2743 | 41 |
2159924 | 2159924 | 2022-01-28 | Washington | North Carolina | 37187 | 2743 | 41 |
2156669 | 2156669 | 2022-01-27 | Washington | North Carolina | 37187 | 2710 | 41 |
2153416 | 2153416 | 2022-01-26 | Washington | North Carolina | 37187 | 2673 | 41 |
2150164 | 2150164 | 2022-01-25 | Washington | North Carolina | 37187 | 2654 | 41 |
2146912 | 2146912 | 2022-01-24 | Washington | North Carolina | 37187 | 2651 | 41 |
2143658 | 2143658 | 2022-01-23 | Washington | North Carolina | 37187 | 2540 | 41 |
2140403 | 2140403 | 2022-01-22 | Washington | North Carolina | 37187 | 2540 | 41 |
2137147 | 2137147 | 2022-01-21 | Washington | North Carolina | 37187 | 2540 | 41 |
2133894 | 2133894 | 2022-01-20 | Washington | North Carolina | 37187 | 2476 | 41 |
2130642 | 2130642 | 2022-01-19 | Washington | North Carolina | 37187 | 2439 | 40 |
2127388 | 2127388 | 2022-01-18 | Washington | North Carolina | 37187 | 2412 | 40 |
2124136 | 2124136 | 2022-01-17 | Washington | North Carolina | 37187 | 2243 | 40 |
2120884 | 2120884 | 2022-01-16 | Washington | North Carolina | 37187 | 2243 | 40 |
2117632 | 2117632 | 2022-01-15 | Washington | North Carolina | 37187 | 2243 | 40 |
2114381 | 2114381 | 2022-01-14 | Washington | North Carolina | 37187 | 2243 | 40 |
2111129 | 2111129 | 2022-01-13 | Washington | North Carolina | 37187 | 2201 | 40 |
2107877 | 2107877 | 2022-01-12 | Washington | North Carolina | 37187 | 2132 | 39 |
2104626 | 2104626 | 2022-01-11 | Washington | North Carolina | 37187 | 2095 | 39 |
2101375 | 2101375 | 2022-01-10 | Washington | North Carolina | 37187 | 2062 | 39 |
2098124 | 2098124 | 2022-01-09 | Washington | North Carolina | 37187 | 1953 | 39 |
2094872 | 2094872 | 2022-01-08 | Washington | North Carolina | 37187 | 1953 | 39 |
2091620 | 2091620 | 2022-01-07 | Washington | North Carolina | 37187 | 1953 | 39 |
2088369 | 2088369 | 2022-01-06 | Washington | North Carolina | 37187 | 1919 | 39 |
2085117 | 2085117 | 2022-01-05 | Washington | North Carolina | 37187 | 1840 | 39 |
2081865 | 2081865 | 2022-01-04 | Washington | North Carolina | 37187 | 1809 | 39 |
2078613 | 2078613 | 2022-01-03 | Washington | North Carolina | 37187 | 1800 | 39 |
2075362 | 2075362 | 2022-01-02 | Washington | North Carolina | 37187 | 1748 | 39 |
2072111 | 2072111 | 2022-01-01 | Washington | North Carolina | 37187 | 1748 | 39 |
2068860 | 2068860 | 2021-12-31 | Washington | North Carolina | 37187 | 1748 | 39 |
2065609 | 2065609 | 2021-12-30 | Washington | North Carolina | 37187 | 1729 | 39 |
2062359 | 2062359 | 2021-12-29 | Washington | North Carolina | 37187 | 1723 | 39 |
2059110 | 2059110 | 2021-12-28 | Washington | North Carolina | 37187 | 1702 | 38 |
2055861 | 2055861 | 2021-12-27 | Washington | North Carolina | 37187 | 1684 | 38 |
2052611 | 2052611 | 2021-12-26 | Washington | North Carolina | 37187 | 1684 | 38 |
2049361 | 2049361 | 2021-12-25 | Washington | North Carolina | 37187 | 1684 | 38 |
2046111 | 2046111 | 2021-12-24 | Washington | North Carolina | 37187 | 1684 | 38 |
2042861 | 2042861 | 2021-12-23 | Washington | North Carolina | 37187 | 1684 | 38 |
2039612 | 2039612 | 2021-12-22 | Washington | North Carolina | 37187 | 1684 | 38 |
2036362 | 2036362 | 2021-12-21 | Washington | North Carolina | 37187 | 1682 | 38 |
2033112 | 2033112 | 2021-12-20 | Washington | North Carolina | 37187 | 1679 | 38 |
2029862 | 2029862 | 2021-12-19 | Washington | North Carolina | 37187 | 1677 | 37 |
2026611 | 2026611 | 2021-12-18 | Washington | North Carolina | 37187 | 1677 | 37 |
2023360 | 2023360 | 2021-12-17 | Washington | North Carolina | 37187 | 1677 | 37 |
2020109 | 2020109 | 2021-12-16 | Washington | North Carolina | 37187 | 1675 | 37 |
2016858 | 2016858 | 2021-12-15 | Washington | North Carolina | 37187 | 1675 | 37 |
2013608 | 2013608 | 2021-12-14 | Washington | North Carolina | 37187 | 1673 | 37 |
2010357 | 2010357 | 2021-12-13 | Washington | North Carolina | 37187 | 1673 | 37 |
2007106 | 2007106 | 2021-12-12 | Washington | North Carolina | 37187 | 1667 | 37 |
2003855 | 2003855 | 2021-12-11 | Washington | North Carolina | 37187 | 1667 | 37 |
2000604 | 2000604 | 2021-12-10 | Washington | North Carolina | 37187 | 1667 | 37 |
1997354 | 1997354 | 2021-12-09 | Washington | North Carolina | 37187 | 1666 | 37 |
1994103 | 1994103 | 2021-12-08 | Washington | North Carolina | 37187 | 1662 | 37 |
1990852 | 1990852 | 2021-12-07 | Washington | North Carolina | 37187 | 1658 | 37 |
1987601 | 1987601 | 2021-12-06 | Washington | North Carolina | 37187 | 1657 | 37 |
1984351 | 1984351 | 2021-12-05 | Washington | North Carolina | 37187 | 1651 | 37 |
1981101 | 1981101 | 2021-12-04 | Washington | North Carolina | 37187 | 1651 | 37 |
1977851 | 1977851 | 2021-12-03 | Washington | North Carolina | 37187 | 1651 | 37 |
1974601 | 1974601 | 2021-12-02 | Washington | North Carolina | 37187 | 1645 | 37 |
1971352 | 1971352 | 2021-12-01 | Washington | North Carolina | 37187 | 1642 | 37 |
1968102 | 1968102 | 2021-11-30 | Washington | North Carolina | 37187 | 1642 | 37 |
1964851 | 1964851 | 2021-11-29 | Washington | North Carolina | 37187 | 1641 | 37 |
1961599 | 1961599 | 2021-11-28 | Washington | North Carolina | 37187 | 1633 | 37 |
1958348 | 1958348 | 2021-11-27 | Washington | North Carolina | 37187 | 1633 | 37 |
1955097 | 1955097 | 2021-11-26 | Washington | North Carolina | 37187 | 1633 | 37 |
1951846 | 1951846 | 2021-11-25 | Washington | North Carolina | 37187 | 1633 | 37 |
1948595 | 1948595 | 2021-11-24 | Washington | North Carolina | 37187 | 1633 | 37 |
1945344 | 1945344 | 2021-11-23 | Washington | North Carolina | 37187 | 1630 | 37 |
1942093 | 1942093 | 2021-11-22 | Washington | North Carolina | 37187 | 1631 | 37 |
1938843 | 1938843 | 2021-11-21 | Washington | North Carolina | 37187 | 1629 | 37 |
1935593 | 1935593 | 2021-11-20 | Washington | North Carolina | 37187 | 1629 | 37 |
1932343 | 1932343 | 2021-11-19 | Washington | North Carolina | 37187 | 1629 | 37 |
1929092 | 1929092 | 2021-11-18 | Washington | North Carolina | 37187 | 1629 | 37 |
1925842 | 1925842 | 2021-11-17 | Washington | North Carolina | 37187 | 1627 | 37 |
1922593 | 1922593 | 2021-11-16 | Washington | North Carolina | 37187 | 1627 | 37 |
1919343 | 1919343 | 2021-11-15 | Washington | North Carolina | 37187 | 1624 | 37 |
1916093 | 1916093 | 2021-11-14 | Washington | North Carolina | 37187 | 1614 | 37 |
1912843 | 1912843 | 2021-11-13 | Washington | North Carolina | 37187 | 1614 | 37 |
1909593 | 1909593 | 2021-11-12 | Washington | North Carolina | 37187 | 1614 | 37 |
1906344 | 1906344 | 2021-11-11 | Washington | North Carolina | 37187 | 1612 | 37 |
1903095 | 1903095 | 2021-11-10 | Washington | North Carolina | 37187 | 1612 | 37 |
1899845 | 1899845 | 2021-11-09 | Washington | North Carolina | 37187 | 1610 | 37 |
1896595 | 1896595 | 2021-11-08 | Washington | North Carolina | 37187 | 1610 | 37 |
1893345 | 1893345 | 2021-11-07 | Washington | North Carolina | 37187 | 1606 | 37 |
1890095 | 1890095 | 2021-11-06 | Washington | North Carolina | 37187 | 1606 | 37 |
1886845 | 1886845 | 2021-11-05 | Washington | North Carolina | 37187 | 1606 | 37 |
1883596 | 1883596 | 2021-11-04 | Washington | North Carolina | 37187 | 1603 | 37 |
1880347 | 1880347 | 2021-11-03 | Washington | North Carolina | 37187 | 1599 | 37 |
1877098 | 1877098 | 2021-11-02 | Washington | North Carolina | 37187 | 1599 | 37 |
1873849 | 1873849 | 2021-11-01 | Washington | North Carolina | 37187 | 1597 | 37 |
1870600 | 1870600 | 2021-10-31 | Washington | North Carolina | 37187 | 1593 | 37 |
1867351 | 1867351 | 2021-10-30 | Washington | North Carolina | 37187 | 1593 | 37 |
1864102 | 1864102 | 2021-10-29 | Washington | North Carolina | 37187 | 1593 | 37 |
1860853 | 1860853 | 2021-10-28 | Washington | North Carolina | 37187 | 1587 | 37 |
1857604 | 1857604 | 2021-10-27 | Washington | North Carolina | 37187 | 1580 | 37 |
1854355 | 1854355 | 2021-10-26 | Washington | North Carolina | 37187 | 1578 | 37 |
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);