ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 46087 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 |
---|---|---|---|---|---|---|---|
637387 | 637387 | 2020-10-16 | McCook | South Dakota | 46087 | 171 | 1 |
634141 | 634141 | 2020-10-15 | McCook | South Dakota | 46087 | 164 | 1 |
630896 | 630896 | 2020-10-14 | McCook | South Dakota | 46087 | 163 | 1 |
627652 | 627652 | 2020-10-13 | McCook | South Dakota | 46087 | 154 | 1 |
624410 | 624410 | 2020-10-12 | McCook | South Dakota | 46087 | 151 | 1 |
621167 | 621167 | 2020-10-11 | McCook | South Dakota | 46087 | 150 | 1 |
617924 | 617924 | 2020-10-10 | McCook | South Dakota | 46087 | 146 | 1 |
614682 | 614682 | 2020-10-09 | McCook | South Dakota | 46087 | 142 | 1 |
611441 | 611441 | 2020-10-08 | McCook | South Dakota | 46087 | 139 | 1 |
608199 | 608199 | 2020-10-07 | McCook | South Dakota | 46087 | 137 | 1 |
604956 | 604956 | 2020-10-06 | McCook | South Dakota | 46087 | 132 | 1 |
601714 | 601714 | 2020-10-05 | McCook | South Dakota | 46087 | 127 | 1 |
598471 | 598471 | 2020-10-04 | McCook | South Dakota | 46087 | 127 | 1 |
595228 | 595228 | 2020-10-03 | McCook | South Dakota | 46087 | 120 | 1 |
591987 | 591987 | 2020-10-02 | McCook | South Dakota | 46087 | 117 | 1 |
588746 | 588746 | 2020-10-01 | McCook | South Dakota | 46087 | 113 | 1 |
585506 | 585506 | 2020-09-30 | McCook | South Dakota | 46087 | 106 | 1 |
582266 | 582266 | 2020-09-29 | McCook | South Dakota | 46087 | 98 | 1 |
579026 | 579026 | 2020-09-28 | McCook | South Dakota | 46087 | 97 | 1 |
575785 | 575785 | 2020-09-27 | McCook | South Dakota | 46087 | 96 | 1 |
572541 | 572541 | 2020-09-26 | McCook | South Dakota | 46087 | 93 | 1 |
569299 | 569299 | 2020-09-25 | McCook | South Dakota | 46087 | 92 | 1 |
566058 | 566058 | 2020-09-24 | McCook | South Dakota | 46087 | 91 | 1 |
562817 | 562817 | 2020-09-23 | McCook | South Dakota | 46087 | 88 | 1 |
559580 | 559580 | 2020-09-22 | McCook | South Dakota | 46087 | 85 | 1 |
556343 | 556343 | 2020-09-21 | McCook | South Dakota | 46087 | 83 | 1 |
553106 | 553106 | 2020-09-20 | McCook | South Dakota | 46087 | 83 | 1 |
549867 | 549867 | 2020-09-19 | McCook | South Dakota | 46087 | 80 | 1 |
546628 | 546628 | 2020-09-18 | McCook | South Dakota | 46087 | 78 | 1 |
543391 | 543391 | 2020-09-17 | McCook | South Dakota | 46087 | 78 | 1 |
540155 | 540155 | 2020-09-16 | McCook | South Dakota | 46087 | 77 | 1 |
536918 | 536918 | 2020-09-15 | McCook | South Dakota | 46087 | 75 | 1 |
533682 | 533682 | 2020-09-14 | McCook | South Dakota | 46087 | 71 | 1 |
530447 | 530447 | 2020-09-13 | McCook | South Dakota | 46087 | 70 | 1 |
527210 | 527210 | 2020-09-12 | McCook | South Dakota | 46087 | 68 | 1 |
523974 | 523974 | 2020-09-11 | McCook | South Dakota | 46087 | 67 | 1 |
520738 | 520738 | 2020-09-10 | McCook | South Dakota | 46087 | 66 | 1 |
517502 | 517502 | 2020-09-09 | McCook | South Dakota | 46087 | 61 | 1 |
514267 | 514267 | 2020-09-08 | McCook | South Dakota | 46087 | 61 | 1 |
511034 | 511034 | 2020-09-07 | McCook | South Dakota | 46087 | 60 | 1 |
507801 | 507801 | 2020-09-06 | McCook | South Dakota | 46087 | 59 | 1 |
504569 | 504569 | 2020-09-05 | McCook | South Dakota | 46087 | 58 | 1 |
501335 | 501335 | 2020-09-04 | McCook | South Dakota | 46087 | 54 | 1 |
498101 | 498101 | 2020-09-03 | McCook | South Dakota | 46087 | 53 | 1 |
494868 | 494868 | 2020-09-02 | McCook | South Dakota | 46087 | 53 | 1 |
491634 | 491634 | 2020-09-01 | McCook | South Dakota | 46087 | 53 | 1 |
488401 | 488401 | 2020-08-31 | McCook | South Dakota | 46087 | 52 | 1 |
485168 | 485168 | 2020-08-30 | McCook | South Dakota | 46087 | 49 | 1 |
481933 | 481933 | 2020-08-29 | McCook | South Dakota | 46087 | 47 | 1 |
478699 | 478699 | 2020-08-28 | McCook | South Dakota | 46087 | 44 | 1 |
475466 | 475466 | 2020-08-27 | McCook | South Dakota | 46087 | 41 | 1 |
472232 | 472232 | 2020-08-26 | McCook | South Dakota | 46087 | 39 | 1 |
469000 | 469000 | 2020-08-25 | McCook | South Dakota | 46087 | 39 | 1 |
465772 | 465772 | 2020-08-24 | McCook | South Dakota | 46087 | 39 | 1 |
462543 | 462543 | 2020-08-23 | McCook | South Dakota | 46087 | 39 | 1 |
459315 | 459315 | 2020-08-22 | McCook | South Dakota | 46087 | 39 | 1 |
456087 | 456087 | 2020-08-21 | McCook | South Dakota | 46087 | 37 | 1 |
452859 | 452859 | 2020-08-20 | McCook | South Dakota | 46087 | 37 | 1 |
449631 | 449631 | 2020-08-19 | McCook | South Dakota | 46087 | 37 | 1 |
446403 | 446403 | 2020-08-18 | McCook | South Dakota | 46087 | 37 | 1 |
443177 | 443177 | 2020-08-17 | McCook | South Dakota | 46087 | 36 | 1 |
439950 | 439950 | 2020-08-16 | McCook | South Dakota | 46087 | 36 | 1 |
436725 | 436725 | 2020-08-15 | McCook | South Dakota | 46087 | 33 | 1 |
433498 | 433498 | 2020-08-14 | McCook | South Dakota | 46087 | 32 | 1 |
430273 | 430273 | 2020-08-13 | McCook | South Dakota | 46087 | 30 | 1 |
427046 | 427046 | 2020-08-12 | McCook | South Dakota | 46087 | 30 | 1 |
423823 | 423823 | 2020-08-11 | McCook | South Dakota | 46087 | 29 | 1 |
420601 | 420601 | 2020-08-10 | McCook | South Dakota | 46087 | 29 | 1 |
417380 | 417380 | 2020-08-09 | McCook | South Dakota | 46087 | 28 | 1 |
414159 | 414159 | 2020-08-08 | McCook | South Dakota | 46087 | 27 | 1 |
410939 | 410939 | 2020-08-07 | McCook | South Dakota | 46087 | 26 | 1 |
407720 | 407720 | 2020-08-06 | McCook | South Dakota | 46087 | 26 | 1 |
404500 | 404500 | 2020-08-05 | McCook | South Dakota | 46087 | 26 | 1 |
401282 | 401282 | 2020-08-04 | McCook | South Dakota | 46087 | 24 | 1 |
398067 | 398067 | 2020-08-03 | McCook | South Dakota | 46087 | 24 | 1 |
394850 | 394850 | 2020-08-02 | McCook | South Dakota | 46087 | 24 | 1 |
391634 | 391634 | 2020-08-01 | McCook | South Dakota | 46087 | 24 | 1 |
388417 | 388417 | 2020-07-31 | McCook | South Dakota | 46087 | 24 | 1 |
385200 | 385200 | 2020-07-30 | McCook | South Dakota | 46087 | 24 | 1 |
381982 | 381982 | 2020-07-29 | McCook | South Dakota | 46087 | 24 | 1 |
378765 | 378765 | 2020-07-28 | McCook | South Dakota | 46087 | 24 | 1 |
375549 | 375549 | 2020-07-27 | McCook | South Dakota | 46087 | 23 | 1 |
372336 | 372336 | 2020-07-26 | McCook | South Dakota | 46087 | 23 | 1 |
369124 | 369124 | 2020-07-25 | McCook | South Dakota | 46087 | 23 | 1 |
365915 | 365915 | 2020-07-24 | McCook | South Dakota | 46087 | 23 | 1 |
362709 | 362709 | 2020-07-23 | McCook | South Dakota | 46087 | 22 | 1 |
359503 | 359503 | 2020-07-22 | McCook | South Dakota | 46087 | 21 | 1 |
356299 | 356299 | 2020-07-21 | McCook | South Dakota | 46087 | 21 | 1 |
353096 | 353096 | 2020-07-20 | McCook | South Dakota | 46087 | 21 | 1 |
349893 | 349893 | 2020-07-19 | McCook | South Dakota | 46087 | 21 | 1 |
346693 | 346693 | 2020-07-18 | McCook | South Dakota | 46087 | 21 | 1 |
343493 | 343493 | 2020-07-17 | McCook | South Dakota | 46087 | 21 | 1 |
340295 | 340295 | 2020-07-16 | McCook | South Dakota | 46087 | 19 | 1 |
337098 | 337098 | 2020-07-15 | McCook | South Dakota | 46087 | 19 | 1 |
333904 | 333904 | 2020-07-14 | McCook | South Dakota | 46087 | 17 | 1 |
330712 | 330712 | 2020-07-13 | McCook | South Dakota | 46087 | 17 | 1 |
327526 | 327526 | 2020-07-12 | McCook | South Dakota | 46087 | 17 | 1 |
324341 | 324341 | 2020-07-11 | McCook | South Dakota | 46087 | 16 | 1 |
321161 | 321161 | 2020-07-10 | McCook | South Dakota | 46087 | 15 | 1 |
317983 | 317983 | 2020-07-09 | McCook | South Dakota | 46087 | 15 | 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);