ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where deaths = 140 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Walla Walla 47
- Clallam 28
- Stevens 16
- Mason 9
- Chelan 6
- Benton 5
- Grays Harbor 4
- Franklin 1
- Whatcom 1
state 1
- Washington · 117 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499389 | 2499389 | 2022-05-12 | Clallam | Washington | 53009 | 11826 | 140 |
2496131 | 2496131 | 2022-05-11 | Clallam | Washington | 53009 | 11826 | 140 |
2492873 | 2492873 | 2022-05-10 | Clallam | Washington | 53009 | 11747 | 140 |
2489615 | 2489615 | 2022-05-09 | Clallam | Washington | 53009 | 11747 | 140 |
2486358 | 2486358 | 2022-05-08 | Clallam | Washington | 53009 | 11635 | 140 |
2483100 | 2483100 | 2022-05-07 | Clallam | Washington | 53009 | 11635 | 140 |
2479842 | 2479842 | 2022-05-06 | Clallam | Washington | 53009 | 11635 | 140 |
2476584 | 2476584 | 2022-05-05 | Clallam | Washington | 53009 | 11635 | 140 |
2473326 | 2473326 | 2022-05-04 | Clallam | Washington | 53009 | 11635 | 140 |
2470070 | 2470070 | 2022-05-03 | Clallam | Washington | 53009 | 11717 | 140 |
2466814 | 2466814 | 2022-05-02 | Clallam | Washington | 53009 | 11717 | 140 |
2463559 | 2463559 | 2022-05-01 | Clallam | Washington | 53009 | 11552 | 140 |
2463590 | 2463590 | 2022-05-01 | Walla Walla | Washington | 53071 | 16139 | 140 |
2460303 | 2460303 | 2022-04-30 | Clallam | Washington | 53009 | 11552 | 140 |
2460334 | 2460334 | 2022-04-30 | Walla Walla | Washington | 53071 | 16139 | 140 |
2457047 | 2457047 | 2022-04-29 | Clallam | Washington | 53009 | 11552 | 140 |
2457078 | 2457078 | 2022-04-29 | Walla Walla | Washington | 53071 | 16139 | 140 |
2453791 | 2453791 | 2022-04-28 | Clallam | Washington | 53009 | 11498 | 140 |
2453822 | 2453822 | 2022-04-28 | Walla Walla | Washington | 53071 | 16133 | 140 |
2450535 | 2450535 | 2022-04-27 | Clallam | Washington | 53009 | 11498 | 140 |
2450566 | 2450566 | 2022-04-27 | Walla Walla | Washington | 53071 | 16114 | 140 |
2447279 | 2447279 | 2022-04-26 | Clallam | Washington | 53009 | 11474 | 140 |
2447310 | 2447310 | 2022-04-26 | Walla Walla | Washington | 53071 | 16064 | 140 |
2444023 | 2444023 | 2022-04-25 | Clallam | Washington | 53009 | 11474 | 140 |
2444054 | 2444054 | 2022-04-25 | Walla Walla | Washington | 53071 | 16064 | 140 |
2440767 | 2440767 | 2022-04-24 | Clallam | Washington | 53009 | 11416 | 140 |
2440798 | 2440798 | 2022-04-24 | Walla Walla | Washington | 53071 | 16044 | 140 |
2437511 | 2437511 | 2022-04-23 | Clallam | Washington | 53009 | 11416 | 140 |
2437542 | 2437542 | 2022-04-23 | Walla Walla | Washington | 53071 | 16044 | 140 |
2434255 | 2434255 | 2022-04-22 | Clallam | Washington | 53009 | 11416 | 140 |
2434286 | 2434286 | 2022-04-22 | Walla Walla | Washington | 53071 | 16044 | 140 |
2430999 | 2430999 | 2022-04-21 | Clallam | Washington | 53009 | 11407 | 140 |
2431017 | 2431017 | 2022-04-21 | Mason | Washington | 53045 | 12378 | 140 |
2431030 | 2431030 | 2022-04-21 | Walla Walla | Washington | 53071 | 16022 | 140 |
2427743 | 2427743 | 2022-04-20 | Clallam | Washington | 53009 | 11407 | 140 |
2427761 | 2427761 | 2022-04-20 | Mason | Washington | 53045 | 12378 | 140 |
2427774 | 2427774 | 2022-04-20 | Walla Walla | Washington | 53071 | 16000 | 140 |
2424487 | 2424487 | 2022-04-19 | Clallam | Washington | 53009 | 11402 | 140 |
2424518 | 2424518 | 2022-04-19 | Walla Walla | Washington | 53071 | 15978 | 140 |
2421231 | 2421231 | 2022-04-18 | Clallam | Washington | 53009 | 11402 | 140 |
2421262 | 2421262 | 2022-04-18 | Walla Walla | Washington | 53071 | 15965 | 140 |
2417975 | 2417975 | 2022-04-17 | Clallam | Washington | 53009 | 11386 | 140 |
2418006 | 2418006 | 2022-04-17 | Walla Walla | Washington | 53071 | 15952 | 140 |
2414719 | 2414719 | 2022-04-16 | Clallam | Washington | 53009 | 11386 | 140 |
2414750 | 2414750 | 2022-04-16 | Walla Walla | Washington | 53071 | 15952 | 140 |
2411463 | 2411463 | 2022-04-15 | Clallam | Washington | 53009 | 11386 | 140 |
2411494 | 2411494 | 2022-04-15 | Walla Walla | Washington | 53071 | 15952 | 140 |
2408225 | 2408225 | 2022-04-14 | Mason | Washington | 53045 | 12322 | 140 |
2408238 | 2408238 | 2022-04-14 | Walla Walla | Washington | 53071 | 15946 | 140 |
2404969 | 2404969 | 2022-04-13 | Mason | Washington | 53045 | 12322 | 140 |
2404982 | 2404982 | 2022-04-13 | Walla Walla | Washington | 53071 | 15939 | 140 |
2401714 | 2401714 | 2022-04-12 | Mason | Washington | 53045 | 12310 | 140 |
2401727 | 2401727 | 2022-04-12 | Walla Walla | Washington | 53071 | 15918 | 140 |
2398459 | 2398459 | 2022-04-11 | Mason | Washington | 53045 | 12310 | 140 |
2398472 | 2398472 | 2022-04-11 | Walla Walla | Washington | 53071 | 15918 | 140 |
2395204 | 2395204 | 2022-04-10 | Mason | Washington | 53045 | 12310 | 140 |
2395217 | 2395217 | 2022-04-10 | Walla Walla | Washington | 53071 | 15918 | 140 |
2391948 | 2391948 | 2022-04-09 | Mason | Washington | 53045 | 12310 | 140 |
2391961 | 2391961 | 2022-04-09 | Walla Walla | Washington | 53071 | 15918 | 140 |
2388692 | 2388692 | 2022-04-08 | Mason | Washington | 53045 | 12310 | 140 |
2388705 | 2388705 | 2022-04-08 | Walla Walla | Washington | 53071 | 15918 | 140 |
2385450 | 2385450 | 2022-04-07 | Walla Walla | Washington | 53071 | 15882 | 140 |
2382195 | 2382195 | 2022-04-06 | Walla Walla | Washington | 53071 | 15882 | 140 |
2378940 | 2378940 | 2022-04-05 | Walla Walla | Washington | 53071 | 15887 | 140 |
2375686 | 2375686 | 2022-04-04 | Walla Walla | Washington | 53071 | 15887 | 140 |
2372434 | 2372434 | 2022-04-03 | Walla Walla | Washington | 53071 | 15892 | 140 |
2369181 | 2369181 | 2022-04-02 | Walla Walla | Washington | 53071 | 15712 | 140 |
2365928 | 2365928 | 2022-04-01 | Walla Walla | Washington | 53071 | 15712 | 140 |
2362675 | 2362675 | 2022-03-31 | Walla Walla | Washington | 53071 | 15705 | 140 |
2359421 | 2359421 | 2022-03-30 | Walla Walla | Washington | 53071 | 15693 | 140 |
2356167 | 2356167 | 2022-03-29 | Walla Walla | Washington | 53071 | 15693 | 140 |
2352914 | 2352914 | 2022-03-28 | Walla Walla | Washington | 53071 | 15683 | 140 |
2349659 | 2349659 | 2022-03-27 | Stevens | Washington | 53065 | 8062 | 140 |
2349662 | 2349662 | 2022-03-27 | Walla Walla | Washington | 53071 | 15656 | 140 |
2346406 | 2346406 | 2022-03-26 | Stevens | Washington | 53065 | 8062 | 140 |
2346409 | 2346409 | 2022-03-26 | Walla Walla | Washington | 53071 | 15656 | 140 |
2343153 | 2343153 | 2022-03-25 | Stevens | Washington | 53065 | 8062 | 140 |
2343156 | 2343156 | 2022-03-25 | Walla Walla | Washington | 53071 | 15656 | 140 |
2339900 | 2339900 | 2022-03-24 | Stevens | Washington | 53065 | 8046 | 140 |
2336647 | 2336647 | 2022-03-23 | Stevens | Washington | 53065 | 8046 | 140 |
2333393 | 2333393 | 2022-03-22 | Stevens | Washington | 53065 | 8032 | 140 |
2330139 | 2330139 | 2022-03-21 | Stevens | Washington | 53065 | 8032 | 140 |
2326887 | 2326887 | 2022-03-20 | Stevens | Washington | 53065 | 8018 | 140 |
2323634 | 2323634 | 2022-03-19 | Stevens | Washington | 53065 | 8018 | 140 |
2320380 | 2320380 | 2022-03-18 | Stevens | Washington | 53065 | 8018 | 140 |
2317126 | 2317126 | 2022-03-17 | Stevens | Washington | 53065 | 8011 | 140 |
2317129 | 2317129 | 2022-03-17 | Walla Walla | Washington | 53071 | 15587 | 140 |
2313873 | 2313873 | 2022-03-16 | Stevens | Washington | 53065 | 8011 | 140 |
2313876 | 2313876 | 2022-03-16 | Walla Walla | Washington | 53071 | 15576 | 140 |
2310620 | 2310620 | 2022-03-15 | Stevens | Washington | 53065 | 7991 | 140 |
2310623 | 2310623 | 2022-03-15 | Walla Walla | Washington | 53071 | 15573 | 140 |
2307367 | 2307367 | 2022-03-14 | Stevens | Washington | 53065 | 7991 | 140 |
2307370 | 2307370 | 2022-03-14 | Walla Walla | Washington | 53071 | 15553 | 140 |
2304119 | 2304119 | 2022-03-13 | Walla Walla | Washington | 53071 | 15553 | 140 |
2300867 | 2300867 | 2022-03-12 | Walla Walla | Washington | 53071 | 15553 | 140 |
2297615 | 2297615 | 2022-03-11 | Walla Walla | Washington | 53071 | 15546 | 140 |
2294363 | 2294363 | 2022-03-10 | Walla Walla | Washington | 53071 | 15546 | 140 |
2291111 | 2291111 | 2022-03-09 | Walla Walla | Washington | 53071 | 15533 | 140 |
2287856 | 2287856 | 2022-03-08 | Stevens | Washington | 53065 | 7943 | 140 |
2284604 | 2284604 | 2022-03-07 | Stevens | Washington | 53065 | 7943 | 140 |
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);