ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Radford city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502612 | 2502612 | 2022-05-13 | Radford city | Virginia | 51750 | 5018 | 53 |
2499354 | 2499354 | 2022-05-12 | Radford city | Virginia | 51750 | 5003 | 53 |
2496096 | 2496096 | 2022-05-11 | Radford city | Virginia | 51750 | 4993 | 53 |
2492838 | 2492838 | 2022-05-10 | Radford city | Virginia | 51750 | 4989 | 53 |
2489580 | 2489580 | 2022-05-09 | Radford city | Virginia | 51750 | 4982 | 53 |
2486323 | 2486323 | 2022-05-08 | Radford city | Virginia | 51750 | 4977 | 53 |
2483065 | 2483065 | 2022-05-07 | Radford city | Virginia | 51750 | 4977 | 53 |
2479807 | 2479807 | 2022-05-06 | Radford city | Virginia | 51750 | 4977 | 53 |
2476549 | 2476549 | 2022-05-05 | Radford city | Virginia | 51750 | 4970 | 53 |
2473291 | 2473291 | 2022-05-04 | Radford city | Virginia | 51750 | 4965 | 53 |
2470035 | 2470035 | 2022-05-03 | Radford city | Virginia | 51750 | 4958 | 53 |
2466779 | 2466779 | 2022-05-02 | Radford city | Virginia | 51750 | 4956 | 53 |
2463524 | 2463524 | 2022-05-01 | Radford city | Virginia | 51750 | 4949 | 53 |
2460268 | 2460268 | 2022-04-30 | Radford city | Virginia | 51750 | 4949 | 53 |
2457012 | 2457012 | 2022-04-29 | Radford city | Virginia | 51750 | 4949 | 53 |
2453756 | 2453756 | 2022-04-28 | Radford city | Virginia | 51750 | 4947 | 53 |
2450500 | 2450500 | 2022-04-27 | Radford city | Virginia | 51750 | 4940 | 53 |
2447243 | 2447243 | 2022-04-26 | Radford city | Virginia | 51750 | 4937 | 52 |
2443988 | 2443988 | 2022-04-25 | Radford city | Virginia | 51750 | 4934 | 52 |
2440732 | 2440732 | 2022-04-24 | Radford city | Virginia | 51750 | 4932 | 52 |
2437476 | 2437476 | 2022-04-23 | Radford city | Virginia | 51750 | 4932 | 52 |
2434220 | 2434220 | 2022-04-22 | Radford city | Virginia | 51750 | 4932 | 52 |
2430964 | 2430964 | 2022-04-21 | Radford city | Virginia | 51750 | 4931 | 52 |
2427708 | 2427708 | 2022-04-20 | Radford city | Virginia | 51750 | 4929 | 52 |
2424452 | 2424452 | 2022-04-19 | Radford city | Virginia | 51750 | 4928 | 52 |
2421196 | 2421196 | 2022-04-18 | Radford city | Virginia | 51750 | 4926 | 52 |
2417940 | 2417940 | 2022-04-17 | Radford city | Virginia | 51750 | 4922 | 52 |
2414684 | 2414684 | 2022-04-16 | Radford city | Virginia | 51750 | 4922 | 52 |
2411428 | 2411428 | 2022-04-15 | Radford city | Virginia | 51750 | 4922 | 52 |
2408172 | 2408172 | 2022-04-14 | Radford city | Virginia | 51750 | 4918 | 52 |
2404916 | 2404916 | 2022-04-13 | Radford city | Virginia | 51750 | 4915 | 52 |
2401661 | 2401661 | 2022-04-12 | Radford city | Virginia | 51750 | 4912 | 50 |
2398406 | 2398406 | 2022-04-11 | Radford city | Virginia | 51750 | 4911 | 50 |
2395151 | 2395151 | 2022-04-10 | Radford city | Virginia | 51750 | 4910 | 49 |
2391895 | 2391895 | 2022-04-09 | Radford city | Virginia | 51750 | 4910 | 49 |
2388639 | 2388639 | 2022-04-08 | Radford city | Virginia | 51750 | 4910 | 49 |
2385384 | 2385384 | 2022-04-07 | Radford city | Virginia | 51750 | 4911 | 49 |
2382129 | 2382129 | 2022-04-06 | Radford city | Virginia | 51750 | 4910 | 49 |
2378874 | 2378874 | 2022-04-05 | Radford city | Virginia | 51750 | 4909 | 48 |
2375620 | 2375620 | 2022-04-04 | Radford city | Virginia | 51750 | 4910 | 48 |
2372368 | 2372368 | 2022-04-03 | Radford city | Virginia | 51750 | 4909 | 48 |
2369115 | 2369115 | 2022-04-02 | Radford city | Virginia | 51750 | 4909 | 48 |
2365862 | 2365862 | 2022-04-01 | Radford city | Virginia | 51750 | 4909 | 48 |
2362609 | 2362609 | 2022-03-31 | Radford city | Virginia | 51750 | 4909 | 48 |
2359355 | 2359355 | 2022-03-30 | Radford city | Virginia | 51750 | 4909 | 48 |
2356101 | 2356101 | 2022-03-29 | Radford city | Virginia | 51750 | 4907 | 48 |
2352848 | 2352848 | 2022-03-28 | Radford city | Virginia | 51750 | 4906 | 48 |
2349596 | 2349596 | 2022-03-27 | Radford city | Virginia | 51750 | 4903 | 48 |
2346343 | 2346343 | 2022-03-26 | Radford city | Virginia | 51750 | 4903 | 48 |
2343090 | 2343090 | 2022-03-25 | Radford city | Virginia | 51750 | 4903 | 48 |
2339837 | 2339837 | 2022-03-24 | Radford city | Virginia | 51750 | 4902 | 48 |
2336583 | 2336583 | 2022-03-23 | Radford city | Virginia | 51750 | 4902 | 48 |
2333329 | 2333329 | 2022-03-22 | Radford city | Virginia | 51750 | 4902 | 48 |
2330076 | 2330076 | 2022-03-21 | Radford city | Virginia | 51750 | 4902 | 48 |
2326824 | 2326824 | 2022-03-20 | Radford city | Virginia | 51750 | 4901 | 47 |
2323571 | 2323571 | 2022-03-19 | Radford city | Virginia | 51750 | 4901 | 47 |
2320317 | 2320317 | 2022-03-18 | Radford city | Virginia | 51750 | 4901 | 47 |
2317063 | 2317063 | 2022-03-17 | Radford city | Virginia | 51750 | 4899 | 47 |
2313810 | 2313810 | 2022-03-16 | Radford city | Virginia | 51750 | 4895 | 47 |
2310557 | 2310557 | 2022-03-15 | Radford city | Virginia | 51750 | 4892 | 47 |
2307304 | 2307304 | 2022-03-14 | Radford city | Virginia | 51750 | 4890 | 47 |
2304053 | 2304053 | 2022-03-13 | Radford city | Virginia | 51750 | 4886 | 47 |
2300801 | 2300801 | 2022-03-12 | Radford city | Virginia | 51750 | 4886 | 47 |
2297549 | 2297549 | 2022-03-11 | Radford city | Virginia | 51750 | 4886 | 47 |
2294297 | 2294297 | 2022-03-10 | Radford city | Virginia | 51750 | 4884 | 46 |
2291045 | 2291045 | 2022-03-09 | Radford city | Virginia | 51750 | 4880 | 46 |
2287793 | 2287793 | 2022-03-08 | Radford city | Virginia | 51750 | 4878 | 46 |
2284541 | 2284541 | 2022-03-07 | Radford city | Virginia | 51750 | 4875 | 46 |
2281289 | 2281289 | 2022-03-06 | Radford city | Virginia | 51750 | 4868 | 46 |
2278036 | 2278036 | 2022-03-05 | Radford city | Virginia | 51750 | 4868 | 46 |
2274783 | 2274783 | 2022-03-04 | Radford city | Virginia | 51750 | 4868 | 46 |
2271530 | 2271530 | 2022-03-03 | Radford city | Virginia | 51750 | 4866 | 46 |
2268278 | 2268278 | 2022-03-02 | Radford city | Virginia | 51750 | 4864 | 46 |
2265025 | 2265025 | 2022-03-01 | Radford city | Virginia | 51750 | 4860 | 46 |
2261775 | 2261775 | 2022-02-28 | Radford city | Virginia | 51750 | 4856 | 46 |
2258524 | 2258524 | 2022-02-27 | Radford city | Virginia | 51750 | 4833 | 46 |
2255273 | 2255273 | 2022-02-26 | Radford city | Virginia | 51750 | 4833 | 46 |
2252022 | 2252022 | 2022-02-25 | Radford city | Virginia | 51750 | 4833 | 46 |
2248771 | 2248771 | 2022-02-24 | Radford city | Virginia | 51750 | 4822 | 46 |
2245520 | 2245520 | 2022-02-23 | Radford city | Virginia | 51750 | 4807 | 46 |
2242269 | 2242269 | 2022-02-22 | Radford city | Virginia | 51750 | 4803 | 46 |
2239018 | 2239018 | 2022-02-21 | Radford city | Virginia | 51750 | 4793 | 45 |
2235767 | 2235767 | 2022-02-20 | Radford city | Virginia | 51750 | 4761 | 45 |
2232516 | 2232516 | 2022-02-19 | Radford city | Virginia | 51750 | 4761 | 45 |
2229265 | 2229265 | 2022-02-18 | Radford city | Virginia | 51750 | 4761 | 45 |
2226014 | 2226014 | 2022-02-17 | Radford city | Virginia | 51750 | 4749 | 45 |
2222763 | 2222763 | 2022-02-16 | Radford city | Virginia | 51750 | 4735 | 44 |
2219512 | 2219512 | 2022-02-15 | Radford city | Virginia | 51750 | 4724 | 44 |
2216262 | 2216262 | 2022-02-14 | Radford city | Virginia | 51750 | 4720 | 44 |
2213011 | 2213011 | 2022-02-13 | Radford city | Virginia | 51750 | 4693 | 43 |
2209758 | 2209758 | 2022-02-12 | Radford city | Virginia | 51750 | 4693 | 43 |
2206505 | 2206505 | 2022-02-11 | Radford city | Virginia | 51750 | 4693 | 43 |
2203252 | 2203252 | 2022-02-10 | Radford city | Virginia | 51750 | 4674 | 43 |
2199998 | 2199998 | 2022-02-09 | Radford city | Virginia | 51750 | 4656 | 43 |
2196744 | 2196744 | 2022-02-08 | Radford city | Virginia | 51750 | 4626 | 42 |
2193489 | 2193489 | 2022-02-07 | Radford city | Virginia | 51750 | 4615 | 42 |
2190236 | 2190236 | 2022-02-06 | Radford city | Virginia | 51750 | 4547 | 41 |
2186983 | 2186983 | 2022-02-05 | Radford city | Virginia | 51750 | 4547 | 41 |
2183730 | 2183730 | 2022-02-04 | Radford city | Virginia | 51750 | 4547 | 41 |
2180478 | 2180478 | 2022-02-03 | Radford city | Virginia | 51750 | 4509 | 39 |
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);