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 216
- Washington 216
- Arkansas 214
- Nebraska 213
- North Carolina 213
- Georgia 211
- Mississippi 210
- Louisiana 208
- Tennessee 207
- Oregon 206
- South Dakota 206
- Montana 205
- Oklahoma 205
- Colorado 204
- Minnesota 204
- Missouri 204
- Idaho 203
- Kentucky 198
- Wyoming 197
- New Mexico 196
- West Virginia 186
- Wisconsin 169
- Nevada 162
- Kansas 99
fips 24
county 1
- Lincoln · 4,752 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635166 | 635166 | 2020-10-16 | Lincoln | Colorado | 8073 | 24 | 0 |
635364 | 635364 | 2020-10-16 | Lincoln | Georgia | 13181 | 234 | 7 |
635471 | 635471 | 2020-10-16 | Lincoln | Idaho | 16063 | 130 | 0 |
635831 | 635831 | 2020-10-16 | Lincoln | Kansas | 20105 | 17 | 1 |
635953 | 635953 | 2020-10-16 | Lincoln | Kentucky | 21137 | 271 | 16 |
636035 | 636035 | 2020-10-16 | Lincoln | Louisiana | 22061 | 1592 | 48 |
636077 | 636077 | 2020-10-16 | Lincoln | Maine | 23015 | 50 | 1 |
636251 | 636251 | 2020-10-16 | Lincoln | Minnesota | 27081 | 156 | 0 |
636341 | 636341 | 2020-10-16 | Lincoln | Mississippi | 28085 | 1321 | 54 |
636439 | 636439 | 2020-10-16 | Lincoln | Missouri | 29113 | 1017 | 4 |
636524 | 636524 | 2020-10-16 | Lincoln | Montana | 30053 | 234 | 3 |
636609 | 636609 | 2020-10-16 | Lincoln | Nebraska | 31111 | 637 | 4 |
636656 | 636656 | 2020-10-16 | Lincoln | Nevada | 32017 | 28 | 0 |
636711 | 636711 | 2020-10-16 | Lincoln | New Mexico | 35027 | 283 | 4 |
636842 | 636842 | 2020-10-16 | Lincoln | North Carolina | 37109 | 2098 | 16 |
637072 | 637072 | 2020-10-16 | Lincoln | Oklahoma | 40081 | 687 | 10 |
637130 | 637130 | 2020-10-16 | Lincoln | Oregon | 41041 | 507 | 13 |
637384 | 637384 | 2020-10-16 | Lincoln | South Dakota | 46083 | 2094 | 11 |
637461 | 637461 | 2020-10-16 | Lincoln | Tennessee | 47103 | 770 | 2 |
637960 | 637960 | 2020-10-16 | Lincoln | Washington | 53043 | 64 | 2 |
638000 | 638000 | 2020-10-16 | Lincoln | West Virginia | 54043 | 206 | 2 |
638068 | 638068 | 2020-10-16 | Lincoln | Wisconsin | 55069 | 528 | 5 |
638118 | 638118 | 2020-10-16 | Lincoln | Wyoming | 56023 | 296 | 2 |
631788 | 631788 | 2020-10-15 | Lincoln | Arkansas | 5079 | 2162 | 17 |
631920 | 631920 | 2020-10-15 | Lincoln | Colorado | 8073 | 24 | 0 |
632118 | 632118 | 2020-10-15 | Lincoln | Georgia | 13181 | 233 | 7 |
632225 | 632225 | 2020-10-15 | Lincoln | Idaho | 16063 | 126 | 0 |
632585 | 632585 | 2020-10-15 | Lincoln | Kansas | 20105 | 16 | 1 |
632707 | 632707 | 2020-10-15 | Lincoln | Kentucky | 21137 | 262 | 16 |
632789 | 632789 | 2020-10-15 | Lincoln | Louisiana | 22061 | 1582 | 48 |
632831 | 632831 | 2020-10-15 | Lincoln | Maine | 23015 | 52 | 1 |
633005 | 633005 | 2020-10-15 | Lincoln | Minnesota | 27081 | 151 | 0 |
633095 | 633095 | 2020-10-15 | Lincoln | Mississippi | 28085 | 1302 | 54 |
633193 | 633193 | 2020-10-15 | Lincoln | Missouri | 29113 | 1004 | 4 |
633278 | 633278 | 2020-10-15 | Lincoln | Montana | 30053 | 224 | 3 |
633363 | 633363 | 2020-10-15 | Lincoln | Nebraska | 31111 | 617 | 4 |
633410 | 633410 | 2020-10-15 | Lincoln | Nevada | 32017 | 18 | 0 |
633465 | 633465 | 2020-10-15 | Lincoln | New Mexico | 35027 | 267 | 4 |
633596 | 633596 | 2020-10-15 | Lincoln | North Carolina | 37109 | 2069 | 16 |
633826 | 633826 | 2020-10-15 | Lincoln | Oklahoma | 40081 | 670 | 10 |
633884 | 633884 | 2020-10-15 | Lincoln | Oregon | 41041 | 507 | 13 |
634138 | 634138 | 2020-10-15 | Lincoln | South Dakota | 46083 | 2022 | 11 |
634215 | 634215 | 2020-10-15 | Lincoln | Tennessee | 47103 | 763 | 2 |
634715 | 634715 | 2020-10-15 | Lincoln | Washington | 53043 | 63 | 1 |
634755 | 634755 | 2020-10-15 | Lincoln | West Virginia | 54043 | 203 | 2 |
634823 | 634823 | 2020-10-15 | Lincoln | Wisconsin | 55069 | 502 | 4 |
634873 | 634873 | 2020-10-15 | Lincoln | Wyoming | 56023 | 295 | 2 |
628544 | 628544 | 2020-10-14 | Lincoln | Arkansas | 5079 | 2157 | 17 |
628676 | 628676 | 2020-10-14 | Lincoln | Colorado | 8073 | 24 | 0 |
628874 | 628874 | 2020-10-14 | Lincoln | Georgia | 13181 | 233 | 7 |
628981 | 628981 | 2020-10-14 | Lincoln | Idaho | 16063 | 122 | 0 |
629341 | 629341 | 2020-10-14 | Lincoln | Kansas | 20105 | 16 | 1 |
629463 | 629463 | 2020-10-14 | Lincoln | Kentucky | 21137 | 258 | 16 |
629545 | 629545 | 2020-10-14 | Lincoln | Louisiana | 22061 | 1574 | 48 |
629587 | 629587 | 2020-10-14 | Lincoln | Maine | 23015 | 51 | 1 |
629760 | 629760 | 2020-10-14 | Lincoln | Minnesota | 27081 | 150 | 0 |
629850 | 629850 | 2020-10-14 | Lincoln | Mississippi | 28085 | 1278 | 54 |
629948 | 629948 | 2020-10-14 | Lincoln | Missouri | 29113 | 985 | 3 |
630033 | 630033 | 2020-10-14 | Lincoln | Montana | 30053 | 208 | 3 |
630118 | 630118 | 2020-10-14 | Lincoln | Nebraska | 31111 | 598 | 4 |
630165 | 630165 | 2020-10-14 | Lincoln | Nevada | 32017 | 18 | 0 |
630220 | 630220 | 2020-10-14 | Lincoln | New Mexico | 35027 | 263 | 4 |
630351 | 630351 | 2020-10-14 | Lincoln | North Carolina | 37109 | 2043 | 16 |
630581 | 630581 | 2020-10-14 | Lincoln | Oklahoma | 40081 | 655 | 10 |
630639 | 630639 | 2020-10-14 | Lincoln | Oregon | 41041 | 503 | 13 |
630893 | 630893 | 2020-10-14 | Lincoln | South Dakota | 46083 | 1976 | 10 |
630970 | 630970 | 2020-10-14 | Lincoln | Tennessee | 47103 | 745 | 2 |
631470 | 631470 | 2020-10-14 | Lincoln | Washington | 53043 | 63 | 1 |
631510 | 631510 | 2020-10-14 | Lincoln | West Virginia | 54043 | 199 | 2 |
631578 | 631578 | 2020-10-14 | Lincoln | Wisconsin | 55069 | 478 | 4 |
631628 | 631628 | 2020-10-14 | Lincoln | Wyoming | 56023 | 294 | 2 |
625301 | 625301 | 2020-10-13 | Lincoln | Arkansas | 5079 | 2150 | 17 |
625433 | 625433 | 2020-10-13 | Lincoln | Colorado | 8073 | 24 | 0 |
625631 | 625631 | 2020-10-13 | Lincoln | Georgia | 13181 | 233 | 7 |
625738 | 625738 | 2020-10-13 | Lincoln | Idaho | 16063 | 119 | 0 |
626098 | 626098 | 2020-10-13 | Lincoln | Kansas | 20105 | 16 | 0 |
626219 | 626219 | 2020-10-13 | Lincoln | Kentucky | 21137 | 254 | 16 |
626301 | 626301 | 2020-10-13 | Lincoln | Louisiana | 22061 | 1554 | 48 |
626343 | 626343 | 2020-10-13 | Lincoln | Maine | 23015 | 50 | 1 |
626516 | 626516 | 2020-10-13 | Lincoln | Minnesota | 27081 | 149 | 0 |
626606 | 626606 | 2020-10-13 | Lincoln | Mississippi | 28085 | 1254 | 53 |
626704 | 626704 | 2020-10-13 | Lincoln | Missouri | 29113 | 948 | 3 |
626789 | 626789 | 2020-10-13 | Lincoln | Montana | 30053 | 197 | 3 |
626874 | 626874 | 2020-10-13 | Lincoln | Nebraska | 31111 | 576 | 4 |
626921 | 626921 | 2020-10-13 | Lincoln | Nevada | 32017 | 16 | 0 |
626976 | 626976 | 2020-10-13 | Lincoln | New Mexico | 35027 | 262 | 4 |
627107 | 627107 | 2020-10-13 | Lincoln | North Carolina | 37109 | 2020 | 16 |
627337 | 627337 | 2020-10-13 | Lincoln | Oklahoma | 40081 | 648 | 10 |
627395 | 627395 | 2020-10-13 | Lincoln | Oregon | 41041 | 501 | 13 |
627649 | 627649 | 2020-10-13 | Lincoln | South Dakota | 46083 | 1897 | 10 |
627726 | 627726 | 2020-10-13 | Lincoln | Tennessee | 47103 | 735 | 2 |
628226 | 628226 | 2020-10-13 | Lincoln | Washington | 53043 | 63 | 1 |
628266 | 628266 | 2020-10-13 | Lincoln | West Virginia | 54043 | 199 | 2 |
628334 | 628334 | 2020-10-13 | Lincoln | Wisconsin | 55069 | 464 | 3 |
628384 | 628384 | 2020-10-13 | Lincoln | Wyoming | 56023 | 289 | 2 |
622058 | 622058 | 2020-10-12 | Lincoln | Arkansas | 5079 | 2149 | 17 |
622190 | 622190 | 2020-10-12 | Lincoln | Colorado | 8073 | 24 | 0 |
622388 | 622388 | 2020-10-12 | Lincoln | Georgia | 13181 | 232 | 7 |
622495 | 622495 | 2020-10-12 | Lincoln | Idaho | 16063 | 105 | 0 |
622856 | 622856 | 2020-10-12 | Lincoln | Kansas | 20105 | 16 | 0 |
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);