ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where deaths = 117 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2294351 | 2294351 | 2022-03-10 | Okanogan | Washington | 53047 | 8328 | 117 |
2291099 | 2291099 | 2022-03-09 | Okanogan | Washington | 53047 | 8328 | 117 |
2287847 | 2287847 | 2022-03-08 | Okanogan | Washington | 53047 | 8319 | 117 |
2284595 | 2284595 | 2022-03-07 | Okanogan | Washington | 53047 | 8319 | 117 |
2281343 | 2281343 | 2022-03-06 | Okanogan | Washington | 53047 | 8293 | 117 |
2278090 | 2278090 | 2022-03-05 | Okanogan | Washington | 53047 | 8293 | 117 |
2274837 | 2274837 | 2022-03-04 | Okanogan | Washington | 53047 | 8293 | 117 |
2242304 | 2242304 | 2022-02-22 | Clallam | Washington | 53009 | 11020 | 117 |
2239053 | 2239053 | 2022-02-21 | Clallam | Washington | 53009 | 11020 | 117 |
2235802 | 2235802 | 2022-02-20 | Clallam | Washington | 53009 | 11020 | 117 |
2232551 | 2232551 | 2022-02-19 | Clallam | Washington | 53009 | 11020 | 117 |
2229300 | 2229300 | 2022-02-18 | Clallam | Washington | 53009 | 11020 | 117 |
2180531 | 2180531 | 2022-02-03 | Mason | Washington | 53045 | 11035 | 117 |
2177280 | 2177280 | 2022-02-02 | Mason | Washington | 53045 | 11035 | 117 |
2144756 | 2144756 | 2022-01-23 | Stevens | Washington | 53065 | 6407 | 117 |
2141501 | 2141501 | 2022-01-22 | Stevens | Washington | 53065 | 6407 | 117 |
2138245 | 2138245 | 2022-01-21 | Stevens | Washington | 53065 | 6407 | 117 |
2134990 | 2134990 | 2022-01-20 | Stevens | Washington | 53065 | 6320 | 117 |
2131738 | 2131738 | 2022-01-19 | Stevens | Washington | 53065 | 6276 | 117 |
2128484 | 2128484 | 2022-01-18 | Stevens | Washington | 53065 | 6246 | 117 |
2125231 | 2125231 | 2022-01-17 | Stevens | Washington | 53065 | 6065 | 117 |
2121979 | 2121979 | 2022-01-16 | Stevens | Washington | 53065 | 6065 | 117 |
2118727 | 2118727 | 2022-01-15 | Stevens | Washington | 53065 | 6065 | 117 |
2115475 | 2115475 | 2022-01-14 | Stevens | Washington | 53065 | 6065 | 117 |
2112223 | 2112223 | 2022-01-13 | Stevens | Washington | 53065 | 5972 | 117 |
2108971 | 2108971 | 2022-01-12 | Stevens | Washington | 53065 | 5922 | 117 |
1962665 | 1962665 | 2021-11-28 | Chelan | Washington | 53007 | 12327 | 117 |
1959414 | 1959414 | 2021-11-27 | Chelan | Washington | 53007 | 12327 | 117 |
1956163 | 1956163 | 2021-11-26 | Chelan | Washington | 53007 | 12327 | 117 |
1952912 | 1952912 | 2021-11-25 | Chelan | Washington | 53007 | 12327 | 117 |
1949661 | 1949661 | 2021-11-24 | Chelan | Washington | 53007 | 12327 | 117 |
1946410 | 1946410 | 2021-11-23 | Chelan | Washington | 53007 | 12318 | 117 |
1917183 | 1917183 | 2021-11-14 | Skagit | Washington | 53057 | 12170 | 117 |
1913933 | 1913933 | 2021-11-13 | Skagit | Washington | 53057 | 12170 | 117 |
1910683 | 1910683 | 2021-11-12 | Skagit | Washington | 53057 | 12170 | 117 |
1809941 | 1809941 | 2021-10-12 | Grays Harbor | Washington | 53027 | 8110 | 117 |
1806692 | 1806692 | 2021-10-11 | Grays Harbor | Washington | 53027 | 8088 | 117 |
1653994 | 1653994 | 2021-08-25 | Cowlitz | Washington | 53015 | 9141 | 117 |
1530589 | 1530589 | 2021-07-18 | Thurston | Washington | 53067 | 11389 | 117 |
1527342 | 1527342 | 2021-07-17 | Thurston | Washington | 53067 | 11389 | 117 |
1524095 | 1524095 | 2021-07-16 | Thurston | Washington | 53067 | 11389 | 117 |
1488364 | 1488364 | 2021-07-05 | Kitsap | Washington | 53035 | 8854 | 117 |
1485117 | 1485117 | 2021-07-04 | Kitsap | Washington | 53035 | 8854 | 117 |
1481871 | 1481871 | 2021-07-03 | Kitsap | Washington | 53035 | 8854 | 117 |
1478624 | 1478624 | 2021-07-02 | Kitsap | Washington | 53035 | 8854 | 117 |
1475378 | 1475378 | 2021-07-01 | Kitsap | Washington | 53035 | 8846 | 117 |
1472132 | 1472132 | 2021-06-30 | Kitsap | Washington | 53035 | 8845 | 117 |
1468887 | 1468887 | 2021-06-29 | Kitsap | Washington | 53035 | 8822 | 117 |
1465642 | 1465642 | 2021-06-28 | Kitsap | Washington | 53035 | 8809 | 117 |
1462397 | 1462397 | 2021-06-27 | Kitsap | Washington | 53035 | 8793 | 117 |
1459152 | 1459152 | 2021-06-26 | Kitsap | Washington | 53035 | 8793 | 117 |
1455907 | 1455907 | 2021-06-25 | Kitsap | Washington | 53035 | 8782 | 117 |
1452662 | 1452662 | 2021-06-24 | Kitsap | Washington | 53035 | 8761 | 117 |
1449416 | 1449416 | 2021-06-23 | Kitsap | Washington | 53035 | 8745 | 117 |
1397479 | 1397479 | 2021-06-07 | Franklin | Washington | 53021 | 12627 | 117 |
1394232 | 1394232 | 2021-06-06 | Franklin | Washington | 53021 | 12618 | 117 |
1390987 | 1390987 | 2021-06-05 | Franklin | Washington | 53021 | 12618 | 117 |
1387742 | 1387742 | 2021-06-04 | Franklin | Washington | 53021 | 12609 | 117 |
1384497 | 1384497 | 2021-06-03 | Franklin | Washington | 53021 | 12598 | 117 |
780705 | 780705 | 2020-11-29 | Clark | Washington | 53011 | 8497 | 117 |
777459 | 777459 | 2020-11-28 | Clark | Washington | 53011 | 8377 | 117 |
774214 | 774214 | 2020-11-27 | Clark | Washington | 53011 | 8288 | 117 |
770969 | 770969 | 2020-11-26 | Clark | Washington | 53011 | 8030 | 117 |
767723 | 767723 | 2020-11-25 | Clark | Washington | 53011 | 8030 | 117 |
446984 | 446984 | 2020-08-18 | Spokane | Washington | 53063 | 4843 | 117 |
236878 | 236878 | 2020-06-13 | Yakima | Washington | 53077 | 5504 | 117 |
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);