ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Lincoln" and fips = 54043 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177318 | 2177318 | 2022-02-02 | Lincoln | West Virginia | 54043 | 4862 | 62 |
2174065 | 2174065 | 2022-02-01 | Lincoln | West Virginia | 54043 | 4813 | 62 |
2170813 | 2170813 | 2022-01-31 | Lincoln | West Virginia | 54043 | 4773 | 62 |
2167560 | 2167560 | 2022-01-30 | Lincoln | West Virginia | 54043 | 4746 | 62 |
2164305 | 2164305 | 2022-01-29 | Lincoln | West Virginia | 54043 | 4718 | 62 |
2161050 | 2161050 | 2022-01-28 | Lincoln | West Virginia | 54043 | 4674 | 62 |
2157794 | 2157794 | 2022-01-27 | Lincoln | West Virginia | 54043 | 4603 | 62 |
2154541 | 2154541 | 2022-01-26 | Lincoln | West Virginia | 54043 | 4516 | 61 |
2151288 | 2151288 | 2022-01-25 | Lincoln | West Virginia | 54043 | 4463 | 58 |
2148036 | 2148036 | 2022-01-24 | Lincoln | West Virginia | 54043 | 4419 | 58 |
2144784 | 2144784 | 2022-01-23 | Lincoln | West Virginia | 54043 | 4384 | 58 |
2141529 | 2141529 | 2022-01-22 | Lincoln | West Virginia | 54043 | 4317 | 58 |
2138273 | 2138273 | 2022-01-21 | Lincoln | West Virginia | 54043 | 4243 | 58 |
2135018 | 2135018 | 2022-01-20 | Lincoln | West Virginia | 54043 | 4198 | 58 |
2131766 | 2131766 | 2022-01-19 | Lincoln | West Virginia | 54043 | 4150 | 58 |
2128512 | 2128512 | 2022-01-18 | Lincoln | West Virginia | 54043 | 4092 | 58 |
2125259 | 2125259 | 2022-01-17 | Lincoln | West Virginia | 54043 | 4075 | 58 |
2122007 | 2122007 | 2022-01-16 | Lincoln | West Virginia | 54043 | 4042 | 58 |
2118755 | 2118755 | 2022-01-15 | Lincoln | West Virginia | 54043 | 4011 | 58 |
2115503 | 2115503 | 2022-01-14 | Lincoln | West Virginia | 54043 | 3963 | 58 |
2112251 | 2112251 | 2022-01-13 | Lincoln | West Virginia | 54043 | 3904 | 58 |
2108999 | 2108999 | 2022-01-12 | Lincoln | West Virginia | 54043 | 3839 | 58 |
2105748 | 2105748 | 2022-01-11 | Lincoln | West Virginia | 54043 | 3791 | 58 |
2102497 | 2102497 | 2022-01-10 | Lincoln | West Virginia | 54043 | 3771 | 58 |
2099246 | 2099246 | 2022-01-09 | Lincoln | West Virginia | 54043 | 3760 | 58 |
2095995 | 2095995 | 2022-01-08 | Lincoln | West Virginia | 54043 | 3736 | 58 |
2092743 | 2092743 | 2022-01-07 | Lincoln | West Virginia | 54043 | 3698 | 58 |
2089491 | 2089491 | 2022-01-06 | Lincoln | West Virginia | 54043 | 3656 | 58 |
2086240 | 2086240 | 2022-01-05 | Lincoln | West Virginia | 54043 | 3609 | 57 |
2082988 | 2082988 | 2022-01-04 | Lincoln | West Virginia | 54043 | 3590 | 57 |
2079736 | 2079736 | 2022-01-03 | Lincoln | West Virginia | 54043 | 3573 | 57 |
2076484 | 2076484 | 2022-01-02 | Lincoln | West Virginia | 54043 | 3508 | 57 |
2073233 | 2073233 | 2022-01-01 | Lincoln | West Virginia | 54043 | 3508 | 57 |
2069982 | 2069982 | 2021-12-31 | Lincoln | West Virginia | 54043 | 3508 | 57 |
2066731 | 2066731 | 2021-12-30 | Lincoln | West Virginia | 54043 | 3508 | 57 |
2063481 | 2063481 | 2021-12-29 | Lincoln | West Virginia | 54043 | 3496 | 56 |
2060231 | 2060231 | 2021-12-28 | Lincoln | West Virginia | 54043 | 3477 | 56 |
2056982 | 2056982 | 2021-12-27 | Lincoln | West Virginia | 54043 | 3468 | 55 |
2053733 | 2053733 | 2021-12-26 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2050483 | 2050483 | 2021-12-25 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2047233 | 2047233 | 2021-12-24 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2043983 | 2043983 | 2021-12-23 | Lincoln | West Virginia | 54043 | 3456 | 54 |
2040734 | 2040734 | 2021-12-22 | Lincoln | West Virginia | 54043 | 3442 | 54 |
2037484 | 2037484 | 2021-12-21 | Lincoln | West Virginia | 54043 | 3425 | 54 |
2034234 | 2034234 | 2021-12-20 | Lincoln | West Virginia | 54043 | 3413 | 54 |
2030984 | 2030984 | 2021-12-19 | Lincoln | West Virginia | 54043 | 3402 | 54 |
2027733 | 2027733 | 2021-12-18 | Lincoln | West Virginia | 54043 | 3397 | 54 |
2024482 | 2024482 | 2021-12-17 | Lincoln | West Virginia | 54043 | 3386 | 54 |
2021231 | 2021231 | 2021-12-16 | Lincoln | West Virginia | 54043 | 3368 | 54 |
2017980 | 2017980 | 2021-12-15 | Lincoln | West Virginia | 54043 | 3359 | 54 |
2014730 | 2014730 | 2021-12-14 | Lincoln | West Virginia | 54043 | 3352 | 54 |
2011479 | 2011479 | 2021-12-13 | Lincoln | West Virginia | 54043 | 3343 | 54 |
2008228 | 2008228 | 2021-12-12 | Lincoln | West Virginia | 54043 | 3338 | 54 |
2004977 | 2004977 | 2021-12-11 | Lincoln | West Virginia | 54043 | 3329 | 54 |
2001726 | 2001726 | 2021-12-10 | Lincoln | West Virginia | 54043 | 3308 | 54 |
1998476 | 1998476 | 2021-12-09 | Lincoln | West Virginia | 54043 | 3293 | 54 |
1995225 | 1995225 | 2021-12-08 | Lincoln | West Virginia | 54043 | 3286 | 54 |
1991974 | 1991974 | 2021-12-07 | Lincoln | West Virginia | 54043 | 3279 | 54 |
1988723 | 1988723 | 2021-12-06 | Lincoln | West Virginia | 54043 | 3273 | 53 |
1985473 | 1985473 | 2021-12-05 | Lincoln | West Virginia | 54043 | 3263 | 53 |
1982223 | 1982223 | 2021-12-04 | Lincoln | West Virginia | 54043 | 3259 | 53 |
1978973 | 1978973 | 2021-12-03 | Lincoln | West Virginia | 54043 | 3250 | 53 |
1975723 | 1975723 | 2021-12-02 | Lincoln | West Virginia | 54043 | 3247 | 52 |
1972474 | 1972474 | 2021-12-01 | Lincoln | West Virginia | 54043 | 3235 | 52 |
1969224 | 1969224 | 2021-11-30 | Lincoln | West Virginia | 54043 | 3223 | 51 |
1965974 | 1965974 | 2021-11-29 | Lincoln | West Virginia | 54043 | 3215 | 51 |
1962722 | 1962722 | 2021-11-28 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1959471 | 1959471 | 2021-11-27 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1956220 | 1956220 | 2021-11-26 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1952969 | 1952969 | 2021-11-25 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1949718 | 1949718 | 2021-11-24 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1946467 | 1946467 | 2021-11-23 | Lincoln | West Virginia | 54043 | 3169 | 49 |
1943216 | 1943216 | 2021-11-22 | Lincoln | West Virginia | 54043 | 3177 | 49 |
1939966 | 1939966 | 2021-11-21 | Lincoln | West Virginia | 54043 | 3174 | 49 |
1936716 | 1936716 | 2021-11-20 | Lincoln | West Virginia | 54043 | 3170 | 49 |
1933466 | 1933466 | 2021-11-19 | Lincoln | West Virginia | 54043 | 3162 | 49 |
1930214 | 1930214 | 2021-11-18 | Lincoln | West Virginia | 54043 | 3155 | 49 |
1926964 | 1926964 | 2021-11-17 | Lincoln | West Virginia | 54043 | 3143 | 49 |
1923714 | 1923714 | 2021-11-16 | Lincoln | West Virginia | 54043 | 3126 | 48 |
1920465 | 1920465 | 2021-11-15 | Lincoln | West Virginia | 54043 | 3119 | 46 |
1917215 | 1917215 | 2021-11-14 | Lincoln | West Virginia | 54043 | 3113 | 46 |
1913965 | 1913965 | 2021-11-13 | Lincoln | West Virginia | 54043 | 3103 | 46 |
1910715 | 1910715 | 2021-11-12 | Lincoln | West Virginia | 54043 | 3089 | 46 |
1907466 | 1907466 | 2021-11-11 | Lincoln | West Virginia | 54043 | 3071 | 46 |
1904217 | 1904217 | 2021-11-10 | Lincoln | West Virginia | 54043 | 3042 | 46 |
1900967 | 1900967 | 2021-11-09 | Lincoln | West Virginia | 54043 | 3030 | 45 |
1897717 | 1897717 | 2021-11-08 | Lincoln | West Virginia | 54043 | 3013 | 46 |
1894467 | 1894467 | 2021-11-07 | Lincoln | West Virginia | 54043 | 3336 | 45 |
1891217 | 1891217 | 2021-11-06 | Lincoln | West Virginia | 54043 | 2979 | 45 |
1887967 | 1887967 | 2021-11-05 | Lincoln | West Virginia | 54043 | 2965 | 45 |
1884717 | 1884717 | 2021-11-04 | Lincoln | West Virginia | 54043 | 2926 | 45 |
1881468 | 1881468 | 2021-11-03 | Lincoln | West Virginia | 54043 | 2899 | 45 |
1878219 | 1878219 | 2021-11-02 | Lincoln | West Virginia | 54043 | 2887 | 44 |
1874970 | 1874970 | 2021-11-01 | Lincoln | West Virginia | 54043 | 2874 | 44 |
1871721 | 1871721 | 2021-10-31 | Lincoln | West Virginia | 54043 | 2866 | 44 |
1868472 | 1868472 | 2021-10-30 | Lincoln | West Virginia | 54043 | 2854 | 44 |
1865223 | 1865223 | 2021-10-29 | Lincoln | West Virginia | 54043 | 2831 | 44 |
1861974 | 1861974 | 2021-10-28 | Lincoln | West Virginia | 54043 | 2812 | 44 |
1858725 | 1858725 | 2021-10-27 | Lincoln | West Virginia | 54043 | 2794 | 43 |
1855476 | 1855476 | 2021-10-26 | Lincoln | West Virginia | 54043 | 2780 | 43 |
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);