ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 19087 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535259 | 535259 | 2020-09-15 | Henry | Iowa | 19087 | 470 | 4 |
532024 | 532024 | 2020-09-14 | Henry | Iowa | 19087 | 464 | 4 |
528787 | 528787 | 2020-09-13 | Henry | Iowa | 19087 | 459 | 4 |
525551 | 525551 | 2020-09-12 | Henry | Iowa | 19087 | 459 | 4 |
522315 | 522315 | 2020-09-11 | Henry | Iowa | 19087 | 454 | 4 |
519078 | 519078 | 2020-09-10 | Henry | Iowa | 19087 | 451 | 4 |
515843 | 515843 | 2020-09-09 | Henry | Iowa | 19087 | 448 | 4 |
512610 | 512610 | 2020-09-08 | Henry | Iowa | 19087 | 408 | 4 |
509377 | 509377 | 2020-09-07 | Henry | Iowa | 19087 | 404 | 4 |
506145 | 506145 | 2020-09-06 | Henry | Iowa | 19087 | 403 | 4 |
502911 | 502911 | 2020-09-05 | Henry | Iowa | 19087 | 392 | 4 |
499677 | 499677 | 2020-09-04 | Henry | Iowa | 19087 | 377 | 4 |
496444 | 496444 | 2020-09-03 | Henry | Iowa | 19087 | 306 | 4 |
493210 | 493210 | 2020-09-02 | Henry | Iowa | 19087 | 296 | 4 |
489977 | 489977 | 2020-09-01 | Henry | Iowa | 19087 | 294 | 4 |
486744 | 486744 | 2020-08-31 | Henry | Iowa | 19087 | 284 | 4 |
483509 | 483509 | 2020-08-30 | Henry | Iowa | 19087 | 279 | 4 |
480275 | 480275 | 2020-08-29 | Henry | Iowa | 19087 | 276 | 4 |
477042 | 477042 | 2020-08-28 | Henry | Iowa | 19087 | 261 | 4 |
473809 | 473809 | 2020-08-27 | Henry | Iowa | 19087 | 235 | 4 |
470577 | 470577 | 2020-08-26 | Henry | Iowa | 19087 | 216 | 4 |
467348 | 467348 | 2020-08-25 | Henry | Iowa | 19087 | 205 | 4 |
464119 | 464119 | 2020-08-24 | Henry | Iowa | 19087 | 205 | 4 |
460890 | 460890 | 2020-08-23 | Henry | Iowa | 19087 | 202 | 4 |
457663 | 457663 | 2020-08-22 | Henry | Iowa | 19087 | 202 | 4 |
454435 | 454435 | 2020-08-21 | Henry | Iowa | 19087 | 197 | 4 |
451207 | 451207 | 2020-08-20 | Henry | Iowa | 19087 | 190 | 4 |
447979 | 447979 | 2020-08-19 | Henry | Iowa | 19087 | 178 | 4 |
444752 | 444752 | 2020-08-18 | Henry | Iowa | 19087 | 171 | 4 |
441526 | 441526 | 2020-08-17 | Henry | Iowa | 19087 | 166 | 4 |
438300 | 438300 | 2020-08-16 | Henry | Iowa | 19087 | 166 | 4 |
435074 | 435074 | 2020-08-15 | Henry | Iowa | 19087 | 148 | 4 |
431849 | 431849 | 2020-08-14 | Henry | Iowa | 19087 | 146 | 4 |
428621 | 428621 | 2020-08-13 | Henry | Iowa | 19087 | 142 | 4 |
425397 | 425397 | 2020-08-12 | Henry | Iowa | 19087 | 136 | 4 |
422176 | 422176 | 2020-08-11 | Henry | Iowa | 19087 | 127 | 4 |
418953 | 418953 | 2020-08-10 | Henry | Iowa | 19087 | 127 | 4 |
415732 | 415732 | 2020-08-09 | Henry | Iowa | 19087 | 125 | 4 |
412512 | 412512 | 2020-08-08 | Henry | Iowa | 19087 | 120 | 3 |
409293 | 409293 | 2020-08-07 | Henry | Iowa | 19087 | 118 | 3 |
406073 | 406073 | 2020-08-06 | Henry | Iowa | 19087 | 119 | 3 |
402855 | 402855 | 2020-08-05 | Henry | Iowa | 19087 | 114 | 3 |
399639 | 399639 | 2020-08-04 | Henry | Iowa | 19087 | 114 | 3 |
396423 | 396423 | 2020-08-03 | Henry | Iowa | 19087 | 113 | 3 |
393207 | 393207 | 2020-08-02 | Henry | Iowa | 19087 | 112 | 3 |
389990 | 389990 | 2020-08-01 | Henry | Iowa | 19087 | 111 | 3 |
386773 | 386773 | 2020-07-31 | Henry | Iowa | 19087 | 109 | 3 |
383555 | 383555 | 2020-07-30 | Henry | Iowa | 19087 | 108 | 3 |
380338 | 380338 | 2020-07-29 | Henry | Iowa | 19087 | 107 | 3 |
377121 | 377121 | 2020-07-28 | Henry | Iowa | 19087 | 107 | 3 |
373906 | 373906 | 2020-07-27 | Henry | Iowa | 19087 | 105 | 3 |
370694 | 370694 | 2020-07-26 | Henry | Iowa | 19087 | 104 | 3 |
367484 | 367484 | 2020-07-25 | Henry | Iowa | 19087 | 104 | 3 |
364277 | 364277 | 2020-07-24 | Henry | Iowa | 19087 | 103 | 3 |
361070 | 361070 | 2020-07-23 | Henry | Iowa | 19087 | 101 | 3 |
357865 | 357865 | 2020-07-22 | Henry | Iowa | 19087 | 100 | 3 |
354663 | 354663 | 2020-07-21 | Henry | Iowa | 19087 | 100 | 3 |
351461 | 351461 | 2020-07-20 | Henry | Iowa | 19087 | 100 | 3 |
348261 | 348261 | 2020-07-19 | Henry | Iowa | 19087 | 100 | 3 |
345060 | 345060 | 2020-07-18 | Henry | Iowa | 19087 | 100 | 3 |
341860 | 341860 | 2020-07-17 | Henry | Iowa | 19087 | 98 | 3 |
338664 | 338664 | 2020-07-16 | Henry | Iowa | 19087 | 98 | 3 |
335468 | 335468 | 2020-07-15 | Henry | Iowa | 19087 | 94 | 3 |
332275 | 332275 | 2020-07-14 | Henry | Iowa | 19087 | 93 | 3 |
329088 | 329088 | 2020-07-13 | Henry | Iowa | 19087 | 93 | 3 |
325902 | 325902 | 2020-07-12 | Henry | Iowa | 19087 | 93 | 3 |
322721 | 322721 | 2020-07-11 | Henry | Iowa | 19087 | 93 | 3 |
319542 | 319542 | 2020-07-10 | Henry | Iowa | 19087 | 93 | 3 |
316369 | 316369 | 2020-07-09 | Henry | Iowa | 19087 | 90 | 3 |
313195 | 313195 | 2020-07-08 | Henry | Iowa | 19087 | 88 | 3 |
310025 | 310025 | 2020-07-07 | Henry | Iowa | 19087 | 86 | 3 |
306857 | 306857 | 2020-07-06 | Henry | Iowa | 19087 | 86 | 3 |
303692 | 303692 | 2020-07-05 | Henry | Iowa | 19087 | 86 | 3 |
300528 | 300528 | 2020-07-04 | Henry | Iowa | 19087 | 86 | 3 |
297366 | 297366 | 2020-07-03 | Henry | Iowa | 19087 | 86 | 3 |
294208 | 294208 | 2020-07-02 | Henry | Iowa | 19087 | 85 | 3 |
291054 | 291054 | 2020-07-01 | Henry | Iowa | 19087 | 83 | 3 |
287904 | 287904 | 2020-06-30 | Henry | Iowa | 19087 | 82 | 3 |
284755 | 284755 | 2020-06-29 | Henry | Iowa | 19087 | 81 | 3 |
281610 | 281610 | 2020-06-28 | Henry | Iowa | 19087 | 81 | 3 |
278462 | 278462 | 2020-06-27 | Henry | Iowa | 19087 | 80 | 3 |
275314 | 275314 | 2020-06-26 | Henry | Iowa | 19087 | 80 | 3 |
272172 | 272172 | 2020-06-25 | Henry | Iowa | 19087 | 79 | 3 |
269035 | 269035 | 2020-06-24 | Henry | Iowa | 19087 | 80 | 3 |
265905 | 265905 | 2020-06-23 | Henry | Iowa | 19087 | 79 | 3 |
262777 | 262777 | 2020-06-22 | Henry | Iowa | 19087 | 78 | 3 |
259650 | 259650 | 2020-06-21 | Henry | Iowa | 19087 | 78 | 3 |
256524 | 256524 | 2020-06-20 | Henry | Iowa | 19087 | 76 | 3 |
253404 | 253404 | 2020-06-19 | Henry | Iowa | 19087 | 75 | 3 |
250289 | 250289 | 2020-06-18 | Henry | Iowa | 19087 | 75 | 3 |
247177 | 247177 | 2020-06-17 | Henry | Iowa | 19087 | 75 | 3 |
244064 | 244064 | 2020-06-16 | Henry | Iowa | 19087 | 74 | 2 |
240953 | 240953 | 2020-06-15 | Henry | Iowa | 19087 | 74 | 2 |
237845 | 237845 | 2020-06-14 | Henry | Iowa | 19087 | 73 | 2 |
234738 | 234738 | 2020-06-13 | Henry | Iowa | 19087 | 73 | 2 |
231632 | 231632 | 2020-06-12 | Henry | Iowa | 19087 | 73 | 2 |
228529 | 228529 | 2020-06-11 | Henry | Iowa | 19087 | 73 | 2 |
225427 | 225427 | 2020-06-10 | Henry | Iowa | 19087 | 73 | 2 |
222332 | 222332 | 2020-06-09 | Henry | Iowa | 19087 | 73 | 2 |
219237 | 219237 | 2020-06-08 | Henry | Iowa | 19087 | 73 | 2 |
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);