ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Union" and fips = 19175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635766 | 635766 | 2020-10-16 | Union | Iowa | 19175 | 204 | 3 |
632520 | 632520 | 2020-10-15 | Union | Iowa | 19175 | 202 | 3 |
629276 | 629276 | 2020-10-14 | Union | Iowa | 19175 | 198 | 3 |
626033 | 626033 | 2020-10-13 | Union | Iowa | 19175 | 191 | 3 |
622791 | 622791 | 2020-10-12 | Union | Iowa | 19175 | 190 | 3 |
619547 | 619547 | 2020-10-11 | Union | Iowa | 19175 | 189 | 3 |
616305 | 616305 | 2020-10-10 | Union | Iowa | 19175 | 177 | 3 |
613064 | 613064 | 2020-10-09 | Union | Iowa | 19175 | 177 | 3 |
609822 | 609822 | 2020-10-08 | Union | Iowa | 19175 | 174 | 3 |
606579 | 606579 | 2020-10-07 | Union | Iowa | 19175 | 160 | 3 |
603337 | 603337 | 2020-10-06 | Union | Iowa | 19175 | 158 | 3 |
600094 | 600094 | 2020-10-05 | Union | Iowa | 19175 | 155 | 3 |
596852 | 596852 | 2020-10-04 | Union | Iowa | 19175 | 152 | 3 |
593610 | 593610 | 2020-10-03 | Union | Iowa | 19175 | 152 | 3 |
590369 | 590369 | 2020-10-02 | Union | Iowa | 19175 | 152 | 3 |
587128 | 587128 | 2020-10-01 | Union | Iowa | 19175 | 149 | 3 |
583888 | 583888 | 2020-09-30 | Union | Iowa | 19175 | 146 | 3 |
580649 | 580649 | 2020-09-29 | Union | Iowa | 19175 | 142 | 3 |
577408 | 577408 | 2020-09-28 | Union | Iowa | 19175 | 138 | 3 |
574166 | 574166 | 2020-09-27 | Union | Iowa | 19175 | 137 | 3 |
570923 | 570923 | 2020-09-26 | Union | Iowa | 19175 | 135 | 3 |
567681 | 567681 | 2020-09-25 | Union | Iowa | 19175 | 131 | 3 |
564441 | 564441 | 2020-09-24 | Union | Iowa | 19175 | 128 | 3 |
561201 | 561201 | 2020-09-23 | Union | Iowa | 19175 | 126 | 3 |
557965 | 557965 | 2020-09-22 | Union | Iowa | 19175 | 123 | 3 |
554728 | 554728 | 2020-09-21 | Union | Iowa | 19175 | 122 | 3 |
551489 | 551489 | 2020-09-20 | Union | Iowa | 19175 | 122 | 3 |
548250 | 548250 | 2020-09-19 | Union | Iowa | 19175 | 120 | 3 |
545012 | 545012 | 2020-09-18 | Union | Iowa | 19175 | 119 | 3 |
541776 | 541776 | 2020-09-17 | Union | Iowa | 19175 | 113 | 3 |
538539 | 538539 | 2020-09-16 | Union | Iowa | 19175 | 109 | 3 |
535303 | 535303 | 2020-09-15 | Union | Iowa | 19175 | 105 | 3 |
532068 | 532068 | 2020-09-14 | Union | Iowa | 19175 | 105 | 3 |
528831 | 528831 | 2020-09-13 | Union | Iowa | 19175 | 104 | 3 |
525595 | 525595 | 2020-09-12 | Union | Iowa | 19175 | 104 | 3 |
522359 | 522359 | 2020-09-11 | Union | Iowa | 19175 | 96 | 3 |
519122 | 519122 | 2020-09-10 | Union | Iowa | 19175 | 97 | 3 |
515887 | 515887 | 2020-09-09 | Union | Iowa | 19175 | 96 | 3 |
512654 | 512654 | 2020-09-08 | Union | Iowa | 19175 | 94 | 3 |
509421 | 509421 | 2020-09-07 | Union | Iowa | 19175 | 94 | 3 |
506189 | 506189 | 2020-09-06 | Union | Iowa | 19175 | 93 | 3 |
502955 | 502955 | 2020-09-05 | Union | Iowa | 19175 | 93 | 3 |
499721 | 499721 | 2020-09-04 | Union | Iowa | 19175 | 93 | 3 |
496488 | 496488 | 2020-09-03 | Union | Iowa | 19175 | 92 | 3 |
493254 | 493254 | 2020-09-02 | Union | Iowa | 19175 | 92 | 3 |
490021 | 490021 | 2020-09-01 | Union | Iowa | 19175 | 93 | 3 |
486788 | 486788 | 2020-08-31 | Union | Iowa | 19175 | 93 | 3 |
483553 | 483553 | 2020-08-30 | Union | Iowa | 19175 | 93 | 3 |
480319 | 480319 | 2020-08-29 | Union | Iowa | 19175 | 93 | 3 |
477086 | 477086 | 2020-08-28 | Union | Iowa | 19175 | 93 | 3 |
473853 | 473853 | 2020-08-27 | Union | Iowa | 19175 | 93 | 3 |
470621 | 470621 | 2020-08-26 | Union | Iowa | 19175 | 91 | 3 |
467392 | 467392 | 2020-08-25 | Union | Iowa | 19175 | 90 | 3 |
464163 | 464163 | 2020-08-24 | Union | Iowa | 19175 | 90 | 3 |
460934 | 460934 | 2020-08-23 | Union | Iowa | 19175 | 90 | 3 |
457707 | 457707 | 2020-08-22 | Union | Iowa | 19175 | 90 | 3 |
454479 | 454479 | 2020-08-21 | Union | Iowa | 19175 | 90 | 3 |
451251 | 451251 | 2020-08-20 | Union | Iowa | 19175 | 89 | 3 |
448023 | 448023 | 2020-08-19 | Union | Iowa | 19175 | 89 | 3 |
444796 | 444796 | 2020-08-18 | Union | Iowa | 19175 | 88 | 3 |
441570 | 441570 | 2020-08-17 | Union | Iowa | 19175 | 88 | 3 |
438344 | 438344 | 2020-08-16 | Union | Iowa | 19175 | 88 | 2 |
435118 | 435118 | 2020-08-15 | Union | Iowa | 19175 | 87 | 2 |
431893 | 431893 | 2020-08-14 | Union | Iowa | 19175 | 83 | 2 |
428665 | 428665 | 2020-08-13 | Union | Iowa | 19175 | 81 | 1 |
425441 | 425441 | 2020-08-12 | Union | Iowa | 19175 | 78 | 1 |
422220 | 422220 | 2020-08-11 | Union | Iowa | 19175 | 78 | 1 |
418997 | 418997 | 2020-08-10 | Union | Iowa | 19175 | 77 | 1 |
415776 | 415776 | 2020-08-09 | Union | Iowa | 19175 | 77 | 1 |
412556 | 412556 | 2020-08-08 | Union | Iowa | 19175 | 76 | 1 |
409337 | 409337 | 2020-08-07 | Union | Iowa | 19175 | 75 | 1 |
406117 | 406117 | 2020-08-06 | Union | Iowa | 19175 | 75 | 1 |
402899 | 402899 | 2020-08-05 | Union | Iowa | 19175 | 74 | 1 |
399683 | 399683 | 2020-08-04 | Union | Iowa | 19175 | 72 | 1 |
396467 | 396467 | 2020-08-03 | Union | Iowa | 19175 | 70 | 1 |
393251 | 393251 | 2020-08-02 | Union | Iowa | 19175 | 70 | 1 |
390034 | 390034 | 2020-08-01 | Union | Iowa | 19175 | 70 | 1 |
386817 | 386817 | 2020-07-31 | Union | Iowa | 19175 | 66 | 1 |
383599 | 383599 | 2020-07-30 | Union | Iowa | 19175 | 67 | 1 |
380382 | 380382 | 2020-07-29 | Union | Iowa | 19175 | 66 | 1 |
377165 | 377165 | 2020-07-28 | Union | Iowa | 19175 | 66 | 1 |
373950 | 373950 | 2020-07-27 | Union | Iowa | 19175 | 64 | 1 |
370738 | 370738 | 2020-07-26 | Union | Iowa | 19175 | 64 | 1 |
367528 | 367528 | 2020-07-25 | Union | Iowa | 19175 | 64 | 1 |
364321 | 364321 | 2020-07-24 | Union | Iowa | 19175 | 61 | 1 |
361114 | 361114 | 2020-07-23 | Union | Iowa | 19175 | 59 | 1 |
357909 | 357909 | 2020-07-22 | Union | Iowa | 19175 | 59 | 1 |
354707 | 354707 | 2020-07-21 | Union | Iowa | 19175 | 56 | 1 |
351505 | 351505 | 2020-07-20 | Union | Iowa | 19175 | 56 | 1 |
348305 | 348305 | 2020-07-19 | Union | Iowa | 19175 | 56 | 1 |
345104 | 345104 | 2020-07-18 | Union | Iowa | 19175 | 54 | 1 |
341904 | 341904 | 2020-07-17 | Union | Iowa | 19175 | 54 | 1 |
338708 | 338708 | 2020-07-16 | Union | Iowa | 19175 | 53 | 1 |
335512 | 335512 | 2020-07-15 | Union | Iowa | 19175 | 50 | 1 |
332319 | 332319 | 2020-07-14 | Union | Iowa | 19175 | 42 | 0 |
329132 | 329132 | 2020-07-13 | Union | Iowa | 19175 | 43 | 0 |
325946 | 325946 | 2020-07-12 | Union | Iowa | 19175 | 43 | 0 |
322765 | 322765 | 2020-07-11 | Union | Iowa | 19175 | 38 | 0 |
319586 | 319586 | 2020-07-10 | Union | Iowa | 19175 | 38 | 0 |
316413 | 316413 | 2020-07-09 | Union | Iowa | 19175 | 37 | 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);