ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 34039 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176007 | 2176007 | 2022-02-02 | Union | New Jersey | 34039 | 137767 | 2228 |
2172754 | 2172754 | 2022-02-01 | Union | New Jersey | 34039 | 137515 | 2224 |
2169501 | 2169501 | 2022-01-31 | Union | New Jersey | 34039 | 137326 | 2217 |
2166246 | 2166246 | 2022-01-30 | Union | New Jersey | 34039 | 137232 | 2216 |
2162991 | 2162991 | 2022-01-29 | Union | New Jersey | 34039 | 137171 | 2213 |
2159736 | 2159736 | 2022-01-28 | Union | New Jersey | 34039 | 136917 | 2207 |
2156482 | 2156482 | 2022-01-27 | Union | New Jersey | 34039 | 136582 | 2203 |
2153229 | 2153229 | 2022-01-26 | Union | New Jersey | 34039 | 136298 | 2200 |
2149977 | 2149977 | 2022-01-25 | Union | New Jersey | 34039 | 135824 | 2194 |
2146725 | 2146725 | 2022-01-24 | Union | New Jersey | 34039 | 135549 | 2189 |
2143470 | 2143470 | 2022-01-23 | Union | New Jersey | 34039 | 135340 | 2189 |
2140215 | 2140215 | 2022-01-22 | Union | New Jersey | 34039 | 135061 | 2188 |
2136959 | 2136959 | 2022-01-21 | Union | New Jersey | 34039 | 134636 | 2182 |
2133707 | 2133707 | 2022-01-20 | Union | New Jersey | 34039 | 133807 | 2177 |
2130454 | 2130454 | 2022-01-19 | Union | New Jersey | 34039 | 133231 | 2168 |
2127200 | 2127200 | 2022-01-18 | Union | New Jersey | 34039 | 132783 | 2153 |
2123948 | 2123948 | 2022-01-17 | Union | New Jersey | 34039 | 132211 | 2149 |
2120696 | 2120696 | 2022-01-16 | Union | New Jersey | 34039 | 131744 | 2147 |
2117444 | 2117444 | 2022-01-15 | Union | New Jersey | 34039 | 130991 | 2145 |
2114193 | 2114193 | 2022-01-14 | Union | New Jersey | 34039 | 130217 | 2132 |
2110941 | 2110941 | 2022-01-13 | Union | New Jersey | 34039 | 129031 | 2131 |
2107690 | 2107690 | 2022-01-12 | Union | New Jersey | 34039 | 127888 | 2126 |
2104439 | 2104439 | 2022-01-11 | Union | New Jersey | 34039 | 126609 | 2119 |
2101188 | 2101188 | 2022-01-10 | Union | New Jersey | 34039 | 125035 | 2113 |
2097937 | 2097937 | 2022-01-09 | Union | New Jersey | 34039 | 123547 | 2111 |
2094685 | 2094685 | 2022-01-08 | Union | New Jersey | 34039 | 121842 | 2111 |
2091433 | 2091433 | 2022-01-07 | Union | New Jersey | 34039 | 119799 | 2105 |
2088182 | 2088182 | 2022-01-06 | Union | New Jersey | 34039 | 117627 | 2099 |
2084930 | 2084930 | 2022-01-05 | Union | New Jersey | 34039 | 115027 | 2092 |
2081678 | 2081678 | 2022-01-04 | Union | New Jersey | 34039 | 112647 | 2086 |
2078426 | 2078426 | 2022-01-03 | Union | New Jersey | 34039 | 110722 | 2082 |
2075175 | 2075175 | 2022-01-02 | Union | New Jersey | 34039 | 109307 | 2082 |
2071924 | 2071924 | 2022-01-01 | Union | New Jersey | 34039 | 107164 | 2082 |
2068673 | 2068673 | 2021-12-31 | Union | New Jersey | 34039 | 104695 | 2082 |
2065422 | 2065422 | 2021-12-30 | Union | New Jersey | 34039 | 101935 | 2081 |
2062172 | 2062172 | 2021-12-29 | Union | New Jersey | 34039 | 98914 | 2080 |
2058923 | 2058923 | 2021-12-28 | Union | New Jersey | 34039 | 96835 | 2077 |
2055674 | 2055674 | 2021-12-27 | Union | New Jersey | 34039 | 95672 | 2076 |
2052424 | 2052424 | 2021-12-26 | Union | New Jersey | 34039 | 94945 | 2077 |
2049174 | 2049174 | 2021-12-25 | Union | New Jersey | 34039 | 93777 | 2077 |
2045924 | 2045924 | 2021-12-24 | Union | New Jersey | 34039 | 92275 | 2077 |
2042674 | 2042674 | 2021-12-23 | Union | New Jersey | 34039 | 90695 | 2075 |
2039425 | 2039425 | 2021-12-22 | Union | New Jersey | 34039 | 89213 | 2072 |
2036175 | 2036175 | 2021-12-21 | Union | New Jersey | 34039 | 88377 | 2070 |
2032925 | 2032925 | 2021-12-20 | Union | New Jersey | 34039 | 87798 | 2069 |
2029674 | 2029674 | 2021-12-19 | Union | New Jersey | 34039 | 87336 | 2069 |
2026423 | 2026423 | 2021-12-18 | Union | New Jersey | 34039 | 86756 | 2069 |
2023172 | 2023172 | 2021-12-17 | Union | New Jersey | 34039 | 86222 | 2066 |
2019921 | 2019921 | 2021-12-16 | Union | New Jersey | 34039 | 85745 | 2066 |
2016671 | 2016671 | 2021-12-15 | Union | New Jersey | 34039 | 85337 | 2066 |
2013420 | 2013420 | 2021-12-14 | Union | New Jersey | 34039 | 85079 | 2066 |
2010169 | 2010169 | 2021-12-13 | Union | New Jersey | 34039 | 84798 | 2065 |
2006918 | 2006918 | 2021-12-12 | Union | New Jersey | 34039 | 84628 | 2065 |
2003667 | 2003667 | 2021-12-11 | Union | New Jersey | 34039 | 84447 | 2065 |
2000417 | 2000417 | 2021-12-10 | Union | New Jersey | 34039 | 84202 | 2065 |
1997166 | 1997166 | 2021-12-09 | Union | New Jersey | 34039 | 83950 | 2061 |
1993915 | 1993915 | 2021-12-08 | Union | New Jersey | 34039 | 83625 | 2061 |
1990664 | 1990664 | 2021-12-07 | Union | New Jersey | 34039 | 83414 | 2060 |
1987414 | 1987414 | 2021-12-06 | Union | New Jersey | 34039 | 83186 | 2060 |
1984164 | 1984164 | 2021-12-05 | Union | New Jersey | 34039 | 83073 | 2060 |
1980914 | 1980914 | 2021-12-04 | Union | New Jersey | 34039 | 82919 | 2060 |
1977664 | 1977664 | 2021-12-03 | Union | New Jersey | 34039 | 82711 | 2058 |
1974414 | 1974414 | 2021-12-02 | Union | New Jersey | 34039 | 82467 | 2057 |
1971165 | 1971165 | 2021-12-01 | Union | New Jersey | 34039 | 82230 | 2057 |
1967915 | 1967915 | 2021-11-30 | Union | New Jersey | 34039 | 82114 | 2057 |
1964663 | 1964663 | 2021-11-29 | Union | New Jersey | 34039 | 81953 | 2055 |
1961412 | 1961412 | 2021-11-28 | Union | New Jersey | 34039 | 81879 | 2055 |
1958161 | 1958161 | 2021-11-27 | Union | New Jersey | 34039 | 81803 | 2055 |
1954910 | 1954910 | 2021-11-26 | Union | New Jersey | 34039 | 81677 | 2054 |
1951659 | 1951659 | 2021-11-25 | Union | New Jersey | 34039 | 81596 | 2054 |
1948408 | 1948408 | 2021-11-24 | Union | New Jersey | 34039 | 81477 | 2052 |
1945157 | 1945157 | 2021-11-23 | Union | New Jersey | 34039 | 81353 | 2053 |
1941906 | 1941906 | 2021-11-22 | Union | New Jersey | 34039 | 81230 | 2053 |
1938656 | 1938656 | 2021-11-21 | Union | New Jersey | 34039 | 81145 | 2052 |
1935406 | 1935406 | 2021-11-20 | Union | New Jersey | 34039 | 81080 | 2052 |
1932156 | 1932156 | 2021-11-19 | Union | New Jersey | 34039 | 80991 | 2052 |
1928905 | 1928905 | 2021-11-18 | Union | New Jersey | 34039 | 80892 | 2052 |
1925655 | 1925655 | 2021-11-17 | Union | New Jersey | 34039 | 80784 | 2052 |
1922406 | 1922406 | 2021-11-16 | Union | New Jersey | 34039 | 80694 | 2052 |
1919156 | 1919156 | 2021-11-15 | Union | New Jersey | 34039 | 80628 | 2051 |
1915906 | 1915906 | 2021-11-14 | Union | New Jersey | 34039 | 80574 | 2051 |
1912656 | 1912656 | 2021-11-13 | Union | New Jersey | 34039 | 80510 | 2051 |
1909406 | 1909406 | 2021-11-12 | Union | New Jersey | 34039 | 80443 | 2051 |
1906157 | 1906157 | 2021-11-11 | Union | New Jersey | 34039 | 80355 | 2049 |
1902908 | 1902908 | 2021-11-10 | Union | New Jersey | 34039 | 80260 | 2048 |
1899658 | 1899658 | 2021-11-09 | Union | New Jersey | 34039 | 80206 | 2048 |
1896408 | 1896408 | 2021-11-08 | Union | New Jersey | 34039 | 80134 | 2048 |
1893158 | 1893158 | 2021-11-07 | Union | New Jersey | 34039 | 80099 | 2048 |
1889908 | 1889908 | 2021-11-06 | Union | New Jersey | 34039 | 80057 | 2048 |
1886658 | 1886658 | 2021-11-05 | Union | New Jersey | 34039 | 79992 | 2048 |
1883409 | 1883409 | 2021-11-04 | Union | New Jersey | 34039 | 79926 | 2044 |
1880160 | 1880160 | 2021-11-03 | Union | New Jersey | 34039 | 79865 | 2044 |
1876911 | 1876911 | 2021-11-02 | Union | New Jersey | 34039 | 79813 | 2044 |
1873662 | 1873662 | 2021-11-01 | Union | New Jersey | 34039 | 79767 | 2044 |
1870413 | 1870413 | 2021-10-31 | Union | New Jersey | 34039 | 79726 | 2044 |
1867164 | 1867164 | 2021-10-30 | Union | New Jersey | 34039 | 79683 | 2044 |
1863915 | 1863915 | 2021-10-29 | Union | New Jersey | 34039 | 79622 | 2044 |
1860666 | 1860666 | 2021-10-28 | Union | New Jersey | 34039 | 79593 | 2044 |
1857417 | 1857417 | 2021-10-27 | Union | New Jersey | 34039 | 79531 | 2044 |
1854168 | 1854168 | 2021-10-26 | Union | New Jersey | 34039 | 79476 | 2043 |
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);