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

799 rows where county = "Washington" and fips = 49053 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 49053 · 799 ✖

county 1

  • Washington · 799 ✖
Link rowid date ▲ county state fips cases deaths
2502489 2502489 2022-05-13 Washington Utah 49053 45053 463
2499231 2499231 2022-05-12 Washington Utah 49053 45053 463
2495973 2495973 2022-05-11 Washington Utah 49053 45032 463
2492715 2492715 2022-05-10 Washington Utah 49053 45012 463
2489457 2489457 2022-05-09 Washington Utah 49053 45006 463
2486199 2486199 2022-05-08 Washington Utah 49053 44976 463
2482941 2482941 2022-05-07 Washington Utah 49053 44976 463
2479683 2479683 2022-05-06 Washington Utah 49053 44976 463
2476425 2476425 2022-05-05 Washington Utah 49053 44976 463
2473168 2473168 2022-05-04 Washington Utah 49053 44949 463
2469912 2469912 2022-05-03 Washington Utah 49053 44949 463
2466656 2466656 2022-05-02 Washington Utah 49053 44940 463
2463401 2463401 2022-05-01 Washington Utah 49053 44866 463
2460145 2460145 2022-04-30 Washington Utah 49053 44866 463
2456889 2456889 2022-04-29 Washington Utah 49053 44866 463
2453633 2453633 2022-04-28 Washington Utah 49053 44866 463
2450377 2450377 2022-04-27 Washington Utah 49053 44820 462
2447120 2447120 2022-04-26 Washington Utah 49053 44820 462
2443865 2443865 2022-04-25 Washington Utah 49053 44820 462
2440609 2440609 2022-04-24 Washington Utah 49053 44806 462
2437353 2437353 2022-04-23 Washington Utah 49053 44806 462
2434097 2434097 2022-04-22 Washington Utah 49053 44806 462
2430841 2430841 2022-04-21 Washington Utah 49053 44795 462
2427585 2427585 2022-04-20 Washington Utah 49053 44780 462
2424329 2424329 2022-04-19 Washington Utah 49053 44780 462
2421073 2421073 2022-04-18 Washington Utah 49053 44759 462
2417817 2417817 2022-04-17 Washington Utah 49053 44759 462
2414561 2414561 2022-04-16 Washington Utah 49053 44759 462
2411305 2411305 2022-04-15 Washington Utah 49053 44759 462
2408049 2408049 2022-04-14 Washington Utah 49053 44759 462
2404793 2404793 2022-04-13 Washington Utah 49053 44735 462
2401538 2401538 2022-04-12 Washington Utah 49053 44735 462
2398283 2398283 2022-04-11 Washington Utah 49053 44735 462
2395028 2395028 2022-04-10 Washington Utah 49053 44735 462
2391772 2391772 2022-04-09 Washington Utah 49053 44735 462
2388516 2388516 2022-04-08 Washington Utah 49053 44735 462
2385261 2385261 2022-04-07 Washington Utah 49053 44735 462
2382006 2382006 2022-04-06 Washington Utah 49053 44714 460
2378751 2378751 2022-04-05 Washington Utah 49053 44714 460
2375497 2375497 2022-04-04 Washington Utah 49053 44714 460
2372245 2372245 2022-04-03 Washington Utah 49053 44714 460
2368992 2368992 2022-04-02 Washington Utah 49053 44714 460
2365739 2365739 2022-04-01 Washington Utah 49053 44714 460
2362486 2362486 2022-03-31 Washington Utah 49053 44714 460
2359232 2359232 2022-03-30 Washington Utah 49053 44706 459
2355978 2355978 2022-03-29 Washington Utah 49053 44695 459
2352725 2352725 2022-03-28 Washington Utah 49053 44689 459
2349473 2349473 2022-03-27 Washington Utah 49053 44678 459
2346220 2346220 2022-03-26 Washington Utah 49053 44678 459
2342967 2342967 2022-03-25 Washington Utah 49053 44678 459
2339714 2339714 2022-03-24 Washington Utah 49053 44667 459
2336460 2336460 2022-03-23 Washington Utah 49053 44662 456
2333206 2333206 2022-03-22 Washington Utah 49053 44654 450
2329953 2329953 2022-03-21 Washington Utah 49053 44645 445
2326701 2326701 2022-03-20 Washington Utah 49053 44628 443
2323448 2323448 2022-03-19 Washington Utah 49053 44628 443
2320194 2320194 2022-03-18 Washington Utah 49053 44628 443
2316940 2316940 2022-03-17 Washington Utah 49053 44624 442
2313687 2313687 2022-03-16 Washington Utah 49053 44620 442
2310434 2310434 2022-03-15 Washington Utah 49053 44618 442
2307181 2307181 2022-03-14 Washington Utah 49053 44594 442
2303930 2303930 2022-03-13 Washington Utah 49053 44594 442
2300678 2300678 2022-03-12 Washington Utah 49053 44594 442
2297426 2297426 2022-03-11 Washington Utah 49053 44594 442
2294174 2294174 2022-03-10 Washington Utah 49053 44587 441
2290922 2290922 2022-03-09 Washington Utah 49053 44581 438
2287670 2287670 2022-03-08 Washington Utah 49053 44575 438
2284418 2284418 2022-03-07 Washington Utah 49053 44549 431
2281166 2281166 2022-03-06 Washington Utah 49053 44549 431
2277913 2277913 2022-03-05 Washington Utah 49053 44549 431
2274660 2274660 2022-03-04 Washington Utah 49053 44549 431
2271407 2271407 2022-03-03 Washington Utah 49053 44537 430
2268155 2268155 2022-03-02 Washington Utah 49053 44524 428
2264902 2264902 2022-03-01 Washington Utah 49053 44506 426
2261652 2261652 2022-02-28 Washington Utah 49053 44487 425
2258401 2258401 2022-02-27 Washington Utah 49053 44444 425
2255150 2255150 2022-02-26 Washington Utah 49053 44444 425
2251899 2251899 2022-02-25 Washington Utah 49053 44444 425
2248648 2248648 2022-02-24 Washington Utah 49053 44421 425
2245397 2245397 2022-02-23 Washington Utah 49053 44379 425
2242146 2242146 2022-02-22 Washington Utah 49053 44355 420
2238895 2238895 2022-02-21 Washington Utah 49053 44238 420
2235644 2235644 2022-02-20 Washington Utah 49053 44238 420
2232393 2232393 2022-02-19 Washington Utah 49053 44238 420
2229142 2229142 2022-02-18 Washington Utah 49053 44238 420
2225891 2225891 2022-02-17 Washington Utah 49053 44171 420
2222640 2222640 2022-02-16 Washington Utah 49053 44119 419
2219389 2219389 2022-02-15 Washington Utah 49053 44064 418
2216138 2216138 2022-02-14 Washington Utah 49053 44026 416
2212887 2212887 2022-02-13 Washington Utah 49053 43868 411
2209634 2209634 2022-02-12 Washington Utah 49053 43868 411
2206381 2206381 2022-02-11 Washington Utah 49053 43868 411
2203128 2203128 2022-02-10 Washington Utah 49053 43799 409
2199874 2199874 2022-02-09 Washington Utah 49053 43690 409
2196620 2196620 2022-02-08 Washington Utah 49053 43624 409
2193366 2193366 2022-02-07 Washington Utah 49053 43538 405
2190113 2190113 2022-02-06 Washington Utah 49053 43254 402
2186860 2186860 2022-02-05 Washington Utah 49053 43254 402
2183607 2183607 2022-02-04 Washington Utah 49053 43254 402
2180355 2180355 2022-02-03 Washington Utah 49053 43101 401

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