ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 46025 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 |
---|---|---|---|---|---|---|---|
637355 | 637355 | 2020-10-16 | Clark | South Dakota | 46025 | 65 | 0 |
634109 | 634109 | 2020-10-15 | Clark | South Dakota | 46025 | 61 | 0 |
630864 | 630864 | 2020-10-14 | Clark | South Dakota | 46025 | 59 | 0 |
627620 | 627620 | 2020-10-13 | Clark | South Dakota | 46025 | 55 | 0 |
624378 | 624378 | 2020-10-12 | Clark | South Dakota | 46025 | 55 | 0 |
621135 | 621135 | 2020-10-11 | Clark | South Dakota | 46025 | 54 | 0 |
617892 | 617892 | 2020-10-10 | Clark | South Dakota | 46025 | 53 | 0 |
614650 | 614650 | 2020-10-09 | Clark | South Dakota | 46025 | 50 | 0 |
611409 | 611409 | 2020-10-08 | Clark | South Dakota | 46025 | 49 | 0 |
608167 | 608167 | 2020-10-07 | Clark | South Dakota | 46025 | 48 | 0 |
604924 | 604924 | 2020-10-06 | Clark | South Dakota | 46025 | 47 | 0 |
601682 | 601682 | 2020-10-05 | Clark | South Dakota | 46025 | 49 | 0 |
598439 | 598439 | 2020-10-04 | Clark | South Dakota | 46025 | 49 | 0 |
595196 | 595196 | 2020-10-03 | Clark | South Dakota | 46025 | 46 | 0 |
591955 | 591955 | 2020-10-02 | Clark | South Dakota | 46025 | 45 | 0 |
588714 | 588714 | 2020-10-01 | Clark | South Dakota | 46025 | 44 | 0 |
585474 | 585474 | 2020-09-30 | Clark | South Dakota | 46025 | 43 | 0 |
582234 | 582234 | 2020-09-29 | Clark | South Dakota | 46025 | 43 | 0 |
578994 | 578994 | 2020-09-28 | Clark | South Dakota | 46025 | 40 | 0 |
575753 | 575753 | 2020-09-27 | Clark | South Dakota | 46025 | 40 | 0 |
572509 | 572509 | 2020-09-26 | Clark | South Dakota | 46025 | 40 | 0 |
569267 | 569267 | 2020-09-25 | Clark | South Dakota | 46025 | 37 | 0 |
566026 | 566026 | 2020-09-24 | Clark | South Dakota | 46025 | 37 | 0 |
562785 | 562785 | 2020-09-23 | Clark | South Dakota | 46025 | 34 | 0 |
559548 | 559548 | 2020-09-22 | Clark | South Dakota | 46025 | 32 | 0 |
556311 | 556311 | 2020-09-21 | Clark | South Dakota | 46025 | 32 | 0 |
553074 | 553074 | 2020-09-20 | Clark | South Dakota | 46025 | 32 | 0 |
549835 | 549835 | 2020-09-19 | Clark | South Dakota | 46025 | 32 | 0 |
546596 | 546596 | 2020-09-18 | Clark | South Dakota | 46025 | 31 | 0 |
543359 | 543359 | 2020-09-17 | Clark | South Dakota | 46025 | 31 | 0 |
540123 | 540123 | 2020-09-16 | Clark | South Dakota | 46025 | 31 | 0 |
536886 | 536886 | 2020-09-15 | Clark | South Dakota | 46025 | 31 | 0 |
533650 | 533650 | 2020-09-14 | Clark | South Dakota | 46025 | 28 | 0 |
530415 | 530415 | 2020-09-13 | Clark | South Dakota | 46025 | 27 | 0 |
527178 | 527178 | 2020-09-12 | Clark | South Dakota | 46025 | 27 | 0 |
523942 | 523942 | 2020-09-11 | Clark | South Dakota | 46025 | 24 | 0 |
520706 | 520706 | 2020-09-10 | Clark | South Dakota | 46025 | 23 | 0 |
517470 | 517470 | 2020-09-09 | Clark | South Dakota | 46025 | 23 | 0 |
514235 | 514235 | 2020-09-08 | Clark | South Dakota | 46025 | 23 | 0 |
511002 | 511002 | 2020-09-07 | Clark | South Dakota | 46025 | 23 | 0 |
507769 | 507769 | 2020-09-06 | Clark | South Dakota | 46025 | 22 | 0 |
504537 | 504537 | 2020-09-05 | Clark | South Dakota | 46025 | 22 | 0 |
501303 | 501303 | 2020-09-04 | Clark | South Dakota | 46025 | 21 | 0 |
498069 | 498069 | 2020-09-03 | Clark | South Dakota | 46025 | 21 | 0 |
494836 | 494836 | 2020-09-02 | Clark | South Dakota | 46025 | 21 | 0 |
491602 | 491602 | 2020-09-01 | Clark | South Dakota | 46025 | 19 | 0 |
488369 | 488369 | 2020-08-31 | Clark | South Dakota | 46025 | 19 | 0 |
485136 | 485136 | 2020-08-30 | Clark | South Dakota | 46025 | 19 | 0 |
481901 | 481901 | 2020-08-29 | Clark | South Dakota | 46025 | 19 | 0 |
478667 | 478667 | 2020-08-28 | Clark | South Dakota | 46025 | 19 | 0 |
475434 | 475434 | 2020-08-27 | Clark | South Dakota | 46025 | 18 | 0 |
472200 | 472200 | 2020-08-26 | Clark | South Dakota | 46025 | 18 | 0 |
468968 | 468968 | 2020-08-25 | Clark | South Dakota | 46025 | 18 | 0 |
465740 | 465740 | 2020-08-24 | Clark | South Dakota | 46025 | 18 | 0 |
462511 | 462511 | 2020-08-23 | Clark | South Dakota | 46025 | 17 | 0 |
459283 | 459283 | 2020-08-22 | Clark | South Dakota | 46025 | 17 | 0 |
456055 | 456055 | 2020-08-21 | Clark | South Dakota | 46025 | 17 | 0 |
452827 | 452827 | 2020-08-20 | Clark | South Dakota | 46025 | 17 | 0 |
449599 | 449599 | 2020-08-19 | Clark | South Dakota | 46025 | 17 | 0 |
446371 | 446371 | 2020-08-18 | Clark | South Dakota | 46025 | 17 | 0 |
443145 | 443145 | 2020-08-17 | Clark | South Dakota | 46025 | 17 | 0 |
439918 | 439918 | 2020-08-16 | Clark | South Dakota | 46025 | 17 | 0 |
436693 | 436693 | 2020-08-15 | Clark | South Dakota | 46025 | 17 | 0 |
433466 | 433466 | 2020-08-14 | Clark | South Dakota | 46025 | 17 | 0 |
430241 | 430241 | 2020-08-13 | Clark | South Dakota | 46025 | 17 | 0 |
427015 | 427015 | 2020-08-12 | Clark | South Dakota | 46025 | 16 | 0 |
423792 | 423792 | 2020-08-11 | Clark | South Dakota | 46025 | 16 | 0 |
420570 | 420570 | 2020-08-10 | Clark | South Dakota | 46025 | 16 | 0 |
417349 | 417349 | 2020-08-09 | Clark | South Dakota | 46025 | 16 | 0 |
414128 | 414128 | 2020-08-08 | Clark | South Dakota | 46025 | 16 | 0 |
410908 | 410908 | 2020-08-07 | Clark | South Dakota | 46025 | 16 | 0 |
407689 | 407689 | 2020-08-06 | Clark | South Dakota | 46025 | 16 | 0 |
404469 | 404469 | 2020-08-05 | Clark | South Dakota | 46025 | 16 | 0 |
401251 | 401251 | 2020-08-04 | Clark | South Dakota | 46025 | 16 | 0 |
398036 | 398036 | 2020-08-03 | Clark | South Dakota | 46025 | 16 | 0 |
394819 | 394819 | 2020-08-02 | Clark | South Dakota | 46025 | 16 | 0 |
391603 | 391603 | 2020-08-01 | Clark | South Dakota | 46025 | 16 | 0 |
388386 | 388386 | 2020-07-31 | Clark | South Dakota | 46025 | 16 | 0 |
385169 | 385169 | 2020-07-30 | Clark | South Dakota | 46025 | 16 | 0 |
381951 | 381951 | 2020-07-29 | Clark | South Dakota | 46025 | 16 | 0 |
378734 | 378734 | 2020-07-28 | Clark | South Dakota | 46025 | 16 | 0 |
375518 | 375518 | 2020-07-27 | Clark | South Dakota | 46025 | 16 | 0 |
372305 | 372305 | 2020-07-26 | Clark | South Dakota | 46025 | 16 | 0 |
369093 | 369093 | 2020-07-25 | Clark | South Dakota | 46025 | 16 | 0 |
365884 | 365884 | 2020-07-24 | Clark | South Dakota | 46025 | 16 | 0 |
362678 | 362678 | 2020-07-23 | Clark | South Dakota | 46025 | 16 | 0 |
359472 | 359472 | 2020-07-22 | Clark | South Dakota | 46025 | 16 | 0 |
356268 | 356268 | 2020-07-21 | Clark | South Dakota | 46025 | 16 | 0 |
353065 | 353065 | 2020-07-20 | Clark | South Dakota | 46025 | 16 | 0 |
349862 | 349862 | 2020-07-19 | Clark | South Dakota | 46025 | 16 | 0 |
346662 | 346662 | 2020-07-18 | Clark | South Dakota | 46025 | 16 | 0 |
343462 | 343462 | 2020-07-17 | Clark | South Dakota | 46025 | 16 | 0 |
340264 | 340264 | 2020-07-16 | Clark | South Dakota | 46025 | 16 | 0 |
337067 | 337067 | 2020-07-15 | Clark | South Dakota | 46025 | 16 | 0 |
333873 | 333873 | 2020-07-14 | Clark | South Dakota | 46025 | 15 | 0 |
330681 | 330681 | 2020-07-13 | Clark | South Dakota | 46025 | 15 | 0 |
327495 | 327495 | 2020-07-12 | Clark | South Dakota | 46025 | 15 | 0 |
324310 | 324310 | 2020-07-11 | Clark | South Dakota | 46025 | 15 | 0 |
321130 | 321130 | 2020-07-10 | Clark | South Dakota | 46025 | 15 | 0 |
317952 | 317952 | 2020-07-09 | Clark | South Dakota | 46025 | 15 | 0 |
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);