ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Faulk" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 249 ✖
- 1 72
- 372 55
- 373 24
- 377 19
- 23 16
- 26 16
- 562 15
- 24 14
- 29 14
- 365 14
- 565 14
- 371 13
- 363 11
- 368 11
- 369 11
- 362 10
- 376 8
- 313 7
- 563 7
- 564 7
- 569 7
- 571 7
- 573 7
- 316 6
- 375 6
- 393 6
- 399 6
- 407 6
- 464 6
- 310 5
- 361 5
- 435 5
- 550 5
- 552 5
- 20 4
- 32 4
- 307 4
- 337 4
- 360 4
- 364 4
- 367 4
- 388 4
- 405 4
- 427 4
- 443 4
- 468 4
- 490 4
- 560 4
- 21 3
- 22 3
- 51 3
- 73 3
- 76 3
- 289 3
- 321 3
- 345 3
- 351 3
- 354 3
- 378 3
- 383 3
- 391 3
- 392 3
- 395 3
- 412 3
- 450 3
- 459 3
- 472 3
- 473 3
- 501 3
- 515 3
- 530 3
- 540 3
- 572 3
- 2 2
- 15 2
- 19 2
- 27 2
- 31 2
- 43 2
- 45 2
- 57 2
- 65 2
- 78 2
- 129 2
- 145 2
- 242 2
- 260 2
- 275 2
- 280 2
- 306 2
- 314 2
- 330 2
- 336 2
- 341 2
- 352 2
- 353 2
- 356 2
- 385 2
- 390 2
- 402 2
- 410 2
- 467 2
- 532 2
- 559 2
- 6 1
- 25 1
- 28 1
- 33 1
- 34 1
- 36 1
- 37 1
- 39 1
- 44 1
- 47 1
- 48 1
- 58 1
- 59 1
- 61 1
- 64 1
- 66 1
- 71 1
- 74 1
- 79 1
- 108 1
- 109 1
- 114 1
- 120 1
- 133 1
- 139 1
- 148 1
- 156 1
- 159 1
- 166 1
- 182 1
- 189 1
- 192 1
- 195 1
- 201 1
- 202 1
- 203 1
- 206 1
- 218 1
- 219 1
- 220 1
- 224 1
- 225 1
- 228 1
- 230 1
- 237 1
- 241 1
- 243 1
- 244 1
- 247 1
- 255 1
- 256 1
- 258 1
- 261 1
- 264 1
- 267 1
- 268 1
- 271 1
- 272 1
- 273 1
- 274 1
- 276 1
- 277 1
- 278 1
- 281 1
- 283 1
- 285 1
- 287 1
- 288 1
- 294 1
- 296 1
- 297 1
- 300 1
- 301 1
- 302 1
- 304 1
- 309 1
- 317 1
- 318 1
- 320 1
- 324 1
- 326 1
- 327 1
- 328 1
- 329 1
- 332 1
- 335 1
- 338 1
- 344 1
- 350 1
- 355 1
- 358 1
- 359 1
- 379 1
- 386 1
- 387 1
- 389 1
- 394 1
- 396 1
- 397 1
- 398 1
- 403 1
- 408 1
- 409 1
- 413 1
- 420 1
- 425 1
- 429 1
- 431 1
- 436 1
- 438 1
- 439 1
- 442 1
- 446 1
- 448 1
- 449 1
- 453 1
- 454 1
- 457 1
- 458 1
- 461 1
- 462 1
- 469 1
- 476 1
- 480 1
- 485 1
- 486 1
- 491 1
- 493 1
- 497 1
- 502 1
- 505 1
- 512 1
- 514 1
- 517 1
- 520 1
- 523 1
- 527 1
- 537 1
- 539 1
- 541 1
- 545 1
- 546 1
- 549 1
- 554 1
- 561 1
state 1
- South Dakota · 778 ✖
fips 1
- 46049 778
county 1
- Faulk · 778 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502068 | 2502068 | 2022-05-13 | Faulk | South Dakota | 46049 | 572 | 16 |
2498810 | 2498810 | 2022-05-12 | Faulk | South Dakota | 46049 | 572 | 16 |
2495552 | 2495552 | 2022-05-11 | Faulk | South Dakota | 46049 | 572 | 16 |
2492294 | 2492294 | 2022-05-10 | Faulk | South Dakota | 46049 | 573 | 16 |
2489036 | 2489036 | 2022-05-09 | Faulk | South Dakota | 46049 | 573 | 16 |
2485779 | 2485779 | 2022-05-08 | Faulk | South Dakota | 46049 | 573 | 16 |
2482521 | 2482521 | 2022-05-07 | Faulk | South Dakota | 46049 | 573 | 16 |
2479263 | 2479263 | 2022-05-06 | Faulk | South Dakota | 46049 | 573 | 16 |
2476005 | 2476005 | 2022-05-05 | Faulk | South Dakota | 46049 | 573 | 16 |
2472748 | 2472748 | 2022-05-04 | Faulk | South Dakota | 46049 | 573 | 16 |
2469492 | 2469492 | 2022-05-03 | Faulk | South Dakota | 46049 | 571 | 16 |
2466236 | 2466236 | 2022-05-02 | Faulk | South Dakota | 46049 | 571 | 16 |
2462981 | 2462981 | 2022-05-01 | Faulk | South Dakota | 46049 | 571 | 16 |
2459725 | 2459725 | 2022-04-30 | Faulk | South Dakota | 46049 | 571 | 16 |
2456469 | 2456469 | 2022-04-29 | Faulk | South Dakota | 46049 | 571 | 16 |
2453213 | 2453213 | 2022-04-28 | Faulk | South Dakota | 46049 | 571 | 16 |
2449957 | 2449957 | 2022-04-27 | Faulk | South Dakota | 46049 | 571 | 16 |
2446700 | 2446700 | 2022-04-26 | Faulk | South Dakota | 46049 | 569 | 16 |
2443445 | 2443445 | 2022-04-25 | Faulk | South Dakota | 46049 | 569 | 16 |
2440189 | 2440189 | 2022-04-24 | Faulk | South Dakota | 46049 | 569 | 16 |
2436933 | 2436933 | 2022-04-23 | Faulk | South Dakota | 46049 | 569 | 16 |
2433677 | 2433677 | 2022-04-22 | Faulk | South Dakota | 46049 | 569 | 16 |
2430421 | 2430421 | 2022-04-21 | Faulk | South Dakota | 46049 | 569 | 16 |
2427165 | 2427165 | 2022-04-20 | Faulk | South Dakota | 46049 | 569 | 16 |
2423909 | 2423909 | 2022-04-19 | Faulk | South Dakota | 46049 | 565 | 16 |
2420653 | 2420653 | 2022-04-18 | Faulk | South Dakota | 46049 | 565 | 16 |
2417397 | 2417397 | 2022-04-17 | Faulk | South Dakota | 46049 | 565 | 16 |
2414141 | 2414141 | 2022-04-16 | Faulk | South Dakota | 46049 | 565 | 16 |
2410885 | 2410885 | 2022-04-15 | Faulk | South Dakota | 46049 | 565 | 16 |
2407629 | 2407629 | 2022-04-14 | Faulk | South Dakota | 46049 | 565 | 16 |
2404373 | 2404373 | 2022-04-13 | Faulk | South Dakota | 46049 | 565 | 16 |
2401118 | 2401118 | 2022-04-12 | Faulk | South Dakota | 46049 | 565 | 16 |
2397863 | 2397863 | 2022-04-11 | Faulk | South Dakota | 46049 | 565 | 16 |
2394608 | 2394608 | 2022-04-10 | Faulk | South Dakota | 46049 | 565 | 16 |
2391352 | 2391352 | 2022-04-09 | Faulk | South Dakota | 46049 | 565 | 16 |
2388096 | 2388096 | 2022-04-08 | Faulk | South Dakota | 46049 | 565 | 16 |
2384841 | 2384841 | 2022-04-07 | Faulk | South Dakota | 46049 | 565 | 16 |
2381586 | 2381586 | 2022-04-06 | Faulk | South Dakota | 46049 | 565 | 16 |
2378331 | 2378331 | 2022-04-05 | Faulk | South Dakota | 46049 | 564 | 16 |
2375077 | 2375077 | 2022-04-04 | Faulk | South Dakota | 46049 | 564 | 16 |
2371825 | 2371825 | 2022-04-03 | Faulk | South Dakota | 46049 | 564 | 16 |
2368572 | 2368572 | 2022-04-02 | Faulk | South Dakota | 46049 | 564 | 16 |
2365319 | 2365319 | 2022-04-01 | Faulk | South Dakota | 46049 | 564 | 16 |
2362066 | 2362066 | 2022-03-31 | Faulk | South Dakota | 46049 | 564 | 16 |
2358812 | 2358812 | 2022-03-30 | Faulk | South Dakota | 46049 | 564 | 16 |
2355558 | 2355558 | 2022-03-29 | Faulk | South Dakota | 46049 | 563 | 16 |
2352305 | 2352305 | 2022-03-28 | Faulk | South Dakota | 46049 | 563 | 16 |
2349053 | 2349053 | 2022-03-27 | Faulk | South Dakota | 46049 | 563 | 16 |
2345800 | 2345800 | 2022-03-26 | Faulk | South Dakota | 46049 | 563 | 16 |
2342547 | 2342547 | 2022-03-25 | Faulk | South Dakota | 46049 | 563 | 16 |
2339294 | 2339294 | 2022-03-24 | Faulk | South Dakota | 46049 | 563 | 16 |
2336040 | 2336040 | 2022-03-23 | Faulk | South Dakota | 46049 | 563 | 16 |
2332786 | 2332786 | 2022-03-22 | Faulk | South Dakota | 46049 | 562 | 16 |
2329533 | 2329533 | 2022-03-21 | Faulk | South Dakota | 46049 | 562 | 16 |
2326281 | 2326281 | 2022-03-20 | Faulk | South Dakota | 46049 | 562 | 16 |
2323028 | 2323028 | 2022-03-19 | Faulk | South Dakota | 46049 | 562 | 16 |
2319774 | 2319774 | 2022-03-18 | Faulk | South Dakota | 46049 | 562 | 16 |
2316520 | 2316520 | 2022-03-17 | Faulk | South Dakota | 46049 | 562 | 16 |
2313267 | 2313267 | 2022-03-16 | Faulk | South Dakota | 46049 | 562 | 16 |
2310014 | 2310014 | 2022-03-15 | Faulk | South Dakota | 46049 | 562 | 16 |
2306761 | 2306761 | 2022-03-14 | Faulk | South Dakota | 46049 | 562 | 16 |
2303510 | 2303510 | 2022-03-13 | Faulk | South Dakota | 46049 | 562 | 16 |
2300258 | 2300258 | 2022-03-12 | Faulk | South Dakota | 46049 | 562 | 16 |
2297006 | 2297006 | 2022-03-11 | Faulk | South Dakota | 46049 | 562 | 16 |
2293754 | 2293754 | 2022-03-10 | Faulk | South Dakota | 46049 | 562 | 16 |
2290502 | 2290502 | 2022-03-09 | Faulk | South Dakota | 46049 | 562 | 16 |
2287250 | 2287250 | 2022-03-08 | Faulk | South Dakota | 46049 | 562 | 16 |
2283998 | 2283998 | 2022-03-07 | Faulk | South Dakota | 46049 | 561 | 16 |
2280746 | 2280746 | 2022-03-06 | Faulk | South Dakota | 46049 | 560 | 16 |
2277493 | 2277493 | 2022-03-05 | Faulk | South Dakota | 46049 | 560 | 16 |
2274240 | 2274240 | 2022-03-04 | Faulk | South Dakota | 46049 | 560 | 16 |
2270987 | 2270987 | 2022-03-03 | Faulk | South Dakota | 46049 | 560 | 16 |
2267735 | 2267735 | 2022-03-02 | Faulk | South Dakota | 46049 | 559 | 16 |
2264482 | 2264482 | 2022-03-01 | Faulk | South Dakota | 46049 | 559 | 16 |
2261232 | 2261232 | 2022-02-28 | Faulk | South Dakota | 46049 | 554 | 16 |
2257981 | 2257981 | 2022-02-27 | Faulk | South Dakota | 46049 | 552 | 16 |
2254730 | 2254730 | 2022-02-26 | Faulk | South Dakota | 46049 | 552 | 16 |
2251479 | 2251479 | 2022-02-25 | Faulk | South Dakota | 46049 | 552 | 16 |
2248228 | 2248228 | 2022-02-24 | Faulk | South Dakota | 46049 | 552 | 16 |
2244977 | 2244977 | 2022-02-23 | Faulk | South Dakota | 46049 | 552 | 16 |
2241726 | 2241726 | 2022-02-22 | Faulk | South Dakota | 46049 | 550 | 16 |
2238475 | 2238475 | 2022-02-21 | Faulk | South Dakota | 46049 | 550 | 16 |
2235224 | 2235224 | 2022-02-20 | Faulk | South Dakota | 46049 | 550 | 16 |
2231973 | 2231973 | 2022-02-19 | Faulk | South Dakota | 46049 | 550 | 16 |
2228722 | 2228722 | 2022-02-18 | Faulk | South Dakota | 46049 | 550 | 16 |
2225471 | 2225471 | 2022-02-17 | Faulk | South Dakota | 46049 | 549 | 16 |
2222220 | 2222220 | 2022-02-16 | Faulk | South Dakota | 46049 | 546 | 16 |
2218969 | 2218969 | 2022-02-15 | Faulk | South Dakota | 46049 | 545 | 16 |
2215718 | 2215718 | 2022-02-14 | Faulk | South Dakota | 46049 | 541 | 16 |
2212467 | 2212467 | 2022-02-13 | Faulk | South Dakota | 46049 | 540 | 16 |
2209214 | 2209214 | 2022-02-12 | Faulk | South Dakota | 46049 | 540 | 16 |
2205961 | 2205961 | 2022-02-11 | Faulk | South Dakota | 46049 | 540 | 16 |
2202708 | 2202708 | 2022-02-10 | Faulk | South Dakota | 46049 | 539 | 16 |
2199454 | 2199454 | 2022-02-09 | Faulk | South Dakota | 46049 | 537 | 16 |
2196200 | 2196200 | 2022-02-08 | Faulk | South Dakota | 46049 | 532 | 16 |
2192946 | 2192946 | 2022-02-07 | Faulk | South Dakota | 46049 | 532 | 16 |
2189692 | 2189692 | 2022-02-06 | Faulk | South Dakota | 46049 | 530 | 16 |
2186439 | 2186439 | 2022-02-05 | Faulk | South Dakota | 46049 | 530 | 16 |
2183187 | 2183187 | 2022-02-04 | Faulk | South Dakota | 46049 | 530 | 16 |
2179935 | 2179935 | 2022-02-03 | Faulk | South Dakota | 46049 | 527 | 16 |
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);