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-01-17 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 |
---|---|---|---|---|---|---|---|
2123929 | 2123929 | 2022-01-17 | Atlantic | New Jersey | 34001 | 61587 | 859 |
2123930 | 2123930 | 2022-01-17 | Bergen | New Jersey | 34003 | 201991 | 3178 |
2123931 | 2123931 | 2022-01-17 | Burlington | New Jersey | 34005 | 91123 | 1046 |
2123932 | 2123932 | 2022-01-17 | Camden | New Jersey | 34007 | 113329 | 1586 |
2123933 | 2123933 | 2022-01-17 | Cape May | New Jersey | 34009 | 19919 | 266 |
2123934 | 2123934 | 2022-01-17 | Cumberland | New Jersey | 34011 | 32948 | 544 |
2123935 | 2123935 | 2022-01-17 | Essex | New Jersey | 34013 | 197824 | 3308 |
2123936 | 2123936 | 2022-01-17 | Gloucester | New Jersey | 34015 | 62782 | 824 |
2123937 | 2123937 | 2022-01-17 | Hudson | New Jersey | 34017 | 157043 | 2516 |
2123938 | 2123938 | 2022-01-17 | Hunterdon | New Jersey | 34019 | 21914 | 221 |
2123939 | 2123939 | 2022-01-17 | Mercer | New Jersey | 34021 | 67859 | 1121 |
2123940 | 2123940 | 2022-01-17 | Middlesex | New Jersey | 34023 | 172926 | 2656 |
2123941 | 2123941 | 2022-01-17 | Monmouth | New Jersey | 34025 | 150003 | 1885 |
2123942 | 2123942 | 2022-01-17 | Morris | New Jersey | 34027 | 107725 | 1394 |
2123943 | 2123943 | 2022-01-17 | Ocean | New Jersey | 34029 | 147382 | 2583 |
2123944 | 2123944 | 2022-01-17 | Passaic | New Jersey | 34031 | 133479 | 2157 |
2123945 | 2123945 | 2022-01-17 | Salem | New Jersey | 34033 | 12754 | 221 |
2123946 | 2123946 | 2022-01-17 | Somerset | New Jersey | 34035 | 61724 | 919 |
2123947 | 2123947 | 2022-01-17 | Sussex | New Jersey | 34037 | 30835 | 389 |
2123948 | 2123948 | 2022-01-17 | Union | New Jersey | 34039 | 132211 | 2149 |
2123949 | 2123949 | 2022-01-17 | Unknown | New Jersey | 4567 | 1 | |
2123950 | 2123950 | 2022-01-17 | Warren | New Jersey | 34041 | 21655 | 297 |
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);