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

749 rows where county = "McPherson" and fips = 46089 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 46089 · 749 ✖

county 1

  • McPherson · 749 ✖
Link rowid date ▲ county state fips cases deaths
2502089 2502089 2022-05-13 McPherson South Dakota 46089 426 9
2498831 2498831 2022-05-12 McPherson South Dakota 46089 426 9
2495573 2495573 2022-05-11 McPherson South Dakota 46089 426 9
2492315 2492315 2022-05-10 McPherson South Dakota 46089 426 9
2489057 2489057 2022-05-09 McPherson South Dakota 46089 426 9
2485800 2485800 2022-05-08 McPherson South Dakota 46089 426 9
2482542 2482542 2022-05-07 McPherson South Dakota 46089 426 9
2479284 2479284 2022-05-06 McPherson South Dakota 46089 426 9
2476026 2476026 2022-05-05 McPherson South Dakota 46089 426 9
2472769 2472769 2022-05-04 McPherson South Dakota 46089 426 9
2469513 2469513 2022-05-03 McPherson South Dakota 46089 426 9
2466257 2466257 2022-05-02 McPherson South Dakota 46089 426 9
2463002 2463002 2022-05-01 McPherson South Dakota 46089 426 9
2459746 2459746 2022-04-30 McPherson South Dakota 46089 426 9
2456490 2456490 2022-04-29 McPherson South Dakota 46089 426 9
2453234 2453234 2022-04-28 McPherson South Dakota 46089 426 9
2449978 2449978 2022-04-27 McPherson South Dakota 46089 426 9
2446721 2446721 2022-04-26 McPherson South Dakota 46089 425 9
2443466 2443466 2022-04-25 McPherson South Dakota 46089 425 9
2440210 2440210 2022-04-24 McPherson South Dakota 46089 425 9
2436954 2436954 2022-04-23 McPherson South Dakota 46089 425 9
2433698 2433698 2022-04-22 McPherson South Dakota 46089 425 9
2430442 2430442 2022-04-21 McPherson South Dakota 46089 425 9
2427186 2427186 2022-04-20 McPherson South Dakota 46089 425 9
2423930 2423930 2022-04-19 McPherson South Dakota 46089 425 9
2420674 2420674 2022-04-18 McPherson South Dakota 46089 425 9
2417418 2417418 2022-04-17 McPherson South Dakota 46089 425 9
2414162 2414162 2022-04-16 McPherson South Dakota 46089 425 9
2410906 2410906 2022-04-15 McPherson South Dakota 46089 425 9
2407650 2407650 2022-04-14 McPherson South Dakota 46089 425 9
2404394 2404394 2022-04-13 McPherson South Dakota 46089 425 9
2401139 2401139 2022-04-12 McPherson South Dakota 46089 425 9
2397884 2397884 2022-04-11 McPherson South Dakota 46089 425 9
2394629 2394629 2022-04-10 McPherson South Dakota 46089 425 9
2391373 2391373 2022-04-09 McPherson South Dakota 46089 425 9
2388117 2388117 2022-04-08 McPherson South Dakota 46089 425 9
2384862 2384862 2022-04-07 McPherson South Dakota 46089 425 9
2381607 2381607 2022-04-06 McPherson South Dakota 46089 425 9
2378352 2378352 2022-04-05 McPherson South Dakota 46089 425 9
2375098 2375098 2022-04-04 McPherson South Dakota 46089 425 9
2371846 2371846 2022-04-03 McPherson South Dakota 46089 425 9
2368593 2368593 2022-04-02 McPherson South Dakota 46089 425 9
2365340 2365340 2022-04-01 McPherson South Dakota 46089 425 9
2362087 2362087 2022-03-31 McPherson South Dakota 46089 425 9
2358833 2358833 2022-03-30 McPherson South Dakota 46089 425 9
2355579 2355579 2022-03-29 McPherson South Dakota 46089 425 9
2352326 2352326 2022-03-28 McPherson South Dakota 46089 425 9
2349074 2349074 2022-03-27 McPherson South Dakota 46089 425 9
2345821 2345821 2022-03-26 McPherson South Dakota 46089 425 9
2342568 2342568 2022-03-25 McPherson South Dakota 46089 425 9
2339315 2339315 2022-03-24 McPherson South Dakota 46089 425 9
2336061 2336061 2022-03-23 McPherson South Dakota 46089 425 9
2332807 2332807 2022-03-22 McPherson South Dakota 46089 425 9
2329554 2329554 2022-03-21 McPherson South Dakota 46089 425 9
2326302 2326302 2022-03-20 McPherson South Dakota 46089 425 9
2323049 2323049 2022-03-19 McPherson South Dakota 46089 425 9
2319795 2319795 2022-03-18 McPherson South Dakota 46089 425 9
2316541 2316541 2022-03-17 McPherson South Dakota 46089 425 9
2313288 2313288 2022-03-16 McPherson South Dakota 46089 425 9
2310035 2310035 2022-03-15 McPherson South Dakota 46089 425 9
2306782 2306782 2022-03-14 McPherson South Dakota 46089 425 9
2303531 2303531 2022-03-13 McPherson South Dakota 46089 425 9
2300279 2300279 2022-03-12 McPherson South Dakota 46089 425 9
2297027 2297027 2022-03-11 McPherson South Dakota 46089 425 9
2293775 2293775 2022-03-10 McPherson South Dakota 46089 425 9
2290523 2290523 2022-03-09 McPherson South Dakota 46089 426 9
2287271 2287271 2022-03-08 McPherson South Dakota 46089 426 9
2284019 2284019 2022-03-07 McPherson South Dakota 46089 426 9
2280767 2280767 2022-03-06 McPherson South Dakota 46089 426 9
2277514 2277514 2022-03-05 McPherson South Dakota 46089 426 9
2274261 2274261 2022-03-04 McPherson South Dakota 46089 426 9
2271008 2271008 2022-03-03 McPherson South Dakota 46089 426 9
2267756 2267756 2022-03-02 McPherson South Dakota 46089 426 9
2264503 2264503 2022-03-01 McPherson South Dakota 46089 426 9
2261253 2261253 2022-02-28 McPherson South Dakota 46089 424 9
2258002 2258002 2022-02-27 McPherson South Dakota 46089 424 9
2254751 2254751 2022-02-26 McPherson South Dakota 46089 424 9
2251500 2251500 2022-02-25 McPherson South Dakota 46089 424 9
2248249 2248249 2022-02-24 McPherson South Dakota 46089 424 9
2244998 2244998 2022-02-23 McPherson South Dakota 46089 423 9
2241747 2241747 2022-02-22 McPherson South Dakota 46089 422 9
2238496 2238496 2022-02-21 McPherson South Dakota 46089 422 9
2235245 2235245 2022-02-20 McPherson South Dakota 46089 422 9
2231994 2231994 2022-02-19 McPherson South Dakota 46089 422 9
2228743 2228743 2022-02-18 McPherson South Dakota 46089 422 9
2225492 2225492 2022-02-17 McPherson South Dakota 46089 422 9
2222241 2222241 2022-02-16 McPherson South Dakota 46089 421 9
2218990 2218990 2022-02-15 McPherson South Dakota 46089 420 9
2215739 2215739 2022-02-14 McPherson South Dakota 46089 419 9
2212488 2212488 2022-02-13 McPherson South Dakota 46089 417 9
2209235 2209235 2022-02-12 McPherson South Dakota 46089 417 9
2205982 2205982 2022-02-11 McPherson South Dakota 46089 417 9
2202729 2202729 2022-02-10 McPherson South Dakota 46089 417 9
2199475 2199475 2022-02-09 McPherson South Dakota 46089 417 9
2196221 2196221 2022-02-08 McPherson South Dakota 46089 416 9
2192967 2192967 2022-02-07 McPherson South Dakota 46089 415 9
2189713 2189713 2022-02-06 McPherson South Dakota 46089 415 9
2186460 2186460 2022-02-05 McPherson South Dakota 46089 415 9
2183208 2183208 2022-02-04 McPherson South Dakota 46089 415 9
2179956 2179956 2022-02-03 McPherson South Dakota 46089 414 9

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