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 2021-11-22 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 |
---|---|---|---|---|---|---|---|
1941887 | 1941887 | 2021-11-22 | Atlantic | New Jersey | 34001 | 40754 | 791 |
1941888 | 1941888 | 2021-11-22 | Bergen | New Jersey | 34003 | 122850 | 3014 |
1941889 | 1941889 | 2021-11-22 | Burlington | New Jersey | 34005 | 57401 | 969 |
1941890 | 1941890 | 2021-11-22 | Camden | New Jersey | 34007 | 70805 | 1472 |
1941891 | 1941891 | 2021-11-22 | Cape May | New Jersey | 34009 | 13024 | 242 |
1941892 | 1941892 | 2021-11-22 | Cumberland | New Jersey | 34011 | 21719 | 490 |
1941893 | 1941893 | 2021-11-22 | Essex | New Jersey | 34013 | 108504 | 3173 |
1941894 | 1941894 | 2021-11-22 | Gloucester | New Jersey | 34015 | 40175 | 746 |
1941895 | 1941895 | 2021-11-22 | Hudson | New Jersey | 34017 | 99127 | 2399 |
1941896 | 1941896 | 2021-11-22 | Hunterdon | New Jersey | 34019 | 12652 | 193 |
1941897 | 1941897 | 2021-11-22 | Mercer | New Jersey | 34021 | 40921 | 1025 |
1941898 | 1941898 | 2021-11-22 | Middlesex | New Jersey | 34023 | 108985 | 2485 |
1941899 | 1941899 | 2021-11-22 | Monmouth | New Jersey | 34025 | 96266 | 1773 |
1941900 | 1941900 | 2021-11-22 | Morris | New Jersey | 34027 | 60179 | 1314 |
1941901 | 1941901 | 2021-11-22 | Ocean | New Jersey | 34029 | 99553 | 2392 |
1941902 | 1941902 | 2021-11-22 | Passaic | New Jersey | 34031 | 83388 | 2031 |
1941903 | 1941903 | 2021-11-22 | Salem | New Jersey | 34033 | 8283 | 211 |
1941904 | 1941904 | 2021-11-22 | Somerset | New Jersey | 34035 | 35867 | 885 |
1941905 | 1941905 | 2021-11-22 | Sussex | New Jersey | 34037 | 18399 | 349 |
1941906 | 1941906 | 2021-11-22 | Union | New Jersey | 34039 | 81230 | 2053 |
1941907 | 1941907 | 2021-11-22 | Unknown | New Jersey | 578 | 0 | |
1941908 | 1941908 | 2021-11-22 | Warren | New Jersey | 34041 | 12851 | 258 |
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);