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 786
- Washington 786
- Arkansas 784
- Nebraska 783
- North Carolina 783
- Georgia 780
- Mississippi 780
- Louisiana 778
- Tennessee 777
- Oregon 776
- South Dakota 776
- Montana 775
- Oklahoma 775
- Minnesota 774
- Missouri 774
- Colorado 773
- Idaho 772
- Kentucky 768
- Wyoming 767
- New Mexico 766
- West Virginia 756
- Wisconsin 739
- Nevada 732
- Kansas 669
fips 24
county 1
- Lincoln · 18,429 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487494 | 2487494 | 2022-05-09 | Lincoln | Kansas | 20105 | 623 | 10 |
2487616 | 2487616 | 2022-05-09 | Lincoln | Kentucky | 21137 | 6487 | 137 |
2487698 | 2487698 | 2022-05-09 | Lincoln | Louisiana | 22061 | 12253 | 144 |
2487740 | 2487740 | 2022-05-09 | Lincoln | Maine | 23015 | 5522 | 35 |
2487914 | 2487914 | 2022-05-09 | Lincoln | Minnesota | 27081 | 1218 | 6 |
2488004 | 2488004 | 2022-05-09 | Lincoln | Mississippi | 28085 | 8324 | 157 |
2488102 | 2488102 | 2022-05-09 | Lincoln | Missouri | 29113 | 15152 | 138 |
2488187 | 2488187 | 2022-05-09 | Lincoln | Montana | 30053 | 4784 | 89 |
2488272 | 2488272 | 2022-05-09 | Lincoln | Nebraska | 31111 | 8730 | 110 |
2488320 | 2488320 | 2022-05-09 | Lincoln | Nevada | 32017 | 548 | 7 |
2488376 | 2488376 | 2022-05-09 | Lincoln | New Mexico | 35027 | 5287 | 67 |
2488508 | 2488508 | 2022-05-09 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2488741 | 2488741 | 2022-05-09 | Lincoln | Oklahoma | 40081 | 7887 | 140 |
2488799 | 2488799 | 2022-05-09 | Lincoln | Oregon | 41041 | 7168 | 85 |
2489053 | 2489053 | 2022-05-09 | Lincoln | South Dakota | 46083 | 15559 | 102 |
2489130 | 2489130 | 2022-05-09 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2489632 | 2489632 | 2022-05-09 | Lincoln | Washington | 53043 | 2217 | 28 |
2489672 | 2489672 | 2022-05-09 | Lincoln | West Virginia | 54043 | 5588 | 82 |
2489740 | 2489740 | 2022-05-09 | Lincoln | Wisconsin | 55069 | 7144 | 148 |
2489789 | 2489789 | 2022-05-09 | Lincoln | Wyoming | 56023 | 3978 | 31 |
2483436 | 2483436 | 2022-05-08 | Lincoln | Arkansas | 5079 | 4918 | 68 |
2483568 | 2483568 | 2022-05-08 | Lincoln | Colorado | 8073 | 2183 | 9 |
2483766 | 2483766 | 2022-05-08 | Lincoln | Georgia | 13181 | 1601 | 35 |
2483875 | 2483875 | 2022-05-08 | Lincoln | Idaho | 16063 | 1108 | 15 |
2484236 | 2484236 | 2022-05-08 | Lincoln | Kansas | 20105 | 623 | 10 |
2484358 | 2484358 | 2022-05-08 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2484440 | 2484440 | 2022-05-08 | Lincoln | Louisiana | 22061 | 12252 | 144 |
2484482 | 2484482 | 2022-05-08 | Lincoln | Maine | 23015 | 5517 | 35 |
2484656 | 2484656 | 2022-05-08 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2484746 | 2484746 | 2022-05-08 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2484845 | 2484845 | 2022-05-08 | Lincoln | Missouri | 29113 | 15152 | 138 |
2484930 | 2484930 | 2022-05-08 | Lincoln | Montana | 30053 | 4784 | 89 |
2485015 | 2485015 | 2022-05-08 | Lincoln | Nebraska | 31111 | 8726 | 110 |
2485063 | 2485063 | 2022-05-08 | Lincoln | Nevada | 32017 | 548 | 7 |
2485119 | 2485119 | 2022-05-08 | Lincoln | New Mexico | 35027 | 5283 | 67 |
2485251 | 2485251 | 2022-05-08 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2485484 | 2485484 | 2022-05-08 | Lincoln | Oklahoma | 40081 | 7887 | 140 |
2485542 | 2485542 | 2022-05-08 | Lincoln | Oregon | 41041 | 7145 | 85 |
2485796 | 2485796 | 2022-05-08 | Lincoln | South Dakota | 46083 | 15559 | 102 |
2485873 | 2485873 | 2022-05-08 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2486375 | 2486375 | 2022-05-08 | Lincoln | Washington | 53043 | 2217 | 28 |
2486415 | 2486415 | 2022-05-08 | Lincoln | West Virginia | 54043 | 5572 | 82 |
2486483 | 2486483 | 2022-05-08 | Lincoln | Wisconsin | 55069 | 7111 | 148 |
2486532 | 2486532 | 2022-05-08 | Lincoln | Wyoming | 56023 | 3978 | 31 |
2480178 | 2480178 | 2022-05-07 | Lincoln | Arkansas | 5079 | 4918 | 68 |
2480310 | 2480310 | 2022-05-07 | Lincoln | Colorado | 8073 | 2183 | 9 |
2480508 | 2480508 | 2022-05-07 | Lincoln | Georgia | 13181 | 1601 | 35 |
2480617 | 2480617 | 2022-05-07 | Lincoln | Idaho | 16063 | 1108 | 15 |
2480978 | 2480978 | 2022-05-07 | Lincoln | Kansas | 20105 | 623 | 10 |
2481100 | 2481100 | 2022-05-07 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2481182 | 2481182 | 2022-05-07 | Lincoln | Louisiana | 22061 | 12252 | 144 |
2481224 | 2481224 | 2022-05-07 | Lincoln | Maine | 23015 | 5517 | 35 |
2481398 | 2481398 | 2022-05-07 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2481488 | 2481488 | 2022-05-07 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2481587 | 2481587 | 2022-05-07 | Lincoln | Missouri | 29113 | 15152 | 138 |
2481672 | 2481672 | 2022-05-07 | Lincoln | Montana | 30053 | 4784 | 89 |
2481757 | 2481757 | 2022-05-07 | Lincoln | Nebraska | 31111 | 8726 | 110 |
2481805 | 2481805 | 2022-05-07 | Lincoln | Nevada | 32017 | 548 | 7 |
2481861 | 2481861 | 2022-05-07 | Lincoln | New Mexico | 35027 | 5283 | 67 |
2481993 | 2481993 | 2022-05-07 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2482226 | 2482226 | 2022-05-07 | Lincoln | Oklahoma | 40081 | 7887 | 140 |
2482284 | 2482284 | 2022-05-07 | Lincoln | Oregon | 41041 | 7145 | 85 |
2482538 | 2482538 | 2022-05-07 | Lincoln | South Dakota | 46083 | 15559 | 102 |
2482615 | 2482615 | 2022-05-07 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2483117 | 2483117 | 2022-05-07 | Lincoln | Washington | 53043 | 2217 | 28 |
2483157 | 2483157 | 2022-05-07 | Lincoln | West Virginia | 54043 | 5572 | 82 |
2483225 | 2483225 | 2022-05-07 | Lincoln | Wisconsin | 55069 | 7111 | 148 |
2483274 | 2483274 | 2022-05-07 | Lincoln | Wyoming | 56023 | 3978 | 31 |
2476920 | 2476920 | 2022-05-06 | Lincoln | Arkansas | 5079 | 4918 | 68 |
2477052 | 2477052 | 2022-05-06 | Lincoln | Colorado | 8073 | 2183 | 9 |
2477250 | 2477250 | 2022-05-06 | Lincoln | Georgia | 13181 | 1601 | 35 |
2477359 | 2477359 | 2022-05-06 | Lincoln | Idaho | 16063 | 1108 | 15 |
2477720 | 2477720 | 2022-05-06 | Lincoln | Kansas | 20105 | 623 | 10 |
2477842 | 2477842 | 2022-05-06 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2477924 | 2477924 | 2022-05-06 | Lincoln | Louisiana | 22061 | 12252 | 144 |
2477966 | 2477966 | 2022-05-06 | Lincoln | Maine | 23015 | 5503 | 35 |
2478140 | 2478140 | 2022-05-06 | Lincoln | Minnesota | 27081 | 1217 | 6 |
2478230 | 2478230 | 2022-05-06 | Lincoln | Mississippi | 28085 | 8318 | 157 |
2478329 | 2478329 | 2022-05-06 | Lincoln | Missouri | 29113 | 15152 | 138 |
2478414 | 2478414 | 2022-05-06 | Lincoln | Montana | 30053 | 4784 | 89 |
2478499 | 2478499 | 2022-05-06 | Lincoln | Nebraska | 31111 | 8726 | 110 |
2478547 | 2478547 | 2022-05-06 | Lincoln | Nevada | 32017 | 548 | 7 |
2478603 | 2478603 | 2022-05-06 | Lincoln | New Mexico | 35027 | 5283 | 67 |
2478735 | 2478735 | 2022-05-06 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2478968 | 2478968 | 2022-05-06 | Lincoln | Oklahoma | 40081 | 7887 | 140 |
2479026 | 2479026 | 2022-05-06 | Lincoln | Oregon | 41041 | 7145 | 85 |
2479280 | 2479280 | 2022-05-06 | Lincoln | South Dakota | 46083 | 15559 | 102 |
2479357 | 2479357 | 2022-05-06 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2479859 | 2479859 | 2022-05-06 | Lincoln | Washington | 53043 | 2217 | 28 |
2479899 | 2479899 | 2022-05-06 | Lincoln | West Virginia | 54043 | 5572 | 82 |
2479967 | 2479967 | 2022-05-06 | Lincoln | Wisconsin | 55069 | 7111 | 148 |
2480016 | 2480016 | 2022-05-06 | Lincoln | Wyoming | 56023 | 3978 | 31 |
2473662 | 2473662 | 2022-05-05 | Lincoln | Arkansas | 5079 | 4917 | 68 |
2473794 | 2473794 | 2022-05-05 | Lincoln | Colorado | 8073 | 2183 | 9 |
2473992 | 2473992 | 2022-05-05 | Lincoln | Georgia | 13181 | 1601 | 35 |
2474101 | 2474101 | 2022-05-05 | Lincoln | Idaho | 16063 | 1108 | 15 |
2474462 | 2474462 | 2022-05-05 | Lincoln | Kansas | 20105 | 623 | 10 |
2474584 | 2474584 | 2022-05-05 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2474666 | 2474666 | 2022-05-05 | Lincoln | Louisiana | 22061 | 12249 | 144 |
2474708 | 2474708 | 2022-05-05 | Lincoln | Maine | 23015 | 5480 | 35 |
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);