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

795 rows where fips = 46099 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 · 795 ✖

fips 1

  • 46099 · 795 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502093 2502093 2022-05-13 Minnehaha South Dakota 46099 57428 519
2498835 2498835 2022-05-12 Minnehaha South Dakota 46099 57428 519
2495577 2495577 2022-05-11 Minnehaha South Dakota 46099 57428 519
2492319 2492319 2022-05-10 Minnehaha South Dakota 46099 57297 519
2489061 2489061 2022-05-09 Minnehaha South Dakota 46099 57297 519
2485804 2485804 2022-05-08 Minnehaha South Dakota 46099 57297 519
2482546 2482546 2022-05-07 Minnehaha South Dakota 46099 57297 519
2479288 2479288 2022-05-06 Minnehaha South Dakota 46099 57297 519
2476030 2476030 2022-05-05 Minnehaha South Dakota 46099 57297 519
2472773 2472773 2022-05-04 Minnehaha South Dakota 46099 57297 519
2469517 2469517 2022-05-03 Minnehaha South Dakota 46099 57166 518
2466261 2466261 2022-05-02 Minnehaha South Dakota 46099 57166 518
2463006 2463006 2022-05-01 Minnehaha South Dakota 46099 57166 518
2459750 2459750 2022-04-30 Minnehaha South Dakota 46099 57166 518
2456494 2456494 2022-04-29 Minnehaha South Dakota 46099 57166 518
2453238 2453238 2022-04-28 Minnehaha South Dakota 46099 57166 518
2449982 2449982 2022-04-27 Minnehaha South Dakota 46099 57166 518
2446725 2446725 2022-04-26 Minnehaha South Dakota 46099 57106 515
2443470 2443470 2022-04-25 Minnehaha South Dakota 46099 57106 515
2440214 2440214 2022-04-24 Minnehaha South Dakota 46099 57106 515
2436958 2436958 2022-04-23 Minnehaha South Dakota 46099 57106 515
2433702 2433702 2022-04-22 Minnehaha South Dakota 46099 57106 515
2430446 2430446 2022-04-21 Minnehaha South Dakota 46099 57106 515
2427190 2427190 2022-04-20 Minnehaha South Dakota 46099 57106 515
2423934 2423934 2022-04-19 Minnehaha South Dakota 46099 57057 514
2420678 2420678 2022-04-18 Minnehaha South Dakota 46099 57057 514
2417422 2417422 2022-04-17 Minnehaha South Dakota 46099 57057 514
2414166 2414166 2022-04-16 Minnehaha South Dakota 46099 57057 514
2410910 2410910 2022-04-15 Minnehaha South Dakota 46099 57057 514
2407654 2407654 2022-04-14 Minnehaha South Dakota 46099 57057 514
2404398 2404398 2022-04-13 Minnehaha South Dakota 46099 57057 514
2401143 2401143 2022-04-12 Minnehaha South Dakota 46099 57034 513
2397888 2397888 2022-04-11 Minnehaha South Dakota 46099 57034 513
2394633 2394633 2022-04-10 Minnehaha South Dakota 46099 57034 513
2391377 2391377 2022-04-09 Minnehaha South Dakota 46099 57034 513
2388121 2388121 2022-04-08 Minnehaha South Dakota 46099 57034 513
2384866 2384866 2022-04-07 Minnehaha South Dakota 46099 57034 513
2381611 2381611 2022-04-06 Minnehaha South Dakota 46099 57034 513
2378356 2378356 2022-04-05 Minnehaha South Dakota 46099 57006 509
2375102 2375102 2022-04-04 Minnehaha South Dakota 46099 57006 509
2371850 2371850 2022-04-03 Minnehaha South Dakota 46099 57006 509
2368597 2368597 2022-04-02 Minnehaha South Dakota 46099 57006 509
2365344 2365344 2022-04-01 Minnehaha South Dakota 46099 57006 509
2362091 2362091 2022-03-31 Minnehaha South Dakota 46099 57006 509
2358837 2358837 2022-03-30 Minnehaha South Dakota 46099 57006 509
2355583 2355583 2022-03-29 Minnehaha South Dakota 46099 56973 509
2352330 2352330 2022-03-28 Minnehaha South Dakota 46099 56973 509
2349078 2349078 2022-03-27 Minnehaha South Dakota 46099 56973 509
2345825 2345825 2022-03-26 Minnehaha South Dakota 46099 56973 509
2342572 2342572 2022-03-25 Minnehaha South Dakota 46099 56973 509
2339319 2339319 2022-03-24 Minnehaha South Dakota 46099 56973 509
2336065 2336065 2022-03-23 Minnehaha South Dakota 46099 56973 509
2332811 2332811 2022-03-22 Minnehaha South Dakota 46099 56962 508
2329558 2329558 2022-03-21 Minnehaha South Dakota 46099 56962 508
2326306 2326306 2022-03-20 Minnehaha South Dakota 46099 56962 508
2323053 2323053 2022-03-19 Minnehaha South Dakota 46099 56962 508
2319799 2319799 2022-03-18 Minnehaha South Dakota 46099 56962 508
2316545 2316545 2022-03-17 Minnehaha South Dakota 46099 56956 507
2313292 2313292 2022-03-16 Minnehaha South Dakota 46099 56947 507
2310039 2310039 2022-03-15 Minnehaha South Dakota 46099 56936 506
2306786 2306786 2022-03-14 Minnehaha South Dakota 46099 56921 506
2303535 2303535 2022-03-13 Minnehaha South Dakota 46099 56909 505
2300283 2300283 2022-03-12 Minnehaha South Dakota 46099 56909 505
2297031 2297031 2022-03-11 Minnehaha South Dakota 46099 56909 505
2293779 2293779 2022-03-10 Minnehaha South Dakota 46099 56900 505
2290527 2290527 2022-03-09 Minnehaha South Dakota 46099 56891 505
2287275 2287275 2022-03-08 Minnehaha South Dakota 46099 56874 505
2284023 2284023 2022-03-07 Minnehaha South Dakota 46099 56862 503
2280771 2280771 2022-03-06 Minnehaha South Dakota 46099 56844 503
2277518 2277518 2022-03-05 Minnehaha South Dakota 46099 56844 503
2274265 2274265 2022-03-04 Minnehaha South Dakota 46099 56844 503
2271012 2271012 2022-03-03 Minnehaha South Dakota 46099 56836 502
2267760 2267760 2022-03-02 Minnehaha South Dakota 46099 56828 501
2264507 2264507 2022-03-01 Minnehaha South Dakota 46099 56818 499
2261257 2261257 2022-02-28 Minnehaha South Dakota 46099 56782 499
2258006 2258006 2022-02-27 Minnehaha South Dakota 46099 56765 498
2254755 2254755 2022-02-26 Minnehaha South Dakota 46099 56765 498
2251504 2251504 2022-02-25 Minnehaha South Dakota 46099 56765 498
2248253 2248253 2022-02-24 Minnehaha South Dakota 46099 56736 497
2245002 2245002 2022-02-23 Minnehaha South Dakota 46099 56718 496
2241751 2241751 2022-02-22 Minnehaha South Dakota 46099 56656 496
2238500 2238500 2022-02-21 Minnehaha South Dakota 46099 56639 493
2235249 2235249 2022-02-20 Minnehaha South Dakota 46099 56639 493
2231998 2231998 2022-02-19 Minnehaha South Dakota 46099 56639 493
2228747 2228747 2022-02-18 Minnehaha South Dakota 46099 56639 493
2225496 2225496 2022-02-17 Minnehaha South Dakota 46099 56611 492
2222245 2222245 2022-02-16 Minnehaha South Dakota 46099 56573 489
2218994 2218994 2022-02-15 Minnehaha South Dakota 46099 56550 488
2215743 2215743 2022-02-14 Minnehaha South Dakota 46099 56475 488
2212492 2212492 2022-02-13 Minnehaha South Dakota 46099 56429 486
2209239 2209239 2022-02-12 Minnehaha South Dakota 46099 56429 486
2205986 2205986 2022-02-11 Minnehaha South Dakota 46099 56429 486
2202733 2202733 2022-02-10 Minnehaha South Dakota 46099 56372 485
2199479 2199479 2022-02-09 Minnehaha South Dakota 46099 56310 482
2196225 2196225 2022-02-08 Minnehaha South Dakota 46099 56215 481
2192971 2192971 2022-02-07 Minnehaha South Dakota 46099 56122 479
2189717 2189717 2022-02-06 Minnehaha South Dakota 46099 56052 477
2186464 2186464 2022-02-05 Minnehaha South Dakota 46099 56052 477
2183212 2183212 2022-02-04 Minnehaha South Dakota 46099 56052 477
2179960 2179960 2022-02-03 Minnehaha South Dakota 46099 55971 472

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