ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Franklin" and fips = 21073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175233 | 2175233 | 2022-02-02 | Franklin | Kentucky | 21073 | 12040 | 123 |
2171980 | 2171980 | 2022-02-01 | Franklin | Kentucky | 21073 | 11961 | 122 |
2168727 | 2168727 | 2022-01-31 | Franklin | Kentucky | 21073 | 11816 | 122 |
2165472 | 2165472 | 2022-01-30 | Franklin | Kentucky | 21073 | 11617 | 122 |
2162217 | 2162217 | 2022-01-29 | Franklin | Kentucky | 21073 | 11617 | 122 |
2158962 | 2158962 | 2022-01-28 | Franklin | Kentucky | 21073 | 11617 | 122 |
2155708 | 2155708 | 2022-01-27 | Franklin | Kentucky | 21073 | 11423 | 122 |
2152455 | 2152455 | 2022-01-26 | Franklin | Kentucky | 21073 | 11322 | 122 |
2149203 | 2149203 | 2022-01-25 | Franklin | Kentucky | 21073 | 11164 | 121 |
2145951 | 2145951 | 2022-01-24 | Franklin | Kentucky | 21073 | 11028 | 121 |
2142696 | 2142696 | 2022-01-23 | Franklin | Kentucky | 21073 | 10730 | 121 |
2139441 | 2139441 | 2022-01-22 | Franklin | Kentucky | 21073 | 10730 | 121 |
2136185 | 2136185 | 2022-01-21 | Franklin | Kentucky | 21073 | 10730 | 121 |
2132933 | 2132933 | 2022-01-20 | Franklin | Kentucky | 21073 | 10525 | 121 |
2129680 | 2129680 | 2022-01-19 | Franklin | Kentucky | 21073 | 10360 | 120 |
2126426 | 2126426 | 2022-01-18 | Franklin | Kentucky | 21073 | 10224 | 120 |
2123174 | 2123174 | 2022-01-17 | Franklin | Kentucky | 21073 | 9761 | 119 |
2119922 | 2119922 | 2022-01-16 | Franklin | Kentucky | 21073 | 9761 | 119 |
2116670 | 2116670 | 2022-01-15 | Franklin | Kentucky | 21073 | 9761 | 119 |
2113419 | 2113419 | 2022-01-14 | Franklin | Kentucky | 21073 | 9761 | 119 |
2110167 | 2110167 | 2022-01-13 | Franklin | Kentucky | 21073 | 9636 | 119 |
2106916 | 2106916 | 2022-01-12 | Franklin | Kentucky | 21073 | 9545 | 119 |
2103665 | 2103665 | 2022-01-11 | Franklin | Kentucky | 21073 | 9372 | 119 |
2100414 | 2100414 | 2022-01-10 | Franklin | Kentucky | 21073 | 9226 | 119 |
2097163 | 2097163 | 2022-01-09 | Franklin | Kentucky | 21073 | 9040 | 117 |
2093911 | 2093911 | 2022-01-08 | Franklin | Kentucky | 21073 | 9040 | 117 |
2090659 | 2090659 | 2022-01-07 | Franklin | Kentucky | 21073 | 9040 | 117 |
2087408 | 2087408 | 2022-01-06 | Franklin | Kentucky | 21073 | 8949 | 116 |
2084156 | 2084156 | 2022-01-05 | Franklin | Kentucky | 21073 | 8805 | 116 |
2080904 | 2080904 | 2022-01-04 | Franklin | Kentucky | 21073 | 8706 | 116 |
2077652 | 2077652 | 2022-01-03 | Franklin | Kentucky | 21073 | 8653 | 115 |
2074401 | 2074401 | 2022-01-02 | Franklin | Kentucky | 21073 | 8397 | 114 |
2071150 | 2071150 | 2022-01-01 | Franklin | Kentucky | 21073 | 8397 | 114 |
2067899 | 2067899 | 2021-12-31 | Franklin | Kentucky | 21073 | 8397 | 114 |
2064648 | 2064648 | 2021-12-30 | Franklin | Kentucky | 21073 | 8397 | 114 |
2061398 | 2061398 | 2021-12-29 | Franklin | Kentucky | 21073 | 8397 | 114 |
2058149 | 2058149 | 2021-12-28 | Franklin | Kentucky | 21073 | 8360 | 114 |
2054900 | 2054900 | 2021-12-27 | Franklin | Kentucky | 21073 | 8338 | 113 |
2051650 | 2051650 | 2021-12-26 | Franklin | Kentucky | 21073 | 8205 | 111 |
2048400 | 2048400 | 2021-12-25 | Franklin | Kentucky | 21073 | 8205 | 111 |
2045150 | 2045150 | 2021-12-24 | Franklin | Kentucky | 21073 | 8205 | 111 |
2041901 | 2041901 | 2021-12-23 | Franklin | Kentucky | 21073 | 8205 | 111 |
2038651 | 2038651 | 2021-12-22 | Franklin | Kentucky | 21073 | 8205 | 111 |
2035401 | 2035401 | 2021-12-21 | Franklin | Kentucky | 21073 | 8174 | 110 |
2032151 | 2032151 | 2021-12-20 | Franklin | Kentucky | 21073 | 8154 | 111 |
2028900 | 2028900 | 2021-12-19 | Franklin | Kentucky | 21073 | 8072 | 108 |
2025649 | 2025649 | 2021-12-18 | Franklin | Kentucky | 21073 | 8072 | 108 |
2022398 | 2022398 | 2021-12-17 | Franklin | Kentucky | 21073 | 8072 | 108 |
2019147 | 2019147 | 2021-12-16 | Franklin | Kentucky | 21073 | 8045 | 108 |
2015897 | 2015897 | 2021-12-15 | Franklin | Kentucky | 21073 | 8019 | 108 |
2012646 | 2012646 | 2021-12-14 | Franklin | Kentucky | 21073 | 7988 | 108 |
2009395 | 2009395 | 2021-12-13 | Franklin | Kentucky | 21073 | 7962 | 108 |
2006144 | 2006144 | 2021-12-12 | Franklin | Kentucky | 21073 | 7877 | 106 |
2002893 | 2002893 | 2021-12-11 | Franklin | Kentucky | 21073 | 7877 | 106 |
1999643 | 1999643 | 2021-12-10 | Franklin | Kentucky | 21073 | 7877 | 106 |
1996392 | 1996392 | 2021-12-09 | Franklin | Kentucky | 21073 | 7838 | 105 |
1993141 | 1993141 | 2021-12-08 | Franklin | Kentucky | 21073 | 7795 | 105 |
1989890 | 1989890 | 2021-12-07 | Franklin | Kentucky | 21073 | 7773 | 105 |
1986640 | 1986640 | 2021-12-06 | Franklin | Kentucky | 21073 | 7732 | 104 |
1983390 | 1983390 | 2021-12-05 | Franklin | Kentucky | 21073 | 7683 | 101 |
1980140 | 1980140 | 2021-12-04 | Franklin | Kentucky | 21073 | 7683 | 101 |
1976890 | 1976890 | 2021-12-03 | Franklin | Kentucky | 21073 | 7683 | 101 |
1973641 | 1973641 | 2021-12-02 | Franklin | Kentucky | 21073 | 7647 | 100 |
1970391 | 1970391 | 2021-12-01 | Franklin | Kentucky | 21073 | 7620 | 100 |
1967141 | 1967141 | 2021-11-30 | Franklin | Kentucky | 21073 | 7578 | 99 |
1963889 | 1963889 | 2021-11-29 | Franklin | Kentucky | 21073 | 7561 | 97 |
1960638 | 1960638 | 2021-11-28 | Franklin | Kentucky | 21073 | 7500 | 97 |
1957387 | 1957387 | 2021-11-27 | Franklin | Kentucky | 21073 | 7500 | 97 |
1954136 | 1954136 | 2021-11-26 | Franklin | Kentucky | 21073 | 7500 | 97 |
1950885 | 1950885 | 2021-11-25 | Franklin | Kentucky | 21073 | 7500 | 97 |
1947634 | 1947634 | 2021-11-24 | Franklin | Kentucky | 21073 | 7500 | 97 |
1944383 | 1944383 | 2021-11-23 | Franklin | Kentucky | 21073 | 7484 | 95 |
1941133 | 1941133 | 2021-11-22 | Franklin | Kentucky | 21073 | 7461 | 95 |
1937883 | 1937883 | 2021-11-21 | Franklin | Kentucky | 21073 | 7420 | 90 |
1934633 | 1934633 | 2021-11-20 | Franklin | Kentucky | 21073 | 7420 | 90 |
1931382 | 1931382 | 2021-11-19 | Franklin | Kentucky | 21073 | 7420 | 90 |
1928131 | 1928131 | 2021-11-18 | Franklin | Kentucky | 21073 | 7400 | 87 |
1924881 | 1924881 | 2021-11-17 | Franklin | Kentucky | 21073 | 7379 | 87 |
1921632 | 1921632 | 2021-11-16 | Franklin | Kentucky | 21073 | 7358 | 84 |
1918382 | 1918382 | 2021-11-15 | Franklin | Kentucky | 21073 | 7337 | 84 |
1915132 | 1915132 | 2021-11-14 | Franklin | Kentucky | 21073 | 7287 | 82 |
1911882 | 1911882 | 2021-11-13 | Franklin | Kentucky | 21073 | 7287 | 82 |
1908633 | 1908633 | 2021-11-12 | Franklin | Kentucky | 21073 | 7287 | 82 |
1905384 | 1905384 | 2021-11-11 | Franklin | Kentucky | 21073 | 7254 | 81 |
1902134 | 1902134 | 2021-11-10 | Franklin | Kentucky | 21073 | 7254 | 81 |
1898884 | 1898884 | 2021-11-09 | Franklin | Kentucky | 21073 | 7230 | 81 |
1895634 | 1895634 | 2021-11-08 | Franklin | Kentucky | 21073 | 7204 | 80 |
1892384 | 1892384 | 2021-11-07 | Franklin | Kentucky | 21073 | 7161 | 80 |
1889134 | 1889134 | 2021-11-06 | Franklin | Kentucky | 21073 | 7161 | 80 |
1885884 | 1885884 | 2021-11-05 | Franklin | Kentucky | 21073 | 7161 | 80 |
1882635 | 1882635 | 2021-11-04 | Franklin | Kentucky | 21073 | 7146 | 80 |
1879386 | 1879386 | 2021-11-03 | Franklin | Kentucky | 21073 | 7136 | 80 |
1876137 | 1876137 | 2021-11-02 | Franklin | Kentucky | 21073 | 7100 | 80 |
1872888 | 1872888 | 2021-11-01 | Franklin | Kentucky | 21073 | 7079 | 79 |
1869639 | 1869639 | 2021-10-31 | Franklin | Kentucky | 21073 | 7032 | 78 |
1866390 | 1866390 | 2021-10-30 | Franklin | Kentucky | 21073 | 7032 | 78 |
1863141 | 1863141 | 2021-10-29 | Franklin | Kentucky | 21073 | 7032 | 78 |
1859892 | 1859892 | 2021-10-28 | Franklin | Kentucky | 21073 | 7009 | 78 |
1856643 | 1856643 | 2021-10-27 | Franklin | Kentucky | 21073 | 6984 | 78 |
1853394 | 1853394 | 2021-10-26 | Franklin | Kentucky | 21073 | 6968 | 78 |
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);