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-01-01 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 |
---|---|---|---|---|---|---|---|
886528 | 886528 | 2021-01-01 | Atlantic | New Jersey | 34001 | 12346 | 370 |
886529 | 886529 | 2021-01-01 | Bergen | New Jersey | 34003 | 47833 | 2330 |
886530 | 886530 | 2021-01-01 | Burlington | New Jersey | 34005 | 21512 | 627 |
886531 | 886531 | 2021-01-01 | Camden | New Jersey | 34007 | 28975 | 827 |
886532 | 886532 | 2021-01-01 | Cape May | New Jersey | 34009 | 2427 | 137 |
886533 | 886533 | 2021-01-01 | Cumberland | New Jersey | 34011 | 7962 | 229 |
886534 | 886534 | 2021-01-01 | Essex | New Jersey | 34013 | 47949 | 2399 |
886535 | 886535 | 2021-01-01 | Gloucester | New Jersey | 34015 | 14310 | 397 |
886536 | 886536 | 2021-01-01 | Hudson | New Jersey | 34017 | 44673 | 1707 |
886537 | 886537 | 2021-01-01 | Hunterdon | New Jersey | 34019 | 3853 | 139 |
886538 | 886538 | 2021-01-01 | Mercer | New Jersey | 34021 | 18960 | 725 |
886539 | 886539 | 2021-01-01 | Middlesex | New Jersey | 34023 | 45487 | 1683 |
886540 | 886540 | 2021-01-01 | Monmouth | New Jersey | 34025 | 32442 | 1049 |
886541 | 886541 | 2021-01-01 | Morris | New Jersey | 34027 | 20567 | 965 |
886542 | 886542 | 2021-01-01 | Ocean | New Jersey | 34029 | 32954 | 1381 |
886543 | 886543 | 2021-01-01 | Passaic | New Jersey | 34031 | 40318 | 1460 |
886544 | 886544 | 2021-01-01 | Salem | New Jersey | 34033 | 2800 | 112 |
886545 | 886545 | 2021-01-01 | Somerset | New Jersey | 34035 | 12848 | 666 |
886546 | 886546 | 2021-01-01 | Sussex | New Jersey | 34037 | 4585 | 215 |
886547 | 886547 | 2021-01-01 | Union | New Jersey | 34039 | 37015 | 1559 |
886548 | 886548 | 2021-01-01 | Unknown | New Jersey | 1075 | 0 | |
886549 | 886549 | 2021-01-01 | Warren | New Jersey | 34041 | 3991 | 183 |
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);