ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Fresno" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946792 | 1946792 | 2021-11-24 | Fresno | California | 6019 | 155899 | 2246 |
1943541 | 1943541 | 2021-11-23 | Fresno | California | 6019 | 155803 | 2243 |
1940291 | 1940291 | 2021-11-22 | Fresno | California | 6019 | 155716 | 2242 |
1937041 | 1937041 | 2021-11-21 | Fresno | California | 6019 | 155092 | 2233 |
1933791 | 1933791 | 2021-11-20 | Fresno | California | 6019 | 155092 | 2233 |
1930539 | 1930539 | 2021-11-19 | Fresno | California | 6019 | 155092 | 2233 |
1927289 | 1927289 | 2021-11-18 | Fresno | California | 6019 | 154879 | 2230 |
1924039 | 1924039 | 2021-11-17 | Fresno | California | 6019 | 154588 | 2218 |
1920790 | 1920790 | 2021-11-16 | Fresno | California | 6019 | 154403 | 2210 |
1917540 | 1917540 | 2021-11-15 | Fresno | California | 6019 | 154257 | 2209 |
1914290 | 1914290 | 2021-11-14 | Fresno | California | 6019 | 153840 | 2205 |
1911040 | 1911040 | 2021-11-13 | Fresno | California | 6019 | 153840 | 2205 |
1907791 | 1907791 | 2021-11-12 | Fresno | California | 6019 | 153221 | 2202 |
1904542 | 1904542 | 2021-11-11 | Fresno | California | 6019 | 153221 | 2202 |
1901292 | 1901292 | 2021-11-10 | Fresno | California | 6019 | 152930 | 2188 |
1898042 | 1898042 | 2021-11-09 | Fresno | California | 6019 | 152730 | 2179 |
1894792 | 1894792 | 2021-11-08 | Fresno | California | 6019 | 152527 | 2179 |
1891542 | 1891542 | 2021-11-07 | Fresno | California | 6019 | 151513 | 2170 |
1888292 | 1888292 | 2021-11-06 | Fresno | California | 6019 | 151513 | 2170 |
1885042 | 1885042 | 2021-11-05 | Fresno | California | 6019 | 151513 | 2170 |
1881793 | 1881793 | 2021-11-04 | Fresno | California | 6019 | 151137 | 2166 |
1878544 | 1878544 | 2021-11-03 | Fresno | California | 6019 | 150681 | 2158 |
1875295 | 1875295 | 2021-11-02 | Fresno | California | 6019 | 150458 | 2149 |
1872046 | 1872046 | 2021-11-01 | Fresno | California | 6019 | 150202 | 2147 |
1868797 | 1868797 | 2021-10-31 | Fresno | California | 6019 | 148938 | 2131 |
1865548 | 1865548 | 2021-10-30 | Fresno | California | 6019 | 148938 | 2131 |
1862299 | 1862299 | 2021-10-29 | Fresno | California | 6019 | 148938 | 2131 |
1859050 | 1859050 | 2021-10-28 | Fresno | California | 6019 | 148484 | 2128 |
1855801 | 1855801 | 2021-10-27 | Fresno | California | 6019 | 148063 | 2122 |
1852552 | 1852552 | 2021-10-26 | Fresno | California | 6019 | 147826 | 2112 |
1849303 | 1849303 | 2021-10-25 | Fresno | California | 6019 | 146318 | 2094 |
1846053 | 1846053 | 2021-10-24 | Fresno | California | 6019 | 146318 | 2094 |
1842803 | 1842803 | 2021-10-23 | Fresno | California | 6019 | 146318 | 2094 |
1839553 | 1839553 | 2021-10-22 | Fresno | California | 6019 | 146318 | 2094 |
1836304 | 1836304 | 2021-10-21 | Fresno | California | 6019 | 145877 | 2084 |
1833055 | 1833055 | 2021-10-20 | Fresno | California | 6019 | 145503 | 2073 |
1829806 | 1829806 | 2021-10-19 | Fresno | California | 6019 | 145378 | 2063 |
1826557 | 1826557 | 2021-10-18 | Fresno | California | 6019 | 145119 | 2063 |
1823308 | 1823308 | 2021-10-17 | Fresno | California | 6019 | 144123 | 2051 |
1820059 | 1820059 | 2021-10-16 | Fresno | California | 6019 | 144123 | 2051 |
1816810 | 1816810 | 2021-10-15 | Fresno | California | 6019 | 144123 | 2051 |
1813562 | 1813562 | 2021-10-14 | Fresno | California | 6019 | 143745 | 2048 |
1810313 | 1810313 | 2021-10-13 | Fresno | California | 6019 | 143365 | 2042 |
1807064 | 1807064 | 2021-10-12 | Fresno | California | 6019 | 143220 | 2036 |
1803813 | 1803813 | 2021-10-11 | Fresno | California | 6019 | 142951 | 2035 |
1800564 | 1800564 | 2021-10-10 | Fresno | California | 6019 | 142025 | 2018 |
1797315 | 1797315 | 2021-10-09 | Fresno | California | 6019 | 142025 | 2018 |
1794066 | 1794066 | 2021-10-08 | Fresno | California | 6019 | 142025 | 2018 |
1790818 | 1790818 | 2021-10-07 | Fresno | California | 6019 | 141591 | 2008 |
1787569 | 1787569 | 2021-10-06 | Fresno | California | 6019 | 141242 | 1987 |
1784320 | 1784320 | 2021-10-05 | Fresno | California | 6019 | 140950 | 1978 |
1781071 | 1781071 | 2021-10-04 | Fresno | California | 6019 | 140650 | 1978 |
1777821 | 1777821 | 2021-10-03 | Fresno | California | 6019 | 139735 | 1964 |
1774571 | 1774571 | 2021-10-02 | Fresno | California | 6019 | 139735 | 1964 |
1771321 | 1771321 | 2021-10-01 | Fresno | California | 6019 | 139735 | 1964 |
1768072 | 1768072 | 2021-09-30 | Fresno | California | 6019 | 139353 | 1957 |
1764823 | 1764823 | 2021-09-29 | Fresno | California | 6019 | 138965 | 1948 |
1761574 | 1761574 | 2021-09-28 | Fresno | California | 6019 | 138563 | 1942 |
1758326 | 1758326 | 2021-09-27 | Fresno | California | 6019 | 138323 | 1939 |
1755078 | 1755078 | 2021-09-26 | Fresno | California | 6019 | 137387 | 1927 |
1751830 | 1751830 | 2021-09-25 | Fresno | California | 6019 | 137387 | 1927 |
1748581 | 1748581 | 2021-09-24 | Fresno | California | 6019 | 137387 | 1927 |
1745331 | 1745331 | 2021-09-23 | Fresno | California | 6019 | 137094 | 1908 |
1742082 | 1742082 | 2021-09-22 | Fresno | California | 6019 | 136665 | 1892 |
1738833 | 1738833 | 2021-09-21 | Fresno | California | 6019 | 136163 | 1889 |
1735584 | 1735584 | 2021-09-20 | Fresno | California | 6019 | 135861 | 1888 |
1732334 | 1732334 | 2021-09-19 | Fresno | California | 6019 | 135647 | 1889 |
1729084 | 1729084 | 2021-09-18 | Fresno | California | 6019 | 135172 | 1882 |
1725834 | 1725834 | 2021-09-17 | Fresno | California | 6019 | 134729 | 1868 |
1722585 | 1722585 | 2021-09-16 | Fresno | California | 6019 | 134246 | 1867 |
1719336 | 1719336 | 2021-09-15 | Fresno | California | 6019 | 133773 | 1856 |
1716088 | 1716088 | 2021-09-14 | Fresno | California | 6019 | 133272 | 1853 |
1712842 | 1712842 | 2021-09-13 | Fresno | California | 6019 | 133029 | 1853 |
1709595 | 1709595 | 2021-09-12 | Fresno | California | 6019 | 132846 | 1853 |
1706348 | 1706348 | 2021-09-11 | Fresno | California | 6019 | 132281 | 1846 |
1703100 | 1703100 | 2021-09-10 | Fresno | California | 6019 | 131662 | 1838 |
1699850 | 1699850 | 2021-09-09 | Fresno | California | 6019 | 131266 | 1831 |
1696601 | 1696601 | 2021-09-08 | Fresno | California | 6019 | 130757 | 1828 |
1693353 | 1693353 | 2021-09-07 | Fresno | California | 6019 | 130227 | 1828 |
1690104 | 1690104 | 2021-09-06 | Fresno | California | 6019 | 129873 | 1828 |
1686854 | 1686854 | 2021-09-05 | Fresno | California | 6019 | 129522 | 1828 |
1683604 | 1683604 | 2021-09-04 | Fresno | California | 6019 | 128997 | 1822 |
1680353 | 1680353 | 2021-09-03 | Fresno | California | 6019 | 128463 | 1804 |
1677105 | 1677105 | 2021-09-02 | Fresno | California | 6019 | 127981 | 1800 |
1673858 | 1673858 | 2021-09-01 | Fresno | California | 6019 | 127396 | 1801 |
1670610 | 1670610 | 2021-08-31 | Fresno | California | 6019 | 126108 | 1790 |
1667363 | 1667363 | 2021-08-30 | Fresno | California | 6019 | 125743 | 1790 |
1664116 | 1664116 | 2021-08-29 | Fresno | California | 6019 | 125320 | 1792 |
1660868 | 1660868 | 2021-08-28 | Fresno | California | 6019 | 124722 | 1774 |
1657620 | 1657620 | 2021-08-27 | Fresno | California | 6019 | 124095 | 1770 |
1654372 | 1654372 | 2021-08-26 | Fresno | California | 6019 | 123625 | 1761 |
1651125 | 1651125 | 2021-08-25 | Fresno | California | 6019 | 123026 | 1761 |
1647876 | 1647876 | 2021-08-24 | Fresno | California | 6019 | 122447 | 1759 |
1644628 | 1644628 | 2021-08-23 | Fresno | California | 6019 | 122059 | 1759 |
1641378 | 1641378 | 2021-08-22 | Fresno | California | 6019 | 121767 | 1759 |
1638128 | 1638128 | 2021-08-21 | Fresno | California | 6019 | 121317 | 1759 |
1634878 | 1634878 | 2021-08-20 | Fresno | California | 6019 | 120949 | 1759 |
1631629 | 1631629 | 2021-08-19 | Fresno | California | 6019 | 120525 | 1759 |
1628382 | 1628382 | 2021-08-18 | Fresno | California | 6019 | 119941 | 1755 |
1625135 | 1625135 | 2021-08-17 | Fresno | California | 6019 | 119301 | 1753 |
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);