ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Jefferson" and fips = 31095 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
400504 | 400504 | 2020-08-04 | Jefferson | Nebraska | 31095 | 14 | 0 |
403722 | 403722 | 2020-08-05 | Jefferson | Nebraska | 31095 | 14 | 0 |
406941 | 406941 | 2020-08-06 | Jefferson | Nebraska | 31095 | 15 | 0 |
410161 | 410161 | 2020-08-07 | Jefferson | Nebraska | 31095 | 15 | 0 |
413381 | 413381 | 2020-08-08 | Jefferson | Nebraska | 31095 | 16 | 0 |
416601 | 416601 | 2020-08-09 | Jefferson | Nebraska | 31095 | 17 | 0 |
419822 | 419822 | 2020-08-10 | Jefferson | Nebraska | 31095 | 17 | 0 |
423045 | 423045 | 2020-08-11 | Jefferson | Nebraska | 31095 | 18 | 0 |
426267 | 426267 | 2020-08-12 | Jefferson | Nebraska | 31095 | 18 | 0 |
429492 | 429492 | 2020-08-13 | Jefferson | Nebraska | 31095 | 18 | 0 |
432719 | 432719 | 2020-08-14 | Jefferson | Nebraska | 31095 | 19 | 0 |
435945 | 435945 | 2020-08-15 | Jefferson | Nebraska | 31095 | 19 | 0 |
439170 | 439170 | 2020-08-16 | Jefferson | Nebraska | 31095 | 19 | 0 |
442397 | 442397 | 2020-08-17 | Jefferson | Nebraska | 31095 | 19 | 0 |
445623 | 445623 | 2020-08-18 | Jefferson | Nebraska | 31095 | 17 | 0 |
448849 | 448849 | 2020-08-19 | Jefferson | Nebraska | 31095 | 19 | 0 |
452077 | 452077 | 2020-08-20 | Jefferson | Nebraska | 31095 | 19 | 0 |
455305 | 455305 | 2020-08-21 | Jefferson | Nebraska | 31095 | 19 | 0 |
458533 | 458533 | 2020-08-22 | Jefferson | Nebraska | 31095 | 19 | 0 |
461760 | 461760 | 2020-08-23 | Jefferson | Nebraska | 31095 | 19 | 0 |
464991 | 464991 | 2020-08-24 | Jefferson | Nebraska | 31095 | 19 | 0 |
468220 | 468220 | 2020-08-25 | Jefferson | Nebraska | 31095 | 19 | 0 |
471450 | 471450 | 2020-08-26 | Jefferson | Nebraska | 31095 | 19 | 0 |
474682 | 474682 | 2020-08-27 | Jefferson | Nebraska | 31095 | 19 | 0 |
477915 | 477915 | 2020-08-28 | Jefferson | Nebraska | 31095 | 19 | 0 |
481147 | 481147 | 2020-08-29 | Jefferson | Nebraska | 31095 | 19 | 0 |
484382 | 484382 | 2020-08-30 | Jefferson | Nebraska | 31095 | 19 | 0 |
487616 | 487616 | 2020-08-31 | Jefferson | Nebraska | 31095 | 19 | 0 |
490849 | 490849 | 2020-09-01 | Jefferson | Nebraska | 31095 | 19 | 0 |
494083 | 494083 | 2020-09-02 | Jefferson | Nebraska | 31095 | 22 | 0 |
497316 | 497316 | 2020-09-03 | Jefferson | Nebraska | 31095 | 22 | 0 |
500550 | 500550 | 2020-09-04 | Jefferson | Nebraska | 31095 | 22 | 0 |
503784 | 503784 | 2020-09-05 | Jefferson | Nebraska | 31095 | 23 | 0 |
507017 | 507017 | 2020-09-06 | Jefferson | Nebraska | 31095 | 23 | 0 |
510250 | 510250 | 2020-09-07 | Jefferson | Nebraska | 31095 | 23 | 0 |
513482 | 513482 | 2020-09-08 | Jefferson | Nebraska | 31095 | 26 | 0 |
516716 | 516716 | 2020-09-09 | Jefferson | Nebraska | 31095 | 26 | 0 |
519951 | 519951 | 2020-09-10 | Jefferson | Nebraska | 31095 | 26 | 0 |
523188 | 523188 | 2020-09-11 | Jefferson | Nebraska | 31095 | 26 | 0 |
526424 | 526424 | 2020-09-12 | Jefferson | Nebraska | 31095 | 26 | 0 |
529660 | 529660 | 2020-09-13 | Jefferson | Nebraska | 31095 | 26 | 0 |
532896 | 532896 | 2020-09-14 | Jefferson | Nebraska | 31095 | 26 | 0 |
536131 | 536131 | 2020-09-15 | Jefferson | Nebraska | 31095 | 27 | 0 |
539369 | 539369 | 2020-09-16 | Jefferson | Nebraska | 31095 | 27 | 0 |
542605 | 542605 | 2020-09-17 | Jefferson | Nebraska | 31095 | 28 | 0 |
545842 | 545842 | 2020-09-18 | Jefferson | Nebraska | 31095 | 28 | 0 |
549080 | 549080 | 2020-09-19 | Jefferson | Nebraska | 31095 | 29 | 0 |
552319 | 552319 | 2020-09-20 | Jefferson | Nebraska | 31095 | 29 | 0 |
555557 | 555557 | 2020-09-21 | Jefferson | Nebraska | 31095 | 29 | 0 |
558794 | 558794 | 2020-09-22 | Jefferson | Nebraska | 31095 | 29 | 0 |
562031 | 562031 | 2020-09-23 | Jefferson | Nebraska | 31095 | 28 | 0 |
565272 | 565272 | 2020-09-24 | Jefferson | Nebraska | 31095 | 28 | 0 |
568513 | 568513 | 2020-09-25 | Jefferson | Nebraska | 31095 | 29 | 0 |
571755 | 571755 | 2020-09-26 | Jefferson | Nebraska | 31095 | 29 | 0 |
574998 | 574998 | 2020-09-27 | Jefferson | Nebraska | 31095 | 31 | 0 |
578239 | 578239 | 2020-09-28 | Jefferson | Nebraska | 31095 | 31 | 0 |
581480 | 581480 | 2020-09-29 | Jefferson | Nebraska | 31095 | 32 | 0 |
584721 | 584721 | 2020-09-30 | Jefferson | Nebraska | 31095 | 32 | 0 |
587961 | 587961 | 2020-10-01 | Jefferson | Nebraska | 31095 | 34 | 0 |
591202 | 591202 | 2020-10-02 | Jefferson | Nebraska | 31095 | 36 | 0 |
594443 | 594443 | 2020-10-03 | Jefferson | Nebraska | 31095 | 36 | 0 |
597685 | 597685 | 2020-10-04 | Jefferson | Nebraska | 31095 | 36 | 0 |
600929 | 600929 | 2020-10-05 | Jefferson | Nebraska | 31095 | 36 | 0 |
604171 | 604171 | 2020-10-06 | Jefferson | Nebraska | 31095 | 37 | 0 |
607414 | 607414 | 2020-10-07 | Jefferson | Nebraska | 31095 | 37 | 0 |
610656 | 610656 | 2020-10-08 | Jefferson | Nebraska | 31095 | 37 | 0 |
613898 | 613898 | 2020-10-09 | Jefferson | Nebraska | 31095 | 37 | 0 |
617139 | 617139 | 2020-10-10 | Jefferson | Nebraska | 31095 | 42 | 0 |
620381 | 620381 | 2020-10-11 | Jefferson | Nebraska | 31095 | 43 | 0 |
623624 | 623624 | 2020-10-12 | Jefferson | Nebraska | 31095 | 43 | 0 |
626866 | 626866 | 2020-10-13 | Jefferson | Nebraska | 31095 | 43 | 0 |
630110 | 630110 | 2020-10-14 | Jefferson | Nebraska | 31095 | 46 | 0 |
633355 | 633355 | 2020-10-15 | Jefferson | Nebraska | 31095 | 55 | 0 |
636601 | 636601 | 2020-10-16 | Jefferson | Nebraska | 31095 | 62 | 0 |
639847 | 639847 | 2020-10-17 | Jefferson | Nebraska | 31095 | 67 | 0 |
643095 | 643095 | 2020-10-18 | Jefferson | Nebraska | 31095 | 70 | 0 |
646341 | 646341 | 2020-10-19 | Jefferson | Nebraska | 31095 | 74 | 0 |
649585 | 649585 | 2020-10-20 | Jefferson | Nebraska | 31095 | 76 | 0 |
652830 | 652830 | 2020-10-21 | Jefferson | Nebraska | 31095 | 79 | 0 |
656075 | 656075 | 2020-10-22 | Jefferson | Nebraska | 31095 | 80 | 0 |
659320 | 659320 | 2020-10-23 | Jefferson | Nebraska | 31095 | 80 | 0 |
662564 | 662564 | 2020-10-24 | Jefferson | Nebraska | 31095 | 82 | 0 |
665809 | 665809 | 2020-10-25 | Jefferson | Nebraska | 31095 | 82 | 0 |
669053 | 669053 | 2020-10-26 | Jefferson | Nebraska | 31095 | 84 | 0 |
672295 | 672295 | 2020-10-27 | Jefferson | Nebraska | 31095 | 85 | 0 |
675538 | 675538 | 2020-10-28 | Jefferson | Nebraska | 31095 | 86 | 0 |
678780 | 678780 | 2020-10-29 | Jefferson | Nebraska | 31095 | 93 | 0 |
682024 | 682024 | 2020-10-30 | Jefferson | Nebraska | 31095 | 102 | 0 |
685267 | 685267 | 2020-10-31 | Jefferson | Nebraska | 31095 | 102 | 0 |
688511 | 688511 | 2020-11-01 | Jefferson | Nebraska | 31095 | 103 | 0 |
691756 | 691756 | 2020-11-02 | Jefferson | Nebraska | 31095 | 106 | 0 |
694998 | 694998 | 2020-11-03 | Jefferson | Nebraska | 31095 | 113 | 0 |
698241 | 698241 | 2020-11-04 | Jefferson | Nebraska | 31095 | 116 | 0 |
701485 | 701485 | 2020-11-05 | Jefferson | Nebraska | 31095 | 129 | 0 |
704727 | 704727 | 2020-11-06 | Jefferson | Nebraska | 31095 | 135 | 0 |
707970 | 707970 | 2020-11-07 | Jefferson | Nebraska | 31095 | 140 | 0 |
711214 | 711214 | 2020-11-08 | Jefferson | Nebraska | 31095 | 145 | 0 |
714458 | 714458 | 2020-11-09 | Jefferson | Nebraska | 31095 | 156 | 0 |
717702 | 717702 | 2020-11-10 | Jefferson | Nebraska | 31095 | 175 | 0 |
720945 | 720945 | 2020-11-11 | Jefferson | Nebraska | 31095 | 194 | 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);