ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,547 rows where county = "Hutchinson" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
308457 | 308457 | 2020-07-06 | Hutchinson | South Dakota | 46067 | 15 | 0 |
311626 | 311626 | 2020-07-07 | Hutchinson | South Dakota | 46067 | 15 | 0 |
314799 | 314799 | 2020-07-08 | Hutchinson | South Dakota | 46067 | 15 | 0 |
317972 | 317972 | 2020-07-09 | Hutchinson | South Dakota | 46067 | 15 | 0 |
321150 | 321150 | 2020-07-10 | Hutchinson | South Dakota | 46067 | 15 | 0 |
324330 | 324330 | 2020-07-11 | Hutchinson | South Dakota | 46067 | 15 | 0 |
327515 | 327515 | 2020-07-12 | Hutchinson | South Dakota | 46067 | 17 | 0 |
330701 | 330701 | 2020-07-13 | Hutchinson | South Dakota | 46067 | 17 | 0 |
333893 | 333893 | 2020-07-14 | Hutchinson | South Dakota | 46067 | 18 | 0 |
337087 | 337087 | 2020-07-15 | Hutchinson | South Dakota | 46067 | 18 | 0 |
340284 | 340284 | 2020-07-16 | Hutchinson | South Dakota | 46067 | 18 | 0 |
343482 | 343482 | 2020-07-17 | Hutchinson | South Dakota | 46067 | 20 | 0 |
346682 | 346682 | 2020-07-18 | Hutchinson | South Dakota | 46067 | 20 | 0 |
349882 | 349882 | 2020-07-19 | Hutchinson | South Dakota | 46067 | 20 | 0 |
353085 | 353085 | 2020-07-20 | Hutchinson | South Dakota | 46067 | 21 | 0 |
356288 | 356288 | 2020-07-21 | Hutchinson | South Dakota | 46067 | 21 | 0 |
359492 | 359492 | 2020-07-22 | Hutchinson | South Dakota | 46067 | 21 | 0 |
362698 | 362698 | 2020-07-23 | Hutchinson | South Dakota | 46067 | 21 | 0 |
365904 | 365904 | 2020-07-24 | Hutchinson | South Dakota | 46067 | 21 | 0 |
369113 | 369113 | 2020-07-25 | Hutchinson | South Dakota | 46067 | 23 | 0 |
372325 | 372325 | 2020-07-26 | Hutchinson | South Dakota | 46067 | 24 | 0 |
375538 | 375538 | 2020-07-27 | Hutchinson | South Dakota | 46067 | 24 | 0 |
378754 | 378754 | 2020-07-28 | Hutchinson | South Dakota | 46067 | 24 | 0 |
381971 | 381971 | 2020-07-29 | Hutchinson | South Dakota | 46067 | 24 | 0 |
385189 | 385189 | 2020-07-30 | Hutchinson | South Dakota | 46067 | 25 | 0 |
388406 | 388406 | 2020-07-31 | Hutchinson | South Dakota | 46067 | 26 | 0 |
391623 | 391623 | 2020-08-01 | Hutchinson | South Dakota | 46067 | 26 | 0 |
394839 | 394839 | 2020-08-02 | Hutchinson | South Dakota | 46067 | 26 | 0 |
398056 | 398056 | 2020-08-03 | Hutchinson | South Dakota | 46067 | 27 | 0 |
401271 | 401271 | 2020-08-04 | Hutchinson | South Dakota | 46067 | 27 | 0 |
404489 | 404489 | 2020-08-05 | Hutchinson | South Dakota | 46067 | 27 | 0 |
407709 | 407709 | 2020-08-06 | Hutchinson | South Dakota | 46067 | 27 | 0 |
410928 | 410928 | 2020-08-07 | Hutchinson | South Dakota | 46067 | 27 | 0 |
414148 | 414148 | 2020-08-08 | Hutchinson | South Dakota | 46067 | 28 | 0 |
417369 | 417369 | 2020-08-09 | Hutchinson | South Dakota | 46067 | 29 | 0 |
420590 | 420590 | 2020-08-10 | Hutchinson | South Dakota | 46067 | 29 | 0 |
423812 | 423812 | 2020-08-11 | Hutchinson | South Dakota | 46067 | 29 | 0 |
427035 | 427035 | 2020-08-12 | Hutchinson | South Dakota | 46067 | 30 | 0 |
430262 | 430262 | 2020-08-13 | Hutchinson | South Dakota | 46067 | 29 | 0 |
433487 | 433487 | 2020-08-14 | Hutchinson | South Dakota | 46067 | 29 | 0 |
436714 | 436714 | 2020-08-15 | Hutchinson | South Dakota | 46067 | 31 | 0 |
439939 | 439939 | 2020-08-16 | Hutchinson | South Dakota | 46067 | 31 | 0 |
443166 | 443166 | 2020-08-17 | Hutchinson | South Dakota | 46067 | 31 | 0 |
446392 | 446392 | 2020-08-18 | Hutchinson | South Dakota | 46067 | 35 | 0 |
449620 | 449620 | 2020-08-19 | Hutchinson | South Dakota | 46067 | 35 | 0 |
452848 | 452848 | 2020-08-20 | Hutchinson | South Dakota | 46067 | 35 | 0 |
456076 | 456076 | 2020-08-21 | Hutchinson | South Dakota | 46067 | 35 | 0 |
459304 | 459304 | 2020-08-22 | Hutchinson | South Dakota | 46067 | 35 | 1 |
462532 | 462532 | 2020-08-23 | Hutchinson | South Dakota | 46067 | 35 | 1 |
465761 | 465761 | 2020-08-24 | Hutchinson | South Dakota | 46067 | 35 | 1 |
468989 | 468989 | 2020-08-25 | Hutchinson | South Dakota | 46067 | 35 | 1 |
472221 | 472221 | 2020-08-26 | Hutchinson | South Dakota | 46067 | 35 | 1 |
475455 | 475455 | 2020-08-27 | Hutchinson | South Dakota | 46067 | 36 | 1 |
478688 | 478688 | 2020-08-28 | Hutchinson | South Dakota | 46067 | 36 | 1 |
481922 | 481922 | 2020-08-29 | Hutchinson | South Dakota | 46067 | 38 | 1 |
485157 | 485157 | 2020-08-30 | Hutchinson | South Dakota | 46067 | 39 | 1 |
488390 | 488390 | 2020-08-31 | Hutchinson | South Dakota | 46067 | 41 | 1 |
491623 | 491623 | 2020-09-01 | Hutchinson | South Dakota | 46067 | 44 | 1 |
494857 | 494857 | 2020-09-02 | Hutchinson | South Dakota | 46067 | 46 | 1 |
498090 | 498090 | 2020-09-03 | Hutchinson | South Dakota | 46067 | 49 | 1 |
501324 | 501324 | 2020-09-04 | Hutchinson | South Dakota | 46067 | 51 | 1 |
504558 | 504558 | 2020-09-05 | Hutchinson | South Dakota | 46067 | 55 | 1 |
507790 | 507790 | 2020-09-06 | Hutchinson | South Dakota | 46067 | 56 | 1 |
511023 | 511023 | 2020-09-07 | Hutchinson | South Dakota | 46067 | 56 | 1 |
514256 | 514256 | 2020-09-08 | Hutchinson | South Dakota | 46067 | 57 | 1 |
517491 | 517491 | 2020-09-09 | Hutchinson | South Dakota | 46067 | 57 | 1 |
520727 | 520727 | 2020-09-10 | Hutchinson | South Dakota | 46067 | 58 | 1 |
523963 | 523963 | 2020-09-11 | Hutchinson | South Dakota | 46067 | 60 | 1 |
527199 | 527199 | 2020-09-12 | Hutchinson | South Dakota | 46067 | 61 | 1 |
530436 | 530436 | 2020-09-13 | Hutchinson | South Dakota | 46067 | 64 | 1 |
533671 | 533671 | 2020-09-14 | Hutchinson | South Dakota | 46067 | 64 | 1 |
536907 | 536907 | 2020-09-15 | Hutchinson | South Dakota | 46067 | 64 | 1 |
540144 | 540144 | 2020-09-16 | Hutchinson | South Dakota | 46067 | 65 | 1 |
543380 | 543380 | 2020-09-17 | Hutchinson | South Dakota | 46067 | 67 | 1 |
546617 | 546617 | 2020-09-18 | Hutchinson | South Dakota | 46067 | 68 | 2 |
549856 | 549856 | 2020-09-19 | Hutchinson | South Dakota | 46067 | 71 | 2 |
553095 | 553095 | 2020-09-20 | Hutchinson | South Dakota | 46067 | 73 | 2 |
556332 | 556332 | 2020-09-21 | Hutchinson | South Dakota | 46067 | 74 | 2 |
559569 | 559569 | 2020-09-22 | Hutchinson | South Dakota | 46067 | 75 | 2 |
562806 | 562806 | 2020-09-23 | Hutchinson | South Dakota | 46067 | 78 | 2 |
566047 | 566047 | 2020-09-24 | Hutchinson | South Dakota | 46067 | 82 | 2 |
569288 | 569288 | 2020-09-25 | Hutchinson | South Dakota | 46067 | 88 | 2 |
572530 | 572530 | 2020-09-26 | Hutchinson | South Dakota | 46067 | 95 | 2 |
575774 | 575774 | 2020-09-27 | Hutchinson | South Dakota | 46067 | 99 | 2 |
579015 | 579015 | 2020-09-28 | Hutchinson | South Dakota | 46067 | 99 | 2 |
582255 | 582255 | 2020-09-29 | Hutchinson | South Dakota | 46067 | 101 | 2 |
585495 | 585495 | 2020-09-30 | Hutchinson | South Dakota | 46067 | 105 | 2 |
588735 | 588735 | 2020-10-01 | Hutchinson | South Dakota | 46067 | 112 | 2 |
591976 | 591976 | 2020-10-02 | Hutchinson | South Dakota | 46067 | 118 | 2 |
595217 | 595217 | 2020-10-03 | Hutchinson | South Dakota | 46067 | 119 | 2 |
598460 | 598460 | 2020-10-04 | Hutchinson | South Dakota | 46067 | 129 | 2 |
601703 | 601703 | 2020-10-05 | Hutchinson | South Dakota | 46067 | 129 | 2 |
604945 | 604945 | 2020-10-06 | Hutchinson | South Dakota | 46067 | 133 | 2 |
608188 | 608188 | 2020-10-07 | Hutchinson | South Dakota | 46067 | 135 | 2 |
611430 | 611430 | 2020-10-08 | Hutchinson | South Dakota | 46067 | 141 | 2 |
614671 | 614671 | 2020-10-09 | Hutchinson | South Dakota | 46067 | 148 | 2 |
617913 | 617913 | 2020-10-10 | Hutchinson | South Dakota | 46067 | 152 | 2 |
621156 | 621156 | 2020-10-11 | Hutchinson | South Dakota | 46067 | 157 | 2 |
624399 | 624399 | 2020-10-12 | Hutchinson | South Dakota | 46067 | 158 | 2 |
627641 | 627641 | 2020-10-13 | Hutchinson | South Dakota | 46067 | 161 | 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);