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

776 rows where county = "Roberts" 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 · 776 ✖

fips 1

county 1

  • Roberts · 776 ✖
Link rowid date ▲ county state fips cases deaths
2502099 2502099 2022-05-13 Roberts South Dakota 46109 2436 53
2498841 2498841 2022-05-12 Roberts South Dakota 46109 2436 53
2495583 2495583 2022-05-11 Roberts South Dakota 46109 2436 53
2492325 2492325 2022-05-10 Roberts South Dakota 46109 2434 53
2489067 2489067 2022-05-09 Roberts South Dakota 46109 2434 53
2485810 2485810 2022-05-08 Roberts South Dakota 46109 2434 53
2482552 2482552 2022-05-07 Roberts South Dakota 46109 2434 53
2479294 2479294 2022-05-06 Roberts South Dakota 46109 2434 53
2476036 2476036 2022-05-05 Roberts South Dakota 46109 2434 53
2472779 2472779 2022-05-04 Roberts South Dakota 46109 2434 53
2469523 2469523 2022-05-03 Roberts South Dakota 46109 2430 53
2466267 2466267 2022-05-02 Roberts South Dakota 46109 2430 53
2463012 2463012 2022-05-01 Roberts South Dakota 46109 2430 53
2459756 2459756 2022-04-30 Roberts South Dakota 46109 2430 53
2456500 2456500 2022-04-29 Roberts South Dakota 46109 2430 53
2453244 2453244 2022-04-28 Roberts South Dakota 46109 2430 53
2449988 2449988 2022-04-27 Roberts South Dakota 46109 2430 53
2446731 2446731 2022-04-26 Roberts South Dakota 46109 2428 53
2443476 2443476 2022-04-25 Roberts South Dakota 46109 2428 53
2440220 2440220 2022-04-24 Roberts South Dakota 46109 2428 53
2436964 2436964 2022-04-23 Roberts South Dakota 46109 2428 53
2433708 2433708 2022-04-22 Roberts South Dakota 46109 2428 53
2430452 2430452 2022-04-21 Roberts South Dakota 46109 2428 53
2427196 2427196 2022-04-20 Roberts South Dakota 46109 2428 53
2423940 2423940 2022-04-19 Roberts South Dakota 46109 2427 53
2420684 2420684 2022-04-18 Roberts South Dakota 46109 2427 53
2417428 2417428 2022-04-17 Roberts South Dakota 46109 2427 53
2414172 2414172 2022-04-16 Roberts South Dakota 46109 2427 53
2410916 2410916 2022-04-15 Roberts South Dakota 46109 2427 53
2407660 2407660 2022-04-14 Roberts South Dakota 46109 2427 53
2404404 2404404 2022-04-13 Roberts South Dakota 46109 2427 53
2401149 2401149 2022-04-12 Roberts South Dakota 46109 2427 53
2397894 2397894 2022-04-11 Roberts South Dakota 46109 2427 53
2394639 2394639 2022-04-10 Roberts South Dakota 46109 2427 53
2391383 2391383 2022-04-09 Roberts South Dakota 46109 2427 53
2388127 2388127 2022-04-08 Roberts South Dakota 46109 2427 53
2384872 2384872 2022-04-07 Roberts South Dakota 46109 2427 53
2381617 2381617 2022-04-06 Roberts South Dakota 46109 2427 53
2378362 2378362 2022-04-05 Roberts South Dakota 46109 2424 52
2375108 2375108 2022-04-04 Roberts South Dakota 46109 2424 52
2371856 2371856 2022-04-03 Roberts South Dakota 46109 2424 52
2368603 2368603 2022-04-02 Roberts South Dakota 46109 2424 52
2365350 2365350 2022-04-01 Roberts South Dakota 46109 2424 52
2362097 2362097 2022-03-31 Roberts South Dakota 46109 2424 52
2358843 2358843 2022-03-30 Roberts South Dakota 46109 2424 52
2355589 2355589 2022-03-29 Roberts South Dakota 46109 2423 52
2352336 2352336 2022-03-28 Roberts South Dakota 46109 2423 52
2349084 2349084 2022-03-27 Roberts South Dakota 46109 2423 52
2345831 2345831 2022-03-26 Roberts South Dakota 46109 2423 52
2342578 2342578 2022-03-25 Roberts South Dakota 46109 2423 52
2339325 2339325 2022-03-24 Roberts South Dakota 46109 2423 52
2336071 2336071 2022-03-23 Roberts South Dakota 46109 2423 52
2332817 2332817 2022-03-22 Roberts South Dakota 46109 2422 52
2329564 2329564 2022-03-21 Roberts South Dakota 46109 2422 52
2326312 2326312 2022-03-20 Roberts South Dakota 46109 2422 52
2323059 2323059 2022-03-19 Roberts South Dakota 46109 2422 52
2319805 2319805 2022-03-18 Roberts South Dakota 46109 2422 52
2316551 2316551 2022-03-17 Roberts South Dakota 46109 2421 52
2313298 2313298 2022-03-16 Roberts South Dakota 46109 2420 52
2310045 2310045 2022-03-15 Roberts South Dakota 46109 2420 52
2306792 2306792 2022-03-14 Roberts South Dakota 46109 2419 52
2303541 2303541 2022-03-13 Roberts South Dakota 46109 2417 51
2300289 2300289 2022-03-12 Roberts South Dakota 46109 2417 51
2297037 2297037 2022-03-11 Roberts South Dakota 46109 2417 51
2293785 2293785 2022-03-10 Roberts South Dakota 46109 2417 51
2290533 2290533 2022-03-09 Roberts South Dakota 46109 2416 50
2287281 2287281 2022-03-08 Roberts South Dakota 46109 2416 50
2284029 2284029 2022-03-07 Roberts South Dakota 46109 2416 50
2280777 2280777 2022-03-06 Roberts South Dakota 46109 2415 49
2277524 2277524 2022-03-05 Roberts South Dakota 46109 2415 49
2274271 2274271 2022-03-04 Roberts South Dakota 46109 2415 49
2271018 2271018 2022-03-03 Roberts South Dakota 46109 2414 49
2267766 2267766 2022-03-02 Roberts South Dakota 46109 2415 49
2264513 2264513 2022-03-01 Roberts South Dakota 46109 2413 49
2261263 2261263 2022-02-28 Roberts South Dakota 46109 2413 49
2258012 2258012 2022-02-27 Roberts South Dakota 46109 2412 49
2254761 2254761 2022-02-26 Roberts South Dakota 46109 2412 49
2251510 2251510 2022-02-25 Roberts South Dakota 46109 2412 49
2248259 2248259 2022-02-24 Roberts South Dakota 46109 2411 49
2245008 2245008 2022-02-23 Roberts South Dakota 46109 2413 49
2241757 2241757 2022-02-22 Roberts South Dakota 46109 2406 49
2238506 2238506 2022-02-21 Roberts South Dakota 46109 2398 49
2235255 2235255 2022-02-20 Roberts South Dakota 46109 2398 49
2232004 2232004 2022-02-19 Roberts South Dakota 46109 2398 49
2228753 2228753 2022-02-18 Roberts South Dakota 46109 2398 49
2225502 2225502 2022-02-17 Roberts South Dakota 46109 2394 49
2222251 2222251 2022-02-16 Roberts South Dakota 46109 2381 49
2219000 2219000 2022-02-15 Roberts South Dakota 46109 2371 47
2215749 2215749 2022-02-14 Roberts South Dakota 46109 2363 47
2212498 2212498 2022-02-13 Roberts South Dakota 46109 2352 47
2209245 2209245 2022-02-12 Roberts South Dakota 46109 2352 47
2205992 2205992 2022-02-11 Roberts South Dakota 46109 2352 47
2202739 2202739 2022-02-10 Roberts South Dakota 46109 2347 47
2199485 2199485 2022-02-09 Roberts South Dakota 46109 2338 47
2196231 2196231 2022-02-08 Roberts South Dakota 46109 2324 47
2192977 2192977 2022-02-07 Roberts South Dakota 46109 2312 47
2189723 2189723 2022-02-06 Roberts South Dakota 46109 2300 47
2186470 2186470 2022-02-05 Roberts South Dakota 46109 2300 47
2183218 2183218 2022-02-04 Roberts South Dakota 46109 2300 47
2179966 2179966 2022-02-03 Roberts South Dakota 46109 2296 47

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