ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 46091 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 |
---|---|---|---|---|---|---|---|
1094955 | 1094955 | 2021-03-06 | Marshall | South Dakota | 46091 | 335 | 5 |
1091709 | 1091709 | 2021-03-05 | Marshall | South Dakota | 46091 | 333 | 5 |
1088463 | 1088463 | 2021-03-04 | Marshall | South Dakota | 46091 | 332 | 5 |
1085218 | 1085218 | 2021-03-03 | Marshall | South Dakota | 46091 | 323 | 5 |
1081972 | 1081972 | 2021-03-02 | Marshall | South Dakota | 46091 | 321 | 5 |
1078726 | 1078726 | 2021-03-01 | Marshall | South Dakota | 46091 | 319 | 5 |
1075481 | 1075481 | 2021-02-28 | Marshall | South Dakota | 46091 | 318 | 5 |
1072235 | 1072235 | 2021-02-27 | Marshall | South Dakota | 46091 | 318 | 5 |
1068989 | 1068989 | 2021-02-26 | Marshall | South Dakota | 46091 | 314 | 5 |
1065744 | 1065744 | 2021-02-25 | Marshall | South Dakota | 46091 | 310 | 5 |
1062499 | 1062499 | 2021-02-24 | Marshall | South Dakota | 46091 | 307 | 5 |
1059254 | 1059254 | 2021-02-23 | Marshall | South Dakota | 46091 | 305 | 5 |
1056008 | 1056008 | 2021-02-22 | Marshall | South Dakota | 46091 | 304 | 5 |
1052762 | 1052762 | 2021-02-21 | Marshall | South Dakota | 46091 | 304 | 5 |
1049515 | 1049515 | 2021-02-20 | Marshall | South Dakota | 46091 | 301 | 5 |
1046268 | 1046268 | 2021-02-19 | Marshall | South Dakota | 46091 | 299 | 5 |
1043023 | 1043023 | 2021-02-18 | Marshall | South Dakota | 46091 | 298 | 5 |
1039778 | 1039778 | 2021-02-17 | Marshall | South Dakota | 46091 | 295 | 5 |
1036533 | 1036533 | 2021-02-16 | Marshall | South Dakota | 46091 | 295 | 5 |
1033288 | 1033288 | 2021-02-15 | Marshall | South Dakota | 46091 | 295 | 5 |
1030042 | 1030042 | 2021-02-14 | Marshall | South Dakota | 46091 | 295 | 5 |
1026795 | 1026795 | 2021-02-13 | Marshall | South Dakota | 46091 | 294 | 5 |
1023550 | 1023550 | 2021-02-12 | Marshall | South Dakota | 46091 | 293 | 5 |
1020305 | 1020305 | 2021-02-11 | Marshall | South Dakota | 46091 | 291 | 5 |
1017060 | 1017060 | 2021-02-10 | Marshall | South Dakota | 46091 | 290 | 5 |
1013815 | 1013815 | 2021-02-09 | Marshall | South Dakota | 46091 | 289 | 5 |
1010570 | 1010570 | 2021-02-08 | Marshall | South Dakota | 46091 | 289 | 5 |
1007324 | 1007324 | 2021-02-07 | Marshall | South Dakota | 46091 | 289 | 5 |
1004078 | 1004078 | 2021-02-06 | Marshall | South Dakota | 46091 | 289 | 5 |
1000832 | 1000832 | 2021-02-05 | Marshall | South Dakota | 46091 | 289 | 5 |
997586 | 997586 | 2021-02-04 | Marshall | South Dakota | 46091 | 289 | 5 |
994340 | 994340 | 2021-02-03 | Marshall | South Dakota | 46091 | 289 | 5 |
991094 | 991094 | 2021-02-02 | Marshall | South Dakota | 46091 | 287 | 5 |
987848 | 987848 | 2021-02-01 | Marshall | South Dakota | 46091 | 287 | 5 |
984601 | 984601 | 2021-01-31 | Marshall | South Dakota | 46091 | 287 | 5 |
981354 | 981354 | 2021-01-30 | Marshall | South Dakota | 46091 | 286 | 5 |
978108 | 978108 | 2021-01-29 | Marshall | South Dakota | 46091 | 286 | 5 |
974863 | 974863 | 2021-01-28 | Marshall | South Dakota | 46091 | 286 | 5 |
971618 | 971618 | 2021-01-27 | Marshall | South Dakota | 46091 | 284 | 5 |
968373 | 968373 | 2021-01-26 | Marshall | South Dakota | 46091 | 283 | 5 |
965129 | 965129 | 2021-01-25 | Marshall | South Dakota | 46091 | 283 | 5 |
961884 | 961884 | 2021-01-24 | Marshall | South Dakota | 46091 | 283 | 5 |
958639 | 958639 | 2021-01-23 | Marshall | South Dakota | 46091 | 282 | 5 |
955393 | 955393 | 2021-01-22 | Marshall | South Dakota | 46091 | 281 | 5 |
952148 | 952148 | 2021-01-21 | Marshall | South Dakota | 46091 | 281 | 5 |
948903 | 948903 | 2021-01-20 | Marshall | South Dakota | 46091 | 280 | 5 |
945657 | 945657 | 2021-01-19 | Marshall | South Dakota | 46091 | 279 | 5 |
942410 | 942410 | 2021-01-18 | Marshall | South Dakota | 46091 | 278 | 5 |
939165 | 939165 | 2021-01-17 | Marshall | South Dakota | 46091 | 277 | 5 |
935920 | 935920 | 2021-01-16 | Marshall | South Dakota | 46091 | 275 | 5 |
932675 | 932675 | 2021-01-15 | Marshall | South Dakota | 46091 | 275 | 5 |
929430 | 929430 | 2021-01-14 | Marshall | South Dakota | 46091 | 274 | 5 |
926185 | 926185 | 2021-01-13 | Marshall | South Dakota | 46091 | 272 | 5 |
922939 | 922939 | 2021-01-12 | Marshall | South Dakota | 46091 | 270 | 5 |
919694 | 919694 | 2021-01-11 | Marshall | South Dakota | 46091 | 270 | 5 |
916449 | 916449 | 2021-01-10 | Marshall | South Dakota | 46091 | 269 | 5 |
913204 | 913204 | 2021-01-09 | Marshall | South Dakota | 46091 | 267 | 5 |
909959 | 909959 | 2021-01-08 | Marshall | South Dakota | 46091 | 266 | 4 |
906714 | 906714 | 2021-01-07 | Marshall | South Dakota | 46091 | 264 | 4 |
903468 | 903468 | 2021-01-06 | Marshall | South Dakota | 46091 | 263 | 4 |
900223 | 900223 | 2021-01-05 | Marshall | South Dakota | 46091 | 262 | 4 |
896978 | 896978 | 2021-01-04 | Marshall | South Dakota | 46091 | 262 | 4 |
893732 | 893732 | 2021-01-03 | Marshall | South Dakota | 46091 | 262 | 4 |
890486 | 890486 | 2021-01-02 | Marshall | South Dakota | 46091 | 262 | 4 |
887239 | 887239 | 2021-01-01 | Marshall | South Dakota | 46091 | 260 | 4 |
883994 | 883994 | 2020-12-31 | Marshall | South Dakota | 46091 | 260 | 4 |
880749 | 880749 | 2020-12-30 | Marshall | South Dakota | 46091 | 260 | 4 |
877504 | 877504 | 2020-12-29 | Marshall | South Dakota | 46091 | 260 | 4 |
874259 | 874259 | 2020-12-28 | Marshall | South Dakota | 46091 | 259 | 4 |
871014 | 871014 | 2020-12-27 | Marshall | South Dakota | 46091 | 257 | 4 |
867769 | 867769 | 2020-12-26 | Marshall | South Dakota | 46091 | 256 | 4 |
864524 | 864524 | 2020-12-25 | Marshall | South Dakota | 46091 | 256 | 4 |
861279 | 861279 | 2020-12-24 | Marshall | South Dakota | 46091 | 256 | 4 |
858034 | 858034 | 2020-12-23 | Marshall | South Dakota | 46091 | 254 | 4 |
854789 | 854789 | 2020-12-22 | Marshall | South Dakota | 46091 | 252 | 4 |
851544 | 851544 | 2020-12-21 | Marshall | South Dakota | 46091 | 249 | 4 |
848299 | 848299 | 2020-12-20 | Marshall | South Dakota | 46091 | 249 | 4 |
845054 | 845054 | 2020-12-19 | Marshall | South Dakota | 46091 | 248 | 4 |
841808 | 841808 | 2020-12-18 | Marshall | South Dakota | 46091 | 240 | 4 |
838563 | 838563 | 2020-12-17 | Marshall | South Dakota | 46091 | 237 | 4 |
835317 | 835317 | 2020-12-16 | Marshall | South Dakota | 46091 | 232 | 4 |
832071 | 832071 | 2020-12-15 | Marshall | South Dakota | 46091 | 231 | 3 |
828824 | 828824 | 2020-12-14 | Marshall | South Dakota | 46091 | 229 | 3 |
825578 | 825578 | 2020-12-13 | Marshall | South Dakota | 46091 | 229 | 3 |
822331 | 822331 | 2020-12-12 | Marshall | South Dakota | 46091 | 224 | 3 |
819085 | 819085 | 2020-12-11 | Marshall | South Dakota | 46091 | 220 | 3 |
815839 | 815839 | 2020-12-10 | Marshall | South Dakota | 46091 | 220 | 3 |
812593 | 812593 | 2020-12-09 | Marshall | South Dakota | 46091 | 219 | 3 |
809349 | 809349 | 2020-12-08 | Marshall | South Dakota | 46091 | 216 | 3 |
806104 | 806104 | 2020-12-07 | Marshall | South Dakota | 46091 | 210 | 3 |
802859 | 802859 | 2020-12-06 | Marshall | South Dakota | 46091 | 207 | 3 |
799614 | 799614 | 2020-12-05 | Marshall | South Dakota | 46091 | 207 | 3 |
796369 | 796369 | 2020-12-04 | Marshall | South Dakota | 46091 | 205 | 3 |
793124 | 793124 | 2020-12-03 | Marshall | South Dakota | 46091 | 198 | 3 |
789879 | 789879 | 2020-12-02 | Marshall | South Dakota | 46091 | 194 | 3 |
786634 | 786634 | 2020-12-01 | Marshall | South Dakota | 46091 | 191 | 3 |
783390 | 783390 | 2020-11-30 | Marshall | South Dakota | 46091 | 183 | 3 |
780145 | 780145 | 2020-11-29 | Marshall | South Dakota | 46091 | 178 | 3 |
776899 | 776899 | 2020-11-28 | Marshall | South Dakota | 46091 | 176 | 3 |
773654 | 773654 | 2020-11-27 | Marshall | South Dakota | 46091 | 170 | 3 |
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);