ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 2026 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- New Jersey 5
- New York 5
- Pennsylvania 4
- Massachusetts 3
- California 2
- Texas 2
- Indiana 1
- Kentucky 1
- Maryland 1
- Michigan 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2377059 | 2377059 | 2022-04-05 | Montgomery | Maryland | 24031 | 167689 | 2026 |
2224040 | 2224040 | 2022-02-17 | Jefferson | Kentucky | 21111 | 219584 | 2026 |
2129881 | 2129881 | 2022-01-19 | Norfolk | Massachusetts | 25021 | 116638 | 2026 |
2063016 | 2063016 | 2021-12-29 | Cameron | Texas | 48061 | 68303 | 2026 |
2059766 | 2059766 | 2021-12-28 | Cameron | Texas | 48061 | 68188 | 2026 |
2042093 | 2042093 | 2021-12-23 | Bristol | Massachusetts | 25005 | 99706 | 2026 |
1948457 | 1948457 | 2021-11-24 | Erie | New York | 36029 | 121435 | 2026 |
1922402 | 1922402 | 2021-11-16 | Passaic | New Jersey | 34031 | 82848 | 2026 |
1779437 | 1779437 | 2021-10-03 | Union | New Jersey | 34039 | 78721 | 2026 |
1776187 | 1776187 | 2021-10-02 | Union | New Jersey | 34039 | 78674 | 2026 |
1772937 | 1772937 | 2021-10-01 | Union | New Jersey | 34039 | 78596 | 2026 |
1723142 | 1723142 | 2021-09-16 | Marion | Indiana | 18097 | 125948 | 2026 |
1712866 | 1712866 | 2021-09-13 | Sacramento | California | 6067 | 147431 | 2026 |
1562235 | 1562235 | 2021-07-28 | Allegheny | Pennsylvania | 42003 | 102811 | 2026 |
1558987 | 1558987 | 2021-07-27 | Allegheny | Pennsylvania | 42003 | 102760 | 2026 |
1245302 | 1245302 | 2021-04-22 | Santa Clara | California | 6085 | 117538 | 2026 |
1168421 | 1168421 | 2021-03-29 | Macomb | Michigan | 26099 | 71046 | 2026 |
1029341 | 1029341 | 2021-02-14 | Middlesex | New Jersey | 34023 | 68756 | 2026 |
1006053 | 1006053 | 2021-02-07 | Essex | Massachusetts | 25009 | 79511 | 2026 |
783200 | 783200 | 2020-11-30 | Philadelphia | Pennsylvania | 42101 | 67283 | 2026 |
779955 | 779955 | 2020-11-29 | Philadelphia | Pennsylvania | 42101 | 65484 | 2026 |
737341 | 737341 | 2020-11-16 | Suffolk | New York | 36103 | 53653 | 2026 |
734097 | 734097 | 2020-11-15 | Suffolk | New York | 36103 | 53308 | 2026 |
285758 | 285758 | 2020-06-29 | Suffolk | New York | 36103 | 41339 | 2026 |
282613 | 282613 | 2020-06-28 | Suffolk | New York | 36103 | 41306 | 2026 |
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);