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-09-02 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 |
---|---|---|---|---|---|---|---|
1678702 | 1678702 | 2021-09-02 | Atlantic | New Jersey | 34001 | 34553 | 711 |
1678703 | 1678703 | 2021-09-02 | Bergen | New Jersey | 34003 | 111592 | 2922 |
1678704 | 1678704 | 2021-09-02 | Burlington | New Jersey | 34005 | 48737 | 903 |
1678705 | 1678705 | 2021-09-02 | Camden | New Jersey | 34007 | 60611 | 1363 |
1678706 | 1678706 | 2021-09-02 | Cape May | New Jersey | 34009 | 10798 | 217 |
1678707 | 1678707 | 2021-09-02 | Cumberland | New Jersey | 34011 | 18499 | 446 |
1678708 | 1678708 | 2021-09-02 | Essex | New Jersey | 34013 | 100377 | 3077 |
1678709 | 1678709 | 2021-09-02 | Gloucester | New Jersey | 34015 | 33562 | 667 |
1678710 | 1678710 | 2021-09-02 | Hudson | New Jersey | 34017 | 92854 | 2348 |
1678711 | 1678711 | 2021-09-02 | Hunterdon | New Jersey | 34019 | 10773 | 180 |
1678712 | 1678712 | 2021-09-02 | Mercer | New Jersey | 34021 | 36424 | 974 |
1678713 | 1678713 | 2021-09-02 | Middlesex | New Jersey | 34023 | 98599 | 2390 |
1678714 | 1678714 | 2021-09-02 | Monmouth | New Jersey | 34025 | 83876 | 1667 |
1678715 | 1678715 | 2021-09-02 | Morris | New Jersey | 34027 | 53623 | 1254 |
1678716 | 1678716 | 2021-09-02 | Ocean | New Jersey | 34029 | 83431 | 2230 |
1678717 | 1678717 | 2021-09-02 | Passaic | New Jersey | 34031 | 77054 | 1962 |
1678718 | 1678718 | 2021-09-02 | Salem | New Jersey | 34033 | 6731 | 193 |
1678719 | 1678719 | 2021-09-02 | Somerset | New Jersey | 34035 | 32375 | 853 |
1678720 | 1678720 | 2021-09-02 | Sussex | New Jersey | 34037 | 15051 | 313 |
1678721 | 1678721 | 2021-09-02 | Union | New Jersey | 34039 | 75737 | 2006 |
1678722 | 1678722 | 2021-09-02 | Unknown | New Jersey | 802 | 0 | |
1678723 | 1678723 | 2021-09-02 | Warren | New Jersey | 34041 | 10732 | 243 |
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);