ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where deaths = 561 and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- Cumberland 4
- Gloucester 4
- Somerset 4
- Morris 2
state 1
- New Jersey · 14 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175993 | 2175993 | 2022-02-02 | Cumberland | New Jersey | 34011 | 37024 | 561 |
2172740 | 2172740 | 2022-02-01 | Cumberland | New Jersey | 34011 | 36932 | 561 |
2166232 | 2166232 | 2022-01-30 | Cumberland | New Jersey | 34011 | 36800 | 561 |
2162977 | 2162977 | 2022-01-29 | Cumberland | New Jersey | 34011 | 36724 | 561 |
1120221 | 1120221 | 2021-03-14 | Gloucester | New Jersey | 34015 | 25206 | 561 |
1116974 | 1116974 | 2021-03-13 | Gloucester | New Jersey | 34015 | 25130 | 561 |
1113728 | 1113728 | 2021-03-12 | Gloucester | New Jersey | 34015 | 25056 | 561 |
1110482 | 1110482 | 2021-03-11 | Gloucester | New Jersey | 34015 | 24976 | 561 |
419909 | 419909 | 2020-08-10 | Somerset | New Jersey | 34035 | 5328 | 561 |
416689 | 416689 | 2020-08-09 | Somerset | New Jersey | 34035 | 5320 | 561 |
413468 | 413468 | 2020-08-08 | Somerset | New Jersey | 34035 | 5306 | 561 |
403809 | 403809 | 2020-08-05 | Somerset | New Jersey | 34035 | 5277 | 561 |
152882 | 152882 | 2020-05-17 | Morris | New Jersey | 34027 | 6036 | 561 |
149872 | 149872 | 2020-05-16 | Morris | New Jersey | 34027 | 6012 | 561 |
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);