ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lancaster" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090930 | 1090930 | 2021-03-05 | Lancaster | Nebraska | 31109 | 28432 | 218 |
1087685 | 1087685 | 2021-03-04 | Lancaster | Nebraska | 31109 | 28372 | 218 |
1084440 | 1084440 | 2021-03-03 | Lancaster | Nebraska | 31109 | 28327 | 218 |
1081194 | 1081194 | 2021-03-02 | Lancaster | Nebraska | 31109 | 28293 | 218 |
1077948 | 1077948 | 2021-03-01 | Lancaster | Nebraska | 31109 | 28210 | 218 |
1074702 | 1074702 | 2021-02-28 | Lancaster | Nebraska | 31109 | 28183 | 218 |
1071456 | 1071456 | 2021-02-27 | Lancaster | Nebraska | 31109 | 28107 | 218 |
1068211 | 1068211 | 2021-02-26 | Lancaster | Nebraska | 31109 | 28041 | 217 |
1064966 | 1064966 | 2021-02-25 | Lancaster | Nebraska | 31109 | 28041 | 217 |
1061722 | 1061722 | 2021-02-24 | Lancaster | Nebraska | 31109 | 27990 | 217 |
1058476 | 1058476 | 2021-02-23 | Lancaster | Nebraska | 31109 | 27932 | 214 |
1055230 | 1055230 | 2021-02-22 | Lancaster | Nebraska | 31109 | 27892 | 214 |
1051983 | 1051983 | 2021-02-21 | Lancaster | Nebraska | 31109 | 27850 | 214 |
1048736 | 1048736 | 2021-02-20 | Lancaster | Nebraska | 31109 | 27822 | 214 |
1045490 | 1045490 | 2021-02-19 | Lancaster | Nebraska | 31109 | 27774 | 214 |
1042245 | 1042245 | 2021-02-18 | Lancaster | Nebraska | 31109 | 27713 | 212 |
1039000 | 1039000 | 2021-02-17 | Lancaster | Nebraska | 31109 | 27630 | 211 |
1035755 | 1035755 | 2021-02-16 | Lancaster | Nebraska | 31109 | 27563 | 209 |
1032510 | 1032510 | 2021-02-15 | Lancaster | Nebraska | 31109 | 27540 | 208 |
1029263 | 1029263 | 2021-02-14 | Lancaster | Nebraska | 31109 | 27534 | 208 |
1026017 | 1026017 | 2021-02-13 | Lancaster | Nebraska | 31109 | 27494 | 208 |
1022772 | 1022772 | 2021-02-12 | Lancaster | Nebraska | 31109 | 27427 | 208 |
1019527 | 1019527 | 2021-02-11 | Lancaster | Nebraska | 31109 | 27378 | 208 |
1016282 | 1016282 | 2021-02-10 | Lancaster | Nebraska | 31109 | 27322 | 208 |
1013037 | 1013037 | 2021-02-09 | Lancaster | Nebraska | 31109 | 27256 | 207 |
1009792 | 1009792 | 2021-02-08 | Lancaster | Nebraska | 31109 | 27202 | 207 |
1006545 | 1006545 | 2021-02-07 | Lancaster | Nebraska | 31109 | 27159 | 206 |
1003299 | 1003299 | 2021-02-06 | Lancaster | Nebraska | 31109 | 27108 | 206 |
1000054 | 1000054 | 2021-02-05 | Lancaster | Nebraska | 31109 | 27067 | 205 |
996808 | 996808 | 2021-02-04 | Lancaster | Nebraska | 31109 | 27009 | 203 |
993562 | 993562 | 2021-02-03 | Lancaster | Nebraska | 31109 | 26958 | 200 |
990316 | 990316 | 2021-02-02 | Lancaster | Nebraska | 31109 | 26880 | 199 |
987069 | 987069 | 2021-02-01 | Lancaster | Nebraska | 31109 | 26789 | 198 |
983822 | 983822 | 2021-01-31 | Lancaster | Nebraska | 31109 | 26718 | 196 |
980576 | 980576 | 2021-01-30 | Lancaster | Nebraska | 31109 | 26650 | 196 |
977330 | 977330 | 2021-01-29 | Lancaster | Nebraska | 31109 | 26583 | 195 |
974085 | 974085 | 2021-01-28 | Lancaster | Nebraska | 31109 | 26509 | 191 |
970840 | 970840 | 2021-01-27 | Lancaster | Nebraska | 31109 | 26393 | 191 |
967595 | 967595 | 2021-01-26 | Lancaster | Nebraska | 31109 | 26280 | 190 |
964351 | 964351 | 2021-01-25 | Lancaster | Nebraska | 31109 | 26235 | 187 |
961106 | 961106 | 2021-01-24 | Lancaster | Nebraska | 31109 | 26193 | 185 |
957860 | 957860 | 2021-01-23 | Lancaster | Nebraska | 31109 | 26117 | 185 |
954615 | 954615 | 2021-01-22 | Lancaster | Nebraska | 31109 | 26003 | 185 |
951370 | 951370 | 2021-01-21 | Lancaster | Nebraska | 31109 | 25824 | 183 |
948124 | 948124 | 2021-01-20 | Lancaster | Nebraska | 31109 | 25697 | 183 |
944877 | 944877 | 2021-01-19 | Lancaster | Nebraska | 31109 | 25536 | 183 |
941632 | 941632 | 2021-01-18 | Lancaster | Nebraska | 31109 | 25301 | 179 |
938387 | 938387 | 2021-01-17 | Lancaster | Nebraska | 31109 | 25257 | 179 |
935142 | 935142 | 2021-01-16 | Lancaster | Nebraska | 31109 | 25050 | 176 |
931897 | 931897 | 2021-01-15 | Lancaster | Nebraska | 31109 | 25050 | 176 |
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 |
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);