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

778 rows where county = "Faulk" 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 · 778 ✖

fips 1

county 1

  • Faulk · 778 ✖
Link rowid date ▲ county state fips cases deaths
2502068 2502068 2022-05-13 Faulk South Dakota 46049 572 16
2498810 2498810 2022-05-12 Faulk South Dakota 46049 572 16
2495552 2495552 2022-05-11 Faulk South Dakota 46049 572 16
2492294 2492294 2022-05-10 Faulk South Dakota 46049 573 16
2489036 2489036 2022-05-09 Faulk South Dakota 46049 573 16
2485779 2485779 2022-05-08 Faulk South Dakota 46049 573 16
2482521 2482521 2022-05-07 Faulk South Dakota 46049 573 16
2479263 2479263 2022-05-06 Faulk South Dakota 46049 573 16
2476005 2476005 2022-05-05 Faulk South Dakota 46049 573 16
2472748 2472748 2022-05-04 Faulk South Dakota 46049 573 16
2469492 2469492 2022-05-03 Faulk South Dakota 46049 571 16
2466236 2466236 2022-05-02 Faulk South Dakota 46049 571 16
2462981 2462981 2022-05-01 Faulk South Dakota 46049 571 16
2459725 2459725 2022-04-30 Faulk South Dakota 46049 571 16
2456469 2456469 2022-04-29 Faulk South Dakota 46049 571 16
2453213 2453213 2022-04-28 Faulk South Dakota 46049 571 16
2449957 2449957 2022-04-27 Faulk South Dakota 46049 571 16
2446700 2446700 2022-04-26 Faulk South Dakota 46049 569 16
2443445 2443445 2022-04-25 Faulk South Dakota 46049 569 16
2440189 2440189 2022-04-24 Faulk South Dakota 46049 569 16
2436933 2436933 2022-04-23 Faulk South Dakota 46049 569 16
2433677 2433677 2022-04-22 Faulk South Dakota 46049 569 16
2430421 2430421 2022-04-21 Faulk South Dakota 46049 569 16
2427165 2427165 2022-04-20 Faulk South Dakota 46049 569 16
2423909 2423909 2022-04-19 Faulk South Dakota 46049 565 16
2420653 2420653 2022-04-18 Faulk South Dakota 46049 565 16
2417397 2417397 2022-04-17 Faulk South Dakota 46049 565 16
2414141 2414141 2022-04-16 Faulk South Dakota 46049 565 16
2410885 2410885 2022-04-15 Faulk South Dakota 46049 565 16
2407629 2407629 2022-04-14 Faulk South Dakota 46049 565 16
2404373 2404373 2022-04-13 Faulk South Dakota 46049 565 16
2401118 2401118 2022-04-12 Faulk South Dakota 46049 565 16
2397863 2397863 2022-04-11 Faulk South Dakota 46049 565 16
2394608 2394608 2022-04-10 Faulk South Dakota 46049 565 16
2391352 2391352 2022-04-09 Faulk South Dakota 46049 565 16
2388096 2388096 2022-04-08 Faulk South Dakota 46049 565 16
2384841 2384841 2022-04-07 Faulk South Dakota 46049 565 16
2381586 2381586 2022-04-06 Faulk South Dakota 46049 565 16
2378331 2378331 2022-04-05 Faulk South Dakota 46049 564 16
2375077 2375077 2022-04-04 Faulk South Dakota 46049 564 16
2371825 2371825 2022-04-03 Faulk South Dakota 46049 564 16
2368572 2368572 2022-04-02 Faulk South Dakota 46049 564 16
2365319 2365319 2022-04-01 Faulk South Dakota 46049 564 16
2362066 2362066 2022-03-31 Faulk South Dakota 46049 564 16
2358812 2358812 2022-03-30 Faulk South Dakota 46049 564 16
2355558 2355558 2022-03-29 Faulk South Dakota 46049 563 16
2352305 2352305 2022-03-28 Faulk South Dakota 46049 563 16
2349053 2349053 2022-03-27 Faulk South Dakota 46049 563 16
2345800 2345800 2022-03-26 Faulk South Dakota 46049 563 16
2342547 2342547 2022-03-25 Faulk South Dakota 46049 563 16
2339294 2339294 2022-03-24 Faulk South Dakota 46049 563 16
2336040 2336040 2022-03-23 Faulk South Dakota 46049 563 16
2332786 2332786 2022-03-22 Faulk South Dakota 46049 562 16
2329533 2329533 2022-03-21 Faulk South Dakota 46049 562 16
2326281 2326281 2022-03-20 Faulk South Dakota 46049 562 16
2323028 2323028 2022-03-19 Faulk South Dakota 46049 562 16
2319774 2319774 2022-03-18 Faulk South Dakota 46049 562 16
2316520 2316520 2022-03-17 Faulk South Dakota 46049 562 16
2313267 2313267 2022-03-16 Faulk South Dakota 46049 562 16
2310014 2310014 2022-03-15 Faulk South Dakota 46049 562 16
2306761 2306761 2022-03-14 Faulk South Dakota 46049 562 16
2303510 2303510 2022-03-13 Faulk South Dakota 46049 562 16
2300258 2300258 2022-03-12 Faulk South Dakota 46049 562 16
2297006 2297006 2022-03-11 Faulk South Dakota 46049 562 16
2293754 2293754 2022-03-10 Faulk South Dakota 46049 562 16
2290502 2290502 2022-03-09 Faulk South Dakota 46049 562 16
2287250 2287250 2022-03-08 Faulk South Dakota 46049 562 16
2283998 2283998 2022-03-07 Faulk South Dakota 46049 561 16
2280746 2280746 2022-03-06 Faulk South Dakota 46049 560 16
2277493 2277493 2022-03-05 Faulk South Dakota 46049 560 16
2274240 2274240 2022-03-04 Faulk South Dakota 46049 560 16
2270987 2270987 2022-03-03 Faulk South Dakota 46049 560 16
2267735 2267735 2022-03-02 Faulk South Dakota 46049 559 16
2264482 2264482 2022-03-01 Faulk South Dakota 46049 559 16
2261232 2261232 2022-02-28 Faulk South Dakota 46049 554 16
2257981 2257981 2022-02-27 Faulk South Dakota 46049 552 16
2254730 2254730 2022-02-26 Faulk South Dakota 46049 552 16
2251479 2251479 2022-02-25 Faulk South Dakota 46049 552 16
2248228 2248228 2022-02-24 Faulk South Dakota 46049 552 16
2244977 2244977 2022-02-23 Faulk South Dakota 46049 552 16
2241726 2241726 2022-02-22 Faulk South Dakota 46049 550 16
2238475 2238475 2022-02-21 Faulk South Dakota 46049 550 16
2235224 2235224 2022-02-20 Faulk South Dakota 46049 550 16
2231973 2231973 2022-02-19 Faulk South Dakota 46049 550 16
2228722 2228722 2022-02-18 Faulk South Dakota 46049 550 16
2225471 2225471 2022-02-17 Faulk South Dakota 46049 549 16
2222220 2222220 2022-02-16 Faulk South Dakota 46049 546 16
2218969 2218969 2022-02-15 Faulk South Dakota 46049 545 16
2215718 2215718 2022-02-14 Faulk South Dakota 46049 541 16
2212467 2212467 2022-02-13 Faulk South Dakota 46049 540 16
2209214 2209214 2022-02-12 Faulk South Dakota 46049 540 16
2205961 2205961 2022-02-11 Faulk South Dakota 46049 540 16
2202708 2202708 2022-02-10 Faulk South Dakota 46049 539 16
2199454 2199454 2022-02-09 Faulk South Dakota 46049 537 16
2196200 2196200 2022-02-08 Faulk South Dakota 46049 532 16
2192946 2192946 2022-02-07 Faulk South Dakota 46049 532 16
2189692 2189692 2022-02-06 Faulk South Dakota 46049 530 16
2186439 2186439 2022-02-05 Faulk South Dakota 46049 530 16
2183187 2183187 2022-02-04 Faulk South Dakota 46049 530 16
2179935 2179935 2022-02-03 Faulk South Dakota 46049 527 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);