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 2020-06-01 and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
198534 | 198534 | 2020-06-01 | Atlantic | New Jersey | 34001 | 2222 | 159 |
198535 | 198535 | 2020-06-01 | Bergen | New Jersey | 34003 | 18302 | 1580 |
198536 | 198536 | 2020-06-01 | Burlington | New Jersey | 34005 | 4657 | 294 |
198537 | 198537 | 2020-06-01 | Camden | New Jersey | 34007 | 6543 | 338 |
198538 | 198538 | 2020-06-01 | Cape May | New Jersey | 34009 | 623 | 49 |
198539 | 198539 | 2020-06-01 | Cumberland | New Jersey | 34011 | 2310 | 75 |
198540 | 198540 | 2020-06-01 | Essex | New Jersey | 34013 | 17695 | 1667 |
198541 | 198541 | 2020-06-01 | Gloucester | New Jersey | 34015 | 2245 | 148 |
198542 | 198542 | 2020-06-01 | Hudson | New Jersey | 34017 | 18428 | 1182 |
198543 | 198543 | 2020-06-01 | Hunterdon | New Jersey | 34019 | 996 | 60 |
198544 | 198544 | 2020-06-01 | Mercer | New Jersey | 34021 | 6961 | 475 |
198545 | 198545 | 2020-06-01 | Middlesex | New Jersey | 34023 | 15977 | 996 |
198546 | 198546 | 2020-06-01 | Monmouth | New Jersey | 34025 | 8249 | 599 |
198547 | 198547 | 2020-06-01 | Morris | New Jersey | 34027 | 6506 | 616 |
198548 | 198548 | 2020-06-01 | Ocean | New Jersey | 34029 | 8770 | 740 |
198549 | 198549 | 2020-06-01 | Passaic | New Jersey | 34031 | 16200 | 929 |
198550 | 198550 | 2020-06-01 | Salem | New Jersey | 34033 | 639 | 41 |
198551 | 198551 | 2020-06-01 | Somerset | New Jersey | 34035 | 4595 | 419 |
198552 | 198552 | 2020-06-01 | Sussex | New Jersey | 34037 | 1114 | 148 |
198553 | 198553 | 2020-06-01 | Union | New Jersey | 34039 | 15858 | 1074 |
198554 | 198554 | 2020-06-01 | Unknown | New Jersey | 863 | 0 | |
198555 | 198555 | 2020-06-01 | Warren | New Jersey | 34041 | 1165 | 132 |
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);