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

782 rows where county = "Codington" 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 · 782 ✖

fips 1

county 1

  • Codington · 782 ✖
Link rowid date ▲ county state fips cases deaths
2502058 2502058 2022-05-13 Codington South Dakota 46029 8474 101
2498800 2498800 2022-05-12 Codington South Dakota 46029 8474 101
2495542 2495542 2022-05-11 Codington South Dakota 46029 8474 101
2492284 2492284 2022-05-10 Codington South Dakota 46029 8438 101
2489026 2489026 2022-05-09 Codington South Dakota 46029 8438 101
2485769 2485769 2022-05-08 Codington South Dakota 46029 8438 101
2482511 2482511 2022-05-07 Codington South Dakota 46029 8438 101
2479253 2479253 2022-05-06 Codington South Dakota 46029 8438 101
2475995 2475995 2022-05-05 Codington South Dakota 46029 8438 101
2472738 2472738 2022-05-04 Codington South Dakota 46029 8438 101
2469482 2469482 2022-05-03 Codington South Dakota 46029 8423 101
2466226 2466226 2022-05-02 Codington South Dakota 46029 8423 101
2462971 2462971 2022-05-01 Codington South Dakota 46029 8423 101
2459715 2459715 2022-04-30 Codington South Dakota 46029 8423 101
2456459 2456459 2022-04-29 Codington South Dakota 46029 8423 101
2453203 2453203 2022-04-28 Codington South Dakota 46029 8423 101
2449947 2449947 2022-04-27 Codington South Dakota 46029 8423 101
2446690 2446690 2022-04-26 Codington South Dakota 46029 8413 99
2443435 2443435 2022-04-25 Codington South Dakota 46029 8413 99
2440179 2440179 2022-04-24 Codington South Dakota 46029 8413 99
2436923 2436923 2022-04-23 Codington South Dakota 46029 8413 99
2433667 2433667 2022-04-22 Codington South Dakota 46029 8413 99
2430411 2430411 2022-04-21 Codington South Dakota 46029 8413 99
2427155 2427155 2022-04-20 Codington South Dakota 46029 8413 99
2423899 2423899 2022-04-19 Codington South Dakota 46029 8411 99
2420643 2420643 2022-04-18 Codington South Dakota 46029 8411 99
2417387 2417387 2022-04-17 Codington South Dakota 46029 8411 99
2414131 2414131 2022-04-16 Codington South Dakota 46029 8411 99
2410875 2410875 2022-04-15 Codington South Dakota 46029 8411 99
2407619 2407619 2022-04-14 Codington South Dakota 46029 8411 99
2404363 2404363 2022-04-13 Codington South Dakota 46029 8411 99
2401108 2401108 2022-04-12 Codington South Dakota 46029 8408 99
2397853 2397853 2022-04-11 Codington South Dakota 46029 8408 99
2394598 2394598 2022-04-10 Codington South Dakota 46029 8408 99
2391342 2391342 2022-04-09 Codington South Dakota 46029 8408 99
2388086 2388086 2022-04-08 Codington South Dakota 46029 8408 99
2384831 2384831 2022-04-07 Codington South Dakota 46029 8408 99
2381576 2381576 2022-04-06 Codington South Dakota 46029 8408 99
2378321 2378321 2022-04-05 Codington South Dakota 46029 8403 99
2375067 2375067 2022-04-04 Codington South Dakota 46029 8403 99
2371815 2371815 2022-04-03 Codington South Dakota 46029 8403 99
2368562 2368562 2022-04-02 Codington South Dakota 46029 8403 99
2365309 2365309 2022-04-01 Codington South Dakota 46029 8403 99
2362056 2362056 2022-03-31 Codington South Dakota 46029 8403 99
2358802 2358802 2022-03-30 Codington South Dakota 46029 8403 99
2355548 2355548 2022-03-29 Codington South Dakota 46029 8400 99
2352295 2352295 2022-03-28 Codington South Dakota 46029 8400 99
2349043 2349043 2022-03-27 Codington South Dakota 46029 8400 99
2345790 2345790 2022-03-26 Codington South Dakota 46029 8400 99
2342537 2342537 2022-03-25 Codington South Dakota 46029 8400 99
2339284 2339284 2022-03-24 Codington South Dakota 46029 8400 99
2336030 2336030 2022-03-23 Codington South Dakota 46029 8400 99
2332776 2332776 2022-03-22 Codington South Dakota 46029 8389 99
2329523 2329523 2022-03-21 Codington South Dakota 46029 8389 99
2326271 2326271 2022-03-20 Codington South Dakota 46029 8389 99
2323018 2323018 2022-03-19 Codington South Dakota 46029 8389 99
2319764 2319764 2022-03-18 Codington South Dakota 46029 8389 99
2316510 2316510 2022-03-17 Codington South Dakota 46029 8388 99
2313257 2313257 2022-03-16 Codington South Dakota 46029 8385 99
2310004 2310004 2022-03-15 Codington South Dakota 46029 8385 99
2306751 2306751 2022-03-14 Codington South Dakota 46029 8378 99
2303500 2303500 2022-03-13 Codington South Dakota 46029 8377 99
2300248 2300248 2022-03-12 Codington South Dakota 46029 8377 99
2296996 2296996 2022-03-11 Codington South Dakota 46029 8377 99
2293744 2293744 2022-03-10 Codington South Dakota 46029 8375 99
2290492 2290492 2022-03-09 Codington South Dakota 46029 8375 99
2287240 2287240 2022-03-08 Codington South Dakota 46029 8375 99
2283988 2283988 2022-03-07 Codington South Dakota 46029 8368 99
2280736 2280736 2022-03-06 Codington South Dakota 46029 8363 98
2277483 2277483 2022-03-05 Codington South Dakota 46029 8363 98
2274230 2274230 2022-03-04 Codington South Dakota 46029 8363 98
2270977 2270977 2022-03-03 Codington South Dakota 46029 8355 98
2267725 2267725 2022-03-02 Codington South Dakota 46029 8347 98
2264472 2264472 2022-03-01 Codington South Dakota 46029 8344 98
2261222 2261222 2022-02-28 Codington South Dakota 46029 8333 97
2257971 2257971 2022-02-27 Codington South Dakota 46029 8331 97
2254720 2254720 2022-02-26 Codington South Dakota 46029 8331 97
2251469 2251469 2022-02-25 Codington South Dakota 46029 8331 97
2248218 2248218 2022-02-24 Codington South Dakota 46029 8324 97
2244967 2244967 2022-02-23 Codington South Dakota 46029 8320 97
2241716 2241716 2022-02-22 Codington South Dakota 46029 8307 97
2238465 2238465 2022-02-21 Codington South Dakota 46029 8303 96
2235214 2235214 2022-02-20 Codington South Dakota 46029 8303 96
2231963 2231963 2022-02-19 Codington South Dakota 46029 8303 96
2228712 2228712 2022-02-18 Codington South Dakota 46029 8303 96
2225461 2225461 2022-02-17 Codington South Dakota 46029 8296 96
2222210 2222210 2022-02-16 Codington South Dakota 46029 8288 95
2218959 2218959 2022-02-15 Codington South Dakota 46029 8273 95
2215708 2215708 2022-02-14 Codington South Dakota 46029 8249 95
2212457 2212457 2022-02-13 Codington South Dakota 46029 8239 95
2209204 2209204 2022-02-12 Codington South Dakota 46029 8239 95
2205951 2205951 2022-02-11 Codington South Dakota 46029 8239 95
2202698 2202698 2022-02-10 Codington South Dakota 46029 8224 95
2199444 2199444 2022-02-09 Codington South Dakota 46029 8212 95
2196190 2196190 2022-02-08 Codington South Dakota 46029 8181 95
2192936 2192936 2022-02-07 Codington South Dakota 46029 8171 94
2189682 2189682 2022-02-06 Codington South Dakota 46029 8141 94
2186429 2186429 2022-02-05 Codington South Dakota 46029 8141 94
2183177 2183177 2022-02-04 Codington South Dakota 46029 8141 94
2179925 2179925 2022-02-03 Codington South Dakota 46029 8124 94

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