ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Essex" and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110928 | 2110928 | 2022-01-13 | Essex | New Jersey | 34013 | 192332 | 3288 |
2107677 | 2107677 | 2022-01-12 | Essex | New Jersey | 34013 | 189925 | 3274 |
2104426 | 2104426 | 2022-01-11 | Essex | New Jersey | 34013 | 187866 | 3257 |
2101175 | 2101175 | 2022-01-10 | Essex | New Jersey | 34013 | 185276 | 3245 |
2097924 | 2097924 | 2022-01-09 | Essex | New Jersey | 34013 | 183325 | 3245 |
2094672 | 2094672 | 2022-01-08 | Essex | New Jersey | 34013 | 180218 | 3244 |
2091420 | 2091420 | 2022-01-07 | Essex | New Jersey | 34013 | 177129 | 3234 |
2088169 | 2088169 | 2022-01-06 | Essex | New Jersey | 34013 | 173220 | 3229 |
2084917 | 2084917 | 2022-01-05 | Essex | New Jersey | 34013 | 170220 | 3219 |
2081665 | 2081665 | 2022-01-04 | Essex | New Jersey | 34013 | 166712 | 3216 |
2078413 | 2078413 | 2022-01-03 | Essex | New Jersey | 34013 | 163322 | 3213 |
2075162 | 2075162 | 2022-01-02 | Essex | New Jersey | 34013 | 160249 | 3212 |
2071911 | 2071911 | 2022-01-01 | Essex | New Jersey | 34013 | 156341 | 3212 |
2068660 | 2068660 | 2021-12-31 | Essex | New Jersey | 34013 | 151892 | 3212 |
2065409 | 2065409 | 2021-12-30 | Essex | New Jersey | 34013 | 147588 | 3212 |
2062159 | 2062159 | 2021-12-29 | Essex | New Jersey | 34013 | 141881 | 3210 |
2058910 | 2058910 | 2021-12-28 | Essex | New Jersey | 34013 | 138474 | 3204 |
2055661 | 2055661 | 2021-12-27 | Essex | New Jersey | 34013 | 136288 | 3203 |
2052411 | 2052411 | 2021-12-26 | Essex | New Jersey | 34013 | 134967 | 3204 |
2049161 | 2049161 | 2021-12-25 | Essex | New Jersey | 34013 | 132320 | 3204 |
2045911 | 2045911 | 2021-12-24 | Essex | New Jersey | 34013 | 128827 | 3203 |
2042661 | 2042661 | 2021-12-23 | Essex | New Jersey | 34013 | 125770 | 3203 |
2039412 | 2039412 | 2021-12-22 | Essex | New Jersey | 34013 | 122618 | 3200 |
2036162 | 2036162 | 2021-12-21 | Essex | New Jersey | 34013 | 120592 | 3199 |
2032912 | 2032912 | 2021-12-20 | Essex | New Jersey | 34013 | 119389 | 3197 |
2029661 | 2029661 | 2021-12-19 | Essex | New Jersey | 34013 | 118190 | 3195 |
2026410 | 2026410 | 2021-12-18 | Essex | New Jersey | 34013 | 117063 | 3194 |
2023159 | 2023159 | 2021-12-17 | Essex | New Jersey | 34013 | 115900 | 3192 |
2019908 | 2019908 | 2021-12-16 | Essex | New Jersey | 34013 | 115110 | 3191 |
2016658 | 2016658 | 2021-12-15 | Essex | New Jersey | 34013 | 114324 | 3190 |
2013407 | 2013407 | 2021-12-14 | Essex | New Jersey | 34013 | 113901 | 3184 |
2010156 | 2010156 | 2021-12-13 | Essex | New Jersey | 34013 | 113555 | 3184 |
2006905 | 2006905 | 2021-12-12 | Essex | New Jersey | 34013 | 113256 | 3183 |
2003654 | 2003654 | 2021-12-11 | Essex | New Jersey | 34013 | 112889 | 3183 |
2000404 | 2000404 | 2021-12-10 | Essex | New Jersey | 34013 | 112607 | 3182 |
1997153 | 1997153 | 2021-12-09 | Essex | New Jersey | 34013 | 112155 | 3182 |
1993902 | 1993902 | 2021-12-08 | Essex | New Jersey | 34013 | 111764 | 3182 |
1990651 | 1990651 | 2021-12-07 | Essex | New Jersey | 34013 | 111461 | 3182 |
1987401 | 1987401 | 2021-12-06 | Essex | New Jersey | 34013 | 111165 | 3180 |
1984151 | 1984151 | 2021-12-05 | Essex | New Jersey | 34013 | 111007 | 3180 |
1980901 | 1980901 | 2021-12-04 | Essex | New Jersey | 34013 | 110843 | 3180 |
1977651 | 1977651 | 2021-12-03 | Essex | New Jersey | 34013 | 110553 | 3180 |
1974401 | 1974401 | 2021-12-02 | Essex | New Jersey | 34013 | 110247 | 3180 |
1971152 | 1971152 | 2021-12-01 | Essex | New Jersey | 34013 | 109956 | 3180 |
1967902 | 1967902 | 2021-11-30 | Essex | New Jersey | 34013 | 109761 | 3179 |
1964650 | 1964650 | 2021-11-29 | Essex | New Jersey | 34013 | 109589 | 3178 |
1961399 | 1961399 | 2021-11-28 | Essex | New Jersey | 34013 | 109465 | 3176 |
1958148 | 1958148 | 2021-11-27 | Essex | New Jersey | 34013 | 109335 | 3175 |
1954897 | 1954897 | 2021-11-26 | Essex | New Jersey | 34013 | 109186 | 3175 |
1951646 | 1951646 | 2021-11-25 | Essex | New Jersey | 34013 | 109046 | 3175 |
1948395 | 1948395 | 2021-11-24 | Essex | New Jersey | 34013 | 108868 | 3174 |
1945144 | 1945144 | 2021-11-23 | Essex | New Jersey | 34013 | 108710 | 3174 |
1941893 | 1941893 | 2021-11-22 | Essex | New Jersey | 34013 | 108504 | 3173 |
1938643 | 1938643 | 2021-11-21 | Essex | New Jersey | 34013 | 108419 | 3172 |
1935393 | 1935393 | 2021-11-20 | Essex | New Jersey | 34013 | 108328 | 3172 |
1932143 | 1932143 | 2021-11-19 | Essex | New Jersey | 34013 | 108179 | 3173 |
1928892 | 1928892 | 2021-11-18 | Essex | New Jersey | 34013 | 108036 | 3170 |
1925642 | 1925642 | 2021-11-17 | Essex | New Jersey | 34013 | 107867 | 3170 |
1922393 | 1922393 | 2021-11-16 | Essex | New Jersey | 34013 | 107752 | 3170 |
1919143 | 1919143 | 2021-11-15 | Essex | New Jersey | 34013 | 107619 | 3169 |
1915893 | 1915893 | 2021-11-14 | Essex | New Jersey | 34013 | 107545 | 3169 |
1912643 | 1912643 | 2021-11-13 | Essex | New Jersey | 34013 | 107465 | 3169 |
1909393 | 1909393 | 2021-11-12 | Essex | New Jersey | 34013 | 107381 | 3169 |
1906144 | 1906144 | 2021-11-11 | Essex | New Jersey | 34013 | 107281 | 3169 |
1902895 | 1902895 | 2021-11-10 | Essex | New Jersey | 34013 | 107154 | 3168 |
1899645 | 1899645 | 2021-11-09 | Essex | New Jersey | 34013 | 107054 | 3166 |
1896395 | 1896395 | 2021-11-08 | Essex | New Jersey | 34013 | 106948 | 3163 |
1893145 | 1893145 | 2021-11-07 | Essex | New Jersey | 34013 | 106891 | 3161 |
1889895 | 1889895 | 2021-11-06 | Essex | New Jersey | 34013 | 106851 | 3161 |
1886645 | 1886645 | 2021-11-05 | Essex | New Jersey | 34013 | 106767 | 3160 |
1883396 | 1883396 | 2021-11-04 | Essex | New Jersey | 34013 | 106673 | 3158 |
1880147 | 1880147 | 2021-11-03 | Essex | New Jersey | 34013 | 106581 | 3158 |
1876898 | 1876898 | 2021-11-02 | Essex | New Jersey | 34013 | 106509 | 3155 |
1873649 | 1873649 | 2021-11-01 | Essex | New Jersey | 34013 | 106411 | 3154 |
1870400 | 1870400 | 2021-10-31 | Essex | New Jersey | 34013 | 106366 | 3154 |
1867151 | 1867151 | 2021-10-30 | Essex | New Jersey | 34013 | 106292 | 3154 |
1863902 | 1863902 | 2021-10-29 | Essex | New Jersey | 34013 | 106250 | 3153 |
1860653 | 1860653 | 2021-10-28 | Essex | New Jersey | 34013 | 106195 | 3153 |
1857404 | 1857404 | 2021-10-27 | Essex | New Jersey | 34013 | 106114 | 3151 |
1854155 | 1854155 | 2021-10-26 | Essex | New Jersey | 34013 | 106049 | 3147 |
1850906 | 1850906 | 2021-10-25 | Essex | New Jersey | 34013 | 105931 | 3145 |
1847656 | 1847656 | 2021-10-24 | Essex | New Jersey | 34013 | 105879 | 3146 |
1844406 | 1844406 | 2021-10-23 | Essex | New Jersey | 34013 | 105856 | 3145 |
1841156 | 1841156 | 2021-10-22 | Essex | New Jersey | 34013 | 105835 | 3145 |
1837907 | 1837907 | 2021-10-21 | Essex | New Jersey | 34013 | 105744 | 3143 |
1834658 | 1834658 | 2021-10-20 | Essex | New Jersey | 34013 | 105721 | 3141 |
1831409 | 1831409 | 2021-10-19 | Essex | New Jersey | 34013 | 105705 | 3141 |
1828160 | 1828160 | 2021-10-18 | Essex | New Jersey | 34013 | 105670 | 3141 |
1824911 | 1824911 | 2021-10-17 | Essex | New Jersey | 34013 | 105678 | 3140 |
1821662 | 1821662 | 2021-10-16 | Essex | New Jersey | 34013 | 105665 | 3140 |
1818413 | 1818413 | 2021-10-15 | Essex | New Jersey | 34013 | 105613 | 3139 |
1815164 | 1815164 | 2021-10-14 | Essex | New Jersey | 34013 | 105583 | 3137 |
1811916 | 1811916 | 2021-10-13 | Essex | New Jersey | 34013 | 105492 | 3135 |
1808667 | 1808667 | 2021-10-12 | Essex | New Jersey | 34013 | 105367 | 3135 |
1805416 | 1805416 | 2021-10-11 | Essex | New Jersey | 34013 | 105270 | 3133 |
1802167 | 1802167 | 2021-10-10 | Essex | New Jersey | 34013 | 105235 | 3133 |
1798918 | 1798918 | 2021-10-09 | Essex | New Jersey | 34013 | 105157 | 3132 |
1795669 | 1795669 | 2021-10-08 | Essex | New Jersey | 34013 | 105060 | 3130 |
1792420 | 1792420 | 2021-10-07 | Essex | New Jersey | 34013 | 104968 | 3129 |
1789171 | 1789171 | 2021-10-06 | Essex | New Jersey | 34013 | 104834 | 3132 |
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);