ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Gaston" 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 |
---|---|---|---|---|---|---|---|
1812058 | 1812058 | 2021-10-13 | Gaston | North Carolina | 37071 | 39114 | 587 |
1808809 | 1808809 | 2021-10-12 | Gaston | North Carolina | 37071 | 39027 | 588 |
1805558 | 1805558 | 2021-10-11 | Gaston | North Carolina | 37071 | 38951 | 587 |
1802309 | 1802309 | 2021-10-10 | Gaston | North Carolina | 37071 | 38627 | 582 |
1799060 | 1799060 | 2021-10-09 | Gaston | North Carolina | 37071 | 38627 | 582 |
1795811 | 1795811 | 2021-10-08 | Gaston | North Carolina | 37071 | 38627 | 582 |
1792562 | 1792562 | 2021-10-07 | Gaston | North Carolina | 37071 | 38491 | 579 |
1789313 | 1789313 | 2021-10-06 | Gaston | North Carolina | 37071 | 38383 | 576 |
1786065 | 1786065 | 2021-10-05 | Gaston | North Carolina | 37071 | 38259 | 574 |
1782816 | 1782816 | 2021-10-04 | Gaston | North Carolina | 37071 | 38176 | 572 |
1779567 | 1779567 | 2021-10-03 | Gaston | North Carolina | 37071 | 37817 | 567 |
1776317 | 1776317 | 2021-10-02 | Gaston | North Carolina | 37071 | 37817 | 567 |
1773067 | 1773067 | 2021-10-01 | Gaston | North Carolina | 37071 | 37817 | 567 |
1769817 | 1769817 | 2021-09-30 | Gaston | North Carolina | 37071 | 37692 | 561 |
1766568 | 1766568 | 2021-09-29 | Gaston | North Carolina | 37071 | 37567 | 553 |
1763319 | 1763319 | 2021-09-28 | Gaston | North Carolina | 37071 | 37429 | 545 |
1760070 | 1760070 | 2021-09-27 | Gaston | North Carolina | 37071 | 37312 | 544 |
1756822 | 1756822 | 2021-09-26 | Gaston | North Carolina | 37071 | 36863 | 537 |
1753574 | 1753574 | 2021-09-25 | Gaston | North Carolina | 37071 | 36863 | 537 |
1750326 | 1750326 | 2021-09-24 | Gaston | North Carolina | 37071 | 36863 | 537 |
1747076 | 1747076 | 2021-09-23 | Gaston | North Carolina | 37071 | 36717 | 531 |
1743827 | 1743827 | 2021-09-22 | Gaston | North Carolina | 37071 | 36487 | 529 |
1740578 | 1740578 | 2021-09-21 | Gaston | North Carolina | 37071 | 36236 | 528 |
1737329 | 1737329 | 2021-09-20 | Gaston | North Carolina | 37071 | 36056 | 528 |
1734079 | 1734079 | 2021-09-19 | Gaston | North Carolina | 37071 | 35481 | 517 |
1730829 | 1730829 | 2021-09-18 | Gaston | North Carolina | 37071 | 35481 | 517 |
1727579 | 1727579 | 2021-09-17 | Gaston | North Carolina | 37071 | 35481 | 517 |
1724330 | 1724330 | 2021-09-16 | Gaston | North Carolina | 37071 | 35250 | 515 |
1721081 | 1721081 | 2021-09-15 | Gaston | North Carolina | 37071 | 35093 | 512 |
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 |
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);