ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Hancock" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386770 | 386770 | 2020-07-31 | Hancock | Iowa | 19081 | 114 | 2 |
383552 | 383552 | 2020-07-30 | Hancock | Iowa | 19081 | 108 | 2 |
380335 | 380335 | 2020-07-29 | Hancock | Iowa | 19081 | 107 | 2 |
377118 | 377118 | 2020-07-28 | Hancock | Iowa | 19081 | 106 | 2 |
373903 | 373903 | 2020-07-27 | Hancock | Iowa | 19081 | 105 | 2 |
370691 | 370691 | 2020-07-26 | Hancock | Iowa | 19081 | 105 | 2 |
367481 | 367481 | 2020-07-25 | Hancock | Iowa | 19081 | 102 | 2 |
364274 | 364274 | 2020-07-24 | Hancock | Iowa | 19081 | 98 | 2 |
361067 | 361067 | 2020-07-23 | Hancock | Iowa | 19081 | 95 | 2 |
357862 | 357862 | 2020-07-22 | Hancock | Iowa | 19081 | 93 | 2 |
354660 | 354660 | 2020-07-21 | Hancock | Iowa | 19081 | 85 | 2 |
351458 | 351458 | 2020-07-20 | Hancock | Iowa | 19081 | 81 | 2 |
348258 | 348258 | 2020-07-19 | Hancock | Iowa | 19081 | 76 | 2 |
345057 | 345057 | 2020-07-18 | Hancock | Iowa | 19081 | 74 | 2 |
341857 | 341857 | 2020-07-17 | Hancock | Iowa | 19081 | 73 | 2 |
338661 | 338661 | 2020-07-16 | Hancock | Iowa | 19081 | 73 | 2 |
335465 | 335465 | 2020-07-15 | Hancock | Iowa | 19081 | 67 | 2 |
332272 | 332272 | 2020-07-14 | Hancock | Iowa | 19081 | 64 | 1 |
329085 | 329085 | 2020-07-13 | Hancock | Iowa | 19081 | 62 | 1 |
325899 | 325899 | 2020-07-12 | Hancock | Iowa | 19081 | 61 | 1 |
322718 | 322718 | 2020-07-11 | Hancock | Iowa | 19081 | 60 | 1 |
319539 | 319539 | 2020-07-10 | Hancock | Iowa | 19081 | 58 | 1 |
316366 | 316366 | 2020-07-09 | Hancock | Iowa | 19081 | 57 | 1 |
313192 | 313192 | 2020-07-08 | Hancock | Iowa | 19081 | 54 | 1 |
310022 | 310022 | 2020-07-07 | Hancock | Iowa | 19081 | 55 | 1 |
306854 | 306854 | 2020-07-06 | Hancock | Iowa | 19081 | 54 | 1 |
303689 | 303689 | 2020-07-05 | Hancock | Iowa | 19081 | 54 | 0 |
300525 | 300525 | 2020-07-04 | Hancock | Iowa | 19081 | 52 | 0 |
297363 | 297363 | 2020-07-03 | Hancock | Iowa | 19081 | 49 | 0 |
294205 | 294205 | 2020-07-02 | Hancock | Iowa | 19081 | 49 | 0 |
291051 | 291051 | 2020-07-01 | Hancock | Iowa | 19081 | 47 | 0 |
287901 | 287901 | 2020-06-30 | Hancock | Iowa | 19081 | 47 | 0 |
284752 | 284752 | 2020-06-29 | Hancock | Iowa | 19081 | 46 | 0 |
281607 | 281607 | 2020-06-28 | Hancock | Iowa | 19081 | 45 | 0 |
278459 | 278459 | 2020-06-27 | Hancock | Iowa | 19081 | 45 | 0 |
275311 | 275311 | 2020-06-26 | Hancock | Iowa | 19081 | 43 | 0 |
272169 | 272169 | 2020-06-25 | Hancock | Iowa | 19081 | 41 | 0 |
269032 | 269032 | 2020-06-24 | Hancock | Iowa | 19081 | 40 | 0 |
265902 | 265902 | 2020-06-23 | Hancock | Iowa | 19081 | 38 | 0 |
262774 | 262774 | 2020-06-22 | Hancock | Iowa | 19081 | 38 | 0 |
259647 | 259647 | 2020-06-21 | Hancock | Iowa | 19081 | 38 | 0 |
256521 | 256521 | 2020-06-20 | Hancock | Iowa | 19081 | 36 | 0 |
253401 | 253401 | 2020-06-19 | Hancock | Iowa | 19081 | 35 | 0 |
250286 | 250286 | 2020-06-18 | Hancock | Iowa | 19081 | 34 | 0 |
247174 | 247174 | 2020-06-17 | Hancock | Iowa | 19081 | 30 | 0 |
244061 | 244061 | 2020-06-16 | Hancock | Iowa | 19081 | 31 | 0 |
240950 | 240950 | 2020-06-15 | Hancock | Iowa | 19081 | 33 | 0 |
237842 | 237842 | 2020-06-14 | Hancock | Iowa | 19081 | 29 | 0 |
234735 | 234735 | 2020-06-13 | Hancock | Iowa | 19081 | 27 | 0 |
231629 | 231629 | 2020-06-12 | Hancock | Iowa | 19081 | 26 | 0 |
228526 | 228526 | 2020-06-11 | Hancock | Iowa | 19081 | 25 | 0 |
225424 | 225424 | 2020-06-10 | Hancock | Iowa | 19081 | 25 | 0 |
222329 | 222329 | 2020-06-09 | Hancock | Iowa | 19081 | 22 | 0 |
219234 | 219234 | 2020-06-08 | Hancock | Iowa | 19081 | 22 | 0 |
216142 | 216142 | 2020-06-07 | Hancock | Iowa | 19081 | 22 | 0 |
213055 | 213055 | 2020-06-06 | Hancock | Iowa | 19081 | 19 | 0 |
209970 | 209970 | 2020-06-05 | Hancock | Iowa | 19081 | 18 | 0 |
206889 | 206889 | 2020-06-04 | Hancock | Iowa | 19081 | 16 | 0 |
203809 | 203809 | 2020-06-03 | Hancock | Iowa | 19081 | 16 | 0 |
200733 | 200733 | 2020-06-02 | Hancock | Iowa | 19081 | 16 | 0 |
197660 | 197660 | 2020-06-01 | Hancock | Iowa | 19081 | 16 | 0 |
194590 | 194590 | 2020-05-31 | Hancock | Iowa | 19081 | 16 | 0 |
191523 | 191523 | 2020-05-30 | Hancock | Iowa | 19081 | 16 | 0 |
188458 | 188458 | 2020-05-29 | Hancock | Iowa | 19081 | 16 | 0 |
185400 | 185400 | 2020-05-28 | Hancock | Iowa | 19081 | 16 | 0 |
182346 | 182346 | 2020-05-27 | Hancock | Iowa | 19081 | 15 | 0 |
179301 | 179301 | 2020-05-26 | Hancock | Iowa | 19081 | 14 | 0 |
176257 | 176257 | 2020-05-25 | Hancock | Iowa | 19081 | 13 | 0 |
173213 | 173213 | 2020-05-24 | Hancock | Iowa | 19081 | 12 | 0 |
170172 | 170172 | 2020-05-23 | Hancock | Iowa | 19081 | 11 | 0 |
167135 | 167135 | 2020-05-22 | Hancock | Iowa | 19081 | 11 | 0 |
164102 | 164102 | 2020-05-21 | Hancock | Iowa | 19081 | 10 | 0 |
161074 | 161074 | 2020-05-20 | Hancock | Iowa | 19081 | 9 | 0 |
158048 | 158048 | 2020-05-19 | Hancock | Iowa | 19081 | 5 | 0 |
155032 | 155032 | 2020-05-18 | Hancock | Iowa | 19081 | 5 | 0 |
152020 | 152020 | 2020-05-17 | Hancock | Iowa | 19081 | 5 | 0 |
149010 | 149010 | 2020-05-16 | Hancock | Iowa | 19081 | 3 | 0 |
146006 | 146006 | 2020-05-15 | Hancock | Iowa | 19081 | 3 | 0 |
143006 | 143006 | 2020-05-14 | Hancock | Iowa | 19081 | 3 | 0 |
140010 | 140010 | 2020-05-13 | Hancock | Iowa | 19081 | 3 | 0 |
137017 | 137017 | 2020-05-12 | Hancock | Iowa | 19081 | 3 | 0 |
134028 | 134028 | 2020-05-11 | Hancock | Iowa | 19081 | 3 | 0 |
131038 | 131038 | 2020-05-10 | Hancock | Iowa | 19081 | 3 | 0 |
128047 | 128047 | 2020-05-09 | Hancock | Iowa | 19081 | 3 | 0 |
125060 | 125060 | 2020-05-08 | Hancock | Iowa | 19081 | 3 | 0 |
122079 | 122079 | 2020-05-07 | Hancock | Iowa | 19081 | 3 | 0 |
119109 | 119109 | 2020-05-06 | Hancock | Iowa | 19081 | 3 | 0 |
116149 | 116149 | 2020-05-05 | Hancock | Iowa | 19081 | 3 | 0 |
113266 | 113266 | 2020-05-04 | Hancock | Iowa | 19081 | 3 | 0 |
110391 | 110391 | 2020-05-03 | Hancock | Iowa | 19081 | 3 | 0 |
107521 | 107521 | 2020-05-02 | Hancock | Iowa | 19081 | 3 | 0 |
104656 | 104656 | 2020-05-01 | Hancock | Iowa | 19081 | 3 | 0 |
101798 | 101798 | 2020-04-30 | Hancock | Iowa | 19081 | 3 | 0 |
98947 | 98947 | 2020-04-29 | Hancock | Iowa | 19081 | 3 | 0 |
96102 | 96102 | 2020-04-28 | Hancock | Iowa | 19081 | 3 | 0 |
93270 | 93270 | 2020-04-27 | Hancock | Iowa | 19081 | 3 | 0 |
90451 | 90451 | 2020-04-26 | Hancock | Iowa | 19081 | 3 | 0 |
87635 | 87635 | 2020-04-25 | Hancock | Iowa | 19081 | 3 | 0 |
84825 | 84825 | 2020-04-24 | Hancock | Iowa | 19081 | 3 | 0 |
82025 | 82025 | 2020-04-23 | Hancock | Iowa | 19081 | 3 | 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);