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

797 rows where county = "Douglas", fips = 41019 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 · 797 ✖

fips 1

  • 41019 · 797 ✖

county 1

  • Douglas · 797 ✖
Link rowid date ▲ county state fips cases deaths
2501820 2501820 2022-05-13 Douglas Oregon 41019 20020 396
2498562 2498562 2022-05-12 Douglas Oregon 41019 19991 396
2495304 2495304 2022-05-11 Douglas Oregon 41019 19977 393
2492046 2492046 2022-05-10 Douglas Oregon 41019 19950 392
2488788 2488788 2022-05-09 Douglas Oregon 41019 19927 392
2485531 2485531 2022-05-08 Douglas Oregon 41019 19912 392
2482273 2482273 2022-05-07 Douglas Oregon 41019 19912 392
2479015 2479015 2022-05-06 Douglas Oregon 41019 19912 392
2475757 2475757 2022-05-05 Douglas Oregon 41019 19902 392
2472500 2472500 2022-05-04 Douglas Oregon 41019 19892 392
2469244 2469244 2022-05-03 Douglas Oregon 41019 19878 392
2465988 2465988 2022-05-02 Douglas Oregon 41019 19862 392
2462733 2462733 2022-05-01 Douglas Oregon 41019 19837 392
2459477 2459477 2022-04-30 Douglas Oregon 41019 19837 392
2456221 2456221 2022-04-29 Douglas Oregon 41019 19837 392
2452965 2452965 2022-04-28 Douglas Oregon 41019 19822 392
2449709 2449709 2022-04-27 Douglas Oregon 41019 19812 391
2446452 2446452 2022-04-26 Douglas Oregon 41019 19806 390
2443197 2443197 2022-04-25 Douglas Oregon 41019 19799 390
2439941 2439941 2022-04-24 Douglas Oregon 41019 19796 390
2436685 2436685 2022-04-23 Douglas Oregon 41019 19796 390
2433429 2433429 2022-04-22 Douglas Oregon 41019 19796 390
2430173 2430173 2022-04-21 Douglas Oregon 41019 19792 390
2426917 2426917 2022-04-20 Douglas Oregon 41019 19783 390
2423661 2423661 2022-04-19 Douglas Oregon 41019 19775 390
2420404 2420404 2022-04-18 Douglas Oregon 41019 19762 389
2417149 2417149 2022-04-17 Douglas Oregon 41019 19762 389
2413893 2413893 2022-04-16 Douglas Oregon 41019 19762 389
2410637 2410637 2022-04-15 Douglas Oregon 41019 19762 389
2407381 2407381 2022-04-14 Douglas Oregon 41019 19760 387
2404125 2404125 2022-04-13 Douglas Oregon 41019 19757 385
2400870 2400870 2022-04-12 Douglas Oregon 41019 19754 385
2397615 2397615 2022-04-11 Douglas Oregon 41019 19752 385
2394360 2394360 2022-04-10 Douglas Oregon 41019 19747 384
2391104 2391104 2022-04-09 Douglas Oregon 41019 19747 384
2387848 2387848 2022-04-08 Douglas Oregon 41019 19747 384
2384593 2384593 2022-04-07 Douglas Oregon 41019 19745 384
2381338 2381338 2022-04-06 Douglas Oregon 41019 19739 380
2378083 2378083 2022-04-05 Douglas Oregon 41019 19737 380
2374829 2374829 2022-04-04 Douglas Oregon 41019 19732 380
2371577 2371577 2022-04-03 Douglas Oregon 41019 19726 380
2368324 2368324 2022-04-02 Douglas Oregon 41019 19726 380
2365071 2365071 2022-04-01 Douglas Oregon 41019 19726 380
2361818 2361818 2022-03-31 Douglas Oregon 41019 19723 380
2358564 2358564 2022-03-30 Douglas Oregon 41019 19721 380
2355310 2355310 2022-03-29 Douglas Oregon 41019 19712 380
2352057 2352057 2022-03-28 Douglas Oregon 41019 19701 380
2348805 2348805 2022-03-27 Douglas Oregon 41019 19692 379
2345552 2345552 2022-03-26 Douglas Oregon 41019 19692 379
2342299 2342299 2022-03-25 Douglas Oregon 41019 19692 379
2339046 2339046 2022-03-24 Douglas Oregon 41019 19682 379
2335792 2335792 2022-03-23 Douglas Oregon 41019 19672 379
2332538 2332538 2022-03-22 Douglas Oregon 41019 19665 379
2329285 2329285 2022-03-21 Douglas Oregon 41019 19659 378
2326033 2326033 2022-03-20 Douglas Oregon 41019 19656 378
2322780 2322780 2022-03-19 Douglas Oregon 41019 19656 378
2319526 2319526 2022-03-18 Douglas Oregon 41019 19656 378
2316272 2316272 2022-03-17 Douglas Oregon 41019 19650 378
2313019 2313019 2022-03-16 Douglas Oregon 41019 19639 378
2309766 2309766 2022-03-15 Douglas Oregon 41019 19624 374
2306513 2306513 2022-03-14 Douglas Oregon 41019 19614 373
2303262 2303262 2022-03-13 Douglas Oregon 41019 19599 373
2300010 2300010 2022-03-12 Douglas Oregon 41019 19599 373
2296758 2296758 2022-03-11 Douglas Oregon 41019 19599 373
2293506 2293506 2022-03-10 Douglas Oregon 41019 19574 373
2290254 2290254 2022-03-09 Douglas Oregon 41019 19562 373
2287002 2287002 2022-03-08 Douglas Oregon 41019 19548 372
2283750 2283750 2022-03-07 Douglas Oregon 41019 19531 372
2280498 2280498 2022-03-06 Douglas Oregon 41019 19493 372
2277245 2277245 2022-03-05 Douglas Oregon 41019 19493 372
2273992 2273992 2022-03-04 Douglas Oregon 41019 19493 372
2270739 2270739 2022-03-03 Douglas Oregon 41019 19473 370
2267487 2267487 2022-03-02 Douglas Oregon 41019 19449 368
2264234 2264234 2022-03-01 Douglas Oregon 41019 19430 368
2260984 2260984 2022-02-28 Douglas Oregon 41019 19395 366
2257733 2257733 2022-02-27 Douglas Oregon 41019 19347 364
2254482 2254482 2022-02-26 Douglas Oregon 41019 19347 364
2251231 2251231 2022-02-25 Douglas Oregon 41019 19347 364
2247980 2247980 2022-02-24 Douglas Oregon 41019 19315 364
2244729 2244729 2022-02-23 Douglas Oregon 41019 19288 363
2241478 2241478 2022-02-22 Douglas Oregon 41019 19247 360
2238227 2238227 2022-02-21 Douglas Oregon 41019 19137 359
2234976 2234976 2022-02-20 Douglas Oregon 41019 19137 359
2231725 2231725 2022-02-19 Douglas Oregon 41019 19137 359
2228474 2228474 2022-02-18 Douglas Oregon 41019 19137 359
2225223 2225223 2022-02-17 Douglas Oregon 41019 19074 357
2221972 2221972 2022-02-16 Douglas Oregon 41019 19027 353
2218721 2218721 2022-02-15 Douglas Oregon 41019 18978 350
2215470 2215470 2022-02-14 Douglas Oregon 41019 18892 350
2212219 2212219 2022-02-13 Douglas Oregon 41019 18798 345
2208966 2208966 2022-02-12 Douglas Oregon 41019 18798 345
2205713 2205713 2022-02-11 Douglas Oregon 41019 18798 345
2202460 2202460 2022-02-10 Douglas Oregon 41019 18747 345
2199206 2199206 2022-02-09 Douglas Oregon 41019 18641 344
2195952 2195952 2022-02-08 Douglas Oregon 41019 18560 344
2192698 2192698 2022-02-07 Douglas Oregon 41019 18401 342
2189444 2189444 2022-02-06 Douglas Oregon 41019 18219 339
2186191 2186191 2022-02-05 Douglas Oregon 41019 18219 339
2182939 2182939 2022-02-04 Douglas Oregon 41019 18219 339
2179687 2179687 2022-02-03 Douglas Oregon 41019 18140 338

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