ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 2, fips = 46039 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
796345 | 796345 | 2020-12-04 | Deuel | South Dakota | 46039 | 335 | 2 |
793100 | 793100 | 2020-12-03 | Deuel | South Dakota | 46039 | 332 | 2 |
789855 | 789855 | 2020-12-02 | Deuel | South Dakota | 46039 | 326 | 2 |
786610 | 786610 | 2020-12-01 | Deuel | South Dakota | 46039 | 311 | 2 |
783366 | 783366 | 2020-11-30 | Deuel | South Dakota | 46039 | 311 | 2 |
780121 | 780121 | 2020-11-29 | Deuel | South Dakota | 46039 | 306 | 2 |
776875 | 776875 | 2020-11-28 | Deuel | South Dakota | 46039 | 302 | 2 |
773630 | 773630 | 2020-11-27 | Deuel | South Dakota | 46039 | 297 | 2 |
770385 | 770385 | 2020-11-26 | Deuel | South Dakota | 46039 | 292 | 2 |
767139 | 767139 | 2020-11-25 | Deuel | South Dakota | 46039 | 292 | 2 |
763894 | 763894 | 2020-11-24 | Deuel | South Dakota | 46039 | 287 | 2 |
760649 | 760649 | 2020-11-23 | Deuel | South Dakota | 46039 | 283 | 2 |
757404 | 757404 | 2020-11-22 | Deuel | South Dakota | 46039 | 278 | 2 |
754157 | 754157 | 2020-11-21 | Deuel | South Dakota | 46039 | 277 | 2 |
750911 | 750911 | 2020-11-20 | Deuel | South Dakota | 46039 | 272 | 2 |
747665 | 747665 | 2020-11-19 | Deuel | South Dakota | 46039 | 267 | 2 |
744419 | 744419 | 2020-11-18 | Deuel | South Dakota | 46039 | 265 | 2 |
741172 | 741172 | 2020-11-17 | Deuel | South Dakota | 46039 | 261 | 2 |
737926 | 737926 | 2020-11-16 | Deuel | South Dakota | 46039 | 258 | 2 |
734682 | 734682 | 2020-11-15 | Deuel | South Dakota | 46039 | 254 | 2 |
731436 | 731436 | 2020-11-14 | Deuel | South Dakota | 46039 | 249 | 2 |
728192 | 728192 | 2020-11-13 | Deuel | South Dakota | 46039 | 247 | 2 |
724948 | 724948 | 2020-11-12 | Deuel | South Dakota | 46039 | 238 | 2 |
721705 | 721705 | 2020-11-11 | Deuel | South Dakota | 46039 | 232 | 2 |
718462 | 718462 | 2020-11-10 | Deuel | South Dakota | 46039 | 230 | 2 |
715219 | 715219 | 2020-11-09 | Deuel | South Dakota | 46039 | 226 | 2 |
711975 | 711975 | 2020-11-08 | Deuel | South Dakota | 46039 | 222 | 2 |
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);