ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Gooding" and state = "Idaho" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
24358 | 24358 | 2020-04-01 | Gooding | Idaho | 16047 | 1 | 0 |
26590 | 26590 | 2020-04-02 | Gooding | Idaho | 16047 | 1 | 0 |
28897 | 28897 | 2020-04-03 | Gooding | Idaho | 16047 | 1 | 0 |
31259 | 31259 | 2020-04-04 | Gooding | Idaho | 16047 | 1 | 0 |
33666 | 33666 | 2020-04-05 | Gooding | Idaho | 16047 | 1 | 0 |
36117 | 36117 | 2020-04-06 | Gooding | Idaho | 16047 | 3 | 0 |
38610 | 38610 | 2020-04-07 | Gooding | Idaho | 16047 | 3 | 0 |
41154 | 41154 | 2020-04-08 | Gooding | Idaho | 16047 | 4 | 0 |
43728 | 43728 | 2020-04-09 | Gooding | Idaho | 16047 | 5 | 0 |
46330 | 46330 | 2020-04-10 | Gooding | Idaho | 16047 | 5 | 0 |
48961 | 48961 | 2020-04-11 | Gooding | Idaho | 16047 | 5 | 0 |
51623 | 51623 | 2020-04-12 | Gooding | Idaho | 16047 | 5 | 0 |
54303 | 54303 | 2020-04-13 | Gooding | Idaho | 16047 | 5 | 0 |
56995 | 56995 | 2020-04-14 | Gooding | Idaho | 16047 | 5 | 0 |
59702 | 59702 | 2020-04-15 | Gooding | Idaho | 16047 | 7 | 0 |
62422 | 62422 | 2020-04-16 | Gooding | Idaho | 16047 | 7 | 0 |
65154 | 65154 | 2020-04-17 | Gooding | Idaho | 16047 | 7 | 0 |
67902 | 67902 | 2020-04-18 | Gooding | Idaho | 16047 | 8 | 0 |
70664 | 70664 | 2020-04-19 | Gooding | Idaho | 16047 | 8 | 0 |
73433 | 73433 | 2020-04-20 | Gooding | Idaho | 16047 | 8 | 0 |
76209 | 76209 | 2020-04-21 | Gooding | Idaho | 16047 | 8 | 0 |
78993 | 78993 | 2020-04-22 | Gooding | Idaho | 16047 | 8 | 0 |
81786 | 81786 | 2020-04-23 | Gooding | Idaho | 16047 | 9 | 0 |
84586 | 84586 | 2020-04-24 | Gooding | Idaho | 16047 | 9 | 0 |
87395 | 87395 | 2020-04-25 | Gooding | Idaho | 16047 | 9 | 0 |
90211 | 90211 | 2020-04-26 | Gooding | Idaho | 16047 | 9 | 0 |
93030 | 93030 | 2020-04-27 | Gooding | Idaho | 16047 | 9 | 0 |
95862 | 95862 | 2020-04-28 | Gooding | Idaho | 16047 | 9 | 0 |
98706 | 98706 | 2020-04-29 | Gooding | Idaho | 16047 | 11 | 0 |
104412 | 104412 | 2020-05-01 | Gooding | Idaho | 16047 | 11 | 0 |
110147 | 110147 | 2020-05-03 | Gooding | Idaho | 16047 | 11 | 0 |
101557 | 101557 | 2020-04-30 | Gooding | Idaho | 16047 | 12 | 0 |
107277 | 107277 | 2020-05-02 | Gooding | Idaho | 16047 | 12 | 0 |
113022 | 113022 | 2020-05-04 | Gooding | Idaho | 16047 | 13 | 0 |
115905 | 115905 | 2020-05-05 | Gooding | Idaho | 16047 | 13 | 0 |
118865 | 118865 | 2020-05-06 | Gooding | Idaho | 16047 | 14 | 0 |
121835 | 121835 | 2020-05-07 | Gooding | Idaho | 16047 | 16 | 0 |
124814 | 124814 | 2020-05-08 | Gooding | Idaho | 16047 | 16 | 0 |
127801 | 127801 | 2020-05-09 | Gooding | Idaho | 16047 | 17 | 0 |
130792 | 130792 | 2020-05-10 | Gooding | Idaho | 16047 | 17 | 0 |
133783 | 133783 | 2020-05-11 | Gooding | Idaho | 16047 | 18 | 0 |
136772 | 136772 | 2020-05-12 | Gooding | Idaho | 16047 | 20 | 0 |
139763 | 139763 | 2020-05-13 | Gooding | Idaho | 16047 | 21 | 0 |
142759 | 142759 | 2020-05-14 | Gooding | Idaho | 16047 | 22 | 0 |
145759 | 145759 | 2020-05-15 | Gooding | Idaho | 16047 | 24 | 0 |
148762 | 148762 | 2020-05-16 | Gooding | Idaho | 16047 | 25 | 0 |
151771 | 151771 | 2020-05-17 | Gooding | Idaho | 16047 | 25 | 0 |
154783 | 154783 | 2020-05-18 | Gooding | Idaho | 16047 | 26 | 0 |
157799 | 157799 | 2020-05-19 | Gooding | Idaho | 16047 | 27 | 0 |
160825 | 160825 | 2020-05-20 | Gooding | Idaho | 16047 | 29 | 0 |
163853 | 163853 | 2020-05-21 | Gooding | Idaho | 16047 | 32 | 0 |
166886 | 166886 | 2020-05-22 | Gooding | Idaho | 16047 | 35 | 0 |
169923 | 169923 | 2020-05-23 | Gooding | Idaho | 16047 | 39 | 0 |
172964 | 172964 | 2020-05-24 | Gooding | Idaho | 16047 | 39 | 0 |
176008 | 176008 | 2020-05-25 | Gooding | Idaho | 16047 | 39 | 0 |
179052 | 179052 | 2020-05-26 | Gooding | Idaho | 16047 | 40 | 0 |
182096 | 182096 | 2020-05-27 | Gooding | Idaho | 16047 | 44 | 0 |
185150 | 185150 | 2020-05-28 | Gooding | Idaho | 16047 | 46 | 0 |
188207 | 188207 | 2020-05-29 | Gooding | Idaho | 16047 | 47 | 0 |
191272 | 191272 | 2020-05-30 | Gooding | Idaho | 16047 | 47 | 0 |
194339 | 194339 | 2020-05-31 | Gooding | Idaho | 16047 | 48 | 0 |
197409 | 197409 | 2020-06-01 | Gooding | Idaho | 16047 | 49 | 0 |
200482 | 200482 | 2020-06-02 | Gooding | Idaho | 16047 | 49 | 0 |
203558 | 203558 | 2020-06-03 | Gooding | Idaho | 16047 | 50 | 0 |
206638 | 206638 | 2020-06-04 | Gooding | Idaho | 16047 | 53 | 0 |
209719 | 209719 | 2020-06-05 | Gooding | Idaho | 16047 | 55 | 0 |
212804 | 212804 | 2020-06-06 | Gooding | Idaho | 16047 | 56 | 0 |
215891 | 215891 | 2020-06-07 | Gooding | Idaho | 16047 | 56 | 0 |
218982 | 218982 | 2020-06-08 | Gooding | Idaho | 16047 | 57 | 0 |
222077 | 222077 | 2020-06-09 | Gooding | Idaho | 16047 | 57 | 0 |
225172 | 225172 | 2020-06-10 | Gooding | Idaho | 16047 | 57 | 0 |
228274 | 228274 | 2020-06-11 | Gooding | Idaho | 16047 | 58 | 0 |
231377 | 231377 | 2020-06-12 | Gooding | Idaho | 16047 | 58 | 0 |
234483 | 234483 | 2020-06-13 | Gooding | Idaho | 16047 | 59 | 0 |
237590 | 237590 | 2020-06-14 | Gooding | Idaho | 16047 | 59 | 0 |
240698 | 240698 | 2020-06-15 | Gooding | Idaho | 16047 | 59 | 1 |
243809 | 243809 | 2020-06-16 | Gooding | Idaho | 16047 | 60 | 1 |
246922 | 246922 | 2020-06-17 | Gooding | Idaho | 16047 | 60 | 1 |
250034 | 250034 | 2020-06-18 | Gooding | Idaho | 16047 | 60 | 1 |
253149 | 253149 | 2020-06-19 | Gooding | Idaho | 16047 | 60 | 1 |
256268 | 256268 | 2020-06-20 | Gooding | Idaho | 16047 | 61 | 1 |
259395 | 259395 | 2020-06-21 | Gooding | Idaho | 16047 | 61 | 1 |
262522 | 262522 | 2020-06-22 | Gooding | Idaho | 16047 | 61 | 1 |
265650 | 265650 | 2020-06-23 | Gooding | Idaho | 16047 | 61 | 1 |
268780 | 268780 | 2020-06-24 | Gooding | Idaho | 16047 | 61 | 1 |
271917 | 271917 | 2020-06-25 | Gooding | Idaho | 16047 | 62 | 1 |
275059 | 275059 | 2020-06-26 | Gooding | Idaho | 16047 | 62 | 1 |
278207 | 278207 | 2020-06-27 | Gooding | Idaho | 16047 | 62 | 1 |
281354 | 281354 | 2020-06-28 | Gooding | Idaho | 16047 | 62 | 1 |
284500 | 284500 | 2020-06-29 | Gooding | Idaho | 16047 | 64 | 0 |
287648 | 287648 | 2020-06-30 | Gooding | Idaho | 16047 | 65 | 0 |
290798 | 290798 | 2020-07-01 | Gooding | Idaho | 16047 | 65 | 0 |
293952 | 293952 | 2020-07-02 | Gooding | Idaho | 16047 | 65 | 0 |
297108 | 297108 | 2020-07-03 | Gooding | Idaho | 16047 | 66 | 0 |
300270 | 300270 | 2020-07-04 | Gooding | Idaho | 16047 | 66 | 0 |
303434 | 303434 | 2020-07-05 | Gooding | Idaho | 16047 | 66 | 0 |
306598 | 306598 | 2020-07-06 | Gooding | Idaho | 16047 | 66 | 0 |
309766 | 309766 | 2020-07-07 | Gooding | Idaho | 16047 | 68 | 0 |
312936 | 312936 | 2020-07-08 | Gooding | Idaho | 16047 | 71 | 0 |
316111 | 316111 | 2020-07-09 | Gooding | Idaho | 16047 | 79 | 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);