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 |
---|---|---|---|---|---|---|---|
2488352 | 2488352 | 2022-05-09 | Monmouth | New Jersey | 34025 | 170700 | 2176 |
2488353 | 2488353 | 2022-05-09 | Morris | New Jersey | 34027 | 124531 | 1546 |
2488354 | 2488354 | 2022-05-09 | Ocean | New Jersey | 34029 | 167099 | 2970 |
2488355 | 2488355 | 2022-05-09 | Passaic | New Jersey | 34031 | 148734 | 2336 |
2488356 | 2488356 | 2022-05-09 | Salem | New Jersey | 34033 | 14579 | 248 |
2488357 | 2488357 | 2022-05-09 | Somerset | New Jersey | 34035 | 71416 | 975 |
2488358 | 2488358 | 2022-05-09 | Sussex | New Jersey | 34037 | 35162 | 475 |
2488359 | 2488359 | 2022-05-09 | Union | New Jersey | 34039 | 149770 | 2352 |
2488360 | 2488360 | 2022-05-09 | Unknown | New Jersey | 3229 | 0 | |
2488361 | 2488361 | 2022-05-09 | Warren | New Jersey | 34041 | 24643 | 342 |
2485083 | 2485083 | 2022-05-08 | Atlantic | New Jersey | 34001 | 69971 | 997 |
2485084 | 2485084 | 2022-05-08 | Bergen | New Jersey | 34003 | 236030 | 3450 |
2485085 | 2485085 | 2022-05-08 | Burlington | New Jersey | 34005 | 105592 | 1207 |
2485086 | 2485086 | 2022-05-08 | Camden | New Jersey | 34007 | 128882 | 1805 |
2485087 | 2485087 | 2022-05-08 | Cape May | New Jersey | 34009 | 22578 | 304 |
2485088 | 2485088 | 2022-05-08 | Cumberland | New Jersey | 34011 | 40165 | 604 |
2485089 | 2485089 | 2022-05-08 | Essex | New Jersey | 34013 | 220451 | 3610 |
2485090 | 2485090 | 2022-05-08 | Gloucester | New Jersey | 34015 | 71244 | 964 |
2485091 | 2485091 | 2022-05-08 | Hudson | New Jersey | 34017 | 177441 | 2723 |
2485092 | 2485092 | 2022-05-08 | Hunterdon | New Jersey | 34019 | 25683 | 275 |
2485093 | 2485093 | 2022-05-08 | Mercer | New Jersey | 34021 | 79927 | 1260 |
2485094 | 2485094 | 2022-05-08 | Middlesex | New Jersey | 34023 | 202034 | 2873 |
2485095 | 2485095 | 2022-05-08 | Monmouth | New Jersey | 34025 | 170552 | 2178 |
2485096 | 2485096 | 2022-05-08 | Morris | New Jersey | 34027 | 124380 | 1545 |
2485097 | 2485097 | 2022-05-08 | Ocean | New Jersey | 34029 | 166956 | 2968 |
2485098 | 2485098 | 2022-05-08 | Passaic | New Jersey | 34031 | 148573 | 2336 |
2485099 | 2485099 | 2022-05-08 | Salem | New Jersey | 34033 | 14568 | 248 |
2485100 | 2485100 | 2022-05-08 | Somerset | New Jersey | 34035 | 71326 | 973 |
2485101 | 2485101 | 2022-05-08 | Sussex | New Jersey | 34037 | 35129 | 475 |
2485102 | 2485102 | 2022-05-08 | Union | New Jersey | 34039 | 149624 | 2352 |
2485103 | 2485103 | 2022-05-08 | Unknown | New Jersey | 3221 | 0 | |
2485104 | 2485104 | 2022-05-08 | Warren | New Jersey | 34041 | 24623 | 342 |
2481825 | 2481825 | 2022-05-07 | Atlantic | New Jersey | 34001 | 69895 | 997 |
2481826 | 2481826 | 2022-05-07 | Bergen | New Jersey | 34003 | 235523 | 3450 |
2481827 | 2481827 | 2022-05-07 | Burlington | New Jersey | 34005 | 105469 | 1207 |
2481828 | 2481828 | 2022-05-07 | Camden | New Jersey | 34007 | 128744 | 1805 |
2481829 | 2481829 | 2022-05-07 | Cape May | New Jersey | 34009 | 22553 | 304 |
2481830 | 2481830 | 2022-05-07 | Cumberland | New Jersey | 34011 | 40139 | 604 |
2481831 | 2481831 | 2022-05-07 | Essex | New Jersey | 34013 | 220065 | 3610 |
2481832 | 2481832 | 2022-05-07 | Gloucester | New Jersey | 34015 | 71181 | 964 |
2481833 | 2481833 | 2022-05-07 | Hudson | New Jersey | 34017 | 177272 | 2723 |
2481834 | 2481834 | 2022-05-07 | Hunterdon | New Jersey | 34019 | 25638 | 275 |
2481835 | 2481835 | 2022-05-07 | Mercer | New Jersey | 34021 | 79789 | 1260 |
2481836 | 2481836 | 2022-05-07 | Middlesex | New Jersey | 34023 | 201658 | 2872 |
2481837 | 2481837 | 2022-05-07 | Monmouth | New Jersey | 34025 | 170294 | 2178 |
2481838 | 2481838 | 2022-05-07 | Morris | New Jersey | 34027 | 124168 | 1545 |
2481839 | 2481839 | 2022-05-07 | Ocean | New Jersey | 34029 | 166773 | 2968 |
2481840 | 2481840 | 2022-05-07 | Passaic | New Jersey | 34031 | 148417 | 2336 |
2481841 | 2481841 | 2022-05-07 | Salem | New Jersey | 34033 | 14557 | 248 |
2481842 | 2481842 | 2022-05-07 | Somerset | New Jersey | 34035 | 71193 | 973 |
2481843 | 2481843 | 2022-05-07 | Sussex | New Jersey | 34037 | 35075 | 475 |
2481844 | 2481844 | 2022-05-07 | Union | New Jersey | 34039 | 149434 | 2352 |
2481845 | 2481845 | 2022-05-07 | Unknown | New Jersey | 3212 | 0 | |
2481846 | 2481846 | 2022-05-07 | Warren | New Jersey | 34041 | 24592 | 342 |
2478567 | 2478567 | 2022-05-06 | Atlantic | New Jersey | 34001 | 69797 | 997 |
2478568 | 2478568 | 2022-05-06 | Bergen | New Jersey | 34003 | 234927 | 3451 |
2478569 | 2478569 | 2022-05-06 | Burlington | New Jersey | 34005 | 105285 | 1206 |
2478570 | 2478570 | 2022-05-06 | Camden | New Jersey | 34007 | 128572 | 1805 |
2478571 | 2478571 | 2022-05-06 | Cape May | New Jersey | 34009 | 22507 | 304 |
2478572 | 2478572 | 2022-05-06 | Cumberland | New Jersey | 34011 | 40100 | 604 |
2478573 | 2478573 | 2022-05-06 | Essex | New Jersey | 34013 | 219718 | 3610 |
2478574 | 2478574 | 2022-05-06 | Gloucester | New Jersey | 34015 | 71096 | 964 |
2478575 | 2478575 | 2022-05-06 | Hudson | New Jersey | 34017 | 177022 | 2722 |
2478576 | 2478576 | 2022-05-06 | Hunterdon | New Jersey | 34019 | 25584 | 275 |
2478577 | 2478577 | 2022-05-06 | Mercer | New Jersey | 34021 | 79628 | 1260 |
2478578 | 2478578 | 2022-05-06 | Middlesex | New Jersey | 34023 | 201233 | 2871 |
2478579 | 2478579 | 2022-05-06 | Monmouth | New Jersey | 34025 | 169999 | 2178 |
2478580 | 2478580 | 2022-05-06 | Morris | New Jersey | 34027 | 123889 | 1544 |
2478581 | 2478581 | 2022-05-06 | Ocean | New Jersey | 34029 | 166516 | 2966 |
2478582 | 2478582 | 2022-05-06 | Passaic | New Jersey | 34031 | 148235 | 2336 |
2478583 | 2478583 | 2022-05-06 | Salem | New Jersey | 34033 | 14544 | 248 |
2478584 | 2478584 | 2022-05-06 | Somerset | New Jersey | 34035 | 71037 | 973 |
2478585 | 2478585 | 2022-05-06 | Sussex | New Jersey | 34037 | 35026 | 475 |
2478586 | 2478586 | 2022-05-06 | Union | New Jersey | 34039 | 149198 | 2351 |
2478587 | 2478587 | 2022-05-06 | Unknown | New Jersey | 3198 | 0 | |
2478588 | 2478588 | 2022-05-06 | Warren | New Jersey | 34041 | 24544 | 342 |
2475309 | 2475309 | 2022-05-05 | Atlantic | New Jersey | 34001 | 69715 | 997 |
2475310 | 2475310 | 2022-05-05 | Bergen | New Jersey | 34003 | 234326 | 3449 |
2475311 | 2475311 | 2022-05-05 | Burlington | New Jersey | 34005 | 105139 | 1205 |
2475312 | 2475312 | 2022-05-05 | Camden | New Jersey | 34007 | 128404 | 1804 |
2475313 | 2475313 | 2022-05-05 | Cape May | New Jersey | 34009 | 22471 | 304 |
2475314 | 2475314 | 2022-05-05 | Cumberland | New Jersey | 34011 | 40079 | 604 |
2475315 | 2475315 | 2022-05-05 | Essex | New Jersey | 34013 | 219342 | 3610 |
2475316 | 2475316 | 2022-05-05 | Gloucester | New Jersey | 34015 | 71022 | 964 |
2475317 | 2475317 | 2022-05-05 | Hudson | New Jersey | 34017 | 176675 | 2722 |
2475318 | 2475318 | 2022-05-05 | Hunterdon | New Jersey | 34019 | 25524 | 275 |
2475319 | 2475319 | 2022-05-05 | Mercer | New Jersey | 34021 | 79447 | 1260 |
2475320 | 2475320 | 2022-05-05 | Middlesex | New Jersey | 34023 | 200775 | 2871 |
2475321 | 2475321 | 2022-05-05 | Monmouth | New Jersey | 34025 | 169692 | 2178 |
2475322 | 2475322 | 2022-05-05 | Morris | New Jersey | 34027 | 123575 | 1542 |
2475323 | 2475323 | 2022-05-05 | Ocean | New Jersey | 34029 | 166205 | 2964 |
2475324 | 2475324 | 2022-05-05 | Passaic | New Jersey | 34031 | 148013 | 2336 |
2475325 | 2475325 | 2022-05-05 | Salem | New Jersey | 34033 | 14537 | 248 |
2475326 | 2475326 | 2022-05-05 | Somerset | New Jersey | 34035 | 70822 | 973 |
2475327 | 2475327 | 2022-05-05 | Sussex | New Jersey | 34037 | 34966 | 475 |
2475328 | 2475328 | 2022-05-05 | Union | New Jersey | 34039 | 148951 | 2351 |
2475329 | 2475329 | 2022-05-05 | Unknown | New Jersey | 3206 | 0 | |
2475330 | 2475330 | 2022-05-05 | Warren | New Jersey | 34041 | 24503 | 342 |
2472052 | 2472052 | 2022-05-04 | Atlantic | New Jersey | 34001 | 69613 | 997 |
2472053 | 2472053 | 2022-05-04 | Bergen | New Jersey | 34003 | 233768 | 3448 |
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);