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

1,474 rows where county = "Dewey" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Dewey · 1,474 ✖
Link rowid date ▲ county state fips cases deaths
2501754 2501754 2022-05-13 Dewey Oklahoma 40043 1064 32
2502064 2502064 2022-05-13 Dewey South Dakota 46041 3139 44
2498496 2498496 2022-05-12 Dewey Oklahoma 40043 1064 32
2498806 2498806 2022-05-12 Dewey South Dakota 46041 3139 44
2495238 2495238 2022-05-11 Dewey Oklahoma 40043 1063 32
2495548 2495548 2022-05-11 Dewey South Dakota 46041 3139 44
2491980 2491980 2022-05-10 Dewey Oklahoma 40043 1063 32
2492290 2492290 2022-05-10 Dewey South Dakota 46041 3137 44
2488722 2488722 2022-05-09 Dewey Oklahoma 40043 1063 32
2489032 2489032 2022-05-09 Dewey South Dakota 46041 3137 44
2485465 2485465 2022-05-08 Dewey Oklahoma 40043 1063 32
2485775 2485775 2022-05-08 Dewey South Dakota 46041 3137 44
2482207 2482207 2022-05-07 Dewey Oklahoma 40043 1063 32
2482517 2482517 2022-05-07 Dewey South Dakota 46041 3137 44
2478949 2478949 2022-05-06 Dewey Oklahoma 40043 1063 32
2479259 2479259 2022-05-06 Dewey South Dakota 46041 3137 44
2475691 2475691 2022-05-05 Dewey Oklahoma 40043 1063 32
2476001 2476001 2022-05-05 Dewey South Dakota 46041 3137 44
2472434 2472434 2022-05-04 Dewey Oklahoma 40043 1063 31
2472744 2472744 2022-05-04 Dewey South Dakota 46041 3137 44
2469178 2469178 2022-05-03 Dewey Oklahoma 40043 1063 31
2469488 2469488 2022-05-03 Dewey South Dakota 46041 3136 44
2465922 2465922 2022-05-02 Dewey Oklahoma 40043 1063 31
2466232 2466232 2022-05-02 Dewey South Dakota 46041 3136 44
2462667 2462667 2022-05-01 Dewey Oklahoma 40043 1063 31
2462977 2462977 2022-05-01 Dewey South Dakota 46041 3136 44
2459411 2459411 2022-04-30 Dewey Oklahoma 40043 1063 31
2459721 2459721 2022-04-30 Dewey South Dakota 46041 3136 44
2456155 2456155 2022-04-29 Dewey Oklahoma 40043 1063 31
2456465 2456465 2022-04-29 Dewey South Dakota 46041 3136 44
2452899 2452899 2022-04-28 Dewey Oklahoma 40043 1063 31
2453209 2453209 2022-04-28 Dewey South Dakota 46041 3136 44
2449643 2449643 2022-04-27 Dewey Oklahoma 40043 1062 31
2449953 2449953 2022-04-27 Dewey South Dakota 46041 3136 44
2446386 2446386 2022-04-26 Dewey Oklahoma 40043 1062 31
2446696 2446696 2022-04-26 Dewey South Dakota 46041 3136 43
2443131 2443131 2022-04-25 Dewey Oklahoma 40043 1062 31
2443441 2443441 2022-04-25 Dewey South Dakota 46041 3136 43
2439875 2439875 2022-04-24 Dewey Oklahoma 40043 1062 31
2440185 2440185 2022-04-24 Dewey South Dakota 46041 3136 43
2436619 2436619 2022-04-23 Dewey Oklahoma 40043 1062 31
2436929 2436929 2022-04-23 Dewey South Dakota 46041 3136 43
2433363 2433363 2022-04-22 Dewey Oklahoma 40043 1062 31
2433673 2433673 2022-04-22 Dewey South Dakota 46041 3136 43
2430107 2430107 2022-04-21 Dewey Oklahoma 40043 1062 31
2430417 2430417 2022-04-21 Dewey South Dakota 46041 3136 43
2426851 2426851 2022-04-20 Dewey Oklahoma 40043 1060 31
2427161 2427161 2022-04-20 Dewey South Dakota 46041 3136 43
2423595 2423595 2022-04-19 Dewey Oklahoma 40043 1060 31
2423905 2423905 2022-04-19 Dewey South Dakota 46041 3136 42
2420338 2420338 2022-04-18 Dewey Oklahoma 40043 1060 31
2420649 2420649 2022-04-18 Dewey South Dakota 46041 3136 42
2417083 2417083 2022-04-17 Dewey Oklahoma 40043 1060 31
2417393 2417393 2022-04-17 Dewey South Dakota 46041 3136 42
2413827 2413827 2022-04-16 Dewey Oklahoma 40043 1060 31
2414137 2414137 2022-04-16 Dewey South Dakota 46041 3136 42
2410571 2410571 2022-04-15 Dewey Oklahoma 40043 1060 31
2410881 2410881 2022-04-15 Dewey South Dakota 46041 3136 42
2407315 2407315 2022-04-14 Dewey Oklahoma 40043 1060 31
2407625 2407625 2022-04-14 Dewey South Dakota 46041 3136 42
2404059 2404059 2022-04-13 Dewey Oklahoma 40043 1063 31
2404369 2404369 2022-04-13 Dewey South Dakota 46041 3136 42
2400804 2400804 2022-04-12 Dewey Oklahoma 40043 1063 31
2401114 2401114 2022-04-12 Dewey South Dakota 46041 3137 42
2397549 2397549 2022-04-11 Dewey Oklahoma 40043 1063 31
2397859 2397859 2022-04-11 Dewey South Dakota 46041 3137 42
2394294 2394294 2022-04-10 Dewey Oklahoma 40043 1063 31
2394604 2394604 2022-04-10 Dewey South Dakota 46041 3137 42
2391038 2391038 2022-04-09 Dewey Oklahoma 40043 1063 31
2391348 2391348 2022-04-09 Dewey South Dakota 46041 3137 42
2387782 2387782 2022-04-08 Dewey Oklahoma 40043 1063 31
2388092 2388092 2022-04-08 Dewey South Dakota 46041 3137 42
2384527 2384527 2022-04-07 Dewey Oklahoma 40043 1063 31
2384837 2384837 2022-04-07 Dewey South Dakota 46041 3137 42
2381272 2381272 2022-04-06 Dewey Oklahoma 40043 1062 29
2381582 2381582 2022-04-06 Dewey South Dakota 46041 3137 42
2378017 2378017 2022-04-05 Dewey Oklahoma 40043 1062 29
2378327 2378327 2022-04-05 Dewey South Dakota 46041 3139 42
2374763 2374763 2022-04-04 Dewey Oklahoma 40043 1062 29
2375073 2375073 2022-04-04 Dewey South Dakota 46041 3139 42
2371511 2371511 2022-04-03 Dewey Oklahoma 40043 1062 29
2371821 2371821 2022-04-03 Dewey South Dakota 46041 3139 42
2368258 2368258 2022-04-02 Dewey Oklahoma 40043 1062 29
2368568 2368568 2022-04-02 Dewey South Dakota 46041 3139 42
2365005 2365005 2022-04-01 Dewey Oklahoma 40043 1062 29
2365315 2365315 2022-04-01 Dewey South Dakota 46041 3139 42
2361752 2361752 2022-03-31 Dewey Oklahoma 40043 1062 29
2362062 2362062 2022-03-31 Dewey South Dakota 46041 3139 42
2358498 2358498 2022-03-30 Dewey Oklahoma 40043 1061 29
2358808 2358808 2022-03-30 Dewey South Dakota 46041 3139 42
2355244 2355244 2022-03-29 Dewey Oklahoma 40043 1061 29
2355554 2355554 2022-03-29 Dewey South Dakota 46041 3137 42
2351991 2351991 2022-03-28 Dewey Oklahoma 40043 1061 29
2352301 2352301 2022-03-28 Dewey South Dakota 46041 3137 42
2348739 2348739 2022-03-27 Dewey Oklahoma 40043 1061 29
2349049 2349049 2022-03-27 Dewey South Dakota 46041 3137 42
2345486 2345486 2022-03-26 Dewey Oklahoma 40043 1061 29
2345796 2345796 2022-03-26 Dewey South Dakota 46041 3137 42
2342233 2342233 2022-03-25 Dewey Oklahoma 40043 1061 29
2342543 2342543 2022-03-25 Dewey South Dakota 46041 3137 42

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