ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18,529 rows where county = "Lincoln" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 24
- Maine 576
- Washington 576
- Arkansas 574
- Nebraska 573
- North Carolina 573
- Georgia 570
- Mississippi 570
- Louisiana 568
- Tennessee 567
- Oregon 566
- South Dakota 566
- Montana 565
- Oklahoma 565
- Minnesota 564
- Missouri 564
- Colorado 563
- Idaho 562
- Kentucky 558
- Wyoming 557
- New Mexico 556
- West Virginia 546
- Wisconsin 529
- Nevada 522
- Kansas 459
fips 24
county 1
- Lincoln · 13,389 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1804566 | 1804566 | 2021-10-11 | Lincoln | Kansas | 20105 | 330 | 5 |
1804687 | 1804687 | 2021-10-11 | Lincoln | Kentucky | 21137 | 4147 | 80 |
1804769 | 1804769 | 2021-10-11 | Lincoln | Louisiana | 22061 | 6957 | 115 |
1804811 | 1804811 | 2021-10-11 | Lincoln | Maine | 23015 | 1665 | 5 |
1804985 | 1804985 | 2021-10-11 | Lincoln | Minnesota | 27081 | 738 | 5 |
1805075 | 1805075 | 2021-10-11 | Lincoln | Mississippi | 28085 | 5390 | 134 |
1805173 | 1805173 | 2021-10-11 | Lincoln | Missouri | 29113 | 8987 | 66 |
1805258 | 1805258 | 2021-10-11 | Lincoln | Montana | 30053 | 3096 | 52 |
1805343 | 1805343 | 2021-10-11 | Lincoln | Nebraska | 31111 | 5127 | 80 |
1805391 | 1805391 | 2021-10-11 | Lincoln | Nevada | 32017 | 507 | 5 |
1805446 | 1805446 | 2021-10-11 | Lincoln | New Mexico | 35027 | 2749 | 29 |
1805577 | 1805577 | 2021-10-11 | Lincoln | North Carolina | 37109 | 14558 | 107 |
1805809 | 1805809 | 2021-10-11 | Lincoln | Oklahoma | 40081 | 4620 | 101 |
1805867 | 1805867 | 2021-10-11 | Lincoln | Oregon | 41041 | 3052 | 33 |
1806121 | 1806121 | 2021-10-11 | Lincoln | South Dakota | 46083 | 9955 | 78 |
1806198 | 1806198 | 2021-10-11 | Lincoln | Tennessee | 47103 | 6550 | 81 |
1806700 | 1806700 | 2021-10-11 | Lincoln | Washington | 53043 | 1294 | 18 |
1806739 | 1806739 | 2021-10-11 | Lincoln | West Virginia | 54043 | 2608 | 41 |
1806807 | 1806807 | 2021-10-11 | Lincoln | Wisconsin | 55069 | 4121 | 106 |
1806856 | 1806856 | 2021-10-11 | Lincoln | Wyoming | 56023 | 2536 | 15 |
1800518 | 1800518 | 2021-10-10 | Lincoln | Arkansas | 5079 | 3627 | 57 |
1800650 | 1800650 | 2021-10-10 | Lincoln | Colorado | 8073 | 1256 | 6 |
1800848 | 1800848 | 2021-10-10 | Lincoln | Georgia | 13181 | 1160 | 32 |
1800957 | 1800957 | 2021-10-10 | Lincoln | Idaho | 16063 | 642 | 12 |
1801317 | 1801317 | 2021-10-10 | Lincoln | Kansas | 20105 | 325 | 5 |
1801438 | 1801438 | 2021-10-10 | Lincoln | Kentucky | 21137 | 4118 | 80 |
1801520 | 1801520 | 2021-10-10 | Lincoln | Louisiana | 22061 | 6944 | 115 |
1801562 | 1801562 | 2021-10-10 | Lincoln | Maine | 23015 | 1665 | 5 |
1801736 | 1801736 | 2021-10-10 | Lincoln | Minnesota | 27081 | 719 | 5 |
1801826 | 1801826 | 2021-10-10 | Lincoln | Mississippi | 28085 | 5387 | 134 |
1801924 | 1801924 | 2021-10-10 | Lincoln | Missouri | 29113 | 8969 | 66 |
1802009 | 1802009 | 2021-10-10 | Lincoln | Montana | 30053 | 3096 | 52 |
1802094 | 1802094 | 2021-10-10 | Lincoln | Nebraska | 31111 | 5127 | 80 |
1802142 | 1802142 | 2021-10-10 | Lincoln | Nevada | 32017 | 507 | 5 |
1802197 | 1802197 | 2021-10-10 | Lincoln | New Mexico | 35027 | 2749 | 29 |
1802328 | 1802328 | 2021-10-10 | Lincoln | North Carolina | 37109 | 14446 | 92 |
1802559 | 1802559 | 2021-10-10 | Lincoln | Oklahoma | 40081 | 4620 | 101 |
1802617 | 1802617 | 2021-10-10 | Lincoln | Oregon | 41041 | 3026 | 32 |
1802871 | 1802871 | 2021-10-10 | Lincoln | South Dakota | 46083 | 9955 | 78 |
1802948 | 1802948 | 2021-10-10 | Lincoln | Tennessee | 47103 | 6519 | 81 |
1803449 | 1803449 | 2021-10-10 | Lincoln | Washington | 53043 | 1279 | 18 |
1803488 | 1803488 | 2021-10-10 | Lincoln | West Virginia | 54043 | 2590 | 41 |
1803556 | 1803556 | 2021-10-10 | Lincoln | Wisconsin | 55069 | 4089 | 106 |
1803605 | 1803605 | 2021-10-10 | Lincoln | Wyoming | 56023 | 2515 | 15 |
1797269 | 1797269 | 2021-10-09 | Lincoln | Arkansas | 5079 | 3625 | 55 |
1797401 | 1797401 | 2021-10-09 | Lincoln | Colorado | 8073 | 1256 | 6 |
1797599 | 1797599 | 2021-10-09 | Lincoln | Georgia | 13181 | 1160 | 32 |
1797708 | 1797708 | 2021-10-09 | Lincoln | Idaho | 16063 | 642 | 12 |
1798068 | 1798068 | 2021-10-09 | Lincoln | Kansas | 20105 | 325 | 5 |
1798189 | 1798189 | 2021-10-09 | Lincoln | Kentucky | 21137 | 4118 | 80 |
1798271 | 1798271 | 2021-10-09 | Lincoln | Louisiana | 22061 | 6944 | 115 |
1798313 | 1798313 | 2021-10-09 | Lincoln | Maine | 23015 | 1665 | 5 |
1798487 | 1798487 | 2021-10-09 | Lincoln | Minnesota | 27081 | 719 | 5 |
1798577 | 1798577 | 2021-10-09 | Lincoln | Mississippi | 28085 | 5387 | 134 |
1798675 | 1798675 | 2021-10-09 | Lincoln | Missouri | 29113 | 8958 | 66 |
1798760 | 1798760 | 2021-10-09 | Lincoln | Montana | 30053 | 3096 | 52 |
1798845 | 1798845 | 2021-10-09 | Lincoln | Nebraska | 31111 | 5127 | 80 |
1798893 | 1798893 | 2021-10-09 | Lincoln | Nevada | 32017 | 507 | 5 |
1798948 | 1798948 | 2021-10-09 | Lincoln | New Mexico | 35027 | 2749 | 29 |
1799079 | 1799079 | 2021-10-09 | Lincoln | North Carolina | 37109 | 14446 | 92 |
1799310 | 1799310 | 2021-10-09 | Lincoln | Oklahoma | 40081 | 4620 | 101 |
1799368 | 1799368 | 2021-10-09 | Lincoln | Oregon | 41041 | 3026 | 32 |
1799622 | 1799622 | 2021-10-09 | Lincoln | South Dakota | 46083 | 9955 | 78 |
1799699 | 1799699 | 2021-10-09 | Lincoln | Tennessee | 47103 | 6519 | 81 |
1800200 | 1800200 | 2021-10-09 | Lincoln | Washington | 53043 | 1279 | 18 |
1800239 | 1800239 | 2021-10-09 | Lincoln | West Virginia | 54043 | 2577 | 41 |
1800307 | 1800307 | 2021-10-09 | Lincoln | Wisconsin | 55069 | 4089 | 106 |
1800356 | 1800356 | 2021-10-09 | Lincoln | Wyoming | 56023 | 2515 | 15 |
1794020 | 1794020 | 2021-10-08 | Lincoln | Arkansas | 5079 | 3624 | 55 |
1794152 | 1794152 | 2021-10-08 | Lincoln | Colorado | 8073 | 1256 | 6 |
1794350 | 1794350 | 2021-10-08 | Lincoln | Georgia | 13181 | 1160 | 32 |
1794459 | 1794459 | 2021-10-08 | Lincoln | Idaho | 16063 | 641 | 12 |
1794819 | 1794819 | 2021-10-08 | Lincoln | Kansas | 20105 | 325 | 5 |
1794940 | 1794940 | 2021-10-08 | Lincoln | Kentucky | 21137 | 4118 | 80 |
1795022 | 1795022 | 2021-10-08 | Lincoln | Louisiana | 22061 | 6944 | 115 |
1795064 | 1795064 | 2021-10-08 | Lincoln | Maine | 23015 | 1662 | 4 |
1795238 | 1795238 | 2021-10-08 | Lincoln | Minnesota | 27081 | 719 | 5 |
1795328 | 1795328 | 2021-10-08 | Lincoln | Mississippi | 28085 | 5387 | 134 |
1795426 | 1795426 | 2021-10-08 | Lincoln | Missouri | 29113 | 8929 | 66 |
1795511 | 1795511 | 2021-10-08 | Lincoln | Montana | 30053 | 3096 | 52 |
1795596 | 1795596 | 2021-10-08 | Lincoln | Nebraska | 31111 | 5127 | 80 |
1795644 | 1795644 | 2021-10-08 | Lincoln | Nevada | 32017 | 507 | 5 |
1795699 | 1795699 | 2021-10-08 | Lincoln | New Mexico | 35027 | 2749 | 29 |
1795830 | 1795830 | 2021-10-08 | Lincoln | North Carolina | 37109 | 14446 | 92 |
1796061 | 1796061 | 2021-10-08 | Lincoln | Oklahoma | 40081 | 4620 | 101 |
1796119 | 1796119 | 2021-10-08 | Lincoln | Oregon | 41041 | 3026 | 32 |
1796373 | 1796373 | 2021-10-08 | Lincoln | South Dakota | 46083 | 9955 | 78 |
1796450 | 1796450 | 2021-10-08 | Lincoln | Tennessee | 47103 | 6519 | 81 |
1796951 | 1796951 | 2021-10-08 | Lincoln | Washington | 53043 | 1279 | 18 |
1796990 | 1796990 | 2021-10-08 | Lincoln | West Virginia | 54043 | 2563 | 41 |
1797058 | 1797058 | 2021-10-08 | Lincoln | Wisconsin | 55069 | 4089 | 106 |
1797107 | 1797107 | 2021-10-08 | Lincoln | Wyoming | 56023 | 2515 | 15 |
1790772 | 1790772 | 2021-10-07 | Lincoln | Arkansas | 5079 | 3623 | 55 |
1790904 | 1790904 | 2021-10-07 | Lincoln | Colorado | 8073 | 1246 | 6 |
1791102 | 1791102 | 2021-10-07 | Lincoln | Georgia | 13181 | 1159 | 32 |
1791211 | 1791211 | 2021-10-07 | Lincoln | Idaho | 16063 | 639 | 12 |
1791571 | 1791571 | 2021-10-07 | Lincoln | Kansas | 20105 | 317 | 5 |
1791692 | 1791692 | 2021-10-07 | Lincoln | Kentucky | 21137 | 4095 | 80 |
1791774 | 1791774 | 2021-10-07 | Lincoln | Louisiana | 22061 | 6932 | 114 |
1791816 | 1791816 | 2021-10-07 | Lincoln | Maine | 23015 | 1651 | 4 |
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);