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-04 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 |
---|---|---|---|---|---|---|---|
996875 | 996875 | 2021-02-04 | Atlantic | New Jersey | 34001 | 22094 | 494 |
996876 | 996876 | 2021-02-04 | Bergen | New Jersey | 34003 | 68542 | 2501 |
996877 | 996877 | 2021-02-04 | Burlington | New Jersey | 34005 | 32202 | 692 |
996878 | 996878 | 2021-02-04 | Camden | New Jersey | 34007 | 40930 | 1040 |
996879 | 996879 | 2021-02-04 | Cape May | New Jersey | 34009 | 6363 | 165 |
996880 | 996880 | 2021-02-04 | Cumberland | New Jersey | 34011 | 13081 | 312 |
996881 | 996881 | 2021-02-04 | Essex | New Jersey | 34013 | 66173 | 2561 |
996882 | 996882 | 2021-02-04 | Gloucester | New Jersey | 34015 | 22268 | 506 |
996883 | 996883 | 2021-02-04 | Hudson | New Jersey | 34017 | 62256 | 1881 |
996884 | 996884 | 2021-02-04 | Hunterdon | New Jersey | 34019 | 6028 | 149 |
996885 | 996885 | 2021-02-04 | Mercer | New Jersey | 34021 | 25446 | 825 |
996886 | 996886 | 2021-02-04 | Middlesex | New Jersey | 34023 | 65251 | 1954 |
996887 | 996887 | 2021-02-04 | Monmouth | New Jersey | 34025 | 50005 | 1297 |
996888 | 996888 | 2021-02-04 | Morris | New Jersey | 34027 | 33050 | 1069 |
996889 | 996889 | 2021-02-04 | Ocean | New Jersey | 34029 | 51439 | 1692 |
996890 | 996890 | 2021-02-04 | Passaic | New Jersey | 34031 | 52025 | 1612 |
996891 | 996891 | 2021-02-04 | Salem | New Jersey | 34033 | 4403 | 150 |
996892 | 996892 | 2021-02-04 | Somerset | New Jersey | 34035 | 20295 | 750 |
996893 | 996893 | 2021-02-04 | Sussex | New Jersey | 34037 | 8001 | 257 |
996894 | 996894 | 2021-02-04 | Union | New Jersey | 34039 | 51932 | 1685 |
996895 | 996895 | 2021-02-04 | Unknown | New Jersey | 1074 | 0 | |
996896 | 996896 | 2021-02-04 | Warren | New Jersey | 34041 | 6238 | 201 |
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);