ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Greene" 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 |
---|---|---|---|---|---|---|---|
2176141 | 2176141 | 2022-02-02 | Greene | North Carolina | 37079 | 5434 | 55 |
2172888 | 2172888 | 2022-02-01 | Greene | North Carolina | 37079 | 5415 | 56 |
2169635 | 2169635 | 2022-01-31 | Greene | North Carolina | 37079 | 5387 | 56 |
2166380 | 2166380 | 2022-01-30 | Greene | North Carolina | 37079 | 5282 | 56 |
2163125 | 2163125 | 2022-01-29 | Greene | North Carolina | 37079 | 5282 | 56 |
2159870 | 2159870 | 2022-01-28 | Greene | North Carolina | 37079 | 5282 | 56 |
2156615 | 2156615 | 2022-01-27 | Greene | North Carolina | 37079 | 5208 | 56 |
2153362 | 2153362 | 2022-01-26 | Greene | North Carolina | 37079 | 5133 | 56 |
2150110 | 2150110 | 2022-01-25 | Greene | North Carolina | 37079 | 5074 | 56 |
2146858 | 2146858 | 2022-01-24 | Greene | North Carolina | 37079 | 5039 | 56 |
2143604 | 2143604 | 2022-01-23 | Greene | North Carolina | 37079 | 4839 | 56 |
2140349 | 2140349 | 2022-01-22 | Greene | North Carolina | 37079 | 4839 | 56 |
2137093 | 2137093 | 2022-01-21 | Greene | North Carolina | 37079 | 4839 | 56 |
2133840 | 2133840 | 2022-01-20 | Greene | North Carolina | 37079 | 4720 | 56 |
2130588 | 2130588 | 2022-01-19 | Greene | North Carolina | 37079 | 4651 | 56 |
2127334 | 2127334 | 2022-01-18 | Greene | North Carolina | 37079 | 4588 | 56 |
2124082 | 2124082 | 2022-01-17 | Greene | North Carolina | 37079 | 4286 | 56 |
2120830 | 2120830 | 2022-01-16 | Greene | North Carolina | 37079 | 4286 | 56 |
2117578 | 2117578 | 2022-01-15 | Greene | North Carolina | 37079 | 4286 | 56 |
2114327 | 2114327 | 2022-01-14 | Greene | North Carolina | 37079 | 4286 | 56 |
2111075 | 2111075 | 2022-01-13 | Greene | North Carolina | 37079 | 4225 | 56 |
2107823 | 2107823 | 2022-01-12 | Greene | North Carolina | 37079 | 4133 | 56 |
2104572 | 2104572 | 2022-01-11 | Greene | North Carolina | 37079 | 4092 | 56 |
2101321 | 2101321 | 2022-01-10 | Greene | North Carolina | 37079 | 4050 | 56 |
2098070 | 2098070 | 2022-01-09 | Greene | North Carolina | 37079 | 3907 | 56 |
2094818 | 2094818 | 2022-01-08 | Greene | North Carolina | 37079 | 3907 | 56 |
2091566 | 2091566 | 2022-01-07 | Greene | North Carolina | 37079 | 3907 | 56 |
2088315 | 2088315 | 2022-01-06 | Greene | North Carolina | 37079 | 3837 | 56 |
2085063 | 2085063 | 2022-01-05 | Greene | North Carolina | 37079 | 3799 | 56 |
2081811 | 2081811 | 2022-01-04 | Greene | North Carolina | 37079 | 3770 | 56 |
2078559 | 2078559 | 2022-01-03 | Greene | North Carolina | 37079 | 3760 | 56 |
2075308 | 2075308 | 2022-01-02 | Greene | North Carolina | 37079 | 3685 | 56 |
2072057 | 2072057 | 2022-01-01 | Greene | North Carolina | 37079 | 3685 | 56 |
2068806 | 2068806 | 2021-12-31 | Greene | North Carolina | 37079 | 3685 | 56 |
2065555 | 2065555 | 2021-12-30 | Greene | North Carolina | 37079 | 3640 | 56 |
2062305 | 2062305 | 2021-12-29 | Greene | North Carolina | 37079 | 3618 | 56 |
2059056 | 2059056 | 2021-12-28 | Greene | North Carolina | 37079 | 3615 | 56 |
2055807 | 2055807 | 2021-12-27 | Greene | North Carolina | 37079 | 3546 | 56 |
2052557 | 2052557 | 2021-12-26 | Greene | North Carolina | 37079 | 3546 | 56 |
2049307 | 2049307 | 2021-12-25 | Greene | North Carolina | 37079 | 3546 | 56 |
2046057 | 2046057 | 2021-12-24 | Greene | North Carolina | 37079 | 3546 | 56 |
2042807 | 2042807 | 2021-12-23 | Greene | North Carolina | 37079 | 3546 | 56 |
2039558 | 2039558 | 2021-12-22 | Greene | North Carolina | 37079 | 3546 | 56 |
2036308 | 2036308 | 2021-12-21 | Greene | North Carolina | 37079 | 3541 | 56 |
2033058 | 2033058 | 2021-12-20 | Greene | North Carolina | 37079 | 3539 | 56 |
2029808 | 2029808 | 2021-12-19 | Greene | North Carolina | 37079 | 3486 | 56 |
2026557 | 2026557 | 2021-12-18 | Greene | North Carolina | 37079 | 3486 | 56 |
2023306 | 2023306 | 2021-12-17 | Greene | North Carolina | 37079 | 3486 | 56 |
2020055 | 2020055 | 2021-12-16 | Greene | North Carolina | 37079 | 3478 | 56 |
2016804 | 2016804 | 2021-12-15 | Greene | North Carolina | 37079 | 3468 | 56 |
2013554 | 2013554 | 2021-12-14 | Greene | North Carolina | 37079 | 3458 | 56 |
2010303 | 2010303 | 2021-12-13 | Greene | North Carolina | 37079 | 3456 | 56 |
2007052 | 2007052 | 2021-12-12 | Greene | North Carolina | 37079 | 3446 | 56 |
2003801 | 2003801 | 2021-12-11 | Greene | North Carolina | 37079 | 3446 | 56 |
2000550 | 2000550 | 2021-12-10 | Greene | North Carolina | 37079 | 3446 | 56 |
1997300 | 1997300 | 2021-12-09 | Greene | North Carolina | 37079 | 3437 | 56 |
1994049 | 1994049 | 2021-12-08 | Greene | North Carolina | 37079 | 3426 | 56 |
1990798 | 1990798 | 2021-12-07 | Greene | North Carolina | 37079 | 3419 | 56 |
1987547 | 1987547 | 2021-12-06 | Greene | North Carolina | 37079 | 3418 | 56 |
1984297 | 1984297 | 2021-12-05 | Greene | North Carolina | 37079 | 3408 | 56 |
1981047 | 1981047 | 2021-12-04 | Greene | North Carolina | 37079 | 3408 | 56 |
1977797 | 1977797 | 2021-12-03 | Greene | North Carolina | 37079 | 3408 | 56 |
1974547 | 1974547 | 2021-12-02 | Greene | North Carolina | 37079 | 3403 | 56 |
1971298 | 1971298 | 2021-12-01 | Greene | North Carolina | 37079 | 3395 | 56 |
1968048 | 1968048 | 2021-11-30 | Greene | North Carolina | 37079 | 3388 | 56 |
1964797 | 1964797 | 2021-11-29 | Greene | North Carolina | 37079 | 3398 | 56 |
1961545 | 1961545 | 2021-11-28 | Greene | North Carolina | 37079 | 3381 | 56 |
1958294 | 1958294 | 2021-11-27 | Greene | North Carolina | 37079 | 3381 | 56 |
1955043 | 1955043 | 2021-11-26 | Greene | North Carolina | 37079 | 3381 | 56 |
1951792 | 1951792 | 2021-11-25 | Greene | North Carolina | 37079 | 3381 | 56 |
1948541 | 1948541 | 2021-11-24 | Greene | North Carolina | 37079 | 3381 | 56 |
1945290 | 1945290 | 2021-11-23 | Greene | North Carolina | 37079 | 3381 | 56 |
1942039 | 1942039 | 2021-11-22 | Greene | North Carolina | 37079 | 3380 | 56 |
1938789 | 1938789 | 2021-11-21 | Greene | North Carolina | 37079 | 3364 | 55 |
1935539 | 1935539 | 2021-11-20 | Greene | North Carolina | 37079 | 3364 | 55 |
1932289 | 1932289 | 2021-11-19 | Greene | North Carolina | 37079 | 3364 | 55 |
1929038 | 1929038 | 2021-11-18 | Greene | North Carolina | 37079 | 3359 | 55 |
1925788 | 1925788 | 2021-11-17 | Greene | North Carolina | 37079 | 3356 | 55 |
1922539 | 1922539 | 2021-11-16 | Greene | North Carolina | 37079 | 3354 | 55 |
1919289 | 1919289 | 2021-11-15 | Greene | North Carolina | 37079 | 3355 | 55 |
1916039 | 1916039 | 2021-11-14 | Greene | North Carolina | 37079 | 3346 | 55 |
1912789 | 1912789 | 2021-11-13 | Greene | North Carolina | 37079 | 3346 | 55 |
1909539 | 1909539 | 2021-11-12 | Greene | North Carolina | 37079 | 3346 | 55 |
1906290 | 1906290 | 2021-11-11 | Greene | North Carolina | 37079 | 3346 | 56 |
1903041 | 1903041 | 2021-11-10 | Greene | North Carolina | 37079 | 3346 | 56 |
1899791 | 1899791 | 2021-11-09 | Greene | North Carolina | 37079 | 3341 | 56 |
1896541 | 1896541 | 2021-11-08 | Greene | North Carolina | 37079 | 3341 | 56 |
1893291 | 1893291 | 2021-11-07 | Greene | North Carolina | 37079 | 3340 | 56 |
1890041 | 1890041 | 2021-11-06 | Greene | North Carolina | 37079 | 3340 | 56 |
1886791 | 1886791 | 2021-11-05 | Greene | North Carolina | 37079 | 3340 | 56 |
1883542 | 1883542 | 2021-11-04 | Greene | North Carolina | 37079 | 3339 | 56 |
1880293 | 1880293 | 2021-11-03 | Greene | North Carolina | 37079 | 3339 | 56 |
1877044 | 1877044 | 2021-11-02 | Greene | North Carolina | 37079 | 3333 | 56 |
1873795 | 1873795 | 2021-11-01 | Greene | North Carolina | 37079 | 3332 | 56 |
1870546 | 1870546 | 2021-10-31 | Greene | North Carolina | 37079 | 3318 | 56 |
1867297 | 1867297 | 2021-10-30 | Greene | North Carolina | 37079 | 3318 | 56 |
1864048 | 1864048 | 2021-10-29 | Greene | North Carolina | 37079 | 3318 | 56 |
1860799 | 1860799 | 2021-10-28 | Greene | North Carolina | 37079 | 3318 | 56 |
1857550 | 1857550 | 2021-10-27 | Greene | North Carolina | 37079 | 3314 | 56 |
1854301 | 1854301 | 2021-10-26 | Greene | North Carolina | 37079 | 3300 | 56 |
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);