ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Morgan" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175284 | 2175284 | 2022-02-02 | Morgan | Kentucky | 21175 | 4012 | 17 |
2172031 | 2172031 | 2022-02-01 | Morgan | Kentucky | 21175 | 3996 | 17 |
2168778 | 2168778 | 2022-01-31 | Morgan | Kentucky | 21175 | 3974 | 17 |
2165523 | 2165523 | 2022-01-30 | Morgan | Kentucky | 21175 | 3931 | 17 |
2162268 | 2162268 | 2022-01-29 | Morgan | Kentucky | 21175 | 3931 | 17 |
2159013 | 2159013 | 2022-01-28 | Morgan | Kentucky | 21175 | 3931 | 17 |
2155759 | 2155759 | 2022-01-27 | Morgan | Kentucky | 21175 | 3875 | 17 |
2152506 | 2152506 | 2022-01-26 | Morgan | Kentucky | 21175 | 3740 | 17 |
2149254 | 2149254 | 2022-01-25 | Morgan | Kentucky | 21175 | 3724 | 17 |
2146002 | 2146002 | 2022-01-24 | Morgan | Kentucky | 21175 | 3700 | 17 |
2142747 | 2142747 | 2022-01-23 | Morgan | Kentucky | 21175 | 3513 | 17 |
2139492 | 2139492 | 2022-01-22 | Morgan | Kentucky | 21175 | 3513 | 17 |
2136236 | 2136236 | 2022-01-21 | Morgan | Kentucky | 21175 | 3513 | 17 |
2132984 | 2132984 | 2022-01-20 | Morgan | Kentucky | 21175 | 3499 | 17 |
2129731 | 2129731 | 2022-01-19 | Morgan | Kentucky | 21175 | 3453 | 17 |
2126477 | 2126477 | 2022-01-18 | Morgan | Kentucky | 21175 | 3383 | 17 |
2123225 | 2123225 | 2022-01-17 | Morgan | Kentucky | 21175 | 3314 | 17 |
2119973 | 2119973 | 2022-01-16 | Morgan | Kentucky | 21175 | 3314 | 17 |
2116721 | 2116721 | 2022-01-15 | Morgan | Kentucky | 21175 | 3314 | 17 |
2113470 | 2113470 | 2022-01-14 | Morgan | Kentucky | 21175 | 3314 | 17 |
2110218 | 2110218 | 2022-01-13 | Morgan | Kentucky | 21175 | 3285 | 17 |
2106967 | 2106967 | 2022-01-12 | Morgan | Kentucky | 21175 | 3276 | 17 |
2103716 | 2103716 | 2022-01-11 | Morgan | Kentucky | 21175 | 3265 | 17 |
2100465 | 2100465 | 2022-01-10 | Morgan | Kentucky | 21175 | 3254 | 17 |
2097214 | 2097214 | 2022-01-09 | Morgan | Kentucky | 21175 | 3247 | 17 |
2093962 | 2093962 | 2022-01-08 | Morgan | Kentucky | 21175 | 3247 | 17 |
2090710 | 2090710 | 2022-01-07 | Morgan | Kentucky | 21175 | 3247 | 17 |
2087459 | 2087459 | 2022-01-06 | Morgan | Kentucky | 21175 | 3240 | 17 |
2084207 | 2084207 | 2022-01-05 | Morgan | Kentucky | 21175 | 3226 | 17 |
2080955 | 2080955 | 2022-01-04 | Morgan | Kentucky | 21175 | 3221 | 17 |
2077703 | 2077703 | 2022-01-03 | Morgan | Kentucky | 21175 | 3212 | 17 |
2074452 | 2074452 | 2022-01-02 | Morgan | Kentucky | 21175 | 3196 | 17 |
2071201 | 2071201 | 2022-01-01 | Morgan | Kentucky | 21175 | 3196 | 17 |
2067950 | 2067950 | 2021-12-31 | Morgan | Kentucky | 21175 | 3196 | 17 |
2064699 | 2064699 | 2021-12-30 | Morgan | Kentucky | 21175 | 3196 | 17 |
2061449 | 2061449 | 2021-12-29 | Morgan | Kentucky | 21175 | 3196 | 17 |
2058200 | 2058200 | 2021-12-28 | Morgan | Kentucky | 21175 | 3191 | 17 |
2054951 | 2054951 | 2021-12-27 | Morgan | Kentucky | 21175 | 3189 | 17 |
2051701 | 2051701 | 2021-12-26 | Morgan | Kentucky | 21175 | 3181 | 17 |
2048451 | 2048451 | 2021-12-25 | Morgan | Kentucky | 21175 | 3181 | 17 |
2045201 | 2045201 | 2021-12-24 | Morgan | Kentucky | 21175 | 3181 | 17 |
2041952 | 2041952 | 2021-12-23 | Morgan | Kentucky | 21175 | 3181 | 17 |
2038702 | 2038702 | 2021-12-22 | Morgan | Kentucky | 21175 | 3181 | 17 |
2035452 | 2035452 | 2021-12-21 | Morgan | Kentucky | 21175 | 3177 | 17 |
2032202 | 2032202 | 2021-12-20 | Morgan | Kentucky | 21175 | 3169 | 17 |
2028951 | 2028951 | 2021-12-19 | Morgan | Kentucky | 21175 | 3131 | 17 |
2025700 | 2025700 | 2021-12-18 | Morgan | Kentucky | 21175 | 3131 | 17 |
2022449 | 2022449 | 2021-12-17 | Morgan | Kentucky | 21175 | 3131 | 17 |
2019198 | 2019198 | 2021-12-16 | Morgan | Kentucky | 21175 | 3121 | 16 |
2015948 | 2015948 | 2021-12-15 | Morgan | Kentucky | 21175 | 3104 | 16 |
2012697 | 2012697 | 2021-12-14 | Morgan | Kentucky | 21175 | 3101 | 16 |
2009446 | 2009446 | 2021-12-13 | Morgan | Kentucky | 21175 | 3095 | 16 |
2006195 | 2006195 | 2021-12-12 | Morgan | Kentucky | 21175 | 3086 | 16 |
2002944 | 2002944 | 2021-12-11 | Morgan | Kentucky | 21175 | 3086 | 16 |
1999694 | 1999694 | 2021-12-10 | Morgan | Kentucky | 21175 | 3086 | 16 |
1996443 | 1996443 | 2021-12-09 | Morgan | Kentucky | 21175 | 3073 | 16 |
1993192 | 1993192 | 2021-12-08 | Morgan | Kentucky | 21175 | 3067 | 16 |
1989941 | 1989941 | 2021-12-07 | Morgan | Kentucky | 21175 | 3057 | 16 |
1986691 | 1986691 | 2021-12-06 | Morgan | Kentucky | 21175 | 3051 | 16 |
1983441 | 1983441 | 2021-12-05 | Morgan | Kentucky | 21175 | 3040 | 12 |
1980191 | 1980191 | 2021-12-04 | Morgan | Kentucky | 21175 | 3040 | 12 |
1976941 | 1976941 | 2021-12-03 | Morgan | Kentucky | 21175 | 3040 | 12 |
1973692 | 1973692 | 2021-12-02 | Morgan | Kentucky | 21175 | 3011 | 11 |
1970442 | 1970442 | 2021-12-01 | Morgan | Kentucky | 21175 | 3009 | 11 |
1967192 | 1967192 | 2021-11-30 | Morgan | Kentucky | 21175 | 3004 | 11 |
1963940 | 1963940 | 2021-11-29 | Morgan | Kentucky | 21175 | 2993 | 11 |
1960689 | 1960689 | 2021-11-28 | Morgan | Kentucky | 21175 | 2987 | 11 |
1957438 | 1957438 | 2021-11-27 | Morgan | Kentucky | 21175 | 2987 | 11 |
1954187 | 1954187 | 2021-11-26 | Morgan | Kentucky | 21175 | 2987 | 11 |
1950936 | 1950936 | 2021-11-25 | Morgan | Kentucky | 21175 | 2987 | 11 |
1947685 | 1947685 | 2021-11-24 | Morgan | Kentucky | 21175 | 2987 | 11 |
1944434 | 1944434 | 2021-11-23 | Morgan | Kentucky | 21175 | 2983 | 11 |
1941184 | 1941184 | 2021-11-22 | Morgan | Kentucky | 21175 | 2976 | 11 |
1937934 | 1937934 | 2021-11-21 | Morgan | Kentucky | 21175 | 2954 | 11 |
1934684 | 1934684 | 2021-11-20 | Morgan | Kentucky | 21175 | 2954 | 11 |
1931433 | 1931433 | 2021-11-19 | Morgan | Kentucky | 21175 | 2954 | 11 |
1928182 | 1928182 | 2021-11-18 | Morgan | Kentucky | 21175 | 2965 | 10 |
1924932 | 1924932 | 2021-11-17 | Morgan | Kentucky | 21175 | 2956 | 10 |
1921683 | 1921683 | 2021-11-16 | Morgan | Kentucky | 21175 | 2944 | 10 |
1918433 | 1918433 | 2021-11-15 | Morgan | Kentucky | 21175 | 2941 | 10 |
1915183 | 1915183 | 2021-11-14 | Morgan | Kentucky | 21175 | 2927 | 10 |
1911933 | 1911933 | 2021-11-13 | Morgan | Kentucky | 21175 | 2927 | 10 |
1908684 | 1908684 | 2021-11-12 | Morgan | Kentucky | 21175 | 2927 | 10 |
1905435 | 1905435 | 2021-11-11 | Morgan | Kentucky | 21175 | 2925 | 10 |
1902185 | 1902185 | 2021-11-10 | Morgan | Kentucky | 21175 | 2925 | 10 |
1898935 | 1898935 | 2021-11-09 | Morgan | Kentucky | 21175 | 2917 | 10 |
1895685 | 1895685 | 2021-11-08 | Morgan | Kentucky | 21175 | 2916 | 10 |
1892435 | 1892435 | 2021-11-07 | Morgan | Kentucky | 21175 | 2914 | 10 |
1889185 | 1889185 | 2021-11-06 | Morgan | Kentucky | 21175 | 2914 | 10 |
1885935 | 1885935 | 2021-11-05 | Morgan | Kentucky | 21175 | 2914 | 10 |
1882686 | 1882686 | 2021-11-04 | Morgan | Kentucky | 21175 | 2913 | 10 |
1879437 | 1879437 | 2021-11-03 | Morgan | Kentucky | 21175 | 2908 | 10 |
1876188 | 1876188 | 2021-11-02 | Morgan | Kentucky | 21175 | 2897 | 10 |
1872939 | 1872939 | 2021-11-01 | Morgan | Kentucky | 21175 | 2892 | 9 |
1869690 | 1869690 | 2021-10-31 | Morgan | Kentucky | 21175 | 2883 | 9 |
1866441 | 1866441 | 2021-10-30 | Morgan | Kentucky | 21175 | 2883 | 9 |
1863192 | 1863192 | 2021-10-29 | Morgan | Kentucky | 21175 | 2883 | 9 |
1859943 | 1859943 | 2021-10-28 | Morgan | Kentucky | 21175 | 2873 | 9 |
1856694 | 1856694 | 2021-10-27 | Morgan | Kentucky | 21175 | 2865 | 9 |
1853445 | 1853445 | 2021-10-26 | Morgan | Kentucky | 21175 | 2853 | 9 |
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);