ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 15656 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Michigan 7
- Indiana 4
- Maine 3
- Texas 3
- Washington 3
- Arkansas 1
- Georgia 1
- New York 1
- Ohio 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2349662 | 2349662 | 2022-03-27 | Walla Walla | Washington | 53071 | 15656 | 140 |
2346409 | 2346409 | 2022-03-26 | Walla Walla | Washington | 53071 | 15656 | 140 |
2343156 | 2343156 | 2022-03-25 | Walla Walla | Washington | 53071 | 15656 | 140 |
2258235 | 2258235 | 2022-02-27 | Hunt | Texas | 48231 | 15656 | 351 |
2254984 | 2254984 | 2022-02-26 | Hunt | Texas | 48231 | 15656 | 350 |
2129368 | 2129368 | 2022-01-19 | Floyd | Indiana | 18043 | 15656 | 268 |
2123328 | 2123328 | 2022-01-17 | Kennebec | Maine | 23011 | 15656 | 169 |
2119677 | 2119677 | 2022-01-16 | Wayne | Indiana | 18177 | 15656 | 303 |
2120076 | 2120076 | 2022-01-16 | Kennebec | Maine | 23011 | 15656 | 169 |
2116425 | 2116425 | 2022-01-15 | Wayne | Indiana | 18177 | 15656 | 303 |
2116824 | 2116824 | 2022-01-15 | Kennebec | Maine | 23011 | 15656 | 169 |
2113174 | 2113174 | 2022-01-14 | Wayne | Indiana | 18177 | 15656 | 303 |
2054330 | 2054330 | 2021-12-27 | Jackson | Georgia | 13157 | 15656 | 233 |
1905597 | 1905597 | 2021-11-11 | Bay | Michigan | 26017 | 15656 | 404 |
1902348 | 1902348 | 2021-11-10 | Bay | Michigan | 26017 | 15656 | 404 |
1781011 | 1781011 | 2021-10-04 | Garland | Arkansas | 5051 | 15656 | 374 |
1769765 | 1769765 | 2021-09-30 | Schenectady | New York | 36093 | 15656 | 218 |
1672487 | 1672487 | 2021-08-31 | Clark | Ohio | 39023 | 15656 | 316 |
1587258 | 1587258 | 2021-08-05 | Monroe | Michigan | 26115 | 15656 | 267 |
1584007 | 1584007 | 2021-08-04 | Monroe | Michigan | 26115 | 15656 | 267 |
1580758 | 1580758 | 2021-08-03 | Monroe | Michigan | 26115 | 15656 | 267 |
1179168 | 1179168 | 2021-04-01 | Lackawanna | Pennsylvania | 42069 | 15656 | 435 |
1028854 | 1028854 | 2021-02-14 | Saginaw | Michigan | 26145 | 15656 | 494 |
1025608 | 1025608 | 2021-02-13 | Saginaw | Michigan | 26145 | 15656 | 494 |
699383 | 699383 | 2020-11-04 | Webb | Texas | 48479 | 15656 | 361 |
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);