ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51177 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177241 | 2177241 | 2022-02-02 | Spotsylvania | Virginia | 51177 | 25086 | 216 |
2173988 | 2173988 | 2022-02-01 | Spotsylvania | Virginia | 51177 | 25006 | 208 |
2170736 | 2170736 | 2022-01-31 | Spotsylvania | Virginia | 51177 | 24923 | 208 |
2167483 | 2167483 | 2022-01-30 | Spotsylvania | Virginia | 51177 | 24606 | 206 |
2164228 | 2164228 | 2022-01-29 | Spotsylvania | Virginia | 51177 | 24606 | 206 |
2160973 | 2160973 | 2022-01-28 | Spotsylvania | Virginia | 51177 | 24606 | 206 |
2157717 | 2157717 | 2022-01-27 | Spotsylvania | Virginia | 51177 | 24417 | 206 |
2154464 | 2154464 | 2022-01-26 | Spotsylvania | Virginia | 51177 | 24267 | 199 |
2151211 | 2151211 | 2022-01-25 | Spotsylvania | Virginia | 51177 | 24153 | 199 |
2147959 | 2147959 | 2022-01-24 | Spotsylvania | Virginia | 51177 | 23984 | 199 |
2144706 | 2144706 | 2022-01-23 | Spotsylvania | Virginia | 51177 | 23470 | 196 |
2141451 | 2141451 | 2022-01-22 | Spotsylvania | Virginia | 51177 | 23470 | 196 |
2138195 | 2138195 | 2022-01-21 | Spotsylvania | Virginia | 51177 | 23470 | 196 |
2134941 | 2134941 | 2022-01-20 | Spotsylvania | Virginia | 51177 | 23231 | 196 |
2131689 | 2131689 | 2022-01-19 | Spotsylvania | Virginia | 51177 | 23035 | 196 |
2128435 | 2128435 | 2022-01-18 | Spotsylvania | Virginia | 51177 | 22846 | 196 |
2125182 | 2125182 | 2022-01-17 | Spotsylvania | Virginia | 51177 | 22707 | 195 |
2121930 | 2121930 | 2022-01-16 | Spotsylvania | Virginia | 51177 | 22222 | 195 |
2118678 | 2118678 | 2022-01-15 | Spotsylvania | Virginia | 51177 | 22222 | 195 |
2115426 | 2115426 | 2022-01-14 | Spotsylvania | Virginia | 51177 | 22222 | 195 |
2112174 | 2112174 | 2022-01-13 | Spotsylvania | Virginia | 51177 | 21940 | 190 |
2108922 | 2108922 | 2022-01-12 | Spotsylvania | Virginia | 51177 | 21719 | 190 |
2105671 | 2105671 | 2022-01-11 | Spotsylvania | Virginia | 51177 | 21406 | 189 |
2102420 | 2102420 | 2022-01-10 | Spotsylvania | Virginia | 51177 | 21215 | 189 |
2099169 | 2099169 | 2022-01-09 | Spotsylvania | Virginia | 51177 | 20341 | 189 |
2095918 | 2095918 | 2022-01-08 | Spotsylvania | Virginia | 51177 | 20341 | 189 |
2092666 | 2092666 | 2022-01-07 | Spotsylvania | Virginia | 51177 | 20341 | 189 |
2089414 | 2089414 | 2022-01-06 | Spotsylvania | Virginia | 51177 | 20176 | 189 |
2086163 | 2086163 | 2022-01-05 | Spotsylvania | Virginia | 51177 | 20066 | 188 |
2082911 | 2082911 | 2022-01-04 | Spotsylvania | Virginia | 51177 | 19996 | 185 |
2079659 | 2079659 | 2022-01-03 | Spotsylvania | Virginia | 51177 | 19467 | 185 |
2076407 | 2076407 | 2022-01-02 | Spotsylvania | Virginia | 51177 | 18742 | 184 |
2073156 | 2073156 | 2022-01-01 | Spotsylvania | Virginia | 51177 | 18742 | 184 |
2069905 | 2069905 | 2021-12-31 | Spotsylvania | Virginia | 51177 | 18742 | 184 |
2066654 | 2066654 | 2021-12-30 | Spotsylvania | Virginia | 51177 | 18421 | 183 |
2063404 | 2063404 | 2021-12-29 | Spotsylvania | Virginia | 51177 | 18165 | 182 |
2060154 | 2060154 | 2021-12-28 | Spotsylvania | Virginia | 51177 | 18032 | 175 |
2056905 | 2056905 | 2021-12-27 | Spotsylvania | Virginia | 51177 | 17950 | 175 |
2053656 | 2053656 | 2021-12-26 | Spotsylvania | Virginia | 51177 | 17607 | 175 |
2050406 | 2050406 | 2021-12-25 | Spotsylvania | Virginia | 51177 | 17607 | 175 |
2047156 | 2047156 | 2021-12-24 | Spotsylvania | Virginia | 51177 | 17607 | 175 |
2043906 | 2043906 | 2021-12-23 | Spotsylvania | Virginia | 51177 | 17441 | 175 |
2040657 | 2040657 | 2021-12-22 | Spotsylvania | Virginia | 51177 | 17340 | 174 |
2037407 | 2037407 | 2021-12-21 | Spotsylvania | Virginia | 51177 | 17270 | 174 |
2034157 | 2034157 | 2021-12-20 | Spotsylvania | Virginia | 51177 | 17215 | 174 |
2030907 | 2030907 | 2021-12-19 | Spotsylvania | Virginia | 51177 | 17028 | 172 |
2027656 | 2027656 | 2021-12-18 | Spotsylvania | Virginia | 51177 | 17028 | 172 |
2024405 | 2024405 | 2021-12-17 | Spotsylvania | Virginia | 51177 | 17028 | 172 |
2021154 | 2021154 | 2021-12-16 | Spotsylvania | Virginia | 51177 | 16977 | 172 |
2017903 | 2017903 | 2021-12-15 | Spotsylvania | Virginia | 51177 | 16883 | 171 |
2014653 | 2014653 | 2021-12-14 | Spotsylvania | Virginia | 51177 | 16856 | 170 |
2011402 | 2011402 | 2021-12-13 | Spotsylvania | Virginia | 51177 | 16820 | 168 |
2008151 | 2008151 | 2021-12-12 | Spotsylvania | Virginia | 51177 | 16682 | 168 |
2004900 | 2004900 | 2021-12-11 | Spotsylvania | Virginia | 51177 | 16682 | 168 |
2001649 | 2001649 | 2021-12-10 | Spotsylvania | Virginia | 51177 | 16682 | 168 |
1998399 | 1998399 | 2021-12-09 | Spotsylvania | Virginia | 51177 | 16633 | 167 |
1995148 | 1995148 | 2021-12-08 | Spotsylvania | Virginia | 51177 | 16565 | 165 |
1991897 | 1991897 | 2021-12-07 | Spotsylvania | Virginia | 51177 | 16517 | 165 |
1988646 | 1988646 | 2021-12-06 | Spotsylvania | Virginia | 51177 | 16477 | 165 |
1985396 | 1985396 | 2021-12-05 | Spotsylvania | Virginia | 51177 | 16321 | 165 |
1982146 | 1982146 | 2021-12-04 | Spotsylvania | Virginia | 51177 | 16321 | 165 |
1978896 | 1978896 | 2021-12-03 | Spotsylvania | Virginia | 51177 | 16321 | 165 |
1975646 | 1975646 | 2021-12-02 | Spotsylvania | Virginia | 51177 | 16272 | 164 |
1972397 | 1972397 | 2021-12-01 | Spotsylvania | Virginia | 51177 | 16217 | 163 |
1969147 | 1969147 | 2021-11-30 | Spotsylvania | Virginia | 51177 | 16170 | 163 |
1965897 | 1965897 | 2021-11-29 | Spotsylvania | Virginia | 51177 | 16130 | 162 |
1962645 | 1962645 | 2021-11-28 | Spotsylvania | Virginia | 51177 | 16029 | 160 |
1959394 | 1959394 | 2021-11-27 | Spotsylvania | Virginia | 51177 | 16029 | 160 |
1956143 | 1956143 | 2021-11-26 | Spotsylvania | Virginia | 51177 | 16029 | 160 |
1952892 | 1952892 | 2021-11-25 | Spotsylvania | Virginia | 51177 | 15995 | 160 |
1949641 | 1949641 | 2021-11-24 | Spotsylvania | Virginia | 51177 | 15957 | 160 |
1946390 | 1946390 | 2021-11-23 | Spotsylvania | Virginia | 51177 | 15932 | 160 |
1943139 | 1943139 | 2021-11-22 | Spotsylvania | Virginia | 51177 | 15903 | 160 |
1939889 | 1939889 | 2021-11-21 | Spotsylvania | Virginia | 51177 | 15805 | 159 |
1936639 | 1936639 | 2021-11-20 | Spotsylvania | Virginia | 51177 | 15805 | 159 |
1933389 | 1933389 | 2021-11-19 | Spotsylvania | Virginia | 51177 | 15805 | 159 |
1930137 | 1930137 | 2021-11-18 | Spotsylvania | Virginia | 51177 | 15762 | 158 |
1926887 | 1926887 | 2021-11-17 | Spotsylvania | Virginia | 51177 | 15737 | 158 |
1923637 | 1923637 | 2021-11-16 | Spotsylvania | Virginia | 51177 | 15677 | 157 |
1920388 | 1920388 | 2021-11-15 | Spotsylvania | Virginia | 51177 | 15658 | 156 |
1917138 | 1917138 | 2021-11-14 | Spotsylvania | Virginia | 51177 | 15578 | 156 |
1913888 | 1913888 | 2021-11-13 | Spotsylvania | Virginia | 51177 | 15578 | 156 |
1910638 | 1910638 | 2021-11-12 | Spotsylvania | Virginia | 51177 | 15578 | 156 |
1907389 | 1907389 | 2021-11-11 | Spotsylvania | Virginia | 51177 | 15549 | 156 |
1904140 | 1904140 | 2021-11-10 | Spotsylvania | Virginia | 51177 | 15515 | 154 |
1900890 | 1900890 | 2021-11-09 | Spotsylvania | Virginia | 51177 | 15485 | 153 |
1897640 | 1897640 | 2021-11-08 | Spotsylvania | Virginia | 51177 | 15453 | 153 |
1894390 | 1894390 | 2021-11-07 | Spotsylvania | Virginia | 51177 | 15356 | 152 |
1891140 | 1891140 | 2021-11-06 | Spotsylvania | Virginia | 51177 | 15356 | 152 |
1887890 | 1887890 | 2021-11-05 | Spotsylvania | Virginia | 51177 | 15356 | 152 |
1884640 | 1884640 | 2021-11-04 | Spotsylvania | Virginia | 51177 | 15321 | 152 |
1881391 | 1881391 | 2021-11-03 | Spotsylvania | Virginia | 51177 | 15278 | 151 |
1878142 | 1878142 | 2021-11-02 | Spotsylvania | Virginia | 51177 | 15252 | 151 |
1874893 | 1874893 | 2021-11-01 | Spotsylvania | Virginia | 51177 | 15219 | 150 |
1871644 | 1871644 | 2021-10-31 | Spotsylvania | Virginia | 51177 | 15142 | 149 |
1868395 | 1868395 | 2021-10-30 | Spotsylvania | Virginia | 51177 | 15142 | 149 |
1865146 | 1865146 | 2021-10-29 | Spotsylvania | Virginia | 51177 | 15142 | 149 |
1861897 | 1861897 | 2021-10-28 | Spotsylvania | Virginia | 51177 | 15112 | 148 |
1858648 | 1858648 | 2021-10-27 | Spotsylvania | Virginia | 51177 | 15056 | 148 |
1855399 | 1855399 | 2021-10-26 | Spotsylvania | Virginia | 51177 | 15023 | 148 |
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);