ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where deaths = 6, fips = 53013 and state = "Washington" 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 |
---|---|---|---|---|---|---|---|
1793687 | 1793687 | 2021-10-07 | Columbia | Washington | 53013 | 333 | 6 |
1790438 | 1790438 | 2021-10-06 | Columbia | Washington | 53013 | 329 | 6 |
1787190 | 1787190 | 2021-10-05 | Columbia | Washington | 53013 | 322 | 6 |
1783941 | 1783941 | 2021-10-04 | Columbia | Washington | 53013 | 321 | 6 |
1780692 | 1780692 | 2021-10-03 | Columbia | Washington | 53013 | 315 | 6 |
1777442 | 1777442 | 2021-10-02 | Columbia | Washington | 53013 | 315 | 6 |
1774192 | 1774192 | 2021-10-01 | Columbia | Washington | 53013 | 315 | 6 |
1770942 | 1770942 | 2021-09-30 | Columbia | Washington | 53013 | 315 | 6 |
1767693 | 1767693 | 2021-09-29 | Columbia | Washington | 53013 | 310 | 6 |
1764444 | 1764444 | 2021-09-28 | Columbia | Washington | 53013 | 308 | 6 |
1761195 | 1761195 | 2021-09-27 | Columbia | Washington | 53013 | 303 | 6 |
1757947 | 1757947 | 2021-09-26 | Columbia | Washington | 53013 | 299 | 6 |
1754699 | 1754699 | 2021-09-25 | Columbia | Washington | 53013 | 299 | 6 |
1751451 | 1751451 | 2021-09-24 | Columbia | Washington | 53013 | 299 | 6 |
1748202 | 1748202 | 2021-09-23 | Columbia | Washington | 53013 | 297 | 6 |
1744952 | 1744952 | 2021-09-22 | Columbia | Washington | 53013 | 296 | 6 |
1741703 | 1741703 | 2021-09-21 | Columbia | Washington | 53013 | 294 | 6 |
1738454 | 1738454 | 2021-09-20 | Columbia | Washington | 53013 | 288 | 6 |
1735205 | 1735205 | 2021-09-19 | Columbia | Washington | 53013 | 284 | 6 |
1731955 | 1731955 | 2021-09-18 | Columbia | Washington | 53013 | 284 | 6 |
1728705 | 1728705 | 2021-09-17 | Columbia | Washington | 53013 | 284 | 6 |
1725455 | 1725455 | 2021-09-16 | Columbia | Washington | 53013 | 284 | 6 |
1722206 | 1722206 | 2021-09-15 | Columbia | Washington | 53013 | 282 | 6 |
1718958 | 1718958 | 2021-09-14 | Columbia | Washington | 53013 | 280 | 6 |
1715710 | 1715710 | 2021-09-13 | Columbia | Washington | 53013 | 278 | 6 |
1712464 | 1712464 | 2021-09-12 | Columbia | Washington | 53013 | 277 | 6 |
1709217 | 1709217 | 2021-09-11 | Columbia | Washington | 53013 | 277 | 6 |
1705970 | 1705970 | 2021-09-10 | Columbia | Washington | 53013 | 277 | 6 |
1702720 | 1702720 | 2021-09-09 | Columbia | Washington | 53013 | 274 | 6 |
1699471 | 1699471 | 2021-09-08 | Columbia | Washington | 53013 | 268 | 6 |
1696223 | 1696223 | 2021-09-07 | Columbia | Washington | 53013 | 264 | 6 |
1692975 | 1692975 | 2021-09-06 | Columbia | Washington | 53013 | 259 | 6 |
1689726 | 1689726 | 2021-09-05 | Columbia | Washington | 53013 | 259 | 6 |
1686476 | 1686476 | 2021-09-04 | Columbia | Washington | 53013 | 259 | 6 |
1683225 | 1683225 | 2021-09-03 | Columbia | Washington | 53013 | 259 | 6 |
1679975 | 1679975 | 2021-09-02 | Columbia | Washington | 53013 | 257 | 6 |
1676727 | 1676727 | 2021-09-01 | Columbia | Washington | 53013 | 243 | 6 |
1673480 | 1673480 | 2021-08-31 | Columbia | Washington | 53013 | 239 | 6 |
1670232 | 1670232 | 2021-08-30 | Columbia | Washington | 53013 | 236 | 6 |
1666985 | 1666985 | 2021-08-29 | Columbia | Washington | 53013 | 229 | 6 |
1663737 | 1663737 | 2021-08-28 | Columbia | Washington | 53013 | 229 | 6 |
1660489 | 1660489 | 2021-08-27 | Columbia | Washington | 53013 | 229 | 6 |
1657241 | 1657241 | 2021-08-26 | Columbia | Washington | 53013 | 214 | 6 |
1653993 | 1653993 | 2021-08-25 | Columbia | Washington | 53013 | 211 | 6 |
1650747 | 1650747 | 2021-08-24 | Columbia | Washington | 53013 | 210 | 6 |
1647498 | 1647498 | 2021-08-23 | Columbia | Washington | 53013 | 208 | 6 |
1644249 | 1644249 | 2021-08-22 | Columbia | Washington | 53013 | 203 | 6 |
1640999 | 1640999 | 2021-08-21 | Columbia | Washington | 53013 | 203 | 6 |
1637749 | 1637749 | 2021-08-20 | Columbia | Washington | 53013 | 203 | 6 |
1634499 | 1634499 | 2021-08-19 | Columbia | Washington | 53013 | 197 | 6 |
1631251 | 1631251 | 2021-08-18 | Columbia | Washington | 53013 | 192 | 6 |
1628004 | 1628004 | 2021-08-17 | Columbia | Washington | 53013 | 188 | 6 |
1624757 | 1624757 | 2021-08-16 | Columbia | Washington | 53013 | 186 | 6 |
1621510 | 1621510 | 2021-08-15 | Columbia | Washington | 53013 | 183 | 6 |
1618262 | 1618262 | 2021-08-14 | Columbia | Washington | 53013 | 183 | 6 |
1615014 | 1615014 | 2021-08-13 | Columbia | Washington | 53013 | 183 | 6 |
1611765 | 1611765 | 2021-08-12 | Columbia | Washington | 53013 | 182 | 6 |
1608518 | 1608518 | 2021-08-11 | Columbia | Washington | 53013 | 180 | 6 |
1605269 | 1605269 | 2021-08-10 | Columbia | Washington | 53013 | 178 | 6 |
1602019 | 1602019 | 2021-08-09 | Columbia | Washington | 53013 | 178 | 6 |
1598771 | 1598771 | 2021-08-08 | Columbia | Washington | 53013 | 168 | 6 |
1595522 | 1595522 | 2021-08-07 | Columbia | Washington | 53013 | 168 | 6 |
1592273 | 1592273 | 2021-08-06 | Columbia | Washington | 53013 | 168 | 6 |
1589024 | 1589024 | 2021-08-05 | Columbia | Washington | 53013 | 165 | 6 |
1585775 | 1585775 | 2021-08-04 | Columbia | Washington | 53013 | 165 | 6 |
1582525 | 1582525 | 2021-08-03 | Columbia | Washington | 53013 | 161 | 6 |
1579275 | 1579275 | 2021-08-02 | Columbia | Washington | 53013 | 156 | 6 |
1576027 | 1576027 | 2021-08-01 | Columbia | Washington | 53013 | 153 | 6 |
1572779 | 1572779 | 2021-07-31 | Columbia | Washington | 53013 | 153 | 6 |
1569531 | 1569531 | 2021-07-30 | Columbia | Washington | 53013 | 153 | 6 |
1566283 | 1566283 | 2021-07-29 | Columbia | Washington | 53013 | 149 | 6 |
1563035 | 1563035 | 2021-07-28 | Columbia | Washington | 53013 | 145 | 6 |
1559787 | 1559787 | 2021-07-27 | Columbia | Washington | 53013 | 144 | 6 |
1556540 | 1556540 | 2021-07-26 | Columbia | Washington | 53013 | 141 | 6 |
1553293 | 1553293 | 2021-07-25 | Columbia | Washington | 53013 | 141 | 6 |
1550046 | 1550046 | 2021-07-24 | Columbia | Washington | 53013 | 141 | 6 |
1546799 | 1546799 | 2021-07-23 | Columbia | Washington | 53013 | 141 | 6 |
1543552 | 1543552 | 2021-07-22 | Columbia | Washington | 53013 | 143 | 6 |
1540304 | 1540304 | 2021-07-21 | Columbia | Washington | 53013 | 140 | 6 |
1537057 | 1537057 | 2021-07-20 | Columbia | Washington | 53013 | 140 | 6 |
1533809 | 1533809 | 2021-07-19 | Columbia | Washington | 53013 | 139 | 6 |
1530562 | 1530562 | 2021-07-18 | Columbia | Washington | 53013 | 137 | 6 |
1527315 | 1527315 | 2021-07-17 | Columbia | Washington | 53013 | 137 | 6 |
1524068 | 1524068 | 2021-07-16 | Columbia | Washington | 53013 | 137 | 6 |
1520820 | 1520820 | 2021-07-15 | Columbia | Washington | 53013 | 137 | 6 |
1517572 | 1517572 | 2021-07-14 | Columbia | Washington | 53013 | 134 | 6 |
1514325 | 1514325 | 2021-07-13 | Columbia | Washington | 53013 | 134 | 6 |
1511079 | 1511079 | 2021-07-12 | Columbia | Washington | 53013 | 132 | 6 |
1507832 | 1507832 | 2021-07-11 | Columbia | Washington | 53013 | 132 | 6 |
1504586 | 1504586 | 2021-07-10 | Columbia | Washington | 53013 | 132 | 6 |
1501340 | 1501340 | 2021-07-09 | Columbia | Washington | 53013 | 132 | 6 |
1498094 | 1498094 | 2021-07-08 | Columbia | Washington | 53013 | 132 | 6 |
1494847 | 1494847 | 2021-07-07 | Columbia | Washington | 53013 | 133 | 6 |
1491600 | 1491600 | 2021-07-06 | Columbia | Washington | 53013 | 133 | 6 |
1488353 | 1488353 | 2021-07-05 | Columbia | Washington | 53013 | 133 | 6 |
1485106 | 1485106 | 2021-07-04 | Columbia | Washington | 53013 | 133 | 6 |
1481860 | 1481860 | 2021-07-03 | Columbia | Washington | 53013 | 133 | 6 |
1478613 | 1478613 | 2021-07-02 | Columbia | Washington | 53013 | 133 | 6 |
1475367 | 1475367 | 2021-07-01 | Columbia | Washington | 53013 | 133 | 6 |
1472121 | 1472121 | 2021-06-30 | Columbia | Washington | 53013 | 133 | 6 |
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);