ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 34019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175997 | 2175997 | 2022-02-02 | Hunterdon | New Jersey | 34019 | 23474 | 252 |
2172744 | 2172744 | 2022-02-01 | Hunterdon | New Jersey | 34019 | 23413 | 248 |
2169491 | 2169491 | 2022-01-31 | Hunterdon | New Jersey | 34019 | 23378 | 247 |
2166236 | 2166236 | 2022-01-30 | Hunterdon | New Jersey | 34019 | 23346 | 247 |
2162981 | 2162981 | 2022-01-29 | Hunterdon | New Jersey | 34019 | 23299 | 247 |
2159726 | 2159726 | 2022-01-28 | Hunterdon | New Jersey | 34019 | 23191 | 245 |
2156472 | 2156472 | 2022-01-27 | Hunterdon | New Jersey | 34019 | 23093 | 243 |
2153219 | 2153219 | 2022-01-26 | Hunterdon | New Jersey | 34019 | 22960 | 243 |
2149967 | 2149967 | 2022-01-25 | Hunterdon | New Jersey | 34019 | 22899 | 242 |
2146715 | 2146715 | 2022-01-24 | Hunterdon | New Jersey | 34019 | 22808 | 234 |
2143460 | 2143460 | 2022-01-23 | Hunterdon | New Jersey | 34019 | 22730 | 232 |
2140205 | 2140205 | 2022-01-22 | Hunterdon | New Jersey | 34019 | 22651 | 232 |
2136949 | 2136949 | 2022-01-21 | Hunterdon | New Jersey | 34019 | 22545 | 229 |
2133697 | 2133697 | 2022-01-20 | Hunterdon | New Jersey | 34019 | 22361 | 226 |
2130444 | 2130444 | 2022-01-19 | Hunterdon | New Jersey | 34019 | 22209 | 222 |
2127190 | 2127190 | 2022-01-18 | Hunterdon | New Jersey | 34019 | 22087 | 221 |
2123938 | 2123938 | 2022-01-17 | Hunterdon | New Jersey | 34019 | 21914 | 221 |
2120686 | 2120686 | 2022-01-16 | Hunterdon | New Jersey | 34019 | 21836 | 220 |
2117434 | 2117434 | 2022-01-15 | Hunterdon | New Jersey | 34019 | 21660 | 220 |
2114183 | 2114183 | 2022-01-14 | Hunterdon | New Jersey | 34019 | 21410 | 217 |
2110931 | 2110931 | 2022-01-13 | Hunterdon | New Jersey | 34019 | 21006 | 216 |
2107680 | 2107680 | 2022-01-12 | Hunterdon | New Jersey | 34019 | 20787 | 214 |
2104429 | 2104429 | 2022-01-11 | Hunterdon | New Jersey | 34019 | 20463 | 212 |
2101178 | 2101178 | 2022-01-10 | Hunterdon | New Jersey | 34019 | 20071 | 210 |
2097927 | 2097927 | 2022-01-09 | Hunterdon | New Jersey | 34019 | 19705 | 210 |
2094675 | 2094675 | 2022-01-08 | Hunterdon | New Jersey | 34019 | 19417 | 209 |
2091423 | 2091423 | 2022-01-07 | Hunterdon | New Jersey | 34019 | 19055 | 209 |
2088172 | 2088172 | 2022-01-06 | Hunterdon | New Jersey | 34019 | 18503 | 210 |
2084920 | 2084920 | 2022-01-05 | Hunterdon | New Jersey | 34019 | 18150 | 207 |
2081668 | 2081668 | 2022-01-04 | Hunterdon | New Jersey | 34019 | 17685 | 204 |
2078416 | 2078416 | 2022-01-03 | Hunterdon | New Jersey | 34019 | 17177 | 203 |
2075165 | 2075165 | 2022-01-02 | Hunterdon | New Jersey | 34019 | 16975 | 202 |
2071914 | 2071914 | 2022-01-01 | Hunterdon | New Jersey | 34019 | 16697 | 201 |
2068663 | 2068663 | 2021-12-31 | Hunterdon | New Jersey | 34019 | 16354 | 200 |
2065412 | 2065412 | 2021-12-30 | Hunterdon | New Jersey | 34019 | 16074 | 200 |
2062162 | 2062162 | 2021-12-29 | Hunterdon | New Jersey | 34019 | 15817 | 199 |
2058913 | 2058913 | 2021-12-28 | Hunterdon | New Jersey | 34019 | 15413 | 199 |
2055664 | 2055664 | 2021-12-27 | Hunterdon | New Jersey | 34019 | 15279 | 198 |
2052414 | 2052414 | 2021-12-26 | Hunterdon | New Jersey | 34019 | 15160 | 198 |
2049164 | 2049164 | 2021-12-25 | Hunterdon | New Jersey | 34019 | 15049 | 198 |
2045914 | 2045914 | 2021-12-24 | Hunterdon | New Jersey | 34019 | 14870 | 198 |
2042664 | 2042664 | 2021-12-23 | Hunterdon | New Jersey | 34019 | 14698 | 198 |
2039415 | 2039415 | 2021-12-22 | Hunterdon | New Jersey | 34019 | 14440 | 198 |
2036165 | 2036165 | 2021-12-21 | Hunterdon | New Jersey | 34019 | 14358 | 197 |
2032915 | 2032915 | 2021-12-20 | Hunterdon | New Jersey | 34019 | 14243 | 196 |
2029664 | 2029664 | 2021-12-19 | Hunterdon | New Jersey | 34019 | 14181 | 196 |
2026413 | 2026413 | 2021-12-18 | Hunterdon | New Jersey | 34019 | 14119 | 196 |
2023162 | 2023162 | 2021-12-17 | Hunterdon | New Jersey | 34019 | 14047 | 196 |
2019911 | 2019911 | 2021-12-16 | Hunterdon | New Jersey | 34019 | 13963 | 196 |
2016661 | 2016661 | 2021-12-15 | Hunterdon | New Jersey | 34019 | 13878 | 196 |
2013410 | 2013410 | 2021-12-14 | Hunterdon | New Jersey | 34019 | 13826 | 196 |
2010159 | 2010159 | 2021-12-13 | Hunterdon | New Jersey | 34019 | 13765 | 196 |
2006908 | 2006908 | 2021-12-12 | Hunterdon | New Jersey | 34019 | 13729 | 196 |
2003657 | 2003657 | 2021-12-11 | Hunterdon | New Jersey | 34019 | 13680 | 196 |
2000407 | 2000407 | 2021-12-10 | Hunterdon | New Jersey | 34019 | 13601 | 196 |
1997156 | 1997156 | 2021-12-09 | Hunterdon | New Jersey | 34019 | 13520 | 196 |
1993905 | 1993905 | 2021-12-08 | Hunterdon | New Jersey | 34019 | 13448 | 196 |
1990654 | 1990654 | 2021-12-07 | Hunterdon | New Jersey | 34019 | 13381 | 196 |
1987404 | 1987404 | 2021-12-06 | Hunterdon | New Jersey | 34019 | 13345 | 196 |
1984154 | 1984154 | 2021-12-05 | Hunterdon | New Jersey | 34019 | 13289 | 196 |
1980904 | 1980904 | 2021-12-04 | Hunterdon | New Jersey | 34019 | 13245 | 196 |
1977654 | 1977654 | 2021-12-03 | Hunterdon | New Jersey | 34019 | 13185 | 196 |
1974404 | 1974404 | 2021-12-02 | Hunterdon | New Jersey | 34019 | 13103 | 196 |
1971155 | 1971155 | 2021-12-01 | Hunterdon | New Jersey | 34019 | 13041 | 196 |
1967905 | 1967905 | 2021-11-30 | Hunterdon | New Jersey | 34019 | 12998 | 195 |
1964653 | 1964653 | 2021-11-29 | Hunterdon | New Jersey | 34019 | 12938 | 195 |
1961402 | 1961402 | 2021-11-28 | Hunterdon | New Jersey | 34019 | 12884 | 195 |
1958151 | 1958151 | 2021-11-27 | Hunterdon | New Jersey | 34019 | 12850 | 195 |
1954900 | 1954900 | 2021-11-26 | Hunterdon | New Jersey | 34019 | 12822 | 195 |
1951649 | 1951649 | 2021-11-25 | Hunterdon | New Jersey | 34019 | 12787 | 194 |
1948398 | 1948398 | 2021-11-24 | Hunterdon | New Jersey | 34019 | 12745 | 194 |
1945147 | 1945147 | 2021-11-23 | Hunterdon | New Jersey | 34019 | 12709 | 194 |
1941896 | 1941896 | 2021-11-22 | Hunterdon | New Jersey | 34019 | 12652 | 193 |
1938646 | 1938646 | 2021-11-21 | Hunterdon | New Jersey | 34019 | 12625 | 193 |
1935396 | 1935396 | 2021-11-20 | Hunterdon | New Jersey | 34019 | 12602 | 193 |
1932146 | 1932146 | 2021-11-19 | Hunterdon | New Jersey | 34019 | 12559 | 193 |
1928895 | 1928895 | 2021-11-18 | Hunterdon | New Jersey | 34019 | 12514 | 193 |
1925645 | 1925645 | 2021-11-17 | Hunterdon | New Jersey | 34019 | 12453 | 193 |
1922396 | 1922396 | 2021-11-16 | Hunterdon | New Jersey | 34019 | 12412 | 193 |
1919146 | 1919146 | 2021-11-15 | Hunterdon | New Jersey | 34019 | 12386 | 192 |
1915896 | 1915896 | 2021-11-14 | Hunterdon | New Jersey | 34019 | 12363 | 192 |
1912646 | 1912646 | 2021-11-13 | Hunterdon | New Jersey | 34019 | 12338 | 192 |
1909396 | 1909396 | 2021-11-12 | Hunterdon | New Jersey | 34019 | 12300 | 192 |
1906147 | 1906147 | 2021-11-11 | Hunterdon | New Jersey | 34019 | 12282 | 192 |
1902898 | 1902898 | 2021-11-10 | Hunterdon | New Jersey | 34019 | 12238 | 192 |
1899648 | 1899648 | 2021-11-09 | Hunterdon | New Jersey | 34019 | 12211 | 192 |
1896398 | 1896398 | 2021-11-08 | Hunterdon | New Jersey | 34019 | 12191 | 192 |
1893148 | 1893148 | 2021-11-07 | Hunterdon | New Jersey | 34019 | 12178 | 192 |
1889898 | 1889898 | 2021-11-06 | Hunterdon | New Jersey | 34019 | 12165 | 192 |
1886648 | 1886648 | 2021-11-05 | Hunterdon | New Jersey | 34019 | 12150 | 192 |
1883399 | 1883399 | 2021-11-04 | Hunterdon | New Jersey | 34019 | 12137 | 192 |
1880150 | 1880150 | 2021-11-03 | Hunterdon | New Jersey | 34019 | 12118 | 192 |
1876901 | 1876901 | 2021-11-02 | Hunterdon | New Jersey | 34019 | 12110 | 192 |
1873652 | 1873652 | 2021-11-01 | Hunterdon | New Jersey | 34019 | 12096 | 192 |
1870403 | 1870403 | 2021-10-31 | Hunterdon | New Jersey | 34019 | 12086 | 192 |
1867154 | 1867154 | 2021-10-30 | Hunterdon | New Jersey | 34019 | 12072 | 192 |
1863905 | 1863905 | 2021-10-29 | Hunterdon | New Jersey | 34019 | 12047 | 192 |
1860656 | 1860656 | 2021-10-28 | Hunterdon | New Jersey | 34019 | 12025 | 192 |
1857407 | 1857407 | 2021-10-27 | Hunterdon | New Jersey | 34019 | 12016 | 192 |
1854158 | 1854158 | 2021-10-26 | Hunterdon | New Jersey | 34019 | 11991 | 192 |
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);