ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where "date" is on date 2020-04-22 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 |
---|---|---|---|---|---|---|---|
80572 | 80572 | 2020-04-22 | Aurora | South Dakota | 46003 | 1 | 0 |
80573 | 80573 | 2020-04-22 | Beadle | South Dakota | 46005 | 21 | 2 |
80574 | 80574 | 2020-04-22 | Bon Homme | South Dakota | 46009 | 4 | 0 |
80575 | 80575 | 2020-04-22 | Brookings | South Dakota | 46011 | 9 | 0 |
80576 | 80576 | 2020-04-22 | Brown | South Dakota | 46013 | 27 | 0 |
80577 | 80577 | 2020-04-22 | Charles Mix | South Dakota | 46023 | 4 | 0 |
80578 | 80578 | 2020-04-22 | Clark | South Dakota | 46025 | 1 | 0 |
80579 | 80579 | 2020-04-22 | Clay | South Dakota | 46027 | 5 | 0 |
80580 | 80580 | 2020-04-22 | Codington | South Dakota | 46029 | 13 | 0 |
80581 | 80581 | 2020-04-22 | Corson | South Dakota | 46031 | 1 | 0 |
80582 | 80582 | 2020-04-22 | Davison | South Dakota | 46035 | 5 | 1 |
80583 | 80583 | 2020-04-22 | Deuel | South Dakota | 46039 | 1 | 0 |
80584 | 80584 | 2020-04-22 | Fall River | South Dakota | 46047 | 1 | 0 |
80585 | 80585 | 2020-04-22 | Faulk | South Dakota | 46049 | 1 | 0 |
80586 | 80586 | 2020-04-22 | Hamlin | South Dakota | 46057 | 2 | 0 |
80587 | 80587 | 2020-04-22 | Hughes | South Dakota | 46065 | 6 | 0 |
80588 | 80588 | 2020-04-22 | Hutchinson | South Dakota | 46067 | 2 | 0 |
80589 | 80589 | 2020-04-22 | Hyde | South Dakota | 46069 | 1 | 0 |
80590 | 80590 | 2020-04-22 | Jerauld | South Dakota | 46073 | 4 | 0 |
80591 | 80591 | 2020-04-22 | Lake | South Dakota | 46079 | 3 | 0 |
80592 | 80592 | 2020-04-22 | Lawrence | South Dakota | 46081 | 9 | 0 |
80593 | 80593 | 2020-04-22 | Lincoln | South Dakota | 46083 | 104 | 0 |
80594 | 80594 | 2020-04-22 | Lyman | South Dakota | 46085 | 2 | 0 |
80595 | 80595 | 2020-04-22 | Marshall | South Dakota | 46091 | 1 | 0 |
80596 | 80596 | 2020-04-22 | McCook | South Dakota | 46087 | 3 | 1 |
80597 | 80597 | 2020-04-22 | Meade | South Dakota | 46093 | 1 | 0 |
80598 | 80598 | 2020-04-22 | Miner | South Dakota | 46097 | 1 | 0 |
80599 | 80599 | 2020-04-22 | Minnehaha | South Dakota | 46099 | 1555 | 5 |
80600 | 80600 | 2020-04-22 | Moody | South Dakota | 46101 | 2 | 0 |
80601 | 80601 | 2020-04-22 | Oglala Lakota | South Dakota | 46102 | 1 | 0 |
80602 | 80602 | 2020-04-22 | Pennington | South Dakota | 46103 | 11 | 0 |
80603 | 80603 | 2020-04-22 | Roberts | South Dakota | 46109 | 4 | 0 |
80604 | 80604 | 2020-04-22 | Sanborn | South Dakota | 46111 | 3 | 0 |
80605 | 80605 | 2020-04-22 | Spink | South Dakota | 46115 | 3 | 0 |
80606 | 80606 | 2020-04-22 | Sully | South Dakota | 46119 | 1 | 0 |
80607 | 80607 | 2020-04-22 | Todd | South Dakota | 46121 | 1 | 0 |
80608 | 80608 | 2020-04-22 | Turner | South Dakota | 46125 | 9 | 0 |
80609 | 80609 | 2020-04-22 | Union | South Dakota | 46127 | 7 | 0 |
80610 | 80610 | 2020-04-22 | Walworth | South Dakota | 46129 | 5 | 0 |
80611 | 80611 | 2020-04-22 | Yankton | South Dakota | 46135 | 23 | 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);