ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where cases = 8 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
621154 | 621154 | 2020-10-11 | Harding | South Dakota | 46063 | 8 | 0 |
540145 | 540145 | 2020-09-16 | Hyde | South Dakota | 46069 | 8 | 0 |
540170 | 540170 | 2020-09-16 | Sully | South Dakota | 46119 | 8 | 0 |
536908 | 536908 | 2020-09-15 | Hyde | South Dakota | 46069 | 8 | 0 |
536933 | 536933 | 2020-09-15 | Sully | South Dakota | 46119 | 8 | 0 |
533672 | 533672 | 2020-09-14 | Hyde | South Dakota | 46069 | 8 | 0 |
533697 | 533697 | 2020-09-14 | Sully | South Dakota | 46119 | 8 | 0 |
530437 | 530437 | 2020-09-13 | Hyde | South Dakota | 46069 | 8 | 0 |
530462 | 530462 | 2020-09-13 | Sully | South Dakota | 46119 | 8 | 0 |
527200 | 527200 | 2020-09-12 | Hyde | South Dakota | 46069 | 8 | 0 |
527225 | 527225 | 2020-09-12 | Sully | South Dakota | 46119 | 8 | 0 |
523964 | 523964 | 2020-09-11 | Hyde | South Dakota | 46069 | 8 | 0 |
523989 | 523989 | 2020-09-11 | Sully | South Dakota | 46119 | 8 | 0 |
520721 | 520721 | 2020-09-10 | Haakon | South Dakota | 46055 | 8 | 0 |
520728 | 520728 | 2020-09-10 | Hyde | South Dakota | 46069 | 8 | 0 |
520753 | 520753 | 2020-09-10 | Sully | South Dakota | 46119 | 8 | 0 |
517485 | 517485 | 2020-09-09 | Haakon | South Dakota | 46055 | 8 | 0 |
517517 | 517517 | 2020-09-09 | Sully | South Dakota | 46119 | 8 | 0 |
514250 | 514250 | 2020-09-08 | Haakon | South Dakota | 46055 | 8 | 0 |
514282 | 514282 | 2020-09-08 | Sully | South Dakota | 46119 | 8 | 0 |
511024 | 511024 | 2020-09-07 | Hyde | South Dakota | 46069 | 8 | 0 |
511049 | 511049 | 2020-09-07 | Sully | South Dakota | 46119 | 8 | 0 |
507791 | 507791 | 2020-09-06 | Hyde | South Dakota | 46069 | 8 | 0 |
507816 | 507816 | 2020-09-06 | Sully | South Dakota | 46119 | 8 | 0 |
504559 | 504559 | 2020-09-05 | Hyde | South Dakota | 46069 | 8 | 0 |
504584 | 504584 | 2020-09-05 | Sully | South Dakota | 46119 | 8 | 0 |
501325 | 501325 | 2020-09-04 | Hyde | South Dakota | 46069 | 8 | 0 |
501350 | 501350 | 2020-09-04 | Sully | South Dakota | 46119 | 8 | 0 |
498091 | 498091 | 2020-09-03 | Hyde | South Dakota | 46069 | 8 | 0 |
498116 | 498116 | 2020-09-03 | Sully | South Dakota | 46119 | 8 | 0 |
494883 | 494883 | 2020-09-02 | Sully | South Dakota | 46119 | 8 | 0 |
491649 | 491649 | 2020-09-01 | Sully | South Dakota | 46119 | 8 | 0 |
488416 | 488416 | 2020-08-31 | Sully | South Dakota | 46119 | 8 | 0 |
485183 | 485183 | 2020-08-30 | Sully | South Dakota | 46119 | 8 | 0 |
481948 | 481948 | 2020-08-29 | Sully | South Dakota | 46119 | 8 | 0 |
478714 | 478714 | 2020-08-28 | Sully | South Dakota | 46119 | 8 | 0 |
475481 | 475481 | 2020-08-27 | Sully | South Dakota | 46119 | 8 | 0 |
472247 | 472247 | 2020-08-26 | Sully | South Dakota | 46119 | 8 | 0 |
469015 | 469015 | 2020-08-25 | Sully | South Dakota | 46119 | 8 | 0 |
465781 | 465781 | 2020-08-24 | Perkins | South Dakota | 46105 | 8 | 0 |
465787 | 465787 | 2020-08-24 | Sully | South Dakota | 46119 | 8 | 0 |
462525 | 462525 | 2020-08-23 | Gregory | South Dakota | 46053 | 8 | 0 |
459297 | 459297 | 2020-08-22 | Gregory | South Dakota | 46053 | 8 | 0 |
456069 | 456069 | 2020-08-21 | Gregory | South Dakota | 46053 | 8 | 0 |
452841 | 452841 | 2020-08-20 | Gregory | South Dakota | 46053 | 8 | 0 |
452860 | 452860 | 2020-08-20 | McPherson | South Dakota | 46089 | 8 | 0 |
449613 | 449613 | 2020-08-19 | Gregory | South Dakota | 46053 | 8 | 0 |
449632 | 449632 | 2020-08-19 | McPherson | South Dakota | 46089 | 8 | 0 |
446385 | 446385 | 2020-08-18 | Gregory | South Dakota | 46053 | 8 | 0 |
446404 | 446404 | 2020-08-18 | McPherson | South Dakota | 46089 | 8 | 0 |
443159 | 443159 | 2020-08-17 | Gregory | South Dakota | 46053 | 8 | 0 |
443178 | 443178 | 2020-08-17 | McPherson | South Dakota | 46089 | 8 | 0 |
439951 | 439951 | 2020-08-16 | McPherson | South Dakota | 46089 | 8 | 0 |
436726 | 436726 | 2020-08-15 | McPherson | South Dakota | 46089 | 8 | 0 |
433499 | 433499 | 2020-08-14 | McPherson | South Dakota | 46089 | 8 | 0 |
430274 | 430274 | 2020-08-13 | McPherson | South Dakota | 46089 | 8 | 0 |
427047 | 427047 | 2020-08-12 | McPherson | South Dakota | 46089 | 8 | 0 |
423809 | 423809 | 2020-08-11 | Hand | South Dakota | 46059 | 8 | 0 |
423824 | 423824 | 2020-08-11 | McPherson | South Dakota | 46089 | 8 | 0 |
420587 | 420587 | 2020-08-10 | Hand | South Dakota | 46059 | 8 | 0 |
420602 | 420602 | 2020-08-10 | McPherson | South Dakota | 46089 | 8 | 0 |
417381 | 417381 | 2020-08-09 | McPherson | South Dakota | 46089 | 8 | 0 |
414160 | 414160 | 2020-08-08 | McPherson | South Dakota | 46089 | 8 | 0 |
410938 | 410938 | 2020-08-07 | Marshall | South Dakota | 46091 | 8 | 0 |
410940 | 410940 | 2020-08-07 | McPherson | South Dakota | 46089 | 8 | 0 |
407719 | 407719 | 2020-08-06 | Marshall | South Dakota | 46091 | 8 | 0 |
407721 | 407721 | 2020-08-06 | McPherson | South Dakota | 46089 | 8 | 0 |
404499 | 404499 | 2020-08-05 | Marshall | South Dakota | 46091 | 8 | 0 |
401281 | 401281 | 2020-08-04 | Marshall | South Dakota | 46091 | 8 | 0 |
401304 | 401304 | 2020-08-04 | Ziebach | South Dakota | 46137 | 8 | 0 |
398043 | 398043 | 2020-08-03 | Deuel | South Dakota | 46039 | 8 | 0 |
398066 | 398066 | 2020-08-03 | Marshall | South Dakota | 46091 | 8 | 0 |
398089 | 398089 | 2020-08-03 | Ziebach | South Dakota | 46137 | 8 | 0 |
394826 | 394826 | 2020-08-02 | Deuel | South Dakota | 46039 | 8 | 0 |
394849 | 394849 | 2020-08-02 | Marshall | South Dakota | 46091 | 8 | 0 |
394872 | 394872 | 2020-08-02 | Ziebach | South Dakota | 46137 | 8 | 0 |
391610 | 391610 | 2020-08-01 | Deuel | South Dakota | 46039 | 8 | 0 |
391625 | 391625 | 2020-08-01 | Jackson | South Dakota | 46071 | 8 | 1 |
391633 | 391633 | 2020-08-01 | Marshall | South Dakota | 46091 | 8 | 0 |
391656 | 391656 | 2020-08-01 | Ziebach | South Dakota | 46137 | 8 | 0 |
388408 | 388408 | 2020-07-31 | Jackson | South Dakota | 46071 | 8 | 1 |
388416 | 388416 | 2020-07-31 | Marshall | South Dakota | 46091 | 8 | 0 |
388439 | 388439 | 2020-07-31 | Ziebach | South Dakota | 46137 | 8 | 0 |
385199 | 385199 | 2020-07-30 | Marshall | South Dakota | 46091 | 8 | 0 |
385222 | 385222 | 2020-07-30 | Ziebach | South Dakota | 46137 | 8 | 0 |
381981 | 381981 | 2020-07-29 | Marshall | South Dakota | 46091 | 8 | 0 |
382004 | 382004 | 2020-07-29 | Ziebach | South Dakota | 46137 | 8 | 0 |
378731 | 378731 | 2020-07-28 | Butte | South Dakota | 46019 | 8 | 1 |
378741 | 378741 | 2020-07-28 | Deuel | South Dakota | 46039 | 8 | 0 |
378764 | 378764 | 2020-07-28 | Marshall | South Dakota | 46091 | 8 | 0 |
375515 | 375515 | 2020-07-27 | Butte | South Dakota | 46019 | 8 | 1 |
375525 | 375525 | 2020-07-27 | Deuel | South Dakota | 46039 | 8 | 0 |
375548 | 375548 | 2020-07-27 | Marshall | South Dakota | 46091 | 8 | 0 |
372302 | 372302 | 2020-07-26 | Butte | South Dakota | 46019 | 8 | 1 |
372335 | 372335 | 2020-07-26 | Marshall | South Dakota | 46091 | 8 | 0 |
369090 | 369090 | 2020-07-25 | Butte | South Dakota | 46019 | 8 | 1 |
369123 | 369123 | 2020-07-25 | Marshall | South Dakota | 46091 | 8 | 0 |
365881 | 365881 | 2020-07-24 | Butte | South Dakota | 46019 | 8 | 1 |
359497 | 359497 | 2020-07-22 | Kingsbury | South Dakota | 46077 | 8 | 0 |
356293 | 356293 | 2020-07-21 | Kingsbury | South Dakota | 46077 | 8 | 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);