ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where "date" is on date 2020-07-09 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 |
---|---|---|---|---|---|---|---|
317941 | 317941 | 2020-07-09 | Aurora | South Dakota | 46003 | 34 | 0 |
317942 | 317942 | 2020-07-09 | Beadle | South Dakota | 46005 | 551 | 7 |
317943 | 317943 | 2020-07-09 | Bennett | South Dakota | 46007 | 4 | 0 |
317944 | 317944 | 2020-07-09 | Bon Homme | South Dakota | 46009 | 13 | 0 |
317945 | 317945 | 2020-07-09 | Brookings | South Dakota | 46011 | 86 | 0 |
317946 | 317946 | 2020-07-09 | Brown | South Dakota | 46013 | 352 | 2 |
317947 | 317947 | 2020-07-09 | Brule | South Dakota | 46015 | 33 | 0 |
317948 | 317948 | 2020-07-09 | Buffalo | South Dakota | 46017 | 84 | 3 |
317949 | 317949 | 2020-07-09 | Butte | South Dakota | 46019 | 1 | 0 |
317950 | 317950 | 2020-07-09 | Campbell | South Dakota | 46021 | 1 | 0 |
317951 | 317951 | 2020-07-09 | Charles Mix | South Dakota | 46023 | 96 | 0 |
317952 | 317952 | 2020-07-09 | Clark | South Dakota | 46025 | 15 | 0 |
317953 | 317953 | 2020-07-09 | Clay | South Dakota | 46027 | 92 | 0 |
317954 | 317954 | 2020-07-09 | Codington | South Dakota | 46029 | 90 | 0 |
317955 | 317955 | 2020-07-09 | Corson | South Dakota | 46031 | 19 | 0 |
317956 | 317956 | 2020-07-09 | Custer | South Dakota | 46033 | 10 | 0 |
317957 | 317957 | 2020-07-09 | Davison | South Dakota | 46035 | 51 | 1 |
317958 | 317958 | 2020-07-09 | Day | South Dakota | 46037 | 19 | 0 |
317959 | 317959 | 2020-07-09 | Deuel | South Dakota | 46039 | 4 | 0 |
317960 | 317960 | 2020-07-09 | Dewey | South Dakota | 46041 | 27 | 0 |
317961 | 317961 | 2020-07-09 | Douglas | South Dakota | 46043 | 10 | 0 |
317962 | 317962 | 2020-07-09 | Edmunds | South Dakota | 46045 | 8 | 0 |
317963 | 317963 | 2020-07-09 | Fall River | South Dakota | 46047 | 13 | 0 |
317964 | 317964 | 2020-07-09 | Faulk | South Dakota | 46049 | 23 | 1 |
317965 | 317965 | 2020-07-09 | Grant | South Dakota | 46051 | 16 | 0 |
317966 | 317966 | 2020-07-09 | Gregory | South Dakota | 46053 | 5 | 0 |
317967 | 317967 | 2020-07-09 | Haakon | South Dakota | 46055 | 1 | 0 |
317968 | 317968 | 2020-07-09 | Hamlin | South Dakota | 46057 | 13 | 0 |
317969 | 317969 | 2020-07-09 | Hand | South Dakota | 46059 | 7 | 0 |
317970 | 317970 | 2020-07-09 | Hanson | South Dakota | 46061 | 13 | 0 |
317971 | 317971 | 2020-07-09 | Hughes | South Dakota | 46065 | 68 | 0 |
317972 | 317972 | 2020-07-09 | Hutchinson | South Dakota | 46067 | 15 | 0 |
317973 | 317973 | 2020-07-09 | Hyde | South Dakota | 46069 | 3 | 0 |
317974 | 317974 | 2020-07-09 | Jackson | South Dakota | 46071 | 6 | 1 |
317975 | 317975 | 2020-07-09 | Jerauld | South Dakota | 46073 | 39 | 1 |
317976 | 317976 | 2020-07-09 | Jones | South Dakota | 46075 | 1 | 0 |
317977 | 317977 | 2020-07-09 | Kingsbury | South Dakota | 46077 | 6 | 0 |
317978 | 317978 | 2020-07-09 | Lake | South Dakota | 46079 | 23 | 1 |
317979 | 317979 | 2020-07-09 | Lawrence | South Dakota | 46081 | 19 | 0 |
317980 | 317980 | 2020-07-09 | Lincoln | South Dakota | 46083 | 381 | 1 |
317981 | 317981 | 2020-07-09 | Lyman | South Dakota | 46085 | 80 | 1 |
317982 | 317982 | 2020-07-09 | Marshall | South Dakota | 46091 | 5 | 0 |
317983 | 317983 | 2020-07-09 | McCook | South Dakota | 46087 | 15 | 1 |
317984 | 317984 | 2020-07-09 | McPherson | South Dakota | 46089 | 5 | 0 |
317985 | 317985 | 2020-07-09 | Meade | South Dakota | 46093 | 53 | 1 |
317986 | 317986 | 2020-07-09 | Mellette | South Dakota | 46095 | 6 | 0 |
317987 | 317987 | 2020-07-09 | Miner | South Dakota | 46097 | 10 | 0 |
317988 | 317988 | 2020-07-09 | Minnehaha | South Dakota | 46099 | 3723 | 59 |
317989 | 317989 | 2020-07-09 | Moody | South Dakota | 46101 | 23 | 0 |
317990 | 317990 | 2020-07-09 | Oglala Lakota | South Dakota | 46102 | 108 | 0 |
317991 | 317991 | 2020-07-09 | Pennington | South Dakota | 46103 | 616 | 17 |
317992 | 317992 | 2020-07-09 | Roberts | South Dakota | 46109 | 53 | 0 |
317993 | 317993 | 2020-07-09 | Sanborn | South Dakota | 46111 | 12 | 0 |
317994 | 317994 | 2020-07-09 | Spink | South Dakota | 46115 | 12 | 0 |
317995 | 317995 | 2020-07-09 | Stanley | South Dakota | 46117 | 14 | 0 |
317996 | 317996 | 2020-07-09 | Sully | South Dakota | 46119 | 1 | 0 |
317997 | 317997 | 2020-07-09 | Todd | South Dakota | 46121 | 61 | 2 |
317998 | 317998 | 2020-07-09 | Tripp | South Dakota | 46123 | 18 | 0 |
317999 | 317999 | 2020-07-09 | Turner | South Dakota | 46125 | 28 | 0 |
318000 | 318000 | 2020-07-09 | Union | South Dakota | 46127 | 140 | 1 |
318001 | 318001 | 2020-07-09 | Walworth | South Dakota | 46129 | 16 | 0 |
318002 | 318002 | 2020-07-09 | Yankton | South Dakota | 46135 | 83 | 1 |
318003 | 318003 | 2020-07-09 | Ziebach | South Dakota | 46137 | 2 | 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);