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 388
- Washington 388
- Arkansas 387
- Nebraska 385
- North Carolina 385
- Georgia 383
- Mississippi 382
- Louisiana 380
- Tennessee 379
- Oregon 378
- South Dakota 378
- Montana 377
- Oklahoma 377
- Colorado 376
- Minnesota 376
- Missouri 376
- Idaho 375
- Kentucky 370
- Wyoming 370
- New Mexico 368
- West Virginia 358
- Wisconsin 342
- Nevada 334
- Kansas 271
fips 24
county 1
- Lincoln · 8,883 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199545 | 1199545 | 2021-04-07 | Lincoln | Wisconsin | 55069 | 3175 | 87 |
1199594 | 1199594 | 2021-04-07 | Lincoln | Wyoming | 56023 | 1375 | 12 |
1193258 | 1193258 | 2021-04-06 | Lincoln | Arkansas | 5079 | 3183 | 48 |
1193390 | 1193390 | 2021-04-06 | Lincoln | Colorado | 8073 | 1008 | 4 |
1193588 | 1193588 | 2021-04-06 | Lincoln | Georgia | 13181 | 788 | 26 |
1193696 | 1193696 | 2021-04-06 | Lincoln | Idaho | 16063 | 494 | 11 |
1194056 | 1194056 | 2021-04-06 | Lincoln | Kansas | 20105 | 257 | 4 |
1194178 | 1194178 | 2021-04-06 | Lincoln | Kentucky | 21137 | 2213 | 45 |
1194260 | 1194260 | 2021-04-06 | Lincoln | Louisiana | 22061 | 4350 | 91 |
1194302 | 1194302 | 2021-04-06 | Lincoln | Maine | 23015 | 682 | 2 |
1194475 | 1194475 | 2021-04-06 | Lincoln | Minnesota | 27081 | 547 | 2 |
1194565 | 1194565 | 2021-04-06 | Lincoln | Mississippi | 28085 | 3862 | 107 |
1194663 | 1194663 | 2021-04-06 | Lincoln | Missouri | 29113 | 5612 | 39 |
1194748 | 1194748 | 2021-04-06 | Lincoln | Montana | 30053 | 1567 | 16 |
1194833 | 1194833 | 2021-04-06 | Lincoln | Nebraska | 31111 | 3684 | 52 |
1194881 | 1194881 | 2021-04-06 | Lincoln | Nevada | 32017 | 354 | 3 |
1194936 | 1194936 | 2021-04-06 | Lincoln | New Mexico | 35027 | 1596 | 18 |
1195067 | 1195067 | 2021-04-06 | Lincoln | North Carolina | 37109 | 9378 | 80 |
1195298 | 1195298 | 2021-04-06 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1195356 | 1195356 | 2021-04-06 | Lincoln | Oregon | 41041 | 1238 | 20 |
1195610 | 1195610 | 2021-04-06 | Lincoln | South Dakota | 46083 | 8313 | 77 |
1195687 | 1195687 | 2021-04-06 | Lincoln | Tennessee | 47103 | 4270 | 63 |
1196189 | 1196189 | 2021-04-06 | Lincoln | Washington | 53043 | 398 | 6 |
1196228 | 1196228 | 2021-04-06 | Lincoln | West Virginia | 54043 | 1368 | 20 |
1196296 | 1196296 | 2021-04-06 | Lincoln | Wisconsin | 55069 | 3172 | 87 |
1196345 | 1196345 | 2021-04-06 | Lincoln | Wyoming | 56023 | 1373 | 12 |
1190008 | 1190008 | 2021-04-05 | Lincoln | Arkansas | 5079 | 3182 | 48 |
1190140 | 1190140 | 2021-04-05 | Lincoln | Colorado | 8073 | 1008 | 4 |
1190338 | 1190338 | 2021-04-05 | Lincoln | Georgia | 13181 | 788 | 26 |
1190446 | 1190446 | 2021-04-05 | Lincoln | Idaho | 16063 | 494 | 11 |
1190806 | 1190806 | 2021-04-05 | Lincoln | Kansas | 20105 | 257 | 4 |
1190928 | 1190928 | 2021-04-05 | Lincoln | Kentucky | 21137 | 2207 | 45 |
1191010 | 1191010 | 2021-04-05 | Lincoln | Louisiana | 22061 | 4348 | 91 |
1191052 | 1191052 | 2021-04-05 | Lincoln | Maine | 23015 | 681 | 2 |
1191226 | 1191226 | 2021-04-05 | Lincoln | Minnesota | 27081 | 547 | 2 |
1191316 | 1191316 | 2021-04-05 | Lincoln | Mississippi | 28085 | 3861 | 107 |
1191414 | 1191414 | 2021-04-05 | Lincoln | Missouri | 29113 | 5597 | 39 |
1191499 | 1191499 | 2021-04-05 | Lincoln | Montana | 30053 | 1562 | 14 |
1191584 | 1191584 | 2021-04-05 | Lincoln | Nebraska | 31111 | 3684 | 52 |
1191632 | 1191632 | 2021-04-05 | Lincoln | Nevada | 32017 | 354 | 2 |
1191687 | 1191687 | 2021-04-05 | Lincoln | New Mexico | 35027 | 1595 | 18 |
1191819 | 1191819 | 2021-04-05 | Lincoln | North Carolina | 37109 | 9371 | 80 |
1192050 | 1192050 | 2021-04-05 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1192108 | 1192108 | 2021-04-05 | Lincoln | Oregon | 41041 | 1235 | 20 |
1192362 | 1192362 | 2021-04-05 | Lincoln | South Dakota | 46083 | 8293 | 77 |
1192439 | 1192439 | 2021-04-05 | Lincoln | Tennessee | 47103 | 4264 | 63 |
1192941 | 1192941 | 2021-04-05 | Lincoln | Washington | 53043 | 397 | 6 |
1192980 | 1192980 | 2021-04-05 | Lincoln | West Virginia | 54043 | 1369 | 20 |
1193048 | 1193048 | 2021-04-05 | Lincoln | Wisconsin | 55069 | 3170 | 87 |
1193097 | 1193097 | 2021-04-05 | Lincoln | Wyoming | 56023 | 1361 | 12 |
1186761 | 1186761 | 2021-04-04 | Lincoln | Arkansas | 5079 | 3182 | 48 |
1186893 | 1186893 | 2021-04-04 | Lincoln | Colorado | 8073 | 1008 | 4 |
1187091 | 1187091 | 2021-04-04 | Lincoln | Georgia | 13181 | 786 | 26 |
1187199 | 1187199 | 2021-04-04 | Lincoln | Idaho | 16063 | 494 | 11 |
1187559 | 1187559 | 2021-04-04 | Lincoln | Kansas | 20105 | 257 | 4 |
1187681 | 1187681 | 2021-04-04 | Lincoln | Kentucky | 21137 | 2200 | 45 |
1187763 | 1187763 | 2021-04-04 | Lincoln | Louisiana | 22061 | 4334 | 91 |
1187805 | 1187805 | 2021-04-04 | Lincoln | Maine | 23015 | 680 | 2 |
1187978 | 1187978 | 2021-04-04 | Lincoln | Minnesota | 27081 | 546 | 2 |
1188068 | 1188068 | 2021-04-04 | Lincoln | Mississippi | 28085 | 3861 | 107 |
1188166 | 1188166 | 2021-04-04 | Lincoln | Missouri | 29113 | 5595 | 39 |
1188251 | 1188251 | 2021-04-04 | Lincoln | Montana | 30053 | 1562 | 14 |
1188336 | 1188336 | 2021-04-04 | Lincoln | Nebraska | 31111 | 3681 | 52 |
1188384 | 1188384 | 2021-04-04 | Lincoln | Nevada | 32017 | 354 | 2 |
1188439 | 1188439 | 2021-04-04 | Lincoln | New Mexico | 35027 | 1592 | 18 |
1188570 | 1188570 | 2021-04-04 | Lincoln | North Carolina | 37109 | 9318 | 80 |
1188801 | 1188801 | 2021-04-04 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1188859 | 1188859 | 2021-04-04 | Lincoln | Oregon | 41041 | 1230 | 20 |
1189113 | 1189113 | 2021-04-04 | Lincoln | South Dakota | 46083 | 8277 | 77 |
1189190 | 1189190 | 2021-04-04 | Lincoln | Tennessee | 47103 | 4254 | 63 |
1189691 | 1189691 | 2021-04-04 | Lincoln | Washington | 53043 | 393 | 6 |
1189730 | 1189730 | 2021-04-04 | Lincoln | West Virginia | 54043 | 1367 | 20 |
1189798 | 1189798 | 2021-04-04 | Lincoln | Wisconsin | 55069 | 3170 | 87 |
1189847 | 1189847 | 2021-04-04 | Lincoln | Wyoming | 56023 | 1357 | 12 |
1183514 | 1183514 | 2021-04-03 | Lincoln | Arkansas | 5079 | 3182 | 48 |
1183646 | 1183646 | 2021-04-03 | Lincoln | Colorado | 8073 | 1007 | 4 |
1183844 | 1183844 | 2021-04-03 | Lincoln | Georgia | 13181 | 784 | 26 |
1183952 | 1183952 | 2021-04-03 | Lincoln | Idaho | 16063 | 494 | 11 |
1184312 | 1184312 | 2021-04-03 | Lincoln | Kansas | 20105 | 257 | 4 |
1184434 | 1184434 | 2021-04-03 | Lincoln | Kentucky | 21137 | 2200 | 45 |
1184516 | 1184516 | 2021-04-03 | Lincoln | Louisiana | 22061 | 4334 | 91 |
1184558 | 1184558 | 2021-04-03 | Lincoln | Maine | 23015 | 675 | 2 |
1184731 | 1184731 | 2021-04-03 | Lincoln | Minnesota | 27081 | 546 | 2 |
1184821 | 1184821 | 2021-04-03 | Lincoln | Mississippi | 28085 | 3861 | 107 |
1184919 | 1184919 | 2021-04-03 | Lincoln | Missouri | 29113 | 5586 | 39 |
1185004 | 1185004 | 2021-04-03 | Lincoln | Montana | 30053 | 1560 | 14 |
1185089 | 1185089 | 2021-04-03 | Lincoln | Nebraska | 31111 | 3679 | 52 |
1185137 | 1185137 | 2021-04-03 | Lincoln | Nevada | 32017 | 354 | 2 |
1185192 | 1185192 | 2021-04-03 | Lincoln | New Mexico | 35027 | 1592 | 18 |
1185323 | 1185323 | 2021-04-03 | Lincoln | North Carolina | 37109 | 9318 | 80 |
1185554 | 1185554 | 2021-04-03 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1185612 | 1185612 | 2021-04-03 | Lincoln | Oregon | 41041 | 1226 | 20 |
1185866 | 1185866 | 2021-04-03 | Lincoln | South Dakota | 46083 | 8277 | 77 |
1185943 | 1185943 | 2021-04-03 | Lincoln | Tennessee | 47103 | 4254 | 63 |
1186444 | 1186444 | 2021-04-03 | Lincoln | Washington | 53043 | 393 | 6 |
1186483 | 1186483 | 2021-04-03 | Lincoln | West Virginia | 54043 | 1367 | 20 |
1186551 | 1186551 | 2021-04-03 | Lincoln | Wisconsin | 55069 | 3170 | 87 |
1186600 | 1186600 | 2021-04-03 | Lincoln | Wyoming | 56023 | 1357 | 12 |
1180267 | 1180267 | 2021-04-02 | Lincoln | Arkansas | 5079 | 3182 | 48 |
1180399 | 1180399 | 2021-04-02 | Lincoln | Colorado | 8073 | 1007 | 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);