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 |
---|---|---|---|---|---|---|---|
2395100 | 2395100 | 2022-04-10 | Grayson | Virginia | 51077 | 4040 | 79 |
2391844 | 2391844 | 2022-04-09 | Grayson | Virginia | 51077 | 4040 | 79 |
2388588 | 2388588 | 2022-04-08 | Grayson | Virginia | 51077 | 4040 | 79 |
2385333 | 2385333 | 2022-04-07 | Grayson | Virginia | 51077 | 4040 | 79 |
2382078 | 2382078 | 2022-04-06 | Grayson | Virginia | 51077 | 4040 | 79 |
2378823 | 2378823 | 2022-04-05 | Grayson | Virginia | 51077 | 4039 | 79 |
2375569 | 2375569 | 2022-04-04 | Grayson | Virginia | 51077 | 4038 | 79 |
2372317 | 2372317 | 2022-04-03 | Grayson | Virginia | 51077 | 4037 | 79 |
2369064 | 2369064 | 2022-04-02 | Grayson | Virginia | 51077 | 4037 | 79 |
2365811 | 2365811 | 2022-04-01 | Grayson | Virginia | 51077 | 4037 | 79 |
2362558 | 2362558 | 2022-03-31 | Grayson | Virginia | 51077 | 4036 | 79 |
2359304 | 2359304 | 2022-03-30 | Grayson | Virginia | 51077 | 4036 | 79 |
2356050 | 2356050 | 2022-03-29 | Grayson | Virginia | 51077 | 4035 | 79 |
2352797 | 2352797 | 2022-03-28 | Grayson | Virginia | 51077 | 4035 | 79 |
2349545 | 2349545 | 2022-03-27 | Grayson | Virginia | 51077 | 4035 | 79 |
2346292 | 2346292 | 2022-03-26 | Grayson | Virginia | 51077 | 4035 | 79 |
2343039 | 2343039 | 2022-03-25 | Grayson | Virginia | 51077 | 4035 | 79 |
2339786 | 2339786 | 2022-03-24 | Grayson | Virginia | 51077 | 4034 | 79 |
2336532 | 2336532 | 2022-03-23 | Grayson | Virginia | 51077 | 4033 | 79 |
2333278 | 2333278 | 2022-03-22 | Grayson | Virginia | 51077 | 4032 | 79 |
2330025 | 2330025 | 2022-03-21 | Grayson | Virginia | 51077 | 4032 | 79 |
2326773 | 2326773 | 2022-03-20 | Grayson | Virginia | 51077 | 4030 | 79 |
2323520 | 2323520 | 2022-03-19 | Grayson | Virginia | 51077 | 4030 | 79 |
2320266 | 2320266 | 2022-03-18 | Grayson | Virginia | 51077 | 4030 | 79 |
2317012 | 2317012 | 2022-03-17 | Grayson | Virginia | 51077 | 4030 | 79 |
2313759 | 2313759 | 2022-03-16 | Grayson | Virginia | 51077 | 4030 | 79 |
2310506 | 2310506 | 2022-03-15 | Grayson | Virginia | 51077 | 4025 | 79 |
2307253 | 2307253 | 2022-03-14 | Grayson | Virginia | 51077 | 4014 | 79 |
2304002 | 2304002 | 2022-03-13 | Grayson | Virginia | 51077 | 4006 | 77 |
2300750 | 2300750 | 2022-03-12 | Grayson | Virginia | 51077 | 4006 | 77 |
2297498 | 2297498 | 2022-03-11 | Grayson | Virginia | 51077 | 4006 | 77 |
2294246 | 2294246 | 2022-03-10 | Grayson | Virginia | 51077 | 3996 | 77 |
2290994 | 2290994 | 2022-03-09 | Grayson | Virginia | 51077 | 3994 | 77 |
2287742 | 2287742 | 2022-03-08 | Grayson | Virginia | 51077 | 3990 | 76 |
2284490 | 2284490 | 2022-03-07 | Grayson | Virginia | 51077 | 3979 | 76 |
2281238 | 2281238 | 2022-03-06 | Grayson | Virginia | 51077 | 3975 | 77 |
2277985 | 2277985 | 2022-03-05 | Grayson | Virginia | 51077 | 3975 | 77 |
2274732 | 2274732 | 2022-03-04 | Grayson | Virginia | 51077 | 3975 | 77 |
2271479 | 2271479 | 2022-03-03 | Grayson | Virginia | 51077 | 3969 | 77 |
2268227 | 2268227 | 2022-03-02 | Grayson | Virginia | 51077 | 3964 | 77 |
2264974 | 2264974 | 2022-03-01 | Grayson | Virginia | 51077 | 3961 | 77 |
2261724 | 2261724 | 2022-02-28 | Grayson | Virginia | 51077 | 3943 | 77 |
2258473 | 2258473 | 2022-02-27 | Grayson | Virginia | 51077 | 3937 | 76 |
2255222 | 2255222 | 2022-02-26 | Grayson | Virginia | 51077 | 3937 | 76 |
2251971 | 2251971 | 2022-02-25 | Grayson | Virginia | 51077 | 3937 | 76 |
2248720 | 2248720 | 2022-02-24 | Grayson | Virginia | 51077 | 3924 | 76 |
2245469 | 2245469 | 2022-02-23 | Grayson | Virginia | 51077 | 3912 | 75 |
2242218 | 2242218 | 2022-02-22 | Grayson | Virginia | 51077 | 3892 | 75 |
2238967 | 2238967 | 2022-02-21 | Grayson | Virginia | 51077 | 3865 | 75 |
2235716 | 2235716 | 2022-02-20 | Grayson | Virginia | 51077 | 3842 | 75 |
2232465 | 2232465 | 2022-02-19 | Grayson | Virginia | 51077 | 3842 | 75 |
2229214 | 2229214 | 2022-02-18 | Grayson | Virginia | 51077 | 3842 | 75 |
2225963 | 2225963 | 2022-02-17 | Grayson | Virginia | 51077 | 3823 | 75 |
2222712 | 2222712 | 2022-02-16 | Grayson | Virginia | 51077 | 3806 | 74 |
2219461 | 2219461 | 2022-02-15 | Grayson | Virginia | 51077 | 3792 | 74 |
2216211 | 2216211 | 2022-02-14 | Grayson | Virginia | 51077 | 3773 | 74 |
2212960 | 2212960 | 2022-02-13 | Grayson | Virginia | 51077 | 3732 | 74 |
2209707 | 2209707 | 2022-02-12 | Grayson | Virginia | 51077 | 3732 | 74 |
2206454 | 2206454 | 2022-02-11 | Grayson | Virginia | 51077 | 3732 | 74 |
2203201 | 2203201 | 2022-02-10 | Grayson | Virginia | 51077 | 3714 | 74 |
2199947 | 2199947 | 2022-02-09 | Grayson | Virginia | 51077 | 3695 | 73 |
2196693 | 2196693 | 2022-02-08 | Grayson | Virginia | 51077 | 3666 | 73 |
2193438 | 2193438 | 2022-02-07 | Grayson | Virginia | 51077 | 3517 | 73 |
2190185 | 2190185 | 2022-02-06 | Grayson | Virginia | 51077 | 3462 | 70 |
2186932 | 2186932 | 2022-02-05 | Grayson | Virginia | 51077 | 3462 | 70 |
2183679 | 2183679 | 2022-02-04 | Grayson | Virginia | 51077 | 3462 | 70 |
2180427 | 2180427 | 2022-02-03 | Grayson | Virginia | 51077 | 3454 | 69 |
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 |
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);