ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where deaths = 1668 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- Massachusetts 5
- California 4
- Georgia 3
- Maryland 3
- New Jersey 2
- Pennsylvania 2
- Tennessee 2
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2357561 | 2357561 | 2022-03-30 | Plymouth | Massachusetts | 25023 | 115188 | 1668 |
2354308 | 2354308 | 2022-03-29 | Plymouth | Massachusetts | 25023 | 115143 | 1668 |
2351056 | 2351056 | 2022-03-28 | Plymouth | Massachusetts | 25023 | 115103 | 1668 |
2346996 | 2346996 | 2022-03-27 | DeKalb | Georgia | 13089 | 146586 | 1668 |
2343743 | 2343743 | 2022-03-26 | DeKalb | Georgia | 13089 | 146586 | 1668 |
2340490 | 2340490 | 2022-03-25 | DeKalb | Georgia | 13089 | 146586 | 1668 |
2185158 | 2185158 | 2022-02-05 | Baltimore city | Maryland | 24510 | 105799 | 1668 |
2143948 | 2143948 | 2022-01-23 | Delaware | Pennsylvania | 42045 | 103646 | 1668 |
1879583 | 1879583 | 2021-11-03 | Hampden | Massachusetts | 25013 | 66151 | 1668 |
1790847 | 1790847 | 2021-10-07 | San Joaquin | California | 6077 | 100642 | 1668 |
1787598 | 1787598 | 2021-10-06 | San Joaquin | California | 6077 | 100447 | 1668 |
1756101 | 1756101 | 2021-09-26 | Prince George's | Maryland | 24033 | 96183 | 1668 |
1739856 | 1739856 | 2021-09-21 | Montgomery | Maryland | 24031 | 78806 | 1668 |
1685213 | 1685213 | 2021-09-04 | Monmouth | New Jersey | 34025 | 84262 | 1668 |
1387327 | 1387327 | 2021-06-04 | Cameron | Texas | 48061 | 41316 | 1668 |
1354822 | 1354822 | 2021-05-25 | Shelby | Tennessee | 47157 | 98368 | 1668 |
1351576 | 1351576 | 2021-05-24 | Shelby | Tennessee | 47157 | 98298 | 1668 |
1326427 | 1326427 | 2021-05-17 | Alameda | California | 6001 | 88178 | 1668 |
1323181 | 1323181 | 2021-05-16 | Alameda | California | 6001 | 88169 | 1668 |
1286345 | 1286345 | 2021-05-04 | Montgomery | Pennsylvania | 42091 | 68399 | 1668 |
1048252 | 1048252 | 2021-02-20 | Suffolk | Massachusetts | 25025 | 76620 | 1668 |
857331 | 857331 | 2020-12-23 | Hudson | New Jersey | 34017 | 40985 | 1668 |
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);