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 |
---|---|---|---|---|---|---|---|
1055297 | 1055297 | 2021-02-22 | Atlantic | New Jersey | 34001 | 24207 | 552 |
1055298 | 1055298 | 2021-02-22 | Bergen | New Jersey | 34003 | 75062 | 2592 |
1055299 | 1055299 | 2021-02-22 | Burlington | New Jersey | 34005 | 34677 | 733 |
1055300 | 1055300 | 2021-02-22 | Camden | New Jersey | 34007 | 43390 | 1115 |
1055301 | 1055301 | 2021-02-22 | Cape May | New Jersey | 34009 | 7007 | 178 |
1055302 | 1055302 | 2021-02-22 | Cumberland | New Jersey | 34011 | 14011 | 350 |
1055303 | 1055303 | 2021-02-22 | Essex | New Jersey | 34013 | 71834 | 2648 |
1055304 | 1055304 | 2021-02-22 | Gloucester | New Jersey | 34015 | 23719 | 530 |
1055305 | 1055305 | 2021-02-22 | Hudson | New Jersey | 34017 | 67349 | 1973 |
1055306 | 1055306 | 2021-02-22 | Hunterdon | New Jersey | 34019 | 6699 | 156 |
1055307 | 1055307 | 2021-02-22 | Mercer | New Jersey | 34021 | 27236 | 864 |
1055308 | 1055308 | 2021-02-22 | Middlesex | New Jersey | 34023 | 70874 | 2061 |
1055309 | 1055309 | 2021-02-22 | Monmouth | New Jersey | 34025 | 55082 | 1376 |
1055310 | 1055310 | 2021-02-22 | Morris | New Jersey | 34027 | 36515 | 1111 |
1055311 | 1055311 | 2021-02-22 | Ocean | New Jersey | 34029 | 56895 | 1813 |
1055312 | 1055312 | 2021-02-22 | Passaic | New Jersey | 34031 | 55755 | 1663 |
1055313 | 1055313 | 2021-02-22 | Salem | New Jersey | 34033 | 4602 | 162 |
1055314 | 1055314 | 2021-02-22 | Somerset | New Jersey | 34035 | 22171 | 776 |
1055315 | 1055315 | 2021-02-22 | Sussex | New Jersey | 34037 | 8850 | 269 |
1055316 | 1055316 | 2021-02-22 | Union | New Jersey | 34039 | 55484 | 1739 |
1055317 | 1055317 | 2021-02-22 | Unknown | New Jersey | 875 | 0 | |
1055318 | 1055318 | 2021-02-22 | Warren | New Jersey | 34041 | 6815 | 213 |
1052050 | 1052050 | 2021-02-21 | Atlantic | New Jersey | 34001 | 24131 | 551 |
1052051 | 1052051 | 2021-02-21 | Bergen | New Jersey | 34003 | 74698 | 2590 |
1052052 | 1052052 | 2021-02-21 | Burlington | New Jersey | 34005 | 34585 | 732 |
1052053 | 1052053 | 2021-02-21 | Camden | New Jersey | 34007 | 43261 | 1115 |
1052054 | 1052054 | 2021-02-21 | Cape May | New Jersey | 34009 | 6974 | 177 |
1052055 | 1052055 | 2021-02-21 | Cumberland | New Jersey | 34011 | 13955 | 350 |
1052056 | 1052056 | 2021-02-21 | Essex | New Jersey | 34013 | 71598 | 2643 |
1052057 | 1052057 | 2021-02-21 | Gloucester | New Jersey | 34015 | 23655 | 531 |
1052058 | 1052058 | 2021-02-21 | Hudson | New Jersey | 34017 | 67061 | 1972 |
1052059 | 1052059 | 2021-02-21 | Hunterdon | New Jersey | 34019 | 6673 | 156 |
1052060 | 1052060 | 2021-02-21 | Mercer | New Jersey | 34021 | 27147 | 864 |
1052061 | 1052061 | 2021-02-21 | Middlesex | New Jersey | 34023 | 70680 | 2061 |
1052062 | 1052062 | 2021-02-21 | Monmouth | New Jersey | 34025 | 54892 | 1376 |
1052063 | 1052063 | 2021-02-21 | Morris | New Jersey | 34027 | 36343 | 1110 |
1052064 | 1052064 | 2021-02-21 | Ocean | New Jersey | 34029 | 56646 | 1812 |
1052065 | 1052065 | 2021-02-21 | Passaic | New Jersey | 34031 | 55639 | 1661 |
1052066 | 1052066 | 2021-02-21 | Salem | New Jersey | 34033 | 4592 | 162 |
1052067 | 1052067 | 2021-02-21 | Somerset | New Jersey | 34035 | 22093 | 776 |
1052068 | 1052068 | 2021-02-21 | Sussex | New Jersey | 34037 | 8815 | 269 |
1052069 | 1052069 | 2021-02-21 | Union | New Jersey | 34039 | 55306 | 1737 |
1052070 | 1052070 | 2021-02-21 | Unknown | New Jersey | 866 | 0 | |
1052071 | 1052071 | 2021-02-21 | Warren | New Jersey | 34041 | 6795 | 213 |
1048803 | 1048803 | 2021-02-20 | Atlantic | New Jersey | 34001 | 24048 | 551 |
1048804 | 1048804 | 2021-02-20 | Bergen | New Jersey | 34003 | 74471 | 2588 |
1048805 | 1048805 | 2021-02-20 | Burlington | New Jersey | 34005 | 34473 | 730 |
1048806 | 1048806 | 2021-02-20 | Camden | New Jersey | 34007 | 43169 | 1115 |
1048807 | 1048807 | 2021-02-20 | Cape May | New Jersey | 34009 | 6938 | 177 |
1048808 | 1048808 | 2021-02-20 | Cumberland | New Jersey | 34011 | 13938 | 349 |
1048809 | 1048809 | 2021-02-20 | Essex | New Jersey | 34013 | 71449 | 2639 |
1048810 | 1048810 | 2021-02-20 | Gloucester | New Jersey | 34015 | 23602 | 531 |
1048811 | 1048811 | 2021-02-20 | Hudson | New Jersey | 34017 | 66897 | 1967 |
1048812 | 1048812 | 2021-02-20 | Hunterdon | New Jersey | 34019 | 6658 | 156 |
1048813 | 1048813 | 2021-02-20 | Mercer | New Jersey | 34021 | 27098 | 862 |
1048814 | 1048814 | 2021-02-20 | Middlesex | New Jersey | 34023 | 70503 | 2060 |
1048815 | 1048815 | 2021-02-20 | Monmouth | New Jersey | 34025 | 54680 | 1374 |
1048816 | 1048816 | 2021-02-20 | Morris | New Jersey | 34027 | 36220 | 1109 |
1048817 | 1048817 | 2021-02-20 | Ocean | New Jersey | 34029 | 56459 | 1810 |
1048818 | 1048818 | 2021-02-20 | Passaic | New Jersey | 34031 | 55529 | 1661 |
1048819 | 1048819 | 2021-02-20 | Salem | New Jersey | 34033 | 4585 | 162 |
1048820 | 1048820 | 2021-02-20 | Somerset | New Jersey | 34035 | 22034 | 776 |
1048821 | 1048821 | 2021-02-20 | Sussex | New Jersey | 34037 | 8797 | 269 |
1048822 | 1048822 | 2021-02-20 | Union | New Jersey | 34039 | 55207 | 1735 |
1048823 | 1048823 | 2021-02-20 | Unknown | New Jersey | 851 | 0 | |
1048824 | 1048824 | 2021-02-20 | Warren | New Jersey | 34041 | 6768 | 213 |
1045557 | 1045557 | 2021-02-19 | Atlantic | New Jersey | 34001 | 23909 | 549 |
1045558 | 1045558 | 2021-02-19 | Bergen | New Jersey | 34003 | 74126 | 2583 |
1045559 | 1045559 | 2021-02-19 | Burlington | New Jersey | 34005 | 34230 | 729 |
1045560 | 1045560 | 2021-02-19 | Camden | New Jersey | 34007 | 43042 | 1111 |
1045561 | 1045561 | 2021-02-19 | Cape May | New Jersey | 34009 | 6902 | 176 |
1045562 | 1045562 | 2021-02-19 | Cumberland | New Jersey | 34011 | 13871 | 349 |
1045563 | 1045563 | 2021-02-19 | Essex | New Jersey | 34013 | 71178 | 2634 |
1045564 | 1045564 | 2021-02-19 | Gloucester | New Jersey | 34015 | 23511 | 528 |
1045565 | 1045565 | 2021-02-19 | Hudson | New Jersey | 34017 | 66716 | 1965 |
1045566 | 1045566 | 2021-02-19 | Hunterdon | New Jersey | 34019 | 6615 | 156 |
1045567 | 1045567 | 2021-02-19 | Mercer | New Jersey | 34021 | 27015 | 860 |
1045568 | 1045568 | 2021-02-19 | Middlesex | New Jersey | 34023 | 70279 | 2057 |
1045569 | 1045569 | 2021-02-19 | Monmouth | New Jersey | 34025 | 54467 | 1370 |
1045570 | 1045570 | 2021-02-19 | Morris | New Jersey | 34027 | 36077 | 1103 |
1045571 | 1045571 | 2021-02-19 | Ocean | New Jersey | 34029 | 56273 | 1806 |
1045572 | 1045572 | 2021-02-19 | Passaic | New Jersey | 34031 | 55408 | 1660 |
1045573 | 1045573 | 2021-02-19 | Salem | New Jersey | 34033 | 4576 | 160 |
1045574 | 1045574 | 2021-02-19 | Somerset | New Jersey | 34035 | 21937 | 777 |
1045575 | 1045575 | 2021-02-19 | Sussex | New Jersey | 34037 | 8750 | 268 |
1045576 | 1045576 | 2021-02-19 | Union | New Jersey | 34039 | 55029 | 1732 |
1045577 | 1045577 | 2021-02-19 | Unknown | New Jersey | 849 | 0 | |
1045578 | 1045578 | 2021-02-19 | Warren | New Jersey | 34041 | 6736 | 211 |
1042312 | 1042312 | 2021-02-18 | Atlantic | New Jersey | 34001 | 23833 | 546 |
1042313 | 1042313 | 2021-02-18 | Bergen | New Jersey | 34003 | 73819 | 2572 |
1042314 | 1042314 | 2021-02-18 | Burlington | New Jersey | 34005 | 34132 | 726 |
1042315 | 1042315 | 2021-02-18 | Camden | New Jersey | 34007 | 42934 | 1108 |
1042316 | 1042316 | 2021-02-18 | Cape May | New Jersey | 34009 | 6881 | 176 |
1042317 | 1042317 | 2021-02-18 | Cumberland | New Jersey | 34011 | 13823 | 346 |
1042318 | 1042318 | 2021-02-18 | Essex | New Jersey | 34013 | 70899 | 2630 |
1042319 | 1042319 | 2021-02-18 | Gloucester | New Jersey | 34015 | 23441 | 526 |
1042320 | 1042320 | 2021-02-18 | Hudson | New Jersey | 34017 | 66417 | 1961 |
1042321 | 1042321 | 2021-02-18 | Hunterdon | New Jersey | 34019 | 6590 | 155 |
1042322 | 1042322 | 2021-02-18 | Mercer | New Jersey | 34021 | 26919 | 859 |
1042323 | 1042323 | 2021-02-18 | Middlesex | New Jersey | 34023 | 69979 | 2051 |
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);