ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
830 rows where deaths = 8 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502078 | 2502078 | 2022-05-13 | Hyde | South Dakota | 46069 | 307 | 8 |
2502091 | 2502091 | 2022-05-13 | Mellette | South Dakota | 46095 | 527 | 8 |
2498820 | 2498820 | 2022-05-12 | Hyde | South Dakota | 46069 | 307 | 8 |
2498833 | 2498833 | 2022-05-12 | Mellette | South Dakota | 46095 | 527 | 8 |
2495562 | 2495562 | 2022-05-11 | Hyde | South Dakota | 46069 | 307 | 8 |
2495575 | 2495575 | 2022-05-11 | Mellette | South Dakota | 46095 | 527 | 8 |
2492304 | 2492304 | 2022-05-10 | Hyde | South Dakota | 46069 | 306 | 8 |
2492317 | 2492317 | 2022-05-10 | Mellette | South Dakota | 46095 | 527 | 8 |
2489046 | 2489046 | 2022-05-09 | Hyde | South Dakota | 46069 | 306 | 8 |
2489059 | 2489059 | 2022-05-09 | Mellette | South Dakota | 46095 | 527 | 8 |
2485789 | 2485789 | 2022-05-08 | Hyde | South Dakota | 46069 | 306 | 8 |
2485802 | 2485802 | 2022-05-08 | Mellette | South Dakota | 46095 | 527 | 8 |
2482531 | 2482531 | 2022-05-07 | Hyde | South Dakota | 46069 | 306 | 8 |
2482544 | 2482544 | 2022-05-07 | Mellette | South Dakota | 46095 | 527 | 8 |
2479273 | 2479273 | 2022-05-06 | Hyde | South Dakota | 46069 | 306 | 8 |
2479286 | 2479286 | 2022-05-06 | Mellette | South Dakota | 46095 | 527 | 8 |
2476015 | 2476015 | 2022-05-05 | Hyde | South Dakota | 46069 | 306 | 8 |
2476028 | 2476028 | 2022-05-05 | Mellette | South Dakota | 46095 | 527 | 8 |
2472758 | 2472758 | 2022-05-04 | Hyde | South Dakota | 46069 | 306 | 8 |
2472771 | 2472771 | 2022-05-04 | Mellette | South Dakota | 46095 | 527 | 8 |
2469502 | 2469502 | 2022-05-03 | Hyde | South Dakota | 46069 | 306 | 8 |
2469515 | 2469515 | 2022-05-03 | Mellette | South Dakota | 46095 | 527 | 8 |
2466246 | 2466246 | 2022-05-02 | Hyde | South Dakota | 46069 | 306 | 8 |
2466259 | 2466259 | 2022-05-02 | Mellette | South Dakota | 46095 | 527 | 8 |
2462991 | 2462991 | 2022-05-01 | Hyde | South Dakota | 46069 | 306 | 8 |
2463004 | 2463004 | 2022-05-01 | Mellette | South Dakota | 46095 | 527 | 8 |
2459735 | 2459735 | 2022-04-30 | Hyde | South Dakota | 46069 | 306 | 8 |
2459748 | 2459748 | 2022-04-30 | Mellette | South Dakota | 46095 | 527 | 8 |
2456479 | 2456479 | 2022-04-29 | Hyde | South Dakota | 46069 | 306 | 8 |
2456492 | 2456492 | 2022-04-29 | Mellette | South Dakota | 46095 | 527 | 8 |
2453223 | 2453223 | 2022-04-28 | Hyde | South Dakota | 46069 | 306 | 8 |
2453236 | 2453236 | 2022-04-28 | Mellette | South Dakota | 46095 | 527 | 8 |
2449967 | 2449967 | 2022-04-27 | Hyde | South Dakota | 46069 | 306 | 8 |
2449980 | 2449980 | 2022-04-27 | Mellette | South Dakota | 46095 | 527 | 8 |
2446710 | 2446710 | 2022-04-26 | Hyde | South Dakota | 46069 | 306 | 8 |
2446723 | 2446723 | 2022-04-26 | Mellette | South Dakota | 46095 | 527 | 8 |
2443455 | 2443455 | 2022-04-25 | Hyde | South Dakota | 46069 | 306 | 8 |
2443468 | 2443468 | 2022-04-25 | Mellette | South Dakota | 46095 | 527 | 8 |
2440199 | 2440199 | 2022-04-24 | Hyde | South Dakota | 46069 | 306 | 8 |
2440212 | 2440212 | 2022-04-24 | Mellette | South Dakota | 46095 | 527 | 8 |
2436943 | 2436943 | 2022-04-23 | Hyde | South Dakota | 46069 | 306 | 8 |
2436956 | 2436956 | 2022-04-23 | Mellette | South Dakota | 46095 | 527 | 8 |
2433687 | 2433687 | 2022-04-22 | Hyde | South Dakota | 46069 | 306 | 8 |
2433700 | 2433700 | 2022-04-22 | Mellette | South Dakota | 46095 | 527 | 8 |
2430431 | 2430431 | 2022-04-21 | Hyde | South Dakota | 46069 | 306 | 8 |
2430444 | 2430444 | 2022-04-21 | Mellette | South Dakota | 46095 | 527 | 8 |
2427175 | 2427175 | 2022-04-20 | Hyde | South Dakota | 46069 | 306 | 8 |
2427188 | 2427188 | 2022-04-20 | Mellette | South Dakota | 46095 | 527 | 8 |
2423919 | 2423919 | 2022-04-19 | Hyde | South Dakota | 46069 | 306 | 8 |
2423932 | 2423932 | 2022-04-19 | Mellette | South Dakota | 46095 | 527 | 8 |
2420663 | 2420663 | 2022-04-18 | Hyde | South Dakota | 46069 | 306 | 8 |
2420676 | 2420676 | 2022-04-18 | Mellette | South Dakota | 46095 | 527 | 8 |
2417407 | 2417407 | 2022-04-17 | Hyde | South Dakota | 46069 | 306 | 8 |
2417420 | 2417420 | 2022-04-17 | Mellette | South Dakota | 46095 | 527 | 8 |
2414151 | 2414151 | 2022-04-16 | Hyde | South Dakota | 46069 | 306 | 8 |
2414164 | 2414164 | 2022-04-16 | Mellette | South Dakota | 46095 | 527 | 8 |
2410895 | 2410895 | 2022-04-15 | Hyde | South Dakota | 46069 | 306 | 8 |
2410908 | 2410908 | 2022-04-15 | Mellette | South Dakota | 46095 | 527 | 8 |
2407639 | 2407639 | 2022-04-14 | Hyde | South Dakota | 46069 | 306 | 8 |
2407652 | 2407652 | 2022-04-14 | Mellette | South Dakota | 46095 | 527 | 8 |
2404383 | 2404383 | 2022-04-13 | Hyde | South Dakota | 46069 | 306 | 8 |
2404396 | 2404396 | 2022-04-13 | Mellette | South Dakota | 46095 | 527 | 8 |
2401128 | 2401128 | 2022-04-12 | Hyde | South Dakota | 46069 | 306 | 8 |
2401141 | 2401141 | 2022-04-12 | Mellette | South Dakota | 46095 | 527 | 8 |
2397873 | 2397873 | 2022-04-11 | Hyde | South Dakota | 46069 | 306 | 8 |
2397886 | 2397886 | 2022-04-11 | Mellette | South Dakota | 46095 | 527 | 8 |
2394618 | 2394618 | 2022-04-10 | Hyde | South Dakota | 46069 | 306 | 8 |
2394631 | 2394631 | 2022-04-10 | Mellette | South Dakota | 46095 | 527 | 8 |
2391362 | 2391362 | 2022-04-09 | Hyde | South Dakota | 46069 | 306 | 8 |
2391375 | 2391375 | 2022-04-09 | Mellette | South Dakota | 46095 | 527 | 8 |
2388106 | 2388106 | 2022-04-08 | Hyde | South Dakota | 46069 | 306 | 8 |
2388119 | 2388119 | 2022-04-08 | Mellette | South Dakota | 46095 | 527 | 8 |
2384851 | 2384851 | 2022-04-07 | Hyde | South Dakota | 46069 | 306 | 8 |
2384864 | 2384864 | 2022-04-07 | Mellette | South Dakota | 46095 | 527 | 8 |
2381596 | 2381596 | 2022-04-06 | Hyde | South Dakota | 46069 | 306 | 8 |
2381609 | 2381609 | 2022-04-06 | Mellette | South Dakota | 46095 | 527 | 8 |
2378341 | 2378341 | 2022-04-05 | Hyde | South Dakota | 46069 | 306 | 8 |
2378354 | 2378354 | 2022-04-05 | Mellette | South Dakota | 46095 | 526 | 8 |
2375087 | 2375087 | 2022-04-04 | Hyde | South Dakota | 46069 | 306 | 8 |
2375100 | 2375100 | 2022-04-04 | Mellette | South Dakota | 46095 | 526 | 8 |
2371835 | 2371835 | 2022-04-03 | Hyde | South Dakota | 46069 | 306 | 8 |
2371848 | 2371848 | 2022-04-03 | Mellette | South Dakota | 46095 | 526 | 8 |
2368582 | 2368582 | 2022-04-02 | Hyde | South Dakota | 46069 | 306 | 8 |
2368595 | 2368595 | 2022-04-02 | Mellette | South Dakota | 46095 | 526 | 8 |
2365329 | 2365329 | 2022-04-01 | Hyde | South Dakota | 46069 | 306 | 8 |
2365342 | 2365342 | 2022-04-01 | Mellette | South Dakota | 46095 | 526 | 8 |
2362076 | 2362076 | 2022-03-31 | Hyde | South Dakota | 46069 | 306 | 8 |
2362089 | 2362089 | 2022-03-31 | Mellette | South Dakota | 46095 | 526 | 8 |
2358822 | 2358822 | 2022-03-30 | Hyde | South Dakota | 46069 | 306 | 8 |
2358835 | 2358835 | 2022-03-30 | Mellette | South Dakota | 46095 | 526 | 8 |
2355568 | 2355568 | 2022-03-29 | Hyde | South Dakota | 46069 | 306 | 8 |
2355581 | 2355581 | 2022-03-29 | Mellette | South Dakota | 46095 | 525 | 8 |
2352315 | 2352315 | 2022-03-28 | Hyde | South Dakota | 46069 | 306 | 8 |
2352328 | 2352328 | 2022-03-28 | Mellette | South Dakota | 46095 | 525 | 8 |
2349063 | 2349063 | 2022-03-27 | Hyde | South Dakota | 46069 | 306 | 8 |
2349076 | 2349076 | 2022-03-27 | Mellette | South Dakota | 46095 | 525 | 8 |
2345810 | 2345810 | 2022-03-26 | Hyde | South Dakota | 46069 | 306 | 8 |
2345823 | 2345823 | 2022-03-26 | Mellette | South Dakota | 46095 | 525 | 8 |
2342557 | 2342557 | 2022-03-25 | Hyde | South Dakota | 46069 | 306 | 8 |
2342570 | 2342570 | 2022-03-25 | Mellette | South Dakota | 46095 | 525 | 8 |
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);