ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Scott" and fips = 51169 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177237 | 2177237 | 2022-02-02 | Scott | Virginia | 51169 | 5030 | 95 |
2173984 | 2173984 | 2022-02-01 | Scott | Virginia | 51169 | 4990 | 93 |
2170732 | 2170732 | 2022-01-31 | Scott | Virginia | 51169 | 4963 | 93 |
2167479 | 2167479 | 2022-01-30 | Scott | Virginia | 51169 | 4849 | 93 |
2164224 | 2164224 | 2022-01-29 | Scott | Virginia | 51169 | 4849 | 93 |
2160969 | 2160969 | 2022-01-28 | Scott | Virginia | 51169 | 4849 | 93 |
2157713 | 2157713 | 2022-01-27 | Scott | Virginia | 51169 | 4799 | 93 |
2154460 | 2154460 | 2022-01-26 | Scott | Virginia | 51169 | 4727 | 93 |
2151207 | 2151207 | 2022-01-25 | Scott | Virginia | 51169 | 4666 | 93 |
2147955 | 2147955 | 2022-01-24 | Scott | Virginia | 51169 | 4609 | 93 |
2144702 | 2144702 | 2022-01-23 | Scott | Virginia | 51169 | 4493 | 93 |
2141447 | 2141447 | 2022-01-22 | Scott | Virginia | 51169 | 4493 | 93 |
2138191 | 2138191 | 2022-01-21 | Scott | Virginia | 51169 | 4493 | 93 |
2134937 | 2134937 | 2022-01-20 | Scott | Virginia | 51169 | 4433 | 93 |
2131685 | 2131685 | 2022-01-19 | Scott | Virginia | 51169 | 4310 | 93 |
2128431 | 2128431 | 2022-01-18 | Scott | Virginia | 51169 | 4281 | 93 |
2125178 | 2125178 | 2022-01-17 | Scott | Virginia | 51169 | 4260 | 92 |
2121926 | 2121926 | 2022-01-16 | Scott | Virginia | 51169 | 4135 | 92 |
2118674 | 2118674 | 2022-01-15 | Scott | Virginia | 51169 | 4135 | 92 |
2115422 | 2115422 | 2022-01-14 | Scott | Virginia | 51169 | 4135 | 92 |
2112170 | 2112170 | 2022-01-13 | Scott | Virginia | 51169 | 4106 | 92 |
2108918 | 2108918 | 2022-01-12 | Scott | Virginia | 51169 | 4060 | 92 |
2105667 | 2105667 | 2022-01-11 | Scott | Virginia | 51169 | 4047 | 92 |
2102416 | 2102416 | 2022-01-10 | Scott | Virginia | 51169 | 4022 | 92 |
2099165 | 2099165 | 2022-01-09 | Scott | Virginia | 51169 | 3945 | 92 |
2095914 | 2095914 | 2022-01-08 | Scott | Virginia | 51169 | 3945 | 92 |
2092662 | 2092662 | 2022-01-07 | Scott | Virginia | 51169 | 3945 | 92 |
2089410 | 2089410 | 2022-01-06 | Scott | Virginia | 51169 | 3916 | 92 |
2086159 | 2086159 | 2022-01-05 | Scott | Virginia | 51169 | 3882 | 92 |
2082907 | 2082907 | 2022-01-04 | Scott | Virginia | 51169 | 3853 | 92 |
2079655 | 2079655 | 2022-01-03 | Scott | Virginia | 51169 | 3831 | 92 |
2076403 | 2076403 | 2022-01-02 | Scott | Virginia | 51169 | 3774 | 92 |
2073152 | 2073152 | 2022-01-01 | Scott | Virginia | 51169 | 3774 | 92 |
2069901 | 2069901 | 2021-12-31 | Scott | Virginia | 51169 | 3774 | 92 |
2066650 | 2066650 | 2021-12-30 | Scott | Virginia | 51169 | 3749 | 92 |
2063400 | 2063400 | 2021-12-29 | Scott | Virginia | 51169 | 3734 | 92 |
2060150 | 2060150 | 2021-12-28 | Scott | Virginia | 51169 | 3720 | 93 |
2056901 | 2056901 | 2021-12-27 | Scott | Virginia | 51169 | 3712 | 89 |
2053652 | 2053652 | 2021-12-26 | Scott | Virginia | 51169 | 3690 | 88 |
2050402 | 2050402 | 2021-12-25 | Scott | Virginia | 51169 | 3690 | 88 |
2047152 | 2047152 | 2021-12-24 | Scott | Virginia | 51169 | 3690 | 88 |
2043902 | 2043902 | 2021-12-23 | Scott | Virginia | 51169 | 3681 | 87 |
2040653 | 2040653 | 2021-12-22 | Scott | Virginia | 51169 | 3663 | 87 |
2037403 | 2037403 | 2021-12-21 | Scott | Virginia | 51169 | 3653 | 87 |
2034153 | 2034153 | 2021-12-20 | Scott | Virginia | 51169 | 3642 | 87 |
2030903 | 2030903 | 2021-12-19 | Scott | Virginia | 51169 | 3629 | 87 |
2027652 | 2027652 | 2021-12-18 | Scott | Virginia | 51169 | 3629 | 87 |
2024401 | 2024401 | 2021-12-17 | Scott | Virginia | 51169 | 3629 | 87 |
2021150 | 2021150 | 2021-12-16 | Scott | Virginia | 51169 | 3617 | 87 |
2017899 | 2017899 | 2021-12-15 | Scott | Virginia | 51169 | 3608 | 87 |
2014649 | 2014649 | 2021-12-14 | Scott | Virginia | 51169 | 3597 | 87 |
2011398 | 2011398 | 2021-12-13 | Scott | Virginia | 51169 | 3588 | 87 |
2008147 | 2008147 | 2021-12-12 | Scott | Virginia | 51169 | 3568 | 86 |
2004896 | 2004896 | 2021-12-11 | Scott | Virginia | 51169 | 3568 | 86 |
2001645 | 2001645 | 2021-12-10 | Scott | Virginia | 51169 | 3568 | 86 |
1998395 | 1998395 | 2021-12-09 | Scott | Virginia | 51169 | 3555 | 86 |
1995144 | 1995144 | 2021-12-08 | Scott | Virginia | 51169 | 3543 | 85 |
1991893 | 1991893 | 2021-12-07 | Scott | Virginia | 51169 | 3535 | 84 |
1988642 | 1988642 | 2021-12-06 | Scott | Virginia | 51169 | 3522 | 84 |
1985392 | 1985392 | 2021-12-05 | Scott | Virginia | 51169 | 3483 | 84 |
1982142 | 1982142 | 2021-12-04 | Scott | Virginia | 51169 | 3483 | 84 |
1978892 | 1978892 | 2021-12-03 | Scott | Virginia | 51169 | 3483 | 84 |
1975642 | 1975642 | 2021-12-02 | Scott | Virginia | 51169 | 3472 | 84 |
1972393 | 1972393 | 2021-12-01 | Scott | Virginia | 51169 | 3450 | 84 |
1969143 | 1969143 | 2021-11-30 | Scott | Virginia | 51169 | 3425 | 84 |
1965893 | 1965893 | 2021-11-29 | Scott | Virginia | 51169 | 3410 | 84 |
1962641 | 1962641 | 2021-11-28 | Scott | Virginia | 51169 | 3393 | 84 |
1959390 | 1959390 | 2021-11-27 | Scott | Virginia | 51169 | 3393 | 84 |
1956139 | 1956139 | 2021-11-26 | Scott | Virginia | 51169 | 3393 | 84 |
1952888 | 1952888 | 2021-11-25 | Scott | Virginia | 51169 | 3389 | 84 |
1949637 | 1949637 | 2021-11-24 | Scott | Virginia | 51169 | 3385 | 84 |
1946386 | 1946386 | 2021-11-23 | Scott | Virginia | 51169 | 3390 | 84 |
1943135 | 1943135 | 2021-11-22 | Scott | Virginia | 51169 | 3384 | 83 |
1939885 | 1939885 | 2021-11-21 | Scott | Virginia | 51169 | 3363 | 83 |
1936635 | 1936635 | 2021-11-20 | Scott | Virginia | 51169 | 3363 | 83 |
1933385 | 1933385 | 2021-11-19 | Scott | Virginia | 51169 | 3363 | 83 |
1930133 | 1930133 | 2021-11-18 | Scott | Virginia | 51169 | 3362 | 83 |
1926883 | 1926883 | 2021-11-17 | Scott | Virginia | 51169 | 3313 | 83 |
1923633 | 1923633 | 2021-11-16 | Scott | Virginia | 51169 | 3290 | 83 |
1920384 | 1920384 | 2021-11-15 | Scott | Virginia | 51169 | 3271 | 83 |
1917134 | 1917134 | 2021-11-14 | Scott | Virginia | 51169 | 3254 | 82 |
1913884 | 1913884 | 2021-11-13 | Scott | Virginia | 51169 | 3254 | 82 |
1910634 | 1910634 | 2021-11-12 | Scott | Virginia | 51169 | 3254 | 82 |
1907385 | 1907385 | 2021-11-11 | Scott | Virginia | 51169 | 3251 | 81 |
1904136 | 1904136 | 2021-11-10 | Scott | Virginia | 51169 | 3243 | 81 |
1900886 | 1900886 | 2021-11-09 | Scott | Virginia | 51169 | 3240 | 79 |
1897636 | 1897636 | 2021-11-08 | Scott | Virginia | 51169 | 3230 | 79 |
1894386 | 1894386 | 2021-11-07 | Scott | Virginia | 51169 | 3217 | 78 |
1891136 | 1891136 | 2021-11-06 | Scott | Virginia | 51169 | 3217 | 78 |
1887886 | 1887886 | 2021-11-05 | Scott | Virginia | 51169 | 3217 | 78 |
1884636 | 1884636 | 2021-11-04 | Scott | Virginia | 51169 | 3203 | 78 |
1881387 | 1881387 | 2021-11-03 | Scott | Virginia | 51169 | 3197 | 78 |
1878138 | 1878138 | 2021-11-02 | Scott | Virginia | 51169 | 3188 | 78 |
1874889 | 1874889 | 2021-11-01 | Scott | Virginia | 51169 | 3175 | 77 |
1871640 | 1871640 | 2021-10-31 | Scott | Virginia | 51169 | 3151 | 76 |
1868391 | 1868391 | 2021-10-30 | Scott | Virginia | 51169 | 3151 | 76 |
1865142 | 1865142 | 2021-10-29 | Scott | Virginia | 51169 | 3151 | 76 |
1861893 | 1861893 | 2021-10-28 | Scott | Virginia | 51169 | 3145 | 76 |
1858644 | 1858644 | 2021-10-27 | Scott | Virginia | 51169 | 3139 | 76 |
1855395 | 1855395 | 2021-10-26 | Scott | Virginia | 51169 | 3129 | 77 |
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);