ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
745 rows where county = "Day" 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 |
---|---|---|---|---|---|---|---|
1091684 | 1091684 | 2021-03-05 | Day | South Dakota | 46037 | 667 | 28 |
1088438 | 1088438 | 2021-03-04 | Day | South Dakota | 46037 | 665 | 28 |
1085193 | 1085193 | 2021-03-03 | Day | South Dakota | 46037 | 665 | 28 |
1081947 | 1081947 | 2021-03-02 | Day | South Dakota | 46037 | 665 | 28 |
1078701 | 1078701 | 2021-03-01 | Day | South Dakota | 46037 | 663 | 28 |
1075456 | 1075456 | 2021-02-28 | Day | South Dakota | 46037 | 663 | 28 |
1072210 | 1072210 | 2021-02-27 | Day | South Dakota | 46037 | 663 | 28 |
1068964 | 1068964 | 2021-02-26 | Day | South Dakota | 46037 | 662 | 28 |
1065719 | 1065719 | 2021-02-25 | Day | South Dakota | 46037 | 662 | 28 |
1062474 | 1062474 | 2021-02-24 | Day | South Dakota | 46037 | 662 | 28 |
1059229 | 1059229 | 2021-02-23 | Day | South Dakota | 46037 | 660 | 28 |
1055983 | 1055983 | 2021-02-22 | Day | South Dakota | 46037 | 654 | 28 |
1052737 | 1052737 | 2021-02-21 | Day | South Dakota | 46037 | 654 | 28 |
1049490 | 1049490 | 2021-02-20 | Day | South Dakota | 46037 | 653 | 28 |
1046243 | 1046243 | 2021-02-19 | Day | South Dakota | 46037 | 652 | 28 |
1042998 | 1042998 | 2021-02-18 | Day | South Dakota | 46037 | 650 | 28 |
1039753 | 1039753 | 2021-02-17 | Day | South Dakota | 46037 | 647 | 28 |
1036508 | 1036508 | 2021-02-16 | Day | South Dakota | 46037 | 647 | 28 |
1033263 | 1033263 | 2021-02-15 | Day | South Dakota | 46037 | 641 | 28 |
1030017 | 1030017 | 2021-02-14 | Day | South Dakota | 46037 | 640 | 28 |
1026770 | 1026770 | 2021-02-13 | Day | South Dakota | 46037 | 639 | 28 |
1023525 | 1023525 | 2021-02-12 | Day | South Dakota | 46037 | 637 | 28 |
1020280 | 1020280 | 2021-02-11 | Day | South Dakota | 46037 | 633 | 28 |
1017035 | 1017035 | 2021-02-10 | Day | South Dakota | 46037 | 630 | 28 |
1013790 | 1013790 | 2021-02-09 | Day | South Dakota | 46037 | 625 | 28 |
1010545 | 1010545 | 2021-02-08 | Day | South Dakota | 46037 | 625 | 28 |
1007299 | 1007299 | 2021-02-07 | Day | South Dakota | 46037 | 623 | 28 |
1004053 | 1004053 | 2021-02-06 | Day | South Dakota | 46037 | 620 | 27 |
1000807 | 1000807 | 2021-02-05 | Day | South Dakota | 46037 | 617 | 27 |
997561 | 997561 | 2021-02-04 | Day | South Dakota | 46037 | 614 | 27 |
994315 | 994315 | 2021-02-03 | Day | South Dakota | 46037 | 613 | 27 |
991069 | 991069 | 2021-02-02 | Day | South Dakota | 46037 | 612 | 27 |
987823 | 987823 | 2021-02-01 | Day | South Dakota | 46037 | 610 | 27 |
984576 | 984576 | 2021-01-31 | Day | South Dakota | 46037 | 609 | 27 |
981329 | 981329 | 2021-01-30 | Day | South Dakota | 46037 | 607 | 27 |
978083 | 978083 | 2021-01-29 | Day | South Dakota | 46037 | 606 | 27 |
974838 | 974838 | 2021-01-28 | Day | South Dakota | 46037 | 604 | 27 |
971593 | 971593 | 2021-01-27 | Day | South Dakota | 46037 | 601 | 26 |
968348 | 968348 | 2021-01-26 | Day | South Dakota | 46037 | 599 | 25 |
965104 | 965104 | 2021-01-25 | Day | South Dakota | 46037 | 594 | 25 |
961859 | 961859 | 2021-01-24 | Day | South Dakota | 46037 | 594 | 25 |
958614 | 958614 | 2021-01-23 | Day | South Dakota | 46037 | 590 | 25 |
955368 | 955368 | 2021-01-22 | Day | South Dakota | 46037 | 586 | 23 |
952123 | 952123 | 2021-01-21 | Day | South Dakota | 46037 | 583 | 23 |
948878 | 948878 | 2021-01-20 | Day | South Dakota | 46037 | 582 | 23 |
945632 | 945632 | 2021-01-19 | Day | South Dakota | 46037 | 582 | 23 |
942385 | 942385 | 2021-01-18 | Day | South Dakota | 46037 | 582 | 23 |
939140 | 939140 | 2021-01-17 | Day | South Dakota | 46037 | 581 | 23 |
935895 | 935895 | 2021-01-16 | Day | South Dakota | 46037 | 579 | 23 |
932650 | 932650 | 2021-01-15 | Day | South Dakota | 46037 | 579 | 23 |
929405 | 929405 | 2021-01-14 | Day | South Dakota | 46037 | 574 | 23 |
926160 | 926160 | 2021-01-13 | Day | South Dakota | 46037 | 571 | 22 |
922914 | 922914 | 2021-01-12 | Day | South Dakota | 46037 | 565 | 21 |
919669 | 919669 | 2021-01-11 | Day | South Dakota | 46037 | 564 | 21 |
916424 | 916424 | 2021-01-10 | Day | South Dakota | 46037 | 561 | 21 |
913179 | 913179 | 2021-01-09 | Day | South Dakota | 46037 | 560 | 21 |
909934 | 909934 | 2021-01-08 | Day | South Dakota | 46037 | 558 | 21 |
906689 | 906689 | 2021-01-07 | Day | South Dakota | 46037 | 553 | 20 |
903443 | 903443 | 2021-01-06 | Day | South Dakota | 46037 | 550 | 20 |
900198 | 900198 | 2021-01-05 | Day | South Dakota | 46037 | 546 | 20 |
896953 | 896953 | 2021-01-04 | Day | South Dakota | 46037 | 542 | 20 |
893707 | 893707 | 2021-01-03 | Day | South Dakota | 46037 | 541 | 20 |
890461 | 890461 | 2021-01-02 | Day | South Dakota | 46037 | 540 | 20 |
887214 | 887214 | 2021-01-01 | Day | South Dakota | 46037 | 537 | 20 |
883969 | 883969 | 2020-12-31 | Day | South Dakota | 46037 | 537 | 20 |
880724 | 880724 | 2020-12-30 | Day | South Dakota | 46037 | 529 | 20 |
877479 | 877479 | 2020-12-29 | Day | South Dakota | 46037 | 528 | 20 |
874234 | 874234 | 2020-12-28 | Day | South Dakota | 46037 | 523 | 20 |
870989 | 870989 | 2020-12-27 | Day | South Dakota | 46037 | 523 | 20 |
867744 | 867744 | 2020-12-26 | Day | South Dakota | 46037 | 517 | 20 |
864499 | 864499 | 2020-12-25 | Day | South Dakota | 46037 | 516 | 20 |
861254 | 861254 | 2020-12-24 | Day | South Dakota | 46037 | 516 | 20 |
858009 | 858009 | 2020-12-23 | Day | South Dakota | 46037 | 513 | 19 |
854764 | 854764 | 2020-12-22 | Day | South Dakota | 46037 | 511 | 19 |
851519 | 851519 | 2020-12-21 | Day | South Dakota | 46037 | 505 | 19 |
848274 | 848274 | 2020-12-20 | Day | South Dakota | 46037 | 504 | 18 |
845029 | 845029 | 2020-12-19 | Day | South Dakota | 46037 | 502 | 17 |
841783 | 841783 | 2020-12-18 | Day | South Dakota | 46037 | 497 | 17 |
838538 | 838538 | 2020-12-17 | Day | South Dakota | 46037 | 494 | 15 |
835292 | 835292 | 2020-12-16 | Day | South Dakota | 46037 | 492 | 15 |
832046 | 832046 | 2020-12-15 | Day | South Dakota | 46037 | 481 | 14 |
828799 | 828799 | 2020-12-14 | Day | South Dakota | 46037 | 468 | 14 |
825553 | 825553 | 2020-12-13 | Day | South Dakota | 46037 | 463 | 14 |
822306 | 822306 | 2020-12-12 | Day | South Dakota | 46037 | 460 | 14 |
819060 | 819060 | 2020-12-11 | Day | South Dakota | 46037 | 452 | 13 |
815814 | 815814 | 2020-12-10 | Day | South Dakota | 46037 | 448 | 12 |
812568 | 812568 | 2020-12-09 | Day | South Dakota | 46037 | 441 | 12 |
809324 | 809324 | 2020-12-08 | Day | South Dakota | 46037 | 424 | 11 |
806079 | 806079 | 2020-12-07 | Day | South Dakota | 46037 | 417 | 11 |
802834 | 802834 | 2020-12-06 | Day | South Dakota | 46037 | 417 | 11 |
799589 | 799589 | 2020-12-05 | Day | South Dakota | 46037 | 412 | 11 |
796344 | 796344 | 2020-12-04 | Day | South Dakota | 46037 | 402 | 11 |
793099 | 793099 | 2020-12-03 | Day | South Dakota | 46037 | 396 | 11 |
789854 | 789854 | 2020-12-02 | Day | South Dakota | 46037 | 388 | 11 |
786609 | 786609 | 2020-12-01 | Day | South Dakota | 46037 | 382 | 10 |
783365 | 783365 | 2020-11-30 | Day | South Dakota | 46037 | 381 | 10 |
780120 | 780120 | 2020-11-29 | Day | South Dakota | 46037 | 374 | 9 |
776874 | 776874 | 2020-11-28 | Day | South Dakota | 46037 | 368 | 9 |
773629 | 773629 | 2020-11-27 | Day | South Dakota | 46037 | 360 | 7 |
770384 | 770384 | 2020-11-26 | Day | South Dakota | 46037 | 336 | 5 |
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);