ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,307 rows where county = "Grayson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Grayson · 2,207 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394837 | 2394837 | 2022-04-10 | Grayson | Texas | 48181 | 27097 | 633 |
2395100 | 2395100 | 2022-04-10 | Grayson | Virginia | 51077 | 4040 | 79 |
2389905 | 2389905 | 2022-04-09 | Grayson | Kentucky | 21085 | 8121 | 126 |
2391581 | 2391581 | 2022-04-09 | Grayson | Texas | 48181 | 27094 | 633 |
2391844 | 2391844 | 2022-04-09 | Grayson | Virginia | 51077 | 4040 | 79 |
2386649 | 2386649 | 2022-04-08 | Grayson | Kentucky | 21085 | 8121 | 126 |
2388325 | 2388325 | 2022-04-08 | Grayson | Texas | 48181 | 27094 | 632 |
2388588 | 2388588 | 2022-04-08 | Grayson | Virginia | 51077 | 4040 | 79 |
2383394 | 2383394 | 2022-04-07 | Grayson | Kentucky | 21085 | 8121 | 126 |
2385070 | 2385070 | 2022-04-07 | Grayson | Texas | 48181 | 27094 | 632 |
2385333 | 2385333 | 2022-04-07 | Grayson | Virginia | 51077 | 4040 | 79 |
2380139 | 2380139 | 2022-04-06 | Grayson | Kentucky | 21085 | 8121 | 126 |
2381815 | 2381815 | 2022-04-06 | Grayson | Texas | 48181 | 27092 | 631 |
2382078 | 2382078 | 2022-04-06 | Grayson | Virginia | 51077 | 4040 | 79 |
2376884 | 2376884 | 2022-04-05 | Grayson | Kentucky | 21085 | 8121 | 126 |
2378560 | 2378560 | 2022-04-05 | Grayson | Texas | 48181 | 27092 | 631 |
2378823 | 2378823 | 2022-04-05 | Grayson | Virginia | 51077 | 4039 | 79 |
2373632 | 2373632 | 2022-04-04 | Grayson | Kentucky | 21085 | 8121 | 126 |
2375306 | 2375306 | 2022-04-04 | Grayson | Texas | 48181 | 27090 | 631 |
2375569 | 2375569 | 2022-04-04 | Grayson | Virginia | 51077 | 4038 | 79 |
2370379 | 2370379 | 2022-04-03 | Grayson | Kentucky | 21085 | 8112 | 126 |
2372054 | 2372054 | 2022-04-03 | Grayson | Texas | 48181 | 27090 | 631 |
2372317 | 2372317 | 2022-04-03 | Grayson | Virginia | 51077 | 4037 | 79 |
2367126 | 2367126 | 2022-04-02 | Grayson | Kentucky | 21085 | 8112 | 126 |
2368801 | 2368801 | 2022-04-02 | Grayson | Texas | 48181 | 27090 | 629 |
2369064 | 2369064 | 2022-04-02 | Grayson | Virginia | 51077 | 4037 | 79 |
2363873 | 2363873 | 2022-04-01 | Grayson | Kentucky | 21085 | 8112 | 126 |
2365548 | 2365548 | 2022-04-01 | Grayson | Texas | 48181 | 27086 | 628 |
2365811 | 2365811 | 2022-04-01 | Grayson | Virginia | 51077 | 4037 | 79 |
2360619 | 2360619 | 2022-03-31 | Grayson | Kentucky | 21085 | 8112 | 126 |
2362295 | 2362295 | 2022-03-31 | Grayson | Texas | 48181 | 27085 | 628 |
2362558 | 2362558 | 2022-03-31 | Grayson | Virginia | 51077 | 4036 | 79 |
2357365 | 2357365 | 2022-03-30 | Grayson | Kentucky | 21085 | 8112 | 126 |
2359041 | 2359041 | 2022-03-30 | Grayson | Texas | 48181 | 27084 | 628 |
2359304 | 2359304 | 2022-03-30 | Grayson | Virginia | 51077 | 4036 | 79 |
2354112 | 2354112 | 2022-03-29 | Grayson | Kentucky | 21085 | 8112 | 126 |
2355787 | 2355787 | 2022-03-29 | Grayson | Texas | 48181 | 27083 | 628 |
2356050 | 2356050 | 2022-03-29 | Grayson | Virginia | 51077 | 4035 | 79 |
2350860 | 2350860 | 2022-03-28 | Grayson | Kentucky | 21085 | 8112 | 126 |
2352534 | 2352534 | 2022-03-28 | Grayson | Texas | 48181 | 27079 | 628 |
2352797 | 2352797 | 2022-03-28 | Grayson | Virginia | 51077 | 4035 | 79 |
2347607 | 2347607 | 2022-03-27 | Grayson | Kentucky | 21085 | 8098 | 125 |
2349282 | 2349282 | 2022-03-27 | Grayson | Texas | 48181 | 27078 | 628 |
2349545 | 2349545 | 2022-03-27 | Grayson | Virginia | 51077 | 4035 | 79 |
2344354 | 2344354 | 2022-03-26 | Grayson | Kentucky | 21085 | 8098 | 125 |
2346029 | 2346029 | 2022-03-26 | Grayson | Texas | 48181 | 27077 | 628 |
2346292 | 2346292 | 2022-03-26 | Grayson | Virginia | 51077 | 4035 | 79 |
2341101 | 2341101 | 2022-03-25 | Grayson | Kentucky | 21085 | 8098 | 125 |
2342776 | 2342776 | 2022-03-25 | Grayson | Texas | 48181 | 27073 | 626 |
2343039 | 2343039 | 2022-03-25 | Grayson | Virginia | 51077 | 4035 | 79 |
2337848 | 2337848 | 2022-03-24 | Grayson | Kentucky | 21085 | 8098 | 125 |
2339523 | 2339523 | 2022-03-24 | Grayson | Texas | 48181 | 27068 | 623 |
2339786 | 2339786 | 2022-03-24 | Grayson | Virginia | 51077 | 4034 | 79 |
2334594 | 2334594 | 2022-03-23 | Grayson | Kentucky | 21085 | 8098 | 125 |
2336269 | 2336269 | 2022-03-23 | Grayson | Texas | 48181 | 27066 | 621 |
2336532 | 2336532 | 2022-03-23 | Grayson | Virginia | 51077 | 4033 | 79 |
2331340 | 2331340 | 2022-03-22 | Grayson | Kentucky | 21085 | 8098 | 125 |
2333015 | 2333015 | 2022-03-22 | Grayson | Texas | 48181 | 27066 | 620 |
2333278 | 2333278 | 2022-03-22 | Grayson | Virginia | 51077 | 4032 | 79 |
2328088 | 2328088 | 2022-03-21 | Grayson | Kentucky | 21085 | 8098 | 125 |
2329762 | 2329762 | 2022-03-21 | Grayson | Texas | 48181 | 27064 | 620 |
2330025 | 2330025 | 2022-03-21 | Grayson | Virginia | 51077 | 4032 | 79 |
2324835 | 2324835 | 2022-03-20 | Grayson | Kentucky | 21085 | 8066 | 122 |
2326510 | 2326510 | 2022-03-20 | Grayson | Texas | 48181 | 27063 | 620 |
2326773 | 2326773 | 2022-03-20 | Grayson | Virginia | 51077 | 4030 | 79 |
2321581 | 2321581 | 2022-03-19 | Grayson | Kentucky | 21085 | 8066 | 122 |
2323257 | 2323257 | 2022-03-19 | Grayson | Texas | 48181 | 27053 | 620 |
2323520 | 2323520 | 2022-03-19 | Grayson | Virginia | 51077 | 4030 | 79 |
2318327 | 2318327 | 2022-03-18 | Grayson | Kentucky | 21085 | 8066 | 122 |
2320003 | 2320003 | 2022-03-18 | Grayson | Texas | 48181 | 27052 | 620 |
2320266 | 2320266 | 2022-03-18 | Grayson | Virginia | 51077 | 4030 | 79 |
2315074 | 2315074 | 2022-03-17 | Grayson | Kentucky | 21085 | 8066 | 122 |
2316749 | 2316749 | 2022-03-17 | Grayson | Texas | 48181 | 27050 | 620 |
2317012 | 2317012 | 2022-03-17 | Grayson | Virginia | 51077 | 4030 | 79 |
2311821 | 2311821 | 2022-03-16 | Grayson | Kentucky | 21085 | 8066 | 122 |
2313496 | 2313496 | 2022-03-16 | Grayson | Texas | 48181 | 27044 | 622 |
2313759 | 2313759 | 2022-03-16 | Grayson | Virginia | 51077 | 4030 | 79 |
2308568 | 2308568 | 2022-03-15 | Grayson | Kentucky | 21085 | 8066 | 122 |
2310243 | 2310243 | 2022-03-15 | Grayson | Texas | 48181 | 27042 | 622 |
2310506 | 2310506 | 2022-03-15 | Grayson | Virginia | 51077 | 4025 | 79 |
2305317 | 2305317 | 2022-03-14 | Grayson | Kentucky | 21085 | 8066 | 122 |
2306990 | 2306990 | 2022-03-14 | Grayson | Texas | 48181 | 27042 | 622 |
2307253 | 2307253 | 2022-03-14 | Grayson | Virginia | 51077 | 4014 | 79 |
2302065 | 2302065 | 2022-03-13 | Grayson | Kentucky | 21085 | 8045 | 122 |
2303739 | 2303739 | 2022-03-13 | Grayson | Texas | 48181 | 27039 | 622 |
2304002 | 2304002 | 2022-03-13 | Grayson | Virginia | 51077 | 4006 | 77 |
2298813 | 2298813 | 2022-03-12 | Grayson | Kentucky | 21085 | 8045 | 122 |
2300487 | 2300487 | 2022-03-12 | Grayson | Texas | 48181 | 27038 | 622 |
2300750 | 2300750 | 2022-03-12 | Grayson | Virginia | 51077 | 4006 | 77 |
2295561 | 2295561 | 2022-03-11 | Grayson | Kentucky | 21085 | 8045 | 122 |
2297235 | 2297235 | 2022-03-11 | Grayson | Texas | 48181 | 27037 | 620 |
2297498 | 2297498 | 2022-03-11 | Grayson | Virginia | 51077 | 4006 | 77 |
2292309 | 2292309 | 2022-03-10 | Grayson | Kentucky | 21085 | 8045 | 122 |
2293983 | 2293983 | 2022-03-10 | Grayson | Texas | 48181 | 27029 | 620 |
2294246 | 2294246 | 2022-03-10 | Grayson | Virginia | 51077 | 3996 | 77 |
2289057 | 2289057 | 2022-03-09 | Grayson | Kentucky | 21085 | 8045 | 122 |
2290731 | 2290731 | 2022-03-09 | Grayson | Texas | 48181 | 27022 | 619 |
2290994 | 2290994 | 2022-03-09 | Grayson | Virginia | 51077 | 3994 | 77 |
2285806 | 2285806 | 2022-03-08 | Grayson | Kentucky | 21085 | 8045 | 122 |
2287479 | 2287479 | 2022-03-08 | Grayson | Texas | 48181 | 27019 | 618 |
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);