ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where county = "Kingsbury", deaths = 14 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1260560 | 1260560 | 2021-04-26 | Kingsbury | South Dakota | 46077 | 809 | 14 |
1257313 | 1257313 | 2021-04-25 | Kingsbury | South Dakota | 46077 | 808 | 14 |
1254066 | 1254066 | 2021-04-24 | Kingsbury | South Dakota | 46077 | 808 | 14 |
1250819 | 1250819 | 2021-04-23 | Kingsbury | South Dakota | 46077 | 808 | 14 |
1247572 | 1247572 | 2021-04-22 | Kingsbury | South Dakota | 46077 | 807 | 14 |
1244325 | 1244325 | 2021-04-21 | Kingsbury | South Dakota | 46077 | 806 | 14 |
1241078 | 1241078 | 2021-04-20 | Kingsbury | South Dakota | 46077 | 806 | 14 |
1237831 | 1237831 | 2021-04-19 | Kingsbury | South Dakota | 46077 | 804 | 14 |
1234584 | 1234584 | 2021-04-18 | Kingsbury | South Dakota | 46077 | 804 | 14 |
1231336 | 1231336 | 2021-04-17 | Kingsbury | South Dakota | 46077 | 804 | 14 |
1228088 | 1228088 | 2021-04-16 | Kingsbury | South Dakota | 46077 | 801 | 14 |
1224840 | 1224840 | 2021-04-15 | Kingsbury | South Dakota | 46077 | 796 | 14 |
1221593 | 1221593 | 2021-04-14 | Kingsbury | South Dakota | 46077 | 794 | 14 |
1218345 | 1218345 | 2021-04-13 | Kingsbury | South Dakota | 46077 | 791 | 14 |
1215097 | 1215097 | 2021-04-12 | Kingsbury | South Dakota | 46077 | 787 | 14 |
1211850 | 1211850 | 2021-04-11 | Kingsbury | South Dakota | 46077 | 782 | 14 |
1208601 | 1208601 | 2021-04-10 | Kingsbury | South Dakota | 46077 | 782 | 14 |
1205353 | 1205353 | 2021-04-09 | Kingsbury | South Dakota | 46077 | 776 | 14 |
1202105 | 1202105 | 2021-04-08 | Kingsbury | South Dakota | 46077 | 767 | 14 |
1198856 | 1198856 | 2021-04-07 | Kingsbury | South Dakota | 46077 | 763 | 14 |
1195607 | 1195607 | 2021-04-06 | Kingsbury | South Dakota | 46077 | 756 | 14 |
1192359 | 1192359 | 2021-04-05 | Kingsbury | South Dakota | 46077 | 753 | 14 |
1189110 | 1189110 | 2021-04-04 | Kingsbury | South Dakota | 46077 | 748 | 14 |
1185863 | 1185863 | 2021-04-03 | Kingsbury | South Dakota | 46077 | 748 | 14 |
1182616 | 1182616 | 2021-04-02 | Kingsbury | South Dakota | 46077 | 740 | 14 |
1179369 | 1179369 | 2021-04-01 | Kingsbury | South Dakota | 46077 | 738 | 14 |
1176122 | 1176122 | 2021-03-31 | Kingsbury | South Dakota | 46077 | 734 | 14 |
1172875 | 1172875 | 2021-03-30 | Kingsbury | South Dakota | 46077 | 728 | 14 |
1169628 | 1169628 | 2021-03-29 | Kingsbury | South Dakota | 46077 | 725 | 14 |
1166380 | 1166380 | 2021-03-28 | Kingsbury | South Dakota | 46077 | 724 | 14 |
1163132 | 1163132 | 2021-03-27 | Kingsbury | South Dakota | 46077 | 718 | 14 |
1159883 | 1159883 | 2021-03-26 | Kingsbury | South Dakota | 46077 | 710 | 14 |
1156636 | 1156636 | 2021-03-25 | Kingsbury | South Dakota | 46077 | 695 | 14 |
1153389 | 1153389 | 2021-03-24 | Kingsbury | South Dakota | 46077 | 681 | 14 |
1150142 | 1150142 | 2021-03-23 | Kingsbury | South Dakota | 46077 | 675 | 14 |
1146895 | 1146895 | 2021-03-22 | Kingsbury | South Dakota | 46077 | 673 | 14 |
1143648 | 1143648 | 2021-03-21 | Kingsbury | South Dakota | 46077 | 671 | 14 |
1140401 | 1140401 | 2021-03-20 | Kingsbury | South Dakota | 46077 | 668 | 14 |
1137155 | 1137155 | 2021-03-19 | Kingsbury | South Dakota | 46077 | 663 | 14 |
1133909 | 1133909 | 2021-03-18 | Kingsbury | South Dakota | 46077 | 660 | 14 |
1130661 | 1130661 | 2021-03-17 | Kingsbury | South Dakota | 46077 | 657 | 14 |
1127414 | 1127414 | 2021-03-16 | Kingsbury | South Dakota | 46077 | 656 | 14 |
1124168 | 1124168 | 2021-03-15 | Kingsbury | South Dakota | 46077 | 653 | 14 |
1120922 | 1120922 | 2021-03-14 | Kingsbury | South Dakota | 46077 | 653 | 14 |
1117675 | 1117675 | 2021-03-13 | Kingsbury | South Dakota | 46077 | 652 | 14 |
1114428 | 1114428 | 2021-03-12 | Kingsbury | South Dakota | 46077 | 652 | 14 |
1111182 | 1111182 | 2021-03-11 | Kingsbury | South Dakota | 46077 | 651 | 14 |
1107936 | 1107936 | 2021-03-10 | Kingsbury | South Dakota | 46077 | 648 | 14 |
1104690 | 1104690 | 2021-03-09 | Kingsbury | South Dakota | 46077 | 648 | 14 |
1101444 | 1101444 | 2021-03-08 | Kingsbury | South Dakota | 46077 | 647 | 14 |
1098198 | 1098198 | 2021-03-07 | Kingsbury | South Dakota | 46077 | 647 | 14 |
1094950 | 1094950 | 2021-03-06 | Kingsbury | South Dakota | 46077 | 643 | 14 |
1091704 | 1091704 | 2021-03-05 | Kingsbury | South Dakota | 46077 | 643 | 14 |
1088458 | 1088458 | 2021-03-04 | Kingsbury | South Dakota | 46077 | 642 | 14 |
1085213 | 1085213 | 2021-03-03 | Kingsbury | South Dakota | 46077 | 639 | 14 |
1081967 | 1081967 | 2021-03-02 | Kingsbury | South Dakota | 46077 | 639 | 14 |
1078721 | 1078721 | 2021-03-01 | Kingsbury | South Dakota | 46077 | 639 | 14 |
1075476 | 1075476 | 2021-02-28 | Kingsbury | South Dakota | 46077 | 639 | 14 |
1072230 | 1072230 | 2021-02-27 | Kingsbury | South Dakota | 46077 | 638 | 14 |
1068984 | 1068984 | 2021-02-26 | Kingsbury | South Dakota | 46077 | 638 | 14 |
1065739 | 1065739 | 2021-02-25 | Kingsbury | South Dakota | 46077 | 637 | 14 |
1062494 | 1062494 | 2021-02-24 | Kingsbury | South Dakota | 46077 | 636 | 14 |
1059249 | 1059249 | 2021-02-23 | Kingsbury | South Dakota | 46077 | 635 | 14 |
1056003 | 1056003 | 2021-02-22 | Kingsbury | South Dakota | 46077 | 631 | 14 |
1052757 | 1052757 | 2021-02-21 | Kingsbury | South Dakota | 46077 | 631 | 14 |
1049510 | 1049510 | 2021-02-20 | Kingsbury | South Dakota | 46077 | 630 | 14 |
1046263 | 1046263 | 2021-02-19 | Kingsbury | South Dakota | 46077 | 628 | 14 |
1043018 | 1043018 | 2021-02-18 | Kingsbury | South Dakota | 46077 | 626 | 14 |
1039773 | 1039773 | 2021-02-17 | Kingsbury | South Dakota | 46077 | 624 | 14 |
1036528 | 1036528 | 2021-02-16 | Kingsbury | South Dakota | 46077 | 624 | 14 |
1033283 | 1033283 | 2021-02-15 | Kingsbury | South Dakota | 46077 | 623 | 14 |
1030037 | 1030037 | 2021-02-14 | Kingsbury | South Dakota | 46077 | 621 | 14 |
1026790 | 1026790 | 2021-02-13 | Kingsbury | South Dakota | 46077 | 619 | 14 |
1023545 | 1023545 | 2021-02-12 | Kingsbury | South Dakota | 46077 | 617 | 14 |
1020300 | 1020300 | 2021-02-11 | Kingsbury | South Dakota | 46077 | 615 | 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);