ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 19081 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054341 | 1054341 | 2021-02-22 | Hancock | Iowa | 19081 | 1362 | 29 |
1051094 | 1051094 | 2021-02-21 | Hancock | Iowa | 19081 | 1362 | 28 |
1047847 | 1047847 | 2021-02-20 | Hancock | Iowa | 19081 | 1362 | 28 |
1044602 | 1044602 | 2021-02-19 | Hancock | Iowa | 19081 | 1362 | 28 |
1041357 | 1041357 | 2021-02-18 | Hancock | Iowa | 19081 | 1363 | 28 |
1038112 | 1038112 | 2021-02-17 | Hancock | Iowa | 19081 | 1361 | 28 |
1034867 | 1034867 | 2021-02-16 | Hancock | Iowa | 19081 | 1361 | 27 |
1031621 | 1031621 | 2021-02-15 | Hancock | Iowa | 19081 | 1359 | 27 |
1028374 | 1028374 | 2021-02-14 | Hancock | Iowa | 19081 | 1358 | 27 |
1025129 | 1025129 | 2021-02-13 | Hancock | Iowa | 19081 | 1358 | 27 |
1021884 | 1021884 | 2021-02-12 | Hancock | Iowa | 19081 | 1356 | 27 |
1018639 | 1018639 | 2021-02-11 | Hancock | Iowa | 19081 | 1357 | 27 |
1015394 | 1015394 | 2021-02-10 | Hancock | Iowa | 19081 | 1356 | 27 |
1012149 | 1012149 | 2021-02-09 | Hancock | Iowa | 19081 | 1356 | 26 |
1008903 | 1008903 | 2021-02-08 | Hancock | Iowa | 19081 | 1355 | 26 |
1005657 | 1005657 | 2021-02-07 | Hancock | Iowa | 19081 | 1353 | 26 |
1002411 | 1002411 | 2021-02-06 | Hancock | Iowa | 19081 | 1350 | 26 |
999165 | 999165 | 2021-02-05 | Hancock | Iowa | 19081 | 1350 | 26 |
995919 | 995919 | 2021-02-04 | Hancock | Iowa | 19081 | 1349 | 25 |
992673 | 992673 | 2021-02-03 | Hancock | Iowa | 19081 | 1348 | 25 |
989427 | 989427 | 2021-02-02 | Hancock | Iowa | 19081 | 1345 | 25 |
986180 | 986180 | 2021-02-01 | Hancock | Iowa | 19081 | 1344 | 25 |
982933 | 982933 | 2021-01-31 | Hancock | Iowa | 19081 | 1345 | 25 |
979687 | 979687 | 2021-01-30 | Hancock | Iowa | 19081 | 1345 | 24 |
976441 | 976441 | 2021-01-29 | Hancock | Iowa | 19081 | 1344 | 24 |
973196 | 973196 | 2021-01-28 | Hancock | Iowa | 19081 | 1343 | 24 |
969951 | 969951 | 2021-01-27 | Hancock | Iowa | 19081 | 1333 | 24 |
966707 | 966707 | 2021-01-26 | Hancock | Iowa | 19081 | 1330 | 24 |
963462 | 963462 | 2021-01-25 | Hancock | Iowa | 19081 | 1324 | 24 |
960217 | 960217 | 2021-01-24 | Hancock | Iowa | 19081 | 1319 | 24 |
956971 | 956971 | 2021-01-23 | Hancock | Iowa | 19081 | 1315 | 24 |
953726 | 953726 | 2021-01-22 | Hancock | Iowa | 19081 | 1314 | 24 |
950481 | 950481 | 2021-01-21 | Hancock | Iowa | 19081 | 1308 | 24 |
947235 | 947235 | 2021-01-20 | Hancock | Iowa | 19081 | 1307 | 24 |
943988 | 943988 | 2021-01-19 | Hancock | Iowa | 19081 | 1302 | 24 |
940743 | 940743 | 2021-01-18 | Hancock | Iowa | 19081 | 1298 | 24 |
937498 | 937498 | 2021-01-17 | Hancock | Iowa | 19081 | 1289 | 24 |
934253 | 934253 | 2021-01-16 | Hancock | Iowa | 19081 | 1289 | 24 |
931008 | 931008 | 2021-01-15 | Hancock | Iowa | 19081 | 1285 | 24 |
927763 | 927763 | 2021-01-14 | Hancock | Iowa | 19081 | 1279 | 24 |
924517 | 924517 | 2021-01-13 | Hancock | Iowa | 19081 | 1274 | 24 |
921272 | 921272 | 2021-01-12 | Hancock | Iowa | 19081 | 1264 | 24 |
918027 | 918027 | 2021-01-11 | Hancock | Iowa | 19081 | 1258 | 24 |
914782 | 914782 | 2021-01-10 | Hancock | Iowa | 19081 | 1254 | 24 |
911537 | 911537 | 2021-01-09 | Hancock | Iowa | 19081 | 1250 | 24 |
908292 | 908292 | 2021-01-08 | Hancock | Iowa | 19081 | 1246 | 24 |
905046 | 905046 | 2021-01-07 | Hancock | Iowa | 19081 | 1236 | 24 |
901801 | 901801 | 2021-01-06 | Hancock | Iowa | 19081 | 1222 | 24 |
898556 | 898556 | 2021-01-05 | Hancock | Iowa | 19081 | 1208 | 24 |
895311 | 895311 | 2021-01-04 | Hancock | Iowa | 19081 | 1198 | 24 |
892064 | 892064 | 2021-01-03 | Hancock | Iowa | 19081 | 1189 | 24 |
888818 | 888818 | 2021-01-02 | Hancock | Iowa | 19081 | 1186 | 24 |
885572 | 885572 | 2021-01-01 | Hancock | Iowa | 19081 | 1183 | 24 |
882327 | 882327 | 2020-12-31 | Hancock | Iowa | 19081 | 1178 | 24 |
879082 | 879082 | 2020-12-30 | Hancock | Iowa | 19081 | 1171 | 24 |
875837 | 875837 | 2020-12-29 | Hancock | Iowa | 19081 | 1155 | 24 |
872592 | 872592 | 2020-12-28 | Hancock | Iowa | 19081 | 1151 | 24 |
869347 | 869347 | 2020-12-27 | Hancock | Iowa | 19081 | 1150 | 24 |
866102 | 866102 | 2020-12-26 | Hancock | Iowa | 19081 | 1146 | 24 |
862857 | 862857 | 2020-12-25 | Hancock | Iowa | 19081 | 1145 | 24 |
859612 | 859612 | 2020-12-24 | Hancock | Iowa | 19081 | 1140 | 24 |
856367 | 856367 | 2020-12-23 | Hancock | Iowa | 19081 | 1138 | 24 |
853122 | 853122 | 2020-12-22 | Hancock | Iowa | 19081 | 1123 | 24 |
849877 | 849877 | 2020-12-21 | Hancock | Iowa | 19081 | 1115 | 23 |
846632 | 846632 | 2020-12-20 | Hancock | Iowa | 19081 | 1102 | 23 |
843386 | 843386 | 2020-12-19 | Hancock | Iowa | 19081 | 1099 | 23 |
840141 | 840141 | 2020-12-18 | Hancock | Iowa | 19081 | 1088 | 22 |
836896 | 836896 | 2020-12-17 | Hancock | Iowa | 19081 | 1068 | 22 |
833650 | 833650 | 2020-12-16 | Hancock | Iowa | 19081 | 1064 | 21 |
830403 | 830403 | 2020-12-15 | Hancock | Iowa | 19081 | 1054 | 21 |
827157 | 827157 | 2020-12-14 | Hancock | Iowa | 19081 | 1022 | 21 |
823910 | 823910 | 2020-12-13 | Hancock | Iowa | 19081 | 1015 | 21 |
820664 | 820664 | 2020-12-12 | Hancock | Iowa | 19081 | 1013 | 21 |
817418 | 817418 | 2020-12-11 | Hancock | Iowa | 19081 | 1007 | 21 |
814172 | 814172 | 2020-12-10 | Hancock | Iowa | 19081 | 985 | 19 |
810927 | 810927 | 2020-12-09 | Hancock | Iowa | 19081 | 972 | 19 |
807682 | 807682 | 2020-12-08 | Hancock | Iowa | 19081 | 960 | 19 |
804437 | 804437 | 2020-12-07 | Hancock | Iowa | 19081 | 958 | 8 |
801192 | 801192 | 2020-12-06 | Hancock | Iowa | 19081 | 944 | 8 |
797947 | 797947 | 2020-12-05 | Hancock | Iowa | 19081 | 941 | 8 |
794702 | 794702 | 2020-12-04 | Hancock | Iowa | 19081 | 930 | 8 |
791457 | 791457 | 2020-12-03 | Hancock | Iowa | 19081 | 914 | 8 |
788212 | 788212 | 2020-12-02 | Hancock | Iowa | 19081 | 900 | 8 |
784968 | 784968 | 2020-12-01 | Hancock | Iowa | 19081 | 882 | 7 |
781723 | 781723 | 2020-11-30 | Hancock | Iowa | 19081 | 873 | 7 |
778477 | 778477 | 2020-11-29 | Hancock | Iowa | 19081 | 867 | 7 |
775232 | 775232 | 2020-11-28 | Hancock | Iowa | 19081 | 859 | 7 |
771987 | 771987 | 2020-11-27 | Hancock | Iowa | 19081 | 854 | 7 |
768742 | 768742 | 2020-11-26 | Hancock | Iowa | 19081 | 849 | 7 |
765496 | 765496 | 2020-11-25 | Hancock | Iowa | 19081 | 841 | 7 |
762251 | 762251 | 2020-11-24 | Hancock | Iowa | 19081 | 821 | 7 |
759006 | 759006 | 2020-11-23 | Hancock | Iowa | 19081 | 806 | 7 |
755759 | 755759 | 2020-11-22 | Hancock | Iowa | 19081 | 794 | 7 |
752513 | 752513 | 2020-11-21 | Hancock | Iowa | 19081 | 787 | 7 |
749267 | 749267 | 2020-11-20 | Hancock | Iowa | 19081 | 773 | 7 |
746021 | 746021 | 2020-11-19 | Hancock | Iowa | 19081 | 750 | 7 |
742774 | 742774 | 2020-11-18 | Hancock | Iowa | 19081 | 733 | 6 |
739527 | 739527 | 2020-11-17 | Hancock | Iowa | 19081 | 701 | 6 |
736283 | 736283 | 2020-11-16 | Hancock | Iowa | 19081 | 687 | 6 |
733037 | 733037 | 2020-11-15 | Hancock | Iowa | 19081 | 671 | 6 |
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);