ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 37071 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 |
---|---|---|---|---|---|---|---|
1717833 | 1717833 | 2021-09-14 | Gaston | North Carolina | 37071 | 34858 | 510 |
1714585 | 1714585 | 2021-09-13 | Gaston | North Carolina | 37071 | 34709 | 508 |
1711339 | 1711339 | 2021-09-12 | Gaston | North Carolina | 37071 | 33993 | 489 |
1708092 | 1708092 | 2021-09-11 | Gaston | North Carolina | 37071 | 33993 | 489 |
1704845 | 1704845 | 2021-09-10 | Gaston | North Carolina | 37071 | 33993 | 489 |
1701595 | 1701595 | 2021-09-09 | Gaston | North Carolina | 37071 | 33802 | 486 |
1698346 | 1698346 | 2021-09-08 | Gaston | North Carolina | 37071 | 33681 | 483 |
1695098 | 1695098 | 2021-09-07 | Gaston | North Carolina | 37071 | 33569 | 482 |
1691850 | 1691850 | 2021-09-06 | Gaston | North Carolina | 37071 | 32897 | 481 |
1688600 | 1688600 | 2021-09-05 | Gaston | North Carolina | 37071 | 32897 | 481 |
1685350 | 1685350 | 2021-09-04 | Gaston | North Carolina | 37071 | 32897 | 481 |
1682099 | 1682099 | 2021-09-03 | Gaston | North Carolina | 37071 | 32897 | 481 |
1678850 | 1678850 | 2021-09-02 | Gaston | North Carolina | 37071 | 32657 | 476 |
1675602 | 1675602 | 2021-09-01 | Gaston | North Carolina | 37071 | 32438 | 476 |
1672355 | 1672355 | 2021-08-31 | Gaston | North Carolina | 37071 | 32288 | 474 |
1669107 | 1669107 | 2021-08-30 | Gaston | North Carolina | 37071 | 32126 | 474 |
1665860 | 1665860 | 2021-08-29 | Gaston | North Carolina | 37071 | 31569 | 473 |
1662612 | 1662612 | 2021-08-28 | Gaston | North Carolina | 37071 | 31569 | 473 |
1659364 | 1659364 | 2021-08-27 | Gaston | North Carolina | 37071 | 31569 | 473 |
1656115 | 1656115 | 2021-08-26 | Gaston | North Carolina | 37071 | 31320 | 469 |
1652868 | 1652868 | 2021-08-25 | Gaston | North Carolina | 37071 | 31080 | 468 |
1649620 | 1649620 | 2021-08-24 | Gaston | North Carolina | 37071 | 30941 | 468 |
1646371 | 1646371 | 2021-08-23 | Gaston | North Carolina | 37071 | 30756 | 468 |
1643122 | 1643122 | 2021-08-22 | Gaston | North Carolina | 37071 | 30337 | 465 |
1639872 | 1639872 | 2021-08-21 | Gaston | North Carolina | 37071 | 30337 | 465 |
1636622 | 1636622 | 2021-08-20 | Gaston | North Carolina | 37071 | 30337 | 465 |
1633372 | 1633372 | 2021-08-19 | Gaston | North Carolina | 37071 | 30173 | 459 |
1630125 | 1630125 | 2021-08-18 | Gaston | North Carolina | 37071 | 30016 | 453 |
1626878 | 1626878 | 2021-08-17 | Gaston | North Carolina | 37071 | 29873 | 452 |
1623631 | 1623631 | 2021-08-16 | Gaston | North Carolina | 37071 | 29772 | 452 |
1620384 | 1620384 | 2021-08-15 | Gaston | North Carolina | 37071 | 29368 | 449 |
1617136 | 1617136 | 2021-08-14 | Gaston | North Carolina | 37071 | 29368 | 449 |
1613888 | 1613888 | 2021-08-13 | Gaston | North Carolina | 37071 | 29368 | 449 |
1610639 | 1610639 | 2021-08-12 | Gaston | North Carolina | 37071 | 29190 | 449 |
1607391 | 1607391 | 2021-08-11 | Gaston | North Carolina | 37071 | 29063 | 449 |
1604142 | 1604142 | 2021-08-10 | Gaston | North Carolina | 37071 | 28930 | 448 |
1600893 | 1600893 | 2021-08-09 | Gaston | North Carolina | 37071 | 28853 | 448 |
1597645 | 1597645 | 2021-08-08 | Gaston | North Carolina | 37071 | 28430 | 447 |
1594396 | 1594396 | 2021-08-07 | Gaston | North Carolina | 37071 | 28430 | 447 |
1591147 | 1591147 | 2021-08-06 | Gaston | North Carolina | 37071 | 28430 | 447 |
1587898 | 1587898 | 2021-08-05 | Gaston | North Carolina | 37071 | 28322 | 447 |
1584648 | 1584648 | 2021-08-04 | Gaston | North Carolina | 37071 | 28230 | 447 |
1581398 | 1581398 | 2021-08-03 | Gaston | North Carolina | 37071 | 28141 | 446 |
1578149 | 1578149 | 2021-08-02 | Gaston | North Carolina | 37071 | 28100 | 446 |
1574901 | 1574901 | 2021-08-01 | Gaston | North Carolina | 37071 | 27868 | 446 |
1571653 | 1571653 | 2021-07-31 | Gaston | North Carolina | 37071 | 27868 | 446 |
1568405 | 1568405 | 2021-07-30 | Gaston | North Carolina | 37071 | 27868 | 446 |
1565157 | 1565157 | 2021-07-29 | Gaston | North Carolina | 37071 | 27800 | 446 |
1561909 | 1561909 | 2021-07-28 | Gaston | North Carolina | 37071 | 27744 | 445 |
1558661 | 1558661 | 2021-07-27 | Gaston | North Carolina | 37071 | 27679 | 445 |
1555414 | 1555414 | 2021-07-26 | Gaston | North Carolina | 37071 | 27619 | 445 |
1552167 | 1552167 | 2021-07-25 | Gaston | North Carolina | 37071 | 27503 | 444 |
1548920 | 1548920 | 2021-07-24 | Gaston | North Carolina | 37071 | 27503 | 444 |
1545673 | 1545673 | 2021-07-23 | Gaston | North Carolina | 37071 | 27503 | 444 |
1542426 | 1542426 | 2021-07-22 | Gaston | North Carolina | 37071 | 27450 | 444 |
1539178 | 1539178 | 2021-07-21 | Gaston | North Carolina | 37071 | 27424 | 444 |
1535931 | 1535931 | 2021-07-20 | Gaston | North Carolina | 37071 | 27400 | 444 |
1532683 | 1532683 | 2021-07-19 | Gaston | North Carolina | 37071 | 27386 | 444 |
1529436 | 1529436 | 2021-07-18 | Gaston | North Carolina | 37071 | 27329 | 444 |
1526189 | 1526189 | 2021-07-17 | Gaston | North Carolina | 37071 | 27329 | 444 |
1522942 | 1522942 | 2021-07-16 | Gaston | North Carolina | 37071 | 27329 | 444 |
1519694 | 1519694 | 2021-07-15 | Gaston | North Carolina | 37071 | 27318 | 444 |
1516446 | 1516446 | 2021-07-14 | Gaston | North Carolina | 37071 | 27291 | 444 |
1513199 | 1513199 | 2021-07-13 | Gaston | North Carolina | 37071 | 27278 | 444 |
1509953 | 1509953 | 2021-07-12 | Gaston | North Carolina | 37071 | 27265 | 444 |
1506706 | 1506706 | 2021-07-11 | Gaston | North Carolina | 37071 | 27246 | 444 |
1503460 | 1503460 | 2021-07-10 | Gaston | North Carolina | 37071 | 27246 | 444 |
1500214 | 1500214 | 2021-07-09 | Gaston | North Carolina | 37071 | 27246 | 444 |
1496968 | 1496968 | 2021-07-08 | Gaston | North Carolina | 37071 | 27241 | 443 |
1493721 | 1493721 | 2021-07-07 | Gaston | North Carolina | 37071 | 27225 | 441 |
1490474 | 1490474 | 2021-07-06 | Gaston | North Carolina | 37071 | 27221 | 441 |
1487227 | 1487227 | 2021-07-05 | Gaston | North Carolina | 37071 | 27198 | 441 |
1483981 | 1483981 | 2021-07-04 | Gaston | North Carolina | 37071 | 27198 | 441 |
1480735 | 1480735 | 2021-07-03 | Gaston | North Carolina | 37071 | 27198 | 441 |
1477488 | 1477488 | 2021-07-02 | Gaston | North Carolina | 37071 | 27198 | 441 |
1474242 | 1474242 | 2021-07-01 | Gaston | North Carolina | 37071 | 27187 | 441 |
1470996 | 1470996 | 2021-06-30 | Gaston | North Carolina | 37071 | 27194 | 443 |
1467751 | 1467751 | 2021-06-29 | Gaston | North Carolina | 37071 | 27204 | 443 |
1464506 | 1464506 | 2021-06-28 | Gaston | North Carolina | 37071 | 27195 | 443 |
1461261 | 1461261 | 2021-06-27 | Gaston | North Carolina | 37071 | 27181 | 443 |
1458016 | 1458016 | 2021-06-26 | Gaston | North Carolina | 37071 | 27181 | 443 |
1454771 | 1454771 | 2021-06-25 | Gaston | North Carolina | 37071 | 27181 | 443 |
1451526 | 1451526 | 2021-06-24 | Gaston | North Carolina | 37071 | 27179 | 444 |
1448280 | 1448280 | 2021-06-23 | Gaston | North Carolina | 37071 | 27178 | 444 |
1445035 | 1445035 | 2021-06-22 | Gaston | North Carolina | 37071 | 27173 | 444 |
1441790 | 1441790 | 2021-06-21 | Gaston | North Carolina | 37071 | 27166 | 444 |
1438545 | 1438545 | 2021-06-20 | Gaston | North Carolina | 37071 | 27147 | 445 |
1435298 | 1435298 | 2021-06-19 | Gaston | North Carolina | 37071 | 27147 | 445 |
1432051 | 1432051 | 2021-06-18 | Gaston | North Carolina | 37071 | 27147 | 445 |
1428805 | 1428805 | 2021-06-17 | Gaston | North Carolina | 37071 | 27142 | 446 |
1425560 | 1425560 | 2021-06-16 | Gaston | North Carolina | 37071 | 27132 | 446 |
1422313 | 1422313 | 2021-06-15 | Gaston | North Carolina | 37071 | 27126 | 446 |
1419067 | 1419067 | 2021-06-14 | Gaston | North Carolina | 37071 | 27115 | 445 |
1415822 | 1415822 | 2021-06-13 | Gaston | North Carolina | 37071 | 27087 | 444 |
1412576 | 1412576 | 2021-06-12 | Gaston | North Carolina | 37071 | 27087 | 444 |
1409331 | 1409331 | 2021-06-11 | Gaston | North Carolina | 37071 | 27087 | 444 |
1406086 | 1406086 | 2021-06-10 | Gaston | North Carolina | 37071 | 27068 | 443 |
1402840 | 1402840 | 2021-06-09 | Gaston | North Carolina | 37071 | 27049 | 443 |
1399595 | 1399595 | 2021-06-08 | Gaston | North Carolina | 37071 | 27036 | 442 |
1396350 | 1396350 | 2021-06-07 | Gaston | North Carolina | 37071 | 27030 | 441 |
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);