ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
675 rows where fips = 46019 and state = "South Dakota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
314776 | 314776 | 2020-07-08 | Butte | South Dakota | 46019 | 1 | 0 |
317949 | 317949 | 2020-07-09 | Butte | South Dakota | 46019 | 1 | 0 |
321127 | 321127 | 2020-07-10 | Butte | South Dakota | 46019 | 2 | 0 |
324307 | 324307 | 2020-07-11 | Butte | South Dakota | 46019 | 3 | 0 |
327492 | 327492 | 2020-07-12 | Butte | South Dakota | 46019 | 3 | 0 |
330678 | 330678 | 2020-07-13 | Butte | South Dakota | 46019 | 3 | 0 |
333870 | 333870 | 2020-07-14 | Butte | South Dakota | 46019 | 3 | 0 |
337064 | 337064 | 2020-07-15 | Butte | South Dakota | 46019 | 3 | 1 |
340261 | 340261 | 2020-07-16 | Butte | South Dakota | 46019 | 3 | 1 |
343459 | 343459 | 2020-07-17 | Butte | South Dakota | 46019 | 4 | 1 |
346659 | 346659 | 2020-07-18 | Butte | South Dakota | 46019 | 5 | 1 |
349859 | 349859 | 2020-07-19 | Butte | South Dakota | 46019 | 5 | 1 |
353062 | 353062 | 2020-07-20 | Butte | South Dakota | 46019 | 5 | 1 |
356265 | 356265 | 2020-07-21 | Butte | South Dakota | 46019 | 7 | 1 |
359469 | 359469 | 2020-07-22 | Butte | South Dakota | 46019 | 7 | 1 |
362675 | 362675 | 2020-07-23 | Butte | South Dakota | 46019 | 7 | 1 |
365881 | 365881 | 2020-07-24 | Butte | South Dakota | 46019 | 8 | 1 |
369090 | 369090 | 2020-07-25 | Butte | South Dakota | 46019 | 8 | 1 |
372302 | 372302 | 2020-07-26 | Butte | South Dakota | 46019 | 8 | 1 |
375515 | 375515 | 2020-07-27 | Butte | South Dakota | 46019 | 8 | 1 |
378731 | 378731 | 2020-07-28 | Butte | South Dakota | 46019 | 8 | 1 |
381948 | 381948 | 2020-07-29 | Butte | South Dakota | 46019 | 10 | 1 |
385166 | 385166 | 2020-07-30 | Butte | South Dakota | 46019 | 10 | 1 |
388383 | 388383 | 2020-07-31 | Butte | South Dakota | 46019 | 10 | 1 |
391600 | 391600 | 2020-08-01 | Butte | South Dakota | 46019 | 10 | 1 |
394816 | 394816 | 2020-08-02 | Butte | South Dakota | 46019 | 11 | 1 |
398033 | 398033 | 2020-08-03 | Butte | South Dakota | 46019 | 11 | 1 |
401248 | 401248 | 2020-08-04 | Butte | South Dakota | 46019 | 11 | 1 |
404466 | 404466 | 2020-08-05 | Butte | South Dakota | 46019 | 12 | 1 |
407686 | 407686 | 2020-08-06 | Butte | South Dakota | 46019 | 14 | 1 |
410905 | 410905 | 2020-08-07 | Butte | South Dakota | 46019 | 14 | 1 |
414125 | 414125 | 2020-08-08 | Butte | South Dakota | 46019 | 14 | 1 |
417346 | 417346 | 2020-08-09 | Butte | South Dakota | 46019 | 17 | 1 |
420567 | 420567 | 2020-08-10 | Butte | South Dakota | 46019 | 18 | 1 |
423789 | 423789 | 2020-08-11 | Butte | South Dakota | 46019 | 18 | 1 |
427012 | 427012 | 2020-08-12 | Butte | South Dakota | 46019 | 18 | 1 |
430238 | 430238 | 2020-08-13 | Butte | South Dakota | 46019 | 18 | 1 |
433463 | 433463 | 2020-08-14 | Butte | South Dakota | 46019 | 18 | 1 |
436690 | 436690 | 2020-08-15 | Butte | South Dakota | 46019 | 19 | 1 |
439915 | 439915 | 2020-08-16 | Butte | South Dakota | 46019 | 20 | 1 |
443142 | 443142 | 2020-08-17 | Butte | South Dakota | 46019 | 20 | 1 |
446368 | 446368 | 2020-08-18 | Butte | South Dakota | 46019 | 20 | 1 |
449596 | 449596 | 2020-08-19 | Butte | South Dakota | 46019 | 21 | 1 |
452824 | 452824 | 2020-08-20 | Butte | South Dakota | 46019 | 22 | 1 |
456052 | 456052 | 2020-08-21 | Butte | South Dakota | 46019 | 24 | 1 |
459280 | 459280 | 2020-08-22 | Butte | South Dakota | 46019 | 26 | 1 |
462508 | 462508 | 2020-08-23 | Butte | South Dakota | 46019 | 27 | 1 |
465737 | 465737 | 2020-08-24 | Butte | South Dakota | 46019 | 29 | 1 |
468965 | 468965 | 2020-08-25 | Butte | South Dakota | 46019 | 31 | 1 |
472197 | 472197 | 2020-08-26 | Butte | South Dakota | 46019 | 33 | 1 |
475431 | 475431 | 2020-08-27 | Butte | South Dakota | 46019 | 41 | 1 |
478664 | 478664 | 2020-08-28 | Butte | South Dakota | 46019 | 44 | 1 |
481898 | 481898 | 2020-08-29 | Butte | South Dakota | 46019 | 45 | 1 |
485133 | 485133 | 2020-08-30 | Butte | South Dakota | 46019 | 46 | 1 |
488366 | 488366 | 2020-08-31 | Butte | South Dakota | 46019 | 47 | 1 |
491599 | 491599 | 2020-09-01 | Butte | South Dakota | 46019 | 47 | 1 |
494833 | 494833 | 2020-09-02 | Butte | South Dakota | 46019 | 49 | 1 |
498066 | 498066 | 2020-09-03 | Butte | South Dakota | 46019 | 52 | 1 |
501300 | 501300 | 2020-09-04 | Butte | South Dakota | 46019 | 51 | 1 |
504534 | 504534 | 2020-09-05 | Butte | South Dakota | 46019 | 52 | 1 |
507766 | 507766 | 2020-09-06 | Butte | South Dakota | 46019 | 54 | 1 |
510999 | 510999 | 2020-09-07 | Butte | South Dakota | 46019 | 57 | 1 |
514232 | 514232 | 2020-09-08 | Butte | South Dakota | 46019 | 58 | 1 |
517467 | 517467 | 2020-09-09 | Butte | South Dakota | 46019 | 61 | 1 |
520703 | 520703 | 2020-09-10 | Butte | South Dakota | 46019 | 62 | 1 |
523939 | 523939 | 2020-09-11 | Butte | South Dakota | 46019 | 64 | 1 |
527175 | 527175 | 2020-09-12 | Butte | South Dakota | 46019 | 65 | 1 |
530412 | 530412 | 2020-09-13 | Butte | South Dakota | 46019 | 65 | 1 |
533647 | 533647 | 2020-09-14 | Butte | South Dakota | 46019 | 65 | 1 |
536883 | 536883 | 2020-09-15 | Butte | South Dakota | 46019 | 65 | 1 |
540120 | 540120 | 2020-09-16 | Butte | South Dakota | 46019 | 69 | 1 |
543356 | 543356 | 2020-09-17 | Butte | South Dakota | 46019 | 73 | 1 |
546593 | 546593 | 2020-09-18 | Butte | South Dakota | 46019 | 74 | 1 |
549832 | 549832 | 2020-09-19 | Butte | South Dakota | 46019 | 74 | 1 |
553071 | 553071 | 2020-09-20 | Butte | South Dakota | 46019 | 75 | 1 |
556308 | 556308 | 2020-09-21 | Butte | South Dakota | 46019 | 75 | 1 |
559545 | 559545 | 2020-09-22 | Butte | South Dakota | 46019 | 77 | 1 |
562782 | 562782 | 2020-09-23 | Butte | South Dakota | 46019 | 82 | 1 |
566023 | 566023 | 2020-09-24 | Butte | South Dakota | 46019 | 86 | 2 |
569264 | 569264 | 2020-09-25 | Butte | South Dakota | 46019 | 91 | 3 |
572506 | 572506 | 2020-09-26 | Butte | South Dakota | 46019 | 97 | 3 |
575750 | 575750 | 2020-09-27 | Butte | South Dakota | 46019 | 102 | 3 |
578991 | 578991 | 2020-09-28 | Butte | South Dakota | 46019 | 104 | 3 |
582231 | 582231 | 2020-09-29 | Butte | South Dakota | 46019 | 106 | 3 |
585471 | 585471 | 2020-09-30 | Butte | South Dakota | 46019 | 110 | 3 |
588711 | 588711 | 2020-10-01 | Butte | South Dakota | 46019 | 121 | 3 |
591952 | 591952 | 2020-10-02 | Butte | South Dakota | 46019 | 123 | 3 |
595193 | 595193 | 2020-10-03 | Butte | South Dakota | 46019 | 122 | 3 |
598436 | 598436 | 2020-10-04 | Butte | South Dakota | 46019 | 127 | 3 |
601679 | 601679 | 2020-10-05 | Butte | South Dakota | 46019 | 132 | 3 |
604921 | 604921 | 2020-10-06 | Butte | South Dakota | 46019 | 136 | 3 |
608164 | 608164 | 2020-10-07 | Butte | South Dakota | 46019 | 144 | 3 |
611406 | 611406 | 2020-10-08 | Butte | South Dakota | 46019 | 149 | 3 |
614647 | 614647 | 2020-10-09 | Butte | South Dakota | 46019 | 153 | 3 |
617889 | 617889 | 2020-10-10 | Butte | South Dakota | 46019 | 161 | 3 |
621132 | 621132 | 2020-10-11 | Butte | South Dakota | 46019 | 167 | 3 |
624375 | 624375 | 2020-10-12 | Butte | South Dakota | 46019 | 171 | 3 |
627617 | 627617 | 2020-10-13 | Butte | South Dakota | 46019 | 172 | 3 |
630861 | 630861 | 2020-10-14 | Butte | South Dakota | 46019 | 179 | 3 |
634106 | 634106 | 2020-10-15 | Butte | South Dakota | 46019 | 184 | 3 |
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);