ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 31109 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
928652 | 928652 | 2021-01-14 | Lancaster | Nebraska | 31109 | 24882 | 176 |
925406 | 925406 | 2021-01-13 | Lancaster | Nebraska | 31109 | 24705 | 175 |
922161 | 922161 | 2021-01-12 | Lancaster | Nebraska | 31109 | 24561 | 173 |
918916 | 918916 | 2021-01-11 | Lancaster | Nebraska | 31109 | 24280 | 169 |
915671 | 915671 | 2021-01-10 | Lancaster | Nebraska | 31109 | 24280 | 169 |
912426 | 912426 | 2021-01-09 | Lancaster | Nebraska | 31109 | 24199 | 169 |
909181 | 909181 | 2021-01-08 | Lancaster | Nebraska | 31109 | 23973 | 165 |
905935 | 905935 | 2021-01-07 | Lancaster | Nebraska | 31109 | 23772 | 163 |
902690 | 902690 | 2021-01-06 | Lancaster | Nebraska | 31109 | 23667 | 159 |
899445 | 899445 | 2021-01-05 | Lancaster | Nebraska | 31109 | 23426 | 159 |
896200 | 896200 | 2021-01-04 | Lancaster | Nebraska | 31109 | 23239 | 157 |
892953 | 892953 | 2021-01-03 | Lancaster | Nebraska | 31109 | 23163 | 152 |
889707 | 889707 | 2021-01-02 | Lancaster | Nebraska | 31109 | 23005 | 152 |
886461 | 886461 | 2021-01-01 | Lancaster | Nebraska | 31109 | 22654 | 152 |
883216 | 883216 | 2020-12-31 | Lancaster | Nebraska | 31109 | 22654 | 152 |
879971 | 879971 | 2020-12-30 | Lancaster | Nebraska | 31109 | 22461 | 151 |
876726 | 876726 | 2020-12-29 | Lancaster | Nebraska | 31109 | 22236 | 149 |
873481 | 873481 | 2020-12-28 | Lancaster | Nebraska | 31109 | 22083 | 147 |
870236 | 870236 | 2020-12-27 | Lancaster | Nebraska | 31109 | 21997 | 145 |
866991 | 866991 | 2020-12-26 | Lancaster | Nebraska | 31109 | 21816 | 145 |
863746 | 863746 | 2020-12-25 | Lancaster | Nebraska | 31109 | 21654 | 145 |
860501 | 860501 | 2020-12-24 | Lancaster | Nebraska | 31109 | 21654 | 145 |
857256 | 857256 | 2020-12-23 | Lancaster | Nebraska | 31109 | 21461 | 143 |
854011 | 854011 | 2020-12-22 | Lancaster | Nebraska | 31109 | 21295 | 140 |
850766 | 850766 | 2020-12-21 | Lancaster | Nebraska | 31109 | 21106 | 136 |
847521 | 847521 | 2020-12-20 | Lancaster | Nebraska | 31109 | 20906 | 134 |
844275 | 844275 | 2020-12-19 | Lancaster | Nebraska | 31109 | 20906 | 134 |
841030 | 841030 | 2020-12-18 | Lancaster | Nebraska | 31109 | 20741 | 134 |
837785 | 837785 | 2020-12-17 | Lancaster | Nebraska | 31109 | 20592 | 132 |
834539 | 834539 | 2020-12-16 | Lancaster | Nebraska | 31109 | 20477 | 127 |
831292 | 831292 | 2020-12-15 | Lancaster | Nebraska | 31109 | 20314 | 125 |
828046 | 828046 | 2020-12-14 | Lancaster | Nebraska | 31109 | 20124 | 120 |
824799 | 824799 | 2020-12-13 | Lancaster | Nebraska | 31109 | 20043 | 118 |
821553 | 821553 | 2020-12-12 | Lancaster | Nebraska | 31109 | 19762 | 118 |
818307 | 818307 | 2020-12-11 | Lancaster | Nebraska | 31109 | 19645 | 117 |
815061 | 815061 | 2020-12-10 | Lancaster | Nebraska | 31109 | 19466 | 114 |
811816 | 811816 | 2020-12-09 | Lancaster | Nebraska | 31109 | 19195 | 109 |
808571 | 808571 | 2020-12-08 | Lancaster | Nebraska | 31109 | 19023 | 102 |
805326 | 805326 | 2020-12-07 | Lancaster | Nebraska | 31109 | 18820 | 97 |
802081 | 802081 | 2020-12-06 | Lancaster | Nebraska | 31109 | 18616 | 92 |
798836 | 798836 | 2020-12-05 | Lancaster | Nebraska | 31109 | 18385 | 92 |
795591 | 795591 | 2020-12-04 | Lancaster | Nebraska | 31109 | 18101 | 91 |
792346 | 792346 | 2020-12-03 | Lancaster | Nebraska | 31109 | 17796 | 89 |
789101 | 789101 | 2020-12-02 | Lancaster | Nebraska | 31109 | 17453 | 84 |
785856 | 785856 | 2020-12-01 | Lancaster | Nebraska | 31109 | 17155 | 81 |
782612 | 782612 | 2020-11-30 | Lancaster | Nebraska | 31109 | 16821 | 78 |
779366 | 779366 | 2020-11-29 | Lancaster | Nebraska | 31109 | 16637 | 73 |
776121 | 776121 | 2020-11-28 | Lancaster | Nebraska | 31109 | 16341 | 72 |
772876 | 772876 | 2020-11-27 | Lancaster | Nebraska | 31109 | 16125 | 72 |
769631 | 769631 | 2020-11-26 | Lancaster | Nebraska | 31109 | 15710 | 72 |
766385 | 766385 | 2020-11-25 | Lancaster | Nebraska | 31109 | 15424 | 72 |
763140 | 763140 | 2020-11-24 | Lancaster | Nebraska | 31109 | 15061 | 72 |
759895 | 759895 | 2020-11-23 | Lancaster | Nebraska | 31109 | 14835 | 70 |
756648 | 756648 | 2020-11-22 | Lancaster | Nebraska | 31109 | 14526 | 67 |
753402 | 753402 | 2020-11-21 | Lancaster | Nebraska | 31109 | 14428 | 67 |
750156 | 750156 | 2020-11-20 | Lancaster | Nebraska | 31109 | 14150 | 66 |
746910 | 746910 | 2020-11-19 | Lancaster | Nebraska | 31109 | 13822 | 64 |
743663 | 743663 | 2020-11-18 | Lancaster | Nebraska | 31109 | 13548 | 63 |
740416 | 740416 | 2020-11-17 | Lancaster | Nebraska | 31109 | 13254 | 63 |
737172 | 737172 | 2020-11-16 | Lancaster | Nebraska | 31109 | 13077 | 61 |
733926 | 733926 | 2020-11-15 | Lancaster | Nebraska | 31109 | 12875 | 59 |
730681 | 730681 | 2020-11-14 | Lancaster | Nebraska | 31109 | 12499 | 58 |
727438 | 727438 | 2020-11-13 | Lancaster | Nebraska | 31109 | 12284 | 57 |
724195 | 724195 | 2020-11-12 | Lancaster | Nebraska | 31109 | 12123 | 57 |
720952 | 720952 | 2020-11-11 | Lancaster | Nebraska | 31109 | 11778 | 54 |
717709 | 717709 | 2020-11-10 | Lancaster | Nebraska | 31109 | 11513 | 54 |
714465 | 714465 | 2020-11-09 | Lancaster | Nebraska | 31109 | 11321 | 51 |
711221 | 711221 | 2020-11-08 | Lancaster | Nebraska | 31109 | 11120 | 50 |
707977 | 707977 | 2020-11-07 | Lancaster | Nebraska | 31109 | 10807 | 50 |
704734 | 704734 | 2020-11-06 | Lancaster | Nebraska | 31109 | 10580 | 50 |
701492 | 701492 | 2020-11-05 | Lancaster | Nebraska | 31109 | 10455 | 50 |
698248 | 698248 | 2020-11-04 | Lancaster | Nebraska | 31109 | 10242 | 50 |
695005 | 695005 | 2020-11-03 | Lancaster | Nebraska | 31109 | 10061 | 47 |
691763 | 691763 | 2020-11-02 | Lancaster | Nebraska | 31109 | 9917 | 45 |
688518 | 688518 | 2020-11-01 | Lancaster | Nebraska | 31109 | 9792 | 45 |
685274 | 685274 | 2020-10-31 | Lancaster | Nebraska | 31109 | 9660 | 45 |
682031 | 682031 | 2020-10-30 | Lancaster | Nebraska | 31109 | 9413 | 45 |
678787 | 678787 | 2020-10-29 | Lancaster | Nebraska | 31109 | 9330 | 45 |
675545 | 675545 | 2020-10-28 | Lancaster | Nebraska | 31109 | 9164 | 45 |
672302 | 672302 | 2020-10-27 | Lancaster | Nebraska | 31109 | 9072 | 43 |
669060 | 669060 | 2020-10-26 | Lancaster | Nebraska | 31109 | 8979 | 43 |
665816 | 665816 | 2020-10-25 | Lancaster | Nebraska | 31109 | 8877 | 43 |
662571 | 662571 | 2020-10-24 | Lancaster | Nebraska | 31109 | 8746 | 42 |
659327 | 659327 | 2020-10-23 | Lancaster | Nebraska | 31109 | 8668 | 42 |
656082 | 656082 | 2020-10-22 | Lancaster | Nebraska | 31109 | 8526 | 42 |
652837 | 652837 | 2020-10-21 | Lancaster | Nebraska | 31109 | 8445 | 41 |
649592 | 649592 | 2020-10-20 | Lancaster | Nebraska | 31109 | 8339 | 39 |
646348 | 646348 | 2020-10-19 | Lancaster | Nebraska | 31109 | 8205 | 37 |
643102 | 643102 | 2020-10-18 | Lancaster | Nebraska | 31109 | 8112 | 35 |
639854 | 639854 | 2020-10-17 | Lancaster | Nebraska | 31109 | 8054 | 35 |
636608 | 636608 | 2020-10-16 | Lancaster | Nebraska | 31109 | 7912 | 35 |
633362 | 633362 | 2020-10-15 | Lancaster | Nebraska | 31109 | 7825 | 33 |
630117 | 630117 | 2020-10-14 | Lancaster | Nebraska | 31109 | 7714 | 32 |
626873 | 626873 | 2020-10-13 | Lancaster | Nebraska | 31109 | 7620 | 32 |
623631 | 623631 | 2020-10-12 | Lancaster | Nebraska | 31109 | 7534 | 32 |
620388 | 620388 | 2020-10-11 | Lancaster | Nebraska | 31109 | 7481 | 31 |
617146 | 617146 | 2020-10-10 | Lancaster | Nebraska | 31109 | 7411 | 31 |
613905 | 613905 | 2020-10-09 | Lancaster | Nebraska | 31109 | 7289 | 30 |
610663 | 610663 | 2020-10-08 | Lancaster | Nebraska | 31109 | 7177 | 30 |
607421 | 607421 | 2020-10-07 | Lancaster | Nebraska | 31109 | 7075 | 30 |
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);