ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,013 rows where deaths = 13 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
- Faulk 207
- Buffalo 153
- Miner 87
- Marshall 86
- Custer 68
- Kingsbury 64
- Edmunds 62
- Corson 61
- Jerauld 38
- Jackson 23
- Bennett 19
- Walworth 16
- Fall River 15
- Perkins 14
- Butte 11
- Meade 11
- Beadle 9
- Moody 7
- Hutchinson 6
- Lake 6
- Tripp 6
- Brule 5
- Clay 5
- Roberts 5
- Brookings 4
- Charles Mix 4
- Davison 4
- Gregory 3
- Oglala Lakota 3
- Bon Homme 2
- …
state 1
- South Dakota · 1,013 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502087 | 2502087 | 2022-05-13 | Marshall | South Dakota | 46091 | 796 | 13 |
2502092 | 2502092 | 2022-05-13 | Miner | South Dakota | 46097 | 457 | 13 |
2498829 | 2498829 | 2022-05-12 | Marshall | South Dakota | 46091 | 796 | 13 |
2498834 | 2498834 | 2022-05-12 | Miner | South Dakota | 46097 | 457 | 13 |
2495571 | 2495571 | 2022-05-11 | Marshall | South Dakota | 46091 | 796 | 13 |
2495576 | 2495576 | 2022-05-11 | Miner | South Dakota | 46097 | 457 | 13 |
2492313 | 2492313 | 2022-05-10 | Marshall | South Dakota | 46091 | 793 | 13 |
2492318 | 2492318 | 2022-05-10 | Miner | South Dakota | 46097 | 457 | 13 |
2489055 | 2489055 | 2022-05-09 | Marshall | South Dakota | 46091 | 793 | 13 |
2489060 | 2489060 | 2022-05-09 | Miner | South Dakota | 46097 | 457 | 13 |
2485798 | 2485798 | 2022-05-08 | Marshall | South Dakota | 46091 | 793 | 13 |
2485803 | 2485803 | 2022-05-08 | Miner | South Dakota | 46097 | 457 | 13 |
2482540 | 2482540 | 2022-05-07 | Marshall | South Dakota | 46091 | 793 | 13 |
2482545 | 2482545 | 2022-05-07 | Miner | South Dakota | 46097 | 457 | 13 |
2479282 | 2479282 | 2022-05-06 | Marshall | South Dakota | 46091 | 793 | 13 |
2479287 | 2479287 | 2022-05-06 | Miner | South Dakota | 46097 | 457 | 13 |
2476024 | 2476024 | 2022-05-05 | Marshall | South Dakota | 46091 | 793 | 13 |
2476029 | 2476029 | 2022-05-05 | Miner | South Dakota | 46097 | 457 | 13 |
2472767 | 2472767 | 2022-05-04 | Marshall | South Dakota | 46091 | 793 | 13 |
2472772 | 2472772 | 2022-05-04 | Miner | South Dakota | 46097 | 457 | 13 |
2469511 | 2469511 | 2022-05-03 | Marshall | South Dakota | 46091 | 788 | 13 |
2469516 | 2469516 | 2022-05-03 | Miner | South Dakota | 46097 | 457 | 13 |
2466255 | 2466255 | 2022-05-02 | Marshall | South Dakota | 46091 | 788 | 13 |
2466260 | 2466260 | 2022-05-02 | Miner | South Dakota | 46097 | 457 | 13 |
2463000 | 2463000 | 2022-05-01 | Marshall | South Dakota | 46091 | 788 | 13 |
2463005 | 2463005 | 2022-05-01 | Miner | South Dakota | 46097 | 457 | 13 |
2459744 | 2459744 | 2022-04-30 | Marshall | South Dakota | 46091 | 788 | 13 |
2459749 | 2459749 | 2022-04-30 | Miner | South Dakota | 46097 | 457 | 13 |
2456488 | 2456488 | 2022-04-29 | Marshall | South Dakota | 46091 | 788 | 13 |
2456493 | 2456493 | 2022-04-29 | Miner | South Dakota | 46097 | 457 | 13 |
2453232 | 2453232 | 2022-04-28 | Marshall | South Dakota | 46091 | 788 | 13 |
2453237 | 2453237 | 2022-04-28 | Miner | South Dakota | 46097 | 457 | 13 |
2449976 | 2449976 | 2022-04-27 | Marshall | South Dakota | 46091 | 788 | 13 |
2449981 | 2449981 | 2022-04-27 | Miner | South Dakota | 46097 | 457 | 13 |
2446719 | 2446719 | 2022-04-26 | Marshall | South Dakota | 46091 | 786 | 13 |
2446724 | 2446724 | 2022-04-26 | Miner | South Dakota | 46097 | 457 | 13 |
2443464 | 2443464 | 2022-04-25 | Marshall | South Dakota | 46091 | 786 | 13 |
2443469 | 2443469 | 2022-04-25 | Miner | South Dakota | 46097 | 457 | 13 |
2440208 | 2440208 | 2022-04-24 | Marshall | South Dakota | 46091 | 786 | 13 |
2440213 | 2440213 | 2022-04-24 | Miner | South Dakota | 46097 | 457 | 13 |
2436952 | 2436952 | 2022-04-23 | Marshall | South Dakota | 46091 | 786 | 13 |
2436957 | 2436957 | 2022-04-23 | Miner | South Dakota | 46097 | 457 | 13 |
2433696 | 2433696 | 2022-04-22 | Marshall | South Dakota | 46091 | 786 | 13 |
2433701 | 2433701 | 2022-04-22 | Miner | South Dakota | 46097 | 457 | 13 |
2430440 | 2430440 | 2022-04-21 | Marshall | South Dakota | 46091 | 786 | 13 |
2430445 | 2430445 | 2022-04-21 | Miner | South Dakota | 46097 | 457 | 13 |
2427184 | 2427184 | 2022-04-20 | Marshall | South Dakota | 46091 | 786 | 13 |
2427189 | 2427189 | 2022-04-20 | Miner | South Dakota | 46097 | 457 | 13 |
2423928 | 2423928 | 2022-04-19 | Marshall | South Dakota | 46091 | 784 | 13 |
2423933 | 2423933 | 2022-04-19 | Miner | South Dakota | 46097 | 456 | 13 |
2420672 | 2420672 | 2022-04-18 | Marshall | South Dakota | 46091 | 784 | 13 |
2420677 | 2420677 | 2022-04-18 | Miner | South Dakota | 46097 | 456 | 13 |
2417416 | 2417416 | 2022-04-17 | Marshall | South Dakota | 46091 | 784 | 13 |
2417421 | 2417421 | 2022-04-17 | Miner | South Dakota | 46097 | 456 | 13 |
2414160 | 2414160 | 2022-04-16 | Marshall | South Dakota | 46091 | 784 | 13 |
2414165 | 2414165 | 2022-04-16 | Miner | South Dakota | 46097 | 456 | 13 |
2410904 | 2410904 | 2022-04-15 | Marshall | South Dakota | 46091 | 784 | 13 |
2410909 | 2410909 | 2022-04-15 | Miner | South Dakota | 46097 | 456 | 13 |
2407648 | 2407648 | 2022-04-14 | Marshall | South Dakota | 46091 | 784 | 13 |
2407653 | 2407653 | 2022-04-14 | Miner | South Dakota | 46097 | 456 | 13 |
2404392 | 2404392 | 2022-04-13 | Marshall | South Dakota | 46091 | 784 | 13 |
2404397 | 2404397 | 2022-04-13 | Miner | South Dakota | 46097 | 456 | 13 |
2401137 | 2401137 | 2022-04-12 | Marshall | South Dakota | 46091 | 784 | 13 |
2401142 | 2401142 | 2022-04-12 | Miner | South Dakota | 46097 | 456 | 13 |
2397882 | 2397882 | 2022-04-11 | Marshall | South Dakota | 46091 | 784 | 13 |
2397887 | 2397887 | 2022-04-11 | Miner | South Dakota | 46097 | 456 | 13 |
2394627 | 2394627 | 2022-04-10 | Marshall | South Dakota | 46091 | 784 | 13 |
2394632 | 2394632 | 2022-04-10 | Miner | South Dakota | 46097 | 456 | 13 |
2391371 | 2391371 | 2022-04-09 | Marshall | South Dakota | 46091 | 784 | 13 |
2391376 | 2391376 | 2022-04-09 | Miner | South Dakota | 46097 | 456 | 13 |
2388115 | 2388115 | 2022-04-08 | Marshall | South Dakota | 46091 | 784 | 13 |
2388120 | 2388120 | 2022-04-08 | Miner | South Dakota | 46097 | 456 | 13 |
2384860 | 2384860 | 2022-04-07 | Marshall | South Dakota | 46091 | 784 | 13 |
2384865 | 2384865 | 2022-04-07 | Miner | South Dakota | 46097 | 456 | 13 |
2381605 | 2381605 | 2022-04-06 | Marshall | South Dakota | 46091 | 784 | 13 |
2381610 | 2381610 | 2022-04-06 | Miner | South Dakota | 46097 | 456 | 13 |
2378350 | 2378350 | 2022-04-05 | Marshall | South Dakota | 46091 | 783 | 13 |
2378355 | 2378355 | 2022-04-05 | Miner | South Dakota | 46097 | 455 | 13 |
2375096 | 2375096 | 2022-04-04 | Marshall | South Dakota | 46091 | 783 | 13 |
2375101 | 2375101 | 2022-04-04 | Miner | South Dakota | 46097 | 455 | 13 |
2371844 | 2371844 | 2022-04-03 | Marshall | South Dakota | 46091 | 783 | 13 |
2371849 | 2371849 | 2022-04-03 | Miner | South Dakota | 46097 | 455 | 13 |
2368591 | 2368591 | 2022-04-02 | Marshall | South Dakota | 46091 | 783 | 13 |
2368596 | 2368596 | 2022-04-02 | Miner | South Dakota | 46097 | 455 | 13 |
2365338 | 2365338 | 2022-04-01 | Marshall | South Dakota | 46091 | 783 | 13 |
2365343 | 2365343 | 2022-04-01 | Miner | South Dakota | 46097 | 455 | 13 |
2362085 | 2362085 | 2022-03-31 | Marshall | South Dakota | 46091 | 783 | 13 |
2362090 | 2362090 | 2022-03-31 | Miner | South Dakota | 46097 | 455 | 13 |
2358831 | 2358831 | 2022-03-30 | Marshall | South Dakota | 46091 | 783 | 13 |
2358836 | 2358836 | 2022-03-30 | Miner | South Dakota | 46097 | 455 | 13 |
2355577 | 2355577 | 2022-03-29 | Marshall | South Dakota | 46091 | 782 | 13 |
2355582 | 2355582 | 2022-03-29 | Miner | South Dakota | 46097 | 455 | 13 |
2352324 | 2352324 | 2022-03-28 | Marshall | South Dakota | 46091 | 782 | 13 |
2352329 | 2352329 | 2022-03-28 | Miner | South Dakota | 46097 | 455 | 13 |
2349072 | 2349072 | 2022-03-27 | Marshall | South Dakota | 46091 | 782 | 13 |
2349077 | 2349077 | 2022-03-27 | Miner | South Dakota | 46097 | 455 | 13 |
2345819 | 2345819 | 2022-03-26 | Marshall | South Dakota | 46091 | 782 | 13 |
2345824 | 2345824 | 2022-03-26 | Miner | South Dakota | 46097 | 455 | 13 |
2342566 | 2342566 | 2022-03-25 | Marshall | South Dakota | 46091 | 782 | 13 |
2342571 | 2342571 | 2022-03-25 | Miner | South Dakota | 46097 | 455 | 13 |
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);