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-02-08 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 |
---|---|---|---|---|---|---|---|
1009859 | 1009859 | 2021-02-08 | Atlantic | New Jersey | 34001 | 22745 | 508 |
1009860 | 1009860 | 2021-02-08 | Bergen | New Jersey | 34003 | 70209 | 2510 |
1009861 | 1009861 | 2021-02-08 | Burlington | New Jersey | 34005 | 32919 | 696 |
1009862 | 1009862 | 2021-02-08 | Camden | New Jersey | 34007 | 41517 | 1054 |
1009863 | 1009863 | 2021-02-08 | Cape May | New Jersey | 34009 | 6536 | 168 |
1009864 | 1009864 | 2021-02-08 | Cumberland | New Jersey | 34011 | 13320 | 318 |
1009865 | 1009865 | 2021-02-08 | Essex | New Jersey | 34013 | 67620 | 2574 |
1009866 | 1009866 | 2021-02-08 | Gloucester | New Jersey | 34015 | 22645 | 511 |
1009867 | 1009867 | 2021-02-08 | Hudson | New Jersey | 34017 | 63457 | 1897 |
1009868 | 1009868 | 2021-02-08 | Hunterdon | New Jersey | 34019 | 6200 | 152 |
1009869 | 1009869 | 2021-02-08 | Mercer | New Jersey | 34021 | 25922 | 837 |
1009870 | 1009870 | 2021-02-08 | Middlesex | New Jersey | 34023 | 66773 | 1985 |
1009871 | 1009871 | 2021-02-08 | Monmouth | New Jersey | 34025 | 51350 | 1309 |
1009872 | 1009872 | 2021-02-08 | Morris | New Jersey | 34027 | 34003 | 1080 |
1009873 | 1009873 | 2021-02-08 | Ocean | New Jersey | 34029 | 52781 | 1719 |
1009874 | 1009874 | 2021-02-08 | Passaic | New Jersey | 34031 | 52987 | 1620 |
1009875 | 1009875 | 2021-02-08 | Salem | New Jersey | 34033 | 4451 | 150 |
1009876 | 1009876 | 2021-02-08 | Somerset | New Jersey | 34035 | 20812 | 758 |
1009877 | 1009877 | 2021-02-08 | Sussex | New Jersey | 34037 | 8242 | 261 |
1009878 | 1009878 | 2021-02-08 | Union | New Jersey | 34039 | 52736 | 1699 |
1009879 | 1009879 | 2021-02-08 | Unknown | New Jersey | 1081 | 0 | |
1009880 | 1009880 | 2021-02-08 | Warren | New Jersey | 34041 | 6421 | 205 |
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);