ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,335 rows where county = "Perkins" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
352337 | 352337 | 2020-07-20 | Perkins | Nebraska | 31135 | 7 | 0 |
355540 | 355540 | 2020-07-21 | Perkins | Nebraska | 31135 | 8 | 0 |
358744 | 358744 | 2020-07-22 | Perkins | Nebraska | 31135 | 8 | 0 |
361950 | 361950 | 2020-07-23 | Perkins | Nebraska | 31135 | 8 | 0 |
365156 | 365156 | 2020-07-24 | Perkins | Nebraska | 31135 | 8 | 0 |
368365 | 368365 | 2020-07-25 | Perkins | Nebraska | 31135 | 8 | 0 |
371576 | 371576 | 2020-07-26 | Perkins | Nebraska | 31135 | 9 | 0 |
374788 | 374788 | 2020-07-27 | Perkins | Nebraska | 31135 | 10 | 0 |
378004 | 378004 | 2020-07-28 | Perkins | Nebraska | 31135 | 10 | 1 |
381222 | 381222 | 2020-07-29 | Perkins | Nebraska | 31135 | 11 | 1 |
384438 | 384438 | 2020-07-30 | Perkins | Nebraska | 31135 | 12 | 1 |
387656 | 387656 | 2020-07-31 | Perkins | Nebraska | 31135 | 15 | 1 |
390873 | 390873 | 2020-08-01 | Perkins | Nebraska | 31135 | 15 | 1 |
394090 | 394090 | 2020-08-02 | Perkins | Nebraska | 31135 | 17 | 1 |
397306 | 397306 | 2020-08-03 | Perkins | Nebraska | 31135 | 17 | 1 |
400521 | 400521 | 2020-08-04 | Perkins | Nebraska | 31135 | 17 | 1 |
403739 | 403739 | 2020-08-05 | Perkins | Nebraska | 31135 | 17 | 1 |
406958 | 406958 | 2020-08-06 | Perkins | Nebraska | 31135 | 17 | 6 |
410178 | 410178 | 2020-08-07 | Perkins | Nebraska | 31135 | 19 | 7 |
413398 | 413398 | 2020-08-08 | Perkins | Nebraska | 31135 | 19 | 7 |
416618 | 416618 | 2020-08-09 | Perkins | Nebraska | 31135 | 18 | 7 |
419839 | 419839 | 2020-08-10 | Perkins | Nebraska | 31135 | 18 | 7 |
423062 | 423062 | 2020-08-11 | Perkins | Nebraska | 31135 | 18 | 7 |
426284 | 426284 | 2020-08-12 | Perkins | Nebraska | 31135 | 19 | 7 |
429509 | 429509 | 2020-08-13 | Perkins | Nebraska | 31135 | 19 | 7 |
432736 | 432736 | 2020-08-14 | Perkins | Nebraska | 31135 | 21 | 7 |
435962 | 435962 | 2020-08-15 | Perkins | Nebraska | 31135 | 21 | 7 |
439187 | 439187 | 2020-08-16 | Perkins | Nebraska | 31135 | 24 | 7 |
442414 | 442414 | 2020-08-17 | Perkins | Nebraska | 31135 | 24 | 7 |
445641 | 445641 | 2020-08-18 | Perkins | Nebraska | 31135 | 16 | 7 |
448867 | 448867 | 2020-08-19 | Perkins | Nebraska | 31135 | 25 | 7 |
452095 | 452095 | 2020-08-20 | Perkins | Nebraska | 31135 | 25 | 7 |
455323 | 455323 | 2020-08-21 | Perkins | Nebraska | 31135 | 27 | 7 |
458551 | 458551 | 2020-08-22 | Perkins | Nebraska | 31135 | 27 | 7 |
461778 | 461778 | 2020-08-23 | Perkins | Nebraska | 31135 | 28 | 7 |
465009 | 465009 | 2020-08-24 | Perkins | Nebraska | 31135 | 28 | 7 |
468238 | 468238 | 2020-08-25 | Perkins | Nebraska | 31135 | 28 | 7 |
471469 | 471469 | 2020-08-26 | Perkins | Nebraska | 31135 | 29 | 7 |
474702 | 474702 | 2020-08-27 | Perkins | Nebraska | 31135 | 29 | 7 |
477935 | 477935 | 2020-08-28 | Perkins | Nebraska | 31135 | 29 | 7 |
481167 | 481167 | 2020-08-29 | Perkins | Nebraska | 31135 | 29 | 7 |
484402 | 484402 | 2020-08-30 | Perkins | Nebraska | 31135 | 29 | 7 |
487636 | 487636 | 2020-08-31 | Perkins | Nebraska | 31135 | 30 | 7 |
490869 | 490869 | 2020-09-01 | Perkins | Nebraska | 31135 | 30 | 7 |
494103 | 494103 | 2020-09-02 | Perkins | Nebraska | 31135 | 29 | 7 |
497336 | 497336 | 2020-09-03 | Perkins | Nebraska | 31135 | 29 | 7 |
500570 | 500570 | 2020-09-04 | Perkins | Nebraska | 31135 | 30 | 7 |
503804 | 503804 | 2020-09-05 | Perkins | Nebraska | 31135 | 31 | 7 |
507037 | 507037 | 2020-09-06 | Perkins | Nebraska | 31135 | 31 | 7 |
510270 | 510270 | 2020-09-07 | Perkins | Nebraska | 31135 | 31 | 7 |
513502 | 513502 | 2020-09-08 | Perkins | Nebraska | 31135 | 31 | 9 |
516736 | 516736 | 2020-09-09 | Perkins | Nebraska | 31135 | 31 | 9 |
519971 | 519971 | 2020-09-10 | Perkins | Nebraska | 31135 | 31 | 9 |
523208 | 523208 | 2020-09-11 | Perkins | Nebraska | 31135 | 32 | 9 |
526444 | 526444 | 2020-09-12 | Perkins | Nebraska | 31135 | 32 | 9 |
529680 | 529680 | 2020-09-13 | Perkins | Nebraska | 31135 | 32 | 9 |
532916 | 532916 | 2020-09-14 | Perkins | Nebraska | 31135 | 32 | 9 |
536151 | 536151 | 2020-09-15 | Perkins | Nebraska | 31135 | 33 | 9 |
539389 | 539389 | 2020-09-16 | Perkins | Nebraska | 31135 | 33 | 9 |
542625 | 542625 | 2020-09-17 | Perkins | Nebraska | 31135 | 33 | 9 |
545862 | 545862 | 2020-09-18 | Perkins | Nebraska | 31135 | 33 | 9 |
549100 | 549100 | 2020-09-19 | Perkins | Nebraska | 31135 | 33 | 9 |
552339 | 552339 | 2020-09-20 | Perkins | Nebraska | 31135 | 33 | 9 |
555577 | 555577 | 2020-09-21 | Perkins | Nebraska | 31135 | 33 | 10 |
558814 | 558814 | 2020-09-22 | Perkins | Nebraska | 31135 | 33 | 10 |
562051 | 562051 | 2020-09-23 | Perkins | Nebraska | 31135 | 34 | 10 |
565292 | 565292 | 2020-09-24 | Perkins | Nebraska | 31135 | 34 | 10 |
568533 | 568533 | 2020-09-25 | Perkins | Nebraska | 31135 | 33 | 10 |
571775 | 571775 | 2020-09-26 | Perkins | Nebraska | 31135 | 33 | 10 |
575018 | 575018 | 2020-09-27 | Perkins | Nebraska | 31135 | 33 | 10 |
578259 | 578259 | 2020-09-28 | Perkins | Nebraska | 31135 | 32 | 10 |
581500 | 581500 | 2020-09-29 | Perkins | Nebraska | 31135 | 32 | 10 |
584741 | 584741 | 2020-09-30 | Perkins | Nebraska | 31135 | 32 | 10 |
587981 | 587981 | 2020-10-01 | Perkins | Nebraska | 31135 | 34 | 10 |
591222 | 591222 | 2020-10-02 | Perkins | Nebraska | 31135 | 34 | 10 |
594463 | 594463 | 2020-10-03 | Perkins | Nebraska | 31135 | 34 | 10 |
597705 | 597705 | 2020-10-04 | Perkins | Nebraska | 31135 | 34 | 10 |
600949 | 600949 | 2020-10-05 | Perkins | Nebraska | 31135 | 34 | 10 |
604191 | 604191 | 2020-10-06 | Perkins | Nebraska | 31135 | 34 | 10 |
607434 | 607434 | 2020-10-07 | Perkins | Nebraska | 31135 | 34 | 10 |
610676 | 610676 | 2020-10-08 | Perkins | Nebraska | 31135 | 34 | 10 |
613918 | 613918 | 2020-10-09 | Perkins | Nebraska | 31135 | 34 | 10 |
617159 | 617159 | 2020-10-10 | Perkins | Nebraska | 31135 | 36 | 10 |
620401 | 620401 | 2020-10-11 | Perkins | Nebraska | 31135 | 36 | 10 |
623644 | 623644 | 2020-10-12 | Perkins | Nebraska | 31135 | 36 | 10 |
626886 | 626886 | 2020-10-13 | Perkins | Nebraska | 31135 | 37 | 10 |
630130 | 630130 | 2020-10-14 | Perkins | Nebraska | 31135 | 37 | 10 |
633375 | 633375 | 2020-10-15 | Perkins | Nebraska | 31135 | 36 | 10 |
636621 | 636621 | 2020-10-16 | Perkins | Nebraska | 31135 | 36 | 10 |
639867 | 639867 | 2020-10-17 | Perkins | Nebraska | 31135 | 39 | 10 |
643115 | 643115 | 2020-10-18 | Perkins | Nebraska | 31135 | 39 | 10 |
646361 | 646361 | 2020-10-19 | Perkins | Nebraska | 31135 | 40 | 10 |
649605 | 649605 | 2020-10-20 | Perkins | Nebraska | 31135 | 40 | 10 |
652850 | 652850 | 2020-10-21 | Perkins | Nebraska | 31135 | 40 | 10 |
656095 | 656095 | 2020-10-22 | Perkins | Nebraska | 31135 | 41 | 10 |
659340 | 659340 | 2020-10-23 | Perkins | Nebraska | 31135 | 42 | 10 |
662584 | 662584 | 2020-10-24 | Perkins | Nebraska | 31135 | 43 | 10 |
665829 | 665829 | 2020-10-25 | Perkins | Nebraska | 31135 | 43 | 10 |
669073 | 669073 | 2020-10-26 | Perkins | Nebraska | 31135 | 44 | 10 |
672315 | 672315 | 2020-10-27 | Perkins | Nebraska | 31135 | 45 | 10 |
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);