ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
672 rows where county = "Perkins" and state = "South Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324350 | 324350 | 2020-07-11 | Perkins | South Dakota | 46105 | 1 | 0 |
327535 | 327535 | 2020-07-12 | Perkins | South Dakota | 46105 | 1 | 0 |
330721 | 330721 | 2020-07-13 | Perkins | South Dakota | 46105 | 1 | 0 |
333913 | 333913 | 2020-07-14 | Perkins | South Dakota | 46105 | 1 | 0 |
337107 | 337107 | 2020-07-15 | Perkins | South Dakota | 46105 | 1 | 0 |
340304 | 340304 | 2020-07-16 | Perkins | South Dakota | 46105 | 3 | 0 |
343502 | 343502 | 2020-07-17 | Perkins | South Dakota | 46105 | 4 | 0 |
346702 | 346702 | 2020-07-18 | Perkins | South Dakota | 46105 | 4 | 0 |
349902 | 349902 | 2020-07-19 | Perkins | South Dakota | 46105 | 4 | 0 |
353105 | 353105 | 2020-07-20 | Perkins | South Dakota | 46105 | 4 | 0 |
356308 | 356308 | 2020-07-21 | Perkins | South Dakota | 46105 | 4 | 0 |
359512 | 359512 | 2020-07-22 | Perkins | South Dakota | 46105 | 4 | 0 |
362718 | 362718 | 2020-07-23 | Perkins | South Dakota | 46105 | 4 | 0 |
365924 | 365924 | 2020-07-24 | Perkins | South Dakota | 46105 | 4 | 0 |
369133 | 369133 | 2020-07-25 | Perkins | South Dakota | 46105 | 4 | 0 |
372345 | 372345 | 2020-07-26 | Perkins | South Dakota | 46105 | 4 | 0 |
375558 | 375558 | 2020-07-27 | Perkins | South Dakota | 46105 | 4 | 0 |
378774 | 378774 | 2020-07-28 | Perkins | South Dakota | 46105 | 4 | 0 |
381991 | 381991 | 2020-07-29 | Perkins | South Dakota | 46105 | 6 | 0 |
385209 | 385209 | 2020-07-30 | Perkins | South Dakota | 46105 | 6 | 0 |
388426 | 388426 | 2020-07-31 | Perkins | South Dakota | 46105 | 6 | 0 |
391643 | 391643 | 2020-08-01 | Perkins | South Dakota | 46105 | 6 | 0 |
394859 | 394859 | 2020-08-02 | Perkins | South Dakota | 46105 | 6 | 0 |
398076 | 398076 | 2020-08-03 | Perkins | South Dakota | 46105 | 6 | 0 |
401291 | 401291 | 2020-08-04 | Perkins | South Dakota | 46105 | 6 | 0 |
404509 | 404509 | 2020-08-05 | Perkins | South Dakota | 46105 | 6 | 0 |
407729 | 407729 | 2020-08-06 | Perkins | South Dakota | 46105 | 6 | 0 |
410948 | 410948 | 2020-08-07 | Perkins | South Dakota | 46105 | 6 | 0 |
414168 | 414168 | 2020-08-08 | Perkins | South Dakota | 46105 | 6 | 0 |
417389 | 417389 | 2020-08-09 | Perkins | South Dakota | 46105 | 6 | 0 |
420610 | 420610 | 2020-08-10 | Perkins | South Dakota | 46105 | 6 | 0 |
423832 | 423832 | 2020-08-11 | Perkins | South Dakota | 46105 | 6 | 0 |
427055 | 427055 | 2020-08-12 | Perkins | South Dakota | 46105 | 6 | 0 |
430282 | 430282 | 2020-08-13 | Perkins | South Dakota | 46105 | 6 | 0 |
433507 | 433507 | 2020-08-14 | Perkins | South Dakota | 46105 | 6 | 0 |
436734 | 436734 | 2020-08-15 | Perkins | South Dakota | 46105 | 6 | 0 |
439959 | 439959 | 2020-08-16 | Perkins | South Dakota | 46105 | 6 | 0 |
443186 | 443186 | 2020-08-17 | Perkins | South Dakota | 46105 | 6 | 0 |
446412 | 446412 | 2020-08-18 | Perkins | South Dakota | 46105 | 6 | 0 |
449640 | 449640 | 2020-08-19 | Perkins | South Dakota | 46105 | 6 | 0 |
452868 | 452868 | 2020-08-20 | Perkins | South Dakota | 46105 | 6 | 0 |
456096 | 456096 | 2020-08-21 | Perkins | South Dakota | 46105 | 6 | 0 |
459324 | 459324 | 2020-08-22 | Perkins | South Dakota | 46105 | 6 | 0 |
462552 | 462552 | 2020-08-23 | Perkins | South Dakota | 46105 | 6 | 0 |
465781 | 465781 | 2020-08-24 | Perkins | South Dakota | 46105 | 8 | 0 |
469009 | 469009 | 2020-08-25 | Perkins | South Dakota | 46105 | 9 | 0 |
472241 | 472241 | 2020-08-26 | Perkins | South Dakota | 46105 | 9 | 0 |
475475 | 475475 | 2020-08-27 | Perkins | South Dakota | 46105 | 13 | 0 |
478708 | 478708 | 2020-08-28 | Perkins | South Dakota | 46105 | 14 | 0 |
481942 | 481942 | 2020-08-29 | Perkins | South Dakota | 46105 | 14 | 0 |
485177 | 485177 | 2020-08-30 | Perkins | South Dakota | 46105 | 13 | 0 |
488410 | 488410 | 2020-08-31 | Perkins | South Dakota | 46105 | 16 | 0 |
491643 | 491643 | 2020-09-01 | Perkins | South Dakota | 46105 | 16 | 0 |
494877 | 494877 | 2020-09-02 | Perkins | South Dakota | 46105 | 19 | 0 |
498110 | 498110 | 2020-09-03 | Perkins | South Dakota | 46105 | 19 | 0 |
501344 | 501344 | 2020-09-04 | Perkins | South Dakota | 46105 | 23 | 0 |
504578 | 504578 | 2020-09-05 | Perkins | South Dakota | 46105 | 23 | 0 |
507810 | 507810 | 2020-09-06 | Perkins | South Dakota | 46105 | 23 | 0 |
511043 | 511043 | 2020-09-07 | Perkins | South Dakota | 46105 | 22 | 0 |
514276 | 514276 | 2020-09-08 | Perkins | South Dakota | 46105 | 24 | 0 |
517511 | 517511 | 2020-09-09 | Perkins | South Dakota | 46105 | 24 | 0 |
520747 | 520747 | 2020-09-10 | Perkins | South Dakota | 46105 | 24 | 0 |
523983 | 523983 | 2020-09-11 | Perkins | South Dakota | 46105 | 24 | 0 |
527219 | 527219 | 2020-09-12 | Perkins | South Dakota | 46105 | 24 | 0 |
530456 | 530456 | 2020-09-13 | Perkins | South Dakota | 46105 | 24 | 0 |
533691 | 533691 | 2020-09-14 | Perkins | South Dakota | 46105 | 24 | 0 |
536927 | 536927 | 2020-09-15 | Perkins | South Dakota | 46105 | 25 | 0 |
540164 | 540164 | 2020-09-16 | Perkins | South Dakota | 46105 | 27 | 0 |
543400 | 543400 | 2020-09-17 | Perkins | South Dakota | 46105 | 27 | 0 |
546637 | 546637 | 2020-09-18 | Perkins | South Dakota | 46105 | 28 | 0 |
549876 | 549876 | 2020-09-19 | Perkins | South Dakota | 46105 | 28 | 0 |
553115 | 553115 | 2020-09-20 | Perkins | South Dakota | 46105 | 30 | 0 |
556352 | 556352 | 2020-09-21 | Perkins | South Dakota | 46105 | 30 | 0 |
559589 | 559589 | 2020-09-22 | Perkins | South Dakota | 46105 | 34 | 0 |
562826 | 562826 | 2020-09-23 | Perkins | South Dakota | 46105 | 36 | 0 |
566067 | 566067 | 2020-09-24 | Perkins | South Dakota | 46105 | 36 | 0 |
569308 | 569308 | 2020-09-25 | Perkins | South Dakota | 46105 | 37 | 0 |
572550 | 572550 | 2020-09-26 | Perkins | South Dakota | 46105 | 37 | 0 |
575794 | 575794 | 2020-09-27 | Perkins | South Dakota | 46105 | 38 | 0 |
579035 | 579035 | 2020-09-28 | Perkins | South Dakota | 46105 | 40 | 0 |
582275 | 582275 | 2020-09-29 | Perkins | South Dakota | 46105 | 40 | 0 |
585515 | 585515 | 2020-09-30 | Perkins | South Dakota | 46105 | 41 | 0 |
588755 | 588755 | 2020-10-01 | Perkins | South Dakota | 46105 | 43 | 0 |
591996 | 591996 | 2020-10-02 | Perkins | South Dakota | 46105 | 42 | 0 |
595237 | 595237 | 2020-10-03 | Perkins | South Dakota | 46105 | 42 | 0 |
598480 | 598480 | 2020-10-04 | Perkins | South Dakota | 46105 | 44 | 0 |
601723 | 601723 | 2020-10-05 | Perkins | South Dakota | 46105 | 44 | 0 |
604965 | 604965 | 2020-10-06 | Perkins | South Dakota | 46105 | 44 | 0 |
608208 | 608208 | 2020-10-07 | Perkins | South Dakota | 46105 | 48 | 0 |
611450 | 611450 | 2020-10-08 | Perkins | South Dakota | 46105 | 47 | 0 |
614691 | 614691 | 2020-10-09 | Perkins | South Dakota | 46105 | 47 | 0 |
617933 | 617933 | 2020-10-10 | Perkins | South Dakota | 46105 | 47 | 0 |
621176 | 621176 | 2020-10-11 | Perkins | South Dakota | 46105 | 52 | 0 |
624419 | 624419 | 2020-10-12 | Perkins | South Dakota | 46105 | 52 | 0 |
627661 | 627661 | 2020-10-13 | Perkins | South Dakota | 46105 | 52 | 0 |
630905 | 630905 | 2020-10-14 | Perkins | South Dakota | 46105 | 54 | 0 |
634150 | 634150 | 2020-10-15 | Perkins | South Dakota | 46105 | 58 | 0 |
637396 | 637396 | 2020-10-16 | Perkins | South Dakota | 46105 | 59 | 0 |
640642 | 640642 | 2020-10-17 | Perkins | South Dakota | 46105 | 60 | 0 |
643890 | 643890 | 2020-10-18 | Perkins | South Dakota | 46105 | 61 | 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);