ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 28 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
596526 | 596526 | 2020-10-04 | Adams | Idaho | 16003 | 28 | 2 |
593284 | 593284 | 2020-10-03 | Adams | Idaho | 16003 | 28 | 2 |
586837 | 586837 | 2020-10-01 | Oneida | Idaho | 16071 | 28 | 0 |
583597 | 583597 | 2020-09-30 | Oneida | Idaho | 16071 | 28 | 0 |
580324 | 580324 | 2020-09-29 | Adams | Idaho | 16003 | 28 | 2 |
580358 | 580358 | 2020-09-29 | Oneida | Idaho | 16071 | 28 | 0 |
577083 | 577083 | 2020-09-28 | Adams | Idaho | 16003 | 28 | 2 |
573840 | 573840 | 2020-09-27 | Adams | Idaho | 16003 | 28 | 2 |
570598 | 570598 | 2020-09-26 | Adams | Idaho | 16003 | 28 | 2 |
567356 | 567356 | 2020-09-25 | Adams | Idaho | 16003 | 28 | 2 |
564116 | 564116 | 2020-09-24 | Adams | Idaho | 16003 | 28 | 2 |
564126 | 564126 | 2020-09-24 | Butte | Idaho | 16023 | 28 | 0 |
560876 | 560876 | 2020-09-23 | Adams | Idaho | 16003 | 28 | 1 |
557640 | 557640 | 2020-09-22 | Adams | Idaho | 16003 | 28 | 1 |
554403 | 554403 | 2020-09-21 | Adams | Idaho | 16003 | 28 | 1 |
551164 | 551164 | 2020-09-20 | Adams | Idaho | 16003 | 28 | 1 |
547925 | 547925 | 2020-09-19 | Adams | Idaho | 16003 | 28 | 1 |
538229 | 538229 | 2020-09-16 | Clark | Idaho | 16033 | 28 | 0 |
518807 | 518807 | 2020-09-10 | Butte | Idaho | 16023 | 28 | 0 |
515572 | 515572 | 2020-09-09 | Butte | Idaho | 16023 | 28 | 0 |
512339 | 512339 | 2020-09-08 | Butte | Idaho | 16023 | 28 | 0 |
376854 | 376854 | 2020-07-28 | Caribou | Idaho | 16029 | 28 | 0 |
360826 | 360826 | 2020-07-23 | Power | Idaho | 16077 | 28 | 0 |
351218 | 351218 | 2020-07-20 | Shoshone | Idaho | 16079 | 28 | 0 |
335228 | 335228 | 2020-07-15 | Valley | Idaho | 16085 | 28 | 0 |
306603 | 306603 | 2020-07-06 | Latah | Idaho | 16057 | 28 | 0 |
293949 | 293949 | 2020-07-02 | Franklin | Idaho | 16041 | 28 | 0 |
293951 | 293951 | 2020-07-02 | Gem | Idaho | 16045 | 28 | 0 |
268791 | 268791 | 2020-06-24 | Owyhee | Idaho | 16073 | 28 | 0 |
262533 | 262533 | 2020-06-22 | Owyhee | Idaho | 16073 | 28 | 0 |
240710 | 240710 | 2020-06-15 | Payette | Idaho | 16075 | 28 | 2 |
228282 | 228282 | 2020-06-11 | Madison | Idaho | 16065 | 28 | 0 |
191257 | 191257 | 2020-05-30 | Bannock | Idaho | 16005 | 28 | 0 |
169918 | 169918 | 2020-05-23 | Cassia | Idaho | 16031 | 28 | 1 |
121826 | 121826 | 2020-05-07 | Bonneville | Idaho | 16019 | 28 | 0 |
118856 | 118856 | 2020-05-06 | Bonneville | Idaho | 16019 | 28 | 0 |
115896 | 115896 | 2020-05-05 | Bonneville | Idaho | 16019 | 28 | 0 |
113013 | 113013 | 2020-05-04 | Bonneville | Idaho | 16019 | 28 | 0 |
110138 | 110138 | 2020-05-03 | Bonneville | Idaho | 16019 | 28 | 0 |
107268 | 107268 | 2020-05-02 | Bonneville | Idaho | 16019 | 28 | 0 |
104403 | 104403 | 2020-05-01 | Bonneville | Idaho | 16019 | 28 | 0 |
101548 | 101548 | 2020-04-30 | Bonneville | Idaho | 16019 | 28 | 0 |
98697 | 98697 | 2020-04-29 | Bonneville | Idaho | 16019 | 28 | 0 |
90202 | 90202 | 2020-04-26 | Bonneville | Idaho | 16019 | 28 | 0 |
87386 | 87386 | 2020-04-25 | Bonneville | Idaho | 16019 | 28 | 0 |
84577 | 84577 | 2020-04-24 | Bonneville | Idaho | 16019 | 28 | 0 |
81777 | 81777 | 2020-04-23 | Bonneville | Idaho | 16019 | 28 | 0 |
78984 | 78984 | 2020-04-22 | Bonneville | Idaho | 16019 | 28 | 0 |
78990 | 78990 | 2020-04-22 | Elmore | Idaho | 16039 | 28 | 1 |
20104 | 20104 | 2020-03-30 | Kootenai | Idaho | 16055 | 28 | 0 |
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);