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 23
- Maine 115
- Washington 115
- Arkansas 114
- Nebraska 112
- North Carolina 112
- Georgia 110
- Mississippi 109
- Louisiana 107
- Tennessee 106
- Oregon 105
- South Dakota 105
- Montana 104
- Oklahoma 104
- Colorado 103
- Minnesota 103
- Missouri 103
- Idaho 102
- Kentucky 97
- Wyoming 96
- New Mexico 95
- West Virginia 85
- Wisconsin 68
- Nevada 61
fips 23
county 1
- Lincoln · 2,331 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
309343 | 309343 | 2020-07-07 | Lincoln | Arkansas | 5079 | 1044 | 11 |
309472 | 309472 | 2020-07-07 | Lincoln | Colorado | 8073 | 4 | 0 |
309669 | 309669 | 2020-07-07 | Lincoln | Georgia | 13181 | 53 | 1 |
309774 | 309774 | 2020-07-07 | Lincoln | Idaho | 16063 | 37 | 0 |
310248 | 310248 | 2020-07-07 | Lincoln | Kentucky | 21137 | 39 | 1 |
310330 | 310330 | 2020-07-07 | Lincoln | Louisiana | 22061 | 354 | 19 |
310372 | 310372 | 2020-07-07 | Lincoln | Maine | 23015 | 25 | 0 |
310545 | 310545 | 2020-07-07 | Lincoln | Minnesota | 27081 | 10 | 0 |
310635 | 310635 | 2020-07-07 | Lincoln | Mississippi | 28085 | 484 | 34 |
310732 | 310732 | 2020-07-07 | Lincoln | Missouri | 29113 | 105 | 1 |
310810 | 310810 | 2020-07-07 | Lincoln | Montana | 30053 | 9 | 1 |
310877 | 310877 | 2020-07-07 | Lincoln | Nebraska | 31111 | 63 | 2 |
310917 | 310917 | 2020-07-07 | Lincoln | Nevada | 32017 | 2 | 0 |
310971 | 310971 | 2020-07-07 | Lincoln | New Mexico | 35027 | 14 | 0 |
311101 | 311101 | 2020-07-07 | Lincoln | North Carolina | 37109 | 334 | 1 |
311327 | 311327 | 2020-07-07 | Lincoln | Oklahoma | 40081 | 37 | 2 |
311383 | 311383 | 2020-07-07 | Lincoln | Oregon | 41041 | 346 | 4 |
311633 | 311633 | 2020-07-07 | Lincoln | South Dakota | 46083 | 371 | 1 |
311708 | 311708 | 2020-07-07 | Lincoln | Tennessee | 47103 | 68 | 0 |
312198 | 312198 | 2020-07-07 | Lincoln | Washington | 53043 | 4 | 0 |
312236 | 312236 | 2020-07-07 | Lincoln | West Virginia | 54043 | 9 | 0 |
312304 | 312304 | 2020-07-07 | Lincoln | Wisconsin | 55069 | 17 | 0 |
312354 | 312354 | 2020-07-07 | Lincoln | Wyoming | 56023 | 37 | 0 |
306175 | 306175 | 2020-07-06 | Lincoln | Arkansas | 5079 | 1043 | 11 |
306304 | 306304 | 2020-07-06 | Lincoln | Colorado | 8073 | 4 | 0 |
306501 | 306501 | 2020-07-06 | Lincoln | Georgia | 13181 | 51 | 1 |
306606 | 306606 | 2020-07-06 | Lincoln | Idaho | 16063 | 36 | 0 |
307080 | 307080 | 2020-07-06 | Lincoln | Kentucky | 21137 | 36 | 1 |
307162 | 307162 | 2020-07-06 | Lincoln | Louisiana | 22061 | 353 | 19 |
307204 | 307204 | 2020-07-06 | Lincoln | Maine | 23015 | 25 | 0 |
307377 | 307377 | 2020-07-06 | Lincoln | Minnesota | 27081 | 10 | 0 |
307467 | 307467 | 2020-07-06 | Lincoln | Mississippi | 28085 | 466 | 34 |
307564 | 307564 | 2020-07-06 | Lincoln | Missouri | 29113 | 102 | 1 |
307642 | 307642 | 2020-07-06 | Lincoln | Montana | 30053 | 9 | 1 |
307709 | 307709 | 2020-07-06 | Lincoln | Nebraska | 31111 | 61 | 2 |
307749 | 307749 | 2020-07-06 | Lincoln | Nevada | 32017 | 2 | 0 |
307803 | 307803 | 2020-07-06 | Lincoln | New Mexico | 35027 | 14 | 0 |
307933 | 307933 | 2020-07-06 | Lincoln | North Carolina | 37109 | 323 | 1 |
308158 | 308158 | 2020-07-06 | Lincoln | Oklahoma | 40081 | 36 | 2 |
308214 | 308214 | 2020-07-06 | Lincoln | Oregon | 41041 | 346 | 4 |
308464 | 308464 | 2020-07-06 | Lincoln | South Dakota | 46083 | 366 | 1 |
308539 | 308539 | 2020-07-06 | Lincoln | Tennessee | 47103 | 65 | 0 |
309029 | 309029 | 2020-07-06 | Lincoln | Washington | 53043 | 4 | 0 |
309067 | 309067 | 2020-07-06 | Lincoln | West Virginia | 54043 | 9 | 0 |
309135 | 309135 | 2020-07-06 | Lincoln | Wisconsin | 55069 | 15 | 0 |
309185 | 309185 | 2020-07-06 | Lincoln | Wyoming | 56023 | 36 | 0 |
303011 | 303011 | 2020-07-05 | Lincoln | Arkansas | 5079 | 1043 | 11 |
303140 | 303140 | 2020-07-05 | Lincoln | Colorado | 8073 | 4 | 0 |
303337 | 303337 | 2020-07-05 | Lincoln | Georgia | 13181 | 51 | 1 |
303441 | 303441 | 2020-07-05 | Lincoln | Idaho | 16063 | 36 | 0 |
303913 | 303913 | 2020-07-05 | Lincoln | Kentucky | 21137 | 30 | 1 |
303995 | 303995 | 2020-07-05 | Lincoln | Louisiana | 22061 | 350 | 19 |
304037 | 304037 | 2020-07-05 | Lincoln | Maine | 23015 | 25 | 0 |
304210 | 304210 | 2020-07-05 | Lincoln | Minnesota | 27081 | 10 | 0 |
304300 | 304300 | 2020-07-05 | Lincoln | Mississippi | 28085 | 460 | 34 |
304397 | 304397 | 2020-07-05 | Lincoln | Missouri | 29113 | 98 | 1 |
304475 | 304475 | 2020-07-05 | Lincoln | Montana | 30053 | 9 | 1 |
304542 | 304542 | 2020-07-05 | Lincoln | Nebraska | 31111 | 58 | 2 |
304582 | 304582 | 2020-07-05 | Lincoln | Nevada | 32017 | 2 | 0 |
304636 | 304636 | 2020-07-05 | Lincoln | New Mexico | 35027 | 13 | 0 |
304766 | 304766 | 2020-07-05 | Lincoln | North Carolina | 37109 | 300 | 1 |
304991 | 304991 | 2020-07-05 | Lincoln | Oklahoma | 40081 | 35 | 2 |
305047 | 305047 | 2020-07-05 | Lincoln | Oregon | 41041 | 346 | 4 |
305296 | 305296 | 2020-07-05 | Lincoln | South Dakota | 46083 | 365 | 1 |
305371 | 305371 | 2020-07-05 | Lincoln | Tennessee | 47103 | 64 | 0 |
305861 | 305861 | 2020-07-05 | Lincoln | Washington | 53043 | 4 | 0 |
305899 | 305899 | 2020-07-05 | Lincoln | West Virginia | 54043 | 8 | 0 |
305966 | 305966 | 2020-07-05 | Lincoln | Wisconsin | 55069 | 15 | 0 |
306016 | 306016 | 2020-07-05 | Lincoln | Wyoming | 56023 | 35 | 0 |
299847 | 299847 | 2020-07-04 | Lincoln | Arkansas | 5079 | 1041 | 11 |
299976 | 299976 | 2020-07-04 | Lincoln | Colorado | 8073 | 4 | 0 |
300173 | 300173 | 2020-07-04 | Lincoln | Georgia | 13181 | 51 | 1 |
300277 | 300277 | 2020-07-04 | Lincoln | Idaho | 16063 | 36 | 0 |
300749 | 300749 | 2020-07-04 | Lincoln | Kentucky | 21137 | 30 | 1 |
300831 | 300831 | 2020-07-04 | Lincoln | Louisiana | 22061 | 344 | 19 |
300873 | 300873 | 2020-07-04 | Lincoln | Maine | 23015 | 24 | 0 |
301046 | 301046 | 2020-07-04 | Lincoln | Minnesota | 27081 | 10 | 0 |
301136 | 301136 | 2020-07-04 | Lincoln | Mississippi | 28085 | 454 | 34 |
301233 | 301233 | 2020-07-04 | Lincoln | Missouri | 29113 | 98 | 1 |
301311 | 301311 | 2020-07-04 | Lincoln | Montana | 30053 | 9 | 1 |
301378 | 301378 | 2020-07-04 | Lincoln | Nebraska | 31111 | 58 | 2 |
301419 | 301419 | 2020-07-04 | Lincoln | Nevada | 32017 | 2 | 0 |
301473 | 301473 | 2020-07-04 | Lincoln | New Mexico | 35027 | 13 | 0 |
301603 | 301603 | 2020-07-04 | Lincoln | North Carolina | 37109 | 295 | 1 |
301828 | 301828 | 2020-07-04 | Lincoln | Oklahoma | 40081 | 33 | 2 |
301884 | 301884 | 2020-07-04 | Lincoln | Oregon | 41041 | 346 | 3 |
302133 | 302133 | 2020-07-04 | Lincoln | South Dakota | 46083 | 365 | 1 |
302208 | 302208 | 2020-07-04 | Lincoln | Tennessee | 47103 | 63 | 0 |
302697 | 302697 | 2020-07-04 | Lincoln | Washington | 53043 | 4 | 0 |
302735 | 302735 | 2020-07-04 | Lincoln | West Virginia | 54043 | 8 | 0 |
302802 | 302802 | 2020-07-04 | Lincoln | Wisconsin | 55069 | 14 | 0 |
302852 | 302852 | 2020-07-04 | Lincoln | Wyoming | 56023 | 34 | 0 |
296685 | 296685 | 2020-07-03 | Lincoln | Arkansas | 5079 | 1041 | 11 |
296814 | 296814 | 2020-07-03 | Lincoln | Colorado | 8073 | 4 | 0 |
297011 | 297011 | 2020-07-03 | Lincoln | Georgia | 13181 | 41 | 1 |
297115 | 297115 | 2020-07-03 | Lincoln | Idaho | 16063 | 36 | 0 |
297587 | 297587 | 2020-07-03 | Lincoln | Kentucky | 21137 | 30 | 1 |
297669 | 297669 | 2020-07-03 | Lincoln | Louisiana | 22061 | 344 | 19 |
297711 | 297711 | 2020-07-03 | Lincoln | Maine | 23015 | 24 | 0 |
297883 | 297883 | 2020-07-03 | Lincoln | Minnesota | 27081 | 10 | 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);