ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

788 rows where fips = 51075 and state = "Virginia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Virginia · 788 ✖

fips 1

  • 51075 · 788 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502560 2502560 2022-05-13 Goochland Virginia 51075 4153 53
2499302 2499302 2022-05-12 Goochland Virginia 51075 4140 53
2496044 2496044 2022-05-11 Goochland Virginia 51075 4132 53
2492786 2492786 2022-05-10 Goochland Virginia 51075 4123 53
2489528 2489528 2022-05-09 Goochland Virginia 51075 4117 53
2486271 2486271 2022-05-08 Goochland Virginia 51075 4101 53
2483013 2483013 2022-05-07 Goochland Virginia 51075 4101 53
2479755 2479755 2022-05-06 Goochland Virginia 51075 4101 53
2476497 2476497 2022-05-05 Goochland Virginia 51075 4091 53
2473239 2473239 2022-05-04 Goochland Virginia 51075 4085 53
2469983 2469983 2022-05-03 Goochland Virginia 51075 4076 53
2466727 2466727 2022-05-02 Goochland Virginia 51075 4069 53
2463472 2463472 2022-05-01 Goochland Virginia 51075 4065 53
2460216 2460216 2022-04-30 Goochland Virginia 51075 4065 53
2456960 2456960 2022-04-29 Goochland Virginia 51075 4065 53
2453704 2453704 2022-04-28 Goochland Virginia 51075 4062 52
2450448 2450448 2022-04-27 Goochland Virginia 51075 4060 52
2447191 2447191 2022-04-26 Goochland Virginia 51075 4056 52
2443936 2443936 2022-04-25 Goochland Virginia 51075 4051 52
2440680 2440680 2022-04-24 Goochland Virginia 51075 4046 52
2437424 2437424 2022-04-23 Goochland Virginia 51075 4046 52
2434168 2434168 2022-04-22 Goochland Virginia 51075 4046 52
2430912 2430912 2022-04-21 Goochland Virginia 51075 4036 52
2427656 2427656 2022-04-20 Goochland Virginia 51075 4031 52
2424400 2424400 2022-04-19 Goochland Virginia 51075 4025 52
2421144 2421144 2022-04-18 Goochland Virginia 51075 4024 52
2417888 2417888 2022-04-17 Goochland Virginia 51075 4018 52
2414632 2414632 2022-04-16 Goochland Virginia 51075 4018 52
2411376 2411376 2022-04-15 Goochland Virginia 51075 4018 52
2408120 2408120 2022-04-14 Goochland Virginia 51075 4002 51
2404864 2404864 2022-04-13 Goochland Virginia 51075 3999 51
2401609 2401609 2022-04-12 Goochland Virginia 51075 3989 51
2398354 2398354 2022-04-11 Goochland Virginia 51075 3989 51
2395099 2395099 2022-04-10 Goochland Virginia 51075 3983 51
2391843 2391843 2022-04-09 Goochland Virginia 51075 3983 51
2388587 2388587 2022-04-08 Goochland Virginia 51075 3983 51
2385332 2385332 2022-04-07 Goochland Virginia 51075 3975 51
2382077 2382077 2022-04-06 Goochland Virginia 51075 3962 50
2378822 2378822 2022-04-05 Goochland Virginia 51075 3952 50
2375568 2375568 2022-04-04 Goochland Virginia 51075 3949 50
2372316 2372316 2022-04-03 Goochland Virginia 51075 3934 50
2369063 2369063 2022-04-02 Goochland Virginia 51075 3934 50
2365810 2365810 2022-04-01 Goochland Virginia 51075 3934 50
2362557 2362557 2022-03-31 Goochland Virginia 51075 3913 50
2359303 2359303 2022-03-30 Goochland Virginia 51075 3908 49
2356049 2356049 2022-03-29 Goochland Virginia 51075 3903 49
2352796 2352796 2022-03-28 Goochland Virginia 51075 3900 47
2349544 2349544 2022-03-27 Goochland Virginia 51075 3898 47
2346291 2346291 2022-03-26 Goochland Virginia 51075 3898 47
2343038 2343038 2022-03-25 Goochland Virginia 51075 3898 47
2339785 2339785 2022-03-24 Goochland Virginia 51075 3894 47
2336531 2336531 2022-03-23 Goochland Virginia 51075 3892 47
2333277 2333277 2022-03-22 Goochland Virginia 51075 3886 46
2330024 2330024 2022-03-21 Goochland Virginia 51075 3886 46
2326772 2326772 2022-03-20 Goochland Virginia 51075 3885 46
2323519 2323519 2022-03-19 Goochland Virginia 51075 3885 46
2320265 2320265 2022-03-18 Goochland Virginia 51075 3885 46
2317011 2317011 2022-03-17 Goochland Virginia 51075 3886 46
2313758 2313758 2022-03-16 Goochland Virginia 51075 3886 46
2310505 2310505 2022-03-15 Goochland Virginia 51075 3884 46
2307252 2307252 2022-03-14 Goochland Virginia 51075 3885 46
2304001 2304001 2022-03-13 Goochland Virginia 51075 3879 45
2300749 2300749 2022-03-12 Goochland Virginia 51075 3879 45
2297497 2297497 2022-03-11 Goochland Virginia 51075 3879 45
2294245 2294245 2022-03-10 Goochland Virginia 51075 3877 44
2290993 2290993 2022-03-09 Goochland Virginia 51075 3877 44
2287741 2287741 2022-03-08 Goochland Virginia 51075 3876 43
2284489 2284489 2022-03-07 Goochland Virginia 51075 3871 43
2281237 2281237 2022-03-06 Goochland Virginia 51075 3866 43
2277984 2277984 2022-03-05 Goochland Virginia 51075 3866 43
2274731 2274731 2022-03-04 Goochland Virginia 51075 3866 43
2271478 2271478 2022-03-03 Goochland Virginia 51075 3861 43
2268226 2268226 2022-03-02 Goochland Virginia 51075 3859 43
2264973 2264973 2022-03-01 Goochland Virginia 51075 3854 42
2261723 2261723 2022-02-28 Goochland Virginia 51075 3846 42
2258472 2258472 2022-02-27 Goochland Virginia 51075 3831 42
2255221 2255221 2022-02-26 Goochland Virginia 51075 3831 42
2251970 2251970 2022-02-25 Goochland Virginia 51075 3831 42
2248719 2248719 2022-02-24 Goochland Virginia 51075 3827 42
2245468 2245468 2022-02-23 Goochland Virginia 51075 3825 42
2242217 2242217 2022-02-22 Goochland Virginia 51075 3814 42
2238966 2238966 2022-02-21 Goochland Virginia 51075 3805 42
2235715 2235715 2022-02-20 Goochland Virginia 51075 3799 42
2232464 2232464 2022-02-19 Goochland Virginia 51075 3799 42
2229213 2229213 2022-02-18 Goochland Virginia 51075 3799 42
2225962 2225962 2022-02-17 Goochland Virginia 51075 3792 42
2222711 2222711 2022-02-16 Goochland Virginia 51075 3780 42
2219460 2219460 2022-02-15 Goochland Virginia 51075 3769 42
2216210 2216210 2022-02-14 Goochland Virginia 51075 3758 42
2212959 2212959 2022-02-13 Goochland Virginia 51075 3722 41
2209706 2209706 2022-02-12 Goochland Virginia 51075 3722 41
2206453 2206453 2022-02-11 Goochland Virginia 51075 3722 41
2203200 2203200 2022-02-10 Goochland Virginia 51075 3713 40
2199946 2199946 2022-02-09 Goochland Virginia 51075 3694 40
2196692 2196692 2022-02-08 Goochland Virginia 51075 3684 40
2193437 2193437 2022-02-07 Goochland Virginia 51075 3671 40
2190184 2190184 2022-02-06 Goochland Virginia 51075 3621 40
2186931 2186931 2022-02-05 Goochland Virginia 51075 3621 40
2183678 2183678 2022-02-04 Goochland Virginia 51075 3621 40
2180426 2180426 2022-02-03 Goochland Virginia 51075 3610 37

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);