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 = "Lawrence" 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 · 778 ✖

fips 1

county 1

  • Lawrence · 778 ✖
Link rowid date ▲ county state fips cases deaths
2502084 2502084 2022-05-13 Lawrence South Dakota 46081 6605 83
2498826 2498826 2022-05-12 Lawrence South Dakota 46081 6605 83
2495568 2495568 2022-05-11 Lawrence South Dakota 46081 6605 83
2492310 2492310 2022-05-10 Lawrence South Dakota 46081 6589 83
2489052 2489052 2022-05-09 Lawrence South Dakota 46081 6589 83
2485795 2485795 2022-05-08 Lawrence South Dakota 46081 6589 83
2482537 2482537 2022-05-07 Lawrence South Dakota 46081 6589 83
2479279 2479279 2022-05-06 Lawrence South Dakota 46081 6589 83
2476021 2476021 2022-05-05 Lawrence South Dakota 46081 6589 83
2472764 2472764 2022-05-04 Lawrence South Dakota 46081 6589 83
2469508 2469508 2022-05-03 Lawrence South Dakota 46081 6579 83
2466252 2466252 2022-05-02 Lawrence South Dakota 46081 6579 83
2462997 2462997 2022-05-01 Lawrence South Dakota 46081 6579 83
2459741 2459741 2022-04-30 Lawrence South Dakota 46081 6579 83
2456485 2456485 2022-04-29 Lawrence South Dakota 46081 6579 83
2453229 2453229 2022-04-28 Lawrence South Dakota 46081 6579 83
2449973 2449973 2022-04-27 Lawrence South Dakota 46081 6579 83
2446716 2446716 2022-04-26 Lawrence South Dakota 46081 6575 83
2443461 2443461 2022-04-25 Lawrence South Dakota 46081 6575 83
2440205 2440205 2022-04-24 Lawrence South Dakota 46081 6575 83
2436949 2436949 2022-04-23 Lawrence South Dakota 46081 6575 83
2433693 2433693 2022-04-22 Lawrence South Dakota 46081 6575 83
2430437 2430437 2022-04-21 Lawrence South Dakota 46081 6575 83
2427181 2427181 2022-04-20 Lawrence South Dakota 46081 6575 83
2423925 2423925 2022-04-19 Lawrence South Dakota 46081 6570 83
2420669 2420669 2022-04-18 Lawrence South Dakota 46081 6570 83
2417413 2417413 2022-04-17 Lawrence South Dakota 46081 6570 83
2414157 2414157 2022-04-16 Lawrence South Dakota 46081 6570 83
2410901 2410901 2022-04-15 Lawrence South Dakota 46081 6570 83
2407645 2407645 2022-04-14 Lawrence South Dakota 46081 6570 83
2404389 2404389 2022-04-13 Lawrence South Dakota 46081 6570 83
2401134 2401134 2022-04-12 Lawrence South Dakota 46081 6565 83
2397879 2397879 2022-04-11 Lawrence South Dakota 46081 6565 83
2394624 2394624 2022-04-10 Lawrence South Dakota 46081 6565 83
2391368 2391368 2022-04-09 Lawrence South Dakota 46081 6565 83
2388112 2388112 2022-04-08 Lawrence South Dakota 46081 6565 83
2384857 2384857 2022-04-07 Lawrence South Dakota 46081 6565 83
2381602 2381602 2022-04-06 Lawrence South Dakota 46081 6565 83
2378347 2378347 2022-04-05 Lawrence South Dakota 46081 6560 82
2375093 2375093 2022-04-04 Lawrence South Dakota 46081 6560 82
2371841 2371841 2022-04-03 Lawrence South Dakota 46081 6560 82
2368588 2368588 2022-04-02 Lawrence South Dakota 46081 6560 82
2365335 2365335 2022-04-01 Lawrence South Dakota 46081 6560 82
2362082 2362082 2022-03-31 Lawrence South Dakota 46081 6560 82
2358828 2358828 2022-03-30 Lawrence South Dakota 46081 6560 82
2355574 2355574 2022-03-29 Lawrence South Dakota 46081 6555 82
2352321 2352321 2022-03-28 Lawrence South Dakota 46081 6555 82
2349069 2349069 2022-03-27 Lawrence South Dakota 46081 6555 82
2345816 2345816 2022-03-26 Lawrence South Dakota 46081 6555 82
2342563 2342563 2022-03-25 Lawrence South Dakota 46081 6555 82
2339310 2339310 2022-03-24 Lawrence South Dakota 46081 6555 82
2336056 2336056 2022-03-23 Lawrence South Dakota 46081 6555 82
2332802 2332802 2022-03-22 Lawrence South Dakota 46081 6554 82
2329549 2329549 2022-03-21 Lawrence South Dakota 46081 6554 82
2326297 2326297 2022-03-20 Lawrence South Dakota 46081 6554 82
2323044 2323044 2022-03-19 Lawrence South Dakota 46081 6554 82
2319790 2319790 2022-03-18 Lawrence South Dakota 46081 6554 82
2316536 2316536 2022-03-17 Lawrence South Dakota 46081 6553 82
2313283 2313283 2022-03-16 Lawrence South Dakota 46081 6551 82
2310030 2310030 2022-03-15 Lawrence South Dakota 46081 6551 82
2306777 2306777 2022-03-14 Lawrence South Dakota 46081 6550 82
2303526 2303526 2022-03-13 Lawrence South Dakota 46081 6551 82
2300274 2300274 2022-03-12 Lawrence South Dakota 46081 6551 82
2297022 2297022 2022-03-11 Lawrence South Dakota 46081 6551 82
2293770 2293770 2022-03-10 Lawrence South Dakota 46081 6548 82
2290518 2290518 2022-03-09 Lawrence South Dakota 46081 6548 82
2287266 2287266 2022-03-08 Lawrence South Dakota 46081 6544 82
2284014 2284014 2022-03-07 Lawrence South Dakota 46081 6544 82
2280762 2280762 2022-03-06 Lawrence South Dakota 46081 6542 82
2277509 2277509 2022-03-05 Lawrence South Dakota 46081 6542 82
2274256 2274256 2022-03-04 Lawrence South Dakota 46081 6542 82
2271003 2271003 2022-03-03 Lawrence South Dakota 46081 6538 82
2267751 2267751 2022-03-02 Lawrence South Dakota 46081 6540 82
2264498 2264498 2022-03-01 Lawrence South Dakota 46081 6540 82
2261248 2261248 2022-02-28 Lawrence South Dakota 46081 6536 82
2257997 2257997 2022-02-27 Lawrence South Dakota 46081 6538 82
2254746 2254746 2022-02-26 Lawrence South Dakota 46081 6538 82
2251495 2251495 2022-02-25 Lawrence South Dakota 46081 6538 82
2248244 2248244 2022-02-24 Lawrence South Dakota 46081 6533 82
2244993 2244993 2022-02-23 Lawrence South Dakota 46081 6524 82
2241742 2241742 2022-02-22 Lawrence South Dakota 46081 6515 82
2238491 2238491 2022-02-21 Lawrence South Dakota 46081 6511 82
2235240 2235240 2022-02-20 Lawrence South Dakota 46081 6511 82
2231989 2231989 2022-02-19 Lawrence South Dakota 46081 6511 82
2228738 2228738 2022-02-18 Lawrence South Dakota 46081 6511 82
2225487 2225487 2022-02-17 Lawrence South Dakota 46081 6503 81
2222236 2222236 2022-02-16 Lawrence South Dakota 46081 6494 81
2218985 2218985 2022-02-15 Lawrence South Dakota 46081 6481 80
2215734 2215734 2022-02-14 Lawrence South Dakota 46081 6441 80
2212483 2212483 2022-02-13 Lawrence South Dakota 46081 6428 80
2209230 2209230 2022-02-12 Lawrence South Dakota 46081 6428 80
2205977 2205977 2022-02-11 Lawrence South Dakota 46081 6428 80
2202724 2202724 2022-02-10 Lawrence South Dakota 46081 6417 80
2199470 2199470 2022-02-09 Lawrence South Dakota 46081 6403 79
2196216 2196216 2022-02-08 Lawrence South Dakota 46081 6382 79
2192962 2192962 2022-02-07 Lawrence South Dakota 46081 6358 79
2189708 2189708 2022-02-06 Lawrence South Dakota 46081 6338 79
2186455 2186455 2022-02-05 Lawrence South Dakota 46081 6338 79
2183203 2183203 2022-02-04 Lawrence South Dakota 46081 6338 79
2179951 2179951 2022-02-03 Lawrence South Dakota 46081 6317 79

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