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-07-09 and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
317281 | 317281 | 2020-07-09 | Atlantic | New Jersey | 34001 | 2991 | 226 |
317282 | 317282 | 2020-07-09 | Bergen | New Jersey | 34003 | 20043 | 2020 |
317283 | 317283 | 2020-07-09 | Burlington | New Jersey | 34005 | 5357 | 446 |
317284 | 317284 | 2020-07-09 | Camden | New Jersey | 34007 | 7652 | 540 |
317285 | 317285 | 2020-07-09 | Cape May | New Jersey | 34009 | 727 | 76 |
317286 | 317286 | 2020-07-09 | Cumberland | New Jersey | 34011 | 3045 | 149 |
317287 | 317287 | 2020-07-09 | Essex | New Jersey | 34013 | 19177 | 2060 |
317288 | 317288 | 2020-07-09 | Gloucester | New Jersey | 34015 | 2704 | 193 |
317289 | 317289 | 2020-07-09 | Hudson | New Jersey | 34017 | 19216 | 1477 |
317290 | 317290 | 2020-07-09 | Hunterdon | New Jersey | 34019 | 1150 | 125 |
317291 | 317291 | 2020-07-09 | Mercer | New Jersey | 34021 | 7809 | 596 |
317292 | 317292 | 2020-07-09 | Middlesex | New Jersey | 34023 | 17158 | 1361 |
317293 | 317293 | 2020-07-09 | Monmouth | New Jersey | 34025 | 9469 | 831 |
317294 | 317294 | 2020-07-09 | Morris | New Jersey | 34027 | 7018 | 817 |
317295 | 317295 | 2020-07-09 | Ocean | New Jersey | 34029 | 9846 | 992 |
317296 | 317296 | 2020-07-09 | Passaic | New Jersey | 34031 | 17158 | 1216 |
317297 | 317297 | 2020-07-09 | Salem | New Jersey | 34033 | 816 | 77 |
317298 | 317298 | 2020-07-09 | Somerset | New Jersey | 34035 | 5038 | 544 |
317299 | 317299 | 2020-07-09 | Sussex | New Jersey | 34037 | 1257 | 194 |
317300 | 317300 | 2020-07-09 | Union | New Jersey | 34039 | 16646 | 1341 |
317301 | 317301 | 2020-07-09 | Unknown | New Jersey | 665 | 0 | |
317302 | 317302 | 2020-07-09 | Warren | New Jersey | 34041 | 1275 | 167 |
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);