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

671 rows where fips = 53023 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 53023 · 671 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502654 2502654 2022-05-13 Garfield Washington 53023 389 7
2499396 2499396 2022-05-12 Garfield Washington 53023 389 7
2496138 2496138 2022-05-11 Garfield Washington 53023 389 7
2492880 2492880 2022-05-10 Garfield Washington 53023 389 7
2489622 2489622 2022-05-09 Garfield Washington 53023 389 7
2486365 2486365 2022-05-08 Garfield Washington 53023 389 7
2483107 2483107 2022-05-07 Garfield Washington 53023 389 7
2479849 2479849 2022-05-06 Garfield Washington 53023 389 7
2476591 2476591 2022-05-05 Garfield Washington 53023 389 7
2473333 2473333 2022-05-04 Garfield Washington 53023 389 7
2470077 2470077 2022-05-03 Garfield Washington 53023 388 7
2466821 2466821 2022-05-02 Garfield Washington 53023 388 7
2463566 2463566 2022-05-01 Garfield Washington 53023 388 7
2460310 2460310 2022-04-30 Garfield Washington 53023 388 7
2457054 2457054 2022-04-29 Garfield Washington 53023 388 7
2453798 2453798 2022-04-28 Garfield Washington 53023 388 7
2450542 2450542 2022-04-27 Garfield Washington 53023 388 7
2447286 2447286 2022-04-26 Garfield Washington 53023 388 7
2444030 2444030 2022-04-25 Garfield Washington 53023 388 7
2440774 2440774 2022-04-24 Garfield Washington 53023 388 7
2437518 2437518 2022-04-23 Garfield Washington 53023 388 7
2434262 2434262 2022-04-22 Garfield Washington 53023 388 7
2431006 2431006 2022-04-21 Garfield Washington 53023 388 7
2427750 2427750 2022-04-20 Garfield Washington 53023 388 7
2424494 2424494 2022-04-19 Garfield Washington 53023 388 7
2421238 2421238 2022-04-18 Garfield Washington 53023 388 7
2417982 2417982 2022-04-17 Garfield Washington 53023 388 7
2414726 2414726 2022-04-16 Garfield Washington 53023 388 7
2411470 2411470 2022-04-15 Garfield Washington 53023 388 7
2408214 2408214 2022-04-14 Garfield Washington 53023 386 7
2404958 2404958 2022-04-13 Garfield Washington 53023 386 7
2401703 2401703 2022-04-12 Garfield Washington 53023 386 7
2398448 2398448 2022-04-11 Garfield Washington 53023 386 7
2395193 2395193 2022-04-10 Garfield Washington 53023 386 7
2391937 2391937 2022-04-09 Garfield Washington 53023 386 7
2388681 2388681 2022-04-08 Garfield Washington 53023 386 7
2385426 2385426 2022-04-07 Garfield Washington 53023 386 7
2382171 2382171 2022-04-06 Garfield Washington 53023 386 7
2378916 2378916 2022-04-05 Garfield Washington 53023 386 7
2375662 2375662 2022-04-04 Garfield Washington 53023 386 7
2372410 2372410 2022-04-03 Garfield Washington 53023 386 7
2369157 2369157 2022-04-02 Garfield Washington 53023 386 7
2365904 2365904 2022-04-01 Garfield Washington 53023 386 7
2362651 2362651 2022-03-31 Garfield Washington 53023 386 7
2359397 2359397 2022-03-30 Garfield Washington 53023 386 7
2356143 2356143 2022-03-29 Garfield Washington 53023 385 7
2352890 2352890 2022-03-28 Garfield Washington 53023 385 7
2349638 2349638 2022-03-27 Garfield Washington 53023 385 7
2346385 2346385 2022-03-26 Garfield Washington 53023 385 7
2343132 2343132 2022-03-25 Garfield Washington 53023 385 7
2339879 2339879 2022-03-24 Garfield Washington 53023 385 7
2336626 2336626 2022-03-23 Garfield Washington 53023 385 7
2333372 2333372 2022-03-22 Garfield Washington 53023 385 7
2330118 2330118 2022-03-21 Garfield Washington 53023 385 7
2326866 2326866 2022-03-20 Garfield Washington 53023 384 7
2323613 2323613 2022-03-19 Garfield Washington 53023 384 7
2320359 2320359 2022-03-18 Garfield Washington 53023 384 7
2317105 2317105 2022-03-17 Garfield Washington 53023 384 7
2313852 2313852 2022-03-16 Garfield Washington 53023 384 7
2310599 2310599 2022-03-15 Garfield Washington 53023 384 7
2307346 2307346 2022-03-14 Garfield Washington 53023 384 7
2304095 2304095 2022-03-13 Garfield Washington 53023 384 7
2300843 2300843 2022-03-12 Garfield Washington 53023 384 7
2297591 2297591 2022-03-11 Garfield Washington 53023 384 7
2294339 2294339 2022-03-10 Garfield Washington 53023 383 7
2291087 2291087 2022-03-09 Garfield Washington 53023 383 7
2287835 2287835 2022-03-08 Garfield Washington 53023 383 7
2284583 2284583 2022-03-07 Garfield Washington 53023 383 7
2281331 2281331 2022-03-06 Garfield Washington 53023 383 7
2278078 2278078 2022-03-05 Garfield Washington 53023 383 7
2274825 2274825 2022-03-04 Garfield Washington 53023 383 7
2271572 2271572 2022-03-03 Garfield Washington 53023 383 7
2268320 2268320 2022-03-02 Garfield Washington 53023 383 7
2265067 2265067 2022-03-01 Garfield Washington 53023 383 7
2261817 2261817 2022-02-28 Garfield Washington 53023 383 7
2258566 2258566 2022-02-27 Garfield Washington 53023 383 7
2255315 2255315 2022-02-26 Garfield Washington 53023 383 7
2252064 2252064 2022-02-25 Garfield Washington 53023 383 7
2248813 2248813 2022-02-24 Garfield Washington 53023 384 7
2245562 2245562 2022-02-23 Garfield Washington 53023 384 7
2242311 2242311 2022-02-22 Garfield Washington 53023 376 7
2239060 2239060 2022-02-21 Garfield Washington 53023 376 7
2235809 2235809 2022-02-20 Garfield Washington 53023 376 7
2232558 2232558 2022-02-19 Garfield Washington 53023 376 7
2229307 2229307 2022-02-18 Garfield Washington 53023 376 7
2226056 2226056 2022-02-17 Garfield Washington 53023 375 7
2222805 2222805 2022-02-16 Garfield Washington 53023 375 7
2219554 2219554 2022-02-15 Garfield Washington 53023 369 7
2216304 2216304 2022-02-14 Garfield Washington 53023 369 7
2213053 2213053 2022-02-13 Garfield Washington 53023 365 7
2209800 2209800 2022-02-12 Garfield Washington 53023 365 7
2206547 2206547 2022-02-11 Garfield Washington 53023 365 7
2203294 2203294 2022-02-10 Garfield Washington 53023 362 7
2200040 2200040 2022-02-09 Garfield Washington 53023 362 7
2196786 2196786 2022-02-08 Garfield Washington 53023 356 7
2193531 2193531 2022-02-07 Garfield Washington 53023 356 7
2190278 2190278 2022-02-06 Garfield Washington 53023 349 7
2187025 2187025 2022-02-05 Garfield Washington 53023 349 7
2183772 2183772 2022-02-04 Garfield Washington 53023 349 7
2180520 2180520 2022-02-03 Garfield Washington 53023 343 7

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