ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Amherst" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177130 | 2177130 | 2022-02-02 | Amherst | Virginia | 51009 | 6288 | 70 |
2173877 | 2173877 | 2022-02-01 | Amherst | Virginia | 51009 | 6258 | 69 |
2170625 | 2170625 | 2022-01-31 | Amherst | Virginia | 51009 | 6221 | 69 |
2167372 | 2167372 | 2022-01-30 | Amherst | Virginia | 51009 | 6133 | 69 |
2164117 | 2164117 | 2022-01-29 | Amherst | Virginia | 51009 | 6133 | 69 |
2160862 | 2160862 | 2022-01-28 | Amherst | Virginia | 51009 | 6133 | 69 |
2157606 | 2157606 | 2022-01-27 | Amherst | Virginia | 51009 | 6101 | 69 |
2154353 | 2154353 | 2022-01-26 | Amherst | Virginia | 51009 | 6056 | 66 |
2151100 | 2151100 | 2022-01-25 | Amherst | Virginia | 51009 | 5997 | 66 |
2147848 | 2147848 | 2022-01-24 | Amherst | Virginia | 51009 | 5958 | 66 |
2144595 | 2144595 | 2022-01-23 | Amherst | Virginia | 51009 | 5852 | 65 |
2141340 | 2141340 | 2022-01-22 | Amherst | Virginia | 51009 | 5852 | 65 |
2138084 | 2138084 | 2022-01-21 | Amherst | Virginia | 51009 | 5852 | 65 |
2134830 | 2134830 | 2022-01-20 | Amherst | Virginia | 51009 | 5798 | 65 |
2131578 | 2131578 | 2022-01-19 | Amherst | Virginia | 51009 | 5735 | 65 |
2128324 | 2128324 | 2022-01-18 | Amherst | Virginia | 51009 | 5716 | 65 |
2125071 | 2125071 | 2022-01-17 | Amherst | Virginia | 51009 | 5697 | 64 |
2121819 | 2121819 | 2022-01-16 | Amherst | Virginia | 51009 | 5528 | 64 |
2118567 | 2118567 | 2022-01-15 | Amherst | Virginia | 51009 | 5528 | 64 |
2115315 | 2115315 | 2022-01-14 | Amherst | Virginia | 51009 | 5528 | 64 |
2112063 | 2112063 | 2022-01-13 | Amherst | Virginia | 51009 | 5495 | 64 |
2108811 | 2108811 | 2022-01-12 | Amherst | Virginia | 51009 | 5426 | 63 |
2105560 | 2105560 | 2022-01-11 | Amherst | Virginia | 51009 | 5358 | 63 |
2102309 | 2102309 | 2022-01-10 | Amherst | Virginia | 51009 | 5330 | 63 |
2099058 | 2099058 | 2022-01-09 | Amherst | Virginia | 51009 | 5146 | 63 |
2095807 | 2095807 | 2022-01-08 | Amherst | Virginia | 51009 | 5146 | 63 |
2092555 | 2092555 | 2022-01-07 | Amherst | Virginia | 51009 | 5146 | 63 |
2089303 | 2089303 | 2022-01-06 | Amherst | Virginia | 51009 | 5100 | 63 |
2086052 | 2086052 | 2022-01-05 | Amherst | Virginia | 51009 | 5059 | 63 |
2082800 | 2082800 | 2022-01-04 | Amherst | Virginia | 51009 | 5042 | 63 |
2079548 | 2079548 | 2022-01-03 | Amherst | Virginia | 51009 | 5008 | 63 |
2076296 | 2076296 | 2022-01-02 | Amherst | Virginia | 51009 | 4894 | 63 |
2073045 | 2073045 | 2022-01-01 | Amherst | Virginia | 51009 | 4894 | 63 |
2069794 | 2069794 | 2021-12-31 | Amherst | Virginia | 51009 | 4894 | 63 |
2066543 | 2066543 | 2021-12-30 | Amherst | Virginia | 51009 | 4845 | 63 |
2063293 | 2063293 | 2021-12-29 | Amherst | Virginia | 51009 | 4822 | 63 |
2060043 | 2060043 | 2021-12-28 | Amherst | Virginia | 51009 | 4795 | 62 |
2056794 | 2056794 | 2021-12-27 | Amherst | Virginia | 51009 | 4794 | 62 |
2053545 | 2053545 | 2021-12-26 | Amherst | Virginia | 51009 | 4774 | 62 |
2050295 | 2050295 | 2021-12-25 | Amherst | Virginia | 51009 | 4774 | 62 |
2047045 | 2047045 | 2021-12-24 | Amherst | Virginia | 51009 | 4774 | 62 |
2043795 | 2043795 | 2021-12-23 | Amherst | Virginia | 51009 | 4760 | 62 |
2040546 | 2040546 | 2021-12-22 | Amherst | Virginia | 51009 | 4755 | 62 |
2037296 | 2037296 | 2021-12-21 | Amherst | Virginia | 51009 | 4735 | 62 |
2034046 | 2034046 | 2021-12-20 | Amherst | Virginia | 51009 | 4729 | 62 |
2030796 | 2030796 | 2021-12-19 | Amherst | Virginia | 51009 | 4691 | 62 |
2027545 | 2027545 | 2021-12-18 | Amherst | Virginia | 51009 | 4691 | 62 |
2024294 | 2024294 | 2021-12-17 | Amherst | Virginia | 51009 | 4691 | 62 |
2021043 | 2021043 | 2021-12-16 | Amherst | Virginia | 51009 | 4684 | 62 |
2017792 | 2017792 | 2021-12-15 | Amherst | Virginia | 51009 | 4671 | 62 |
2014542 | 2014542 | 2021-12-14 | Amherst | Virginia | 51009 | 4659 | 62 |
2011291 | 2011291 | 2021-12-13 | Amherst | Virginia | 51009 | 4648 | 62 |
2008040 | 2008040 | 2021-12-12 | Amherst | Virginia | 51009 | 4623 | 62 |
2004789 | 2004789 | 2021-12-11 | Amherst | Virginia | 51009 | 4623 | 62 |
2001538 | 2001538 | 2021-12-10 | Amherst | Virginia | 51009 | 4623 | 62 |
1998288 | 1998288 | 2021-12-09 | Amherst | Virginia | 51009 | 4610 | 62 |
1995037 | 1995037 | 2021-12-08 | Amherst | Virginia | 51009 | 4597 | 62 |
1991786 | 1991786 | 2021-12-07 | Amherst | Virginia | 51009 | 4592 | 62 |
1988535 | 1988535 | 2021-12-06 | Amherst | Virginia | 51009 | 4588 | 62 |
1985285 | 1985285 | 2021-12-05 | Amherst | Virginia | 51009 | 4543 | 61 |
1982035 | 1982035 | 2021-12-04 | Amherst | Virginia | 51009 | 4543 | 61 |
1978785 | 1978785 | 2021-12-03 | Amherst | Virginia | 51009 | 4543 | 61 |
1975535 | 1975535 | 2021-12-02 | Amherst | Virginia | 51009 | 4538 | 61 |
1972286 | 1972286 | 2021-12-01 | Amherst | Virginia | 51009 | 4526 | 61 |
1969036 | 1969036 | 2021-11-30 | Amherst | Virginia | 51009 | 4517 | 61 |
1965786 | 1965786 | 2021-11-29 | Amherst | Virginia | 51009 | 4509 | 61 |
1962534 | 1962534 | 2021-11-28 | Amherst | Virginia | 51009 | 4504 | 61 |
1959283 | 1959283 | 2021-11-27 | Amherst | Virginia | 51009 | 4504 | 61 |
1956032 | 1956032 | 2021-11-26 | Amherst | Virginia | 51009 | 4504 | 61 |
1952781 | 1952781 | 2021-11-25 | Amherst | Virginia | 51009 | 4497 | 61 |
1949530 | 1949530 | 2021-11-24 | Amherst | Virginia | 51009 | 4491 | 61 |
1946279 | 1946279 | 2021-11-23 | Amherst | Virginia | 51009 | 4489 | 61 |
1943028 | 1943028 | 2021-11-22 | Amherst | Virginia | 51009 | 4481 | 61 |
1939778 | 1939778 | 2021-11-21 | Amherst | Virginia | 51009 | 4470 | 61 |
1936528 | 1936528 | 2021-11-20 | Amherst | Virginia | 51009 | 4470 | 61 |
1933278 | 1933278 | 2021-11-19 | Amherst | Virginia | 51009 | 4470 | 61 |
1930026 | 1930026 | 2021-11-18 | Amherst | Virginia | 51009 | 4467 | 61 |
1926776 | 1926776 | 2021-11-17 | Amherst | Virginia | 51009 | 4456 | 61 |
1923526 | 1923526 | 2021-11-16 | Amherst | Virginia | 51009 | 4448 | 60 |
1920277 | 1920277 | 2021-11-15 | Amherst | Virginia | 51009 | 4446 | 60 |
1917027 | 1917027 | 2021-11-14 | Amherst | Virginia | 51009 | 4440 | 60 |
1913777 | 1913777 | 2021-11-13 | Amherst | Virginia | 51009 | 4440 | 60 |
1910527 | 1910527 | 2021-11-12 | Amherst | Virginia | 51009 | 4440 | 60 |
1907278 | 1907278 | 2021-11-11 | Amherst | Virginia | 51009 | 4429 | 60 |
1904029 | 1904029 | 2021-11-10 | Amherst | Virginia | 51009 | 4425 | 60 |
1900779 | 1900779 | 2021-11-09 | Amherst | Virginia | 51009 | 4410 | 60 |
1897529 | 1897529 | 2021-11-08 | Amherst | Virginia | 51009 | 4399 | 59 |
1894279 | 1894279 | 2021-11-07 | Amherst | Virginia | 51009 | 4382 | 59 |
1891029 | 1891029 | 2021-11-06 | Amherst | Virginia | 51009 | 4382 | 59 |
1887779 | 1887779 | 2021-11-05 | Amherst | Virginia | 51009 | 4382 | 59 |
1884529 | 1884529 | 2021-11-04 | Amherst | Virginia | 51009 | 4373 | 59 |
1881280 | 1881280 | 2021-11-03 | Amherst | Virginia | 51009 | 4368 | 57 |
1878031 | 1878031 | 2021-11-02 | Amherst | Virginia | 51009 | 4364 | 57 |
1874782 | 1874782 | 2021-11-01 | Amherst | Virginia | 51009 | 4360 | 57 |
1871533 | 1871533 | 2021-10-31 | Amherst | Virginia | 51009 | 4349 | 57 |
1868284 | 1868284 | 2021-10-30 | Amherst | Virginia | 51009 | 4349 | 57 |
1865035 | 1865035 | 2021-10-29 | Amherst | Virginia | 51009 | 4349 | 57 |
1861786 | 1861786 | 2021-10-28 | Amherst | Virginia | 51009 | 4340 | 57 |
1858537 | 1858537 | 2021-10-27 | Amherst | Virginia | 51009 | 4338 | 57 |
1855288 | 1855288 | 2021-10-26 | Amherst | Virginia | 51009 | 4326 | 57 |
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);