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-30 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 |
---|---|---|---|---|---|---|---|
682097 | 682097 | 2020-10-30 | Atlantic | New Jersey | 34001 | 5220 | 267 |
682098 | 682098 | 2020-10-30 | Bergen | New Jersey | 34003 | 25478 | 2062 |
682099 | 682099 | 2020-10-30 | Burlington | New Jersey | 34005 | 8628 | 514 |
682100 | 682100 | 2020-10-30 | Camden | New Jersey | 34007 | 11782 | 635 |
682101 | 682101 | 2020-10-30 | Cape May | New Jersey | 34009 | 1139 | 100 |
682102 | 682102 | 2020-10-30 | Cumberland | New Jersey | 34011 | 4042 | 162 |
682103 | 682103 | 2020-10-30 | Essex | New Jersey | 34013 | 25200 | 2144 |
682104 | 682104 | 2020-10-30 | Gloucester | New Jersey | 34015 | 5557 | 248 |
682105 | 682105 | 2020-10-30 | Hudson | New Jersey | 34017 | 23514 | 1530 |
682106 | 682106 | 2020-10-30 | Hunterdon | New Jersey | 34019 | 1657 | 127 |
682107 | 682107 | 2020-10-30 | Mercer | New Jersey | 34021 | 9374 | 639 |
682108 | 682108 | 2020-10-30 | Middlesex | New Jersey | 34023 | 22647 | 1447 |
682109 | 682109 | 2020-10-30 | Monmouth | New Jersey | 34025 | 14334 | 873 |
682110 | 682110 | 2020-10-30 | Morris | New Jersey | 34027 | 9388 | 838 |
682111 | 682111 | 2020-10-30 | Ocean | New Jersey | 34029 | 16870 | 1067 |
682112 | 682112 | 2020-10-30 | Passaic | New Jersey | 34031 | 21201 | 1261 |
682113 | 682113 | 2020-10-30 | Salem | New Jersey | 34033 | 1185 | 89 |
682114 | 682114 | 2020-10-30 | Somerset | New Jersey | 34035 | 6602 | 595 |
682115 | 682115 | 2020-10-30 | Sussex | New Jersey | 34037 | 1775 | 197 |
682116 | 682116 | 2020-10-30 | Union | New Jersey | 34039 | 20581 | 1373 |
682117 | 682117 | 2020-10-30 | Unknown | New Jersey | 522 | 0 | |
682118 | 682118 | 2020-10-30 | Warren | New Jersey | 34041 | 1620 | 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);