ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Black Hawk" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054307 | 1054307 | 2021-02-22 | Black Hawk | Iowa | 19013 | 14757 | 285 |
1051060 | 1051060 | 2021-02-21 | Black Hawk | Iowa | 19013 | 14757 | 284 |
1047813 | 1047813 | 2021-02-20 | Black Hawk | Iowa | 19013 | 14757 | 284 |
1044568 | 1044568 | 2021-02-19 | Black Hawk | Iowa | 19013 | 14757 | 284 |
1041323 | 1041323 | 2021-02-18 | Black Hawk | Iowa | 19013 | 14748 | 280 |
1038078 | 1038078 | 2021-02-17 | Black Hawk | Iowa | 19013 | 14729 | 279 |
1034833 | 1034833 | 2021-02-16 | Black Hawk | Iowa | 19013 | 14722 | 277 |
1031587 | 1031587 | 2021-02-15 | Black Hawk | Iowa | 19013 | 14707 | 275 |
1028340 | 1028340 | 2021-02-14 | Black Hawk | Iowa | 19013 | 14698 | 275 |
1025095 | 1025095 | 2021-02-13 | Black Hawk | Iowa | 19013 | 14691 | 275 |
1021850 | 1021850 | 2021-02-12 | Black Hawk | Iowa | 19013 | 14678 | 274 |
1018605 | 1018605 | 2021-02-11 | Black Hawk | Iowa | 19013 | 14636 | 271 |
1015360 | 1015360 | 2021-02-10 | Black Hawk | Iowa | 19013 | 14627 | 270 |
1012115 | 1012115 | 2021-02-09 | Black Hawk | Iowa | 19013 | 14598 | 267 |
1008869 | 1008869 | 2021-02-08 | Black Hawk | Iowa | 19013 | 14567 | 265 |
1005623 | 1005623 | 2021-02-07 | Black Hawk | Iowa | 19013 | 14554 | 265 |
1002377 | 1002377 | 2021-02-06 | Black Hawk | Iowa | 19013 | 14548 | 265 |
999131 | 999131 | 2021-02-05 | Black Hawk | Iowa | 19013 | 14518 | 265 |
995885 | 995885 | 2021-02-04 | Black Hawk | Iowa | 19013 | 14499 | 264 |
992639 | 992639 | 2021-02-03 | Black Hawk | Iowa | 19013 | 14468 | 263 |
989393 | 989393 | 2021-02-02 | Black Hawk | Iowa | 19013 | 14433 | 261 |
986146 | 986146 | 2021-02-01 | Black Hawk | Iowa | 19013 | 14387 | 261 |
982899 | 982899 | 2021-01-31 | Black Hawk | Iowa | 19013 | 14374 | 259 |
979653 | 979653 | 2021-01-30 | Black Hawk | Iowa | 19013 | 14371 | 248 |
976407 | 976407 | 2021-01-29 | Black Hawk | Iowa | 19013 | 14296 | 248 |
973162 | 973162 | 2021-01-28 | Black Hawk | Iowa | 19013 | 14276 | 246 |
969917 | 969917 | 2021-01-27 | Black Hawk | Iowa | 19013 | 14235 | 243 |
966673 | 966673 | 2021-01-26 | Black Hawk | Iowa | 19013 | 14184 | 243 |
963428 | 963428 | 2021-01-25 | Black Hawk | Iowa | 19013 | 14123 | 243 |
960183 | 960183 | 2021-01-24 | Black Hawk | Iowa | 19013 | 14090 | 243 |
956937 | 956937 | 2021-01-23 | Black Hawk | Iowa | 19013 | 14076 | 243 |
953692 | 953692 | 2021-01-22 | Black Hawk | Iowa | 19013 | 14037 | 243 |
950447 | 950447 | 2021-01-21 | Black Hawk | Iowa | 19013 | 13962 | 242 |
947201 | 947201 | 2021-01-20 | Black Hawk | Iowa | 19013 | 13875 | 238 |
943954 | 943954 | 2021-01-19 | Black Hawk | Iowa | 19013 | 13773 | 236 |
940709 | 940709 | 2021-01-18 | Black Hawk | Iowa | 19013 | 13694 | 236 |
937464 | 937464 | 2021-01-17 | Black Hawk | Iowa | 19013 | 13660 | 236 |
934219 | 934219 | 2021-01-16 | Black Hawk | Iowa | 19013 | 13647 | 236 |
930974 | 930974 | 2021-01-15 | Black Hawk | Iowa | 19013 | 13615 | 228 |
927729 | 927729 | 2021-01-14 | Black Hawk | Iowa | 19013 | 13550 | 228 |
924483 | 924483 | 2021-01-13 | Black Hawk | Iowa | 19013 | 13485 | 228 |
921238 | 921238 | 2021-01-12 | Black Hawk | Iowa | 19013 | 13392 | 228 |
917993 | 917993 | 2021-01-11 | Black Hawk | Iowa | 19013 | 13320 | 225 |
914748 | 914748 | 2021-01-10 | Black Hawk | Iowa | 19013 | 13294 | 225 |
911503 | 911503 | 2021-01-09 | Black Hawk | Iowa | 19013 | 13281 | 224 |
908258 | 908258 | 2021-01-08 | Black Hawk | Iowa | 19013 | 13235 | 224 |
905012 | 905012 | 2021-01-07 | Black Hawk | Iowa | 19013 | 13147 | 222 |
901767 | 901767 | 2021-01-06 | Black Hawk | Iowa | 19013 | 13067 | 222 |
898522 | 898522 | 2021-01-05 | Black Hawk | Iowa | 19013 | 12989 | 220 |
895277 | 895277 | 2021-01-04 | Black Hawk | Iowa | 19013 | 12938 | 220 |
892030 | 892030 | 2021-01-03 | Black Hawk | Iowa | 19013 | 12903 | 220 |
888784 | 888784 | 2021-01-02 | Black Hawk | Iowa | 19013 | 12862 | 220 |
885538 | 885538 | 2021-01-01 | Black Hawk | Iowa | 19013 | 12820 | 218 |
882293 | 882293 | 2020-12-31 | Black Hawk | Iowa | 19013 | 12788 | 218 |
879048 | 879048 | 2020-12-30 | Black Hawk | Iowa | 19013 | 12730 | 218 |
875803 | 875803 | 2020-12-29 | Black Hawk | Iowa | 19013 | 12671 | 218 |
872558 | 872558 | 2020-12-28 | Black Hawk | Iowa | 19013 | 12588 | 215 |
869313 | 869313 | 2020-12-27 | Black Hawk | Iowa | 19013 | 12538 | 215 |
866068 | 866068 | 2020-12-26 | Black Hawk | Iowa | 19013 | 12518 | 215 |
862823 | 862823 | 2020-12-25 | Black Hawk | Iowa | 19013 | 12500 | 215 |
859578 | 859578 | 2020-12-24 | Black Hawk | Iowa | 19013 | 12480 | 214 |
856333 | 856333 | 2020-12-23 | Black Hawk | Iowa | 19013 | 12394 | 211 |
853088 | 853088 | 2020-12-22 | Black Hawk | Iowa | 19013 | 12307 | 210 |
849843 | 849843 | 2020-12-21 | Black Hawk | Iowa | 19013 | 12269 | 207 |
846598 | 846598 | 2020-12-20 | Black Hawk | Iowa | 19013 | 12225 | 207 |
843352 | 843352 | 2020-12-19 | Black Hawk | Iowa | 19013 | 12209 | 204 |
840107 | 840107 | 2020-12-18 | Black Hawk | Iowa | 19013 | 12114 | 200 |
836862 | 836862 | 2020-12-17 | Black Hawk | Iowa | 19013 | 12004 | 200 |
833616 | 833616 | 2020-12-16 | Black Hawk | Iowa | 19013 | 11950 | 195 |
830369 | 830369 | 2020-12-15 | Black Hawk | Iowa | 19013 | 11882 | 193 |
827123 | 827123 | 2020-12-14 | Black Hawk | Iowa | 19013 | 11845 | 189 |
823876 | 823876 | 2020-12-13 | Black Hawk | Iowa | 19013 | 11839 | 184 |
820630 | 820630 | 2020-12-12 | Black Hawk | Iowa | 19013 | 11802 | 184 |
817384 | 817384 | 2020-12-11 | Black Hawk | Iowa | 19013 | 11747 | 183 |
814138 | 814138 | 2020-12-10 | Black Hawk | Iowa | 19013 | 11664 | 178 |
810893 | 810893 | 2020-12-09 | Black Hawk | Iowa | 19013 | 11581 | 169 |
807648 | 807648 | 2020-12-08 | Black Hawk | Iowa | 19013 | 11502 | 161 |
804403 | 804403 | 2020-12-07 | Black Hawk | Iowa | 19013 | 11488 | 156 |
801158 | 801158 | 2020-12-06 | Black Hawk | Iowa | 19013 | 11453 | 156 |
797913 | 797913 | 2020-12-05 | Black Hawk | Iowa | 19013 | 11403 | 152 |
794668 | 794668 | 2020-12-04 | Black Hawk | Iowa | 19013 | 11350 | 149 |
791423 | 791423 | 2020-12-03 | Black Hawk | Iowa | 19013 | 11287 | 147 |
788178 | 788178 | 2020-12-02 | Black Hawk | Iowa | 19013 | 11194 | 139 |
784934 | 784934 | 2020-12-01 | Black Hawk | Iowa | 19013 | 11130 | 137 |
781689 | 781689 | 2020-11-30 | Black Hawk | Iowa | 19013 | 10968 | 137 |
778443 | 778443 | 2020-11-29 | Black Hawk | Iowa | 19013 | 10892 | 135 |
775198 | 775198 | 2020-11-28 | Black Hawk | Iowa | 19013 | 10849 | 134 |
771953 | 771953 | 2020-11-27 | Black Hawk | Iowa | 19013 | 10796 | 134 |
768708 | 768708 | 2020-11-26 | Black Hawk | Iowa | 19013 | 10730 | 134 |
765462 | 765462 | 2020-11-25 | Black Hawk | Iowa | 19013 | 10629 | 132 |
762217 | 762217 | 2020-11-24 | Black Hawk | Iowa | 19013 | 10541 | 131 |
758972 | 758972 | 2020-11-23 | Black Hawk | Iowa | 19013 | 10394 | 127 |
755725 | 755725 | 2020-11-22 | Black Hawk | Iowa | 19013 | 10209 | 126 |
752479 | 752479 | 2020-11-21 | Black Hawk | Iowa | 19013 | 10145 | 126 |
749233 | 749233 | 2020-11-20 | Black Hawk | Iowa | 19013 | 10006 | 125 |
745987 | 745987 | 2020-11-19 | Black Hawk | Iowa | 19013 | 9804 | 125 |
742740 | 742740 | 2020-11-18 | Black Hawk | Iowa | 19013 | 9616 | 124 |
739493 | 739493 | 2020-11-17 | Black Hawk | Iowa | 19013 | 9414 | 122 |
736249 | 736249 | 2020-11-16 | Black Hawk | Iowa | 19013 | 9272 | 118 |
733003 | 733003 | 2020-11-15 | Black Hawk | Iowa | 19013 | 9125 | 116 |
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);