ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where deaths = 1250 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- New Jersey 10
- Florida 8
- Texas 5
- California 4
- Ohio 4
- Pennsylvania 4
- Colorado 3
- Indiana 3
- Georgia 2
- South Carolina 2
- Connecticut 1
- Delaware 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2293069 | 2293069 | 2022-03-10 | Mercer | New Jersey | 34021 | 74990 | 1250 |
2289817 | 2289817 | 2022-03-09 | Mercer | New Jersey | 34021 | 74944 | 1250 |
2286565 | 2286565 | 2022-03-08 | Mercer | New Jersey | 34021 | 74892 | 1250 |
2229030 | 2229030 | 2022-02-18 | Montgomery | Texas | 48339 | 134337 | 1250 |
2225779 | 2225779 | 2022-02-17 | Montgomery | Texas | 48339 | 134018 | 1250 |
2216008 | 2216008 | 2022-02-14 | Lubbock | Texas | 48303 | 96503 | 1250 |
2210239 | 2210239 | 2022-02-13 | Denver | Colorado | 8031 | 161991 | 1250 |
2206986 | 2206986 | 2022-02-12 | Denver | Colorado | 8031 | 161991 | 1250 |
2203733 | 2203733 | 2022-02-11 | Denver | Colorado | 8031 | 161991 | 1250 |
2199272 | 2199272 | 2022-02-09 | Luzerne | Pennsylvania | 42079 | 71390 | 1250 |
2194030 | 2194030 | 2022-02-08 | New Castle | Delaware | 10003 | 142688 | 1250 |
2175342 | 2175342 | 2022-02-02 | Jefferson | Louisiana | 22051 | 109878 | 1250 |
2080222 | 2080222 | 2022-01-04 | Lake | Florida | 12069 | 59574 | 1250 |
2076970 | 2076970 | 2022-01-03 | Lake | Florida | 12069 | 59574 | 1250 |
2073719 | 2073719 | 2022-01-02 | Lake | Florida | 12069 | 59574 | 1250 |
2070468 | 2070468 | 2022-01-01 | Lake | Florida | 12069 | 59574 | 1250 |
2067217 | 2067217 | 2021-12-31 | Lake | Florida | 12069 | 59574 | 1250 |
2063966 | 2063966 | 2021-12-30 | Lake | Florida | 12069 | 56730 | 1250 |
2060716 | 2060716 | 2021-12-29 | Lake | Florida | 12069 | 56730 | 1250 |
2040161 | 2040161 | 2021-12-22 | Davidson | Tennessee | 47037 | 140061 | 1250 |
1991312 | 1991312 | 2021-12-07 | Spartanburg | South Carolina | 45083 | 63610 | 1250 |
1988061 | 1988061 | 2021-12-06 | Spartanburg | South Carolina | 45083 | 63570 | 1250 |
1914844 | 1914844 | 2021-11-14 | Lake | Indiana | 18089 | 68736 | 1250 |
1911594 | 1911594 | 2021-11-13 | Lake | Indiana | 18089 | 68736 | 1250 |
1908345 | 1908345 | 2021-11-12 | Lake | Indiana | 18089 | 68736 | 1250 |
1810550 | 1810550 | 2021-10-13 | DeKalb | Georgia | 13089 | 90845 | 1250 |
1807301 | 1807301 | 2021-10-12 | DeKalb | Georgia | 13089 | 90731 | 1250 |
1745371 | 1745371 | 2021-09-23 | Stanislaus | California | 6099 | 81209 | 1250 |
1672219 | 1672219 | 2021-08-31 | Morris | New Jersey | 34027 | 53384 | 1250 |
1668972 | 1668972 | 2021-08-30 | Morris | New Jersey | 34027 | 53275 | 1250 |
1665725 | 1665725 | 2021-08-29 | Morris | New Jersey | 34027 | 53205 | 1250 |
1662477 | 1662477 | 2021-08-28 | Morris | New Jersey | 34027 | 53123 | 1250 |
1659229 | 1659229 | 2021-08-27 | Morris | New Jersey | 34027 | 53032 | 1250 |
1470263 | 1470263 | 2021-06-30 | Baltimore city | Maryland | 24510 | 53166 | 1250 |
1441941 | 1441941 | 2021-06-21 | Hamilton | Ohio | 39061 | 81413 | 1250 |
1438696 | 1438696 | 2021-06-20 | Hamilton | Ohio | 39061 | 81409 | 1250 |
1435449 | 1435449 | 2021-06-19 | Hamilton | Ohio | 39061 | 81397 | 1250 |
1432202 | 1432202 | 2021-06-18 | Hamilton | Ohio | 39061 | 81373 | 1250 |
1164105 | 1164105 | 2021-03-28 | San Joaquin | California | 6077 | 69448 | 1250 |
1160857 | 1160857 | 2021-03-27 | San Joaquin | California | 6077 | 69448 | 1250 |
1157609 | 1157609 | 2021-03-26 | San Joaquin | California | 6077 | 69448 | 1250 |
1042805 | 1042805 | 2021-02-18 | Delaware | Pennsylvania | 42045 | 39778 | 1250 |
1039560 | 1039560 | 2021-02-17 | Delaware | Pennsylvania | 42045 | 39642 | 1250 |
1037222 | 1037222 | 2021-02-16 | Milwaukee | Wisconsin | 55079 | 105835 | 1250 |
962977 | 962977 | 2021-01-25 | Hillsborough | Florida | 12057 | 97288 | 1250 |
925990 | 925990 | 2021-01-13 | Montgomery | Pennsylvania | 42091 | 41961 | 1250 |
844356 | 844356 | 2020-12-19 | Ocean | New Jersey | 34029 | 28239 | 1250 |
785372 | 785372 | 2020-12-01 | Suffolk | Massachusetts | 25025 | 37318 | 1250 |
545931 | 545931 | 2020-09-18 | Passaic | New Jersey | 34031 | 18917 | 1250 |
504794 | 504794 | 2020-09-05 | Hidalgo | Texas | 48215 | 28369 | 1250 |
501560 | 501560 | 2020-09-04 | Hidalgo | Texas | 48215 | 28309 | 1250 |
194076 | 194076 | 2020-05-31 | Hartford | Connecticut | 9003 | 10296 | 1250 |
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);