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 |
---|---|---|---|---|---|---|---|
1948537 | 1948537 | 2021-11-24 | Gaston | North Carolina | 37071 | 41343 | 631 |
1945286 | 1945286 | 2021-11-23 | Gaston | North Carolina | 37071 | 41292 | 630 |
1942035 | 1942035 | 2021-11-22 | Gaston | North Carolina | 37071 | 41241 | 630 |
1938785 | 1938785 | 2021-11-21 | Gaston | North Carolina | 37071 | 41057 | 630 |
1935535 | 1935535 | 2021-11-20 | Gaston | North Carolina | 37071 | 41057 | 630 |
1932285 | 1932285 | 2021-11-19 | Gaston | North Carolina | 37071 | 41057 | 630 |
1929034 | 1929034 | 2021-11-18 | Gaston | North Carolina | 37071 | 40980 | 630 |
1925784 | 1925784 | 2021-11-17 | Gaston | North Carolina | 37071 | 40885 | 629 |
1922535 | 1922535 | 2021-11-16 | Gaston | North Carolina | 37071 | 40824 | 628 |
1919285 | 1919285 | 2021-11-15 | Gaston | North Carolina | 37071 | 40766 | 628 |
1916035 | 1916035 | 2021-11-14 | Gaston | North Carolina | 37071 | 40592 | 628 |
1912785 | 1912785 | 2021-11-13 | Gaston | North Carolina | 37071 | 40592 | 628 |
1909535 | 1909535 | 2021-11-12 | Gaston | North Carolina | 37071 | 40592 | 628 |
1906286 | 1906286 | 2021-11-11 | Gaston | North Carolina | 37071 | 40456 | 627 |
1903037 | 1903037 | 2021-11-10 | Gaston | North Carolina | 37071 | 40456 | 627 |
1899787 | 1899787 | 2021-11-09 | Gaston | North Carolina | 37071 | 40386 | 626 |
1896537 | 1896537 | 2021-11-08 | Gaston | North Carolina | 37071 | 40355 | 626 |
1893287 | 1893287 | 2021-11-07 | Gaston | North Carolina | 37071 | 40243 | 624 |
1890037 | 1890037 | 2021-11-06 | Gaston | North Carolina | 37071 | 40243 | 624 |
1886787 | 1886787 | 2021-11-05 | Gaston | North Carolina | 37071 | 40243 | 624 |
1883538 | 1883538 | 2021-11-04 | Gaston | North Carolina | 37071 | 40208 | 624 |
1880289 | 1880289 | 2021-11-03 | Gaston | North Carolina | 37071 | 40167 | 624 |
1877040 | 1877040 | 2021-11-02 | Gaston | North Carolina | 37071 | 40152 | 622 |
1873791 | 1873791 | 2021-11-01 | Gaston | North Carolina | 37071 | 40131 | 622 |
1870542 | 1870542 | 2021-10-31 | Gaston | North Carolina | 37071 | 40027 | 621 |
1867293 | 1867293 | 2021-10-30 | Gaston | North Carolina | 37071 | 40027 | 621 |
1864044 | 1864044 | 2021-10-29 | Gaston | North Carolina | 37071 | 40027 | 621 |
1860795 | 1860795 | 2021-10-28 | Gaston | North Carolina | 37071 | 39978 | 621 |
1857546 | 1857546 | 2021-10-27 | Gaston | North Carolina | 37071 | 39910 | 615 |
1854297 | 1854297 | 2021-10-26 | Gaston | North Carolina | 37071 | 39877 | 615 |
1851048 | 1851048 | 2021-10-25 | Gaston | North Carolina | 37071 | 39858 | 615 |
1847798 | 1847798 | 2021-10-24 | Gaston | North Carolina | 37071 | 39725 | 609 |
1844548 | 1844548 | 2021-10-23 | Gaston | North Carolina | 37071 | 39725 | 609 |
1841298 | 1841298 | 2021-10-22 | Gaston | North Carolina | 37071 | 39725 | 609 |
1838049 | 1838049 | 2021-10-21 | Gaston | North Carolina | 37071 | 39665 | 603 |
1834800 | 1834800 | 2021-10-20 | Gaston | North Carolina | 37071 | 39611 | 603 |
1831551 | 1831551 | 2021-10-19 | Gaston | North Carolina | 37071 | 39553 | 602 |
1828302 | 1828302 | 2021-10-18 | Gaston | North Carolina | 37071 | 39524 | 602 |
1825053 | 1825053 | 2021-10-17 | Gaston | North Carolina | 37071 | 39320 | 595 |
1821804 | 1821804 | 2021-10-16 | Gaston | North Carolina | 37071 | 39320 | 595 |
1818555 | 1818555 | 2021-10-15 | Gaston | North Carolina | 37071 | 39320 | 595 |
1815306 | 1815306 | 2021-10-14 | Gaston | North Carolina | 37071 | 39208 | 593 |
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 |
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);