ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948517 | 1948517 | 2021-11-24 | Carteret | North Carolina | 37031 | 8697 | 83 |
1945266 | 1945266 | 2021-11-23 | Carteret | North Carolina | 37031 | 8673 | 83 |
1942015 | 1942015 | 2021-11-22 | Carteret | North Carolina | 37031 | 8666 | 83 |
1938765 | 1938765 | 2021-11-21 | Carteret | North Carolina | 37031 | 8627 | 83 |
1935515 | 1935515 | 2021-11-20 | Carteret | North Carolina | 37031 | 8627 | 83 |
1932265 | 1932265 | 2021-11-19 | Carteret | North Carolina | 37031 | 8627 | 83 |
1929014 | 1929014 | 2021-11-18 | Carteret | North Carolina | 37031 | 8619 | 83 |
1925764 | 1925764 | 2021-11-17 | Carteret | North Carolina | 37031 | 8575 | 83 |
1922515 | 1922515 | 2021-11-16 | Carteret | North Carolina | 37031 | 8562 | 83 |
1919265 | 1919265 | 2021-11-15 | Carteret | North Carolina | 37031 | 8558 | 83 |
1916015 | 1916015 | 2021-11-14 | Carteret | North Carolina | 37031 | 8519 | 83 |
1912765 | 1912765 | 2021-11-13 | Carteret | North Carolina | 37031 | 8519 | 83 |
1909515 | 1909515 | 2021-11-12 | Carteret | North Carolina | 37031 | 8519 | 83 |
1906266 | 1906266 | 2021-11-11 | Carteret | North Carolina | 37031 | 8497 | 83 |
1903017 | 1903017 | 2021-11-10 | Carteret | North Carolina | 37031 | 8497 | 83 |
1899767 | 1899767 | 2021-11-09 | Carteret | North Carolina | 37031 | 8482 | 83 |
1896517 | 1896517 | 2021-11-08 | Carteret | North Carolina | 37031 | 8473 | 83 |
1893267 | 1893267 | 2021-11-07 | Carteret | North Carolina | 37031 | 8448 | 83 |
1890017 | 1890017 | 2021-11-06 | Carteret | North Carolina | 37031 | 8448 | 83 |
1886767 | 1886767 | 2021-11-05 | Carteret | North Carolina | 37031 | 8448 | 83 |
1883518 | 1883518 | 2021-11-04 | Carteret | North Carolina | 37031 | 8446 | 83 |
1880269 | 1880269 | 2021-11-03 | Carteret | North Carolina | 37031 | 8437 | 83 |
1877020 | 1877020 | 2021-11-02 | Carteret | North Carolina | 37031 | 8416 | 83 |
1873771 | 1873771 | 2021-11-01 | Carteret | North Carolina | 37031 | 8409 | 83 |
1870522 | 1870522 | 2021-10-31 | Carteret | North Carolina | 37031 | 8377 | 83 |
1867273 | 1867273 | 2021-10-30 | Carteret | North Carolina | 37031 | 8377 | 83 |
1864024 | 1864024 | 2021-10-29 | Carteret | North Carolina | 37031 | 8377 | 83 |
1860775 | 1860775 | 2021-10-28 | Carteret | North Carolina | 37031 | 8362 | 83 |
1857526 | 1857526 | 2021-10-27 | Carteret | North Carolina | 37031 | 8355 | 83 |
1854277 | 1854277 | 2021-10-26 | Carteret | North Carolina | 37031 | 8343 | 83 |
1851028 | 1851028 | 2021-10-25 | Carteret | North Carolina | 37031 | 8332 | 83 |
1847778 | 1847778 | 2021-10-24 | Carteret | North Carolina | 37031 | 8296 | 83 |
1844528 | 1844528 | 2021-10-23 | Carteret | North Carolina | 37031 | 8296 | 83 |
1841278 | 1841278 | 2021-10-22 | Carteret | North Carolina | 37031 | 8296 | 83 |
1838029 | 1838029 | 2021-10-21 | Carteret | North Carolina | 37031 | 8282 | 83 |
1834780 | 1834780 | 2021-10-20 | Carteret | North Carolina | 37031 | 8269 | 83 |
1831531 | 1831531 | 2021-10-19 | Carteret | North Carolina | 37031 | 8242 | 83 |
1828282 | 1828282 | 2021-10-18 | Carteret | North Carolina | 37031 | 8227 | 83 |
1825033 | 1825033 | 2021-10-17 | Carteret | North Carolina | 37031 | 8194 | 81 |
1821784 | 1821784 | 2021-10-16 | Carteret | North Carolina | 37031 | 8194 | 81 |
1818535 | 1818535 | 2021-10-15 | Carteret | North Carolina | 37031 | 8194 | 81 |
1815286 | 1815286 | 2021-10-14 | Carteret | North Carolina | 37031 | 8167 | 81 |
1812038 | 1812038 | 2021-10-13 | Carteret | North Carolina | 37031 | 8144 | 79 |
1808789 | 1808789 | 2021-10-12 | Carteret | North Carolina | 37031 | 8110 | 76 |
1805538 | 1805538 | 2021-10-11 | Carteret | North Carolina | 37031 | 8081 | 76 |
1802289 | 1802289 | 2021-10-10 | Carteret | North Carolina | 37031 | 8017 | 71 |
1799040 | 1799040 | 2021-10-09 | Carteret | North Carolina | 37031 | 8017 | 71 |
1795791 | 1795791 | 2021-10-08 | Carteret | North Carolina | 37031 | 8017 | 71 |
1792542 | 1792542 | 2021-10-07 | Carteret | North Carolina | 37031 | 7984 | 58 |
1789293 | 1789293 | 2021-10-06 | Carteret | North Carolina | 37031 | 7964 | 58 |
1786045 | 1786045 | 2021-10-05 | Carteret | North Carolina | 37031 | 7936 | 58 |
1782796 | 1782796 | 2021-10-04 | Carteret | North Carolina | 37031 | 7907 | 58 |
1779547 | 1779547 | 2021-10-03 | Carteret | North Carolina | 37031 | 7817 | 58 |
1776297 | 1776297 | 2021-10-02 | Carteret | North Carolina | 37031 | 7817 | 58 |
1773047 | 1773047 | 2021-10-01 | Carteret | North Carolina | 37031 | 7817 | 58 |
1769797 | 1769797 | 2021-09-30 | Carteret | North Carolina | 37031 | 7802 | 58 |
1766548 | 1766548 | 2021-09-29 | Carteret | North Carolina | 37031 | 7777 | 58 |
1763299 | 1763299 | 2021-09-28 | Carteret | North Carolina | 37031 | 7740 | 58 |
1760050 | 1760050 | 2021-09-27 | Carteret | North Carolina | 37031 | 7711 | 58 |
1756802 | 1756802 | 2021-09-26 | Carteret | North Carolina | 37031 | 7614 | 58 |
1753554 | 1753554 | 2021-09-25 | Carteret | North Carolina | 37031 | 7614 | 58 |
1750306 | 1750306 | 2021-09-24 | Carteret | North Carolina | 37031 | 7614 | 58 |
1747056 | 1747056 | 2021-09-23 | Carteret | North Carolina | 37031 | 7562 | 58 |
1743807 | 1743807 | 2021-09-22 | Carteret | North Carolina | 37031 | 7499 | 58 |
1740558 | 1740558 | 2021-09-21 | Carteret | North Carolina | 37031 | 7445 | 58 |
1737309 | 1737309 | 2021-09-20 | Carteret | North Carolina | 37031 | 7427 | 58 |
1734059 | 1734059 | 2021-09-19 | Carteret | North Carolina | 37031 | 7335 | 58 |
1730809 | 1730809 | 2021-09-18 | Carteret | North Carolina | 37031 | 7335 | 58 |
1727559 | 1727559 | 2021-09-17 | Carteret | North Carolina | 37031 | 7335 | 58 |
1724310 | 1724310 | 2021-09-16 | Carteret | North Carolina | 37031 | 7263 | 58 |
1721061 | 1721061 | 2021-09-15 | Carteret | North Carolina | 37031 | 7230 | 58 |
1717813 | 1717813 | 2021-09-14 | Carteret | North Carolina | 37031 | 7110 | 58 |
1714565 | 1714565 | 2021-09-13 | Carteret | North Carolina | 37031 | 7063 | 58 |
1711319 | 1711319 | 2021-09-12 | Carteret | North Carolina | 37031 | 6900 | 58 |
1708072 | 1708072 | 2021-09-11 | Carteret | North Carolina | 37031 | 6900 | 58 |
1704825 | 1704825 | 2021-09-10 | Carteret | North Carolina | 37031 | 6900 | 58 |
1701575 | 1701575 | 2021-09-09 | Carteret | North Carolina | 37031 | 6845 | 58 |
1698326 | 1698326 | 2021-09-08 | Carteret | North Carolina | 37031 | 6854 | 58 |
1695078 | 1695078 | 2021-09-07 | Carteret | North Carolina | 37031 | 6791 | 58 |
1691830 | 1691830 | 2021-09-06 | Carteret | North Carolina | 37031 | 6642 | 58 |
1688580 | 1688580 | 2021-09-05 | Carteret | North Carolina | 37031 | 6642 | 58 |
1685330 | 1685330 | 2021-09-04 | Carteret | North Carolina | 37031 | 6642 | 58 |
1682079 | 1682079 | 2021-09-03 | Carteret | North Carolina | 37031 | 6642 | 58 |
1678830 | 1678830 | 2021-09-02 | Carteret | North Carolina | 37031 | 6616 | 58 |
1675582 | 1675582 | 2021-09-01 | Carteret | North Carolina | 37031 | 6557 | 58 |
1672335 | 1672335 | 2021-08-31 | Carteret | North Carolina | 37031 | 6508 | 58 |
1669087 | 1669087 | 2021-08-30 | Carteret | North Carolina | 37031 | 6472 | 58 |
1665840 | 1665840 | 2021-08-29 | Carteret | North Carolina | 37031 | 6357 | 58 |
1662592 | 1662592 | 2021-08-28 | Carteret | North Carolina | 37031 | 6357 | 58 |
1659344 | 1659344 | 2021-08-27 | Carteret | North Carolina | 37031 | 6357 | 58 |
1656095 | 1656095 | 2021-08-26 | Carteret | North Carolina | 37031 | 6324 | 58 |
1652848 | 1652848 | 2021-08-25 | Carteret | North Carolina | 37031 | 6248 | 57 |
1649600 | 1649600 | 2021-08-24 | Carteret | North Carolina | 37031 | 6230 | 57 |
1646351 | 1646351 | 2021-08-23 | Carteret | North Carolina | 37031 | 6206 | 57 |
1643102 | 1643102 | 2021-08-22 | Carteret | North Carolina | 37031 | 6125 | 57 |
1639852 | 1639852 | 2021-08-21 | Carteret | North Carolina | 37031 | 6125 | 57 |
1636602 | 1636602 | 2021-08-20 | Carteret | North Carolina | 37031 | 6125 | 57 |
1633352 | 1633352 | 2021-08-19 | Carteret | North Carolina | 37031 | 6067 | 57 |
1630105 | 1630105 | 2021-08-18 | Carteret | North Carolina | 37031 | 6010 | 57 |
1626858 | 1626858 | 2021-08-17 | Carteret | North Carolina | 37031 | 5939 | 57 |
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);