ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 19085 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535258 | 535258 | 2020-09-15 | Harrison | Iowa | 19085 | 164 | 2 |
532023 | 532023 | 2020-09-14 | Harrison | Iowa | 19085 | 162 | 2 |
528786 | 528786 | 2020-09-13 | Harrison | Iowa | 19085 | 162 | 2 |
525550 | 525550 | 2020-09-12 | Harrison | Iowa | 19085 | 161 | 2 |
522314 | 522314 | 2020-09-11 | Harrison | Iowa | 19085 | 160 | 2 |
519077 | 519077 | 2020-09-10 | Harrison | Iowa | 19085 | 158 | 2 |
515842 | 515842 | 2020-09-09 | Harrison | Iowa | 19085 | 157 | 2 |
512609 | 512609 | 2020-09-08 | Harrison | Iowa | 19085 | 156 | 2 |
509376 | 509376 | 2020-09-07 | Harrison | Iowa | 19085 | 157 | 2 |
506144 | 506144 | 2020-09-06 | Harrison | Iowa | 19085 | 157 | 2 |
502910 | 502910 | 2020-09-05 | Harrison | Iowa | 19085 | 156 | 2 |
499676 | 499676 | 2020-09-04 | Harrison | Iowa | 19085 | 153 | 2 |
496443 | 496443 | 2020-09-03 | Harrison | Iowa | 19085 | 151 | 2 |
493209 | 493209 | 2020-09-02 | Harrison | Iowa | 19085 | 150 | 2 |
489976 | 489976 | 2020-09-01 | Harrison | Iowa | 19085 | 148 | 2 |
486743 | 486743 | 2020-08-31 | Harrison | Iowa | 19085 | 147 | 2 |
483508 | 483508 | 2020-08-30 | Harrison | Iowa | 19085 | 147 | 1 |
480274 | 480274 | 2020-08-29 | Harrison | Iowa | 19085 | 147 | 1 |
477041 | 477041 | 2020-08-28 | Harrison | Iowa | 19085 | 143 | 1 |
473808 | 473808 | 2020-08-27 | Harrison | Iowa | 19085 | 142 | 1 |
470576 | 470576 | 2020-08-26 | Harrison | Iowa | 19085 | 140 | 1 |
467347 | 467347 | 2020-08-25 | Harrison | Iowa | 19085 | 139 | 1 |
464118 | 464118 | 2020-08-24 | Harrison | Iowa | 19085 | 137 | 1 |
460889 | 460889 | 2020-08-23 | Harrison | Iowa | 19085 | 135 | 1 |
457662 | 457662 | 2020-08-22 | Harrison | Iowa | 19085 | 135 | 1 |
454434 | 454434 | 2020-08-21 | Harrison | Iowa | 19085 | 131 | 1 |
451206 | 451206 | 2020-08-20 | Harrison | Iowa | 19085 | 129 | 1 |
447978 | 447978 | 2020-08-19 | Harrison | Iowa | 19085 | 125 | 1 |
444751 | 444751 | 2020-08-18 | Harrison | Iowa | 19085 | 119 | 1 |
441525 | 441525 | 2020-08-17 | Harrison | Iowa | 19085 | 118 | 1 |
438299 | 438299 | 2020-08-16 | Harrison | Iowa | 19085 | 117 | 1 |
435073 | 435073 | 2020-08-15 | Harrison | Iowa | 19085 | 116 | 1 |
431848 | 431848 | 2020-08-14 | Harrison | Iowa | 19085 | 116 | 1 |
428620 | 428620 | 2020-08-13 | Harrison | Iowa | 19085 | 114 | 1 |
425396 | 425396 | 2020-08-12 | Harrison | Iowa | 19085 | 110 | 1 |
422175 | 422175 | 2020-08-11 | Harrison | Iowa | 19085 | 110 | 1 |
418952 | 418952 | 2020-08-10 | Harrison | Iowa | 19085 | 109 | 1 |
415731 | 415731 | 2020-08-09 | Harrison | Iowa | 19085 | 107 | 1 |
412511 | 412511 | 2020-08-08 | Harrison | Iowa | 19085 | 105 | 0 |
409292 | 409292 | 2020-08-07 | Harrison | Iowa | 19085 | 103 | 0 |
406072 | 406072 | 2020-08-06 | Harrison | Iowa | 19085 | 102 | 0 |
402854 | 402854 | 2020-08-05 | Harrison | Iowa | 19085 | 99 | 0 |
399638 | 399638 | 2020-08-04 | Harrison | Iowa | 19085 | 98 | 0 |
396422 | 396422 | 2020-08-03 | Harrison | Iowa | 19085 | 97 | 0 |
393206 | 393206 | 2020-08-02 | Harrison | Iowa | 19085 | 96 | 0 |
389989 | 389989 | 2020-08-01 | Harrison | Iowa | 19085 | 95 | 0 |
386772 | 386772 | 2020-07-31 | Harrison | Iowa | 19085 | 90 | 0 |
383554 | 383554 | 2020-07-30 | Harrison | Iowa | 19085 | 89 | 0 |
380337 | 380337 | 2020-07-29 | Harrison | Iowa | 19085 | 88 | 0 |
377120 | 377120 | 2020-07-28 | Harrison | Iowa | 19085 | 84 | 0 |
373905 | 373905 | 2020-07-27 | Harrison | Iowa | 19085 | 84 | 0 |
370693 | 370693 | 2020-07-26 | Harrison | Iowa | 19085 | 83 | 0 |
367483 | 367483 | 2020-07-25 | Harrison | Iowa | 19085 | 82 | 0 |
364276 | 364276 | 2020-07-24 | Harrison | Iowa | 19085 | 78 | 0 |
361069 | 361069 | 2020-07-23 | Harrison | Iowa | 19085 | 73 | 0 |
357864 | 357864 | 2020-07-22 | Harrison | Iowa | 19085 | 73 | 0 |
354662 | 354662 | 2020-07-21 | Harrison | Iowa | 19085 | 71 | 0 |
351460 | 351460 | 2020-07-20 | Harrison | Iowa | 19085 | 71 | 0 |
348260 | 348260 | 2020-07-19 | Harrison | Iowa | 19085 | 69 | 0 |
345059 | 345059 | 2020-07-18 | Harrison | Iowa | 19085 | 69 | 0 |
341859 | 341859 | 2020-07-17 | Harrison | Iowa | 19085 | 68 | 0 |
338663 | 338663 | 2020-07-16 | Harrison | Iowa | 19085 | 67 | 0 |
335467 | 335467 | 2020-07-15 | Harrison | Iowa | 19085 | 64 | 0 |
332274 | 332274 | 2020-07-14 | Harrison | Iowa | 19085 | 63 | 0 |
329087 | 329087 | 2020-07-13 | Harrison | Iowa | 19085 | 62 | 0 |
325901 | 325901 | 2020-07-12 | Harrison | Iowa | 19085 | 62 | 0 |
322720 | 322720 | 2020-07-11 | Harrison | Iowa | 19085 | 60 | 0 |
319541 | 319541 | 2020-07-10 | Harrison | Iowa | 19085 | 58 | 0 |
316368 | 316368 | 2020-07-09 | Harrison | Iowa | 19085 | 56 | 0 |
313194 | 313194 | 2020-07-08 | Harrison | Iowa | 19085 | 54 | 0 |
310024 | 310024 | 2020-07-07 | Harrison | Iowa | 19085 | 54 | 0 |
306856 | 306856 | 2020-07-06 | Harrison | Iowa | 19085 | 54 | 0 |
303691 | 303691 | 2020-07-05 | Harrison | Iowa | 19085 | 53 | 0 |
300527 | 300527 | 2020-07-04 | Harrison | Iowa | 19085 | 53 | 0 |
297365 | 297365 | 2020-07-03 | Harrison | Iowa | 19085 | 53 | 0 |
294207 | 294207 | 2020-07-02 | Harrison | Iowa | 19085 | 53 | 0 |
291053 | 291053 | 2020-07-01 | Harrison | Iowa | 19085 | 52 | 0 |
287903 | 287903 | 2020-06-30 | Harrison | Iowa | 19085 | 51 | 0 |
284754 | 284754 | 2020-06-29 | Harrison | Iowa | 19085 | 49 | 0 |
281609 | 281609 | 2020-06-28 | Harrison | Iowa | 19085 | 49 | 0 |
278461 | 278461 | 2020-06-27 | Harrison | Iowa | 19085 | 49 | 0 |
275313 | 275313 | 2020-06-26 | Harrison | Iowa | 19085 | 48 | 0 |
272171 | 272171 | 2020-06-25 | Harrison | Iowa | 19085 | 47 | 0 |
269034 | 269034 | 2020-06-24 | Harrison | Iowa | 19085 | 46 | 0 |
265904 | 265904 | 2020-06-23 | Harrison | Iowa | 19085 | 44 | 0 |
262776 | 262776 | 2020-06-22 | Harrison | Iowa | 19085 | 44 | 0 |
259649 | 259649 | 2020-06-21 | Harrison | Iowa | 19085 | 42 | 0 |
256523 | 256523 | 2020-06-20 | Harrison | Iowa | 19085 | 41 | 0 |
253403 | 253403 | 2020-06-19 | Harrison | Iowa | 19085 | 41 | 0 |
250288 | 250288 | 2020-06-18 | Harrison | Iowa | 19085 | 41 | 0 |
247176 | 247176 | 2020-06-17 | Harrison | Iowa | 19085 | 41 | 0 |
244063 | 244063 | 2020-06-16 | Harrison | Iowa | 19085 | 40 | 0 |
240952 | 240952 | 2020-06-15 | Harrison | Iowa | 19085 | 41 | 0 |
237844 | 237844 | 2020-06-14 | Harrison | Iowa | 19085 | 39 | 0 |
234737 | 234737 | 2020-06-13 | Harrison | Iowa | 19085 | 39 | 0 |
231631 | 231631 | 2020-06-12 | Harrison | Iowa | 19085 | 33 | 0 |
228528 | 228528 | 2020-06-11 | Harrison | Iowa | 19085 | 32 | 0 |
225426 | 225426 | 2020-06-10 | Harrison | Iowa | 19085 | 30 | 0 |
222331 | 222331 | 2020-06-09 | Harrison | Iowa | 19085 | 27 | 0 |
219236 | 219236 | 2020-06-08 | Harrison | Iowa | 19085 | 27 | 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);