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-10-31 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 |
---|---|---|---|---|---|---|---|
685340 | 685340 | 2020-10-31 | Atlantic | New Jersey | 34001 | 5270 | 267 |
685341 | 685341 | 2020-10-31 | Bergen | New Jersey | 34003 | 25609 | 2063 |
685342 | 685342 | 2020-10-31 | Burlington | New Jersey | 34005 | 8664 | 516 |
685343 | 685343 | 2020-10-31 | Camden | New Jersey | 34007 | 11852 | 635 |
685344 | 685344 | 2020-10-31 | Cape May | New Jersey | 34009 | 1145 | 100 |
685345 | 685345 | 2020-10-31 | Cumberland | New Jersey | 34011 | 4054 | 162 |
685346 | 685346 | 2020-10-31 | Essex | New Jersey | 34013 | 25347 | 2144 |
685347 | 685347 | 2020-10-31 | Gloucester | New Jersey | 34015 | 5598 | 249 |
685348 | 685348 | 2020-10-31 | Hudson | New Jersey | 34017 | 23643 | 1530 |
685349 | 685349 | 2020-10-31 | Hunterdon | New Jersey | 34019 | 1669 | 127 |
685350 | 685350 | 2020-10-31 | Mercer | New Jersey | 34021 | 9413 | 639 |
685351 | 685351 | 2020-10-31 | Middlesex | New Jersey | 34023 | 22756 | 1449 |
685352 | 685352 | 2020-10-31 | Monmouth | New Jersey | 34025 | 14401 | 873 |
685353 | 685353 | 2020-10-31 | Morris | New Jersey | 34027 | 9438 | 839 |
685354 | 685354 | 2020-10-31 | Ocean | New Jersey | 34029 | 17004 | 1069 |
685355 | 685355 | 2020-10-31 | Passaic | New Jersey | 34031 | 21296 | 1262 |
685356 | 685356 | 2020-10-31 | Salem | New Jersey | 34033 | 1190 | 89 |
685357 | 685357 | 2020-10-31 | Somerset | New Jersey | 34035 | 6624 | 595 |
685358 | 685358 | 2020-10-31 | Sussex | New Jersey | 34037 | 1790 | 197 |
685359 | 685359 | 2020-10-31 | Union | New Jersey | 34039 | 20720 | 1374 |
685360 | 685360 | 2020-10-31 | Unknown | New Jersey | 563 | 0 | |
685361 | 685361 | 2020-10-31 | Warren | New Jersey | 34041 | 1633 | 171 |
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);