ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Hutchinson" 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 |
---|---|---|---|---|---|---|---|
536907 | 536907 | 2020-09-15 | Hutchinson | South Dakota | 46067 | 64 | 1 |
533671 | 533671 | 2020-09-14 | Hutchinson | South Dakota | 46067 | 64 | 1 |
530436 | 530436 | 2020-09-13 | Hutchinson | South Dakota | 46067 | 64 | 1 |
527199 | 527199 | 2020-09-12 | Hutchinson | South Dakota | 46067 | 61 | 1 |
523963 | 523963 | 2020-09-11 | Hutchinson | South Dakota | 46067 | 60 | 1 |
520727 | 520727 | 2020-09-10 | Hutchinson | South Dakota | 46067 | 58 | 1 |
517491 | 517491 | 2020-09-09 | Hutchinson | South Dakota | 46067 | 57 | 1 |
514256 | 514256 | 2020-09-08 | Hutchinson | South Dakota | 46067 | 57 | 1 |
511023 | 511023 | 2020-09-07 | Hutchinson | South Dakota | 46067 | 56 | 1 |
507790 | 507790 | 2020-09-06 | Hutchinson | South Dakota | 46067 | 56 | 1 |
504558 | 504558 | 2020-09-05 | Hutchinson | South Dakota | 46067 | 55 | 1 |
501324 | 501324 | 2020-09-04 | Hutchinson | South Dakota | 46067 | 51 | 1 |
498090 | 498090 | 2020-09-03 | Hutchinson | South Dakota | 46067 | 49 | 1 |
494857 | 494857 | 2020-09-02 | Hutchinson | South Dakota | 46067 | 46 | 1 |
491623 | 491623 | 2020-09-01 | Hutchinson | South Dakota | 46067 | 44 | 1 |
488390 | 488390 | 2020-08-31 | Hutchinson | South Dakota | 46067 | 41 | 1 |
485157 | 485157 | 2020-08-30 | Hutchinson | South Dakota | 46067 | 39 | 1 |
481922 | 481922 | 2020-08-29 | Hutchinson | South Dakota | 46067 | 38 | 1 |
478688 | 478688 | 2020-08-28 | Hutchinson | South Dakota | 46067 | 36 | 1 |
475455 | 475455 | 2020-08-27 | Hutchinson | South Dakota | 46067 | 36 | 1 |
472221 | 472221 | 2020-08-26 | Hutchinson | South Dakota | 46067 | 35 | 1 |
468989 | 468989 | 2020-08-25 | Hutchinson | South Dakota | 46067 | 35 | 1 |
465761 | 465761 | 2020-08-24 | Hutchinson | South Dakota | 46067 | 35 | 1 |
462532 | 462532 | 2020-08-23 | Hutchinson | South Dakota | 46067 | 35 | 1 |
459304 | 459304 | 2020-08-22 | Hutchinson | South Dakota | 46067 | 35 | 1 |
456076 | 456076 | 2020-08-21 | Hutchinson | South Dakota | 46067 | 35 | 0 |
452848 | 452848 | 2020-08-20 | Hutchinson | South Dakota | 46067 | 35 | 0 |
449620 | 449620 | 2020-08-19 | Hutchinson | South Dakota | 46067 | 35 | 0 |
446392 | 446392 | 2020-08-18 | Hutchinson | South Dakota | 46067 | 35 | 0 |
443166 | 443166 | 2020-08-17 | Hutchinson | South Dakota | 46067 | 31 | 0 |
439939 | 439939 | 2020-08-16 | Hutchinson | South Dakota | 46067 | 31 | 0 |
436714 | 436714 | 2020-08-15 | Hutchinson | South Dakota | 46067 | 31 | 0 |
433487 | 433487 | 2020-08-14 | Hutchinson | South Dakota | 46067 | 29 | 0 |
430262 | 430262 | 2020-08-13 | Hutchinson | South Dakota | 46067 | 29 | 0 |
427035 | 427035 | 2020-08-12 | Hutchinson | South Dakota | 46067 | 30 | 0 |
423812 | 423812 | 2020-08-11 | Hutchinson | South Dakota | 46067 | 29 | 0 |
420590 | 420590 | 2020-08-10 | Hutchinson | South Dakota | 46067 | 29 | 0 |
417369 | 417369 | 2020-08-09 | Hutchinson | South Dakota | 46067 | 29 | 0 |
414148 | 414148 | 2020-08-08 | Hutchinson | South Dakota | 46067 | 28 | 0 |
410928 | 410928 | 2020-08-07 | Hutchinson | South Dakota | 46067 | 27 | 0 |
407709 | 407709 | 2020-08-06 | Hutchinson | South Dakota | 46067 | 27 | 0 |
404489 | 404489 | 2020-08-05 | Hutchinson | South Dakota | 46067 | 27 | 0 |
401271 | 401271 | 2020-08-04 | Hutchinson | South Dakota | 46067 | 27 | 0 |
398056 | 398056 | 2020-08-03 | Hutchinson | South Dakota | 46067 | 27 | 0 |
394839 | 394839 | 2020-08-02 | Hutchinson | South Dakota | 46067 | 26 | 0 |
391623 | 391623 | 2020-08-01 | Hutchinson | South Dakota | 46067 | 26 | 0 |
388406 | 388406 | 2020-07-31 | Hutchinson | South Dakota | 46067 | 26 | 0 |
385189 | 385189 | 2020-07-30 | Hutchinson | South Dakota | 46067 | 25 | 0 |
381971 | 381971 | 2020-07-29 | Hutchinson | South Dakota | 46067 | 24 | 0 |
378754 | 378754 | 2020-07-28 | Hutchinson | South Dakota | 46067 | 24 | 0 |
375538 | 375538 | 2020-07-27 | Hutchinson | South Dakota | 46067 | 24 | 0 |
372325 | 372325 | 2020-07-26 | Hutchinson | South Dakota | 46067 | 24 | 0 |
369113 | 369113 | 2020-07-25 | Hutchinson | South Dakota | 46067 | 23 | 0 |
365904 | 365904 | 2020-07-24 | Hutchinson | South Dakota | 46067 | 21 | 0 |
362698 | 362698 | 2020-07-23 | Hutchinson | South Dakota | 46067 | 21 | 0 |
359492 | 359492 | 2020-07-22 | Hutchinson | South Dakota | 46067 | 21 | 0 |
356288 | 356288 | 2020-07-21 | Hutchinson | South Dakota | 46067 | 21 | 0 |
353085 | 353085 | 2020-07-20 | Hutchinson | South Dakota | 46067 | 21 | 0 |
349882 | 349882 | 2020-07-19 | Hutchinson | South Dakota | 46067 | 20 | 0 |
346682 | 346682 | 2020-07-18 | Hutchinson | South Dakota | 46067 | 20 | 0 |
343482 | 343482 | 2020-07-17 | Hutchinson | South Dakota | 46067 | 20 | 0 |
340284 | 340284 | 2020-07-16 | Hutchinson | South Dakota | 46067 | 18 | 0 |
337087 | 337087 | 2020-07-15 | Hutchinson | South Dakota | 46067 | 18 | 0 |
333893 | 333893 | 2020-07-14 | Hutchinson | South Dakota | 46067 | 18 | 0 |
330701 | 330701 | 2020-07-13 | Hutchinson | South Dakota | 46067 | 17 | 0 |
327515 | 327515 | 2020-07-12 | Hutchinson | South Dakota | 46067 | 17 | 0 |
324330 | 324330 | 2020-07-11 | Hutchinson | South Dakota | 46067 | 15 | 0 |
321150 | 321150 | 2020-07-10 | Hutchinson | South Dakota | 46067 | 15 | 0 |
317972 | 317972 | 2020-07-09 | Hutchinson | South Dakota | 46067 | 15 | 0 |
314799 | 314799 | 2020-07-08 | Hutchinson | South Dakota | 46067 | 15 | 0 |
311626 | 311626 | 2020-07-07 | Hutchinson | South Dakota | 46067 | 15 | 0 |
308457 | 308457 | 2020-07-06 | Hutchinson | South Dakota | 46067 | 15 | 0 |
305289 | 305289 | 2020-07-05 | Hutchinson | South Dakota | 46067 | 14 | 0 |
302126 | 302126 | 2020-07-04 | Hutchinson | South Dakota | 46067 | 14 | 0 |
298962 | 298962 | 2020-07-03 | Hutchinson | South Dakota | 46067 | 13 | 0 |
295802 | 295802 | 2020-07-02 | Hutchinson | South Dakota | 46067 | 13 | 0 |
292646 | 292646 | 2020-07-01 | Hutchinson | South Dakota | 46067 | 12 | 0 |
289494 | 289494 | 2020-06-30 | Hutchinson | South Dakota | 46067 | 12 | 0 |
286343 | 286343 | 2020-06-29 | Hutchinson | South Dakota | 46067 | 12 | 0 |
283198 | 283198 | 2020-06-28 | Hutchinson | South Dakota | 46067 | 12 | 0 |
280052 | 280052 | 2020-06-27 | Hutchinson | South Dakota | 46067 | 11 | 0 |
276904 | 276904 | 2020-06-26 | Hutchinson | South Dakota | 46067 | 10 | 0 |
273757 | 273757 | 2020-06-25 | Hutchinson | South Dakota | 46067 | 10 | 0 |
270618 | 270618 | 2020-06-24 | Hutchinson | South Dakota | 46067 | 10 | 0 |
267484 | 267484 | 2020-06-23 | Hutchinson | South Dakota | 46067 | 10 | 0 |
264356 | 264356 | 2020-06-22 | Hutchinson | South Dakota | 46067 | 10 | 0 |
261228 | 261228 | 2020-06-21 | Hutchinson | South Dakota | 46067 | 10 | 0 |
258101 | 258101 | 2020-06-20 | Hutchinson | South Dakota | 46067 | 10 | 0 |
254975 | 254975 | 2020-06-19 | Hutchinson | South Dakota | 46067 | 10 | 0 |
251860 | 251860 | 2020-06-18 | Hutchinson | South Dakota | 46067 | 10 | 0 |
248745 | 248745 | 2020-06-17 | Hutchinson | South Dakota | 46067 | 9 | 0 |
245632 | 245632 | 2020-06-16 | Hutchinson | South Dakota | 46067 | 9 | 0 |
242520 | 242520 | 2020-06-15 | Hutchinson | South Dakota | 46067 | 9 | 0 |
239410 | 239410 | 2020-06-14 | Hutchinson | South Dakota | 46067 | 8 | 0 |
236302 | 236302 | 2020-06-13 | Hutchinson | South Dakota | 46067 | 8 | 0 |
233197 | 233197 | 2020-06-12 | Hutchinson | South Dakota | 46067 | 8 | 0 |
230092 | 230092 | 2020-06-11 | Hutchinson | South Dakota | 46067 | 8 | 0 |
226988 | 226988 | 2020-06-10 | Hutchinson | South Dakota | 46067 | 8 | 0 |
223888 | 223888 | 2020-06-09 | Hutchinson | South Dakota | 46067 | 6 | 0 |
220793 | 220793 | 2020-06-08 | Hutchinson | South Dakota | 46067 | 6 | 0 |
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);