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-08-07 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 |
---|---|---|---|---|---|---|---|
410231 | 410231 | 2020-08-07 | Atlantic | New Jersey | 34001 | 3461 | 252 |
410232 | 410232 | 2020-08-07 | Bergen | New Jersey | 34003 | 20945 | 2037 |
410233 | 410233 | 2020-08-07 | Burlington | New Jersey | 34005 | 5992 | 471 |
410234 | 410234 | 2020-08-07 | Camden | New Jersey | 34007 | 8555 | 578 |
410235 | 410235 | 2020-08-07 | Cape May | New Jersey | 34009 | 827 | 87 |
410236 | 410236 | 2020-08-07 | Cumberland | New Jersey | 34011 | 3330 | 158 |
410237 | 410237 | 2020-08-07 | Essex | New Jersey | 34013 | 19925 | 2107 |
410238 | 410238 | 2020-08-07 | Gloucester | New Jersey | 34015 | 3223 | 209 |
410239 | 410239 | 2020-08-07 | Hudson | New Jersey | 34017 | 19774 | 1502 |
410240 | 410240 | 2020-08-07 | Hunterdon | New Jersey | 34019 | 1202 | 126 |
410241 | 410241 | 2020-08-07 | Mercer | New Jersey | 34021 | 8143 | 618 |
410242 | 410242 | 2020-08-07 | Middlesex | New Jersey | 34023 | 18061 | 1401 |
410243 | 410243 | 2020-08-07 | Monmouth | New Jersey | 34025 | 10364 | 856 |
410244 | 410244 | 2020-08-07 | Morris | New Jersey | 34027 | 7372 | 827 |
410245 | 410245 | 2020-08-07 | Ocean | New Jersey | 34029 | 10631 | 1016 |
410246 | 410246 | 2020-08-07 | Passaic | New Jersey | 34031 | 17747 | 1239 |
410247 | 410247 | 2020-08-07 | Salem | New Jersey | 34033 | 892 | 87 |
410248 | 410248 | 2020-08-07 | Somerset | New Jersey | 34035 | 5298 | 562 |
410249 | 410249 | 2020-08-07 | Sussex | New Jersey | 34037 | 1359 | 197 |
410250 | 410250 | 2020-08-07 | Union | New Jersey | 34039 | 16806 | 1348 |
410251 | 410251 | 2020-08-07 | Unknown | New Jersey | 653 | 11 | |
410252 | 410252 | 2020-08-07 | Warren | New Jersey | 34041 | 1354 | 171 |
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);