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

787 rows where county = "Benton" 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 · 787 ✖

fips 1

county 1

  • Benton · 787 ✖
Link rowid date ▲ county state fips cases deaths
2502645 2502645 2022-05-13 Benton Washington 53005 53006 472
2499387 2499387 2022-05-12 Benton Washington 53005 52943 472
2496129 2496129 2022-05-11 Benton Washington 53005 52943 472
2492871 2492871 2022-05-10 Benton Washington 53005 52896 470
2489613 2489613 2022-05-09 Benton Washington 53005 52896 470
2486356 2486356 2022-05-08 Benton Washington 53005 52801 470
2483098 2483098 2022-05-07 Benton Washington 53005 52801 470
2479840 2479840 2022-05-06 Benton Washington 53005 52801 470
2476582 2476582 2022-05-05 Benton Washington 53005 52801 470
2473324 2473324 2022-05-04 Benton Washington 53005 52801 470
2470068 2470068 2022-05-03 Benton Washington 53005 52834 469
2466812 2466812 2022-05-02 Benton Washington 53005 52834 469
2463557 2463557 2022-05-01 Benton Washington 53005 52716 469
2460301 2460301 2022-04-30 Benton Washington 53005 52716 469
2457045 2457045 2022-04-29 Benton Washington 53005 52716 469
2453789 2453789 2022-04-28 Benton Washington 53005 52666 470
2450533 2450533 2022-04-27 Benton Washington 53005 52666 470
2447277 2447277 2022-04-26 Benton Washington 53005 52622 468
2444021 2444021 2022-04-25 Benton Washington 53005 52622 468
2440765 2440765 2022-04-24 Benton Washington 53005 52566 468
2437509 2437509 2022-04-23 Benton Washington 53005 52566 468
2434253 2434253 2022-04-22 Benton Washington 53005 52566 468
2430997 2430997 2022-04-21 Benton Washington 53005 52537 467
2427741 2427741 2022-04-20 Benton Washington 53005 52537 467
2424485 2424485 2022-04-19 Benton Washington 53005 52516 466
2421229 2421229 2022-04-18 Benton Washington 53005 52516 466
2417973 2417973 2022-04-17 Benton Washington 53005 52493 466
2414717 2414717 2022-04-16 Benton Washington 53005 52493 466
2411461 2411461 2022-04-15 Benton Washington 53005 52493 466
2408205 2408205 2022-04-14 Benton Washington 53005 52472 467
2404949 2404949 2022-04-13 Benton Washington 53005 52472 467
2401694 2401694 2022-04-12 Benton Washington 53005 52408 467
2398439 2398439 2022-04-11 Benton Washington 53005 52408 467
2395184 2395184 2022-04-10 Benton Washington 53005 52408 467
2391928 2391928 2022-04-09 Benton Washington 53005 52408 467
2388672 2388672 2022-04-08 Benton Washington 53005 52408 467
2385417 2385417 2022-04-07 Benton Washington 53005 52355 467
2382162 2382162 2022-04-06 Benton Washington 53005 52355 467
2378907 2378907 2022-04-05 Benton Washington 53005 52327 466
2375653 2375653 2022-04-04 Benton Washington 53005 52327 466
2372401 2372401 2022-04-03 Benton Washington 53005 52309 466
2369148 2369148 2022-04-02 Benton Washington 53005 52309 466
2365895 2365895 2022-04-01 Benton Washington 53005 52309 466
2362642 2362642 2022-03-31 Benton Washington 53005 52286 464
2359388 2359388 2022-03-30 Benton Washington 53005 52286 464
2356134 2356134 2022-03-29 Benton Washington 53005 52256 464
2352881 2352881 2022-03-28 Benton Washington 53005 52256 464
2349629 2349629 2022-03-27 Benton Washington 53005 52233 464
2346376 2346376 2022-03-26 Benton Washington 53005 52233 464
2343123 2343123 2022-03-25 Benton Washington 53005 52233 464
2339870 2339870 2022-03-24 Benton Washington 53005 52187 463
2336617 2336617 2022-03-23 Benton Washington 53005 52187 463
2333363 2333363 2022-03-22 Benton Washington 53005 52140 463
2330109 2330109 2022-03-21 Benton Washington 53005 52140 463
2326857 2326857 2022-03-20 Benton Washington 53005 52113 462
2323604 2323604 2022-03-19 Benton Washington 53005 52113 462
2320350 2320350 2022-03-18 Benton Washington 53005 52113 462
2317096 2317096 2022-03-17 Benton Washington 53005 52063 462
2313843 2313843 2022-03-16 Benton Washington 53005 52063 462
2310590 2310590 2022-03-15 Benton Washington 53005 51941 460
2307337 2307337 2022-03-14 Benton Washington 53005 51941 460
2304086 2304086 2022-03-13 Benton Washington 53005 51898 460
2300834 2300834 2022-03-12 Benton Washington 53005 51898 460
2297582 2297582 2022-03-11 Benton Washington 53005 51898 460
2294330 2294330 2022-03-10 Benton Washington 53005 51837 461
2291078 2291078 2022-03-09 Benton Washington 53005 51837 461
2287826 2287826 2022-03-08 Benton Washington 53005 51659 459
2284574 2284574 2022-03-07 Benton Washington 53005 51659 459
2281322 2281322 2022-03-06 Benton Washington 53005 51592 457
2278069 2278069 2022-03-05 Benton Washington 53005 51592 457
2274816 2274816 2022-03-04 Benton Washington 53005 51592 457
2271563 2271563 2022-03-03 Benton Washington 53005 51523 455
2268311 2268311 2022-03-02 Benton Washington 53005 51523 455
2265058 2265058 2022-03-01 Benton Washington 53005 51320 451
2261808 2261808 2022-02-28 Benton Washington 53005 51320 451
2258557 2258557 2022-02-27 Benton Washington 53005 51170 452
2255306 2255306 2022-02-26 Benton Washington 53005 51170 452
2252055 2252055 2022-02-25 Benton Washington 53005 51170 452
2248804 2248804 2022-02-24 Benton Washington 53005 51150 448
2245553 2245553 2022-02-23 Benton Washington 53005 51150 448
2242302 2242302 2022-02-22 Benton Washington 53005 50809 441
2239051 2239051 2022-02-21 Benton Washington 53005 50809 441
2235800 2235800 2022-02-20 Benton Washington 53005 50809 441
2232549 2232549 2022-02-19 Benton Washington 53005 50809 441
2229298 2229298 2022-02-18 Benton Washington 53005 50809 441
2226047 2226047 2022-02-17 Benton Washington 53005 50897 441
2222796 2222796 2022-02-16 Benton Washington 53005 50897 441
2219545 2219545 2022-02-15 Benton Washington 53005 50875 436
2216295 2216295 2022-02-14 Benton Washington 53005 50875 436
2213044 2213044 2022-02-13 Benton Washington 53005 51082 432
2209791 2209791 2022-02-12 Benton Washington 53005 51082 432
2206538 2206538 2022-02-11 Benton Washington 53005 51082 432
2203285 2203285 2022-02-10 Benton Washington 53005 50474 430
2200031 2200031 2022-02-09 Benton Washington 53005 50474 430
2196777 2196777 2022-02-08 Benton Washington 53005 49921 429
2193522 2193522 2022-02-07 Benton Washington 53005 49921 429
2190269 2190269 2022-02-06 Benton Washington 53005 49620 426
2187016 2187016 2022-02-05 Benton Washington 53005 49620 426
2183763 2183763 2022-02-04 Benton Washington 53005 49620 426
2180511 2180511 2022-02-03 Benton Washington 53005 49289 424

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