ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where date = "2020-05-07" 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 |
---|---|---|---|---|---|---|---|
122918 | 122918 | 2020-05-07 | Atlantic | New Jersey | 34001 | 1302 | 62 |
122919 | 122919 | 2020-05-07 | Bergen | New Jersey | 34003 | 16609 | 1319 |
122920 | 122920 | 2020-05-07 | Burlington | New Jersey | 34005 | 3367 | 185 |
122921 | 122921 | 2020-05-07 | Camden | New Jersey | 34007 | 4479 | 193 |
122922 | 122922 | 2020-05-07 | Cape May | New Jersey | 34009 | 401 | 31 |
122923 | 122923 | 2020-05-07 | Cumberland | New Jersey | 34011 | 1090 | 25 |
122924 | 122924 | 2020-05-07 | Essex | New Jersey | 34013 | 15095 | 1381 |
122925 | 122925 | 2020-05-07 | Gloucester | New Jersey | 34015 | 1548 | 66 |
122926 | 122926 | 2020-05-07 | Hudson | New Jersey | 34017 | 16354 | 923 |
122927 | 122927 | 2020-05-07 | Hunterdon | New Jersey | 34019 | 685 | 43 |
122928 | 122928 | 2020-05-07 | Mercer | New Jersey | 34021 | 4986 | 313 |
122929 | 122929 | 2020-05-07 | Middlesex | New Jersey | 34023 | 13411 | 737 |
122930 | 122930 | 2020-05-07 | Monmouth | New Jersey | 34025 | 6649 | 428 |
122931 | 122931 | 2020-05-07 | Morris | New Jersey | 34027 | 5702 | 503 |
122932 | 122932 | 2020-05-07 | Ocean | New Jersey | 34029 | 7209 | 500 |
122933 | 122933 | 2020-05-07 | Passaic | New Jersey | 34031 | 14133 | 703 |
122934 | 122934 | 2020-05-07 | Salem | New Jersey | 34033 | 358 | 18 |
122935 | 122935 | 2020-05-07 | Somerset | New Jersey | 34035 | 3914 | 320 |
122936 | 122936 | 2020-05-07 | Sussex | New Jersey | 34037 | 1006 | 123 |
122937 | 122937 | 2020-05-07 | Union | New Jersey | 34039 | 13781 | 829 |
122938 | 122938 | 2020-05-07 | Unknown | New Jersey | 552 | 0 | |
122939 | 122939 | 2020-05-07 | Warren | New Jersey | 34041 | 1004 | 99 |
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);