ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 19061 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930998 | 930998 | 2021-01-15 | Dubuque | Iowa | 19061 | 11276 | 148 |
927753 | 927753 | 2021-01-14 | Dubuque | Iowa | 19061 | 11229 | 148 |
924507 | 924507 | 2021-01-13 | Dubuque | Iowa | 19061 | 11204 | 146 |
921262 | 921262 | 2021-01-12 | Dubuque | Iowa | 19061 | 11138 | 146 |
918017 | 918017 | 2021-01-11 | Dubuque | Iowa | 19061 | 11112 | 142 |
914772 | 914772 | 2021-01-10 | Dubuque | Iowa | 19061 | 11087 | 142 |
911527 | 911527 | 2021-01-09 | Dubuque | Iowa | 19061 | 11079 | 141 |
908282 | 908282 | 2021-01-08 | Dubuque | Iowa | 19061 | 11036 | 140 |
905036 | 905036 | 2021-01-07 | Dubuque | Iowa | 19061 | 10952 | 140 |
901791 | 901791 | 2021-01-06 | Dubuque | Iowa | 19061 | 10866 | 140 |
898546 | 898546 | 2021-01-05 | Dubuque | Iowa | 19061 | 10787 | 139 |
895301 | 895301 | 2021-01-04 | Dubuque | Iowa | 19061 | 10744 | 139 |
892054 | 892054 | 2021-01-03 | Dubuque | Iowa | 19061 | 10719 | 139 |
888808 | 888808 | 2021-01-02 | Dubuque | Iowa | 19061 | 10683 | 139 |
885562 | 885562 | 2021-01-01 | Dubuque | Iowa | 19061 | 10653 | 136 |
882317 | 882317 | 2020-12-31 | Dubuque | Iowa | 19061 | 10615 | 136 |
879072 | 879072 | 2020-12-30 | Dubuque | Iowa | 19061 | 10568 | 135 |
875827 | 875827 | 2020-12-29 | Dubuque | Iowa | 19061 | 10554 | 135 |
872582 | 872582 | 2020-12-28 | Dubuque | Iowa | 19061 | 10482 | 135 |
869337 | 869337 | 2020-12-27 | Dubuque | Iowa | 19061 | 10452 | 135 |
866092 | 866092 | 2020-12-26 | Dubuque | Iowa | 19061 | 10439 | 135 |
862847 | 862847 | 2020-12-25 | Dubuque | Iowa | 19061 | 10428 | 135 |
859602 | 859602 | 2020-12-24 | Dubuque | Iowa | 19061 | 10400 | 135 |
856357 | 856357 | 2020-12-23 | Dubuque | Iowa | 19061 | 10345 | 135 |
853112 | 853112 | 2020-12-22 | Dubuque | Iowa | 19061 | 10308 | 135 |
849867 | 849867 | 2020-12-21 | Dubuque | Iowa | 19061 | 10266 | 133 |
846622 | 846622 | 2020-12-20 | Dubuque | Iowa | 19061 | 10235 | 133 |
843376 | 843376 | 2020-12-19 | Dubuque | Iowa | 19061 | 10233 | 131 |
840131 | 840131 | 2020-12-18 | Dubuque | Iowa | 19061 | 10193 | 129 |
836886 | 836886 | 2020-12-17 | Dubuque | Iowa | 19061 | 10148 | 129 |
833640 | 833640 | 2020-12-16 | Dubuque | Iowa | 19061 | 10109 | 126 |
830393 | 830393 | 2020-12-15 | Dubuque | Iowa | 19061 | 10037 | 126 |
827147 | 827147 | 2020-12-14 | Dubuque | Iowa | 19061 | 10008 | 125 |
823900 | 823900 | 2020-12-13 | Dubuque | Iowa | 19061 | 9984 | 123 |
820654 | 820654 | 2020-12-12 | Dubuque | Iowa | 19061 | 9940 | 123 |
817408 | 817408 | 2020-12-11 | Dubuque | Iowa | 19061 | 9891 | 123 |
814162 | 814162 | 2020-12-10 | Dubuque | Iowa | 19061 | 9828 | 123 |
810917 | 810917 | 2020-12-09 | Dubuque | Iowa | 19061 | 9762 | 119 |
807672 | 807672 | 2020-12-08 | Dubuque | Iowa | 19061 | 9699 | 115 |
804427 | 804427 | 2020-12-07 | Dubuque | Iowa | 19061 | 9680 | 101 |
801182 | 801182 | 2020-12-06 | Dubuque | Iowa | 19061 | 9656 | 101 |
797937 | 797937 | 2020-12-05 | Dubuque | Iowa | 19061 | 9618 | 100 |
794692 | 794692 | 2020-12-04 | Dubuque | Iowa | 19061 | 9547 | 100 |
791447 | 791447 | 2020-12-03 | Dubuque | Iowa | 19061 | 9479 | 99 |
788202 | 788202 | 2020-12-02 | Dubuque | Iowa | 19061 | 9415 | 94 |
784958 | 784958 | 2020-12-01 | Dubuque | Iowa | 19061 | 9342 | 93 |
781713 | 781713 | 2020-11-30 | Dubuque | Iowa | 19061 | 9272 | 91 |
778467 | 778467 | 2020-11-29 | Dubuque | Iowa | 19061 | 9234 | 91 |
775222 | 775222 | 2020-11-28 | Dubuque | Iowa | 19061 | 9181 | 91 |
771977 | 771977 | 2020-11-27 | Dubuque | Iowa | 19061 | 9134 | 91 |
768732 | 768732 | 2020-11-26 | Dubuque | Iowa | 19061 | 9077 | 91 |
765486 | 765486 | 2020-11-25 | Dubuque | Iowa | 19061 | 9040 | 91 |
762241 | 762241 | 2020-11-24 | Dubuque | Iowa | 19061 | 8865 | 90 |
758996 | 758996 | 2020-11-23 | Dubuque | Iowa | 19061 | 8792 | 90 |
755749 | 755749 | 2020-11-22 | Dubuque | Iowa | 19061 | 8664 | 90 |
752503 | 752503 | 2020-11-21 | Dubuque | Iowa | 19061 | 8580 | 90 |
749257 | 749257 | 2020-11-20 | Dubuque | Iowa | 19061 | 8476 | 89 |
746011 | 746011 | 2020-11-19 | Dubuque | Iowa | 19061 | 8323 | 89 |
742764 | 742764 | 2020-11-18 | Dubuque | Iowa | 19061 | 8200 | 88 |
739517 | 739517 | 2020-11-17 | Dubuque | Iowa | 19061 | 8068 | 86 |
736273 | 736273 | 2020-11-16 | Dubuque | Iowa | 19061 | 7885 | 84 |
733027 | 733027 | 2020-11-15 | Dubuque | Iowa | 19061 | 7835 | 79 |
729782 | 729782 | 2020-11-14 | Dubuque | Iowa | 19061 | 7744 | 78 |
726539 | 726539 | 2020-11-13 | Dubuque | Iowa | 19061 | 7600 | 78 |
723296 | 723296 | 2020-11-12 | Dubuque | Iowa | 19061 | 7388 | 77 |
720053 | 720053 | 2020-11-11 | Dubuque | Iowa | 19061 | 7218 | 76 |
716810 | 716810 | 2020-11-10 | Dubuque | Iowa | 19061 | 7135 | 74 |
713566 | 713566 | 2020-11-09 | Dubuque | Iowa | 19061 | 6943 | 73 |
710322 | 710322 | 2020-11-08 | Dubuque | Iowa | 19061 | 6881 | 69 |
707078 | 707078 | 2020-11-07 | Dubuque | Iowa | 19061 | 6662 | 69 |
703835 | 703835 | 2020-11-06 | Dubuque | Iowa | 19061 | 6477 | 67 |
700593 | 700593 | 2020-11-05 | Dubuque | Iowa | 19061 | 6333 | 66 |
697349 | 697349 | 2020-11-04 | Dubuque | Iowa | 19061 | 6127 | 65 |
694107 | 694107 | 2020-11-03 | Dubuque | Iowa | 19061 | 6038 | 63 |
690864 | 690864 | 2020-11-02 | Dubuque | Iowa | 19061 | 5934 | 62 |
687619 | 687619 | 2020-11-01 | Dubuque | Iowa | 19061 | 5857 | 61 |
684375 | 684375 | 2020-10-31 | Dubuque | Iowa | 19061 | 5769 | 59 |
681132 | 681132 | 2020-10-30 | Dubuque | Iowa | 19061 | 5645 | 59 |
677889 | 677889 | 2020-10-29 | Dubuque | Iowa | 19061 | 5511 | 58 |
674646 | 674646 | 2020-10-28 | Dubuque | Iowa | 19061 | 5397 | 58 |
671404 | 671404 | 2020-10-27 | Dubuque | Iowa | 19061 | 5310 | 58 |
668161 | 668161 | 2020-10-26 | Dubuque | Iowa | 19061 | 5211 | 57 |
664917 | 664917 | 2020-10-25 | Dubuque | Iowa | 19061 | 5186 | 57 |
661672 | 661672 | 2020-10-24 | Dubuque | Iowa | 19061 | 5116 | 57 |
658428 | 658428 | 2020-10-23 | Dubuque | Iowa | 19061 | 5030 | 57 |
655183 | 655183 | 2020-10-22 | Dubuque | Iowa | 19061 | 4936 | 55 |
651938 | 651938 | 2020-10-21 | Dubuque | Iowa | 19061 | 4809 | 54 |
648694 | 648694 | 2020-10-20 | Dubuque | Iowa | 19061 | 4764 | 54 |
645449 | 645449 | 2020-10-19 | Dubuque | Iowa | 19061 | 4679 | 52 |
642202 | 642202 | 2020-10-18 | Dubuque | Iowa | 19061 | 4638 | 52 |
638955 | 638955 | 2020-10-17 | Dubuque | Iowa | 19061 | 4601 | 52 |
635709 | 635709 | 2020-10-16 | Dubuque | Iowa | 19061 | 4528 | 52 |
632463 | 632463 | 2020-10-15 | Dubuque | Iowa | 19061 | 4441 | 52 |
629219 | 629219 | 2020-10-14 | Dubuque | Iowa | 19061 | 4341 | 50 |
625976 | 625976 | 2020-10-13 | Dubuque | Iowa | 19061 | 4273 | 50 |
622734 | 622734 | 2020-10-12 | Dubuque | Iowa | 19061 | 4183 | 50 |
619490 | 619490 | 2020-10-11 | Dubuque | Iowa | 19061 | 4157 | 48 |
616248 | 616248 | 2020-10-10 | Dubuque | Iowa | 19061 | 4108 | 47 |
613007 | 613007 | 2020-10-09 | Dubuque | Iowa | 19061 | 4037 | 47 |
609765 | 609765 | 2020-10-08 | Dubuque | Iowa | 19061 | 3940 | 47 |
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);