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

772 rows where county = "Lake" 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 · 772 ✖

fips 1

county 1

  • Lake · 772 ✖
Link rowid date ▲ county state fips cases deaths
2502083 2502083 2022-05-13 Lake South Dakota 46079 2335 28
2498825 2498825 2022-05-12 Lake South Dakota 46079 2335 28
2495567 2495567 2022-05-11 Lake South Dakota 46079 2335 28
2492309 2492309 2022-05-10 Lake South Dakota 46079 2333 28
2489051 2489051 2022-05-09 Lake South Dakota 46079 2333 28
2485794 2485794 2022-05-08 Lake South Dakota 46079 2333 28
2482536 2482536 2022-05-07 Lake South Dakota 46079 2333 28
2479278 2479278 2022-05-06 Lake South Dakota 46079 2333 28
2476020 2476020 2022-05-05 Lake South Dakota 46079 2333 28
2472763 2472763 2022-05-04 Lake South Dakota 46079 2333 28
2469507 2469507 2022-05-03 Lake South Dakota 46079 2331 28
2466251 2466251 2022-05-02 Lake South Dakota 46079 2331 28
2462996 2462996 2022-05-01 Lake South Dakota 46079 2331 28
2459740 2459740 2022-04-30 Lake South Dakota 46079 2331 28
2456484 2456484 2022-04-29 Lake South Dakota 46079 2331 28
2453228 2453228 2022-04-28 Lake South Dakota 46079 2331 28
2449972 2449972 2022-04-27 Lake South Dakota 46079 2331 28
2446715 2446715 2022-04-26 Lake South Dakota 46079 2329 28
2443460 2443460 2022-04-25 Lake South Dakota 46079 2329 28
2440204 2440204 2022-04-24 Lake South Dakota 46079 2329 28
2436948 2436948 2022-04-23 Lake South Dakota 46079 2329 28
2433692 2433692 2022-04-22 Lake South Dakota 46079 2329 28
2430436 2430436 2022-04-21 Lake South Dakota 46079 2329 28
2427180 2427180 2022-04-20 Lake South Dakota 46079 2329 28
2423924 2423924 2022-04-19 Lake South Dakota 46079 2327 28
2420668 2420668 2022-04-18 Lake South Dakota 46079 2327 28
2417412 2417412 2022-04-17 Lake South Dakota 46079 2327 28
2414156 2414156 2022-04-16 Lake South Dakota 46079 2327 28
2410900 2410900 2022-04-15 Lake South Dakota 46079 2327 28
2407644 2407644 2022-04-14 Lake South Dakota 46079 2327 28
2404388 2404388 2022-04-13 Lake South Dakota 46079 2327 28
2401133 2401133 2022-04-12 Lake South Dakota 46079 2326 28
2397878 2397878 2022-04-11 Lake South Dakota 46079 2326 28
2394623 2394623 2022-04-10 Lake South Dakota 46079 2326 28
2391367 2391367 2022-04-09 Lake South Dakota 46079 2326 28
2388111 2388111 2022-04-08 Lake South Dakota 46079 2326 28
2384856 2384856 2022-04-07 Lake South Dakota 46079 2326 28
2381601 2381601 2022-04-06 Lake South Dakota 46079 2326 28
2378346 2378346 2022-04-05 Lake South Dakota 46079 2326 28
2375092 2375092 2022-04-04 Lake South Dakota 46079 2326 28
2371840 2371840 2022-04-03 Lake South Dakota 46079 2326 28
2368587 2368587 2022-04-02 Lake South Dakota 46079 2326 28
2365334 2365334 2022-04-01 Lake South Dakota 46079 2326 28
2362081 2362081 2022-03-31 Lake South Dakota 46079 2326 28
2358827 2358827 2022-03-30 Lake South Dakota 46079 2326 28
2355573 2355573 2022-03-29 Lake South Dakota 46079 2326 28
2352320 2352320 2022-03-28 Lake South Dakota 46079 2326 28
2349068 2349068 2022-03-27 Lake South Dakota 46079 2326 28
2345815 2345815 2022-03-26 Lake South Dakota 46079 2326 28
2342562 2342562 2022-03-25 Lake South Dakota 46079 2326 28
2339309 2339309 2022-03-24 Lake South Dakota 46079 2326 28
2336055 2336055 2022-03-23 Lake South Dakota 46079 2326 28
2332801 2332801 2022-03-22 Lake South Dakota 46079 2324 28
2329548 2329548 2022-03-21 Lake South Dakota 46079 2324 28
2326296 2326296 2022-03-20 Lake South Dakota 46079 2324 28
2323043 2323043 2022-03-19 Lake South Dakota 46079 2324 28
2319789 2319789 2022-03-18 Lake South Dakota 46079 2324 28
2316535 2316535 2022-03-17 Lake South Dakota 46079 2324 28
2313282 2313282 2022-03-16 Lake South Dakota 46079 2324 28
2310029 2310029 2022-03-15 Lake South Dakota 46079 2324 28
2306776 2306776 2022-03-14 Lake South Dakota 46079 2323 28
2303525 2303525 2022-03-13 Lake South Dakota 46079 2322 27
2300273 2300273 2022-03-12 Lake South Dakota 46079 2322 27
2297021 2297021 2022-03-11 Lake South Dakota 46079 2322 27
2293769 2293769 2022-03-10 Lake South Dakota 46079 2321 27
2290517 2290517 2022-03-09 Lake South Dakota 46079 2320 27
2287265 2287265 2022-03-08 Lake South Dakota 46079 2317 27
2284013 2284013 2022-03-07 Lake South Dakota 46079 2317 27
2280761 2280761 2022-03-06 Lake South Dakota 46079 2316 27
2277508 2277508 2022-03-05 Lake South Dakota 46079 2316 27
2274255 2274255 2022-03-04 Lake South Dakota 46079 2316 27
2271002 2271002 2022-03-03 Lake South Dakota 46079 2316 27
2267750 2267750 2022-03-02 Lake South Dakota 46079 2315 27
2264497 2264497 2022-03-01 Lake South Dakota 46079 2314 27
2261247 2261247 2022-02-28 Lake South Dakota 46079 2312 27
2257996 2257996 2022-02-27 Lake South Dakota 46079 2312 27
2254745 2254745 2022-02-26 Lake South Dakota 46079 2312 27
2251494 2251494 2022-02-25 Lake South Dakota 46079 2312 27
2248243 2248243 2022-02-24 Lake South Dakota 46079 2313 27
2244992 2244992 2022-02-23 Lake South Dakota 46079 2310 27
2241741 2241741 2022-02-22 Lake South Dakota 46079 2311 27
2238490 2238490 2022-02-21 Lake South Dakota 46079 2308 27
2235239 2235239 2022-02-20 Lake South Dakota 46079 2308 27
2231988 2231988 2022-02-19 Lake South Dakota 46079 2308 27
2228737 2228737 2022-02-18 Lake South Dakota 46079 2308 27
2225486 2225486 2022-02-17 Lake South Dakota 46079 2307 27
2222235 2222235 2022-02-16 Lake South Dakota 46079 2307 27
2218984 2218984 2022-02-15 Lake South Dakota 46079 2305 27
2215733 2215733 2022-02-14 Lake South Dakota 46079 2305 27
2212482 2212482 2022-02-13 Lake South Dakota 46079 2303 27
2209229 2209229 2022-02-12 Lake South Dakota 46079 2303 27
2205976 2205976 2022-02-11 Lake South Dakota 46079 2303 27
2202723 2202723 2022-02-10 Lake South Dakota 46079 2303 27
2199469 2199469 2022-02-09 Lake South Dakota 46079 2300 26
2196215 2196215 2022-02-08 Lake South Dakota 46079 2294 26
2192961 2192961 2022-02-07 Lake South Dakota 46079 2290 26
2189707 2189707 2022-02-06 Lake South Dakota 46079 2287 26
2186454 2186454 2022-02-05 Lake South Dakota 46079 2287 26
2183202 2183202 2022-02-04 Lake South Dakota 46079 2287 26
2179950 2179950 2022-02-03 Lake South Dakota 46079 2281 26

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