ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 19005 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054303 | 1054303 | 2021-02-22 | Allamakee | Iowa | 19005 | 1386 | 42 |
1051056 | 1051056 | 2021-02-21 | Allamakee | Iowa | 19005 | 1386 | 41 |
1047809 | 1047809 | 2021-02-20 | Allamakee | Iowa | 19005 | 1386 | 41 |
1044564 | 1044564 | 2021-02-19 | Allamakee | Iowa | 19005 | 1386 | 41 |
1041319 | 1041319 | 2021-02-18 | Allamakee | Iowa | 19005 | 1385 | 41 |
1038074 | 1038074 | 2021-02-17 | Allamakee | Iowa | 19005 | 1384 | 41 |
1034829 | 1034829 | 2021-02-16 | Allamakee | Iowa | 19005 | 1380 | 41 |
1031583 | 1031583 | 2021-02-15 | Allamakee | Iowa | 19005 | 1376 | 41 |
1028336 | 1028336 | 2021-02-14 | Allamakee | Iowa | 19005 | 1375 | 41 |
1025091 | 1025091 | 2021-02-13 | Allamakee | Iowa | 19005 | 1371 | 41 |
1021846 | 1021846 | 2021-02-12 | Allamakee | Iowa | 19005 | 1370 | 41 |
1018601 | 1018601 | 2021-02-11 | Allamakee | Iowa | 19005 | 1363 | 41 |
1015356 | 1015356 | 2021-02-10 | Allamakee | Iowa | 19005 | 1359 | 41 |
1012111 | 1012111 | 2021-02-09 | Allamakee | Iowa | 19005 | 1355 | 41 |
1008865 | 1008865 | 2021-02-08 | Allamakee | Iowa | 19005 | 1353 | 39 |
1005619 | 1005619 | 2021-02-07 | Allamakee | Iowa | 19005 | 1351 | 39 |
1002373 | 1002373 | 2021-02-06 | Allamakee | Iowa | 19005 | 1346 | 39 |
999127 | 999127 | 2021-02-05 | Allamakee | Iowa | 19005 | 1346 | 38 |
995881 | 995881 | 2021-02-04 | Allamakee | Iowa | 19005 | 1343 | 38 |
992635 | 992635 | 2021-02-03 | Allamakee | Iowa | 19005 | 1341 | 38 |
989389 | 989389 | 2021-02-02 | Allamakee | Iowa | 19005 | 1331 | 37 |
986142 | 986142 | 2021-02-01 | Allamakee | Iowa | 19005 | 1329 | 37 |
982895 | 982895 | 2021-01-31 | Allamakee | Iowa | 19005 | 1328 | 37 |
979649 | 979649 | 2021-01-30 | Allamakee | Iowa | 19005 | 1325 | 32 |
976403 | 976403 | 2021-01-29 | Allamakee | Iowa | 19005 | 1319 | 30 |
973158 | 973158 | 2021-01-28 | Allamakee | Iowa | 19005 | 1318 | 30 |
969913 | 969913 | 2021-01-27 | Allamakee | Iowa | 19005 | 1316 | 30 |
966669 | 966669 | 2021-01-26 | Allamakee | Iowa | 19005 | 1316 | 30 |
963424 | 963424 | 2021-01-25 | Allamakee | Iowa | 19005 | 1315 | 30 |
960179 | 960179 | 2021-01-24 | Allamakee | Iowa | 19005 | 1309 | 30 |
956933 | 956933 | 2021-01-23 | Allamakee | Iowa | 19005 | 1309 | 30 |
953688 | 953688 | 2021-01-22 | Allamakee | Iowa | 19005 | 1302 | 30 |
950443 | 950443 | 2021-01-21 | Allamakee | Iowa | 19005 | 1300 | 29 |
947197 | 947197 | 2021-01-20 | Allamakee | Iowa | 19005 | 1296 | 28 |
943950 | 943950 | 2021-01-19 | Allamakee | Iowa | 19005 | 1279 | 28 |
940705 | 940705 | 2021-01-18 | Allamakee | Iowa | 19005 | 1276 | 27 |
937460 | 937460 | 2021-01-17 | Allamakee | Iowa | 19005 | 1269 | 27 |
934215 | 934215 | 2021-01-16 | Allamakee | Iowa | 19005 | 1268 | 27 |
930970 | 930970 | 2021-01-15 | Allamakee | Iowa | 19005 | 1263 | 27 |
927725 | 927725 | 2021-01-14 | Allamakee | Iowa | 19005 | 1259 | 27 |
924479 | 924479 | 2021-01-13 | Allamakee | Iowa | 19005 | 1254 | 26 |
921234 | 921234 | 2021-01-12 | Allamakee | Iowa | 19005 | 1250 | 26 |
917989 | 917989 | 2021-01-11 | Allamakee | Iowa | 19005 | 1245 | 26 |
914744 | 914744 | 2021-01-10 | Allamakee | Iowa | 19005 | 1241 | 26 |
911499 | 911499 | 2021-01-09 | Allamakee | Iowa | 19005 | 1238 | 26 |
908254 | 908254 | 2021-01-08 | Allamakee | Iowa | 19005 | 1234 | 26 |
905008 | 905008 | 2021-01-07 | Allamakee | Iowa | 19005 | 1227 | 26 |
901763 | 901763 | 2021-01-06 | Allamakee | Iowa | 19005 | 1224 | 26 |
898518 | 898518 | 2021-01-05 | Allamakee | Iowa | 19005 | 1215 | 26 |
895273 | 895273 | 2021-01-04 | Allamakee | Iowa | 19005 | 1207 | 26 |
892026 | 892026 | 2021-01-03 | Allamakee | Iowa | 19005 | 1194 | 26 |
888780 | 888780 | 2021-01-02 | Allamakee | Iowa | 19005 | 1188 | 26 |
885534 | 885534 | 2021-01-01 | Allamakee | Iowa | 19005 | 1184 | 25 |
882289 | 882289 | 2020-12-31 | Allamakee | Iowa | 19005 | 1179 | 25 |
879044 | 879044 | 2020-12-30 | Allamakee | Iowa | 19005 | 1176 | 24 |
875799 | 875799 | 2020-12-29 | Allamakee | Iowa | 19005 | 1171 | 21 |
872554 | 872554 | 2020-12-28 | Allamakee | Iowa | 19005 | 1152 | 20 |
869309 | 869309 | 2020-12-27 | Allamakee | Iowa | 19005 | 1144 | 20 |
866064 | 866064 | 2020-12-26 | Allamakee | Iowa | 19005 | 1142 | 20 |
862819 | 862819 | 2020-12-25 | Allamakee | Iowa | 19005 | 1138 | 20 |
859574 | 859574 | 2020-12-24 | Allamakee | Iowa | 19005 | 1133 | 20 |
856329 | 856329 | 2020-12-23 | Allamakee | Iowa | 19005 | 1122 | 20 |
853084 | 853084 | 2020-12-22 | Allamakee | Iowa | 19005 | 1110 | 19 |
849839 | 849839 | 2020-12-21 | Allamakee | Iowa | 19005 | 1101 | 19 |
846594 | 846594 | 2020-12-20 | Allamakee | Iowa | 19005 | 1091 | 19 |
843348 | 843348 | 2020-12-19 | Allamakee | Iowa | 19005 | 1087 | 18 |
840103 | 840103 | 2020-12-18 | Allamakee | Iowa | 19005 | 1067 | 18 |
836858 | 836858 | 2020-12-17 | Allamakee | Iowa | 19005 | 1056 | 18 |
833612 | 833612 | 2020-12-16 | Allamakee | Iowa | 19005 | 1046 | 18 |
830365 | 830365 | 2020-12-15 | Allamakee | Iowa | 19005 | 1027 | 18 |
827119 | 827119 | 2020-12-14 | Allamakee | Iowa | 19005 | 1017 | 18 |
823872 | 823872 | 2020-12-13 | Allamakee | Iowa | 19005 | 1012 | 18 |
820626 | 820626 | 2020-12-12 | Allamakee | Iowa | 19005 | 1003 | 18 |
817380 | 817380 | 2020-12-11 | Allamakee | Iowa | 19005 | 995 | 17 |
814134 | 814134 | 2020-12-10 | Allamakee | Iowa | 19005 | 980 | 16 |
810889 | 810889 | 2020-12-09 | Allamakee | Iowa | 19005 | 964 | 16 |
807644 | 807644 | 2020-12-08 | Allamakee | Iowa | 19005 | 940 | 16 |
804399 | 804399 | 2020-12-07 | Allamakee | Iowa | 19005 | 939 | 13 |
801154 | 801154 | 2020-12-06 | Allamakee | Iowa | 19005 | 925 | 13 |
797909 | 797909 | 2020-12-05 | Allamakee | Iowa | 19005 | 922 | 13 |
794664 | 794664 | 2020-12-04 | Allamakee | Iowa | 19005 | 912 | 13 |
791419 | 791419 | 2020-12-03 | Allamakee | Iowa | 19005 | 884 | 13 |
788174 | 788174 | 2020-12-02 | Allamakee | Iowa | 19005 | 870 | 13 |
784930 | 784930 | 2020-12-01 | Allamakee | Iowa | 19005 | 850 | 11 |
781685 | 781685 | 2020-11-30 | Allamakee | Iowa | 19005 | 828 | 11 |
778439 | 778439 | 2020-11-29 | Allamakee | Iowa | 19005 | 818 | 11 |
775194 | 775194 | 2020-11-28 | Allamakee | Iowa | 19005 | 799 | 11 |
771949 | 771949 | 2020-11-27 | Allamakee | Iowa | 19005 | 790 | 11 |
768704 | 768704 | 2020-11-26 | Allamakee | Iowa | 19005 | 768 | 11 |
765458 | 765458 | 2020-11-25 | Allamakee | Iowa | 19005 | 764 | 11 |
762213 | 762213 | 2020-11-24 | Allamakee | Iowa | 19005 | 732 | 11 |
758968 | 758968 | 2020-11-23 | Allamakee | Iowa | 19005 | 724 | 11 |
755721 | 755721 | 2020-11-22 | Allamakee | Iowa | 19005 | 711 | 11 |
752475 | 752475 | 2020-11-21 | Allamakee | Iowa | 19005 | 695 | 11 |
749229 | 749229 | 2020-11-20 | Allamakee | Iowa | 19005 | 688 | 11 |
745983 | 745983 | 2020-11-19 | Allamakee | Iowa | 19005 | 674 | 11 |
742736 | 742736 | 2020-11-18 | Allamakee | Iowa | 19005 | 663 | 9 |
739489 | 739489 | 2020-11-17 | Allamakee | Iowa | 19005 | 640 | 9 |
736245 | 736245 | 2020-11-16 | Allamakee | Iowa | 19005 | 626 | 9 |
732999 | 732999 | 2020-11-15 | Allamakee | Iowa | 19005 | 609 | 9 |
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);