ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Bon Homme" 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 |
---|---|---|---|---|---|---|---|
1195573 | 1195573 | 2021-04-06 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1192325 | 1192325 | 2021-04-05 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1189076 | 1189076 | 2021-04-04 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1185829 | 1185829 | 2021-04-03 | Bon Homme | South Dakota | 46009 | 1515 | 26 |
1182582 | 1182582 | 2021-04-02 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1179335 | 1179335 | 2021-04-01 | Bon Homme | South Dakota | 46009 | 1513 | 26 |
1176088 | 1176088 | 2021-03-31 | Bon Homme | South Dakota | 46009 | 1513 | 26 |
1172841 | 1172841 | 2021-03-30 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1169594 | 1169594 | 2021-03-29 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1166346 | 1166346 | 2021-03-28 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1163098 | 1163098 | 2021-03-27 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1159849 | 1159849 | 2021-03-26 | Bon Homme | South Dakota | 46009 | 1512 | 26 |
1156602 | 1156602 | 2021-03-25 | Bon Homme | South Dakota | 46009 | 1514 | 26 |
1153355 | 1153355 | 2021-03-24 | Bon Homme | South Dakota | 46009 | 1513 | 26 |
1150108 | 1150108 | 2021-03-23 | Bon Homme | South Dakota | 46009 | 1513 | 26 |
1146861 | 1146861 | 2021-03-22 | Bon Homme | South Dakota | 46009 | 1512 | 26 |
1143614 | 1143614 | 2021-03-21 | Bon Homme | South Dakota | 46009 | 1512 | 26 |
1140367 | 1140367 | 2021-03-20 | Bon Homme | South Dakota | 46009 | 1511 | 26 |
1137121 | 1137121 | 2021-03-19 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1133875 | 1133875 | 2021-03-18 | Bon Homme | South Dakota | 46009 | 1511 | 26 |
1130627 | 1130627 | 2021-03-17 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1127380 | 1127380 | 2021-03-16 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1124134 | 1124134 | 2021-03-15 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1120888 | 1120888 | 2021-03-14 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1117641 | 1117641 | 2021-03-13 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1114394 | 1114394 | 2021-03-12 | Bon Homme | South Dakota | 46009 | 1510 | 26 |
1111148 | 1111148 | 2021-03-11 | Bon Homme | South Dakota | 46009 | 1510 | 25 |
1107902 | 1107902 | 2021-03-10 | Bon Homme | South Dakota | 46009 | 1510 | 25 |
1104656 | 1104656 | 2021-03-09 | Bon Homme | South Dakota | 46009 | 1509 | 25 |
1101410 | 1101410 | 2021-03-08 | Bon Homme | South Dakota | 46009 | 1509 | 25 |
1098164 | 1098164 | 2021-03-07 | Bon Homme | South Dakota | 46009 | 1508 | 25 |
1094916 | 1094916 | 2021-03-06 | Bon Homme | South Dakota | 46009 | 1507 | 25 |
1091670 | 1091670 | 2021-03-05 | Bon Homme | South Dakota | 46009 | 1506 | 25 |
1088424 | 1088424 | 2021-03-04 | Bon Homme | South Dakota | 46009 | 1506 | 25 |
1085179 | 1085179 | 2021-03-03 | Bon Homme | South Dakota | 46009 | 1505 | 25 |
1081933 | 1081933 | 2021-03-02 | Bon Homme | South Dakota | 46009 | 1505 | 25 |
1078687 | 1078687 | 2021-03-01 | Bon Homme | South Dakota | 46009 | 1504 | 25 |
1075442 | 1075442 | 2021-02-28 | Bon Homme | South Dakota | 46009 | 1504 | 25 |
1072196 | 1072196 | 2021-02-27 | Bon Homme | South Dakota | 46009 | 1504 | 25 |
1068950 | 1068950 | 2021-02-26 | Bon Homme | South Dakota | 46009 | 1504 | 25 |
1065705 | 1065705 | 2021-02-25 | Bon Homme | South Dakota | 46009 | 1504 | 25 |
1062460 | 1062460 | 2021-02-24 | Bon Homme | South Dakota | 46009 | 1503 | 25 |
1059215 | 1059215 | 2021-02-23 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1055969 | 1055969 | 2021-02-22 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1052723 | 1052723 | 2021-02-21 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1049476 | 1049476 | 2021-02-20 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1046229 | 1046229 | 2021-02-19 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1042984 | 1042984 | 2021-02-18 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1039739 | 1039739 | 2021-02-17 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1036494 | 1036494 | 2021-02-16 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1033249 | 1033249 | 2021-02-15 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1030003 | 1030003 | 2021-02-14 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1026756 | 1026756 | 2021-02-13 | Bon Homme | South Dakota | 46009 | 1502 | 25 |
1023511 | 1023511 | 2021-02-12 | Bon Homme | South Dakota | 46009 | 1502 | 24 |
1020266 | 1020266 | 2021-02-11 | Bon Homme | South Dakota | 46009 | 1502 | 24 |
1017021 | 1017021 | 2021-02-10 | Bon Homme | South Dakota | 46009 | 1500 | 24 |
1013776 | 1013776 | 2021-02-09 | Bon Homme | South Dakota | 46009 | 1500 | 24 |
1010531 | 1010531 | 2021-02-08 | Bon Homme | South Dakota | 46009 | 1499 | 24 |
1007285 | 1007285 | 2021-02-07 | Bon Homme | South Dakota | 46009 | 1499 | 24 |
1004039 | 1004039 | 2021-02-06 | Bon Homme | South Dakota | 46009 | 1499 | 24 |
1000793 | 1000793 | 2021-02-05 | Bon Homme | South Dakota | 46009 | 1499 | 24 |
997547 | 997547 | 2021-02-04 | Bon Homme | South Dakota | 46009 | 1500 | 25 |
994301 | 994301 | 2021-02-03 | Bon Homme | South Dakota | 46009 | 1500 | 25 |
991055 | 991055 | 2021-02-02 | Bon Homme | South Dakota | 46009 | 1500 | 25 |
987809 | 987809 | 2021-02-01 | Bon Homme | South Dakota | 46009 | 1500 | 25 |
984562 | 984562 | 2021-01-31 | Bon Homme | South Dakota | 46009 | 1500 | 25 |
981315 | 981315 | 2021-01-30 | Bon Homme | South Dakota | 46009 | 1499 | 25 |
978069 | 978069 | 2021-01-29 | Bon Homme | South Dakota | 46009 | 1500 | 25 |
974824 | 974824 | 2021-01-28 | Bon Homme | South Dakota | 46009 | 1501 | 25 |
971579 | 971579 | 2021-01-27 | Bon Homme | South Dakota | 46009 | 1499 | 23 |
968334 | 968334 | 2021-01-26 | Bon Homme | South Dakota | 46009 | 1480 | 23 |
965090 | 965090 | 2021-01-25 | Bon Homme | South Dakota | 46009 | 1482 | 23 |
961845 | 961845 | 2021-01-24 | Bon Homme | South Dakota | 46009 | 1502 | 23 |
958600 | 958600 | 2021-01-23 | Bon Homme | South Dakota | 46009 | 1502 | 23 |
955354 | 955354 | 2021-01-22 | Bon Homme | South Dakota | 46009 | 1504 | 23 |
952109 | 952109 | 2021-01-21 | Bon Homme | South Dakota | 46009 | 1504 | 23 |
948864 | 948864 | 2021-01-20 | Bon Homme | South Dakota | 46009 | 1502 | 23 |
945618 | 945618 | 2021-01-19 | Bon Homme | South Dakota | 46009 | 1502 | 23 |
942371 | 942371 | 2021-01-18 | Bon Homme | South Dakota | 46009 | 1501 | 23 |
939126 | 939126 | 2021-01-17 | Bon Homme | South Dakota | 46009 | 1502 | 23 |
935881 | 935881 | 2021-01-16 | Bon Homme | South Dakota | 46009 | 1502 | 23 |
932636 | 932636 | 2021-01-15 | Bon Homme | South Dakota | 46009 | 1500 | 23 |
929391 | 929391 | 2021-01-14 | Bon Homme | South Dakota | 46009 | 1499 | 23 |
926146 | 926146 | 2021-01-13 | Bon Homme | South Dakota | 46009 | 1499 | 23 |
922900 | 922900 | 2021-01-12 | Bon Homme | South Dakota | 46009 | 1500 | 23 |
919655 | 919655 | 2021-01-11 | Bon Homme | South Dakota | 46009 | 1499 | 23 |
916410 | 916410 | 2021-01-10 | Bon Homme | South Dakota | 46009 | 1496 | 23 |
913165 | 913165 | 2021-01-09 | Bon Homme | South Dakota | 46009 | 1493 | 23 |
909920 | 909920 | 2021-01-08 | Bon Homme | South Dakota | 46009 | 1489 | 23 |
906675 | 906675 | 2021-01-07 | Bon Homme | South Dakota | 46009 | 1488 | 23 |
903429 | 903429 | 2021-01-06 | Bon Homme | South Dakota | 46009 | 1485 | 23 |
900184 | 900184 | 2021-01-05 | Bon Homme | South Dakota | 46009 | 1482 | 23 |
896939 | 896939 | 2021-01-04 | Bon Homme | South Dakota | 46009 | 1479 | 23 |
893693 | 893693 | 2021-01-03 | Bon Homme | South Dakota | 46009 | 1477 | 23 |
890447 | 890447 | 2021-01-02 | Bon Homme | South Dakota | 46009 | 1476 | 23 |
887200 | 887200 | 2021-01-01 | Bon Homme | South Dakota | 46009 | 1477 | 23 |
883955 | 883955 | 2020-12-31 | Bon Homme | South Dakota | 46009 | 1477 | 23 |
880710 | 880710 | 2020-12-30 | Bon Homme | South Dakota | 46009 | 1477 | 23 |
877465 | 877465 | 2020-12-29 | Bon Homme | South Dakota | 46009 | 1472 | 23 |
874220 | 874220 | 2020-12-28 | Bon Homme | South Dakota | 46009 | 1471 | 23 |
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);