ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where cases = 24 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 |
---|---|---|---|---|---|---|---|
637380 | 637380 | 2020-10-16 | Jones | South Dakota | 46075 | 24 | 0 |
634134 | 634134 | 2020-10-15 | Jones | South Dakota | 46075 | 24 | 0 |
634156 | 634156 | 2020-10-15 | Sully | South Dakota | 46119 | 24 | 0 |
630911 | 630911 | 2020-10-14 | Sully | South Dakota | 46119 | 24 | 0 |
627667 | 627667 | 2020-10-13 | Sully | South Dakota | 46119 | 24 | 0 |
624425 | 624425 | 2020-10-12 | Sully | South Dakota | 46119 | 24 | 0 |
608189 | 608189 | 2020-10-07 | Hyde | South Dakota | 46069 | 24 | 0 |
582270 | 582270 | 2020-09-29 | Miner | South Dakota | 46097 | 24 | 0 |
575768 | 575768 | 2020-09-27 | Haakon | South Dakota | 46055 | 24 | 0 |
572507 | 572507 | 2020-09-26 | Campbell | South Dakota | 46021 | 24 | 0 |
566070 | 566070 | 2020-09-24 | Sanborn | South Dakota | 46111 | 24 | 0 |
549858 | 549858 | 2020-09-19 | Jackson | South Dakota | 46071 | 24 | 1 |
546613 | 546613 | 2020-09-18 | Hand | South Dakota | 46059 | 24 | 0 |
540141 | 540141 | 2020-09-16 | Hanson | South Dakota | 46061 | 24 | 0 |
536904 | 536904 | 2020-09-15 | Hanson | South Dakota | 46061 | 24 | 0 |
533668 | 533668 | 2020-09-14 | Hanson | South Dakota | 46061 | 24 | 0 |
533691 | 533691 | 2020-09-14 | Perkins | South Dakota | 46105 | 24 | 0 |
530433 | 530433 | 2020-09-13 | Hanson | South Dakota | 46061 | 24 | 0 |
530456 | 530456 | 2020-09-13 | Perkins | South Dakota | 46105 | 24 | 0 |
527196 | 527196 | 2020-09-12 | Hanson | South Dakota | 46061 | 24 | 0 |
527209 | 527209 | 2020-09-12 | Marshall | South Dakota | 46091 | 24 | 0 |
527219 | 527219 | 2020-09-12 | Perkins | South Dakota | 46105 | 24 | 0 |
523942 | 523942 | 2020-09-11 | Clark | South Dakota | 46025 | 24 | 0 |
523960 | 523960 | 2020-09-11 | Hanson | South Dakota | 46061 | 24 | 0 |
523983 | 523983 | 2020-09-11 | Perkins | South Dakota | 46105 | 24 | 0 |
520724 | 520724 | 2020-09-10 | Hanson | South Dakota | 46061 | 24 | 0 |
520747 | 520747 | 2020-09-10 | Perkins | South Dakota | 46105 | 24 | 0 |
517511 | 517511 | 2020-09-09 | Perkins | South Dakota | 46105 | 24 | 0 |
514276 | 514276 | 2020-09-08 | Perkins | South Dakota | 46105 | 24 | 0 |
507795 | 507795 | 2020-09-06 | Kingsbury | South Dakota | 46077 | 24 | 0 |
507811 | 507811 | 2020-09-06 | Potter | South Dakota | 46107 | 24 | 0 |
504563 | 504563 | 2020-09-05 | Kingsbury | South Dakota | 46077 | 24 | 0 |
504579 | 504579 | 2020-09-05 | Potter | South Dakota | 46107 | 24 | 0 |
501321 | 501321 | 2020-09-04 | Hanson | South Dakota | 46061 | 24 | 0 |
498087 | 498087 | 2020-09-03 | Hanson | South Dakota | 46061 | 24 | 0 |
498095 | 498095 | 2020-09-03 | Kingsbury | South Dakota | 46077 | 24 | 0 |
494827 | 494827 | 2020-09-02 | Bennett | South Dakota | 46007 | 24 | 0 |
491637 | 491637 | 2020-09-01 | Mellette | South Dakota | 46095 | 24 | 0 |
488404 | 488404 | 2020-08-31 | Mellette | South Dakota | 46095 | 24 | 0 |
485171 | 485171 | 2020-08-30 | Mellette | South Dakota | 46095 | 24 | 0 |
481936 | 481936 | 2020-08-29 | Mellette | South Dakota | 46095 | 24 | 0 |
478702 | 478702 | 2020-08-28 | Mellette | South Dakota | 46095 | 24 | 0 |
475469 | 475469 | 2020-08-27 | Mellette | South Dakota | 46095 | 24 | 0 |
472235 | 472235 | 2020-08-26 | Mellette | South Dakota | 46095 | 24 | 0 |
468979 | 468979 | 2020-08-25 | Fall River | South Dakota | 46047 | 24 | 0 |
469003 | 469003 | 2020-08-25 | Mellette | South Dakota | 46095 | 24 | 0 |
465751 | 465751 | 2020-08-24 | Fall River | South Dakota | 46047 | 24 | 0 |
465775 | 465775 | 2020-08-24 | Mellette | South Dakota | 46095 | 24 | 0 |
462546 | 462546 | 2020-08-23 | Mellette | South Dakota | 46095 | 24 | 0 |
459318 | 459318 | 2020-08-22 | Mellette | South Dakota | 46095 | 24 | 0 |
456052 | 456052 | 2020-08-21 | Butte | South Dakota | 46019 | 24 | 1 |
456090 | 456090 | 2020-08-21 | Mellette | South Dakota | 46095 | 24 | 0 |
452862 | 452862 | 2020-08-20 | Mellette | South Dakota | 46095 | 24 | 0 |
452879 | 452879 | 2020-08-20 | Walworth | South Dakota | 46129 | 24 | 0 |
449634 | 449634 | 2020-08-19 | Mellette | South Dakota | 46095 | 24 | 0 |
446378 | 446378 | 2020-08-18 | Deuel | South Dakota | 46039 | 24 | 0 |
446406 | 446406 | 2020-08-18 | Mellette | South Dakota | 46095 | 24 | 0 |
443152 | 443152 | 2020-08-17 | Deuel | South Dakota | 46039 | 24 | 0 |
443180 | 443180 | 2020-08-17 | Mellette | South Dakota | 46095 | 24 | 0 |
439910 | 439910 | 2020-08-16 | Bon Homme | South Dakota | 46009 | 24 | 0 |
439953 | 439953 | 2020-08-16 | Mellette | South Dakota | 46095 | 24 | 0 |
436728 | 436728 | 2020-08-15 | Mellette | South Dakota | 46095 | 24 | 0 |
433472 | 433472 | 2020-08-14 | Day | South Dakota | 46037 | 24 | 0 |
433501 | 433501 | 2020-08-14 | Mellette | South Dakota | 46095 | 24 | 0 |
430247 | 430247 | 2020-08-13 | Day | South Dakota | 46037 | 24 | 0 |
430276 | 430276 | 2020-08-13 | Mellette | South Dakota | 46095 | 24 | 0 |
427031 | 427031 | 2020-08-12 | Hamlin | South Dakota | 46057 | 24 | 0 |
427049 | 427049 | 2020-08-12 | Mellette | South Dakota | 46095 | 24 | 0 |
423826 | 423826 | 2020-08-11 | Mellette | South Dakota | 46095 | 24 | 0 |
420604 | 420604 | 2020-08-10 | Mellette | South Dakota | 46095 | 24 | 0 |
417383 | 417383 | 2020-08-09 | Mellette | South Dakota | 46095 | 24 | 0 |
414162 | 414162 | 2020-08-08 | Mellette | South Dakota | 46095 | 24 | 0 |
414172 | 414172 | 2020-08-08 | Spink | South Dakota | 46115 | 24 | 0 |
410921 | 410921 | 2020-08-07 | Grant | South Dakota | 46051 | 24 | 0 |
410942 | 410942 | 2020-08-07 | Mellette | South Dakota | 46095 | 24 | 0 |
410952 | 410952 | 2020-08-07 | Spink | South Dakota | 46115 | 24 | 0 |
407702 | 407702 | 2020-08-06 | Grant | South Dakota | 46051 | 24 | 0 |
407723 | 407723 | 2020-08-06 | Mellette | South Dakota | 46095 | 24 | 0 |
404503 | 404503 | 2020-08-05 | Mellette | South Dakota | 46095 | 24 | 0 |
401282 | 401282 | 2020-08-04 | McCook | South Dakota | 46087 | 24 | 1 |
401285 | 401285 | 2020-08-04 | Mellette | South Dakota | 46095 | 24 | 0 |
398067 | 398067 | 2020-08-03 | McCook | South Dakota | 46087 | 24 | 1 |
398070 | 398070 | 2020-08-03 | Mellette | South Dakota | 46095 | 24 | 0 |
394850 | 394850 | 2020-08-02 | McCook | South Dakota | 46087 | 24 | 1 |
394853 | 394853 | 2020-08-02 | Mellette | South Dakota | 46095 | 24 | 0 |
391634 | 391634 | 2020-08-01 | McCook | South Dakota | 46087 | 24 | 1 |
391637 | 391637 | 2020-08-01 | Mellette | South Dakota | 46095 | 24 | 0 |
388417 | 388417 | 2020-07-31 | McCook | South Dakota | 46087 | 24 | 1 |
388420 | 388420 | 2020-07-31 | Mellette | South Dakota | 46095 | 24 | 0 |
385200 | 385200 | 2020-07-30 | McCook | South Dakota | 46087 | 24 | 1 |
385203 | 385203 | 2020-07-30 | Mellette | South Dakota | 46095 | 24 | 0 |
381971 | 381971 | 2020-07-29 | Hutchinson | South Dakota | 46067 | 24 | 0 |
381982 | 381982 | 2020-07-29 | McCook | South Dakota | 46087 | 24 | 1 |
378737 | 378737 | 2020-07-28 | Corson | South Dakota | 46031 | 24 | 0 |
378754 | 378754 | 2020-07-28 | Hutchinson | South Dakota | 46067 | 24 | 0 |
378765 | 378765 | 2020-07-28 | McCook | South Dakota | 46087 | 24 | 1 |
375521 | 375521 | 2020-07-27 | Corson | South Dakota | 46031 | 24 | 0 |
375538 | 375538 | 2020-07-27 | Hutchinson | South Dakota | 46067 | 24 | 0 |
372308 | 372308 | 2020-07-26 | Corson | South Dakota | 46031 | 24 | 0 |
372325 | 372325 | 2020-07-26 | Hutchinson | South Dakota | 46067 | 24 | 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);