ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

399 rows where deaths = 28 and state = "Washington" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips 26

state 1

  • Washington · 399 ✖
Link rowid date ▲ county state fips cases deaths
2502664 2502664 2022-05-13 Lincoln Washington 53043 2224 28
2499406 2499406 2022-05-12 Lincoln Washington 53043 2219 28
2496148 2496148 2022-05-11 Lincoln Washington 53043 2219 28
2492884 2492884 2022-05-10 Jefferson Washington 53031 3159 28
2492890 2492890 2022-05-10 Lincoln Washington 53043 2217 28
2489626 2489626 2022-05-09 Jefferson Washington 53031 3159 28
2489632 2489632 2022-05-09 Lincoln Washington 53043 2217 28
2486369 2486369 2022-05-08 Jefferson Washington 53031 3124 28
2486375 2486375 2022-05-08 Lincoln Washington 53043 2217 28
2483111 2483111 2022-05-07 Jefferson Washington 53031 3124 28
2483117 2483117 2022-05-07 Lincoln Washington 53043 2217 28
2479853 2479853 2022-05-06 Jefferson Washington 53031 3124 28
2479859 2479859 2022-05-06 Lincoln Washington 53043 2217 28
2476595 2476595 2022-05-05 Jefferson Washington 53031 3124 28
2476601 2476601 2022-05-05 Lincoln Washington 53043 2217 28
2473337 2473337 2022-05-04 Jefferson Washington 53031 3124 28
2473343 2473343 2022-05-04 Lincoln Washington 53043 2217 28
2470081 2470081 2022-05-03 Jefferson Washington 53031 3089 28
2470087 2470087 2022-05-03 Lincoln Washington 53043 2215 28
2466825 2466825 2022-05-02 Jefferson Washington 53031 3089 28
2466831 2466831 2022-05-02 Lincoln Washington 53043 2215 28
2463570 2463570 2022-05-01 Jefferson Washington 53031 3074 28
2463576 2463576 2022-05-01 Lincoln Washington 53043 2215 28
2460314 2460314 2022-04-30 Jefferson Washington 53031 3074 28
2460320 2460320 2022-04-30 Lincoln Washington 53043 2215 28
2457058 2457058 2022-04-29 Jefferson Washington 53031 3074 28
2457064 2457064 2022-04-29 Lincoln Washington 53043 2215 28
2453802 2453802 2022-04-28 Jefferson Washington 53031 3060 28
2453808 2453808 2022-04-28 Lincoln Washington 53043 2215 28
2450546 2450546 2022-04-27 Jefferson Washington 53031 3060 28
2450552 2450552 2022-04-27 Lincoln Washington 53043 2215 28
2447290 2447290 2022-04-26 Jefferson Washington 53031 3047 28
2447296 2447296 2022-04-26 Lincoln Washington 53043 2212 28
2444034 2444034 2022-04-25 Jefferson Washington 53031 3047 28
2444040 2444040 2022-04-25 Lincoln Washington 53043 2212 28
2440778 2440778 2022-04-24 Jefferson Washington 53031 3022 28
2440784 2440784 2022-04-24 Lincoln Washington 53043 2211 28
2437522 2437522 2022-04-23 Jefferson Washington 53031 3022 28
2437528 2437528 2022-04-23 Lincoln Washington 53043 2211 28
2434266 2434266 2022-04-22 Jefferson Washington 53031 3022 28
2434272 2434272 2022-04-22 Lincoln Washington 53043 2211 28
2431010 2431010 2022-04-21 Jefferson Washington 53031 3010 28
2431016 2431016 2022-04-21 Lincoln Washington 53043 2211 28
2427754 2427754 2022-04-20 Jefferson Washington 53031 3010 28
2427760 2427760 2022-04-20 Lincoln Washington 53043 2211 28
2424498 2424498 2022-04-19 Jefferson Washington 53031 3010 28
2424504 2424504 2022-04-19 Lincoln Washington 53043 2210 28
2421242 2421242 2022-04-18 Jefferson Washington 53031 3010 28
2421248 2421248 2022-04-18 Lincoln Washington 53043 2210 28
2417986 2417986 2022-04-17 Jefferson Washington 53031 2992 28
2417992 2417992 2022-04-17 Lincoln Washington 53043 2209 28
2414730 2414730 2022-04-16 Jefferson Washington 53031 2992 28
2414736 2414736 2022-04-16 Lincoln Washington 53043 2209 28
2411474 2411474 2022-04-15 Jefferson Washington 53031 2992 28
2411480 2411480 2022-04-15 Lincoln Washington 53043 2209 28
2408218 2408218 2022-04-14 Jefferson Washington 53031 2977 28
2404962 2404962 2022-04-13 Jefferson Washington 53031 2977 28
2401707 2401707 2022-04-12 Jefferson Washington 53031 2959 28
2398452 2398452 2022-04-11 Jefferson Washington 53031 2959 28
2395197 2395197 2022-04-10 Jefferson Washington 53031 2959 28
2391941 2391941 2022-04-09 Jefferson Washington 53031 2959 28
2388685 2388685 2022-04-08 Jefferson Washington 53031 2959 28
2385430 2385430 2022-04-07 Jefferson Washington 53031 2953 28
2382175 2382175 2022-04-06 Jefferson Washington 53031 2953 28
2378920 2378920 2022-04-05 Jefferson Washington 53031 2949 28
2375666 2375666 2022-04-04 Jefferson Washington 53031 2949 28
2372414 2372414 2022-04-03 Jefferson Washington 53031 2947 28
2369161 2369161 2022-04-02 Jefferson Washington 53031 2947 28
2365908 2365908 2022-04-01 Jefferson Washington 53031 2947 28
2362655 2362655 2022-03-31 Jefferson Washington 53031 2944 28
2359401 2359401 2022-03-30 Jefferson Washington 53031 2944 28
2356147 2356147 2022-03-29 Jefferson Washington 53031 2939 28
2352894 2352894 2022-03-28 Jefferson Washington 53031 2939 28
2349642 2349642 2022-03-27 Jefferson Washington 53031 2934 28
2346389 2346389 2022-03-26 Jefferson Washington 53031 2934 28
2343136 2343136 2022-03-25 Jefferson Washington 53031 2934 28
2339883 2339883 2022-03-24 Jefferson Washington 53031 2925 28
2336630 2336630 2022-03-23 Jefferson Washington 53031 2925 28
2333376 2333376 2022-03-22 Jefferson Washington 53031 2917 28
2330122 2330122 2022-03-21 Jefferson Washington 53031 2917 28
2326870 2326870 2022-03-20 Jefferson Washington 53031 2921 28
2323617 2323617 2022-03-19 Jefferson Washington 53031 2921 28
2320363 2320363 2022-03-18 Jefferson Washington 53031 2921 28
2317109 2317109 2022-03-17 Jefferson Washington 53031 2914 28
2313856 2313856 2022-03-16 Jefferson Washington 53031 2914 28
2310597 2310597 2022-03-15 Ferry Washington 53019 1393 28
2310603 2310603 2022-03-15 Jefferson Washington 53031 2912 28
2307344 2307344 2022-03-14 Ferry Washington 53019 1393 28
2307350 2307350 2022-03-14 Jefferson Washington 53031 2912 28
2304093 2304093 2022-03-13 Ferry Washington 53019 1391 28
2304099 2304099 2022-03-13 Jefferson Washington 53031 2911 28
2300841 2300841 2022-03-12 Ferry Washington 53019 1391 28
2300847 2300847 2022-03-12 Jefferson Washington 53031 2911 28
2297589 2297589 2022-03-11 Ferry Washington 53019 1391 28
2297595 2297595 2022-03-11 Jefferson Washington 53031 2911 28
2294337 2294337 2022-03-10 Ferry Washington 53019 1388 28
2294343 2294343 2022-03-10 Jefferson Washington 53031 2897 28
2291085 2291085 2022-03-09 Ferry Washington 53019 1388 28
2291091 2291091 2022-03-09 Jefferson Washington 53031 2897 28
2287833 2287833 2022-03-08 Ferry Washington 53019 1386 28

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);