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-04-17 and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
66163 | 66163 | 2020-04-17 | Atlantic | New Jersey | 34001 | 370 | 17 |
66164 | 66164 | 2020-04-17 | Bergen | New Jersey | 34003 | 11863 | 714 |
66165 | 66165 | 2020-04-17 | Burlington | New Jersey | 34005 | 1366 | 54 |
66166 | 66166 | 2020-04-17 | Camden | New Jersey | 34007 | 1807 | 64 |
66167 | 66167 | 2020-04-17 | Cape May | New Jersey | 34009 | 189 | 14 |
66168 | 66168 | 2020-04-17 | Cumberland | New Jersey | 34011 | 263 | 3 |
66169 | 66169 | 2020-04-17 | Essex | New Jersey | 34013 | 9672 | 684 |
66170 | 66170 | 2020-04-17 | Gloucester | New Jersey | 34015 | 664 | 22 |
66171 | 66171 | 2020-04-17 | Hudson | New Jersey | 34017 | 9636 | 420 |
66172 | 66172 | 2020-04-17 | Hunterdon | New Jersey | 34019 | 385 | 16 |
66173 | 66173 | 2020-04-17 | Mercer | New Jersey | 34021 | 2123 | 101 |
66174 | 66174 | 2020-04-17 | Middlesex | New Jersey | 34023 | 7308 | 309 |
66175 | 66175 | 2020-04-17 | Monmouth | New Jersey | 34025 | 4414 | 206 |
66176 | 66176 | 2020-04-17 | Morris | New Jersey | 34027 | 3822 | 232 |
66177 | 66177 | 2020-04-17 | Ocean | New Jersey | 34029 | 4424 | 201 |
66178 | 66178 | 2020-04-17 | Passaic | New Jersey | 34031 | 7604 | 221 |
66179 | 66179 | 2020-04-17 | Salem | New Jersey | 34033 | 102 | 4 |
66180 | 66180 | 2020-04-17 | Somerset | New Jersey | 34035 | 2195 | 135 |
66181 | 66181 | 2020-04-17 | Sussex | New Jersey | 34037 | 591 | 54 |
66182 | 66182 | 2020-04-17 | Union | New Jersey | 34039 | 8429 | 330 |
66183 | 66183 | 2020-04-17 | Unknown | New Jersey | 719 | 3 | |
66184 | 66184 | 2020-04-17 | Warren | New Jersey | 34041 | 521 | 36 |
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);