ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 66 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
763906 | 763906 | 2020-11-24 | Harding | South Dakota | 46063 | 66 | 0 |
760661 | 760661 | 2020-11-23 | Harding | South Dakota | 46063 | 66 | 0 |
708746 | 708746 | 2020-11-07 | Hyde | South Dakota | 46069 | 66 | 0 |
669839 | 669839 | 2020-10-26 | McPherson | South Dakota | 46089 | 66 | 0 |
643864 | 643864 | 2020-10-18 | Haakon | South Dakota | 46055 | 66 | 1 |
640601 | 640601 | 2020-10-17 | Clark | South Dakota | 46025 | 66 | 0 |
637399 | 637399 | 2020-10-16 | Sanborn | South Dakota | 46111 | 66 | 0 |
621171 | 621171 | 2020-10-11 | Miner | South Dakota | 46097 | 66 | 0 |
611451 | 611451 | 2020-10-08 | Potter | South Dakota | 46107 | 66 | 0 |
591944 | 591944 | 2020-10-02 | Aurora | South Dakota | 46003 | 66 | 0 |
569279 | 569279 | 2020-09-25 | Faulk | South Dakota | 46049 | 66 | 1 |
549859 | 549859 | 2020-09-19 | Jerauld | South Dakota | 46073 | 66 | 1 |
536899 | 536899 | 2020-09-15 | Grant | South Dakota | 46051 | 66 | 1 |
527230 | 527230 | 2020-09-12 | Walworth | South Dakota | 46129 | 66 | 0 |
520738 | 520738 | 2020-09-10 | McCook | South Dakota | 46087 | 66 | 1 |
488364 | 488364 | 2020-08-31 | Brule | South Dakota | 46015 | 66 | 0 |
485131 | 485131 | 2020-08-30 | Brule | South Dakota | 46015 | 66 | 0 |
401298 | 401298 | 2020-08-04 | Todd | South Dakota | 46121 | 66 | 4 |
398083 | 398083 | 2020-08-03 | Todd | South Dakota | 46121 | 66 | 4 |
394866 | 394866 | 2020-08-02 | Todd | South Dakota | 46121 | 66 | 4 |
391650 | 391650 | 2020-08-01 | Todd | South Dakota | 46121 | 66 | 4 |
388433 | 388433 | 2020-07-31 | Todd | South Dakota | 46121 | 66 | 4 |
385216 | 385216 | 2020-07-30 | Todd | South Dakota | 46121 | 66 | 4 |
381998 | 381998 | 2020-07-29 | Todd | South Dakota | 46121 | 66 | 4 |
378781 | 378781 | 2020-07-28 | Todd | South Dakota | 46121 | 66 | 4 |
375565 | 375565 | 2020-07-27 | Todd | South Dakota | 46121 | 66 | 4 |
372331 | 372331 | 2020-07-26 | Lake | South Dakota | 46079 | 66 | 2 |
372352 | 372352 | 2020-07-26 | Todd | South Dakota | 46121 | 66 | 4 |
369140 | 369140 | 2020-07-25 | Todd | South Dakota | 46121 | 66 | 3 |
365931 | 365931 | 2020-07-24 | Todd | South Dakota | 46121 | 66 | 3 |
362725 | 362725 | 2020-07-23 | Todd | South Dakota | 46121 | 66 | 3 |
359518 | 359518 | 2020-07-22 | Todd | South Dakota | 46121 | 66 | 3 |
346667 | 346667 | 2020-07-18 | Davison | South Dakota | 46035 | 66 | 1 |
330727 | 330727 | 2020-07-13 | Todd | South Dakota | 46121 | 66 | 2 |
327541 | 327541 | 2020-07-12 | Todd | South Dakota | 46121 | 66 | 2 |
314798 | 314798 | 2020-07-08 | Hughes | South Dakota | 46065 | 66 | 0 |
267463 | 267463 | 2020-06-23 | Buffalo | South Dakota | 46017 | 66 | 0 |
264335 | 264335 | 2020-06-22 | Buffalo | South Dakota | 46017 | 66 | 0 |
261207 | 261207 | 2020-06-21 | Buffalo | South Dakota | 46017 | 66 | 0 |
258080 | 258080 | 2020-06-20 | Buffalo | South Dakota | 46017 | 66 | 0 |
242502 | 242502 | 2020-06-15 | Clay | South Dakota | 46027 | 66 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);