ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 51071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502558 | 2502558 | 2022-05-13 | Giles | Virginia | 51071 | 4115 | 50 |
2499300 | 2499300 | 2022-05-12 | Giles | Virginia | 51071 | 4104 | 50 |
2496042 | 2496042 | 2022-05-11 | Giles | Virginia | 51071 | 4100 | 50 |
2492784 | 2492784 | 2022-05-10 | Giles | Virginia | 51071 | 4095 | 50 |
2489526 | 2489526 | 2022-05-09 | Giles | Virginia | 51071 | 4091 | 50 |
2486269 | 2486269 | 2022-05-08 | Giles | Virginia | 51071 | 4085 | 50 |
2483011 | 2483011 | 2022-05-07 | Giles | Virginia | 51071 | 4085 | 50 |
2479753 | 2479753 | 2022-05-06 | Giles | Virginia | 51071 | 4085 | 50 |
2476495 | 2476495 | 2022-05-05 | Giles | Virginia | 51071 | 4083 | 50 |
2473237 | 2473237 | 2022-05-04 | Giles | Virginia | 51071 | 4081 | 50 |
2469981 | 2469981 | 2022-05-03 | Giles | Virginia | 51071 | 4080 | 50 |
2466725 | 2466725 | 2022-05-02 | Giles | Virginia | 51071 | 4079 | 50 |
2463470 | 2463470 | 2022-05-01 | Giles | Virginia | 51071 | 4070 | 50 |
2460214 | 2460214 | 2022-04-30 | Giles | Virginia | 51071 | 4070 | 50 |
2456958 | 2456958 | 2022-04-29 | Giles | Virginia | 51071 | 4070 | 50 |
2453702 | 2453702 | 2022-04-28 | Giles | Virginia | 51071 | 4068 | 50 |
2450446 | 2450446 | 2022-04-27 | Giles | Virginia | 51071 | 4066 | 50 |
2447189 | 2447189 | 2022-04-26 | Giles | Virginia | 51071 | 4063 | 50 |
2443934 | 2443934 | 2022-04-25 | Giles | Virginia | 51071 | 4061 | 50 |
2440678 | 2440678 | 2022-04-24 | Giles | Virginia | 51071 | 4058 | 50 |
2437422 | 2437422 | 2022-04-23 | Giles | Virginia | 51071 | 4058 | 50 |
2434166 | 2434166 | 2022-04-22 | Giles | Virginia | 51071 | 4058 | 50 |
2430910 | 2430910 | 2022-04-21 | Giles | Virginia | 51071 | 4056 | 50 |
2427654 | 2427654 | 2022-04-20 | Giles | Virginia | 51071 | 4057 | 50 |
2424398 | 2424398 | 2022-04-19 | Giles | Virginia | 51071 | 4057 | 50 |
2421142 | 2421142 | 2022-04-18 | Giles | Virginia | 51071 | 4058 | 49 |
2417886 | 2417886 | 2022-04-17 | Giles | Virginia | 51071 | 4056 | 49 |
2414630 | 2414630 | 2022-04-16 | Giles | Virginia | 51071 | 4056 | 49 |
2411374 | 2411374 | 2022-04-15 | Giles | Virginia | 51071 | 4056 | 49 |
2408118 | 2408118 | 2022-04-14 | Giles | Virginia | 51071 | 4054 | 49 |
2404862 | 2404862 | 2022-04-13 | Giles | Virginia | 51071 | 4054 | 49 |
2401607 | 2401607 | 2022-04-12 | Giles | Virginia | 51071 | 4053 | 48 |
2398352 | 2398352 | 2022-04-11 | Giles | Virginia | 51071 | 4051 | 48 |
2395097 | 2395097 | 2022-04-10 | Giles | Virginia | 51071 | 4052 | 48 |
2391841 | 2391841 | 2022-04-09 | Giles | Virginia | 51071 | 4052 | 48 |
2388585 | 2388585 | 2022-04-08 | Giles | Virginia | 51071 | 4052 | 48 |
2385330 | 2385330 | 2022-04-07 | Giles | Virginia | 51071 | 4051 | 47 |
2382075 | 2382075 | 2022-04-06 | Giles | Virginia | 51071 | 4051 | 47 |
2378820 | 2378820 | 2022-04-05 | Giles | Virginia | 51071 | 4051 | 46 |
2375566 | 2375566 | 2022-04-04 | Giles | Virginia | 51071 | 4049 | 46 |
2372314 | 2372314 | 2022-04-03 | Giles | Virginia | 51071 | 4048 | 46 |
2369061 | 2369061 | 2022-04-02 | Giles | Virginia | 51071 | 4048 | 46 |
2365808 | 2365808 | 2022-04-01 | Giles | Virginia | 51071 | 4048 | 46 |
2362555 | 2362555 | 2022-03-31 | Giles | Virginia | 51071 | 4046 | 46 |
2359301 | 2359301 | 2022-03-30 | Giles | Virginia | 51071 | 4045 | 46 |
2356047 | 2356047 | 2022-03-29 | Giles | Virginia | 51071 | 4044 | 46 |
2352794 | 2352794 | 2022-03-28 | Giles | Virginia | 51071 | 4044 | 46 |
2349542 | 2349542 | 2022-03-27 | Giles | Virginia | 51071 | 4041 | 46 |
2346289 | 2346289 | 2022-03-26 | Giles | Virginia | 51071 | 4041 | 46 |
2343036 | 2343036 | 2022-03-25 | Giles | Virginia | 51071 | 4041 | 46 |
2339783 | 2339783 | 2022-03-24 | Giles | Virginia | 51071 | 4037 | 46 |
2336529 | 2336529 | 2022-03-23 | Giles | Virginia | 51071 | 4036 | 46 |
2333275 | 2333275 | 2022-03-22 | Giles | Virginia | 51071 | 4036 | 46 |
2330022 | 2330022 | 2022-03-21 | Giles | Virginia | 51071 | 4036 | 46 |
2326770 | 2326770 | 2022-03-20 | Giles | Virginia | 51071 | 4036 | 46 |
2323517 | 2323517 | 2022-03-19 | Giles | Virginia | 51071 | 4036 | 46 |
2320263 | 2320263 | 2022-03-18 | Giles | Virginia | 51071 | 4036 | 46 |
2317009 | 2317009 | 2022-03-17 | Giles | Virginia | 51071 | 4036 | 46 |
2313756 | 2313756 | 2022-03-16 | Giles | Virginia | 51071 | 4036 | 46 |
2310503 | 2310503 | 2022-03-15 | Giles | Virginia | 51071 | 4033 | 46 |
2307250 | 2307250 | 2022-03-14 | Giles | Virginia | 51071 | 4030 | 46 |
2303999 | 2303999 | 2022-03-13 | Giles | Virginia | 51071 | 4028 | 45 |
2300747 | 2300747 | 2022-03-12 | Giles | Virginia | 51071 | 4028 | 45 |
2297495 | 2297495 | 2022-03-11 | Giles | Virginia | 51071 | 4028 | 45 |
2294243 | 2294243 | 2022-03-10 | Giles | Virginia | 51071 | 4021 | 44 |
2290991 | 2290991 | 2022-03-09 | Giles | Virginia | 51071 | 4017 | 44 |
2287739 | 2287739 | 2022-03-08 | Giles | Virginia | 51071 | 4014 | 44 |
2284487 | 2284487 | 2022-03-07 | Giles | Virginia | 51071 | 4014 | 44 |
2281235 | 2281235 | 2022-03-06 | Giles | Virginia | 51071 | 4004 | 44 |
2277982 | 2277982 | 2022-03-05 | Giles | Virginia | 51071 | 4004 | 44 |
2274729 | 2274729 | 2022-03-04 | Giles | Virginia | 51071 | 4004 | 44 |
2271476 | 2271476 | 2022-03-03 | Giles | Virginia | 51071 | 3999 | 44 |
2268224 | 2268224 | 2022-03-02 | Giles | Virginia | 51071 | 3995 | 44 |
2264971 | 2264971 | 2022-03-01 | Giles | Virginia | 51071 | 3986 | 44 |
2261721 | 2261721 | 2022-02-28 | Giles | Virginia | 51071 | 3981 | 44 |
2258470 | 2258470 | 2022-02-27 | Giles | Virginia | 51071 | 3968 | 43 |
2255219 | 2255219 | 2022-02-26 | Giles | Virginia | 51071 | 3968 | 43 |
2251968 | 2251968 | 2022-02-25 | Giles | Virginia | 51071 | 3968 | 43 |
2248717 | 2248717 | 2022-02-24 | Giles | Virginia | 51071 | 3963 | 43 |
2245466 | 2245466 | 2022-02-23 | Giles | Virginia | 51071 | 3958 | 43 |
2242215 | 2242215 | 2022-02-22 | Giles | Virginia | 51071 | 3950 | 43 |
2238964 | 2238964 | 2022-02-21 | Giles | Virginia | 51071 | 3945 | 43 |
2235713 | 2235713 | 2022-02-20 | Giles | Virginia | 51071 | 3905 | 43 |
2232462 | 2232462 | 2022-02-19 | Giles | Virginia | 51071 | 3905 | 43 |
2229211 | 2229211 | 2022-02-18 | Giles | Virginia | 51071 | 3905 | 43 |
2225960 | 2225960 | 2022-02-17 | Giles | Virginia | 51071 | 3890 | 43 |
2222709 | 2222709 | 2022-02-16 | Giles | Virginia | 51071 | 3868 | 43 |
2219458 | 2219458 | 2022-02-15 | Giles | Virginia | 51071 | 3844 | 43 |
2216208 | 2216208 | 2022-02-14 | Giles | Virginia | 51071 | 3831 | 43 |
2212957 | 2212957 | 2022-02-13 | Giles | Virginia | 51071 | 3778 | 42 |
2209704 | 2209704 | 2022-02-12 | Giles | Virginia | 51071 | 3778 | 42 |
2206451 | 2206451 | 2022-02-11 | Giles | Virginia | 51071 | 3778 | 42 |
2203198 | 2203198 | 2022-02-10 | Giles | Virginia | 51071 | 3745 | 42 |
2199944 | 2199944 | 2022-02-09 | Giles | Virginia | 51071 | 3720 | 42 |
2196690 | 2196690 | 2022-02-08 | Giles | Virginia | 51071 | 3692 | 42 |
2193435 | 2193435 | 2022-02-07 | Giles | Virginia | 51071 | 3679 | 42 |
2190182 | 2190182 | 2022-02-06 | Giles | Virginia | 51071 | 3604 | 42 |
2186929 | 2186929 | 2022-02-05 | Giles | Virginia | 51071 | 3604 | 42 |
2183676 | 2183676 | 2022-02-04 | Giles | Virginia | 51071 | 3604 | 42 |
2180424 | 2180424 | 2022-02-03 | Giles | Virginia | 51071 | 3574 | 41 |
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);