ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30,893 rows where state = "Washington" sorted by deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 40
- 53061 844
- 53063 810
- 53033 806
- 53071 803
- 53007 801
- 53011 799
- 53031 799
- 53053 799
- 53037 798
- 53035 797
- 53057 795
- 53073 795
- 53029 794
- 53067 794
- 53013 793
- 53027 793
- 53077 793
- 53025 792
- 53039 791
- 53041 790
- 53043 790
- 53021 788
- 53045 788
- 53005 787
- 53009 786
- 53015 785
- 53055 785
- 53065 785
- 53075 783
- 53001 782
- 53017 782
- 53019 780
- 53047 780
- 53059 778
- 53051 772
- 53003 771
- 53069 770
- 53049 764
- 53023 671
- - 180
county 40
- Snohomish 844
- Spokane 810
- King 806
- Walla Walla 803
- Chelan 801
- Clark 799
- Jefferson 799
- Pierce 799
- Kittitas 798
- Kitsap 797
- Skagit 795
- Whatcom 795
- Island 794
- Thurston 794
- Columbia 793
- Grays Harbor 793
- Yakima 793
- Grant 792
- Klickitat 791
- Lewis 790
- Lincoln 790
- Franklin 788
- Mason 788
- Benton 787
- Clallam 786
- Cowlitz 785
- San Juan 785
- Stevens 785
- Whitman 783
- Adams 782
- Douglas 782
- Ferry 780
- Okanogan 780
- Skamania 778
- Pend Oreille 772
- Asotin 771
- Wahkiakum 770
- Pacific 764
- Garfield 671
- Unknown 180
state 1
- Washington · 30,893 ✖
Link | rowid | date | county | state | fips | cases | deaths ▲ |
---|---|---|---|---|---|---|---|
2502659 | 2502659 | 2022-05-13 | King | Washington | 53033 | 410322 | 2774 |
2496143 | 2496143 | 2022-05-11 | King | Washington | 53033 | 407538 | 2765 |
2499401 | 2499401 | 2022-05-12 | King | Washington | 53033 | 407538 | 2765 |
2489627 | 2489627 | 2022-05-09 | King | Washington | 53033 | 405165 | 2757 |
2492885 | 2492885 | 2022-05-10 | King | Washington | 53033 | 405165 | 2757 |
2479854 | 2479854 | 2022-05-06 | King | Washington | 53033 | 402422 | 2754 |
2483112 | 2483112 | 2022-05-07 | King | Washington | 53033 | 402422 | 2754 |
2486370 | 2486370 | 2022-05-08 | King | Washington | 53033 | 402422 | 2754 |
2473338 | 2473338 | 2022-05-04 | King | Washington | 53033 | 400183 | 2750 |
2476596 | 2476596 | 2022-05-05 | King | Washington | 53033 | 400183 | 2750 |
2466826 | 2466826 | 2022-05-02 | King | Washington | 53033 | 400290 | 2741 |
2470082 | 2470082 | 2022-05-03 | King | Washington | 53033 | 400290 | 2741 |
2457059 | 2457059 | 2022-04-29 | King | Washington | 53033 | 395392 | 2740 |
2460315 | 2460315 | 2022-04-30 | King | Washington | 53033 | 395392 | 2740 |
2463571 | 2463571 | 2022-05-01 | King | Washington | 53033 | 395392 | 2740 |
2450547 | 2450547 | 2022-04-27 | King | Washington | 53033 | 393274 | 2736 |
2453803 | 2453803 | 2022-04-28 | King | Washington | 53033 | 393274 | 2736 |
2444035 | 2444035 | 2022-04-25 | King | Washington | 53033 | 391842 | 2735 |
2447291 | 2447291 | 2022-04-26 | King | Washington | 53033 | 391842 | 2735 |
2434267 | 2434267 | 2022-04-22 | King | Washington | 53033 | 388710 | 2733 |
2437523 | 2437523 | 2022-04-23 | King | Washington | 53033 | 388710 | 2733 |
2440779 | 2440779 | 2022-04-24 | King | Washington | 53033 | 388710 | 2733 |
2427755 | 2427755 | 2022-04-20 | King | Washington | 53033 | 386808 | 2730 |
2431011 | 2431011 | 2022-04-21 | King | Washington | 53033 | 386808 | 2730 |
2411475 | 2411475 | 2022-04-15 | King | Washington | 53033 | 384353 | 2724 |
2414731 | 2414731 | 2022-04-16 | King | Washington | 53033 | 384353 | 2724 |
2417987 | 2417987 | 2022-04-17 | King | Washington | 53033 | 384353 | 2724 |
2421243 | 2421243 | 2022-04-18 | King | Washington | 53033 | 386023 | 2724 |
2424499 | 2424499 | 2022-04-19 | King | Washington | 53033 | 386023 | 2724 |
2404963 | 2404963 | 2022-04-13 | King | Washington | 53033 | 382806 | 2717 |
2408219 | 2408219 | 2022-04-14 | King | Washington | 53033 | 382806 | 2717 |
2398453 | 2398453 | 2022-04-11 | King | Washington | 53033 | 381614 | 2716 |
2401708 | 2401708 | 2022-04-12 | King | Washington | 53033 | 381614 | 2716 |
2388686 | 2388686 | 2022-04-08 | King | Washington | 53033 | 380229 | 2712 |
2391942 | 2391942 | 2022-04-09 | King | Washington | 53033 | 380229 | 2712 |
2395198 | 2395198 | 2022-04-10 | King | Washington | 53033 | 380229 | 2712 |
2382176 | 2382176 | 2022-04-06 | King | Washington | 53033 | 378891 | 2706 |
2385431 | 2385431 | 2022-04-07 | King | Washington | 53033 | 378891 | 2706 |
2375667 | 2375667 | 2022-04-04 | King | Washington | 53033 | 375676 | 2705 |
2378921 | 2378921 | 2022-04-05 | King | Washington | 53033 | 375676 | 2705 |
2365909 | 2365909 | 2022-04-01 | King | Washington | 53033 | 374748 | 2703 |
2369162 | 2369162 | 2022-04-02 | King | Washington | 53033 | 374748 | 2703 |
2372415 | 2372415 | 2022-04-03 | King | Washington | 53033 | 374748 | 2703 |
2359402 | 2359402 | 2022-03-30 | King | Washington | 53033 | 373931 | 2699 |
2362656 | 2362656 | 2022-03-31 | King | Washington | 53033 | 373931 | 2699 |
2352895 | 2352895 | 2022-03-28 | King | Washington | 53033 | 373239 | 2690 |
2356148 | 2356148 | 2022-03-29 | King | Washington | 53033 | 373239 | 2690 |
2343137 | 2343137 | 2022-03-25 | King | Washington | 53033 | 372411 | 2684 |
2346390 | 2346390 | 2022-03-26 | King | Washington | 53033 | 372411 | 2684 |
2349643 | 2349643 | 2022-03-27 | King | Washington | 53033 | 372411 | 2684 |
2336631 | 2336631 | 2022-03-23 | King | Washington | 53033 | 371678 | 2679 |
2339884 | 2339884 | 2022-03-24 | King | Washington | 53033 | 371678 | 2679 |
2320364 | 2320364 | 2022-03-18 | King | Washington | 53033 | 370694 | 2659 |
2323618 | 2323618 | 2022-03-19 | King | Washington | 53033 | 370694 | 2659 |
2326871 | 2326871 | 2022-03-20 | King | Washington | 53033 | 370694 | 2659 |
2330123 | 2330123 | 2022-03-21 | King | Washington | 53033 | 371216 | 2658 |
2333377 | 2333377 | 2022-03-22 | King | Washington | 53033 | 371216 | 2658 |
2313857 | 2313857 | 2022-03-16 | King | Washington | 53033 | 370114 | 2649 |
2317110 | 2317110 | 2022-03-17 | King | Washington | 53033 | 370114 | 2649 |
2307351 | 2307351 | 2022-03-14 | King | Washington | 53033 | 369599 | 2635 |
2310604 | 2310604 | 2022-03-15 | King | Washington | 53033 | 369599 | 2635 |
2297596 | 2297596 | 2022-03-11 | King | Washington | 53033 | 369046 | 2631 |
2300848 | 2300848 | 2022-03-12 | King | Washington | 53033 | 369046 | 2631 |
2304100 | 2304100 | 2022-03-13 | King | Washington | 53033 | 369046 | 2631 |
2291092 | 2291092 | 2022-03-09 | King | Washington | 53033 | 368391 | 2620 |
2294344 | 2294344 | 2022-03-10 | King | Washington | 53033 | 368391 | 2620 |
2274830 | 2274830 | 2022-03-04 | King | Washington | 53033 | 367328 | 2593 |
2278083 | 2278083 | 2022-03-05 | King | Washington | 53033 | 367328 | 2593 |
2281336 | 2281336 | 2022-03-06 | King | Washington | 53033 | 367328 | 2593 |
2284588 | 2284588 | 2022-03-07 | King | Washington | 53033 | 367807 | 2593 |
2287840 | 2287840 | 2022-03-08 | King | Washington | 53033 | 367807 | 2593 |
2268325 | 2268325 | 2022-03-02 | King | Washington | 53033 | 366645 | 2577 |
2271577 | 2271577 | 2022-03-03 | King | Washington | 53033 | 366645 | 2577 |
2261822 | 2261822 | 2022-02-28 | King | Washington | 53033 | 365873 | 2569 |
2265072 | 2265072 | 2022-03-01 | King | Washington | 53033 | 365873 | 2569 |
2252069 | 2252069 | 2022-02-25 | King | Washington | 53033 | 364955 | 2553 |
2255320 | 2255320 | 2022-02-26 | King | Washington | 53033 | 364955 | 2553 |
2258571 | 2258571 | 2022-02-27 | King | Washington | 53033 | 364955 | 2553 |
2245567 | 2245567 | 2022-02-23 | King | Washington | 53033 | 364481 | 2541 |
2248818 | 2248818 | 2022-02-24 | King | Washington | 53033 | 364846 | 2540 |
2242316 | 2242316 | 2022-02-22 | King | Washington | 53033 | 364445 | 2532 |
2229312 | 2229312 | 2022-02-18 | King | Washington | 53033 | 362616 | 2526 |
2232563 | 2232563 | 2022-02-19 | King | Washington | 53033 | 362616 | 2526 |
2235814 | 2235814 | 2022-02-20 | King | Washington | 53033 | 362616 | 2526 |
2239065 | 2239065 | 2022-02-21 | King | Washington | 53033 | 362616 | 2526 |
2226061 | 2226061 | 2022-02-17 | King | Washington | 53033 | 362256 | 2517 |
2222810 | 2222810 | 2022-02-16 | King | Washington | 53033 | 362022 | 2500 |
2216309 | 2216309 | 2022-02-14 | King | Washington | 53033 | 361948 | 2484 |
2219559 | 2219559 | 2022-02-15 | King | Washington | 53033 | 361829 | 2484 |
2206552 | 2206552 | 2022-02-11 | King | Washington | 53033 | 361215 | 2467 |
2209805 | 2209805 | 2022-02-12 | King | Washington | 53033 | 361215 | 2467 |
2213058 | 2213058 | 2022-02-13 | King | Washington | 53033 | 361215 | 2467 |
2203299 | 2203299 | 2022-02-10 | King | Washington | 53033 | 360425 | 2453 |
2200045 | 2200045 | 2022-02-09 | King | Washington | 53033 | 357858 | 2447 |
2196791 | 2196791 | 2022-02-08 | King | Washington | 53033 | 356460 | 2431 |
2193536 | 2193536 | 2022-02-07 | King | Washington | 53033 | 356001 | 2419 |
2183777 | 2183777 | 2022-02-04 | King | Washington | 53033 | 351932 | 2401 |
2187030 | 2187030 | 2022-02-05 | King | Washington | 53033 | 351932 | 2401 |
2190283 | 2190283 | 2022-02-06 | King | Washington | 53033 | 351932 | 2401 |
2180525 | 2180525 | 2022-02-03 | King | Washington | 53033 | 350701 | 2394 |
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);