ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176510 | 2176510 | 2022-02-02 | Northampton | Pennsylvania | 42095 | 77204 | 1011 |
2173256 | 2173256 | 2022-02-01 | Northampton | Pennsylvania | 42095 | 77061 | 1009 |
2170004 | 2170004 | 2022-01-31 | Northampton | Pennsylvania | 42095 | 76968 | 1003 |
2166750 | 2166750 | 2022-01-30 | Northampton | Pennsylvania | 42095 | 76847 | 1003 |
2163495 | 2163495 | 2022-01-29 | Northampton | Pennsylvania | 42095 | 76664 | 1003 |
2160240 | 2160240 | 2022-01-28 | Northampton | Pennsylvania | 42095 | 76508 | 996 |
2156984 | 2156984 | 2022-01-27 | Northampton | Pennsylvania | 42095 | 76210 | 991 |
2153731 | 2153731 | 2022-01-26 | Northampton | Pennsylvania | 42095 | 75826 | 978 |
2150479 | 2150479 | 2022-01-25 | Northampton | Pennsylvania | 42095 | 75544 | 971 |
2147227 | 2147227 | 2022-01-24 | Northampton | Pennsylvania | 42095 | 75269 | 963 |
2143973 | 2143973 | 2022-01-23 | Northampton | Pennsylvania | 42095 | 75154 | 963 |
2140718 | 2140718 | 2022-01-22 | Northampton | Pennsylvania | 42095 | 74876 | 961 |
2137462 | 2137462 | 2022-01-21 | Northampton | Pennsylvania | 42095 | 74410 | 957 |
2134208 | 2134208 | 2022-01-20 | Northampton | Pennsylvania | 42095 | 73982 | 950 |
2130956 | 2130956 | 2022-01-19 | Northampton | Pennsylvania | 42095 | 73679 | 939 |
2127702 | 2127702 | 2022-01-18 | Northampton | Pennsylvania | 42095 | 73365 | 936 |
2124450 | 2124450 | 2022-01-17 | Northampton | Pennsylvania | 42095 | 73080 | 935 |
2121198 | 2121198 | 2022-01-16 | Northampton | Pennsylvania | 42095 | 72729 | 935 |
2117946 | 2117946 | 2022-01-15 | Northampton | Pennsylvania | 42095 | 71600 | 935 |
2114695 | 2114695 | 2022-01-14 | Northampton | Pennsylvania | 42095 | 71205 | 931 |
2111443 | 2111443 | 2022-01-13 | Northampton | Pennsylvania | 42095 | 70436 | 927 |
2108191 | 2108191 | 2022-01-12 | Northampton | Pennsylvania | 42095 | 69717 | 923 |
2104940 | 2104940 | 2022-01-11 | Northampton | Pennsylvania | 42095 | 68678 | 915 |
2101689 | 2101689 | 2022-01-10 | Northampton | Pennsylvania | 42095 | 67302 | 907 |
2098438 | 2098438 | 2022-01-09 | Northampton | Pennsylvania | 42095 | 66238 | 907 |
2095186 | 2095186 | 2022-01-08 | Northampton | Pennsylvania | 42095 | 65337 | 906 |
2091934 | 2091934 | 2022-01-07 | Northampton | Pennsylvania | 42095 | 64193 | 903 |
2088682 | 2088682 | 2022-01-06 | Northampton | Pennsylvania | 42095 | 63189 | 899 |
2085431 | 2085431 | 2022-01-05 | Northampton | Pennsylvania | 42095 | 62242 | 890 |
2082179 | 2082179 | 2022-01-04 | Northampton | Pennsylvania | 42095 | 61669 | 886 |
2078927 | 2078927 | 2022-01-03 | Northampton | Pennsylvania | 42095 | 61091 | 884 |
2075676 | 2075676 | 2022-01-02 | Northampton | Pennsylvania | 42095 | 60175 | 882 |
2072425 | 2072425 | 2022-01-01 | Northampton | Pennsylvania | 42095 | 59540 | 882 |
2069174 | 2069174 | 2021-12-31 | Northampton | Pennsylvania | 42095 | 58875 | 882 |
2065923 | 2065923 | 2021-12-30 | Northampton | Pennsylvania | 42095 | 57829 | 879 |
2062673 | 2062673 | 2021-12-29 | Northampton | Pennsylvania | 42095 | 57463 | 876 |
2059423 | 2059423 | 2021-12-28 | Northampton | Pennsylvania | 42095 | 57047 | 865 |
2056174 | 2056174 | 2021-12-27 | Northampton | Pennsylvania | 42095 | 56419 | 863 |
2052925 | 2052925 | 2021-12-26 | Northampton | Pennsylvania | 42095 | 56143 | 863 |
2049675 | 2049675 | 2021-12-25 | Northampton | Pennsylvania | 42095 | 55726 | 863 |
2046425 | 2046425 | 2021-12-24 | Northampton | Pennsylvania | 42095 | 55301 | 863 |
2043175 | 2043175 | 2021-12-23 | Northampton | Pennsylvania | 42095 | 54959 | 861 |
2039926 | 2039926 | 2021-12-22 | Northampton | Pennsylvania | 42095 | 54646 | 859 |
2036676 | 2036676 | 2021-12-21 | Northampton | Pennsylvania | 42095 | 54387 | 854 |
2033426 | 2033426 | 2021-12-20 | Northampton | Pennsylvania | 42095 | 54047 | 852 |
2030176 | 2030176 | 2021-12-19 | Northampton | Pennsylvania | 42095 | 53806 | 852 |
2026925 | 2026925 | 2021-12-18 | Northampton | Pennsylvania | 42095 | 53535 | 852 |
2023674 | 2023674 | 2021-12-17 | Northampton | Pennsylvania | 42095 | 53179 | 847 |
2020423 | 2020423 | 2021-12-16 | Northampton | Pennsylvania | 42095 | 52929 | 845 |
2017172 | 2017172 | 2021-12-15 | Northampton | Pennsylvania | 42095 | 52581 | 842 |
2013922 | 2013922 | 2021-12-14 | Northampton | Pennsylvania | 42095 | 52376 | 838 |
2010671 | 2010671 | 2021-12-13 | Northampton | Pennsylvania | 42095 | 52131 | 836 |
2007420 | 2007420 | 2021-12-12 | Northampton | Pennsylvania | 42095 | 51917 | 836 |
2004169 | 2004169 | 2021-12-11 | Northampton | Pennsylvania | 42095 | 51563 | 836 |
2000918 | 2000918 | 2021-12-10 | Northampton | Pennsylvania | 42095 | 51178 | 834 |
1997668 | 1997668 | 2021-12-09 | Northampton | Pennsylvania | 42095 | 50768 | 831 |
1994417 | 1994417 | 2021-12-08 | Northampton | Pennsylvania | 42095 | 50581 | 829 |
1991166 | 1991166 | 2021-12-07 | Northampton | Pennsylvania | 42095 | 50386 | 828 |
1987915 | 1987915 | 2021-12-06 | Northampton | Pennsylvania | 42095 | 50144 | 825 |
1984665 | 1984665 | 2021-12-05 | Northampton | Pennsylvania | 42095 | 49958 | 824 |
1981415 | 1981415 | 2021-12-04 | Northampton | Pennsylvania | 42095 | 49658 | 824 |
1978165 | 1978165 | 2021-12-03 | Northampton | Pennsylvania | 42095 | 49326 | 822 |
1974915 | 1974915 | 2021-12-02 | Northampton | Pennsylvania | 42095 | 48992 | 821 |
1971666 | 1971666 | 2021-12-01 | Northampton | Pennsylvania | 42095 | 48668 | 819 |
1968416 | 1968416 | 2021-11-30 | Northampton | Pennsylvania | 42095 | 48548 | 816 |
1965165 | 1965165 | 2021-11-29 | Northampton | Pennsylvania | 42095 | 48397 | 815 |
1961913 | 1961913 | 2021-11-28 | Northampton | Pennsylvania | 42095 | 48274 | 815 |
1958662 | 1958662 | 2021-11-27 | Northampton | Pennsylvania | 42095 | 48147 | 815 |
1955411 | 1955411 | 2021-11-26 | Northampton | Pennsylvania | 42095 | 48053 | 815 |
1952160 | 1952160 | 2021-11-25 | Northampton | Pennsylvania | 42095 | 47879 | 815 |
1948909 | 1948909 | 2021-11-24 | Northampton | Pennsylvania | 42095 | 47741 | 813 |
1945658 | 1945658 | 2021-11-23 | Northampton | Pennsylvania | 42095 | 47586 | 809 |
1942407 | 1942407 | 2021-11-22 | Northampton | Pennsylvania | 42095 | 47373 | 809 |
1939157 | 1939157 | 2021-11-21 | Northampton | Pennsylvania | 42095 | 47261 | 809 |
1935907 | 1935907 | 2021-11-20 | Northampton | Pennsylvania | 42095 | 47162 | 809 |
1932657 | 1932657 | 2021-11-19 | Northampton | Pennsylvania | 42095 | 47038 | 809 |
1929406 | 1929406 | 2021-11-18 | Northampton | Pennsylvania | 42095 | 46886 | 808 |
1926156 | 1926156 | 2021-11-17 | Northampton | Pennsylvania | 42095 | 46724 | 807 |
1922906 | 1922906 | 2021-11-16 | Northampton | Pennsylvania | 42095 | 46580 | 807 |
1919657 | 1919657 | 2021-11-15 | Northampton | Pennsylvania | 42095 | 46424 | 806 |
1916407 | 1916407 | 2021-11-14 | Northampton | Pennsylvania | 42095 | 46375 | 806 |
1913157 | 1913157 | 2021-11-13 | Northampton | Pennsylvania | 42095 | 46286 | 805 |
1909907 | 1909907 | 2021-11-12 | Northampton | Pennsylvania | 42095 | 45756 | 805 |
1906658 | 1906658 | 2021-11-11 | Northampton | Pennsylvania | 42095 | 45639 | 805 |
1903409 | 1903409 | 2021-11-10 | Northampton | Pennsylvania | 42095 | 45510 | 804 |
1900159 | 1900159 | 2021-11-09 | Northampton | Pennsylvania | 42095 | 45441 | 802 |
1896909 | 1896909 | 2021-11-08 | Northampton | Pennsylvania | 42095 | 45319 | 801 |
1893659 | 1893659 | 2021-11-07 | Northampton | Pennsylvania | 42095 | 45260 | 801 |
1890409 | 1890409 | 2021-11-06 | Northampton | Pennsylvania | 42095 | 45199 | 801 |
1887159 | 1887159 | 2021-11-05 | Northampton | Pennsylvania | 42095 | 45082 | 801 |
1883909 | 1883909 | 2021-11-04 | Northampton | Pennsylvania | 42095 | 44996 | 798 |
1880660 | 1880660 | 2021-11-03 | Northampton | Pennsylvania | 42095 | 44897 | 798 |
1877411 | 1877411 | 2021-11-02 | Northampton | Pennsylvania | 42095 | 44856 | 795 |
1874162 | 1874162 | 2021-11-01 | Northampton | Pennsylvania | 42095 | 44694 | 795 |
1870913 | 1870913 | 2021-10-31 | Northampton | Pennsylvania | 42095 | 44694 | 795 |
1867664 | 1867664 | 2021-10-30 | Northampton | Pennsylvania | 42095 | 44645 | 794 |
1864415 | 1864415 | 2021-10-29 | Northampton | Pennsylvania | 42095 | 44571 | 794 |
1861166 | 1861166 | 2021-10-28 | Northampton | Pennsylvania | 42095 | 44490 | 794 |
1857917 | 1857917 | 2021-10-27 | Northampton | Pennsylvania | 42095 | 44377 | 793 |
1854668 | 1854668 | 2021-10-26 | Northampton | Pennsylvania | 42095 | 44320 | 790 |
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);