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-06-28 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 |
---|---|---|---|---|---|---|---|
282513 | 282513 | 2020-06-28 | Atlantic | New Jersey | 34001 | 2853 | 211 |
282514 | 282514 | 2020-06-28 | Bergen | New Jersey | 34003 | 19617 | 1983 |
282515 | 282515 | 2020-06-28 | Burlington | New Jersey | 34005 | 5174 | 419 |
282516 | 282516 | 2020-06-28 | Camden | New Jersey | 34007 | 7331 | 483 |
282517 | 282517 | 2020-06-28 | Cape May | New Jersey | 34009 | 736 | 68 |
282518 | 282518 | 2020-06-28 | Cumberland | New Jersey | 34011 | 2954 | 141 |
282519 | 282519 | 2020-06-28 | Essex | New Jersey | 34013 | 18953 | 2021 |
282520 | 282520 | 2020-06-28 | Gloucester | New Jersey | 34015 | 2564 | 181 |
282521 | 282521 | 2020-06-28 | Hudson | New Jersey | 34017 | 19005 | 1449 |
282522 | 282522 | 2020-06-28 | Hunterdon | New Jersey | 34019 | 1129 | 123 |
282523 | 282523 | 2020-06-28 | Mercer | New Jersey | 34021 | 7664 | 578 |
282524 | 282524 | 2020-06-28 | Middlesex | New Jersey | 34023 | 16964 | 1318 |
282525 | 282525 | 2020-06-28 | Monmouth | New Jersey | 34025 | 9201 | 805 |
282526 | 282526 | 2020-06-28 | Morris | New Jersey | 34027 | 6876 | 795 |
282527 | 282527 | 2020-06-28 | Ocean | New Jersey | 34029 | 9638 | 944 |
282528 | 282528 | 2020-06-28 | Passaic | New Jersey | 34031 | 17015 | 1181 |
282529 | 282529 | 2020-06-28 | Salem | New Jersey | 34033 | 760 | 75 |
282530 | 282530 | 2020-06-28 | Somerset | New Jersey | 34035 | 4938 | 527 |
282531 | 282531 | 2020-06-28 | Sussex | New Jersey | 34037 | 1226 | 192 |
282532 | 282532 | 2020-06-28 | Union | New Jersey | 34039 | 16548 | 1325 |
282533 | 282533 | 2020-06-28 | Unknown | New Jersey | 651 | 0 | |
282534 | 282534 | 2020-06-28 | Warren | New Jersey | 34041 | 1239 | 156 |
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);