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

738 rows where county = "Grant" and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

state 1

  • South Dakota · 738 ✖

fips 1

county 1

  • Grant · 738 ✖
Link rowid date ▲ county state fips cases deaths
2502069 2502069 2022-05-13 Grant South Dakota 46051 2047 51
2498811 2498811 2022-05-12 Grant South Dakota 46051 2047 51
2495553 2495553 2022-05-11 Grant South Dakota 46051 2047 51
2492295 2492295 2022-05-10 Grant South Dakota 46051 2044 51
2489037 2489037 2022-05-09 Grant South Dakota 46051 2044 51
2485780 2485780 2022-05-08 Grant South Dakota 46051 2044 51
2482522 2482522 2022-05-07 Grant South Dakota 46051 2044 51
2479264 2479264 2022-05-06 Grant South Dakota 46051 2044 51
2476006 2476006 2022-05-05 Grant South Dakota 46051 2044 51
2472749 2472749 2022-05-04 Grant South Dakota 46051 2044 51
2469493 2469493 2022-05-03 Grant South Dakota 46051 2040 51
2466237 2466237 2022-05-02 Grant South Dakota 46051 2040 51
2462982 2462982 2022-05-01 Grant South Dakota 46051 2040 51
2459726 2459726 2022-04-30 Grant South Dakota 46051 2040 51
2456470 2456470 2022-04-29 Grant South Dakota 46051 2040 51
2453214 2453214 2022-04-28 Grant South Dakota 46051 2040 51
2449958 2449958 2022-04-27 Grant South Dakota 46051 2040 51
2446701 2446701 2022-04-26 Grant South Dakota 46051 2039 50
2443446 2443446 2022-04-25 Grant South Dakota 46051 2039 50
2440190 2440190 2022-04-24 Grant South Dakota 46051 2039 50
2436934 2436934 2022-04-23 Grant South Dakota 46051 2039 50
2433678 2433678 2022-04-22 Grant South Dakota 46051 2039 50
2430422 2430422 2022-04-21 Grant South Dakota 46051 2039 50
2427166 2427166 2022-04-20 Grant South Dakota 46051 2039 50
2423910 2423910 2022-04-19 Grant South Dakota 46051 2039 50
2420654 2420654 2022-04-18 Grant South Dakota 46051 2039 50
2417398 2417398 2022-04-17 Grant South Dakota 46051 2039 50
2414142 2414142 2022-04-16 Grant South Dakota 46051 2039 50
2410886 2410886 2022-04-15 Grant South Dakota 46051 2039 50
2407630 2407630 2022-04-14 Grant South Dakota 46051 2039 50
2404374 2404374 2022-04-13 Grant South Dakota 46051 2039 50
2401119 2401119 2022-04-12 Grant South Dakota 46051 2039 50
2397864 2397864 2022-04-11 Grant South Dakota 46051 2039 50
2394609 2394609 2022-04-10 Grant South Dakota 46051 2039 50
2391353 2391353 2022-04-09 Grant South Dakota 46051 2039 50
2388097 2388097 2022-04-08 Grant South Dakota 46051 2039 50
2384842 2384842 2022-04-07 Grant South Dakota 46051 2039 50
2381587 2381587 2022-04-06 Grant South Dakota 46051 2039 50
2378332 2378332 2022-04-05 Grant South Dakota 46051 2039 50
2375078 2375078 2022-04-04 Grant South Dakota 46051 2039 50
2371826 2371826 2022-04-03 Grant South Dakota 46051 2039 50
2368573 2368573 2022-04-02 Grant South Dakota 46051 2039 50
2365320 2365320 2022-04-01 Grant South Dakota 46051 2039 50
2362067 2362067 2022-03-31 Grant South Dakota 46051 2039 50
2358813 2358813 2022-03-30 Grant South Dakota 46051 2039 50
2355559 2355559 2022-03-29 Grant South Dakota 46051 2038 50
2352306 2352306 2022-03-28 Grant South Dakota 46051 2038 50
2349054 2349054 2022-03-27 Grant South Dakota 46051 2038 50
2345801 2345801 2022-03-26 Grant South Dakota 46051 2038 50
2342548 2342548 2022-03-25 Grant South Dakota 46051 2038 50
2339295 2339295 2022-03-24 Grant South Dakota 46051 2038 50
2336041 2336041 2022-03-23 Grant South Dakota 46051 2038 50
2332787 2332787 2022-03-22 Grant South Dakota 46051 2033 50
2329534 2329534 2022-03-21 Grant South Dakota 46051 2033 50
2326282 2326282 2022-03-20 Grant South Dakota 46051 2033 50
2323029 2323029 2022-03-19 Grant South Dakota 46051 2033 50
2319775 2319775 2022-03-18 Grant South Dakota 46051 2033 50
2316521 2316521 2022-03-17 Grant South Dakota 46051 2031 50
2313268 2313268 2022-03-16 Grant South Dakota 46051 2031 50
2310015 2310015 2022-03-15 Grant South Dakota 46051 2031 50
2306762 2306762 2022-03-14 Grant South Dakota 46051 2031 50
2303511 2303511 2022-03-13 Grant South Dakota 46051 2031 50
2300259 2300259 2022-03-12 Grant South Dakota 46051 2031 50
2297007 2297007 2022-03-11 Grant South Dakota 46051 2031 50
2293755 2293755 2022-03-10 Grant South Dakota 46051 2031 50
2290503 2290503 2022-03-09 Grant South Dakota 46051 2030 50
2287251 2287251 2022-03-08 Grant South Dakota 46051 2030 50
2283999 2283999 2022-03-07 Grant South Dakota 46051 2030 50
2280747 2280747 2022-03-06 Grant South Dakota 46051 2029 50
2277494 2277494 2022-03-05 Grant South Dakota 46051 2029 50
2274241 2274241 2022-03-04 Grant South Dakota 46051 2029 50
2270988 2270988 2022-03-03 Grant South Dakota 46051 2029 50
2267736 2267736 2022-03-02 Grant South Dakota 46051 2028 50
2264483 2264483 2022-03-01 Grant South Dakota 46051 2028 50
2261233 2261233 2022-02-28 Grant South Dakota 46051 2026 50
2257982 2257982 2022-02-27 Grant South Dakota 46051 2023 50
2254731 2254731 2022-02-26 Grant South Dakota 46051 2023 50
2251480 2251480 2022-02-25 Grant South Dakota 46051 2023 50
2248229 2248229 2022-02-24 Grant South Dakota 46051 2022 50
2244978 2244978 2022-02-23 Grant South Dakota 46051 2022 50
2241727 2241727 2022-02-22 Grant South Dakota 46051 2023 50
2238476 2238476 2022-02-21 Grant South Dakota 46051 2023 50
2235225 2235225 2022-02-20 Grant South Dakota 46051 2023 50
2231974 2231974 2022-02-19 Grant South Dakota 46051 2023 50
2228723 2228723 2022-02-18 Grant South Dakota 46051 2023 50
2225472 2225472 2022-02-17 Grant South Dakota 46051 2022 50
2222221 2222221 2022-02-16 Grant South Dakota 46051 2022 50
2218970 2218970 2022-02-15 Grant South Dakota 46051 2021 49
2215719 2215719 2022-02-14 Grant South Dakota 46051 2021 49
2212468 2212468 2022-02-13 Grant South Dakota 46051 2019 49
2209215 2209215 2022-02-12 Grant South Dakota 46051 2019 49
2205962 2205962 2022-02-11 Grant South Dakota 46051 2019 49
2202709 2202709 2022-02-10 Grant South Dakota 46051 2015 49
2199455 2199455 2022-02-09 Grant South Dakota 46051 2012 49
2196201 2196201 2022-02-08 Grant South Dakota 46051 2008 48
2192947 2192947 2022-02-07 Grant South Dakota 46051 2006 48
2189693 2189693 2022-02-06 Grant South Dakota 46051 1997 48
2186440 2186440 2022-02-05 Grant South Dakota 46051 1997 48
2183188 2183188 2022-02-04 Grant South Dakota 46051 1997 48
2179936 2179936 2022-02-03 Grant South Dakota 46051 1991 48

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