ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17,417 rows where state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418919 | 1418919 | 2021-06-14 | Atlantic | New Jersey | 34001 | 31584 | 689 |
1418920 | 1418920 | 2021-06-14 | Bergen | New Jersey | 34003 | 104574 | 2878 |
1418921 | 1418921 | 2021-06-14 | Burlington | New Jersey | 34005 | 44278 | 864 |
1418922 | 1418922 | 2021-06-14 | Camden | New Jersey | 34007 | 55747 | 1319 |
1418923 | 1418923 | 2021-06-14 | Cape May | New Jersey | 34009 | 9220 | 207 |
1418924 | 1418924 | 2021-06-14 | Cumberland | New Jersey | 34011 | 17157 | 439 |
1418925 | 1418925 | 2021-06-14 | Essex | New Jersey | 34013 | 94279 | 3007 |
1418926 | 1418926 | 2021-06-14 | Gloucester | New Jersey | 34015 | 30604 | 643 |
1418927 | 1418927 | 2021-06-14 | Hudson | New Jersey | 34017 | 88197 | 2294 |
1418928 | 1418928 | 2021-06-14 | Hunterdon | New Jersey | 34019 | 9825 | 176 |
1418929 | 1418929 | 2021-06-14 | Mercer | New Jersey | 34021 | 34099 | 955 |
1418930 | 1418930 | 2021-06-14 | Middlesex | New Jersey | 34023 | 92439 | 2364 |
1418931 | 1418931 | 2021-06-14 | Monmouth | New Jersey | 34025 | 75737 | 1626 |
1418932 | 1418932 | 2021-06-14 | Morris | New Jersey | 34027 | 50237 | 1237 |
1418933 | 1418933 | 2021-06-14 | Ocean | New Jersey | 34029 | 76051 | 2162 |
1418934 | 1418934 | 2021-06-14 | Passaic | New Jersey | 34031 | 73129 | 1930 |
1418935 | 1418935 | 2021-06-14 | Salem | New Jersey | 34033 | 6088 | 185 |
1418936 | 1418936 | 2021-06-14 | Somerset | New Jersey | 34035 | 30118 | 846 |
1418937 | 1418937 | 2021-06-14 | Sussex | New Jersey | 34037 | 14036 | 305 |
1418938 | 1418938 | 2021-06-14 | Union | New Jersey | 34039 | 71587 | 1971 |
1418939 | 1418939 | 2021-06-14 | Unknown | New Jersey | 812 | 0 | |
1418940 | 1418940 | 2021-06-14 | Warren | New Jersey | 34041 | 9996 | 237 |
1415674 | 1415674 | 2021-06-13 | Atlantic | New Jersey | 34001 | 31582 | 688 |
1415675 | 1415675 | 2021-06-13 | Bergen | New Jersey | 34003 | 104553 | 2878 |
1415676 | 1415676 | 2021-06-13 | Burlington | New Jersey | 34005 | 44271 | 864 |
1415677 | 1415677 | 2021-06-13 | Camden | New Jersey | 34007 | 55734 | 1319 |
1415678 | 1415678 | 2021-06-13 | Cape May | New Jersey | 34009 | 9220 | 207 |
1415679 | 1415679 | 2021-06-13 | Cumberland | New Jersey | 34011 | 17152 | 439 |
1415680 | 1415680 | 2021-06-13 | Essex | New Jersey | 34013 | 94257 | 3004 |
1415681 | 1415681 | 2021-06-13 | Gloucester | New Jersey | 34015 | 30600 | 643 |
1415682 | 1415682 | 2021-06-13 | Hudson | New Jersey | 34017 | 88161 | 2294 |
1415683 | 1415683 | 2021-06-13 | Hunterdon | New Jersey | 34019 | 9828 | 176 |
1415684 | 1415684 | 2021-06-13 | Mercer | New Jersey | 34021 | 34090 | 955 |
1415685 | 1415685 | 2021-06-13 | Middlesex | New Jersey | 34023 | 92423 | 2365 |
1415686 | 1415686 | 2021-06-13 | Monmouth | New Jersey | 34025 | 75715 | 1626 |
1415687 | 1415687 | 2021-06-13 | Morris | New Jersey | 34027 | 50230 | 1237 |
1415688 | 1415688 | 2021-06-13 | Ocean | New Jersey | 34029 | 76030 | 2162 |
1415689 | 1415689 | 2021-06-13 | Passaic | New Jersey | 34031 | 73107 | 1929 |
1415690 | 1415690 | 2021-06-13 | Salem | New Jersey | 34033 | 6087 | 185 |
1415691 | 1415691 | 2021-06-13 | Somerset | New Jersey | 34035 | 30103 | 846 |
1415692 | 1415692 | 2021-06-13 | Sussex | New Jersey | 34037 | 14039 | 305 |
1415693 | 1415693 | 2021-06-13 | Union | New Jersey | 34039 | 71574 | 1971 |
1415694 | 1415694 | 2021-06-13 | Unknown | New Jersey | 812 | 0 | |
1415695 | 1415695 | 2021-06-13 | Warren | New Jersey | 34041 | 9995 | 237 |
1412428 | 1412428 | 2021-06-12 | Atlantic | New Jersey | 34001 | 31578 | 688 |
1412429 | 1412429 | 2021-06-12 | Bergen | New Jersey | 34003 | 104528 | 2878 |
1412430 | 1412430 | 2021-06-12 | Burlington | New Jersey | 34005 | 44260 | 864 |
1412431 | 1412431 | 2021-06-12 | Camden | New Jersey | 34007 | 55725 | 1318 |
1412432 | 1412432 | 2021-06-12 | Cape May | New Jersey | 34009 | 9219 | 207 |
1412433 | 1412433 | 2021-06-12 | Cumberland | New Jersey | 34011 | 17148 | 439 |
1412434 | 1412434 | 2021-06-12 | Essex | New Jersey | 34013 | 94245 | 3004 |
1412435 | 1412435 | 2021-06-12 | Gloucester | New Jersey | 34015 | 30595 | 643 |
1412436 | 1412436 | 2021-06-12 | Hudson | New Jersey | 34017 | 88149 | 2294 |
1412437 | 1412437 | 2021-06-12 | Hunterdon | New Jersey | 34019 | 9828 | 176 |
1412438 | 1412438 | 2021-06-12 | Mercer | New Jersey | 34021 | 34086 | 954 |
1412439 | 1412439 | 2021-06-12 | Middlesex | New Jersey | 34023 | 92409 | 2365 |
1412440 | 1412440 | 2021-06-12 | Monmouth | New Jersey | 34025 | 75689 | 1626 |
1412441 | 1412441 | 2021-06-12 | Morris | New Jersey | 34027 | 50223 | 1237 |
1412442 | 1412442 | 2021-06-12 | Ocean | New Jersey | 34029 | 76009 | 2162 |
1412443 | 1412443 | 2021-06-12 | Passaic | New Jersey | 34031 | 73087 | 1928 |
1412444 | 1412444 | 2021-06-12 | Salem | New Jersey | 34033 | 6087 | 185 |
1412445 | 1412445 | 2021-06-12 | Somerset | New Jersey | 34035 | 30091 | 846 |
1412446 | 1412446 | 2021-06-12 | Sussex | New Jersey | 34037 | 14038 | 305 |
1412447 | 1412447 | 2021-06-12 | Union | New Jersey | 34039 | 71556 | 1971 |
1412448 | 1412448 | 2021-06-12 | Unknown | New Jersey | 811 | 0 | |
1412449 | 1412449 | 2021-06-12 | Warren | New Jersey | 34041 | 9995 | 237 |
1409183 | 1409183 | 2021-06-11 | Atlantic | New Jersey | 34001 | 31574 | 688 |
1409184 | 1409184 | 2021-06-11 | Bergen | New Jersey | 34003 | 104508 | 2878 |
1409185 | 1409185 | 2021-06-11 | Burlington | New Jersey | 34005 | 44253 | 863 |
1409186 | 1409186 | 2021-06-11 | Camden | New Jersey | 34007 | 55714 | 1318 |
1409187 | 1409187 | 2021-06-11 | Cape May | New Jersey | 34009 | 9211 | 207 |
1409188 | 1409188 | 2021-06-11 | Cumberland | New Jersey | 34011 | 17147 | 440 |
1409189 | 1409189 | 2021-06-11 | Essex | New Jersey | 34013 | 94248 | 3003 |
1409190 | 1409190 | 2021-06-11 | Gloucester | New Jersey | 34015 | 30588 | 643 |
1409191 | 1409191 | 2021-06-11 | Hudson | New Jersey | 34017 | 88116 | 2293 |
1409192 | 1409192 | 2021-06-11 | Hunterdon | New Jersey | 34019 | 9820 | 176 |
1409193 | 1409193 | 2021-06-11 | Mercer | New Jersey | 34021 | 34079 | 954 |
1409194 | 1409194 | 2021-06-11 | Middlesex | New Jersey | 34023 | 92392 | 2364 |
1409195 | 1409195 | 2021-06-11 | Monmouth | New Jersey | 34025 | 75661 | 1626 |
1409196 | 1409196 | 2021-06-11 | Morris | New Jersey | 34027 | 50210 | 1237 |
1409197 | 1409197 | 2021-06-11 | Ocean | New Jersey | 34029 | 75983 | 2162 |
1409198 | 1409198 | 2021-06-11 | Passaic | New Jersey | 34031 | 73063 | 1928 |
1409199 | 1409199 | 2021-06-11 | Salem | New Jersey | 34033 | 6091 | 185 |
1409200 | 1409200 | 2021-06-11 | Somerset | New Jersey | 34035 | 30078 | 846 |
1409201 | 1409201 | 2021-06-11 | Sussex | New Jersey | 34037 | 14031 | 305 |
1409202 | 1409202 | 2021-06-11 | Union | New Jersey | 34039 | 71534 | 1971 |
1409203 | 1409203 | 2021-06-11 | Unknown | New Jersey | 815 | 0 | |
1409204 | 1409204 | 2021-06-11 | Warren | New Jersey | 34041 | 9991 | 237 |
1405938 | 1405938 | 2021-06-10 | Atlantic | New Jersey | 34001 | 31571 | 688 |
1405939 | 1405939 | 2021-06-10 | Bergen | New Jersey | 34003 | 104476 | 2878 |
1405940 | 1405940 | 2021-06-10 | Burlington | New Jersey | 34005 | 44243 | 863 |
1405941 | 1405941 | 2021-06-10 | Camden | New Jersey | 34007 | 55703 | 1317 |
1405942 | 1405942 | 2021-06-10 | Cape May | New Jersey | 34009 | 9206 | 209 |
1405943 | 1405943 | 2021-06-10 | Cumberland | New Jersey | 34011 | 17148 | 439 |
1405944 | 1405944 | 2021-06-10 | Essex | New Jersey | 34013 | 94237 | 3003 |
1405945 | 1405945 | 2021-06-10 | Gloucester | New Jersey | 34015 | 30581 | 643 |
1405946 | 1405946 | 2021-06-10 | Hudson | New Jersey | 34017 | 88085 | 2292 |
1405947 | 1405947 | 2021-06-10 | Hunterdon | New Jersey | 34019 | 9819 | 176 |
1405948 | 1405948 | 2021-06-10 | Mercer | New Jersey | 34021 | 34063 | 954 |
1405949 | 1405949 | 2021-06-10 | Middlesex | New Jersey | 34023 | 92367 | 2364 |
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);