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-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 |
---|---|---|---|---|---|---|---|
1477340 | 1477340 | 2021-07-02 | Atlantic | New Jersey | 34001 | 31669 | 695 |
1477341 | 1477341 | 2021-07-02 | Bergen | New Jersey | 34003 | 105056 | 2890 |
1477342 | 1477342 | 2021-07-02 | Burlington | New Jersey | 34005 | 44430 | 872 |
1477343 | 1477343 | 2021-07-02 | Camden | New Jersey | 34007 | 55978 | 1340 |
1477344 | 1477344 | 2021-07-02 | Cape May | New Jersey | 34009 | 9297 | 208 |
1477345 | 1477345 | 2021-07-02 | Cumberland | New Jersey | 34011 | 17253 | 441 |
1477346 | 1477346 | 2021-07-02 | Essex | New Jersey | 34013 | 94523 | 3024 |
1477347 | 1477347 | 2021-07-02 | Gloucester | New Jersey | 34015 | 30741 | 645 |
1477348 | 1477348 | 2021-07-02 | Hudson | New Jersey | 34017 | 88420 | 2303 |
1477349 | 1477349 | 2021-07-02 | Hunterdon | New Jersey | 34019 | 9902 | 176 |
1477350 | 1477350 | 2021-07-02 | Mercer | New Jersey | 34021 | 34210 | 961 |
1477351 | 1477351 | 2021-07-02 | Middlesex | New Jersey | 34023 | 92704 | 2369 |
1477352 | 1477352 | 2021-07-02 | Monmouth | New Jersey | 34025 | 76180 | 1638 |
1477353 | 1477353 | 2021-07-02 | Morris | New Jersey | 34027 | 50421 | 1240 |
1477354 | 1477354 | 2021-07-02 | Ocean | New Jersey | 34029 | 76531 | 2171 |
1477355 | 1477355 | 2021-07-02 | Passaic | New Jersey | 34031 | 73435 | 1938 |
1477356 | 1477356 | 2021-07-02 | Salem | New Jersey | 34033 | 6120 | 188 |
1477357 | 1477357 | 2021-07-02 | Somerset | New Jersey | 34035 | 30264 | 846 |
1477358 | 1477358 | 2021-07-02 | Sussex | New Jersey | 34037 | 14122 | 307 |
1477359 | 1477359 | 2021-07-02 | Union | New Jersey | 34039 | 71810 | 1978 |
1477360 | 1477360 | 2021-07-02 | Unknown | New Jersey | 816 | 0 | |
1477361 | 1477361 | 2021-07-02 | Warren | New Jersey | 34041 | 10041 | 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);