ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where "date" is on date 2020-12-24 and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
860568 | 860568 | 2020-12-24 | Atlantic | New Jersey | 34001 | 11242 | 350 |
860569 | 860569 | 2020-12-24 | Bergen | New Jersey | 34003 | 44886 | 2275 |
860570 | 860570 | 2020-12-24 | Burlington | New Jersey | 34005 | 19562 | 604 |
860571 | 860571 | 2020-12-24 | Camden | New Jersey | 34007 | 26908 | 774 |
860572 | 860572 | 2020-12-24 | Cape May | New Jersey | 34009 | 2238 | 130 |
860573 | 860573 | 2020-12-24 | Cumberland | New Jersey | 34011 | 7230 | 208 |
860574 | 860574 | 2020-12-24 | Essex | New Jersey | 34013 | 45256 | 2361 |
860575 | 860575 | 2020-12-24 | Gloucester | New Jersey | 34015 | 13171 | 358 |
860576 | 860576 | 2020-12-24 | Hudson | New Jersey | 34017 | 41472 | 1673 |
860577 | 860577 | 2020-12-24 | Hunterdon | New Jersey | 34019 | 3543 | 136 |
860578 | 860578 | 2020-12-24 | Mercer | New Jersey | 34021 | 17927 | 708 |
860579 | 860579 | 2020-12-24 | Middlesex | New Jersey | 34023 | 42284 | 1623 |
860580 | 860580 | 2020-12-24 | Monmouth | New Jersey | 34025 | 29540 | 1000 |
860581 | 860581 | 2020-12-24 | Morris | New Jersey | 34027 | 19152 | 945 |
860582 | 860582 | 2020-12-24 | Ocean | New Jersey | 34029 | 30152 | 1298 |
860583 | 860583 | 2020-12-24 | Passaic | New Jersey | 34031 | 38618 | 1424 |
860584 | 860584 | 2020-12-24 | Salem | New Jersey | 34033 | 2529 | 107 |
860585 | 860585 | 2020-12-24 | Somerset | New Jersey | 34035 | 11974 | 654 |
860586 | 860586 | 2020-12-24 | Sussex | New Jersey | 34037 | 4084 | 211 |
860587 | 860587 | 2020-12-24 | Union | New Jersey | 34039 | 35279 | 1524 |
860588 | 860588 | 2020-12-24 | Unknown | New Jersey | 1105 | 0 | |
860589 | 860589 | 2020-12-24 | Warren | New Jersey | 34041 | 3635 | 181 |
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);