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

792 rows where fips = 46087 and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • South Dakota · 792 ✖

fips 1

  • 46087 · 792 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502088 2502088 2022-05-13 McCook South Dakota 46087 1348 31
2498830 2498830 2022-05-12 McCook South Dakota 46087 1348 31
2495572 2495572 2022-05-11 McCook South Dakota 46087 1348 31
2492314 2492314 2022-05-10 McCook South Dakota 46087 1344 31
2489056 2489056 2022-05-09 McCook South Dakota 46087 1344 31
2485799 2485799 2022-05-08 McCook South Dakota 46087 1344 31
2482541 2482541 2022-05-07 McCook South Dakota 46087 1344 31
2479283 2479283 2022-05-06 McCook South Dakota 46087 1344 31
2476025 2476025 2022-05-05 McCook South Dakota 46087 1344 31
2472768 2472768 2022-05-04 McCook South Dakota 46087 1344 31
2469512 2469512 2022-05-03 McCook South Dakota 46087 1341 31
2466256 2466256 2022-05-02 McCook South Dakota 46087 1341 31
2463001 2463001 2022-05-01 McCook South Dakota 46087 1341 31
2459745 2459745 2022-04-30 McCook South Dakota 46087 1341 31
2456489 2456489 2022-04-29 McCook South Dakota 46087 1341 31
2453233 2453233 2022-04-28 McCook South Dakota 46087 1341 31
2449977 2449977 2022-04-27 McCook South Dakota 46087 1341 31
2446720 2446720 2022-04-26 McCook South Dakota 46087 1341 31
2443465 2443465 2022-04-25 McCook South Dakota 46087 1341 31
2440209 2440209 2022-04-24 McCook South Dakota 46087 1341 31
2436953 2436953 2022-04-23 McCook South Dakota 46087 1341 31
2433697 2433697 2022-04-22 McCook South Dakota 46087 1341 31
2430441 2430441 2022-04-21 McCook South Dakota 46087 1341 31
2427185 2427185 2022-04-20 McCook South Dakota 46087 1341 31
2423929 2423929 2022-04-19 McCook South Dakota 46087 1340 31
2420673 2420673 2022-04-18 McCook South Dakota 46087 1340 31
2417417 2417417 2022-04-17 McCook South Dakota 46087 1340 31
2414161 2414161 2022-04-16 McCook South Dakota 46087 1340 31
2410905 2410905 2022-04-15 McCook South Dakota 46087 1340 31
2407649 2407649 2022-04-14 McCook South Dakota 46087 1340 31
2404393 2404393 2022-04-13 McCook South Dakota 46087 1340 31
2401138 2401138 2022-04-12 McCook South Dakota 46087 1340 31
2397883 2397883 2022-04-11 McCook South Dakota 46087 1340 31
2394628 2394628 2022-04-10 McCook South Dakota 46087 1340 31
2391372 2391372 2022-04-09 McCook South Dakota 46087 1340 31
2388116 2388116 2022-04-08 McCook South Dakota 46087 1340 31
2384861 2384861 2022-04-07 McCook South Dakota 46087 1340 31
2381606 2381606 2022-04-06 McCook South Dakota 46087 1340 31
2378351 2378351 2022-04-05 McCook South Dakota 46087 1340 31
2375097 2375097 2022-04-04 McCook South Dakota 46087 1340 31
2371845 2371845 2022-04-03 McCook South Dakota 46087 1340 31
2368592 2368592 2022-04-02 McCook South Dakota 46087 1340 31
2365339 2365339 2022-04-01 McCook South Dakota 46087 1340 31
2362086 2362086 2022-03-31 McCook South Dakota 46087 1340 31
2358832 2358832 2022-03-30 McCook South Dakota 46087 1340 31
2355578 2355578 2022-03-29 McCook South Dakota 46087 1341 31
2352325 2352325 2022-03-28 McCook South Dakota 46087 1341 31
2349073 2349073 2022-03-27 McCook South Dakota 46087 1341 31
2345820 2345820 2022-03-26 McCook South Dakota 46087 1341 31
2342567 2342567 2022-03-25 McCook South Dakota 46087 1341 31
2339314 2339314 2022-03-24 McCook South Dakota 46087 1341 31
2336060 2336060 2022-03-23 McCook South Dakota 46087 1341 31
2332806 2332806 2022-03-22 McCook South Dakota 46087 1341 31
2329553 2329553 2022-03-21 McCook South Dakota 46087 1341 31
2326301 2326301 2022-03-20 McCook South Dakota 46087 1341 31
2323048 2323048 2022-03-19 McCook South Dakota 46087 1341 31
2319794 2319794 2022-03-18 McCook South Dakota 46087 1341 31
2316540 2316540 2022-03-17 McCook South Dakota 46087 1341 31
2313287 2313287 2022-03-16 McCook South Dakota 46087 1341 31
2310034 2310034 2022-03-15 McCook South Dakota 46087 1341 31
2306781 2306781 2022-03-14 McCook South Dakota 46087 1341 31
2303530 2303530 2022-03-13 McCook South Dakota 46087 1341 31
2300278 2300278 2022-03-12 McCook South Dakota 46087 1341 31
2297026 2297026 2022-03-11 McCook South Dakota 46087 1341 31
2293774 2293774 2022-03-10 McCook South Dakota 46087 1341 31
2290522 2290522 2022-03-09 McCook South Dakota 46087 1341 31
2287270 2287270 2022-03-08 McCook South Dakota 46087 1340 31
2284018 2284018 2022-03-07 McCook South Dakota 46087 1339 31
2280766 2280766 2022-03-06 McCook South Dakota 46087 1339 31
2277513 2277513 2022-03-05 McCook South Dakota 46087 1339 31
2274260 2274260 2022-03-04 McCook South Dakota 46087 1339 31
2271007 2271007 2022-03-03 McCook South Dakota 46087 1339 31
2267755 2267755 2022-03-02 McCook South Dakota 46087 1338 31
2264502 2264502 2022-03-01 McCook South Dakota 46087 1337 31
2261252 2261252 2022-02-28 McCook South Dakota 46087 1336 31
2258001 2258001 2022-02-27 McCook South Dakota 46087 1335 31
2254750 2254750 2022-02-26 McCook South Dakota 46087 1335 31
2251499 2251499 2022-02-25 McCook South Dakota 46087 1335 31
2248248 2248248 2022-02-24 McCook South Dakota 46087 1335 31
2244997 2244997 2022-02-23 McCook South Dakota 46087 1334 31
2241746 2241746 2022-02-22 McCook South Dakota 46087 1332 31
2238495 2238495 2022-02-21 McCook South Dakota 46087 1331 31
2235244 2235244 2022-02-20 McCook South Dakota 46087 1331 31
2231993 2231993 2022-02-19 McCook South Dakota 46087 1331 31
2228742 2228742 2022-02-18 McCook South Dakota 46087 1331 31
2225491 2225491 2022-02-17 McCook South Dakota 46087 1331 30
2222240 2222240 2022-02-16 McCook South Dakota 46087 1328 30
2218989 2218989 2022-02-15 McCook South Dakota 46087 1327 30
2215738 2215738 2022-02-14 McCook South Dakota 46087 1326 30
2212487 2212487 2022-02-13 McCook South Dakota 46087 1325 30
2209234 2209234 2022-02-12 McCook South Dakota 46087 1325 30
2205981 2205981 2022-02-11 McCook South Dakota 46087 1325 30
2202728 2202728 2022-02-10 McCook South Dakota 46087 1325 30
2199474 2199474 2022-02-09 McCook South Dakota 46087 1322 30
2196220 2196220 2022-02-08 McCook South Dakota 46087 1318 30
2192966 2192966 2022-02-07 McCook South Dakota 46087 1317 30
2189712 2189712 2022-02-06 McCook South Dakota 46087 1315 30
2186459 2186459 2022-02-05 McCook South Dakota 46087 1315 30
2183207 2183207 2022-02-04 McCook South Dakota 46087 1315 30
2179955 2179955 2022-02-03 McCook South Dakota 46087 1313 30

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