ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Anson" 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 |
---|---|---|---|---|---|---|---|
2111039 | 2111039 | 2022-01-13 | Anson | North Carolina | 37007 | 4915 | 86 |
2107787 | 2107787 | 2022-01-12 | Anson | North Carolina | 37007 | 4733 | 86 |
2104536 | 2104536 | 2022-01-11 | Anson | North Carolina | 37007 | 4681 | 86 |
2101285 | 2101285 | 2022-01-10 | Anson | North Carolina | 37007 | 4655 | 86 |
2098034 | 2098034 | 2022-01-09 | Anson | North Carolina | 37007 | 4537 | 86 |
2094782 | 2094782 | 2022-01-08 | Anson | North Carolina | 37007 | 4537 | 86 |
2091530 | 2091530 | 2022-01-07 | Anson | North Carolina | 37007 | 4537 | 86 |
2088279 | 2088279 | 2022-01-06 | Anson | North Carolina | 37007 | 4485 | 86 |
2085027 | 2085027 | 2022-01-05 | Anson | North Carolina | 37007 | 4440 | 86 |
2081775 | 2081775 | 2022-01-04 | Anson | North Carolina | 37007 | 4361 | 86 |
2078523 | 2078523 | 2022-01-03 | Anson | North Carolina | 37007 | 4331 | 86 |
2075272 | 2075272 | 2022-01-02 | Anson | North Carolina | 37007 | 4272 | 86 |
2072021 | 2072021 | 2022-01-01 | Anson | North Carolina | 37007 | 4272 | 86 |
2068770 | 2068770 | 2021-12-31 | Anson | North Carolina | 37007 | 4272 | 86 |
2065519 | 2065519 | 2021-12-30 | Anson | North Carolina | 37007 | 4249 | 85 |
2062269 | 2062269 | 2021-12-29 | Anson | North Carolina | 37007 | 4217 | 85 |
2059020 | 2059020 | 2021-12-28 | Anson | North Carolina | 37007 | 4204 | 85 |
2055771 | 2055771 | 2021-12-27 | Anson | North Carolina | 37007 | 4144 | 85 |
2052521 | 2052521 | 2021-12-26 | Anson | North Carolina | 37007 | 4144 | 85 |
2049271 | 2049271 | 2021-12-25 | Anson | North Carolina | 37007 | 4144 | 85 |
2046021 | 2046021 | 2021-12-24 | Anson | North Carolina | 37007 | 4144 | 85 |
2042771 | 2042771 | 2021-12-23 | Anson | North Carolina | 37007 | 4144 | 85 |
2039522 | 2039522 | 2021-12-22 | Anson | North Carolina | 37007 | 4144 | 85 |
2036272 | 2036272 | 2021-12-21 | Anson | North Carolina | 37007 | 4137 | 85 |
2033022 | 2033022 | 2021-12-20 | Anson | North Carolina | 37007 | 4133 | 85 |
2029772 | 2029772 | 2021-12-19 | Anson | North Carolina | 37007 | 4117 | 84 |
2026521 | 2026521 | 2021-12-18 | Anson | North Carolina | 37007 | 4117 | 84 |
2023270 | 2023270 | 2021-12-17 | Anson | North Carolina | 37007 | 4117 | 84 |
2020019 | 2020019 | 2021-12-16 | Anson | North Carolina | 37007 | 4107 | 84 |
2016768 | 2016768 | 2021-12-15 | Anson | North Carolina | 37007 | 4104 | 84 |
2013518 | 2013518 | 2021-12-14 | Anson | North Carolina | 37007 | 4100 | 84 |
2010267 | 2010267 | 2021-12-13 | Anson | North Carolina | 37007 | 4098 | 83 |
2007016 | 2007016 | 2021-12-12 | Anson | North Carolina | 37007 | 4083 | 83 |
2003765 | 2003765 | 2021-12-11 | Anson | North Carolina | 37007 | 4083 | 83 |
2000514 | 2000514 | 2021-12-10 | Anson | North Carolina | 37007 | 4083 | 83 |
1997264 | 1997264 | 2021-12-09 | Anson | North Carolina | 37007 | 4076 | 83 |
1994013 | 1994013 | 2021-12-08 | Anson | North Carolina | 37007 | 4072 | 83 |
1990762 | 1990762 | 2021-12-07 | Anson | North Carolina | 37007 | 4064 | 83 |
1987511 | 1987511 | 2021-12-06 | Anson | North Carolina | 37007 | 4065 | 83 |
1984261 | 1984261 | 2021-12-05 | Anson | North Carolina | 37007 | 4052 | 83 |
1981011 | 1981011 | 2021-12-04 | Anson | North Carolina | 37007 | 4052 | 83 |
1977761 | 1977761 | 2021-12-03 | Anson | North Carolina | 37007 | 4052 | 83 |
1974511 | 1974511 | 2021-12-02 | Anson | North Carolina | 37007 | 4042 | 83 |
1971262 | 1971262 | 2021-12-01 | Anson | North Carolina | 37007 | 4031 | 83 |
1968012 | 1968012 | 2021-11-30 | Anson | North Carolina | 37007 | 4029 | 83 |
1964761 | 1964761 | 2021-11-29 | Anson | North Carolina | 37007 | 4030 | 83 |
1961509 | 1961509 | 2021-11-28 | Anson | North Carolina | 37007 | 4016 | 83 |
1958258 | 1958258 | 2021-11-27 | Anson | North Carolina | 37007 | 4016 | 83 |
1955007 | 1955007 | 2021-11-26 | Anson | North Carolina | 37007 | 4016 | 83 |
1951756 | 1951756 | 2021-11-25 | Anson | North Carolina | 37007 | 4016 | 83 |
1948505 | 1948505 | 2021-11-24 | Anson | North Carolina | 37007 | 4016 | 83 |
1945254 | 1945254 | 2021-11-23 | Anson | North Carolina | 37007 | 4010 | 83 |
1942003 | 1942003 | 2021-11-22 | Anson | North Carolina | 37007 | 4005 | 82 |
1938753 | 1938753 | 2021-11-21 | Anson | North Carolina | 37007 | 3990 | 82 |
1935503 | 1935503 | 2021-11-20 | Anson | North Carolina | 37007 | 3990 | 82 |
1932253 | 1932253 | 2021-11-19 | Anson | North Carolina | 37007 | 3990 | 82 |
1929002 | 1929002 | 2021-11-18 | Anson | North Carolina | 37007 | 3989 | 82 |
1925752 | 1925752 | 2021-11-17 | Anson | North Carolina | 37007 | 3985 | 82 |
1922503 | 1922503 | 2021-11-16 | Anson | North Carolina | 37007 | 3984 | 82 |
1919253 | 1919253 | 2021-11-15 | Anson | North Carolina | 37007 | 3983 | 82 |
1916003 | 1916003 | 2021-11-14 | Anson | North Carolina | 37007 | 3963 | 82 |
1912753 | 1912753 | 2021-11-13 | Anson | North Carolina | 37007 | 3963 | 82 |
1909503 | 1909503 | 2021-11-12 | Anson | North Carolina | 37007 | 3963 | 82 |
1906254 | 1906254 | 2021-11-11 | Anson | North Carolina | 37007 | 3941 | 81 |
1903005 | 1903005 | 2021-11-10 | Anson | North Carolina | 37007 | 3941 | 81 |
1899755 | 1899755 | 2021-11-09 | Anson | North Carolina | 37007 | 3933 | 81 |
1896505 | 1896505 | 2021-11-08 | Anson | North Carolina | 37007 | 3933 | 81 |
1893255 | 1893255 | 2021-11-07 | Anson | North Carolina | 37007 | 3918 | 81 |
1890005 | 1890005 | 2021-11-06 | Anson | North Carolina | 37007 | 3918 | 81 |
1886755 | 1886755 | 2021-11-05 | Anson | North Carolina | 37007 | 3918 | 81 |
1883506 | 1883506 | 2021-11-04 | Anson | North Carolina | 37007 | 3901 | 81 |
1880257 | 1880257 | 2021-11-03 | Anson | North Carolina | 37007 | 3887 | 80 |
1877008 | 1877008 | 2021-11-02 | Anson | North Carolina | 37007 | 3877 | 80 |
1873759 | 1873759 | 2021-11-01 | Anson | North Carolina | 37007 | 3872 | 80 |
1870510 | 1870510 | 2021-10-31 | Anson | North Carolina | 37007 | 3856 | 80 |
1867261 | 1867261 | 2021-10-30 | Anson | North Carolina | 37007 | 3856 | 80 |
1864012 | 1864012 | 2021-10-29 | Anson | North Carolina | 37007 | 3856 | 80 |
1860763 | 1860763 | 2021-10-28 | Anson | North Carolina | 37007 | 3848 | 80 |
1857514 | 1857514 | 2021-10-27 | Anson | North Carolina | 37007 | 3825 | 79 |
1854265 | 1854265 | 2021-10-26 | Anson | North Carolina | 37007 | 3824 | 79 |
1851016 | 1851016 | 2021-10-25 | Anson | North Carolina | 37007 | 3820 | 78 |
1847766 | 1847766 | 2021-10-24 | Anson | North Carolina | 37007 | 3807 | 78 |
1844516 | 1844516 | 2021-10-23 | Anson | North Carolina | 37007 | 3807 | 78 |
1841266 | 1841266 | 2021-10-22 | Anson | North Carolina | 37007 | 3807 | 78 |
1838017 | 1838017 | 2021-10-21 | Anson | North Carolina | 37007 | 3799 | 78 |
1834768 | 1834768 | 2021-10-20 | Anson | North Carolina | 37007 | 3798 | 78 |
1831519 | 1831519 | 2021-10-19 | Anson | North Carolina | 37007 | 3797 | 77 |
1828270 | 1828270 | 2021-10-18 | Anson | North Carolina | 37007 | 3798 | 77 |
1825021 | 1825021 | 2021-10-17 | Anson | North Carolina | 37007 | 3781 | 77 |
1821772 | 1821772 | 2021-10-16 | Anson | North Carolina | 37007 | 3781 | 77 |
1818523 | 1818523 | 2021-10-15 | Anson | North Carolina | 37007 | 3781 | 77 |
1815274 | 1815274 | 2021-10-14 | Anson | North Carolina | 37007 | 3769 | 77 |
1812026 | 1812026 | 2021-10-13 | Anson | North Carolina | 37007 | 3765 | 75 |
1808777 | 1808777 | 2021-10-12 | Anson | North Carolina | 37007 | 3758 | 75 |
1805526 | 1805526 | 2021-10-11 | Anson | North Carolina | 37007 | 3751 | 75 |
1802277 | 1802277 | 2021-10-10 | Anson | North Carolina | 37007 | 3720 | 75 |
1799028 | 1799028 | 2021-10-09 | Anson | North Carolina | 37007 | 3720 | 75 |
1795779 | 1795779 | 2021-10-08 | Anson | North Carolina | 37007 | 3720 | 75 |
1792530 | 1792530 | 2021-10-07 | Anson | North Carolina | 37007 | 3711 | 75 |
1789281 | 1789281 | 2021-10-06 | Anson | North Carolina | 37007 | 3703 | 75 |
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);