ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
693 rows where county = "Wayne" and fips = 29223 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850718 | 1850718 | 2021-10-25 | Wayne | Missouri | 29223 | 1585 | 18 |
1847468 | 1847468 | 2021-10-24 | Wayne | Missouri | 29223 | 1585 | 18 |
1844218 | 1844218 | 2021-10-23 | Wayne | Missouri | 29223 | 1585 | 18 |
1840968 | 1840968 | 2021-10-22 | Wayne | Missouri | 29223 | 1583 | 18 |
1837719 | 1837719 | 2021-10-21 | Wayne | Missouri | 29223 | 1581 | 18 |
1834470 | 1834470 | 2021-10-20 | Wayne | Missouri | 29223 | 1579 | 18 |
1831221 | 1831221 | 2021-10-19 | Wayne | Missouri | 29223 | 1572 | 18 |
1827972 | 1827972 | 2021-10-18 | Wayne | Missouri | 29223 | 1566 | 18 |
1824723 | 1824723 | 2021-10-17 | Wayne | Missouri | 29223 | 1566 | 18 |
1821474 | 1821474 | 2021-10-16 | Wayne | Missouri | 29223 | 1563 | 18 |
1818225 | 1818225 | 2021-10-15 | Wayne | Missouri | 29223 | 1561 | 18 |
1814976 | 1814976 | 2021-10-14 | Wayne | Missouri | 29223 | 1556 | 18 |
1811728 | 1811728 | 2021-10-13 | Wayne | Missouri | 29223 | 1548 | 18 |
1808479 | 1808479 | 2021-10-12 | Wayne | Missouri | 29223 | 1544 | 18 |
1805228 | 1805228 | 2021-10-11 | Wayne | Missouri | 29223 | 1542 | 18 |
1801979 | 1801979 | 2021-10-10 | Wayne | Missouri | 29223 | 1539 | 18 |
1798730 | 1798730 | 2021-10-09 | Wayne | Missouri | 29223 | 1538 | 18 |
1795481 | 1795481 | 2021-10-08 | Wayne | Missouri | 29223 | 1532 | 18 |
1792232 | 1792232 | 2021-10-07 | Wayne | Missouri | 29223 | 1525 | 18 |
1788983 | 1788983 | 2021-10-06 | Wayne | Missouri | 29223 | 1520 | 18 |
1785735 | 1785735 | 2021-10-05 | Wayne | Missouri | 29223 | 1507 | 18 |
1782486 | 1782486 | 2021-10-04 | Wayne | Missouri | 29223 | 1500 | 18 |
1779236 | 1779236 | 2021-10-03 | Wayne | Missouri | 29223 | 1500 | 18 |
1775986 | 1775986 | 2021-10-02 | Wayne | Missouri | 29223 | 1493 | 18 |
1772736 | 1772736 | 2021-10-01 | Wayne | Missouri | 29223 | 1487 | 18 |
1769487 | 1769487 | 2021-09-30 | Wayne | Missouri | 29223 | 1475 | 18 |
1766238 | 1766238 | 2021-09-29 | Wayne | Missouri | 29223 | 1469 | 18 |
1762989 | 1762989 | 2021-09-28 | Wayne | Missouri | 29223 | 1462 | 18 |
1759740 | 1759740 | 2021-09-27 | Wayne | Missouri | 29223 | 1460 | 18 |
1756492 | 1756492 | 2021-09-26 | Wayne | Missouri | 29223 | 1454 | 18 |
1753244 | 1753244 | 2021-09-25 | Wayne | Missouri | 29223 | 1452 | 18 |
1749996 | 1749996 | 2021-09-24 | Wayne | Missouri | 29223 | 1439 | 18 |
1746746 | 1746746 | 2021-09-23 | Wayne | Missouri | 29223 | 1433 | 18 |
1743497 | 1743497 | 2021-09-22 | Wayne | Missouri | 29223 | 1427 | 18 |
1740248 | 1740248 | 2021-09-21 | Wayne | Missouri | 29223 | 1417 | 18 |
1736999 | 1736999 | 2021-09-20 | Wayne | Missouri | 29223 | 1411 | 18 |
1733749 | 1733749 | 2021-09-19 | Wayne | Missouri | 29223 | 1408 | 18 |
1730499 | 1730499 | 2021-09-18 | Wayne | Missouri | 29223 | 1406 | 18 |
1727249 | 1727249 | 2021-09-17 | Wayne | Missouri | 29223 | 1403 | 18 |
1724000 | 1724000 | 2021-09-16 | Wayne | Missouri | 29223 | 1396 | 18 |
1720751 | 1720751 | 2021-09-15 | Wayne | Missouri | 29223 | 1392 | 18 |
1717503 | 1717503 | 2021-09-14 | Wayne | Missouri | 29223 | 1384 | 18 |
1714255 | 1714255 | 2021-09-13 | Wayne | Missouri | 29223 | 1375 | 17 |
1711009 | 1711009 | 2021-09-12 | Wayne | Missouri | 29223 | 1369 | 17 |
1707762 | 1707762 | 2021-09-11 | Wayne | Missouri | 29223 | 1362 | 17 |
1704515 | 1704515 | 2021-09-10 | Wayne | Missouri | 29223 | 1350 | 17 |
1701265 | 1701265 | 2021-09-09 | Wayne | Missouri | 29223 | 1347 | 17 |
1698016 | 1698016 | 2021-09-08 | Wayne | Missouri | 29223 | 1333 | 17 |
1694768 | 1694768 | 2021-09-07 | Wayne | Missouri | 29223 | 1328 | 17 |
1691519 | 1691519 | 2021-09-06 | Wayne | Missouri | 29223 | 1328 | 17 |
1688269 | 1688269 | 2021-09-05 | Wayne | Missouri | 29223 | 1326 | 17 |
1685019 | 1685019 | 2021-09-04 | Wayne | Missouri | 29223 | 1321 | 17 |
1681768 | 1681768 | 2021-09-03 | Wayne | Missouri | 29223 | 1312 | 17 |
1678520 | 1678520 | 2021-09-02 | Wayne | Missouri | 29223 | 1303 | 17 |
1675272 | 1675272 | 2021-09-01 | Wayne | Missouri | 29223 | 1297 | 17 |
1672024 | 1672024 | 2021-08-31 | Wayne | Missouri | 29223 | 1289 | 17 |
1668777 | 1668777 | 2021-08-30 | Wayne | Missouri | 29223 | 1289 | 15 |
1665530 | 1665530 | 2021-08-29 | Wayne | Missouri | 29223 | 1287 | 15 |
1662282 | 1662282 | 2021-08-28 | Wayne | Missouri | 29223 | 1281 | 15 |
1659034 | 1659034 | 2021-08-27 | Wayne | Missouri | 29223 | 1272 | 15 |
1655785 | 1655785 | 2021-08-26 | Wayne | Missouri | 29223 | 1262 | 15 |
1652538 | 1652538 | 2021-08-25 | Wayne | Missouri | 29223 | 1259 | 15 |
1649290 | 1649290 | 2021-08-24 | Wayne | Missouri | 29223 | 1248 | 15 |
1646041 | 1646041 | 2021-08-23 | Wayne | Missouri | 29223 | 1244 | 15 |
1642792 | 1642792 | 2021-08-22 | Wayne | Missouri | 29223 | 1242 | 15 |
1639542 | 1639542 | 2021-08-21 | Wayne | Missouri | 29223 | 1239 | 15 |
1636292 | 1636292 | 2021-08-20 | Wayne | Missouri | 29223 | 1235 | 15 |
1633042 | 1633042 | 2021-08-19 | Wayne | Missouri | 29223 | 1226 | 15 |
1629795 | 1629795 | 2021-08-18 | Wayne | Missouri | 29223 | 1219 | 15 |
1626548 | 1626548 | 2021-08-17 | Wayne | Missouri | 29223 | 1213 | 15 |
1623301 | 1623301 | 2021-08-16 | Wayne | Missouri | 29223 | 1208 | 14 |
1620054 | 1620054 | 2021-08-15 | Wayne | Missouri | 29223 | 1203 | 14 |
1616806 | 1616806 | 2021-08-14 | Wayne | Missouri | 29223 | 1199 | 14 |
1613558 | 1613558 | 2021-08-13 | Wayne | Missouri | 29223 | 1188 | 14 |
1610309 | 1610309 | 2021-08-12 | Wayne | Missouri | 29223 | 1181 | 14 |
1607061 | 1607061 | 2021-08-11 | Wayne | Missouri | 29223 | 1176 | 14 |
1603812 | 1603812 | 2021-08-10 | Wayne | Missouri | 29223 | 1165 | 14 |
1600563 | 1600563 | 2021-08-09 | Wayne | Missouri | 29223 | 1161 | 14 |
1597315 | 1597315 | 2021-08-08 | Wayne | Missouri | 29223 | 1155 | 14 |
1594066 | 1594066 | 2021-08-07 | Wayne | Missouri | 29223 | 1152 | 14 |
1590817 | 1590817 | 2021-08-06 | Wayne | Missouri | 29223 | 1148 | 14 |
1587568 | 1587568 | 2021-08-05 | Wayne | Missouri | 29223 | 1140 | 14 |
1584317 | 1584317 | 2021-08-04 | Wayne | Missouri | 29223 | 1127 | 14 |
1581068 | 1581068 | 2021-08-03 | Wayne | Missouri | 29223 | 1116 | 14 |
1577819 | 1577819 | 2021-08-02 | Wayne | Missouri | 29223 | 1108 | 14 |
1574571 | 1574571 | 2021-08-01 | Wayne | Missouri | 29223 | 1105 | 14 |
1571323 | 1571323 | 2021-07-31 | Wayne | Missouri | 29223 | 1104 | 14 |
1568075 | 1568075 | 2021-07-30 | Wayne | Missouri | 29223 | 1098 | 14 |
1564827 | 1564827 | 2021-07-29 | Wayne | Missouri | 29223 | 1094 | 14 |
1561579 | 1561579 | 2021-07-28 | Wayne | Missouri | 29223 | 1094 | 14 |
1558331 | 1558331 | 2021-07-27 | Wayne | Missouri | 29223 | 1093 | 14 |
1555084 | 1555084 | 2021-07-26 | Wayne | Missouri | 29223 | 1091 | 14 |
1551837 | 1551837 | 2021-07-25 | Wayne | Missouri | 29223 | 1091 | 14 |
1548590 | 1548590 | 2021-07-24 | Wayne | Missouri | 29223 | 1089 | 14 |
1545343 | 1545343 | 2021-07-23 | Wayne | Missouri | 29223 | 1083 | 14 |
1542095 | 1542095 | 2021-07-22 | Wayne | Missouri | 29223 | 1079 | 14 |
1538848 | 1538848 | 2021-07-21 | Wayne | Missouri | 29223 | 1075 | 14 |
1535601 | 1535601 | 2021-07-20 | Wayne | Missouri | 29223 | 1067 | 14 |
1532353 | 1532353 | 2021-07-19 | Wayne | Missouri | 29223 | 1061 | 14 |
1529106 | 1529106 | 2021-07-18 | Wayne | Missouri | 29223 | 1057 | 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);