ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,106 rows where deaths = 12 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 |
---|---|---|---|---|---|---|---|
2502063 | 2502063 | 2022-05-13 | Deuel | South Dakota | 46039 | 1043 | 12 |
2502071 | 2502071 | 2022-05-13 | Haakon | South Dakota | 46055 | 452 | 12 |
2502073 | 2502073 | 2022-05-13 | Hand | South Dakota | 46059 | 562 | 12 |
2502086 | 2502086 | 2022-05-13 | Lyman | South Dakota | 46085 | 1205 | 12 |
2498805 | 2498805 | 2022-05-12 | Deuel | South Dakota | 46039 | 1043 | 12 |
2498813 | 2498813 | 2022-05-12 | Haakon | South Dakota | 46055 | 452 | 12 |
2498815 | 2498815 | 2022-05-12 | Hand | South Dakota | 46059 | 562 | 12 |
2498828 | 2498828 | 2022-05-12 | Lyman | South Dakota | 46085 | 1205 | 12 |
2495547 | 2495547 | 2022-05-11 | Deuel | South Dakota | 46039 | 1043 | 12 |
2495555 | 2495555 | 2022-05-11 | Haakon | South Dakota | 46055 | 452 | 12 |
2495557 | 2495557 | 2022-05-11 | Hand | South Dakota | 46059 | 562 | 12 |
2495570 | 2495570 | 2022-05-11 | Lyman | South Dakota | 46085 | 1205 | 12 |
2492289 | 2492289 | 2022-05-10 | Deuel | South Dakota | 46039 | 1042 | 12 |
2492297 | 2492297 | 2022-05-10 | Haakon | South Dakota | 46055 | 452 | 12 |
2492299 | 2492299 | 2022-05-10 | Hand | South Dakota | 46059 | 562 | 12 |
2492312 | 2492312 | 2022-05-10 | Lyman | South Dakota | 46085 | 1203 | 12 |
2489031 | 2489031 | 2022-05-09 | Deuel | South Dakota | 46039 | 1042 | 12 |
2489039 | 2489039 | 2022-05-09 | Haakon | South Dakota | 46055 | 452 | 12 |
2489041 | 2489041 | 2022-05-09 | Hand | South Dakota | 46059 | 562 | 12 |
2489054 | 2489054 | 2022-05-09 | Lyman | South Dakota | 46085 | 1203 | 12 |
2485774 | 2485774 | 2022-05-08 | Deuel | South Dakota | 46039 | 1042 | 12 |
2485782 | 2485782 | 2022-05-08 | Haakon | South Dakota | 46055 | 452 | 12 |
2485784 | 2485784 | 2022-05-08 | Hand | South Dakota | 46059 | 562 | 12 |
2485797 | 2485797 | 2022-05-08 | Lyman | South Dakota | 46085 | 1203 | 12 |
2482516 | 2482516 | 2022-05-07 | Deuel | South Dakota | 46039 | 1042 | 12 |
2482524 | 2482524 | 2022-05-07 | Haakon | South Dakota | 46055 | 452 | 12 |
2482526 | 2482526 | 2022-05-07 | Hand | South Dakota | 46059 | 562 | 12 |
2482539 | 2482539 | 2022-05-07 | Lyman | South Dakota | 46085 | 1203 | 12 |
2479258 | 2479258 | 2022-05-06 | Deuel | South Dakota | 46039 | 1042 | 12 |
2479266 | 2479266 | 2022-05-06 | Haakon | South Dakota | 46055 | 452 | 12 |
2479268 | 2479268 | 2022-05-06 | Hand | South Dakota | 46059 | 562 | 12 |
2479281 | 2479281 | 2022-05-06 | Lyman | South Dakota | 46085 | 1203 | 12 |
2476000 | 2476000 | 2022-05-05 | Deuel | South Dakota | 46039 | 1042 | 12 |
2476008 | 2476008 | 2022-05-05 | Haakon | South Dakota | 46055 | 452 | 12 |
2476010 | 2476010 | 2022-05-05 | Hand | South Dakota | 46059 | 562 | 12 |
2476023 | 2476023 | 2022-05-05 | Lyman | South Dakota | 46085 | 1203 | 12 |
2472743 | 2472743 | 2022-05-04 | Deuel | South Dakota | 46039 | 1042 | 12 |
2472751 | 2472751 | 2022-05-04 | Haakon | South Dakota | 46055 | 452 | 12 |
2472753 | 2472753 | 2022-05-04 | Hand | South Dakota | 46059 | 562 | 12 |
2472766 | 2472766 | 2022-05-04 | Lyman | South Dakota | 46085 | 1203 | 12 |
2469487 | 2469487 | 2022-05-03 | Deuel | South Dakota | 46039 | 1038 | 12 |
2469495 | 2469495 | 2022-05-03 | Haakon | South Dakota | 46055 | 452 | 12 |
2469497 | 2469497 | 2022-05-03 | Hand | South Dakota | 46059 | 562 | 12 |
2469510 | 2469510 | 2022-05-03 | Lyman | South Dakota | 46085 | 1203 | 12 |
2466231 | 2466231 | 2022-05-02 | Deuel | South Dakota | 46039 | 1038 | 12 |
2466239 | 2466239 | 2022-05-02 | Haakon | South Dakota | 46055 | 452 | 12 |
2466241 | 2466241 | 2022-05-02 | Hand | South Dakota | 46059 | 562 | 12 |
2466254 | 2466254 | 2022-05-02 | Lyman | South Dakota | 46085 | 1203 | 12 |
2462976 | 2462976 | 2022-05-01 | Deuel | South Dakota | 46039 | 1038 | 12 |
2462984 | 2462984 | 2022-05-01 | Haakon | South Dakota | 46055 | 452 | 12 |
2462986 | 2462986 | 2022-05-01 | Hand | South Dakota | 46059 | 562 | 12 |
2462999 | 2462999 | 2022-05-01 | Lyman | South Dakota | 46085 | 1203 | 12 |
2459720 | 2459720 | 2022-04-30 | Deuel | South Dakota | 46039 | 1038 | 12 |
2459728 | 2459728 | 2022-04-30 | Haakon | South Dakota | 46055 | 452 | 12 |
2459730 | 2459730 | 2022-04-30 | Hand | South Dakota | 46059 | 562 | 12 |
2459743 | 2459743 | 2022-04-30 | Lyman | South Dakota | 46085 | 1203 | 12 |
2456464 | 2456464 | 2022-04-29 | Deuel | South Dakota | 46039 | 1038 | 12 |
2456472 | 2456472 | 2022-04-29 | Haakon | South Dakota | 46055 | 452 | 12 |
2456474 | 2456474 | 2022-04-29 | Hand | South Dakota | 46059 | 562 | 12 |
2456487 | 2456487 | 2022-04-29 | Lyman | South Dakota | 46085 | 1203 | 12 |
2453208 | 2453208 | 2022-04-28 | Deuel | South Dakota | 46039 | 1038 | 12 |
2453216 | 2453216 | 2022-04-28 | Haakon | South Dakota | 46055 | 452 | 12 |
2453218 | 2453218 | 2022-04-28 | Hand | South Dakota | 46059 | 562 | 12 |
2453231 | 2453231 | 2022-04-28 | Lyman | South Dakota | 46085 | 1203 | 12 |
2449952 | 2449952 | 2022-04-27 | Deuel | South Dakota | 46039 | 1038 | 12 |
2449960 | 2449960 | 2022-04-27 | Haakon | South Dakota | 46055 | 452 | 12 |
2449962 | 2449962 | 2022-04-27 | Hand | South Dakota | 46059 | 562 | 12 |
2449975 | 2449975 | 2022-04-27 | Lyman | South Dakota | 46085 | 1203 | 12 |
2446695 | 2446695 | 2022-04-26 | Deuel | South Dakota | 46039 | 1037 | 12 |
2446703 | 2446703 | 2022-04-26 | Haakon | South Dakota | 46055 | 451 | 12 |
2446705 | 2446705 | 2022-04-26 | Hand | South Dakota | 46059 | 562 | 12 |
2446718 | 2446718 | 2022-04-26 | Lyman | South Dakota | 46085 | 1203 | 12 |
2443440 | 2443440 | 2022-04-25 | Deuel | South Dakota | 46039 | 1037 | 12 |
2443448 | 2443448 | 2022-04-25 | Haakon | South Dakota | 46055 | 451 | 12 |
2443450 | 2443450 | 2022-04-25 | Hand | South Dakota | 46059 | 562 | 12 |
2443463 | 2443463 | 2022-04-25 | Lyman | South Dakota | 46085 | 1203 | 12 |
2440184 | 2440184 | 2022-04-24 | Deuel | South Dakota | 46039 | 1037 | 12 |
2440192 | 2440192 | 2022-04-24 | Haakon | South Dakota | 46055 | 451 | 12 |
2440194 | 2440194 | 2022-04-24 | Hand | South Dakota | 46059 | 562 | 12 |
2440207 | 2440207 | 2022-04-24 | Lyman | South Dakota | 46085 | 1203 | 12 |
2436928 | 2436928 | 2022-04-23 | Deuel | South Dakota | 46039 | 1037 | 12 |
2436936 | 2436936 | 2022-04-23 | Haakon | South Dakota | 46055 | 451 | 12 |
2436938 | 2436938 | 2022-04-23 | Hand | South Dakota | 46059 | 562 | 12 |
2436951 | 2436951 | 2022-04-23 | Lyman | South Dakota | 46085 | 1203 | 12 |
2433672 | 2433672 | 2022-04-22 | Deuel | South Dakota | 46039 | 1037 | 12 |
2433680 | 2433680 | 2022-04-22 | Haakon | South Dakota | 46055 | 451 | 12 |
2433682 | 2433682 | 2022-04-22 | Hand | South Dakota | 46059 | 562 | 12 |
2433695 | 2433695 | 2022-04-22 | Lyman | South Dakota | 46085 | 1203 | 12 |
2430416 | 2430416 | 2022-04-21 | Deuel | South Dakota | 46039 | 1037 | 12 |
2430424 | 2430424 | 2022-04-21 | Haakon | South Dakota | 46055 | 451 | 12 |
2430426 | 2430426 | 2022-04-21 | Hand | South Dakota | 46059 | 562 | 12 |
2430439 | 2430439 | 2022-04-21 | Lyman | South Dakota | 46085 | 1203 | 12 |
2427160 | 2427160 | 2022-04-20 | Deuel | South Dakota | 46039 | 1037 | 12 |
2427168 | 2427168 | 2022-04-20 | Haakon | South Dakota | 46055 | 451 | 12 |
2427170 | 2427170 | 2022-04-20 | Hand | South Dakota | 46059 | 562 | 12 |
2427183 | 2427183 | 2022-04-20 | Lyman | South Dakota | 46085 | 1203 | 12 |
2423904 | 2423904 | 2022-04-19 | Deuel | South Dakota | 46039 | 1036 | 12 |
2423912 | 2423912 | 2022-04-19 | Haakon | South Dakota | 46055 | 451 | 12 |
2423914 | 2423914 | 2022-04-19 | Hand | South Dakota | 46059 | 561 | 12 |
2423927 | 2423927 | 2022-04-19 | Lyman | South Dakota | 46085 | 1203 | 12 |
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);