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

781 rows where county = "Brookings" and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • South Dakota · 781 ✖

fips 1

county 1

  • Brookings · 781 ✖
Link rowid date ▲ county state fips cases deaths
2502049 2502049 2022-05-13 Brookings South Dakota 46011 8149 52
2498791 2498791 2022-05-12 Brookings South Dakota 46011 8149 52
2495533 2495533 2022-05-11 Brookings South Dakota 46011 8149 52
2492275 2492275 2022-05-10 Brookings South Dakota 46011 8133 52
2489017 2489017 2022-05-09 Brookings South Dakota 46011 8133 52
2485760 2485760 2022-05-08 Brookings South Dakota 46011 8133 52
2482502 2482502 2022-05-07 Brookings South Dakota 46011 8133 52
2479244 2479244 2022-05-06 Brookings South Dakota 46011 8133 52
2475986 2475986 2022-05-05 Brookings South Dakota 46011 8133 52
2472729 2472729 2022-05-04 Brookings South Dakota 46011 8133 52
2469473 2469473 2022-05-03 Brookings South Dakota 46011 8118 52
2466217 2466217 2022-05-02 Brookings South Dakota 46011 8118 52
2462962 2462962 2022-05-01 Brookings South Dakota 46011 8118 52
2459706 2459706 2022-04-30 Brookings South Dakota 46011 8118 52
2456450 2456450 2022-04-29 Brookings South Dakota 46011 8118 52
2453194 2453194 2022-04-28 Brookings South Dakota 46011 8118 52
2449938 2449938 2022-04-27 Brookings South Dakota 46011 8118 52
2446681 2446681 2022-04-26 Brookings South Dakota 46011 8102 52
2443426 2443426 2022-04-25 Brookings South Dakota 46011 8102 52
2440170 2440170 2022-04-24 Brookings South Dakota 46011 8102 52
2436914 2436914 2022-04-23 Brookings South Dakota 46011 8102 52
2433658 2433658 2022-04-22 Brookings South Dakota 46011 8102 52
2430402 2430402 2022-04-21 Brookings South Dakota 46011 8102 52
2427146 2427146 2022-04-20 Brookings South Dakota 46011 8102 52
2423890 2423890 2022-04-19 Brookings South Dakota 46011 8100 52
2420634 2420634 2022-04-18 Brookings South Dakota 46011 8100 52
2417378 2417378 2022-04-17 Brookings South Dakota 46011 8100 52
2414122 2414122 2022-04-16 Brookings South Dakota 46011 8100 52
2410866 2410866 2022-04-15 Brookings South Dakota 46011 8100 52
2407610 2407610 2022-04-14 Brookings South Dakota 46011 8100 52
2404354 2404354 2022-04-13 Brookings South Dakota 46011 8100 52
2401099 2401099 2022-04-12 Brookings South Dakota 46011 8096 52
2397844 2397844 2022-04-11 Brookings South Dakota 46011 8096 52
2394589 2394589 2022-04-10 Brookings South Dakota 46011 8096 52
2391333 2391333 2022-04-09 Brookings South Dakota 46011 8096 52
2388077 2388077 2022-04-08 Brookings South Dakota 46011 8096 52
2384822 2384822 2022-04-07 Brookings South Dakota 46011 8096 52
2381567 2381567 2022-04-06 Brookings South Dakota 46011 8096 52
2378312 2378312 2022-04-05 Brookings South Dakota 46011 8093 51
2375058 2375058 2022-04-04 Brookings South Dakota 46011 8093 51
2371806 2371806 2022-04-03 Brookings South Dakota 46011 8093 51
2368553 2368553 2022-04-02 Brookings South Dakota 46011 8093 51
2365300 2365300 2022-04-01 Brookings South Dakota 46011 8093 51
2362047 2362047 2022-03-31 Brookings South Dakota 46011 8093 51
2358793 2358793 2022-03-30 Brookings South Dakota 46011 8093 51
2355539 2355539 2022-03-29 Brookings South Dakota 46011 8091 51
2352286 2352286 2022-03-28 Brookings South Dakota 46011 8091 51
2349034 2349034 2022-03-27 Brookings South Dakota 46011 8091 51
2345781 2345781 2022-03-26 Brookings South Dakota 46011 8091 51
2342528 2342528 2022-03-25 Brookings South Dakota 46011 8091 51
2339275 2339275 2022-03-24 Brookings South Dakota 46011 8091 51
2336021 2336021 2022-03-23 Brookings South Dakota 46011 8091 51
2332767 2332767 2022-03-22 Brookings South Dakota 46011 8089 51
2329514 2329514 2022-03-21 Brookings South Dakota 46011 8089 51
2326262 2326262 2022-03-20 Brookings South Dakota 46011 8089 51
2323009 2323009 2022-03-19 Brookings South Dakota 46011 8089 51
2319755 2319755 2022-03-18 Brookings South Dakota 46011 8089 51
2316501 2316501 2022-03-17 Brookings South Dakota 46011 8087 51
2313248 2313248 2022-03-16 Brookings South Dakota 46011 8085 51
2309995 2309995 2022-03-15 Brookings South Dakota 46011 8083 51
2306742 2306742 2022-03-14 Brookings South Dakota 46011 8080 51
2303491 2303491 2022-03-13 Brookings South Dakota 46011 8078 51
2300239 2300239 2022-03-12 Brookings South Dakota 46011 8078 51
2296987 2296987 2022-03-11 Brookings South Dakota 46011 8078 51
2293735 2293735 2022-03-10 Brookings South Dakota 46011 8076 51
2290483 2290483 2022-03-09 Brookings South Dakota 46011 8075 51
2287231 2287231 2022-03-08 Brookings South Dakota 46011 8073 51
2283979 2283979 2022-03-07 Brookings South Dakota 46011 8070 51
2280727 2280727 2022-03-06 Brookings South Dakota 46011 8069 51
2277474 2277474 2022-03-05 Brookings South Dakota 46011 8069 51
2274221 2274221 2022-03-04 Brookings South Dakota 46011 8069 51
2270968 2270968 2022-03-03 Brookings South Dakota 46011 8067 50
2267716 2267716 2022-03-02 Brookings South Dakota 46011 8064 50
2264463 2264463 2022-03-01 Brookings South Dakota 46011 8064 50
2261213 2261213 2022-02-28 Brookings South Dakota 46011 8058 50
2257962 2257962 2022-02-27 Brookings South Dakota 46011 8061 50
2254711 2254711 2022-02-26 Brookings South Dakota 46011 8061 50
2251460 2251460 2022-02-25 Brookings South Dakota 46011 8061 50
2248209 2248209 2022-02-24 Brookings South Dakota 46011 8055 50
2244958 2244958 2022-02-23 Brookings South Dakota 46011 8056 50
2241707 2241707 2022-02-22 Brookings South Dakota 46011 8051 48
2238456 2238456 2022-02-21 Brookings South Dakota 46011 8050 48
2235205 2235205 2022-02-20 Brookings South Dakota 46011 8050 48
2231954 2231954 2022-02-19 Brookings South Dakota 46011 8050 48
2228703 2228703 2022-02-18 Brookings South Dakota 46011 8050 48
2225452 2225452 2022-02-17 Brookings South Dakota 46011 8044 48
2222201 2222201 2022-02-16 Brookings South Dakota 46011 8038 48
2218950 2218950 2022-02-15 Brookings South Dakota 46011 8032 48
2215699 2215699 2022-02-14 Brookings South Dakota 46011 8022 48
2212448 2212448 2022-02-13 Brookings South Dakota 46011 8011 46
2209195 2209195 2022-02-12 Brookings South Dakota 46011 8011 46
2205942 2205942 2022-02-11 Brookings South Dakota 46011 8011 46
2202689 2202689 2022-02-10 Brookings South Dakota 46011 7996 45
2199435 2199435 2022-02-09 Brookings South Dakota 46011 7982 45
2196181 2196181 2022-02-08 Brookings South Dakota 46011 7953 44
2192927 2192927 2022-02-07 Brookings South Dakota 46011 7941 44
2189673 2189673 2022-02-06 Brookings South Dakota 46011 7931 44
2186420 2186420 2022-02-05 Brookings South Dakota 46011 7931 44
2183168 2183168 2022-02-04 Brookings South Dakota 46011 7931 44
2179916 2179916 2022-02-03 Brookings South Dakota 46011 7915 44

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