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

747 rows where fips = 46043 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 46043 · 747 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502065 2502065 2022-05-13 Douglas South Dakota 46043 684 16
2498807 2498807 2022-05-12 Douglas South Dakota 46043 684 16
2495549 2495549 2022-05-11 Douglas South Dakota 46043 684 16
2492291 2492291 2022-05-10 Douglas South Dakota 46043 684 16
2489033 2489033 2022-05-09 Douglas South Dakota 46043 684 16
2485776 2485776 2022-05-08 Douglas South Dakota 46043 684 16
2482518 2482518 2022-05-07 Douglas South Dakota 46043 684 16
2479260 2479260 2022-05-06 Douglas South Dakota 46043 684 16
2476002 2476002 2022-05-05 Douglas South Dakota 46043 684 16
2472745 2472745 2022-05-04 Douglas South Dakota 46043 684 16
2469489 2469489 2022-05-03 Douglas South Dakota 46043 684 16
2466233 2466233 2022-05-02 Douglas South Dakota 46043 684 16
2462978 2462978 2022-05-01 Douglas South Dakota 46043 684 16
2459722 2459722 2022-04-30 Douglas South Dakota 46043 684 16
2456466 2456466 2022-04-29 Douglas South Dakota 46043 684 16
2453210 2453210 2022-04-28 Douglas South Dakota 46043 684 16
2449954 2449954 2022-04-27 Douglas South Dakota 46043 684 16
2446697 2446697 2022-04-26 Douglas South Dakota 46043 682 16
2443442 2443442 2022-04-25 Douglas South Dakota 46043 682 16
2440186 2440186 2022-04-24 Douglas South Dakota 46043 682 16
2436930 2436930 2022-04-23 Douglas South Dakota 46043 682 16
2433674 2433674 2022-04-22 Douglas South Dakota 46043 682 16
2430418 2430418 2022-04-21 Douglas South Dakota 46043 682 16
2427162 2427162 2022-04-20 Douglas South Dakota 46043 682 16
2423906 2423906 2022-04-19 Douglas South Dakota 46043 681 16
2420650 2420650 2022-04-18 Douglas South Dakota 46043 681 16
2417394 2417394 2022-04-17 Douglas South Dakota 46043 681 16
2414138 2414138 2022-04-16 Douglas South Dakota 46043 681 16
2410882 2410882 2022-04-15 Douglas South Dakota 46043 681 16
2407626 2407626 2022-04-14 Douglas South Dakota 46043 681 16
2404370 2404370 2022-04-13 Douglas South Dakota 46043 681 16
2401115 2401115 2022-04-12 Douglas South Dakota 46043 681 16
2397860 2397860 2022-04-11 Douglas South Dakota 46043 681 16
2394605 2394605 2022-04-10 Douglas South Dakota 46043 681 16
2391349 2391349 2022-04-09 Douglas South Dakota 46043 681 16
2388093 2388093 2022-04-08 Douglas South Dakota 46043 681 16
2384838 2384838 2022-04-07 Douglas South Dakota 46043 681 16
2381583 2381583 2022-04-06 Douglas South Dakota 46043 681 16
2378328 2378328 2022-04-05 Douglas South Dakota 46043 681 16
2375074 2375074 2022-04-04 Douglas South Dakota 46043 681 16
2371822 2371822 2022-04-03 Douglas South Dakota 46043 681 16
2368569 2368569 2022-04-02 Douglas South Dakota 46043 681 16
2365316 2365316 2022-04-01 Douglas South Dakota 46043 681 16
2362063 2362063 2022-03-31 Douglas South Dakota 46043 681 16
2358809 2358809 2022-03-30 Douglas South Dakota 46043 681 16
2355555 2355555 2022-03-29 Douglas South Dakota 46043 681 16
2352302 2352302 2022-03-28 Douglas South Dakota 46043 681 16
2349050 2349050 2022-03-27 Douglas South Dakota 46043 681 16
2345797 2345797 2022-03-26 Douglas South Dakota 46043 681 16
2342544 2342544 2022-03-25 Douglas South Dakota 46043 681 16
2339291 2339291 2022-03-24 Douglas South Dakota 46043 681 16
2336037 2336037 2022-03-23 Douglas South Dakota 46043 681 16
2332783 2332783 2022-03-22 Douglas South Dakota 46043 682 16
2329530 2329530 2022-03-21 Douglas South Dakota 46043 682 16
2326278 2326278 2022-03-20 Douglas South Dakota 46043 682 16
2323025 2323025 2022-03-19 Douglas South Dakota 46043 682 16
2319771 2319771 2022-03-18 Douglas South Dakota 46043 682 16
2316517 2316517 2022-03-17 Douglas South Dakota 46043 682 16
2313264 2313264 2022-03-16 Douglas South Dakota 46043 682 16
2310011 2310011 2022-03-15 Douglas South Dakota 46043 682 16
2306758 2306758 2022-03-14 Douglas South Dakota 46043 682 16
2303507 2303507 2022-03-13 Douglas South Dakota 46043 682 16
2300255 2300255 2022-03-12 Douglas South Dakota 46043 682 16
2297003 2297003 2022-03-11 Douglas South Dakota 46043 682 16
2293751 2293751 2022-03-10 Douglas South Dakota 46043 682 16
2290499 2290499 2022-03-09 Douglas South Dakota 46043 682 16
2287247 2287247 2022-03-08 Douglas South Dakota 46043 682 16
2283995 2283995 2022-03-07 Douglas South Dakota 46043 682 16
2280743 2280743 2022-03-06 Douglas South Dakota 46043 682 16
2277490 2277490 2022-03-05 Douglas South Dakota 46043 682 16
2274237 2274237 2022-03-04 Douglas South Dakota 46043 682 16
2270984 2270984 2022-03-03 Douglas South Dakota 46043 682 16
2267732 2267732 2022-03-02 Douglas South Dakota 46043 682 16
2264479 2264479 2022-03-01 Douglas South Dakota 46043 682 16
2261229 2261229 2022-02-28 Douglas South Dakota 46043 682 16
2257978 2257978 2022-02-27 Douglas South Dakota 46043 682 16
2254727 2254727 2022-02-26 Douglas South Dakota 46043 682 16
2251476 2251476 2022-02-25 Douglas South Dakota 46043 682 16
2248225 2248225 2022-02-24 Douglas South Dakota 46043 682 16
2244974 2244974 2022-02-23 Douglas South Dakota 46043 682 16
2241723 2241723 2022-02-22 Douglas South Dakota 46043 680 16
2238472 2238472 2022-02-21 Douglas South Dakota 46043 680 16
2235221 2235221 2022-02-20 Douglas South Dakota 46043 680 16
2231970 2231970 2022-02-19 Douglas South Dakota 46043 680 16
2228719 2228719 2022-02-18 Douglas South Dakota 46043 680 16
2225468 2225468 2022-02-17 Douglas South Dakota 46043 680 16
2222217 2222217 2022-02-16 Douglas South Dakota 46043 680 16
2218966 2218966 2022-02-15 Douglas South Dakota 46043 680 16
2215715 2215715 2022-02-14 Douglas South Dakota 46043 680 16
2212464 2212464 2022-02-13 Douglas South Dakota 46043 680 16
2209211 2209211 2022-02-12 Douglas South Dakota 46043 680 16
2205958 2205958 2022-02-11 Douglas South Dakota 46043 680 16
2202705 2202705 2022-02-10 Douglas South Dakota 46043 680 16
2199451 2199451 2022-02-09 Douglas South Dakota 46043 679 16
2196197 2196197 2022-02-08 Douglas South Dakota 46043 675 16
2192943 2192943 2022-02-07 Douglas South Dakota 46043 675 16
2189689 2189689 2022-02-06 Douglas South Dakota 46043 673 16
2186436 2186436 2022-02-05 Douglas South Dakota 46043 673 16
2183184 2183184 2022-02-04 Douglas South Dakota 46043 673 16
2179932 2179932 2022-02-03 Douglas South Dakota 46043 671 16

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