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-07-15 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 |
---|---|---|---|---|---|---|---|
1519545 | 1519545 | 2021-07-15 | Atlantic | New Jersey | 34001 | 31812 | 696 |
1519546 | 1519546 | 2021-07-15 | Bergen | New Jersey | 34003 | 105384 | 2895 |
1519547 | 1519547 | 2021-07-15 | Burlington | New Jersey | 34005 | 44598 | 879 |
1519548 | 1519548 | 2021-07-15 | Camden | New Jersey | 34007 | 56208 | 1343 |
1519549 | 1519549 | 2021-07-15 | Cape May | New Jersey | 34009 | 9318 | 208 |
1519550 | 1519550 | 2021-07-15 | Cumberland | New Jersey | 34011 | 17292 | 442 |
1519551 | 1519551 | 2021-07-15 | Essex | New Jersey | 34013 | 94829 | 3031 |
1519552 | 1519552 | 2021-07-15 | Gloucester | New Jersey | 34015 | 30826 | 647 |
1519553 | 1519553 | 2021-07-15 | Hudson | New Jersey | 34017 | 88604 | 2308 |
1519554 | 1519554 | 2021-07-15 | Hunterdon | New Jersey | 34019 | 9945 | 176 |
1519555 | 1519555 | 2021-07-15 | Mercer | New Jersey | 34021 | 34270 | 961 |
1519556 | 1519556 | 2021-07-15 | Middlesex | New Jersey | 34023 | 92933 | 2373 |
1519557 | 1519557 | 2021-07-15 | Monmouth | New Jersey | 34025 | 76687 | 1642 |
1519558 | 1519558 | 2021-07-15 | Morris | New Jersey | 34027 | 50596 | 1242 |
1519559 | 1519559 | 2021-07-15 | Ocean | New Jersey | 34029 | 76893 | 2176 |
1519560 | 1519560 | 2021-07-15 | Passaic | New Jersey | 34031 | 73638 | 1945 |
1519561 | 1519561 | 2021-07-15 | Salem | New Jersey | 34033 | 6140 | 188 |
1519562 | 1519562 | 2021-07-15 | Somerset | New Jersey | 34035 | 30376 | 846 |
1519563 | 1519563 | 2021-07-15 | Sussex | New Jersey | 34037 | 14165 | 307 |
1519564 | 1519564 | 2021-07-15 | Union | New Jersey | 34039 | 72046 | 1986 |
1519565 | 1519565 | 2021-07-15 | Unknown | New Jersey | 829 | 0 | |
1519566 | 1519566 | 2021-07-15 | Warren | New Jersey | 34041 | 10071 | 238 |
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);