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 |
---|---|---|---|---|---|---|---|
1054331 | 1054331 | 2021-02-22 | Dubuque | Iowa | 19061 | 12202 | 192 |
1051084 | 1051084 | 2021-02-21 | Dubuque | Iowa | 19061 | 12202 | 191 |
1047837 | 1047837 | 2021-02-20 | Dubuque | Iowa | 19061 | 12202 | 191 |
1044592 | 1044592 | 2021-02-19 | Dubuque | Iowa | 19061 | 12202 | 191 |
1041347 | 1041347 | 2021-02-18 | Dubuque | Iowa | 19061 | 12194 | 190 |
1038102 | 1038102 | 2021-02-17 | Dubuque | Iowa | 19061 | 12179 | 190 |
1034857 | 1034857 | 2021-02-16 | Dubuque | Iowa | 19061 | 12153 | 189 |
1031611 | 1031611 | 2021-02-15 | Dubuque | Iowa | 19061 | 12133 | 187 |
1028364 | 1028364 | 2021-02-14 | Dubuque | Iowa | 19061 | 12126 | 187 |
1025119 | 1025119 | 2021-02-13 | Dubuque | Iowa | 19061 | 12118 | 187 |
1021874 | 1021874 | 2021-02-12 | Dubuque | Iowa | 19061 | 12106 | 187 |
1018629 | 1018629 | 2021-02-11 | Dubuque | Iowa | 19061 | 12068 | 186 |
1015384 | 1015384 | 2021-02-10 | Dubuque | Iowa | 19061 | 12058 | 186 |
1012139 | 1012139 | 2021-02-09 | Dubuque | Iowa | 19061 | 12034 | 187 |
1008893 | 1008893 | 2021-02-08 | Dubuque | Iowa | 19061 | 11991 | 186 |
1005647 | 1005647 | 2021-02-07 | Dubuque | Iowa | 19061 | 11966 | 185 |
1002401 | 1002401 | 2021-02-06 | Dubuque | Iowa | 19061 | 11958 | 185 |
999155 | 999155 | 2021-02-05 | Dubuque | Iowa | 19061 | 11944 | 184 |
995909 | 995909 | 2021-02-04 | Dubuque | Iowa | 19061 | 11935 | 181 |
992663 | 992663 | 2021-02-03 | Dubuque | Iowa | 19061 | 11911 | 177 |
989417 | 989417 | 2021-02-02 | Dubuque | Iowa | 19061 | 11872 | 177 |
986170 | 986170 | 2021-02-01 | Dubuque | Iowa | 19061 | 11837 | 176 |
982923 | 982923 | 2021-01-31 | Dubuque | Iowa | 19061 | 11830 | 176 |
979677 | 979677 | 2021-01-30 | Dubuque | Iowa | 19061 | 11821 | 166 |
976431 | 976431 | 2021-01-29 | Dubuque | Iowa | 19061 | 11780 | 162 |
973186 | 973186 | 2021-01-28 | Dubuque | Iowa | 19061 | 11760 | 160 |
969941 | 969941 | 2021-01-27 | Dubuque | Iowa | 19061 | 11743 | 161 |
966697 | 966697 | 2021-01-26 | Dubuque | Iowa | 19061 | 11678 | 159 |
963452 | 963452 | 2021-01-25 | Dubuque | Iowa | 19061 | 11650 | 159 |
960207 | 960207 | 2021-01-24 | Dubuque | Iowa | 19061 | 11625 | 159 |
956961 | 956961 | 2021-01-23 | Dubuque | Iowa | 19061 | 11615 | 159 |
953716 | 953716 | 2021-01-22 | Dubuque | Iowa | 19061 | 11535 | 159 |
950471 | 950471 | 2021-01-21 | Dubuque | Iowa | 19061 | 11504 | 157 |
947225 | 947225 | 2021-01-20 | Dubuque | Iowa | 19061 | 11434 | 153 |
943978 | 943978 | 2021-01-19 | Dubuque | Iowa | 19061 | 11387 | 150 |
940733 | 940733 | 2021-01-18 | Dubuque | Iowa | 19061 | 11348 | 150 |
937488 | 937488 | 2021-01-17 | Dubuque | Iowa | 19061 | 11311 | 150 |
934243 | 934243 | 2021-01-16 | Dubuque | Iowa | 19061 | 11301 | 149 |
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 |
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);