ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 97 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 |
---|---|---|---|---|---|---|---|
1672913 | 1672913 | 2021-08-31 | Jones | South Dakota | 46075 | 97 | 0 |
1536484 | 1536484 | 2021-07-20 | Harding | South Dakota | 46063 | 97 | 1 |
1533236 | 1533236 | 2021-07-19 | Harding | South Dakota | 46063 | 97 | 1 |
1529989 | 1529989 | 2021-07-18 | Harding | South Dakota | 46063 | 97 | 1 |
1526742 | 1526742 | 2021-07-17 | Harding | South Dakota | 46063 | 97 | 1 |
1523495 | 1523495 | 2021-07-16 | Harding | South Dakota | 46063 | 97 | 1 |
1520247 | 1520247 | 2021-07-15 | Harding | South Dakota | 46063 | 97 | 1 |
1516999 | 1516999 | 2021-07-14 | Harding | South Dakota | 46063 | 97 | 1 |
1513752 | 1513752 | 2021-07-13 | Harding | South Dakota | 46063 | 97 | 1 |
1510506 | 1510506 | 2021-07-12 | Harding | South Dakota | 46063 | 97 | 1 |
1507259 | 1507259 | 2021-07-11 | Harding | South Dakota | 46063 | 97 | 1 |
1504013 | 1504013 | 2021-07-10 | Harding | South Dakota | 46063 | 97 | 1 |
1500767 | 1500767 | 2021-07-09 | Harding | South Dakota | 46063 | 97 | 1 |
1497521 | 1497521 | 2021-07-08 | Harding | South Dakota | 46063 | 97 | 1 |
1494274 | 1494274 | 2021-07-07 | Harding | South Dakota | 46063 | 97 | 1 |
1491027 | 1491027 | 2021-07-06 | Harding | South Dakota | 46063 | 97 | 1 |
1487780 | 1487780 | 2021-07-05 | Harding | South Dakota | 46063 | 97 | 1 |
1484533 | 1484533 | 2021-07-04 | Harding | South Dakota | 46063 | 97 | 1 |
1481287 | 1481287 | 2021-07-03 | Harding | South Dakota | 46063 | 97 | 1 |
1478040 | 1478040 | 2021-07-02 | Harding | South Dakota | 46063 | 97 | 1 |
1474794 | 1474794 | 2021-07-01 | Harding | South Dakota | 46063 | 97 | 1 |
1471548 | 1471548 | 2021-06-30 | Harding | South Dakota | 46063 | 97 | 1 |
1468303 | 1468303 | 2021-06-29 | Harding | South Dakota | 46063 | 97 | 1 |
1465058 | 1465058 | 2021-06-28 | Harding | South Dakota | 46063 | 97 | 1 |
1461813 | 1461813 | 2021-06-27 | Harding | South Dakota | 46063 | 97 | 1 |
1458568 | 1458568 | 2021-06-26 | Harding | South Dakota | 46063 | 97 | 1 |
1455323 | 1455323 | 2021-06-25 | Harding | South Dakota | 46063 | 97 | 1 |
1452078 | 1452078 | 2021-06-24 | Harding | South Dakota | 46063 | 97 | 1 |
1448832 | 1448832 | 2021-06-23 | Harding | South Dakota | 46063 | 97 | 1 |
1445587 | 1445587 | 2021-06-22 | Harding | South Dakota | 46063 | 97 | 1 |
1442342 | 1442342 | 2021-06-21 | Harding | South Dakota | 46063 | 97 | 1 |
1439097 | 1439097 | 2021-06-20 | Harding | South Dakota | 46063 | 97 | 1 |
1435850 | 1435850 | 2021-06-19 | Harding | South Dakota | 46063 | 97 | 1 |
1432603 | 1432603 | 2021-06-18 | Harding | South Dakota | 46063 | 97 | 1 |
1429357 | 1429357 | 2021-06-17 | Harding | South Dakota | 46063 | 97 | 1 |
1426112 | 1426112 | 2021-06-16 | Harding | South Dakota | 46063 | 97 | 1 |
1422865 | 1422865 | 2021-06-15 | Harding | South Dakota | 46063 | 97 | 1 |
1419619 | 1419619 | 2021-06-14 | Harding | South Dakota | 46063 | 97 | 1 |
1416374 | 1416374 | 2021-06-13 | Harding | South Dakota | 46063 | 97 | 1 |
1413128 | 1413128 | 2021-06-12 | Harding | South Dakota | 46063 | 97 | 1 |
1409883 | 1409883 | 2021-06-11 | Harding | South Dakota | 46063 | 97 | 1 |
1406638 | 1406638 | 2021-06-10 | Harding | South Dakota | 46063 | 97 | 1 |
1403392 | 1403392 | 2021-06-09 | Harding | South Dakota | 46063 | 97 | 1 |
1400147 | 1400147 | 2021-06-08 | Harding | South Dakota | 46063 | 97 | 1 |
1396902 | 1396902 | 2021-06-07 | Harding | South Dakota | 46063 | 97 | 1 |
1393655 | 1393655 | 2021-06-06 | Harding | South Dakota | 46063 | 97 | 1 |
1390410 | 1390410 | 2021-06-05 | Harding | South Dakota | 46063 | 97 | 1 |
1387165 | 1387165 | 2021-06-04 | Harding | South Dakota | 46063 | 97 | 1 |
1383920 | 1383920 | 2021-06-03 | Harding | South Dakota | 46063 | 97 | 1 |
1380674 | 1380674 | 2021-06-02 | Harding | South Dakota | 46063 | 97 | 1 |
1377429 | 1377429 | 2021-06-01 | Harding | South Dakota | 46063 | 97 | 1 |
1374183 | 1374183 | 2021-05-31 | Harding | South Dakota | 46063 | 97 | 1 |
1370938 | 1370938 | 2021-05-30 | Harding | South Dakota | 46063 | 97 | 1 |
1367692 | 1367692 | 2021-05-29 | Harding | South Dakota | 46063 | 97 | 1 |
1364446 | 1364446 | 2021-05-28 | Harding | South Dakota | 46063 | 97 | 1 |
1361200 | 1361200 | 2021-05-27 | Harding | South Dakota | 46063 | 97 | 1 |
1357954 | 1357954 | 2021-05-26 | Harding | South Dakota | 46063 | 97 | 1 |
1354708 | 1354708 | 2021-05-25 | Harding | South Dakota | 46063 | 97 | 1 |
1351462 | 1351462 | 2021-05-24 | Harding | South Dakota | 46063 | 97 | 1 |
1348216 | 1348216 | 2021-05-23 | Harding | South Dakota | 46063 | 97 | 1 |
1344968 | 1344968 | 2021-05-22 | Harding | South Dakota | 46063 | 97 | 1 |
1341720 | 1341720 | 2021-05-21 | Harding | South Dakota | 46063 | 97 | 1 |
1338472 | 1338472 | 2021-05-20 | Harding | South Dakota | 46063 | 97 | 1 |
1335225 | 1335225 | 2021-05-19 | Harding | South Dakota | 46063 | 97 | 1 |
1331978 | 1331978 | 2021-05-18 | Harding | South Dakota | 46063 | 97 | 1 |
1328731 | 1328731 | 2021-05-17 | Harding | South Dakota | 46063 | 97 | 1 |
1325485 | 1325485 | 2021-05-16 | Harding | South Dakota | 46063 | 97 | 1 |
1322239 | 1322239 | 2021-05-15 | Harding | South Dakota | 46063 | 97 | 1 |
1318993 | 1318993 | 2021-05-14 | Harding | South Dakota | 46063 | 97 | 1 |
1315745 | 1315745 | 2021-05-13 | Harding | South Dakota | 46063 | 97 | 1 |
1312499 | 1312499 | 2021-05-12 | Harding | South Dakota | 46063 | 97 | 1 |
1309252 | 1309252 | 2021-05-11 | Harding | South Dakota | 46063 | 97 | 1 |
1306006 | 1306006 | 2021-05-10 | Harding | South Dakota | 46063 | 97 | 1 |
1302760 | 1302760 | 2021-05-09 | Harding | South Dakota | 46063 | 97 | 1 |
1299513 | 1299513 | 2021-05-08 | Harding | South Dakota | 46063 | 97 | 1 |
1296266 | 1296266 | 2021-05-07 | Harding | South Dakota | 46063 | 97 | 1 |
1293020 | 1293020 | 2021-05-06 | Harding | South Dakota | 46063 | 97 | 1 |
1289774 | 1289774 | 2021-05-05 | Harding | South Dakota | 46063 | 97 | 1 |
754148 | 754148 | 2020-11-21 | Campbell | South Dakota | 46021 | 97 | 1 |
750902 | 750902 | 2020-11-20 | Campbell | South Dakota | 46021 | 97 | 1 |
724972 | 724972 | 2020-11-12 | Marshall | South Dakota | 46091 | 97 | 3 |
712009 | 712009 | 2020-11-08 | Perkins | South Dakota | 46105 | 97 | 0 |
663317 | 663317 | 2020-10-24 | Clark | South Dakota | 46025 | 97 | 0 |
614641 | 614641 | 2020-10-09 | Bennett | South Dakota | 46007 | 97 | 4 |
604931 | 604931 | 2020-10-06 | Deuel | South Dakota | 46039 | 97 | 0 |
601689 | 601689 | 2020-10-05 | Deuel | South Dakota | 46039 | 97 | 0 |
598446 | 598446 | 2020-10-04 | Deuel | South Dakota | 46039 | 97 | 0 |
579026 | 579026 | 2020-09-28 | McCook | South Dakota | 46087 | 97 | 1 |
572506 | 572506 | 2020-09-26 | Butte | South Dakota | 46019 | 97 | 3 |
572525 | 572525 | 2020-09-26 | Hamlin | South Dakota | 46057 | 97 | 0 |
556360 | 556360 | 2020-09-21 | Tripp | South Dakota | 46123 | 97 | 0 |
546641 | 546641 | 2020-09-18 | Spink | South Dakota | 46115 | 97 | 0 |
540171 | 540171 | 2020-09-16 | Todd | South Dakota | 46121 | 97 | 5 |
517520 | 517520 | 2020-09-09 | Turner | South Dakota | 46125 | 97 | 0 |
514285 | 514285 | 2020-09-08 | Turner | South Dakota | 46125 | 97 | 0 |
511052 | 511052 | 2020-09-07 | Turner | South Dakota | 46125 | 97 | 0 |
507819 | 507819 | 2020-09-06 | Turner | South Dakota | 46125 | 97 | 0 |
485179 | 485179 | 2020-08-30 | Roberts | South Dakota | 46109 | 97 | 1 |
436713 | 436713 | 2020-08-15 | Hughes | South Dakota | 46065 | 97 | 3 |
436727 | 436727 | 2020-08-15 | Meade | South Dakota | 46093 | 97 | 1 |
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);