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 |
---|---|---|---|---|---|---|---|
2097930 | 2097930 | 2022-01-09 | Monmouth | New Jersey | 34025 | 139771 | 1841 |
2097931 | 2097931 | 2022-01-09 | Morris | New Jersey | 34027 | 97006 | 1359 |
2097932 | 2097932 | 2022-01-09 | Ocean | New Jersey | 34029 | 137186 | 2518 |
2097933 | 2097933 | 2022-01-09 | Passaic | New Jersey | 34031 | 123940 | 2104 |
2097934 | 2097934 | 2022-01-09 | Salem | New Jersey | 34033 | 11587 | 218 |
2097935 | 2097935 | 2022-01-09 | Somerset | New Jersey | 34035 | 56673 | 912 |
2097936 | 2097936 | 2022-01-09 | Sussex | New Jersey | 34037 | 28362 | 380 |
2097937 | 2097937 | 2022-01-09 | Union | New Jersey | 34039 | 123547 | 2111 |
2097938 | 2097938 | 2022-01-09 | Unknown | New Jersey | 5603 | 0 | |
2097939 | 2097939 | 2022-01-09 | Warren | New Jersey | 34041 | 19819 | 288 |
2094666 | 2094666 | 2022-01-08 | Atlantic | New Jersey | 34001 | 55332 | 838 |
2094667 | 2094667 | 2022-01-08 | Bergen | New Jersey | 34003 | 183161 | 3117 |
2094668 | 2094668 | 2022-01-08 | Burlington | New Jersey | 34005 | 82084 | 1030 |
2094669 | 2094669 | 2022-01-08 | Camden | New Jersey | 34007 | 100590 | 1542 |
2094670 | 2094670 | 2022-01-08 | Cape May | New Jersey | 34009 | 18380 | 259 |
2094671 | 2094671 | 2022-01-08 | Cumberland | New Jersey | 34011 | 29120 | 526 |
2094672 | 2094672 | 2022-01-08 | Essex | New Jersey | 34013 | 180218 | 3244 |
2094673 | 2094673 | 2022-01-08 | Gloucester | New Jersey | 34015 | 56363 | 801 |
2094674 | 2094674 | 2022-01-08 | Hudson | New Jersey | 34017 | 139723 | 2471 |
2094675 | 2094675 | 2022-01-08 | Hunterdon | New Jersey | 34019 | 19417 | 209 |
2094676 | 2094676 | 2022-01-08 | Mercer | New Jersey | 34021 | 60064 | 1090 |
2094677 | 2094677 | 2022-01-08 | Middlesex | New Jersey | 34023 | 157690 | 2590 |
2094678 | 2094678 | 2022-01-08 | Monmouth | New Jersey | 34025 | 137819 | 1841 |
2094679 | 2094679 | 2022-01-08 | Morris | New Jersey | 34027 | 95349 | 1358 |
2094680 | 2094680 | 2022-01-08 | Ocean | New Jersey | 34029 | 135374 | 2516 |
2094681 | 2094681 | 2022-01-08 | Passaic | New Jersey | 34031 | 122101 | 2103 |
2094682 | 2094682 | 2022-01-08 | Salem | New Jersey | 34033 | 11409 | 218 |
2094683 | 2094683 | 2022-01-08 | Somerset | New Jersey | 34035 | 55732 | 912 |
2094684 | 2094684 | 2022-01-08 | Sussex | New Jersey | 34037 | 27931 | 380 |
2094685 | 2094685 | 2022-01-08 | Union | New Jersey | 34039 | 121842 | 2111 |
2094686 | 2094686 | 2022-01-08 | Unknown | New Jersey | 5992 | 0 | |
2094687 | 2094687 | 2022-01-08 | Warren | New Jersey | 34041 | 19472 | 288 |
2091414 | 2091414 | 2022-01-07 | Atlantic | New Jersey | 34001 | 54384 | 835 |
2091415 | 2091415 | 2022-01-07 | Bergen | New Jersey | 34003 | 179690 | 3103 |
2091416 | 2091416 | 2022-01-07 | Burlington | New Jersey | 34005 | 80490 | 1029 |
2091417 | 2091417 | 2022-01-07 | Camden | New Jersey | 34007 | 98458 | 1541 |
2091418 | 2091418 | 2022-01-07 | Cape May | New Jersey | 34009 | 18140 | 256 |
2091419 | 2091419 | 2022-01-07 | Cumberland | New Jersey | 34011 | 28477 | 526 |
2091420 | 2091420 | 2022-01-07 | Essex | New Jersey | 34013 | 177129 | 3234 |
2091421 | 2091421 | 2022-01-07 | Gloucester | New Jersey | 34015 | 55203 | 798 |
2091422 | 2091422 | 2022-01-07 | Hudson | New Jersey | 34017 | 136423 | 2468 |
2091423 | 2091423 | 2022-01-07 | Hunterdon | New Jersey | 34019 | 19055 | 209 |
2091424 | 2091424 | 2022-01-07 | Mercer | New Jersey | 34021 | 58851 | 1086 |
2091425 | 2091425 | 2022-01-07 | Middlesex | New Jersey | 34023 | 155121 | 2587 |
2091426 | 2091426 | 2022-01-07 | Monmouth | New Jersey | 34025 | 135558 | 1838 |
2091427 | 2091427 | 2022-01-07 | Morris | New Jersey | 34027 | 93417 | 1357 |
2091428 | 2091428 | 2022-01-07 | Ocean | New Jersey | 34029 | 133340 | 2509 |
2091429 | 2091429 | 2022-01-07 | Passaic | New Jersey | 34031 | 119749 | 2098 |
2091430 | 2091430 | 2022-01-07 | Salem | New Jersey | 34033 | 11209 | 218 |
2091431 | 2091431 | 2022-01-07 | Somerset | New Jersey | 34035 | 54839 | 911 |
2091432 | 2091432 | 2022-01-07 | Sussex | New Jersey | 34037 | 27571 | 380 |
2091433 | 2091433 | 2022-01-07 | Union | New Jersey | 34039 | 119799 | 2105 |
2091434 | 2091434 | 2022-01-07 | Unknown | New Jersey | 6416 | 0 | |
2091435 | 2091435 | 2022-01-07 | Warren | New Jersey | 34041 | 19144 | 286 |
2088163 | 2088163 | 2022-01-06 | Atlantic | New Jersey | 34001 | 53204 | 834 |
2088164 | 2088164 | 2022-01-06 | Bergen | New Jersey | 34003 | 175750 | 3099 |
2088165 | 2088165 | 2022-01-06 | Burlington | New Jersey | 34005 | 78653 | 1024 |
2088166 | 2088166 | 2022-01-06 | Camden | New Jersey | 34007 | 96181 | 1537 |
2088167 | 2088167 | 2022-01-06 | Cape May | New Jersey | 34009 | 17809 | 255 |
2088168 | 2088168 | 2022-01-06 | Cumberland | New Jersey | 34011 | 27880 | 525 |
2088169 | 2088169 | 2022-01-06 | Essex | New Jersey | 34013 | 173220 | 3229 |
2088170 | 2088170 | 2022-01-06 | Gloucester | New Jersey | 34015 | 54211 | 794 |
2088171 | 2088171 | 2022-01-06 | Hudson | New Jersey | 34017 | 133400 | 2464 |
2088172 | 2088172 | 2022-01-06 | Hunterdon | New Jersey | 34019 | 18503 | 210 |
2088173 | 2088173 | 2022-01-06 | Mercer | New Jersey | 34021 | 57431 | 1084 |
2088174 | 2088174 | 2022-01-06 | Middlesex | New Jersey | 34023 | 151676 | 2580 |
2088175 | 2088175 | 2022-01-06 | Monmouth | New Jersey | 34025 | 132835 | 1837 |
2088176 | 2088176 | 2022-01-06 | Morris | New Jersey | 34027 | 90976 | 1355 |
2088177 | 2088177 | 2022-01-06 | Ocean | New Jersey | 34029 | 130882 | 2502 |
2088178 | 2088178 | 2022-01-06 | Passaic | New Jersey | 34031 | 117133 | 2095 |
2088179 | 2088179 | 2022-01-06 | Salem | New Jersey | 34033 | 11061 | 218 |
2088180 | 2088180 | 2022-01-06 | Somerset | New Jersey | 34035 | 53355 | 911 |
2088181 | 2088181 | 2022-01-06 | Sussex | New Jersey | 34037 | 27091 | 379 |
2088182 | 2088182 | 2022-01-06 | Union | New Jersey | 34039 | 117627 | 2099 |
2088183 | 2088183 | 2022-01-06 | Unknown | New Jersey | 6433 | 0 | |
2088184 | 2088184 | 2022-01-06 | Warren | New Jersey | 34041 | 18691 | 284 |
2084911 | 2084911 | 2022-01-05 | Atlantic | New Jersey | 34001 | 52441 | 829 |
2084912 | 2084912 | 2022-01-05 | Bergen | New Jersey | 34003 | 172553 | 3088 |
2084913 | 2084913 | 2022-01-05 | Burlington | New Jersey | 34005 | 77167 | 1022 |
2084914 | 2084914 | 2022-01-05 | Camden | New Jersey | 34007 | 94521 | 1532 |
2084915 | 2084915 | 2022-01-05 | Cape May | New Jersey | 34009 | 17611 | 252 |
2084916 | 2084916 | 2022-01-05 | Cumberland | New Jersey | 34011 | 27588 | 523 |
2084917 | 2084917 | 2022-01-05 | Essex | New Jersey | 34013 | 170220 | 3219 |
2084918 | 2084918 | 2022-01-05 | Gloucester | New Jersey | 34015 | 53422 | 793 |
2084919 | 2084919 | 2022-01-05 | Hudson | New Jersey | 34017 | 130898 | 2457 |
2084920 | 2084920 | 2022-01-05 | Hunterdon | New Jersey | 34019 | 18150 | 207 |
2084921 | 2084921 | 2022-01-05 | Mercer | New Jersey | 34021 | 56241 | 1082 |
2084922 | 2084922 | 2022-01-05 | Middlesex | New Jersey | 34023 | 148452 | 2570 |
2084923 | 2084923 | 2022-01-05 | Monmouth | New Jersey | 34025 | 130654 | 1832 |
2084924 | 2084924 | 2022-01-05 | Morris | New Jersey | 34027 | 88262 | 1354 |
2084925 | 2084925 | 2022-01-05 | Ocean | New Jersey | 34029 | 128969 | 2488 |
2084926 | 2084926 | 2022-01-05 | Passaic | New Jersey | 34031 | 114539 | 2083 |
2084927 | 2084927 | 2022-01-05 | Salem | New Jersey | 34033 | 10940 | 218 |
2084928 | 2084928 | 2022-01-05 | Somerset | New Jersey | 34035 | 52289 | 909 |
2084929 | 2084929 | 2022-01-05 | Sussex | New Jersey | 34037 | 26588 | 377 |
2084930 | 2084930 | 2022-01-05 | Union | New Jersey | 34039 | 115027 | 2092 |
2084931 | 2084931 | 2022-01-05 | Unknown | New Jersey | 6835 | 0 | |
2084932 | 2084932 | 2022-01-05 | Warren | New Jersey | 34041 | 18371 | 282 |
2081659 | 2081659 | 2022-01-04 | Atlantic | New Jersey | 34001 | 51387 | 827 |
2081660 | 2081660 | 2022-01-04 | Bergen | New Jersey | 34003 | 168644 | 3083 |
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);