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 304
- Washington 304
- Arkansas 302
- Nebraska 301
- North Carolina 301
- Georgia 299
- Mississippi 298
- Louisiana 296
- Tennessee 295
- Oregon 294
- South Dakota 294
- Montana 293
- Oklahoma 293
- Colorado 292
- Minnesota 292
- Missouri 292
- Idaho 291
- Kentucky 286
- Wyoming 285
- New Mexico 284
- West Virginia 274
- Wisconsin 257
- Nevada 250
- Kansas 187
fips 24
county 1
- Lincoln · 6,864 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920719 | 920719 | 2021-01-12 | Lincoln | Colorado | 8073 | 800 | 3 |
920917 | 920917 | 2021-01-12 | Lincoln | Georgia | 13181 | 515 | 13 |
921025 | 921025 | 2021-01-12 | Lincoln | Idaho | 16063 | 455 | 9 |
921384 | 921384 | 2021-01-12 | Lincoln | Kansas | 20105 | 235 | 2 |
921506 | 921506 | 2021-01-12 | Lincoln | Kentucky | 21137 | 1654 | 27 |
921588 | 921588 | 2021-01-12 | Lincoln | Louisiana | 22061 | 3612 | 78 |
921630 | 921630 | 2021-01-12 | Lincoln | Maine | 23015 | 367 | 2 |
921804 | 921804 | 2021-01-12 | Lincoln | Minnesota | 27081 | 477 | 1 |
921894 | 921894 | 2021-01-12 | Lincoln | Mississippi | 28085 | 2862 | 83 |
921992 | 921992 | 2021-01-12 | Lincoln | Missouri | 29113 | 3817 | 23 |
922077 | 922077 | 2021-01-12 | Lincoln | Montana | 30053 | 1224 | 9 |
922162 | 922162 | 2021-01-12 | Lincoln | Nebraska | 31111 | 3197 | 39 |
922209 | 922209 | 2021-01-12 | Lincoln | Nevada | 32017 | 302 | 1 |
922264 | 922264 | 2021-01-12 | Lincoln | New Mexico | 35027 | 1178 | 13 |
922395 | 922395 | 2021-01-12 | Lincoln | North Carolina | 37109 | 6510 | 40 |
922625 | 922625 | 2021-01-12 | Lincoln | Oklahoma | 40081 | 2461 | 37 |
922683 | 922683 | 2021-01-12 | Lincoln | Oregon | 41041 | 964 | 17 |
922937 | 922937 | 2021-01-12 | Lincoln | South Dakota | 46083 | 7114 | 68 |
923014 | 923014 | 2021-01-12 | Lincoln | Tennessee | 47103 | 3657 | 41 |
923515 | 923515 | 2021-01-12 | Lincoln | Washington | 53043 | 281 | 5 |
923554 | 923554 | 2021-01-12 | Lincoln | West Virginia | 54043 | 954 | 9 |
923622 | 923622 | 2021-01-12 | Lincoln | Wisconsin | 55069 | 2834 | 64 |
923671 | 923671 | 2021-01-12 | Lincoln | Wyoming | 56023 | 1039 | 11 |
917342 | 917342 | 2021-01-11 | Lincoln | Arkansas | 5079 | 2908 | 28 |
917474 | 917474 | 2021-01-11 | Lincoln | Colorado | 8073 | 800 | 3 |
917672 | 917672 | 2021-01-11 | Lincoln | Georgia | 13181 | 507 | 13 |
917780 | 917780 | 2021-01-11 | Lincoln | Idaho | 16063 | 453 | 9 |
918139 | 918139 | 2021-01-11 | Lincoln | Kansas | 20105 | 235 | 2 |
918261 | 918261 | 2021-01-11 | Lincoln | Kentucky | 21137 | 1635 | 27 |
918343 | 918343 | 2021-01-11 | Lincoln | Louisiana | 22061 | 3587 | 78 |
918385 | 918385 | 2021-01-11 | Lincoln | Maine | 23015 | 357 | 2 |
918559 | 918559 | 2021-01-11 | Lincoln | Minnesota | 27081 | 477 | 1 |
918649 | 918649 | 2021-01-11 | Lincoln | Mississippi | 28085 | 2842 | 81 |
918747 | 918747 | 2021-01-11 | Lincoln | Missouri | 29113 | 3803 | 20 |
918832 | 918832 | 2021-01-11 | Lincoln | Montana | 30053 | 1201 | 9 |
918917 | 918917 | 2021-01-11 | Lincoln | Nebraska | 31111 | 3181 | 37 |
918964 | 918964 | 2021-01-11 | Lincoln | Nevada | 32017 | 302 | 1 |
919019 | 919019 | 2021-01-11 | Lincoln | New Mexico | 35027 | 1173 | 13 |
919150 | 919150 | 2021-01-11 | Lincoln | North Carolina | 37109 | 6439 | 40 |
919380 | 919380 | 2021-01-11 | Lincoln | Oklahoma | 40081 | 2443 | 36 |
919438 | 919438 | 2021-01-11 | Lincoln | Oregon | 41041 | 958 | 17 |
919692 | 919692 | 2021-01-11 | Lincoln | South Dakota | 46083 | 7089 | 68 |
919769 | 919769 | 2021-01-11 | Lincoln | Tennessee | 47103 | 3651 | 40 |
920270 | 920270 | 2021-01-11 | Lincoln | Washington | 53043 | 281 | 5 |
920309 | 920309 | 2021-01-11 | Lincoln | West Virginia | 54043 | 947 | 9 |
920377 | 920377 | 2021-01-11 | Lincoln | Wisconsin | 55069 | 2828 | 63 |
920426 | 920426 | 2021-01-11 | Lincoln | Wyoming | 56023 | 1032 | 11 |
914097 | 914097 | 2021-01-10 | Lincoln | Arkansas | 5079 | 2905 | 28 |
914229 | 914229 | 2021-01-10 | Lincoln | Colorado | 8073 | 800 | 3 |
914427 | 914427 | 2021-01-10 | Lincoln | Georgia | 13181 | 492 | 13 |
914535 | 914535 | 2021-01-10 | Lincoln | Idaho | 16063 | 450 | 9 |
914894 | 914894 | 2021-01-10 | Lincoln | Kansas | 20105 | 227 | 2 |
915016 | 915016 | 2021-01-10 | Lincoln | Kentucky | 21137 | 1633 | 27 |
915098 | 915098 | 2021-01-10 | Lincoln | Louisiana | 22061 | 3585 | 78 |
915140 | 915140 | 2021-01-10 | Lincoln | Maine | 23015 | 355 | 2 |
915314 | 915314 | 2021-01-10 | Lincoln | Minnesota | 27081 | 477 | 1 |
915404 | 915404 | 2021-01-10 | Lincoln | Mississippi | 28085 | 2835 | 81 |
915502 | 915502 | 2021-01-10 | Lincoln | Missouri | 29113 | 3791 | 20 |
915587 | 915587 | 2021-01-10 | Lincoln | Montana | 30053 | 1200 | 9 |
915672 | 915672 | 2021-01-10 | Lincoln | Nebraska | 31111 | 3156 | 37 |
915719 | 915719 | 2021-01-10 | Lincoln | Nevada | 32017 | 298 | 1 |
915774 | 915774 | 2021-01-10 | Lincoln | New Mexico | 35027 | 1153 | 13 |
915905 | 915905 | 2021-01-10 | Lincoln | North Carolina | 37109 | 6341 | 40 |
916135 | 916135 | 2021-01-10 | Lincoln | Oklahoma | 40081 | 2406 | 36 |
916193 | 916193 | 2021-01-10 | Lincoln | Oregon | 41041 | 950 | 17 |
916447 | 916447 | 2021-01-10 | Lincoln | South Dakota | 46083 | 7078 | 68 |
916524 | 916524 | 2021-01-10 | Lincoln | Tennessee | 47103 | 3639 | 39 |
917025 | 917025 | 2021-01-10 | Lincoln | Washington | 53043 | 277 | 5 |
917064 | 917064 | 2021-01-10 | Lincoln | West Virginia | 54043 | 932 | 9 |
917132 | 917132 | 2021-01-10 | Lincoln | Wisconsin | 55069 | 2819 | 63 |
917181 | 917181 | 2021-01-10 | Lincoln | Wyoming | 56023 | 1022 | 11 |
910852 | 910852 | 2021-01-09 | Lincoln | Arkansas | 5079 | 2900 | 28 |
910984 | 910984 | 2021-01-09 | Lincoln | Colorado | 8073 | 800 | 3 |
911182 | 911182 | 2021-01-09 | Lincoln | Georgia | 13181 | 481 | 13 |
911290 | 911290 | 2021-01-09 | Lincoln | Idaho | 16063 | 450 | 9 |
911649 | 911649 | 2021-01-09 | Lincoln | Kansas | 20105 | 227 | 2 |
911771 | 911771 | 2021-01-09 | Lincoln | Kentucky | 21137 | 1615 | 27 |
911853 | 911853 | 2021-01-09 | Lincoln | Louisiana | 22061 | 3520 | 78 |
911895 | 911895 | 2021-01-09 | Lincoln | Maine | 23015 | 355 | 2 |
912069 | 912069 | 2021-01-09 | Lincoln | Minnesota | 27081 | 475 | 1 |
912159 | 912159 | 2021-01-09 | Lincoln | Mississippi | 28085 | 2818 | 81 |
912257 | 912257 | 2021-01-09 | Lincoln | Missouri | 29113 | 3758 | 20 |
912342 | 912342 | 2021-01-09 | Lincoln | Montana | 30053 | 1198 | 9 |
912427 | 912427 | 2021-01-09 | Lincoln | Nebraska | 31111 | 3151 | 37 |
912474 | 912474 | 2021-01-09 | Lincoln | Nevada | 32017 | 298 | 1 |
912529 | 912529 | 2021-01-09 | Lincoln | New Mexico | 35027 | 1143 | 13 |
912660 | 912660 | 2021-01-09 | Lincoln | North Carolina | 37109 | 6228 | 39 |
912890 | 912890 | 2021-01-09 | Lincoln | Oklahoma | 40081 | 2355 | 35 |
912948 | 912948 | 2021-01-09 | Lincoln | Oregon | 41041 | 947 | 17 |
913202 | 913202 | 2021-01-09 | Lincoln | South Dakota | 46083 | 7052 | 68 |
913279 | 913279 | 2021-01-09 | Lincoln | Tennessee | 47103 | 3608 | 39 |
913780 | 913780 | 2021-01-09 | Lincoln | Washington | 53043 | 277 | 5 |
913819 | 913819 | 2021-01-09 | Lincoln | West Virginia | 54043 | 908 | 9 |
913887 | 913887 | 2021-01-09 | Lincoln | Wisconsin | 55069 | 2809 | 63 |
913936 | 913936 | 2021-01-09 | Lincoln | Wyoming | 56023 | 1019 | 11 |
907607 | 907607 | 2021-01-08 | Lincoln | Arkansas | 5079 | 2892 | 27 |
907739 | 907739 | 2021-01-08 | Lincoln | Colorado | 8073 | 789 | 3 |
907937 | 907937 | 2021-01-08 | Lincoln | Georgia | 13181 | 475 | 12 |
908045 | 908045 | 2021-01-08 | Lincoln | Idaho | 16063 | 450 | 9 |
908404 | 908404 | 2021-01-08 | Lincoln | Kansas | 20105 | 227 | 2 |
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);