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-12-07 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 |
---|---|---|---|---|---|---|---|
805393 | 805393 | 2020-12-07 | Atlantic | New Jersey | 34001 | 8882 | 307 |
805394 | 805394 | 2020-12-07 | Bergen | New Jersey | 34003 | 38479 | 2165 |
805395 | 805395 | 2020-12-07 | Burlington | New Jersey | 34005 | 15591 | 552 |
805396 | 805396 | 2020-12-07 | Camden | New Jersey | 34007 | 21850 | 699 |
805397 | 805397 | 2020-12-07 | Cape May | New Jersey | 34009 | 1818 | 117 |
805398 | 805398 | 2020-12-07 | Cumberland | New Jersey | 34011 | 5627 | 183 |
805399 | 805399 | 2020-12-07 | Essex | New Jersey | 34013 | 38807 | 2261 |
805400 | 805400 | 2020-12-07 | Gloucester | New Jersey | 34015 | 10362 | 304 |
805401 | 805401 | 2020-12-07 | Hudson | New Jersey | 34017 | 34820 | 1610 |
805402 | 805402 | 2020-12-07 | Hunterdon | New Jersey | 34019 | 2819 | 132 |
805403 | 805403 | 2020-12-07 | Mercer | New Jersey | 34021 | 15105 | 669 |
805404 | 805404 | 2020-12-07 | Middlesex | New Jersey | 34023 | 34039 | 1513 |
805405 | 805405 | 2020-12-07 | Monmouth | New Jersey | 34025 | 23168 | 919 |
805406 | 805406 | 2020-12-07 | Morris | New Jersey | 34027 | 15307 | 871 |
805407 | 805407 | 2020-12-07 | Ocean | New Jersey | 34029 | 24295 | 1158 |
805408 | 805408 | 2020-12-07 | Passaic | New Jersey | 34031 | 33318 | 1338 |
805409 | 805409 | 2020-12-07 | Salem | New Jersey | 34033 | 1871 | 99 |
805410 | 805410 | 2020-12-07 | Somerset | New Jersey | 34035 | 9985 | 614 |
805411 | 805411 | 2020-12-07 | Sussex | New Jersey | 34037 | 3022 | 200 |
805412 | 805412 | 2020-12-07 | Union | New Jersey | 34039 | 30561 | 1451 |
805413 | 805413 | 2020-12-07 | Unknown | New Jersey | 869 | 0 | |
805414 | 805414 | 2020-12-07 | Warren | New Jersey | 34041 | 2820 | 174 |
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);