ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 19085 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054343 | 1054343 | 2021-02-22 | Harrison | Iowa | 19085 | 1650 | 69 |
1051096 | 1051096 | 2021-02-21 | Harrison | Iowa | 19085 | 1650 | 68 |
1047849 | 1047849 | 2021-02-20 | Harrison | Iowa | 19085 | 1650 | 68 |
1044604 | 1044604 | 2021-02-19 | Harrison | Iowa | 19085 | 1650 | 68 |
1041359 | 1041359 | 2021-02-18 | Harrison | Iowa | 19085 | 1650 | 68 |
1038114 | 1038114 | 2021-02-17 | Harrison | Iowa | 19085 | 1650 | 68 |
1034869 | 1034869 | 2021-02-16 | Harrison | Iowa | 19085 | 1649 | 68 |
1031623 | 1031623 | 2021-02-15 | Harrison | Iowa | 19085 | 1645 | 68 |
1028376 | 1028376 | 2021-02-14 | Harrison | Iowa | 19085 | 1646 | 68 |
1025131 | 1025131 | 2021-02-13 | Harrison | Iowa | 19085 | 1645 | 68 |
1021886 | 1021886 | 2021-02-12 | Harrison | Iowa | 19085 | 1644 | 68 |
1018641 | 1018641 | 2021-02-11 | Harrison | Iowa | 19085 | 1640 | 68 |
1015396 | 1015396 | 2021-02-10 | Harrison | Iowa | 19085 | 1640 | 67 |
1012151 | 1012151 | 2021-02-09 | Harrison | Iowa | 19085 | 1637 | 67 |
1008905 | 1008905 | 2021-02-08 | Harrison | Iowa | 19085 | 1636 | 67 |
1005659 | 1005659 | 2021-02-07 | Harrison | Iowa | 19085 | 1633 | 67 |
1002413 | 1002413 | 2021-02-06 | Harrison | Iowa | 19085 | 1631 | 67 |
999167 | 999167 | 2021-02-05 | Harrison | Iowa | 19085 | 1631 | 67 |
995921 | 995921 | 2021-02-04 | Harrison | Iowa | 19085 | 1627 | 67 |
992675 | 992675 | 2021-02-03 | Harrison | Iowa | 19085 | 1625 | 67 |
989429 | 989429 | 2021-02-02 | Harrison | Iowa | 19085 | 1618 | 65 |
986182 | 986182 | 2021-02-01 | Harrison | Iowa | 19085 | 1613 | 65 |
982935 | 982935 | 2021-01-31 | Harrison | Iowa | 19085 | 1612 | 65 |
979689 | 979689 | 2021-01-30 | Harrison | Iowa | 19085 | 1610 | 65 |
976443 | 976443 | 2021-01-29 | Harrison | Iowa | 19085 | 1605 | 64 |
973198 | 973198 | 2021-01-28 | Harrison | Iowa | 19085 | 1600 | 63 |
969953 | 969953 | 2021-01-27 | Harrison | Iowa | 19085 | 1592 | 62 |
966709 | 966709 | 2021-01-26 | Harrison | Iowa | 19085 | 1591 | 62 |
963464 | 963464 | 2021-01-25 | Harrison | Iowa | 19085 | 1587 | 62 |
960219 | 960219 | 2021-01-24 | Harrison | Iowa | 19085 | 1585 | 62 |
956973 | 956973 | 2021-01-23 | Harrison | Iowa | 19085 | 1581 | 62 |
953728 | 953728 | 2021-01-22 | Harrison | Iowa | 19085 | 1579 | 62 |
950483 | 950483 | 2021-01-21 | Harrison | Iowa | 19085 | 1573 | 62 |
947237 | 947237 | 2021-01-20 | Harrison | Iowa | 19085 | 1567 | 62 |
943990 | 943990 | 2021-01-19 | Harrison | Iowa | 19085 | 1551 | 62 |
940745 | 940745 | 2021-01-18 | Harrison | Iowa | 19085 | 1548 | 62 |
937500 | 937500 | 2021-01-17 | Harrison | Iowa | 19085 | 1547 | 62 |
934255 | 934255 | 2021-01-16 | Harrison | Iowa | 19085 | 1544 | 62 |
931010 | 931010 | 2021-01-15 | Harrison | Iowa | 19085 | 1538 | 62 |
927765 | 927765 | 2021-01-14 | Harrison | Iowa | 19085 | 1529 | 61 |
924519 | 924519 | 2021-01-13 | Harrison | Iowa | 19085 | 1522 | 61 |
921274 | 921274 | 2021-01-12 | Harrison | Iowa | 19085 | 1516 | 61 |
918029 | 918029 | 2021-01-11 | Harrison | Iowa | 19085 | 1515 | 60 |
914784 | 914784 | 2021-01-10 | Harrison | Iowa | 19085 | 1509 | 60 |
911539 | 911539 | 2021-01-09 | Harrison | Iowa | 19085 | 1506 | 60 |
908294 | 908294 | 2021-01-08 | Harrison | Iowa | 19085 | 1501 | 59 |
905048 | 905048 | 2021-01-07 | Harrison | Iowa | 19085 | 1492 | 59 |
901803 | 901803 | 2021-01-06 | Harrison | Iowa | 19085 | 1482 | 59 |
898558 | 898558 | 2021-01-05 | Harrison | Iowa | 19085 | 1467 | 59 |
895313 | 895313 | 2021-01-04 | Harrison | Iowa | 19085 | 1464 | 59 |
892066 | 892066 | 2021-01-03 | Harrison | Iowa | 19085 | 1460 | 58 |
888820 | 888820 | 2021-01-02 | Harrison | Iowa | 19085 | 1458 | 58 |
885574 | 885574 | 2021-01-01 | Harrison | Iowa | 19085 | 1446 | 53 |
882329 | 882329 | 2020-12-31 | Harrison | Iowa | 19085 | 1443 | 53 |
879084 | 879084 | 2020-12-30 | Harrison | Iowa | 19085 | 1430 | 52 |
875839 | 875839 | 2020-12-29 | Harrison | Iowa | 19085 | 1412 | 52 |
872594 | 872594 | 2020-12-28 | Harrison | Iowa | 19085 | 1407 | 52 |
869349 | 869349 | 2020-12-27 | Harrison | Iowa | 19085 | 1398 | 52 |
866104 | 866104 | 2020-12-26 | Harrison | Iowa | 19085 | 1397 | 52 |
862859 | 862859 | 2020-12-25 | Harrison | Iowa | 19085 | 1389 | 52 |
859614 | 859614 | 2020-12-24 | Harrison | Iowa | 19085 | 1386 | 52 |
856369 | 856369 | 2020-12-23 | Harrison | Iowa | 19085 | 1379 | 52 |
853124 | 853124 | 2020-12-22 | Harrison | Iowa | 19085 | 1357 | 52 |
849879 | 849879 | 2020-12-21 | Harrison | Iowa | 19085 | 1341 | 51 |
846634 | 846634 | 2020-12-20 | Harrison | Iowa | 19085 | 1329 | 51 |
843388 | 843388 | 2020-12-19 | Harrison | Iowa | 19085 | 1326 | 51 |
840143 | 840143 | 2020-12-18 | Harrison | Iowa | 19085 | 1306 | 50 |
836898 | 836898 | 2020-12-17 | Harrison | Iowa | 19085 | 1297 | 50 |
833652 | 833652 | 2020-12-16 | Harrison | Iowa | 19085 | 1289 | 50 |
830405 | 830405 | 2020-12-15 | Harrison | Iowa | 19085 | 1264 | 49 |
827159 | 827159 | 2020-12-14 | Harrison | Iowa | 19085 | 1252 | 49 |
823912 | 823912 | 2020-12-13 | Harrison | Iowa | 19085 | 1245 | 49 |
820666 | 820666 | 2020-12-12 | Harrison | Iowa | 19085 | 1232 | 49 |
817420 | 817420 | 2020-12-11 | Harrison | Iowa | 19085 | 1214 | 49 |
814174 | 814174 | 2020-12-10 | Harrison | Iowa | 19085 | 1199 | 48 |
810929 | 810929 | 2020-12-09 | Harrison | Iowa | 19085 | 1179 | 47 |
807684 | 807684 | 2020-12-08 | Harrison | Iowa | 19085 | 1171 | 46 |
804439 | 804439 | 2020-12-07 | Harrison | Iowa | 19085 | 1170 | 33 |
801194 | 801194 | 2020-12-06 | Harrison | Iowa | 19085 | 1164 | 33 |
797949 | 797949 | 2020-12-05 | Harrison | Iowa | 19085 | 1157 | 32 |
794704 | 794704 | 2020-12-04 | Harrison | Iowa | 19085 | 1149 | 32 |
791459 | 791459 | 2020-12-03 | Harrison | Iowa | 19085 | 1134 | 32 |
788214 | 788214 | 2020-12-02 | Harrison | Iowa | 19085 | 1108 | 32 |
784970 | 784970 | 2020-12-01 | Harrison | Iowa | 19085 | 1101 | 30 |
781725 | 781725 | 2020-11-30 | Harrison | Iowa | 19085 | 1086 | 30 |
778479 | 778479 | 2020-11-29 | Harrison | Iowa | 19085 | 1077 | 29 |
775234 | 775234 | 2020-11-28 | Harrison | Iowa | 19085 | 1067 | 29 |
771989 | 771989 | 2020-11-27 | Harrison | Iowa | 19085 | 1066 | 29 |
768744 | 768744 | 2020-11-26 | Harrison | Iowa | 19085 | 1061 | 29 |
765498 | 765498 | 2020-11-25 | Harrison | Iowa | 19085 | 1043 | 28 |
762253 | 762253 | 2020-11-24 | Harrison | Iowa | 19085 | 1024 | 28 |
759008 | 759008 | 2020-11-23 | Harrison | Iowa | 19085 | 1023 | 28 |
755761 | 755761 | 2020-11-22 | Harrison | Iowa | 19085 | 1014 | 28 |
752515 | 752515 | 2020-11-21 | Harrison | Iowa | 19085 | 1002 | 28 |
749269 | 749269 | 2020-11-20 | Harrison | Iowa | 19085 | 991 | 27 |
746023 | 746023 | 2020-11-19 | Harrison | Iowa | 19085 | 967 | 26 |
742776 | 742776 | 2020-11-18 | Harrison | Iowa | 19085 | 952 | 26 |
739529 | 739529 | 2020-11-17 | Harrison | Iowa | 19085 | 936 | 26 |
736285 | 736285 | 2020-11-16 | Harrison | Iowa | 19085 | 930 | 25 |
733039 | 733039 | 2020-11-15 | Harrison | Iowa | 19085 | 900 | 24 |
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);