ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
689 rows where deaths = 7 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Campbell 114
- Potter 100
- McPherson 60
- Stanley 60
- Miner 38
- Ziebach 36
- Deuel 28
- Brule 23
- Lake 21
- Custer 20
- Hyde 20
- Mellette 20
- Douglas 15
- Lyman 12
- Aurora 10
- Fall River 10
- Haakon 10
- Beadle 9
- Clay 9
- Hand 9
- Dewey 8
- Gregory 7
- Union 7
- Codington 6
- Corson 5
- Lawrence 4
- Turner 4
- Bon Homme 3
- Pennington 3
- Yankton 3
- …
state 1
- South Dakota · 689 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502054 | 2502054 | 2022-05-13 | Campbell | South Dakota | 46021 | 268 | 7 |
2502098 | 2502098 | 2022-05-13 | Potter | South Dakota | 46107 | 703 | 7 |
2502102 | 2502102 | 2022-05-13 | Stanley | South Dakota | 46117 | 637 | 7 |
2498796 | 2498796 | 2022-05-12 | Campbell | South Dakota | 46021 | 268 | 7 |
2498840 | 2498840 | 2022-05-12 | Potter | South Dakota | 46107 | 703 | 7 |
2498844 | 2498844 | 2022-05-12 | Stanley | South Dakota | 46117 | 637 | 7 |
2495538 | 2495538 | 2022-05-11 | Campbell | South Dakota | 46021 | 268 | 7 |
2495582 | 2495582 | 2022-05-11 | Potter | South Dakota | 46107 | 703 | 7 |
2495586 | 2495586 | 2022-05-11 | Stanley | South Dakota | 46117 | 637 | 7 |
2492280 | 2492280 | 2022-05-10 | Campbell | South Dakota | 46021 | 268 | 7 |
2492324 | 2492324 | 2022-05-10 | Potter | South Dakota | 46107 | 704 | 7 |
2492328 | 2492328 | 2022-05-10 | Stanley | South Dakota | 46117 | 637 | 7 |
2489022 | 2489022 | 2022-05-09 | Campbell | South Dakota | 46021 | 268 | 7 |
2489066 | 2489066 | 2022-05-09 | Potter | South Dakota | 46107 | 704 | 7 |
2489070 | 2489070 | 2022-05-09 | Stanley | South Dakota | 46117 | 637 | 7 |
2485765 | 2485765 | 2022-05-08 | Campbell | South Dakota | 46021 | 268 | 7 |
2485809 | 2485809 | 2022-05-08 | Potter | South Dakota | 46107 | 704 | 7 |
2485813 | 2485813 | 2022-05-08 | Stanley | South Dakota | 46117 | 637 | 7 |
2482507 | 2482507 | 2022-05-07 | Campbell | South Dakota | 46021 | 268 | 7 |
2482551 | 2482551 | 2022-05-07 | Potter | South Dakota | 46107 | 704 | 7 |
2482555 | 2482555 | 2022-05-07 | Stanley | South Dakota | 46117 | 637 | 7 |
2479249 | 2479249 | 2022-05-06 | Campbell | South Dakota | 46021 | 268 | 7 |
2479293 | 2479293 | 2022-05-06 | Potter | South Dakota | 46107 | 704 | 7 |
2479297 | 2479297 | 2022-05-06 | Stanley | South Dakota | 46117 | 637 | 7 |
2475991 | 2475991 | 2022-05-05 | Campbell | South Dakota | 46021 | 268 | 7 |
2476035 | 2476035 | 2022-05-05 | Potter | South Dakota | 46107 | 704 | 7 |
2476039 | 2476039 | 2022-05-05 | Stanley | South Dakota | 46117 | 637 | 7 |
2472734 | 2472734 | 2022-05-04 | Campbell | South Dakota | 46021 | 268 | 7 |
2472778 | 2472778 | 2022-05-04 | Potter | South Dakota | 46107 | 704 | 7 |
2472782 | 2472782 | 2022-05-04 | Stanley | South Dakota | 46117 | 637 | 7 |
2469478 | 2469478 | 2022-05-03 | Campbell | South Dakota | 46021 | 268 | 7 |
2469522 | 2469522 | 2022-05-03 | Potter | South Dakota | 46107 | 703 | 7 |
2469526 | 2469526 | 2022-05-03 | Stanley | South Dakota | 46117 | 637 | 7 |
2466222 | 2466222 | 2022-05-02 | Campbell | South Dakota | 46021 | 268 | 7 |
2466266 | 2466266 | 2022-05-02 | Potter | South Dakota | 46107 | 703 | 7 |
2466270 | 2466270 | 2022-05-02 | Stanley | South Dakota | 46117 | 637 | 7 |
2462967 | 2462967 | 2022-05-01 | Campbell | South Dakota | 46021 | 268 | 7 |
2463011 | 2463011 | 2022-05-01 | Potter | South Dakota | 46107 | 703 | 7 |
2463015 | 2463015 | 2022-05-01 | Stanley | South Dakota | 46117 | 637 | 7 |
2459711 | 2459711 | 2022-04-30 | Campbell | South Dakota | 46021 | 268 | 7 |
2459755 | 2459755 | 2022-04-30 | Potter | South Dakota | 46107 | 703 | 7 |
2459759 | 2459759 | 2022-04-30 | Stanley | South Dakota | 46117 | 637 | 7 |
2456455 | 2456455 | 2022-04-29 | Campbell | South Dakota | 46021 | 268 | 7 |
2456499 | 2456499 | 2022-04-29 | Potter | South Dakota | 46107 | 703 | 7 |
2456503 | 2456503 | 2022-04-29 | Stanley | South Dakota | 46117 | 637 | 7 |
2453199 | 2453199 | 2022-04-28 | Campbell | South Dakota | 46021 | 268 | 7 |
2453243 | 2453243 | 2022-04-28 | Potter | South Dakota | 46107 | 703 | 7 |
2453247 | 2453247 | 2022-04-28 | Stanley | South Dakota | 46117 | 637 | 7 |
2449943 | 2449943 | 2022-04-27 | Campbell | South Dakota | 46021 | 268 | 7 |
2449987 | 2449987 | 2022-04-27 | Potter | South Dakota | 46107 | 703 | 7 |
2449991 | 2449991 | 2022-04-27 | Stanley | South Dakota | 46117 | 637 | 7 |
2446686 | 2446686 | 2022-04-26 | Campbell | South Dakota | 46021 | 267 | 7 |
2446730 | 2446730 | 2022-04-26 | Potter | South Dakota | 46107 | 703 | 7 |
2446734 | 2446734 | 2022-04-26 | Stanley | South Dakota | 46117 | 637 | 7 |
2443431 | 2443431 | 2022-04-25 | Campbell | South Dakota | 46021 | 267 | 7 |
2443475 | 2443475 | 2022-04-25 | Potter | South Dakota | 46107 | 703 | 7 |
2443479 | 2443479 | 2022-04-25 | Stanley | South Dakota | 46117 | 637 | 7 |
2440175 | 2440175 | 2022-04-24 | Campbell | South Dakota | 46021 | 267 | 7 |
2440219 | 2440219 | 2022-04-24 | Potter | South Dakota | 46107 | 703 | 7 |
2440223 | 2440223 | 2022-04-24 | Stanley | South Dakota | 46117 | 637 | 7 |
2436919 | 2436919 | 2022-04-23 | Campbell | South Dakota | 46021 | 267 | 7 |
2436963 | 2436963 | 2022-04-23 | Potter | South Dakota | 46107 | 703 | 7 |
2436967 | 2436967 | 2022-04-23 | Stanley | South Dakota | 46117 | 637 | 7 |
2433663 | 2433663 | 2022-04-22 | Campbell | South Dakota | 46021 | 267 | 7 |
2433707 | 2433707 | 2022-04-22 | Potter | South Dakota | 46107 | 703 | 7 |
2433711 | 2433711 | 2022-04-22 | Stanley | South Dakota | 46117 | 637 | 7 |
2430407 | 2430407 | 2022-04-21 | Campbell | South Dakota | 46021 | 267 | 7 |
2430451 | 2430451 | 2022-04-21 | Potter | South Dakota | 46107 | 703 | 7 |
2430455 | 2430455 | 2022-04-21 | Stanley | South Dakota | 46117 | 637 | 7 |
2427151 | 2427151 | 2022-04-20 | Campbell | South Dakota | 46021 | 267 | 7 |
2427195 | 2427195 | 2022-04-20 | Potter | South Dakota | 46107 | 703 | 7 |
2427199 | 2427199 | 2022-04-20 | Stanley | South Dakota | 46117 | 637 | 7 |
2423895 | 2423895 | 2022-04-19 | Campbell | South Dakota | 46021 | 267 | 7 |
2423939 | 2423939 | 2022-04-19 | Potter | South Dakota | 46107 | 704 | 7 |
2423943 | 2423943 | 2022-04-19 | Stanley | South Dakota | 46117 | 636 | 7 |
2420639 | 2420639 | 2022-04-18 | Campbell | South Dakota | 46021 | 267 | 7 |
2420683 | 2420683 | 2022-04-18 | Potter | South Dakota | 46107 | 704 | 7 |
2420687 | 2420687 | 2022-04-18 | Stanley | South Dakota | 46117 | 636 | 7 |
2417383 | 2417383 | 2022-04-17 | Campbell | South Dakota | 46021 | 267 | 7 |
2417427 | 2417427 | 2022-04-17 | Potter | South Dakota | 46107 | 704 | 7 |
2417431 | 2417431 | 2022-04-17 | Stanley | South Dakota | 46117 | 636 | 7 |
2414127 | 2414127 | 2022-04-16 | Campbell | South Dakota | 46021 | 267 | 7 |
2414171 | 2414171 | 2022-04-16 | Potter | South Dakota | 46107 | 704 | 7 |
2414175 | 2414175 | 2022-04-16 | Stanley | South Dakota | 46117 | 636 | 7 |
2410871 | 2410871 | 2022-04-15 | Campbell | South Dakota | 46021 | 267 | 7 |
2410915 | 2410915 | 2022-04-15 | Potter | South Dakota | 46107 | 704 | 7 |
2410919 | 2410919 | 2022-04-15 | Stanley | South Dakota | 46117 | 636 | 7 |
2407615 | 2407615 | 2022-04-14 | Campbell | South Dakota | 46021 | 267 | 7 |
2407659 | 2407659 | 2022-04-14 | Potter | South Dakota | 46107 | 704 | 7 |
2407663 | 2407663 | 2022-04-14 | Stanley | South Dakota | 46117 | 636 | 7 |
2404359 | 2404359 | 2022-04-13 | Campbell | South Dakota | 46021 | 267 | 7 |
2404403 | 2404403 | 2022-04-13 | Potter | South Dakota | 46107 | 704 | 7 |
2404407 | 2404407 | 2022-04-13 | Stanley | South Dakota | 46117 | 636 | 7 |
2401104 | 2401104 | 2022-04-12 | Campbell | South Dakota | 46021 | 266 | 7 |
2401148 | 2401148 | 2022-04-12 | Potter | South Dakota | 46107 | 704 | 7 |
2401152 | 2401152 | 2022-04-12 | Stanley | South Dakota | 46117 | 635 | 7 |
2397849 | 2397849 | 2022-04-11 | Campbell | South Dakota | 46021 | 266 | 7 |
2397893 | 2397893 | 2022-04-11 | Potter | South Dakota | 46107 | 704 | 7 |
2397897 | 2397897 | 2022-04-11 | Stanley | South Dakota | 46117 | 635 | 7 |
2394594 | 2394594 | 2022-04-10 | Campbell | South Dakota | 46021 | 266 | 7 |
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);