ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 80 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
968367 | 968367 | 2021-01-26 | Jones | South Dakota | 46075 | 80 | 0 |
721720 | 721720 | 2020-11-11 | Hyde | South Dakota | 46069 | 80 | 0 |
692550 | 692550 | 2020-11-02 | Perkins | South Dakota | 46105 | 80 | 0 |
686018 | 686018 | 2020-10-31 | Campbell | South Dakota | 46021 | 80 | 1 |
686061 | 686061 | 2020-10-31 | Perkins | South Dakota | 46105 | 80 | 0 |
679575 | 679575 | 2020-10-29 | Perkins | South Dakota | 46105 | 80 | 0 |
676326 | 676326 | 2020-10-28 | Mellette | South Dakota | 46095 | 80 | 1 |
663335 | 663335 | 2020-10-24 | Hanson | South Dakota | 46061 | 80 | 1 |
630881 | 630881 | 2020-10-14 | Hand | South Dakota | 46059 | 80 | 1 |
608193 | 608193 | 2020-10-07 | Kingsbury | South Dakota | 46077 | 80 | 0 |
575762 | 575762 | 2020-09-27 | Douglas | South Dakota | 46043 | 80 | 1 |
566018 | 566018 | 2020-09-24 | Bon Homme | South Dakota | 46009 | 80 | 1 |
566033 | 566033 | 2020-09-24 | Deuel | South Dakota | 46039 | 80 | 0 |
562801 | 562801 | 2020-09-23 | Hamlin | South Dakota | 46057 | 80 | 0 |
559564 | 559564 | 2020-09-22 | Hamlin | South Dakota | 46057 | 80 | 0 |
556327 | 556327 | 2020-09-21 | Hamlin | South Dakota | 46057 | 80 | 0 |
553090 | 553090 | 2020-09-20 | Hamlin | South Dakota | 46057 | 80 | 0 |
549845 | 549845 | 2020-09-19 | Edmunds | South Dakota | 46045 | 80 | 0 |
549867 | 549867 | 2020-09-19 | McCook | South Dakota | 46087 | 80 | 1 |
546599 | 546599 | 2020-09-18 | Corson | South Dakota | 46031 | 80 | 1 |
543373 | 543373 | 2020-09-17 | Gregory | South Dakota | 46053 | 80 | 1 |
536881 | 536881 | 2020-09-15 | Brule | South Dakota | 46015 | 80 | 0 |
533645 | 533645 | 2020-09-14 | Brule | South Dakota | 46015 | 80 | 0 |
530410 | 530410 | 2020-09-13 | Brule | South Dakota | 46015 | 80 | 0 |
527173 | 527173 | 2020-09-12 | Brule | South Dakota | 46015 | 80 | 0 |
430284 | 430284 | 2020-08-13 | Roberts | South Dakota | 46109 | 80 | 1 |
427057 | 427057 | 2020-08-12 | Roberts | South Dakota | 46109 | 80 | 1 |
423834 | 423834 | 2020-08-11 | Roberts | South Dakota | 46109 | 80 | 1 |
420612 | 420612 | 2020-08-10 | Roberts | South Dakota | 46109 | 80 | 1 |
417391 | 417391 | 2020-08-09 | Roberts | South Dakota | 46109 | 80 | 1 |
317981 | 317981 | 2020-07-09 | Lyman | South Dakota | 46085 | 80 | 1 |
286325 | 286325 | 2020-06-29 | Clay | South Dakota | 46027 | 80 | 0 |
283180 | 283180 | 2020-06-28 | Clay | South Dakota | 46027 | 80 | 0 |
280034 | 280034 | 2020-06-27 | Clay | South Dakota | 46027 | 80 | 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);