ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Macon" 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 |
---|---|---|---|---|---|---|---|
2111091 | 2111091 | 2022-01-13 | Macon | North Carolina | 37113 | 5856 | 88 |
2107839 | 2107839 | 2022-01-12 | Macon | North Carolina | 37113 | 5835 | 88 |
2104588 | 2104588 | 2022-01-11 | Macon | North Carolina | 37113 | 5791 | 87 |
2101337 | 2101337 | 2022-01-10 | Macon | North Carolina | 37113 | 5752 | 87 |
2098086 | 2098086 | 2022-01-09 | Macon | North Carolina | 37113 | 5656 | 87 |
2094834 | 2094834 | 2022-01-08 | Macon | North Carolina | 37113 | 5656 | 87 |
2091582 | 2091582 | 2022-01-07 | Macon | North Carolina | 37113 | 5656 | 87 |
2088331 | 2088331 | 2022-01-06 | Macon | North Carolina | 37113 | 5581 | 87 |
2085079 | 2085079 | 2022-01-05 | Macon | North Carolina | 37113 | 5560 | 87 |
2081827 | 2081827 | 2022-01-04 | Macon | North Carolina | 37113 | 5518 | 87 |
2078575 | 2078575 | 2022-01-03 | Macon | North Carolina | 37113 | 5496 | 87 |
2075324 | 2075324 | 2022-01-02 | Macon | North Carolina | 37113 | 5426 | 87 |
2072073 | 2072073 | 2022-01-01 | Macon | North Carolina | 37113 | 5426 | 87 |
2068822 | 2068822 | 2021-12-31 | Macon | North Carolina | 37113 | 5426 | 87 |
2065571 | 2065571 | 2021-12-30 | Macon | North Carolina | 37113 | 5388 | 87 |
2062321 | 2062321 | 2021-12-29 | Macon | North Carolina | 37113 | 5360 | 87 |
2059072 | 2059072 | 2021-12-28 | Macon | North Carolina | 37113 | 5336 | 87 |
2055823 | 2055823 | 2021-12-27 | Macon | North Carolina | 37113 | 5261 | 87 |
2052573 | 2052573 | 2021-12-26 | Macon | North Carolina | 37113 | 5261 | 87 |
2049323 | 2049323 | 2021-12-25 | Macon | North Carolina | 37113 | 5261 | 87 |
2046073 | 2046073 | 2021-12-24 | Macon | North Carolina | 37113 | 5261 | 87 |
2042823 | 2042823 | 2021-12-23 | Macon | North Carolina | 37113 | 5261 | 87 |
2039574 | 2039574 | 2021-12-22 | Macon | North Carolina | 37113 | 5261 | 87 |
2036324 | 2036324 | 2021-12-21 | Macon | North Carolina | 37113 | 5260 | 87 |
2033074 | 2033074 | 2021-12-20 | Macon | North Carolina | 37113 | 5254 | 87 |
2029824 | 2029824 | 2021-12-19 | Macon | North Carolina | 37113 | 5238 | 87 |
2026573 | 2026573 | 2021-12-18 | Macon | North Carolina | 37113 | 5238 | 87 |
2023322 | 2023322 | 2021-12-17 | Macon | North Carolina | 37113 | 5238 | 87 |
2020071 | 2020071 | 2021-12-16 | Macon | North Carolina | 37113 | 5229 | 87 |
2016820 | 2016820 | 2021-12-15 | Macon | North Carolina | 37113 | 5226 | 86 |
2013570 | 2013570 | 2021-12-14 | Macon | North Carolina | 37113 | 5218 | 85 |
2010319 | 2010319 | 2021-12-13 | Macon | North Carolina | 37113 | 5216 | 85 |
2007068 | 2007068 | 2021-12-12 | Macon | North Carolina | 37113 | 5202 | 85 |
2003817 | 2003817 | 2021-12-11 | Macon | North Carolina | 37113 | 5202 | 85 |
2000566 | 2000566 | 2021-12-10 | Macon | North Carolina | 37113 | 5202 | 85 |
1997316 | 1997316 | 2021-12-09 | Macon | North Carolina | 37113 | 5188 | 85 |
1994065 | 1994065 | 2021-12-08 | Macon | North Carolina | 37113 | 5173 | 85 |
1990814 | 1990814 | 2021-12-07 | Macon | North Carolina | 37113 | 5161 | 80 |
1987563 | 1987563 | 2021-12-06 | Macon | North Carolina | 37113 | 5161 | 80 |
1984313 | 1984313 | 2021-12-05 | Macon | North Carolina | 37113 | 5139 | 80 |
1981063 | 1981063 | 2021-12-04 | Macon | North Carolina | 37113 | 5139 | 80 |
1977813 | 1977813 | 2021-12-03 | Macon | North Carolina | 37113 | 5139 | 80 |
1974563 | 1974563 | 2021-12-02 | Macon | North Carolina | 37113 | 5134 | 80 |
1971314 | 1971314 | 2021-12-01 | Macon | North Carolina | 37113 | 5129 | 80 |
1968064 | 1968064 | 2021-11-30 | Macon | North Carolina | 37113 | 5121 | 80 |
1964813 | 1964813 | 2021-11-29 | Macon | North Carolina | 37113 | 5121 | 80 |
1961561 | 1961561 | 2021-11-28 | Macon | North Carolina | 37113 | 5111 | 80 |
1958310 | 1958310 | 2021-11-27 | Macon | North Carolina | 37113 | 5111 | 80 |
1955059 | 1955059 | 2021-11-26 | Macon | North Carolina | 37113 | 5111 | 80 |
1951808 | 1951808 | 2021-11-25 | Macon | North Carolina | 37113 | 5111 | 80 |
1948557 | 1948557 | 2021-11-24 | Macon | North Carolina | 37113 | 5111 | 80 |
1945306 | 1945306 | 2021-11-23 | Macon | North Carolina | 37113 | 5110 | 77 |
1942055 | 1942055 | 2021-11-22 | Macon | North Carolina | 37113 | 5104 | 77 |
1938805 | 1938805 | 2021-11-21 | Macon | North Carolina | 37113 | 5096 | 77 |
1935555 | 1935555 | 2021-11-20 | Macon | North Carolina | 37113 | 5096 | 77 |
1932305 | 1932305 | 2021-11-19 | Macon | North Carolina | 37113 | 5096 | 77 |
1929054 | 1929054 | 2021-11-18 | Macon | North Carolina | 37113 | 5092 | 75 |
1925804 | 1925804 | 2021-11-17 | Macon | North Carolina | 37113 | 5086 | 75 |
1922555 | 1922555 | 2021-11-16 | Macon | North Carolina | 37113 | 5079 | 75 |
1919305 | 1919305 | 2021-11-15 | Macon | North Carolina | 37113 | 5076 | 74 |
1916055 | 1916055 | 2021-11-14 | Macon | North Carolina | 37113 | 5057 | 74 |
1912805 | 1912805 | 2021-11-13 | Macon | North Carolina | 37113 | 5057 | 74 |
1909555 | 1909555 | 2021-11-12 | Macon | North Carolina | 37113 | 5057 | 74 |
1906306 | 1906306 | 2021-11-11 | Macon | North Carolina | 37113 | 5046 | 74 |
1903057 | 1903057 | 2021-11-10 | Macon | North Carolina | 37113 | 5046 | 74 |
1899807 | 1899807 | 2021-11-09 | Macon | North Carolina | 37113 | 5039 | 73 |
1896557 | 1896557 | 2021-11-08 | Macon | North Carolina | 37113 | 5037 | 73 |
1893307 | 1893307 | 2021-11-07 | Macon | North Carolina | 37113 | 5018 | 71 |
1890057 | 1890057 | 2021-11-06 | Macon | North Carolina | 37113 | 5018 | 71 |
1886807 | 1886807 | 2021-11-05 | Macon | North Carolina | 37113 | 5018 | 71 |
1883558 | 1883558 | 2021-11-04 | Macon | North Carolina | 37113 | 5012 | 71 |
1880309 | 1880309 | 2021-11-03 | Macon | North Carolina | 37113 | 5004 | 71 |
1877060 | 1877060 | 2021-11-02 | Macon | North Carolina | 37113 | 4993 | 71 |
1873811 | 1873811 | 2021-11-01 | Macon | North Carolina | 37113 | 4989 | 71 |
1870562 | 1870562 | 2021-10-31 | Macon | North Carolina | 37113 | 4970 | 69 |
1867313 | 1867313 | 2021-10-30 | Macon | North Carolina | 37113 | 4970 | 69 |
1864064 | 1864064 | 2021-10-29 | Macon | North Carolina | 37113 | 4970 | 69 |
1860815 | 1860815 | 2021-10-28 | Macon | North Carolina | 37113 | 4962 | 69 |
1857566 | 1857566 | 2021-10-27 | Macon | North Carolina | 37113 | 4951 | 69 |
1854317 | 1854317 | 2021-10-26 | Macon | North Carolina | 37113 | 4942 | 67 |
1851068 | 1851068 | 2021-10-25 | Macon | North Carolina | 37113 | 4939 | 67 |
1847818 | 1847818 | 2021-10-24 | Macon | North Carolina | 37113 | 4924 | 67 |
1844568 | 1844568 | 2021-10-23 | Macon | North Carolina | 37113 | 4924 | 67 |
1841318 | 1841318 | 2021-10-22 | Macon | North Carolina | 37113 | 4924 | 67 |
1838069 | 1838069 | 2021-10-21 | Macon | North Carolina | 37113 | 4911 | 57 |
1834820 | 1834820 | 2021-10-20 | Macon | North Carolina | 37113 | 4896 | 54 |
1831571 | 1831571 | 2021-10-19 | Macon | North Carolina | 37113 | 4890 | 54 |
1828322 | 1828322 | 2021-10-18 | Macon | North Carolina | 37113 | 4884 | 54 |
1825073 | 1825073 | 2021-10-17 | Macon | North Carolina | 37113 | 4867 | 54 |
1821824 | 1821824 | 2021-10-16 | Macon | North Carolina | 37113 | 4867 | 54 |
1818575 | 1818575 | 2021-10-15 | Macon | North Carolina | 37113 | 4867 | 54 |
1815326 | 1815326 | 2021-10-14 | Macon | North Carolina | 37113 | 4848 | 54 |
1812078 | 1812078 | 2021-10-13 | Macon | North Carolina | 37113 | 4832 | 54 |
1808829 | 1808829 | 2021-10-12 | Macon | North Carolina | 37113 | 4824 | 54 |
1805578 | 1805578 | 2021-10-11 | Macon | North Carolina | 37113 | 4813 | 54 |
1802329 | 1802329 | 2021-10-10 | Macon | North Carolina | 37113 | 4760 | 54 |
1799080 | 1799080 | 2021-10-09 | Macon | North Carolina | 37113 | 4760 | 54 |
1795831 | 1795831 | 2021-10-08 | Macon | North Carolina | 37113 | 4760 | 54 |
1792582 | 1792582 | 2021-10-07 | Macon | North Carolina | 37113 | 4741 | 54 |
1789333 | 1789333 | 2021-10-06 | Macon | North Carolina | 37113 | 4727 | 54 |
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);