ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Warren" and fips = 34041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176009 | 2176009 | 2022-02-02 | Warren | New Jersey | 34041 | 22996 | 316 |
2172756 | 2172756 | 2022-02-01 | Warren | New Jersey | 34041 | 22949 | 314 |
2169503 | 2169503 | 2022-01-31 | Warren | New Jersey | 34041 | 22897 | 312 |
2166248 | 2166248 | 2022-01-30 | Warren | New Jersey | 34041 | 22860 | 312 |
2162993 | 2162993 | 2022-01-29 | Warren | New Jersey | 34041 | 22832 | 310 |
2159738 | 2159738 | 2022-01-28 | Warren | New Jersey | 34041 | 22763 | 309 |
2156484 | 2156484 | 2022-01-27 | Warren | New Jersey | 34041 | 22692 | 309 |
2153231 | 2153231 | 2022-01-26 | Warren | New Jersey | 34041 | 22603 | 308 |
2149979 | 2149979 | 2022-01-25 | Warren | New Jersey | 34041 | 22538 | 307 |
2146727 | 2146727 | 2022-01-24 | Warren | New Jersey | 34041 | 22470 | 301 |
2143472 | 2143472 | 2022-01-23 | Warren | New Jersey | 34041 | 22412 | 301 |
2140217 | 2140217 | 2022-01-22 | Warren | New Jersey | 34041 | 22344 | 301 |
2136961 | 2136961 | 2022-01-21 | Warren | New Jersey | 34041 | 22238 | 301 |
2133709 | 2133709 | 2022-01-20 | Warren | New Jersey | 34041 | 22073 | 301 |
2130456 | 2130456 | 2022-01-19 | Warren | New Jersey | 34041 | 21909 | 300 |
2127202 | 2127202 | 2022-01-18 | Warren | New Jersey | 34041 | 21767 | 298 |
2123950 | 2123950 | 2022-01-17 | Warren | New Jersey | 34041 | 21655 | 297 |
2120698 | 2120698 | 2022-01-16 | Warren | New Jersey | 34041 | 21530 | 297 |
2117446 | 2117446 | 2022-01-15 | Warren | New Jersey | 34041 | 21390 | 297 |
2114195 | 2114195 | 2022-01-14 | Warren | New Jersey | 34041 | 21154 | 297 |
2110943 | 2110943 | 2022-01-13 | Warren | New Jersey | 34041 | 20886 | 294 |
2107692 | 2107692 | 2022-01-12 | Warren | New Jersey | 34041 | 20678 | 294 |
2104441 | 2104441 | 2022-01-11 | Warren | New Jersey | 34041 | 20386 | 294 |
2101190 | 2101190 | 2022-01-10 | Warren | New Jersey | 34041 | 20043 | 290 |
2097939 | 2097939 | 2022-01-09 | Warren | New Jersey | 34041 | 19819 | 288 |
2094687 | 2094687 | 2022-01-08 | Warren | New Jersey | 34041 | 19472 | 288 |
2091435 | 2091435 | 2022-01-07 | Warren | New Jersey | 34041 | 19144 | 286 |
2088184 | 2088184 | 2022-01-06 | Warren | New Jersey | 34041 | 18691 | 284 |
2084932 | 2084932 | 2022-01-05 | Warren | New Jersey | 34041 | 18371 | 282 |
2081680 | 2081680 | 2022-01-04 | Warren | New Jersey | 34041 | 18130 | 280 |
2078428 | 2078428 | 2022-01-03 | Warren | New Jersey | 34041 | 17784 | 280 |
2075177 | 2075177 | 2022-01-02 | Warren | New Jersey | 34041 | 17484 | 279 |
2071926 | 2071926 | 2022-01-01 | Warren | New Jersey | 34041 | 17202 | 279 |
2068675 | 2068675 | 2021-12-31 | Warren | New Jersey | 34041 | 16862 | 279 |
2065424 | 2065424 | 2021-12-30 | Warren | New Jersey | 34041 | 16475 | 277 |
2062174 | 2062174 | 2021-12-29 | Warren | New Jersey | 34041 | 16217 | 277 |
2058925 | 2058925 | 2021-12-28 | Warren | New Jersey | 34041 | 15924 | 277 |
2055676 | 2055676 | 2021-12-27 | Warren | New Jersey | 34041 | 15825 | 275 |
2052426 | 2052426 | 2021-12-26 | Warren | New Jersey | 34041 | 15766 | 275 |
2049176 | 2049176 | 2021-12-25 | Warren | New Jersey | 34041 | 15618 | 274 |
2045926 | 2045926 | 2021-12-24 | Warren | New Jersey | 34041 | 15440 | 274 |
2042676 | 2042676 | 2021-12-23 | Warren | New Jersey | 34041 | 15286 | 271 |
2039427 | 2039427 | 2021-12-22 | Warren | New Jersey | 34041 | 15131 | 271 |
2036177 | 2036177 | 2021-12-21 | Warren | New Jersey | 34041 | 15016 | 271 |
2032927 | 2032927 | 2021-12-20 | Warren | New Jersey | 34041 | 14880 | 269 |
2029676 | 2029676 | 2021-12-19 | Warren | New Jersey | 34041 | 14786 | 269 |
2026425 | 2026425 | 2021-12-18 | Warren | New Jersey | 34041 | 14724 | 269 |
2023174 | 2023174 | 2021-12-17 | Warren | New Jersey | 34041 | 14653 | 269 |
2019923 | 2019923 | 2021-12-16 | Warren | New Jersey | 34041 | 14558 | 268 |
2016673 | 2016673 | 2021-12-15 | Warren | New Jersey | 34041 | 14449 | 268 |
2013422 | 2013422 | 2021-12-14 | Warren | New Jersey | 34041 | 14359 | 267 |
2010171 | 2010171 | 2021-12-13 | Warren | New Jersey | 34041 | 14271 | 267 |
2006920 | 2006920 | 2021-12-12 | Warren | New Jersey | 34041 | 14213 | 267 |
2003669 | 2003669 | 2021-12-11 | Warren | New Jersey | 34041 | 14161 | 266 |
2000419 | 2000419 | 2021-12-10 | Warren | New Jersey | 34041 | 14049 | 265 |
1997168 | 1997168 | 2021-12-09 | Warren | New Jersey | 34041 | 13955 | 265 |
1993917 | 1993917 | 2021-12-08 | Warren | New Jersey | 34041 | 13847 | 265 |
1990666 | 1990666 | 2021-12-07 | Warren | New Jersey | 34041 | 13753 | 264 |
1987416 | 1987416 | 2021-12-06 | Warren | New Jersey | 34041 | 13692 | 264 |
1984166 | 1984166 | 2021-12-05 | Warren | New Jersey | 34041 | 13626 | 264 |
1980916 | 1980916 | 2021-12-04 | Warren | New Jersey | 34041 | 13565 | 263 |
1977666 | 1977666 | 2021-12-03 | Warren | New Jersey | 34041 | 13478 | 263 |
1974416 | 1974416 | 2021-12-02 | Warren | New Jersey | 34041 | 13383 | 262 |
1971167 | 1971167 | 2021-12-01 | Warren | New Jersey | 34041 | 13304 | 262 |
1967917 | 1967917 | 2021-11-30 | Warren | New Jersey | 34041 | 13238 | 261 |
1964665 | 1964665 | 2021-11-29 | Warren | New Jersey | 34041 | 13158 | 260 |
1961414 | 1961414 | 2021-11-28 | Warren | New Jersey | 34041 | 13099 | 260 |
1958163 | 1958163 | 2021-11-27 | Warren | New Jersey | 34041 | 13072 | 260 |
1954912 | 1954912 | 2021-11-26 | Warren | New Jersey | 34041 | 13045 | 260 |
1951661 | 1951661 | 2021-11-25 | Warren | New Jersey | 34041 | 12994 | 260 |
1948410 | 1948410 | 2021-11-24 | Warren | New Jersey | 34041 | 12934 | 260 |
1945159 | 1945159 | 2021-11-23 | Warren | New Jersey | 34041 | 12899 | 260 |
1941908 | 1941908 | 2021-11-22 | Warren | New Jersey | 34041 | 12851 | 258 |
1938658 | 1938658 | 2021-11-21 | Warren | New Jersey | 34041 | 12814 | 258 |
1935408 | 1935408 | 2021-11-20 | Warren | New Jersey | 34041 | 12783 | 258 |
1932158 | 1932158 | 2021-11-19 | Warren | New Jersey | 34041 | 12735 | 258 |
1928907 | 1928907 | 2021-11-18 | Warren | New Jersey | 34041 | 12688 | 258 |
1925657 | 1925657 | 2021-11-17 | Warren | New Jersey | 34041 | 12642 | 258 |
1922408 | 1922408 | 2021-11-16 | Warren | New Jersey | 34041 | 12594 | 257 |
1919158 | 1919158 | 2021-11-15 | Warren | New Jersey | 34041 | 12569 | 257 |
1915908 | 1915908 | 2021-11-14 | Warren | New Jersey | 34041 | 12551 | 257 |
1912658 | 1912658 | 2021-11-13 | Warren | New Jersey | 34041 | 12525 | 257 |
1909408 | 1909408 | 2021-11-12 | Warren | New Jersey | 34041 | 12493 | 256 |
1906159 | 1906159 | 2021-11-11 | Warren | New Jersey | 34041 | 12457 | 256 |
1902910 | 1902910 | 2021-11-10 | Warren | New Jersey | 34041 | 12431 | 255 |
1899660 | 1899660 | 2021-11-09 | Warren | New Jersey | 34041 | 12401 | 255 |
1896410 | 1896410 | 2021-11-08 | Warren | New Jersey | 34041 | 12373 | 255 |
1893160 | 1893160 | 2021-11-07 | Warren | New Jersey | 34041 | 12353 | 255 |
1889910 | 1889910 | 2021-11-06 | Warren | New Jersey | 34041 | 12333 | 255 |
1886660 | 1886660 | 2021-11-05 | Warren | New Jersey | 34041 | 12319 | 255 |
1883411 | 1883411 | 2021-11-04 | Warren | New Jersey | 34041 | 12295 | 255 |
1880162 | 1880162 | 2021-11-03 | Warren | New Jersey | 34041 | 12276 | 255 |
1876913 | 1876913 | 2021-11-02 | Warren | New Jersey | 34041 | 12259 | 255 |
1873664 | 1873664 | 2021-11-01 | Warren | New Jersey | 34041 | 12237 | 255 |
1870415 | 1870415 | 2021-10-31 | Warren | New Jersey | 34041 | 12221 | 255 |
1867166 | 1867166 | 2021-10-30 | Warren | New Jersey | 34041 | 12203 | 255 |
1863917 | 1863917 | 2021-10-29 | Warren | New Jersey | 34041 | 12182 | 254 |
1860668 | 1860668 | 2021-10-28 | Warren | New Jersey | 34041 | 12165 | 253 |
1857419 | 1857419 | 2021-10-27 | Warren | New Jersey | 34041 | 12135 | 253 |
1854170 | 1854170 | 2021-10-26 | Warren | New Jersey | 34041 | 12118 | 253 |
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);