ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
370 rows where deaths = 22 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 |
---|---|---|---|---|---|---|---|
2196784 | 2196784 | 2022-02-08 | Ferry | Washington | 53019 | 1274 | 22 |
2193529 | 2193529 | 2022-02-07 | Ferry | Washington | 53019 | 1274 | 22 |
2167515 | 2167515 | 2022-01-30 | Jefferson | Washington | 53031 | 2452 | 22 |
2164260 | 2164260 | 2022-01-29 | Jefferson | Washington | 53031 | 2452 | 22 |
2161005 | 2161005 | 2022-01-28 | Jefferson | Washington | 53031 | 2452 | 22 |
2157749 | 2157749 | 2022-01-27 | Jefferson | Washington | 53031 | 2385 | 22 |
2154496 | 2154496 | 2022-01-26 | Jefferson | Washington | 53031 | 2385 | 22 |
2151243 | 2151243 | 2022-01-25 | Jefferson | Washington | 53031 | 2291 | 22 |
2147991 | 2147991 | 2022-01-24 | Jefferson | Washington | 53031 | 2291 | 22 |
2144739 | 2144739 | 2022-01-23 | Jefferson | Washington | 53031 | 2191 | 22 |
2141484 | 2141484 | 2022-01-22 | Jefferson | Washington | 53031 | 2191 | 22 |
2138228 | 2138228 | 2022-01-21 | Jefferson | Washington | 53031 | 2191 | 22 |
2134973 | 2134973 | 2022-01-20 | Jefferson | Washington | 53031 | 2128 | 22 |
2131721 | 2131721 | 2022-01-19 | Jefferson | Washington | 53031 | 2080 | 22 |
2128467 | 2128467 | 2022-01-18 | Jefferson | Washington | 53031 | 2046 | 22 |
2125214 | 2125214 | 2022-01-17 | Jefferson | Washington | 53031 | 1949 | 22 |
2121962 | 2121962 | 2022-01-16 | Jefferson | Washington | 53031 | 1949 | 22 |
2118710 | 2118710 | 2022-01-15 | Jefferson | Washington | 53031 | 1949 | 22 |
2115458 | 2115458 | 2022-01-14 | Jefferson | Washington | 53031 | 1949 | 22 |
1907427 | 1907427 | 2021-11-11 | Lincoln | Washington | 53043 | 1435 | 22 |
1904178 | 1904178 | 2021-11-10 | Lincoln | Washington | 53043 | 1435 | 22 |
1900928 | 1900928 | 2021-11-09 | Lincoln | Washington | 53043 | 1429 | 22 |
1897678 | 1897678 | 2021-11-08 | Lincoln | Washington | 53043 | 1418 | 22 |
1897682 | 1897682 | 2021-11-08 | Pend Oreille | Washington | 53051 | 1586 | 22 |
1894428 | 1894428 | 2021-11-07 | Lincoln | Washington | 53043 | 1412 | 22 |
1894432 | 1894432 | 2021-11-07 | Pend Oreille | Washington | 53051 | 1571 | 22 |
1891178 | 1891178 | 2021-11-06 | Lincoln | Washington | 53043 | 1412 | 22 |
1891182 | 1891182 | 2021-11-06 | Pend Oreille | Washington | 53051 | 1571 | 22 |
1887928 | 1887928 | 2021-11-05 | Lincoln | Washington | 53043 | 1412 | 22 |
1887932 | 1887932 | 2021-11-05 | Pend Oreille | Washington | 53051 | 1571 | 22 |
1884676 | 1884676 | 2021-11-04 | Klickitat | Washington | 53039 | 2092 | 22 |
1884678 | 1884678 | 2021-11-04 | Lincoln | Washington | 53043 | 1407 | 22 |
1884682 | 1884682 | 2021-11-04 | Pend Oreille | Washington | 53051 | 1567 | 22 |
1881427 | 1881427 | 2021-11-03 | Klickitat | Washington | 53039 | 2079 | 22 |
1881429 | 1881429 | 2021-11-03 | Lincoln | Washington | 53043 | 1406 | 22 |
1881433 | 1881433 | 2021-11-03 | Pend Oreille | Washington | 53051 | 1558 | 22 |
1878180 | 1878180 | 2021-11-02 | Lincoln | Washington | 53043 | 1407 | 22 |
1878184 | 1878184 | 2021-11-02 | Pend Oreille | Washington | 53051 | 1555 | 22 |
1874931 | 1874931 | 2021-11-01 | Lincoln | Washington | 53043 | 1402 | 22 |
1874935 | 1874935 | 2021-11-01 | Pend Oreille | Washington | 53051 | 1550 | 22 |
1871682 | 1871682 | 2021-10-31 | Lincoln | Washington | 53043 | 1390 | 22 |
1871686 | 1871686 | 2021-10-31 | Pend Oreille | Washington | 53051 | 1539 | 22 |
1868433 | 1868433 | 2021-10-30 | Lincoln | Washington | 53043 | 1390 | 22 |
1868437 | 1868437 | 2021-10-30 | Pend Oreille | Washington | 53051 | 1539 | 22 |
1865184 | 1865184 | 2021-10-29 | Lincoln | Washington | 53043 | 1390 | 22 |
1865188 | 1865188 | 2021-10-29 | Pend Oreille | Washington | 53051 | 1539 | 22 |
1861935 | 1861935 | 2021-10-28 | Lincoln | Washington | 53043 | 1385 | 22 |
1861939 | 1861939 | 2021-10-28 | Pend Oreille | Washington | 53051 | 1531 | 22 |
1858686 | 1858686 | 2021-10-27 | Lincoln | Washington | 53043 | 1370 | 22 |
1858690 | 1858690 | 2021-10-27 | Pend Oreille | Washington | 53051 | 1527 | 22 |
1855437 | 1855437 | 2021-10-26 | Lincoln | Washington | 53043 | 1362 | 22 |
1855441 | 1855441 | 2021-10-26 | Pend Oreille | Washington | 53051 | 1523 | 22 |
1852188 | 1852188 | 2021-10-25 | Lincoln | Washington | 53043 | 1355 | 22 |
1852192 | 1852192 | 2021-10-25 | Pend Oreille | Washington | 53051 | 1521 | 22 |
1848942 | 1848942 | 2021-10-24 | Pend Oreille | Washington | 53051 | 1507 | 22 |
1845692 | 1845692 | 2021-10-23 | Pend Oreille | Washington | 53051 | 1507 | 22 |
1842442 | 1842442 | 2021-10-22 | Pend Oreille | Washington | 53051 | 1507 | 22 |
1839193 | 1839193 | 2021-10-21 | Pend Oreille | Washington | 53051 | 1504 | 22 |
1835944 | 1835944 | 2021-10-20 | Pend Oreille | Washington | 53051 | 1491 | 22 |
1832695 | 1832695 | 2021-10-19 | Pend Oreille | Washington | 53051 | 1486 | 22 |
1735223 | 1735223 | 2021-09-19 | Pacific | Washington | 53049 | 1561 | 22 |
1731973 | 1731973 | 2021-09-18 | Pacific | Washington | 53049 | 1561 | 22 |
1728723 | 1728723 | 2021-09-17 | Pacific | Washington | 53049 | 1561 | 22 |
1361775 | 1361775 | 2021-05-27 | Douglas | Washington | 53017 | 3688 | 22 |
1358529 | 1358529 | 2021-05-26 | Douglas | Washington | 53017 | 3684 | 22 |
1355283 | 1355283 | 2021-05-25 | Douglas | Washington | 53017 | 3682 | 22 |
1352037 | 1352037 | 2021-05-24 | Douglas | Washington | 53017 | 3682 | 22 |
1348791 | 1348791 | 2021-05-23 | Douglas | Washington | 53017 | 3678 | 22 |
1345543 | 1345543 | 2021-05-22 | Douglas | Washington | 53017 | 3675 | 22 |
1342295 | 1342295 | 2021-05-21 | Douglas | Washington | 53017 | 3675 | 22 |
1339047 | 1339047 | 2021-05-20 | Douglas | Washington | 53017 | 3675 | 22 |
1335800 | 1335800 | 2021-05-19 | Douglas | Washington | 53017 | 3675 | 22 |
1332553 | 1332553 | 2021-05-18 | Douglas | Washington | 53017 | 3672 | 22 |
1329306 | 1329306 | 2021-05-17 | Douglas | Washington | 53017 | 3672 | 22 |
1326060 | 1326060 | 2021-05-16 | Douglas | Washington | 53017 | 3665 | 22 |
1322814 | 1322814 | 2021-05-15 | Douglas | Washington | 53017 | 3665 | 22 |
1319568 | 1319568 | 2021-05-14 | Douglas | Washington | 53017 | 3665 | 22 |
1316312 | 1316312 | 2021-05-13 | Adams | Washington | 53001 | 2132 | 22 |
1316320 | 1316320 | 2021-05-13 | Douglas | Washington | 53017 | 3659 | 22 |
1313066 | 1313066 | 2021-05-12 | Adams | Washington | 53001 | 2129 | 22 |
1313074 | 1313074 | 2021-05-12 | Douglas | Washington | 53017 | 3658 | 22 |
1309819 | 1309819 | 2021-05-11 | Adams | Washington | 53001 | 2127 | 22 |
1309827 | 1309827 | 2021-05-11 | Douglas | Washington | 53017 | 3658 | 22 |
1306573 | 1306573 | 2021-05-10 | Adams | Washington | 53001 | 2123 | 22 |
1306581 | 1306581 | 2021-05-10 | Douglas | Washington | 53017 | 3655 | 22 |
1303327 | 1303327 | 2021-05-09 | Adams | Washington | 53001 | 2123 | 22 |
1303335 | 1303335 | 2021-05-09 | Douglas | Washington | 53017 | 3645 | 22 |
1300080 | 1300080 | 2021-05-08 | Adams | Washington | 53001 | 2123 | 22 |
1300088 | 1300088 | 2021-05-08 | Douglas | Washington | 53017 | 3645 | 22 |
1296833 | 1296833 | 2021-05-07 | Adams | Washington | 53001 | 2120 | 22 |
1296841 | 1296841 | 2021-05-07 | Douglas | Washington | 53017 | 3645 | 22 |
1293587 | 1293587 | 2021-05-06 | Adams | Washington | 53001 | 2115 | 22 |
1293595 | 1293595 | 2021-05-06 | Douglas | Washington | 53017 | 3635 | 22 |
1290341 | 1290341 | 2021-05-05 | Adams | Washington | 53001 | 2105 | 22 |
1287095 | 1287095 | 2021-05-04 | Adams | Washington | 53001 | 2104 | 22 |
1283849 | 1283849 | 2021-05-03 | Adams | Washington | 53001 | 2102 | 22 |
1280602 | 1280602 | 2021-05-02 | Adams | Washington | 53001 | 2092 | 22 |
1277355 | 1277355 | 2021-05-01 | Adams | Washington | 53001 | 2092 | 22 |
1274108 | 1274108 | 2021-04-30 | Adams | Washington | 53001 | 2090 | 22 |
1270861 | 1270861 | 2021-04-29 | Adams | Washington | 53001 | 2086 | 22 |
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);