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

18,529 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 24

county 1

  • Lincoln · 18,529 ✖
Link rowid date ▲ county state fips cases deaths
2499725 2499725 2022-05-13 Lincoln Arkansas 5079 4920 68
2499857 2499857 2022-05-13 Lincoln Colorado 8073 2199 9
2500055 2500055 2022-05-13 Lincoln Georgia 13181 1601 35
2500164 2500164 2022-05-13 Lincoln Idaho 16063 1107 15
2500525 2500525 2022-05-13 Lincoln Kansas 20105 623 10
2500647 2500647 2022-05-13 Lincoln Kentucky 21137 6487 137
2500729 2500729 2022-05-13 Lincoln Louisiana 22061 12269 144
2500771 2500771 2022-05-13 Lincoln Maine 23015 5578 35
2500945 2500945 2022-05-13 Lincoln Minnesota 27081 1220 6
2501035 2501035 2022-05-13 Lincoln Mississippi 28085 8324 157
2501134 2501134 2022-05-13 Lincoln Missouri 29113 15187 138
2501219 2501219 2022-05-13 Lincoln Montana 30053 4787 89
2501304 2501304 2022-05-13 Lincoln Nebraska 31111 8706 110
2501352 2501352 2022-05-13 Lincoln Nevada 32017 550 7
2501408 2501408 2022-05-13 Lincoln New Mexico 35027 5296 67
2501540 2501540 2022-05-13 Lincoln North Carolina 37109 24543 174
2501773 2501773 2022-05-13 Lincoln Oklahoma 40081 7897 140
2501831 2501831 2022-05-13 Lincoln Oregon 41041 7223 85
2502085 2502085 2022-05-13 Lincoln South Dakota 46083 15590 102
2502162 2502162 2022-05-13 Lincoln Tennessee 47103 10003 170
2502664 2502664 2022-05-13 Lincoln Washington 53043 2224 28
2502704 2502704 2022-05-13 Lincoln West Virginia 54043 5606 82
2502772 2502772 2022-05-13 Lincoln Wisconsin 55069 7188 148
2502821 2502821 2022-05-13 Lincoln Wyoming 56023 3979 31
2496467 2496467 2022-05-12 Lincoln Arkansas 5079 4919 68
2496599 2496599 2022-05-12 Lincoln Colorado 8073 2199 9
2496797 2496797 2022-05-12 Lincoln Georgia 13181 1601 35
2496906 2496906 2022-05-12 Lincoln Idaho 16063 1107 15
2497267 2497267 2022-05-12 Lincoln Kansas 20105 623 10
2497389 2497389 2022-05-12 Lincoln Kentucky 21137 6487 137
2497471 2497471 2022-05-12 Lincoln Louisiana 22061 12266 144
2497513 2497513 2022-05-12 Lincoln Maine 23015 5566 35
2497687 2497687 2022-05-12 Lincoln Minnesota 27081 1219 6
2497777 2497777 2022-05-12 Lincoln Mississippi 28085 8324 157
2497876 2497876 2022-05-12 Lincoln Missouri 29113 15152 138
2497961 2497961 2022-05-12 Lincoln Montana 30053 4784 89
2498046 2498046 2022-05-12 Lincoln Nebraska 31111 8698 110
2498094 2498094 2022-05-12 Lincoln Nevada 32017 550 7
2498150 2498150 2022-05-12 Lincoln New Mexico 35027 5295 67
2498282 2498282 2022-05-12 Lincoln North Carolina 37109 24543 174
2498515 2498515 2022-05-12 Lincoln Oklahoma 40081 7897 140
2498573 2498573 2022-05-12 Lincoln Oregon 41041 7211 85
2498827 2498827 2022-05-12 Lincoln South Dakota 46083 15590 102
2498904 2498904 2022-05-12 Lincoln Tennessee 47103 10003 170
2499406 2499406 2022-05-12 Lincoln Washington 53043 2219 28
2499446 2499446 2022-05-12 Lincoln West Virginia 54043 5601 82
2499514 2499514 2022-05-12 Lincoln Wisconsin 55069 7174 148
2499563 2499563 2022-05-12 Lincoln Wyoming 56023 3979 31
2493209 2493209 2022-05-11 Lincoln Arkansas 5079 4919 68
2493341 2493341 2022-05-11 Lincoln Colorado 8073 2186 9
2493539 2493539 2022-05-11 Lincoln Georgia 13181 1601 35
2493648 2493648 2022-05-11 Lincoln Idaho 16063 1107 15
2494009 2494009 2022-05-11 Lincoln Kansas 20105 623 10
2494131 2494131 2022-05-11 Lincoln Kentucky 21137 6487 137
2494213 2494213 2022-05-11 Lincoln Louisiana 22061 12264 144
2494255 2494255 2022-05-11 Lincoln Maine 23015 5551 35
2494429 2494429 2022-05-11 Lincoln Minnesota 27081 1219 6
2494519 2494519 2022-05-11 Lincoln Mississippi 28085 8324 157
2494618 2494618 2022-05-11 Lincoln Missouri 29113 15152 138
2494703 2494703 2022-05-11 Lincoln Montana 30053 4784 89
2494788 2494788 2022-05-11 Lincoln Nebraska 31111 8698 110
2494836 2494836 2022-05-11 Lincoln Nevada 32017 550 7
2494892 2494892 2022-05-11 Lincoln New Mexico 35027 5292 67
2495024 2495024 2022-05-11 Lincoln North Carolina 37109 24543 174
2495257 2495257 2022-05-11 Lincoln Oklahoma 40081 7887 140
2495315 2495315 2022-05-11 Lincoln Oregon 41041 7196 85
2495569 2495569 2022-05-11 Lincoln South Dakota 46083 15590 102
2495646 2495646 2022-05-11 Lincoln Tennessee 47103 10003 170
2496148 2496148 2022-05-11 Lincoln Washington 53043 2219 28
2496188 2496188 2022-05-11 Lincoln West Virginia 54043 5593 82
2496256 2496256 2022-05-11 Lincoln Wisconsin 55069 7156 148
2496305 2496305 2022-05-11 Lincoln Wyoming 56023 3979 31
2489951 2489951 2022-05-10 Lincoln Arkansas 5079 4919 68
2490083 2490083 2022-05-10 Lincoln Colorado 8073 2185 9
2490281 2490281 2022-05-10 Lincoln Georgia 13181 1601 35
2490390 2490390 2022-05-10 Lincoln Idaho 16063 1108 15
2490751 2490751 2022-05-10 Lincoln Kansas 20105 623 10
2490873 2490873 2022-05-10 Lincoln Kentucky 21137 6487 137
2490955 2490955 2022-05-10 Lincoln Louisiana 22061 12259 144
2490997 2490997 2022-05-10 Lincoln Maine 23015 5538 35
2491171 2491171 2022-05-10 Lincoln Minnesota 27081 1219 6
2491261 2491261 2022-05-10 Lincoln Mississippi 28085 8324 157
2491360 2491360 2022-05-10 Lincoln Missouri 29113 15152 138
2491445 2491445 2022-05-10 Lincoln Montana 30053 4784 89
2491530 2491530 2022-05-10 Lincoln Nebraska 31111 8730 110
2491578 2491578 2022-05-10 Lincoln Nevada 32017 548 7
2491634 2491634 2022-05-10 Lincoln New Mexico 35027 5290 67
2491766 2491766 2022-05-10 Lincoln North Carolina 37109 24436 174
2491999 2491999 2022-05-10 Lincoln Oklahoma 40081 7887 140
2492057 2492057 2022-05-10 Lincoln Oregon 41041 7182 85
2492311 2492311 2022-05-10 Lincoln South Dakota 46083 15559 102
2492388 2492388 2022-05-10 Lincoln Tennessee 47103 9997 170
2492890 2492890 2022-05-10 Lincoln Washington 53043 2217 28
2492930 2492930 2022-05-10 Lincoln West Virginia 54043 5588 82
2492998 2492998 2022-05-10 Lincoln Wisconsin 55069 7145 148
2493047 2493047 2022-05-10 Lincoln Wyoming 56023 3979 31
2486694 2486694 2022-05-09 Lincoln Arkansas 5079 4918 68
2486826 2486826 2022-05-09 Lincoln Colorado 8073 2184 9
2487024 2487024 2022-05-09 Lincoln Georgia 13181 1601 35
2487133 2487133 2022-05-09 Lincoln Idaho 16063 1108 15

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