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 212
- Washington 212
- Arkansas 210
- Nebraska 209
- North Carolina 209
- Georgia 206
- Mississippi 206
- Louisiana 204
- Tennessee 203
- Oregon 202
- South Dakota 202
- Montana 201
- Oklahoma 201
- Minnesota 200
- Missouri 200
- Colorado 199
- Idaho 198
- Kentucky 194
- Wyoming 193
- New Mexico 192
- West Virginia 182
- Wisconsin 165
- Nevada 158
- Kansas 94
fips 24
county 1
- Lincoln · 4,652 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
622977 | 622977 | 2020-10-12 | Lincoln | Kentucky | 21137 | 250 | 16 |
623059 | 623059 | 2020-10-12 | Lincoln | Louisiana | 22061 | 1542 | 48 |
623101 | 623101 | 2020-10-12 | Lincoln | Maine | 23015 | 50 | 1 |
623274 | 623274 | 2020-10-12 | Lincoln | Minnesota | 27081 | 147 | 0 |
623364 | 623364 | 2020-10-12 | Lincoln | Mississippi | 28085 | 1247 | 53 |
623462 | 623462 | 2020-10-12 | Lincoln | Missouri | 29113 | 948 | 3 |
623547 | 623547 | 2020-10-12 | Lincoln | Montana | 30053 | 192 | 3 |
623632 | 623632 | 2020-10-12 | Lincoln | Nebraska | 31111 | 568 | 4 |
623679 | 623679 | 2020-10-12 | Lincoln | Nevada | 32017 | 16 | 0 |
623734 | 623734 | 2020-10-12 | Lincoln | New Mexico | 35027 | 260 | 4 |
623865 | 623865 | 2020-10-12 | Lincoln | North Carolina | 37109 | 2000 | 16 |
624095 | 624095 | 2020-10-12 | Lincoln | Oklahoma | 40081 | 648 | 10 |
624153 | 624153 | 2020-10-12 | Lincoln | Oregon | 41041 | 496 | 13 |
624407 | 624407 | 2020-10-12 | Lincoln | South Dakota | 46083 | 1844 | 10 |
624484 | 624484 | 2020-10-12 | Lincoln | Tennessee | 47103 | 730 | 2 |
624983 | 624983 | 2020-10-12 | Lincoln | Washington | 53043 | 63 | 1 |
625023 | 625023 | 2020-10-12 | Lincoln | West Virginia | 54043 | 198 | 2 |
625091 | 625091 | 2020-10-12 | Lincoln | Wisconsin | 55069 | 454 | 4 |
625141 | 625141 | 2020-10-12 | Lincoln | Wyoming | 56023 | 282 | 1 |
618815 | 618815 | 2020-10-11 | Lincoln | Arkansas | 5079 | 2148 | 17 |
618947 | 618947 | 2020-10-11 | Lincoln | Colorado | 8073 | 24 | 0 |
619145 | 619145 | 2020-10-11 | Lincoln | Georgia | 13181 | 232 | 7 |
619252 | 619252 | 2020-10-11 | Lincoln | Idaho | 16063 | 105 | 0 |
619612 | 619612 | 2020-10-11 | Lincoln | Kansas | 20105 | 15 | 0 |
619733 | 619733 | 2020-10-11 | Lincoln | Kentucky | 21137 | 246 | 16 |
619815 | 619815 | 2020-10-11 | Lincoln | Louisiana | 22061 | 1537 | 48 |
619857 | 619857 | 2020-10-11 | Lincoln | Maine | 23015 | 50 | 1 |
620031 | 620031 | 2020-10-11 | Lincoln | Minnesota | 27081 | 147 | 0 |
620121 | 620121 | 2020-10-11 | Lincoln | Mississippi | 28085 | 1241 | 53 |
620219 | 620219 | 2020-10-11 | Lincoln | Missouri | 29113 | 948 | 3 |
620304 | 620304 | 2020-10-11 | Lincoln | Montana | 30053 | 192 | 3 |
620389 | 620389 | 2020-10-11 | Lincoln | Nebraska | 31111 | 558 | 4 |
620436 | 620436 | 2020-10-11 | Lincoln | Nevada | 32017 | 14 | 0 |
620491 | 620491 | 2020-10-11 | Lincoln | New Mexico | 35027 | 260 | 3 |
620622 | 620622 | 2020-10-11 | Lincoln | North Carolina | 37109 | 1972 | 16 |
620852 | 620852 | 2020-10-11 | Lincoln | Oklahoma | 40081 | 628 | 10 |
620910 | 620910 | 2020-10-11 | Lincoln | Oregon | 41041 | 496 | 13 |
621164 | 621164 | 2020-10-11 | Lincoln | South Dakota | 46083 | 1832 | 10 |
621241 | 621241 | 2020-10-11 | Lincoln | Tennessee | 47103 | 719 | 2 |
621740 | 621740 | 2020-10-11 | Lincoln | Washington | 53043 | 63 | 1 |
621780 | 621780 | 2020-10-11 | Lincoln | West Virginia | 54043 | 198 | 2 |
621848 | 621848 | 2020-10-11 | Lincoln | Wisconsin | 55069 | 437 | 4 |
621898 | 621898 | 2020-10-11 | Lincoln | Wyoming | 56023 | 274 | 1 |
615573 | 615573 | 2020-10-10 | Lincoln | Arkansas | 5079 | 2141 | 17 |
615705 | 615705 | 2020-10-10 | Lincoln | Colorado | 8073 | 24 | 0 |
615903 | 615903 | 2020-10-10 | Lincoln | Georgia | 13181 | 232 | 7 |
616010 | 616010 | 2020-10-10 | Lincoln | Idaho | 16063 | 105 | 0 |
616370 | 616370 | 2020-10-10 | Lincoln | Kansas | 20105 | 15 | 0 |
616491 | 616491 | 2020-10-10 | Lincoln | Kentucky | 21137 | 245 | 16 |
616573 | 616573 | 2020-10-10 | Lincoln | Louisiana | 22061 | 1469 | 48 |
616615 | 616615 | 2020-10-10 | Lincoln | Maine | 23015 | 50 | 1 |
616789 | 616789 | 2020-10-10 | Lincoln | Minnesota | 27081 | 144 | 0 |
616879 | 616879 | 2020-10-10 | Lincoln | Mississippi | 28085 | 1236 | 53 |
616977 | 616977 | 2020-10-10 | Lincoln | Missouri | 29113 | 948 | 3 |
617062 | 617062 | 2020-10-10 | Lincoln | Montana | 30053 | 181 | 3 |
617147 | 617147 | 2020-10-10 | Lincoln | Nebraska | 31111 | 546 | 4 |
617194 | 617194 | 2020-10-10 | Lincoln | Nevada | 32017 | 14 | 0 |
617249 | 617249 | 2020-10-10 | Lincoln | New Mexico | 35027 | 250 | 3 |
617380 | 617380 | 2020-10-10 | Lincoln | North Carolina | 37109 | 1951 | 16 |
617610 | 617610 | 2020-10-10 | Lincoln | Oklahoma | 40081 | 619 | 10 |
617668 | 617668 | 2020-10-10 | Lincoln | Oregon | 41041 | 495 | 13 |
617921 | 617921 | 2020-10-10 | Lincoln | South Dakota | 46083 | 1788 | 10 |
617998 | 617998 | 2020-10-10 | Lincoln | Tennessee | 47103 | 716 | 2 |
618497 | 618497 | 2020-10-10 | Lincoln | Washington | 53043 | 63 | 1 |
618537 | 618537 | 2020-10-10 | Lincoln | West Virginia | 54043 | 198 | 2 |
618605 | 618605 | 2020-10-10 | Lincoln | Wisconsin | 55069 | 417 | 3 |
618655 | 618655 | 2020-10-10 | Lincoln | Wyoming | 56023 | 262 | 1 |
612332 | 612332 | 2020-10-09 | Lincoln | Arkansas | 5079 | 2140 | 17 |
612464 | 612464 | 2020-10-09 | Lincoln | Colorado | 8073 | 24 | 0 |
612662 | 612662 | 2020-10-09 | Lincoln | Georgia | 13181 | 230 | 7 |
612769 | 612769 | 2020-10-09 | Lincoln | Idaho | 16063 | 105 | 0 |
613129 | 613129 | 2020-10-09 | Lincoln | Kansas | 20105 | 15 | 0 |
613250 | 613250 | 2020-10-09 | Lincoln | Kentucky | 21137 | 246 | 16 |
613332 | 613332 | 2020-10-09 | Lincoln | Louisiana | 22061 | 1469 | 48 |
613374 | 613374 | 2020-10-09 | Lincoln | Maine | 23015 | 50 | 1 |
613548 | 613548 | 2020-10-09 | Lincoln | Minnesota | 27081 | 140 | 0 |
613638 | 613638 | 2020-10-09 | Lincoln | Mississippi | 28085 | 1209 | 53 |
613736 | 613736 | 2020-10-09 | Lincoln | Missouri | 29113 | 938 | 3 |
613821 | 613821 | 2020-10-09 | Lincoln | Montana | 30053 | 178 | 3 |
613906 | 613906 | 2020-10-09 | Lincoln | Nebraska | 31111 | 512 | 4 |
613952 | 613952 | 2020-10-09 | Lincoln | Nevada | 32017 | 10 | 0 |
614007 | 614007 | 2020-10-09 | Lincoln | New Mexico | 35027 | 246 | 3 |
614138 | 614138 | 2020-10-09 | Lincoln | North Carolina | 37109 | 1909 | 16 |
614368 | 614368 | 2020-10-09 | Lincoln | Oklahoma | 40081 | 598 | 10 |
614426 | 614426 | 2020-10-09 | Lincoln | Oregon | 41041 | 493 | 13 |
614679 | 614679 | 2020-10-09 | Lincoln | South Dakota | 46083 | 1740 | 8 |
614756 | 614756 | 2020-10-09 | Lincoln | Tennessee | 47103 | 711 | 2 |
615255 | 615255 | 2020-10-09 | Lincoln | Washington | 53043 | 63 | 1 |
615295 | 615295 | 2020-10-09 | Lincoln | West Virginia | 54043 | 195 | 2 |
615363 | 615363 | 2020-10-09 | Lincoln | Wisconsin | 55069 | 401 | 3 |
615413 | 615413 | 2020-10-09 | Lincoln | Wyoming | 56023 | 260 | 1 |
609090 | 609090 | 2020-10-08 | Lincoln | Arkansas | 5079 | 2100 | 17 |
609222 | 609222 | 2020-10-08 | Lincoln | Colorado | 8073 | 25 | 0 |
609420 | 609420 | 2020-10-08 | Lincoln | Georgia | 13181 | 230 | 7 |
609527 | 609527 | 2020-10-08 | Lincoln | Idaho | 16063 | 100 | 0 |
609887 | 609887 | 2020-10-08 | Lincoln | Kansas | 20105 | 15 | 0 |
610008 | 610008 | 2020-10-08 | Lincoln | Kentucky | 21137 | 244 | 16 |
610090 | 610090 | 2020-10-08 | Lincoln | Louisiana | 22061 | 1471 | 48 |
610132 | 610132 | 2020-10-08 | Lincoln | Maine | 23015 | 50 | 1 |
610306 | 610306 | 2020-10-08 | Lincoln | Minnesota | 27081 | 136 | 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);