ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where date = "2021-05-21" 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 |
---|---|---|---|---|---|---|---|
1341020 | 1341020 | 2021-05-21 | Atlantic | New Jersey | 34001 | 31455 | 677 |
1341021 | 1341021 | 2021-05-21 | Bergen | New Jersey | 34003 | 103965 | 2860 |
1341022 | 1341022 | 2021-05-21 | Burlington | New Jersey | 34005 | 44020 | 847 |
1341023 | 1341023 | 2021-05-21 | Camden | New Jersey | 34007 | 55277 | 1302 |
1341024 | 1341024 | 2021-05-21 | Cape May | New Jersey | 34009 | 9136 | 207 |
1341025 | 1341025 | 2021-05-21 | Cumberland | New Jersey | 34011 | 16983 | 433 |
1341026 | 1341026 | 2021-05-21 | Essex | New Jersey | 34013 | 93811 | 2967 |
1341027 | 1341027 | 2021-05-21 | Gloucester | New Jersey | 34015 | 30391 | 634 |
1341028 | 1341028 | 2021-05-21 | Hudson | New Jersey | 34017 | 87746 | 2263 |
1341029 | 1341029 | 2021-05-21 | Hunterdon | New Jersey | 34019 | 9740 | 175 |
1341030 | 1341030 | 2021-05-21 | Mercer | New Jersey | 34021 | 33794 | 945 |
1341031 | 1341031 | 2021-05-21 | Middlesex | New Jersey | 34023 | 91873 | 2345 |
1341032 | 1341032 | 2021-05-21 | Monmouth | New Jersey | 34025 | 75260 | 1612 |
1341033 | 1341033 | 2021-05-21 | Morris | New Jersey | 34027 | 49934 | 1223 |
1341034 | 1341034 | 2021-05-21 | Ocean | New Jersey | 34029 | 75538 | 2144 |
1341035 | 1341035 | 2021-05-21 | Passaic | New Jersey | 34031 | 72607 | 1909 |
1341036 | 1341036 | 2021-05-21 | Salem | New Jersey | 34033 | 6056 | 185 |
1341037 | 1341037 | 2021-05-21 | Somerset | New Jersey | 34035 | 29933 | 838 |
1341038 | 1341038 | 2021-05-21 | Sussex | New Jersey | 34037 | 13920 | 302 |
1341039 | 1341039 | 2021-05-21 | Union | New Jersey | 34039 | 71198 | 1955 |
1341040 | 1341040 | 2021-05-21 | Unknown | New Jersey | 859 | 0 | |
1341041 | 1341041 | 2021-05-21 | Warren | New Jersey | 34041 | 9913 | 236 |
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);