ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Sanborn", fips = 46111 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502100 | 2502100 | 2022-05-13 | Sanborn | South Dakota | 46111 | 575 | 6 |
2498842 | 2498842 | 2022-05-12 | Sanborn | South Dakota | 46111 | 575 | 6 |
2495584 | 2495584 | 2022-05-11 | Sanborn | South Dakota | 46111 | 575 | 6 |
2492326 | 2492326 | 2022-05-10 | Sanborn | South Dakota | 46111 | 572 | 6 |
2489068 | 2489068 | 2022-05-09 | Sanborn | South Dakota | 46111 | 572 | 6 |
2485811 | 2485811 | 2022-05-08 | Sanborn | South Dakota | 46111 | 572 | 6 |
2482553 | 2482553 | 2022-05-07 | Sanborn | South Dakota | 46111 | 572 | 6 |
2479295 | 2479295 | 2022-05-06 | Sanborn | South Dakota | 46111 | 572 | 6 |
2476037 | 2476037 | 2022-05-05 | Sanborn | South Dakota | 46111 | 572 | 6 |
2472780 | 2472780 | 2022-05-04 | Sanborn | South Dakota | 46111 | 572 | 6 |
2469524 | 2469524 | 2022-05-03 | Sanborn | South Dakota | 46111 | 572 | 6 |
2466268 | 2466268 | 2022-05-02 | Sanborn | South Dakota | 46111 | 572 | 6 |
2463013 | 2463013 | 2022-05-01 | Sanborn | South Dakota | 46111 | 572 | 6 |
2459757 | 2459757 | 2022-04-30 | Sanborn | South Dakota | 46111 | 572 | 6 |
2456501 | 2456501 | 2022-04-29 | Sanborn | South Dakota | 46111 | 572 | 6 |
2453245 | 2453245 | 2022-04-28 | Sanborn | South Dakota | 46111 | 572 | 6 |
2449989 | 2449989 | 2022-04-27 | Sanborn | South Dakota | 46111 | 572 | 6 |
2446732 | 2446732 | 2022-04-26 | Sanborn | South Dakota | 46111 | 572 | 6 |
2443477 | 2443477 | 2022-04-25 | Sanborn | South Dakota | 46111 | 572 | 6 |
2440221 | 2440221 | 2022-04-24 | Sanborn | South Dakota | 46111 | 572 | 6 |
2436965 | 2436965 | 2022-04-23 | Sanborn | South Dakota | 46111 | 572 | 6 |
2433709 | 2433709 | 2022-04-22 | Sanborn | South Dakota | 46111 | 572 | 6 |
2430453 | 2430453 | 2022-04-21 | Sanborn | South Dakota | 46111 | 572 | 6 |
2427197 | 2427197 | 2022-04-20 | Sanborn | South Dakota | 46111 | 572 | 6 |
2423941 | 2423941 | 2022-04-19 | Sanborn | South Dakota | 46111 | 573 | 6 |
2420685 | 2420685 | 2022-04-18 | Sanborn | South Dakota | 46111 | 573 | 6 |
2417429 | 2417429 | 2022-04-17 | Sanborn | South Dakota | 46111 | 573 | 6 |
2414173 | 2414173 | 2022-04-16 | Sanborn | South Dakota | 46111 | 573 | 6 |
2410917 | 2410917 | 2022-04-15 | Sanborn | South Dakota | 46111 | 573 | 6 |
2407661 | 2407661 | 2022-04-14 | Sanborn | South Dakota | 46111 | 573 | 6 |
2404405 | 2404405 | 2022-04-13 | Sanborn | South Dakota | 46111 | 573 | 6 |
2401150 | 2401150 | 2022-04-12 | Sanborn | South Dakota | 46111 | 573 | 6 |
2397895 | 2397895 | 2022-04-11 | Sanborn | South Dakota | 46111 | 573 | 6 |
2394640 | 2394640 | 2022-04-10 | Sanborn | South Dakota | 46111 | 573 | 6 |
2391384 | 2391384 | 2022-04-09 | Sanborn | South Dakota | 46111 | 573 | 6 |
2388128 | 2388128 | 2022-04-08 | Sanborn | South Dakota | 46111 | 573 | 6 |
2384873 | 2384873 | 2022-04-07 | Sanborn | South Dakota | 46111 | 573 | 6 |
2381618 | 2381618 | 2022-04-06 | Sanborn | South Dakota | 46111 | 573 | 6 |
2378363 | 2378363 | 2022-04-05 | Sanborn | South Dakota | 46111 | 573 | 6 |
2375109 | 2375109 | 2022-04-04 | Sanborn | South Dakota | 46111 | 573 | 6 |
2371857 | 2371857 | 2022-04-03 | Sanborn | South Dakota | 46111 | 573 | 6 |
2368604 | 2368604 | 2022-04-02 | Sanborn | South Dakota | 46111 | 573 | 6 |
2365351 | 2365351 | 2022-04-01 | Sanborn | South Dakota | 46111 | 573 | 6 |
2362098 | 2362098 | 2022-03-31 | Sanborn | South Dakota | 46111 | 573 | 6 |
2358844 | 2358844 | 2022-03-30 | Sanborn | South Dakota | 46111 | 573 | 6 |
2355590 | 2355590 | 2022-03-29 | Sanborn | South Dakota | 46111 | 573 | 6 |
2352337 | 2352337 | 2022-03-28 | Sanborn | South Dakota | 46111 | 573 | 6 |
2349085 | 2349085 | 2022-03-27 | Sanborn | South Dakota | 46111 | 573 | 6 |
2345832 | 2345832 | 2022-03-26 | Sanborn | South Dakota | 46111 | 573 | 6 |
2342579 | 2342579 | 2022-03-25 | Sanborn | South Dakota | 46111 | 573 | 6 |
2339326 | 2339326 | 2022-03-24 | Sanborn | South Dakota | 46111 | 573 | 6 |
2336072 | 2336072 | 2022-03-23 | Sanborn | South Dakota | 46111 | 573 | 6 |
2332818 | 2332818 | 2022-03-22 | Sanborn | South Dakota | 46111 | 573 | 6 |
2329565 | 2329565 | 2022-03-21 | Sanborn | South Dakota | 46111 | 573 | 6 |
2326313 | 2326313 | 2022-03-20 | Sanborn | South Dakota | 46111 | 573 | 6 |
2323060 | 2323060 | 2022-03-19 | Sanborn | South Dakota | 46111 | 573 | 6 |
2319806 | 2319806 | 2022-03-18 | Sanborn | South Dakota | 46111 | 573 | 6 |
2316552 | 2316552 | 2022-03-17 | Sanborn | South Dakota | 46111 | 573 | 6 |
2313299 | 2313299 | 2022-03-16 | Sanborn | South Dakota | 46111 | 573 | 6 |
2310046 | 2310046 | 2022-03-15 | Sanborn | South Dakota | 46111 | 573 | 6 |
2306793 | 2306793 | 2022-03-14 | Sanborn | South Dakota | 46111 | 573 | 6 |
2303542 | 2303542 | 2022-03-13 | Sanborn | South Dakota | 46111 | 573 | 6 |
2300290 | 2300290 | 2022-03-12 | Sanborn | South Dakota | 46111 | 573 | 6 |
2297038 | 2297038 | 2022-03-11 | Sanborn | South Dakota | 46111 | 573 | 6 |
2293786 | 2293786 | 2022-03-10 | Sanborn | South Dakota | 46111 | 572 | 6 |
2290534 | 2290534 | 2022-03-09 | Sanborn | South Dakota | 46111 | 572 | 6 |
2287282 | 2287282 | 2022-03-08 | Sanborn | South Dakota | 46111 | 572 | 6 |
2284030 | 2284030 | 2022-03-07 | Sanborn | South Dakota | 46111 | 572 | 6 |
2280778 | 2280778 | 2022-03-06 | Sanborn | South Dakota | 46111 | 572 | 6 |
2277525 | 2277525 | 2022-03-05 | Sanborn | South Dakota | 46111 | 572 | 6 |
2274272 | 2274272 | 2022-03-04 | Sanborn | South Dakota | 46111 | 572 | 6 |
2271019 | 2271019 | 2022-03-03 | Sanborn | South Dakota | 46111 | 573 | 6 |
2267767 | 2267767 | 2022-03-02 | Sanborn | South Dakota | 46111 | 572 | 6 |
2264514 | 2264514 | 2022-03-01 | Sanborn | South Dakota | 46111 | 573 | 6 |
2261264 | 2261264 | 2022-02-28 | Sanborn | South Dakota | 46111 | 573 | 6 |
2258013 | 2258013 | 2022-02-27 | Sanborn | South Dakota | 46111 | 573 | 6 |
2254762 | 2254762 | 2022-02-26 | Sanborn | South Dakota | 46111 | 573 | 6 |
2251511 | 2251511 | 2022-02-25 | Sanborn | South Dakota | 46111 | 573 | 6 |
2248260 | 2248260 | 2022-02-24 | Sanborn | South Dakota | 46111 | 572 | 6 |
2245009 | 2245009 | 2022-02-23 | Sanborn | South Dakota | 46111 | 571 | 6 |
2241758 | 2241758 | 2022-02-22 | Sanborn | South Dakota | 46111 | 567 | 6 |
2238507 | 2238507 | 2022-02-21 | Sanborn | South Dakota | 46111 | 566 | 6 |
2235256 | 2235256 | 2022-02-20 | Sanborn | South Dakota | 46111 | 566 | 6 |
2232005 | 2232005 | 2022-02-19 | Sanborn | South Dakota | 46111 | 566 | 6 |
2228754 | 2228754 | 2022-02-18 | Sanborn | South Dakota | 46111 | 566 | 6 |
2225503 | 2225503 | 2022-02-17 | Sanborn | South Dakota | 46111 | 566 | 6 |
2222252 | 2222252 | 2022-02-16 | Sanborn | South Dakota | 46111 | 566 | 6 |
2219001 | 2219001 | 2022-02-15 | Sanborn | South Dakota | 46111 | 564 | 6 |
2215750 | 2215750 | 2022-02-14 | Sanborn | South Dakota | 46111 | 564 | 6 |
2212499 | 2212499 | 2022-02-13 | Sanborn | South Dakota | 46111 | 563 | 6 |
2209246 | 2209246 | 2022-02-12 | Sanborn | South Dakota | 46111 | 563 | 6 |
2205993 | 2205993 | 2022-02-11 | Sanborn | South Dakota | 46111 | 563 | 6 |
2202740 | 2202740 | 2022-02-10 | Sanborn | South Dakota | 46111 | 563 | 6 |
2199486 | 2199486 | 2022-02-09 | Sanborn | South Dakota | 46111 | 563 | 6 |
2196232 | 2196232 | 2022-02-08 | Sanborn | South Dakota | 46111 | 562 | 6 |
2192978 | 2192978 | 2022-02-07 | Sanborn | South Dakota | 46111 | 562 | 6 |
2189724 | 2189724 | 2022-02-06 | Sanborn | South Dakota | 46111 | 555 | 6 |
2186471 | 2186471 | 2022-02-05 | Sanborn | South Dakota | 46111 | 555 | 6 |
2183219 | 2183219 | 2022-02-04 | Sanborn | South Dakota | 46111 | 555 | 6 |
2179967 | 2179967 | 2022-02-03 | Sanborn | South Dakota | 46111 | 552 | 6 |
Advanced export
JSON shape: default, array, newline-delimited
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);