ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 22

county 22

state 1

  • New Jersey · 17,417 ✖
Link rowid date ▲ county state fips cases deaths
2501372 2501372 2022-05-13 Atlantic New Jersey 34001 70482 997
2501373 2501373 2022-05-13 Bergen New Jersey 34003 239353 3458
2501374 2501374 2022-05-13 Burlington New Jersey 34005 106935 1210
2501375 2501375 2022-05-13 Camden New Jersey 34007 130289 1807
2501376 2501376 2022-05-13 Cape May New Jersey 34009 22796 304
2501377 2501377 2022-05-13 Cumberland New Jersey 34011 40389 605
2501378 2501378 2022-05-13 Essex New Jersey 34013 222558 3614
2501379 2501379 2022-05-13 Gloucester New Jersey 34015 71942 968
2501380 2501380 2022-05-13 Hudson New Jersey 34017 179135 2721
2501381 2501381 2022-05-13 Hunterdon New Jersey 34019 26017 275
2501382 2501382 2022-05-13 Mercer New Jersey 34021 80988 1261
2501383 2501383 2022-05-13 Middlesex New Jersey 34023 204363 2877
2501384 2501384 2022-05-13 Monmouth New Jersey 34025 172251 2180
2501385 2501385 2022-05-13 Morris New Jersey 34027 125971 1550
2501386 2501386 2022-05-13 Ocean New Jersey 34029 168238 2975
2501387 2501387 2022-05-13 Passaic New Jersey 34031 149761 2337
2501388 2501388 2022-05-13 Salem New Jersey 34033 14662 250
2501389 2501389 2022-05-13 Somerset New Jersey 34035 72382 975
2501390 2501390 2022-05-13 Sussex New Jersey 34037 35481 476
2501391 2501391 2022-05-13 Union New Jersey 34039 151057 2355
2501392 2501392 2022-05-13 Unknown New Jersey   3174 0
2501393 2501393 2022-05-13 Warren New Jersey 34041 24838 342
2498114 2498114 2022-05-12 Atlantic New Jersey 34001 70346 996
2498115 2498115 2022-05-12 Bergen New Jersey 34003 238428 3455
2498116 2498116 2022-05-12 Burlington New Jersey 34005 106613 1209
2498117 2498117 2022-05-12 Camden New Jersey 34007 129945 1807
2498118 2498118 2022-05-12 Cape May New Jersey 34009 22743 304
2498119 2498119 2022-05-12 Cumberland New Jersey 34011 40323 605
2498120 2498120 2022-05-12 Essex New Jersey 34013 221984 3612
2498121 2498121 2022-05-12 Gloucester New Jersey 34015 71756 968
2498122 2498122 2022-05-12 Hudson New Jersey 34017 178658 2721
2498123 2498123 2022-05-12 Hunterdon New Jersey 34019 25907 275
2498124 2498124 2022-05-12 Mercer New Jersey 34021 80762 1261
2498125 2498125 2022-05-12 Middlesex New Jersey 34023 203696 2877
2498126 2498126 2022-05-12 Monmouth New Jersey 34025 171810 2180
2498127 2498127 2022-05-12 Morris New Jersey 34027 125555 1549
2498128 2498128 2022-05-12 Ocean New Jersey 34029 167923 2975
2498129 2498129 2022-05-12 Passaic New Jersey 34031 149431 2337
2498130 2498130 2022-05-12 Salem New Jersey 34033 14639 250
2498131 2498131 2022-05-12 Somerset New Jersey 34035 72097 975
2498132 2498132 2022-05-12 Sussex New Jersey 34037 35397 476
2498133 2498133 2022-05-12 Union New Jersey 34039 150590 2355
2498134 2498134 2022-05-12 Unknown New Jersey   3200 0
2498135 2498135 2022-05-12 Warren New Jersey 34041 24771 342
2494856 2494856 2022-05-11 Atlantic New Jersey 34001 70222 996
2494857 2494857 2022-05-11 Bergen New Jersey 34003 237703 3452
2494858 2494858 2022-05-11 Burlington New Jersey 34005 106147 1208
2494859 2494859 2022-05-11 Camden New Jersey 34007 129462 1807
2494860 2494860 2022-05-11 Cape May New Jersey 34009 22701 304
2494861 2494861 2022-05-11 Cumberland New Jersey 34011 40276 605
2494862 2494862 2022-05-11 Essex New Jersey 34013 221477 3611
2494863 2494863 2022-05-11 Gloucester New Jersey 34015 71513 968
2494864 2494864 2022-05-11 Hudson New Jersey 34017 178250 2721
2494865 2494865 2022-05-11 Hunterdon New Jersey 34019 25817 275
2494866 2494866 2022-05-11 Mercer New Jersey 34021 80363 1261
2494867 2494867 2022-05-11 Middlesex New Jersey 34023 203132 2877
2494868 2494868 2022-05-11 Monmouth New Jersey 34025 171404 2179
2494869 2494869 2022-05-11 Morris New Jersey 34027 125170 1547
2494870 2494870 2022-05-11 Ocean New Jersey 34029 167598 2974
2494871 2494871 2022-05-11 Passaic New Jersey 34031 149168 2337
2494872 2494872 2022-05-11 Salem New Jersey 34033 14629 249
2494873 2494873 2022-05-11 Somerset New Jersey 34035 71849 975
2494874 2494874 2022-05-11 Sussex New Jersey 34037 35296 475
2494875 2494875 2022-05-11 Union New Jersey 34039 150301 2354
2494876 2494876 2022-05-11 Unknown New Jersey   3207 0
2494877 2494877 2022-05-11 Warren New Jersey 34041 24722 342
2491598 2491598 2022-05-10 Atlantic New Jersey 34001 70111 995
2491599 2491599 2022-05-10 Bergen New Jersey 34003 236987 3451
2491600 2491600 2022-05-10 Burlington New Jersey 34005 105926 1208
2491601 2491601 2022-05-10 Camden New Jersey 34007 129218 1806
2491602 2491602 2022-05-10 Cape May New Jersey 34009 22655 304
2491603 2491603 2022-05-10 Cumberland New Jersey 34011 40215 605
2491604 2491604 2022-05-10 Essex New Jersey 34013 221033 3611
2491605 2491605 2022-05-10 Gloucester New Jersey 34015 71418 966
2491606 2491606 2022-05-10 Hudson New Jersey 34017 177875 2721
2491607 2491607 2022-05-10 Hunterdon New Jersey 34019 25758 275
2491608 2491608 2022-05-10 Mercer New Jersey 34021 80165 1261
2491609 2491609 2022-05-10 Middlesex New Jersey 34023 202679 2877
2491610 2491610 2022-05-10 Monmouth New Jersey 34025 171009 2178
2491611 2491611 2022-05-10 Morris New Jersey 34027 124829 1546
2491612 2491612 2022-05-10 Ocean New Jersey 34029 167312 2970
2491613 2491613 2022-05-10 Passaic New Jersey 34031 148918 2336
2491614 2491614 2022-05-10 Salem New Jersey 34033 14599 248
2491615 2491615 2022-05-10 Somerset New Jersey 34035 71645 975
2491616 2491616 2022-05-10 Sussex New Jersey 34037 35223 475
2491617 2491617 2022-05-10 Union New Jersey 34039 150022 2353
2491618 2491618 2022-05-10 Unknown New Jersey   3204 0
2491619 2491619 2022-05-10 Warren New Jersey 34041 24681 342
2488340 2488340 2022-05-09 Atlantic New Jersey 34001 70029 995
2488341 2488341 2022-05-09 Bergen New Jersey 34003 236300 3450
2488342 2488342 2022-05-09 Burlington New Jersey 34005 105717 1207
2488343 2488343 2022-05-09 Camden New Jersey 34007 128950 1805
2488344 2488344 2022-05-09 Cape May New Jersey 34009 22605 304
2488345 2488345 2022-05-09 Cumberland New Jersey 34011 40175 605
2488346 2488346 2022-05-09 Essex New Jersey 34013 220683 3611
2488347 2488347 2022-05-09 Gloucester New Jersey 34015 71299 965
2488348 2488348 2022-05-09 Hudson New Jersey 34017 177597 2721
2488349 2488349 2022-05-09 Hunterdon New Jersey 34019 25694 275
2488350 2488350 2022-05-09 Mercer New Jersey 34021 80000 1260
2488351 2488351 2022-05-09 Middlesex New Jersey 34023 202177 2877

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);