ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
753 rows where fips = 19091 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 |
---|---|---|---|---|---|---|---|
76453 | 76453 | 2020-04-21 | Humboldt | Iowa | 19091 | 1 | 0 |
79237 | 79237 | 2020-04-22 | Humboldt | Iowa | 19091 | 2 | 0 |
82030 | 82030 | 2020-04-23 | Humboldt | Iowa | 19091 | 2 | 0 |
84830 | 84830 | 2020-04-24 | Humboldt | Iowa | 19091 | 4 | 0 |
87640 | 87640 | 2020-04-25 | Humboldt | Iowa | 19091 | 4 | 0 |
90456 | 90456 | 2020-04-26 | Humboldt | Iowa | 19091 | 4 | 0 |
93275 | 93275 | 2020-04-27 | Humboldt | Iowa | 19091 | 4 | 0 |
96107 | 96107 | 2020-04-28 | Humboldt | Iowa | 19091 | 4 | 0 |
98952 | 98952 | 2020-04-29 | Humboldt | Iowa | 19091 | 4 | 0 |
101803 | 101803 | 2020-04-30 | Humboldt | Iowa | 19091 | 4 | 0 |
104661 | 104661 | 2020-05-01 | Humboldt | Iowa | 19091 | 4 | 0 |
107526 | 107526 | 2020-05-02 | Humboldt | Iowa | 19091 | 4 | 0 |
110396 | 110396 | 2020-05-03 | Humboldt | Iowa | 19091 | 4 | 0 |
113271 | 113271 | 2020-05-04 | Humboldt | Iowa | 19091 | 4 | 0 |
116154 | 116154 | 2020-05-05 | Humboldt | Iowa | 19091 | 4 | 0 |
119114 | 119114 | 2020-05-06 | Humboldt | Iowa | 19091 | 4 | 0 |
122084 | 122084 | 2020-05-07 | Humboldt | Iowa | 19091 | 6 | 0 |
125065 | 125065 | 2020-05-08 | Humboldt | Iowa | 19091 | 6 | 0 |
128052 | 128052 | 2020-05-09 | Humboldt | Iowa | 19091 | 6 | 0 |
131043 | 131043 | 2020-05-10 | Humboldt | Iowa | 19091 | 7 | 0 |
134033 | 134033 | 2020-05-11 | Humboldt | Iowa | 19091 | 7 | 0 |
137022 | 137022 | 2020-05-12 | Humboldt | Iowa | 19091 | 7 | 0 |
140015 | 140015 | 2020-05-13 | Humboldt | Iowa | 19091 | 7 | 0 |
143011 | 143011 | 2020-05-14 | Humboldt | Iowa | 19091 | 7 | 0 |
146011 | 146011 | 2020-05-15 | Humboldt | Iowa | 19091 | 7 | 0 |
149015 | 149015 | 2020-05-16 | Humboldt | Iowa | 19091 | 7 | 0 |
152025 | 152025 | 2020-05-17 | Humboldt | Iowa | 19091 | 7 | 0 |
155037 | 155037 | 2020-05-18 | Humboldt | Iowa | 19091 | 7 | 0 |
158053 | 158053 | 2020-05-19 | Humboldt | Iowa | 19091 | 7 | 0 |
161079 | 161079 | 2020-05-20 | Humboldt | Iowa | 19091 | 7 | 0 |
164107 | 164107 | 2020-05-21 | Humboldt | Iowa | 19091 | 9 | 0 |
167140 | 167140 | 2020-05-22 | Humboldt | Iowa | 19091 | 10 | 0 |
170177 | 170177 | 2020-05-23 | Humboldt | Iowa | 19091 | 10 | 0 |
173218 | 173218 | 2020-05-24 | Humboldt | Iowa | 19091 | 13 | 0 |
176262 | 176262 | 2020-05-25 | Humboldt | Iowa | 19091 | 13 | 0 |
179306 | 179306 | 2020-05-26 | Humboldt | Iowa | 19091 | 13 | 0 |
182351 | 182351 | 2020-05-27 | Humboldt | Iowa | 19091 | 15 | 0 |
185405 | 185405 | 2020-05-28 | Humboldt | Iowa | 19091 | 16 | 0 |
188463 | 188463 | 2020-05-29 | Humboldt | Iowa | 19091 | 16 | 0 |
191528 | 191528 | 2020-05-30 | Humboldt | Iowa | 19091 | 17 | 0 |
194595 | 194595 | 2020-05-31 | Humboldt | Iowa | 19091 | 18 | 0 |
197665 | 197665 | 2020-06-01 | Humboldt | Iowa | 19091 | 18 | 1 |
200738 | 200738 | 2020-06-02 | Humboldt | Iowa | 19091 | 18 | 1 |
203814 | 203814 | 2020-06-03 | Humboldt | Iowa | 19091 | 18 | 1 |
206894 | 206894 | 2020-06-04 | Humboldt | Iowa | 19091 | 19 | 1 |
209975 | 209975 | 2020-06-05 | Humboldt | Iowa | 19091 | 20 | 1 |
213060 | 213060 | 2020-06-06 | Humboldt | Iowa | 19091 | 20 | 1 |
216147 | 216147 | 2020-06-07 | Humboldt | Iowa | 19091 | 20 | 1 |
219239 | 219239 | 2020-06-08 | Humboldt | Iowa | 19091 | 24 | 1 |
222334 | 222334 | 2020-06-09 | Humboldt | Iowa | 19091 | 24 | 1 |
225429 | 225429 | 2020-06-10 | Humboldt | Iowa | 19091 | 27 | 1 |
228531 | 228531 | 2020-06-11 | Humboldt | Iowa | 19091 | 29 | 1 |
231634 | 231634 | 2020-06-12 | Humboldt | Iowa | 19091 | 30 | 1 |
234740 | 234740 | 2020-06-13 | Humboldt | Iowa | 19091 | 32 | 1 |
237847 | 237847 | 2020-06-14 | Humboldt | Iowa | 19091 | 33 | 1 |
240955 | 240955 | 2020-06-15 | Humboldt | Iowa | 19091 | 34 | 1 |
244066 | 244066 | 2020-06-16 | Humboldt | Iowa | 19091 | 34 | 1 |
247179 | 247179 | 2020-06-17 | Humboldt | Iowa | 19091 | 34 | 1 |
250291 | 250291 | 2020-06-18 | Humboldt | Iowa | 19091 | 38 | 1 |
253406 | 253406 | 2020-06-19 | Humboldt | Iowa | 19091 | 39 | 1 |
256526 | 256526 | 2020-06-20 | Humboldt | Iowa | 19091 | 39 | 1 |
259652 | 259652 | 2020-06-21 | Humboldt | Iowa | 19091 | 40 | 1 |
262779 | 262779 | 2020-06-22 | Humboldt | Iowa | 19091 | 41 | 1 |
265907 | 265907 | 2020-06-23 | Humboldt | Iowa | 19091 | 42 | 1 |
269037 | 269037 | 2020-06-24 | Humboldt | Iowa | 19091 | 44 | 1 |
272174 | 272174 | 2020-06-25 | Humboldt | Iowa | 19091 | 46 | 1 |
275316 | 275316 | 2020-06-26 | Humboldt | Iowa | 19091 | 45 | 1 |
278464 | 278464 | 2020-06-27 | Humboldt | Iowa | 19091 | 45 | 1 |
281612 | 281612 | 2020-06-28 | Humboldt | Iowa | 19091 | 46 | 1 |
284757 | 284757 | 2020-06-29 | Humboldt | Iowa | 19091 | 48 | 1 |
287906 | 287906 | 2020-06-30 | Humboldt | Iowa | 19091 | 48 | 1 |
291056 | 291056 | 2020-07-01 | Humboldt | Iowa | 19091 | 52 | 1 |
294210 | 294210 | 2020-07-02 | Humboldt | Iowa | 19091 | 53 | 1 |
297368 | 297368 | 2020-07-03 | Humboldt | Iowa | 19091 | 53 | 1 |
300530 | 300530 | 2020-07-04 | Humboldt | Iowa | 19091 | 54 | 1 |
303694 | 303694 | 2020-07-05 | Humboldt | Iowa | 19091 | 54 | 1 |
306859 | 306859 | 2020-07-06 | Humboldt | Iowa | 19091 | 55 | 1 |
310027 | 310027 | 2020-07-07 | Humboldt | Iowa | 19091 | 55 | 1 |
313197 | 313197 | 2020-07-08 | Humboldt | Iowa | 19091 | 57 | 1 |
316371 | 316371 | 2020-07-09 | Humboldt | Iowa | 19091 | 59 | 1 |
319544 | 319544 | 2020-07-10 | Humboldt | Iowa | 19091 | 59 | 1 |
322723 | 322723 | 2020-07-11 | Humboldt | Iowa | 19091 | 60 | 1 |
325904 | 325904 | 2020-07-12 | Humboldt | Iowa | 19091 | 60 | 1 |
329090 | 329090 | 2020-07-13 | Humboldt | Iowa | 19091 | 60 | 1 |
332277 | 332277 | 2020-07-14 | Humboldt | Iowa | 19091 | 61 | 1 |
335470 | 335470 | 2020-07-15 | Humboldt | Iowa | 19091 | 62 | 1 |
338666 | 338666 | 2020-07-16 | Humboldt | Iowa | 19091 | 68 | 1 |
341862 | 341862 | 2020-07-17 | Humboldt | Iowa | 19091 | 69 | 1 |
345062 | 345062 | 2020-07-18 | Humboldt | Iowa | 19091 | 70 | 1 |
348263 | 348263 | 2020-07-19 | Humboldt | Iowa | 19091 | 70 | 1 |
351463 | 351463 | 2020-07-20 | Humboldt | Iowa | 19091 | 70 | 1 |
354665 | 354665 | 2020-07-21 | Humboldt | Iowa | 19091 | 70 | 1 |
357867 | 357867 | 2020-07-22 | Humboldt | Iowa | 19091 | 72 | 1 |
361072 | 361072 | 2020-07-23 | Humboldt | Iowa | 19091 | 72 | 1 |
364279 | 364279 | 2020-07-24 | Humboldt | Iowa | 19091 | 73 | 1 |
367486 | 367486 | 2020-07-25 | Humboldt | Iowa | 19091 | 72 | 1 |
370696 | 370696 | 2020-07-26 | Humboldt | Iowa | 19091 | 72 | 1 |
373908 | 373908 | 2020-07-27 | Humboldt | Iowa | 19091 | 82 | 1 |
377123 | 377123 | 2020-07-28 | Humboldt | Iowa | 19091 | 84 | 1 |
380340 | 380340 | 2020-07-29 | Humboldt | Iowa | 19091 | 83 | 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);