ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 1351 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Colorado 11
- Ohio 7
- New Jersey 6
- Maryland 3
- Pennsylvania 3
- Wisconsin 3
- Illinois 2
- Texas 2
- Alabama 1
- Connecticut 1
- Georgia 1
- Massachusetts 1
- Minnesota 1
- New Mexico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470530 | 2470530 | 2022-05-04 | Jefferson | Colorado | 8059 | 125913 | 1351 |
2467274 | 2467274 | 2022-05-03 | Jefferson | Colorado | 8059 | 125805 | 1351 |
2463989 | 2463989 | 2022-05-02 | Adams | Colorado | 8001 | 136652 | 1351 |
2460733 | 2460733 | 2022-05-01 | Adams | Colorado | 8001 | 136652 | 1351 |
2457477 | 2457477 | 2022-04-30 | Adams | Colorado | 8001 | 136577 | 1351 |
2454221 | 2454221 | 2022-04-29 | Adams | Colorado | 8001 | 136577 | 1351 |
2456669 | 2456669 | 2022-04-29 | Denton | Texas | 48121 | 180267 | 1351 |
2450965 | 2450965 | 2022-04-28 | Adams | Colorado | 8001 | 136054 | 1351 |
2447709 | 2447709 | 2022-04-27 | Adams | Colorado | 8001 | 135971 | 1351 |
2293597 | 2293597 | 2022-03-10 | Westmoreland | Pennsylvania | 42129 | 79267 | 1351 |
2081672 | 2081672 | 2022-01-04 | Morris | New Jersey | 34027 | 86505 | 1351 |
2081681 | 2081681 | 2022-01-04 | Bernalillo | New Mexico | 35001 | 101683 | 1351 |
2028127 | 2028127 | 2021-12-19 | El Paso | Colorado | 8041 | 119329 | 1351 |
2024876 | 2024876 | 2021-12-18 | El Paso | Colorado | 8041 | 119329 | 1351 |
2021625 | 2021625 | 2021-12-17 | El Paso | Colorado | 8041 | 119329 | 1351 |
1929212 | 1929212 | 2021-11-18 | Montgomery | Ohio | 39113 | 77865 | 1351 |
1925962 | 1925962 | 2021-11-17 | Montgomery | Ohio | 39113 | 77651 | 1351 |
1922712 | 1922712 | 2021-11-16 | Montgomery | Ohio | 39113 | 77496 | 1351 |
1875147 | 1875147 | 2021-11-02 | Mobile | Alabama | 1097 | 73235 | 1351 |
1782967 | 1782967 | 2021-10-04 | Hamilton | Ohio | 39061 | 101339 | 1351 |
1779718 | 1779718 | 2021-10-03 | Hamilton | Ohio | 39061 | 101129 | 1351 |
1776468 | 1776468 | 2021-10-02 | Hamilton | Ohio | 39061 | 100935 | 1351 |
1773218 | 1773218 | 2021-10-01 | Hamilton | Ohio | 39061 | 100609 | 1351 |
1646226 | 1646226 | 2021-08-23 | Camden | New Jersey | 34007 | 59168 | 1351 |
1642977 | 1642977 | 2021-08-22 | Camden | New Jersey | 34007 | 59016 | 1351 |
1306707 | 1306707 | 2021-05-10 | Milwaukee | Wisconsin | 55079 | 115913 | 1351 |
1303461 | 1303461 | 2021-05-09 | Milwaukee | Wisconsin | 55079 | 115852 | 1351 |
1300214 | 1300214 | 2021-05-08 | Milwaukee | Wisconsin | 55079 | 115777 | 1351 |
1278165 | 1278165 | 2021-05-02 | DuPage | Illinois | 17043 | 89043 | 1351 |
1274918 | 1274918 | 2021-05-01 | DuPage | Illinois | 17043 | 88941 | 1351 |
1252017 | 1252017 | 2021-04-24 | Fulton | Georgia | 13121 | 95621 | 1351 |
1201892 | 1201892 | 2021-04-08 | Delaware | Pennsylvania | 42045 | 46357 | 1351 |
1198643 | 1198643 | 2021-04-07 | Delaware | Pennsylvania | 42045 | 46140 | 1351 |
1113149 | 1113149 | 2021-03-12 | Prince George's | Maryland | 24033 | 75020 | 1351 |
1109903 | 1109903 | 2021-03-11 | Prince George's | Maryland | 24033 | 74880 | 1351 |
1087195 | 1087195 | 2021-03-04 | Hampden | Massachusetts | 25013 | 42209 | 1351 |
1012531 | 1012531 | 2021-02-09 | Montgomery | Maryland | 24031 | 60879 | 1351 |
994490 | 994490 | 2021-02-03 | Cameron | Texas | 48061 | 35536 | 1351 |
866620 | 866620 | 2020-12-26 | Hennepin | Minnesota | 27053 | 84526 | 1351 |
813650 | 813650 | 2020-12-10 | New Haven | Connecticut | 9009 | 36354 | 1351 |
494176 | 494176 | 2020-09-02 | Union | New Jersey | 34039 | 17303 | 1351 |
490942 | 490942 | 2020-09-01 | Union | New Jersey | 34039 | 17290 | 1351 |
487709 | 487709 | 2020-08-31 | Union | New Jersey | 34039 | 17269 | 1351 |
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);