ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 87 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1726208 | 1726208 | 2021-09-17 | Camas | Idaho | 16025 | 87 | 0 |
1722959 | 1722959 | 2021-09-16 | Camas | Idaho | 16025 | 87 | 0 |
1719710 | 1719710 | 2021-09-15 | Camas | Idaho | 16025 | 87 | 0 |
716577 | 716577 | 2020-11-10 | Oneida | Idaho | 16071 | 87 | 0 |
687357 | 687357 | 2020-11-01 | Boise | Idaho | 16015 | 87 | 2 |
684113 | 684113 | 2020-10-31 | Boise | Idaho | 16015 | 87 | 2 |
632212 | 632212 | 2020-10-15 | Custer | Idaho | 16037 | 87 | 1 |
609513 | 609513 | 2020-10-08 | Clearwater | Idaho | 16035 | 87 | 0 |
560904 | 560904 | 2020-09-23 | Lemhi | Idaho | 16059 | 87 | 0 |
557670 | 557670 | 2020-09-22 | Lincoln | Idaho | 16063 | 87 | 0 |
557681 | 557681 | 2020-09-22 | Valley | Idaho | 16085 | 87 | 1 |
554433 | 554433 | 2020-09-21 | Lincoln | Idaho | 16063 | 87 | 0 |
554444 | 554444 | 2020-09-21 | Valley | Idaho | 16085 | 87 | 1 |
551194 | 551194 | 2020-09-20 | Lincoln | Idaho | 16063 | 87 | 0 |
547955 | 547955 | 2020-09-19 | Lincoln | Idaho | 16063 | 87 | 0 |
544717 | 544717 | 2020-09-18 | Lincoln | Idaho | 16063 | 87 | 0 |
421916 | 421916 | 2020-08-11 | Fremont | Idaho | 16043 | 87 | 0 |
418711 | 418711 | 2020-08-10 | Teton | Idaho | 16081 | 87 | 0 |
409050 | 409050 | 2020-08-07 | Shoshone | Idaho | 16079 | 87 | 2 |
367228 | 367228 | 2020-07-25 | Jefferson | Idaho | 16051 | 87 | 1 |
341601 | 341601 | 2020-07-17 | Gem | Idaho | 16045 | 87 | 0 |
335197 | 335197 | 2020-07-15 | Bonner | Idaho | 16017 | 87 | 0 |
335218 | 335218 | 2020-07-15 | Madison | Idaho | 16065 | 87 | 0 |
332017 | 332017 | 2020-07-14 | Gooding | Idaho | 16047 | 87 | 0 |
322475 | 322475 | 2020-07-11 | Owyhee | Idaho | 16073 | 87 | 0 |
243799 | 243799 | 2020-06-16 | Bonneville | Idaho | 16019 | 87 | 1 |
228283 | 228283 | 2020-06-11 | Minidoka | Idaho | 16067 | 87 | 0 |
142762 | 142762 | 2020-05-14 | Jerome | Idaho | 16053 | 87 | 2 |
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);