ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,201 rows where deaths = 6 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502074 | 2502074 | 2022-05-13 | Hanson | South Dakota | 46061 | 655 | 6 |
2502100 | 2502100 | 2022-05-13 | Sanborn | South Dakota | 46111 | 575 | 6 |
2498816 | 2498816 | 2022-05-12 | Hanson | South Dakota | 46061 | 655 | 6 |
2498842 | 2498842 | 2022-05-12 | Sanborn | South Dakota | 46111 | 575 | 6 |
2495558 | 2495558 | 2022-05-11 | Hanson | South Dakota | 46061 | 655 | 6 |
2495584 | 2495584 | 2022-05-11 | Sanborn | South Dakota | 46111 | 575 | 6 |
2492300 | 2492300 | 2022-05-10 | Hanson | South Dakota | 46061 | 655 | 6 |
2492326 | 2492326 | 2022-05-10 | Sanborn | South Dakota | 46111 | 572 | 6 |
2489042 | 2489042 | 2022-05-09 | Hanson | South Dakota | 46061 | 655 | 6 |
2489068 | 2489068 | 2022-05-09 | Sanborn | South Dakota | 46111 | 572 | 6 |
2485785 | 2485785 | 2022-05-08 | Hanson | South Dakota | 46061 | 655 | 6 |
2485811 | 2485811 | 2022-05-08 | Sanborn | South Dakota | 46111 | 572 | 6 |
2482527 | 2482527 | 2022-05-07 | Hanson | South Dakota | 46061 | 655 | 6 |
2482553 | 2482553 | 2022-05-07 | Sanborn | South Dakota | 46111 | 572 | 6 |
2479269 | 2479269 | 2022-05-06 | Hanson | South Dakota | 46061 | 655 | 6 |
2479295 | 2479295 | 2022-05-06 | Sanborn | South Dakota | 46111 | 572 | 6 |
2476011 | 2476011 | 2022-05-05 | Hanson | South Dakota | 46061 | 655 | 6 |
2476037 | 2476037 | 2022-05-05 | Sanborn | South Dakota | 46111 | 572 | 6 |
2472754 | 2472754 | 2022-05-04 | Hanson | South Dakota | 46061 | 655 | 6 |
2472780 | 2472780 | 2022-05-04 | Sanborn | South Dakota | 46111 | 572 | 6 |
2469498 | 2469498 | 2022-05-03 | Hanson | South Dakota | 46061 | 655 | 6 |
2469524 | 2469524 | 2022-05-03 | Sanborn | South Dakota | 46111 | 572 | 6 |
2466242 | 2466242 | 2022-05-02 | Hanson | South Dakota | 46061 | 655 | 6 |
2466268 | 2466268 | 2022-05-02 | Sanborn | South Dakota | 46111 | 572 | 6 |
2462987 | 2462987 | 2022-05-01 | Hanson | South Dakota | 46061 | 655 | 6 |
2463013 | 2463013 | 2022-05-01 | Sanborn | South Dakota | 46111 | 572 | 6 |
2459731 | 2459731 | 2022-04-30 | Hanson | South Dakota | 46061 | 655 | 6 |
2459757 | 2459757 | 2022-04-30 | Sanborn | South Dakota | 46111 | 572 | 6 |
2456475 | 2456475 | 2022-04-29 | Hanson | South Dakota | 46061 | 655 | 6 |
2456501 | 2456501 | 2022-04-29 | Sanborn | South Dakota | 46111 | 572 | 6 |
2453219 | 2453219 | 2022-04-28 | Hanson | South Dakota | 46061 | 655 | 6 |
2453245 | 2453245 | 2022-04-28 | Sanborn | South Dakota | 46111 | 572 | 6 |
2449963 | 2449963 | 2022-04-27 | Hanson | South Dakota | 46061 | 655 | 6 |
2449989 | 2449989 | 2022-04-27 | Sanborn | South Dakota | 46111 | 572 | 6 |
2446706 | 2446706 | 2022-04-26 | Hanson | South Dakota | 46061 | 655 | 6 |
2446732 | 2446732 | 2022-04-26 | Sanborn | South Dakota | 46111 | 572 | 6 |
2443451 | 2443451 | 2022-04-25 | Hanson | South Dakota | 46061 | 655 | 6 |
2443477 | 2443477 | 2022-04-25 | Sanborn | South Dakota | 46111 | 572 | 6 |
2440195 | 2440195 | 2022-04-24 | Hanson | South Dakota | 46061 | 655 | 6 |
2440221 | 2440221 | 2022-04-24 | Sanborn | South Dakota | 46111 | 572 | 6 |
2436939 | 2436939 | 2022-04-23 | Hanson | South Dakota | 46061 | 655 | 6 |
2436965 | 2436965 | 2022-04-23 | Sanborn | South Dakota | 46111 | 572 | 6 |
2433683 | 2433683 | 2022-04-22 | Hanson | South Dakota | 46061 | 655 | 6 |
2433709 | 2433709 | 2022-04-22 | Sanborn | South Dakota | 46111 | 572 | 6 |
2430427 | 2430427 | 2022-04-21 | Hanson | South Dakota | 46061 | 655 | 6 |
2430453 | 2430453 | 2022-04-21 | Sanborn | South Dakota | 46111 | 572 | 6 |
2427171 | 2427171 | 2022-04-20 | Hanson | South Dakota | 46061 | 655 | 6 |
2427197 | 2427197 | 2022-04-20 | Sanborn | South Dakota | 46111 | 572 | 6 |
2423915 | 2423915 | 2022-04-19 | Hanson | South Dakota | 46061 | 655 | 6 |
2423941 | 2423941 | 2022-04-19 | Sanborn | South Dakota | 46111 | 573 | 6 |
2420659 | 2420659 | 2022-04-18 | Hanson | South Dakota | 46061 | 655 | 6 |
2420685 | 2420685 | 2022-04-18 | Sanborn | South Dakota | 46111 | 573 | 6 |
2417403 | 2417403 | 2022-04-17 | Hanson | South Dakota | 46061 | 655 | 6 |
2417429 | 2417429 | 2022-04-17 | Sanborn | South Dakota | 46111 | 573 | 6 |
2414147 | 2414147 | 2022-04-16 | Hanson | South Dakota | 46061 | 655 | 6 |
2414173 | 2414173 | 2022-04-16 | Sanborn | South Dakota | 46111 | 573 | 6 |
2410891 | 2410891 | 2022-04-15 | Hanson | South Dakota | 46061 | 655 | 6 |
2410917 | 2410917 | 2022-04-15 | Sanborn | South Dakota | 46111 | 573 | 6 |
2407635 | 2407635 | 2022-04-14 | Hanson | South Dakota | 46061 | 655 | 6 |
2407661 | 2407661 | 2022-04-14 | Sanborn | South Dakota | 46111 | 573 | 6 |
2404379 | 2404379 | 2022-04-13 | Hanson | South Dakota | 46061 | 655 | 6 |
2404405 | 2404405 | 2022-04-13 | Sanborn | South Dakota | 46111 | 573 | 6 |
2401124 | 2401124 | 2022-04-12 | Hanson | South Dakota | 46061 | 655 | 6 |
2401150 | 2401150 | 2022-04-12 | Sanborn | South Dakota | 46111 | 573 | 6 |
2397869 | 2397869 | 2022-04-11 | Hanson | South Dakota | 46061 | 655 | 6 |
2397895 | 2397895 | 2022-04-11 | Sanborn | South Dakota | 46111 | 573 | 6 |
2394614 | 2394614 | 2022-04-10 | Hanson | South Dakota | 46061 | 655 | 6 |
2394640 | 2394640 | 2022-04-10 | Sanborn | South Dakota | 46111 | 573 | 6 |
2391358 | 2391358 | 2022-04-09 | Hanson | South Dakota | 46061 | 655 | 6 |
2391384 | 2391384 | 2022-04-09 | Sanborn | South Dakota | 46111 | 573 | 6 |
2388102 | 2388102 | 2022-04-08 | Hanson | South Dakota | 46061 | 655 | 6 |
2388128 | 2388128 | 2022-04-08 | Sanborn | South Dakota | 46111 | 573 | 6 |
2384847 | 2384847 | 2022-04-07 | Hanson | South Dakota | 46061 | 655 | 6 |
2384873 | 2384873 | 2022-04-07 | Sanborn | South Dakota | 46111 | 573 | 6 |
2381592 | 2381592 | 2022-04-06 | Hanson | South Dakota | 46061 | 655 | 6 |
2381618 | 2381618 | 2022-04-06 | Sanborn | South Dakota | 46111 | 573 | 6 |
2378337 | 2378337 | 2022-04-05 | Hanson | South Dakota | 46061 | 654 | 6 |
2378363 | 2378363 | 2022-04-05 | Sanborn | South Dakota | 46111 | 573 | 6 |
2375083 | 2375083 | 2022-04-04 | Hanson | South Dakota | 46061 | 654 | 6 |
2375109 | 2375109 | 2022-04-04 | Sanborn | South Dakota | 46111 | 573 | 6 |
2371831 | 2371831 | 2022-04-03 | Hanson | South Dakota | 46061 | 654 | 6 |
2371857 | 2371857 | 2022-04-03 | Sanborn | South Dakota | 46111 | 573 | 6 |
2368578 | 2368578 | 2022-04-02 | Hanson | South Dakota | 46061 | 654 | 6 |
2368604 | 2368604 | 2022-04-02 | Sanborn | South Dakota | 46111 | 573 | 6 |
2365325 | 2365325 | 2022-04-01 | Hanson | South Dakota | 46061 | 654 | 6 |
2365351 | 2365351 | 2022-04-01 | Sanborn | South Dakota | 46111 | 573 | 6 |
2362072 | 2362072 | 2022-03-31 | Hanson | South Dakota | 46061 | 654 | 6 |
2362098 | 2362098 | 2022-03-31 | Sanborn | South Dakota | 46111 | 573 | 6 |
2358818 | 2358818 | 2022-03-30 | Hanson | South Dakota | 46061 | 654 | 6 |
2358844 | 2358844 | 2022-03-30 | Sanborn | South Dakota | 46111 | 573 | 6 |
2355564 | 2355564 | 2022-03-29 | Hanson | South Dakota | 46061 | 653 | 6 |
2355590 | 2355590 | 2022-03-29 | Sanborn | South Dakota | 46111 | 573 | 6 |
2352311 | 2352311 | 2022-03-28 | Hanson | South Dakota | 46061 | 653 | 6 |
2352337 | 2352337 | 2022-03-28 | Sanborn | South Dakota | 46111 | 573 | 6 |
2349059 | 2349059 | 2022-03-27 | Hanson | South Dakota | 46061 | 653 | 6 |
2349085 | 2349085 | 2022-03-27 | Sanborn | South Dakota | 46111 | 573 | 6 |
2345806 | 2345806 | 2022-03-26 | Hanson | South Dakota | 46061 | 653 | 6 |
2345832 | 2345832 | 2022-03-26 | Sanborn | South Dakota | 46111 | 573 | 6 |
2342553 | 2342553 | 2022-03-25 | Hanson | South Dakota | 46061 | 653 | 6 |
2342579 | 2342579 | 2022-03-25 | Sanborn | South Dakota | 46111 | 573 | 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);