ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where county = "Grayson" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177176 | 2177176 | 2022-02-02 | Grayson | Virginia | 51077 | 3418 | 68 |
2173923 | 2173923 | 2022-02-01 | Grayson | Virginia | 51077 | 3315 | 67 |
2170671 | 2170671 | 2022-01-31 | Grayson | Virginia | 51077 | 3292 | 67 |
2167418 | 2167418 | 2022-01-30 | Grayson | Virginia | 51077 | 3188 | 67 |
2164163 | 2164163 | 2022-01-29 | Grayson | Virginia | 51077 | 3188 | 67 |
2160908 | 2160908 | 2022-01-28 | Grayson | Virginia | 51077 | 3188 | 67 |
2157652 | 2157652 | 2022-01-27 | Grayson | Virginia | 51077 | 3144 | 67 |
2154399 | 2154399 | 2022-01-26 | Grayson | Virginia | 51077 | 3111 | 67 |
2151146 | 2151146 | 2022-01-25 | Grayson | Virginia | 51077 | 3076 | 67 |
2147894 | 2147894 | 2022-01-24 | Grayson | Virginia | 51077 | 3053 | 67 |
2144641 | 2144641 | 2022-01-23 | Grayson | Virginia | 51077 | 2949 | 67 |
2141386 | 2141386 | 2022-01-22 | Grayson | Virginia | 51077 | 2949 | 67 |
2138130 | 2138130 | 2022-01-21 | Grayson | Virginia | 51077 | 2949 | 67 |
2134876 | 2134876 | 2022-01-20 | Grayson | Virginia | 51077 | 2907 | 67 |
2131624 | 2131624 | 2022-01-19 | Grayson | Virginia | 51077 | 2871 | 67 |
2128370 | 2128370 | 2022-01-18 | Grayson | Virginia | 51077 | 2852 | 66 |
2125117 | 2125117 | 2022-01-17 | Grayson | Virginia | 51077 | 2844 | 66 |
2121865 | 2121865 | 2022-01-16 | Grayson | Virginia | 51077 | 2767 | 65 |
2118613 | 2118613 | 2022-01-15 | Grayson | Virginia | 51077 | 2767 | 65 |
2115361 | 2115361 | 2022-01-14 | Grayson | Virginia | 51077 | 2767 | 65 |
2112109 | 2112109 | 2022-01-13 | Grayson | Virginia | 51077 | 2747 | 65 |
2108857 | 2108857 | 2022-01-12 | Grayson | Virginia | 51077 | 2724 | 65 |
2105606 | 2105606 | 2022-01-11 | Grayson | Virginia | 51077 | 2712 | 64 |
2102355 | 2102355 | 2022-01-10 | Grayson | Virginia | 51077 | 2704 | 63 |
2099104 | 2099104 | 2022-01-09 | Grayson | Virginia | 51077 | 2672 | 63 |
2095853 | 2095853 | 2022-01-08 | Grayson | Virginia | 51077 | 2672 | 63 |
2092601 | 2092601 | 2022-01-07 | Grayson | Virginia | 51077 | 2672 | 63 |
2089349 | 2089349 | 2022-01-06 | Grayson | Virginia | 51077 | 2660 | 63 |
2086098 | 2086098 | 2022-01-05 | Grayson | Virginia | 51077 | 2655 | 63 |
2082846 | 2082846 | 2022-01-04 | Grayson | Virginia | 51077 | 2649 | 63 |
2079594 | 2079594 | 2022-01-03 | Grayson | Virginia | 51077 | 2641 | 63 |
2076342 | 2076342 | 2022-01-02 | Grayson | Virginia | 51077 | 2612 | 62 |
2073091 | 2073091 | 2022-01-01 | Grayson | Virginia | 51077 | 2612 | 62 |
2069840 | 2069840 | 2021-12-31 | Grayson | Virginia | 51077 | 2612 | 62 |
2066589 | 2066589 | 2021-12-30 | Grayson | Virginia | 51077 | 2601 | 62 |
2063339 | 2063339 | 2021-12-29 | Grayson | Virginia | 51077 | 2588 | 62 |
2060089 | 2060089 | 2021-12-28 | Grayson | Virginia | 51077 | 2579 | 62 |
2056840 | 2056840 | 2021-12-27 | Grayson | Virginia | 51077 | 2572 | 59 |
2053591 | 2053591 | 2021-12-26 | Grayson | Virginia | 51077 | 2555 | 59 |
2050341 | 2050341 | 2021-12-25 | Grayson | Virginia | 51077 | 2555 | 59 |
2047091 | 2047091 | 2021-12-24 | Grayson | Virginia | 51077 | 2555 | 59 |
2043841 | 2043841 | 2021-12-23 | Grayson | Virginia | 51077 | 2544 | 56 |
2040592 | 2040592 | 2021-12-22 | Grayson | Virginia | 51077 | 2532 | 56 |
2037342 | 2037342 | 2021-12-21 | Grayson | Virginia | 51077 | 2527 | 56 |
2034092 | 2034092 | 2021-12-20 | Grayson | Virginia | 51077 | 2515 | 56 |
2030842 | 2030842 | 2021-12-19 | Grayson | Virginia | 51077 | 2485 | 56 |
2027591 | 2027591 | 2021-12-18 | Grayson | Virginia | 51077 | 2485 | 56 |
2024340 | 2024340 | 2021-12-17 | Grayson | Virginia | 51077 | 2485 | 56 |
2021089 | 2021089 | 2021-12-16 | Grayson | Virginia | 51077 | 2438 | 56 |
2017838 | 2017838 | 2021-12-15 | Grayson | Virginia | 51077 | 2416 | 56 |
2014588 | 2014588 | 2021-12-14 | Grayson | Virginia | 51077 | 2407 | 55 |
2011337 | 2011337 | 2021-12-13 | Grayson | Virginia | 51077 | 2404 | 54 |
2008086 | 2008086 | 2021-12-12 | Grayson | Virginia | 51077 | 2376 | 54 |
2004835 | 2004835 | 2021-12-11 | Grayson | Virginia | 51077 | 2376 | 54 |
2001584 | 2001584 | 2021-12-10 | Grayson | Virginia | 51077 | 2376 | 54 |
1998334 | 1998334 | 2021-12-09 | Grayson | Virginia | 51077 | 2353 | 53 |
1995083 | 1995083 | 2021-12-08 | Grayson | Virginia | 51077 | 2343 | 53 |
1991832 | 1991832 | 2021-12-07 | Grayson | Virginia | 51077 | 2333 | 52 |
1988581 | 1988581 | 2021-12-06 | Grayson | Virginia | 51077 | 2326 | 52 |
1985331 | 1985331 | 2021-12-05 | Grayson | Virginia | 51077 | 2312 | 52 |
1982081 | 1982081 | 2021-12-04 | Grayson | Virginia | 51077 | 2312 | 52 |
1978831 | 1978831 | 2021-12-03 | Grayson | Virginia | 51077 | 2312 | 52 |
1975581 | 1975581 | 2021-12-02 | Grayson | Virginia | 51077 | 2309 | 52 |
1972332 | 1972332 | 2021-12-01 | Grayson | Virginia | 51077 | 2303 | 52 |
1969082 | 1969082 | 2021-11-30 | Grayson | Virginia | 51077 | 2287 | 52 |
1965832 | 1965832 | 2021-11-29 | Grayson | Virginia | 51077 | 2286 | 52 |
1962580 | 1962580 | 2021-11-28 | Grayson | Virginia | 51077 | 2271 | 51 |
1959329 | 1959329 | 2021-11-27 | Grayson | Virginia | 51077 | 2271 | 51 |
1956078 | 1956078 | 2021-11-26 | Grayson | Virginia | 51077 | 2271 | 51 |
1952827 | 1952827 | 2021-11-25 | Grayson | Virginia | 51077 | 2269 | 51 |
1949576 | 1949576 | 2021-11-24 | Grayson | Virginia | 51077 | 2266 | 51 |
1946325 | 1946325 | 2021-11-23 | Grayson | Virginia | 51077 | 2259 | 51 |
1943074 | 1943074 | 2021-11-22 | Grayson | Virginia | 51077 | 2253 | 50 |
1939824 | 1939824 | 2021-11-21 | Grayson | Virginia | 51077 | 2231 | 48 |
1936574 | 1936574 | 2021-11-20 | Grayson | Virginia | 51077 | 2231 | 48 |
1933324 | 1933324 | 2021-11-19 | Grayson | Virginia | 51077 | 2231 | 48 |
1930072 | 1930072 | 2021-11-18 | Grayson | Virginia | 51077 | 2209 | 48 |
1926822 | 1926822 | 2021-11-17 | Grayson | Virginia | 51077 | 2199 | 48 |
1923572 | 1923572 | 2021-11-16 | Grayson | Virginia | 51077 | 2191 | 48 |
1920323 | 1920323 | 2021-11-15 | Grayson | Virginia | 51077 | 2187 | 48 |
1917073 | 1917073 | 2021-11-14 | Grayson | Virginia | 51077 | 2166 | 47 |
1913823 | 1913823 | 2021-11-13 | Grayson | Virginia | 51077 | 2166 | 47 |
1910573 | 1910573 | 2021-11-12 | Grayson | Virginia | 51077 | 2166 | 47 |
1907324 | 1907324 | 2021-11-11 | Grayson | Virginia | 51077 | 2154 | 47 |
1904075 | 1904075 | 2021-11-10 | Grayson | Virginia | 51077 | 2144 | 47 |
1900825 | 1900825 | 2021-11-09 | Grayson | Virginia | 51077 | 2138 | 47 |
1897575 | 1897575 | 2021-11-08 | Grayson | Virginia | 51077 | 2133 | 47 |
1894325 | 1894325 | 2021-11-07 | Grayson | Virginia | 51077 | 2123 | 46 |
1891075 | 1891075 | 2021-11-06 | Grayson | Virginia | 51077 | 2123 | 46 |
1887825 | 1887825 | 2021-11-05 | Grayson | Virginia | 51077 | 2123 | 46 |
1884575 | 1884575 | 2021-11-04 | Grayson | Virginia | 51077 | 2118 | 46 |
1881326 | 1881326 | 2021-11-03 | Grayson | Virginia | 51077 | 2109 | 46 |
1878077 | 1878077 | 2021-11-02 | Grayson | Virginia | 51077 | 2105 | 46 |
1874828 | 1874828 | 2021-11-01 | Grayson | Virginia | 51077 | 2095 | 46 |
1871579 | 1871579 | 2021-10-31 | Grayson | Virginia | 51077 | 2076 | 46 |
1868330 | 1868330 | 2021-10-30 | Grayson | Virginia | 51077 | 2076 | 46 |
1865081 | 1865081 | 2021-10-29 | Grayson | Virginia | 51077 | 2076 | 46 |
1861832 | 1861832 | 2021-10-28 | Grayson | Virginia | 51077 | 2070 | 46 |
1858583 | 1858583 | 2021-10-27 | Grayson | Virginia | 51077 | 2065 | 46 |
1855334 | 1855334 | 2021-10-26 | Grayson | Virginia | 51077 | 2062 | 46 |
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);