ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 19049 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054325 | 1054325 | 2021-02-22 | Dallas | Iowa | 19049 | 9905 | 89 |
1051078 | 1051078 | 2021-02-21 | Dallas | Iowa | 19049 | 9905 | 88 |
1047831 | 1047831 | 2021-02-20 | Dallas | Iowa | 19049 | 9905 | 88 |
1044586 | 1044586 | 2021-02-19 | Dallas | Iowa | 19049 | 9905 | 88 |
1041341 | 1041341 | 2021-02-18 | Dallas | Iowa | 19049 | 9897 | 88 |
1038096 | 1038096 | 2021-02-17 | Dallas | Iowa | 19049 | 9875 | 87 |
1034851 | 1034851 | 2021-02-16 | Dallas | Iowa | 19049 | 9852 | 86 |
1031605 | 1031605 | 2021-02-15 | Dallas | Iowa | 19049 | 9816 | 85 |
1028358 | 1028358 | 2021-02-14 | Dallas | Iowa | 19049 | 9786 | 85 |
1025113 | 1025113 | 2021-02-13 | Dallas | Iowa | 19049 | 9782 | 85 |
1021868 | 1021868 | 2021-02-12 | Dallas | Iowa | 19049 | 9764 | 84 |
1018623 | 1018623 | 2021-02-11 | Dallas | Iowa | 19049 | 9712 | 84 |
1015378 | 1015378 | 2021-02-10 | Dallas | Iowa | 19049 | 9692 | 84 |
1012133 | 1012133 | 2021-02-09 | Dallas | Iowa | 19049 | 9654 | 84 |
1008887 | 1008887 | 2021-02-08 | Dallas | Iowa | 19049 | 9604 | 84 |
1005641 | 1005641 | 2021-02-07 | Dallas | Iowa | 19049 | 9565 | 84 |
1002395 | 1002395 | 2021-02-06 | Dallas | Iowa | 19049 | 9556 | 84 |
999149 | 999149 | 2021-02-05 | Dallas | Iowa | 19049 | 9537 | 84 |
995903 | 995903 | 2021-02-04 | Dallas | Iowa | 19049 | 9512 | 84 |
992657 | 992657 | 2021-02-03 | Dallas | Iowa | 19049 | 9466 | 79 |
989411 | 989411 | 2021-02-02 | Dallas | Iowa | 19049 | 9426 | 78 |
986164 | 986164 | 2021-02-01 | Dallas | Iowa | 19049 | 9375 | 78 |
982917 | 982917 | 2021-01-31 | Dallas | Iowa | 19049 | 9337 | 78 |
979671 | 979671 | 2021-01-30 | Dallas | Iowa | 19049 | 9320 | 74 |
976425 | 976425 | 2021-01-29 | Dallas | Iowa | 19049 | 9275 | 72 |
973180 | 973180 | 2021-01-28 | Dallas | Iowa | 19049 | 9249 | 72 |
969935 | 969935 | 2021-01-27 | Dallas | Iowa | 19049 | 9203 | 72 |
966691 | 966691 | 2021-01-26 | Dallas | Iowa | 19049 | 9154 | 72 |
963446 | 963446 | 2021-01-25 | Dallas | Iowa | 19049 | 9107 | 72 |
960201 | 960201 | 2021-01-24 | Dallas | Iowa | 19049 | 9089 | 72 |
956955 | 956955 | 2021-01-23 | Dallas | Iowa | 19049 | 9077 | 72 |
953710 | 953710 | 2021-01-22 | Dallas | Iowa | 19049 | 9059 | 72 |
950465 | 950465 | 2021-01-21 | Dallas | Iowa | 19049 | 9017 | 72 |
947219 | 947219 | 2021-01-20 | Dallas | Iowa | 19049 | 8965 | 72 |
943972 | 943972 | 2021-01-19 | Dallas | Iowa | 19049 | 8887 | 71 |
940727 | 940727 | 2021-01-18 | Dallas | Iowa | 19049 | 8852 | 71 |
937482 | 937482 | 2021-01-17 | Dallas | Iowa | 19049 | 8820 | 71 |
934237 | 934237 | 2021-01-16 | Dallas | Iowa | 19049 | 8813 | 71 |
930992 | 930992 | 2021-01-15 | Dallas | Iowa | 19049 | 8794 | 69 |
927747 | 927747 | 2021-01-14 | Dallas | Iowa | 19049 | 8742 | 69 |
924501 | 924501 | 2021-01-13 | Dallas | Iowa | 19049 | 8675 | 69 |
921256 | 921256 | 2021-01-12 | Dallas | Iowa | 19049 | 8616 | 69 |
918011 | 918011 | 2021-01-11 | Dallas | Iowa | 19049 | 8547 | 67 |
914766 | 914766 | 2021-01-10 | Dallas | Iowa | 19049 | 8488 | 67 |
911521 | 911521 | 2021-01-09 | Dallas | Iowa | 19049 | 8479 | 67 |
908276 | 908276 | 2021-01-08 | Dallas | Iowa | 19049 | 8413 | 66 |
905030 | 905030 | 2021-01-07 | Dallas | Iowa | 19049 | 8349 | 66 |
901785 | 901785 | 2021-01-06 | Dallas | Iowa | 19049 | 8248 | 66 |
898540 | 898540 | 2021-01-05 | Dallas | Iowa | 19049 | 8181 | 66 |
895295 | 895295 | 2021-01-04 | Dallas | Iowa | 19049 | 8089 | 67 |
892048 | 892048 | 2021-01-03 | Dallas | Iowa | 19049 | 8028 | 67 |
888802 | 888802 | 2021-01-02 | Dallas | Iowa | 19049 | 8000 | 67 |
885556 | 885556 | 2021-01-01 | Dallas | Iowa | 19049 | 7983 | 66 |
882311 | 882311 | 2020-12-31 | Dallas | Iowa | 19049 | 7943 | 66 |
879066 | 879066 | 2020-12-30 | Dallas | Iowa | 19049 | 7871 | 66 |
875821 | 875821 | 2020-12-29 | Dallas | Iowa | 19049 | 7828 | 65 |
872576 | 872576 | 2020-12-28 | Dallas | Iowa | 19049 | 7788 | 64 |
869331 | 869331 | 2020-12-27 | Dallas | Iowa | 19049 | 7738 | 64 |
866086 | 866086 | 2020-12-26 | Dallas | Iowa | 19049 | 7724 | 64 |
862841 | 862841 | 2020-12-25 | Dallas | Iowa | 19049 | 7708 | 64 |
859596 | 859596 | 2020-12-24 | Dallas | Iowa | 19049 | 7689 | 63 |
856351 | 856351 | 2020-12-23 | Dallas | Iowa | 19049 | 7629 | 62 |
853106 | 853106 | 2020-12-22 | Dallas | Iowa | 19049 | 7583 | 62 |
849861 | 849861 | 2020-12-21 | Dallas | Iowa | 19049 | 7539 | 62 |
846616 | 846616 | 2020-12-20 | Dallas | Iowa | 19049 | 7482 | 62 |
843370 | 843370 | 2020-12-19 | Dallas | Iowa | 19049 | 7477 | 61 |
840125 | 840125 | 2020-12-18 | Dallas | Iowa | 19049 | 7414 | 60 |
836880 | 836880 | 2020-12-17 | Dallas | Iowa | 19049 | 7341 | 60 |
833634 | 833634 | 2020-12-16 | Dallas | Iowa | 19049 | 7285 | 60 |
830387 | 830387 | 2020-12-15 | Dallas | Iowa | 19049 | 7192 | 60 |
827141 | 827141 | 2020-12-14 | Dallas | Iowa | 19049 | 7152 | 60 |
823894 | 823894 | 2020-12-13 | Dallas | Iowa | 19049 | 7136 | 60 |
820648 | 820648 | 2020-12-12 | Dallas | Iowa | 19049 | 7094 | 60 |
817402 | 817402 | 2020-12-11 | Dallas | Iowa | 19049 | 7057 | 60 |
814156 | 814156 | 2020-12-10 | Dallas | Iowa | 19049 | 6983 | 59 |
810911 | 810911 | 2020-12-09 | Dallas | Iowa | 19049 | 6911 | 59 |
807666 | 807666 | 2020-12-08 | Dallas | Iowa | 19049 | 6834 | 58 |
804421 | 804421 | 2020-12-07 | Dallas | Iowa | 19049 | 6831 | 60 |
801176 | 801176 | 2020-12-06 | Dallas | Iowa | 19049 | 6805 | 60 |
797931 | 797931 | 2020-12-05 | Dallas | Iowa | 19049 | 6768 | 60 |
794686 | 794686 | 2020-12-04 | Dallas | Iowa | 19049 | 6698 | 60 |
791441 | 791441 | 2020-12-03 | Dallas | Iowa | 19049 | 6612 | 60 |
788196 | 788196 | 2020-12-02 | Dallas | Iowa | 19049 | 6571 | 59 |
784952 | 784952 | 2020-12-01 | Dallas | Iowa | 19049 | 6476 | 57 |
781707 | 781707 | 2020-11-30 | Dallas | Iowa | 19049 | 6418 | 57 |
778461 | 778461 | 2020-11-29 | Dallas | Iowa | 19049 | 6373 | 57 |
775216 | 775216 | 2020-11-28 | Dallas | Iowa | 19049 | 6336 | 57 |
771971 | 771971 | 2020-11-27 | Dallas | Iowa | 19049 | 6290 | 57 |
768726 | 768726 | 2020-11-26 | Dallas | Iowa | 19049 | 6246 | 57 |
765480 | 765480 | 2020-11-25 | Dallas | Iowa | 19049 | 6200 | 57 |
762235 | 762235 | 2020-11-24 | Dallas | Iowa | 19049 | 6114 | 56 |
758990 | 758990 | 2020-11-23 | Dallas | Iowa | 19049 | 6027 | 56 |
755743 | 755743 | 2020-11-22 | Dallas | Iowa | 19049 | 5955 | 55 |
752497 | 752497 | 2020-11-21 | Dallas | Iowa | 19049 | 5857 | 55 |
749251 | 749251 | 2020-11-20 | Dallas | Iowa | 19049 | 5792 | 55 |
746005 | 746005 | 2020-11-19 | Dallas | Iowa | 19049 | 5686 | 54 |
742758 | 742758 | 2020-11-18 | Dallas | Iowa | 19049 | 5577 | 54 |
739511 | 739511 | 2020-11-17 | Dallas | Iowa | 19049 | 5485 | 54 |
736267 | 736267 | 2020-11-16 | Dallas | Iowa | 19049 | 5402 | 54 |
733021 | 733021 | 2020-11-15 | Dallas | Iowa | 19049 | 5286 | 53 |
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);