ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Fall River" and state = "South Dakota" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
311617 | 311617 | 2020-07-07 | Fall River | South Dakota | 46047 | 12 | 0 |
314790 | 314790 | 2020-07-08 | Fall River | South Dakota | 46047 | 13 | 0 |
317963 | 317963 | 2020-07-09 | Fall River | South Dakota | 46047 | 13 | 0 |
321141 | 321141 | 2020-07-10 | Fall River | South Dakota | 46047 | 13 | 0 |
324321 | 324321 | 2020-07-11 | Fall River | South Dakota | 46047 | 13 | 0 |
327506 | 327506 | 2020-07-12 | Fall River | South Dakota | 46047 | 13 | 0 |
330692 | 330692 | 2020-07-13 | Fall River | South Dakota | 46047 | 13 | 0 |
333884 | 333884 | 2020-07-14 | Fall River | South Dakota | 46047 | 13 | 0 |
337078 | 337078 | 2020-07-15 | Fall River | South Dakota | 46047 | 13 | 0 |
340275 | 340275 | 2020-07-16 | Fall River | South Dakota | 46047 | 14 | 0 |
343473 | 343473 | 2020-07-17 | Fall River | South Dakota | 46047 | 14 | 0 |
346673 | 346673 | 2020-07-18 | Fall River | South Dakota | 46047 | 14 | 0 |
349873 | 349873 | 2020-07-19 | Fall River | South Dakota | 46047 | 14 | 0 |
353076 | 353076 | 2020-07-20 | Fall River | South Dakota | 46047 | 14 | 0 |
356279 | 356279 | 2020-07-21 | Fall River | South Dakota | 46047 | 14 | 0 |
359483 | 359483 | 2020-07-22 | Fall River | South Dakota | 46047 | 14 | 0 |
362689 | 362689 | 2020-07-23 | Fall River | South Dakota | 46047 | 14 | 0 |
365895 | 365895 | 2020-07-24 | Fall River | South Dakota | 46047 | 14 | 0 |
369104 | 369104 | 2020-07-25 | Fall River | South Dakota | 46047 | 14 | 0 |
372316 | 372316 | 2020-07-26 | Fall River | South Dakota | 46047 | 14 | 0 |
375529 | 375529 | 2020-07-27 | Fall River | South Dakota | 46047 | 14 | 0 |
378745 | 378745 | 2020-07-28 | Fall River | South Dakota | 46047 | 14 | 0 |
381962 | 381962 | 2020-07-29 | Fall River | South Dakota | 46047 | 14 | 0 |
385180 | 385180 | 2020-07-30 | Fall River | South Dakota | 46047 | 14 | 0 |
388397 | 388397 | 2020-07-31 | Fall River | South Dakota | 46047 | 14 | 0 |
391614 | 391614 | 2020-08-01 | Fall River | South Dakota | 46047 | 15 | 0 |
394830 | 394830 | 2020-08-02 | Fall River | South Dakota | 46047 | 16 | 0 |
398047 | 398047 | 2020-08-03 | Fall River | South Dakota | 46047 | 16 | 0 |
401262 | 401262 | 2020-08-04 | Fall River | South Dakota | 46047 | 18 | 0 |
404480 | 404480 | 2020-08-05 | Fall River | South Dakota | 46047 | 20 | 0 |
407700 | 407700 | 2020-08-06 | Fall River | South Dakota | 46047 | 20 | 0 |
410919 | 410919 | 2020-08-07 | Fall River | South Dakota | 46047 | 22 | 0 |
414139 | 414139 | 2020-08-08 | Fall River | South Dakota | 46047 | 22 | 0 |
417360 | 417360 | 2020-08-09 | Fall River | South Dakota | 46047 | 22 | 0 |
420581 | 420581 | 2020-08-10 | Fall River | South Dakota | 46047 | 22 | 0 |
423803 | 423803 | 2020-08-11 | Fall River | South Dakota | 46047 | 22 | 0 |
427026 | 427026 | 2020-08-12 | Fall River | South Dakota | 46047 | 22 | 0 |
430252 | 430252 | 2020-08-13 | Fall River | South Dakota | 46047 | 22 | 0 |
433477 | 433477 | 2020-08-14 | Fall River | South Dakota | 46047 | 22 | 0 |
436704 | 436704 | 2020-08-15 | Fall River | South Dakota | 46047 | 23 | 0 |
439929 | 439929 | 2020-08-16 | Fall River | South Dakota | 46047 | 23 | 0 |
443156 | 443156 | 2020-08-17 | Fall River | South Dakota | 46047 | 23 | 0 |
446382 | 446382 | 2020-08-18 | Fall River | South Dakota | 46047 | 23 | 0 |
449610 | 449610 | 2020-08-19 | Fall River | South Dakota | 46047 | 23 | 0 |
452838 | 452838 | 2020-08-20 | Fall River | South Dakota | 46047 | 23 | 0 |
456066 | 456066 | 2020-08-21 | Fall River | South Dakota | 46047 | 23 | 0 |
459294 | 459294 | 2020-08-22 | Fall River | South Dakota | 46047 | 23 | 0 |
462522 | 462522 | 2020-08-23 | Fall River | South Dakota | 46047 | 23 | 0 |
465751 | 465751 | 2020-08-24 | Fall River | South Dakota | 46047 | 24 | 0 |
468979 | 468979 | 2020-08-25 | Fall River | South Dakota | 46047 | 24 | 0 |
472211 | 472211 | 2020-08-26 | Fall River | South Dakota | 46047 | 27 | 0 |
475445 | 475445 | 2020-08-27 | Fall River | South Dakota | 46047 | 32 | 0 |
478678 | 478678 | 2020-08-28 | Fall River | South Dakota | 46047 | 32 | 1 |
481912 | 481912 | 2020-08-29 | Fall River | South Dakota | 46047 | 34 | 1 |
485147 | 485147 | 2020-08-30 | Fall River | South Dakota | 46047 | 38 | 1 |
488380 | 488380 | 2020-08-31 | Fall River | South Dakota | 46047 | 42 | 1 |
491613 | 491613 | 2020-09-01 | Fall River | South Dakota | 46047 | 50 | 1 |
494847 | 494847 | 2020-09-02 | Fall River | South Dakota | 46047 | 56 | 1 |
498080 | 498080 | 2020-09-03 | Fall River | South Dakota | 46047 | 58 | 1 |
501314 | 501314 | 2020-09-04 | Fall River | South Dakota | 46047 | 60 | 1 |
504548 | 504548 | 2020-09-05 | Fall River | South Dakota | 46047 | 63 | 1 |
507780 | 507780 | 2020-09-06 | Fall River | South Dakota | 46047 | 65 | 1 |
511013 | 511013 | 2020-09-07 | Fall River | South Dakota | 46047 | 67 | 1 |
514246 | 514246 | 2020-09-08 | Fall River | South Dakota | 46047 | 68 | 1 |
517481 | 517481 | 2020-09-09 | Fall River | South Dakota | 46047 | 70 | 1 |
520717 | 520717 | 2020-09-10 | Fall River | South Dakota | 46047 | 71 | 1 |
523953 | 523953 | 2020-09-11 | Fall River | South Dakota | 46047 | 74 | 1 |
527189 | 527189 | 2020-09-12 | Fall River | South Dakota | 46047 | 75 | 1 |
530426 | 530426 | 2020-09-13 | Fall River | South Dakota | 46047 | 77 | 1 |
533661 | 533661 | 2020-09-14 | Fall River | South Dakota | 46047 | 77 | 1 |
536897 | 536897 | 2020-09-15 | Fall River | South Dakota | 46047 | 77 | 1 |
540134 | 540134 | 2020-09-16 | Fall River | South Dakota | 46047 | 79 | 2 |
543370 | 543370 | 2020-09-17 | Fall River | South Dakota | 46047 | 81 | 2 |
546607 | 546607 | 2020-09-18 | Fall River | South Dakota | 46047 | 85 | 3 |
549846 | 549846 | 2020-09-19 | Fall River | South Dakota | 46047 | 87 | 3 |
553085 | 553085 | 2020-09-20 | Fall River | South Dakota | 46047 | 87 | 3 |
556322 | 556322 | 2020-09-21 | Fall River | South Dakota | 46047 | 87 | 3 |
559559 | 559559 | 2020-09-22 | Fall River | South Dakota | 46047 | 87 | 3 |
562796 | 562796 | 2020-09-23 | Fall River | South Dakota | 46047 | 88 | 3 |
566037 | 566037 | 2020-09-24 | Fall River | South Dakota | 46047 | 91 | 3 |
569278 | 569278 | 2020-09-25 | Fall River | South Dakota | 46047 | 92 | 3 |
572520 | 572520 | 2020-09-26 | Fall River | South Dakota | 46047 | 93 | 3 |
575764 | 575764 | 2020-09-27 | Fall River | South Dakota | 46047 | 94 | 3 |
579005 | 579005 | 2020-09-28 | Fall River | South Dakota | 46047 | 95 | 3 |
582245 | 582245 | 2020-09-29 | Fall River | South Dakota | 46047 | 95 | 4 |
585485 | 585485 | 2020-09-30 | Fall River | South Dakota | 46047 | 96 | 4 |
588725 | 588725 | 2020-10-01 | Fall River | South Dakota | 46047 | 99 | 4 |
591966 | 591966 | 2020-10-02 | Fall River | South Dakota | 46047 | 100 | 5 |
595207 | 595207 | 2020-10-03 | Fall River | South Dakota | 46047 | 103 | 5 |
598450 | 598450 | 2020-10-04 | Fall River | South Dakota | 46047 | 105 | 5 |
601693 | 601693 | 2020-10-05 | Fall River | South Dakota | 46047 | 105 | 5 |
604935 | 604935 | 2020-10-06 | Fall River | South Dakota | 46047 | 106 | 5 |
608178 | 608178 | 2020-10-07 | Fall River | South Dakota | 46047 | 113 | 5 |
611420 | 611420 | 2020-10-08 | Fall River | South Dakota | 46047 | 122 | 5 |
614661 | 614661 | 2020-10-09 | Fall River | South Dakota | 46047 | 124 | 5 |
617903 | 617903 | 2020-10-10 | Fall River | South Dakota | 46047 | 130 | 6 |
621146 | 621146 | 2020-10-11 | Fall River | South Dakota | 46047 | 135 | 6 |
624389 | 624389 | 2020-10-12 | Fall River | South Dakota | 46047 | 137 | 6 |
627631 | 627631 | 2020-10-13 | Fall River | South Dakota | 46047 | 137 | 6 |
630875 | 630875 | 2020-10-14 | Fall River | South Dakota | 46047 | 143 | 6 |
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);