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-07-06 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 |
---|---|---|---|---|---|---|---|
307768 | 307768 | 2020-07-06 | Atlantic | New Jersey | 34001 | 2963 | 221 |
307769 | 307769 | 2020-07-06 | Bergen | New Jersey | 34003 | 19916 | 2006 |
307770 | 307770 | 2020-07-06 | Burlington | New Jersey | 34005 | 5315 | 434 |
307771 | 307771 | 2020-07-06 | Camden | New Jersey | 34007 | 7547 | 525 |
307772 | 307772 | 2020-07-06 | Cape May | New Jersey | 34009 | 724 | 74 |
307773 | 307773 | 2020-07-06 | Cumberland | New Jersey | 34011 | 3034 | 149 |
307774 | 307774 | 2020-07-06 | Essex | New Jersey | 34013 | 19136 | 2041 |
307775 | 307775 | 2020-07-06 | Gloucester | New Jersey | 34015 | 2663 | 188 |
307776 | 307776 | 2020-07-06 | Hudson | New Jersey | 34017 | 19157 | 1456 |
307777 | 307777 | 2020-07-06 | Hunterdon | New Jersey | 34019 | 1145 | 124 |
307778 | 307778 | 2020-07-06 | Mercer | New Jersey | 34021 | 7788 | 591 |
307779 | 307779 | 2020-07-06 | Middlesex | New Jersey | 34023 | 17153 | 1333 |
307780 | 307780 | 2020-07-06 | Monmouth | New Jersey | 34025 | 9416 | 820 |
307781 | 307781 | 2020-07-06 | Morris | New Jersey | 34027 | 6967 | 806 |
307782 | 307782 | 2020-07-06 | Ocean | New Jersey | 34029 | 9784 | 974 |
307783 | 307783 | 2020-07-06 | Passaic | New Jersey | 34031 | 17110 | 1196 |
307784 | 307784 | 2020-07-06 | Salem | New Jersey | 34033 | 810 | 77 |
307785 | 307785 | 2020-07-06 | Somerset | New Jersey | 34035 | 5023 | 531 |
307786 | 307786 | 2020-07-06 | Sussex | New Jersey | 34037 | 1248 | 193 |
307787 | 307787 | 2020-07-06 | Union | New Jersey | 34039 | 16607 | 1328 |
307788 | 307788 | 2020-07-06 | Unknown | New Jersey | 695 | 0 | |
307789 | 307789 | 2020-07-06 | Warren | New Jersey | 34041 | 1266 | 162 |
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);