ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 53015 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949665 | 1949665 | 2021-11-24 | Cowlitz | Washington | 53015 | 14229 | 256 |
1946414 | 1946414 | 2021-11-23 | Cowlitz | Washington | 53015 | 14202 | 254 |
1943163 | 1943163 | 2021-11-22 | Cowlitz | Washington | 53015 | 14172 | 253 |
1939913 | 1939913 | 2021-11-21 | Cowlitz | Washington | 53015 | 14119 | 254 |
1936663 | 1936663 | 2021-11-20 | Cowlitz | Washington | 53015 | 14119 | 254 |
1933413 | 1933413 | 2021-11-19 | Cowlitz | Washington | 53015 | 14119 | 254 |
1930161 | 1930161 | 2021-11-18 | Cowlitz | Washington | 53015 | 14085 | 254 |
1926911 | 1926911 | 2021-11-17 | Cowlitz | Washington | 53015 | 14068 | 254 |
1923661 | 1923661 | 2021-11-16 | Cowlitz | Washington | 53015 | 14032 | 254 |
1920412 | 1920412 | 2021-11-15 | Cowlitz | Washington | 53015 | 14010 | 253 |
1917162 | 1917162 | 2021-11-14 | Cowlitz | Washington | 53015 | 13939 | 253 |
1913912 | 1913912 | 2021-11-13 | Cowlitz | Washington | 53015 | 13939 | 253 |
1910662 | 1910662 | 2021-11-12 | Cowlitz | Washington | 53015 | 13939 | 253 |
1907413 | 1907413 | 2021-11-11 | Cowlitz | Washington | 53015 | 13910 | 249 |
1904164 | 1904164 | 2021-11-10 | Cowlitz | Washington | 53015 | 13910 | 249 |
1900914 | 1900914 | 2021-11-09 | Cowlitz | Washington | 53015 | 13883 | 249 |
1897664 | 1897664 | 2021-11-08 | Cowlitz | Washington | 53015 | 13835 | 248 |
1894414 | 1894414 | 2021-11-07 | Cowlitz | Washington | 53015 | 13748 | 248 |
1891164 | 1891164 | 2021-11-06 | Cowlitz | Washington | 53015 | 13748 | 248 |
1887914 | 1887914 | 2021-11-05 | Cowlitz | Washington | 53015 | 13748 | 248 |
1884664 | 1884664 | 2021-11-04 | Cowlitz | Washington | 53015 | 13712 | 247 |
1881415 | 1881415 | 2021-11-03 | Cowlitz | Washington | 53015 | 13673 | 247 |
1878166 | 1878166 | 2021-11-02 | Cowlitz | Washington | 53015 | 13631 | 247 |
1874917 | 1874917 | 2021-11-01 | Cowlitz | Washington | 53015 | 13589 | 243 |
1871668 | 1871668 | 2021-10-31 | Cowlitz | Washington | 53015 | 13514 | 241 |
1868419 | 1868419 | 2021-10-30 | Cowlitz | Washington | 53015 | 13514 | 241 |
1865170 | 1865170 | 2021-10-29 | Cowlitz | Washington | 53015 | 13514 | 241 |
1861921 | 1861921 | 2021-10-28 | Cowlitz | Washington | 53015 | 13466 | 239 |
1858672 | 1858672 | 2021-10-27 | Cowlitz | Washington | 53015 | 13420 | 238 |
1855423 | 1855423 | 2021-10-26 | Cowlitz | Washington | 53015 | 13389 | 235 |
1852174 | 1852174 | 2021-10-25 | Cowlitz | Washington | 53015 | 13334 | 233 |
1848924 | 1848924 | 2021-10-24 | Cowlitz | Washington | 53015 | 13234 | 231 |
1845674 | 1845674 | 2021-10-23 | Cowlitz | Washington | 53015 | 13234 | 231 |
1842424 | 1842424 | 2021-10-22 | Cowlitz | Washington | 53015 | 13234 | 231 |
1839175 | 1839175 | 2021-10-21 | Cowlitz | Washington | 53015 | 13164 | 229 |
1835926 | 1835926 | 2021-10-20 | Cowlitz | Washington | 53015 | 13125 | 228 |
1832677 | 1832677 | 2021-10-19 | Cowlitz | Washington | 53015 | 13088 | 226 |
1829428 | 1829428 | 2021-10-18 | Cowlitz | Washington | 53015 | 12921 | 222 |
1826179 | 1826179 | 2021-10-17 | Cowlitz | Washington | 53015 | 12921 | 222 |
1822930 | 1822930 | 2021-10-16 | Cowlitz | Washington | 53015 | 12921 | 222 |
1819681 | 1819681 | 2021-10-15 | Cowlitz | Washington | 53015 | 12921 | 222 |
1816432 | 1816432 | 2021-10-14 | Cowlitz | Washington | 53015 | 12865 | 220 |
1813184 | 1813184 | 2021-10-13 | Cowlitz | Washington | 53015 | 12814 | 219 |
1809935 | 1809935 | 2021-10-12 | Cowlitz | Washington | 53015 | 12761 | 214 |
1806686 | 1806686 | 2021-10-11 | Cowlitz | Washington | 53015 | 12696 | 214 |
1803435 | 1803435 | 2021-10-10 | Cowlitz | Washington | 53015 | 12596 | 211 |
1800186 | 1800186 | 2021-10-09 | Cowlitz | Washington | 53015 | 12596 | 211 |
1796937 | 1796937 | 2021-10-08 | Cowlitz | Washington | 53015 | 12596 | 211 |
1793688 | 1793688 | 2021-10-07 | Cowlitz | Washington | 53015 | 12542 | 210 |
1790439 | 1790439 | 2021-10-06 | Cowlitz | Washington | 53015 | 12484 | 205 |
1787191 | 1787191 | 2021-10-05 | Cowlitz | Washington | 53015 | 12431 | 202 |
1783942 | 1783942 | 2021-10-04 | Cowlitz | Washington | 53015 | 12369 | 198 |
1780693 | 1780693 | 2021-10-03 | Cowlitz | Washington | 53015 | 12221 | 192 |
1777443 | 1777443 | 2021-10-02 | Cowlitz | Washington | 53015 | 12221 | 192 |
1774193 | 1774193 | 2021-10-01 | Cowlitz | Washington | 53015 | 12221 | 192 |
1770943 | 1770943 | 2021-09-30 | Cowlitz | Washington | 53015 | 12100 | 193 |
1767694 | 1767694 | 2021-09-29 | Cowlitz | Washington | 53015 | 12045 | 192 |
1764445 | 1764445 | 2021-09-28 | Cowlitz | Washington | 53015 | 11989 | 190 |
1761196 | 1761196 | 2021-09-27 | Cowlitz | Washington | 53015 | 11888 | 189 |
1757948 | 1757948 | 2021-09-26 | Cowlitz | Washington | 53015 | 11690 | 187 |
1754700 | 1754700 | 2021-09-25 | Cowlitz | Washington | 53015 | 11690 | 187 |
1751452 | 1751452 | 2021-09-24 | Cowlitz | Washington | 53015 | 11690 | 187 |
1748203 | 1748203 | 2021-09-23 | Cowlitz | Washington | 53015 | 11560 | 183 |
1744953 | 1744953 | 2021-09-22 | Cowlitz | Washington | 53015 | 11461 | 180 |
1741704 | 1741704 | 2021-09-21 | Cowlitz | Washington | 53015 | 11373 | 179 |
1738455 | 1738455 | 2021-09-20 | Cowlitz | Washington | 53015 | 11317 | 176 |
1735206 | 1735206 | 2021-09-19 | Cowlitz | Washington | 53015 | 11135 | 169 |
1731956 | 1731956 | 2021-09-18 | Cowlitz | Washington | 53015 | 11135 | 169 |
1728706 | 1728706 | 2021-09-17 | Cowlitz | Washington | 53015 | 11135 | 169 |
1725456 | 1725456 | 2021-09-16 | Cowlitz | Washington | 53015 | 11060 | 167 |
1722207 | 1722207 | 2021-09-15 | Cowlitz | Washington | 53015 | 10967 | 163 |
1718959 | 1718959 | 2021-09-14 | Cowlitz | Washington | 53015 | 10864 | 160 |
1715711 | 1715711 | 2021-09-13 | Cowlitz | Washington | 53015 | 10731 | 158 |
1712465 | 1712465 | 2021-09-12 | Cowlitz | Washington | 53015 | 10535 | 153 |
1709218 | 1709218 | 2021-09-11 | Cowlitz | Washington | 53015 | 10535 | 153 |
1705971 | 1705971 | 2021-09-10 | Cowlitz | Washington | 53015 | 10535 | 153 |
1702721 | 1702721 | 2021-09-09 | Cowlitz | Washington | 53015 | 10472 | 148 |
1699472 | 1699472 | 2021-09-08 | Cowlitz | Washington | 53015 | 10353 | 138 |
1696224 | 1696224 | 2021-09-07 | Cowlitz | Washington | 53015 | 10231 | 137 |
1692976 | 1692976 | 2021-09-06 | Cowlitz | Washington | 53015 | 9989 | 131 |
1689727 | 1689727 | 2021-09-05 | Cowlitz | Washington | 53015 | 9989 | 131 |
1686477 | 1686477 | 2021-09-04 | Cowlitz | Washington | 53015 | 9989 | 131 |
1683226 | 1683226 | 2021-09-03 | Cowlitz | Washington | 53015 | 9989 | 131 |
1679976 | 1679976 | 2021-09-02 | Cowlitz | Washington | 53015 | 9863 | 127 |
1676728 | 1676728 | 2021-09-01 | Cowlitz | Washington | 53015 | 9767 | 126 |
1673481 | 1673481 | 2021-08-31 | Cowlitz | Washington | 53015 | 9653 | 123 |
1670233 | 1670233 | 2021-08-30 | Cowlitz | Washington | 53015 | 9527 | 122 |
1666986 | 1666986 | 2021-08-29 | Cowlitz | Washington | 53015 | 9326 | 119 |
1663738 | 1663738 | 2021-08-28 | Cowlitz | Washington | 53015 | 9326 | 119 |
1660490 | 1660490 | 2021-08-27 | Cowlitz | Washington | 53015 | 9326 | 119 |
1657242 | 1657242 | 2021-08-26 | Cowlitz | Washington | 53015 | 9202 | 119 |
1653994 | 1653994 | 2021-08-25 | Cowlitz | Washington | 53015 | 9141 | 117 |
1650748 | 1650748 | 2021-08-24 | Cowlitz | Washington | 53015 | 9068 | 113 |
1647499 | 1647499 | 2021-08-23 | Cowlitz | Washington | 53015 | 8933 | 111 |
1644250 | 1644250 | 2021-08-22 | Cowlitz | Washington | 53015 | 8701 | 110 |
1641000 | 1641000 | 2021-08-21 | Cowlitz | Washington | 53015 | 8701 | 110 |
1637750 | 1637750 | 2021-08-20 | Cowlitz | Washington | 53015 | 8701 | 110 |
1634500 | 1634500 | 2021-08-19 | Cowlitz | Washington | 53015 | 8592 | 108 |
1631252 | 1631252 | 2021-08-18 | Cowlitz | Washington | 53015 | 8451 | 107 |
1628005 | 1628005 | 2021-08-17 | Cowlitz | Washington | 53015 | 8392 | 107 |
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);