ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 51680 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177198 | 2177198 | 2022-02-02 | Lynchburg city | Virginia | 51680 | 17996 | 233 |
2173945 | 2173945 | 2022-02-01 | Lynchburg city | Virginia | 51680 | 17912 | 230 |
2170693 | 2170693 | 2022-01-31 | Lynchburg city | Virginia | 51680 | 17836 | 230 |
2167440 | 2167440 | 2022-01-30 | Lynchburg city | Virginia | 51680 | 17560 | 225 |
2164185 | 2164185 | 2022-01-29 | Lynchburg city | Virginia | 51680 | 17560 | 225 |
2160930 | 2160930 | 2022-01-28 | Lynchburg city | Virginia | 51680 | 17560 | 225 |
2157674 | 2157674 | 2022-01-27 | Lynchburg city | Virginia | 51680 | 17438 | 225 |
2154421 | 2154421 | 2022-01-26 | Lynchburg city | Virginia | 51680 | 17283 | 224 |
2151168 | 2151168 | 2022-01-25 | Lynchburg city | Virginia | 51680 | 17148 | 224 |
2147916 | 2147916 | 2022-01-24 | Lynchburg city | Virginia | 51680 | 17010 | 224 |
2144663 | 2144663 | 2022-01-23 | Lynchburg city | Virginia | 51680 | 16617 | 224 |
2141408 | 2141408 | 2022-01-22 | Lynchburg city | Virginia | 51680 | 16617 | 224 |
2138152 | 2138152 | 2022-01-21 | Lynchburg city | Virginia | 51680 | 16617 | 224 |
2134898 | 2134898 | 2022-01-20 | Lynchburg city | Virginia | 51680 | 16395 | 224 |
2131646 | 2131646 | 2022-01-19 | Lynchburg city | Virginia | 51680 | 16162 | 224 |
2128392 | 2128392 | 2022-01-18 | Lynchburg city | Virginia | 51680 | 16099 | 224 |
2125139 | 2125139 | 2022-01-17 | Lynchburg city | Virginia | 51680 | 16021 | 224 |
2121887 | 2121887 | 2022-01-16 | Lynchburg city | Virginia | 51680 | 15434 | 224 |
2118635 | 2118635 | 2022-01-15 | Lynchburg city | Virginia | 51680 | 15434 | 224 |
2115383 | 2115383 | 2022-01-14 | Lynchburg city | Virginia | 51680 | 15434 | 224 |
2112131 | 2112131 | 2022-01-13 | Lynchburg city | Virginia | 51680 | 15285 | 223 |
2108879 | 2108879 | 2022-01-12 | Lynchburg city | Virginia | 51680 | 15087 | 218 |
2105628 | 2105628 | 2022-01-11 | Lynchburg city | Virginia | 51680 | 14912 | 218 |
2102377 | 2102377 | 2022-01-10 | Lynchburg city | Virginia | 51680 | 14797 | 218 |
2099126 | 2099126 | 2022-01-09 | Lynchburg city | Virginia | 51680 | 14226 | 218 |
2095875 | 2095875 | 2022-01-08 | Lynchburg city | Virginia | 51680 | 14226 | 218 |
2092623 | 2092623 | 2022-01-07 | Lynchburg city | Virginia | 51680 | 14226 | 218 |
2089371 | 2089371 | 2022-01-06 | Lynchburg city | Virginia | 51680 | 14023 | 216 |
2086120 | 2086120 | 2022-01-05 | Lynchburg city | Virginia | 51680 | 13853 | 216 |
2082868 | 2082868 | 2022-01-04 | Lynchburg city | Virginia | 51680 | 13799 | 216 |
2079616 | 2079616 | 2022-01-03 | Lynchburg city | Virginia | 51680 | 13668 | 216 |
2076364 | 2076364 | 2022-01-02 | Lynchburg city | Virginia | 51680 | 13205 | 216 |
2073113 | 2073113 | 2022-01-01 | Lynchburg city | Virginia | 51680 | 13205 | 216 |
2069862 | 2069862 | 2021-12-31 | Lynchburg city | Virginia | 51680 | 13205 | 216 |
2066611 | 2066611 | 2021-12-30 | Lynchburg city | Virginia | 51680 | 13022 | 215 |
2063361 | 2063361 | 2021-12-29 | Lynchburg city | Virginia | 51680 | 12913 | 215 |
2060111 | 2060111 | 2021-12-28 | Lynchburg city | Virginia | 51680 | 12791 | 215 |
2056862 | 2056862 | 2021-12-27 | Lynchburg city | Virginia | 51680 | 12771 | 215 |
2053613 | 2053613 | 2021-12-26 | Lynchburg city | Virginia | 51680 | 12660 | 214 |
2050363 | 2050363 | 2021-12-25 | Lynchburg city | Virginia | 51680 | 12660 | 214 |
2047113 | 2047113 | 2021-12-24 | Lynchburg city | Virginia | 51680 | 12660 | 214 |
2043863 | 2043863 | 2021-12-23 | Lynchburg city | Virginia | 51680 | 12593 | 212 |
2040614 | 2040614 | 2021-12-22 | Lynchburg city | Virginia | 51680 | 12571 | 211 |
2037364 | 2037364 | 2021-12-21 | Lynchburg city | Virginia | 51680 | 12525 | 207 |
2034114 | 2034114 | 2021-12-20 | Lynchburg city | Virginia | 51680 | 12499 | 206 |
2030864 | 2030864 | 2021-12-19 | Lynchburg city | Virginia | 51680 | 12437 | 206 |
2027613 | 2027613 | 2021-12-18 | Lynchburg city | Virginia | 51680 | 12437 | 206 |
2024362 | 2024362 | 2021-12-17 | Lynchburg city | Virginia | 51680 | 12437 | 206 |
2021111 | 2021111 | 2021-12-16 | Lynchburg city | Virginia | 51680 | 12417 | 205 |
2017860 | 2017860 | 2021-12-15 | Lynchburg city | Virginia | 51680 | 12390 | 205 |
2014610 | 2014610 | 2021-12-14 | Lynchburg city | Virginia | 51680 | 12338 | 201 |
2011359 | 2011359 | 2021-12-13 | Lynchburg city | Virginia | 51680 | 12339 | 199 |
2008108 | 2008108 | 2021-12-12 | Lynchburg city | Virginia | 51680 | 12312 | 199 |
2004857 | 2004857 | 2021-12-11 | Lynchburg city | Virginia | 51680 | 12312 | 199 |
2001606 | 2001606 | 2021-12-10 | Lynchburg city | Virginia | 51680 | 12312 | 199 |
1998356 | 1998356 | 2021-12-09 | Lynchburg city | Virginia | 51680 | 12277 | 198 |
1995105 | 1995105 | 2021-12-08 | Lynchburg city | Virginia | 51680 | 12255 | 196 |
1991854 | 1991854 | 2021-12-07 | Lynchburg city | Virginia | 51680 | 12221 | 195 |
1988603 | 1988603 | 2021-12-06 | Lynchburg city | Virginia | 51680 | 12199 | 195 |
1985353 | 1985353 | 2021-12-05 | Lynchburg city | Virginia | 51680 | 12113 | 196 |
1982103 | 1982103 | 2021-12-04 | Lynchburg city | Virginia | 51680 | 12113 | 196 |
1978853 | 1978853 | 2021-12-03 | Lynchburg city | Virginia | 51680 | 12113 | 196 |
1975603 | 1975603 | 2021-12-02 | Lynchburg city | Virginia | 51680 | 12063 | 196 |
1972354 | 1972354 | 2021-12-01 | Lynchburg city | Virginia | 51680 | 12039 | 196 |
1969104 | 1969104 | 2021-11-30 | Lynchburg city | Virginia | 51680 | 12017 | 195 |
1965854 | 1965854 | 2021-11-29 | Lynchburg city | Virginia | 51680 | 12001 | 195 |
1962602 | 1962602 | 2021-11-28 | Lynchburg city | Virginia | 51680 | 11970 | 195 |
1959351 | 1959351 | 2021-11-27 | Lynchburg city | Virginia | 51680 | 11970 | 195 |
1956100 | 1956100 | 2021-11-26 | Lynchburg city | Virginia | 51680 | 11970 | 195 |
1952849 | 1952849 | 2021-11-25 | Lynchburg city | Virginia | 51680 | 11946 | 195 |
1949598 | 1949598 | 2021-11-24 | Lynchburg city | Virginia | 51680 | 11934 | 195 |
1946347 | 1946347 | 2021-11-23 | Lynchburg city | Virginia | 51680 | 11942 | 195 |
1943096 | 1943096 | 2021-11-22 | Lynchburg city | Virginia | 51680 | 11943 | 195 |
1939846 | 1939846 | 2021-11-21 | Lynchburg city | Virginia | 51680 | 11908 | 195 |
1936596 | 1936596 | 2021-11-20 | Lynchburg city | Virginia | 51680 | 11908 | 195 |
1933346 | 1933346 | 2021-11-19 | Lynchburg city | Virginia | 51680 | 11908 | 195 |
1930094 | 1930094 | 2021-11-18 | Lynchburg city | Virginia | 51680 | 11890 | 193 |
1926844 | 1926844 | 2021-11-17 | Lynchburg city | Virginia | 51680 | 11876 | 193 |
1923594 | 1923594 | 2021-11-16 | Lynchburg city | Virginia | 51680 | 11863 | 193 |
1920345 | 1920345 | 2021-11-15 | Lynchburg city | Virginia | 51680 | 11867 | 193 |
1917095 | 1917095 | 2021-11-14 | Lynchburg city | Virginia | 51680 | 11859 | 192 |
1913845 | 1913845 | 2021-11-13 | Lynchburg city | Virginia | 51680 | 11859 | 192 |
1910595 | 1910595 | 2021-11-12 | Lynchburg city | Virginia | 51680 | 11859 | 192 |
1907346 | 1907346 | 2021-11-11 | Lynchburg city | Virginia | 51680 | 11866 | 191 |
1904097 | 1904097 | 2021-11-10 | Lynchburg city | Virginia | 51680 | 11872 | 191 |
1900847 | 1900847 | 2021-11-09 | Lynchburg city | Virginia | 51680 | 11861 | 188 |
1897597 | 1897597 | 2021-11-08 | Lynchburg city | Virginia | 51680 | 11856 | 188 |
1894347 | 1894347 | 2021-11-07 | Lynchburg city | Virginia | 51680 | 11835 | 186 |
1891097 | 1891097 | 2021-11-06 | Lynchburg city | Virginia | 51680 | 11835 | 186 |
1887847 | 1887847 | 2021-11-05 | Lynchburg city | Virginia | 51680 | 11835 | 186 |
1884597 | 1884597 | 2021-11-04 | Lynchburg city | Virginia | 51680 | 11831 | 186 |
1881348 | 1881348 | 2021-11-03 | Lynchburg city | Virginia | 51680 | 11828 | 186 |
1878099 | 1878099 | 2021-11-02 | Lynchburg city | Virginia | 51680 | 11829 | 186 |
1874850 | 1874850 | 2021-11-01 | Lynchburg city | Virginia | 51680 | 11815 | 186 |
1871601 | 1871601 | 2021-10-31 | Lynchburg city | Virginia | 51680 | 11799 | 186 |
1868352 | 1868352 | 2021-10-30 | Lynchburg city | Virginia | 51680 | 11799 | 186 |
1865103 | 1865103 | 2021-10-29 | Lynchburg city | Virginia | 51680 | 11799 | 186 |
1861854 | 1861854 | 2021-10-28 | Lynchburg city | Virginia | 51680 | 11786 | 186 |
1858605 | 1858605 | 2021-10-27 | Lynchburg city | Virginia | 51680 | 11780 | 186 |
1855356 | 1855356 | 2021-10-26 | Lynchburg city | Virginia | 51680 | 11771 | 186 |
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);