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 2022-01-06 and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2088163 | 2088163 | 2022-01-06 | Atlantic | New Jersey | 34001 | 53204 | 834 |
2088164 | 2088164 | 2022-01-06 | Bergen | New Jersey | 34003 | 175750 | 3099 |
2088165 | 2088165 | 2022-01-06 | Burlington | New Jersey | 34005 | 78653 | 1024 |
2088166 | 2088166 | 2022-01-06 | Camden | New Jersey | 34007 | 96181 | 1537 |
2088167 | 2088167 | 2022-01-06 | Cape May | New Jersey | 34009 | 17809 | 255 |
2088168 | 2088168 | 2022-01-06 | Cumberland | New Jersey | 34011 | 27880 | 525 |
2088169 | 2088169 | 2022-01-06 | Essex | New Jersey | 34013 | 173220 | 3229 |
2088170 | 2088170 | 2022-01-06 | Gloucester | New Jersey | 34015 | 54211 | 794 |
2088171 | 2088171 | 2022-01-06 | Hudson | New Jersey | 34017 | 133400 | 2464 |
2088172 | 2088172 | 2022-01-06 | Hunterdon | New Jersey | 34019 | 18503 | 210 |
2088173 | 2088173 | 2022-01-06 | Mercer | New Jersey | 34021 | 57431 | 1084 |
2088174 | 2088174 | 2022-01-06 | Middlesex | New Jersey | 34023 | 151676 | 2580 |
2088175 | 2088175 | 2022-01-06 | Monmouth | New Jersey | 34025 | 132835 | 1837 |
2088176 | 2088176 | 2022-01-06 | Morris | New Jersey | 34027 | 90976 | 1355 |
2088177 | 2088177 | 2022-01-06 | Ocean | New Jersey | 34029 | 130882 | 2502 |
2088178 | 2088178 | 2022-01-06 | Passaic | New Jersey | 34031 | 117133 | 2095 |
2088179 | 2088179 | 2022-01-06 | Salem | New Jersey | 34033 | 11061 | 218 |
2088180 | 2088180 | 2022-01-06 | Somerset | New Jersey | 34035 | 53355 | 911 |
2088181 | 2088181 | 2022-01-06 | Sussex | New Jersey | 34037 | 27091 | 379 |
2088182 | 2088182 | 2022-01-06 | Union | New Jersey | 34039 | 117627 | 2099 |
2088183 | 2088183 | 2022-01-06 | Unknown | New Jersey | 6433 | 0 | |
2088184 | 2088184 | 2022-01-06 | Warren | New Jersey | 34041 | 18691 | 284 |
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);