ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where cases = 126 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Idaho · 14 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174765 | 2174765 | 2022-02-02 | Camas | Idaho | 16025 | 126 | 2 |
787945 | 787945 | 2020-12-02 | Butte | Idaho | 16023 | 126 | 0 |
755488 | 755488 | 2020-11-22 | Boise | Idaho | 16015 | 126 | 2 |
632225 | 632225 | 2020-10-15 | Lincoln | Idaho | 16063 | 126 | 0 |
606282 | 606282 | 2020-10-07 | Lemhi | Idaho | 16059 | 126 | 0 |
580337 | 580337 | 2020-09-29 | Caribou | Idaho | 16029 | 126 | 0 |
528509 | 528509 | 2020-09-13 | Benewah | Idaho | 16009 | 126 | 2 |
525273 | 525273 | 2020-09-12 | Benewah | Idaho | 16009 | 126 | 2 |
512349 | 512349 | 2020-09-08 | Fremont | Idaho | 16043 | 126 | 2 |
509116 | 509116 | 2020-09-07 | Fremont | Idaho | 16043 | 126 | 2 |
476800 | 476800 | 2020-08-28 | Teton | Idaho | 16081 | 126 | 0 |
473567 | 473567 | 2020-08-27 | Teton | Idaho | 16081 | 126 | 0 |
380080 | 380080 | 2020-07-29 | Gooding | Idaho | 16047 | 126 | 0 |
228268 | 228268 | 2020-06-11 | Cassia | Idaho | 16031 | 126 | 1 |
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);