ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 29073 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418661 | 1418661 | 2021-06-14 | Gasconade | Missouri | 29073 | 1577 | 46 |
1415416 | 1415416 | 2021-06-13 | Gasconade | Missouri | 29073 | 1577 | 46 |
1412170 | 1412170 | 2021-06-12 | Gasconade | Missouri | 29073 | 1577 | 46 |
1408925 | 1408925 | 2021-06-11 | Gasconade | Missouri | 29073 | 1576 | 46 |
1405680 | 1405680 | 2021-06-10 | Gasconade | Missouri | 29073 | 1576 | 46 |
1402434 | 1402434 | 2021-06-09 | Gasconade | Missouri | 29073 | 1575 | 46 |
1399189 | 1399189 | 2021-06-08 | Gasconade | Missouri | 29073 | 1574 | 46 |
1395943 | 1395943 | 2021-06-07 | Gasconade | Missouri | 29073 | 1571 | 46 |
1392697 | 1392697 | 2021-06-06 | Gasconade | Missouri | 29073 | 1571 | 46 |
1389452 | 1389452 | 2021-06-05 | Gasconade | Missouri | 29073 | 1571 | 46 |
1386207 | 1386207 | 2021-06-04 | Gasconade | Missouri | 29073 | 1569 | 46 |
1382962 | 1382962 | 2021-06-03 | Gasconade | Missouri | 29073 | 1567 | 46 |
1379716 | 1379716 | 2021-06-02 | Gasconade | Missouri | 29073 | 1563 | 46 |
1376471 | 1376471 | 2021-06-01 | Gasconade | Missouri | 29073 | 1561 | 46 |
1373225 | 1373225 | 2021-05-31 | Gasconade | Missouri | 29073 | 1561 | 46 |
1369980 | 1369980 | 2021-05-30 | Gasconade | Missouri | 29073 | 1561 | 46 |
1366734 | 1366734 | 2021-05-29 | Gasconade | Missouri | 29073 | 1560 | 46 |
1363488 | 1363488 | 2021-05-28 | Gasconade | Missouri | 29073 | 1558 | 46 |
1360241 | 1360241 | 2021-05-27 | Gasconade | Missouri | 29073 | 1557 | 46 |
1356995 | 1356995 | 2021-05-26 | Gasconade | Missouri | 29073 | 1546 | 46 |
1353749 | 1353749 | 2021-05-25 | Gasconade | Missouri | 29073 | 1545 | 46 |
1350503 | 1350503 | 2021-05-24 | Gasconade | Missouri | 29073 | 1546 | 45 |
1347257 | 1347257 | 2021-05-23 | Gasconade | Missouri | 29073 | 1545 | 45 |
1344009 | 1344009 | 2021-05-22 | Gasconade | Missouri | 29073 | 1545 | 45 |
1340760 | 1340760 | 2021-05-21 | Gasconade | Missouri | 29073 | 1545 | 45 |
1337513 | 1337513 | 2021-05-20 | Gasconade | Missouri | 29073 | 1544 | 45 |
1334266 | 1334266 | 2021-05-19 | Gasconade | Missouri | 29073 | 1542 | 45 |
1331019 | 1331019 | 2021-05-18 | Gasconade | Missouri | 29073 | 1542 | 45 |
1327772 | 1327772 | 2021-05-17 | Gasconade | Missouri | 29073 | 1541 | 45 |
1324526 | 1324526 | 2021-05-16 | Gasconade | Missouri | 29073 | 1540 | 45 |
1321280 | 1321280 | 2021-05-15 | Gasconade | Missouri | 29073 | 1540 | 45 |
1318034 | 1318034 | 2021-05-14 | Gasconade | Missouri | 29073 | 1539 | 45 |
1314786 | 1314786 | 2021-05-13 | Gasconade | Missouri | 29073 | 1537 | 45 |
1311540 | 1311540 | 2021-05-12 | Gasconade | Missouri | 29073 | 1536 | 45 |
1308293 | 1308293 | 2021-05-11 | Gasconade | Missouri | 29073 | 1536 | 45 |
1305047 | 1305047 | 2021-05-10 | Gasconade | Missouri | 29073 | 1536 | 45 |
1301801 | 1301801 | 2021-05-09 | Gasconade | Missouri | 29073 | 1536 | 45 |
1298553 | 1298553 | 2021-05-08 | Gasconade | Missouri | 29073 | 1536 | 45 |
1295307 | 1295307 | 2021-05-07 | Gasconade | Missouri | 29073 | 1535 | 45 |
1292061 | 1292061 | 2021-05-06 | Gasconade | Missouri | 29073 | 1534 | 45 |
1288815 | 1288815 | 2021-05-05 | Gasconade | Missouri | 29073 | 1533 | 45 |
1285569 | 1285569 | 2021-05-04 | Gasconade | Missouri | 29073 | 1532 | 45 |
1282323 | 1282323 | 2021-05-03 | Gasconade | Missouri | 29073 | 1532 | 45 |
1279076 | 1279076 | 2021-05-02 | Gasconade | Missouri | 29073 | 1532 | 45 |
1275829 | 1275829 | 2021-05-01 | Gasconade | Missouri | 29073 | 1528 | 45 |
1272582 | 1272582 | 2021-04-30 | Gasconade | Missouri | 29073 | 1525 | 45 |
1269335 | 1269335 | 2021-04-29 | Gasconade | Missouri | 29073 | 1523 | 45 |
1266088 | 1266088 | 2021-04-28 | Gasconade | Missouri | 29073 | 1522 | 45 |
1262841 | 1262841 | 2021-04-27 | Gasconade | Missouri | 29073 | 1519 | 45 |
1259594 | 1259594 | 2021-04-26 | Gasconade | Missouri | 29073 | 1519 | 44 |
1256347 | 1256347 | 2021-04-25 | Gasconade | Missouri | 29073 | 1519 | 44 |
1253100 | 1253100 | 2021-04-24 | Gasconade | Missouri | 29073 | 1519 | 44 |
1249853 | 1249853 | 2021-04-23 | Gasconade | Missouri | 29073 | 1519 | 44 |
1246606 | 1246606 | 2021-04-22 | Gasconade | Missouri | 29073 | 1518 | 44 |
1243359 | 1243359 | 2021-04-21 | Gasconade | Missouri | 29073 | 1517 | 44 |
1240112 | 1240112 | 2021-04-20 | Gasconade | Missouri | 29073 | 1518 | 44 |
1236865 | 1236865 | 2021-04-19 | Gasconade | Missouri | 29073 | 1515 | 44 |
1233618 | 1233618 | 2021-04-18 | Gasconade | Missouri | 29073 | 1514 | 44 |
1230370 | 1230370 | 2021-04-17 | Gasconade | Missouri | 29073 | 1514 | 44 |
1227122 | 1227122 | 2021-04-16 | Gasconade | Missouri | 29073 | 1580 | 44 |
1223874 | 1223874 | 2021-04-15 | Gasconade | Missouri | 29073 | 1580 | 44 |
1220627 | 1220627 | 2021-04-14 | Gasconade | Missouri | 29073 | 1578 | 44 |
1217379 | 1217379 | 2021-04-13 | Gasconade | Missouri | 29073 | 1576 | 44 |
1214132 | 1214132 | 2021-04-12 | Gasconade | Missouri | 29073 | 1575 | 43 |
1210884 | 1210884 | 2021-04-11 | Gasconade | Missouri | 29073 | 1575 | 43 |
1207635 | 1207635 | 2021-04-10 | Gasconade | Missouri | 29073 | 1574 | 43 |
1204387 | 1204387 | 2021-04-09 | Gasconade | Missouri | 29073 | 1573 | 43 |
1201139 | 1201139 | 2021-04-08 | Gasconade | Missouri | 29073 | 1572 | 43 |
1197890 | 1197890 | 2021-04-07 | Gasconade | Missouri | 29073 | 1572 | 43 |
1194641 | 1194641 | 2021-04-06 | Gasconade | Missouri | 29073 | 1572 | 43 |
1191392 | 1191392 | 2021-04-05 | Gasconade | Missouri | 29073 | 1569 | 43 |
1188144 | 1188144 | 2021-04-04 | Gasconade | Missouri | 29073 | 1569 | 43 |
1184897 | 1184897 | 2021-04-03 | Gasconade | Missouri | 29073 | 1569 | 43 |
1181651 | 1181651 | 2021-04-02 | Gasconade | Missouri | 29073 | 1568 | 43 |
1178404 | 1178404 | 2021-04-01 | Gasconade | Missouri | 29073 | 1566 | 43 |
1175157 | 1175157 | 2021-03-31 | Gasconade | Missouri | 29073 | 1565 | 43 |
1171910 | 1171910 | 2021-03-30 | Gasconade | Missouri | 29073 | 1562 | 43 |
1168662 | 1168662 | 2021-03-29 | Gasconade | Missouri | 29073 | 1561 | 43 |
1165414 | 1165414 | 2021-03-28 | Gasconade | Missouri | 29073 | 1560 | 43 |
1162166 | 1162166 | 2021-03-27 | Gasconade | Missouri | 29073 | 1559 | 43 |
1158918 | 1158918 | 2021-03-26 | Gasconade | Missouri | 29073 | 1557 | 43 |
1155671 | 1155671 | 2021-03-25 | Gasconade | Missouri | 29073 | 1556 | 43 |
1152424 | 1152424 | 2021-03-24 | Gasconade | Missouri | 29073 | 1557 | 43 |
1149177 | 1149177 | 2021-03-23 | Gasconade | Missouri | 29073 | 1554 | 43 |
1145930 | 1145930 | 2021-03-22 | Gasconade | Missouri | 29073 | 1553 | 42 |
1142683 | 1142683 | 2021-03-21 | Gasconade | Missouri | 29073 | 1553 | 42 |
1139436 | 1139436 | 2021-03-20 | Gasconade | Missouri | 29073 | 1554 | 42 |
1136190 | 1136190 | 2021-03-19 | Gasconade | Missouri | 29073 | 1549 | 42 |
1132944 | 1132944 | 2021-03-18 | Gasconade | Missouri | 29073 | 1548 | 42 |
1129696 | 1129696 | 2021-03-17 | Gasconade | Missouri | 29073 | 1546 | 42 |
1126449 | 1126449 | 2021-03-16 | Gasconade | Missouri | 29073 | 1538 | 42 |
1123203 | 1123203 | 2021-03-15 | Gasconade | Missouri | 29073 | 1529 | 42 |
1119956 | 1119956 | 2021-03-14 | Gasconade | Missouri | 29073 | 1528 | 42 |
1116709 | 1116709 | 2021-03-13 | Gasconade | Missouri | 29073 | 1525 | 42 |
1113463 | 1113463 | 2021-03-12 | Gasconade | Missouri | 29073 | 1524 | 42 |
1110217 | 1110217 | 2021-03-11 | Gasconade | Missouri | 29073 | 1519 | 42 |
1106971 | 1106971 | 2021-03-10 | Gasconade | Missouri | 29073 | 1516 | 42 |
1103725 | 1103725 | 2021-03-09 | Gasconade | Missouri | 29073 | 1515 | 42 |
1100479 | 1100479 | 2021-03-08 | Gasconade | Missouri | 29073 | 1512 | 41 |
1097232 | 1097232 | 2021-03-07 | Gasconade | Missouri | 29073 | 885 | 41 |
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);