ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 146 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 |
---|---|---|---|---|---|---|---|
1965352 | 1965352 | 2021-11-29 | Jones | South Dakota | 46075 | 146 | 1 |
1962100 | 1962100 | 2021-11-28 | Jones | South Dakota | 46075 | 146 | 1 |
1958849 | 1958849 | 2021-11-27 | Jones | South Dakota | 46075 | 146 | 1 |
1955598 | 1955598 | 2021-11-26 | Jones | South Dakota | 46075 | 146 | 1 |
1952347 | 1952347 | 2021-11-25 | Jones | South Dakota | 46075 | 146 | 1 |
1949096 | 1949096 | 2021-11-24 | Jones | South Dakota | 46075 | 146 | 1 |
1945845 | 1945845 | 2021-11-23 | Jones | South Dakota | 46075 | 146 | 1 |
1942594 | 1942594 | 2021-11-22 | Jones | South Dakota | 46075 | 146 | 1 |
1939344 | 1939344 | 2021-11-21 | Jones | South Dakota | 46075 | 146 | 1 |
1936094 | 1936094 | 2021-11-20 | Jones | South Dakota | 46075 | 146 | 1 |
1932844 | 1932844 | 2021-11-19 | Jones | South Dakota | 46075 | 146 | 1 |
1929593 | 1929593 | 2021-11-18 | Jones | South Dakota | 46075 | 146 | 1 |
1926343 | 1926343 | 2021-11-17 | Jones | South Dakota | 46075 | 146 | 1 |
1923093 | 1923093 | 2021-11-16 | Jones | South Dakota | 46075 | 146 | 1 |
1718364 | 1718364 | 2021-09-14 | Campbell | South Dakota | 46021 | 146 | 4 |
1715116 | 1715116 | 2021-09-13 | Campbell | South Dakota | 46021 | 146 | 4 |
1711870 | 1711870 | 2021-09-12 | Campbell | South Dakota | 46021 | 146 | 4 |
1708623 | 1708623 | 2021-09-11 | Campbell | South Dakota | 46021 | 146 | 4 |
1705376 | 1705376 | 2021-09-10 | Campbell | South Dakota | 46021 | 146 | 4 |
1702126 | 1702126 | 2021-09-09 | Campbell | South Dakota | 46021 | 146 | 4 |
1698877 | 1698877 | 2021-09-08 | Campbell | South Dakota | 46021 | 146 | 4 |
1604723 | 1604723 | 2021-08-10 | Sully | South Dakota | 46119 | 146 | 3 |
1601474 | 1601474 | 2021-08-09 | Sully | South Dakota | 46119 | 146 | 3 |
1598226 | 1598226 | 2021-08-08 | Sully | South Dakota | 46119 | 146 | 3 |
1594977 | 1594977 | 2021-08-07 | Sully | South Dakota | 46119 | 146 | 3 |
1591728 | 1591728 | 2021-08-06 | Sully | South Dakota | 46119 | 146 | 3 |
1588479 | 1588479 | 2021-08-05 | Sully | South Dakota | 46119 | 146 | 3 |
1585229 | 1585229 | 2021-08-04 | Sully | South Dakota | 46119 | 146 | 3 |
1581979 | 1581979 | 2021-08-03 | Sully | South Dakota | 46119 | 146 | 3 |
1578730 | 1578730 | 2021-08-02 | Sully | South Dakota | 46119 | 146 | 3 |
1575482 | 1575482 | 2021-08-01 | Sully | South Dakota | 46119 | 146 | 3 |
1572234 | 1572234 | 2021-07-31 | Sully | South Dakota | 46119 | 146 | 3 |
1568986 | 1568986 | 2021-07-30 | Sully | South Dakota | 46119 | 146 | 3 |
1565738 | 1565738 | 2021-07-29 | Sully | South Dakota | 46119 | 146 | 3 |
1562490 | 1562490 | 2021-07-28 | Sully | South Dakota | 46119 | 146 | 3 |
773656 | 773656 | 2020-11-27 | McPherson | South Dakota | 46089 | 146 | 1 |
747693 | 747693 | 2020-11-19 | Mellette | South Dakota | 46095 | 146 | 1 |
724987 | 724987 | 2020-11-12 | Stanley | South Dakota | 46117 | 146 | 0 |
692509 | 692509 | 2020-11-02 | Clark | South Dakota | 46025 | 146 | 1 |
686037 | 686037 | 2020-10-31 | Hand | South Dakota | 46059 | 146 | 1 |
640610 | 640610 | 2020-10-17 | Douglas | South Dakota | 46043 | 146 | 4 |
624416 | 624416 | 2020-10-12 | Moody | South Dakota | 46101 | 146 | 1 |
617924 | 617924 | 2020-10-10 | McCook | South Dakota | 46087 | 146 | 1 |
611433 | 611433 | 2020-10-08 | Jerauld | South Dakota | 46073 | 146 | 4 |
608191 | 608191 | 2020-10-07 | Jerauld | South Dakota | 46073 | 146 | 3 |
604976 | 604976 | 2020-10-06 | Walworth | South Dakota | 46129 | 146 | 1 |
601734 | 601734 | 2020-10-05 | Walworth | South Dakota | 46129 | 146 | 1 |
595191 | 595191 | 2020-10-03 | Brule | South Dakota | 46015 | 146 | 1 |
579002 | 579002 | 2020-09-28 | Dewey | South Dakota | 46041 | 146 | 0 |
569297 | 569297 | 2020-09-25 | Lyman | South Dakota | 46085 | 146 | 3 |
511022 | 511022 | 2020-09-07 | Hughes | South Dakota | 46065 | 146 | 4 |
498074 | 498074 | 2020-09-03 | Davison | South Dakota | 46035 | 146 | 2 |
391641 | 391641 | 2020-08-01 | Oglala Lakota | South Dakota | 46102 | 146 | 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);