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 |
---|---|---|---|---|---|---|---|
1194900 | 1194900 | 2021-04-06 | Atlantic | New Jersey | 34001 | 28950 | 622 |
1194901 | 1194901 | 2021-04-06 | Bergen | New Jersey | 34003 | 94130 | 2750 |
1194902 | 1194902 | 2021-04-06 | Burlington | New Jersey | 34005 | 40959 | 797 |
1194903 | 1194903 | 2021-04-06 | Camden | New Jersey | 34007 | 49963 | 1232 |
1194904 | 1194904 | 2021-04-06 | Cape May | New Jersey | 34009 | 8451 | 197 |
1194905 | 1194905 | 2021-04-06 | Cumberland | New Jersey | 34011 | 15530 | 407 |
1194906 | 1194906 | 2021-04-06 | Essex | New Jersey | 34013 | 87641 | 2810 |
1194907 | 1194907 | 2021-04-06 | Gloucester | New Jersey | 34015 | 27518 | 582 |
1194908 | 1194908 | 2021-04-06 | Hudson | New Jersey | 34017 | 81819 | 2138 |
1194909 | 1194909 | 2021-04-06 | Hunterdon | New Jersey | 34019 | 8688 | 170 |
1194910 | 1194910 | 2021-04-06 | Mercer | New Jersey | 34021 | 31497 | 909 |
1194911 | 1194911 | 2021-04-06 | Middlesex | New Jersey | 34023 | 85647 | 2216 |
1194912 | 1194912 | 2021-04-06 | Monmouth | New Jersey | 34025 | 69781 | 1511 |
1194913 | 1194913 | 2021-04-06 | Morris | New Jersey | 34027 | 46290 | 1183 |
1194914 | 1194914 | 2021-04-06 | Ocean | New Jersey | 34029 | 70250 | 2010 |
1194915 | 1194915 | 2021-04-06 | Passaic | New Jersey | 34031 | 66120 | 1804 |
1194916 | 1194916 | 2021-04-06 | Salem | New Jersey | 34033 | 5345 | 171 |
1194917 | 1194917 | 2021-04-06 | Somerset | New Jersey | 34035 | 27496 | 809 |
1194918 | 1194918 | 2021-04-06 | Sussex | New Jersey | 34037 | 12178 | 285 |
1194919 | 1194919 | 2021-04-06 | Union | New Jersey | 34039 | 65739 | 1868 |
1194920 | 1194920 | 2021-04-06 | Unknown | New Jersey | 1030 | 0 | |
1194921 | 1194921 | 2021-04-06 | Warren | New Jersey | 34041 | 8716 | 229 |
1191651 | 1191651 | 2021-04-05 | Atlantic | New Jersey | 34001 | 28851 | 619 |
1191652 | 1191652 | 2021-04-05 | Bergen | New Jersey | 34003 | 93767 | 2748 |
1191653 | 1191653 | 2021-04-05 | Burlington | New Jersey | 34005 | 40821 | 796 |
1191654 | 1191654 | 2021-04-05 | Camden | New Jersey | 34007 | 49833 | 1230 |
1191655 | 1191655 | 2021-04-05 | Cape May | New Jersey | 34009 | 8407 | 196 |
1191656 | 1191656 | 2021-04-05 | Cumberland | New Jersey | 34011 | 15492 | 405 |
1191657 | 1191657 | 2021-04-05 | Essex | New Jersey | 34013 | 87242 | 2806 |
1191658 | 1191658 | 2021-04-05 | Gloucester | New Jersey | 34015 | 27438 | 582 |
1191659 | 1191659 | 2021-04-05 | Hudson | New Jersey | 34017 | 81520 | 2130 |
1191660 | 1191660 | 2021-04-05 | Hunterdon | New Jersey | 34019 | 8641 | 169 |
1191661 | 1191661 | 2021-04-05 | Mercer | New Jersey | 34021 | 31394 | 908 |
1191662 | 1191662 | 2021-04-05 | Middlesex | New Jersey | 34023 | 85227 | 2207 |
1191663 | 1191663 | 2021-04-05 | Monmouth | New Jersey | 34025 | 69492 | 1509 |
1191664 | 1191664 | 2021-04-05 | Morris | New Jersey | 34027 | 46036 | 1179 |
1191665 | 1191665 | 2021-04-05 | Ocean | New Jersey | 34029 | 70020 | 2009 |
1191666 | 1191666 | 2021-04-05 | Passaic | New Jersey | 34031 | 65784 | 1801 |
1191667 | 1191667 | 2021-04-05 | Salem | New Jersey | 34033 | 5325 | 170 |
1191668 | 1191668 | 2021-04-05 | Somerset | New Jersey | 34035 | 27346 | 807 |
1191669 | 1191669 | 2021-04-05 | Sussex | New Jersey | 34037 | 12114 | 284 |
1191670 | 1191670 | 2021-04-05 | Union | New Jersey | 34039 | 65522 | 1865 |
1191671 | 1191671 | 2021-04-05 | Unknown | New Jersey | 1076 | 0 | |
1191672 | 1191672 | 2021-04-05 | Warren | New Jersey | 34041 | 8678 | 229 |
1188403 | 1188403 | 2021-04-04 | Atlantic | New Jersey | 34001 | 28735 | 619 |
1188404 | 1188404 | 2021-04-04 | Bergen | New Jersey | 34003 | 93426 | 2747 |
1188405 | 1188405 | 2021-04-04 | Burlington | New Jersey | 34005 | 40699 | 795 |
1188406 | 1188406 | 2021-04-04 | Camden | New Jersey | 34007 | 49676 | 1230 |
1188407 | 1188407 | 2021-04-04 | Cape May | New Jersey | 34009 | 8381 | 196 |
1188408 | 1188408 | 2021-04-04 | Cumberland | New Jersey | 34011 | 15477 | 404 |
1188409 | 1188409 | 2021-04-04 | Essex | New Jersey | 34013 | 86986 | 2803 |
1188410 | 1188410 | 2021-04-04 | Gloucester | New Jersey | 34015 | 27370 | 580 |
1188411 | 1188411 | 2021-04-04 | Hudson | New Jersey | 34017 | 81323 | 2131 |
1188412 | 1188412 | 2021-04-04 | Hunterdon | New Jersey | 34019 | 8601 | 169 |
1188413 | 1188413 | 2021-04-04 | Mercer | New Jersey | 34021 | 31314 | 908 |
1188414 | 1188414 | 2021-04-04 | Middlesex | New Jersey | 34023 | 84939 | 2208 |
1188415 | 1188415 | 2021-04-04 | Monmouth | New Jersey | 34025 | 69268 | 1508 |
1188416 | 1188416 | 2021-04-04 | Morris | New Jersey | 34027 | 45889 | 1179 |
1188417 | 1188417 | 2021-04-04 | Ocean | New Jersey | 34029 | 69787 | 2009 |
1188418 | 1188418 | 2021-04-04 | Passaic | New Jersey | 34031 | 65636 | 1798 |
1188419 | 1188419 | 2021-04-04 | Salem | New Jersey | 34033 | 5309 | 170 |
1188420 | 1188420 | 2021-04-04 | Somerset | New Jersey | 34035 | 27268 | 807 |
1188421 | 1188421 | 2021-04-04 | Sussex | New Jersey | 34037 | 12034 | 284 |
1188422 | 1188422 | 2021-04-04 | Union | New Jersey | 34039 | 65354 | 1864 |
1188423 | 1188423 | 2021-04-04 | Unknown | New Jersey | 1073 | 0 | |
1188424 | 1188424 | 2021-04-04 | Warren | New Jersey | 34041 | 8650 | 228 |
1185156 | 1185156 | 2021-04-03 | Atlantic | New Jersey | 34001 | 28634 | 618 |
1185157 | 1185157 | 2021-04-03 | Bergen | New Jersey | 34003 | 93058 | 2748 |
1185158 | 1185158 | 2021-04-03 | Burlington | New Jersey | 34005 | 40494 | 796 |
1185159 | 1185159 | 2021-04-03 | Camden | New Jersey | 34007 | 49468 | 1228 |
1185160 | 1185160 | 2021-04-03 | Cape May | New Jersey | 34009 | 8366 | 196 |
1185161 | 1185161 | 2021-04-03 | Cumberland | New Jersey | 34011 | 15456 | 404 |
1185162 | 1185162 | 2021-04-03 | Essex | New Jersey | 34013 | 86518 | 2800 |
1185163 | 1185163 | 2021-04-03 | Gloucester | New Jersey | 34015 | 27274 | 580 |
1185164 | 1185164 | 2021-04-03 | Hudson | New Jersey | 34017 | 80996 | 2131 |
1185165 | 1185165 | 2021-04-03 | Hunterdon | New Jersey | 34019 | 8548 | 170 |
1185166 | 1185166 | 2021-04-03 | Mercer | New Jersey | 34021 | 31224 | 909 |
1185167 | 1185167 | 2021-04-03 | Middlesex | New Jersey | 34023 | 84593 | 2208 |
1185168 | 1185168 | 2021-04-03 | Monmouth | New Jersey | 34025 | 69024 | 1508 |
1185169 | 1185169 | 2021-04-03 | Morris | New Jersey | 34027 | 45670 | 1179 |
1185170 | 1185170 | 2021-04-03 | Ocean | New Jersey | 34029 | 69463 | 2007 |
1185171 | 1185171 | 2021-04-03 | Passaic | New Jersey | 34031 | 65413 | 1797 |
1185172 | 1185172 | 2021-04-03 | Salem | New Jersey | 34033 | 5290 | 170 |
1185173 | 1185173 | 2021-04-03 | Somerset | New Jersey | 34035 | 27160 | 807 |
1185174 | 1185174 | 2021-04-03 | Sussex | New Jersey | 34037 | 11937 | 284 |
1185175 | 1185175 | 2021-04-03 | Union | New Jersey | 34039 | 65130 | 1864 |
1185176 | 1185176 | 2021-04-03 | Unknown | New Jersey | 1071 | 0 | |
1185177 | 1185177 | 2021-04-03 | Warren | New Jersey | 34041 | 8607 | 228 |
1181909 | 1181909 | 2021-04-02 | Atlantic | New Jersey | 34001 | 28475 | 619 |
1181910 | 1181910 | 2021-04-02 | Bergen | New Jersey | 34003 | 92547 | 2745 |
1181911 | 1181911 | 2021-04-02 | Burlington | New Jersey | 34005 | 40316 | 795 |
1181912 | 1181912 | 2021-04-02 | Camden | New Jersey | 34007 | 49223 | 1228 |
1181913 | 1181913 | 2021-04-02 | Cape May | New Jersey | 34009 | 8323 | 195 |
1181914 | 1181914 | 2021-04-02 | Cumberland | New Jersey | 34011 | 15421 | 404 |
1181915 | 1181915 | 2021-04-02 | Essex | New Jersey | 34013 | 86128 | 2799 |
1181916 | 1181916 | 2021-04-02 | Gloucester | New Jersey | 34015 | 27155 | 579 |
1181917 | 1181917 | 2021-04-02 | Hudson | New Jersey | 34017 | 80614 | 2129 |
1181918 | 1181918 | 2021-04-02 | Hunterdon | New Jersey | 34019 | 8492 | 169 |
1181919 | 1181919 | 2021-04-02 | Mercer | New Jersey | 34021 | 31120 | 908 |
1181920 | 1181920 | 2021-04-02 | Middlesex | New Jersey | 34023 | 84176 | 2208 |
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);