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 |
---|---|---|---|---|---|---|---|
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 |
1852150 | 1852150 | 2021-10-25 | Spotsylvania | Virginia | 51177 | 14996 | 148 |
1848900 | 1848900 | 2021-10-24 | Spotsylvania | Virginia | 51177 | 14868 | 147 |
1845650 | 1845650 | 2021-10-23 | Spotsylvania | Virginia | 51177 | 14868 | 147 |
1842400 | 1842400 | 2021-10-22 | Spotsylvania | Virginia | 51177 | 14868 | 147 |
1839151 | 1839151 | 2021-10-21 | Spotsylvania | Virginia | 51177 | 14829 | 147 |
1835902 | 1835902 | 2021-10-20 | Spotsylvania | Virginia | 51177 | 14800 | 145 |
1832653 | 1832653 | 2021-10-19 | Spotsylvania | Virginia | 51177 | 14750 | 145 |
1829404 | 1829404 | 2021-10-18 | Spotsylvania | Virginia | 51177 | 14735 | 145 |
1826155 | 1826155 | 2021-10-17 | Spotsylvania | Virginia | 51177 | 14577 | 144 |
1822906 | 1822906 | 2021-10-16 | Spotsylvania | Virginia | 51177 | 14577 | 144 |
1819657 | 1819657 | 2021-10-15 | Spotsylvania | Virginia | 51177 | 14577 | 144 |
1816408 | 1816408 | 2021-10-14 | Spotsylvania | Virginia | 51177 | 14522 | 144 |
1813160 | 1813160 | 2021-10-13 | Spotsylvania | Virginia | 51177 | 14482 | 143 |
1809911 | 1809911 | 2021-10-12 | Spotsylvania | Virginia | 51177 | 14434 | 143 |
1806661 | 1806661 | 2021-10-11 | Spotsylvania | Virginia | 51177 | 14266 | 141 |
1803411 | 1803411 | 2021-10-10 | Spotsylvania | Virginia | 51177 | 14266 | 141 |
1800162 | 1800162 | 2021-10-09 | Spotsylvania | Virginia | 51177 | 14266 | 141 |
1796913 | 1796913 | 2021-10-08 | Spotsylvania | Virginia | 51177 | 14266 | 141 |
1793664 | 1793664 | 2021-10-07 | Spotsylvania | Virginia | 51177 | 14205 | 141 |
1790415 | 1790415 | 2021-10-06 | Spotsylvania | Virginia | 51177 | 14148 | 141 |
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);