ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
205 rows where deaths = 32 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 |
---|---|---|---|---|---|---|---|
2222207 | 2222207 | 2022-02-16 | Charles Mix | South Dakota | 46023 | 2904 | 32 |
2218956 | 2218956 | 2022-02-15 | Charles Mix | South Dakota | 46023 | 2902 | 32 |
2215705 | 2215705 | 2022-02-14 | Charles Mix | South Dakota | 46023 | 2898 | 32 |
2212454 | 2212454 | 2022-02-13 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2209201 | 2209201 | 2022-02-12 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2205948 | 2205948 | 2022-02-11 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2202695 | 2202695 | 2022-02-10 | Charles Mix | South Dakota | 46023 | 2886 | 32 |
2199441 | 2199441 | 2022-02-09 | Charles Mix | South Dakota | 46023 | 2882 | 32 |
2199448 | 2199448 | 2022-02-09 | Day | South Dakota | 46037 | 1249 | 32 |
2199487 | 2199487 | 2022-02-09 | Spink | South Dakota | 46115 | 1371 | 32 |
2196187 | 2196187 | 2022-02-08 | Charles Mix | South Dakota | 46023 | 2866 | 32 |
2196194 | 2196194 | 2022-02-08 | Day | South Dakota | 46037 | 1245 | 32 |
2196233 | 2196233 | 2022-02-08 | Spink | South Dakota | 46115 | 1366 | 32 |
2192933 | 2192933 | 2022-02-07 | Charles Mix | South Dakota | 46023 | 2860 | 32 |
2192940 | 2192940 | 2022-02-07 | Day | South Dakota | 46037 | 1241 | 32 |
2192979 | 2192979 | 2022-02-07 | Spink | South Dakota | 46115 | 1363 | 32 |
2189679 | 2189679 | 2022-02-06 | Charles Mix | South Dakota | 46023 | 2852 | 32 |
2189686 | 2189686 | 2022-02-06 | Day | South Dakota | 46037 | 1238 | 32 |
2189725 | 2189725 | 2022-02-06 | Spink | South Dakota | 46115 | 1359 | 32 |
2186426 | 2186426 | 2022-02-05 | Charles Mix | South Dakota | 46023 | 2852 | 32 |
2186433 | 2186433 | 2022-02-05 | Day | South Dakota | 46037 | 1238 | 32 |
2186472 | 2186472 | 2022-02-05 | Spink | South Dakota | 46115 | 1359 | 32 |
2183174 | 2183174 | 2022-02-04 | Charles Mix | South Dakota | 46023 | 2852 | 32 |
2183181 | 2183181 | 2022-02-04 | Day | South Dakota | 46037 | 1238 | 32 |
2183220 | 2183220 | 2022-02-04 | Spink | South Dakota | 46115 | 1359 | 32 |
2179922 | 2179922 | 2022-02-03 | Charles Mix | South Dakota | 46023 | 2837 | 32 |
2179929 | 2179929 | 2022-02-03 | Day | South Dakota | 46037 | 1233 | 32 |
2179968 | 2179968 | 2022-02-03 | Spink | South Dakota | 46115 | 1354 | 32 |
2176678 | 2176678 | 2022-02-02 | Day | South Dakota | 46037 | 1229 | 32 |
2176717 | 2176717 | 2022-02-02 | Spink | South Dakota | 46115 | 1350 | 32 |
2173424 | 2173424 | 2022-02-01 | Day | South Dakota | 46037 | 1220 | 32 |
2173463 | 2173463 | 2022-02-01 | Spink | South Dakota | 46115 | 1345 | 32 |
2170172 | 2170172 | 2022-01-31 | Day | South Dakota | 46037 | 1215 | 32 |
2170211 | 2170211 | 2022-01-31 | Spink | South Dakota | 46115 | 1337 | 32 |
2166918 | 2166918 | 2022-01-30 | Day | South Dakota | 46037 | 1209 | 32 |
2166957 | 2166957 | 2022-01-30 | Spink | South Dakota | 46115 | 1332 | 32 |
2163663 | 2163663 | 2022-01-29 | Day | South Dakota | 46037 | 1209 | 32 |
2163702 | 2163702 | 2022-01-29 | Spink | South Dakota | 46115 | 1332 | 32 |
2160408 | 2160408 | 2022-01-28 | Day | South Dakota | 46037 | 1209 | 32 |
2160447 | 2160447 | 2022-01-28 | Spink | South Dakota | 46115 | 1332 | 32 |
2157152 | 2157152 | 2022-01-27 | Day | South Dakota | 46037 | 1199 | 32 |
2157191 | 2157191 | 2022-01-27 | Spink | South Dakota | 46115 | 1325 | 32 |
2153899 | 2153899 | 2022-01-26 | Day | South Dakota | 46037 | 1189 | 32 |
2153938 | 2153938 | 2022-01-26 | Spink | South Dakota | 46115 | 1320 | 32 |
2150647 | 2150647 | 2022-01-25 | Day | South Dakota | 46037 | 1170 | 32 |
2150686 | 2150686 | 2022-01-25 | Spink | South Dakota | 46115 | 1312 | 32 |
2147395 | 2147395 | 2022-01-24 | Day | South Dakota | 46037 | 1149 | 32 |
2147434 | 2147434 | 2022-01-24 | Spink | South Dakota | 46115 | 1302 | 32 |
2144141 | 2144141 | 2022-01-23 | Day | South Dakota | 46037 | 1141 | 32 |
2144180 | 2144180 | 2022-01-23 | Spink | South Dakota | 46115 | 1294 | 32 |
2140886 | 2140886 | 2022-01-22 | Day | South Dakota | 46037 | 1141 | 32 |
2140925 | 2140925 | 2022-01-22 | Spink | South Dakota | 46115 | 1294 | 32 |
2137630 | 2137630 | 2022-01-21 | Day | South Dakota | 46037 | 1141 | 32 |
2137669 | 2137669 | 2022-01-21 | Spink | South Dakota | 46115 | 1294 | 32 |
2134369 | 2134369 | 2022-01-20 | Charles Mix | South Dakota | 46023 | 2592 | 32 |
2134376 | 2134376 | 2022-01-20 | Day | South Dakota | 46037 | 1128 | 32 |
2134391 | 2134391 | 2022-01-20 | Hutchinson | South Dakota | 46067 | 1589 | 32 |
2134415 | 2134415 | 2022-01-20 | Spink | South Dakota | 46115 | 1285 | 32 |
2131117 | 2131117 | 2022-01-19 | Charles Mix | South Dakota | 46023 | 2543 | 32 |
2131163 | 2131163 | 2022-01-19 | Spink | South Dakota | 46115 | 1278 | 32 |
2127863 | 2127863 | 2022-01-18 | Charles Mix | South Dakota | 46023 | 2465 | 32 |
2127909 | 2127909 | 2022-01-18 | Spink | South Dakota | 46115 | 1253 | 32 |
2124611 | 2124611 | 2022-01-17 | Charles Mix | South Dakota | 46023 | 2415 | 32 |
2124657 | 2124657 | 2022-01-17 | Spink | South Dakota | 46115 | 1239 | 32 |
2121359 | 2121359 | 2022-01-16 | Charles Mix | South Dakota | 46023 | 2415 | 32 |
2121405 | 2121405 | 2022-01-16 | Spink | South Dakota | 46115 | 1239 | 32 |
2118107 | 2118107 | 2022-01-15 | Charles Mix | South Dakota | 46023 | 2415 | 32 |
2118153 | 2118153 | 2022-01-15 | Spink | South Dakota | 46115 | 1239 | 32 |
2114856 | 2114856 | 2022-01-14 | Charles Mix | South Dakota | 46023 | 2415 | 32 |
2114902 | 2114902 | 2022-01-14 | Spink | South Dakota | 46115 | 1239 | 32 |
2111604 | 2111604 | 2022-01-13 | Charles Mix | South Dakota | 46023 | 2381 | 32 |
2108352 | 2108352 | 2022-01-12 | Charles Mix | South Dakota | 46023 | 2343 | 32 |
2105101 | 2105101 | 2022-01-11 | Charles Mix | South Dakota | 46023 | 2317 | 32 |
2101850 | 2101850 | 2022-01-10 | Charles Mix | South Dakota | 46023 | 2261 | 32 |
2098599 | 2098599 | 2022-01-09 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2095347 | 2095347 | 2022-01-08 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2092095 | 2092095 | 2022-01-07 | Charles Mix | South Dakota | 46023 | 2236 | 32 |
2088843 | 2088843 | 2022-01-06 | Charles Mix | South Dakota | 46023 | 2218 | 32 |
2085592 | 2085592 | 2022-01-05 | Charles Mix | South Dakota | 46023 | 2192 | 32 |
2082340 | 2082340 | 2022-01-04 | Charles Mix | South Dakota | 46023 | 2148 | 32 |
2079088 | 2079088 | 2022-01-03 | Charles Mix | South Dakota | 46023 | 2141 | 32 |
2075837 | 2075837 | 2022-01-02 | Charles Mix | South Dakota | 46023 | 2137 | 32 |
2072586 | 2072586 | 2022-01-01 | Charles Mix | South Dakota | 46023 | 2137 | 32 |
2069335 | 2069335 | 2021-12-31 | Charles Mix | South Dakota | 46023 | 2137 | 32 |
2066084 | 2066084 | 2021-12-30 | Charles Mix | South Dakota | 46023 | 2137 | 32 |
2062834 | 2062834 | 2021-12-29 | Charles Mix | South Dakota | 46023 | 2131 | 32 |
2059599 | 2059599 | 2021-12-28 | Gregory | South Dakota | 46053 | 847 | 32 |
2056350 | 2056350 | 2021-12-27 | Gregory | South Dakota | 46053 | 844 | 32 |
2053101 | 2053101 | 2021-12-26 | Gregory | South Dakota | 46053 | 844 | 32 |
2049851 | 2049851 | 2021-12-25 | Gregory | South Dakota | 46053 | 844 | 32 |
2046601 | 2046601 | 2021-12-24 | Gregory | South Dakota | 46053 | 844 | 32 |
2043351 | 2043351 | 2021-12-23 | Gregory | South Dakota | 46053 | 844 | 32 |
2040102 | 2040102 | 2021-12-22 | Gregory | South Dakota | 46053 | 841 | 32 |
2036852 | 2036852 | 2021-12-21 | Gregory | South Dakota | 46053 | 839 | 32 |
1968586 | 1968586 | 2021-11-30 | Dewey | South Dakota | 46041 | 2032 | 32 |
1965335 | 1965335 | 2021-11-29 | Dewey | South Dakota | 46041 | 2018 | 32 |
1962083 | 1962083 | 2021-11-28 | Dewey | South Dakota | 46041 | 2016 | 32 |
1958832 | 1958832 | 2021-11-27 | Dewey | South Dakota | 46041 | 2016 | 32 |
1955581 | 1955581 | 2021-11-26 | Dewey | South Dakota | 46041 | 2016 | 32 |
1952330 | 1952330 | 2021-11-25 | Dewey | South Dakota | 46041 | 2016 | 32 |
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);