ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Pasco" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174568 | 2174568 | 2022-02-02 | Pasco | Florida | 12101 | 112390 | 1687 |
2171315 | 2171315 | 2022-02-01 | Pasco | Florida | 12101 | 112390 | 1661 |
2168062 | 2168062 | 2022-01-31 | Pasco | Florida | 12101 | 112390 | 1661 |
2164807 | 2164807 | 2022-01-30 | Pasco | Florida | 12101 | 112390 | 1661 |
2161552 | 2161552 | 2022-01-29 | Pasco | Florida | 12101 | 112390 | 1661 |
2158296 | 2158296 | 2022-01-28 | Pasco | Florida | 12101 | 112390 | 1661 |
2155043 | 2155043 | 2022-01-27 | Pasco | Florida | 12101 | 106816 | 1661 |
2151790 | 2151790 | 2022-01-26 | Pasco | Florida | 12101 | 106816 | 1661 |
2148538 | 2148538 | 2022-01-25 | Pasco | Florida | 12101 | 106816 | 1651 |
2145286 | 2145286 | 2022-01-24 | Pasco | Florida | 12101 | 106816 | 1651 |
2142031 | 2142031 | 2022-01-23 | Pasco | Florida | 12101 | 106816 | 1651 |
2138776 | 2138776 | 2022-01-22 | Pasco | Florida | 12101 | 106816 | 1651 |
2135520 | 2135520 | 2022-01-21 | Pasco | Florida | 12101 | 106816 | 1651 |
2132268 | 2132268 | 2022-01-20 | Pasco | Florida | 12101 | 99718 | 1651 |
2129015 | 2129015 | 2022-01-19 | Pasco | Florida | 12101 | 99718 | 1651 |
2125761 | 2125761 | 2022-01-18 | Pasco | Florida | 12101 | 99718 | 1635 |
2122509 | 2122509 | 2022-01-17 | Pasco | Florida | 12101 | 99718 | 1635 |
2119257 | 2119257 | 2022-01-16 | Pasco | Florida | 12101 | 99718 | 1635 |
2116005 | 2116005 | 2022-01-15 | Pasco | Florida | 12101 | 99718 | 1635 |
2112754 | 2112754 | 2022-01-14 | Pasco | Florida | 12101 | 99718 | 1635 |
2109502 | 2109502 | 2022-01-13 | Pasco | Florida | 12101 | 91476 | 1635 |
2106251 | 2106251 | 2022-01-12 | Pasco | Florida | 12101 | 91476 | 1635 |
2103000 | 2103000 | 2022-01-11 | Pasco | Florida | 12101 | 91476 | 1624 |
2099749 | 2099749 | 2022-01-10 | Pasco | Florida | 12101 | 91476 | 1624 |
2096498 | 2096498 | 2022-01-09 | Pasco | Florida | 12101 | 91476 | 1624 |
2093246 | 2093246 | 2022-01-08 | Pasco | Florida | 12101 | 91476 | 1624 |
2089994 | 2089994 | 2022-01-07 | Pasco | Florida | 12101 | 91476 | 1624 |
2086743 | 2086743 | 2022-01-06 | Pasco | Florida | 12101 | 85229 | 1624 |
2083491 | 2083491 | 2022-01-05 | Pasco | Florida | 12101 | 85229 | 1624 |
2080239 | 2080239 | 2022-01-04 | Pasco | Florida | 12101 | 85229 | 1619 |
2076987 | 2076987 | 2022-01-03 | Pasco | Florida | 12101 | 85229 | 1619 |
2073736 | 2073736 | 2022-01-02 | Pasco | Florida | 12101 | 85229 | 1619 |
2070485 | 2070485 | 2022-01-01 | Pasco | Florida | 12101 | 85229 | 1619 |
2067234 | 2067234 | 2021-12-31 | Pasco | Florida | 12101 | 85229 | 1619 |
2063983 | 2063983 | 2021-12-30 | Pasco | Florida | 12101 | 81832 | 1619 |
2060733 | 2060733 | 2021-12-29 | Pasco | Florida | 12101 | 81832 | 1619 |
2057484 | 2057484 | 2021-12-28 | Pasco | Florida | 12101 | 81832 | 1618 |
2054235 | 2054235 | 2021-12-27 | Pasco | Florida | 12101 | 81832 | 1618 |
2050985 | 2050985 | 2021-12-26 | Pasco | Florida | 12101 | 81832 | 1618 |
2047735 | 2047735 | 2021-12-25 | Pasco | Florida | 12101 | 81832 | 1618 |
2044485 | 2044485 | 2021-12-24 | Pasco | Florida | 12101 | 81832 | 1618 |
2041236 | 2041236 | 2021-12-23 | Pasco | Florida | 12101 | 80859 | 1618 |
2037986 | 2037986 | 2021-12-22 | Pasco | Florida | 12101 | 80859 | 1618 |
2034736 | 2034736 | 2021-12-21 | Pasco | Florida | 12101 | 80859 | 1608 |
2031486 | 2031486 | 2021-12-20 | Pasco | Florida | 12101 | 80859 | 1608 |
2028235 | 2028235 | 2021-12-19 | Pasco | Florida | 12101 | 80859 | 1608 |
2024984 | 2024984 | 2021-12-18 | Pasco | Florida | 12101 | 80859 | 1608 |
2021733 | 2021733 | 2021-12-17 | Pasco | Florida | 12101 | 80859 | 1608 |
2018482 | 2018482 | 2021-12-16 | Pasco | Florida | 12101 | 80464 | 1608 |
2015232 | 2015232 | 2021-12-15 | Pasco | Florida | 12101 | 80464 | 1608 |
2011981 | 2011981 | 2021-12-14 | Pasco | Florida | 12101 | 80464 | 1608 |
2008730 | 2008730 | 2021-12-13 | Pasco | Florida | 12101 | 80464 | 1597 |
2005479 | 2005479 | 2021-12-12 | Pasco | Florida | 12101 | 80464 | 1597 |
2002228 | 2002228 | 2021-12-11 | Pasco | Florida | 12101 | 80464 | 1597 |
1998978 | 1998978 | 2021-12-10 | Pasco | Florida | 12101 | 80464 | 1597 |
1995727 | 1995727 | 2021-12-09 | Pasco | Florida | 12101 | 80176 | 1597 |
1992476 | 1992476 | 2021-12-08 | Pasco | Florida | 12101 | 80176 | 1597 |
1989225 | 1989225 | 2021-12-07 | Pasco | Florida | 12101 | 80176 | 1582 |
1985975 | 1985975 | 2021-12-06 | Pasco | Florida | 12101 | 80176 | 1582 |
1982725 | 1982725 | 2021-12-05 | Pasco | Florida | 12101 | 80176 | 1582 |
1979475 | 1979475 | 2021-12-04 | Pasco | Florida | 12101 | 80176 | 1582 |
1976225 | 1976225 | 2021-12-03 | Pasco | Florida | 12101 | 80176 | 1582 |
1972976 | 1972976 | 2021-12-02 | Pasco | Florida | 12101 | 79942 | 1582 |
1969726 | 1969726 | 2021-12-01 | Pasco | Florida | 12101 | 79942 | 1582 |
1966476 | 1966476 | 2021-11-30 | Pasco | Florida | 12101 | 79942 | 1582 |
1963224 | 1963224 | 2021-11-29 | Pasco | Florida | 12101 | 79767 | 1582 |
1959973 | 1959973 | 2021-11-28 | Pasco | Florida | 12101 | 79767 | 1582 |
1956722 | 1956722 | 2021-11-27 | Pasco | Florida | 12101 | 79767 | 1582 |
1953471 | 1953471 | 2021-11-26 | Pasco | Florida | 12101 | 79767 | 1582 |
1950220 | 1950220 | 2021-11-25 | Pasco | Florida | 12101 | 79767 | 1582 |
1946969 | 1946969 | 2021-11-24 | Pasco | Florida | 12101 | 79767 | 1582 |
1943718 | 1943718 | 2021-11-23 | Pasco | Florida | 12101 | 79767 | 1582 |
1940468 | 1940468 | 2021-11-22 | Pasco | Florida | 12101 | 79767 | 1582 |
1937218 | 1937218 | 2021-11-21 | Pasco | Florida | 12101 | 79767 | 1582 |
1933968 | 1933968 | 2021-11-20 | Pasco | Florida | 12101 | 79767 | 1582 |
1930716 | 1930716 | 2021-11-19 | Pasco | Florida | 12101 | 79767 | 1576 |
1927466 | 1927466 | 2021-11-18 | Pasco | Florida | 12101 | 79553 | 1576 |
1924216 | 1924216 | 2021-11-17 | Pasco | Florida | 12101 | 79553 | 1576 |
1920967 | 1920967 | 2021-11-16 | Pasco | Florida | 12101 | 79553 | 1576 |
1917717 | 1917717 | 2021-11-15 | Pasco | Florida | 12101 | 79553 | 1576 |
1914467 | 1914467 | 2021-11-14 | Pasco | Florida | 12101 | 79553 | 1570 |
1911217 | 1911217 | 2021-11-13 | Pasco | Florida | 12101 | 79553 | 1570 |
1907968 | 1907968 | 2021-11-12 | Pasco | Florida | 12101 | 79553 | 1570 |
1904719 | 1904719 | 2021-11-11 | Pasco | Florida | 12101 | 79364 | 1570 |
1901469 | 1901469 | 2021-11-10 | Pasco | Florida | 12101 | 79364 | 1570 |
1898219 | 1898219 | 2021-11-09 | Pasco | Florida | 12101 | 79364 | 1570 |
1894969 | 1894969 | 2021-11-08 | Pasco | Florida | 12101 | 79364 | 1570 |
1891719 | 1891719 | 2021-11-07 | Pasco | Florida | 12101 | 79364 | 1555 |
1888469 | 1888469 | 2021-11-06 | Pasco | Florida | 12101 | 79364 | 1555 |
1885219 | 1885219 | 2021-11-05 | Pasco | Florida | 12101 | 79364 | 1555 |
1881970 | 1881970 | 2021-11-04 | Pasco | Florida | 12101 | 79142 | 1555 |
1878721 | 1878721 | 2021-11-03 | Pasco | Florida | 12101 | 79142 | 1555 |
1875472 | 1875472 | 2021-11-02 | Pasco | Florida | 12101 | 79142 | 1555 |
1872223 | 1872223 | 2021-11-01 | Pasco | Florida | 12101 | 79142 | 1555 |
1868974 | 1868974 | 2021-10-31 | Pasco | Florida | 12101 | 79142 | 1555 |
1865725 | 1865725 | 2021-10-30 | Pasco | Florida | 12101 | 79142 | 1539 |
1862476 | 1862476 | 2021-10-29 | Pasco | Florida | 12101 | 79142 | 1539 |
1859227 | 1859227 | 2021-10-28 | Pasco | Florida | 12101 | 78907 | 1539 |
1855978 | 1855978 | 2021-10-27 | Pasco | Florida | 12101 | 78907 | 1539 |
1852729 | 1852729 | 2021-10-26 | Pasco | Florida | 12101 | 78907 | 1539 |
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);