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

779 rows where county = "Greene" 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 · 779 ✖

fips 1

county 1

  • Greene · 779 ✖
Link rowid date ▲ county state fips cases deaths
2502562 2502562 2022-05-13 Greene Virginia 51079 4074 62
2499304 2499304 2022-05-12 Greene Virginia 51079 4063 62
2496046 2496046 2022-05-11 Greene Virginia 51079 4059 62
2492788 2492788 2022-05-10 Greene Virginia 51079 4051 62
2489530 2489530 2022-05-09 Greene Virginia 51079 4041 62
2486273 2486273 2022-05-08 Greene Virginia 51079 4028 62
2483015 2483015 2022-05-07 Greene Virginia 51079 4028 62
2479757 2479757 2022-05-06 Greene Virginia 51079 4028 62
2476499 2476499 2022-05-05 Greene Virginia 51079 4017 62
2473241 2473241 2022-05-04 Greene Virginia 51079 4012 61
2469985 2469985 2022-05-03 Greene Virginia 51079 4004 61
2466729 2466729 2022-05-02 Greene Virginia 51079 4001 61
2463474 2463474 2022-05-01 Greene Virginia 51079 3995 61
2460218 2460218 2022-04-30 Greene Virginia 51079 3995 61
2456962 2456962 2022-04-29 Greene Virginia 51079 3995 61
2453706 2453706 2022-04-28 Greene Virginia 51079 3993 61
2450450 2450450 2022-04-27 Greene Virginia 51079 3989 61
2447193 2447193 2022-04-26 Greene Virginia 51079 3988 61
2443938 2443938 2022-04-25 Greene Virginia 51079 3986 61
2440682 2440682 2022-04-24 Greene Virginia 51079 3984 61
2437426 2437426 2022-04-23 Greene Virginia 51079 3984 61
2434170 2434170 2022-04-22 Greene Virginia 51079 3984 61
2430914 2430914 2022-04-21 Greene Virginia 51079 3982 61
2427658 2427658 2022-04-20 Greene Virginia 51079 3979 61
2424402 2424402 2022-04-19 Greene Virginia 51079 3978 61
2421146 2421146 2022-04-18 Greene Virginia 51079 3975 61
2417890 2417890 2022-04-17 Greene Virginia 51079 3967 61
2414634 2414634 2022-04-16 Greene Virginia 51079 3967 61
2411378 2411378 2022-04-15 Greene Virginia 51079 3967 61
2408122 2408122 2022-04-14 Greene Virginia 51079 3966 61
2404866 2404866 2022-04-13 Greene Virginia 51079 3967 61
2401611 2401611 2022-04-12 Greene Virginia 51079 3968 60
2398356 2398356 2022-04-11 Greene Virginia 51079 3972 60
2395101 2395101 2022-04-10 Greene Virginia 51079 3979 61
2391845 2391845 2022-04-09 Greene Virginia 51079 3979 61
2388589 2388589 2022-04-08 Greene Virginia 51079 3979 61
2385334 2385334 2022-04-07 Greene Virginia 51079 3997 61
2382079 2382079 2022-04-06 Greene Virginia 51079 4010 61
2378824 2378824 2022-04-05 Greene Virginia 51079 4008 62
2375570 2375570 2022-04-04 Greene Virginia 51079 4009 61
2372318 2372318 2022-04-03 Greene Virginia 51079 4008 61
2369065 2369065 2022-04-02 Greene Virginia 51079 4008 61
2365812 2365812 2022-04-01 Greene Virginia 51079 4008 61
2362559 2362559 2022-03-31 Greene Virginia 51079 4022 61
2359305 2359305 2022-03-30 Greene Virginia 51079 4025 61
2356051 2356051 2022-03-29 Greene Virginia 51079 4028 61
2352798 2352798 2022-03-28 Greene Virginia 51079 4029 61
2349546 2349546 2022-03-27 Greene Virginia 51079 4024 61
2346293 2346293 2022-03-26 Greene Virginia 51079 4024 61
2343040 2343040 2022-03-25 Greene Virginia 51079 4024 61
2339787 2339787 2022-03-24 Greene Virginia 51079 4021 61
2336533 2336533 2022-03-23 Greene Virginia 51079 4015 61
2333279 2333279 2022-03-22 Greene Virginia 51079 4006 61
2330026 2330026 2022-03-21 Greene Virginia 51079 4006 61
2326774 2326774 2022-03-20 Greene Virginia 51079 4002 61
2323521 2323521 2022-03-19 Greene Virginia 51079 4002 61
2320267 2320267 2022-03-18 Greene Virginia 51079 4002 61
2317013 2317013 2022-03-17 Greene Virginia 51079 3996 61
2313760 2313760 2022-03-16 Greene Virginia 51079 3993 61
2310507 2310507 2022-03-15 Greene Virginia 51079 3993 61
2307254 2307254 2022-03-14 Greene Virginia 51079 3992 61
2304003 2304003 2022-03-13 Greene Virginia 51079 3985 60
2300751 2300751 2022-03-12 Greene Virginia 51079 3985 60
2297499 2297499 2022-03-11 Greene Virginia 51079 3985 60
2294247 2294247 2022-03-10 Greene Virginia 51079 3981 60
2290995 2290995 2022-03-09 Greene Virginia 51079 3976 60
2287743 2287743 2022-03-08 Greene Virginia 51079 3975 60
2284491 2284491 2022-03-07 Greene Virginia 51079 3971 60
2281239 2281239 2022-03-06 Greene Virginia 51079 3964 60
2277986 2277986 2022-03-05 Greene Virginia 51079 3964 60
2274733 2274733 2022-03-04 Greene Virginia 51079 3964 60
2271480 2271480 2022-03-03 Greene Virginia 51079 3955 59
2268228 2268228 2022-03-02 Greene Virginia 51079 3950 59
2264975 2264975 2022-03-01 Greene Virginia 51079 3946 59
2261725 2261725 2022-02-28 Greene Virginia 51079 3942 59
2258474 2258474 2022-02-27 Greene Virginia 51079 3922 59
2255223 2255223 2022-02-26 Greene Virginia 51079 3922 59
2251972 2251972 2022-02-25 Greene Virginia 51079 3922 59
2248721 2248721 2022-02-24 Greene Virginia 51079 3918 59
2245470 2245470 2022-02-23 Greene Virginia 51079 3912 59
2242219 2242219 2022-02-22 Greene Virginia 51079 3905 58
2238968 2238968 2022-02-21 Greene Virginia 51079 3898 58
2235717 2235717 2022-02-20 Greene Virginia 51079 3889 57
2232466 2232466 2022-02-19 Greene Virginia 51079 3889 57
2229215 2229215 2022-02-18 Greene Virginia 51079 3889 57
2225964 2225964 2022-02-17 Greene Virginia 51079 3886 57
2222713 2222713 2022-02-16 Greene Virginia 51079 3878 57
2219462 2219462 2022-02-15 Greene Virginia 51079 3863 56
2216212 2216212 2022-02-14 Greene Virginia 51079 3854 56
2212961 2212961 2022-02-13 Greene Virginia 51079 3809 55
2209708 2209708 2022-02-12 Greene Virginia 51079 3809 55
2206455 2206455 2022-02-11 Greene Virginia 51079 3809 55
2203202 2203202 2022-02-10 Greene Virginia 51079 3790 55
2199948 2199948 2022-02-09 Greene Virginia 51079 3761 52
2196694 2196694 2022-02-08 Greene Virginia 51079 3749 52
2193439 2193439 2022-02-07 Greene Virginia 51079 3740 52
2190186 2190186 2022-02-06 Greene Virginia 51079 3698 52
2186933 2186933 2022-02-05 Greene Virginia 51079 3698 52
2183680 2183680 2022-02-04 Greene Virginia 51079 3698 52
2180428 2180428 2022-02-03 Greene Virginia 51079 3678 50

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