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-10-18 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 |
---|---|---|---|---|---|---|---|
643169 | 643169 | 2020-10-18 | Atlantic | New Jersey | 34001 | 4716 | 264 |
643170 | 643170 | 2020-10-18 | Bergen | New Jersey | 34003 | 23980 | 2050 |
643171 | 643171 | 2020-10-18 | Burlington | New Jersey | 34005 | 7866 | 506 |
643172 | 643172 | 2020-10-18 | Camden | New Jersey | 34007 | 10888 | 618 |
643173 | 643173 | 2020-10-18 | Cape May | New Jersey | 34009 | 1084 | 99 |
643174 | 643174 | 2020-10-18 | Cumberland | New Jersey | 34011 | 3906 | 161 |
643175 | 643175 | 2020-10-18 | Essex | New Jersey | 34013 | 22709 | 2134 |
643176 | 643176 | 2020-10-18 | Gloucester | New Jersey | 34015 | 5186 | 235 |
643177 | 643177 | 2020-10-18 | Hudson | New Jersey | 34017 | 21890 | 1523 |
643178 | 643178 | 2020-10-18 | Hunterdon | New Jersey | 34019 | 1541 | 126 |
643179 | 643179 | 2020-10-18 | Mercer | New Jersey | 34021 | 8991 | 637 |
643180 | 643180 | 2020-10-18 | Middlesex | New Jersey | 34023 | 21132 | 1437 |
643181 | 643181 | 2020-10-18 | Monmouth | New Jersey | 34025 | 13403 | 868 |
643182 | 643182 | 2020-10-18 | Morris | New Jersey | 34027 | 8574 | 832 |
643183 | 643183 | 2020-10-18 | Ocean | New Jersey | 34029 | 16018 | 1054 |
643184 | 643184 | 2020-10-18 | Passaic | New Jersey | 34031 | 20117 | 1259 |
643185 | 643185 | 2020-10-18 | Salem | New Jersey | 34033 | 1143 | 88 |
643186 | 643186 | 2020-10-18 | Somerset | New Jersey | 34035 | 6216 | 589 |
643187 | 643187 | 2020-10-18 | Sussex | New Jersey | 34037 | 1652 | 197 |
643188 | 643188 | 2020-10-18 | Union | New Jersey | 34039 | 18876 | 1363 |
643189 | 643189 | 2020-10-18 | Unknown | New Jersey | 394 | 0 | |
643190 | 643190 | 2020-10-18 | Warren | New Jersey | 34041 | 1520 | 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);