ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 27 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 |
---|---|---|---|---|---|---|---|
577117 | 577117 | 2020-09-28 | Oneida | Idaho | 16071 | 27 | 0 |
573851 | 573851 | 2020-09-27 | Camas | Idaho | 16025 | 27 | 0 |
573874 | 573874 | 2020-09-27 | Oneida | Idaho | 16071 | 27 | 0 |
570609 | 570609 | 2020-09-26 | Camas | Idaho | 16025 | 27 | 0 |
570632 | 570632 | 2020-09-26 | Oneida | Idaho | 16071 | 27 | 0 |
567367 | 567367 | 2020-09-25 | Camas | Idaho | 16025 | 27 | 0 |
560886 | 560886 | 2020-09-23 | Butte | Idaho | 16023 | 27 | 0 |
557650 | 557650 | 2020-09-22 | Butte | Idaho | 16023 | 27 | 0 |
554413 | 554413 | 2020-09-21 | Butte | Idaho | 16023 | 27 | 0 |
551174 | 551174 | 2020-09-20 | Butte | Idaho | 16023 | 27 | 0 |
547935 | 547935 | 2020-09-19 | Butte | Idaho | 16023 | 27 | 0 |
534993 | 534993 | 2020-09-15 | Clark | Idaho | 16033 | 27 | 0 |
531759 | 531759 | 2020-09-14 | Clearwater | Idaho | 16035 | 27 | 0 |
528522 | 528522 | 2020-09-13 | Clearwater | Idaho | 16035 | 27 | 0 |
525286 | 525286 | 2020-09-12 | Clearwater | Idaho | 16035 | 27 | 0 |
522050 | 522050 | 2020-09-11 | Clearwater | Idaho | 16035 | 27 | 0 |
518813 | 518813 | 2020-09-10 | Clearwater | Idaho | 16035 | 27 | 0 |
515578 | 515578 | 2020-09-09 | Clearwater | Idaho | 16035 | 27 | 0 |
509106 | 509106 | 2020-09-07 | Butte | Idaho | 16023 | 27 | 0 |
505874 | 505874 | 2020-09-06 | Butte | Idaho | 16023 | 27 | 0 |
502640 | 502640 | 2020-09-05 | Butte | Idaho | 16023 | 27 | 0 |
499406 | 499406 | 2020-09-04 | Butte | Idaho | 16023 | 27 | 0 |
496173 | 496173 | 2020-09-03 | Butte | Idaho | 16023 | 27 | 0 |
438021 | 438021 | 2020-08-16 | Bear Lake | Idaho | 16007 | 27 | 0 |
434795 | 434795 | 2020-08-15 | Bear Lake | Idaho | 16007 | 27 | 0 |
431570 | 431570 | 2020-08-14 | Bear Lake | Idaho | 16007 | 27 | 0 |
428342 | 428342 | 2020-08-13 | Bear Lake | Idaho | 16007 | 27 | 0 |
383298 | 383298 | 2020-07-30 | Idaho | Idaho | 16049 | 27 | 0 |
380081 | 380081 | 2020-07-29 | Idaho | Idaho | 16049 | 27 | 0 |
360801 | 360801 | 2020-07-23 | Boundary | Idaho | 16021 | 27 | 0 |
357621 | 357621 | 2020-07-22 | Power | Idaho | 16077 | 27 | 0 |
259406 | 259406 | 2020-06-21 | Owyhee | Idaho | 16073 | 27 | 0 |
256279 | 256279 | 2020-06-20 | Owyhee | Idaho | 16073 | 27 | 0 |
253136 | 253136 | 2020-06-19 | Bingham | Idaho | 16011 | 27 | 0 |
250021 | 250021 | 2020-06-18 | Bingham | Idaho | 16011 | 27 | 0 |
237602 | 237602 | 2020-06-14 | Payette | Idaho | 16075 | 27 | 2 |
234495 | 234495 | 2020-06-13 | Payette | Idaho | 16075 | 27 | 2 |
231389 | 231389 | 2020-06-12 | Payette | Idaho | 16075 | 27 | 2 |
228286 | 228286 | 2020-06-11 | Payette | Idaho | 16075 | 27 | 2 |
225180 | 225180 | 2020-06-10 | Madison | Idaho | 16065 | 27 | 0 |
222085 | 222085 | 2020-06-09 | Madison | Idaho | 16065 | 27 | 0 |
218990 | 218990 | 2020-06-08 | Madison | Idaho | 16065 | 27 | 0 |
215899 | 215899 | 2020-06-07 | Madison | Idaho | 16065 | 27 | 0 |
212812 | 212812 | 2020-06-06 | Madison | Idaho | 16065 | 27 | 0 |
209727 | 209727 | 2020-06-05 | Madison | Idaho | 16065 | 27 | 0 |
188192 | 188192 | 2020-05-29 | Bannock | Idaho | 16005 | 27 | 0 |
157799 | 157799 | 2020-05-19 | Gooding | Idaho | 16047 | 27 | 0 |
104419 | 104419 | 2020-05-01 | Lincoln | Idaho | 16063 | 27 | 0 |
101564 | 101564 | 2020-04-30 | Lincoln | Idaho | 16063 | 27 | 0 |
98713 | 98713 | 2020-04-29 | Lincoln | Idaho | 16063 | 27 | 0 |
95853 | 95853 | 2020-04-28 | Bonneville | Idaho | 16019 | 27 | 0 |
59711 | 59711 | 2020-04-15 | Nez Perce | Idaho | 16069 | 27 | 10 |
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);