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

783 rows where fips = 53075 and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Washington · 783 ✖

fips 1

  • 53075 · 783 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502681 2502681 2022-05-13 Whitman Washington 53075 8806 90
2499423 2499423 2022-05-12 Whitman Washington 53075 8789 90
2496165 2496165 2022-05-11 Whitman Washington 53075 8789 90
2492907 2492907 2022-05-10 Whitman Washington 53075 8779 90
2489649 2489649 2022-05-09 Whitman Washington 53075 8779 90
2486392 2486392 2022-05-08 Whitman Washington 53075 8756 90
2483134 2483134 2022-05-07 Whitman Washington 53075 8756 90
2479876 2479876 2022-05-06 Whitman Washington 53075 8756 90
2476618 2476618 2022-05-05 Whitman Washington 53075 8756 90
2473360 2473360 2022-05-04 Whitman Washington 53075 8756 90
2470103 2470103 2022-05-03 Whitman Washington 53075 8746 90
2466847 2466847 2022-05-02 Whitman Washington 53075 8746 90
2463592 2463592 2022-05-01 Whitman Washington 53075 8739 90
2460336 2460336 2022-04-30 Whitman Washington 53075 8739 90
2457080 2457080 2022-04-29 Whitman Washington 53075 8739 90
2453824 2453824 2022-04-28 Whitman Washington 53075 8732 90
2450568 2450568 2022-04-27 Whitman Washington 53075 8732 90
2447312 2447312 2022-04-26 Whitman Washington 53075 8726 90
2444056 2444056 2022-04-25 Whitman Washington 53075 8726 90
2440800 2440800 2022-04-24 Whitman Washington 53075 8711 90
2437544 2437544 2022-04-23 Whitman Washington 53075 8711 90
2434288 2434288 2022-04-22 Whitman Washington 53075 8711 90
2431032 2431032 2022-04-21 Whitman Washington 53075 8702 90
2427776 2427776 2022-04-20 Whitman Washington 53075 8702 90
2424520 2424520 2022-04-19 Whitman Washington 53075 8700 90
2421264 2421264 2022-04-18 Whitman Washington 53075 8700 90
2418008 2418008 2022-04-17 Whitman Washington 53075 8696 90
2414752 2414752 2022-04-16 Whitman Washington 53075 8696 90
2411496 2411496 2022-04-15 Whitman Washington 53075 8696 90
2408240 2408240 2022-04-14 Whitman Washington 53075 8695 90
2404984 2404984 2022-04-13 Whitman Washington 53075 8695 90
2401729 2401729 2022-04-12 Whitman Washington 53075 8690 90
2398474 2398474 2022-04-11 Whitman Washington 53075 8690 90
2395219 2395219 2022-04-10 Whitman Washington 53075 8690 90
2391963 2391963 2022-04-09 Whitman Washington 53075 8690 90
2388707 2388707 2022-04-08 Whitman Washington 53075 8690 90
2385452 2385452 2022-04-07 Whitman Washington 53075 8685 90
2382197 2382197 2022-04-06 Whitman Washington 53075 8685 90
2378942 2378942 2022-04-05 Whitman Washington 53075 8680 90
2375688 2375688 2022-04-04 Whitman Washington 53075 8680 90
2372436 2372436 2022-04-03 Whitman Washington 53075 8675 90
2369183 2369183 2022-04-02 Whitman Washington 53075 8675 90
2365930 2365930 2022-04-01 Whitman Washington 53075 8675 90
2362677 2362677 2022-03-31 Whitman Washington 53075 8673 90
2359423 2359423 2022-03-30 Whitman Washington 53075 8673 90
2356169 2356169 2022-03-29 Whitman Washington 53075 8670 90
2352916 2352916 2022-03-28 Whitman Washington 53075 8670 90
2349664 2349664 2022-03-27 Whitman Washington 53075 8669 90
2346411 2346411 2022-03-26 Whitman Washington 53075 8669 90
2343158 2343158 2022-03-25 Whitman Washington 53075 8669 90
2339905 2339905 2022-03-24 Whitman Washington 53075 8659 90
2336652 2336652 2022-03-23 Whitman Washington 53075 8659 90
2333398 2333398 2022-03-22 Whitman Washington 53075 8657 90
2330144 2330144 2022-03-21 Whitman Washington 53075 8657 90
2326892 2326892 2022-03-20 Whitman Washington 53075 8655 90
2323639 2323639 2022-03-19 Whitman Washington 53075 8655 90
2320385 2320385 2022-03-18 Whitman Washington 53075 8655 90
2317131 2317131 2022-03-17 Whitman Washington 53075 8644 90
2313878 2313878 2022-03-16 Whitman Washington 53075 8644 90
2310625 2310625 2022-03-15 Whitman Washington 53075 8640 90
2307372 2307372 2022-03-14 Whitman Washington 53075 8640 90
2304121 2304121 2022-03-13 Whitman Washington 53075 8637 90
2300869 2300869 2022-03-12 Whitman Washington 53075 8637 90
2297617 2297617 2022-03-11 Whitman Washington 53075 8637 90
2294365 2294365 2022-03-10 Whitman Washington 53075 8621 90
2291113 2291113 2022-03-09 Whitman Washington 53075 8621 90
2287861 2287861 2022-03-08 Whitman Washington 53075 8617 90
2284609 2284609 2022-03-07 Whitman Washington 53075 8617 90
2281357 2281357 2022-03-06 Whitman Washington 53075 8609 90
2278104 2278104 2022-03-05 Whitman Washington 53075 8609 90
2274851 2274851 2022-03-04 Whitman Washington 53075 8609 90
2271598 2271598 2022-03-03 Whitman Washington 53075 9246 90
2268346 2268346 2022-03-02 Whitman Washington 53075 9246 90
2265093 2265093 2022-03-01 Whitman Washington 53075 9246 89
2261843 2261843 2022-02-28 Whitman Washington 53075 9246 89
2258592 2258592 2022-02-27 Whitman Washington 53075 9229 89
2255341 2255341 2022-02-26 Whitman Washington 53075 9229 89
2252090 2252090 2022-02-25 Whitman Washington 53075 9229 89
2248839 2248839 2022-02-24 Whitman Washington 53075 9229 89
2245588 2245588 2022-02-23 Whitman Washington 53075 9224 89
2242337 2242337 2022-02-22 Whitman Washington 53075 9191 88
2239086 2239086 2022-02-21 Whitman Washington 53075 9162 88
2235835 2235835 2022-02-20 Whitman Washington 53075 9162 88
2232584 2232584 2022-02-19 Whitman Washington 53075 9162 88
2229333 2229333 2022-02-18 Whitman Washington 53075 9162 88
2226082 2226082 2022-02-17 Whitman Washington 53075 9162 88
2222831 2222831 2022-02-16 Whitman Washington 53075 9146 88
2219580 2219580 2022-02-15 Whitman Washington 53075 9097 88
2216330 2216330 2022-02-14 Whitman Washington 53075 9060 88
2213079 2213079 2022-02-13 Whitman Washington 53075 9060 88
2209826 2209826 2022-02-12 Whitman Washington 53075 9060 88
2206573 2206573 2022-02-11 Whitman Washington 53075 9060 88
2203320 2203320 2022-02-10 Whitman Washington 53075 9036 87
2200066 2200066 2022-02-09 Whitman Washington 53075 9012 87
2196812 2196812 2022-02-08 Whitman Washington 53075 8977 87
2193557 2193557 2022-02-07 Whitman Washington 53075 8862 87
2190304 2190304 2022-02-06 Whitman Washington 53075 9001 87
2187051 2187051 2022-02-05 Whitman Washington 53075 9001 87
2183798 2183798 2022-02-04 Whitman Washington 53075 8827 87
2180546 2180546 2022-02-03 Whitman Washington 53075 8691 86

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