ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 1677 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Massachusetts 8
- Tennessee 7
- Ohio 4
- New Jersey 3
- California 2
- Maryland 2
- New York 2
- Georgia 1
- Michigan 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464986 | 2464986 | 2022-05-02 | Plymouth | Massachusetts | 25023 | 118055 | 1677 |
2461730 | 2461730 | 2022-05-01 | Plymouth | Massachusetts | 25023 | 117761 | 1677 |
2458474 | 2458474 | 2022-04-30 | Plymouth | Massachusetts | 25023 | 117761 | 1677 |
2455218 | 2455218 | 2022-04-29 | Plymouth | Massachusetts | 25023 | 117761 | 1677 |
2353501 | 2353501 | 2022-03-29 | DeKalb | Georgia | 13089 | 146804 | 1677 |
2143961 | 2143961 | 2022-01-23 | Lancaster | Pennsylvania | 42071 | 113233 | 1677 |
2101469 | 2101469 | 2022-01-10 | Hamilton | Ohio | 39061 | 148833 | 1677 |
2098218 | 2098218 | 2022-01-09 | Hamilton | Ohio | 39061 | 147629 | 1677 |
2094966 | 2094966 | 2022-01-08 | Hamilton | Ohio | 39061 | 145454 | 1677 |
2091714 | 2091714 | 2022-01-07 | Hamilton | Ohio | 39061 | 143634 | 1677 |
1899081 | 1899081 | 2021-11-09 | Hampden | Massachusetts | 25013 | 66842 | 1677 |
1765846 | 1765846 | 2021-09-29 | Montgomery | Maryland | 24031 | 79701 | 1677 |
1447546 | 1447546 | 2021-06-23 | Baltimore | Maryland | 24005 | 65943 | 1677 |
1397016 | 1397016 | 2021-06-07 | Shelby | Tennessee | 47157 | 98942 | 1677 |
1393769 | 1393769 | 2021-06-06 | Shelby | Tennessee | 47157 | 98942 | 1677 |
1390524 | 1390524 | 2021-06-05 | Shelby | Tennessee | 47157 | 98942 | 1677 |
1387279 | 1387279 | 2021-06-04 | Shelby | Tennessee | 47157 | 98888 | 1677 |
1384034 | 1384034 | 2021-06-03 | Shelby | Tennessee | 47157 | 98829 | 1677 |
1380788 | 1380788 | 2021-06-02 | Shelby | Tennessee | 47157 | 98829 | 1677 |
1377543 | 1377543 | 2021-06-01 | Shelby | Tennessee | 47157 | 98779 | 1677 |
1336168 | 1336168 | 2021-05-20 | Alameda | California | 6001 | 88429 | 1677 |
1287479 | 1287479 | 2021-05-05 | Fresno | California | 6019 | 101451 | 1677 |
1246303 | 1246303 | 2021-04-22 | Bristol | Massachusetts | 25005 | 63758 | 1677 |
1211211 | 1211211 | 2021-04-11 | Erie | New York | 36029 | 79217 | 1677 |
1057992 | 1057992 | 2021-02-23 | Suffolk | Massachusetts | 25025 | 77071 | 1677 |
990402 | 990402 | 2021-02-02 | Union | New Jersey | 34039 | 51643 | 1677 |
928170 | 928170 | 2021-01-14 | Worcester | Massachusetts | 25027 | 51725 | 1677 |
899026 | 899026 | 2021-01-05 | Oakland | Michigan | 26125 | 63188 | 1677 |
889885 | 889885 | 2021-01-02 | Westchester | New York | 36119 | 71626 | 1677 |
883294 | 883294 | 2020-12-31 | Middlesex | New Jersey | 34023 | 45012 | 1677 |
863821 | 863821 | 2020-12-25 | Hudson | New Jersey | 34017 | 41922 | 1677 |
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);