ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Allen", fips = 21003 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175198 | 2175198 | 2022-02-02 | Allen | Kentucky | 21003 | 6048 | 90 |
2171945 | 2171945 | 2022-02-01 | Allen | Kentucky | 21003 | 6023 | 90 |
2168692 | 2168692 | 2022-01-31 | Allen | Kentucky | 21003 | 5956 | 90 |
2165437 | 2165437 | 2022-01-30 | Allen | Kentucky | 21003 | 5830 | 88 |
2162182 | 2162182 | 2022-01-29 | Allen | Kentucky | 21003 | 5830 | 88 |
2158927 | 2158927 | 2022-01-28 | Allen | Kentucky | 21003 | 5830 | 88 |
2155673 | 2155673 | 2022-01-27 | Allen | Kentucky | 21003 | 5728 | 87 |
2152420 | 2152420 | 2022-01-26 | Allen | Kentucky | 21003 | 5638 | 87 |
2149168 | 2149168 | 2022-01-25 | Allen | Kentucky | 21003 | 5554 | 87 |
2145916 | 2145916 | 2022-01-24 | Allen | Kentucky | 21003 | 5476 | 87 |
2142661 | 2142661 | 2022-01-23 | Allen | Kentucky | 21003 | 5294 | 86 |
2139406 | 2139406 | 2022-01-22 | Allen | Kentucky | 21003 | 5294 | 86 |
2136150 | 2136150 | 2022-01-21 | Allen | Kentucky | 21003 | 5294 | 86 |
2132898 | 2132898 | 2022-01-20 | Allen | Kentucky | 21003 | 5223 | 86 |
2129645 | 2129645 | 2022-01-19 | Allen | Kentucky | 21003 | 5127 | 86 |
2126391 | 2126391 | 2022-01-18 | Allen | Kentucky | 21003 | 5041 | 85 |
2123139 | 2123139 | 2022-01-17 | Allen | Kentucky | 21003 | 4860 | 85 |
2119887 | 2119887 | 2022-01-16 | Allen | Kentucky | 21003 | 4860 | 85 |
2116635 | 2116635 | 2022-01-15 | Allen | Kentucky | 21003 | 4860 | 85 |
2113384 | 2113384 | 2022-01-14 | Allen | Kentucky | 21003 | 4860 | 85 |
2110132 | 2110132 | 2022-01-13 | Allen | Kentucky | 21003 | 4785 | 85 |
2106881 | 2106881 | 2022-01-12 | Allen | Kentucky | 21003 | 4730 | 85 |
2103630 | 2103630 | 2022-01-11 | Allen | Kentucky | 21003 | 4673 | 85 |
2100379 | 2100379 | 2022-01-10 | Allen | Kentucky | 21003 | 4628 | 85 |
2097128 | 2097128 | 2022-01-09 | Allen | Kentucky | 21003 | 4583 | 83 |
2093876 | 2093876 | 2022-01-08 | Allen | Kentucky | 21003 | 4583 | 83 |
2090624 | 2090624 | 2022-01-07 | Allen | Kentucky | 21003 | 4583 | 83 |
2087373 | 2087373 | 2022-01-06 | Allen | Kentucky | 21003 | 4531 | 83 |
2084121 | 2084121 | 2022-01-05 | Allen | Kentucky | 21003 | 4495 | 83 |
2080869 | 2080869 | 2022-01-04 | Allen | Kentucky | 21003 | 4458 | 83 |
2077617 | 2077617 | 2022-01-03 | Allen | Kentucky | 21003 | 4433 | 83 |
2074366 | 2074366 | 2022-01-02 | Allen | Kentucky | 21003 | 4326 | 82 |
2071115 | 2071115 | 2022-01-01 | Allen | Kentucky | 21003 | 4326 | 82 |
2067864 | 2067864 | 2021-12-31 | Allen | Kentucky | 21003 | 4326 | 82 |
2064613 | 2064613 | 2021-12-30 | Allen | Kentucky | 21003 | 4326 | 82 |
2061363 | 2061363 | 2021-12-29 | Allen | Kentucky | 21003 | 4326 | 82 |
2058114 | 2058114 | 2021-12-28 | Allen | Kentucky | 21003 | 4311 | 81 |
2054865 | 2054865 | 2021-12-27 | Allen | Kentucky | 21003 | 4281 | 80 |
2051615 | 2051615 | 2021-12-26 | Allen | Kentucky | 21003 | 4237 | 79 |
2048365 | 2048365 | 2021-12-25 | Allen | Kentucky | 21003 | 4237 | 79 |
2045115 | 2045115 | 2021-12-24 | Allen | Kentucky | 21003 | 4237 | 79 |
2041866 | 2041866 | 2021-12-23 | Allen | Kentucky | 21003 | 4237 | 79 |
2038616 | 2038616 | 2021-12-22 | Allen | Kentucky | 21003 | 4237 | 79 |
2035366 | 2035366 | 2021-12-21 | Allen | Kentucky | 21003 | 4224 | 79 |
2032116 | 2032116 | 2021-12-20 | Allen | Kentucky | 21003 | 4213 | 79 |
2028865 | 2028865 | 2021-12-19 | Allen | Kentucky | 21003 | 4181 | 78 |
2025614 | 2025614 | 2021-12-18 | Allen | Kentucky | 21003 | 4181 | 78 |
2022363 | 2022363 | 2021-12-17 | Allen | Kentucky | 21003 | 4181 | 78 |
2019112 | 2019112 | 2021-12-16 | Allen | Kentucky | 21003 | 4171 | 78 |
2015862 | 2015862 | 2021-12-15 | Allen | Kentucky | 21003 | 4161 | 78 |
2012611 | 2012611 | 2021-12-14 | Allen | Kentucky | 21003 | 4137 | 78 |
2009360 | 2009360 | 2021-12-13 | Allen | Kentucky | 21003 | 4125 | 77 |
2006109 | 2006109 | 2021-12-12 | Allen | Kentucky | 21003 | 4111 | 77 |
2002858 | 2002858 | 2021-12-11 | Allen | Kentucky | 21003 | 4111 | 77 |
1999608 | 1999608 | 2021-12-10 | Allen | Kentucky | 21003 | 4111 | 77 |
1996357 | 1996357 | 2021-12-09 | Allen | Kentucky | 21003 | 4094 | 76 |
1993106 | 1993106 | 2021-12-08 | Allen | Kentucky | 21003 | 4075 | 76 |
1989855 | 1989855 | 2021-12-07 | Allen | Kentucky | 21003 | 4061 | 75 |
1986605 | 1986605 | 2021-12-06 | Allen | Kentucky | 21003 | 4041 | 75 |
1983355 | 1983355 | 2021-12-05 | Allen | Kentucky | 21003 | 4013 | 75 |
1980105 | 1980105 | 2021-12-04 | Allen | Kentucky | 21003 | 4013 | 75 |
1976855 | 1976855 | 2021-12-03 | Allen | Kentucky | 21003 | 4013 | 75 |
1973606 | 1973606 | 2021-12-02 | Allen | Kentucky | 21003 | 4001 | 75 |
1970356 | 1970356 | 2021-12-01 | Allen | Kentucky | 21003 | 3983 | 75 |
1967106 | 1967106 | 2021-11-30 | Allen | Kentucky | 21003 | 3961 | 75 |
1963854 | 1963854 | 2021-11-29 | Allen | Kentucky | 21003 | 3945 | 75 |
1960603 | 1960603 | 2021-11-28 | Allen | Kentucky | 21003 | 3920 | 74 |
1957352 | 1957352 | 2021-11-27 | Allen | Kentucky | 21003 | 3920 | 74 |
1954101 | 1954101 | 2021-11-26 | Allen | Kentucky | 21003 | 3920 | 74 |
1950850 | 1950850 | 2021-11-25 | Allen | Kentucky | 21003 | 3920 | 74 |
1947599 | 1947599 | 2021-11-24 | Allen | Kentucky | 21003 | 3920 | 74 |
1944348 | 1944348 | 2021-11-23 | Allen | Kentucky | 21003 | 3908 | 72 |
1941098 | 1941098 | 2021-11-22 | Allen | Kentucky | 21003 | 3901 | 72 |
1937848 | 1937848 | 2021-11-21 | Allen | Kentucky | 21003 | 3893 | 72 |
1934598 | 1934598 | 2021-11-20 | Allen | Kentucky | 21003 | 3893 | 72 |
1931347 | 1931347 | 2021-11-19 | Allen | Kentucky | 21003 | 3893 | 72 |
1928096 | 1928096 | 2021-11-18 | Allen | Kentucky | 21003 | 3881 | 70 |
1924846 | 1924846 | 2021-11-17 | Allen | Kentucky | 21003 | 3876 | 70 |
1921597 | 1921597 | 2021-11-16 | Allen | Kentucky | 21003 | 3873 | 70 |
1918347 | 1918347 | 2021-11-15 | Allen | Kentucky | 21003 | 3865 | 70 |
1915097 | 1915097 | 2021-11-14 | Allen | Kentucky | 21003 | 3858 | 70 |
1911847 | 1911847 | 2021-11-13 | Allen | Kentucky | 21003 | 3858 | 70 |
1908598 | 1908598 | 2021-11-12 | Allen | Kentucky | 21003 | 3858 | 70 |
1905349 | 1905349 | 2021-11-11 | Allen | Kentucky | 21003 | 3851 | 70 |
1902099 | 1902099 | 2021-11-10 | Allen | Kentucky | 21003 | 3851 | 70 |
1898849 | 1898849 | 2021-11-09 | Allen | Kentucky | 21003 | 3844 | 70 |
1895599 | 1895599 | 2021-11-08 | Allen | Kentucky | 21003 | 3837 | 70 |
1892349 | 1892349 | 2021-11-07 | Allen | Kentucky | 21003 | 3836 | 70 |
1889099 | 1889099 | 2021-11-06 | Allen | Kentucky | 21003 | 3836 | 70 |
1885849 | 1885849 | 2021-11-05 | Allen | Kentucky | 21003 | 3836 | 70 |
1882600 | 1882600 | 2021-11-04 | Allen | Kentucky | 21003 | 3831 | 70 |
1879351 | 1879351 | 2021-11-03 | Allen | Kentucky | 21003 | 3825 | 70 |
1876102 | 1876102 | 2021-11-02 | Allen | Kentucky | 21003 | 3821 | 70 |
1872853 | 1872853 | 2021-11-01 | Allen | Kentucky | 21003 | 3820 | 69 |
1869604 | 1869604 | 2021-10-31 | Allen | Kentucky | 21003 | 3816 | 69 |
1866355 | 1866355 | 2021-10-30 | Allen | Kentucky | 21003 | 3816 | 69 |
1863106 | 1863106 | 2021-10-29 | Allen | Kentucky | 21003 | 3816 | 69 |
1859857 | 1859857 | 2021-10-28 | Allen | Kentucky | 21003 | 3810 | 69 |
1856608 | 1856608 | 2021-10-27 | Allen | Kentucky | 21003 | 3805 | 68 |
1853359 | 1853359 | 2021-10-26 | Allen | Kentucky | 21003 | 3799 | 68 |
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);