ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 37025 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 |
---|---|---|---|---|---|---|---|
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 |
1487204 | 1487204 | 2021-07-05 | Cabarrus | North Carolina | 37025 | 22396 | 262 |
1483958 | 1483958 | 2021-07-04 | Cabarrus | North Carolina | 37025 | 22396 | 262 |
1480712 | 1480712 | 2021-07-03 | Cabarrus | North Carolina | 37025 | 22396 | 262 |
1477465 | 1477465 | 2021-07-02 | Cabarrus | North Carolina | 37025 | 22396 | 262 |
1474219 | 1474219 | 2021-07-01 | Cabarrus | North Carolina | 37025 | 22378 | 262 |
1470973 | 1470973 | 2021-06-30 | Cabarrus | North Carolina | 37025 | 22368 | 262 |
1467728 | 1467728 | 2021-06-29 | Cabarrus | North Carolina | 37025 | 22357 | 262 |
1464483 | 1464483 | 2021-06-28 | Cabarrus | North Carolina | 37025 | 22344 | 262 |
1461238 | 1461238 | 2021-06-27 | Cabarrus | North Carolina | 37025 | 22320 | 262 |
1457993 | 1457993 | 2021-06-26 | Cabarrus | North Carolina | 37025 | 22320 | 262 |
1454748 | 1454748 | 2021-06-25 | Cabarrus | North Carolina | 37025 | 22320 | 262 |
1451503 | 1451503 | 2021-06-24 | Cabarrus | North Carolina | 37025 | 22314 | 262 |
1448257 | 1448257 | 2021-06-23 | Cabarrus | North Carolina | 37025 | 22303 | 262 |
1445012 | 1445012 | 2021-06-22 | Cabarrus | North Carolina | 37025 | 22281 | 262 |
1441767 | 1441767 | 2021-06-21 | Cabarrus | North Carolina | 37025 | 22278 | 262 |
1438522 | 1438522 | 2021-06-20 | Cabarrus | North Carolina | 37025 | 22256 | 261 |
1435275 | 1435275 | 2021-06-19 | Cabarrus | North Carolina | 37025 | 22256 | 261 |
1432028 | 1432028 | 2021-06-18 | Cabarrus | North Carolina | 37025 | 22256 | 261 |
1428782 | 1428782 | 2021-06-17 | Cabarrus | North Carolina | 37025 | 22250 | 261 |
1425537 | 1425537 | 2021-06-16 | Cabarrus | North Carolina | 37025 | 22239 | 261 |
1422290 | 1422290 | 2021-06-15 | Cabarrus | North Carolina | 37025 | 22240 | 261 |
1419044 | 1419044 | 2021-06-14 | Cabarrus | North Carolina | 37025 | 22234 | 261 |
1415799 | 1415799 | 2021-06-13 | Cabarrus | North Carolina | 37025 | 22227 | 260 |
1412553 | 1412553 | 2021-06-12 | Cabarrus | North Carolina | 37025 | 22227 | 260 |
1409308 | 1409308 | 2021-06-11 | Cabarrus | North Carolina | 37025 | 22227 | 260 |
1406063 | 1406063 | 2021-06-10 | Cabarrus | North Carolina | 37025 | 22217 | 261 |
1402817 | 1402817 | 2021-06-09 | Cabarrus | North Carolina | 37025 | 22211 | 260 |
1399572 | 1399572 | 2021-06-08 | Cabarrus | North Carolina | 37025 | 22202 | 260 |
1396327 | 1396327 | 2021-06-07 | Cabarrus | North Carolina | 37025 | 22203 | 260 |
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);