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

786 rows where county = "Tucker" and state = "West Virginia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • West Virginia · 786 ✖

fips 1

county 1

  • Tucker · 786 ✖
Link rowid date ▲ county state fips cases deaths
2502729 2502729 2022-05-13 Tucker West Virginia 54093 2024 38
2499471 2499471 2022-05-12 Tucker West Virginia 54093 2023 38
2496213 2496213 2022-05-11 Tucker West Virginia 54093 2022 38
2492955 2492955 2022-05-10 Tucker West Virginia 54093 2019 38
2489697 2489697 2022-05-09 Tucker West Virginia 54093 2019 38
2486440 2486440 2022-05-08 Tucker West Virginia 54093 2017 38
2483182 2483182 2022-05-07 Tucker West Virginia 54093 2017 38
2479924 2479924 2022-05-06 Tucker West Virginia 54093 2017 38
2476666 2476666 2022-05-05 Tucker West Virginia 54093 2017 38
2473408 2473408 2022-05-04 Tucker West Virginia 54093 2013 38
2470151 2470151 2022-05-03 Tucker West Virginia 54093 2013 38
2466895 2466895 2022-05-02 Tucker West Virginia 54093 2012 38
2463640 2463640 2022-05-01 Tucker West Virginia 54093 2008 38
2460384 2460384 2022-04-30 Tucker West Virginia 54093 2008 38
2457128 2457128 2022-04-29 Tucker West Virginia 54093 2008 38
2453872 2453872 2022-04-28 Tucker West Virginia 54093 2005 38
2450616 2450616 2022-04-27 Tucker West Virginia 54093 2005 38
2447360 2447360 2022-04-26 Tucker West Virginia 54093 2005 38
2444104 2444104 2022-04-25 Tucker West Virginia 54093 2004 37
2440848 2440848 2022-04-24 Tucker West Virginia 54093 2003 37
2437592 2437592 2022-04-23 Tucker West Virginia 54093 2003 37
2434336 2434336 2022-04-22 Tucker West Virginia 54093 2003 37
2431080 2431080 2022-04-21 Tucker West Virginia 54093 1999 37
2427824 2427824 2022-04-20 Tucker West Virginia 54093 1999 37
2424568 2424568 2022-04-19 Tucker West Virginia 54093 1999 37
2421312 2421312 2022-04-18 Tucker West Virginia 54093 1999 37
2418056 2418056 2022-04-17 Tucker West Virginia 54093 1998 37
2414800 2414800 2022-04-16 Tucker West Virginia 54093 1998 37
2411544 2411544 2022-04-15 Tucker West Virginia 54093 1998 37
2408288 2408288 2022-04-14 Tucker West Virginia 54093 1998 37
2405032 2405032 2022-04-13 Tucker West Virginia 54093 1998 37
2401777 2401777 2022-04-12 Tucker West Virginia 54093 1993 37
2398522 2398522 2022-04-11 Tucker West Virginia 54093 1993 37
2395267 2395267 2022-04-10 Tucker West Virginia 54093 1991 37
2392011 2392011 2022-04-09 Tucker West Virginia 54093 1991 37
2388755 2388755 2022-04-08 Tucker West Virginia 54093 1991 37
2385500 2385500 2022-04-07 Tucker West Virginia 54093 1990 37
2382245 2382245 2022-04-06 Tucker West Virginia 54093 1990 37
2378990 2378990 2022-04-05 Tucker West Virginia 54093 1990 37
2375736 2375736 2022-04-04 Tucker West Virginia 54093 1990 37
2372484 2372484 2022-04-03 Tucker West Virginia 54093 1989 37
2369231 2369231 2022-04-02 Tucker West Virginia 54093 1989 37
2365978 2365978 2022-04-01 Tucker West Virginia 54093 1989 37
2362725 2362725 2022-03-31 Tucker West Virginia 54093 1989 37
2359471 2359471 2022-03-30 Tucker West Virginia 54093 1989 37
2356217 2356217 2022-03-29 Tucker West Virginia 54093 1988 37
2352964 2352964 2022-03-28 Tucker West Virginia 54093 1988 36
2349712 2349712 2022-03-27 Tucker West Virginia 54093 1984 36
2346459 2346459 2022-03-26 Tucker West Virginia 54093 1984 36
2343206 2343206 2022-03-25 Tucker West Virginia 54093 1984 36
2339953 2339953 2022-03-24 Tucker West Virginia 54093 1983 36
2336700 2336700 2022-03-23 Tucker West Virginia 54093 1983 36
2333446 2333446 2022-03-22 Tucker West Virginia 54093 1981 34
2330192 2330192 2022-03-21 Tucker West Virginia 54093 1980 34
2326940 2326940 2022-03-20 Tucker West Virginia 54093 1973 34
2323687 2323687 2022-03-19 Tucker West Virginia 54093 1973 34
2320433 2320433 2022-03-18 Tucker West Virginia 54093 1973 34
2317179 2317179 2022-03-17 Tucker West Virginia 54093 1973 34
2313926 2313926 2022-03-16 Tucker West Virginia 54093 1971 34
2310673 2310673 2022-03-15 Tucker West Virginia 54093 1971 34
2307420 2307420 2022-03-14 Tucker West Virginia 54093 1966 34
2304169 2304169 2022-03-13 Tucker West Virginia 54093 1962 34
2300917 2300917 2022-03-12 Tucker West Virginia 54093 1962 34
2297665 2297665 2022-03-11 Tucker West Virginia 54093 1962 34
2294413 2294413 2022-03-10 Tucker West Virginia 54093 1960 34
2291161 2291161 2022-03-09 Tucker West Virginia 54093 1959 33
2287909 2287909 2022-03-08 Tucker West Virginia 54093 1958 33
2284657 2284657 2022-03-07 Tucker West Virginia 54093 1957 33
2281405 2281405 2022-03-06 Tucker West Virginia 54093 1950 33
2278152 2278152 2022-03-05 Tucker West Virginia 54093 1950 33
2274899 2274899 2022-03-04 Tucker West Virginia 54093 1950 33
2271646 2271646 2022-03-03 Tucker West Virginia 54093 1939 33
2268394 2268394 2022-03-02 Tucker West Virginia 54093 1935 33
2265141 2265141 2022-03-01 Tucker West Virginia 54093 1929 33
2261891 2261891 2022-02-28 Tucker West Virginia 54093 1928 33
2258640 2258640 2022-02-27 Tucker West Virginia 54093 1912 33
2255389 2255389 2022-02-26 Tucker West Virginia 54093 1912 33
2252138 2252138 2022-02-25 Tucker West Virginia 54093 1912 33
2248887 2248887 2022-02-24 Tucker West Virginia 54093 1906 33
2245636 2245636 2022-02-23 Tucker West Virginia 54093 1905 33
2242385 2242385 2022-02-22 Tucker West Virginia 54093 1905 33
2239134 2239134 2022-02-21 Tucker West Virginia 54093 1904 33
2235883 2235883 2022-02-20 Tucker West Virginia 54093 1901 33
2232632 2232632 2022-02-19 Tucker West Virginia 54093 1901 33
2229381 2229381 2022-02-18 Tucker West Virginia 54093 1901 33
2226130 2226130 2022-02-17 Tucker West Virginia 54093 1892 33
2222879 2222879 2022-02-16 Tucker West Virginia 54093 1884 33
2219628 2219628 2022-02-15 Tucker West Virginia 54093 1876 33
2216378 2216378 2022-02-14 Tucker West Virginia 54093 1875 33
2213127 2213127 2022-02-13 Tucker West Virginia 54093 1872 33
2209874 2209874 2022-02-12 Tucker West Virginia 54093 1865 33
2206621 2206621 2022-02-11 Tucker West Virginia 54093 1860 33
2203368 2203368 2022-02-10 Tucker West Virginia 54093 1849 33
2200114 2200114 2022-02-09 Tucker West Virginia 54093 1844 33
2196860 2196860 2022-02-08 Tucker West Virginia 54093 1836 33
2193605 2193605 2022-02-07 Tucker West Virginia 54093 1826 33
2190352 2190352 2022-02-06 Tucker West Virginia 54093 1822 33
2187099 2187099 2022-02-05 Tucker West Virginia 54093 1812 33
2183846 2183846 2022-02-04 Tucker West Virginia 54093 1796 33
2180594 2180594 2022-02-03 Tucker West Virginia 54093 1784 33

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