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 |
---|---|---|---|---|---|---|---|
523274 | 523274 | 2020-09-11 | Monmouth | New Jersey | 34025 | 11194 | 863 |
523275 | 523275 | 2020-09-11 | Morris | New Jersey | 34027 | 7755 | 831 |
523276 | 523276 | 2020-09-11 | Ocean | New Jersey | 34029 | 11719 | 1034 |
523277 | 523277 | 2020-09-11 | Passaic | New Jersey | 34031 | 18751 | 1249 |
523278 | 523278 | 2020-09-11 | Salem | New Jersey | 34033 | 1013 | 89 |
523279 | 523279 | 2020-09-11 | Somerset | New Jersey | 34035 | 5603 | 568 |
523280 | 523280 | 2020-09-11 | Sussex | New Jersey | 34037 | 1459 | 198 |
523281 | 523281 | 2020-09-11 | Union | New Jersey | 34039 | 17452 | 1354 |
523282 | 523282 | 2020-09-11 | Unknown | New Jersey | 313 | 0 | |
523283 | 523283 | 2020-09-11 | Warren | New Jersey | 34041 | 1428 | 171 |
520025 | 520025 | 2020-09-10 | Atlantic | New Jersey | 34001 | 3860 | 253 |
520026 | 520026 | 2020-09-10 | Bergen | New Jersey | 34003 | 22137 | 2040 |
520027 | 520027 | 2020-09-10 | Burlington | New Jersey | 34005 | 6680 | 485 |
520028 | 520028 | 2020-09-10 | Camden | New Jersey | 34007 | 9466 | 595 |
520029 | 520029 | 2020-09-10 | Cape May | New Jersey | 34009 | 956 | 94 |
520030 | 520030 | 2020-09-10 | Cumberland | New Jersey | 34011 | 3671 | 157 |
520031 | 520031 | 2020-09-10 | Essex | New Jersey | 34013 | 20820 | 2121 |
520032 | 520032 | 2020-09-10 | Gloucester | New Jersey | 34015 | 3952 | 223 |
520033 | 520033 | 2020-09-10 | Hudson | New Jersey | 34017 | 20489 | 1512 |
520034 | 520034 | 2020-09-10 | Hunterdon | New Jersey | 34019 | 1299 | 125 |
520035 | 520035 | 2020-09-10 | Mercer | New Jersey | 34021 | 8491 | 633 |
520036 | 520036 | 2020-09-10 | Middlesex | New Jersey | 34023 | 18905 | 1423 |
520037 | 520037 | 2020-09-10 | Monmouth | New Jersey | 34025 | 11135 | 860 |
520038 | 520038 | 2020-09-10 | Morris | New Jersey | 34027 | 7748 | 831 |
520039 | 520039 | 2020-09-10 | Ocean | New Jersey | 34029 | 11662 | 1034 |
520040 | 520040 | 2020-09-10 | Passaic | New Jersey | 34031 | 18722 | 1248 |
520041 | 520041 | 2020-09-10 | Salem | New Jersey | 34033 | 1009 | 89 |
520042 | 520042 | 2020-09-10 | Somerset | New Jersey | 34035 | 5582 | 568 |
520043 | 520043 | 2020-09-10 | Sussex | New Jersey | 34037 | 1453 | 198 |
520044 | 520044 | 2020-09-10 | Union | New Jersey | 34039 | 17433 | 1354 |
520045 | 520045 | 2020-09-10 | Unknown | New Jersey | 308 | 0 | |
520046 | 520046 | 2020-09-10 | Warren | New Jersey | 34041 | 1425 | 171 |
516790 | 516790 | 2020-09-09 | Atlantic | New Jersey | 34001 | 3851 | 253 |
516791 | 516791 | 2020-09-09 | Bergen | New Jersey | 34003 | 22115 | 2039 |
516792 | 516792 | 2020-09-09 | Burlington | New Jersey | 34005 | 6662 | 485 |
516793 | 516793 | 2020-09-09 | Camden | New Jersey | 34007 | 9437 | 595 |
516794 | 516794 | 2020-09-09 | Cape May | New Jersey | 34009 | 953 | 94 |
516795 | 516795 | 2020-09-09 | Cumberland | New Jersey | 34011 | 3657 | 156 |
516796 | 516796 | 2020-09-09 | Essex | New Jersey | 34013 | 20803 | 2121 |
516797 | 516797 | 2020-09-09 | Gloucester | New Jersey | 34015 | 3902 | 223 |
516798 | 516798 | 2020-09-09 | Hudson | New Jersey | 34017 | 20465 | 1512 |
516799 | 516799 | 2020-09-09 | Hunterdon | New Jersey | 34019 | 1296 | 125 |
516800 | 516800 | 2020-09-09 | Mercer | New Jersey | 34021 | 8475 | 633 |
516801 | 516801 | 2020-09-09 | Middlesex | New Jersey | 34023 | 18851 | 1421 |
516802 | 516802 | 2020-09-09 | Monmouth | New Jersey | 34025 | 11094 | 860 |
516803 | 516803 | 2020-09-09 | Morris | New Jersey | 34027 | 7741 | 831 |
516804 | 516804 | 2020-09-09 | Ocean | New Jersey | 34029 | 11607 | 1032 |
516805 | 516805 | 2020-09-09 | Passaic | New Jersey | 34031 | 18703 | 1249 |
516806 | 516806 | 2020-09-09 | Salem | New Jersey | 34033 | 1010 | 89 |
516807 | 516807 | 2020-09-09 | Somerset | New Jersey | 34035 | 5563 | 567 |
516808 | 516808 | 2020-09-09 | Sussex | New Jersey | 34037 | 1454 | 198 |
516809 | 516809 | 2020-09-09 | Union | New Jersey | 34039 | 17414 | 1355 |
516810 | 516810 | 2020-09-09 | Unknown | New Jersey | 303 | 0 | |
516811 | 516811 | 2020-09-09 | Warren | New Jersey | 34041 | 1423 | 171 |
513556 | 513556 | 2020-09-08 | Atlantic | New Jersey | 34001 | 3838 | 253 |
513557 | 513557 | 2020-09-08 | Bergen | New Jersey | 34003 | 22086 | 2038 |
513558 | 513558 | 2020-09-08 | Burlington | New Jersey | 34005 | 6645 | 483 |
513559 | 513559 | 2020-09-08 | Camden | New Jersey | 34007 | 9407 | 594 |
513560 | 513560 | 2020-09-08 | Cape May | New Jersey | 34009 | 951 | 94 |
513561 | 513561 | 2020-09-08 | Cumberland | New Jersey | 34011 | 3646 | 156 |
513562 | 513562 | 2020-09-08 | Essex | New Jersey | 34013 | 20774 | 2121 |
513563 | 513563 | 2020-09-08 | Gloucester | New Jersey | 34015 | 3860 | 223 |
513564 | 513564 | 2020-09-08 | Hudson | New Jersey | 34017 | 20453 | 1512 |
513565 | 513565 | 2020-09-08 | Hunterdon | New Jersey | 34019 | 1290 | 125 |
513566 | 513566 | 2020-09-08 | Mercer | New Jersey | 34021 | 8468 | 632 |
513567 | 513567 | 2020-09-08 | Middlesex | New Jersey | 34023 | 18826 | 1420 |
513568 | 513568 | 2020-09-08 | Monmouth | New Jersey | 34025 | 11058 | 860 |
513569 | 513569 | 2020-09-08 | Morris | New Jersey | 34027 | 7736 | 830 |
513570 | 513570 | 2020-09-08 | Ocean | New Jersey | 34029 | 11585 | 1030 |
513571 | 513571 | 2020-09-08 | Passaic | New Jersey | 34031 | 18676 | 1248 |
513572 | 513572 | 2020-09-08 | Salem | New Jersey | 34033 | 1005 | 89 |
513573 | 513573 | 2020-09-08 | Somerset | New Jersey | 34035 | 5554 | 566 |
513574 | 513574 | 2020-09-08 | Sussex | New Jersey | 34037 | 1457 | 197 |
513575 | 513575 | 2020-09-08 | Union | New Jersey | 34039 | 17404 | 1354 |
513576 | 513576 | 2020-09-08 | Unknown | New Jersey | 307 | 0 | |
513577 | 513577 | 2020-09-08 | Warren | New Jersey | 34041 | 1424 | 171 |
510323 | 510323 | 2020-09-07 | Atlantic | New Jersey | 34001 | 3831 | 252 |
510324 | 510324 | 2020-09-07 | Bergen | New Jersey | 34003 | 22058 | 2038 |
510325 | 510325 | 2020-09-07 | Burlington | New Jersey | 34005 | 6620 | 483 |
510326 | 510326 | 2020-09-07 | Camden | New Jersey | 34007 | 9388 | 594 |
510327 | 510327 | 2020-09-07 | Cape May | New Jersey | 34009 | 946 | 94 |
510328 | 510328 | 2020-09-07 | Cumberland | New Jersey | 34011 | 3638 | 156 |
510329 | 510329 | 2020-09-07 | Essex | New Jersey | 34013 | 20757 | 2120 |
510330 | 510330 | 2020-09-07 | Gloucester | New Jersey | 34015 | 3837 | 223 |
510331 | 510331 | 2020-09-07 | Hudson | New Jersey | 34017 | 20446 | 1512 |
510332 | 510332 | 2020-09-07 | Hunterdon | New Jersey | 34019 | 1289 | 125 |
510333 | 510333 | 2020-09-07 | Mercer | New Jersey | 34021 | 8458 | 632 |
510334 | 510334 | 2020-09-07 | Middlesex | New Jersey | 34023 | 18804 | 1419 |
510335 | 510335 | 2020-09-07 | Monmouth | New Jersey | 34025 | 11043 | 859 |
510336 | 510336 | 2020-09-07 | Morris | New Jersey | 34027 | 7725 | 829 |
510337 | 510337 | 2020-09-07 | Ocean | New Jersey | 34029 | 11558 | 1030 |
510338 | 510338 | 2020-09-07 | Passaic | New Jersey | 34031 | 18663 | 1248 |
510339 | 510339 | 2020-09-07 | Salem | New Jersey | 34033 | 1000 | 89 |
510340 | 510340 | 2020-09-07 | Somerset | New Jersey | 34035 | 5551 | 566 |
510341 | 510341 | 2020-09-07 | Sussex | New Jersey | 34037 | 1452 | 197 |
510342 | 510342 | 2020-09-07 | Union | New Jersey | 34039 | 17384 | 1354 |
510343 | 510343 | 2020-09-07 | Unknown | New Jersey | 304 | 0 | |
510344 | 510344 | 2020-09-07 | Warren | New Jersey | 34041 | 1421 | 171 |
507090 | 507090 | 2020-09-06 | Atlantic | New Jersey | 34001 | 3809 | 252 |
507091 | 507091 | 2020-09-06 | Bergen | New Jersey | 34003 | 22030 | 2038 |
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);