ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
753 rows where fips = 19035 and state = "Iowa" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
76430 | 76430 | 2020-04-21 | Cherokee | Iowa | 19035 | 1 | 0 |
79214 | 79214 | 2020-04-22 | Cherokee | Iowa | 19035 | 1 | 0 |
82007 | 82007 | 2020-04-23 | Cherokee | Iowa | 19035 | 1 | 0 |
84807 | 84807 | 2020-04-24 | Cherokee | Iowa | 19035 | 2 | 0 |
87617 | 87617 | 2020-04-25 | Cherokee | Iowa | 19035 | 2 | 0 |
90433 | 90433 | 2020-04-26 | Cherokee | Iowa | 19035 | 2 | 0 |
93252 | 93252 | 2020-04-27 | Cherokee | Iowa | 19035 | 2 | 0 |
96084 | 96084 | 2020-04-28 | Cherokee | Iowa | 19035 | 2 | 0 |
98928 | 98928 | 2020-04-29 | Cherokee | Iowa | 19035 | 2 | 0 |
101779 | 101779 | 2020-04-30 | Cherokee | Iowa | 19035 | 2 | 0 |
104636 | 104636 | 2020-05-01 | Cherokee | Iowa | 19035 | 2 | 0 |
107501 | 107501 | 2020-05-02 | Cherokee | Iowa | 19035 | 3 | 0 |
110371 | 110371 | 2020-05-03 | Cherokee | Iowa | 19035 | 4 | 0 |
113246 | 113246 | 2020-05-04 | Cherokee | Iowa | 19035 | 4 | 0 |
116129 | 116129 | 2020-05-05 | Cherokee | Iowa | 19035 | 4 | 0 |
119089 | 119089 | 2020-05-06 | Cherokee | Iowa | 19035 | 4 | 0 |
122059 | 122059 | 2020-05-07 | Cherokee | Iowa | 19035 | 4 | 0 |
125039 | 125039 | 2020-05-08 | Cherokee | Iowa | 19035 | 4 | 0 |
128026 | 128026 | 2020-05-09 | Cherokee | Iowa | 19035 | 4 | 0 |
131017 | 131017 | 2020-05-10 | Cherokee | Iowa | 19035 | 4 | 0 |
134007 | 134007 | 2020-05-11 | Cherokee | Iowa | 19035 | 6 | 0 |
136996 | 136996 | 2020-05-12 | Cherokee | Iowa | 19035 | 6 | 0 |
139988 | 139988 | 2020-05-13 | Cherokee | Iowa | 19035 | 6 | 0 |
142984 | 142984 | 2020-05-14 | Cherokee | Iowa | 19035 | 6 | 0 |
145984 | 145984 | 2020-05-15 | Cherokee | Iowa | 19035 | 8 | 0 |
148988 | 148988 | 2020-05-16 | Cherokee | Iowa | 19035 | 9 | 0 |
151998 | 151998 | 2020-05-17 | Cherokee | Iowa | 19035 | 9 | 0 |
155010 | 155010 | 2020-05-18 | Cherokee | Iowa | 19035 | 9 | 0 |
158026 | 158026 | 2020-05-19 | Cherokee | Iowa | 19035 | 9 | 0 |
161052 | 161052 | 2020-05-20 | Cherokee | Iowa | 19035 | 10 | 0 |
164080 | 164080 | 2020-05-21 | Cherokee | Iowa | 19035 | 10 | 0 |
167113 | 167113 | 2020-05-22 | Cherokee | Iowa | 19035 | 10 | 0 |
170150 | 170150 | 2020-05-23 | Cherokee | Iowa | 19035 | 10 | 0 |
173191 | 173191 | 2020-05-24 | Cherokee | Iowa | 19035 | 16 | 0 |
176235 | 176235 | 2020-05-25 | Cherokee | Iowa | 19035 | 18 | 0 |
179279 | 179279 | 2020-05-26 | Cherokee | Iowa | 19035 | 21 | 0 |
182323 | 182323 | 2020-05-27 | Cherokee | Iowa | 19035 | 23 | 0 |
185377 | 185377 | 2020-05-28 | Cherokee | Iowa | 19035 | 24 | 0 |
188435 | 188435 | 2020-05-29 | Cherokee | Iowa | 19035 | 27 | 0 |
191500 | 191500 | 2020-05-30 | Cherokee | Iowa | 19035 | 28 | 0 |
194567 | 194567 | 2020-05-31 | Cherokee | Iowa | 19035 | 31 | 0 |
197637 | 197637 | 2020-06-01 | Cherokee | Iowa | 19035 | 31 | 0 |
200710 | 200710 | 2020-06-02 | Cherokee | Iowa | 19035 | 32 | 0 |
203786 | 203786 | 2020-06-03 | Cherokee | Iowa | 19035 | 36 | 0 |
206866 | 206866 | 2020-06-04 | Cherokee | Iowa | 19035 | 41 | 0 |
209947 | 209947 | 2020-06-05 | Cherokee | Iowa | 19035 | 41 | 0 |
213032 | 213032 | 2020-06-06 | Cherokee | Iowa | 19035 | 46 | 0 |
216119 | 216119 | 2020-06-07 | Cherokee | Iowa | 19035 | 46 | 0 |
219211 | 219211 | 2020-06-08 | Cherokee | Iowa | 19035 | 46 | 0 |
222306 | 222306 | 2020-06-09 | Cherokee | Iowa | 19035 | 49 | 0 |
225401 | 225401 | 2020-06-10 | Cherokee | Iowa | 19035 | 52 | 0 |
228503 | 228503 | 2020-06-11 | Cherokee | Iowa | 19035 | 55 | 0 |
231606 | 231606 | 2020-06-12 | Cherokee | Iowa | 19035 | 56 | 0 |
234712 | 234712 | 2020-06-13 | Cherokee | Iowa | 19035 | 58 | 0 |
237819 | 237819 | 2020-06-14 | Cherokee | Iowa | 19035 | 59 | 0 |
240927 | 240927 | 2020-06-15 | Cherokee | Iowa | 19035 | 59 | 0 |
244038 | 244038 | 2020-06-16 | Cherokee | Iowa | 19035 | 60 | 0 |
247151 | 247151 | 2020-06-17 | Cherokee | Iowa | 19035 | 62 | 0 |
250263 | 250263 | 2020-06-18 | Cherokee | Iowa | 19035 | 65 | 0 |
253378 | 253378 | 2020-06-19 | Cherokee | Iowa | 19035 | 65 | 0 |
256498 | 256498 | 2020-06-20 | Cherokee | Iowa | 19035 | 65 | 0 |
259624 | 259624 | 2020-06-21 | Cherokee | Iowa | 19035 | 66 | 0 |
262751 | 262751 | 2020-06-22 | Cherokee | Iowa | 19035 | 67 | 0 |
265879 | 265879 | 2020-06-23 | Cherokee | Iowa | 19035 | 68 | 0 |
269009 | 269009 | 2020-06-24 | Cherokee | Iowa | 19035 | 69 | 0 |
272146 | 272146 | 2020-06-25 | Cherokee | Iowa | 19035 | 68 | 0 |
275288 | 275288 | 2020-06-26 | Cherokee | Iowa | 19035 | 69 | 0 |
278436 | 278436 | 2020-06-27 | Cherokee | Iowa | 19035 | 69 | 0 |
281584 | 281584 | 2020-06-28 | Cherokee | Iowa | 19035 | 71 | 0 |
284729 | 284729 | 2020-06-29 | Cherokee | Iowa | 19035 | 71 | 0 |
287878 | 287878 | 2020-06-30 | Cherokee | Iowa | 19035 | 72 | 0 |
291028 | 291028 | 2020-07-01 | Cherokee | Iowa | 19035 | 74 | 0 |
294182 | 294182 | 2020-07-02 | Cherokee | Iowa | 19035 | 75 | 1 |
297340 | 297340 | 2020-07-03 | Cherokee | Iowa | 19035 | 75 | 1 |
300502 | 300502 | 2020-07-04 | Cherokee | Iowa | 19035 | 75 | 1 |
303666 | 303666 | 2020-07-05 | Cherokee | Iowa | 19035 | 75 | 1 |
306831 | 306831 | 2020-07-06 | Cherokee | Iowa | 19035 | 75 | 1 |
309999 | 309999 | 2020-07-07 | Cherokee | Iowa | 19035 | 76 | 1 |
313169 | 313169 | 2020-07-08 | Cherokee | Iowa | 19035 | 79 | 1 |
316343 | 316343 | 2020-07-09 | Cherokee | Iowa | 19035 | 81 | 1 |
319516 | 319516 | 2020-07-10 | Cherokee | Iowa | 19035 | 82 | 1 |
322695 | 322695 | 2020-07-11 | Cherokee | Iowa | 19035 | 83 | 1 |
325876 | 325876 | 2020-07-12 | Cherokee | Iowa | 19035 | 85 | 1 |
329062 | 329062 | 2020-07-13 | Cherokee | Iowa | 19035 | 85 | 1 |
332249 | 332249 | 2020-07-14 | Cherokee | Iowa | 19035 | 85 | 1 |
335442 | 335442 | 2020-07-15 | Cherokee | Iowa | 19035 | 87 | 1 |
338638 | 338638 | 2020-07-16 | Cherokee | Iowa | 19035 | 87 | 1 |
341834 | 341834 | 2020-07-17 | Cherokee | Iowa | 19035 | 87 | 1 |
345034 | 345034 | 2020-07-18 | Cherokee | Iowa | 19035 | 87 | 1 |
348235 | 348235 | 2020-07-19 | Cherokee | Iowa | 19035 | 88 | 1 |
351435 | 351435 | 2020-07-20 | Cherokee | Iowa | 19035 | 89 | 1 |
354637 | 354637 | 2020-07-21 | Cherokee | Iowa | 19035 | 89 | 1 |
357839 | 357839 | 2020-07-22 | Cherokee | Iowa | 19035 | 92 | 1 |
361044 | 361044 | 2020-07-23 | Cherokee | Iowa | 19035 | 93 | 1 |
364251 | 364251 | 2020-07-24 | Cherokee | Iowa | 19035 | 94 | 1 |
367458 | 367458 | 2020-07-25 | Cherokee | Iowa | 19035 | 94 | 1 |
370668 | 370668 | 2020-07-26 | Cherokee | Iowa | 19035 | 96 | 1 |
373880 | 373880 | 2020-07-27 | Cherokee | Iowa | 19035 | 96 | 1 |
377095 | 377095 | 2020-07-28 | Cherokee | Iowa | 19035 | 96 | 1 |
380312 | 380312 | 2020-07-29 | Cherokee | Iowa | 19035 | 97 | 1 |
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);