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-22 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 |
---|---|---|---|---|---|---|---|
854078 | 854078 | 2020-12-22 | Atlantic | New Jersey | 34001 | 10977 | 339 |
854079 | 854079 | 2020-12-22 | Bergen | New Jersey | 34003 | 43963 | 2257 |
854080 | 854080 | 2020-12-22 | Burlington | New Jersey | 34005 | 18990 | 598 |
854081 | 854081 | 2020-12-22 | Camden | New Jersey | 34007 | 26330 | 763 |
854082 | 854082 | 2020-12-22 | Cape May | New Jersey | 34009 | 2196 | 128 |
854083 | 854083 | 2020-12-22 | Cumberland | New Jersey | 34011 | 7033 | 205 |
854084 | 854084 | 2020-12-22 | Essex | New Jersey | 34013 | 44557 | 2339 |
854085 | 854085 | 2020-12-22 | Gloucester | New Jersey | 34015 | 12829 | 349 |
854086 | 854086 | 2020-12-22 | Hudson | New Jersey | 34017 | 40567 | 1664 |
854087 | 854087 | 2020-12-22 | Hunterdon | New Jersey | 34019 | 3458 | 134 |
854088 | 854088 | 2020-12-22 | Mercer | New Jersey | 34021 | 17662 | 704 |
854089 | 854089 | 2020-12-22 | Middlesex | New Jersey | 34023 | 41381 | 1607 |
854090 | 854090 | 2020-12-22 | Monmouth | New Jersey | 34025 | 28795 | 976 |
854091 | 854091 | 2020-12-22 | Morris | New Jersey | 34027 | 18658 | 934 |
854092 | 854092 | 2020-12-22 | Ocean | New Jersey | 34029 | 29345 | 1267 |
854093 | 854093 | 2020-12-22 | Passaic | New Jersey | 34031 | 37992 | 1407 |
854094 | 854094 | 2020-12-22 | Salem | New Jersey | 34033 | 2434 | 106 |
854095 | 854095 | 2020-12-22 | Somerset | New Jersey | 34035 | 11743 | 647 |
854096 | 854096 | 2020-12-22 | Sussex | New Jersey | 34037 | 3919 | 209 |
854097 | 854097 | 2020-12-22 | Union | New Jersey | 34039 | 34841 | 1514 |
854098 | 854098 | 2020-12-22 | Unknown | New Jersey | 1083 | 0 | |
854099 | 854099 | 2020-12-22 | Warren | New Jersey | 34041 | 3521 | 179 |
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);