ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 46087 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 |
---|---|---|---|---|---|---|---|
770410 | 770410 | 2020-11-26 | McCook | South Dakota | 46087 | 574 | 11 |
767164 | 767164 | 2020-11-25 | McCook | South Dakota | 46087 | 574 | 11 |
763919 | 763919 | 2020-11-24 | McCook | South Dakota | 46087 | 565 | 11 |
760674 | 760674 | 2020-11-23 | McCook | South Dakota | 46087 | 561 | 11 |
757429 | 757429 | 2020-11-22 | McCook | South Dakota | 46087 | 556 | 11 |
754182 | 754182 | 2020-11-21 | McCook | South Dakota | 46087 | 551 | 11 |
750936 | 750936 | 2020-11-20 | McCook | South Dakota | 46087 | 546 | 11 |
747690 | 747690 | 2020-11-19 | McCook | South Dakota | 46087 | 538 | 10 |
744444 | 744444 | 2020-11-18 | McCook | South Dakota | 46087 | 525 | 9 |
741197 | 741197 | 2020-11-17 | McCook | South Dakota | 46087 | 512 | 9 |
737951 | 737951 | 2020-11-16 | McCook | South Dakota | 46087 | 499 | 9 |
734707 | 734707 | 2020-11-15 | McCook | South Dakota | 46087 | 490 | 9 |
731461 | 731461 | 2020-11-14 | McCook | South Dakota | 46087 | 475 | 9 |
728217 | 728217 | 2020-11-13 | McCook | South Dakota | 46087 | 453 | 3 |
724973 | 724973 | 2020-11-12 | McCook | South Dakota | 46087 | 438 | 3 |
721730 | 721730 | 2020-11-11 | McCook | South Dakota | 46087 | 411 | 3 |
718487 | 718487 | 2020-11-10 | McCook | South Dakota | 46087 | 401 | 3 |
715244 | 715244 | 2020-11-09 | McCook | South Dakota | 46087 | 395 | 3 |
712000 | 712000 | 2020-11-08 | McCook | South Dakota | 46087 | 379 | 3 |
708756 | 708756 | 2020-11-07 | McCook | South Dakota | 46087 | 361 | 3 |
705513 | 705513 | 2020-11-06 | McCook | South Dakota | 46087 | 351 | 3 |
702270 | 702270 | 2020-11-05 | McCook | South Dakota | 46087 | 332 | 3 |
699026 | 699026 | 2020-11-04 | McCook | South Dakota | 46087 | 324 | 1 |
695783 | 695783 | 2020-11-03 | McCook | South Dakota | 46087 | 315 | 1 |
692541 | 692541 | 2020-11-02 | McCook | South Dakota | 46087 | 307 | 1 |
689297 | 689297 | 2020-11-01 | McCook | South Dakota | 46087 | 302 | 1 |
686052 | 686052 | 2020-10-31 | McCook | South Dakota | 46087 | 282 | 1 |
682809 | 682809 | 2020-10-30 | McCook | South Dakota | 46087 | 259 | 1 |
679566 | 679566 | 2020-10-29 | McCook | South Dakota | 46087 | 250 | 1 |
676323 | 676323 | 2020-10-28 | McCook | South Dakota | 46087 | 234 | 1 |
673080 | 673080 | 2020-10-27 | McCook | South Dakota | 46087 | 225 | 1 |
669838 | 669838 | 2020-10-26 | McCook | South Dakota | 46087 | 223 | 1 |
666594 | 666594 | 2020-10-25 | McCook | South Dakota | 46087 | 220 | 1 |
663349 | 663349 | 2020-10-24 | McCook | South Dakota | 46087 | 213 | 1 |
660105 | 660105 | 2020-10-23 | McCook | South Dakota | 46087 | 205 | 1 |
656861 | 656861 | 2020-10-22 | McCook | South Dakota | 46087 | 192 | 1 |
653616 | 653616 | 2020-10-21 | McCook | South Dakota | 46087 | 188 | 1 |
650371 | 650371 | 2020-10-20 | McCook | South Dakota | 46087 | 187 | 1 |
647127 | 647127 | 2020-10-19 | McCook | South Dakota | 46087 | 183 | 1 |
643881 | 643881 | 2020-10-18 | McCook | South Dakota | 46087 | 179 | 1 |
640633 | 640633 | 2020-10-17 | McCook | South Dakota | 46087 | 177 | 1 |
637387 | 637387 | 2020-10-16 | McCook | South Dakota | 46087 | 171 | 1 |
634141 | 634141 | 2020-10-15 | McCook | South Dakota | 46087 | 164 | 1 |
630896 | 630896 | 2020-10-14 | McCook | South Dakota | 46087 | 163 | 1 |
627652 | 627652 | 2020-10-13 | McCook | South Dakota | 46087 | 154 | 1 |
624410 | 624410 | 2020-10-12 | McCook | South Dakota | 46087 | 151 | 1 |
621167 | 621167 | 2020-10-11 | McCook | South Dakota | 46087 | 150 | 1 |
617924 | 617924 | 2020-10-10 | McCook | South Dakota | 46087 | 146 | 1 |
614682 | 614682 | 2020-10-09 | McCook | South Dakota | 46087 | 142 | 1 |
611441 | 611441 | 2020-10-08 | McCook | South Dakota | 46087 | 139 | 1 |
608199 | 608199 | 2020-10-07 | McCook | South Dakota | 46087 | 137 | 1 |
604956 | 604956 | 2020-10-06 | McCook | South Dakota | 46087 | 132 | 1 |
601714 | 601714 | 2020-10-05 | McCook | South Dakota | 46087 | 127 | 1 |
598471 | 598471 | 2020-10-04 | McCook | South Dakota | 46087 | 127 | 1 |
595228 | 595228 | 2020-10-03 | McCook | South Dakota | 46087 | 120 | 1 |
591987 | 591987 | 2020-10-02 | McCook | South Dakota | 46087 | 117 | 1 |
588746 | 588746 | 2020-10-01 | McCook | South Dakota | 46087 | 113 | 1 |
585506 | 585506 | 2020-09-30 | McCook | South Dakota | 46087 | 106 | 1 |
582266 | 582266 | 2020-09-29 | McCook | South Dakota | 46087 | 98 | 1 |
579026 | 579026 | 2020-09-28 | McCook | South Dakota | 46087 | 97 | 1 |
575785 | 575785 | 2020-09-27 | McCook | South Dakota | 46087 | 96 | 1 |
572541 | 572541 | 2020-09-26 | McCook | South Dakota | 46087 | 93 | 1 |
569299 | 569299 | 2020-09-25 | McCook | South Dakota | 46087 | 92 | 1 |
566058 | 566058 | 2020-09-24 | McCook | South Dakota | 46087 | 91 | 1 |
562817 | 562817 | 2020-09-23 | McCook | South Dakota | 46087 | 88 | 1 |
559580 | 559580 | 2020-09-22 | McCook | South Dakota | 46087 | 85 | 1 |
556343 | 556343 | 2020-09-21 | McCook | South Dakota | 46087 | 83 | 1 |
553106 | 553106 | 2020-09-20 | McCook | South Dakota | 46087 | 83 | 1 |
549867 | 549867 | 2020-09-19 | McCook | South Dakota | 46087 | 80 | 1 |
546628 | 546628 | 2020-09-18 | McCook | South Dakota | 46087 | 78 | 1 |
543391 | 543391 | 2020-09-17 | McCook | South Dakota | 46087 | 78 | 1 |
540155 | 540155 | 2020-09-16 | McCook | South Dakota | 46087 | 77 | 1 |
536918 | 536918 | 2020-09-15 | McCook | South Dakota | 46087 | 75 | 1 |
533682 | 533682 | 2020-09-14 | McCook | South Dakota | 46087 | 71 | 1 |
530447 | 530447 | 2020-09-13 | McCook | South Dakota | 46087 | 70 | 1 |
527210 | 527210 | 2020-09-12 | McCook | South Dakota | 46087 | 68 | 1 |
523974 | 523974 | 2020-09-11 | McCook | South Dakota | 46087 | 67 | 1 |
520738 | 520738 | 2020-09-10 | McCook | South Dakota | 46087 | 66 | 1 |
517502 | 517502 | 2020-09-09 | McCook | South Dakota | 46087 | 61 | 1 |
514267 | 514267 | 2020-09-08 | McCook | South Dakota | 46087 | 61 | 1 |
511034 | 511034 | 2020-09-07 | McCook | South Dakota | 46087 | 60 | 1 |
507801 | 507801 | 2020-09-06 | McCook | South Dakota | 46087 | 59 | 1 |
504569 | 504569 | 2020-09-05 | McCook | South Dakota | 46087 | 58 | 1 |
501335 | 501335 | 2020-09-04 | McCook | South Dakota | 46087 | 54 | 1 |
498101 | 498101 | 2020-09-03 | McCook | South Dakota | 46087 | 53 | 1 |
494868 | 494868 | 2020-09-02 | McCook | South Dakota | 46087 | 53 | 1 |
491634 | 491634 | 2020-09-01 | McCook | South Dakota | 46087 | 53 | 1 |
488401 | 488401 | 2020-08-31 | McCook | South Dakota | 46087 | 52 | 1 |
485168 | 485168 | 2020-08-30 | McCook | South Dakota | 46087 | 49 | 1 |
481933 | 481933 | 2020-08-29 | McCook | South Dakota | 46087 | 47 | 1 |
478699 | 478699 | 2020-08-28 | McCook | South Dakota | 46087 | 44 | 1 |
475466 | 475466 | 2020-08-27 | McCook | South Dakota | 46087 | 41 | 1 |
472232 | 472232 | 2020-08-26 | McCook | South Dakota | 46087 | 39 | 1 |
469000 | 469000 | 2020-08-25 | McCook | South Dakota | 46087 | 39 | 1 |
465772 | 465772 | 2020-08-24 | McCook | South Dakota | 46087 | 39 | 1 |
462543 | 462543 | 2020-08-23 | McCook | South Dakota | 46087 | 39 | 1 |
459315 | 459315 | 2020-08-22 | McCook | South Dakota | 46087 | 39 | 1 |
456087 | 456087 | 2020-08-21 | McCook | South Dakota | 46087 | 37 | 1 |
452859 | 452859 | 2020-08-20 | McCook | South Dakota | 46087 | 37 | 1 |
449631 | 449631 | 2020-08-19 | McCook | South Dakota | 46087 | 37 | 1 |
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);