ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where county = "Lincoln" and deaths = 69 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- Oklahoma 14
- Tennessee 8
- Louisiana 7
- Missouri 7
- West Virginia 7
- Kentucky 6
- Oregon 2
- Wisconsin 2
- Mississippi 1
- South Dakota 1
county 1
- Lincoln · 55 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2268369 | 2268369 | 2022-03-02 | Lincoln | West Virginia | 54043 | 5433 | 69 |
2265116 | 2265116 | 2022-03-01 | Lincoln | West Virginia | 54043 | 5432 | 69 |
2261866 | 2261866 | 2022-02-28 | Lincoln | West Virginia | 54043 | 5430 | 69 |
2258615 | 2258615 | 2022-02-27 | Lincoln | West Virginia | 54043 | 5411 | 69 |
2255364 | 2255364 | 2022-02-26 | Lincoln | West Virginia | 54043 | 5411 | 69 |
2252113 | 2252113 | 2022-02-25 | Lincoln | West Virginia | 54043 | 5411 | 69 |
2248862 | 2248862 | 2022-02-24 | Lincoln | West Virginia | 54043 | 5404 | 69 |
2244740 | 2244740 | 2022-02-23 | Lincoln | Oregon | 41041 | 6842 | 69 |
2241489 | 2241489 | 2022-02-22 | Lincoln | Oregon | 41041 | 6828 | 69 |
1873406 | 1873406 | 2021-11-01 | Lincoln | Missouri | 29113 | 9361 | 69 |
1870157 | 1870157 | 2021-10-31 | Lincoln | Missouri | 29113 | 9353 | 69 |
1866908 | 1866908 | 2021-10-30 | Lincoln | Missouri | 29113 | 9336 | 69 |
1863659 | 1863659 | 2021-10-29 | Lincoln | Missouri | 29113 | 9317 | 69 |
1860410 | 1860410 | 2021-10-28 | Lincoln | Missouri | 29113 | 9297 | 69 |
1857161 | 1857161 | 2021-10-27 | Lincoln | Missouri | 29113 | 9280 | 69 |
1853912 | 1853912 | 2021-10-26 | Lincoln | Missouri | 29113 | 9261 | 69 |
1710469 | 1710469 | 2021-09-12 | Lincoln | Kentucky | 21137 | 3378 | 69 |
1707222 | 1707222 | 2021-09-11 | Lincoln | Kentucky | 21137 | 3378 | 69 |
1703974 | 1703974 | 2021-09-10 | Lincoln | Kentucky | 21137 | 3378 | 69 |
1700724 | 1700724 | 2021-09-09 | Lincoln | Kentucky | 21137 | 3343 | 69 |
1697475 | 1697475 | 2021-09-08 | Lincoln | Kentucky | 21137 | 3309 | 69 |
1694227 | 1694227 | 2021-09-07 | Lincoln | Kentucky | 21137 | 3280 | 69 |
1627518 | 1627518 | 2021-08-17 | Lincoln | Tennessee | 47103 | 4932 | 69 |
1624271 | 1624271 | 2021-08-16 | Lincoln | Tennessee | 47103 | 4897 | 69 |
1621024 | 1621024 | 2021-08-15 | Lincoln | Tennessee | 47103 | 4816 | 69 |
1617776 | 1617776 | 2021-08-14 | Lincoln | Tennessee | 47103 | 4816 | 69 |
1614528 | 1614528 | 2021-08-13 | Lincoln | Tennessee | 47103 | 4816 | 69 |
1611279 | 1611279 | 2021-08-12 | Lincoln | Tennessee | 47103 | 4794 | 69 |
1608031 | 1608031 | 2021-08-11 | Lincoln | Tennessee | 47103 | 4758 | 69 |
1604782 | 1604782 | 2021-08-10 | Lincoln | Tennessee | 47103 | 4732 | 69 |
1240769 | 1240769 | 2021-04-20 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1237522 | 1237522 | 2021-04-19 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1234275 | 1234275 | 2021-04-18 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1231027 | 1231027 | 2021-04-17 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1227779 | 1227779 | 2021-04-16 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1224531 | 1224531 | 2021-04-15 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1221284 | 1221284 | 2021-04-14 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1218036 | 1218036 | 2021-04-13 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1214788 | 1214788 | 2021-04-12 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1211541 | 1211541 | 2021-04-11 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1208292 | 1208292 | 2021-04-10 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1205044 | 1205044 | 2021-04-09 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1201796 | 1201796 | 2021-04-08 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1198547 | 1198547 | 2021-04-07 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
969056 | 969056 | 2021-01-26 | Lincoln | Wisconsin | 55069 | 2956 | 69 |
965812 | 965812 | 2021-01-25 | Lincoln | Wisconsin | 55069 | 2951 | 69 |
935918 | 935918 | 2021-01-16 | Lincoln | South Dakota | 46083 | 7215 | 69 |
876153 | 876153 | 2020-12-29 | Lincoln | Louisiana | 22061 | 3259 | 69 |
872908 | 872908 | 2020-12-28 | Lincoln | Louisiana | 22061 | 3236 | 69 |
869663 | 869663 | 2020-12-27 | Lincoln | Louisiana | 22061 | 3233 | 69 |
866418 | 866418 | 2020-12-26 | Lincoln | Louisiana | 22061 | 3204 | 69 |
863173 | 863173 | 2020-12-25 | Lincoln | Louisiana | 22061 | 3204 | 69 |
859928 | 859928 | 2020-12-24 | Lincoln | Louisiana | 22061 | 3204 | 69 |
856683 | 856683 | 2020-12-23 | Lincoln | Louisiana | 22061 | 3159 | 69 |
808304 | 808304 | 2020-12-08 | Lincoln | Mississippi | 28085 | 2107 | 69 |
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);