ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Columbus" 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 |
---|---|---|---|---|---|---|---|
2111059 | 2111059 | 2022-01-13 | Columbus | North Carolina | 37047 | 11891 | 235 |
2107807 | 2107807 | 2022-01-12 | Columbus | North Carolina | 37047 | 11723 | 235 |
2104556 | 2104556 | 2022-01-11 | Columbus | North Carolina | 37047 | 11641 | 235 |
2101305 | 2101305 | 2022-01-10 | Columbus | North Carolina | 37047 | 11590 | 235 |
2098054 | 2098054 | 2022-01-09 | Columbus | North Carolina | 37047 | 11145 | 235 |
2094802 | 2094802 | 2022-01-08 | Columbus | North Carolina | 37047 | 11145 | 235 |
2091550 | 2091550 | 2022-01-07 | Columbus | North Carolina | 37047 | 11145 | 235 |
2088299 | 2088299 | 2022-01-06 | Columbus | North Carolina | 37047 | 11090 | 235 |
2085047 | 2085047 | 2022-01-05 | Columbus | North Carolina | 37047 | 11004 | 235 |
2081795 | 2081795 | 2022-01-04 | Columbus | North Carolina | 37047 | 10939 | 235 |
2078543 | 2078543 | 2022-01-03 | Columbus | North Carolina | 37047 | 10910 | 235 |
2075292 | 2075292 | 2022-01-02 | Columbus | North Carolina | 37047 | 10757 | 234 |
2072041 | 2072041 | 2022-01-01 | Columbus | North Carolina | 37047 | 10757 | 234 |
2068790 | 2068790 | 2021-12-31 | Columbus | North Carolina | 37047 | 10757 | 234 |
2065539 | 2065539 | 2021-12-30 | Columbus | North Carolina | 37047 | 10711 | 234 |
2062289 | 2062289 | 2021-12-29 | Columbus | North Carolina | 37047 | 10679 | 234 |
2059040 | 2059040 | 2021-12-28 | Columbus | North Carolina | 37047 | 10664 | 234 |
2055791 | 2055791 | 2021-12-27 | Columbus | North Carolina | 37047 | 10576 | 233 |
2052541 | 2052541 | 2021-12-26 | Columbus | North Carolina | 37047 | 10576 | 233 |
2049291 | 2049291 | 2021-12-25 | Columbus | North Carolina | 37047 | 10576 | 233 |
2046041 | 2046041 | 2021-12-24 | Columbus | North Carolina | 37047 | 10576 | 233 |
2042791 | 2042791 | 2021-12-23 | Columbus | North Carolina | 37047 | 10576 | 233 |
2039542 | 2039542 | 2021-12-22 | Columbus | North Carolina | 37047 | 10576 | 233 |
2036292 | 2036292 | 2021-12-21 | Columbus | North Carolina | 37047 | 10559 | 233 |
2033042 | 2033042 | 2021-12-20 | Columbus | North Carolina | 37047 | 10554 | 233 |
2029792 | 2029792 | 2021-12-19 | Columbus | North Carolina | 37047 | 10527 | 233 |
2026541 | 2026541 | 2021-12-18 | Columbus | North Carolina | 37047 | 10527 | 233 |
2023290 | 2023290 | 2021-12-17 | Columbus | North Carolina | 37047 | 10527 | 233 |
2020039 | 2020039 | 2021-12-16 | Columbus | North Carolina | 37047 | 10512 | 233 |
2016788 | 2016788 | 2021-12-15 | Columbus | North Carolina | 37047 | 10493 | 232 |
2013538 | 2013538 | 2021-12-14 | Columbus | North Carolina | 37047 | 10475 | 232 |
2010287 | 2010287 | 2021-12-13 | Columbus | North Carolina | 37047 | 10472 | 231 |
2007036 | 2007036 | 2021-12-12 | Columbus | North Carolina | 37047 | 10443 | 231 |
2003785 | 2003785 | 2021-12-11 | Columbus | North Carolina | 37047 | 10443 | 231 |
2000534 | 2000534 | 2021-12-10 | Columbus | North Carolina | 37047 | 10443 | 231 |
1997284 | 1997284 | 2021-12-09 | Columbus | North Carolina | 37047 | 10423 | 230 |
1994033 | 1994033 | 2021-12-08 | Columbus | North Carolina | 37047 | 10399 | 230 |
1990782 | 1990782 | 2021-12-07 | Columbus | North Carolina | 37047 | 10373 | 230 |
1987531 | 1987531 | 2021-12-06 | Columbus | North Carolina | 37047 | 10369 | 230 |
1984281 | 1984281 | 2021-12-05 | Columbus | North Carolina | 37047 | 10351 | 230 |
1981031 | 1981031 | 2021-12-04 | Columbus | North Carolina | 37047 | 10351 | 230 |
1977781 | 1977781 | 2021-12-03 | Columbus | North Carolina | 37047 | 10351 | 230 |
1974531 | 1974531 | 2021-12-02 | Columbus | North Carolina | 37047 | 10325 | 230 |
1971282 | 1971282 | 2021-12-01 | Columbus | North Carolina | 37047 | 10317 | 230 |
1968032 | 1968032 | 2021-11-30 | Columbus | North Carolina | 37047 | 10302 | 230 |
1964781 | 1964781 | 2021-11-29 | Columbus | North Carolina | 37047 | 10296 | 230 |
1961529 | 1961529 | 2021-11-28 | Columbus | North Carolina | 37047 | 10269 | 230 |
1958278 | 1958278 | 2021-11-27 | Columbus | North Carolina | 37047 | 10269 | 230 |
1955027 | 1955027 | 2021-11-26 | Columbus | North Carolina | 37047 | 10269 | 230 |
1951776 | 1951776 | 2021-11-25 | Columbus | North Carolina | 37047 | 10269 | 230 |
1948525 | 1948525 | 2021-11-24 | Columbus | North Carolina | 37047 | 10269 | 230 |
1945274 | 1945274 | 2021-11-23 | Columbus | North Carolina | 37047 | 10259 | 230 |
1942023 | 1942023 | 2021-11-22 | Columbus | North Carolina | 37047 | 10258 | 230 |
1938773 | 1938773 | 2021-11-21 | Columbus | North Carolina | 37047 | 10231 | 230 |
1935523 | 1935523 | 2021-11-20 | Columbus | North Carolina | 37047 | 10231 | 230 |
1932273 | 1932273 | 2021-11-19 | Columbus | North Carolina | 37047 | 10231 | 230 |
1929022 | 1929022 | 2021-11-18 | Columbus | North Carolina | 37047 | 10220 | 230 |
1925772 | 1925772 | 2021-11-17 | Columbus | North Carolina | 37047 | 10212 | 230 |
1922523 | 1922523 | 2021-11-16 | Columbus | North Carolina | 37047 | 10206 | 230 |
1919273 | 1919273 | 2021-11-15 | Columbus | North Carolina | 37047 | 10195 | 230 |
1916023 | 1916023 | 2021-11-14 | Columbus | North Carolina | 37047 | 10182 | 230 |
1912773 | 1912773 | 2021-11-13 | Columbus | North Carolina | 37047 | 10182 | 230 |
1909523 | 1909523 | 2021-11-12 | Columbus | North Carolina | 37047 | 10182 | 230 |
1906274 | 1906274 | 2021-11-11 | Columbus | North Carolina | 37047 | 10170 | 229 |
1903025 | 1903025 | 2021-11-10 | Columbus | North Carolina | 37047 | 10170 | 229 |
1899775 | 1899775 | 2021-11-09 | Columbus | North Carolina | 37047 | 10162 | 228 |
1896525 | 1896525 | 2021-11-08 | Columbus | North Carolina | 37047 | 10159 | 228 |
1893275 | 1893275 | 2021-11-07 | Columbus | North Carolina | 37047 | 10146 | 227 |
1890025 | 1890025 | 2021-11-06 | Columbus | North Carolina | 37047 | 10146 | 227 |
1886775 | 1886775 | 2021-11-05 | Columbus | North Carolina | 37047 | 10146 | 227 |
1883526 | 1883526 | 2021-11-04 | Columbus | North Carolina | 37047 | 10142 | 227 |
1880277 | 1880277 | 2021-11-03 | Columbus | North Carolina | 37047 | 10133 | 226 |
1877028 | 1877028 | 2021-11-02 | Columbus | North Carolina | 37047 | 10123 | 226 |
1873779 | 1873779 | 2021-11-01 | Columbus | North Carolina | 37047 | 10118 | 226 |
1870530 | 1870530 | 2021-10-31 | Columbus | North Carolina | 37047 | 10086 | 226 |
1867281 | 1867281 | 2021-10-30 | Columbus | North Carolina | 37047 | 10086 | 226 |
1864032 | 1864032 | 2021-10-29 | Columbus | North Carolina | 37047 | 10086 | 226 |
1860783 | 1860783 | 2021-10-28 | Columbus | North Carolina | 37047 | 10078 | 226 |
1857534 | 1857534 | 2021-10-27 | Columbus | North Carolina | 37047 | 10067 | 225 |
1854285 | 1854285 | 2021-10-26 | Columbus | North Carolina | 37047 | 10053 | 224 |
1851036 | 1851036 | 2021-10-25 | Columbus | North Carolina | 37047 | 10049 | 224 |
1847786 | 1847786 | 2021-10-24 | Columbus | North Carolina | 37047 | 9992 | 222 |
1844536 | 1844536 | 2021-10-23 | Columbus | North Carolina | 37047 | 9992 | 222 |
1841286 | 1841286 | 2021-10-22 | Columbus | North Carolina | 37047 | 9992 | 222 |
1838037 | 1838037 | 2021-10-21 | Columbus | North Carolina | 37047 | 9989 | 222 |
1834788 | 1834788 | 2021-10-20 | Columbus | North Carolina | 37047 | 9960 | 221 |
1831539 | 1831539 | 2021-10-19 | Columbus | North Carolina | 37047 | 9941 | 221 |
1828290 | 1828290 | 2021-10-18 | Columbus | North Carolina | 37047 | 9939 | 221 |
1825041 | 1825041 | 2021-10-17 | Columbus | North Carolina | 37047 | 9894 | 221 |
1821792 | 1821792 | 2021-10-16 | Columbus | North Carolina | 37047 | 9894 | 221 |
1818543 | 1818543 | 2021-10-15 | Columbus | North Carolina | 37047 | 9894 | 221 |
1815294 | 1815294 | 2021-10-14 | Columbus | North Carolina | 37047 | 9881 | 221 |
1812046 | 1812046 | 2021-10-13 | Columbus | North Carolina | 37047 | 9871 | 221 |
1808797 | 1808797 | 2021-10-12 | Columbus | North Carolina | 37047 | 9851 | 219 |
1805546 | 1805546 | 2021-10-11 | Columbus | North Carolina | 37047 | 9847 | 219 |
1802297 | 1802297 | 2021-10-10 | Columbus | North Carolina | 37047 | 9816 | 219 |
1799048 | 1799048 | 2021-10-09 | Columbus | North Carolina | 37047 | 9816 | 219 |
1795799 | 1795799 | 2021-10-08 | Columbus | North Carolina | 37047 | 9816 | 219 |
1792550 | 1792550 | 2021-10-07 | Columbus | North Carolina | 37047 | 9803 | 217 |
1789301 | 1789301 | 2021-10-06 | Columbus | North Carolina | 37047 | 9794 | 216 |
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);