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

762 rows where county = "Grant" and state = "West Virginia" sorted by date descending

✎ View and edit SQL

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

state 1

  • West Virginia · 762 ✖

fips 1

county 1

  • Grant · 762 ✖
Link rowid date ▲ county state fips cases deaths
2502694 2502694 2022-05-13 Grant West Virginia 54023 3786 56
2499436 2499436 2022-05-12 Grant West Virginia 54023 3786 56
2496178 2496178 2022-05-11 Grant West Virginia 54023 3786 56
2492920 2492920 2022-05-10 Grant West Virginia 54023 3786 56
2489662 2489662 2022-05-09 Grant West Virginia 54023 3786 56
2486405 2486405 2022-05-08 Grant West Virginia 54023 3787 56
2483147 2483147 2022-05-07 Grant West Virginia 54023 3787 56
2479889 2479889 2022-05-06 Grant West Virginia 54023 3787 56
2476631 2476631 2022-05-05 Grant West Virginia 54023 3785 56
2473373 2473373 2022-05-04 Grant West Virginia 54023 3785 56
2470116 2470116 2022-05-03 Grant West Virginia 54023 3785 56
2466860 2466860 2022-05-02 Grant West Virginia 54023 3785 56
2463605 2463605 2022-05-01 Grant West Virginia 54023 3785 56
2460349 2460349 2022-04-30 Grant West Virginia 54023 3785 56
2457093 2457093 2022-04-29 Grant West Virginia 54023 3785 56
2453837 2453837 2022-04-28 Grant West Virginia 54023 3783 56
2450581 2450581 2022-04-27 Grant West Virginia 54023 3782 56
2447325 2447325 2022-04-26 Grant West Virginia 54023 3782 56
2444069 2444069 2022-04-25 Grant West Virginia 54023 3778 56
2440813 2440813 2022-04-24 Grant West Virginia 54023 3776 56
2437557 2437557 2022-04-23 Grant West Virginia 54023 3776 56
2434301 2434301 2022-04-22 Grant West Virginia 54023 3776 56
2431045 2431045 2022-04-21 Grant West Virginia 54023 3775 56
2427789 2427789 2022-04-20 Grant West Virginia 54023 3774 56
2424533 2424533 2022-04-19 Grant West Virginia 54023 3773 56
2421277 2421277 2022-04-18 Grant West Virginia 54023 3773 56
2418021 2418021 2022-04-17 Grant West Virginia 54023 3771 56
2414765 2414765 2022-04-16 Grant West Virginia 54023 3771 56
2411509 2411509 2022-04-15 Grant West Virginia 54023 3771 56
2408253 2408253 2022-04-14 Grant West Virginia 54023 3769 56
2404997 2404997 2022-04-13 Grant West Virginia 54023 3768 56
2401742 2401742 2022-04-12 Grant West Virginia 54023 3766 56
2398487 2398487 2022-04-11 Grant West Virginia 54023 3766 56
2395232 2395232 2022-04-10 Grant West Virginia 54023 3766 56
2391976 2391976 2022-04-09 Grant West Virginia 54023 3766 56
2388720 2388720 2022-04-08 Grant West Virginia 54023 3766 56
2385465 2385465 2022-04-07 Grant West Virginia 54023 3766 56
2382210 2382210 2022-04-06 Grant West Virginia 54023 3766 56
2378955 2378955 2022-04-05 Grant West Virginia 54023 3766 56
2375701 2375701 2022-04-04 Grant West Virginia 54023 3765 56
2372449 2372449 2022-04-03 Grant West Virginia 54023 3765 56
2369196 2369196 2022-04-02 Grant West Virginia 54023 3765 56
2365943 2365943 2022-04-01 Grant West Virginia 54023 3765 56
2362690 2362690 2022-03-31 Grant West Virginia 54023 3765 56
2359436 2359436 2022-03-30 Grant West Virginia 54023 3765 56
2356182 2356182 2022-03-29 Grant West Virginia 54023 3765 56
2352929 2352929 2022-03-28 Grant West Virginia 54023 3764 56
2349677 2349677 2022-03-27 Grant West Virginia 54023 3765 56
2346424 2346424 2022-03-26 Grant West Virginia 54023 3765 56
2343171 2343171 2022-03-25 Grant West Virginia 54023 3765 56
2339918 2339918 2022-03-24 Grant West Virginia 54023 3764 56
2336665 2336665 2022-03-23 Grant West Virginia 54023 3763 56
2333411 2333411 2022-03-22 Grant West Virginia 54023 3765 56
2330157 2330157 2022-03-21 Grant West Virginia 54023 3764 56
2326905 2326905 2022-03-20 Grant West Virginia 54023 3760 56
2323652 2323652 2022-03-19 Grant West Virginia 54023 3760 56
2320398 2320398 2022-03-18 Grant West Virginia 54023 3760 56
2317144 2317144 2022-03-17 Grant West Virginia 54023 3758 56
2313891 2313891 2022-03-16 Grant West Virginia 54023 3758 56
2310638 2310638 2022-03-15 Grant West Virginia 54023 3758 56
2307385 2307385 2022-03-14 Grant West Virginia 54023 3758 56
2304134 2304134 2022-03-13 Grant West Virginia 54023 3755 56
2300882 2300882 2022-03-12 Grant West Virginia 54023 3755 56
2297630 2297630 2022-03-11 Grant West Virginia 54023 3755 56
2294378 2294378 2022-03-10 Grant West Virginia 54023 3753 56
2291126 2291126 2022-03-09 Grant West Virginia 54023 3751 56
2287874 2287874 2022-03-08 Grant West Virginia 54023 3752 56
2284622 2284622 2022-03-07 Grant West Virginia 54023 3750 56
2281370 2281370 2022-03-06 Grant West Virginia 54023 3748 56
2278117 2278117 2022-03-05 Grant West Virginia 54023 3748 56
2274864 2274864 2022-03-04 Grant West Virginia 54023 3748 56
2271611 2271611 2022-03-03 Grant West Virginia 54023 3746 56
2268359 2268359 2022-03-02 Grant West Virginia 54023 3744 56
2265106 2265106 2022-03-01 Grant West Virginia 54023 3743 55
2261856 2261856 2022-02-28 Grant West Virginia 54023 3741 55
2258605 2258605 2022-02-27 Grant West Virginia 54023 3739 55
2255354 2255354 2022-02-26 Grant West Virginia 54023 3739 55
2252103 2252103 2022-02-25 Grant West Virginia 54023 3739 55
2248852 2248852 2022-02-24 Grant West Virginia 54023 3735 55
2245601 2245601 2022-02-23 Grant West Virginia 54023 3732 55
2242350 2242350 2022-02-22 Grant West Virginia 54023 3732 55
2239099 2239099 2022-02-21 Grant West Virginia 54023 3729 54
2235848 2235848 2022-02-20 Grant West Virginia 54023 3694 54
2232597 2232597 2022-02-19 Grant West Virginia 54023 3694 54
2229346 2229346 2022-02-18 Grant West Virginia 54023 3694 54
2226095 2226095 2022-02-17 Grant West Virginia 54023 3688 54
2222844 2222844 2022-02-16 Grant West Virginia 54023 3680 53
2219593 2219593 2022-02-15 Grant West Virginia 54023 3678 53
2216343 2216343 2022-02-14 Grant West Virginia 54023 3676 52
2213092 2213092 2022-02-13 Grant West Virginia 54023 3671 52
2209839 2209839 2022-02-12 Grant West Virginia 54023 3663 52
2206586 2206586 2022-02-11 Grant West Virginia 54023 3656 52
2203333 2203333 2022-02-10 Grant West Virginia 54023 3632 52
2200079 2200079 2022-02-09 Grant West Virginia 54023 3623 52
2196825 2196825 2022-02-08 Grant West Virginia 54023 3609 52
2193570 2193570 2022-02-07 Grant West Virginia 54023 3600 52
2190317 2190317 2022-02-06 Grant West Virginia 54023 3596 51
2187064 2187064 2022-02-05 Grant West Virginia 54023 3588 51
2183811 2183811 2022-02-04 Grant West Virginia 54023 3566 51
2180559 2180559 2022-02-03 Grant West Virginia 54023 3551 51

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