ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Minnehaha" 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 |
---|---|---|---|---|---|---|---|
1056014 | 1056014 | 2021-02-22 | Minnehaha | South Dakota | 46099 | 27740 | 329 |
1052768 | 1052768 | 2021-02-21 | Minnehaha | South Dakota | 46099 | 27740 | 329 |
1049521 | 1049521 | 2021-02-20 | Minnehaha | South Dakota | 46099 | 27702 | 326 |
1046274 | 1046274 | 2021-02-19 | Minnehaha | South Dakota | 46099 | 27669 | 326 |
1043029 | 1043029 | 2021-02-18 | Minnehaha | South Dakota | 46099 | 27640 | 326 |
1039784 | 1039784 | 2021-02-17 | Minnehaha | South Dakota | 46099 | 27600 | 325 |
1036539 | 1036539 | 2021-02-16 | Minnehaha | South Dakota | 46099 | 27575 | 325 |
1033294 | 1033294 | 2021-02-15 | Minnehaha | South Dakota | 46099 | 27518 | 325 |
1030048 | 1030048 | 2021-02-14 | Minnehaha | South Dakota | 46099 | 27505 | 325 |
1026801 | 1026801 | 2021-02-13 | Minnehaha | South Dakota | 46099 | 27488 | 323 |
1023556 | 1023556 | 2021-02-12 | Minnehaha | South Dakota | 46099 | 27455 | 323 |
1020311 | 1020311 | 2021-02-11 | Minnehaha | South Dakota | 46099 | 27408 | 323 |
1017066 | 1017066 | 2021-02-10 | Minnehaha | South Dakota | 46099 | 27333 | 320 |
1013821 | 1013821 | 2021-02-09 | Minnehaha | South Dakota | 46099 | 27297 | 319 |
1010576 | 1010576 | 2021-02-08 | Minnehaha | South Dakota | 46099 | 27264 | 319 |
1007330 | 1007330 | 2021-02-07 | Minnehaha | South Dakota | 46099 | 27257 | 319 |
1004084 | 1004084 | 2021-02-06 | Minnehaha | South Dakota | 46099 | 27235 | 318 |
1000838 | 1000838 | 2021-02-05 | Minnehaha | South Dakota | 46099 | 27194 | 315 |
997592 | 997592 | 2021-02-04 | Minnehaha | South Dakota | 46099 | 27149 | 312 |
994346 | 994346 | 2021-02-03 | Minnehaha | South Dakota | 46099 | 27109 | 311 |
991100 | 991100 | 2021-02-02 | Minnehaha | South Dakota | 46099 | 27059 | 311 |
987854 | 987854 | 2021-02-01 | Minnehaha | South Dakota | 46099 | 27015 | 311 |
984607 | 984607 | 2021-01-31 | Minnehaha | South Dakota | 46099 | 26993 | 311 |
981360 | 981360 | 2021-01-30 | Minnehaha | South Dakota | 46099 | 26954 | 311 |
978114 | 978114 | 2021-01-29 | Minnehaha | South Dakota | 46099 | 26926 | 310 |
974869 | 974869 | 2021-01-28 | Minnehaha | South Dakota | 46099 | 26895 | 310 |
971624 | 971624 | 2021-01-27 | Minnehaha | South Dakota | 46099 | 26861 | 306 |
968379 | 968379 | 2021-01-26 | Minnehaha | South Dakota | 46099 | 26823 | 300 |
965135 | 965135 | 2021-01-25 | Minnehaha | South Dakota | 46099 | 26775 | 300 |
961890 | 961890 | 2021-01-24 | Minnehaha | South Dakota | 46099 | 26760 | 300 |
958645 | 958645 | 2021-01-23 | Minnehaha | South Dakota | 46099 | 26721 | 298 |
955399 | 955399 | 2021-01-22 | Minnehaha | South Dakota | 46099 | 26676 | 296 |
952154 | 952154 | 2021-01-21 | Minnehaha | South Dakota | 46099 | 26592 | 296 |
948909 | 948909 | 2021-01-20 | Minnehaha | South Dakota | 46099 | 26509 | 296 |
945663 | 945663 | 2021-01-19 | Minnehaha | South Dakota | 46099 | 26457 | 296 |
942416 | 942416 | 2021-01-18 | Minnehaha | South Dakota | 46099 | 26425 | 296 |
939171 | 939171 | 2021-01-17 | Minnehaha | South Dakota | 46099 | 26399 | 296 |
935926 | 935926 | 2021-01-16 | Minnehaha | South Dakota | 46099 | 26339 | 293 |
932681 | 932681 | 2021-01-15 | Minnehaha | South Dakota | 46099 | 26288 | 291 |
929436 | 929436 | 2021-01-14 | Minnehaha | South Dakota | 46099 | 26189 | 290 |
926191 | 926191 | 2021-01-13 | Minnehaha | South Dakota | 46099 | 26117 | 290 |
922945 | 922945 | 2021-01-12 | Minnehaha | South Dakota | 46099 | 26028 | 285 |
919700 | 919700 | 2021-01-11 | Minnehaha | South Dakota | 46099 | 25972 | 285 |
916455 | 916455 | 2021-01-10 | Minnehaha | South Dakota | 46099 | 25924 | 285 |
913210 | 913210 | 2021-01-09 | Minnehaha | South Dakota | 46099 | 25838 | 284 |
909965 | 909965 | 2021-01-08 | Minnehaha | South Dakota | 46099 | 25774 | 281 |
906720 | 906720 | 2021-01-07 | Minnehaha | South Dakota | 46099 | 25672 | 276 |
903474 | 903474 | 2021-01-06 | Minnehaha | South Dakota | 46099 | 25579 | 272 |
900229 | 900229 | 2021-01-05 | Minnehaha | South Dakota | 46099 | 25435 | 271 |
896984 | 896984 | 2021-01-04 | Minnehaha | South Dakota | 46099 | 25333 | 271 |
893738 | 893738 | 2021-01-03 | Minnehaha | South Dakota | 46099 | 25315 | 271 |
890492 | 890492 | 2021-01-02 | Minnehaha | South Dakota | 46099 | 25108 | 267 |
887245 | 887245 | 2021-01-01 | Minnehaha | South Dakota | 46099 | 24977 | 264 |
884000 | 884000 | 2020-12-31 | Minnehaha | South Dakota | 46099 | 24977 | 264 |
880755 | 880755 | 2020-12-30 | Minnehaha | South Dakota | 46099 | 24896 | 262 |
877510 | 877510 | 2020-12-29 | Minnehaha | South Dakota | 46099 | 24774 | 259 |
874265 | 874265 | 2020-12-28 | Minnehaha | South Dakota | 46099 | 24663 | 259 |
871020 | 871020 | 2020-12-27 | Minnehaha | South Dakota | 46099 | 24605 | 259 |
867775 | 867775 | 2020-12-26 | Minnehaha | South Dakota | 46099 | 24483 | 259 |
864530 | 864530 | 2020-12-25 | Minnehaha | South Dakota | 46099 | 24377 | 257 |
861285 | 861285 | 2020-12-24 | Minnehaha | South Dakota | 46099 | 24377 | 257 |
858040 | 858040 | 2020-12-23 | Minnehaha | South Dakota | 46099 | 24263 | 251 |
854795 | 854795 | 2020-12-22 | Minnehaha | South Dakota | 46099 | 24154 | 251 |
851550 | 851550 | 2020-12-21 | Minnehaha | South Dakota | 46099 | 24064 | 251 |
848305 | 848305 | 2020-12-20 | Minnehaha | South Dakota | 46099 | 23980 | 247 |
845060 | 845060 | 2020-12-19 | Minnehaha | South Dakota | 46099 | 23900 | 244 |
841814 | 841814 | 2020-12-18 | Minnehaha | South Dakota | 46099 | 23759 | 239 |
838569 | 838569 | 2020-12-17 | Minnehaha | South Dakota | 46099 | 23618 | 237 |
835323 | 835323 | 2020-12-16 | Minnehaha | South Dakota | 46099 | 23455 | 237 |
832077 | 832077 | 2020-12-15 | Minnehaha | South Dakota | 46099 | 23269 | 232 |
828830 | 828830 | 2020-12-14 | Minnehaha | South Dakota | 46099 | 23188 | 232 |
825584 | 825584 | 2020-12-13 | Minnehaha | South Dakota | 46099 | 23112 | 232 |
822337 | 822337 | 2020-12-12 | Minnehaha | South Dakota | 46099 | 22930 | 229 |
819091 | 819091 | 2020-12-11 | Minnehaha | South Dakota | 46099 | 22743 | 221 |
815845 | 815845 | 2020-12-10 | Minnehaha | South Dakota | 46099 | 22451 | 215 |
812599 | 812599 | 2020-12-09 | Minnehaha | South Dakota | 46099 | 22291 | 208 |
809355 | 809355 | 2020-12-08 | Minnehaha | South Dakota | 46099 | 22081 | 204 |
806110 | 806110 | 2020-12-07 | Minnehaha | South Dakota | 46099 | 21902 | 204 |
802865 | 802865 | 2020-12-06 | Minnehaha | South Dakota | 46099 | 21771 | 204 |
799620 | 799620 | 2020-12-05 | Minnehaha | South Dakota | 46099 | 21579 | 203 |
796375 | 796375 | 2020-12-04 | Minnehaha | South Dakota | 46099 | 21369 | 202 |
793130 | 793130 | 2020-12-03 | Minnehaha | South Dakota | 46099 | 21173 | 195 |
789885 | 789885 | 2020-12-02 | Minnehaha | South Dakota | 46099 | 20947 | 191 |
786640 | 786640 | 2020-12-01 | Minnehaha | South Dakota | 46099 | 20652 | 184 |
783396 | 783396 | 2020-11-30 | Minnehaha | South Dakota | 46099 | 20520 | 183 |
780151 | 780151 | 2020-11-29 | Minnehaha | South Dakota | 46099 | 20454 | 183 |
776905 | 776905 | 2020-11-28 | Minnehaha | South Dakota | 46099 | 20247 | 183 |
773660 | 773660 | 2020-11-27 | Minnehaha | South Dakota | 46099 | 20045 | 172 |
770415 | 770415 | 2020-11-26 | Minnehaha | South Dakota | 46099 | 19493 | 169 |
767169 | 767169 | 2020-11-25 | Minnehaha | South Dakota | 46099 | 19493 | 169 |
763924 | 763924 | 2020-11-24 | Minnehaha | South Dakota | 46099 | 19186 | 162 |
760679 | 760679 | 2020-11-23 | Minnehaha | South Dakota | 46099 | 18938 | 162 |
757434 | 757434 | 2020-11-22 | Minnehaha | South Dakota | 46099 | 18739 | 162 |
754187 | 754187 | 2020-11-21 | Minnehaha | South Dakota | 46099 | 18533 | 155 |
750941 | 750941 | 2020-11-20 | Minnehaha | South Dakota | 46099 | 18247 | 151 |
747695 | 747695 | 2020-11-19 | Minnehaha | South Dakota | 46099 | 18013 | 149 |
744449 | 744449 | 2020-11-18 | Minnehaha | South Dakota | 46099 | 17751 | 143 |
741202 | 741202 | 2020-11-17 | Minnehaha | South Dakota | 46099 | 17452 | 139 |
737956 | 737956 | 2020-11-16 | Minnehaha | South Dakota | 46099 | 17222 | 139 |
734712 | 734712 | 2020-11-15 | Minnehaha | South Dakota | 46099 | 17017 | 139 |
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);