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

806 rows where county = "Washington", fips = 41067 and state = "Oregon" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Oregon · 806 ✖

fips 1

  • 41067 · 806 ✖

county 1

  • Washington · 806 ✖
Link rowid date ▲ county state fips cases deaths
2501844 2501844 2022-05-13 Washington Oregon 41067 91092 594
2498586 2498586 2022-05-12 Washington Oregon 41067 90808 594
2495328 2495328 2022-05-11 Washington Oregon 41067 90426 594
2492070 2492070 2022-05-10 Washington Oregon 41067 90141 594
2488812 2488812 2022-05-09 Washington Oregon 41067 89883 593
2485555 2485555 2022-05-08 Washington Oregon 41067 89346 593
2482297 2482297 2022-05-07 Washington Oregon 41067 89346 593
2479039 2479039 2022-05-06 Washington Oregon 41067 89346 593
2475781 2475781 2022-05-05 Washington Oregon 41067 89155 592
2472524 2472524 2022-05-04 Washington Oregon 41067 88785 591
2469268 2469268 2022-05-03 Washington Oregon 41067 88522 589
2466012 2466012 2022-05-02 Washington Oregon 41067 88231 588
2462757 2462757 2022-05-01 Washington Oregon 41067 87891 588
2459501 2459501 2022-04-30 Washington Oregon 41067 87891 588
2456245 2456245 2022-04-29 Washington Oregon 41067 87891 588
2452989 2452989 2022-04-28 Washington Oregon 41067 87628 588
2449733 2449733 2022-04-27 Washington Oregon 41067 87430 588
2446476 2446476 2022-04-26 Washington Oregon 41067 87233 588
2443221 2443221 2022-04-25 Washington Oregon 41067 87075 588
2439965 2439965 2022-04-24 Washington Oregon 41067 86652 588
2436709 2436709 2022-04-23 Washington Oregon 41067 86652 588
2433453 2433453 2022-04-22 Washington Oregon 41067 86652 588
2430197 2430197 2022-04-21 Washington Oregon 41067 86529 588
2426941 2426941 2022-04-20 Washington Oregon 41067 86365 588
2423685 2423685 2022-04-19 Washington Oregon 41067 86205 586
2420429 2420429 2022-04-18 Washington Oregon 41067 85814 585
2417173 2417173 2022-04-17 Washington Oregon 41067 85814 585
2413917 2413917 2022-04-16 Washington Oregon 41067 85814 585
2410661 2410661 2022-04-15 Washington Oregon 41067 85814 585
2407405 2407405 2022-04-14 Washington Oregon 41067 85756 585
2404149 2404149 2022-04-13 Washington Oregon 41067 85645 584
2400894 2400894 2022-04-12 Washington Oregon 41067 85575 584
2397639 2397639 2022-04-11 Washington Oregon 41067 85513 571
2394384 2394384 2022-04-10 Washington Oregon 41067 85374 570
2391128 2391128 2022-04-09 Washington Oregon 41067 85374 570
2387872 2387872 2022-04-08 Washington Oregon 41067 85374 570
2384617 2384617 2022-04-07 Washington Oregon 41067 85300 567
2381362 2381362 2022-04-06 Washington Oregon 41067 85237 562
2378107 2378107 2022-04-05 Washington Oregon 41067 85203 562
2374853 2374853 2022-04-04 Washington Oregon 41067 85181 561
2371601 2371601 2022-04-03 Washington Oregon 41067 85081 553
2368348 2368348 2022-04-02 Washington Oregon 41067 85081 553
2365095 2365095 2022-04-01 Washington Oregon 41067 85081 553
2361842 2361842 2022-03-31 Washington Oregon 41067 85037 553
2358588 2358588 2022-03-30 Washington Oregon 41067 84993 553
2355334 2355334 2022-03-29 Washington Oregon 41067 84955 552
2352081 2352081 2022-03-28 Washington Oregon 41067 84928 549
2348829 2348829 2022-03-27 Washington Oregon 41067 84989 546
2345576 2345576 2022-03-26 Washington Oregon 41067 84989 546
2342323 2342323 2022-03-25 Washington Oregon 41067 84989 546
2339070 2339070 2022-03-24 Washington Oregon 41067 84971 546
2335816 2335816 2022-03-23 Washington Oregon 41067 84952 540
2332562 2332562 2022-03-22 Washington Oregon 41067 84907 538
2329309 2329309 2022-03-21 Washington Oregon 41067 84880 538
2326057 2326057 2022-03-20 Washington Oregon 41067 84800 538
2322804 2322804 2022-03-19 Washington Oregon 41067 84800 538
2319550 2319550 2022-03-18 Washington Oregon 41067 84800 538
2316296 2316296 2022-03-17 Washington Oregon 41067 84813 538
2313043 2313043 2022-03-16 Washington Oregon 41067 84804 538
2309790 2309790 2022-03-15 Washington Oregon 41067 84800 537
2306537 2306537 2022-03-14 Washington Oregon 41067 84739 535
2303286 2303286 2022-03-13 Washington Oregon 41067 84650 531
2300034 2300034 2022-03-12 Washington Oregon 41067 84650 531
2296782 2296782 2022-03-11 Washington Oregon 41067 84650 531
2293530 2293530 2022-03-10 Washington Oregon 41067 84631 530
2290278 2290278 2022-03-09 Washington Oregon 41067 84554 524
2287026 2287026 2022-03-08 Washington Oregon 41067 84518 519
2283774 2283774 2022-03-07 Washington Oregon 41067 84510 515
2280522 2280522 2022-03-06 Washington Oregon 41067 84400 511
2277269 2277269 2022-03-05 Washington Oregon 41067 84400 511
2274016 2274016 2022-03-04 Washington Oregon 41067 84400 511
2270763 2270763 2022-03-03 Washington Oregon 41067 84327 511
2267511 2267511 2022-03-02 Washington Oregon 41067 84248 507
2264258 2264258 2022-03-01 Washington Oregon 41067 84158 507
2261008 2261008 2022-02-28 Washington Oregon 41067 84093 506
2257757 2257757 2022-02-27 Washington Oregon 41067 83858 503
2254506 2254506 2022-02-26 Washington Oregon 41067 83858 503
2251255 2251255 2022-02-25 Washington Oregon 41067 83858 503
2248004 2248004 2022-02-24 Washington Oregon 41067 83752 502
2244753 2244753 2022-02-23 Washington Oregon 41067 83621 497
2241502 2241502 2022-02-22 Washington Oregon 41067 83478 496
2238251 2238251 2022-02-21 Washington Oregon 41067 83057 492
2235000 2235000 2022-02-20 Washington Oregon 41067 83057 492
2231749 2231749 2022-02-19 Washington Oregon 41067 83057 492
2228498 2228498 2022-02-18 Washington Oregon 41067 83057 492
2225247 2225247 2022-02-17 Washington Oregon 41067 82907 491
2221996 2221996 2022-02-16 Washington Oregon 41067 82681 490
2218745 2218745 2022-02-15 Washington Oregon 41067 82489 486
2215494 2215494 2022-02-14 Washington Oregon 41067 82348 486
2212243 2212243 2022-02-13 Washington Oregon 41067 81721 486
2208990 2208990 2022-02-12 Washington Oregon 41067 81721 486
2205737 2205737 2022-02-11 Washington Oregon 41067 81721 486
2202484 2202484 2022-02-10 Washington Oregon 41067 81413 486
2199230 2199230 2022-02-09 Washington Oregon 41067 80994 485
2195976 2195976 2022-02-08 Washington Oregon 41067 80626 483
2192722 2192722 2022-02-07 Washington Oregon 41067 80277 483
2189468 2189468 2022-02-06 Washington Oregon 41067 79186 482
2186215 2186215 2022-02-05 Washington Oregon 41067 79186 482
2182963 2182963 2022-02-04 Washington Oregon 41067 79186 482
2179711 2179711 2022-02-03 Washington Oregon 41067 78447 481

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