ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 14246 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 |
---|---|---|---|---|---|---|---|
2446866 | 2446866 | 2022-04-26 | Caldwell | Texas | 48055 | 14246 | 175 |
2179721 | 2179721 | 2022-02-03 | Bradford | Pennsylvania | 42015 | 14246 | 188 |
2099399 | 2099399 | 2022-01-10 | DeKalb | Alabama | 1049 | 14246 | 283 |
1824324 | 1824324 | 2021-10-17 | Charles | Maryland | 24017 | 14246 | 251 |
1667579 | 1667579 | 2021-08-30 | Carroll | Georgia | 13045 | 14246 | 255 |
1656302 | 1656302 | 2021-08-26 | Portage | Ohio | 39133 | 14246 | 219 |
1451658 | 1451658 | 2021-06-24 | Clark | Ohio | 39023 | 14246 | 306 |
1296082 | 1296082 | 2021-05-07 | Monroe | Pennsylvania | 42089 | 14246 | 305 |
1277595 | 1277595 | 2021-05-02 | Morgan | Alabama | 1103 | 14246 | 279 |
1188591 | 1188591 | 2021-04-04 | Randolph | North Carolina | 37151 | 14246 | 215 |
1185344 | 1185344 | 2021-04-03 | Randolph | North Carolina | 37151 | 14246 | 215 |
1182097 | 1182097 | 2021-04-02 | Randolph | North Carolina | 37151 | 14246 | 215 |
1178850 | 1178850 | 2021-04-01 | Randolph | North Carolina | 37151 | 14246 | 215 |
989990 | 989990 | 2021-02-02 | St. Louis | Minnesota | 27137 | 14246 | 254 |
972657 | 972657 | 2021-01-28 | Pueblo | Colorado | 8101 | 14246 | 356 |
810456 | 810456 | 2020-12-09 | Marion | Florida | 12083 | 14246 | 409 |
699095 | 699095 | 2020-11-04 | Knox | Tennessee | 47093 | 14246 | 109 |
352680 | 352680 | 2020-07-20 | Franklin | Ohio | 39049 | 14246 | 468 |
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);