ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where deaths = 1, fips = 46035 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 |
---|---|---|---|---|---|---|---|
449604 | 449604 | 2020-08-19 | Davison | South Dakota | 46035 | 101 | 1 |
446376 | 446376 | 2020-08-18 | Davison | South Dakota | 46035 | 101 | 1 |
443150 | 443150 | 2020-08-17 | Davison | South Dakota | 46035 | 101 | 1 |
439923 | 439923 | 2020-08-16 | Davison | South Dakota | 46035 | 100 | 1 |
436698 | 436698 | 2020-08-15 | Davison | South Dakota | 46035 | 100 | 1 |
433471 | 433471 | 2020-08-14 | Davison | South Dakota | 46035 | 99 | 1 |
430246 | 430246 | 2020-08-13 | Davison | South Dakota | 46035 | 99 | 1 |
427020 | 427020 | 2020-08-12 | Davison | South Dakota | 46035 | 96 | 1 |
423797 | 423797 | 2020-08-11 | Davison | South Dakota | 46035 | 96 | 1 |
420575 | 420575 | 2020-08-10 | Davison | South Dakota | 46035 | 97 | 1 |
417354 | 417354 | 2020-08-09 | Davison | South Dakota | 46035 | 97 | 1 |
414133 | 414133 | 2020-08-08 | Davison | South Dakota | 46035 | 94 | 1 |
401256 | 401256 | 2020-08-04 | Davison | South Dakota | 46035 | 93 | 1 |
398041 | 398041 | 2020-08-03 | Davison | South Dakota | 46035 | 88 | 1 |
394824 | 394824 | 2020-08-02 | Davison | South Dakota | 46035 | 88 | 1 |
391608 | 391608 | 2020-08-01 | Davison | South Dakota | 46035 | 87 | 1 |
388391 | 388391 | 2020-07-31 | Davison | South Dakota | 46035 | 86 | 1 |
385174 | 385174 | 2020-07-30 | Davison | South Dakota | 46035 | 84 | 1 |
381956 | 381956 | 2020-07-29 | Davison | South Dakota | 46035 | 83 | 1 |
378739 | 378739 | 2020-07-28 | Davison | South Dakota | 46035 | 81 | 1 |
375523 | 375523 | 2020-07-27 | Davison | South Dakota | 46035 | 81 | 1 |
372310 | 372310 | 2020-07-26 | Davison | South Dakota | 46035 | 81 | 1 |
369098 | 369098 | 2020-07-25 | Davison | South Dakota | 46035 | 78 | 1 |
365889 | 365889 | 2020-07-24 | Davison | South Dakota | 46035 | 76 | 1 |
362683 | 362683 | 2020-07-23 | Davison | South Dakota | 46035 | 75 | 1 |
359477 | 359477 | 2020-07-22 | Davison | South Dakota | 46035 | 73 | 1 |
356273 | 356273 | 2020-07-21 | Davison | South Dakota | 46035 | 71 | 1 |
353070 | 353070 | 2020-07-20 | Davison | South Dakota | 46035 | 69 | 1 |
349867 | 349867 | 2020-07-19 | Davison | South Dakota | 46035 | 67 | 1 |
346667 | 346667 | 2020-07-18 | Davison | South Dakota | 46035 | 66 | 1 |
343467 | 343467 | 2020-07-17 | Davison | South Dakota | 46035 | 65 | 1 |
340269 | 340269 | 2020-07-16 | Davison | South Dakota | 46035 | 57 | 1 |
337072 | 337072 | 2020-07-15 | Davison | South Dakota | 46035 | 57 | 1 |
333878 | 333878 | 2020-07-14 | Davison | South Dakota | 46035 | 57 | 1 |
330686 | 330686 | 2020-07-13 | Davison | South Dakota | 46035 | 56 | 1 |
327500 | 327500 | 2020-07-12 | Davison | South Dakota | 46035 | 55 | 1 |
324315 | 324315 | 2020-07-11 | Davison | South Dakota | 46035 | 54 | 1 |
321135 | 321135 | 2020-07-10 | Davison | South Dakota | 46035 | 52 | 1 |
317957 | 317957 | 2020-07-09 | Davison | South Dakota | 46035 | 51 | 1 |
314784 | 314784 | 2020-07-08 | Davison | South Dakota | 46035 | 50 | 1 |
311611 | 311611 | 2020-07-07 | Davison | South Dakota | 46035 | 47 | 1 |
308442 | 308442 | 2020-07-06 | Davison | South Dakota | 46035 | 47 | 1 |
305275 | 305275 | 2020-07-05 | Davison | South Dakota | 46035 | 46 | 1 |
302112 | 302112 | 2020-07-04 | Davison | South Dakota | 46035 | 44 | 1 |
298948 | 298948 | 2020-07-03 | Davison | South Dakota | 46035 | 44 | 1 |
295788 | 295788 | 2020-07-02 | Davison | South Dakota | 46035 | 43 | 1 |
292632 | 292632 | 2020-07-01 | Davison | South Dakota | 46035 | 41 | 1 |
289480 | 289480 | 2020-06-30 | Davison | South Dakota | 46035 | 41 | 1 |
286329 | 286329 | 2020-06-29 | Davison | South Dakota | 46035 | 40 | 1 |
283184 | 283184 | 2020-06-28 | Davison | South Dakota | 46035 | 39 | 1 |
280038 | 280038 | 2020-06-27 | Davison | South Dakota | 46035 | 37 | 1 |
276890 | 276890 | 2020-06-26 | Davison | South Dakota | 46035 | 36 | 1 |
273743 | 273743 | 2020-06-25 | Davison | South Dakota | 46035 | 35 | 1 |
270604 | 270604 | 2020-06-24 | Davison | South Dakota | 46035 | 35 | 1 |
267470 | 267470 | 2020-06-23 | Davison | South Dakota | 46035 | 35 | 1 |
264342 | 264342 | 2020-06-22 | Davison | South Dakota | 46035 | 35 | 1 |
261214 | 261214 | 2020-06-21 | Davison | South Dakota | 46035 | 35 | 1 |
258087 | 258087 | 2020-06-20 | Davison | South Dakota | 46035 | 34 | 1 |
254961 | 254961 | 2020-06-19 | Davison | South Dakota | 46035 | 33 | 1 |
251846 | 251846 | 2020-06-18 | Davison | South Dakota | 46035 | 33 | 1 |
248731 | 248731 | 2020-06-17 | Davison | South Dakota | 46035 | 33 | 1 |
245618 | 245618 | 2020-06-16 | Davison | South Dakota | 46035 | 33 | 1 |
242506 | 242506 | 2020-06-15 | Davison | South Dakota | 46035 | 33 | 1 |
239396 | 239396 | 2020-06-14 | Davison | South Dakota | 46035 | 32 | 1 |
236288 | 236288 | 2020-06-13 | Davison | South Dakota | 46035 | 32 | 1 |
233183 | 233183 | 2020-06-12 | Davison | South Dakota | 46035 | 31 | 1 |
230078 | 230078 | 2020-06-11 | Davison | South Dakota | 46035 | 30 | 1 |
226974 | 226974 | 2020-06-10 | Davison | South Dakota | 46035 | 30 | 1 |
223874 | 223874 | 2020-06-09 | Davison | South Dakota | 46035 | 30 | 1 |
220779 | 220779 | 2020-06-08 | Davison | South Dakota | 46035 | 30 | 1 |
217687 | 217687 | 2020-06-07 | Davison | South Dakota | 46035 | 27 | 1 |
214597 | 214597 | 2020-06-06 | Davison | South Dakota | 46035 | 27 | 1 |
211511 | 211511 | 2020-06-05 | Davison | South Dakota | 46035 | 24 | 1 |
208429 | 208429 | 2020-06-04 | Davison | South Dakota | 46035 | 20 | 1 |
205347 | 205347 | 2020-06-03 | Davison | South Dakota | 46035 | 20 | 1 |
202269 | 202269 | 2020-06-02 | Davison | South Dakota | 46035 | 16 | 1 |
199194 | 199194 | 2020-06-01 | Davison | South Dakota | 46035 | 16 | 1 |
196121 | 196121 | 2020-05-31 | Davison | South Dakota | 46035 | 16 | 1 |
193052 | 193052 | 2020-05-30 | Davison | South Dakota | 46035 | 15 | 1 |
189987 | 189987 | 2020-05-29 | Davison | South Dakota | 46035 | 14 | 1 |
186925 | 186925 | 2020-05-28 | Davison | South Dakota | 46035 | 13 | 1 |
183868 | 183868 | 2020-05-27 | Davison | South Dakota | 46035 | 11 | 1 |
180818 | 180818 | 2020-05-26 | Davison | South Dakota | 46035 | 10 | 1 |
177775 | 177775 | 2020-05-25 | Davison | South Dakota | 46035 | 9 | 1 |
174731 | 174731 | 2020-05-24 | Davison | South Dakota | 46035 | 9 | 1 |
171689 | 171689 | 2020-05-23 | Davison | South Dakota | 46035 | 9 | 1 |
162585 | 162585 | 2020-05-20 | Davison | South Dakota | 46035 | 9 | 1 |
159558 | 159558 | 2020-05-19 | Davison | South Dakota | 46035 | 9 | 1 |
156537 | 156537 | 2020-05-18 | Davison | South Dakota | 46035 | 9 | 1 |
153520 | 153520 | 2020-05-17 | Davison | South Dakota | 46035 | 9 | 1 |
150509 | 150509 | 2020-05-16 | Davison | South Dakota | 46035 | 9 | 1 |
147501 | 147501 | 2020-05-15 | Davison | South Dakota | 46035 | 9 | 1 |
144500 | 144500 | 2020-05-14 | Davison | South Dakota | 46035 | 9 | 1 |
141504 | 141504 | 2020-05-13 | Davison | South Dakota | 46035 | 8 | 1 |
138508 | 138508 | 2020-05-12 | Davison | South Dakota | 46035 | 8 | 1 |
135518 | 135518 | 2020-05-11 | Davison | South Dakota | 46035 | 7 | 1 |
132527 | 132527 | 2020-05-10 | Davison | South Dakota | 46035 | 7 | 1 |
129538 | 129538 | 2020-05-09 | Davison | South Dakota | 46035 | 7 | 1 |
126549 | 126549 | 2020-05-08 | Davison | South Dakota | 46035 | 7 | 1 |
123566 | 123566 | 2020-05-07 | Davison | South Dakota | 46035 | 7 | 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);