ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 27 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 |
---|---|---|---|---|---|---|---|
656854 | 656854 | 2020-10-22 | Jones | South Dakota | 46075 | 27 | 0 |
650364 | 650364 | 2020-10-20 | Jones | South Dakota | 46075 | 27 | 0 |
647120 | 647120 | 2020-10-19 | Jones | South Dakota | 46075 | 27 | 0 |
643874 | 643874 | 2020-10-18 | Jones | South Dakota | 46075 | 27 | 0 |
637402 | 637402 | 2020-10-16 | Sully | South Dakota | 46119 | 27 | 0 |
588750 | 588750 | 2020-10-01 | Miner | South Dakota | 46097 | 27 | 0 |
585489 | 585489 | 2020-09-30 | Haakon | South Dakota | 46055 | 27 | 0 |
569311 | 569311 | 2020-09-25 | Sanborn | South Dakota | 46111 | 27 | 0 |
559565 | 559565 | 2020-09-22 | Hand | South Dakota | 46059 | 27 | 0 |
559571 | 559571 | 2020-09-22 | Jackson | South Dakota | 46071 | 27 | 1 |
556344 | 556344 | 2020-09-21 | McPherson | South Dakota | 46089 | 27 | 0 |
553107 | 553107 | 2020-09-20 | McPherson | South Dakota | 46089 | 27 | 0 |
549868 | 549868 | 2020-09-19 | McPherson | South Dakota | 46089 | 27 | 0 |
543377 | 543377 | 2020-09-17 | Hanson | South Dakota | 46061 | 27 | 0 |
543400 | 543400 | 2020-09-17 | Perkins | South Dakota | 46105 | 27 | 0 |
540158 | 540158 | 2020-09-16 | Mellette | South Dakota | 46095 | 27 | 0 |
540164 | 540164 | 2020-09-16 | Perkins | South Dakota | 46105 | 27 | 0 |
540169 | 540169 | 2020-09-16 | Stanley | South Dakota | 46117 | 27 | 0 |
536932 | 536932 | 2020-09-15 | Stanley | South Dakota | 46117 | 27 | 0 |
533681 | 533681 | 2020-09-14 | Marshall | South Dakota | 46091 | 27 | 0 |
533696 | 533696 | 2020-09-14 | Stanley | South Dakota | 46117 | 27 | 0 |
530415 | 530415 | 2020-09-13 | Clark | South Dakota | 46025 | 27 | 0 |
530461 | 530461 | 2020-09-13 | Stanley | South Dakota | 46117 | 27 | 0 |
527178 | 527178 | 2020-09-12 | Clark | South Dakota | 46025 | 27 | 0 |
523984 | 523984 | 2020-09-11 | Potter | South Dakota | 46107 | 27 | 0 |
520732 | 520732 | 2020-09-10 | Kingsbury | South Dakota | 46077 | 27 | 0 |
517496 | 517496 | 2020-09-09 | Kingsbury | South Dakota | 46077 | 27 | 0 |
514284 | 514284 | 2020-09-08 | Tripp | South Dakota | 46123 | 27 | 0 |
511051 | 511051 | 2020-09-07 | Tripp | South Dakota | 46123 | 27 | 0 |
488378 | 488378 | 2020-08-31 | Douglas | South Dakota | 46043 | 27 | 0 |
475444 | 475444 | 2020-08-27 | Edmunds | South Dakota | 46045 | 27 | 0 |
472211 | 472211 | 2020-08-26 | Fall River | South Dakota | 46047 | 27 | 0 |
462508 | 462508 | 2020-08-23 | Butte | South Dakota | 46019 | 27 | 1 |
456062 | 456062 | 2020-08-21 | Deuel | South Dakota | 46039 | 27 | 0 |
456107 | 456107 | 2020-08-21 | Walworth | South Dakota | 46129 | 27 | 0 |
452872 | 452872 | 2020-08-20 | Spink | South Dakota | 46115 | 27 | 0 |
449644 | 449644 | 2020-08-19 | Spink | South Dakota | 46115 | 27 | 0 |
446416 | 446416 | 2020-08-18 | Spink | South Dakota | 46115 | 27 | 0 |
443190 | 443190 | 2020-08-17 | Spink | South Dakota | 46115 | 27 | 0 |
439963 | 439963 | 2020-08-16 | Spink | South Dakota | 46115 | 27 | 0 |
436709 | 436709 | 2020-08-15 | Hamlin | South Dakota | 46057 | 27 | 0 |
433482 | 433482 | 2020-08-14 | Hamlin | South Dakota | 46057 | 27 | 0 |
427028 | 427028 | 2020-08-12 | Grant | South Dakota | 46051 | 27 | 0 |
423804 | 423804 | 2020-08-11 | Faulk | South Dakota | 46049 | 27 | 1 |
423805 | 423805 | 2020-08-11 | Grant | South Dakota | 46051 | 27 | 0 |
420582 | 420582 | 2020-08-10 | Faulk | South Dakota | 46049 | 27 | 1 |
420583 | 420583 | 2020-08-10 | Grant | South Dakota | 46051 | 27 | 0 |
414159 | 414159 | 2020-08-08 | McCook | South Dakota | 46087 | 27 | 1 |
410928 | 410928 | 2020-08-07 | Hutchinson | South Dakota | 46067 | 27 | 0 |
407709 | 407709 | 2020-08-06 | Hutchinson | South Dakota | 46067 | 27 | 0 |
404489 | 404489 | 2020-08-05 | Hutchinson | South Dakota | 46067 | 27 | 0 |
401271 | 401271 | 2020-08-04 | Hutchinson | South Dakota | 46067 | 27 | 0 |
398056 | 398056 | 2020-08-03 | Hutchinson | South Dakota | 46067 | 27 | 0 |
391630 | 391630 | 2020-08-01 | Lawrence | South Dakota | 46081 | 27 | 0 |
369130 | 369130 | 2020-07-25 | Moody | South Dakota | 46101 | 27 | 0 |
317960 | 317960 | 2020-07-09 | Dewey | South Dakota | 46041 | 27 | 0 |
314826 | 314826 | 2020-07-08 | Turner | South Dakota | 46125 | 27 | 0 |
311652 | 311652 | 2020-07-07 | Turner | South Dakota | 46125 | 27 | 0 |
308483 | 308483 | 2020-07-06 | Turner | South Dakota | 46125 | 27 | 0 |
251859 | 251859 | 2020-06-18 | Hughes | South Dakota | 46065 | 27 | 0 |
223896 | 223896 | 2020-06-09 | Lyman | South Dakota | 46085 | 27 | 0 |
217687 | 217687 | 2020-06-07 | Davison | South Dakota | 46035 | 27 | 1 |
214593 | 214593 | 2020-06-06 | Clay | South Dakota | 46027 | 27 | 0 |
214597 | 214597 | 2020-06-06 | Davison | South Dakota | 46035 | 27 | 1 |
211498 | 211498 | 2020-06-05 | Aurora | South Dakota | 46003 | 27 | 0 |
208416 | 208416 | 2020-06-04 | Aurora | South Dakota | 46003 | 27 | 0 |
205335 | 205335 | 2020-06-03 | Aurora | South Dakota | 46003 | 27 | 0 |
199229 | 199229 | 2020-06-01 | Todd | South Dakota | 46121 | 27 | 1 |
196156 | 196156 | 2020-05-31 | Todd | South Dakota | 46121 | 27 | 1 |
135543 | 135543 | 2020-05-11 | Pennington | South Dakota | 46103 | 27 | 0 |
108946 | 108946 | 2020-05-02 | Union | South Dakota | 46127 | 27 | 0 |
108948 | 108948 | 2020-05-02 | Yankton | South Dakota | 46135 | 27 | 0 |
106081 | 106081 | 2020-05-01 | Yankton | South Dakota | 46135 | 27 | 0 |
103218 | 103218 | 2020-04-30 | Yankton | South Dakota | 46135 | 27 | 0 |
100365 | 100365 | 2020-04-29 | Yankton | South Dakota | 46135 | 27 | 0 |
97515 | 97515 | 2020-04-28 | Yankton | South Dakota | 46135 | 27 | 0 |
94675 | 94675 | 2020-04-27 | Yankton | South Dakota | 46135 | 27 | 0 |
80576 | 80576 | 2020-04-22 | Brown | South Dakota | 46013 | 27 | 0 |
40050 | 40050 | 2020-04-07 | Lincoln | South Dakota | 46083 | 27 | 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);