ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where cases = 11922 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- Ohio 7
- Indiana 3
- Wisconsin 3
- Arizona 2
- Missouri 2
- Pennsylvania 1
- Tennessee 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451471 | 2451471 | 2022-04-28 | Lawrence | Indiana | 18093 | 11922 | 259 |
2448215 | 2448215 | 2022-04-27 | Lawrence | Indiana | 18093 | 11922 | 259 |
2312845 | 2312845 | 2022-03-16 | Ashland | Ohio | 39005 | 11922 | 212 |
2309592 | 2309592 | 2022-03-15 | Ashland | Ohio | 39005 | 11922 | 212 |
2306339 | 2306339 | 2022-03-14 | Ashland | Ohio | 39005 | 11922 | 212 |
2303088 | 2303088 | 2022-03-13 | Ashland | Ohio | 39005 | 11922 | 212 |
2299836 | 2299836 | 2022-03-12 | Ashland | Ohio | 39005 | 11922 | 212 |
2296584 | 2296584 | 2022-03-11 | Ashland | Ohio | 39005 | 11922 | 212 |
1940071 | 1940071 | 2021-11-21 | Wood | Wisconsin | 55141 | 11922 | 140 |
1936821 | 1936821 | 2021-11-20 | Wood | Wisconsin | 55141 | 11922 | 140 |
1933571 | 1933571 | 2021-11-19 | Wood | Wisconsin | 55141 | 11922 | 140 |
1840956 | 1840956 | 2021-10-22 | St. Francois | Missouri | 29187 | 11922 | 164 |
1791369 | 1791369 | 2021-10-07 | Kosciusko | Indiana | 18085 | 11922 | 150 |
1712502 | 1712502 | 2021-09-12 | Cabell | West Virginia | 54011 | 11922 | 199 |
1662194 | 1662194 | 2021-08-28 | Cole | Missouri | 29051 | 11922 | 147 |
1451648 | 1451648 | 2021-06-24 | Allen | Ohio | 39003 | 11922 | 239 |
1419431 | 1419431 | 2021-06-14 | Lycoming | Pennsylvania | 42081 | 11922 | 291 |
1277640 | 1277640 | 2021-05-02 | Cochise | Arizona | 4003 | 11922 | 284 |
894580 | 894580 | 2021-01-04 | Navajo | Arizona | 4017 | 11922 | 347 |
867888 | 867888 | 2020-12-26 | Wilson | Tennessee | 47189 | 11922 | 118 |
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);