ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 176 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2267748 | 2267748 | 2022-03-02 | Jones | South Dakota | 46075 | 176 | 2 |
2264495 | 2264495 | 2022-03-01 | Jones | South Dakota | 46075 | 176 | 2 |
2261245 | 2261245 | 2022-02-28 | Jones | South Dakota | 46075 | 176 | 2 |
2257994 | 2257994 | 2022-02-27 | Jones | South Dakota | 46075 | 176 | 2 |
2254743 | 2254743 | 2022-02-26 | Jones | South Dakota | 46075 | 176 | 2 |
2251492 | 2251492 | 2022-02-25 | Jones | South Dakota | 46075 | 176 | 2 |
2248241 | 2248241 | 2022-02-24 | Jones | South Dakota | 46075 | 176 | 2 |
2244990 | 2244990 | 2022-02-23 | Jones | South Dakota | 46075 | 176 | 2 |
1962073 | 1962073 | 2021-11-28 | Campbell | South Dakota | 46021 | 176 | 4 |
1958822 | 1958822 | 2021-11-27 | Campbell | South Dakota | 46021 | 176 | 4 |
1955571 | 1955571 | 2021-11-26 | Campbell | South Dakota | 46021 | 176 | 4 |
1952320 | 1952320 | 2021-11-25 | Campbell | South Dakota | 46021 | 176 | 4 |
1949069 | 1949069 | 2021-11-24 | Campbell | South Dakota | 46021 | 176 | 4 |
1945818 | 1945818 | 2021-11-23 | Campbell | South Dakota | 46021 | 176 | 4 |
780149 | 780149 | 2020-11-29 | Mellette | South Dakota | 46095 | 176 | 1 |
776899 | 776899 | 2020-11-28 | Marshall | South Dakota | 46091 | 176 | 3 |
744448 | 744448 | 2020-11-18 | Miner | South Dakota | 46097 | 176 | 3 |
741201 | 741201 | 2020-11-17 | Miner | South Dakota | 46097 | 176 | 3 |
737955 | 737955 | 2020-11-16 | Miner | South Dakota | 46097 | 176 | 3 |
734711 | 734711 | 2020-11-15 | Miner | South Dakota | 46097 | 176 | 3 |
702255 | 702255 | 2020-11-05 | Hand | South Dakota | 46059 | 176 | 1 |
702262 | 702262 | 2020-11-05 | Jerauld | South Dakota | 46073 | 176 | 13 |
676280 | 676280 | 2020-10-28 | Aurora | South Dakota | 46003 | 176 | 0 |
676294 | 676294 | 2020-10-28 | Corson | South Dakota | 46031 | 176 | 1 |
673074 | 673074 | 2020-10-27 | Kingsbury | South Dakota | 46077 | 176 | 2 |
660089 | 660089 | 2020-10-23 | Hamlin | South Dakota | 46057 | 176 | 0 |
650377 | 650377 | 2020-10-20 | Moody | South Dakota | 46101 | 176 | 2 |
643863 | 643863 | 2020-10-18 | Gregory | South Dakota | 46053 | 176 | 8 |
637376 | 637376 | 2020-10-16 | Hutchinson | South Dakota | 46067 | 176 | 2 |
588763 | 588763 | 2020-10-01 | Tripp | South Dakota | 46123 | 176 | 1 |
536891 | 536891 | 2020-09-15 | Davison | South Dakota | 46035 | 176 | 2 |
491641 | 491641 | 2020-09-01 | Oglala Lakota | South Dakota | 46102 | 176 | 2 |
472201 | 472201 | 2020-08-26 | Clay | South Dakota | 46027 | 176 | 1 |
468969 | 468969 | 2020-08-25 | Clay | South Dakota | 46027 | 176 | 1 |
469002 | 469002 | 2020-08-25 | Meade | South Dakota | 46093 | 176 | 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);