ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Lewis" and fips = 21135 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175264 | 2175264 | 2022-02-02 | Lewis | Kentucky | 21135 | 4043 | 72 |
2172011 | 2172011 | 2022-02-01 | Lewis | Kentucky | 21135 | 3998 | 72 |
2168758 | 2168758 | 2022-01-31 | Lewis | Kentucky | 21135 | 3957 | 72 |
2165503 | 2165503 | 2022-01-30 | Lewis | Kentucky | 21135 | 3907 | 72 |
2162248 | 2162248 | 2022-01-29 | Lewis | Kentucky | 21135 | 3907 | 72 |
2158993 | 2158993 | 2022-01-28 | Lewis | Kentucky | 21135 | 3907 | 72 |
2155739 | 2155739 | 2022-01-27 | Lewis | Kentucky | 21135 | 3845 | 72 |
2152486 | 2152486 | 2022-01-26 | Lewis | Kentucky | 21135 | 3781 | 72 |
2149234 | 2149234 | 2022-01-25 | Lewis | Kentucky | 21135 | 3706 | 72 |
2145982 | 2145982 | 2022-01-24 | Lewis | Kentucky | 21135 | 3677 | 72 |
2142727 | 2142727 | 2022-01-23 | Lewis | Kentucky | 21135 | 3596 | 71 |
2139472 | 2139472 | 2022-01-22 | Lewis | Kentucky | 21135 | 3596 | 71 |
2136216 | 2136216 | 2022-01-21 | Lewis | Kentucky | 21135 | 3596 | 71 |
2132964 | 2132964 | 2022-01-20 | Lewis | Kentucky | 21135 | 3551 | 71 |
2129711 | 2129711 | 2022-01-19 | Lewis | Kentucky | 21135 | 3503 | 71 |
2126457 | 2126457 | 2022-01-18 | Lewis | Kentucky | 21135 | 3465 | 71 |
2123205 | 2123205 | 2022-01-17 | Lewis | Kentucky | 21135 | 3391 | 71 |
2119953 | 2119953 | 2022-01-16 | Lewis | Kentucky | 21135 | 3391 | 71 |
2116701 | 2116701 | 2022-01-15 | Lewis | Kentucky | 21135 | 3391 | 71 |
2113450 | 2113450 | 2022-01-14 | Lewis | Kentucky | 21135 | 3391 | 71 |
2110198 | 2110198 | 2022-01-13 | Lewis | Kentucky | 21135 | 3358 | 71 |
2106947 | 2106947 | 2022-01-12 | Lewis | Kentucky | 21135 | 3336 | 71 |
2103696 | 2103696 | 2022-01-11 | Lewis | Kentucky | 21135 | 3297 | 71 |
2100445 | 2100445 | 2022-01-10 | Lewis | Kentucky | 21135 | 3270 | 71 |
2097194 | 2097194 | 2022-01-09 | Lewis | Kentucky | 21135 | 3247 | 70 |
2093942 | 2093942 | 2022-01-08 | Lewis | Kentucky | 21135 | 3247 | 70 |
2090690 | 2090690 | 2022-01-07 | Lewis | Kentucky | 21135 | 3247 | 70 |
2087439 | 2087439 | 2022-01-06 | Lewis | Kentucky | 21135 | 3223 | 70 |
2084187 | 2084187 | 2022-01-05 | Lewis | Kentucky | 21135 | 3196 | 69 |
2080935 | 2080935 | 2022-01-04 | Lewis | Kentucky | 21135 | 3177 | 69 |
2077683 | 2077683 | 2022-01-03 | Lewis | Kentucky | 21135 | 3164 | 69 |
2074432 | 2074432 | 2022-01-02 | Lewis | Kentucky | 21135 | 3111 | 68 |
2071181 | 2071181 | 2022-01-01 | Lewis | Kentucky | 21135 | 3111 | 68 |
2067930 | 2067930 | 2021-12-31 | Lewis | Kentucky | 21135 | 3111 | 68 |
2064679 | 2064679 | 2021-12-30 | Lewis | Kentucky | 21135 | 3111 | 68 |
2061429 | 2061429 | 2021-12-29 | Lewis | Kentucky | 21135 | 3111 | 68 |
2058180 | 2058180 | 2021-12-28 | Lewis | Kentucky | 21135 | 3074 | 68 |
2054931 | 2054931 | 2021-12-27 | Lewis | Kentucky | 21135 | 3064 | 67 |
2051681 | 2051681 | 2021-12-26 | Lewis | Kentucky | 21135 | 3033 | 66 |
2048431 | 2048431 | 2021-12-25 | Lewis | Kentucky | 21135 | 3033 | 66 |
2045181 | 2045181 | 2021-12-24 | Lewis | Kentucky | 21135 | 3033 | 66 |
2041932 | 2041932 | 2021-12-23 | Lewis | Kentucky | 21135 | 3033 | 66 |
2038682 | 2038682 | 2021-12-22 | Lewis | Kentucky | 21135 | 3033 | 66 |
2035432 | 2035432 | 2021-12-21 | Lewis | Kentucky | 21135 | 3015 | 66 |
2032182 | 2032182 | 2021-12-20 | Lewis | Kentucky | 21135 | 3001 | 65 |
2028931 | 2028931 | 2021-12-19 | Lewis | Kentucky | 21135 | 2979 | 65 |
2025680 | 2025680 | 2021-12-18 | Lewis | Kentucky | 21135 | 2979 | 65 |
2022429 | 2022429 | 2021-12-17 | Lewis | Kentucky | 21135 | 2979 | 65 |
2019178 | 2019178 | 2021-12-16 | Lewis | Kentucky | 21135 | 2955 | 64 |
2015928 | 2015928 | 2021-12-15 | Lewis | Kentucky | 21135 | 2938 | 64 |
2012677 | 2012677 | 2021-12-14 | Lewis | Kentucky | 21135 | 2913 | 64 |
2009426 | 2009426 | 2021-12-13 | Lewis | Kentucky | 21135 | 2896 | 64 |
2006175 | 2006175 | 2021-12-12 | Lewis | Kentucky | 21135 | 2869 | 64 |
2002924 | 2002924 | 2021-12-11 | Lewis | Kentucky | 21135 | 2869 | 64 |
1999674 | 1999674 | 2021-12-10 | Lewis | Kentucky | 21135 | 2869 | 64 |
1996423 | 1996423 | 2021-12-09 | Lewis | Kentucky | 21135 | 2853 | 63 |
1993172 | 1993172 | 2021-12-08 | Lewis | Kentucky | 21135 | 2835 | 62 |
1989921 | 1989921 | 2021-12-07 | Lewis | Kentucky | 21135 | 2819 | 61 |
1986671 | 1986671 | 2021-12-06 | Lewis | Kentucky | 21135 | 2800 | 61 |
1983421 | 1983421 | 2021-12-05 | Lewis | Kentucky | 21135 | 2771 | 60 |
1980171 | 1980171 | 2021-12-04 | Lewis | Kentucky | 21135 | 2771 | 60 |
1976921 | 1976921 | 2021-12-03 | Lewis | Kentucky | 21135 | 2771 | 60 |
1973672 | 1973672 | 2021-12-02 | Lewis | Kentucky | 21135 | 2758 | 60 |
1970422 | 1970422 | 2021-12-01 | Lewis | Kentucky | 21135 | 2742 | 60 |
1967172 | 1967172 | 2021-11-30 | Lewis | Kentucky | 21135 | 2714 | 60 |
1963920 | 1963920 | 2021-11-29 | Lewis | Kentucky | 21135 | 2713 | 60 |
1960669 | 1960669 | 2021-11-28 | Lewis | Kentucky | 21135 | 2697 | 60 |
1957418 | 1957418 | 2021-11-27 | Lewis | Kentucky | 21135 | 2697 | 60 |
1954167 | 1954167 | 2021-11-26 | Lewis | Kentucky | 21135 | 2697 | 60 |
1950916 | 1950916 | 2021-11-25 | Lewis | Kentucky | 21135 | 2697 | 60 |
1947665 | 1947665 | 2021-11-24 | Lewis | Kentucky | 21135 | 2697 | 60 |
1944414 | 1944414 | 2021-11-23 | Lewis | Kentucky | 21135 | 2689 | 60 |
1941164 | 1941164 | 2021-11-22 | Lewis | Kentucky | 21135 | 2682 | 60 |
1937914 | 1937914 | 2021-11-21 | Lewis | Kentucky | 21135 | 2671 | 60 |
1934664 | 1934664 | 2021-11-20 | Lewis | Kentucky | 21135 | 2671 | 60 |
1931413 | 1931413 | 2021-11-19 | Lewis | Kentucky | 21135 | 2671 | 60 |
1928162 | 1928162 | 2021-11-18 | Lewis | Kentucky | 21135 | 2672 | 58 |
1924912 | 1924912 | 2021-11-17 | Lewis | Kentucky | 21135 | 2663 | 58 |
1921663 | 1921663 | 2021-11-16 | Lewis | Kentucky | 21135 | 2650 | 58 |
1918413 | 1918413 | 2021-11-15 | Lewis | Kentucky | 21135 | 2634 | 58 |
1915163 | 1915163 | 2021-11-14 | Lewis | Kentucky | 21135 | 2626 | 58 |
1911913 | 1911913 | 2021-11-13 | Lewis | Kentucky | 21135 | 2626 | 58 |
1908664 | 1908664 | 2021-11-12 | Lewis | Kentucky | 21135 | 2626 | 58 |
1905415 | 1905415 | 2021-11-11 | Lewis | Kentucky | 21135 | 2615 | 58 |
1902165 | 1902165 | 2021-11-10 | Lewis | Kentucky | 21135 | 2615 | 58 |
1898915 | 1898915 | 2021-11-09 | Lewis | Kentucky | 21135 | 2609 | 58 |
1895665 | 1895665 | 2021-11-08 | Lewis | Kentucky | 21135 | 2607 | 58 |
1892415 | 1892415 | 2021-11-07 | Lewis | Kentucky | 21135 | 2606 | 57 |
1889165 | 1889165 | 2021-11-06 | Lewis | Kentucky | 21135 | 2606 | 57 |
1885915 | 1885915 | 2021-11-05 | Lewis | Kentucky | 21135 | 2606 | 57 |
1882666 | 1882666 | 2021-11-04 | Lewis | Kentucky | 21135 | 2597 | 57 |
1879417 | 1879417 | 2021-11-03 | Lewis | Kentucky | 21135 | 2591 | 57 |
1876168 | 1876168 | 2021-11-02 | Lewis | Kentucky | 21135 | 2585 | 57 |
1872919 | 1872919 | 2021-11-01 | Lewis | Kentucky | 21135 | 2582 | 57 |
1869670 | 1869670 | 2021-10-31 | Lewis | Kentucky | 21135 | 2573 | 57 |
1866421 | 1866421 | 2021-10-30 | Lewis | Kentucky | 21135 | 2573 | 57 |
1863172 | 1863172 | 2021-10-29 | Lewis | Kentucky | 21135 | 2573 | 57 |
1859923 | 1859923 | 2021-10-28 | Lewis | Kentucky | 21135 | 2559 | 56 |
1856674 | 1856674 | 2021-10-27 | Lewis | Kentucky | 21135 | 2550 | 56 |
1853425 | 1853425 | 2021-10-26 | Lewis | Kentucky | 21135 | 2545 | 56 |
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);