ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Moore" 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 |
---|---|---|---|---|---|---|---|
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 |
1623658 | 1623658 | 2021-08-16 | Moore | North Carolina | 37125 | 10239 | 197 |
1620411 | 1620411 | 2021-08-15 | Moore | North Carolina | 37125 | 10088 | 197 |
1617163 | 1617163 | 2021-08-14 | Moore | North Carolina | 37125 | 10088 | 197 |
1613915 | 1613915 | 2021-08-13 | Moore | North Carolina | 37125 | 10088 | 197 |
1610666 | 1610666 | 2021-08-12 | Moore | North Carolina | 37125 | 10004 | 197 |
1607418 | 1607418 | 2021-08-11 | Moore | North Carolina | 37125 | 9926 | 197 |
1604169 | 1604169 | 2021-08-10 | Moore | North Carolina | 37125 | 9862 | 197 |
1600920 | 1600920 | 2021-08-09 | Moore | North Carolina | 37125 | 9830 | 197 |
1597672 | 1597672 | 2021-08-08 | Moore | North Carolina | 37125 | 9671 | 196 |
1594423 | 1594423 | 2021-08-07 | Moore | North Carolina | 37125 | 9671 | 196 |
1591174 | 1591174 | 2021-08-06 | Moore | North Carolina | 37125 | 9671 | 196 |
1587925 | 1587925 | 2021-08-05 | Moore | North Carolina | 37125 | 9611 | 196 |
1584675 | 1584675 | 2021-08-04 | Moore | North Carolina | 37125 | 9573 | 196 |
1581425 | 1581425 | 2021-08-03 | Moore | North Carolina | 37125 | 9538 | 196 |
1578176 | 1578176 | 2021-08-02 | Moore | North Carolina | 37125 | 9498 | 196 |
1574928 | 1574928 | 2021-08-01 | Moore | North Carolina | 37125 | 9421 | 196 |
1571680 | 1571680 | 2021-07-31 | Moore | North Carolina | 37125 | 9421 | 196 |
1568432 | 1568432 | 2021-07-30 | Moore | North Carolina | 37125 | 9421 | 196 |
1565184 | 1565184 | 2021-07-29 | Moore | North Carolina | 37125 | 9391 | 196 |
1561936 | 1561936 | 2021-07-28 | Moore | North Carolina | 37125 | 9351 | 196 |
1558688 | 1558688 | 2021-07-27 | Moore | North Carolina | 37125 | 9316 | 195 |
1555441 | 1555441 | 2021-07-26 | Moore | North Carolina | 37125 | 9304 | 195 |
1552194 | 1552194 | 2021-07-25 | Moore | North Carolina | 37125 | 9240 | 195 |
1548947 | 1548947 | 2021-07-24 | Moore | North Carolina | 37125 | 9240 | 195 |
1545700 | 1545700 | 2021-07-23 | Moore | North Carolina | 37125 | 9240 | 195 |
1542453 | 1542453 | 2021-07-22 | Moore | North Carolina | 37125 | 9221 | 195 |
1539205 | 1539205 | 2021-07-21 | Moore | North Carolina | 37125 | 9199 | 195 |
1535958 | 1535958 | 2021-07-20 | Moore | North Carolina | 37125 | 9176 | 195 |
1532710 | 1532710 | 2021-07-19 | Moore | North Carolina | 37125 | 9166 | 195 |
1529463 | 1529463 | 2021-07-18 | Moore | North Carolina | 37125 | 9138 | 195 |
1526216 | 1526216 | 2021-07-17 | Moore | North Carolina | 37125 | 9138 | 195 |
1522969 | 1522969 | 2021-07-16 | Moore | North Carolina | 37125 | 9138 | 195 |
1519721 | 1519721 | 2021-07-15 | Moore | North Carolina | 37125 | 9124 | 195 |
1516473 | 1516473 | 2021-07-14 | Moore | North Carolina | 37125 | 9113 | 195 |
1513226 | 1513226 | 2021-07-13 | Moore | North Carolina | 37125 | 9107 | 195 |
1509980 | 1509980 | 2021-07-12 | Moore | North Carolina | 37125 | 9101 | 195 |
1506733 | 1506733 | 2021-07-11 | Moore | North Carolina | 37125 | 9089 | 195 |
1503487 | 1503487 | 2021-07-10 | Moore | North Carolina | 37125 | 9089 | 195 |
1500241 | 1500241 | 2021-07-09 | Moore | North Carolina | 37125 | 9089 | 195 |
1496995 | 1496995 | 2021-07-08 | Moore | North Carolina | 37125 | 9088 | 194 |
1493748 | 1493748 | 2021-07-07 | Moore | North Carolina | 37125 | 9080 | 194 |
1490501 | 1490501 | 2021-07-06 | Moore | North Carolina | 37125 | 9077 | 194 |
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);