ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Cabarrus" 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 |
---|---|---|---|---|---|---|---|
1812035 | 1812035 | 2021-10-13 | Cabarrus | North Carolina | 37025 | 32149 | 325 |
1808786 | 1808786 | 2021-10-12 | Cabarrus | North Carolina | 37025 | 32084 | 325 |
1805535 | 1805535 | 2021-10-11 | Cabarrus | North Carolina | 37025 | 32051 | 321 |
1802286 | 1802286 | 2021-10-10 | Cabarrus | North Carolina | 37025 | 31851 | 319 |
1799037 | 1799037 | 2021-10-09 | Cabarrus | North Carolina | 37025 | 31851 | 319 |
1795788 | 1795788 | 2021-10-08 | Cabarrus | North Carolina | 37025 | 31851 | 319 |
1792539 | 1792539 | 2021-10-07 | Cabarrus | North Carolina | 37025 | 31747 | 317 |
1789290 | 1789290 | 2021-10-06 | Cabarrus | North Carolina | 37025 | 31678 | 316 |
1786042 | 1786042 | 2021-10-05 | Cabarrus | North Carolina | 37025 | 31603 | 312 |
1782793 | 1782793 | 2021-10-04 | Cabarrus | North Carolina | 37025 | 31546 | 312 |
1779544 | 1779544 | 2021-10-03 | Cabarrus | North Carolina | 37025 | 31289 | 313 |
1776294 | 1776294 | 2021-10-02 | Cabarrus | North Carolina | 37025 | 31289 | 313 |
1773044 | 1773044 | 2021-10-01 | Cabarrus | North Carolina | 37025 | 31289 | 313 |
1769794 | 1769794 | 2021-09-30 | Cabarrus | North Carolina | 37025 | 31254 | 312 |
1766545 | 1766545 | 2021-09-29 | Cabarrus | North Carolina | 37025 | 31200 | 308 |
1763296 | 1763296 | 2021-09-28 | Cabarrus | North Carolina | 37025 | 31135 | 305 |
1760047 | 1760047 | 2021-09-27 | Cabarrus | North Carolina | 37025 | 31086 | 302 |
1756799 | 1756799 | 2021-09-26 | Cabarrus | North Carolina | 37025 | 30815 | 302 |
1753551 | 1753551 | 2021-09-25 | Cabarrus | North Carolina | 37025 | 30815 | 302 |
1750303 | 1750303 | 2021-09-24 | Cabarrus | North Carolina | 37025 | 30815 | 302 |
1747053 | 1747053 | 2021-09-23 | Cabarrus | North Carolina | 37025 | 30702 | 301 |
1743804 | 1743804 | 2021-09-22 | Cabarrus | North Carolina | 37025 | 30579 | 301 |
1740555 | 1740555 | 2021-09-21 | Cabarrus | North Carolina | 37025 | 30488 | 296 |
1737306 | 1737306 | 2021-09-20 | Cabarrus | North Carolina | 37025 | 30305 | 295 |
1734056 | 1734056 | 2021-09-19 | Cabarrus | North Carolina | 37025 | 29995 | 292 |
1730806 | 1730806 | 2021-09-18 | Cabarrus | North Carolina | 37025 | 29995 | 292 |
1727556 | 1727556 | 2021-09-17 | Cabarrus | North Carolina | 37025 | 29995 | 292 |
1724307 | 1724307 | 2021-09-16 | Cabarrus | North Carolina | 37025 | 29809 | 292 |
1721058 | 1721058 | 2021-09-15 | Cabarrus | North Carolina | 37025 | 29685 | 292 |
1717810 | 1717810 | 2021-09-14 | Cabarrus | North Carolina | 37025 | 29546 | 291 |
1714562 | 1714562 | 2021-09-13 | Cabarrus | North Carolina | 37025 | 29453 | 289 |
1711316 | 1711316 | 2021-09-12 | Cabarrus | North Carolina | 37025 | 28902 | 288 |
1708069 | 1708069 | 2021-09-11 | Cabarrus | North Carolina | 37025 | 28902 | 288 |
1704822 | 1704822 | 2021-09-10 | Cabarrus | North Carolina | 37025 | 28902 | 288 |
1701572 | 1701572 | 2021-09-09 | Cabarrus | North Carolina | 37025 | 28772 | 287 |
1698323 | 1698323 | 2021-09-08 | Cabarrus | North Carolina | 37025 | 28672 | 286 |
1695075 | 1695075 | 2021-09-07 | Cabarrus | North Carolina | 37025 | 28532 | 283 |
1691827 | 1691827 | 2021-09-06 | Cabarrus | North Carolina | 37025 | 27965 | 279 |
1688577 | 1688577 | 2021-09-05 | Cabarrus | North Carolina | 37025 | 27965 | 279 |
1685327 | 1685327 | 2021-09-04 | Cabarrus | North Carolina | 37025 | 27965 | 279 |
1682076 | 1682076 | 2021-09-03 | Cabarrus | North Carolina | 37025 | 27965 | 279 |
1678827 | 1678827 | 2021-09-02 | Cabarrus | North Carolina | 37025 | 27780 | 279 |
1675579 | 1675579 | 2021-09-01 | Cabarrus | North Carolina | 37025 | 27597 | 279 |
1672332 | 1672332 | 2021-08-31 | Cabarrus | North Carolina | 37025 | 27445 | 279 |
1669084 | 1669084 | 2021-08-30 | Cabarrus | North Carolina | 37025 | 27304 | 279 |
1665837 | 1665837 | 2021-08-29 | Cabarrus | North Carolina | 37025 | 26736 | 277 |
1662589 | 1662589 | 2021-08-28 | Cabarrus | North Carolina | 37025 | 26736 | 277 |
1659341 | 1659341 | 2021-08-27 | Cabarrus | North Carolina | 37025 | 26736 | 277 |
1656092 | 1656092 | 2021-08-26 | Cabarrus | North Carolina | 37025 | 26569 | 277 |
1652845 | 1652845 | 2021-08-25 | Cabarrus | North Carolina | 37025 | 26350 | 276 |
1649597 | 1649597 | 2021-08-24 | Cabarrus | North Carolina | 37025 | 26216 | 275 |
1646348 | 1646348 | 2021-08-23 | Cabarrus | North Carolina | 37025 | 26084 | 273 |
1643099 | 1643099 | 2021-08-22 | Cabarrus | North Carolina | 37025 | 25599 | 273 |
1639849 | 1639849 | 2021-08-21 | Cabarrus | North Carolina | 37025 | 25599 | 273 |
1636599 | 1636599 | 2021-08-20 | Cabarrus | North Carolina | 37025 | 25599 | 273 |
1633349 | 1633349 | 2021-08-19 | Cabarrus | North Carolina | 37025 | 25434 | 273 |
1630102 | 1630102 | 2021-08-18 | Cabarrus | North Carolina | 37025 | 25274 | 272 |
1626855 | 1626855 | 2021-08-17 | Cabarrus | North Carolina | 37025 | 25167 | 270 |
1623608 | 1623608 | 2021-08-16 | Cabarrus | North Carolina | 37025 | 25099 | 270 |
1620361 | 1620361 | 2021-08-15 | Cabarrus | North Carolina | 37025 | 24737 | 270 |
1617113 | 1617113 | 2021-08-14 | Cabarrus | North Carolina | 37025 | 24737 | 270 |
1613865 | 1613865 | 2021-08-13 | Cabarrus | North Carolina | 37025 | 24737 | 270 |
1610616 | 1610616 | 2021-08-12 | Cabarrus | North Carolina | 37025 | 24582 | 270 |
1607368 | 1607368 | 2021-08-11 | Cabarrus | North Carolina | 37025 | 24453 | 270 |
1604119 | 1604119 | 2021-08-10 | Cabarrus | North Carolina | 37025 | 24369 | 270 |
1600870 | 1600870 | 2021-08-09 | Cabarrus | North Carolina | 37025 | 24295 | 270 |
1597622 | 1597622 | 2021-08-08 | Cabarrus | North Carolina | 37025 | 23795 | 270 |
1594373 | 1594373 | 2021-08-07 | Cabarrus | North Carolina | 37025 | 23795 | 270 |
1591124 | 1591124 | 2021-08-06 | Cabarrus | North Carolina | 37025 | 23795 | 270 |
1587875 | 1587875 | 2021-08-05 | Cabarrus | North Carolina | 37025 | 23695 | 270 |
1584625 | 1584625 | 2021-08-04 | Cabarrus | North Carolina | 37025 | 23587 | 269 |
1581375 | 1581375 | 2021-08-03 | Cabarrus | North Carolina | 37025 | 23504 | 268 |
1578126 | 1578126 | 2021-08-02 | Cabarrus | North Carolina | 37025 | 23473 | 268 |
1574878 | 1574878 | 2021-08-01 | Cabarrus | North Carolina | 37025 | 23240 | 266 |
1571630 | 1571630 | 2021-07-31 | Cabarrus | North Carolina | 37025 | 23240 | 266 |
1568382 | 1568382 | 2021-07-30 | Cabarrus | North Carolina | 37025 | 23240 | 266 |
1565134 | 1565134 | 2021-07-29 | Cabarrus | North Carolina | 37025 | 23176 | 265 |
1561886 | 1561886 | 2021-07-28 | Cabarrus | North Carolina | 37025 | 23103 | 265 |
1558638 | 1558638 | 2021-07-27 | Cabarrus | North Carolina | 37025 | 23059 | 265 |
1555391 | 1555391 | 2021-07-26 | Cabarrus | North Carolina | 37025 | 23040 | 264 |
1552144 | 1552144 | 2021-07-25 | Cabarrus | North Carolina | 37025 | 22873 | 264 |
1548897 | 1548897 | 2021-07-24 | Cabarrus | North Carolina | 37025 | 22873 | 264 |
1545650 | 1545650 | 2021-07-23 | Cabarrus | North Carolina | 37025 | 22873 | 264 |
1542403 | 1542403 | 2021-07-22 | Cabarrus | North Carolina | 37025 | 22845 | 264 |
1539155 | 1539155 | 2021-07-21 | Cabarrus | North Carolina | 37025 | 22794 | 264 |
1535908 | 1535908 | 2021-07-20 | Cabarrus | North Carolina | 37025 | 22755 | 264 |
1532660 | 1532660 | 2021-07-19 | Cabarrus | North Carolina | 37025 | 22722 | 264 |
1529413 | 1529413 | 2021-07-18 | Cabarrus | North Carolina | 37025 | 22645 | 264 |
1526166 | 1526166 | 2021-07-17 | Cabarrus | North Carolina | 37025 | 22645 | 264 |
1522919 | 1522919 | 2021-07-16 | Cabarrus | North Carolina | 37025 | 22645 | 264 |
1519671 | 1519671 | 2021-07-15 | Cabarrus | North Carolina | 37025 | 22608 | 264 |
1516423 | 1516423 | 2021-07-14 | Cabarrus | North Carolina | 37025 | 22573 | 264 |
1513176 | 1513176 | 2021-07-13 | Cabarrus | North Carolina | 37025 | 22551 | 264 |
1509930 | 1509930 | 2021-07-12 | Cabarrus | North Carolina | 37025 | 22532 | 264 |
1506683 | 1506683 | 2021-07-11 | Cabarrus | North Carolina | 37025 | 22467 | 263 |
1503437 | 1503437 | 2021-07-10 | Cabarrus | North Carolina | 37025 | 22467 | 263 |
1500191 | 1500191 | 2021-07-09 | Cabarrus | North Carolina | 37025 | 22467 | 263 |
1496945 | 1496945 | 2021-07-08 | Cabarrus | North Carolina | 37025 | 22456 | 263 |
1493698 | 1493698 | 2021-07-07 | Cabarrus | North Carolina | 37025 | 22446 | 263 |
1490451 | 1490451 | 2021-07-06 | Cabarrus | North Carolina | 37025 | 22432 | 262 |
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);