ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Hamlin" 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 |
---|---|---|---|---|---|---|---|
1280032 | 1280032 | 2021-05-02 | Hamlin | South Dakota | 46057 | 794 | 39 |
1276785 | 1276785 | 2021-05-01 | Hamlin | South Dakota | 46057 | 794 | 39 |
1273538 | 1273538 | 2021-04-30 | Hamlin | South Dakota | 46057 | 794 | 39 |
1270291 | 1270291 | 2021-04-29 | Hamlin | South Dakota | 46057 | 794 | 39 |
1267044 | 1267044 | 2021-04-28 | Hamlin | South Dakota | 46057 | 793 | 39 |
1263797 | 1263797 | 2021-04-27 | Hamlin | South Dakota | 46057 | 793 | 39 |
1260550 | 1260550 | 2021-04-26 | Hamlin | South Dakota | 46057 | 792 | 39 |
1257303 | 1257303 | 2021-04-25 | Hamlin | South Dakota | 46057 | 792 | 39 |
1254056 | 1254056 | 2021-04-24 | Hamlin | South Dakota | 46057 | 792 | 39 |
1250809 | 1250809 | 2021-04-23 | Hamlin | South Dakota | 46057 | 792 | 39 |
1247562 | 1247562 | 2021-04-22 | Hamlin | South Dakota | 46057 | 791 | 39 |
1244315 | 1244315 | 2021-04-21 | Hamlin | South Dakota | 46057 | 791 | 39 |
1241068 | 1241068 | 2021-04-20 | Hamlin | South Dakota | 46057 | 791 | 39 |
1237821 | 1237821 | 2021-04-19 | Hamlin | South Dakota | 46057 | 789 | 39 |
1234574 | 1234574 | 2021-04-18 | Hamlin | South Dakota | 46057 | 788 | 39 |
1231326 | 1231326 | 2021-04-17 | Hamlin | South Dakota | 46057 | 788 | 39 |
1228078 | 1228078 | 2021-04-16 | Hamlin | South Dakota | 46057 | 788 | 39 |
1224830 | 1224830 | 2021-04-15 | Hamlin | South Dakota | 46057 | 782 | 39 |
1221583 | 1221583 | 2021-04-14 | Hamlin | South Dakota | 46057 | 779 | 39 |
1218335 | 1218335 | 2021-04-13 | Hamlin | South Dakota | 46057 | 776 | 39 |
1215087 | 1215087 | 2021-04-12 | Hamlin | South Dakota | 46057 | 772 | 39 |
1211840 | 1211840 | 2021-04-11 | Hamlin | South Dakota | 46057 | 768 | 39 |
1208591 | 1208591 | 2021-04-10 | Hamlin | South Dakota | 46057 | 768 | 39 |
1205343 | 1205343 | 2021-04-09 | Hamlin | South Dakota | 46057 | 765 | 39 |
1202095 | 1202095 | 2021-04-08 | Hamlin | South Dakota | 46057 | 759 | 39 |
1198846 | 1198846 | 2021-04-07 | Hamlin | South Dakota | 46057 | 758 | 38 |
1195597 | 1195597 | 2021-04-06 | Hamlin | South Dakota | 46057 | 755 | 38 |
1192349 | 1192349 | 2021-04-05 | Hamlin | South Dakota | 46057 | 755 | 38 |
1189100 | 1189100 | 2021-04-04 | Hamlin | South Dakota | 46057 | 754 | 38 |
1185853 | 1185853 | 2021-04-03 | Hamlin | South Dakota | 46057 | 754 | 38 |
1182606 | 1182606 | 2021-04-02 | Hamlin | South Dakota | 46057 | 751 | 38 |
1179359 | 1179359 | 2021-04-01 | Hamlin | South Dakota | 46057 | 747 | 38 |
1176112 | 1176112 | 2021-03-31 | Hamlin | South Dakota | 46057 | 745 | 38 |
1172865 | 1172865 | 2021-03-30 | Hamlin | South Dakota | 46057 | 745 | 38 |
1169618 | 1169618 | 2021-03-29 | Hamlin | South Dakota | 46057 | 745 | 38 |
1166370 | 1166370 | 2021-03-28 | Hamlin | South Dakota | 46057 | 743 | 38 |
1163122 | 1163122 | 2021-03-27 | Hamlin | South Dakota | 46057 | 742 | 38 |
1159873 | 1159873 | 2021-03-26 | Hamlin | South Dakota | 46057 | 740 | 38 |
1156626 | 1156626 | 2021-03-25 | Hamlin | South Dakota | 46057 | 738 | 38 |
1153379 | 1153379 | 2021-03-24 | Hamlin | South Dakota | 46057 | 738 | 38 |
1150132 | 1150132 | 2021-03-23 | Hamlin | South Dakota | 46057 | 737 | 38 |
1146885 | 1146885 | 2021-03-22 | Hamlin | South Dakota | 46057 | 737 | 38 |
1143638 | 1143638 | 2021-03-21 | Hamlin | South Dakota | 46057 | 737 | 38 |
1140391 | 1140391 | 2021-03-20 | Hamlin | South Dakota | 46057 | 737 | 38 |
1137145 | 1137145 | 2021-03-19 | Hamlin | South Dakota | 46057 | 735 | 38 |
1133899 | 1133899 | 2021-03-18 | Hamlin | South Dakota | 46057 | 734 | 38 |
1130651 | 1130651 | 2021-03-17 | Hamlin | South Dakota | 46057 | 734 | 38 |
1127404 | 1127404 | 2021-03-16 | Hamlin | South Dakota | 46057 | 730 | 38 |
1124158 | 1124158 | 2021-03-15 | Hamlin | South Dakota | 46057 | 729 | 38 |
1120912 | 1120912 | 2021-03-14 | Hamlin | South Dakota | 46057 | 729 | 38 |
1117665 | 1117665 | 2021-03-13 | Hamlin | South Dakota | 46057 | 729 | 38 |
1114418 | 1114418 | 2021-03-12 | Hamlin | South Dakota | 46057 | 728 | 38 |
1111172 | 1111172 | 2021-03-11 | Hamlin | South Dakota | 46057 | 726 | 38 |
1107926 | 1107926 | 2021-03-10 | Hamlin | South Dakota | 46057 | 724 | 38 |
1104680 | 1104680 | 2021-03-09 | Hamlin | South Dakota | 46057 | 723 | 38 |
1101434 | 1101434 | 2021-03-08 | Hamlin | South Dakota | 46057 | 722 | 38 |
1098188 | 1098188 | 2021-03-07 | Hamlin | South Dakota | 46057 | 722 | 38 |
1094940 | 1094940 | 2021-03-06 | Hamlin | South Dakota | 46057 | 721 | 38 |
1091694 | 1091694 | 2021-03-05 | Hamlin | South Dakota | 46057 | 721 | 38 |
1088448 | 1088448 | 2021-03-04 | Hamlin | South Dakota | 46057 | 719 | 38 |
1085203 | 1085203 | 2021-03-03 | Hamlin | South Dakota | 46057 | 717 | 38 |
1081957 | 1081957 | 2021-03-02 | Hamlin | South Dakota | 46057 | 714 | 37 |
1078711 | 1078711 | 2021-03-01 | Hamlin | South Dakota | 46057 | 713 | 37 |
1075466 | 1075466 | 2021-02-28 | Hamlin | South Dakota | 46057 | 712 | 37 |
1072220 | 1072220 | 2021-02-27 | Hamlin | South Dakota | 46057 | 709 | 37 |
1068974 | 1068974 | 2021-02-26 | Hamlin | South Dakota | 46057 | 710 | 38 |
1065729 | 1065729 | 2021-02-25 | Hamlin | South Dakota | 46057 | 707 | 38 |
1062484 | 1062484 | 2021-02-24 | Hamlin | South Dakota | 46057 | 701 | 38 |
1059239 | 1059239 | 2021-02-23 | Hamlin | South Dakota | 46057 | 699 | 38 |
1055993 | 1055993 | 2021-02-22 | Hamlin | South Dakota | 46057 | 695 | 38 |
1052747 | 1052747 | 2021-02-21 | Hamlin | South Dakota | 46057 | 695 | 38 |
1049500 | 1049500 | 2021-02-20 | Hamlin | South Dakota | 46057 | 694 | 38 |
1046253 | 1046253 | 2021-02-19 | Hamlin | South Dakota | 46057 | 694 | 38 |
1043008 | 1043008 | 2021-02-18 | Hamlin | South Dakota | 46057 | 689 | 38 |
1039763 | 1039763 | 2021-02-17 | Hamlin | South Dakota | 46057 | 687 | 38 |
1036518 | 1036518 | 2021-02-16 | Hamlin | South Dakota | 46057 | 685 | 38 |
1033273 | 1033273 | 2021-02-15 | Hamlin | South Dakota | 46057 | 684 | 38 |
1030027 | 1030027 | 2021-02-14 | Hamlin | South Dakota | 46057 | 682 | 38 |
1026780 | 1026780 | 2021-02-13 | Hamlin | South Dakota | 46057 | 682 | 38 |
1023535 | 1023535 | 2021-02-12 | Hamlin | South Dakota | 46057 | 679 | 38 |
1020290 | 1020290 | 2021-02-11 | Hamlin | South Dakota | 46057 | 676 | 38 |
1017045 | 1017045 | 2021-02-10 | Hamlin | South Dakota | 46057 | 673 | 38 |
1013800 | 1013800 | 2021-02-09 | Hamlin | South Dakota | 46057 | 673 | 38 |
1010555 | 1010555 | 2021-02-08 | Hamlin | South Dakota | 46057 | 673 | 38 |
1007309 | 1007309 | 2021-02-07 | Hamlin | South Dakota | 46057 | 672 | 38 |
1004063 | 1004063 | 2021-02-06 | Hamlin | South Dakota | 46057 | 672 | 38 |
1000817 | 1000817 | 2021-02-05 | Hamlin | South Dakota | 46057 | 671 | 38 |
997571 | 997571 | 2021-02-04 | Hamlin | South Dakota | 46057 | 671 | 38 |
994325 | 994325 | 2021-02-03 | Hamlin | South Dakota | 46057 | 670 | 38 |
991079 | 991079 | 2021-02-02 | Hamlin | South Dakota | 46057 | 669 | 38 |
987833 | 987833 | 2021-02-01 | Hamlin | South Dakota | 46057 | 669 | 38 |
984586 | 984586 | 2021-01-31 | Hamlin | South Dakota | 46057 | 669 | 38 |
981339 | 981339 | 2021-01-30 | Hamlin | South Dakota | 46057 | 666 | 38 |
978093 | 978093 | 2021-01-29 | Hamlin | South Dakota | 46057 | 665 | 38 |
974848 | 974848 | 2021-01-28 | Hamlin | South Dakota | 46057 | 665 | 38 |
971603 | 971603 | 2021-01-27 | Hamlin | South Dakota | 46057 | 664 | 38 |
968358 | 968358 | 2021-01-26 | Hamlin | South Dakota | 46057 | 664 | 38 |
965114 | 965114 | 2021-01-25 | Hamlin | South Dakota | 46057 | 662 | 38 |
961869 | 961869 | 2021-01-24 | Hamlin | South Dakota | 46057 | 662 | 38 |
958624 | 958624 | 2021-01-23 | Hamlin | South Dakota | 46057 | 662 | 38 |
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);