ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where deaths = 57 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502667 | 2502667 | 2022-05-13 | Pacific | Washington | 53049 | 3795 | 57 |
2499409 | 2499409 | 2022-05-12 | Pacific | Washington | 53049 | 3792 | 57 |
2496151 | 2496151 | 2022-05-11 | Pacific | Washington | 53049 | 3792 | 57 |
2492893 | 2492893 | 2022-05-10 | Pacific | Washington | 53049 | 3785 | 57 |
2489635 | 2489635 | 2022-05-09 | Pacific | Washington | 53049 | 3785 | 57 |
2486378 | 2486378 | 2022-05-08 | Pacific | Washington | 53049 | 3775 | 57 |
2483120 | 2483120 | 2022-05-07 | Pacific | Washington | 53049 | 3775 | 57 |
2479862 | 2479862 | 2022-05-06 | Pacific | Washington | 53049 | 3775 | 57 |
2476604 | 2476604 | 2022-05-05 | Pacific | Washington | 53049 | 3775 | 57 |
2473346 | 2473346 | 2022-05-04 | Pacific | Washington | 53049 | 3775 | 57 |
2470090 | 2470090 | 2022-05-03 | Pacific | Washington | 53049 | 3769 | 57 |
2466834 | 2466834 | 2022-05-02 | Pacific | Washington | 53049 | 3769 | 57 |
2463579 | 2463579 | 2022-05-01 | Pacific | Washington | 53049 | 3759 | 57 |
2460323 | 2460323 | 2022-04-30 | Pacific | Washington | 53049 | 3759 | 57 |
2457067 | 2457067 | 2022-04-29 | Pacific | Washington | 53049 | 3759 | 57 |
2453811 | 2453811 | 2022-04-28 | Pacific | Washington | 53049 | 3752 | 57 |
2450555 | 2450555 | 2022-04-27 | Pacific | Washington | 53049 | 3752 | 57 |
2447299 | 2447299 | 2022-04-26 | Pacific | Washington | 53049 | 3748 | 57 |
2444043 | 2444043 | 2022-04-25 | Pacific | Washington | 53049 | 3748 | 57 |
2440787 | 2440787 | 2022-04-24 | Pacific | Washington | 53049 | 3634 | 57 |
2437531 | 2437531 | 2022-04-23 | Pacific | Washington | 53049 | 3634 | 57 |
2434275 | 2434275 | 2022-04-22 | Pacific | Washington | 53049 | 3634 | 57 |
2431019 | 2431019 | 2022-04-21 | Pacific | Washington | 53049 | 3473 | 57 |
2427763 | 2427763 | 2022-04-20 | Pacific | Washington | 53049 | 3473 | 57 |
2424507 | 2424507 | 2022-04-19 | Pacific | Washington | 53049 | 3464 | 57 |
2421251 | 2421251 | 2022-04-18 | Pacific | Washington | 53049 | 3464 | 57 |
2417995 | 2417995 | 2022-04-17 | Pacific | Washington | 53049 | 3463 | 57 |
2414739 | 2414739 | 2022-04-16 | Pacific | Washington | 53049 | 3463 | 57 |
2411483 | 2411483 | 2022-04-15 | Pacific | Washington | 53049 | 3463 | 57 |
2408227 | 2408227 | 2022-04-14 | Pacific | Washington | 53049 | 3459 | 57 |
2404971 | 2404971 | 2022-04-13 | Pacific | Washington | 53049 | 3459 | 57 |
2401716 | 2401716 | 2022-04-12 | Pacific | Washington | 53049 | 3459 | 57 |
2398461 | 2398461 | 2022-04-11 | Pacific | Washington | 53049 | 3459 | 57 |
2395206 | 2395206 | 2022-04-10 | Pacific | Washington | 53049 | 3459 | 57 |
2391950 | 2391950 | 2022-04-09 | Pacific | Washington | 53049 | 3459 | 57 |
2388694 | 2388694 | 2022-04-08 | Pacific | Washington | 53049 | 3459 | 57 |
2385439 | 2385439 | 2022-04-07 | Pacific | Washington | 53049 | 3457 | 57 |
2382184 | 2382184 | 2022-04-06 | Pacific | Washington | 53049 | 3457 | 57 |
2378929 | 2378929 | 2022-04-05 | Pacific | Washington | 53049 | 3457 | 57 |
2375675 | 2375675 | 2022-04-04 | Pacific | Washington | 53049 | 3457 | 57 |
2372423 | 2372423 | 2022-04-03 | Pacific | Washington | 53049 | 3456 | 57 |
2369170 | 2369170 | 2022-04-02 | Pacific | Washington | 53049 | 3456 | 57 |
2365917 | 2365917 | 2022-04-01 | Pacific | Washington | 53049 | 3456 | 57 |
2196776 | 2196776 | 2022-02-08 | Asotin | Washington | 53003 | 4097 | 57 |
2193521 | 2193521 | 2022-02-07 | Asotin | Washington | 53003 | 4097 | 57 |
2134972 | 2134972 | 2022-01-20 | Island | Washington | 53029 | 7270 | 57 |
2134976 | 2134976 | 2022-01-20 | Kittitas | Washington | 53037 | 6745 | 57 |
2131720 | 2131720 | 2022-01-19 | Island | Washington | 53029 | 7119 | 57 |
2128466 | 2128466 | 2022-01-18 | Island | Washington | 53029 | 7058 | 57 |
2125213 | 2125213 | 2022-01-17 | Island | Washington | 53029 | 6572 | 57 |
2121961 | 2121961 | 2022-01-16 | Island | Washington | 53029 | 6572 | 57 |
2118709 | 2118709 | 2022-01-15 | Island | Washington | 53029 | 6572 | 57 |
2115457 | 2115457 | 2022-01-14 | Island | Washington | 53029 | 6572 | 57 |
2112205 | 2112205 | 2022-01-13 | Island | Washington | 53029 | 6420 | 57 |
2108953 | 2108953 | 2022-01-12 | Island | Washington | 53029 | 6261 | 57 |
2105702 | 2105702 | 2022-01-11 | Island | Washington | 53029 | 6007 | 57 |
2102451 | 2102451 | 2022-01-10 | Island | Washington | 53029 | 5930 | 57 |
2099200 | 2099200 | 2022-01-09 | Island | Washington | 53029 | 5535 | 57 |
2095949 | 2095949 | 2022-01-08 | Island | Washington | 53029 | 5535 | 57 |
2092697 | 2092697 | 2022-01-07 | Island | Washington | 53029 | 5535 | 57 |
2089445 | 2089445 | 2022-01-06 | Island | Washington | 53029 | 5415 | 57 |
2086194 | 2086194 | 2022-01-05 | Island | Washington | 53029 | 5279 | 57 |
2082942 | 2082942 | 2022-01-04 | Island | Washington | 53029 | 5169 | 57 |
1848921 | 1848921 | 2021-10-24 | Clallam | Washington | 53009 | 4724 | 57 |
1845671 | 1845671 | 2021-10-23 | Clallam | Washington | 53009 | 4724 | 57 |
1842421 | 1842421 | 2021-10-22 | Clallam | Washington | 53009 | 4724 | 57 |
1783957 | 1783957 | 2021-10-04 | Mason | Washington | 53045 | 5064 | 57 |
1780708 | 1780708 | 2021-10-03 | Mason | Washington | 53045 | 4940 | 57 |
1777458 | 1777458 | 2021-10-02 | Mason | Washington | 53045 | 4940 | 57 |
1774208 | 1774208 | 2021-10-01 | Mason | Washington | 53045 | 4940 | 57 |
1770958 | 1770958 | 2021-09-30 | Mason | Washington | 53045 | 4902 | 57 |
1767709 | 1767709 | 2021-09-29 | Mason | Washington | 53045 | 4843 | 57 |
1764461 | 1764461 | 2021-09-28 | Okanogan | Washington | 53047 | 4416 | 57 |
1761226 | 1761226 | 2021-09-27 | Whitman | Washington | 53075 | 5402 | 57 |
1757978 | 1757978 | 2021-09-26 | Whitman | Washington | 53075 | 5367 | 57 |
1754730 | 1754730 | 2021-09-25 | Whitman | Washington | 53075 | 5367 | 57 |
1751482 | 1751482 | 2021-09-24 | Whitman | Washington | 53075 | 5367 | 57 |
1202685 | 1202685 | 2021-04-08 | Lewis | Washington | 53041 | 4025 | 57 |
1199430 | 1199430 | 2021-04-07 | Grays Harbor | Washington | 53027 | 3570 | 57 |
1199437 | 1199437 | 2021-04-07 | Lewis | Washington | 53041 | 4017 | 57 |
1196181 | 1196181 | 2021-04-06 | Grays Harbor | Washington | 53027 | 3569 | 57 |
1196188 | 1196188 | 2021-04-06 | Lewis | Washington | 53041 | 3993 | 57 |
1192933 | 1192933 | 2021-04-05 | Grays Harbor | Washington | 53027 | 3565 | 57 |
1189683 | 1189683 | 2021-04-04 | Grays Harbor | Washington | 53027 | 3558 | 57 |
1186436 | 1186436 | 2021-04-03 | Grays Harbor | Washington | 53027 | 3558 | 57 |
1183189 | 1183189 | 2021-04-02 | Grays Harbor | Washington | 53027 | 3552 | 57 |
1179942 | 1179942 | 2021-04-01 | Grays Harbor | Washington | 53027 | 3550 | 57 |
1176695 | 1176695 | 2021-03-31 | Grays Harbor | Washington | 53027 | 3546 | 57 |
1173448 | 1173448 | 2021-03-30 | Grays Harbor | Washington | 53027 | 3538 | 57 |
1170201 | 1170201 | 2021-03-29 | Grays Harbor | Washington | 53027 | 3532 | 57 |
1166953 | 1166953 | 2021-03-28 | Grays Harbor | Washington | 53027 | 3542 | 57 |
1163705 | 1163705 | 2021-03-27 | Grays Harbor | Washington | 53027 | 3542 | 57 |
1160457 | 1160457 | 2021-03-26 | Grays Harbor | Washington | 53027 | 3522 | 57 |
1157209 | 1157209 | 2021-03-25 | Grays Harbor | Washington | 53027 | 3524 | 57 |
1153962 | 1153962 | 2021-03-24 | Grays Harbor | Washington | 53027 | 3510 | 57 |
1127987 | 1127987 | 2021-03-16 | Grays Harbor | Washington | 53027 | 3461 | 57 |
1053324 | 1053324 | 2021-02-21 | Cowlitz | Washington | 53015 | 4188 | 57 |
1053352 | 1053352 | 2021-02-21 | Walla Walla | Washington | 53071 | 4671 | 57 |
1050077 | 1050077 | 2021-02-20 | Cowlitz | Washington | 53015 | 4188 | 57 |
1050105 | 1050105 | 2021-02-20 | Walla Walla | Washington | 53071 | 4671 | 57 |
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);