ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 72 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
929424 | 929424 | 2021-01-14 | Jones | South Dakota | 46075 | 72 | 0 |
776887 | 776887 | 2020-11-28 | Harding | South Dakota | 46063 | 72 | 0 |
708757 | 708757 | 2020-11-07 | McPherson | South Dakota | 46089 | 72 | 1 |
705514 | 705514 | 2020-11-06 | McPherson | South Dakota | 46089 | 72 | 1 |
702269 | 702269 | 2020-11-05 | Marshall | South Dakota | 46091 | 72 | 2 |
692542 | 692542 | 2020-11-02 | McPherson | South Dakota | 46089 | 72 | 0 |
689298 | 689298 | 2020-11-01 | McPherson | South Dakota | 46089 | 72 | 0 |
686053 | 686053 | 2020-10-31 | McPherson | South Dakota | 46089 | 72 | 0 |
682810 | 682810 | 2020-10-30 | McPherson | South Dakota | 46089 | 72 | 0 |
679567 | 679567 | 2020-10-29 | McPherson | South Dakota | 46089 | 72 | 0 |
669841 | 669841 | 2020-10-26 | Mellette | South Dakota | 46095 | 72 | 1 |
660071 | 660071 | 2020-10-23 | Campbell | South Dakota | 46021 | 72 | 0 |
656847 | 656847 | 2020-10-22 | Hanson | South Dakota | 46061 | 72 | 1 |
653582 | 653582 | 2020-10-21 | Campbell | South Dakota | 46021 | 72 | 0 |
640624 | 640624 | 2020-10-17 | Jackson | South Dakota | 46071 | 72 | 1 |
637378 | 637378 | 2020-10-16 | Jackson | South Dakota | 46071 | 72 | 1 |
614667 | 614667 | 2020-10-09 | Hand | South Dakota | 46059 | 72 | 1 |
591946 | 591946 | 2020-10-02 | Bennett | South Dakota | 46007 | 72 | 3 |
562794 | 562794 | 2020-09-23 | Douglas | South Dakota | 46043 | 72 | 0 |
546645 | 546645 | 2020-09-18 | Tripp | South Dakota | 46123 | 72 | 0 |
543351 | 543351 | 2020-09-17 | Bon Homme | South Dakota | 46009 | 72 | 1 |
540133 | 540133 | 2020-09-16 | Edmunds | South Dakota | 46045 | 72 | 0 |
540136 | 540136 | 2020-09-16 | Grant | South Dakota | 46051 | 72 | 1 |
540137 | 540137 | 2020-09-16 | Gregory | South Dakota | 46053 | 72 | 1 |
540175 | 540175 | 2020-09-16 | Walworth | South Dakota | 46129 | 72 | 0 |
530418 | 530418 | 2020-09-13 | Corson | South Dakota | 46031 | 72 | 1 |
527181 | 527181 | 2020-09-12 | Corson | South Dakota | 46031 | 72 | 1 |
523945 | 523945 | 2020-09-11 | Corson | South Dakota | 46031 | 72 | 1 |
520722 | 520722 | 2020-09-10 | Hamlin | South Dakota | 46057 | 72 | 0 |
517486 | 517486 | 2020-09-09 | Hamlin | South Dakota | 46057 | 72 | 0 |
517515 | 517515 | 2020-09-09 | Spink | South Dakota | 46115 | 72 | 0 |
475442 | 475442 | 2020-08-27 | Dewey | South Dakota | 46041 | 72 | 0 |
333892 | 333892 | 2020-07-14 | Hughes | South Dakota | 46065 | 72 | 2 |
311634 | 311634 | 2020-07-07 | Lyman | South Dakota | 46085 | 72 | 1 |
295781 | 295781 | 2020-07-02 | Buffalo | South Dakota | 46017 | 72 | 3 |
295785 | 295785 | 2020-07-02 | Codington | South Dakota | 46029 | 72 | 0 |
283177 | 283177 | 2020-06-28 | Buffalo | South Dakota | 46017 | 72 | 1 |
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);