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 |
---|---|---|---|---|---|---|---|
536205 | 536205 | 2020-09-15 | Atlantic | New Jersey | 34001 | 3922 | 254 |
536206 | 536206 | 2020-09-15 | Bergen | New Jersey | 34003 | 22242 | 2042 |
536207 | 536207 | 2020-09-15 | Burlington | New Jersey | 34005 | 6821 | 490 |
536208 | 536208 | 2020-09-15 | Camden | New Jersey | 34007 | 9587 | 600 |
536209 | 536209 | 2020-09-15 | Cape May | New Jersey | 34009 | 989 | 94 |
536210 | 536210 | 2020-09-15 | Cumberland | New Jersey | 34011 | 3708 | 157 |
536211 | 536211 | 2020-09-15 | Essex | New Jersey | 34013 | 20931 | 2122 |
536212 | 536212 | 2020-09-15 | Gloucester | New Jersey | 34015 | 4154 | 224 |
536213 | 536213 | 2020-09-15 | Hudson | New Jersey | 34017 | 20563 | 1512 |
536214 | 536214 | 2020-09-15 | Hunterdon | New Jersey | 34019 | 1318 | 125 |
536215 | 536215 | 2020-09-15 | Mercer | New Jersey | 34021 | 8546 | 634 |
536216 | 536216 | 2020-09-15 | Middlesex | New Jersey | 34023 | 19111 | 1423 |
536217 | 536217 | 2020-09-15 | Monmouth | New Jersey | 34025 | 11360 | 864 |
536218 | 536218 | 2020-09-15 | Morris | New Jersey | 34027 | 7816 | 831 |
536219 | 536219 | 2020-09-15 | Ocean | New Jersey | 34029 | 11885 | 1038 |
536220 | 536220 | 2020-09-15 | Passaic | New Jersey | 34031 | 18833 | 1251 |
536221 | 536221 | 2020-09-15 | Salem | New Jersey | 34033 | 1028 | 89 |
536222 | 536222 | 2020-09-15 | Somerset | New Jersey | 34035 | 5670 | 568 |
536223 | 536223 | 2020-09-15 | Sussex | New Jersey | 34037 | 1467 | 198 |
536224 | 536224 | 2020-09-15 | Union | New Jersey | 34039 | 17503 | 1356 |
536225 | 536225 | 2020-09-15 | Unknown | New Jersey | 301 | 0 | |
536226 | 536226 | 2020-09-15 | Warren | New Jersey | 34041 | 1438 | 171 |
532970 | 532970 | 2020-09-14 | Atlantic | New Jersey | 34001 | 3906 | 253 |
532971 | 532971 | 2020-09-14 | Bergen | New Jersey | 34003 | 22238 | 2042 |
532972 | 532972 | 2020-09-14 | Burlington | New Jersey | 34005 | 6786 | 489 |
532973 | 532973 | 2020-09-14 | Camden | New Jersey | 34007 | 9559 | 598 |
532974 | 532974 | 2020-09-14 | Cape May | New Jersey | 34009 | 975 | 94 |
532975 | 532975 | 2020-09-14 | Cumberland | New Jersey | 34011 | 3706 | 157 |
532976 | 532976 | 2020-09-14 | Essex | New Jersey | 34013 | 20898 | 2123 |
532977 | 532977 | 2020-09-14 | Gloucester | New Jersey | 34015 | 4089 | 224 |
532978 | 532978 | 2020-09-14 | Hudson | New Jersey | 34017 | 20545 | 1512 |
532979 | 532979 | 2020-09-14 | Hunterdon | New Jersey | 34019 | 1318 | 125 |
532980 | 532980 | 2020-09-14 | Mercer | New Jersey | 34021 | 8534 | 634 |
532981 | 532981 | 2020-09-14 | Middlesex | New Jersey | 34023 | 19072 | 1422 |
532982 | 532982 | 2020-09-14 | Monmouth | New Jersey | 34025 | 11309 | 863 |
532983 | 532983 | 2020-09-14 | Morris | New Jersey | 34027 | 7792 | 831 |
532984 | 532984 | 2020-09-14 | Ocean | New Jersey | 34029 | 11838 | 1037 |
532985 | 532985 | 2020-09-14 | Passaic | New Jersey | 34031 | 18816 | 1249 |
532986 | 532986 | 2020-09-14 | Salem | New Jersey | 34033 | 1022 | 89 |
532987 | 532987 | 2020-09-14 | Somerset | New Jersey | 34035 | 5649 | 568 |
532988 | 532988 | 2020-09-14 | Sussex | New Jersey | 34037 | 1465 | 198 |
532989 | 532989 | 2020-09-14 | Union | New Jersey | 34039 | 17490 | 1355 |
532990 | 532990 | 2020-09-14 | Unknown | New Jersey | 313 | 0 | |
532991 | 532991 | 2020-09-14 | Warren | New Jersey | 34041 | 1437 | 171 |
529734 | 529734 | 2020-09-13 | Atlantic | New Jersey | 34001 | 3898 | 253 |
529735 | 529735 | 2020-09-13 | Bergen | New Jersey | 34003 | 22209 | 2042 |
529736 | 529736 | 2020-09-13 | Burlington | New Jersey | 34005 | 6755 | 488 |
529737 | 529737 | 2020-09-13 | Camden | New Jersey | 34007 | 9529 | 597 |
529738 | 529738 | 2020-09-13 | Cape May | New Jersey | 34009 | 970 | 94 |
529739 | 529739 | 2020-09-13 | Cumberland | New Jersey | 34011 | 3696 | 157 |
529740 | 529740 | 2020-09-13 | Essex | New Jersey | 34013 | 20886 | 2123 |
529741 | 529741 | 2020-09-13 | Gloucester | New Jersey | 34015 | 4065 | 224 |
529742 | 529742 | 2020-09-13 | Hudson | New Jersey | 34017 | 20531 | 1512 |
529743 | 529743 | 2020-09-13 | Hunterdon | New Jersey | 34019 | 1310 | 125 |
529744 | 529744 | 2020-09-13 | Mercer | New Jersey | 34021 | 8527 | 634 |
529745 | 529745 | 2020-09-13 | Middlesex | New Jersey | 34023 | 19044 | 1422 |
529746 | 529746 | 2020-09-13 | Monmouth | New Jersey | 34025 | 11282 | 863 |
529747 | 529747 | 2020-09-13 | Morris | New Jersey | 34027 | 7773 | 831 |
529748 | 529748 | 2020-09-13 | Ocean | New Jersey | 34029 | 11807 | 1036 |
529749 | 529749 | 2020-09-13 | Passaic | New Jersey | 34031 | 18804 | 1249 |
529750 | 529750 | 2020-09-13 | Salem | New Jersey | 34033 | 1020 | 89 |
529751 | 529751 | 2020-09-13 | Somerset | New Jersey | 34035 | 5632 | 568 |
529752 | 529752 | 2020-09-13 | Sussex | New Jersey | 34037 | 1462 | 198 |
529753 | 529753 | 2020-09-13 | Union | New Jersey | 34039 | 17481 | 1355 |
529754 | 529754 | 2020-09-13 | Unknown | New Jersey | 311 | 0 | |
529755 | 529755 | 2020-09-13 | Warren | New Jersey | 34041 | 1431 | 171 |
526498 | 526498 | 2020-09-12 | Atlantic | New Jersey | 34001 | 3886 | 253 |
526499 | 526499 | 2020-09-12 | Bergen | New Jersey | 34003 | 22178 | 2041 |
526500 | 526500 | 2020-09-12 | Burlington | New Jersey | 34005 | 6733 | 487 |
526501 | 526501 | 2020-09-12 | Camden | New Jersey | 34007 | 9513 | 596 |
526502 | 526502 | 2020-09-12 | Cape May | New Jersey | 34009 | 971 | 94 |
526503 | 526503 | 2020-09-12 | Cumberland | New Jersey | 34011 | 3692 | 157 |
526504 | 526504 | 2020-09-12 | Essex | New Jersey | 34013 | 20862 | 2123 |
526505 | 526505 | 2020-09-12 | Gloucester | New Jersey | 34015 | 4034 | 224 |
526506 | 526506 | 2020-09-12 | Hudson | New Jersey | 34017 | 20522 | 1512 |
526507 | 526507 | 2020-09-12 | Hunterdon | New Jersey | 34019 | 1307 | 125 |
526508 | 526508 | 2020-09-12 | Mercer | New Jersey | 34021 | 8517 | 634 |
526509 | 526509 | 2020-09-12 | Middlesex | New Jersey | 34023 | 19016 | 1422 |
526510 | 526510 | 2020-09-12 | Monmouth | New Jersey | 34025 | 11250 | 863 |
526511 | 526511 | 2020-09-12 | Morris | New Jersey | 34027 | 7775 | 831 |
526512 | 526512 | 2020-09-12 | Ocean | New Jersey | 34029 | 11777 | 1036 |
526513 | 526513 | 2020-09-12 | Passaic | New Jersey | 34031 | 18783 | 1249 |
526514 | 526514 | 2020-09-12 | Salem | New Jersey | 34033 | 1020 | 89 |
526515 | 526515 | 2020-09-12 | Somerset | New Jersey | 34035 | 5626 | 568 |
526516 | 526516 | 2020-09-12 | Sussex | New Jersey | 34037 | 1462 | 198 |
526517 | 526517 | 2020-09-12 | Union | New Jersey | 34039 | 17465 | 1354 |
526518 | 526518 | 2020-09-12 | Unknown | New Jersey | 306 | 0 | |
526519 | 526519 | 2020-09-12 | Warren | New Jersey | 34041 | 1431 | 171 |
523262 | 523262 | 2020-09-11 | Atlantic | New Jersey | 34001 | 3876 | 253 |
523263 | 523263 | 2020-09-11 | Bergen | New Jersey | 34003 | 22168 | 2041 |
523264 | 523264 | 2020-09-11 | Burlington | New Jersey | 34005 | 6700 | 486 |
523265 | 523265 | 2020-09-11 | Camden | New Jersey | 34007 | 9498 | 596 |
523266 | 523266 | 2020-09-11 | Cape May | New Jersey | 34009 | 962 | 94 |
523267 | 523267 | 2020-09-11 | Cumberland | New Jersey | 34011 | 3681 | 157 |
523268 | 523268 | 2020-09-11 | Essex | New Jersey | 34013 | 20835 | 2123 |
523269 | 523269 | 2020-09-11 | Gloucester | New Jersey | 34015 | 3998 | 224 |
523270 | 523270 | 2020-09-11 | Hudson | New Jersey | 34017 | 20504 | 1512 |
523271 | 523271 | 2020-09-11 | Hunterdon | New Jersey | 34019 | 1303 | 125 |
523272 | 523272 | 2020-09-11 | Mercer | New Jersey | 34021 | 8503 | 633 |
523273 | 523273 | 2020-09-11 | Middlesex | New Jersey | 34023 | 18962 | 1422 |
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);