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

13,489 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 · 13,489 ✖
Link rowid date ▲ county state fips cases deaths
1816764 1816764 2021-10-15 Lincoln Arkansas 5079 3637 57
1816896 1816896 2021-10-15 Lincoln Colorado 8073 1283 7
1817094 1817094 2021-10-15 Lincoln Georgia 13181 1171 32
1817203 1817203 2021-10-15 Lincoln Idaho 16063 658 12
1817563 1817563 2021-10-15 Lincoln Kansas 20105 339 5
1817684 1817684 2021-10-15 Lincoln Kentucky 21137 4230 80
1817766 1817766 2021-10-15 Lincoln Louisiana 22061 7001 115
1817808 1817808 2021-10-15 Lincoln Maine 23015 1718 5
1817982 1817982 2021-10-15 Lincoln Minnesota 27081 752 5
1818072 1818072 2021-10-15 Lincoln Mississippi 28085 5417 134
1818170 1818170 2021-10-15 Lincoln Missouri 29113 9097 67
1818255 1818255 2021-10-15 Lincoln Montana 30053 3182 52
1818340 1818340 2021-10-15 Lincoln Nebraska 31111 5191 80
1818388 1818388 2021-10-15 Lincoln Nevada 32017 514 5
1818443 1818443 2021-10-15 Lincoln New Mexico 35027 2805 29
1818574 1818574 2021-10-15 Lincoln North Carolina 37109 14677 107
1818805 1818805 2021-10-15 Lincoln Oklahoma 40081 4769 101
1818863 1818863 2021-10-15 Lincoln Oregon 41041 3106 38
1819117 1819117 2021-10-15 Lincoln South Dakota 46083 10091 78
1819194 1819194 2021-10-15 Lincoln Tennessee 47103 6595 81
1819695 1819695 2021-10-15 Lincoln Washington 53043 1316 19
1819734 1819734 2021-10-15 Lincoln West Virginia 54043 2660 42
1819802 1819802 2021-10-15 Lincoln Wisconsin 55069 4193 106
1819851 1819851 2021-10-15 Lincoln Wyoming 56023 2592 18
1813516 1813516 2021-10-14 Lincoln Arkansas 5079 3635 57
1813648 1813648 2021-10-14 Lincoln Colorado 8073 1276 7
1813846 1813846 2021-10-14 Lincoln Georgia 13181 1168 32
1813955 1813955 2021-10-14 Lincoln Idaho 16063 650 12
1814315 1814315 2021-10-14 Lincoln Kansas 20105 334 5
1814436 1814436 2021-10-14 Lincoln Kentucky 21137 4219 80
1814518 1814518 2021-10-14 Lincoln Louisiana 22061 6998 115
1814560 1814560 2021-10-14 Lincoln Maine 23015 1697 5
1814733 1814733 2021-10-14 Lincoln Minnesota 27081 748 5
1814823 1814823 2021-10-14 Lincoln Mississippi 28085 5416 134
1814921 1814921 2021-10-14 Lincoln Missouri 29113 9064 67
1815006 1815006 2021-10-14 Lincoln Montana 30053 3159 52
1815091 1815091 2021-10-14 Lincoln Nebraska 31111 5173 80
1815139 1815139 2021-10-14 Lincoln Nevada 32017 514 5
1815194 1815194 2021-10-14 Lincoln New Mexico 35027 2776 29
1815325 1815325 2021-10-14 Lincoln North Carolina 37109 14635 107
1815556 1815556 2021-10-14 Lincoln Oklahoma 40081 4769 101
1815614 1815614 2021-10-14 Lincoln Oregon 41041 3090 36
1815868 1815868 2021-10-14 Lincoln South Dakota 46083 10067 78
1815945 1815945 2021-10-14 Lincoln Tennessee 47103 6587 81
1816446 1816446 2021-10-14 Lincoln Washington 53043 1310 19
1816485 1816485 2021-10-14 Lincoln West Virginia 54043 2642 41
1816553 1816553 2021-10-14 Lincoln Wisconsin 55069 4193 106
1816602 1816602 2021-10-14 Lincoln Wyoming 56023 2576 18
1810267 1810267 2021-10-13 Lincoln Arkansas 5079 3633 57
1810399 1810399 2021-10-13 Lincoln Colorado 8073 1274 7
1810597 1810597 2021-10-13 Lincoln Georgia 13181 1167 32
1810706 1810706 2021-10-13 Lincoln Idaho 16063 650 12
1811066 1811066 2021-10-13 Lincoln Kansas 20105 334 5
1811187 1811187 2021-10-13 Lincoln Kentucky 21137 4184 80
1811269 1811269 2021-10-13 Lincoln Louisiana 22061 6984 115
1811311 1811311 2021-10-13 Lincoln Maine 23015 1686 5
1811485 1811485 2021-10-13 Lincoln Minnesota 27081 745 5
1811575 1811575 2021-10-13 Lincoln Mississippi 28085 5412 134
1811673 1811673 2021-10-13 Lincoln Missouri 29113 9035 66
1811758 1811758 2021-10-13 Lincoln Montana 30053 3144 52
1811843 1811843 2021-10-13 Lincoln Nebraska 31111 5164 80
1811891 1811891 2021-10-13 Lincoln Nevada 32017 514 5
1811946 1811946 2021-10-13 Lincoln New Mexico 35027 2769 29
1812077 1812077 2021-10-13 Lincoln North Carolina 37109 14597 107
1812308 1812308 2021-10-13 Lincoln Oklahoma 40081 4769 101
1812366 1812366 2021-10-13 Lincoln Oregon 41041 3081 34
1812620 1812620 2021-10-13 Lincoln South Dakota 46083 10052 78
1812697 1812697 2021-10-13 Lincoln Tennessee 47103 6572 81
1813198 1813198 2021-10-13 Lincoln Washington 53043 1300 18
1813237 1813237 2021-10-13 Lincoln West Virginia 54043 2623 41
1813305 1813305 2021-10-13 Lincoln Wisconsin 55069 4169 106
1813354 1813354 2021-10-13 Lincoln Wyoming 56023 2559 18
1807018 1807018 2021-10-12 Lincoln Arkansas 5079 3630 57
1807150 1807150 2021-10-12 Lincoln Colorado 8073 1269 6
1807348 1807348 2021-10-12 Lincoln Georgia 13181 1163 32
1807457 1807457 2021-10-12 Lincoln Idaho 16063 648 12
1807817 1807817 2021-10-12 Lincoln Kansas 20105 330 5
1807938 1807938 2021-10-12 Lincoln Kentucky 21137 4158 80
1808020 1808020 2021-10-12 Lincoln Louisiana 22061 6976 115
1808062 1808062 2021-10-12 Lincoln Maine 23015 1665 5
1808236 1808236 2021-10-12 Lincoln Minnesota 27081 741 5
1808326 1808326 2021-10-12 Lincoln Mississippi 28085 5400 134
1808424 1808424 2021-10-12 Lincoln Missouri 29113 9006 66
1808509 1808509 2021-10-12 Lincoln Montana 30053 3124 52
1808594 1808594 2021-10-12 Lincoln Nebraska 31111 5142 80
1808642 1808642 2021-10-12 Lincoln Nevada 32017 507 5
1808697 1808697 2021-10-12 Lincoln New Mexico 35027 2762 29
1808828 1808828 2021-10-12 Lincoln North Carolina 37109 14571 107
1809059 1809059 2021-10-12 Lincoln Oklahoma 40081 4620 101
1809117 1809117 2021-10-12 Lincoln Oregon 41041 3060 33
1809371 1809371 2021-10-12 Lincoln South Dakota 46083 9988 78
1809448 1809448 2021-10-12 Lincoln Tennessee 47103 6561 81
1809949 1809949 2021-10-12 Lincoln Washington 53043 1296 18
1809988 1809988 2021-10-12 Lincoln West Virginia 54043 2612 41
1810056 1810056 2021-10-12 Lincoln Wisconsin 55069 4151 106
1810105 1810105 2021-10-12 Lincoln Wyoming 56023 2545 18
1803767 1803767 2021-10-11 Lincoln Arkansas 5079 3628 57
1803899 1803899 2021-10-11 Lincoln Colorado 8073 1263 6
1804097 1804097 2021-10-11 Lincoln Georgia 13181 1160 32
1804206 1804206 2021-10-11 Lincoln Idaho 16063 642 12

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