ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

8,137 rows where county = "Lincoln" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

  • Lincoln · 8,137 ✖
Link rowid date ▲ county state fips cases deaths
1092602 1092602 2021-03-06 Lincoln Arkansas 5079 3158 44
1092734 1092734 2021-03-06 Lincoln Colorado 8073 998 3
1092932 1092932 2021-03-06 Lincoln Georgia 13181 760 24
1093040 1093040 2021-03-06 Lincoln Idaho 16063 486 11
1093400 1093400 2021-03-06 Lincoln Kansas 20105 256 4
1093522 1093522 2021-03-06 Lincoln Kentucky 21137 2132 33
1093604 1093604 2021-03-06 Lincoln Louisiana 22061 4238 89
1093646 1093646 2021-03-06 Lincoln Maine 23015 593 2
1093819 1093819 2021-03-06 Lincoln Minnesota 27081 512 2
1093909 1093909 2021-03-06 Lincoln Mississippi 28085 3624 104
1094007 1094007 2021-03-06 Lincoln Missouri 29113 4320 39
1094092 1094092 2021-03-06 Lincoln Montana 30053 1502 13
1094177 1094177 2021-03-06 Lincoln Nebraska 31111 3588 52
1094224 1094224 2021-03-06 Lincoln Nevada 32017 348 1
1094279 1094279 2021-03-06 Lincoln New Mexico 35027 1554 16
1094410 1094410 2021-03-06 Lincoln North Carolina 37109 8904 71
1094641 1094641 2021-03-06 Lincoln Oklahoma 40081 3095 54
1094699 1094699 2021-03-06 Lincoln Oregon 41041 1139 20
1094953 1094953 2021-03-06 Lincoln South Dakota 46083 7837 77
1095030 1095030 2021-03-06 Lincoln Tennessee 47103 4164 62
1095531 1095531 2021-03-06 Lincoln Washington 53043 341 5
1095570 1095570 2021-03-06 Lincoln West Virginia 54043 1239 13
1095638 1095638 2021-03-06 Lincoln Wisconsin 55069 3110 76
1095687 1095687 2021-03-06 Lincoln Wyoming 56023 1248 11
1089356 1089356 2021-03-05 Lincoln Arkansas 5079 3158 44
1089488 1089488 2021-03-05 Lincoln Colorado 8073 999 3
1089686 1089686 2021-03-05 Lincoln Georgia 13181 759 24
1089794 1089794 2021-03-05 Lincoln Idaho 16063 486 11
1090154 1090154 2021-03-05 Lincoln Kansas 20105 256 4
1090276 1090276 2021-03-05 Lincoln Kentucky 21137 2131 33
1090358 1090358 2021-03-05 Lincoln Louisiana 22061 4238 89
1090400 1090400 2021-03-05 Lincoln Maine 23015 590 2
1090573 1090573 2021-03-05 Lincoln Minnesota 27081 512 2
1090663 1090663 2021-03-05 Lincoln Mississippi 28085 3590 104
1090761 1090761 2021-03-05 Lincoln Missouri 29113 4317 39
1090846 1090846 2021-03-05 Lincoln Montana 30053 1501 13
1090931 1090931 2021-03-05 Lincoln Nebraska 31111 3586 52
1090978 1090978 2021-03-05 Lincoln Nevada 32017 348 1
1091033 1091033 2021-03-05 Lincoln New Mexico 35027 1554 16
1091164 1091164 2021-03-05 Lincoln North Carolina 37109 8885 71
1091395 1091395 2021-03-05 Lincoln Oklahoma 40081 3092 54
1091453 1091453 2021-03-05 Lincoln Oregon 41041 1137 20
1091707 1091707 2021-03-05 Lincoln South Dakota 46083 7817 77
1091784 1091784 2021-03-05 Lincoln Tennessee 47103 4159 62
1092285 1092285 2021-03-05 Lincoln Washington 53043 341 5
1092324 1092324 2021-03-05 Lincoln West Virginia 54043 1236 13
1092392 1092392 2021-03-05 Lincoln Wisconsin 55069 3109 76
1092441 1092441 2021-03-05 Lincoln Wyoming 56023 1248 11
1086111 1086111 2021-03-04 Lincoln Arkansas 5079 3154 44
1086243 1086243 2021-03-04 Lincoln Colorado 8073 998 3
1086441 1086441 2021-03-04 Lincoln Georgia 13181 758 24
1086549 1086549 2021-03-04 Lincoln Idaho 16063 487 11
1086909 1086909 2021-03-04 Lincoln Kansas 20105 255 4
1087031 1087031 2021-03-04 Lincoln Kentucky 21137 2130 33
1087113 1087113 2021-03-04 Lincoln Louisiana 22061 4236 89
1087155 1087155 2021-03-04 Lincoln Maine 23015 587 2
1087328 1087328 2021-03-04 Lincoln Minnesota 27081 512 2
1087418 1087418 2021-03-04 Lincoln Mississippi 28085 3564 104
1087516 1087516 2021-03-04 Lincoln Missouri 29113 4311 39
1087601 1087601 2021-03-04 Lincoln Montana 30053 1499 13
1087686 1087686 2021-03-04 Lincoln Nebraska 31111 3583 52
1087733 1087733 2021-03-04 Lincoln Nevada 32017 347 1
1087788 1087788 2021-03-04 Lincoln New Mexico 35027 1552 16
1087919 1087919 2021-03-04 Lincoln North Carolina 37109 8866 71
1088149 1088149 2021-03-04 Lincoln Oklahoma 40081 3072 54
1088207 1088207 2021-03-04 Lincoln Oregon 41041 1137 20
1088461 1088461 2021-03-04 Lincoln South Dakota 46083 7807 77
1088538 1088538 2021-03-04 Lincoln Tennessee 47103 4156 62
1089039 1089039 2021-03-04 Lincoln Washington 53043 340 5
1089078 1089078 2021-03-04 Lincoln West Virginia 54043 1233 13
1089146 1089146 2021-03-04 Lincoln Wisconsin 55069 3108 75
1089195 1089195 2021-03-04 Lincoln Wyoming 56023 1244 11
1082865 1082865 2021-03-03 Lincoln Arkansas 5079 3152 44
1082997 1082997 2021-03-03 Lincoln Colorado 8073 998 3
1083195 1083195 2021-03-03 Lincoln Georgia 13181 757 23
1083303 1083303 2021-03-03 Lincoln Idaho 16063 486 11
1083663 1083663 2021-03-03 Lincoln Kansas 20105 255 4
1083785 1083785 2021-03-03 Lincoln Kentucky 21137 2129 33
1083867 1083867 2021-03-03 Lincoln Louisiana 22061 4228 89
1083909 1083909 2021-03-03 Lincoln Maine 23015 585 2
1084083 1084083 2021-03-03 Lincoln Minnesota 27081 509 2
1084173 1084173 2021-03-03 Lincoln Mississippi 28085 3552 104
1084271 1084271 2021-03-03 Lincoln Missouri 29113 4303 39
1084356 1084356 2021-03-03 Lincoln Montana 30053 1499 13
1084441 1084441 2021-03-03 Lincoln Nebraska 31111 3580 52
1084488 1084488 2021-03-03 Lincoln Nevada 32017 347 1
1084543 1084543 2021-03-03 Lincoln New Mexico 35027 1550 16
1084674 1084674 2021-03-03 Lincoln North Carolina 37109 8850 71
1084904 1084904 2021-03-03 Lincoln Oklahoma 40081 3064 54
1084962 1084962 2021-03-03 Lincoln Oregon 41041 1136 20
1085216 1085216 2021-03-03 Lincoln South Dakota 46083 7784 77
1085293 1085293 2021-03-03 Lincoln Tennessee 47103 4144 62
1085794 1085794 2021-03-03 Lincoln Washington 53043 340 5
1085833 1085833 2021-03-03 Lincoln West Virginia 54043 1230 13
1085901 1085901 2021-03-03 Lincoln Wisconsin 55069 3108 75
1085950 1085950 2021-03-03 Lincoln Wyoming 56023 1242 11
1079619 1079619 2021-03-02 Lincoln Arkansas 5079 3152 44
1079751 1079751 2021-03-02 Lincoln Colorado 8073 998 3
1079949 1079949 2021-03-02 Lincoln Georgia 13181 756 22
1080057 1080057 2021-03-02 Lincoln Idaho 16063 486 11

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);