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 = 46103 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

  • 46103 · 782 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502096 2502096 2022-05-13 Pennington South Dakota 46103 32903 342
2498838 2498838 2022-05-12 Pennington South Dakota 46103 32903 342
2495580 2495580 2022-05-11 Pennington South Dakota 46103 32903 342
2492322 2492322 2022-05-10 Pennington South Dakota 46103 32840 342
2489064 2489064 2022-05-09 Pennington South Dakota 46103 32840 342
2485807 2485807 2022-05-08 Pennington South Dakota 46103 32840 342
2482549 2482549 2022-05-07 Pennington South Dakota 46103 32840 342
2479291 2479291 2022-05-06 Pennington South Dakota 46103 32840 342
2476033 2476033 2022-05-05 Pennington South Dakota 46103 32840 342
2472776 2472776 2022-05-04 Pennington South Dakota 46103 32840 342
2469520 2469520 2022-05-03 Pennington South Dakota 46103 32793 341
2466264 2466264 2022-05-02 Pennington South Dakota 46103 32793 341
2463009 2463009 2022-05-01 Pennington South Dakota 46103 32793 341
2459753 2459753 2022-04-30 Pennington South Dakota 46103 32793 341
2456497 2456497 2022-04-29 Pennington South Dakota 46103 32793 341
2453241 2453241 2022-04-28 Pennington South Dakota 46103 32793 341
2449985 2449985 2022-04-27 Pennington South Dakota 46103 32793 341
2446728 2446728 2022-04-26 Pennington South Dakota 46103 32735 341
2443473 2443473 2022-04-25 Pennington South Dakota 46103 32735 341
2440217 2440217 2022-04-24 Pennington South Dakota 46103 32735 341
2436961 2436961 2022-04-23 Pennington South Dakota 46103 32735 341
2433705 2433705 2022-04-22 Pennington South Dakota 46103 32735 341
2430449 2430449 2022-04-21 Pennington South Dakota 46103 32735 341
2427193 2427193 2022-04-20 Pennington South Dakota 46103 32735 341
2423937 2423937 2022-04-19 Pennington South Dakota 46103 32705 341
2420681 2420681 2022-04-18 Pennington South Dakota 46103 32705 341
2417425 2417425 2022-04-17 Pennington South Dakota 46103 32705 341
2414169 2414169 2022-04-16 Pennington South Dakota 46103 32705 341
2410913 2410913 2022-04-15 Pennington South Dakota 46103 32705 341
2407657 2407657 2022-04-14 Pennington South Dakota 46103 32705 341
2404401 2404401 2022-04-13 Pennington South Dakota 46103 32705 341
2401146 2401146 2022-04-12 Pennington South Dakota 46103 32674 340
2397891 2397891 2022-04-11 Pennington South Dakota 46103 32674 340
2394636 2394636 2022-04-10 Pennington South Dakota 46103 32674 340
2391380 2391380 2022-04-09 Pennington South Dakota 46103 32674 340
2388124 2388124 2022-04-08 Pennington South Dakota 46103 32674 340
2384869 2384869 2022-04-07 Pennington South Dakota 46103 32674 340
2381614 2381614 2022-04-06 Pennington South Dakota 46103 32674 340
2378359 2378359 2022-04-05 Pennington South Dakota 46103 32660 340
2375105 2375105 2022-04-04 Pennington South Dakota 46103 32660 340
2371853 2371853 2022-04-03 Pennington South Dakota 46103 32660 340
2368600 2368600 2022-04-02 Pennington South Dakota 46103 32660 340
2365347 2365347 2022-04-01 Pennington South Dakota 46103 32660 340
2362094 2362094 2022-03-31 Pennington South Dakota 46103 32660 340
2358840 2358840 2022-03-30 Pennington South Dakota 46103 32660 340
2355586 2355586 2022-03-29 Pennington South Dakota 46103 32635 338
2352333 2352333 2022-03-28 Pennington South Dakota 46103 32635 338
2349081 2349081 2022-03-27 Pennington South Dakota 46103 32635 338
2345828 2345828 2022-03-26 Pennington South Dakota 46103 32635 338
2342575 2342575 2022-03-25 Pennington South Dakota 46103 32635 338
2339322 2339322 2022-03-24 Pennington South Dakota 46103 32635 338
2336068 2336068 2022-03-23 Pennington South Dakota 46103 32635 338
2332814 2332814 2022-03-22 Pennington South Dakota 46103 32611 337
2329561 2329561 2022-03-21 Pennington South Dakota 46103 32611 337
2326309 2326309 2022-03-20 Pennington South Dakota 46103 32611 337
2323056 2323056 2022-03-19 Pennington South Dakota 46103 32611 337
2319802 2319802 2022-03-18 Pennington South Dakota 46103 32611 337
2316548 2316548 2022-03-17 Pennington South Dakota 46103 32600 336
2313295 2313295 2022-03-16 Pennington South Dakota 46103 32583 335
2310042 2310042 2022-03-15 Pennington South Dakota 46103 32573 334
2306789 2306789 2022-03-14 Pennington South Dakota 46103 32562 334
2303538 2303538 2022-03-13 Pennington South Dakota 46103 32559 334
2300286 2300286 2022-03-12 Pennington South Dakota 46103 32559 334
2297034 2297034 2022-03-11 Pennington South Dakota 46103 32559 334
2293782 2293782 2022-03-10 Pennington South Dakota 46103 32551 332
2290530 2290530 2022-03-09 Pennington South Dakota 46103 32546 332
2287278 2287278 2022-03-08 Pennington South Dakota 46103 32538 332
2284026 2284026 2022-03-07 Pennington South Dakota 46103 32523 331
2280774 2280774 2022-03-06 Pennington South Dakota 46103 32516 331
2277521 2277521 2022-03-05 Pennington South Dakota 46103 32516 331
2274268 2274268 2022-03-04 Pennington South Dakota 46103 32516 331
2271015 2271015 2022-03-03 Pennington South Dakota 46103 32505 331
2267763 2267763 2022-03-02 Pennington South Dakota 46103 32488 330
2264510 2264510 2022-03-01 Pennington South Dakota 46103 32480 330
2261260 2261260 2022-02-28 Pennington South Dakota 46103 32447 328
2258009 2258009 2022-02-27 Pennington South Dakota 46103 32424 327
2254758 2254758 2022-02-26 Pennington South Dakota 46103 32424 327
2251507 2251507 2022-02-25 Pennington South Dakota 46103 32424 327
2248256 2248256 2022-02-24 Pennington South Dakota 46103 32403 325
2245005 2245005 2022-02-23 Pennington South Dakota 46103 32382 325
2241754 2241754 2022-02-22 Pennington South Dakota 46103 32328 325
2238503 2238503 2022-02-21 Pennington South Dakota 46103 32299 324
2235252 2235252 2022-02-20 Pennington South Dakota 46103 32299 324
2232001 2232001 2022-02-19 Pennington South Dakota 46103 32299 324
2228750 2228750 2022-02-18 Pennington South Dakota 46103 32299 324
2225499 2225499 2022-02-17 Pennington South Dakota 46103 32275 322
2222248 2222248 2022-02-16 Pennington South Dakota 46103 32242 322
2218997 2218997 2022-02-15 Pennington South Dakota 46103 32197 321
2215746 2215746 2022-02-14 Pennington South Dakota 46103 32124 321
2212495 2212495 2022-02-13 Pennington South Dakota 46103 32081 321
2209242 2209242 2022-02-12 Pennington South Dakota 46103 32081 321
2205989 2205989 2022-02-11 Pennington South Dakota 46103 32081 321
2202736 2202736 2022-02-10 Pennington South Dakota 46103 32038 318
2199482 2199482 2022-02-09 Pennington South Dakota 46103 31982 316
2196228 2196228 2022-02-08 Pennington South Dakota 46103 31868 313
2192974 2192974 2022-02-07 Pennington South Dakota 46103 31760 312
2189720 2189720 2022-02-06 Pennington South Dakota 46103 31676 311
2186467 2186467 2022-02-05 Pennington South Dakota 46103 31676 311
2183215 2183215 2022-02-04 Pennington South Dakota 46103 31676 311
2179963 2179963 2022-02-03 Pennington South Dakota 46103 31602 310

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