ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 46039 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 |
---|---|---|---|---|---|---|---|
922915 | 922915 | 2021-01-12 | Deuel | South Dakota | 46039 | 439 | 7 |
919670 | 919670 | 2021-01-11 | Deuel | South Dakota | 46039 | 438 | 7 |
916425 | 916425 | 2021-01-10 | Deuel | South Dakota | 46039 | 437 | 7 |
913180 | 913180 | 2021-01-09 | Deuel | South Dakota | 46039 | 433 | 7 |
909935 | 909935 | 2021-01-08 | Deuel | South Dakota | 46039 | 429 | 7 |
906690 | 906690 | 2021-01-07 | Deuel | South Dakota | 46039 | 428 | 7 |
903444 | 903444 | 2021-01-06 | Deuel | South Dakota | 46039 | 425 | 7 |
900199 | 900199 | 2021-01-05 | Deuel | South Dakota | 46039 | 422 | 7 |
896954 | 896954 | 2021-01-04 | Deuel | South Dakota | 46039 | 417 | 7 |
893708 | 893708 | 2021-01-03 | Deuel | South Dakota | 46039 | 417 | 7 |
890462 | 890462 | 2021-01-02 | Deuel | South Dakota | 46039 | 413 | 7 |
887215 | 887215 | 2021-01-01 | Deuel | South Dakota | 46039 | 412 | 7 |
883970 | 883970 | 2020-12-31 | Deuel | South Dakota | 46039 | 412 | 7 |
880725 | 880725 | 2020-12-30 | Deuel | South Dakota | 46039 | 411 | 7 |
877480 | 877480 | 2020-12-29 | Deuel | South Dakota | 46039 | 405 | 6 |
874235 | 874235 | 2020-12-28 | Deuel | South Dakota | 46039 | 404 | 6 |
870990 | 870990 | 2020-12-27 | Deuel | South Dakota | 46039 | 404 | 6 |
867745 | 867745 | 2020-12-26 | Deuel | South Dakota | 46039 | 402 | 6 |
864500 | 864500 | 2020-12-25 | Deuel | South Dakota | 46039 | 399 | 6 |
861255 | 861255 | 2020-12-24 | Deuel | South Dakota | 46039 | 399 | 6 |
858010 | 858010 | 2020-12-23 | Deuel | South Dakota | 46039 | 397 | 6 |
854765 | 854765 | 2020-12-22 | Deuel | South Dakota | 46039 | 397 | 6 |
851520 | 851520 | 2020-12-21 | Deuel | South Dakota | 46039 | 395 | 6 |
848275 | 848275 | 2020-12-20 | Deuel | South Dakota | 46039 | 394 | 6 |
845030 | 845030 | 2020-12-19 | Deuel | South Dakota | 46039 | 391 | 6 |
841784 | 841784 | 2020-12-18 | Deuel | South Dakota | 46039 | 385 | 6 |
838539 | 838539 | 2020-12-17 | Deuel | South Dakota | 46039 | 383 | 6 |
835293 | 835293 | 2020-12-16 | Deuel | South Dakota | 46039 | 381 | 6 |
832047 | 832047 | 2020-12-15 | Deuel | South Dakota | 46039 | 376 | 5 |
828800 | 828800 | 2020-12-14 | Deuel | South Dakota | 46039 | 372 | 5 |
825554 | 825554 | 2020-12-13 | Deuel | South Dakota | 46039 | 372 | 5 |
822307 | 822307 | 2020-12-12 | Deuel | South Dakota | 46039 | 371 | 5 |
819061 | 819061 | 2020-12-11 | Deuel | South Dakota | 46039 | 367 | 5 |
815815 | 815815 | 2020-12-10 | Deuel | South Dakota | 46039 | 365 | 5 |
812569 | 812569 | 2020-12-09 | Deuel | South Dakota | 46039 | 359 | 4 |
809325 | 809325 | 2020-12-08 | Deuel | South Dakota | 46039 | 353 | 3 |
806080 | 806080 | 2020-12-07 | Deuel | South Dakota | 46039 | 349 | 3 |
802835 | 802835 | 2020-12-06 | Deuel | South Dakota | 46039 | 347 | 3 |
799590 | 799590 | 2020-12-05 | Deuel | South Dakota | 46039 | 344 | 3 |
796345 | 796345 | 2020-12-04 | Deuel | South Dakota | 46039 | 335 | 2 |
793100 | 793100 | 2020-12-03 | Deuel | South Dakota | 46039 | 332 | 2 |
789855 | 789855 | 2020-12-02 | Deuel | South Dakota | 46039 | 326 | 2 |
786610 | 786610 | 2020-12-01 | Deuel | South Dakota | 46039 | 311 | 2 |
783366 | 783366 | 2020-11-30 | Deuel | South Dakota | 46039 | 311 | 2 |
780121 | 780121 | 2020-11-29 | Deuel | South Dakota | 46039 | 306 | 2 |
776875 | 776875 | 2020-11-28 | Deuel | South Dakota | 46039 | 302 | 2 |
773630 | 773630 | 2020-11-27 | Deuel | South Dakota | 46039 | 297 | 2 |
770385 | 770385 | 2020-11-26 | Deuel | South Dakota | 46039 | 292 | 2 |
767139 | 767139 | 2020-11-25 | Deuel | South Dakota | 46039 | 292 | 2 |
763894 | 763894 | 2020-11-24 | Deuel | South Dakota | 46039 | 287 | 2 |
760649 | 760649 | 2020-11-23 | Deuel | South Dakota | 46039 | 283 | 2 |
757404 | 757404 | 2020-11-22 | Deuel | South Dakota | 46039 | 278 | 2 |
754157 | 754157 | 2020-11-21 | Deuel | South Dakota | 46039 | 277 | 2 |
750911 | 750911 | 2020-11-20 | Deuel | South Dakota | 46039 | 272 | 2 |
747665 | 747665 | 2020-11-19 | Deuel | South Dakota | 46039 | 267 | 2 |
744419 | 744419 | 2020-11-18 | Deuel | South Dakota | 46039 | 265 | 2 |
741172 | 741172 | 2020-11-17 | Deuel | South Dakota | 46039 | 261 | 2 |
737926 | 737926 | 2020-11-16 | Deuel | South Dakota | 46039 | 258 | 2 |
734682 | 734682 | 2020-11-15 | Deuel | South Dakota | 46039 | 254 | 2 |
731436 | 731436 | 2020-11-14 | Deuel | South Dakota | 46039 | 249 | 2 |
728192 | 728192 | 2020-11-13 | Deuel | South Dakota | 46039 | 247 | 2 |
724948 | 724948 | 2020-11-12 | Deuel | South Dakota | 46039 | 238 | 2 |
721705 | 721705 | 2020-11-11 | Deuel | South Dakota | 46039 | 232 | 2 |
718462 | 718462 | 2020-11-10 | Deuel | South Dakota | 46039 | 230 | 2 |
715219 | 715219 | 2020-11-09 | Deuel | South Dakota | 46039 | 226 | 2 |
711975 | 711975 | 2020-11-08 | Deuel | South Dakota | 46039 | 222 | 2 |
708731 | 708731 | 2020-11-07 | Deuel | South Dakota | 46039 | 221 | 1 |
705488 | 705488 | 2020-11-06 | Deuel | South Dakota | 46039 | 217 | 1 |
702245 | 702245 | 2020-11-05 | Deuel | South Dakota | 46039 | 212 | 1 |
699001 | 699001 | 2020-11-04 | Deuel | South Dakota | 46039 | 206 | 1 |
695758 | 695758 | 2020-11-03 | Deuel | South Dakota | 46039 | 205 | 1 |
692516 | 692516 | 2020-11-02 | Deuel | South Dakota | 46039 | 203 | 1 |
689272 | 689272 | 2020-11-01 | Deuel | South Dakota | 46039 | 201 | 1 |
686027 | 686027 | 2020-10-31 | Deuel | South Dakota | 46039 | 197 | 1 |
682784 | 682784 | 2020-10-30 | Deuel | South Dakota | 46039 | 195 | 1 |
679541 | 679541 | 2020-10-29 | Deuel | South Dakota | 46039 | 189 | 1 |
676298 | 676298 | 2020-10-28 | Deuel | South Dakota | 46039 | 184 | 0 |
673055 | 673055 | 2020-10-27 | Deuel | South Dakota | 46039 | 182 | 0 |
669813 | 669813 | 2020-10-26 | Deuel | South Dakota | 46039 | 177 | 0 |
666569 | 666569 | 2020-10-25 | Deuel | South Dakota | 46039 | 177 | 0 |
663324 | 663324 | 2020-10-24 | Deuel | South Dakota | 46039 | 172 | 0 |
660080 | 660080 | 2020-10-23 | Deuel | South Dakota | 46039 | 165 | 0 |
656836 | 656836 | 2020-10-22 | Deuel | South Dakota | 46039 | 159 | 0 |
653591 | 653591 | 2020-10-21 | Deuel | South Dakota | 46039 | 157 | 0 |
650346 | 650346 | 2020-10-20 | Deuel | South Dakota | 46039 | 155 | 0 |
647102 | 647102 | 2020-10-19 | Deuel | South Dakota | 46039 | 151 | 0 |
643856 | 643856 | 2020-10-18 | Deuel | South Dakota | 46039 | 147 | 0 |
640608 | 640608 | 2020-10-17 | Deuel | South Dakota | 46039 | 144 | 0 |
637362 | 637362 | 2020-10-16 | Deuel | South Dakota | 46039 | 142 | 0 |
634116 | 634116 | 2020-10-15 | Deuel | South Dakota | 46039 | 137 | 0 |
630871 | 630871 | 2020-10-14 | Deuel | South Dakota | 46039 | 133 | 0 |
627627 | 627627 | 2020-10-13 | Deuel | South Dakota | 46039 | 126 | 0 |
624385 | 624385 | 2020-10-12 | Deuel | South Dakota | 46039 | 123 | 0 |
621142 | 621142 | 2020-10-11 | Deuel | South Dakota | 46039 | 121 | 0 |
617899 | 617899 | 2020-10-10 | Deuel | South Dakota | 46039 | 120 | 0 |
614657 | 614657 | 2020-10-09 | Deuel | South Dakota | 46039 | 115 | 0 |
611416 | 611416 | 2020-10-08 | Deuel | South Dakota | 46039 | 109 | 0 |
608174 | 608174 | 2020-10-07 | Deuel | South Dakota | 46039 | 102 | 0 |
604931 | 604931 | 2020-10-06 | Deuel | South Dakota | 46039 | 97 | 0 |
601689 | 601689 | 2020-10-05 | Deuel | South Dakota | 46039 | 97 | 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);