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 2022-04-16 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 |
---|---|---|---|---|---|---|---|
2413445 | 2413445 | 2022-04-16 | Atlantic | New Jersey | 34001 | 68713 | 991 |
2413446 | 2413446 | 2022-04-16 | Bergen | New Jersey | 34003 | 227223 | 3434 |
2413447 | 2413447 | 2022-04-16 | Burlington | New Jersey | 34005 | 103083 | 1199 |
2413448 | 2413448 | 2022-04-16 | Camden | New Jersey | 34007 | 126431 | 1793 |
2413449 | 2413449 | 2022-04-16 | Cape May | New Jersey | 34009 | 22009 | 300 |
2413450 | 2413450 | 2022-04-16 | Cumberland | New Jersey | 34011 | 39592 | 599 |
2413451 | 2413451 | 2022-04-16 | Essex | New Jersey | 34013 | 214767 | 3600 |
2413452 | 2413452 | 2022-04-16 | Gloucester | New Jersey | 34015 | 70047 | 958 |
2413453 | 2413453 | 2022-04-16 | Hudson | New Jersey | 34017 | 173287 | 2721 |
2413454 | 2413454 | 2022-04-16 | Hunterdon | New Jersey | 34019 | 24902 | 275 |
2413455 | 2413455 | 2022-04-16 | Mercer | New Jersey | 34021 | 77087 | 1256 |
2413456 | 2413456 | 2022-04-16 | Middlesex | New Jersey | 34023 | 195416 | 2864 |
2413457 | 2413457 | 2022-04-16 | Monmouth | New Jersey | 34025 | 165868 | 2167 |
2413458 | 2413458 | 2022-04-16 | Morris | New Jersey | 34027 | 120177 | 1532 |
2413459 | 2413459 | 2022-04-16 | Ocean | New Jersey | 34029 | 163312 | 2927 |
2413460 | 2413460 | 2022-04-16 | Passaic | New Jersey | 34031 | 145696 | 2334 |
2413461 | 2413461 | 2022-04-16 | Salem | New Jersey | 34033 | 14369 | 246 |
2413462 | 2413462 | 2022-04-16 | Somerset | New Jersey | 34035 | 68654 | 971 |
2413463 | 2413463 | 2022-04-16 | Sussex | New Jersey | 34037 | 34215 | 473 |
2413464 | 2413464 | 2022-04-16 | Union | New Jersey | 34039 | 146086 | 2357 |
2413465 | 2413465 | 2022-04-16 | Unknown | New Jersey | 2705 | 0 | |
2413466 | 2413466 | 2022-04-16 | Warren | New Jersey | 34041 | 24070 | 341 |
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);