ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 2352 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 7
- New Jersey 10
- California 1
- Connecticut 1
- Florida 1
- Massachusetts 1
- New York 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488359 | 2488359 | 2022-05-09 | Union | New Jersey | 34039 | 149770 | 2352 |
2485102 | 2485102 | 2022-05-08 | Union | New Jersey | 34039 | 149624 | 2352 |
2481844 | 2481844 | 2022-05-07 | Union | New Jersey | 34039 | 149434 | 2352 |
2348377 | 2348377 | 2022-03-27 | Union | New Jersey | 34039 | 144164 | 2352 |
2345124 | 2345124 | 2022-03-26 | Union | New Jersey | 34039 | 144108 | 2352 |
2341871 | 2341871 | 2022-03-25 | Union | New Jersey | 34039 | 144059 | 2352 |
2338618 | 2338618 | 2022-03-24 | Union | New Jersey | 34039 | 143986 | 2352 |
2332110 | 2332110 | 2022-03-22 | Union | New Jersey | 34039 | 143802 | 2352 |
1971961 | 1971961 | 2021-12-01 | Shelby | Tennessee | 47157 | 149234 | 2352 |
1902999 | 1902999 | 2021-11-10 | Westchester | New York | 36119 | 145179 | 2352 |
1857412 | 1857412 | 2021-10-27 | Ocean | New Jersey | 34029 | 95043 | 2352 |
1357265 | 1357265 | 2021-05-26 | Middlesex | New Jersey | 34023 | 92001 | 2352 |
1282022 | 1282022 | 2021-05-03 | Essex | Massachusetts | 25009 | 95725 | 2352 |
1190168 | 1190168 | 2021-04-05 | Hartford | Connecticut | 9003 | 76839 | 2352 |
1057079 | 1057079 | 2021-02-23 | Broward | Florida | 12011 | 191065 | 2352 |
1024515 | 1024515 | 2021-02-13 | San Bernardino | California | 6071 | 281604 | 2352 |
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);