ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 8 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
463867 | 463867 | 2020-08-24 | Lewis | Idaho | 16061 | 8 | 0 |
376869 | 376869 | 2020-07-28 | Lemhi | Idaho | 16059 | 8 | 0 |
373654 | 373654 | 2020-07-27 | Lemhi | Idaho | 16059 | 8 | 0 |
370442 | 370442 | 2020-07-26 | Lemhi | Idaho | 16059 | 8 | 0 |
367232 | 367232 | 2020-07-25 | Lemhi | Idaho | 16059 | 8 | 0 |
364025 | 364025 | 2020-07-24 | Lemhi | Idaho | 16059 | 8 | 0 |
360823 | 360823 | 2020-07-23 | Oneida | Idaho | 16071 | 8 | 0 |
357601 | 357601 | 2020-07-22 | Clearwater | Idaho | 16035 | 8 | 0 |
357618 | 357618 | 2020-07-22 | Oneida | Idaho | 16071 | 8 | 0 |
354399 | 354399 | 2020-07-21 | Clearwater | Idaho | 16035 | 8 | 0 |
354416 | 354416 | 2020-07-21 | Oneida | Idaho | 16071 | 8 | 0 |
351197 | 351197 | 2020-07-20 | Clearwater | Idaho | 16035 | 8 | 0 |
351214 | 351214 | 2020-07-20 | Oneida | Idaho | 16071 | 8 | 0 |
348014 | 348014 | 2020-07-19 | Oneida | Idaho | 16071 | 8 | 0 |
344813 | 344813 | 2020-07-18 | Oneida | Idaho | 16071 | 8 | 0 |
341613 | 341613 | 2020-07-17 | Oneida | Idaho | 16071 | 8 | 0 |
338417 | 338417 | 2020-07-16 | Oneida | Idaho | 16071 | 8 | 0 |
335199 | 335199 | 2020-07-15 | Boundary | Idaho | 16021 | 8 | 0 |
335221 | 335221 | 2020-07-15 | Oneida | Idaho | 16071 | 8 | 0 |
332028 | 332028 | 2020-07-14 | Oneida | Idaho | 16071 | 8 | 0 |
328841 | 328841 | 2020-07-13 | Oneida | Idaho | 16071 | 8 | 0 |
325655 | 325655 | 2020-07-12 | Oneida | Idaho | 16071 | 8 | 0 |
325659 | 325659 | 2020-07-12 | Shoshone | Idaho | 16079 | 8 | 0 |
322449 | 322449 | 2020-07-11 | Boise | Idaho | 16015 | 8 | 0 |
322474 | 322474 | 2020-07-11 | Oneida | Idaho | 16071 | 8 | 0 |
322478 | 322478 | 2020-07-11 | Shoshone | Idaho | 16079 | 8 | 0 |
319270 | 319270 | 2020-07-10 | Boise | Idaho | 16015 | 8 | 0 |
319295 | 319295 | 2020-07-10 | Oneida | Idaho | 16071 | 8 | 0 |
319299 | 319299 | 2020-07-10 | Shoshone | Idaho | 16079 | 8 | 0 |
316126 | 316126 | 2020-07-09 | Shoshone | Idaho | 16079 | 8 | 0 |
312934 | 312934 | 2020-07-08 | Fremont | Idaho | 16043 | 8 | 0 |
309764 | 309764 | 2020-07-07 | Fremont | Idaho | 16043 | 8 | 0 |
306596 | 306596 | 2020-07-06 | Fremont | Idaho | 16043 | 8 | 0 |
303432 | 303432 | 2020-07-05 | Fremont | Idaho | 16043 | 8 | 0 |
300268 | 300268 | 2020-07-04 | Fremont | Idaho | 16043 | 8 | 0 |
259400 | 259400 | 2020-06-21 | Latah | Idaho | 16057 | 8 | 0 |
256261 | 256261 | 2020-06-20 | Caribou | Idaho | 16029 | 8 | 0 |
256273 | 256273 | 2020-06-20 | Latah | Idaho | 16057 | 8 | 0 |
253142 | 253142 | 2020-06-19 | Caribou | Idaho | 16029 | 8 | 0 |
253154 | 253154 | 2020-06-19 | Latah | Idaho | 16057 | 8 | 0 |
250027 | 250027 | 2020-06-18 | Caribou | Idaho | 16029 | 8 | 0 |
250039 | 250039 | 2020-06-18 | Latah | Idaho | 16057 | 8 | 0 |
246927 | 246927 | 2020-06-17 | Latah | Idaho | 16057 | 8 | 0 |
243793 | 243793 | 2020-06-16 | Adams | Idaho | 16003 | 8 | 0 |
243814 | 243814 | 2020-06-16 | Latah | Idaho | 16057 | 8 | 0 |
240703 | 240703 | 2020-06-15 | Latah | Idaho | 16057 | 8 | 0 |
237601 | 237601 | 2020-06-14 | Owyhee | Idaho | 16073 | 8 | 0 |
234494 | 234494 | 2020-06-13 | Owyhee | Idaho | 16073 | 8 | 0 |
231388 | 231388 | 2020-06-12 | Owyhee | Idaho | 16073 | 8 | 0 |
228285 | 228285 | 2020-06-11 | Owyhee | Idaho | 16073 | 8 | 0 |
225183 | 225183 | 2020-06-10 | Owyhee | Idaho | 16073 | 8 | 0 |
222088 | 222088 | 2020-06-09 | Owyhee | Idaho | 16073 | 8 | 0 |
218993 | 218993 | 2020-06-08 | Owyhee | Idaho | 16073 | 8 | 0 |
218995 | 218995 | 2020-06-08 | Power | Idaho | 16077 | 8 | 0 |
215902 | 215902 | 2020-06-07 | Owyhee | Idaho | 16073 | 8 | 0 |
215904 | 215904 | 2020-06-07 | Power | Idaho | 16077 | 8 | 0 |
212815 | 212815 | 2020-06-06 | Owyhee | Idaho | 16073 | 8 | 0 |
209716 | 209716 | 2020-06-05 | Franklin | Idaho | 16041 | 8 | 0 |
209730 | 209730 | 2020-06-05 | Owyhee | Idaho | 16073 | 8 | 0 |
206649 | 206649 | 2020-06-04 | Owyhee | Idaho | 16073 | 8 | 0 |
203569 | 203569 | 2020-06-03 | Owyhee | Idaho | 16073 | 8 | 0 |
200469 | 200469 | 2020-06-02 | Bingham | Idaho | 16011 | 8 | 0 |
200493 | 200493 | 2020-06-02 | Owyhee | Idaho | 16073 | 8 | 0 |
197396 | 197396 | 2020-06-01 | Bingham | Idaho | 16011 | 8 | 0 |
197420 | 197420 | 2020-06-01 | Owyhee | Idaho | 16073 | 8 | 0 |
194325 | 194325 | 2020-05-31 | Benewah | Idaho | 16009 | 8 | 0 |
194350 | 194350 | 2020-05-31 | Owyhee | Idaho | 16073 | 8 | 0 |
191258 | 191258 | 2020-05-30 | Benewah | Idaho | 16009 | 8 | 0 |
188193 | 188193 | 2020-05-29 | Benewah | Idaho | 16009 | 8 | 0 |
169934 | 169934 | 2020-05-23 | Owyhee | Idaho | 16073 | 8 | 0 |
166897 | 166897 | 2020-05-22 | Owyhee | Idaho | 16073 | 8 | 0 |
160836 | 160836 | 2020-05-20 | Owyhee | Idaho | 16073 | 8 | 0 |
157810 | 157810 | 2020-05-19 | Owyhee | Idaho | 16073 | 8 | 0 |
154794 | 154794 | 2020-05-18 | Owyhee | Idaho | 16073 | 8 | 0 |
151782 | 151782 | 2020-05-17 | Owyhee | Idaho | 16073 | 8 | 0 |
148773 | 148773 | 2020-05-16 | Owyhee | Idaho | 16073 | 8 | 0 |
145770 | 145770 | 2020-05-15 | Owyhee | Idaho | 16073 | 8 | 0 |
142770 | 142770 | 2020-05-14 | Owyhee | Idaho | 16073 | 8 | 0 |
139774 | 139774 | 2020-05-13 | Owyhee | Idaho | 16073 | 8 | 0 |
136783 | 136783 | 2020-05-12 | Owyhee | Idaho | 16073 | 8 | 0 |
136789 | 136789 | 2020-05-12 | Washington | Idaho | 16087 | 8 | 0 |
133794 | 133794 | 2020-05-11 | Owyhee | Idaho | 16073 | 8 | 0 |
130803 | 130803 | 2020-05-10 | Owyhee | Idaho | 16073 | 8 | 0 |
127812 | 127812 | 2020-05-09 | Owyhee | Idaho | 16073 | 8 | 0 |
124825 | 124825 | 2020-05-08 | Owyhee | Idaho | 16073 | 8 | 0 |
121846 | 121846 | 2020-05-07 | Owyhee | Idaho | 16073 | 8 | 0 |
118876 | 118876 | 2020-05-06 | Owyhee | Idaho | 16073 | 8 | 0 |
115916 | 115916 | 2020-05-05 | Owyhee | Idaho | 16073 | 8 | 0 |
113033 | 113033 | 2020-05-04 | Owyhee | Idaho | 16073 | 8 | 0 |
110158 | 110158 | 2020-05-03 | Owyhee | Idaho | 16073 | 8 | 0 |
107288 | 107288 | 2020-05-02 | Owyhee | Idaho | 16073 | 8 | 0 |
104423 | 104423 | 2020-05-01 | Owyhee | Idaho | 16073 | 8 | 0 |
101568 | 101568 | 2020-04-30 | Owyhee | Idaho | 16073 | 8 | 0 |
98717 | 98717 | 2020-04-29 | Owyhee | Idaho | 16073 | 8 | 0 |
95873 | 95873 | 2020-04-28 | Owyhee | Idaho | 16073 | 8 | 0 |
93017 | 93017 | 2020-04-27 | Bannock | Idaho | 16005 | 8 | 0 |
93041 | 93041 | 2020-04-27 | Owyhee | Idaho | 16073 | 8 | 0 |
93044 | 93044 | 2020-04-27 | Teton | Idaho | 16081 | 8 | 0 |
90198 | 90198 | 2020-04-26 | Bannock | Idaho | 16005 | 8 | 0 |
90219 | 90219 | 2020-04-26 | Madison | Idaho | 16065 | 8 | 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);