ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 12069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174551 | 2174551 | 2022-02-02 | Lake | Florida | 12069 | 78050 | 1301 |
2171298 | 2171298 | 2022-02-01 | Lake | Florida | 12069 | 78050 | 1276 |
2168045 | 2168045 | 2022-01-31 | Lake | Florida | 12069 | 78050 | 1276 |
2164790 | 2164790 | 2022-01-30 | Lake | Florida | 12069 | 78050 | 1276 |
2161535 | 2161535 | 2022-01-29 | Lake | Florida | 12069 | 78050 | 1276 |
2158279 | 2158279 | 2022-01-28 | Lake | Florida | 12069 | 78050 | 1276 |
2155026 | 2155026 | 2022-01-27 | Lake | Florida | 12069 | 74451 | 1276 |
2151773 | 2151773 | 2022-01-26 | Lake | Florida | 12069 | 74451 | 1276 |
2148521 | 2148521 | 2022-01-25 | Lake | Florida | 12069 | 74451 | 1271 |
2145269 | 2145269 | 2022-01-24 | Lake | Florida | 12069 | 74451 | 1271 |
2142014 | 2142014 | 2022-01-23 | Lake | Florida | 12069 | 74451 | 1271 |
2138759 | 2138759 | 2022-01-22 | Lake | Florida | 12069 | 74451 | 1271 |
2135503 | 2135503 | 2022-01-21 | Lake | Florida | 12069 | 74451 | 1271 |
2132251 | 2132251 | 2022-01-20 | Lake | Florida | 12069 | 70093 | 1271 |
2128998 | 2128998 | 2022-01-19 | Lake | Florida | 12069 | 70093 | 1271 |
2125744 | 2125744 | 2022-01-18 | Lake | Florida | 12069 | 70093 | 1257 |
2122492 | 2122492 | 2022-01-17 | Lake | Florida | 12069 | 70093 | 1257 |
2119240 | 2119240 | 2022-01-16 | Lake | Florida | 12069 | 70093 | 1257 |
2115988 | 2115988 | 2022-01-15 | Lake | Florida | 12069 | 70093 | 1257 |
2112737 | 2112737 | 2022-01-14 | Lake | Florida | 12069 | 70093 | 1257 |
2109485 | 2109485 | 2022-01-13 | Lake | Florida | 12069 | 63681 | 1257 |
2106234 | 2106234 | 2022-01-12 | Lake | Florida | 12069 | 63681 | 1257 |
2102983 | 2102983 | 2022-01-11 | Lake | Florida | 12069 | 63681 | 1255 |
2099732 | 2099732 | 2022-01-10 | Lake | Florida | 12069 | 63681 | 1255 |
2096481 | 2096481 | 2022-01-09 | Lake | Florida | 12069 | 63681 | 1255 |
2093229 | 2093229 | 2022-01-08 | Lake | Florida | 12069 | 63681 | 1255 |
2089977 | 2089977 | 2022-01-07 | Lake | Florida | 12069 | 63681 | 1255 |
2086726 | 2086726 | 2022-01-06 | Lake | Florida | 12069 | 59574 | 1255 |
2083474 | 2083474 | 2022-01-05 | Lake | Florida | 12069 | 59574 | 1255 |
2080222 | 2080222 | 2022-01-04 | Lake | Florida | 12069 | 59574 | 1250 |
2076970 | 2076970 | 2022-01-03 | Lake | Florida | 12069 | 59574 | 1250 |
2073719 | 2073719 | 2022-01-02 | Lake | Florida | 12069 | 59574 | 1250 |
2070468 | 2070468 | 2022-01-01 | Lake | Florida | 12069 | 59574 | 1250 |
2067217 | 2067217 | 2021-12-31 | Lake | Florida | 12069 | 59574 | 1250 |
2063966 | 2063966 | 2021-12-30 | Lake | Florida | 12069 | 56730 | 1250 |
2060716 | 2060716 | 2021-12-29 | Lake | Florida | 12069 | 56730 | 1250 |
2057467 | 2057467 | 2021-12-28 | Lake | Florida | 12069 | 56730 | 1252 |
2054218 | 2054218 | 2021-12-27 | Lake | Florida | 12069 | 56730 | 1252 |
2050968 | 2050968 | 2021-12-26 | Lake | Florida | 12069 | 56730 | 1252 |
2047718 | 2047718 | 2021-12-25 | Lake | Florida | 12069 | 56730 | 1252 |
2044468 | 2044468 | 2021-12-24 | Lake | Florida | 12069 | 56730 | 1252 |
2041219 | 2041219 | 2021-12-23 | Lake | Florida | 12069 | 56032 | 1252 |
2037969 | 2037969 | 2021-12-22 | Lake | Florida | 12069 | 56032 | 1252 |
2034719 | 2034719 | 2021-12-21 | Lake | Florida | 12069 | 56032 | 1245 |
2031469 | 2031469 | 2021-12-20 | Lake | Florida | 12069 | 56032 | 1245 |
2028218 | 2028218 | 2021-12-19 | Lake | Florida | 12069 | 56032 | 1245 |
2024967 | 2024967 | 2021-12-18 | Lake | Florida | 12069 | 56032 | 1245 |
2021716 | 2021716 | 2021-12-17 | Lake | Florida | 12069 | 56032 | 1245 |
2018465 | 2018465 | 2021-12-16 | Lake | Florida | 12069 | 55746 | 1245 |
2015215 | 2015215 | 2021-12-15 | Lake | Florida | 12069 | 55746 | 1245 |
2011964 | 2011964 | 2021-12-14 | Lake | Florida | 12069 | 55746 | 1245 |
2008713 | 2008713 | 2021-12-13 | Lake | Florida | 12069 | 55746 | 1243 |
2005462 | 2005462 | 2021-12-12 | Lake | Florida | 12069 | 55746 | 1243 |
2002211 | 2002211 | 2021-12-11 | Lake | Florida | 12069 | 55746 | 1243 |
1998961 | 1998961 | 2021-12-10 | Lake | Florida | 12069 | 55746 | 1243 |
1995710 | 1995710 | 2021-12-09 | Lake | Florida | 12069 | 55508 | 1243 |
1992459 | 1992459 | 2021-12-08 | Lake | Florida | 12069 | 55508 | 1243 |
1989208 | 1989208 | 2021-12-07 | Lake | Florida | 12069 | 55508 | 1233 |
1985958 | 1985958 | 2021-12-06 | Lake | Florida | 12069 | 55508 | 1233 |
1982708 | 1982708 | 2021-12-05 | Lake | Florida | 12069 | 55508 | 1233 |
1979458 | 1979458 | 2021-12-04 | Lake | Florida | 12069 | 55508 | 1233 |
1976208 | 1976208 | 2021-12-03 | Lake | Florida | 12069 | 55508 | 1233 |
1972959 | 1972959 | 2021-12-02 | Lake | Florida | 12069 | 55332 | 1233 |
1969709 | 1969709 | 2021-12-01 | Lake | Florida | 12069 | 55332 | 1233 |
1966459 | 1966459 | 2021-11-30 | Lake | Florida | 12069 | 55332 | 1233 |
1963207 | 1963207 | 2021-11-29 | Lake | Florida | 12069 | 55176 | 1233 |
1959956 | 1959956 | 2021-11-28 | Lake | Florida | 12069 | 55176 | 1233 |
1956705 | 1956705 | 2021-11-27 | Lake | Florida | 12069 | 55176 | 1233 |
1953454 | 1953454 | 2021-11-26 | Lake | Florida | 12069 | 55176 | 1233 |
1950203 | 1950203 | 2021-11-25 | Lake | Florida | 12069 | 55176 | 1233 |
1946952 | 1946952 | 2021-11-24 | Lake | Florida | 12069 | 55176 | 1233 |
1943701 | 1943701 | 2021-11-23 | Lake | Florida | 12069 | 55176 | 1233 |
1940451 | 1940451 | 2021-11-22 | Lake | Florida | 12069 | 55176 | 1233 |
1937201 | 1937201 | 2021-11-21 | Lake | Florida | 12069 | 55176 | 1233 |
1933951 | 1933951 | 2021-11-20 | Lake | Florida | 12069 | 55176 | 1233 |
1930699 | 1930699 | 2021-11-19 | Lake | Florida | 12069 | 55176 | 1219 |
1927449 | 1927449 | 2021-11-18 | Lake | Florida | 12069 | 54930 | 1219 |
1924199 | 1924199 | 2021-11-17 | Lake | Florida | 12069 | 54930 | 1219 |
1920950 | 1920950 | 2021-11-16 | Lake | Florida | 12069 | 54930 | 1219 |
1917700 | 1917700 | 2021-11-15 | Lake | Florida | 12069 | 54930 | 1219 |
1914450 | 1914450 | 2021-11-14 | Lake | Florida | 12069 | 54930 | 1207 |
1911200 | 1911200 | 2021-11-13 | Lake | Florida | 12069 | 54930 | 1207 |
1907951 | 1907951 | 2021-11-12 | Lake | Florida | 12069 | 54930 | 1207 |
1904702 | 1904702 | 2021-11-11 | Lake | Florida | 12069 | 54697 | 1207 |
1901452 | 1901452 | 2021-11-10 | Lake | Florida | 12069 | 54697 | 1207 |
1898202 | 1898202 | 2021-11-09 | Lake | Florida | 12069 | 54697 | 1207 |
1894952 | 1894952 | 2021-11-08 | Lake | Florida | 12069 | 54697 | 1207 |
1891702 | 1891702 | 2021-11-07 | Lake | Florida | 12069 | 54697 | 1203 |
1888452 | 1888452 | 2021-11-06 | Lake | Florida | 12069 | 54697 | 1203 |
1885202 | 1885202 | 2021-11-05 | Lake | Florida | 12069 | 54697 | 1203 |
1881953 | 1881953 | 2021-11-04 | Lake | Florida | 12069 | 54454 | 1203 |
1878704 | 1878704 | 2021-11-03 | Lake | Florida | 12069 | 54454 | 1203 |
1875455 | 1875455 | 2021-11-02 | Lake | Florida | 12069 | 54454 | 1203 |
1872206 | 1872206 | 2021-11-01 | Lake | Florida | 12069 | 54454 | 1203 |
1868957 | 1868957 | 2021-10-31 | Lake | Florida | 12069 | 54454 | 1203 |
1865708 | 1865708 | 2021-10-30 | Lake | Florida | 12069 | 54454 | 1193 |
1862459 | 1862459 | 2021-10-29 | Lake | Florida | 12069 | 54454 | 1193 |
1859210 | 1859210 | 2021-10-28 | Lake | Florida | 12069 | 54129 | 1193 |
1855961 | 1855961 | 2021-10-27 | Lake | Florida | 12069 | 54129 | 1193 |
1852712 | 1852712 | 2021-10-26 | Lake | Florida | 12069 | 54129 | 1193 |
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);