ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 8357 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460021 | 2460021 | 2022-04-30 | Matagorda | Texas | 48321 | 8357 | 175 |
2456765 | 2456765 | 2022-04-29 | Matagorda | Texas | 48321 | 8357 | 175 |
2450369 | 2450369 | 2022-04-27 | Sanpete | Utah | 49039 | 8357 | 56 |
2447112 | 2447112 | 2022-04-26 | Sanpete | Utah | 49039 | 8357 | 56 |
2443857 | 2443857 | 2022-04-25 | Sanpete | Utah | 49039 | 8357 | 56 |
2271424 | 2271424 | 2022-03-03 | Windsor | Vermont | 50027 | 8357 | 49 |
2266387 | 2266387 | 2022-03-02 | Evangeline | Louisiana | 22039 | 8357 | 152 |
2256516 | 2256516 | 2022-02-27 | Carter | Kentucky | 21043 | 8357 | 96 |
2253265 | 2253265 | 2022-02-26 | Carter | Kentucky | 21043 | 8357 | 96 |
2250014 | 2250014 | 2022-02-25 | Carter | Kentucky | 21043 | 8357 | 96 |
2109864 | 2109864 | 2022-01-13 | Harrison | Indiana | 18061 | 8357 | 115 |
2051970 | 2051970 | 2021-12-26 | Itasca | Minnesota | 27061 | 8357 | 110 |
2048720 | 2048720 | 2021-12-25 | Itasca | Minnesota | 27061 | 8357 | 110 |
2045470 | 2045470 | 2021-12-24 | Itasca | Minnesota | 27061 | 8357 | 110 |
2042220 | 2042220 | 2021-12-23 | Itasca | Minnesota | 27061 | 8357 | 110 |
1945522 | 1945522 | 2021-11-23 | Grady | Oklahoma | 40051 | 8357 | 185 |
1942271 | 1942271 | 2021-11-22 | Grady | Oklahoma | 40051 | 8357 | 185 |
1939021 | 1939021 | 2021-11-21 | Grady | Oklahoma | 40051 | 8357 | 185 |
1935771 | 1935771 | 2021-11-20 | Grady | Oklahoma | 40051 | 8357 | 185 |
1932521 | 1932521 | 2021-11-19 | Grady | Oklahoma | 40051 | 8357 | 185 |
1929270 | 1929270 | 2021-11-18 | Grady | Oklahoma | 40051 | 8357 | 185 |
1926020 | 1926020 | 2021-11-17 | Grady | Oklahoma | 40051 | 8357 | 185 |
1904873 | 1904873 | 2021-11-11 | Tift | Georgia | 13277 | 8357 | 183 |
1901623 | 1901623 | 2021-11-10 | Tift | Georgia | 13277 | 8357 | 183 |
1898373 | 1898373 | 2021-11-09 | Tift | Georgia | 13277 | 8357 | 183 |
1830781 | 1830781 | 2021-10-19 | St. Martin | Louisiana | 22099 | 8357 | 160 |
1808139 | 1808139 | 2021-10-12 | Grand Traverse | Michigan | 26055 | 8357 | 113 |
1804888 | 1804888 | 2021-10-11 | Grand Traverse | Michigan | 26055 | 8357 | 113 |
1791127 | 1791127 | 2021-10-07 | Polk | Georgia | 13233 | 8357 | 143 |
1722343 | 1722343 | 2021-09-15 | Portage | Wisconsin | 55097 | 8357 | 84 |
1714537 | 1714537 | 2021-09-13 | St. Lawrence | New York | 36089 | 8357 | 109 |
1629411 | 1629411 | 2021-08-18 | Wicomico | Maryland | 24045 | 8357 | 181 |
1627850 | 1627850 | 2021-08-17 | Chittenden | Vermont | 50007 | 8357 | 108 |
1611600 | 1611600 | 2021-08-12 | Tooele | Utah | 49045 | 8357 | 50 |
1607534 | 1607534 | 2021-08-11 | Erie | Ohio | 39043 | 8357 | 167 |
1602276 | 1602276 | 2021-08-10 | Fairbanks North Star Borough | Alaska | 2090 | 8357 | 45 |
1554906 | 1554906 | 2021-07-26 | Forrest | Mississippi | 28035 | 8357 | 157 |
1539678 | 1539678 | 2021-07-21 | Greenwood | South Carolina | 45047 | 8357 | 174 |
1508468 | 1508468 | 2021-07-12 | Gordon | Georgia | 13129 | 8357 | 120 |
1336041 | 1336041 | 2021-05-20 | Talladega | Alabama | 1121 | 8357 | 178 |
1192006 | 1192006 | 2021-04-05 | Wayne | Ohio | 39169 | 8357 | 209 |
1075186 | 1075186 | 2021-02-28 | Payne | Oklahoma | 40119 | 8357 | 47 |
861048 | 861048 | 2020-12-24 | Butler | Pennsylvania | 42019 | 8357 | 165 |
512145 | 512145 | 2020-09-08 | Pasco | Florida | 12101 | 8357 | 184 |
447889 | 447889 | 2020-08-19 | Lake | Indiana | 18089 | 8357 | 304 |
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);