ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
749 rows where fips = 46089 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 206 ✖
- 247 51
- 425 48
- 1 42
- 248 27
- 246 26
- 426 26
- 243 24
- 240 23
- 6 22
- 8 15
- 237 15
- 362 15
- 3 12
- 4 12
- 10 12
- 5 9
- 72 7
- 236 7
- 241 7
- 307 7
- 178 6
- 234 6
- 360 6
- 422 6
- 42 5
- 239 5
- 273 5
- 352 5
- 359 5
- 417 5
- 424 5
- 33 4
- 73 4
- 157 4
- 244 4
- 261 4
- 313 4
- 315 4
- 324 4
- 348 4
- 358 4
- 361 4
- 381 4
- 415 4
- 2 3
- 7 3
- 16 3
- 19 3
- 27 3
- 29 3
- 173 3
- 238 3
- 242 3
- 249 3
- 250 3
- 256 3
- 257 3
- 268 3
- 292 3
- 302 3
- 312 3
- 333 3
- 343 3
- 363 3
- 365 3
- 400 3
- 408 3
- 11 2
- 12 2
- 18 2
- 48 2
- 49 2
- 54 2
- 56 2
- 78 2
- 140 2
- 153 2
- 161 2
- 162 2
- 181 2
- 183 2
- 196 2
- 221 2
- 232 2
- 252 2
- 339 2
- 345 2
- 401 2
- 407 2
- 414 2
- 9 1
- 14 1
- 20 1
- 22 1
- 25 1
- 31 1
- 36 1
- 37 1
- 38 1
- 40 1
- 43 1
- 47 1
- 51 1
- 53 1
- 59 1
- 61 1
- 62 1
- 63 1
- 64 1
- 66 1
- 67 1
- 69 1
- 74 1
- 83 1
- 86 1
- 92 1
- 101 1
- 108 1
- 110 1
- 112 1
- 117 1
- 122 1
- 129 1
- 133 1
- 136 1
- 137 1
- 146 1
- 148 1
- 149 1
- 150 1
- 151 1
- 155 1
- 156 1
- 159 1
- 163 1
- 168 1
- 169 1
- 170 1
- 174 1
- 175 1
- 180 1
- 182 1
- 186 1
- 189 1
- 191 1
- 195 1
- 199 1
- 202 1
- 211 1
- 215 1
- 217 1
- 219 1
- 222 1
- 225 1
- 228 1
- 231 1
- 233 1
- 235 1
- 245 1
- 254 1
- 255 1
- 259 1
- 262 1
- 265 1
- 266 1
- 269 1
- 271 1
- 278 1
- 280 1
- 285 1
- 291 1
- 293 1
- 295 1
- 297 1
- 301 1
- 305 1
- 306 1
- 308 1
- 310 1
- 320 1
- 321 1
- 323 1
- 325 1
- 330 1
- 331 1
- 336 1
- 338 1
- 347 1
- 350 1
- 351 1
- 354 1
- 357 1
- 366 1
- 368 1
- 371 1
- 375 1
- 383 1
- 394 1
- 397 1
- 410 1
- 412 1
- 416 1
- 419 1
- 420 1
- 421 1
- 423 1
state 1
- South Dakota · 749 ✖
fips 1
- 46089 · 749 ✖
county 1
- McPherson 749
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502089 | 2502089 | 2022-05-13 | McPherson | South Dakota | 46089 | 426 | 9 |
2498831 | 2498831 | 2022-05-12 | McPherson | South Dakota | 46089 | 426 | 9 |
2495573 | 2495573 | 2022-05-11 | McPherson | South Dakota | 46089 | 426 | 9 |
2492315 | 2492315 | 2022-05-10 | McPherson | South Dakota | 46089 | 426 | 9 |
2489057 | 2489057 | 2022-05-09 | McPherson | South Dakota | 46089 | 426 | 9 |
2485800 | 2485800 | 2022-05-08 | McPherson | South Dakota | 46089 | 426 | 9 |
2482542 | 2482542 | 2022-05-07 | McPherson | South Dakota | 46089 | 426 | 9 |
2479284 | 2479284 | 2022-05-06 | McPherson | South Dakota | 46089 | 426 | 9 |
2476026 | 2476026 | 2022-05-05 | McPherson | South Dakota | 46089 | 426 | 9 |
2472769 | 2472769 | 2022-05-04 | McPherson | South Dakota | 46089 | 426 | 9 |
2469513 | 2469513 | 2022-05-03 | McPherson | South Dakota | 46089 | 426 | 9 |
2466257 | 2466257 | 2022-05-02 | McPherson | South Dakota | 46089 | 426 | 9 |
2463002 | 2463002 | 2022-05-01 | McPherson | South Dakota | 46089 | 426 | 9 |
2459746 | 2459746 | 2022-04-30 | McPherson | South Dakota | 46089 | 426 | 9 |
2456490 | 2456490 | 2022-04-29 | McPherson | South Dakota | 46089 | 426 | 9 |
2453234 | 2453234 | 2022-04-28 | McPherson | South Dakota | 46089 | 426 | 9 |
2449978 | 2449978 | 2022-04-27 | McPherson | South Dakota | 46089 | 426 | 9 |
2446721 | 2446721 | 2022-04-26 | McPherson | South Dakota | 46089 | 425 | 9 |
2443466 | 2443466 | 2022-04-25 | McPherson | South Dakota | 46089 | 425 | 9 |
2440210 | 2440210 | 2022-04-24 | McPherson | South Dakota | 46089 | 425 | 9 |
2436954 | 2436954 | 2022-04-23 | McPherson | South Dakota | 46089 | 425 | 9 |
2433698 | 2433698 | 2022-04-22 | McPherson | South Dakota | 46089 | 425 | 9 |
2430442 | 2430442 | 2022-04-21 | McPherson | South Dakota | 46089 | 425 | 9 |
2427186 | 2427186 | 2022-04-20 | McPherson | South Dakota | 46089 | 425 | 9 |
2423930 | 2423930 | 2022-04-19 | McPherson | South Dakota | 46089 | 425 | 9 |
2420674 | 2420674 | 2022-04-18 | McPherson | South Dakota | 46089 | 425 | 9 |
2417418 | 2417418 | 2022-04-17 | McPherson | South Dakota | 46089 | 425 | 9 |
2414162 | 2414162 | 2022-04-16 | McPherson | South Dakota | 46089 | 425 | 9 |
2410906 | 2410906 | 2022-04-15 | McPherson | South Dakota | 46089 | 425 | 9 |
2407650 | 2407650 | 2022-04-14 | McPherson | South Dakota | 46089 | 425 | 9 |
2404394 | 2404394 | 2022-04-13 | McPherson | South Dakota | 46089 | 425 | 9 |
2401139 | 2401139 | 2022-04-12 | McPherson | South Dakota | 46089 | 425 | 9 |
2397884 | 2397884 | 2022-04-11 | McPherson | South Dakota | 46089 | 425 | 9 |
2394629 | 2394629 | 2022-04-10 | McPherson | South Dakota | 46089 | 425 | 9 |
2391373 | 2391373 | 2022-04-09 | McPherson | South Dakota | 46089 | 425 | 9 |
2388117 | 2388117 | 2022-04-08 | McPherson | South Dakota | 46089 | 425 | 9 |
2384862 | 2384862 | 2022-04-07 | McPherson | South Dakota | 46089 | 425 | 9 |
2381607 | 2381607 | 2022-04-06 | McPherson | South Dakota | 46089 | 425 | 9 |
2378352 | 2378352 | 2022-04-05 | McPherson | South Dakota | 46089 | 425 | 9 |
2375098 | 2375098 | 2022-04-04 | McPherson | South Dakota | 46089 | 425 | 9 |
2371846 | 2371846 | 2022-04-03 | McPherson | South Dakota | 46089 | 425 | 9 |
2368593 | 2368593 | 2022-04-02 | McPherson | South Dakota | 46089 | 425 | 9 |
2365340 | 2365340 | 2022-04-01 | McPherson | South Dakota | 46089 | 425 | 9 |
2362087 | 2362087 | 2022-03-31 | McPherson | South Dakota | 46089 | 425 | 9 |
2358833 | 2358833 | 2022-03-30 | McPherson | South Dakota | 46089 | 425 | 9 |
2355579 | 2355579 | 2022-03-29 | McPherson | South Dakota | 46089 | 425 | 9 |
2352326 | 2352326 | 2022-03-28 | McPherson | South Dakota | 46089 | 425 | 9 |
2349074 | 2349074 | 2022-03-27 | McPherson | South Dakota | 46089 | 425 | 9 |
2345821 | 2345821 | 2022-03-26 | McPherson | South Dakota | 46089 | 425 | 9 |
2342568 | 2342568 | 2022-03-25 | McPherson | South Dakota | 46089 | 425 | 9 |
2339315 | 2339315 | 2022-03-24 | McPherson | South Dakota | 46089 | 425 | 9 |
2336061 | 2336061 | 2022-03-23 | McPherson | South Dakota | 46089 | 425 | 9 |
2332807 | 2332807 | 2022-03-22 | McPherson | South Dakota | 46089 | 425 | 9 |
2329554 | 2329554 | 2022-03-21 | McPherson | South Dakota | 46089 | 425 | 9 |
2326302 | 2326302 | 2022-03-20 | McPherson | South Dakota | 46089 | 425 | 9 |
2323049 | 2323049 | 2022-03-19 | McPherson | South Dakota | 46089 | 425 | 9 |
2319795 | 2319795 | 2022-03-18 | McPherson | South Dakota | 46089 | 425 | 9 |
2316541 | 2316541 | 2022-03-17 | McPherson | South Dakota | 46089 | 425 | 9 |
2313288 | 2313288 | 2022-03-16 | McPherson | South Dakota | 46089 | 425 | 9 |
2310035 | 2310035 | 2022-03-15 | McPherson | South Dakota | 46089 | 425 | 9 |
2306782 | 2306782 | 2022-03-14 | McPherson | South Dakota | 46089 | 425 | 9 |
2303531 | 2303531 | 2022-03-13 | McPherson | South Dakota | 46089 | 425 | 9 |
2300279 | 2300279 | 2022-03-12 | McPherson | South Dakota | 46089 | 425 | 9 |
2297027 | 2297027 | 2022-03-11 | McPherson | South Dakota | 46089 | 425 | 9 |
2293775 | 2293775 | 2022-03-10 | McPherson | South Dakota | 46089 | 425 | 9 |
2290523 | 2290523 | 2022-03-09 | McPherson | South Dakota | 46089 | 426 | 9 |
2287271 | 2287271 | 2022-03-08 | McPherson | South Dakota | 46089 | 426 | 9 |
2284019 | 2284019 | 2022-03-07 | McPherson | South Dakota | 46089 | 426 | 9 |
2280767 | 2280767 | 2022-03-06 | McPherson | South Dakota | 46089 | 426 | 9 |
2277514 | 2277514 | 2022-03-05 | McPherson | South Dakota | 46089 | 426 | 9 |
2274261 | 2274261 | 2022-03-04 | McPherson | South Dakota | 46089 | 426 | 9 |
2271008 | 2271008 | 2022-03-03 | McPherson | South Dakota | 46089 | 426 | 9 |
2267756 | 2267756 | 2022-03-02 | McPherson | South Dakota | 46089 | 426 | 9 |
2264503 | 2264503 | 2022-03-01 | McPherson | South Dakota | 46089 | 426 | 9 |
2261253 | 2261253 | 2022-02-28 | McPherson | South Dakota | 46089 | 424 | 9 |
2258002 | 2258002 | 2022-02-27 | McPherson | South Dakota | 46089 | 424 | 9 |
2254751 | 2254751 | 2022-02-26 | McPherson | South Dakota | 46089 | 424 | 9 |
2251500 | 2251500 | 2022-02-25 | McPherson | South Dakota | 46089 | 424 | 9 |
2248249 | 2248249 | 2022-02-24 | McPherson | South Dakota | 46089 | 424 | 9 |
2244998 | 2244998 | 2022-02-23 | McPherson | South Dakota | 46089 | 423 | 9 |
2241747 | 2241747 | 2022-02-22 | McPherson | South Dakota | 46089 | 422 | 9 |
2238496 | 2238496 | 2022-02-21 | McPherson | South Dakota | 46089 | 422 | 9 |
2235245 | 2235245 | 2022-02-20 | McPherson | South Dakota | 46089 | 422 | 9 |
2231994 | 2231994 | 2022-02-19 | McPherson | South Dakota | 46089 | 422 | 9 |
2228743 | 2228743 | 2022-02-18 | McPherson | South Dakota | 46089 | 422 | 9 |
2225492 | 2225492 | 2022-02-17 | McPherson | South Dakota | 46089 | 422 | 9 |
2222241 | 2222241 | 2022-02-16 | McPherson | South Dakota | 46089 | 421 | 9 |
2218990 | 2218990 | 2022-02-15 | McPherson | South Dakota | 46089 | 420 | 9 |
2215739 | 2215739 | 2022-02-14 | McPherson | South Dakota | 46089 | 419 | 9 |
2212488 | 2212488 | 2022-02-13 | McPherson | South Dakota | 46089 | 417 | 9 |
2209235 | 2209235 | 2022-02-12 | McPherson | South Dakota | 46089 | 417 | 9 |
2205982 | 2205982 | 2022-02-11 | McPherson | South Dakota | 46089 | 417 | 9 |
2202729 | 2202729 | 2022-02-10 | McPherson | South Dakota | 46089 | 417 | 9 |
2199475 | 2199475 | 2022-02-09 | McPherson | South Dakota | 46089 | 417 | 9 |
2196221 | 2196221 | 2022-02-08 | McPherson | South Dakota | 46089 | 416 | 9 |
2192967 | 2192967 | 2022-02-07 | McPherson | South Dakota | 46089 | 415 | 9 |
2189713 | 2189713 | 2022-02-06 | McPherson | South Dakota | 46089 | 415 | 9 |
2186460 | 2186460 | 2022-02-05 | McPherson | South Dakota | 46089 | 415 | 9 |
2183208 | 2183208 | 2022-02-04 | McPherson | South Dakota | 46089 | 415 | 9 |
2179956 | 2179956 | 2022-02-03 | McPherson | South Dakota | 46089 | 414 | 9 |
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);