ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Adams" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293932 | 293932 | 2020-07-02 | Adams | Idaho | 16003 | 11 | 0 |
290778 | 290778 | 2020-07-01 | Adams | Idaho | 16003 | 11 | 0 |
287628 | 287628 | 2020-06-30 | Adams | Idaho | 16003 | 11 | 0 |
284481 | 284481 | 2020-06-29 | Adams | Idaho | 16003 | 10 | 0 |
281335 | 281335 | 2020-06-28 | Adams | Idaho | 16003 | 10 | 0 |
278188 | 278188 | 2020-06-27 | Adams | Idaho | 16003 | 10 | 0 |
275040 | 275040 | 2020-06-26 | Adams | Idaho | 16003 | 10 | 0 |
271900 | 271900 | 2020-06-25 | Adams | Idaho | 16003 | 10 | 0 |
268764 | 268764 | 2020-06-24 | Adams | Idaho | 16003 | 10 | 0 |
265634 | 265634 | 2020-06-23 | Adams | Idaho | 16003 | 10 | 0 |
262506 | 262506 | 2020-06-22 | Adams | Idaho | 16003 | 10 | 0 |
259379 | 259379 | 2020-06-21 | Adams | Idaho | 16003 | 9 | 0 |
256252 | 256252 | 2020-06-20 | Adams | Idaho | 16003 | 9 | 0 |
253133 | 253133 | 2020-06-19 | Adams | Idaho | 16003 | 9 | 0 |
250018 | 250018 | 2020-06-18 | Adams | Idaho | 16003 | 9 | 0 |
246906 | 246906 | 2020-06-17 | Adams | Idaho | 16003 | 9 | 0 |
243793 | 243793 | 2020-06-16 | Adams | Idaho | 16003 | 8 | 0 |
240682 | 240682 | 2020-06-15 | Adams | Idaho | 16003 | 6 | 0 |
237574 | 237574 | 2020-06-14 | Adams | Idaho | 16003 | 4 | 0 |
234467 | 234467 | 2020-06-13 | Adams | Idaho | 16003 | 4 | 0 |
231361 | 231361 | 2020-06-12 | Adams | Idaho | 16003 | 4 | 0 |
228258 | 228258 | 2020-06-11 | Adams | Idaho | 16003 | 3 | 0 |
225156 | 225156 | 2020-06-10 | Adams | Idaho | 16003 | 3 | 0 |
222061 | 222061 | 2020-06-09 | Adams | Idaho | 16003 | 3 | 0 |
218966 | 218966 | 2020-06-08 | Adams | Idaho | 16003 | 3 | 0 |
215875 | 215875 | 2020-06-07 | Adams | Idaho | 16003 | 3 | 0 |
212788 | 212788 | 2020-06-06 | Adams | Idaho | 16003 | 3 | 0 |
209703 | 209703 | 2020-06-05 | Adams | Idaho | 16003 | 3 | 0 |
206622 | 206622 | 2020-06-04 | Adams | Idaho | 16003 | 3 | 0 |
203542 | 203542 | 2020-06-03 | Adams | Idaho | 16003 | 3 | 0 |
200466 | 200466 | 2020-06-02 | Adams | Idaho | 16003 | 3 | 0 |
197393 | 197393 | 2020-06-01 | Adams | Idaho | 16003 | 3 | 0 |
194323 | 194323 | 2020-05-31 | Adams | Idaho | 16003 | 3 | 0 |
191256 | 191256 | 2020-05-30 | Adams | Idaho | 16003 | 3 | 0 |
188191 | 188191 | 2020-05-29 | Adams | Idaho | 16003 | 3 | 0 |
185135 | 185135 | 2020-05-28 | Adams | Idaho | 16003 | 3 | 0 |
182081 | 182081 | 2020-05-27 | Adams | Idaho | 16003 | 3 | 0 |
179037 | 179037 | 2020-05-26 | Adams | Idaho | 16003 | 3 | 0 |
175993 | 175993 | 2020-05-25 | Adams | Idaho | 16003 | 3 | 0 |
172950 | 172950 | 2020-05-24 | Adams | Idaho | 16003 | 3 | 0 |
169909 | 169909 | 2020-05-23 | Adams | Idaho | 16003 | 3 | 0 |
166872 | 166872 | 2020-05-22 | Adams | Idaho | 16003 | 3 | 0 |
163839 | 163839 | 2020-05-21 | Adams | Idaho | 16003 | 3 | 0 |
160811 | 160811 | 2020-05-20 | Adams | Idaho | 16003 | 3 | 0 |
157785 | 157785 | 2020-05-19 | Adams | Idaho | 16003 | 3 | 0 |
154769 | 154769 | 2020-05-18 | Adams | Idaho | 16003 | 3 | 0 |
151757 | 151757 | 2020-05-17 | Adams | Idaho | 16003 | 3 | 0 |
148748 | 148748 | 2020-05-16 | Adams | Idaho | 16003 | 3 | 0 |
145745 | 145745 | 2020-05-15 | Adams | Idaho | 16003 | 3 | 0 |
142745 | 142745 | 2020-05-14 | Adams | Idaho | 16003 | 3 | 0 |
139749 | 139749 | 2020-05-13 | Adams | Idaho | 16003 | 3 | 0 |
136758 | 136758 | 2020-05-12 | Adams | Idaho | 16003 | 3 | 0 |
133769 | 133769 | 2020-05-11 | Adams | Idaho | 16003 | 3 | 0 |
130778 | 130778 | 2020-05-10 | Adams | Idaho | 16003 | 3 | 0 |
127787 | 127787 | 2020-05-09 | Adams | Idaho | 16003 | 3 | 0 |
124800 | 124800 | 2020-05-08 | Adams | Idaho | 16003 | 3 | 0 |
121821 | 121821 | 2020-05-07 | Adams | Idaho | 16003 | 3 | 0 |
118851 | 118851 | 2020-05-06 | Adams | Idaho | 16003 | 3 | 0 |
115891 | 115891 | 2020-05-05 | Adams | Idaho | 16003 | 3 | 0 |
113008 | 113008 | 2020-05-04 | Adams | Idaho | 16003 | 3 | 0 |
110133 | 110133 | 2020-05-03 | Adams | Idaho | 16003 | 3 | 0 |
107263 | 107263 | 2020-05-02 | Adams | Idaho | 16003 | 3 | 0 |
104398 | 104398 | 2020-05-01 | Adams | Idaho | 16003 | 3 | 0 |
101543 | 101543 | 2020-04-30 | Adams | Idaho | 16003 | 3 | 0 |
98692 | 98692 | 2020-04-29 | Adams | Idaho | 16003 | 3 | 0 |
95848 | 95848 | 2020-04-28 | Adams | Idaho | 16003 | 3 | 0 |
93016 | 93016 | 2020-04-27 | Adams | Idaho | 16003 | 3 | 0 |
90197 | 90197 | 2020-04-26 | Adams | Idaho | 16003 | 3 | 0 |
87381 | 87381 | 2020-04-25 | Adams | Idaho | 16003 | 3 | 0 |
84572 | 84572 | 2020-04-24 | Adams | Idaho | 16003 | 3 | 0 |
81772 | 81772 | 2020-04-23 | Adams | Idaho | 16003 | 3 | 0 |
78979 | 78979 | 2020-04-22 | Adams | Idaho | 16003 | 3 | 0 |
76195 | 76195 | 2020-04-21 | Adams | Idaho | 16003 | 3 | 0 |
73419 | 73419 | 2020-04-20 | Adams | Idaho | 16003 | 3 | 0 |
70650 | 70650 | 2020-04-19 | Adams | Idaho | 16003 | 1 | 0 |
67888 | 67888 | 2020-04-18 | Adams | Idaho | 16003 | 1 | 0 |
65140 | 65140 | 2020-04-17 | Adams | Idaho | 16003 | 1 | 0 |
62408 | 62408 | 2020-04-16 | Adams | Idaho | 16003 | 1 | 0 |
59688 | 59688 | 2020-04-15 | Adams | Idaho | 16003 | 1 | 0 |
56981 | 56981 | 2020-04-14 | Adams | Idaho | 16003 | 1 | 0 |
54289 | 54289 | 2020-04-13 | Adams | Idaho | 16003 | 1 | 0 |
51609 | 51609 | 2020-04-12 | Adams | Idaho | 16003 | 1 | 0 |
48947 | 48947 | 2020-04-11 | Adams | Idaho | 16003 | 1 | 0 |
46316 | 46316 | 2020-04-10 | Adams | Idaho | 16003 | 1 | 0 |
43714 | 43714 | 2020-04-09 | Adams | Idaho | 16003 | 1 | 0 |
41140 | 41140 | 2020-04-08 | Adams | Idaho | 16003 | 1 | 0 |
38596 | 38596 | 2020-04-07 | Adams | Idaho | 16003 | 1 | 0 |
36103 | 36103 | 2020-04-06 | Adams | Idaho | 16003 | 1 | 0 |
33652 | 33652 | 2020-04-05 | Adams | Idaho | 16003 | 1 | 0 |
31245 | 31245 | 2020-04-04 | Adams | Idaho | 16003 | 1 | 0 |
28884 | 28884 | 2020-04-03 | Adams | Idaho | 16003 | 1 | 0 |
26577 | 26577 | 2020-04-02 | Adams | Idaho | 16003 | 1 | 0 |
24345 | 24345 | 2020-04-01 | Adams | Idaho | 16003 | 1 | 0 |
22179 | 22179 | 2020-03-31 | Adams | Idaho | 16003 | 1 | 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);