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

680 rows where county = "Campbell" 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 · 680 ✖

fips 1

county 1

  • Campbell · 680 ✖
Link rowid date ▲ county state fips cases deaths
2502054 2502054 2022-05-13 Campbell South Dakota 46021 268 7
2498796 2498796 2022-05-12 Campbell South Dakota 46021 268 7
2495538 2495538 2022-05-11 Campbell South Dakota 46021 268 7
2492280 2492280 2022-05-10 Campbell South Dakota 46021 268 7
2489022 2489022 2022-05-09 Campbell South Dakota 46021 268 7
2485765 2485765 2022-05-08 Campbell South Dakota 46021 268 7
2482507 2482507 2022-05-07 Campbell South Dakota 46021 268 7
2479249 2479249 2022-05-06 Campbell South Dakota 46021 268 7
2475991 2475991 2022-05-05 Campbell South Dakota 46021 268 7
2472734 2472734 2022-05-04 Campbell South Dakota 46021 268 7
2469478 2469478 2022-05-03 Campbell South Dakota 46021 268 7
2466222 2466222 2022-05-02 Campbell South Dakota 46021 268 7
2462967 2462967 2022-05-01 Campbell South Dakota 46021 268 7
2459711 2459711 2022-04-30 Campbell South Dakota 46021 268 7
2456455 2456455 2022-04-29 Campbell South Dakota 46021 268 7
2453199 2453199 2022-04-28 Campbell South Dakota 46021 268 7
2449943 2449943 2022-04-27 Campbell South Dakota 46021 268 7
2446686 2446686 2022-04-26 Campbell South Dakota 46021 267 7
2443431 2443431 2022-04-25 Campbell South Dakota 46021 267 7
2440175 2440175 2022-04-24 Campbell South Dakota 46021 267 7
2436919 2436919 2022-04-23 Campbell South Dakota 46021 267 7
2433663 2433663 2022-04-22 Campbell South Dakota 46021 267 7
2430407 2430407 2022-04-21 Campbell South Dakota 46021 267 7
2427151 2427151 2022-04-20 Campbell South Dakota 46021 267 7
2423895 2423895 2022-04-19 Campbell South Dakota 46021 267 7
2420639 2420639 2022-04-18 Campbell South Dakota 46021 267 7
2417383 2417383 2022-04-17 Campbell South Dakota 46021 267 7
2414127 2414127 2022-04-16 Campbell South Dakota 46021 267 7
2410871 2410871 2022-04-15 Campbell South Dakota 46021 267 7
2407615 2407615 2022-04-14 Campbell South Dakota 46021 267 7
2404359 2404359 2022-04-13 Campbell South Dakota 46021 267 7
2401104 2401104 2022-04-12 Campbell South Dakota 46021 266 7
2397849 2397849 2022-04-11 Campbell South Dakota 46021 266 7
2394594 2394594 2022-04-10 Campbell South Dakota 46021 266 7
2391338 2391338 2022-04-09 Campbell South Dakota 46021 266 7
2388082 2388082 2022-04-08 Campbell South Dakota 46021 266 7
2384827 2384827 2022-04-07 Campbell South Dakota 46021 266 7
2381572 2381572 2022-04-06 Campbell South Dakota 46021 266 7
2378317 2378317 2022-04-05 Campbell South Dakota 46021 266 7
2375063 2375063 2022-04-04 Campbell South Dakota 46021 266 7
2371811 2371811 2022-04-03 Campbell South Dakota 46021 266 7
2368558 2368558 2022-04-02 Campbell South Dakota 46021 266 7
2365305 2365305 2022-04-01 Campbell South Dakota 46021 266 7
2362052 2362052 2022-03-31 Campbell South Dakota 46021 266 7
2358798 2358798 2022-03-30 Campbell South Dakota 46021 266 7
2355544 2355544 2022-03-29 Campbell South Dakota 46021 266 7
2352291 2352291 2022-03-28 Campbell South Dakota 46021 266 7
2349039 2349039 2022-03-27 Campbell South Dakota 46021 266 7
2345786 2345786 2022-03-26 Campbell South Dakota 46021 266 7
2342533 2342533 2022-03-25 Campbell South Dakota 46021 266 7
2339280 2339280 2022-03-24 Campbell South Dakota 46021 266 7
2336026 2336026 2022-03-23 Campbell South Dakota 46021 266 7
2332772 2332772 2022-03-22 Campbell South Dakota 46021 266 7
2329519 2329519 2022-03-21 Campbell South Dakota 46021 266 7
2326267 2326267 2022-03-20 Campbell South Dakota 46021 266 7
2323014 2323014 2022-03-19 Campbell South Dakota 46021 266 7
2319760 2319760 2022-03-18 Campbell South Dakota 46021 266 7
2316506 2316506 2022-03-17 Campbell South Dakota 46021 265 7
2313253 2313253 2022-03-16 Campbell South Dakota 46021 265 7
2310000 2310000 2022-03-15 Campbell South Dakota 46021 265 7
2306747 2306747 2022-03-14 Campbell South Dakota 46021 265 7
2303496 2303496 2022-03-13 Campbell South Dakota 46021 265 7
2300244 2300244 2022-03-12 Campbell South Dakota 46021 265 7
2296992 2296992 2022-03-11 Campbell South Dakota 46021 265 7
2293740 2293740 2022-03-10 Campbell South Dakota 46021 265 7
2290488 2290488 2022-03-09 Campbell South Dakota 46021 265 7
2287236 2287236 2022-03-08 Campbell South Dakota 46021 265 7
2283984 2283984 2022-03-07 Campbell South Dakota 46021 265 7
2280732 2280732 2022-03-06 Campbell South Dakota 46021 265 7
2277479 2277479 2022-03-05 Campbell South Dakota 46021 265 7
2274226 2274226 2022-03-04 Campbell South Dakota 46021 265 7
2270973 2270973 2022-03-03 Campbell South Dakota 46021 265 7
2267721 2267721 2022-03-02 Campbell South Dakota 46021 265 7
2264468 2264468 2022-03-01 Campbell South Dakota 46021 264 7
2261218 2261218 2022-02-28 Campbell South Dakota 46021 264 7
2257967 2257967 2022-02-27 Campbell South Dakota 46021 263 7
2254716 2254716 2022-02-26 Campbell South Dakota 46021 263 7
2251465 2251465 2022-02-25 Campbell South Dakota 46021 263 7
2248214 2248214 2022-02-24 Campbell South Dakota 46021 263 7
2244963 2244963 2022-02-23 Campbell South Dakota 46021 262 7
2241712 2241712 2022-02-22 Campbell South Dakota 46021 262 7
2238461 2238461 2022-02-21 Campbell South Dakota 46021 262 7
2235210 2235210 2022-02-20 Campbell South Dakota 46021 262 7
2231959 2231959 2022-02-19 Campbell South Dakota 46021 262 7
2228708 2228708 2022-02-18 Campbell South Dakota 46021 262 7
2225457 2225457 2022-02-17 Campbell South Dakota 46021 262 7
2222206 2222206 2022-02-16 Campbell South Dakota 46021 260 7
2218955 2218955 2022-02-15 Campbell South Dakota 46021 260 7
2215704 2215704 2022-02-14 Campbell South Dakota 46021 257 7
2212453 2212453 2022-02-13 Campbell South Dakota 46021 257 7
2209200 2209200 2022-02-12 Campbell South Dakota 46021 257 7
2205947 2205947 2022-02-11 Campbell South Dakota 46021 257 7
2202694 2202694 2022-02-10 Campbell South Dakota 46021 257 7
2199440 2199440 2022-02-09 Campbell South Dakota 46021 256 7
2196186 2196186 2022-02-08 Campbell South Dakota 46021 256 7
2192932 2192932 2022-02-07 Campbell South Dakota 46021 256 7
2189678 2189678 2022-02-06 Campbell South Dakota 46021 257 7
2186425 2186425 2022-02-05 Campbell South Dakota 46021 257 7
2183173 2183173 2022-02-04 Campbell South Dakota 46021 257 7
2179921 2179921 2022-02-03 Campbell South Dakota 46021 257 7

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