ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where county = "Todd", deaths = 1, fips = 46121 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 |
---|---|---|---|---|---|---|---|
314824 | 314824 | 2020-07-08 | Todd | South Dakota | 46121 | 59 | 1 |
311650 | 311650 | 2020-07-07 | Todd | South Dakota | 46121 | 57 | 1 |
308481 | 308481 | 2020-07-06 | Todd | South Dakota | 46121 | 57 | 1 |
305313 | 305313 | 2020-07-05 | Todd | South Dakota | 46121 | 57 | 1 |
302150 | 302150 | 2020-07-04 | Todd | South Dakota | 46121 | 57 | 1 |
298986 | 298986 | 2020-07-03 | Todd | South Dakota | 46121 | 57 | 1 |
295826 | 295826 | 2020-07-02 | Todd | South Dakota | 46121 | 57 | 1 |
292670 | 292670 | 2020-07-01 | Todd | South Dakota | 46121 | 57 | 1 |
289518 | 289518 | 2020-06-30 | Todd | South Dakota | 46121 | 57 | 1 |
286367 | 286367 | 2020-06-29 | Todd | South Dakota | 46121 | 57 | 1 |
283222 | 283222 | 2020-06-28 | Todd | South Dakota | 46121 | 56 | 1 |
280076 | 280076 | 2020-06-27 | Todd | South Dakota | 46121 | 56 | 1 |
276928 | 276928 | 2020-06-26 | Todd | South Dakota | 46121 | 53 | 1 |
273781 | 273781 | 2020-06-25 | Todd | South Dakota | 46121 | 52 | 1 |
270642 | 270642 | 2020-06-24 | Todd | South Dakota | 46121 | 51 | 1 |
267508 | 267508 | 2020-06-23 | Todd | South Dakota | 46121 | 50 | 1 |
264380 | 264380 | 2020-06-22 | Todd | South Dakota | 46121 | 50 | 1 |
261252 | 261252 | 2020-06-21 | Todd | South Dakota | 46121 | 50 | 1 |
258125 | 258125 | 2020-06-20 | Todd | South Dakota | 46121 | 50 | 1 |
254999 | 254999 | 2020-06-19 | Todd | South Dakota | 46121 | 50 | 1 |
251884 | 251884 | 2020-06-18 | Todd | South Dakota | 46121 | 50 | 1 |
248769 | 248769 | 2020-06-17 | Todd | South Dakota | 46121 | 50 | 1 |
245656 | 245656 | 2020-06-16 | Todd | South Dakota | 46121 | 48 | 1 |
242544 | 242544 | 2020-06-15 | Todd | South Dakota | 46121 | 47 | 1 |
239434 | 239434 | 2020-06-14 | Todd | South Dakota | 46121 | 47 | 1 |
236326 | 236326 | 2020-06-13 | Todd | South Dakota | 46121 | 47 | 1 |
233220 | 233220 | 2020-06-12 | Todd | South Dakota | 46121 | 46 | 1 |
230115 | 230115 | 2020-06-11 | Todd | South Dakota | 46121 | 45 | 1 |
227011 | 227011 | 2020-06-10 | Todd | South Dakota | 46121 | 44 | 1 |
223911 | 223911 | 2020-06-09 | Todd | South Dakota | 46121 | 42 | 1 |
220816 | 220816 | 2020-06-08 | Todd | South Dakota | 46121 | 38 | 1 |
217724 | 217724 | 2020-06-07 | Todd | South Dakota | 46121 | 37 | 1 |
214634 | 214634 | 2020-06-06 | Todd | South Dakota | 46121 | 36 | 1 |
211547 | 211547 | 2020-06-05 | Todd | South Dakota | 46121 | 33 | 1 |
208465 | 208465 | 2020-06-04 | Todd | South Dakota | 46121 | 31 | 1 |
205383 | 205383 | 2020-06-03 | Todd | South Dakota | 46121 | 28 | 1 |
202304 | 202304 | 2020-06-02 | Todd | South Dakota | 46121 | 28 | 1 |
199229 | 199229 | 2020-06-01 | Todd | South Dakota | 46121 | 27 | 1 |
196156 | 196156 | 2020-05-31 | Todd | South Dakota | 46121 | 27 | 1 |
193086 | 193086 | 2020-05-30 | Todd | South Dakota | 46121 | 26 | 1 |
190021 | 190021 | 2020-05-29 | Todd | South Dakota | 46121 | 23 | 1 |
186957 | 186957 | 2020-05-28 | Todd | South Dakota | 46121 | 23 | 1 |
183900 | 183900 | 2020-05-27 | Todd | South Dakota | 46121 | 22 | 1 |
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);