ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 37125 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 |
---|---|---|---|---|---|---|---|
1948564 | 1948564 | 2021-11-24 | Moore | North Carolina | 37125 | 13936 | 252 |
1945313 | 1945313 | 2021-11-23 | Moore | North Carolina | 37125 | 13927 | 252 |
1942062 | 1942062 | 2021-11-22 | Moore | North Carolina | 37125 | 13923 | 252 |
1938812 | 1938812 | 2021-11-21 | Moore | North Carolina | 37125 | 13883 | 252 |
1935562 | 1935562 | 2021-11-20 | Moore | North Carolina | 37125 | 13883 | 252 |
1932312 | 1932312 | 2021-11-19 | Moore | North Carolina | 37125 | 13883 | 252 |
1929061 | 1929061 | 2021-11-18 | Moore | North Carolina | 37125 | 13875 | 252 |
1925811 | 1925811 | 2021-11-17 | Moore | North Carolina | 37125 | 13865 | 252 |
1922562 | 1922562 | 2021-11-16 | Moore | North Carolina | 37125 | 13847 | 252 |
1919312 | 1919312 | 2021-11-15 | Moore | North Carolina | 37125 | 13843 | 251 |
1916062 | 1916062 | 2021-11-14 | Moore | North Carolina | 37125 | 13814 | 251 |
1912812 | 1912812 | 2021-11-13 | Moore | North Carolina | 37125 | 13814 | 251 |
1909562 | 1909562 | 2021-11-12 | Moore | North Carolina | 37125 | 13814 | 251 |
1906313 | 1906313 | 2021-11-11 | Moore | North Carolina | 37125 | 13793 | 250 |
1903064 | 1903064 | 2021-11-10 | Moore | North Carolina | 37125 | 13793 | 250 |
1899814 | 1899814 | 2021-11-09 | Moore | North Carolina | 37125 | 13778 | 249 |
1896564 | 1896564 | 2021-11-08 | Moore | North Carolina | 37125 | 13772 | 249 |
1893314 | 1893314 | 2021-11-07 | Moore | North Carolina | 37125 | 13751 | 248 |
1890064 | 1890064 | 2021-11-06 | Moore | North Carolina | 37125 | 13751 | 248 |
1886814 | 1886814 | 2021-11-05 | Moore | North Carolina | 37125 | 13751 | 248 |
1883565 | 1883565 | 2021-11-04 | Moore | North Carolina | 37125 | 13744 | 248 |
1880316 | 1880316 | 2021-11-03 | Moore | North Carolina | 37125 | 13722 | 248 |
1877067 | 1877067 | 2021-11-02 | Moore | North Carolina | 37125 | 13713 | 248 |
1873818 | 1873818 | 2021-11-01 | Moore | North Carolina | 37125 | 13709 | 248 |
1870569 | 1870569 | 2021-10-31 | Moore | North Carolina | 37125 | 13666 | 247 |
1867320 | 1867320 | 2021-10-30 | Moore | North Carolina | 37125 | 13666 | 247 |
1864071 | 1864071 | 2021-10-29 | Moore | North Carolina | 37125 | 13666 | 247 |
1860822 | 1860822 | 2021-10-28 | Moore | North Carolina | 37125 | 13647 | 246 |
1857573 | 1857573 | 2021-10-27 | Moore | North Carolina | 37125 | 13626 | 247 |
1854324 | 1854324 | 2021-10-26 | Moore | North Carolina | 37125 | 13605 | 246 |
1851075 | 1851075 | 2021-10-25 | Moore | North Carolina | 37125 | 13601 | 246 |
1847825 | 1847825 | 2021-10-24 | Moore | North Carolina | 37125 | 13542 | 245 |
1844575 | 1844575 | 2021-10-23 | Moore | North Carolina | 37125 | 13542 | 245 |
1841325 | 1841325 | 2021-10-22 | Moore | North Carolina | 37125 | 13542 | 245 |
1838076 | 1838076 | 2021-10-21 | Moore | North Carolina | 37125 | 13525 | 245 |
1834827 | 1834827 | 2021-10-20 | Moore | North Carolina | 37125 | 13502 | 245 |
1831578 | 1831578 | 2021-10-19 | Moore | North Carolina | 37125 | 13485 | 244 |
1828329 | 1828329 | 2021-10-18 | Moore | North Carolina | 37125 | 13469 | 244 |
1825080 | 1825080 | 2021-10-17 | Moore | North Carolina | 37125 | 13404 | 245 |
1821831 | 1821831 | 2021-10-16 | Moore | North Carolina | 37125 | 13404 | 245 |
1818582 | 1818582 | 2021-10-15 | Moore | North Carolina | 37125 | 13404 | 245 |
1815333 | 1815333 | 2021-10-14 | Moore | North Carolina | 37125 | 13375 | 245 |
1812085 | 1812085 | 2021-10-13 | Moore | North Carolina | 37125 | 13339 | 245 |
1808836 | 1808836 | 2021-10-12 | Moore | North Carolina | 37125 | 13318 | 240 |
1805585 | 1805585 | 2021-10-11 | Moore | North Carolina | 37125 | 13304 | 240 |
1802336 | 1802336 | 2021-10-10 | Moore | North Carolina | 37125 | 13226 | 238 |
1799087 | 1799087 | 2021-10-09 | Moore | North Carolina | 37125 | 13226 | 238 |
1795838 | 1795838 | 2021-10-08 | Moore | North Carolina | 37125 | 13226 | 238 |
1792589 | 1792589 | 2021-10-07 | Moore | North Carolina | 37125 | 13190 | 238 |
1789340 | 1789340 | 2021-10-06 | Moore | North Carolina | 37125 | 13138 | 238 |
1786092 | 1786092 | 2021-10-05 | Moore | North Carolina | 37125 | 13120 | 238 |
1782843 | 1782843 | 2021-10-04 | Moore | North Carolina | 37125 | 13071 | 238 |
1779594 | 1779594 | 2021-10-03 | Moore | North Carolina | 37125 | 13002 | 235 |
1776344 | 1776344 | 2021-10-02 | Moore | North Carolina | 37125 | 13002 | 235 |
1773094 | 1773094 | 2021-10-01 | Moore | North Carolina | 37125 | 13002 | 235 |
1769844 | 1769844 | 2021-09-30 | Moore | North Carolina | 37125 | 12966 | 235 |
1766595 | 1766595 | 2021-09-29 | Moore | North Carolina | 37125 | 12911 | 232 |
1763346 | 1763346 | 2021-09-28 | Moore | North Carolina | 37125 | 12846 | 232 |
1760097 | 1760097 | 2021-09-27 | Moore | North Carolina | 37125 | 12815 | 232 |
1756849 | 1756849 | 2021-09-26 | Moore | North Carolina | 37125 | 12726 | 231 |
1753601 | 1753601 | 2021-09-25 | Moore | North Carolina | 37125 | 12726 | 231 |
1750353 | 1750353 | 2021-09-24 | Moore | North Carolina | 37125 | 12726 | 231 |
1747103 | 1747103 | 2021-09-23 | Moore | North Carolina | 37125 | 12673 | 228 |
1743854 | 1743854 | 2021-09-22 | Moore | North Carolina | 37125 | 12603 | 225 |
1740605 | 1740605 | 2021-09-21 | Moore | North Carolina | 37125 | 12542 | 224 |
1737356 | 1737356 | 2021-09-20 | Moore | North Carolina | 37125 | 12479 | 223 |
1734106 | 1734106 | 2021-09-19 | Moore | North Carolina | 37125 | 12337 | 222 |
1730856 | 1730856 | 2021-09-18 | Moore | North Carolina | 37125 | 12337 | 222 |
1727606 | 1727606 | 2021-09-17 | Moore | North Carolina | 37125 | 12337 | 222 |
1724357 | 1724357 | 2021-09-16 | Moore | North Carolina | 37125 | 12241 | 222 |
1721108 | 1721108 | 2021-09-15 | Moore | North Carolina | 37125 | 12165 | 222 |
1717860 | 1717860 | 2021-09-14 | Moore | North Carolina | 37125 | 12094 | 222 |
1714612 | 1714612 | 2021-09-13 | Moore | North Carolina | 37125 | 12057 | 222 |
1711366 | 1711366 | 2021-09-12 | Moore | North Carolina | 37125 | 11824 | 221 |
1708119 | 1708119 | 2021-09-11 | Moore | North Carolina | 37125 | 11824 | 221 |
1704872 | 1704872 | 2021-09-10 | Moore | North Carolina | 37125 | 11824 | 221 |
1701622 | 1701622 | 2021-09-09 | Moore | North Carolina | 37125 | 11763 | 218 |
1698373 | 1698373 | 2021-09-08 | Moore | North Carolina | 37125 | 11687 | 218 |
1695125 | 1695125 | 2021-09-07 | Moore | North Carolina | 37125 | 11619 | 218 |
1691877 | 1691877 | 2021-09-06 | Moore | North Carolina | 37125 | 11406 | 218 |
1688627 | 1688627 | 2021-09-05 | Moore | North Carolina | 37125 | 11406 | 218 |
1685377 | 1685377 | 2021-09-04 | Moore | North Carolina | 37125 | 11406 | 218 |
1682126 | 1682126 | 2021-09-03 | Moore | North Carolina | 37125 | 11406 | 218 |
1678877 | 1678877 | 2021-09-02 | Moore | North Carolina | 37125 | 11299 | 213 |
1675629 | 1675629 | 2021-09-01 | Moore | North Carolina | 37125 | 11240 | 209 |
1672382 | 1672382 | 2021-08-31 | Moore | North Carolina | 37125 | 11176 | 209 |
1669134 | 1669134 | 2021-08-30 | Moore | North Carolina | 37125 | 11123 | 209 |
1665887 | 1665887 | 2021-08-29 | Moore | North Carolina | 37125 | 10940 | 209 |
1662639 | 1662639 | 2021-08-28 | Moore | North Carolina | 37125 | 10940 | 209 |
1659391 | 1659391 | 2021-08-27 | Moore | North Carolina | 37125 | 10940 | 209 |
1656142 | 1656142 | 2021-08-26 | Moore | North Carolina | 37125 | 10875 | 209 |
1652895 | 1652895 | 2021-08-25 | Moore | North Carolina | 37125 | 10794 | 208 |
1649647 | 1649647 | 2021-08-24 | Moore | North Carolina | 37125 | 10752 | 207 |
1646398 | 1646398 | 2021-08-23 | Moore | North Carolina | 37125 | 10711 | 207 |
1643149 | 1643149 | 2021-08-22 | Moore | North Carolina | 37125 | 10528 | 204 |
1639899 | 1639899 | 2021-08-21 | Moore | North Carolina | 37125 | 10528 | 204 |
1636649 | 1636649 | 2021-08-20 | Moore | North Carolina | 37125 | 10528 | 204 |
1633399 | 1633399 | 2021-08-19 | Moore | North Carolina | 37125 | 10452 | 204 |
1630152 | 1630152 | 2021-08-18 | Moore | North Carolina | 37125 | 10337 | 200 |
1626905 | 1626905 | 2021-08-17 | Moore | North Carolina | 37125 | 10283 | 199 |
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);