ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 46009 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 |
---|---|---|---|---|---|---|---|
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 |
870975 | 870975 | 2020-12-27 | Bon Homme | South Dakota | 46009 | 1467 | 23 |
867730 | 867730 | 2020-12-26 | Bon Homme | South Dakota | 46009 | 1463 | 23 |
864485 | 864485 | 2020-12-25 | Bon Homme | South Dakota | 46009 | 1462 | 23 |
861240 | 861240 | 2020-12-24 | Bon Homme | South Dakota | 46009 | 1462 | 23 |
857995 | 857995 | 2020-12-23 | Bon Homme | South Dakota | 46009 | 1456 | 23 |
854750 | 854750 | 2020-12-22 | Bon Homme | South Dakota | 46009 | 1449 | 22 |
851505 | 851505 | 2020-12-21 | Bon Homme | South Dakota | 46009 | 1446 | 22 |
848260 | 848260 | 2020-12-20 | Bon Homme | South Dakota | 46009 | 1445 | 22 |
845015 | 845015 | 2020-12-19 | Bon Homme | South Dakota | 46009 | 1442 | 22 |
841769 | 841769 | 2020-12-18 | Bon Homme | South Dakota | 46009 | 1439 | 22 |
838524 | 838524 | 2020-12-17 | Bon Homme | South Dakota | 46009 | 1436 | 21 |
835278 | 835278 | 2020-12-16 | Bon Homme | South Dakota | 46009 | 1432 | 21 |
832032 | 832032 | 2020-12-15 | Bon Homme | South Dakota | 46009 | 1427 | 21 |
828785 | 828785 | 2020-12-14 | Bon Homme | South Dakota | 46009 | 1425 | 21 |
825539 | 825539 | 2020-12-13 | Bon Homme | South Dakota | 46009 | 1424 | 21 |
822292 | 822292 | 2020-12-12 | Bon Homme | South Dakota | 46009 | 1420 | 21 |
819046 | 819046 | 2020-12-11 | Bon Homme | South Dakota | 46009 | 1417 | 21 |
815800 | 815800 | 2020-12-10 | Bon Homme | South Dakota | 46009 | 1414 | 21 |
812554 | 812554 | 2020-12-09 | Bon Homme | South Dakota | 46009 | 1412 | 21 |
809310 | 809310 | 2020-12-08 | Bon Homme | South Dakota | 46009 | 1408 | 20 |
806065 | 806065 | 2020-12-07 | Bon Homme | South Dakota | 46009 | 1404 | 20 |
802820 | 802820 | 2020-12-06 | Bon Homme | South Dakota | 46009 | 1401 | 20 |
799575 | 799575 | 2020-12-05 | Bon Homme | South Dakota | 46009 | 1398 | 20 |
796330 | 796330 | 2020-12-04 | Bon Homme | South Dakota | 46009 | 1391 | 20 |
793085 | 793085 | 2020-12-03 | Bon Homme | South Dakota | 46009 | 1377 | 20 |
789840 | 789840 | 2020-12-02 | Bon Homme | South Dakota | 46009 | 1372 | 19 |
786595 | 786595 | 2020-12-01 | Bon Homme | South Dakota | 46009 | 1366 | 14 |
783351 | 783351 | 2020-11-30 | Bon Homme | South Dakota | 46009 | 1363 | 14 |
780106 | 780106 | 2020-11-29 | Bon Homme | South Dakota | 46009 | 1361 | 14 |
776860 | 776860 | 2020-11-28 | Bon Homme | South Dakota | 46009 | 1359 | 14 |
773615 | 773615 | 2020-11-27 | Bon Homme | South Dakota | 46009 | 1349 | 14 |
770370 | 770370 | 2020-11-26 | Bon Homme | South Dakota | 46009 | 1335 | 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);