ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 16963 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Michigan 4
- Georgia 2
- Pennsylvania 2
- Alabama 1
- Arizona 1
- Minnesota 1
- New York 1
- North Carolina 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444745 | 2444745 | 2022-04-26 | Walker | Georgia | 13295 | 16963 | 239 |
2441489 | 2441489 | 2022-04-25 | Walker | Georgia | 13295 | 16963 | 239 |
2354392 | 2354392 | 2022-03-29 | Van Buren | Michigan | 26159 | 16963 | 266 |
2351140 | 2351140 | 2022-03-28 | Van Buren | Michigan | 26159 | 16963 | 266 |
2269770 | 2269770 | 2022-03-03 | Grand Traverse | Michigan | 26055 | 16963 | 218 |
2266517 | 2266517 | 2022-03-02 | Grand Traverse | Michigan | 26055 | 16963 | 218 |
2033063 | 2033063 | 2021-12-20 | Henderson | North Carolina | 37089 | 16963 | 219 |
1982410 | 1982410 | 2021-12-05 | St. Clair | Alabama | 1115 | 16963 | 359 |
1905742 | 1905742 | 2021-11-11 | Sherburne | Minnesota | 27141 | 16963 | 118 |
1780726 | 1780726 | 2021-10-03 | Berkeley | West Virginia | 54003 | 16963 | 158 |
1533021 | 1533021 | 2021-07-19 | Centre | Pennsylvania | 42027 | 16963 | 228 |
1316284 | 1316284 | 2021-05-13 | Richmond city | Virginia | 51760 | 16963 | 261 |
1147741 | 1147741 | 2021-03-23 | Coconino | Arizona | 4005 | 16963 | 323 |
948259 | 948259 | 2021-01-20 | Dutchess | New York | 36027 | 16963 | 322 |
740978 | 740978 | 2020-11-17 | Delaware | Pennsylvania | 42045 | 16963 | 833 |
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);