ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Jefferson" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948117 | 948117 | 2021-01-20 | Jefferson | Nebraska | 31095 | 599 | 1 |
944870 | 944870 | 2021-01-19 | Jefferson | Nebraska | 31095 | 590 | 1 |
941625 | 941625 | 2021-01-18 | Jefferson | Nebraska | 31095 | 590 | 1 |
938380 | 938380 | 2021-01-17 | Jefferson | Nebraska | 31095 | 588 | 1 |
935135 | 935135 | 2021-01-16 | Jefferson | Nebraska | 31095 | 587 | 1 |
931890 | 931890 | 2021-01-15 | Jefferson | Nebraska | 31095 | 587 | 1 |
928645 | 928645 | 2021-01-14 | Jefferson | Nebraska | 31095 | 585 | 1 |
925399 | 925399 | 2021-01-13 | Jefferson | Nebraska | 31095 | 577 | 1 |
922154 | 922154 | 2021-01-12 | Jefferson | Nebraska | 31095 | 576 | 1 |
918909 | 918909 | 2021-01-11 | Jefferson | Nebraska | 31095 | 574 | 1 |
915664 | 915664 | 2021-01-10 | Jefferson | Nebraska | 31095 | 574 | 1 |
912419 | 912419 | 2021-01-09 | Jefferson | Nebraska | 31095 | 572 | 1 |
909174 | 909174 | 2021-01-08 | Jefferson | Nebraska | 31095 | 570 | 1 |
905928 | 905928 | 2021-01-07 | Jefferson | Nebraska | 31095 | 568 | 1 |
902683 | 902683 | 2021-01-06 | Jefferson | Nebraska | 31095 | 566 | 1 |
899438 | 899438 | 2021-01-05 | Jefferson | Nebraska | 31095 | 560 | 1 |
896193 | 896193 | 2021-01-04 | Jefferson | Nebraska | 31095 | 558 | 1 |
892946 | 892946 | 2021-01-03 | Jefferson | Nebraska | 31095 | 558 | 1 |
889700 | 889700 | 2021-01-02 | Jefferson | Nebraska | 31095 | 557 | 1 |
886454 | 886454 | 2021-01-01 | Jefferson | Nebraska | 31095 | 555 | 1 |
883209 | 883209 | 2020-12-31 | Jefferson | Nebraska | 31095 | 555 | 1 |
879964 | 879964 | 2020-12-30 | Jefferson | Nebraska | 31095 | 546 | 1 |
876719 | 876719 | 2020-12-29 | Jefferson | Nebraska | 31095 | 543 | 1 |
873474 | 873474 | 2020-12-28 | Jefferson | Nebraska | 31095 | 545 | 0 |
870229 | 870229 | 2020-12-27 | Jefferson | Nebraska | 31095 | 545 | 0 |
866984 | 866984 | 2020-12-26 | Jefferson | Nebraska | 31095 | 545 | 0 |
863739 | 863739 | 2020-12-25 | Jefferson | Nebraska | 31095 | 544 | 0 |
860494 | 860494 | 2020-12-24 | Jefferson | Nebraska | 31095 | 544 | 0 |
857249 | 857249 | 2020-12-23 | Jefferson | Nebraska | 31095 | 541 | 0 |
854004 | 854004 | 2020-12-22 | Jefferson | Nebraska | 31095 | 536 | 0 |
850759 | 850759 | 2020-12-21 | Jefferson | Nebraska | 31095 | 533 | 0 |
847514 | 847514 | 2020-12-20 | Jefferson | Nebraska | 31095 | 529 | 0 |
844268 | 844268 | 2020-12-19 | Jefferson | Nebraska | 31095 | 529 | 0 |
841023 | 841023 | 2020-12-18 | Jefferson | Nebraska | 31095 | 525 | 0 |
837778 | 837778 | 2020-12-17 | Jefferson | Nebraska | 31095 | 522 | 0 |
834532 | 834532 | 2020-12-16 | Jefferson | Nebraska | 31095 | 508 | 0 |
831285 | 831285 | 2020-12-15 | Jefferson | Nebraska | 31095 | 504 | 0 |
828039 | 828039 | 2020-12-14 | Jefferson | Nebraska | 31095 | 501 | 0 |
824792 | 824792 | 2020-12-13 | Jefferson | Nebraska | 31095 | 494 | 0 |
821546 | 821546 | 2020-12-12 | Jefferson | Nebraska | 31095 | 491 | 0 |
818300 | 818300 | 2020-12-11 | Jefferson | Nebraska | 31095 | 486 | 0 |
815054 | 815054 | 2020-12-10 | Jefferson | Nebraska | 31095 | 477 | 0 |
811809 | 811809 | 2020-12-09 | Jefferson | Nebraska | 31095 | 458 | 0 |
808564 | 808564 | 2020-12-08 | Jefferson | Nebraska | 31095 | 453 | 0 |
805319 | 805319 | 2020-12-07 | Jefferson | Nebraska | 31095 | 450 | 0 |
802074 | 802074 | 2020-12-06 | Jefferson | Nebraska | 31095 | 437 | 0 |
798829 | 798829 | 2020-12-05 | Jefferson | Nebraska | 31095 | 434 | 0 |
795584 | 795584 | 2020-12-04 | Jefferson | Nebraska | 31095 | 425 | 0 |
792339 | 792339 | 2020-12-03 | Jefferson | Nebraska | 31095 | 412 | 0 |
789094 | 789094 | 2020-12-02 | Jefferson | Nebraska | 31095 | 382 | 0 |
785849 | 785849 | 2020-12-01 | Jefferson | Nebraska | 31095 | 371 | 0 |
782605 | 782605 | 2020-11-30 | Jefferson | Nebraska | 31095 | 369 | 0 |
779359 | 779359 | 2020-11-29 | Jefferson | Nebraska | 31095 | 363 | 0 |
776114 | 776114 | 2020-11-28 | Jefferson | Nebraska | 31095 | 360 | 0 |
772869 | 772869 | 2020-11-27 | Jefferson | Nebraska | 31095 | 358 | 0 |
769624 | 769624 | 2020-11-26 | Jefferson | Nebraska | 31095 | 357 | 0 |
766378 | 766378 | 2020-11-25 | Jefferson | Nebraska | 31095 | 341 | 0 |
763133 | 763133 | 2020-11-24 | Jefferson | Nebraska | 31095 | 327 | 0 |
759888 | 759888 | 2020-11-23 | Jefferson | Nebraska | 31095 | 316 | 0 |
756641 | 756641 | 2020-11-22 | Jefferson | Nebraska | 31095 | 292 | 0 |
753395 | 753395 | 2020-11-21 | Jefferson | Nebraska | 31095 | 287 | 0 |
750149 | 750149 | 2020-11-20 | Jefferson | Nebraska | 31095 | 280 | 0 |
746903 | 746903 | 2020-11-19 | Jefferson | Nebraska | 31095 | 272 | 0 |
743656 | 743656 | 2020-11-18 | Jefferson | Nebraska | 31095 | 266 | 0 |
740409 | 740409 | 2020-11-17 | Jefferson | Nebraska | 31095 | 257 | 0 |
737165 | 737165 | 2020-11-16 | Jefferson | Nebraska | 31095 | 252 | 0 |
733919 | 733919 | 2020-11-15 | Jefferson | Nebraska | 31095 | 242 | 0 |
730674 | 730674 | 2020-11-14 | Jefferson | Nebraska | 31095 | 232 | 0 |
727431 | 727431 | 2020-11-13 | Jefferson | Nebraska | 31095 | 230 | 0 |
724188 | 724188 | 2020-11-12 | Jefferson | Nebraska | 31095 | 218 | 0 |
720945 | 720945 | 2020-11-11 | Jefferson | Nebraska | 31095 | 194 | 0 |
717702 | 717702 | 2020-11-10 | Jefferson | Nebraska | 31095 | 175 | 0 |
714458 | 714458 | 2020-11-09 | Jefferson | Nebraska | 31095 | 156 | 0 |
711214 | 711214 | 2020-11-08 | Jefferson | Nebraska | 31095 | 145 | 0 |
707970 | 707970 | 2020-11-07 | Jefferson | Nebraska | 31095 | 140 | 0 |
704727 | 704727 | 2020-11-06 | Jefferson | Nebraska | 31095 | 135 | 0 |
701485 | 701485 | 2020-11-05 | Jefferson | Nebraska | 31095 | 129 | 0 |
698241 | 698241 | 2020-11-04 | Jefferson | Nebraska | 31095 | 116 | 0 |
694998 | 694998 | 2020-11-03 | Jefferson | Nebraska | 31095 | 113 | 0 |
691756 | 691756 | 2020-11-02 | Jefferson | Nebraska | 31095 | 106 | 0 |
688511 | 688511 | 2020-11-01 | Jefferson | Nebraska | 31095 | 103 | 0 |
685267 | 685267 | 2020-10-31 | Jefferson | Nebraska | 31095 | 102 | 0 |
682024 | 682024 | 2020-10-30 | Jefferson | Nebraska | 31095 | 102 | 0 |
678780 | 678780 | 2020-10-29 | Jefferson | Nebraska | 31095 | 93 | 0 |
675538 | 675538 | 2020-10-28 | Jefferson | Nebraska | 31095 | 86 | 0 |
672295 | 672295 | 2020-10-27 | Jefferson | Nebraska | 31095 | 85 | 0 |
669053 | 669053 | 2020-10-26 | Jefferson | Nebraska | 31095 | 84 | 0 |
665809 | 665809 | 2020-10-25 | Jefferson | Nebraska | 31095 | 82 | 0 |
662564 | 662564 | 2020-10-24 | Jefferson | Nebraska | 31095 | 82 | 0 |
659320 | 659320 | 2020-10-23 | Jefferson | Nebraska | 31095 | 80 | 0 |
656075 | 656075 | 2020-10-22 | Jefferson | Nebraska | 31095 | 80 | 0 |
652830 | 652830 | 2020-10-21 | Jefferson | Nebraska | 31095 | 79 | 0 |
649585 | 649585 | 2020-10-20 | Jefferson | Nebraska | 31095 | 76 | 0 |
646341 | 646341 | 2020-10-19 | Jefferson | Nebraska | 31095 | 74 | 0 |
643095 | 643095 | 2020-10-18 | Jefferson | Nebraska | 31095 | 70 | 0 |
639847 | 639847 | 2020-10-17 | Jefferson | Nebraska | 31095 | 67 | 0 |
636601 | 636601 | 2020-10-16 | Jefferson | Nebraska | 31095 | 62 | 0 |
633355 | 633355 | 2020-10-15 | Jefferson | Nebraska | 31095 | 55 | 0 |
630110 | 630110 | 2020-10-14 | Jefferson | Nebraska | 31095 | 46 | 0 |
626866 | 626866 | 2020-10-13 | Jefferson | Nebraska | 31095 | 43 | 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);