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 345
- Washington 345
- Arkansas 344
- Nebraska 342
- North Carolina 342
- Georgia 340
- Mississippi 339
- Louisiana 337
- Tennessee 336
- Oregon 335
- South Dakota 335
- Montana 334
- Oklahoma 334
- Colorado 333
- Minnesota 333
- Missouri 333
- Idaho 332
- Kentucky 327
- Wyoming 326
- New Mexico 325
- West Virginia 315
- Wisconsin 298
- Nevada 291
- Kansas 228
fips 24
county 1
- Lincoln · 7,849 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053655 | 1053655 | 2021-02-22 | Lincoln | Arkansas | 5079 | 3130 | 42 |
1053787 | 1053787 | 2021-02-22 | Lincoln | Colorado | 8073 | 996 | 3 |
1053985 | 1053985 | 2021-02-22 | Lincoln | Georgia | 13181 | 726 | 21 |
1054093 | 1054093 | 2021-02-22 | Lincoln | Idaho | 16063 | 484 | 11 |
1054453 | 1054453 | 2021-02-22 | Lincoln | Kansas | 20105 | 254 | 4 |
1054575 | 1054575 | 2021-02-22 | Lincoln | Kentucky | 21137 | 2064 | 32 |
1054657 | 1054657 | 2021-02-22 | Lincoln | Louisiana | 22061 | 4213 | 88 |
1054699 | 1054699 | 2021-02-22 | Lincoln | Maine | 23015 | 568 | 1 |
1054873 | 1054873 | 2021-02-22 | Lincoln | Minnesota | 27081 | 502 | 2 |
1054963 | 1054963 | 2021-02-22 | Lincoln | Mississippi | 28085 | 3428 | 99 |
1055061 | 1055061 | 2021-02-22 | Lincoln | Missouri | 29113 | 4272 | 32 |
1055146 | 1055146 | 2021-02-22 | Lincoln | Montana | 30053 | 1480 | 13 |
1055231 | 1055231 | 2021-02-22 | Lincoln | Nebraska | 31111 | 3535 | 51 |
1055278 | 1055278 | 2021-02-22 | Lincoln | Nevada | 32017 | 346 | 1 |
1055333 | 1055333 | 2021-02-22 | Lincoln | New Mexico | 35027 | 1516 | 15 |
1055464 | 1055464 | 2021-02-22 | Lincoln | North Carolina | 37109 | 8661 | 66 |
1055694 | 1055694 | 2021-02-22 | Lincoln | Oklahoma | 40081 | 3002 | 54 |
1055752 | 1055752 | 2021-02-22 | Lincoln | Oregon | 41041 | 1121 | 19 |
1056006 | 1056006 | 2021-02-22 | Lincoln | South Dakota | 46083 | 7668 | 77 |
1056083 | 1056083 | 2021-02-22 | Lincoln | Tennessee | 47103 | 4097 | 61 |
1056584 | 1056584 | 2021-02-22 | Lincoln | Washington | 53043 | 335 | 5 |
1056623 | 1056623 | 2021-02-22 | Lincoln | West Virginia | 54043 | 1209 | 13 |
1056691 | 1056691 | 2021-02-22 | Lincoln | Wisconsin | 55069 | 3081 | 73 |
1056740 | 1056740 | 2021-02-22 | Lincoln | Wyoming | 56023 | 1212 | 11 |
1050408 | 1050408 | 2021-02-21 | Lincoln | Arkansas | 5079 | 3128 | 43 |
1050540 | 1050540 | 2021-02-21 | Lincoln | Colorado | 8073 | 996 | 3 |
1050738 | 1050738 | 2021-02-21 | Lincoln | Georgia | 13181 | 723 | 21 |
1050846 | 1050846 | 2021-02-21 | Lincoln | Idaho | 16063 | 483 | 11 |
1051206 | 1051206 | 2021-02-21 | Lincoln | Kansas | 20105 | 254 | 4 |
1051328 | 1051328 | 2021-02-21 | Lincoln | Kentucky | 21137 | 2062 | 32 |
1051410 | 1051410 | 2021-02-21 | Lincoln | Louisiana | 22061 | 4212 | 88 |
1051452 | 1051452 | 2021-02-21 | Lincoln | Maine | 23015 | 566 | 1 |
1051626 | 1051626 | 2021-02-21 | Lincoln | Minnesota | 27081 | 502 | 2 |
1051716 | 1051716 | 2021-02-21 | Lincoln | Mississippi | 28085 | 3423 | 99 |
1051814 | 1051814 | 2021-02-21 | Lincoln | Missouri | 29113 | 4267 | 32 |
1051899 | 1051899 | 2021-02-21 | Lincoln | Montana | 30053 | 1480 | 13 |
1051984 | 1051984 | 2021-02-21 | Lincoln | Nebraska | 31111 | 3529 | 51 |
1052031 | 1052031 | 2021-02-21 | Lincoln | Nevada | 32017 | 346 | 1 |
1052086 | 1052086 | 2021-02-21 | Lincoln | New Mexico | 35027 | 1515 | 15 |
1052218 | 1052218 | 2021-02-21 | Lincoln | North Carolina | 37109 | 8632 | 66 |
1052448 | 1052448 | 2021-02-21 | Lincoln | Oklahoma | 40081 | 3001 | 54 |
1052506 | 1052506 | 2021-02-21 | Lincoln | Oregon | 41041 | 1121 | 19 |
1052760 | 1052760 | 2021-02-21 | Lincoln | South Dakota | 46083 | 7668 | 77 |
1052837 | 1052837 | 2021-02-21 | Lincoln | Tennessee | 47103 | 4092 | 61 |
1053338 | 1053338 | 2021-02-21 | Lincoln | Washington | 53043 | 335 | 5 |
1053377 | 1053377 | 2021-02-21 | Lincoln | West Virginia | 54043 | 1207 | 13 |
1053445 | 1053445 | 2021-02-21 | Lincoln | Wisconsin | 55069 | 3081 | 73 |
1053494 | 1053494 | 2021-02-21 | Lincoln | Wyoming | 56023 | 1210 | 11 |
1047161 | 1047161 | 2021-02-20 | Lincoln | Arkansas | 5079 | 3127 | 42 |
1047293 | 1047293 | 2021-02-20 | Lincoln | Colorado | 8073 | 996 | 3 |
1047491 | 1047491 | 2021-02-20 | Lincoln | Georgia | 13181 | 720 | 21 |
1047599 | 1047599 | 2021-02-20 | Lincoln | Idaho | 16063 | 483 | 11 |
1047959 | 1047959 | 2021-02-20 | Lincoln | Kansas | 20105 | 254 | 4 |
1048081 | 1048081 | 2021-02-20 | Lincoln | Kentucky | 21137 | 2057 | 32 |
1048163 | 1048163 | 2021-02-20 | Lincoln | Louisiana | 22061 | 4205 | 88 |
1048205 | 1048205 | 2021-02-20 | Lincoln | Maine | 23015 | 563 | 1 |
1048379 | 1048379 | 2021-02-20 | Lincoln | Minnesota | 27081 | 501 | 2 |
1048469 | 1048469 | 2021-02-20 | Lincoln | Mississippi | 28085 | 3416 | 99 |
1048567 | 1048567 | 2021-02-20 | Lincoln | Missouri | 29113 | 4264 | 32 |
1048652 | 1048652 | 2021-02-20 | Lincoln | Montana | 30053 | 1480 | 13 |
1048737 | 1048737 | 2021-02-20 | Lincoln | Nebraska | 31111 | 3526 | 51 |
1048784 | 1048784 | 2021-02-20 | Lincoln | Nevada | 32017 | 346 | 1 |
1048839 | 1048839 | 2021-02-20 | Lincoln | New Mexico | 35027 | 1511 | 15 |
1048971 | 1048971 | 2021-02-20 | Lincoln | North Carolina | 37109 | 8607 | 66 |
1049201 | 1049201 | 2021-02-20 | Lincoln | Oklahoma | 40081 | 2997 | 54 |
1049259 | 1049259 | 2021-02-20 | Lincoln | Oregon | 41041 | 1120 | 19 |
1049513 | 1049513 | 2021-02-20 | Lincoln | South Dakota | 46083 | 7660 | 77 |
1049590 | 1049590 | 2021-02-20 | Lincoln | Tennessee | 47103 | 4088 | 61 |
1050091 | 1050091 | 2021-02-20 | Lincoln | Washington | 53043 | 335 | 5 |
1050130 | 1050130 | 2021-02-20 | Lincoln | West Virginia | 54043 | 1205 | 13 |
1050198 | 1050198 | 2021-02-20 | Lincoln | Wisconsin | 55069 | 3078 | 73 |
1050247 | 1050247 | 2021-02-20 | Lincoln | Wyoming | 56023 | 1202 | 11 |
1043916 | 1043916 | 2021-02-19 | Lincoln | Arkansas | 5079 | 3127 | 42 |
1044048 | 1044048 | 2021-02-19 | Lincoln | Colorado | 8073 | 989 | 3 |
1044246 | 1044246 | 2021-02-19 | Lincoln | Georgia | 13181 | 718 | 19 |
1044354 | 1044354 | 2021-02-19 | Lincoln | Idaho | 16063 | 483 | 11 |
1044714 | 1044714 | 2021-02-19 | Lincoln | Kansas | 20105 | 254 | 4 |
1044836 | 1044836 | 2021-02-19 | Lincoln | Kentucky | 21137 | 2056 | 32 |
1044918 | 1044918 | 2021-02-19 | Lincoln | Louisiana | 22061 | 4205 | 88 |
1044960 | 1044960 | 2021-02-19 | Lincoln | Maine | 23015 | 559 | 1 |
1045133 | 1045133 | 2021-02-19 | Lincoln | Minnesota | 27081 | 501 | 2 |
1045223 | 1045223 | 2021-02-19 | Lincoln | Mississippi | 28085 | 3413 | 99 |
1045321 | 1045321 | 2021-02-19 | Lincoln | Missouri | 29113 | 4260 | 32 |
1045406 | 1045406 | 2021-02-19 | Lincoln | Montana | 30053 | 1476 | 13 |
1045491 | 1045491 | 2021-02-19 | Lincoln | Nebraska | 31111 | 3522 | 51 |
1045538 | 1045538 | 2021-02-19 | Lincoln | Nevada | 32017 | 346 | 1 |
1045593 | 1045593 | 2021-02-19 | Lincoln | New Mexico | 35027 | 1510 | 15 |
1045724 | 1045724 | 2021-02-19 | Lincoln | North Carolina | 37109 | 8582 | 66 |
1045954 | 1045954 | 2021-02-19 | Lincoln | Oklahoma | 40081 | 2994 | 54 |
1046012 | 1046012 | 2021-02-19 | Lincoln | Oregon | 41041 | 1119 | 19 |
1046266 | 1046266 | 2021-02-19 | Lincoln | South Dakota | 46083 | 7649 | 77 |
1046343 | 1046343 | 2021-02-19 | Lincoln | Tennessee | 47103 | 4085 | 61 |
1046844 | 1046844 | 2021-02-19 | Lincoln | Washington | 53043 | 335 | 5 |
1046883 | 1046883 | 2021-02-19 | Lincoln | West Virginia | 54043 | 1198 | 13 |
1046951 | 1046951 | 2021-02-19 | Lincoln | Wisconsin | 55069 | 3074 | 73 |
1047000 | 1047000 | 2021-02-19 | Lincoln | Wyoming | 56023 | 1202 | 11 |
1040671 | 1040671 | 2021-02-18 | Lincoln | Arkansas | 5079 | 3125 | 42 |
1040803 | 1040803 | 2021-02-18 | Lincoln | Colorado | 8073 | 988 | 3 |
1041001 | 1041001 | 2021-02-18 | Lincoln | Georgia | 13181 | 716 | 19 |
1041109 | 1041109 | 2021-02-18 | Lincoln | Idaho | 16063 | 483 | 11 |
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);