ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
217 rows where deaths = 0 and fips = 46025 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 |
---|---|---|---|---|---|---|---|
686020 | 686020 | 2020-10-31 | Clark | South Dakota | 46025 | 139 | 0 |
682777 | 682777 | 2020-10-30 | Clark | South Dakota | 46025 | 131 | 0 |
679534 | 679534 | 2020-10-29 | Clark | South Dakota | 46025 | 118 | 0 |
676291 | 676291 | 2020-10-28 | Clark | South Dakota | 46025 | 114 | 0 |
673048 | 673048 | 2020-10-27 | Clark | South Dakota | 46025 | 102 | 0 |
669806 | 669806 | 2020-10-26 | Clark | South Dakota | 46025 | 100 | 0 |
666562 | 666562 | 2020-10-25 | Clark | South Dakota | 46025 | 101 | 0 |
663317 | 663317 | 2020-10-24 | Clark | South Dakota | 46025 | 97 | 0 |
660073 | 660073 | 2020-10-23 | Clark | South Dakota | 46025 | 95 | 0 |
656829 | 656829 | 2020-10-22 | Clark | South Dakota | 46025 | 88 | 0 |
653584 | 653584 | 2020-10-21 | Clark | South Dakota | 46025 | 81 | 0 |
650339 | 650339 | 2020-10-20 | Clark | South Dakota | 46025 | 73 | 0 |
647095 | 647095 | 2020-10-19 | Clark | South Dakota | 46025 | 71 | 0 |
643849 | 643849 | 2020-10-18 | Clark | South Dakota | 46025 | 70 | 0 |
640601 | 640601 | 2020-10-17 | Clark | South Dakota | 46025 | 66 | 0 |
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 |
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);