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

776 rows where fips = 46027 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 · 776 ✖

fips 1

  • 46027 · 776 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502057 2502057 2022-05-13 Clay South Dakota 46027 3493 21
2498799 2498799 2022-05-12 Clay South Dakota 46027 3493 21
2495541 2495541 2022-05-11 Clay South Dakota 46027 3493 21
2492283 2492283 2022-05-10 Clay South Dakota 46027 3489 21
2489025 2489025 2022-05-09 Clay South Dakota 46027 3489 21
2485768 2485768 2022-05-08 Clay South Dakota 46027 3489 21
2482510 2482510 2022-05-07 Clay South Dakota 46027 3489 21
2479252 2479252 2022-05-06 Clay South Dakota 46027 3489 21
2475994 2475994 2022-05-05 Clay South Dakota 46027 3489 21
2472737 2472737 2022-05-04 Clay South Dakota 46027 3489 21
2469481 2469481 2022-05-03 Clay South Dakota 46027 3489 21
2466225 2466225 2022-05-02 Clay South Dakota 46027 3489 21
2462970 2462970 2022-05-01 Clay South Dakota 46027 3489 21
2459714 2459714 2022-04-30 Clay South Dakota 46027 3489 21
2456458 2456458 2022-04-29 Clay South Dakota 46027 3489 21
2453202 2453202 2022-04-28 Clay South Dakota 46027 3489 21
2449946 2449946 2022-04-27 Clay South Dakota 46027 3489 21
2446689 2446689 2022-04-26 Clay South Dakota 46027 3488 21
2443434 2443434 2022-04-25 Clay South Dakota 46027 3488 21
2440178 2440178 2022-04-24 Clay South Dakota 46027 3488 21
2436922 2436922 2022-04-23 Clay South Dakota 46027 3488 21
2433666 2433666 2022-04-22 Clay South Dakota 46027 3488 21
2430410 2430410 2022-04-21 Clay South Dakota 46027 3488 21
2427154 2427154 2022-04-20 Clay South Dakota 46027 3488 21
2423898 2423898 2022-04-19 Clay South Dakota 46027 3488 21
2420642 2420642 2022-04-18 Clay South Dakota 46027 3488 21
2417386 2417386 2022-04-17 Clay South Dakota 46027 3488 21
2414130 2414130 2022-04-16 Clay South Dakota 46027 3488 21
2410874 2410874 2022-04-15 Clay South Dakota 46027 3488 21
2407618 2407618 2022-04-14 Clay South Dakota 46027 3488 21
2404362 2404362 2022-04-13 Clay South Dakota 46027 3488 21
2401107 2401107 2022-04-12 Clay South Dakota 46027 3489 21
2397852 2397852 2022-04-11 Clay South Dakota 46027 3489 21
2394597 2394597 2022-04-10 Clay South Dakota 46027 3489 21
2391341 2391341 2022-04-09 Clay South Dakota 46027 3489 21
2388085 2388085 2022-04-08 Clay South Dakota 46027 3489 21
2384830 2384830 2022-04-07 Clay South Dakota 46027 3489 21
2381575 2381575 2022-04-06 Clay South Dakota 46027 3489 21
2378320 2378320 2022-04-05 Clay South Dakota 46027 3487 21
2375066 2375066 2022-04-04 Clay South Dakota 46027 3487 21
2371814 2371814 2022-04-03 Clay South Dakota 46027 3487 21
2368561 2368561 2022-04-02 Clay South Dakota 46027 3487 21
2365308 2365308 2022-04-01 Clay South Dakota 46027 3487 21
2362055 2362055 2022-03-31 Clay South Dakota 46027 3487 21
2358801 2358801 2022-03-30 Clay South Dakota 46027 3487 21
2355547 2355547 2022-03-29 Clay South Dakota 46027 3484 21
2352294 2352294 2022-03-28 Clay South Dakota 46027 3484 21
2349042 2349042 2022-03-27 Clay South Dakota 46027 3484 21
2345789 2345789 2022-03-26 Clay South Dakota 46027 3484 21
2342536 2342536 2022-03-25 Clay South Dakota 46027 3484 21
2339283 2339283 2022-03-24 Clay South Dakota 46027 3484 21
2336029 2336029 2022-03-23 Clay South Dakota 46027 3484 21
2332775 2332775 2022-03-22 Clay South Dakota 46027 3481 21
2329522 2329522 2022-03-21 Clay South Dakota 46027 3481 21
2326270 2326270 2022-03-20 Clay South Dakota 46027 3481 21
2323017 2323017 2022-03-19 Clay South Dakota 46027 3481 21
2319763 2319763 2022-03-18 Clay South Dakota 46027 3481 21
2316509 2316509 2022-03-17 Clay South Dakota 46027 3481 21
2313256 2313256 2022-03-16 Clay South Dakota 46027 3480 21
2310003 2310003 2022-03-15 Clay South Dakota 46027 3479 21
2306750 2306750 2022-03-14 Clay South Dakota 46027 3479 21
2303499 2303499 2022-03-13 Clay South Dakota 46027 3479 21
2300247 2300247 2022-03-12 Clay South Dakota 46027 3479 21
2296995 2296995 2022-03-11 Clay South Dakota 46027 3479 21
2293743 2293743 2022-03-10 Clay South Dakota 46027 3479 21
2290491 2290491 2022-03-09 Clay South Dakota 46027 3480 21
2287239 2287239 2022-03-08 Clay South Dakota 46027 3479 21
2283987 2283987 2022-03-07 Clay South Dakota 46027 3478 21
2280735 2280735 2022-03-06 Clay South Dakota 46027 3478 21
2277482 2277482 2022-03-05 Clay South Dakota 46027 3478 21
2274229 2274229 2022-03-04 Clay South Dakota 46027 3478 21
2270976 2270976 2022-03-03 Clay South Dakota 46027 3478 21
2267724 2267724 2022-03-02 Clay South Dakota 46027 3477 20
2264471 2264471 2022-03-01 Clay South Dakota 46027 3477 20
2261221 2261221 2022-02-28 Clay South Dakota 46027 3475 20
2257970 2257970 2022-02-27 Clay South Dakota 46027 3478 20
2254719 2254719 2022-02-26 Clay South Dakota 46027 3478 20
2251468 2251468 2022-02-25 Clay South Dakota 46027 3478 20
2248217 2248217 2022-02-24 Clay South Dakota 46027 3480 20
2244966 2244966 2022-02-23 Clay South Dakota 46027 3481 20
2241715 2241715 2022-02-22 Clay South Dakota 46027 3481 20
2238464 2238464 2022-02-21 Clay South Dakota 46027 3481 20
2235213 2235213 2022-02-20 Clay South Dakota 46027 3481 20
2231962 2231962 2022-02-19 Clay South Dakota 46027 3481 20
2228711 2228711 2022-02-18 Clay South Dakota 46027 3481 20
2225460 2225460 2022-02-17 Clay South Dakota 46027 3479 20
2222209 2222209 2022-02-16 Clay South Dakota 46027 3474 20
2218958 2218958 2022-02-15 Clay South Dakota 46027 3470 20
2215707 2215707 2022-02-14 Clay South Dakota 46027 3469 20
2212456 2212456 2022-02-13 Clay South Dakota 46027 3463 20
2209203 2209203 2022-02-12 Clay South Dakota 46027 3463 20
2205950 2205950 2022-02-11 Clay South Dakota 46027 3463 20
2202697 2202697 2022-02-10 Clay South Dakota 46027 3452 20
2199443 2199443 2022-02-09 Clay South Dakota 46027 3446 20
2196189 2196189 2022-02-08 Clay South Dakota 46027 3441 20
2192935 2192935 2022-02-07 Clay South Dakota 46027 3436 20
2189681 2189681 2022-02-06 Clay South Dakota 46027 3426 19
2186428 2186428 2022-02-05 Clay South Dakota 46027 3426 19
2183176 2183176 2022-02-04 Clay South Dakota 46027 3426 19
2179924 2179924 2022-02-03 Clay South Dakota 46027 3422 19

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