ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 29229 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418741 | 1418741 | 2021-06-14 | Wright | Missouri | 29229 | 1659 | 34 |
1415496 | 1415496 | 2021-06-13 | Wright | Missouri | 29229 | 1655 | 34 |
1412250 | 1412250 | 2021-06-12 | Wright | Missouri | 29229 | 1655 | 34 |
1409005 | 1409005 | 2021-06-11 | Wright | Missouri | 29229 | 1650 | 34 |
1405760 | 1405760 | 2021-06-10 | Wright | Missouri | 29229 | 1645 | 34 |
1402514 | 1402514 | 2021-06-09 | Wright | Missouri | 29229 | 1639 | 34 |
1399269 | 1399269 | 2021-06-08 | Wright | Missouri | 29229 | 1635 | 34 |
1396023 | 1396023 | 2021-06-07 | Wright | Missouri | 29229 | 1635 | 34 |
1392777 | 1392777 | 2021-06-06 | Wright | Missouri | 29229 | 1633 | 34 |
1389532 | 1389532 | 2021-06-05 | Wright | Missouri | 29229 | 1633 | 34 |
1386287 | 1386287 | 2021-06-04 | Wright | Missouri | 29229 | 1629 | 34 |
1383042 | 1383042 | 2021-06-03 | Wright | Missouri | 29229 | 1625 | 34 |
1379796 | 1379796 | 2021-06-02 | Wright | Missouri | 29229 | 1625 | 33 |
1376551 | 1376551 | 2021-06-01 | Wright | Missouri | 29229 | 1623 | 33 |
1373305 | 1373305 | 2021-05-31 | Wright | Missouri | 29229 | 1623 | 33 |
1370060 | 1370060 | 2021-05-30 | Wright | Missouri | 29229 | 1621 | 33 |
1366814 | 1366814 | 2021-05-29 | Wright | Missouri | 29229 | 1620 | 33 |
1363568 | 1363568 | 2021-05-28 | Wright | Missouri | 29229 | 1619 | 33 |
1360321 | 1360321 | 2021-05-27 | Wright | Missouri | 29229 | 1616 | 33 |
1357075 | 1357075 | 2021-05-26 | Wright | Missouri | 29229 | 1614 | 33 |
1353829 | 1353829 | 2021-05-25 | Wright | Missouri | 29229 | 1605 | 33 |
1350583 | 1350583 | 2021-05-24 | Wright | Missouri | 29229 | 1605 | 32 |
1347337 | 1347337 | 2021-05-23 | Wright | Missouri | 29229 | 1603 | 32 |
1344089 | 1344089 | 2021-05-22 | Wright | Missouri | 29229 | 1601 | 32 |
1340841 | 1340841 | 2021-05-21 | Wright | Missouri | 29229 | 1599 | 32 |
1337593 | 1337593 | 2021-05-20 | Wright | Missouri | 29229 | 1597 | 32 |
1334346 | 1334346 | 2021-05-19 | Wright | Missouri | 29229 | 1595 | 32 |
1331099 | 1331099 | 2021-05-18 | Wright | Missouri | 29229 | 1593 | 32 |
1327852 | 1327852 | 2021-05-17 | Wright | Missouri | 29229 | 1591 | 32 |
1324606 | 1324606 | 2021-05-16 | Wright | Missouri | 29229 | 1590 | 32 |
1321360 | 1321360 | 2021-05-15 | Wright | Missouri | 29229 | 1589 | 32 |
1318114 | 1318114 | 2021-05-14 | Wright | Missouri | 29229 | 1589 | 32 |
1314866 | 1314866 | 2021-05-13 | Wright | Missouri | 29229 | 1584 | 32 |
1311620 | 1311620 | 2021-05-12 | Wright | Missouri | 29229 | 1584 | 32 |
1308373 | 1308373 | 2021-05-11 | Wright | Missouri | 29229 | 1584 | 32 |
1305127 | 1305127 | 2021-05-10 | Wright | Missouri | 29229 | 1581 | 32 |
1301881 | 1301881 | 2021-05-09 | Wright | Missouri | 29229 | 1581 | 32 |
1298633 | 1298633 | 2021-05-08 | Wright | Missouri | 29229 | 1581 | 32 |
1295387 | 1295387 | 2021-05-07 | Wright | Missouri | 29229 | 1580 | 32 |
1292141 | 1292141 | 2021-05-06 | Wright | Missouri | 29229 | 1580 | 32 |
1288895 | 1288895 | 2021-05-05 | Wright | Missouri | 29229 | 1578 | 32 |
1285649 | 1285649 | 2021-05-04 | Wright | Missouri | 29229 | 1578 | 32 |
1282403 | 1282403 | 2021-05-03 | Wright | Missouri | 29229 | 1578 | 32 |
1279156 | 1279156 | 2021-05-02 | Wright | Missouri | 29229 | 1577 | 32 |
1275909 | 1275909 | 2021-05-01 | Wright | Missouri | 29229 | 1575 | 31 |
1272662 | 1272662 | 2021-04-30 | Wright | Missouri | 29229 | 1573 | 31 |
1269415 | 1269415 | 2021-04-29 | Wright | Missouri | 29229 | 1572 | 31 |
1266168 | 1266168 | 2021-04-28 | Wright | Missouri | 29229 | 1571 | 31 |
1262921 | 1262921 | 2021-04-27 | Wright | Missouri | 29229 | 1571 | 31 |
1259674 | 1259674 | 2021-04-26 | Wright | Missouri | 29229 | 1570 | 31 |
1256427 | 1256427 | 2021-04-25 | Wright | Missouri | 29229 | 1566 | 31 |
1253180 | 1253180 | 2021-04-24 | Wright | Missouri | 29229 | 1557 | 30 |
1249933 | 1249933 | 2021-04-23 | Wright | Missouri | 29229 | 1551 | 30 |
1246686 | 1246686 | 2021-04-22 | Wright | Missouri | 29229 | 1551 | 30 |
1243439 | 1243439 | 2021-04-21 | Wright | Missouri | 29229 | 1551 | 30 |
1240192 | 1240192 | 2021-04-20 | Wright | Missouri | 29229 | 1551 | 30 |
1236945 | 1236945 | 2021-04-19 | Wright | Missouri | 29229 | 1548 | 29 |
1233698 | 1233698 | 2021-04-18 | Wright | Missouri | 29229 | 1547 | 29 |
1230450 | 1230450 | 2021-04-17 | Wright | Missouri | 29229 | 1540 | 29 |
1227202 | 1227202 | 2021-04-16 | Wright | Missouri | 29229 | 1564 | 29 |
1223954 | 1223954 | 2021-04-15 | Wright | Missouri | 29229 | 1562 | 29 |
1220707 | 1220707 | 2021-04-14 | Wright | Missouri | 29229 | 1561 | 29 |
1217459 | 1217459 | 2021-04-13 | Wright | Missouri | 29229 | 1559 | 30 |
1214212 | 1214212 | 2021-04-12 | Wright | Missouri | 29229 | 1559 | 29 |
1210964 | 1210964 | 2021-04-11 | Wright | Missouri | 29229 | 1559 | 29 |
1207715 | 1207715 | 2021-04-10 | Wright | Missouri | 29229 | 1559 | 29 |
1204467 | 1204467 | 2021-04-09 | Wright | Missouri | 29229 | 1559 | 29 |
1201219 | 1201219 | 2021-04-08 | Wright | Missouri | 29229 | 1559 | 29 |
1197970 | 1197970 | 2021-04-07 | Wright | Missouri | 29229 | 1557 | 29 |
1194721 | 1194721 | 2021-04-06 | Wright | Missouri | 29229 | 1556 | 29 |
1191472 | 1191472 | 2021-04-05 | Wright | Missouri | 29229 | 1556 | 29 |
1188224 | 1188224 | 2021-04-04 | Wright | Missouri | 29229 | 1556 | 29 |
1184977 | 1184977 | 2021-04-03 | Wright | Missouri | 29229 | 1556 | 29 |
1181731 | 1181731 | 2021-04-02 | Wright | Missouri | 29229 | 1556 | 29 |
1178484 | 1178484 | 2021-04-01 | Wright | Missouri | 29229 | 1556 | 29 |
1175237 | 1175237 | 2021-03-31 | Wright | Missouri | 29229 | 1555 | 29 |
1171990 | 1171990 | 2021-03-30 | Wright | Missouri | 29229 | 1554 | 29 |
1168742 | 1168742 | 2021-03-29 | Wright | Missouri | 29229 | 1554 | 29 |
1165494 | 1165494 | 2021-03-28 | Wright | Missouri | 29229 | 1553 | 29 |
1162246 | 1162246 | 2021-03-27 | Wright | Missouri | 29229 | 1552 | 29 |
1158998 | 1158998 | 2021-03-26 | Wright | Missouri | 29229 | 1552 | 29 |
1155751 | 1155751 | 2021-03-25 | Wright | Missouri | 29229 | 1551 | 29 |
1152504 | 1152504 | 2021-03-24 | Wright | Missouri | 29229 | 1551 | 29 |
1149257 | 1149257 | 2021-03-23 | Wright | Missouri | 29229 | 1551 | 29 |
1146010 | 1146010 | 2021-03-22 | Wright | Missouri | 29229 | 1551 | 29 |
1142763 | 1142763 | 2021-03-21 | Wright | Missouri | 29229 | 1551 | 29 |
1139516 | 1139516 | 2021-03-20 | Wright | Missouri | 29229 | 1551 | 29 |
1136270 | 1136270 | 2021-03-19 | Wright | Missouri | 29229 | 1548 | 29 |
1133024 | 1133024 | 2021-03-18 | Wright | Missouri | 29229 | 1547 | 29 |
1129776 | 1129776 | 2021-03-17 | Wright | Missouri | 29229 | 1540 | 29 |
1126529 | 1126529 | 2021-03-16 | Wright | Missouri | 29229 | 1539 | 29 |
1123283 | 1123283 | 2021-03-15 | Wright | Missouri | 29229 | 1539 | 29 |
1120036 | 1120036 | 2021-03-14 | Wright | Missouri | 29229 | 1539 | 29 |
1116789 | 1116789 | 2021-03-13 | Wright | Missouri | 29229 | 1539 | 29 |
1113543 | 1113543 | 2021-03-12 | Wright | Missouri | 29229 | 1539 | 29 |
1110297 | 1110297 | 2021-03-11 | Wright | Missouri | 29229 | 1536 | 29 |
1107051 | 1107051 | 2021-03-10 | Wright | Missouri | 29229 | 1537 | 29 |
1103805 | 1103805 | 2021-03-09 | Wright | Missouri | 29229 | 1534 | 29 |
1100559 | 1100559 | 2021-03-08 | Wright | Missouri | 29229 | 1532 | 29 |
1097312 | 1097312 | 2021-03-07 | Wright | Missouri | 29229 | 1365 | 29 |
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);