ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "New Hanover" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812087 | 1812087 | 2021-10-13 | New Hanover | North Carolina | 37129 | 28236 | 281 |
1808838 | 1808838 | 2021-10-12 | New Hanover | North Carolina | 37129 | 28194 | 277 |
1805587 | 1805587 | 2021-10-11 | New Hanover | North Carolina | 37129 | 28161 | 277 |
1802338 | 1802338 | 2021-10-10 | New Hanover | North Carolina | 37129 | 28036 | 275 |
1799089 | 1799089 | 2021-10-09 | New Hanover | North Carolina | 37129 | 28036 | 275 |
1795840 | 1795840 | 2021-10-08 | New Hanover | North Carolina | 37129 | 28036 | 275 |
1792591 | 1792591 | 2021-10-07 | New Hanover | North Carolina | 37129 | 27995 | 274 |
1789342 | 1789342 | 2021-10-06 | New Hanover | North Carolina | 37129 | 27926 | 272 |
1786094 | 1786094 | 2021-10-05 | New Hanover | North Carolina | 37129 | 27827 | 271 |
1782845 | 1782845 | 2021-10-04 | New Hanover | North Carolina | 37129 | 27794 | 267 |
1779596 | 1779596 | 2021-10-03 | New Hanover | North Carolina | 37129 | 27590 | 265 |
1776346 | 1776346 | 2021-10-02 | New Hanover | North Carolina | 37129 | 27590 | 265 |
1773096 | 1773096 | 2021-10-01 | New Hanover | North Carolina | 37129 | 27590 | 265 |
1769846 | 1769846 | 2021-09-30 | New Hanover | North Carolina | 37129 | 27546 | 265 |
1766597 | 1766597 | 2021-09-29 | New Hanover | North Carolina | 37129 | 27503 | 264 |
1763348 | 1763348 | 2021-09-28 | New Hanover | North Carolina | 37129 | 27429 | 264 |
1760099 | 1760099 | 2021-09-27 | New Hanover | North Carolina | 37129 | 27395 | 262 |
1756851 | 1756851 | 2021-09-26 | New Hanover | North Carolina | 37129 | 27203 | 259 |
1753603 | 1753603 | 2021-09-25 | New Hanover | North Carolina | 37129 | 27203 | 259 |
1750355 | 1750355 | 2021-09-24 | New Hanover | North Carolina | 37129 | 27203 | 259 |
1747105 | 1747105 | 2021-09-23 | New Hanover | North Carolina | 37129 | 27139 | 257 |
1743856 | 1743856 | 2021-09-22 | New Hanover | North Carolina | 37129 | 27007 | 258 |
1740607 | 1740607 | 2021-09-21 | New Hanover | North Carolina | 37129 | 26890 | 251 |
1737358 | 1737358 | 2021-09-20 | New Hanover | North Carolina | 37129 | 26824 | 249 |
1734108 | 1734108 | 2021-09-19 | New Hanover | North Carolina | 37129 | 26505 | 241 |
1730858 | 1730858 | 2021-09-18 | New Hanover | North Carolina | 37129 | 26505 | 241 |
1727608 | 1727608 | 2021-09-17 | New Hanover | North Carolina | 37129 | 26505 | 241 |
1724359 | 1724359 | 2021-09-16 | New Hanover | North Carolina | 37129 | 26326 | 238 |
1721110 | 1721110 | 2021-09-15 | New Hanover | North Carolina | 37129 | 26246 | 225 |
1717862 | 1717862 | 2021-09-14 | New Hanover | North Carolina | 37129 | 26099 | 222 |
1714614 | 1714614 | 2021-09-13 | New Hanover | North Carolina | 37129 | 26022 | 218 |
1711368 | 1711368 | 2021-09-12 | New Hanover | North Carolina | 37129 | 25581 | 214 |
1708121 | 1708121 | 2021-09-11 | New Hanover | North Carolina | 37129 | 25581 | 214 |
1704874 | 1704874 | 2021-09-10 | New Hanover | North Carolina | 37129 | 25581 | 214 |
1701624 | 1701624 | 2021-09-09 | New Hanover | North Carolina | 37129 | 25485 | 210 |
1698375 | 1698375 | 2021-09-08 | New Hanover | North Carolina | 37129 | 25324 | 209 |
1695127 | 1695127 | 2021-09-07 | New Hanover | North Carolina | 37129 | 25201 | 207 |
1691879 | 1691879 | 2021-09-06 | New Hanover | North Carolina | 37129 | 24628 | 201 |
1688629 | 1688629 | 2021-09-05 | New Hanover | North Carolina | 37129 | 24628 | 201 |
1685379 | 1685379 | 2021-09-04 | New Hanover | North Carolina | 37129 | 24628 | 201 |
1682128 | 1682128 | 2021-09-03 | New Hanover | North Carolina | 37129 | 24628 | 201 |
1678879 | 1678879 | 2021-09-02 | New Hanover | North Carolina | 37129 | 24441 | 201 |
1675631 | 1675631 | 2021-09-01 | New Hanover | North Carolina | 37129 | 24232 | 201 |
1672384 | 1672384 | 2021-08-31 | New Hanover | North Carolina | 37129 | 24041 | 199 |
1669136 | 1669136 | 2021-08-30 | New Hanover | North Carolina | 37129 | 23897 | 195 |
1665889 | 1665889 | 2021-08-29 | New Hanover | North Carolina | 37129 | 23381 | 193 |
1662641 | 1662641 | 2021-08-28 | New Hanover | North Carolina | 37129 | 23381 | 193 |
1659393 | 1659393 | 2021-08-27 | New Hanover | North Carolina | 37129 | 23381 | 193 |
1656144 | 1656144 | 2021-08-26 | New Hanover | North Carolina | 37129 | 23201 | 191 |
1652897 | 1652897 | 2021-08-25 | New Hanover | North Carolina | 37129 | 22988 | 190 |
1649649 | 1649649 | 2021-08-24 | New Hanover | North Carolina | 37129 | 22873 | 190 |
1646400 | 1646400 | 2021-08-23 | New Hanover | North Carolina | 37129 | 22782 | 187 |
1643151 | 1643151 | 2021-08-22 | New Hanover | North Carolina | 37129 | 22364 | 186 |
1639901 | 1639901 | 2021-08-21 | New Hanover | North Carolina | 37129 | 22364 | 186 |
1636651 | 1636651 | 2021-08-20 | New Hanover | North Carolina | 37129 | 22364 | 186 |
1633401 | 1633401 | 2021-08-19 | New Hanover | North Carolina | 37129 | 22193 | 185 |
1630154 | 1630154 | 2021-08-18 | New Hanover | North Carolina | 37129 | 22038 | 183 |
1626907 | 1626907 | 2021-08-17 | New Hanover | North Carolina | 37129 | 21921 | 183 |
1623660 | 1623660 | 2021-08-16 | New Hanover | North Carolina | 37129 | 21853 | 183 |
1620413 | 1620413 | 2021-08-15 | New Hanover | North Carolina | 37129 | 21486 | 182 |
1617165 | 1617165 | 2021-08-14 | New Hanover | North Carolina | 37129 | 21486 | 182 |
1613917 | 1613917 | 2021-08-13 | New Hanover | North Carolina | 37129 | 21486 | 182 |
1610668 | 1610668 | 2021-08-12 | New Hanover | North Carolina | 37129 | 21325 | 182 |
1607420 | 1607420 | 2021-08-11 | New Hanover | North Carolina | 37129 | 21231 | 182 |
1604171 | 1604171 | 2021-08-10 | New Hanover | North Carolina | 37129 | 21105 | 181 |
1600922 | 1600922 | 2021-08-09 | New Hanover | North Carolina | 37129 | 21043 | 179 |
1597674 | 1597674 | 2021-08-08 | New Hanover | North Carolina | 37129 | 20610 | 179 |
1594425 | 1594425 | 2021-08-07 | New Hanover | North Carolina | 37129 | 20610 | 179 |
1591176 | 1591176 | 2021-08-06 | New Hanover | North Carolina | 37129 | 20610 | 179 |
1587927 | 1587927 | 2021-08-05 | New Hanover | North Carolina | 37129 | 20513 | 179 |
1584677 | 1584677 | 2021-08-04 | New Hanover | North Carolina | 37129 | 20426 | 179 |
1581427 | 1581427 | 2021-08-03 | New Hanover | North Carolina | 37129 | 20374 | 178 |
1578178 | 1578178 | 2021-08-02 | New Hanover | North Carolina | 37129 | 20313 | 178 |
1574930 | 1574930 | 2021-08-01 | New Hanover | North Carolina | 37129 | 20112 | 178 |
1571682 | 1571682 | 2021-07-31 | New Hanover | North Carolina | 37129 | 20112 | 178 |
1568434 | 1568434 | 2021-07-30 | New Hanover | North Carolina | 37129 | 20112 | 178 |
1565186 | 1565186 | 2021-07-29 | New Hanover | North Carolina | 37129 | 20062 | 177 |
1561938 | 1561938 | 2021-07-28 | New Hanover | North Carolina | 37129 | 19984 | 176 |
1558690 | 1558690 | 2021-07-27 | New Hanover | North Carolina | 37129 | 19924 | 176 |
1555443 | 1555443 | 2021-07-26 | New Hanover | North Carolina | 37129 | 19888 | 176 |
1552196 | 1552196 | 2021-07-25 | New Hanover | North Carolina | 37129 | 19811 | 176 |
1548949 | 1548949 | 2021-07-24 | New Hanover | North Carolina | 37129 | 19811 | 176 |
1545702 | 1545702 | 2021-07-23 | New Hanover | North Carolina | 37129 | 19811 | 176 |
1542455 | 1542455 | 2021-07-22 | New Hanover | North Carolina | 37129 | 19779 | 176 |
1539207 | 1539207 | 2021-07-21 | New Hanover | North Carolina | 37129 | 19761 | 176 |
1535960 | 1535960 | 2021-07-20 | New Hanover | North Carolina | 37129 | 19747 | 176 |
1532712 | 1532712 | 2021-07-19 | New Hanover | North Carolina | 37129 | 19735 | 176 |
1529465 | 1529465 | 2021-07-18 | New Hanover | North Carolina | 37129 | 19683 | 176 |
1526218 | 1526218 | 2021-07-17 | New Hanover | North Carolina | 37129 | 19683 | 176 |
1522971 | 1522971 | 2021-07-16 | New Hanover | North Carolina | 37129 | 19683 | 176 |
1519723 | 1519723 | 2021-07-15 | New Hanover | North Carolina | 37129 | 19668 | 176 |
1516475 | 1516475 | 2021-07-14 | New Hanover | North Carolina | 37129 | 19659 | 176 |
1513228 | 1513228 | 2021-07-13 | New Hanover | North Carolina | 37129 | 19641 | 176 |
1509982 | 1509982 | 2021-07-12 | New Hanover | North Carolina | 37129 | 19635 | 176 |
1506735 | 1506735 | 2021-07-11 | New Hanover | North Carolina | 37129 | 19605 | 176 |
1503489 | 1503489 | 2021-07-10 | New Hanover | North Carolina | 37129 | 19605 | 176 |
1500243 | 1500243 | 2021-07-09 | New Hanover | North Carolina | 37129 | 19605 | 176 |
1496997 | 1496997 | 2021-07-08 | New Hanover | North Carolina | 37129 | 19596 | 176 |
1493750 | 1493750 | 2021-07-07 | New Hanover | North Carolina | 37129 | 19593 | 175 |
1490503 | 1490503 | 2021-07-06 | New Hanover | North Carolina | 37129 | 19581 | 175 |
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);