ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where cases = 39 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 |
---|---|---|---|---|---|---|---|
702263 | 702263 | 2020-11-05 | Jones | South Dakota | 46075 | 39 | 0 |
673070 | 673070 | 2020-10-27 | Hyde | South Dakota | 46069 | 39 | 0 |
669828 | 669828 | 2020-10-26 | Hyde | South Dakota | 46069 | 39 | 0 |
660120 | 660120 | 2020-10-23 | Sully | South Dakota | 46119 | 39 | 0 |
656848 | 656848 | 2020-10-22 | Harding | South Dakota | 46063 | 39 | 0 |
656876 | 656876 | 2020-10-22 | Sully | South Dakota | 46119 | 39 | 0 |
653631 | 653631 | 2020-10-21 | Sully | South Dakota | 46119 | 39 | 0 |
598437 | 598437 | 2020-10-04 | Campbell | South Dakota | 46021 | 39 | 0 |
595240 | 595240 | 2020-10-03 | Sanborn | South Dakota | 46111 | 39 | 0 |
559590 | 559590 | 2020-09-22 | Potter | South Dakota | 46107 | 39 | 0 |
556353 | 556353 | 2020-09-21 | Potter | South Dakota | 46107 | 39 | 0 |
546622 | 546622 | 2020-09-18 | Kingsbury | South Dakota | 46077 | 39 | 0 |
530464 | 530464 | 2020-09-13 | Tripp | South Dakota | 46123 | 39 | 0 |
511012 | 511012 | 2020-09-07 | Edmunds | South Dakota | 46045 | 39 | 0 |
511016 | 511016 | 2020-09-07 | Gregory | South Dakota | 46053 | 39 | 1 |
507781 | 507781 | 2020-09-06 | Faulk | South Dakota | 46049 | 39 | 1 |
498075 | 498075 | 2020-09-03 | Day | South Dakota | 46037 | 39 | 0 |
485157 | 485157 | 2020-08-30 | Hutchinson | South Dakota | 46067 | 39 | 1 |
475472 | 475472 | 2020-08-27 | Moody | South Dakota | 46101 | 39 | 0 |
472192 | 472192 | 2020-08-26 | Bon Homme | South Dakota | 46009 | 39 | 1 |
472213 | 472213 | 2020-08-26 | Grant | South Dakota | 46051 | 39 | 0 |
472232 | 472232 | 2020-08-26 | McCook | South Dakota | 46087 | 39 | 1 |
468960 | 468960 | 2020-08-25 | Bon Homme | South Dakota | 46009 | 39 | 1 |
468981 | 468981 | 2020-08-25 | Grant | South Dakota | 46051 | 39 | 0 |
469000 | 469000 | 2020-08-25 | McCook | South Dakota | 46087 | 39 | 1 |
465732 | 465732 | 2020-08-24 | Bon Homme | South Dakota | 46009 | 39 | 1 |
465753 | 465753 | 2020-08-24 | Grant | South Dakota | 46051 | 39 | 0 |
465772 | 465772 | 2020-08-24 | McCook | South Dakota | 46087 | 39 | 1 |
462524 | 462524 | 2020-08-23 | Grant | South Dakota | 46051 | 39 | 0 |
462543 | 462543 | 2020-08-23 | McCook | South Dakota | 46087 | 39 | 1 |
459296 | 459296 | 2020-08-22 | Grant | South Dakota | 46051 | 39 | 0 |
459315 | 459315 | 2020-08-22 | McCook | South Dakota | 46087 | 39 | 1 |
456079 | 456079 | 2020-08-21 | Jerauld | South Dakota | 46073 | 39 | 1 |
452851 | 452851 | 2020-08-20 | Jerauld | South Dakota | 46073 | 39 | 1 |
449623 | 449623 | 2020-08-19 | Jerauld | South Dakota | 46073 | 39 | 1 |
446395 | 446395 | 2020-08-18 | Jerauld | South Dakota | 46073 | 39 | 1 |
443169 | 443169 | 2020-08-17 | Jerauld | South Dakota | 46073 | 39 | 1 |
439942 | 439942 | 2020-08-16 | Jerauld | South Dakota | 46073 | 39 | 1 |
436697 | 436697 | 2020-08-15 | Custer | South Dakota | 46033 | 39 | 0 |
436717 | 436717 | 2020-08-15 | Jerauld | South Dakota | 46073 | 39 | 1 |
433455 | 433455 | 2020-08-14 | Aurora | South Dakota | 46003 | 39 | 0 |
433490 | 433490 | 2020-08-14 | Jerauld | South Dakota | 46073 | 39 | 1 |
430265 | 430265 | 2020-08-13 | Jerauld | South Dakota | 46073 | 39 | 1 |
427038 | 427038 | 2020-08-12 | Jerauld | South Dakota | 46073 | 39 | 1 |
423815 | 423815 | 2020-08-11 | Jerauld | South Dakota | 46073 | 39 | 1 |
420593 | 420593 | 2020-08-10 | Jerauld | South Dakota | 46073 | 39 | 1 |
417372 | 417372 | 2020-08-09 | Jerauld | South Dakota | 46073 | 39 | 1 |
414151 | 414151 | 2020-08-08 | Jerauld | South Dakota | 46073 | 39 | 1 |
410931 | 410931 | 2020-08-07 | Jerauld | South Dakota | 46073 | 39 | 1 |
391626 | 391626 | 2020-08-01 | Jerauld | South Dakota | 46073 | 39 | 1 |
388409 | 388409 | 2020-07-31 | Jerauld | South Dakota | 46073 | 39 | 1 |
385164 | 385164 | 2020-07-30 | Brule | South Dakota | 46015 | 39 | 0 |
385192 | 385192 | 2020-07-30 | Jerauld | South Dakota | 46073 | 39 | 1 |
381974 | 381974 | 2020-07-29 | Jerauld | South Dakota | 46073 | 39 | 1 |
378757 | 378757 | 2020-07-28 | Jerauld | South Dakota | 46073 | 39 | 1 |
375541 | 375541 | 2020-07-27 | Jerauld | South Dakota | 46073 | 39 | 1 |
372328 | 372328 | 2020-07-26 | Jerauld | South Dakota | 46073 | 39 | 1 |
369116 | 369116 | 2020-07-25 | Jerauld | South Dakota | 46073 | 39 | 1 |
365907 | 365907 | 2020-07-24 | Jerauld | South Dakota | 46073 | 39 | 1 |
365933 | 365933 | 2020-07-24 | Turner | South Dakota | 46125 | 39 | 0 |
362701 | 362701 | 2020-07-23 | Jerauld | South Dakota | 46073 | 39 | 1 |
359495 | 359495 | 2020-07-22 | Jerauld | South Dakota | 46073 | 39 | 1 |
356291 | 356291 | 2020-07-21 | Jerauld | South Dakota | 46073 | 39 | 1 |
353088 | 353088 | 2020-07-20 | Jerauld | South Dakota | 46073 | 39 | 1 |
349885 | 349885 | 2020-07-19 | Jerauld | South Dakota | 46073 | 39 | 1 |
346685 | 346685 | 2020-07-18 | Jerauld | South Dakota | 46073 | 39 | 1 |
343485 | 343485 | 2020-07-17 | Jerauld | South Dakota | 46073 | 39 | 1 |
340287 | 340287 | 2020-07-16 | Jerauld | South Dakota | 46073 | 39 | 1 |
337090 | 337090 | 2020-07-15 | Jerauld | South Dakota | 46073 | 39 | 1 |
333896 | 333896 | 2020-07-14 | Jerauld | South Dakota | 46073 | 39 | 1 |
330704 | 330704 | 2020-07-13 | Jerauld | South Dakota | 46073 | 39 | 1 |
327518 | 327518 | 2020-07-12 | Jerauld | South Dakota | 46073 | 39 | 1 |
324333 | 324333 | 2020-07-11 | Jerauld | South Dakota | 46073 | 39 | 1 |
321153 | 321153 | 2020-07-10 | Jerauld | South Dakota | 46073 | 39 | 1 |
317975 | 317975 | 2020-07-09 | Jerauld | South Dakota | 46073 | 39 | 1 |
314802 | 314802 | 2020-07-08 | Jerauld | South Dakota | 46073 | 39 | 1 |
311629 | 311629 | 2020-07-07 | Jerauld | South Dakota | 46073 | 39 | 1 |
308460 | 308460 | 2020-07-06 | Jerauld | South Dakota | 46073 | 39 | 1 |
305292 | 305292 | 2020-07-05 | Jerauld | South Dakota | 46073 | 39 | 1 |
302129 | 302129 | 2020-07-04 | Jerauld | South Dakota | 46073 | 39 | 1 |
298965 | 298965 | 2020-07-03 | Jerauld | South Dakota | 46073 | 39 | 1 |
295805 | 295805 | 2020-07-02 | Jerauld | South Dakota | 46073 | 39 | 1 |
292649 | 292649 | 2020-07-01 | Jerauld | South Dakota | 46073 | 39 | 1 |
289497 | 289497 | 2020-06-30 | Jerauld | South Dakota | 46073 | 39 | 1 |
286346 | 286346 | 2020-06-29 | Jerauld | South Dakota | 46073 | 39 | 1 |
283184 | 283184 | 2020-06-28 | Davison | South Dakota | 46035 | 39 | 1 |
283201 | 283201 | 2020-06-28 | Jerauld | South Dakota | 46073 | 39 | 1 |
280055 | 280055 | 2020-06-27 | Jerauld | South Dakota | 46073 | 39 | 1 |
276907 | 276907 | 2020-06-26 | Jerauld | South Dakota | 46073 | 39 | 1 |
273760 | 273760 | 2020-06-25 | Jerauld | South Dakota | 46073 | 39 | 1 |
270621 | 270621 | 2020-06-24 | Jerauld | South Dakota | 46073 | 39 | 1 |
267487 | 267487 | 2020-06-23 | Jerauld | South Dakota | 46073 | 39 | 1 |
264359 | 264359 | 2020-06-22 | Jerauld | South Dakota | 46073 | 39 | 1 |
261231 | 261231 | 2020-06-21 | Jerauld | South Dakota | 46073 | 39 | 1 |
258104 | 258104 | 2020-06-20 | Jerauld | South Dakota | 46073 | 39 | 1 |
254978 | 254978 | 2020-06-19 | Jerauld | South Dakota | 46073 | 39 | 1 |
248721 | 248721 | 2020-06-17 | Brookings | South Dakota | 46011 | 39 | 0 |
248753 | 248753 | 2020-06-17 | Lyman | South Dakota | 46085 | 39 | 0 |
248757 | 248757 | 2020-06-17 | Meade | South Dakota | 46093 | 39 | 1 |
245644 | 245644 | 2020-06-16 | Meade | South Dakota | 46093 | 39 | 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);