ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Rockbridge" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177233 | 2177233 | 2022-02-02 | Rockbridge | Virginia | 51163 | 2970 | 73 |
2173980 | 2173980 | 2022-02-01 | Rockbridge | Virginia | 51163 | 2958 | 73 |
2170728 | 2170728 | 2022-01-31 | Rockbridge | Virginia | 51163 | 2943 | 73 |
2167475 | 2167475 | 2022-01-30 | Rockbridge | Virginia | 51163 | 2889 | 73 |
2164220 | 2164220 | 2022-01-29 | Rockbridge | Virginia | 51163 | 2889 | 73 |
2160965 | 2160965 | 2022-01-28 | Rockbridge | Virginia | 51163 | 2889 | 73 |
2157709 | 2157709 | 2022-01-27 | Rockbridge | Virginia | 51163 | 2866 | 73 |
2154456 | 2154456 | 2022-01-26 | Rockbridge | Virginia | 51163 | 2851 | 72 |
2151203 | 2151203 | 2022-01-25 | Rockbridge | Virginia | 51163 | 2838 | 72 |
2147951 | 2147951 | 2022-01-24 | Rockbridge | Virginia | 51163 | 2828 | 72 |
2144698 | 2144698 | 2022-01-23 | Rockbridge | Virginia | 51163 | 2775 | 72 |
2141443 | 2141443 | 2022-01-22 | Rockbridge | Virginia | 51163 | 2775 | 72 |
2138187 | 2138187 | 2022-01-21 | Rockbridge | Virginia | 51163 | 2775 | 72 |
2134933 | 2134933 | 2022-01-20 | Rockbridge | Virginia | 51163 | 2750 | 72 |
2131681 | 2131681 | 2022-01-19 | Rockbridge | Virginia | 51163 | 2723 | 72 |
2128427 | 2128427 | 2022-01-18 | Rockbridge | Virginia | 51163 | 2718 | 72 |
2125174 | 2125174 | 2022-01-17 | Rockbridge | Virginia | 51163 | 2701 | 72 |
2121922 | 2121922 | 2022-01-16 | Rockbridge | Virginia | 51163 | 2654 | 72 |
2118670 | 2118670 | 2022-01-15 | Rockbridge | Virginia | 51163 | 2654 | 72 |
2115418 | 2115418 | 2022-01-14 | Rockbridge | Virginia | 51163 | 2654 | 72 |
2112166 | 2112166 | 2022-01-13 | Rockbridge | Virginia | 51163 | 2631 | 72 |
2108914 | 2108914 | 2022-01-12 | Rockbridge | Virginia | 51163 | 2595 | 71 |
2105663 | 2105663 | 2022-01-11 | Rockbridge | Virginia | 51163 | 2581 | 71 |
2102412 | 2102412 | 2022-01-10 | Rockbridge | Virginia | 51163 | 2559 | 71 |
2099161 | 2099161 | 2022-01-09 | Rockbridge | Virginia | 51163 | 2499 | 71 |
2095910 | 2095910 | 2022-01-08 | Rockbridge | Virginia | 51163 | 2499 | 71 |
2092658 | 2092658 | 2022-01-07 | Rockbridge | Virginia | 51163 | 2499 | 71 |
2089406 | 2089406 | 2022-01-06 | Rockbridge | Virginia | 51163 | 2483 | 71 |
2086155 | 2086155 | 2022-01-05 | Rockbridge | Virginia | 51163 | 2479 | 71 |
2082903 | 2082903 | 2022-01-04 | Rockbridge | Virginia | 51163 | 2477 | 71 |
2079651 | 2079651 | 2022-01-03 | Rockbridge | Virginia | 51163 | 2463 | 70 |
2076399 | 2076399 | 2022-01-02 | Rockbridge | Virginia | 51163 | 2439 | 69 |
2073148 | 2073148 | 2022-01-01 | Rockbridge | Virginia | 51163 | 2439 | 69 |
2069897 | 2069897 | 2021-12-31 | Rockbridge | Virginia | 51163 | 2439 | 69 |
2066646 | 2066646 | 2021-12-30 | Rockbridge | Virginia | 51163 | 2425 | 69 |
2063396 | 2063396 | 2021-12-29 | Rockbridge | Virginia | 51163 | 2416 | 69 |
2060146 | 2060146 | 2021-12-28 | Rockbridge | Virginia | 51163 | 2410 | 69 |
2056897 | 2056897 | 2021-12-27 | Rockbridge | Virginia | 51163 | 2406 | 69 |
2053648 | 2053648 | 2021-12-26 | Rockbridge | Virginia | 51163 | 2398 | 69 |
2050398 | 2050398 | 2021-12-25 | Rockbridge | Virginia | 51163 | 2398 | 69 |
2047148 | 2047148 | 2021-12-24 | Rockbridge | Virginia | 51163 | 2398 | 69 |
2043898 | 2043898 | 2021-12-23 | Rockbridge | Virginia | 51163 | 2393 | 69 |
2040649 | 2040649 | 2021-12-22 | Rockbridge | Virginia | 51163 | 2388 | 68 |
2037399 | 2037399 | 2021-12-21 | Rockbridge | Virginia | 51163 | 2378 | 68 |
2034149 | 2034149 | 2021-12-20 | Rockbridge | Virginia | 51163 | 2377 | 68 |
2030899 | 2030899 | 2021-12-19 | Rockbridge | Virginia | 51163 | 2363 | 67 |
2027648 | 2027648 | 2021-12-18 | Rockbridge | Virginia | 51163 | 2363 | 67 |
2024397 | 2024397 | 2021-12-17 | Rockbridge | Virginia | 51163 | 2363 | 67 |
2021146 | 2021146 | 2021-12-16 | Rockbridge | Virginia | 51163 | 2358 | 67 |
2017895 | 2017895 | 2021-12-15 | Rockbridge | Virginia | 51163 | 2353 | 67 |
2014645 | 2014645 | 2021-12-14 | Rockbridge | Virginia | 51163 | 2352 | 67 |
2011394 | 2011394 | 2021-12-13 | Rockbridge | Virginia | 51163 | 2350 | 67 |
2008143 | 2008143 | 2021-12-12 | Rockbridge | Virginia | 51163 | 2328 | 66 |
2004892 | 2004892 | 2021-12-11 | Rockbridge | Virginia | 51163 | 2328 | 66 |
2001641 | 2001641 | 2021-12-10 | Rockbridge | Virginia | 51163 | 2328 | 66 |
1998391 | 1998391 | 2021-12-09 | Rockbridge | Virginia | 51163 | 2319 | 66 |
1995140 | 1995140 | 2021-12-08 | Rockbridge | Virginia | 51163 | 2315 | 66 |
1991889 | 1991889 | 2021-12-07 | Rockbridge | Virginia | 51163 | 2309 | 66 |
1988638 | 1988638 | 2021-12-06 | Rockbridge | Virginia | 51163 | 2306 | 66 |
1985388 | 1985388 | 2021-12-05 | Rockbridge | Virginia | 51163 | 2294 | 66 |
1982138 | 1982138 | 2021-12-04 | Rockbridge | Virginia | 51163 | 2294 | 66 |
1978888 | 1978888 | 2021-12-03 | Rockbridge | Virginia | 51163 | 2294 | 66 |
1975638 | 1975638 | 2021-12-02 | Rockbridge | Virginia | 51163 | 2288 | 66 |
1972389 | 1972389 | 2021-12-01 | Rockbridge | Virginia | 51163 | 2286 | 66 |
1969139 | 1969139 | 2021-11-30 | Rockbridge | Virginia | 51163 | 2283 | 66 |
1965889 | 1965889 | 2021-11-29 | Rockbridge | Virginia | 51163 | 2279 | 66 |
1962637 | 1962637 | 2021-11-28 | Rockbridge | Virginia | 51163 | 2270 | 66 |
1959386 | 1959386 | 2021-11-27 | Rockbridge | Virginia | 51163 | 2270 | 66 |
1956135 | 1956135 | 2021-11-26 | Rockbridge | Virginia | 51163 | 2270 | 66 |
1952884 | 1952884 | 2021-11-25 | Rockbridge | Virginia | 51163 | 2266 | 66 |
1949633 | 1949633 | 2021-11-24 | Rockbridge | Virginia | 51163 | 2257 | 66 |
1946382 | 1946382 | 2021-11-23 | Rockbridge | Virginia | 51163 | 2252 | 65 |
1943131 | 1943131 | 2021-11-22 | Rockbridge | Virginia | 51163 | 2251 | 65 |
1939881 | 1939881 | 2021-11-21 | Rockbridge | Virginia | 51163 | 2234 | 65 |
1936631 | 1936631 | 2021-11-20 | Rockbridge | Virginia | 51163 | 2234 | 65 |
1933381 | 1933381 | 2021-11-19 | Rockbridge | Virginia | 51163 | 2234 | 65 |
1930129 | 1930129 | 2021-11-18 | Rockbridge | Virginia | 51163 | 2229 | 65 |
1926879 | 1926879 | 2021-11-17 | Rockbridge | Virginia | 51163 | 2216 | 65 |
1923629 | 1923629 | 2021-11-16 | Rockbridge | Virginia | 51163 | 2208 | 64 |
1920380 | 1920380 | 2021-11-15 | Rockbridge | Virginia | 51163 | 2204 | 64 |
1917130 | 1917130 | 2021-11-14 | Rockbridge | Virginia | 51163 | 2192 | 63 |
1913880 | 1913880 | 2021-11-13 | Rockbridge | Virginia | 51163 | 2192 | 63 |
1910630 | 1910630 | 2021-11-12 | Rockbridge | Virginia | 51163 | 2192 | 63 |
1907381 | 1907381 | 2021-11-11 | Rockbridge | Virginia | 51163 | 2186 | 62 |
1904132 | 1904132 | 2021-11-10 | Rockbridge | Virginia | 51163 | 2177 | 61 |
1900882 | 1900882 | 2021-11-09 | Rockbridge | Virginia | 51163 | 2173 | 61 |
1897632 | 1897632 | 2021-11-08 | Rockbridge | Virginia | 51163 | 2171 | 61 |
1894382 | 1894382 | 2021-11-07 | Rockbridge | Virginia | 51163 | 2160 | 59 |
1891132 | 1891132 | 2021-11-06 | Rockbridge | Virginia | 51163 | 2160 | 59 |
1887882 | 1887882 | 2021-11-05 | Rockbridge | Virginia | 51163 | 2160 | 59 |
1884632 | 1884632 | 2021-11-04 | Rockbridge | Virginia | 51163 | 2151 | 58 |
1881383 | 1881383 | 2021-11-03 | Rockbridge | Virginia | 51163 | 2150 | 58 |
1878134 | 1878134 | 2021-11-02 | Rockbridge | Virginia | 51163 | 2147 | 58 |
1874885 | 1874885 | 2021-11-01 | Rockbridge | Virginia | 51163 | 2142 | 58 |
1871636 | 1871636 | 2021-10-31 | Rockbridge | Virginia | 51163 | 2128 | 58 |
1868387 | 1868387 | 2021-10-30 | Rockbridge | Virginia | 51163 | 2128 | 58 |
1865138 | 1865138 | 2021-10-29 | Rockbridge | Virginia | 51163 | 2128 | 58 |
1861889 | 1861889 | 2021-10-28 | Rockbridge | Virginia | 51163 | 2122 | 58 |
1858640 | 1858640 | 2021-10-27 | Rockbridge | Virginia | 51163 | 2118 | 57 |
1855391 | 1855391 | 2021-10-26 | Rockbridge | Virginia | 51163 | 2115 | 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);