ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 46003 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 |
---|---|---|---|---|---|---|---|
1487750 | 1487750 | 2021-07-05 | Aurora | South Dakota | 46003 | 475 | 15 |
1484503 | 1484503 | 2021-07-04 | Aurora | South Dakota | 46003 | 475 | 15 |
1481257 | 1481257 | 2021-07-03 | Aurora | South Dakota | 46003 | 475 | 15 |
1478010 | 1478010 | 2021-07-02 | Aurora | South Dakota | 46003 | 475 | 15 |
1474764 | 1474764 | 2021-07-01 | Aurora | South Dakota | 46003 | 475 | 15 |
1471518 | 1471518 | 2021-06-30 | Aurora | South Dakota | 46003 | 475 | 15 |
1468273 | 1468273 | 2021-06-29 | Aurora | South Dakota | 46003 | 475 | 15 |
1465028 | 1465028 | 2021-06-28 | Aurora | South Dakota | 46003 | 475 | 15 |
1461783 | 1461783 | 2021-06-27 | Aurora | South Dakota | 46003 | 475 | 15 |
1458538 | 1458538 | 2021-06-26 | Aurora | South Dakota | 46003 | 475 | 15 |
1455293 | 1455293 | 2021-06-25 | Aurora | South Dakota | 46003 | 475 | 15 |
1452048 | 1452048 | 2021-06-24 | Aurora | South Dakota | 46003 | 475 | 15 |
1448802 | 1448802 | 2021-06-23 | Aurora | South Dakota | 46003 | 475 | 15 |
1445557 | 1445557 | 2021-06-22 | Aurora | South Dakota | 46003 | 475 | 15 |
1442312 | 1442312 | 2021-06-21 | Aurora | South Dakota | 46003 | 475 | 15 |
1439067 | 1439067 | 2021-06-20 | Aurora | South Dakota | 46003 | 475 | 15 |
1435820 | 1435820 | 2021-06-19 | Aurora | South Dakota | 46003 | 475 | 15 |
1432573 | 1432573 | 2021-06-18 | Aurora | South Dakota | 46003 | 475 | 15 |
1429327 | 1429327 | 2021-06-17 | Aurora | South Dakota | 46003 | 475 | 15 |
1426082 | 1426082 | 2021-06-16 | Aurora | South Dakota | 46003 | 475 | 15 |
1422835 | 1422835 | 2021-06-15 | Aurora | South Dakota | 46003 | 475 | 15 |
1419589 | 1419589 | 2021-06-14 | Aurora | South Dakota | 46003 | 475 | 15 |
1416344 | 1416344 | 2021-06-13 | Aurora | South Dakota | 46003 | 475 | 15 |
1413098 | 1413098 | 2021-06-12 | Aurora | South Dakota | 46003 | 475 | 15 |
1409853 | 1409853 | 2021-06-11 | Aurora | South Dakota | 46003 | 475 | 15 |
1406608 | 1406608 | 2021-06-10 | Aurora | South Dakota | 46003 | 475 | 15 |
1403362 | 1403362 | 2021-06-09 | Aurora | South Dakota | 46003 | 475 | 15 |
1400117 | 1400117 | 2021-06-08 | Aurora | South Dakota | 46003 | 475 | 15 |
1396872 | 1396872 | 2021-06-07 | Aurora | South Dakota | 46003 | 475 | 15 |
1393625 | 1393625 | 2021-06-06 | Aurora | South Dakota | 46003 | 475 | 15 |
1390380 | 1390380 | 2021-06-05 | Aurora | South Dakota | 46003 | 475 | 15 |
1387135 | 1387135 | 2021-06-04 | Aurora | South Dakota | 46003 | 475 | 15 |
1383890 | 1383890 | 2021-06-03 | Aurora | South Dakota | 46003 | 475 | 15 |
1380644 | 1380644 | 2021-06-02 | Aurora | South Dakota | 46003 | 475 | 15 |
1377399 | 1377399 | 2021-06-01 | Aurora | South Dakota | 46003 | 475 | 15 |
1374153 | 1374153 | 2021-05-31 | Aurora | South Dakota | 46003 | 475 | 15 |
1370908 | 1370908 | 2021-05-30 | Aurora | South Dakota | 46003 | 475 | 15 |
1367662 | 1367662 | 2021-05-29 | Aurora | South Dakota | 46003 | 475 | 15 |
1364416 | 1364416 | 2021-05-28 | Aurora | South Dakota | 46003 | 475 | 15 |
1361170 | 1361170 | 2021-05-27 | Aurora | South Dakota | 46003 | 475 | 15 |
1357924 | 1357924 | 2021-05-26 | Aurora | South Dakota | 46003 | 475 | 15 |
1354678 | 1354678 | 2021-05-25 | Aurora | South Dakota | 46003 | 475 | 15 |
1351432 | 1351432 | 2021-05-24 | Aurora | South Dakota | 46003 | 475 | 15 |
1348186 | 1348186 | 2021-05-23 | Aurora | South Dakota | 46003 | 474 | 15 |
1344938 | 1344938 | 2021-05-22 | Aurora | South Dakota | 46003 | 474 | 15 |
1341690 | 1341690 | 2021-05-21 | Aurora | South Dakota | 46003 | 474 | 15 |
1338442 | 1338442 | 2021-05-20 | Aurora | South Dakota | 46003 | 474 | 15 |
1335195 | 1335195 | 2021-05-19 | Aurora | South Dakota | 46003 | 473 | 15 |
1331948 | 1331948 | 2021-05-18 | Aurora | South Dakota | 46003 | 473 | 15 |
1328701 | 1328701 | 2021-05-17 | Aurora | South Dakota | 46003 | 473 | 15 |
1325455 | 1325455 | 2021-05-16 | Aurora | South Dakota | 46003 | 473 | 15 |
1322209 | 1322209 | 2021-05-15 | Aurora | South Dakota | 46003 | 473 | 15 |
1318963 | 1318963 | 2021-05-14 | Aurora | South Dakota | 46003 | 473 | 15 |
1315715 | 1315715 | 2021-05-13 | Aurora | South Dakota | 46003 | 473 | 15 |
1312469 | 1312469 | 2021-05-12 | Aurora | South Dakota | 46003 | 474 | 15 |
1309222 | 1309222 | 2021-05-11 | Aurora | South Dakota | 46003 | 472 | 15 |
1305976 | 1305976 | 2021-05-10 | Aurora | South Dakota | 46003 | 471 | 15 |
1302730 | 1302730 | 2021-05-09 | Aurora | South Dakota | 46003 | 471 | 15 |
1299483 | 1299483 | 2021-05-08 | Aurora | South Dakota | 46003 | 471 | 15 |
1296236 | 1296236 | 2021-05-07 | Aurora | South Dakota | 46003 | 471 | 15 |
1292990 | 1292990 | 2021-05-06 | Aurora | South Dakota | 46003 | 471 | 15 |
1289744 | 1289744 | 2021-05-05 | Aurora | South Dakota | 46003 | 471 | 15 |
1286498 | 1286498 | 2021-05-04 | Aurora | South Dakota | 46003 | 471 | 15 |
1283252 | 1283252 | 2021-05-03 | Aurora | South Dakota | 46003 | 471 | 15 |
1280005 | 1280005 | 2021-05-02 | Aurora | South Dakota | 46003 | 471 | 15 |
1276758 | 1276758 | 2021-05-01 | Aurora | South Dakota | 46003 | 471 | 15 |
1273511 | 1273511 | 2021-04-30 | Aurora | South Dakota | 46003 | 471 | 15 |
1270264 | 1270264 | 2021-04-29 | Aurora | South Dakota | 46003 | 470 | 15 |
1267017 | 1267017 | 2021-04-28 | Aurora | South Dakota | 46003 | 469 | 15 |
1263770 | 1263770 | 2021-04-27 | Aurora | South Dakota | 46003 | 468 | 15 |
1260523 | 1260523 | 2021-04-26 | Aurora | South Dakota | 46003 | 468 | 15 |
1257276 | 1257276 | 2021-04-25 | Aurora | South Dakota | 46003 | 468 | 15 |
1254029 | 1254029 | 2021-04-24 | Aurora | South Dakota | 46003 | 468 | 15 |
1250782 | 1250782 | 2021-04-23 | Aurora | South Dakota | 46003 | 468 | 15 |
1247535 | 1247535 | 2021-04-22 | Aurora | South Dakota | 46003 | 468 | 15 |
1244288 | 1244288 | 2021-04-21 | Aurora | South Dakota | 46003 | 468 | 15 |
1241041 | 1241041 | 2021-04-20 | Aurora | South Dakota | 46003 | 468 | 15 |
1237794 | 1237794 | 2021-04-19 | Aurora | South Dakota | 46003 | 468 | 15 |
1234547 | 1234547 | 2021-04-18 | Aurora | South Dakota | 46003 | 466 | 15 |
1231299 | 1231299 | 2021-04-17 | Aurora | South Dakota | 46003 | 466 | 15 |
1228051 | 1228051 | 2021-04-16 | Aurora | South Dakota | 46003 | 466 | 15 |
1224803 | 1224803 | 2021-04-15 | Aurora | South Dakota | 46003 | 466 | 15 |
1221556 | 1221556 | 2021-04-14 | Aurora | South Dakota | 46003 | 463 | 15 |
1218308 | 1218308 | 2021-04-13 | Aurora | South Dakota | 46003 | 463 | 15 |
1215060 | 1215060 | 2021-04-12 | Aurora | South Dakota | 46003 | 461 | 15 |
1211813 | 1211813 | 2021-04-11 | Aurora | South Dakota | 46003 | 461 | 15 |
1208564 | 1208564 | 2021-04-10 | Aurora | South Dakota | 46003 | 461 | 15 |
1205316 | 1205316 | 2021-04-09 | Aurora | South Dakota | 46003 | 461 | 15 |
1202068 | 1202068 | 2021-04-08 | Aurora | South Dakota | 46003 | 461 | 15 |
1198819 | 1198819 | 2021-04-07 | Aurora | South Dakota | 46003 | 461 | 15 |
1195570 | 1195570 | 2021-04-06 | Aurora | South Dakota | 46003 | 461 | 15 |
1192322 | 1192322 | 2021-04-05 | Aurora | South Dakota | 46003 | 461 | 15 |
1189073 | 1189073 | 2021-04-04 | Aurora | South Dakota | 46003 | 460 | 15 |
1185826 | 1185826 | 2021-04-03 | Aurora | South Dakota | 46003 | 460 | 15 |
1182579 | 1182579 | 2021-04-02 | Aurora | South Dakota | 46003 | 459 | 15 |
1179332 | 1179332 | 2021-04-01 | Aurora | South Dakota | 46003 | 459 | 15 |
1176085 | 1176085 | 2021-03-31 | Aurora | South Dakota | 46003 | 459 | 15 |
1172838 | 1172838 | 2021-03-30 | Aurora | South Dakota | 46003 | 459 | 15 |
1169591 | 1169591 | 2021-03-29 | Aurora | South Dakota | 46003 | 459 | 15 |
1166343 | 1166343 | 2021-03-28 | Aurora | South Dakota | 46003 | 459 | 15 |
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);