ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Lee" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174552 | 2174552 | 2022-02-02 | Lee | Florida | 12071 | 175773 | 1931 |
2171299 | 2171299 | 2022-02-01 | Lee | Florida | 12071 | 175773 | 1901 |
2168046 | 2168046 | 2022-01-31 | Lee | Florida | 12071 | 175773 | 1901 |
2164791 | 2164791 | 2022-01-30 | Lee | Florida | 12071 | 175773 | 1901 |
2161536 | 2161536 | 2022-01-29 | Lee | Florida | 12071 | 175773 | 1901 |
2158280 | 2158280 | 2022-01-28 | Lee | Florida | 12071 | 175773 | 1901 |
2155027 | 2155027 | 2022-01-27 | Lee | Florida | 12071 | 168971 | 1901 |
2151774 | 2151774 | 2022-01-26 | Lee | Florida | 12071 | 168971 | 1901 |
2148522 | 2148522 | 2022-01-25 | Lee | Florida | 12071 | 168971 | 1885 |
2145270 | 2145270 | 2022-01-24 | Lee | Florida | 12071 | 168971 | 1885 |
2142015 | 2142015 | 2022-01-23 | Lee | Florida | 12071 | 168971 | 1885 |
2138760 | 2138760 | 2022-01-22 | Lee | Florida | 12071 | 168971 | 1885 |
2135504 | 2135504 | 2022-01-21 | Lee | Florida | 12071 | 168971 | 1885 |
2132252 | 2132252 | 2022-01-20 | Lee | Florida | 12071 | 158788 | 1885 |
2128999 | 2128999 | 2022-01-19 | Lee | Florida | 12071 | 158788 | 1885 |
2125745 | 2125745 | 2022-01-18 | Lee | Florida | 12071 | 158788 | 1869 |
2122493 | 2122493 | 2022-01-17 | Lee | Florida | 12071 | 158788 | 1869 |
2119241 | 2119241 | 2022-01-16 | Lee | Florida | 12071 | 158788 | 1869 |
2115989 | 2115989 | 2022-01-15 | Lee | Florida | 12071 | 158788 | 1869 |
2112738 | 2112738 | 2022-01-14 | Lee | Florida | 12071 | 158788 | 1869 |
2109486 | 2109486 | 2022-01-13 | Lee | Florida | 12071 | 145973 | 1869 |
2106235 | 2106235 | 2022-01-12 | Lee | Florida | 12071 | 145973 | 1869 |
2102984 | 2102984 | 2022-01-11 | Lee | Florida | 12071 | 145973 | 1861 |
2099733 | 2099733 | 2022-01-10 | Lee | Florida | 12071 | 145973 | 1861 |
2096482 | 2096482 | 2022-01-09 | Lee | Florida | 12071 | 145973 | 1861 |
2093230 | 2093230 | 2022-01-08 | Lee | Florida | 12071 | 145973 | 1861 |
2089978 | 2089978 | 2022-01-07 | Lee | Florida | 12071 | 145973 | 1861 |
2086727 | 2086727 | 2022-01-06 | Lee | Florida | 12071 | 135363 | 1861 |
2083475 | 2083475 | 2022-01-05 | Lee | Florida | 12071 | 135363 | 1861 |
2080223 | 2080223 | 2022-01-04 | Lee | Florida | 12071 | 135363 | 1857 |
2076971 | 2076971 | 2022-01-03 | Lee | Florida | 12071 | 135363 | 1857 |
2073720 | 2073720 | 2022-01-02 | Lee | Florida | 12071 | 135363 | 1857 |
2070469 | 2070469 | 2022-01-01 | Lee | Florida | 12071 | 135363 | 1857 |
2067218 | 2067218 | 2021-12-31 | Lee | Florida | 12071 | 135363 | 1857 |
2063967 | 2063967 | 2021-12-30 | Lee | Florida | 12071 | 129344 | 1857 |
2060717 | 2060717 | 2021-12-29 | Lee | Florida | 12071 | 129344 | 1857 |
2057468 | 2057468 | 2021-12-28 | Lee | Florida | 12071 | 129344 | 1853 |
2054219 | 2054219 | 2021-12-27 | Lee | Florida | 12071 | 129344 | 1853 |
2050969 | 2050969 | 2021-12-26 | Lee | Florida | 12071 | 129344 | 1853 |
2047719 | 2047719 | 2021-12-25 | Lee | Florida | 12071 | 129344 | 1853 |
2044469 | 2044469 | 2021-12-24 | Lee | Florida | 12071 | 129344 | 1853 |
2041220 | 2041220 | 2021-12-23 | Lee | Florida | 12071 | 127529 | 1853 |
2037970 | 2037970 | 2021-12-22 | Lee | Florida | 12071 | 127529 | 1853 |
2034720 | 2034720 | 2021-12-21 | Lee | Florida | 12071 | 127529 | 1857 |
2031470 | 2031470 | 2021-12-20 | Lee | Florida | 12071 | 127529 | 1857 |
2028219 | 2028219 | 2021-12-19 | Lee | Florida | 12071 | 127529 | 1857 |
2024968 | 2024968 | 2021-12-18 | Lee | Florida | 12071 | 127529 | 1857 |
2021717 | 2021717 | 2021-12-17 | Lee | Florida | 12071 | 127529 | 1857 |
2018466 | 2018466 | 2021-12-16 | Lee | Florida | 12071 | 127007 | 1857 |
2015216 | 2015216 | 2021-12-15 | Lee | Florida | 12071 | 127007 | 1857 |
2011965 | 2011965 | 2021-12-14 | Lee | Florida | 12071 | 127007 | 1857 |
2008714 | 2008714 | 2021-12-13 | Lee | Florida | 12071 | 127007 | 1844 |
2005463 | 2005463 | 2021-12-12 | Lee | Florida | 12071 | 127007 | 1844 |
2002212 | 2002212 | 2021-12-11 | Lee | Florida | 12071 | 127007 | 1844 |
1998962 | 1998962 | 2021-12-10 | Lee | Florida | 12071 | 127007 | 1844 |
1995711 | 1995711 | 2021-12-09 | Lee | Florida | 12071 | 126586 | 1844 |
1992460 | 1992460 | 2021-12-08 | Lee | Florida | 12071 | 126586 | 1844 |
1989209 | 1989209 | 2021-12-07 | Lee | Florida | 12071 | 126586 | 1840 |
1985959 | 1985959 | 2021-12-06 | Lee | Florida | 12071 | 126586 | 1840 |
1982709 | 1982709 | 2021-12-05 | Lee | Florida | 12071 | 126586 | 1840 |
1979459 | 1979459 | 2021-12-04 | Lee | Florida | 12071 | 126586 | 1840 |
1976209 | 1976209 | 2021-12-03 | Lee | Florida | 12071 | 126586 | 1840 |
1972960 | 1972960 | 2021-12-02 | Lee | Florida | 12071 | 126166 | 1840 |
1969710 | 1969710 | 2021-12-01 | Lee | Florida | 12071 | 126166 | 1840 |
1966460 | 1966460 | 2021-11-30 | Lee | Florida | 12071 | 126166 | 1840 |
1963208 | 1963208 | 2021-11-29 | Lee | Florida | 12071 | 125907 | 1840 |
1959957 | 1959957 | 2021-11-28 | Lee | Florida | 12071 | 125907 | 1840 |
1956706 | 1956706 | 2021-11-27 | Lee | Florida | 12071 | 125907 | 1840 |
1953455 | 1953455 | 2021-11-26 | Lee | Florida | 12071 | 125907 | 1840 |
1950204 | 1950204 | 2021-11-25 | Lee | Florida | 12071 | 125907 | 1840 |
1946953 | 1946953 | 2021-11-24 | Lee | Florida | 12071 | 125907 | 1840 |
1943702 | 1943702 | 2021-11-23 | Lee | Florida | 12071 | 125907 | 1840 |
1940452 | 1940452 | 2021-11-22 | Lee | Florida | 12071 | 125907 | 1840 |
1937202 | 1937202 | 2021-11-21 | Lee | Florida | 12071 | 125907 | 1840 |
1933952 | 1933952 | 2021-11-20 | Lee | Florida | 12071 | 125907 | 1840 |
1930700 | 1930700 | 2021-11-19 | Lee | Florida | 12071 | 125907 | 1832 |
1927450 | 1927450 | 2021-11-18 | Lee | Florida | 12071 | 125649 | 1832 |
1924200 | 1924200 | 2021-11-17 | Lee | Florida | 12071 | 125649 | 1832 |
1920951 | 1920951 | 2021-11-16 | Lee | Florida | 12071 | 125649 | 1832 |
1917701 | 1917701 | 2021-11-15 | Lee | Florida | 12071 | 125649 | 1832 |
1914451 | 1914451 | 2021-11-14 | Lee | Florida | 12071 | 125649 | 1825 |
1911201 | 1911201 | 2021-11-13 | Lee | Florida | 12071 | 125649 | 1825 |
1907952 | 1907952 | 2021-11-12 | Lee | Florida | 12071 | 125649 | 1825 |
1904703 | 1904703 | 2021-11-11 | Lee | Florida | 12071 | 125270 | 1825 |
1901453 | 1901453 | 2021-11-10 | Lee | Florida | 12071 | 125270 | 1825 |
1898203 | 1898203 | 2021-11-09 | Lee | Florida | 12071 | 125270 | 1825 |
1894953 | 1894953 | 2021-11-08 | Lee | Florida | 12071 | 125270 | 1825 |
1891703 | 1891703 | 2021-11-07 | Lee | Florida | 12071 | 125270 | 1812 |
1888453 | 1888453 | 2021-11-06 | Lee | Florida | 12071 | 125270 | 1812 |
1885203 | 1885203 | 2021-11-05 | Lee | Florida | 12071 | 125270 | 1812 |
1881954 | 1881954 | 2021-11-04 | Lee | Florida | 12071 | 124961 | 1812 |
1878705 | 1878705 | 2021-11-03 | Lee | Florida | 12071 | 124961 | 1812 |
1875456 | 1875456 | 2021-11-02 | Lee | Florida | 12071 | 124961 | 1812 |
1872207 | 1872207 | 2021-11-01 | Lee | Florida | 12071 | 124961 | 1812 |
1868958 | 1868958 | 2021-10-31 | Lee | Florida | 12071 | 124961 | 1812 |
1865709 | 1865709 | 2021-10-30 | Lee | Florida | 12071 | 124961 | 1793 |
1862460 | 1862460 | 2021-10-29 | Lee | Florida | 12071 | 124961 | 1793 |
1859211 | 1859211 | 2021-10-28 | Lee | Florida | 12071 | 124415 | 1793 |
1855962 | 1855962 | 2021-10-27 | Lee | Florida | 12071 | 124415 | 1793 |
1852713 | 1852713 | 2021-10-26 | Lee | Florida | 12071 | 124415 | 1793 |
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);