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

777 rows where county = "Hamlin" 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 · 777 ✖

fips 1

county 1

  • Hamlin · 777 ✖
Link rowid date ▲ county state fips cases deaths
2502072 2502072 2022-05-13 Hamlin South Dakota 46057 1508 41
2498814 2498814 2022-05-12 Hamlin South Dakota 46057 1508 41
2495556 2495556 2022-05-11 Hamlin South Dakota 46057 1508 41
2492298 2492298 2022-05-10 Hamlin South Dakota 46057 1506 41
2489040 2489040 2022-05-09 Hamlin South Dakota 46057 1506 41
2485783 2485783 2022-05-08 Hamlin South Dakota 46057 1506 41
2482525 2482525 2022-05-07 Hamlin South Dakota 46057 1506 41
2479267 2479267 2022-05-06 Hamlin South Dakota 46057 1506 41
2476009 2476009 2022-05-05 Hamlin South Dakota 46057 1506 41
2472752 2472752 2022-05-04 Hamlin South Dakota 46057 1506 41
2469496 2469496 2022-05-03 Hamlin South Dakota 46057 1504 41
2466240 2466240 2022-05-02 Hamlin South Dakota 46057 1504 41
2462985 2462985 2022-05-01 Hamlin South Dakota 46057 1504 41
2459729 2459729 2022-04-30 Hamlin South Dakota 46057 1504 41
2456473 2456473 2022-04-29 Hamlin South Dakota 46057 1504 41
2453217 2453217 2022-04-28 Hamlin South Dakota 46057 1504 41
2449961 2449961 2022-04-27 Hamlin South Dakota 46057 1504 41
2446704 2446704 2022-04-26 Hamlin South Dakota 46057 1503 41
2443449 2443449 2022-04-25 Hamlin South Dakota 46057 1503 41
2440193 2440193 2022-04-24 Hamlin South Dakota 46057 1503 41
2436937 2436937 2022-04-23 Hamlin South Dakota 46057 1503 41
2433681 2433681 2022-04-22 Hamlin South Dakota 46057 1503 41
2430425 2430425 2022-04-21 Hamlin South Dakota 46057 1503 41
2427169 2427169 2022-04-20 Hamlin South Dakota 46057 1503 41
2423913 2423913 2022-04-19 Hamlin South Dakota 46057 1501 41
2420657 2420657 2022-04-18 Hamlin South Dakota 46057 1501 41
2417401 2417401 2022-04-17 Hamlin South Dakota 46057 1501 41
2414145 2414145 2022-04-16 Hamlin South Dakota 46057 1501 41
2410889 2410889 2022-04-15 Hamlin South Dakota 46057 1501 41
2407633 2407633 2022-04-14 Hamlin South Dakota 46057 1501 41
2404377 2404377 2022-04-13 Hamlin South Dakota 46057 1501 41
2401122 2401122 2022-04-12 Hamlin South Dakota 46057 1500 41
2397867 2397867 2022-04-11 Hamlin South Dakota 46057 1500 41
2394612 2394612 2022-04-10 Hamlin South Dakota 46057 1500 41
2391356 2391356 2022-04-09 Hamlin South Dakota 46057 1500 41
2388100 2388100 2022-04-08 Hamlin South Dakota 46057 1500 41
2384845 2384845 2022-04-07 Hamlin South Dakota 46057 1500 41
2381590 2381590 2022-04-06 Hamlin South Dakota 46057 1500 41
2378335 2378335 2022-04-05 Hamlin South Dakota 46057 1500 41
2375081 2375081 2022-04-04 Hamlin South Dakota 46057 1500 41
2371829 2371829 2022-04-03 Hamlin South Dakota 46057 1500 41
2368576 2368576 2022-04-02 Hamlin South Dakota 46057 1500 41
2365323 2365323 2022-04-01 Hamlin South Dakota 46057 1500 41
2362070 2362070 2022-03-31 Hamlin South Dakota 46057 1500 41
2358816 2358816 2022-03-30 Hamlin South Dakota 46057 1500 41
2355562 2355562 2022-03-29 Hamlin South Dakota 46057 1499 41
2352309 2352309 2022-03-28 Hamlin South Dakota 46057 1499 41
2349057 2349057 2022-03-27 Hamlin South Dakota 46057 1499 41
2345804 2345804 2022-03-26 Hamlin South Dakota 46057 1499 41
2342551 2342551 2022-03-25 Hamlin South Dakota 46057 1499 41
2339298 2339298 2022-03-24 Hamlin South Dakota 46057 1499 41
2336044 2336044 2022-03-23 Hamlin South Dakota 46057 1499 41
2332790 2332790 2022-03-22 Hamlin South Dakota 46057 1498 41
2329537 2329537 2022-03-21 Hamlin South Dakota 46057 1498 41
2326285 2326285 2022-03-20 Hamlin South Dakota 46057 1498 41
2323032 2323032 2022-03-19 Hamlin South Dakota 46057 1498 41
2319778 2319778 2022-03-18 Hamlin South Dakota 46057 1498 41
2316524 2316524 2022-03-17 Hamlin South Dakota 46057 1498 41
2313271 2313271 2022-03-16 Hamlin South Dakota 46057 1498 41
2310018 2310018 2022-03-15 Hamlin South Dakota 46057 1498 41
2306765 2306765 2022-03-14 Hamlin South Dakota 46057 1497 41
2303514 2303514 2022-03-13 Hamlin South Dakota 46057 1497 41
2300262 2300262 2022-03-12 Hamlin South Dakota 46057 1497 41
2297010 2297010 2022-03-11 Hamlin South Dakota 46057 1497 41
2293758 2293758 2022-03-10 Hamlin South Dakota 46057 1495 41
2290506 2290506 2022-03-09 Hamlin South Dakota 46057 1495 41
2287254 2287254 2022-03-08 Hamlin South Dakota 46057 1495 41
2284002 2284002 2022-03-07 Hamlin South Dakota 46057 1495 41
2280750 2280750 2022-03-06 Hamlin South Dakota 46057 1495 41
2277497 2277497 2022-03-05 Hamlin South Dakota 46057 1495 41
2274244 2274244 2022-03-04 Hamlin South Dakota 46057 1495 41
2270991 2270991 2022-03-03 Hamlin South Dakota 46057 1494 41
2267739 2267739 2022-03-02 Hamlin South Dakota 46057 1493 41
2264486 2264486 2022-03-01 Hamlin South Dakota 46057 1493 41
2261236 2261236 2022-02-28 Hamlin South Dakota 46057 1491 41
2257985 2257985 2022-02-27 Hamlin South Dakota 46057 1489 41
2254734 2254734 2022-02-26 Hamlin South Dakota 46057 1489 41
2251483 2251483 2022-02-25 Hamlin South Dakota 46057 1489 41
2248232 2248232 2022-02-24 Hamlin South Dakota 46057 1489 41
2244981 2244981 2022-02-23 Hamlin South Dakota 46057 1488 41
2241730 2241730 2022-02-22 Hamlin South Dakota 46057 1485 41
2238479 2238479 2022-02-21 Hamlin South Dakota 46057 1484 41
2235228 2235228 2022-02-20 Hamlin South Dakota 46057 1484 41
2231977 2231977 2022-02-19 Hamlin South Dakota 46057 1484 41
2228726 2228726 2022-02-18 Hamlin South Dakota 46057 1484 41
2225475 2225475 2022-02-17 Hamlin South Dakota 46057 1481 41
2222224 2222224 2022-02-16 Hamlin South Dakota 46057 1478 41
2218973 2218973 2022-02-15 Hamlin South Dakota 46057 1474 41
2215722 2215722 2022-02-14 Hamlin South Dakota 46057 1473 41
2212471 2212471 2022-02-13 Hamlin South Dakota 46057 1473 41
2209218 2209218 2022-02-12 Hamlin South Dakota 46057 1473 41
2205965 2205965 2022-02-11 Hamlin South Dakota 46057 1473 41
2202712 2202712 2022-02-10 Hamlin South Dakota 46057 1472 41
2199458 2199458 2022-02-09 Hamlin South Dakota 46057 1471 41
2196204 2196204 2022-02-08 Hamlin South Dakota 46057 1462 40
2192950 2192950 2022-02-07 Hamlin South Dakota 46057 1461 40
2189696 2189696 2022-02-06 Hamlin South Dakota 46057 1460 40
2186443 2186443 2022-02-05 Hamlin South Dakota 46057 1460 40
2183191 2183191 2022-02-04 Hamlin South Dakota 46057 1460 40
2179939 2179939 2022-02-03 Hamlin South Dakota 46057 1457 40

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