ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where county = "Kingsbury", deaths = 20 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 |
---|---|---|---|---|---|---|---|
2267749 | 2267749 | 2022-03-02 | Kingsbury | South Dakota | 46077 | 1305 | 20 |
2264496 | 2264496 | 2022-03-01 | Kingsbury | South Dakota | 46077 | 1304 | 20 |
2261246 | 2261246 | 2022-02-28 | Kingsbury | South Dakota | 46077 | 1302 | 20 |
2257995 | 2257995 | 2022-02-27 | Kingsbury | South Dakota | 46077 | 1299 | 20 |
2254744 | 2254744 | 2022-02-26 | Kingsbury | South Dakota | 46077 | 1299 | 20 |
2251493 | 2251493 | 2022-02-25 | Kingsbury | South Dakota | 46077 | 1299 | 20 |
2248242 | 2248242 | 2022-02-24 | Kingsbury | South Dakota | 46077 | 1298 | 20 |
2244991 | 2244991 | 2022-02-23 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2241740 | 2241740 | 2022-02-22 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2238489 | 2238489 | 2022-02-21 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2235238 | 2235238 | 2022-02-20 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2231987 | 2231987 | 2022-02-19 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2228736 | 2228736 | 2022-02-18 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2225485 | 2225485 | 2022-02-17 | Kingsbury | South Dakota | 46077 | 1296 | 20 |
2222234 | 2222234 | 2022-02-16 | Kingsbury | South Dakota | 46077 | 1296 | 20 |
2218983 | 2218983 | 2022-02-15 | Kingsbury | South Dakota | 46077 | 1294 | 20 |
2215732 | 2215732 | 2022-02-14 | Kingsbury | South Dakota | 46077 | 1292 | 20 |
2212481 | 2212481 | 2022-02-13 | Kingsbury | South Dakota | 46077 | 1290 | 20 |
2209228 | 2209228 | 2022-02-12 | Kingsbury | South Dakota | 46077 | 1290 | 20 |
2205975 | 2205975 | 2022-02-11 | Kingsbury | South Dakota | 46077 | 1290 | 20 |
2202722 | 2202722 | 2022-02-10 | Kingsbury | South Dakota | 46077 | 1287 | 20 |
2199468 | 2199468 | 2022-02-09 | Kingsbury | South Dakota | 46077 | 1285 | 20 |
2196214 | 2196214 | 2022-02-08 | Kingsbury | South Dakota | 46077 | 1280 | 20 |
2192960 | 2192960 | 2022-02-07 | Kingsbury | South Dakota | 46077 | 1278 | 20 |
2189706 | 2189706 | 2022-02-06 | Kingsbury | South Dakota | 46077 | 1277 | 20 |
2186453 | 2186453 | 2022-02-05 | Kingsbury | South Dakota | 46077 | 1277 | 20 |
2183201 | 2183201 | 2022-02-04 | Kingsbury | South Dakota | 46077 | 1277 | 20 |
2179949 | 2179949 | 2022-02-03 | Kingsbury | South Dakota | 46077 | 1277 | 20 |
2176698 | 2176698 | 2022-02-02 | Kingsbury | South Dakota | 46077 | 1274 | 20 |
2173444 | 2173444 | 2022-02-01 | Kingsbury | South Dakota | 46077 | 1271 | 20 |
2170192 | 2170192 | 2022-01-31 | Kingsbury | South Dakota | 46077 | 1256 | 20 |
2166938 | 2166938 | 2022-01-30 | Kingsbury | South Dakota | 46077 | 1252 | 20 |
2163683 | 2163683 | 2022-01-29 | Kingsbury | South Dakota | 46077 | 1252 | 20 |
2160428 | 2160428 | 2022-01-28 | Kingsbury | South Dakota | 46077 | 1252 | 20 |
2157172 | 2157172 | 2022-01-27 | Kingsbury | South Dakota | 46077 | 1240 | 20 |
2153919 | 2153919 | 2022-01-26 | Kingsbury | South Dakota | 46077 | 1224 | 20 |
2150667 | 2150667 | 2022-01-25 | Kingsbury | South Dakota | 46077 | 1212 | 20 |
2147415 | 2147415 | 2022-01-24 | Kingsbury | South Dakota | 46077 | 1192 | 20 |
2144161 | 2144161 | 2022-01-23 | Kingsbury | South Dakota | 46077 | 1178 | 20 |
2140906 | 2140906 | 2022-01-22 | Kingsbury | South Dakota | 46077 | 1178 | 20 |
2137650 | 2137650 | 2022-01-21 | Kingsbury | South Dakota | 46077 | 1178 | 20 |
2134396 | 2134396 | 2022-01-20 | Kingsbury | South Dakota | 46077 | 1164 | 20 |
2131144 | 2131144 | 2022-01-19 | Kingsbury | South Dakota | 46077 | 1154 | 20 |
2127890 | 2127890 | 2022-01-18 | Kingsbury | South Dakota | 46077 | 1124 | 20 |
2124638 | 2124638 | 2022-01-17 | Kingsbury | South Dakota | 46077 | 1119 | 20 |
2121386 | 2121386 | 2022-01-16 | Kingsbury | South Dakota | 46077 | 1119 | 20 |
2118134 | 2118134 | 2022-01-15 | Kingsbury | South Dakota | 46077 | 1119 | 20 |
2114883 | 2114883 | 2022-01-14 | Kingsbury | South Dakota | 46077 | 1119 | 20 |
2111631 | 2111631 | 2022-01-13 | Kingsbury | South Dakota | 46077 | 1110 | 20 |
2108379 | 2108379 | 2022-01-12 | Kingsbury | South Dakota | 46077 | 1105 | 20 |
2105128 | 2105128 | 2022-01-11 | Kingsbury | South Dakota | 46077 | 1089 | 20 |
2101877 | 2101877 | 2022-01-10 | Kingsbury | South Dakota | 46077 | 1076 | 20 |
2098626 | 2098626 | 2022-01-09 | Kingsbury | South Dakota | 46077 | 1070 | 20 |
2095374 | 2095374 | 2022-01-08 | Kingsbury | South Dakota | 46077 | 1070 | 20 |
2092122 | 2092122 | 2022-01-07 | Kingsbury | South Dakota | 46077 | 1070 | 20 |
2088870 | 2088870 | 2022-01-06 | Kingsbury | South Dakota | 46077 | 1066 | 20 |
2085619 | 2085619 | 2022-01-05 | Kingsbury | South Dakota | 46077 | 1056 | 20 |
2082367 | 2082367 | 2022-01-04 | Kingsbury | South Dakota | 46077 | 1040 | 20 |
2079115 | 2079115 | 2022-01-03 | Kingsbury | South Dakota | 46077 | 1030 | 20 |
2075864 | 2075864 | 2022-01-02 | Kingsbury | South Dakota | 46077 | 1028 | 20 |
2072613 | 2072613 | 2022-01-01 | Kingsbury | South Dakota | 46077 | 1028 | 20 |
2069362 | 2069362 | 2021-12-31 | Kingsbury | South Dakota | 46077 | 1028 | 20 |
2066111 | 2066111 | 2021-12-30 | Kingsbury | South Dakota | 46077 | 1028 | 20 |
2062861 | 2062861 | 2021-12-29 | Kingsbury | South Dakota | 46077 | 1023 | 20 |
2059611 | 2059611 | 2021-12-28 | Kingsbury | South Dakota | 46077 | 1022 | 20 |
2056362 | 2056362 | 2021-12-27 | Kingsbury | South Dakota | 46077 | 1019 | 20 |
2053113 | 2053113 | 2021-12-26 | Kingsbury | South Dakota | 46077 | 1017 | 20 |
2049863 | 2049863 | 2021-12-25 | Kingsbury | South Dakota | 46077 | 1017 | 20 |
2046613 | 2046613 | 2021-12-24 | Kingsbury | South Dakota | 46077 | 1017 | 20 |
2043363 | 2043363 | 2021-12-23 | Kingsbury | South Dakota | 46077 | 1017 | 20 |
2040114 | 2040114 | 2021-12-22 | Kingsbury | South Dakota | 46077 | 1012 | 20 |
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);