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-05-01 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 |
---|---|---|---|---|---|---|---|
1276088 | 1276088 | 2021-05-01 | Atlantic | New Jersey | 34001 | 30984 | 664 |
1276089 | 1276089 | 2021-05-01 | Bergen | New Jersey | 34003 | 101120 | 2828 |
1276090 | 1276090 | 2021-05-01 | Burlington | New Jersey | 34005 | 43840 | 833 |
1276091 | 1276091 | 2021-05-01 | Camden | New Jersey | 34007 | 54014 | 1268 |
1276092 | 1276092 | 2021-05-01 | Cape May | New Jersey | 34009 | 8942 | 201 |
1276093 | 1276093 | 2021-05-01 | Cumberland | New Jersey | 34011 | 16469 | 422 |
1276094 | 1276094 | 2021-05-01 | Essex | New Jersey | 34013 | 93170 | 2903 |
1276095 | 1276095 | 2021-05-01 | Gloucester | New Jersey | 34015 | 29697 | 609 |
1276096 | 1276096 | 2021-05-01 | Hudson | New Jersey | 34017 | 86882 | 2220 |
1276097 | 1276097 | 2021-05-01 | Hunterdon | New Jersey | 34019 | 9519 | 172 |
1276098 | 1276098 | 2021-05-01 | Mercer | New Jersey | 34021 | 33309 | 933 |
1276099 | 1276099 | 2021-05-01 | Middlesex | New Jersey | 34023 | 91001 | 2303 |
1276100 | 1276100 | 2021-05-01 | Monmouth | New Jersey | 34025 | 74367 | 1577 |
1276101 | 1276101 | 2021-05-01 | Morris | New Jersey | 34027 | 49488 | 1213 |
1276102 | 1276102 | 2021-05-01 | Ocean | New Jersey | 34029 | 74664 | 2114 |
1276103 | 1276103 | 2021-05-01 | Passaic | New Jersey | 34031 | 71574 | 1863 |
1276104 | 1276104 | 2021-05-01 | Salem | New Jersey | 34033 | 5897 | 177 |
1276105 | 1276105 | 2021-05-01 | Somerset | New Jersey | 34035 | 29442 | 827 |
1276106 | 1276106 | 2021-05-01 | Sussex | New Jersey | 34037 | 13591 | 296 |
1276107 | 1276107 | 2021-05-01 | Union | New Jersey | 34039 | 70328 | 1931 |
1276108 | 1276108 | 2021-05-01 | Unknown | New Jersey | 842 | 0 | |
1276109 | 1276109 | 2021-05-01 | Warren | New Jersey | 34041 | 9671 | 234 |
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);