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

707 rows where county = "Dewey" and fips = 46041 sorted by date descending

✎ View and edit SQL

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

state 1

fips 1

  • 46041 · 707 ✖

county 1

  • Dewey · 707 ✖
Link rowid date ▲ county state fips cases deaths
2502064 2502064 2022-05-13 Dewey South Dakota 46041 3139 44
2498806 2498806 2022-05-12 Dewey South Dakota 46041 3139 44
2495548 2495548 2022-05-11 Dewey South Dakota 46041 3139 44
2492290 2492290 2022-05-10 Dewey South Dakota 46041 3137 44
2489032 2489032 2022-05-09 Dewey South Dakota 46041 3137 44
2485775 2485775 2022-05-08 Dewey South Dakota 46041 3137 44
2482517 2482517 2022-05-07 Dewey South Dakota 46041 3137 44
2479259 2479259 2022-05-06 Dewey South Dakota 46041 3137 44
2476001 2476001 2022-05-05 Dewey South Dakota 46041 3137 44
2472744 2472744 2022-05-04 Dewey South Dakota 46041 3137 44
2469488 2469488 2022-05-03 Dewey South Dakota 46041 3136 44
2466232 2466232 2022-05-02 Dewey South Dakota 46041 3136 44
2462977 2462977 2022-05-01 Dewey South Dakota 46041 3136 44
2459721 2459721 2022-04-30 Dewey South Dakota 46041 3136 44
2456465 2456465 2022-04-29 Dewey South Dakota 46041 3136 44
2453209 2453209 2022-04-28 Dewey South Dakota 46041 3136 44
2449953 2449953 2022-04-27 Dewey South Dakota 46041 3136 44
2446696 2446696 2022-04-26 Dewey South Dakota 46041 3136 43
2443441 2443441 2022-04-25 Dewey South Dakota 46041 3136 43
2440185 2440185 2022-04-24 Dewey South Dakota 46041 3136 43
2436929 2436929 2022-04-23 Dewey South Dakota 46041 3136 43
2433673 2433673 2022-04-22 Dewey South Dakota 46041 3136 43
2430417 2430417 2022-04-21 Dewey South Dakota 46041 3136 43
2427161 2427161 2022-04-20 Dewey South Dakota 46041 3136 43
2423905 2423905 2022-04-19 Dewey South Dakota 46041 3136 42
2420649 2420649 2022-04-18 Dewey South Dakota 46041 3136 42
2417393 2417393 2022-04-17 Dewey South Dakota 46041 3136 42
2414137 2414137 2022-04-16 Dewey South Dakota 46041 3136 42
2410881 2410881 2022-04-15 Dewey South Dakota 46041 3136 42
2407625 2407625 2022-04-14 Dewey South Dakota 46041 3136 42
2404369 2404369 2022-04-13 Dewey South Dakota 46041 3136 42
2401114 2401114 2022-04-12 Dewey South Dakota 46041 3137 42
2397859 2397859 2022-04-11 Dewey South Dakota 46041 3137 42
2394604 2394604 2022-04-10 Dewey South Dakota 46041 3137 42
2391348 2391348 2022-04-09 Dewey South Dakota 46041 3137 42
2388092 2388092 2022-04-08 Dewey South Dakota 46041 3137 42
2384837 2384837 2022-04-07 Dewey South Dakota 46041 3137 42
2381582 2381582 2022-04-06 Dewey South Dakota 46041 3137 42
2378327 2378327 2022-04-05 Dewey South Dakota 46041 3139 42
2375073 2375073 2022-04-04 Dewey South Dakota 46041 3139 42
2371821 2371821 2022-04-03 Dewey South Dakota 46041 3139 42
2368568 2368568 2022-04-02 Dewey South Dakota 46041 3139 42
2365315 2365315 2022-04-01 Dewey South Dakota 46041 3139 42
2362062 2362062 2022-03-31 Dewey South Dakota 46041 3139 42
2358808 2358808 2022-03-30 Dewey South Dakota 46041 3139 42
2355554 2355554 2022-03-29 Dewey South Dakota 46041 3137 42
2352301 2352301 2022-03-28 Dewey South Dakota 46041 3137 42
2349049 2349049 2022-03-27 Dewey South Dakota 46041 3137 42
2345796 2345796 2022-03-26 Dewey South Dakota 46041 3137 42
2342543 2342543 2022-03-25 Dewey South Dakota 46041 3137 42
2339290 2339290 2022-03-24 Dewey South Dakota 46041 3137 42
2336036 2336036 2022-03-23 Dewey South Dakota 46041 3137 42
2332782 2332782 2022-03-22 Dewey South Dakota 46041 3134 42
2329529 2329529 2022-03-21 Dewey South Dakota 46041 3134 42
2326277 2326277 2022-03-20 Dewey South Dakota 46041 3134 42
2323024 2323024 2022-03-19 Dewey South Dakota 46041 3134 42
2319770 2319770 2022-03-18 Dewey South Dakota 46041 3134 42
2316516 2316516 2022-03-17 Dewey South Dakota 46041 3134 42
2313263 2313263 2022-03-16 Dewey South Dakota 46041 3134 42
2310010 2310010 2022-03-15 Dewey South Dakota 46041 3132 40
2306757 2306757 2022-03-14 Dewey South Dakota 46041 3133 40
2303506 2303506 2022-03-13 Dewey South Dakota 46041 3130 40
2300254 2300254 2022-03-12 Dewey South Dakota 46041 3130 40
2297002 2297002 2022-03-11 Dewey South Dakota 46041 3130 40
2293750 2293750 2022-03-10 Dewey South Dakota 46041 3131 40
2290498 2290498 2022-03-09 Dewey South Dakota 46041 3134 40
2287246 2287246 2022-03-08 Dewey South Dakota 46041 3134 40
2283994 2283994 2022-03-07 Dewey South Dakota 46041 3132 40
2280742 2280742 2022-03-06 Dewey South Dakota 46041 3130 40
2277489 2277489 2022-03-05 Dewey South Dakota 46041 3130 40
2274236 2274236 2022-03-04 Dewey South Dakota 46041 3130 40
2270983 2270983 2022-03-03 Dewey South Dakota 46041 3130 39
2267731 2267731 2022-03-02 Dewey South Dakota 46041 3127 39
2264478 2264478 2022-03-01 Dewey South Dakota 46041 3126 39
2261228 2261228 2022-02-28 Dewey South Dakota 46041 3124 39
2257977 2257977 2022-02-27 Dewey South Dakota 46041 3119 39
2254726 2254726 2022-02-26 Dewey South Dakota 46041 3119 39
2251475 2251475 2022-02-25 Dewey South Dakota 46041 3119 39
2248224 2248224 2022-02-24 Dewey South Dakota 46041 3117 39
2244973 2244973 2022-02-23 Dewey South Dakota 46041 3119 39
2241722 2241722 2022-02-22 Dewey South Dakota 46041 3114 38
2238471 2238471 2022-02-21 Dewey South Dakota 46041 3110 38
2235220 2235220 2022-02-20 Dewey South Dakota 46041 3110 38
2231969 2231969 2022-02-19 Dewey South Dakota 46041 3110 38
2228718 2228718 2022-02-18 Dewey South Dakota 46041 3110 38
2225467 2225467 2022-02-17 Dewey South Dakota 46041 2551 38
2222216 2222216 2022-02-16 Dewey South Dakota 46041 2431 38
2218965 2218965 2022-02-15 Dewey South Dakota 46041 2428 38
2215714 2215714 2022-02-14 Dewey South Dakota 46041 2423 38
2212463 2212463 2022-02-13 Dewey South Dakota 46041 2420 38
2209210 2209210 2022-02-12 Dewey South Dakota 46041 2420 38
2205957 2205957 2022-02-11 Dewey South Dakota 46041 2420 38
2202704 2202704 2022-02-10 Dewey South Dakota 46041 2418 38
2199450 2199450 2022-02-09 Dewey South Dakota 46041 2417 38
2196196 2196196 2022-02-08 Dewey South Dakota 46041 2414 38
2192942 2192942 2022-02-07 Dewey South Dakota 46041 2409 38
2189688 2189688 2022-02-06 Dewey South Dakota 46041 2407 38
2186435 2186435 2022-02-05 Dewey South Dakota 46041 2407 38
2183183 2183183 2022-02-04 Dewey South Dakota 46041 2407 38
2179931 2179931 2022-02-03 Dewey South Dakota 46041 2404 38

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