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 2021-04-22 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 |
---|---|---|---|---|---|---|---|
1246865 | 1246865 | 2021-04-22 | Atlantic | New Jersey | 34001 | 30696 | 649 |
1246866 | 1246866 | 2021-04-22 | Bergen | New Jersey | 34003 | 99542 | 2805 |
1246867 | 1246867 | 2021-04-22 | Burlington | New Jersey | 34005 | 43271 | 826 |
1246868 | 1246868 | 2021-04-22 | Camden | New Jersey | 34007 | 52949 | 1253 |
1246869 | 1246869 | 2021-04-22 | Cape May | New Jersey | 34009 | 8831 | 199 |
1246870 | 1246870 | 2021-04-22 | Cumberland | New Jersey | 34011 | 16251 | 417 |
1246871 | 1246871 | 2021-04-22 | Essex | New Jersey | 34013 | 94091 | 2859 |
1246872 | 1246872 | 2021-04-22 | Gloucester | New Jersey | 34015 | 29261 | 599 |
1246873 | 1246873 | 2021-04-22 | Hudson | New Jersey | 34017 | 86631 | 2197 |
1246874 | 1246874 | 2021-04-22 | Hunterdon | New Jersey | 34019 | 9368 | 171 |
1246875 | 1246875 | 2021-04-22 | Mercer | New Jersey | 34021 | 33114 | 921 |
1246876 | 1246876 | 2021-04-22 | Middlesex | New Jersey | 34023 | 91147 | 2273 |
1246877 | 1246877 | 2021-04-22 | Monmouth | New Jersey | 34025 | 73918 | 1560 |
1246878 | 1246878 | 2021-04-22 | Morris | New Jersey | 34027 | 49056 | 1204 |
1246879 | 1246879 | 2021-04-22 | Ocean | New Jersey | 34029 | 73871 | 2085 |
1246880 | 1246880 | 2021-04-22 | Passaic | New Jersey | 34031 | 70492 | 1848 |
1246881 | 1246881 | 2021-04-22 | Salem | New Jersey | 34033 | 5741 | 174 |
1246882 | 1246882 | 2021-04-22 | Somerset | New Jersey | 34035 | 29133 | 817 |
1246883 | 1246883 | 2021-04-22 | Sussex | New Jersey | 34037 | 13335 | 290 |
1246884 | 1246884 | 2021-04-22 | Union | New Jersey | 34039 | 69572 | 1905 |
1246885 | 1246885 | 2021-04-22 | Unknown | New Jersey | 842 | 0 | |
1246886 | 1246886 | 2021-04-22 | Warren | New Jersey | 34041 | 9468 | 230 |
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);