ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Christian" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175220 | 2175220 | 2022-02-02 | Christian | Kentucky | 21047 | 13966 | 183 |
2171967 | 2171967 | 2022-02-01 | Christian | Kentucky | 21047 | 13833 | 183 |
2168714 | 2168714 | 2022-01-31 | Christian | Kentucky | 21047 | 13755 | 183 |
2165459 | 2165459 | 2022-01-30 | Christian | Kentucky | 21047 | 13601 | 182 |
2162204 | 2162204 | 2022-01-29 | Christian | Kentucky | 21047 | 13601 | 182 |
2158949 | 2158949 | 2022-01-28 | Christian | Kentucky | 21047 | 13601 | 182 |
2155695 | 2155695 | 2022-01-27 | Christian | Kentucky | 21047 | 13418 | 182 |
2152442 | 2152442 | 2022-01-26 | Christian | Kentucky | 21047 | 13255 | 182 |
2149190 | 2149190 | 2022-01-25 | Christian | Kentucky | 21047 | 13160 | 182 |
2145938 | 2145938 | 2022-01-24 | Christian | Kentucky | 21047 | 13061 | 182 |
2142683 | 2142683 | 2022-01-23 | Christian | Kentucky | 21047 | 12811 | 180 |
2139428 | 2139428 | 2022-01-22 | Christian | Kentucky | 21047 | 12811 | 180 |
2136172 | 2136172 | 2022-01-21 | Christian | Kentucky | 21047 | 12811 | 180 |
2132920 | 2132920 | 2022-01-20 | Christian | Kentucky | 21047 | 12690 | 179 |
2129667 | 2129667 | 2022-01-19 | Christian | Kentucky | 21047 | 12602 | 179 |
2126413 | 2126413 | 2022-01-18 | Christian | Kentucky | 21047 | 12503 | 179 |
2123161 | 2123161 | 2022-01-17 | Christian | Kentucky | 21047 | 12245 | 179 |
2119909 | 2119909 | 2022-01-16 | Christian | Kentucky | 21047 | 12245 | 179 |
2116657 | 2116657 | 2022-01-15 | Christian | Kentucky | 21047 | 12245 | 179 |
2113406 | 2113406 | 2022-01-14 | Christian | Kentucky | 21047 | 12245 | 179 |
2110154 | 2110154 | 2022-01-13 | Christian | Kentucky | 21047 | 12075 | 177 |
2106903 | 2106903 | 2022-01-12 | Christian | Kentucky | 21047 | 11969 | 177 |
2103652 | 2103652 | 2022-01-11 | Christian | Kentucky | 21047 | 11890 | 176 |
2100401 | 2100401 | 2022-01-10 | Christian | Kentucky | 21047 | 11834 | 176 |
2097150 | 2097150 | 2022-01-09 | Christian | Kentucky | 21047 | 11694 | 175 |
2093898 | 2093898 | 2022-01-08 | Christian | Kentucky | 21047 | 11694 | 175 |
2090646 | 2090646 | 2022-01-07 | Christian | Kentucky | 21047 | 11694 | 175 |
2087395 | 2087395 | 2022-01-06 | Christian | Kentucky | 21047 | 11581 | 175 |
2084143 | 2084143 | 2022-01-05 | Christian | Kentucky | 21047 | 11480 | 175 |
2080891 | 2080891 | 2022-01-04 | Christian | Kentucky | 21047 | 11378 | 175 |
2077639 | 2077639 | 2022-01-03 | Christian | Kentucky | 21047 | 11365 | 175 |
2074388 | 2074388 | 2022-01-02 | Christian | Kentucky | 21047 | 11261 | 174 |
2071137 | 2071137 | 2022-01-01 | Christian | Kentucky | 21047 | 11261 | 174 |
2067886 | 2067886 | 2021-12-31 | Christian | Kentucky | 21047 | 11261 | 174 |
2064635 | 2064635 | 2021-12-30 | Christian | Kentucky | 21047 | 11261 | 174 |
2061385 | 2061385 | 2021-12-29 | Christian | Kentucky | 21047 | 11261 | 174 |
2058136 | 2058136 | 2021-12-28 | Christian | Kentucky | 21047 | 11212 | 174 |
2054887 | 2054887 | 2021-12-27 | Christian | Kentucky | 21047 | 11179 | 174 |
2051637 | 2051637 | 2021-12-26 | Christian | Kentucky | 21047 | 11143 | 174 |
2048387 | 2048387 | 2021-12-25 | Christian | Kentucky | 21047 | 11143 | 174 |
2045137 | 2045137 | 2021-12-24 | Christian | Kentucky | 21047 | 11143 | 174 |
2041888 | 2041888 | 2021-12-23 | Christian | Kentucky | 21047 | 11143 | 174 |
2038638 | 2038638 | 2021-12-22 | Christian | Kentucky | 21047 | 11143 | 174 |
2035388 | 2035388 | 2021-12-21 | Christian | Kentucky | 21047 | 11099 | 173 |
2032138 | 2032138 | 2021-12-20 | Christian | Kentucky | 21047 | 11071 | 172 |
2028887 | 2028887 | 2021-12-19 | Christian | Kentucky | 21047 | 11048 | 170 |
2025636 | 2025636 | 2021-12-18 | Christian | Kentucky | 21047 | 11048 | 170 |
2022385 | 2022385 | 2021-12-17 | Christian | Kentucky | 21047 | 11048 | 170 |
2019134 | 2019134 | 2021-12-16 | Christian | Kentucky | 21047 | 11002 | 170 |
2015884 | 2015884 | 2021-12-15 | Christian | Kentucky | 21047 | 10951 | 169 |
2012633 | 2012633 | 2021-12-14 | Christian | Kentucky | 21047 | 10926 | 167 |
2009382 | 2009382 | 2021-12-13 | Christian | Kentucky | 21047 | 10923 | 167 |
2006131 | 2006131 | 2021-12-12 | Christian | Kentucky | 21047 | 10912 | 164 |
2002880 | 2002880 | 2021-12-11 | Christian | Kentucky | 21047 | 10912 | 164 |
1999630 | 1999630 | 2021-12-10 | Christian | Kentucky | 21047 | 10912 | 164 |
1996379 | 1996379 | 2021-12-09 | Christian | Kentucky | 21047 | 10863 | 160 |
1993128 | 1993128 | 2021-12-08 | Christian | Kentucky | 21047 | 10793 | 159 |
1989877 | 1989877 | 2021-12-07 | Christian | Kentucky | 21047 | 10742 | 158 |
1986627 | 1986627 | 2021-12-06 | Christian | Kentucky | 21047 | 10738 | 157 |
1983377 | 1983377 | 2021-12-05 | Christian | Kentucky | 21047 | 10717 | 150 |
1980127 | 1980127 | 2021-12-04 | Christian | Kentucky | 21047 | 10717 | 150 |
1976877 | 1976877 | 2021-12-03 | Christian | Kentucky | 21047 | 10717 | 150 |
1973628 | 1973628 | 2021-12-02 | Christian | Kentucky | 21047 | 10703 | 149 |
1970378 | 1970378 | 2021-12-01 | Christian | Kentucky | 21047 | 10666 | 149 |
1967128 | 1967128 | 2021-11-30 | Christian | Kentucky | 21047 | 10628 | 149 |
1963876 | 1963876 | 2021-11-29 | Christian | Kentucky | 21047 | 10622 | 149 |
1960625 | 1960625 | 2021-11-28 | Christian | Kentucky | 21047 | 10584 | 147 |
1957374 | 1957374 | 2021-11-27 | Christian | Kentucky | 21047 | 10584 | 147 |
1954123 | 1954123 | 2021-11-26 | Christian | Kentucky | 21047 | 10584 | 147 |
1950872 | 1950872 | 2021-11-25 | Christian | Kentucky | 21047 | 10584 | 147 |
1947621 | 1947621 | 2021-11-24 | Christian | Kentucky | 21047 | 10584 | 147 |
1944370 | 1944370 | 2021-11-23 | Christian | Kentucky | 21047 | 10544 | 147 |
1941120 | 1941120 | 2021-11-22 | Christian | Kentucky | 21047 | 10498 | 145 |
1937870 | 1937870 | 2021-11-21 | Christian | Kentucky | 21047 | 10488 | 145 |
1934620 | 1934620 | 2021-11-20 | Christian | Kentucky | 21047 | 10488 | 145 |
1931369 | 1931369 | 2021-11-19 | Christian | Kentucky | 21047 | 10488 | 145 |
1928118 | 1928118 | 2021-11-18 | Christian | Kentucky | 21047 | 10467 | 133 |
1924868 | 1924868 | 2021-11-17 | Christian | Kentucky | 21047 | 10442 | 133 |
1921619 | 1921619 | 2021-11-16 | Christian | Kentucky | 21047 | 10410 | 133 |
1918369 | 1918369 | 2021-11-15 | Christian | Kentucky | 21047 | 10403 | 133 |
1915119 | 1915119 | 2021-11-14 | Christian | Kentucky | 21047 | 10399 | 133 |
1911869 | 1911869 | 2021-11-13 | Christian | Kentucky | 21047 | 10399 | 133 |
1908620 | 1908620 | 2021-11-12 | Christian | Kentucky | 21047 | 10399 | 133 |
1905371 | 1905371 | 2021-11-11 | Christian | Kentucky | 21047 | 10368 | 132 |
1902121 | 1902121 | 2021-11-10 | Christian | Kentucky | 21047 | 10368 | 132 |
1898871 | 1898871 | 2021-11-09 | Christian | Kentucky | 21047 | 10346 | 132 |
1895621 | 1895621 | 2021-11-08 | Christian | Kentucky | 21047 | 10319 | 132 |
1892371 | 1892371 | 2021-11-07 | Christian | Kentucky | 21047 | 10311 | 129 |
1889121 | 1889121 | 2021-11-06 | Christian | Kentucky | 21047 | 10311 | 129 |
1885871 | 1885871 | 2021-11-05 | Christian | Kentucky | 21047 | 10311 | 129 |
1882622 | 1882622 | 2021-11-04 | Christian | Kentucky | 21047 | 10294 | 128 |
1879373 | 1879373 | 2021-11-03 | Christian | Kentucky | 21047 | 10288 | 128 |
1876124 | 1876124 | 2021-11-02 | Christian | Kentucky | 21047 | 10275 | 128 |
1872875 | 1872875 | 2021-11-01 | Christian | Kentucky | 21047 | 10254 | 128 |
1869626 | 1869626 | 2021-10-31 | Christian | Kentucky | 21047 | 10249 | 128 |
1866377 | 1866377 | 2021-10-30 | Christian | Kentucky | 21047 | 10249 | 128 |
1863128 | 1863128 | 2021-10-29 | Christian | Kentucky | 21047 | 10249 | 128 |
1859879 | 1859879 | 2021-10-28 | Christian | Kentucky | 21047 | 10235 | 128 |
1856630 | 1856630 | 2021-10-27 | Christian | Kentucky | 21047 | 10221 | 128 |
1853381 | 1853381 | 2021-10-26 | Christian | Kentucky | 21047 | 10194 | 128 |
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);