ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 11988 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 |
---|---|---|---|---|---|---|---|
2441567 | 2441567 | 2022-04-25 | Clinton | Illinois | 17027 | 11988 | 122 |
2348244 | 2348244 | 2022-03-27 | Buffalo | Nebraska | 31019 | 11988 | 94 |
2344991 | 2344991 | 2022-03-26 | Buffalo | Nebraska | 31019 | 11988 | 94 |
2341738 | 2341738 | 2022-03-25 | Buffalo | Nebraska | 31019 | 11988 | 94 |
2258219 | 2258219 | 2022-02-27 | Hardin | Texas | 48199 | 11988 | 244 |
2150397 | 2150397 | 2022-01-25 | Benton | Oregon | 41003 | 11988 | 48 |
2142419 | 2142419 | 2022-01-23 | Noble | Indiana | 18113 | 11988 | 146 |
2139164 | 2139164 | 2022-01-22 | Noble | Indiana | 18113 | 11988 | 146 |
2135908 | 2135908 | 2022-01-21 | Noble | Indiana | 18113 | 11988 | 146 |
2011685 | 2011685 | 2021-12-14 | Kenai Peninsula Borough | Alaska | 2122 | 11988 | 66 |
2008434 | 2008434 | 2021-12-13 | Kenai Peninsula Borough | Alaska | 2122 | 11988 | 66 |
1857488 | 1857488 | 2021-10-27 | Oswego | New York | 36075 | 11988 | 116 |
1313426 | 1313426 | 2021-05-13 | Saline | Arkansas | 5125 | 11988 | 168 |
1255463 | 1255463 | 2021-04-25 | LaSalle | Illinois | 17099 | 11988 | 289 |
1222389 | 1222389 | 2021-04-15 | Marshall | Alabama | 1095 | 11988 | 220 |
1113311 | 1113311 | 2021-03-12 | Olmsted | Minnesota | 27109 | 11988 | 93 |
885283 | 885283 | 2021-01-01 | Whitfield | Georgia | 13313 | 11988 | 126 |
731255 | 731255 | 2020-11-14 | Lancaster | Pennsylvania | 42071 | 11988 | 496 |
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);