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

782 rows where fips = 46065 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 · 782 ✖

fips 1

  • 46065 · 782 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502076 2502076 2022-05-13 Hughes South Dakota 46065 4335 58
2498818 2498818 2022-05-12 Hughes South Dakota 46065 4335 58
2495560 2495560 2022-05-11 Hughes South Dakota 46065 4335 58
2492302 2492302 2022-05-10 Hughes South Dakota 46065 4330 58
2489044 2489044 2022-05-09 Hughes South Dakota 46065 4330 58
2485787 2485787 2022-05-08 Hughes South Dakota 46065 4330 58
2482529 2482529 2022-05-07 Hughes South Dakota 46065 4330 58
2479271 2479271 2022-05-06 Hughes South Dakota 46065 4330 58
2476013 2476013 2022-05-05 Hughes South Dakota 46065 4330 58
2472756 2472756 2022-05-04 Hughes South Dakota 46065 4330 58
2469500 2469500 2022-05-03 Hughes South Dakota 46065 4327 58
2466244 2466244 2022-05-02 Hughes South Dakota 46065 4327 58
2462989 2462989 2022-05-01 Hughes South Dakota 46065 4327 58
2459733 2459733 2022-04-30 Hughes South Dakota 46065 4327 58
2456477 2456477 2022-04-29 Hughes South Dakota 46065 4327 58
2453221 2453221 2022-04-28 Hughes South Dakota 46065 4327 58
2449965 2449965 2022-04-27 Hughes South Dakota 46065 4327 58
2446708 2446708 2022-04-26 Hughes South Dakota 46065 4315 58
2443453 2443453 2022-04-25 Hughes South Dakota 46065 4315 58
2440197 2440197 2022-04-24 Hughes South Dakota 46065 4315 58
2436941 2436941 2022-04-23 Hughes South Dakota 46065 4315 58
2433685 2433685 2022-04-22 Hughes South Dakota 46065 4315 58
2430429 2430429 2022-04-21 Hughes South Dakota 46065 4315 58
2427173 2427173 2022-04-20 Hughes South Dakota 46065 4315 58
2423917 2423917 2022-04-19 Hughes South Dakota 46065 4315 58
2420661 2420661 2022-04-18 Hughes South Dakota 46065 4315 58
2417405 2417405 2022-04-17 Hughes South Dakota 46065 4315 58
2414149 2414149 2022-04-16 Hughes South Dakota 46065 4315 58
2410893 2410893 2022-04-15 Hughes South Dakota 46065 4315 58
2407637 2407637 2022-04-14 Hughes South Dakota 46065 4315 58
2404381 2404381 2022-04-13 Hughes South Dakota 46065 4315 58
2401126 2401126 2022-04-12 Hughes South Dakota 46065 4313 58
2397871 2397871 2022-04-11 Hughes South Dakota 46065 4313 58
2394616 2394616 2022-04-10 Hughes South Dakota 46065 4313 58
2391360 2391360 2022-04-09 Hughes South Dakota 46065 4313 58
2388104 2388104 2022-04-08 Hughes South Dakota 46065 4313 58
2384849 2384849 2022-04-07 Hughes South Dakota 46065 4313 58
2381594 2381594 2022-04-06 Hughes South Dakota 46065 4313 58
2378339 2378339 2022-04-05 Hughes South Dakota 46065 4307 58
2375085 2375085 2022-04-04 Hughes South Dakota 46065 4307 58
2371833 2371833 2022-04-03 Hughes South Dakota 46065 4307 58
2368580 2368580 2022-04-02 Hughes South Dakota 46065 4307 58
2365327 2365327 2022-04-01 Hughes South Dakota 46065 4307 58
2362074 2362074 2022-03-31 Hughes South Dakota 46065 4307 58
2358820 2358820 2022-03-30 Hughes South Dakota 46065 4307 58
2355566 2355566 2022-03-29 Hughes South Dakota 46065 4304 58
2352313 2352313 2022-03-28 Hughes South Dakota 46065 4304 58
2349061 2349061 2022-03-27 Hughes South Dakota 46065 4304 58
2345808 2345808 2022-03-26 Hughes South Dakota 46065 4304 58
2342555 2342555 2022-03-25 Hughes South Dakota 46065 4304 58
2339302 2339302 2022-03-24 Hughes South Dakota 46065 4304 58
2336048 2336048 2022-03-23 Hughes South Dakota 46065 4304 58
2332794 2332794 2022-03-22 Hughes South Dakota 46065 4300 58
2329541 2329541 2022-03-21 Hughes South Dakota 46065 4300 58
2326289 2326289 2022-03-20 Hughes South Dakota 46065 4300 58
2323036 2323036 2022-03-19 Hughes South Dakota 46065 4300 58
2319782 2319782 2022-03-18 Hughes South Dakota 46065 4300 58
2316528 2316528 2022-03-17 Hughes South Dakota 46065 4299 58
2313275 2313275 2022-03-16 Hughes South Dakota 46065 4299 58
2310022 2310022 2022-03-15 Hughes South Dakota 46065 4299 58
2306769 2306769 2022-03-14 Hughes South Dakota 46065 4296 58
2303518 2303518 2022-03-13 Hughes South Dakota 46065 4295 57
2300266 2300266 2022-03-12 Hughes South Dakota 46065 4295 57
2297014 2297014 2022-03-11 Hughes South Dakota 46065 4295 57
2293762 2293762 2022-03-10 Hughes South Dakota 46065 4293 57
2290510 2290510 2022-03-09 Hughes South Dakota 46065 4292 57
2287258 2287258 2022-03-08 Hughes South Dakota 46065 4289 57
2284006 2284006 2022-03-07 Hughes South Dakota 46065 4289 58
2280754 2280754 2022-03-06 Hughes South Dakota 46065 4287 58
2277501 2277501 2022-03-05 Hughes South Dakota 46065 4287 58
2274248 2274248 2022-03-04 Hughes South Dakota 46065 4287 58
2270995 2270995 2022-03-03 Hughes South Dakota 46065 4286 58
2267743 2267743 2022-03-02 Hughes South Dakota 46065 4285 58
2264490 2264490 2022-03-01 Hughes South Dakota 46065 4282 58
2261240 2261240 2022-02-28 Hughes South Dakota 46065 4278 58
2257989 2257989 2022-02-27 Hughes South Dakota 46065 4275 58
2254738 2254738 2022-02-26 Hughes South Dakota 46065 4275 58
2251487 2251487 2022-02-25 Hughes South Dakota 46065 4275 58
2248236 2248236 2022-02-24 Hughes South Dakota 46065 4267 58
2244985 2244985 2022-02-23 Hughes South Dakota 46065 4267 58
2241734 2241734 2022-02-22 Hughes South Dakota 46065 4259 58
2238483 2238483 2022-02-21 Hughes South Dakota 46065 4254 58
2235232 2235232 2022-02-20 Hughes South Dakota 46065 4254 58
2231981 2231981 2022-02-19 Hughes South Dakota 46065 4254 58
2228730 2228730 2022-02-18 Hughes South Dakota 46065 4254 58
2225479 2225479 2022-02-17 Hughes South Dakota 46065 4246 58
2222228 2222228 2022-02-16 Hughes South Dakota 46065 4239 58
2218977 2218977 2022-02-15 Hughes South Dakota 46065 4235 57
2215726 2215726 2022-02-14 Hughes South Dakota 46065 4229 57
2212475 2212475 2022-02-13 Hughes South Dakota 46065 4227 57
2209222 2209222 2022-02-12 Hughes South Dakota 46065 4227 57
2205969 2205969 2022-02-11 Hughes South Dakota 46065 4227 57
2202716 2202716 2022-02-10 Hughes South Dakota 46065 4221 57
2199462 2199462 2022-02-09 Hughes South Dakota 46065 4207 57
2196208 2196208 2022-02-08 Hughes South Dakota 46065 4194 57
2192954 2192954 2022-02-07 Hughes South Dakota 46065 4187 57
2189700 2189700 2022-02-06 Hughes South Dakota 46065 4175 57
2186447 2186447 2022-02-05 Hughes South Dakota 46065 4175 57
2183195 2183195 2022-02-04 Hughes South Dakota 46065 4175 57
2179943 2179943 2022-02-03 Hughes South Dakota 46065 4166 57

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