ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Fall River" 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 |
---|---|---|---|---|---|---|---|
1280027 | 1280027 | 2021-05-02 | Fall River | South Dakota | 46047 | 591 | 15 |
1276780 | 1276780 | 2021-05-01 | Fall River | South Dakota | 46047 | 591 | 15 |
1273533 | 1273533 | 2021-04-30 | Fall River | South Dakota | 46047 | 591 | 15 |
1270286 | 1270286 | 2021-04-29 | Fall River | South Dakota | 46047 | 590 | 15 |
1267039 | 1267039 | 2021-04-28 | Fall River | South Dakota | 46047 | 590 | 15 |
1263792 | 1263792 | 2021-04-27 | Fall River | South Dakota | 46047 | 589 | 15 |
1260545 | 1260545 | 2021-04-26 | Fall River | South Dakota | 46047 | 589 | 15 |
1257298 | 1257298 | 2021-04-25 | Fall River | South Dakota | 46047 | 589 | 15 |
1254051 | 1254051 | 2021-04-24 | Fall River | South Dakota | 46047 | 589 | 15 |
1250804 | 1250804 | 2021-04-23 | Fall River | South Dakota | 46047 | 588 | 15 |
1247557 | 1247557 | 2021-04-22 | Fall River | South Dakota | 46047 | 587 | 15 |
1244310 | 1244310 | 2021-04-21 | Fall River | South Dakota | 46047 | 586 | 15 |
1241063 | 1241063 | 2021-04-20 | Fall River | South Dakota | 46047 | 584 | 15 |
1237816 | 1237816 | 2021-04-19 | Fall River | South Dakota | 46047 | 583 | 15 |
1234569 | 1234569 | 2021-04-18 | Fall River | South Dakota | 46047 | 581 | 15 |
1231321 | 1231321 | 2021-04-17 | Fall River | South Dakota | 46047 | 581 | 15 |
1228073 | 1228073 | 2021-04-16 | Fall River | South Dakota | 46047 | 581 | 15 |
1224825 | 1224825 | 2021-04-15 | Fall River | South Dakota | 46047 | 581 | 15 |
1221578 | 1221578 | 2021-04-14 | Fall River | South Dakota | 46047 | 578 | 15 |
1218330 | 1218330 | 2021-04-13 | Fall River | South Dakota | 46047 | 575 | 15 |
1215082 | 1215082 | 2021-04-12 | Fall River | South Dakota | 46047 | 574 | 15 |
1211835 | 1211835 | 2021-04-11 | Fall River | South Dakota | 46047 | 573 | 15 |
1208586 | 1208586 | 2021-04-10 | Fall River | South Dakota | 46047 | 573 | 15 |
1205338 | 1205338 | 2021-04-09 | Fall River | South Dakota | 46047 | 573 | 15 |
1202090 | 1202090 | 2021-04-08 | Fall River | South Dakota | 46047 | 570 | 15 |
1198841 | 1198841 | 2021-04-07 | Fall River | South Dakota | 46047 | 569 | 15 |
1195592 | 1195592 | 2021-04-06 | Fall River | South Dakota | 46047 | 567 | 15 |
1192344 | 1192344 | 2021-04-05 | Fall River | South Dakota | 46047 | 567 | 15 |
1189095 | 1189095 | 2021-04-04 | Fall River | South Dakota | 46047 | 566 | 15 |
1185848 | 1185848 | 2021-04-03 | Fall River | South Dakota | 46047 | 566 | 15 |
1182601 | 1182601 | 2021-04-02 | Fall River | South Dakota | 46047 | 566 | 15 |
1179354 | 1179354 | 2021-04-01 | Fall River | South Dakota | 46047 | 566 | 15 |
1176107 | 1176107 | 2021-03-31 | Fall River | South Dakota | 46047 | 564 | 15 |
1172860 | 1172860 | 2021-03-30 | Fall River | South Dakota | 46047 | 564 | 15 |
1169613 | 1169613 | 2021-03-29 | Fall River | South Dakota | 46047 | 564 | 15 |
1166365 | 1166365 | 2021-03-28 | Fall River | South Dakota | 46047 | 564 | 15 |
1163117 | 1163117 | 2021-03-27 | Fall River | South Dakota | 46047 | 564 | 15 |
1159868 | 1159868 | 2021-03-26 | Fall River | South Dakota | 46047 | 562 | 15 |
1156621 | 1156621 | 2021-03-25 | Fall River | South Dakota | 46047 | 561 | 15 |
1153374 | 1153374 | 2021-03-24 | Fall River | South Dakota | 46047 | 558 | 15 |
1150127 | 1150127 | 2021-03-23 | Fall River | South Dakota | 46047 | 558 | 15 |
1146880 | 1146880 | 2021-03-22 | Fall River | South Dakota | 46047 | 558 | 15 |
1143633 | 1143633 | 2021-03-21 | Fall River | South Dakota | 46047 | 558 | 15 |
1140386 | 1140386 | 2021-03-20 | Fall River | South Dakota | 46047 | 558 | 15 |
1137140 | 1137140 | 2021-03-19 | Fall River | South Dakota | 46047 | 558 | 15 |
1133894 | 1133894 | 2021-03-18 | Fall River | South Dakota | 46047 | 557 | 15 |
1130646 | 1130646 | 2021-03-17 | Fall River | South Dakota | 46047 | 556 | 15 |
1127399 | 1127399 | 2021-03-16 | Fall River | South Dakota | 46047 | 553 | 15 |
1124153 | 1124153 | 2021-03-15 | Fall River | South Dakota | 46047 | 553 | 15 |
1120907 | 1120907 | 2021-03-14 | Fall River | South Dakota | 46047 | 553 | 15 |
1117660 | 1117660 | 2021-03-13 | Fall River | South Dakota | 46047 | 553 | 15 |
1114413 | 1114413 | 2021-03-12 | Fall River | South Dakota | 46047 | 553 | 15 |
1111167 | 1111167 | 2021-03-11 | Fall River | South Dakota | 46047 | 550 | 15 |
1107921 | 1107921 | 2021-03-10 | Fall River | South Dakota | 46047 | 549 | 15 |
1104675 | 1104675 | 2021-03-09 | Fall River | South Dakota | 46047 | 547 | 15 |
1101429 | 1101429 | 2021-03-08 | Fall River | South Dakota | 46047 | 546 | 15 |
1098183 | 1098183 | 2021-03-07 | Fall River | South Dakota | 46047 | 546 | 15 |
1094935 | 1094935 | 2021-03-06 | Fall River | South Dakota | 46047 | 541 | 15 |
1091689 | 1091689 | 2021-03-05 | Fall River | South Dakota | 46047 | 541 | 15 |
1088443 | 1088443 | 2021-03-04 | Fall River | South Dakota | 46047 | 537 | 15 |
1085198 | 1085198 | 2021-03-03 | Fall River | South Dakota | 46047 | 530 | 15 |
1081952 | 1081952 | 2021-03-02 | Fall River | South Dakota | 46047 | 529 | 15 |
1078706 | 1078706 | 2021-03-01 | Fall River | South Dakota | 46047 | 527 | 15 |
1075461 | 1075461 | 2021-02-28 | Fall River | South Dakota | 46047 | 527 | 15 |
1072215 | 1072215 | 2021-02-27 | Fall River | South Dakota | 46047 | 527 | 15 |
1068969 | 1068969 | 2021-02-26 | Fall River | South Dakota | 46047 | 526 | 15 |
1065724 | 1065724 | 2021-02-25 | Fall River | South Dakota | 46047 | 525 | 15 |
1062479 | 1062479 | 2021-02-24 | Fall River | South Dakota | 46047 | 524 | 15 |
1059234 | 1059234 | 2021-02-23 | Fall River | South Dakota | 46047 | 521 | 15 |
1055988 | 1055988 | 2021-02-22 | Fall River | South Dakota | 46047 | 520 | 15 |
1052742 | 1052742 | 2021-02-21 | Fall River | South Dakota | 46047 | 520 | 15 |
1049495 | 1049495 | 2021-02-20 | Fall River | South Dakota | 46047 | 519 | 15 |
1046248 | 1046248 | 2021-02-19 | Fall River | South Dakota | 46047 | 519 | 15 |
1043003 | 1043003 | 2021-02-18 | Fall River | South Dakota | 46047 | 517 | 15 |
1039758 | 1039758 | 2021-02-17 | Fall River | South Dakota | 46047 | 517 | 15 |
1036513 | 1036513 | 2021-02-16 | Fall River | South Dakota | 46047 | 517 | 15 |
1033268 | 1033268 | 2021-02-15 | Fall River | South Dakota | 46047 | 515 | 15 |
1030022 | 1030022 | 2021-02-14 | Fall River | South Dakota | 46047 | 515 | 15 |
1026775 | 1026775 | 2021-02-13 | Fall River | South Dakota | 46047 | 515 | 15 |
1023530 | 1023530 | 2021-02-12 | Fall River | South Dakota | 46047 | 515 | 15 |
1020285 | 1020285 | 2021-02-11 | Fall River | South Dakota | 46047 | 515 | 15 |
1017040 | 1017040 | 2021-02-10 | Fall River | South Dakota | 46047 | 513 | 15 |
1013795 | 1013795 | 2021-02-09 | Fall River | South Dakota | 46047 | 513 | 15 |
1010550 | 1010550 | 2021-02-08 | Fall River | South Dakota | 46047 | 512 | 15 |
1007304 | 1007304 | 2021-02-07 | Fall River | South Dakota | 46047 | 512 | 15 |
1004058 | 1004058 | 2021-02-06 | Fall River | South Dakota | 46047 | 512 | 15 |
1000812 | 1000812 | 2021-02-05 | Fall River | South Dakota | 46047 | 511 | 15 |
997566 | 997566 | 2021-02-04 | Fall River | South Dakota | 46047 | 510 | 15 |
994320 | 994320 | 2021-02-03 | Fall River | South Dakota | 46047 | 508 | 15 |
991074 | 991074 | 2021-02-02 | Fall River | South Dakota | 46047 | 505 | 14 |
987828 | 987828 | 2021-02-01 | Fall River | South Dakota | 46047 | 505 | 14 |
984581 | 984581 | 2021-01-31 | Fall River | South Dakota | 46047 | 505 | 14 |
981334 | 981334 | 2021-01-30 | Fall River | South Dakota | 46047 | 505 | 14 |
978088 | 978088 | 2021-01-29 | Fall River | South Dakota | 46047 | 504 | 14 |
974843 | 974843 | 2021-01-28 | Fall River | South Dakota | 46047 | 503 | 14 |
971598 | 971598 | 2021-01-27 | Fall River | South Dakota | 46047 | 502 | 14 |
968353 | 968353 | 2021-01-26 | Fall River | South Dakota | 46047 | 499 | 14 |
965109 | 965109 | 2021-01-25 | Fall River | South Dakota | 46047 | 498 | 14 |
961864 | 961864 | 2021-01-24 | Fall River | South Dakota | 46047 | 498 | 14 |
958619 | 958619 | 2021-01-23 | Fall River | South Dakota | 46047 | 495 | 14 |
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);