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

780 rows where county = "Lincoln" and state = "South Dakota" sorted by date descending

✎ View and edit SQL

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

state 1

  • South Dakota · 780 ✖

fips 1

county 1

  • Lincoln · 780 ✖
Link rowid date ▲ county state fips cases deaths
2502085 2502085 2022-05-13 Lincoln South Dakota 46083 15590 102
2498827 2498827 2022-05-12 Lincoln South Dakota 46083 15590 102
2495569 2495569 2022-05-11 Lincoln South Dakota 46083 15590 102
2492311 2492311 2022-05-10 Lincoln South Dakota 46083 15559 102
2489053 2489053 2022-05-09 Lincoln South Dakota 46083 15559 102
2485796 2485796 2022-05-08 Lincoln South Dakota 46083 15559 102
2482538 2482538 2022-05-07 Lincoln South Dakota 46083 15559 102
2479280 2479280 2022-05-06 Lincoln South Dakota 46083 15559 102
2476022 2476022 2022-05-05 Lincoln South Dakota 46083 15559 102
2472765 2472765 2022-05-04 Lincoln South Dakota 46083 15559 102
2469509 2469509 2022-05-03 Lincoln South Dakota 46083 15529 102
2466253 2466253 2022-05-02 Lincoln South Dakota 46083 15529 102
2462998 2462998 2022-05-01 Lincoln South Dakota 46083 15529 102
2459742 2459742 2022-04-30 Lincoln South Dakota 46083 15529 102
2456486 2456486 2022-04-29 Lincoln South Dakota 46083 15529 102
2453230 2453230 2022-04-28 Lincoln South Dakota 46083 15529 102
2449974 2449974 2022-04-27 Lincoln South Dakota 46083 15529 102
2446717 2446717 2022-04-26 Lincoln South Dakota 46083 15507 102
2443462 2443462 2022-04-25 Lincoln South Dakota 46083 15507 102
2440206 2440206 2022-04-24 Lincoln South Dakota 46083 15507 102
2436950 2436950 2022-04-23 Lincoln South Dakota 46083 15507 102
2433694 2433694 2022-04-22 Lincoln South Dakota 46083 15507 102
2430438 2430438 2022-04-21 Lincoln South Dakota 46083 15507 102
2427182 2427182 2022-04-20 Lincoln South Dakota 46083 15507 102
2423926 2423926 2022-04-19 Lincoln South Dakota 46083 15494 102
2420670 2420670 2022-04-18 Lincoln South Dakota 46083 15494 102
2417414 2417414 2022-04-17 Lincoln South Dakota 46083 15494 102
2414158 2414158 2022-04-16 Lincoln South Dakota 46083 15494 102
2410902 2410902 2022-04-15 Lincoln South Dakota 46083 15494 102
2407646 2407646 2022-04-14 Lincoln South Dakota 46083 15494 102
2404390 2404390 2022-04-13 Lincoln South Dakota 46083 15494 102
2401135 2401135 2022-04-12 Lincoln South Dakota 46083 15484 102
2397880 2397880 2022-04-11 Lincoln South Dakota 46083 15484 102
2394625 2394625 2022-04-10 Lincoln South Dakota 46083 15484 102
2391369 2391369 2022-04-09 Lincoln South Dakota 46083 15484 102
2388113 2388113 2022-04-08 Lincoln South Dakota 46083 15484 102
2384858 2384858 2022-04-07 Lincoln South Dakota 46083 15484 102
2381603 2381603 2022-04-06 Lincoln South Dakota 46083 15484 102
2378348 2378348 2022-04-05 Lincoln South Dakota 46083 15477 102
2375094 2375094 2022-04-04 Lincoln South Dakota 46083 15477 102
2371842 2371842 2022-04-03 Lincoln South Dakota 46083 15477 102
2368589 2368589 2022-04-02 Lincoln South Dakota 46083 15477 102
2365336 2365336 2022-04-01 Lincoln South Dakota 46083 15477 102
2362083 2362083 2022-03-31 Lincoln South Dakota 46083 15477 102
2358829 2358829 2022-03-30 Lincoln South Dakota 46083 15477 102
2355575 2355575 2022-03-29 Lincoln South Dakota 46083 15472 101
2352322 2352322 2022-03-28 Lincoln South Dakota 46083 15472 101
2349070 2349070 2022-03-27 Lincoln South Dakota 46083 15472 101
2345817 2345817 2022-03-26 Lincoln South Dakota 46083 15472 101
2342564 2342564 2022-03-25 Lincoln South Dakota 46083 15472 101
2339311 2339311 2022-03-24 Lincoln South Dakota 46083 15472 101
2336057 2336057 2022-03-23 Lincoln South Dakota 46083 15472 101
2332803 2332803 2022-03-22 Lincoln South Dakota 46083 15467 101
2329550 2329550 2022-03-21 Lincoln South Dakota 46083 15467 101
2326298 2326298 2022-03-20 Lincoln South Dakota 46083 15467 101
2323045 2323045 2022-03-19 Lincoln South Dakota 46083 15467 101
2319791 2319791 2022-03-18 Lincoln South Dakota 46083 15467 101
2316537 2316537 2022-03-17 Lincoln South Dakota 46083 15465 101
2313284 2313284 2022-03-16 Lincoln South Dakota 46083 15465 101
2310031 2310031 2022-03-15 Lincoln South Dakota 46083 15466 101
2306778 2306778 2022-03-14 Lincoln South Dakota 46083 15465 101
2303527 2303527 2022-03-13 Lincoln South Dakota 46083 15463 100
2300275 2300275 2022-03-12 Lincoln South Dakota 46083 15463 100
2297023 2297023 2022-03-11 Lincoln South Dakota 46083 15463 100
2293771 2293771 2022-03-10 Lincoln South Dakota 46083 15464 100
2290519 2290519 2022-03-09 Lincoln South Dakota 46083 15462 100
2287267 2287267 2022-03-08 Lincoln South Dakota 46083 15458 100
2284015 2284015 2022-03-07 Lincoln South Dakota 46083 15453 98
2280763 2280763 2022-03-06 Lincoln South Dakota 46083 15450 98
2277510 2277510 2022-03-05 Lincoln South Dakota 46083 15450 98
2274257 2274257 2022-03-04 Lincoln South Dakota 46083 15450 98
2271004 2271004 2022-03-03 Lincoln South Dakota 46083 15449 98
2267752 2267752 2022-03-02 Lincoln South Dakota 46083 15443 98
2264499 2264499 2022-03-01 Lincoln South Dakota 46083 15438 98
2261249 2261249 2022-02-28 Lincoln South Dakota 46083 15430 98
2257998 2257998 2022-02-27 Lincoln South Dakota 46083 15430 98
2254747 2254747 2022-02-26 Lincoln South Dakota 46083 15430 98
2251496 2251496 2022-02-25 Lincoln South Dakota 46083 15430 98
2248245 2248245 2022-02-24 Lincoln South Dakota 46083 15426 98
2244994 2244994 2022-02-23 Lincoln South Dakota 46083 15419 97
2241743 2241743 2022-02-22 Lincoln South Dakota 46083 15395 97
2238492 2238492 2022-02-21 Lincoln South Dakota 46083 15392 97
2235241 2235241 2022-02-20 Lincoln South Dakota 46083 15392 97
2231990 2231990 2022-02-19 Lincoln South Dakota 46083 15392 97
2228739 2228739 2022-02-18 Lincoln South Dakota 46083 15392 97
2225488 2225488 2022-02-17 Lincoln South Dakota 46083 15382 97
2222237 2222237 2022-02-16 Lincoln South Dakota 46083 15372 96
2218986 2218986 2022-02-15 Lincoln South Dakota 46083 15371 94
2215735 2215735 2022-02-14 Lincoln South Dakota 46083 15355 94
2212484 2212484 2022-02-13 Lincoln South Dakota 46083 15346 92
2209231 2209231 2022-02-12 Lincoln South Dakota 46083 15346 92
2205978 2205978 2022-02-11 Lincoln South Dakota 46083 15346 92
2202725 2202725 2022-02-10 Lincoln South Dakota 46083 15336 92
2199471 2199471 2022-02-09 Lincoln South Dakota 46083 15329 91
2196217 2196217 2022-02-08 Lincoln South Dakota 46083 15301 91
2192963 2192963 2022-02-07 Lincoln South Dakota 46083 15271 91
2189709 2189709 2022-02-06 Lincoln South Dakota 46083 15260 91
2186456 2186456 2022-02-05 Lincoln South Dakota 46083 15260 91
2183204 2183204 2022-02-04 Lincoln South Dakota 46083 15260 91
2179952 2179952 2022-02-03 Lincoln South Dakota 46083 15240 91

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