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

795 rows where fips = 46005 and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • South Dakota · 795 ✖

fips 1

  • 46005 · 795 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502046 2502046 2022-05-13 Beadle South Dakota 46005 4596 60
2498788 2498788 2022-05-12 Beadle South Dakota 46005 4596 60
2495530 2495530 2022-05-11 Beadle South Dakota 46005 4596 60
2492272 2492272 2022-05-10 Beadle South Dakota 46005 4594 60
2489014 2489014 2022-05-09 Beadle South Dakota 46005 4594 60
2485757 2485757 2022-05-08 Beadle South Dakota 46005 4594 60
2482499 2482499 2022-05-07 Beadle South Dakota 46005 4594 60
2479241 2479241 2022-05-06 Beadle South Dakota 46005 4594 60
2475983 2475983 2022-05-05 Beadle South Dakota 46005 4594 60
2472726 2472726 2022-05-04 Beadle South Dakota 46005 4594 60
2469470 2469470 2022-05-03 Beadle South Dakota 46005 4593 60
2466214 2466214 2022-05-02 Beadle South Dakota 46005 4593 60
2462959 2462959 2022-05-01 Beadle South Dakota 46005 4593 60
2459703 2459703 2022-04-30 Beadle South Dakota 46005 4593 60
2456447 2456447 2022-04-29 Beadle South Dakota 46005 4593 60
2453191 2453191 2022-04-28 Beadle South Dakota 46005 4593 60
2449935 2449935 2022-04-27 Beadle South Dakota 46005 4593 60
2446678 2446678 2022-04-26 Beadle South Dakota 46005 4588 59
2443423 2443423 2022-04-25 Beadle South Dakota 46005 4588 59
2440167 2440167 2022-04-24 Beadle South Dakota 46005 4588 59
2436911 2436911 2022-04-23 Beadle South Dakota 46005 4588 59
2433655 2433655 2022-04-22 Beadle South Dakota 46005 4588 59
2430399 2430399 2022-04-21 Beadle South Dakota 46005 4588 59
2427143 2427143 2022-04-20 Beadle South Dakota 46005 4588 59
2423887 2423887 2022-04-19 Beadle South Dakota 46005 4587 59
2420631 2420631 2022-04-18 Beadle South Dakota 46005 4587 59
2417375 2417375 2022-04-17 Beadle South Dakota 46005 4587 59
2414119 2414119 2022-04-16 Beadle South Dakota 46005 4587 59
2410863 2410863 2022-04-15 Beadle South Dakota 46005 4587 59
2407607 2407607 2022-04-14 Beadle South Dakota 46005 4587 59
2404351 2404351 2022-04-13 Beadle South Dakota 46005 4587 59
2401096 2401096 2022-04-12 Beadle South Dakota 46005 4585 59
2397841 2397841 2022-04-11 Beadle South Dakota 46005 4585 59
2394586 2394586 2022-04-10 Beadle South Dakota 46005 4585 59
2391330 2391330 2022-04-09 Beadle South Dakota 46005 4585 59
2388074 2388074 2022-04-08 Beadle South Dakota 46005 4585 59
2384819 2384819 2022-04-07 Beadle South Dakota 46005 4585 59
2381564 2381564 2022-04-06 Beadle South Dakota 46005 4585 59
2378309 2378309 2022-04-05 Beadle South Dakota 46005 4584 58
2375055 2375055 2022-04-04 Beadle South Dakota 46005 4584 58
2371803 2371803 2022-04-03 Beadle South Dakota 46005 4584 58
2368550 2368550 2022-04-02 Beadle South Dakota 46005 4584 58
2365297 2365297 2022-04-01 Beadle South Dakota 46005 4584 58
2362044 2362044 2022-03-31 Beadle South Dakota 46005 4584 58
2358790 2358790 2022-03-30 Beadle South Dakota 46005 4584 58
2355536 2355536 2022-03-29 Beadle South Dakota 46005 4582 58
2352283 2352283 2022-03-28 Beadle South Dakota 46005 4582 58
2349031 2349031 2022-03-27 Beadle South Dakota 46005 4582 58
2345778 2345778 2022-03-26 Beadle South Dakota 46005 4582 58
2342525 2342525 2022-03-25 Beadle South Dakota 46005 4582 58
2339272 2339272 2022-03-24 Beadle South Dakota 46005 4582 58
2336018 2336018 2022-03-23 Beadle South Dakota 46005 4582 58
2332764 2332764 2022-03-22 Beadle South Dakota 46005 4578 58
2329511 2329511 2022-03-21 Beadle South Dakota 46005 4578 58
2326259 2326259 2022-03-20 Beadle South Dakota 46005 4578 58
2323006 2323006 2022-03-19 Beadle South Dakota 46005 4578 58
2319752 2319752 2022-03-18 Beadle South Dakota 46005 4578 58
2316498 2316498 2022-03-17 Beadle South Dakota 46005 4577 58
2313245 2313245 2022-03-16 Beadle South Dakota 46005 4575 58
2309992 2309992 2022-03-15 Beadle South Dakota 46005 4575 57
2306739 2306739 2022-03-14 Beadle South Dakota 46005 4573 57
2303488 2303488 2022-03-13 Beadle South Dakota 46005 4573 57
2300236 2300236 2022-03-12 Beadle South Dakota 46005 4573 57
2296984 2296984 2022-03-11 Beadle South Dakota 46005 4573 57
2293732 2293732 2022-03-10 Beadle South Dakota 46005 4571 57
2290480 2290480 2022-03-09 Beadle South Dakota 46005 4567 57
2287228 2287228 2022-03-08 Beadle South Dakota 46005 4565 57
2283976 2283976 2022-03-07 Beadle South Dakota 46005 4565 57
2280724 2280724 2022-03-06 Beadle South Dakota 46005 4561 56
2277471 2277471 2022-03-05 Beadle South Dakota 46005 4561 56
2274218 2274218 2022-03-04 Beadle South Dakota 46005 4561 56
2270965 2270965 2022-03-03 Beadle South Dakota 46005 4561 56
2267713 2267713 2022-03-02 Beadle South Dakota 46005 4564 56
2264460 2264460 2022-03-01 Beadle South Dakota 46005 4561 56
2261210 2261210 2022-02-28 Beadle South Dakota 46005 4554 56
2257959 2257959 2022-02-27 Beadle South Dakota 46005 4551 56
2254708 2254708 2022-02-26 Beadle South Dakota 46005 4551 56
2251457 2251457 2022-02-25 Beadle South Dakota 46005 4551 56
2248206 2248206 2022-02-24 Beadle South Dakota 46005 4545 56
2244955 2244955 2022-02-23 Beadle South Dakota 46005 4546 56
2241704 2241704 2022-02-22 Beadle South Dakota 46005 4546 56
2238453 2238453 2022-02-21 Beadle South Dakota 46005 4545 56
2235202 2235202 2022-02-20 Beadle South Dakota 46005 4545 56
2231951 2231951 2022-02-19 Beadle South Dakota 46005 4545 56
2228700 2228700 2022-02-18 Beadle South Dakota 46005 4545 56
2225449 2225449 2022-02-17 Beadle South Dakota 46005 4542 56
2222198 2222198 2022-02-16 Beadle South Dakota 46005 4542 56
2218947 2218947 2022-02-15 Beadle South Dakota 46005 4531 55
2215696 2215696 2022-02-14 Beadle South Dakota 46005 4527 55
2212445 2212445 2022-02-13 Beadle South Dakota 46005 4527 55
2209192 2209192 2022-02-12 Beadle South Dakota 46005 4527 55
2205939 2205939 2022-02-11 Beadle South Dakota 46005 4527 55
2202686 2202686 2022-02-10 Beadle South Dakota 46005 4523 54
2199432 2199432 2022-02-09 Beadle South Dakota 46005 4521 53
2196178 2196178 2022-02-08 Beadle South Dakota 46005 4505 52
2192924 2192924 2022-02-07 Beadle South Dakota 46005 4485 52
2189670 2189670 2022-02-06 Beadle South Dakota 46005 4474 52
2186417 2186417 2022-02-05 Beadle South Dakota 46005 4474 52
2183165 2183165 2022-02-04 Beadle South Dakota 46005 4474 52
2179913 2179913 2022-02-03 Beadle South Dakota 46005 4473 52

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