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 2022-04-13 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 |
---|---|---|---|---|---|---|---|
2403677 | 2403677 | 2022-04-13 | Atlantic | New Jersey | 34001 | 68576 | 991 |
2403678 | 2403678 | 2022-04-13 | Bergen | New Jersey | 34003 | 226211 | 3432 |
2403679 | 2403679 | 2022-04-13 | Burlington | New Jersey | 34005 | 102762 | 1196 |
2403680 | 2403680 | 2022-04-13 | Camden | New Jersey | 34007 | 126129 | 1791 |
2403681 | 2403681 | 2022-04-13 | Cape May | New Jersey | 34009 | 21952 | 297 |
2403682 | 2403682 | 2022-04-13 | Cumberland | New Jersey | 34011 | 39533 | 598 |
2403683 | 2403683 | 2022-04-13 | Essex | New Jersey | 34013 | 213994 | 3598 |
2403684 | 2403684 | 2022-04-13 | Gloucester | New Jersey | 34015 | 69924 | 958 |
2403685 | 2403685 | 2022-04-13 | Hudson | New Jersey | 34017 | 172766 | 2721 |
2403686 | 2403686 | 2022-04-13 | Hunterdon | New Jersey | 34019 | 24806 | 275 |
2403687 | 2403687 | 2022-04-13 | Mercer | New Jersey | 34021 | 76765 | 1256 |
2403688 | 2403688 | 2022-04-13 | Middlesex | New Jersey | 34023 | 194640 | 2863 |
2403689 | 2403689 | 2022-04-13 | Monmouth | New Jersey | 34025 | 165245 | 2165 |
2403690 | 2403690 | 2022-04-13 | Morris | New Jersey | 34027 | 119680 | 1529 |
2403691 | 2403691 | 2022-04-13 | Ocean | New Jersey | 34029 | 162862 | 2924 |
2403692 | 2403692 | 2022-04-13 | Passaic | New Jersey | 34031 | 145391 | 2334 |
2403693 | 2403693 | 2022-04-13 | Salem | New Jersey | 34033 | 14351 | 245 |
2403694 | 2403694 | 2022-04-13 | Somerset | New Jersey | 34035 | 68347 | 971 |
2403695 | 2403695 | 2022-04-13 | Sussex | New Jersey | 34037 | 34087 | 473 |
2403696 | 2403696 | 2022-04-13 | Union | New Jersey | 34039 | 145696 | 2357 |
2403697 | 2403697 | 2022-04-13 | Unknown | New Jersey | 3322 | 0 | |
2403698 | 2403698 | 2022-04-13 | Warren | New Jersey | 34041 | 24019 | 341 |
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);