ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
732 rows where fips = 19093 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054347 | 1054347 | 2021-02-22 | Ida | Iowa | 19093 | 804 | 32 |
1051100 | 1051100 | 2021-02-21 | Ida | Iowa | 19093 | 804 | 32 |
1047853 | 1047853 | 2021-02-20 | Ida | Iowa | 19093 | 804 | 32 |
1044608 | 1044608 | 2021-02-19 | Ida | Iowa | 19093 | 804 | 32 |
1041363 | 1041363 | 2021-02-18 | Ida | Iowa | 19093 | 803 | 32 |
1038118 | 1038118 | 2021-02-17 | Ida | Iowa | 19093 | 802 | 32 |
1034873 | 1034873 | 2021-02-16 | Ida | Iowa | 19093 | 800 | 32 |
1031627 | 1031627 | 2021-02-15 | Ida | Iowa | 19093 | 801 | 32 |
1028380 | 1028380 | 2021-02-14 | Ida | Iowa | 19093 | 799 | 32 |
1025135 | 1025135 | 2021-02-13 | Ida | Iowa | 19093 | 800 | 32 |
1021890 | 1021890 | 2021-02-12 | Ida | Iowa | 19093 | 800 | 32 |
1018645 | 1018645 | 2021-02-11 | Ida | Iowa | 19093 | 799 | 31 |
1015400 | 1015400 | 2021-02-10 | Ida | Iowa | 19093 | 799 | 31 |
1012155 | 1012155 | 2021-02-09 | Ida | Iowa | 19093 | 799 | 31 |
1008909 | 1008909 | 2021-02-08 | Ida | Iowa | 19093 | 796 | 31 |
1005663 | 1005663 | 2021-02-07 | Ida | Iowa | 19093 | 795 | 31 |
1002417 | 1002417 | 2021-02-06 | Ida | Iowa | 19093 | 794 | 31 |
999171 | 999171 | 2021-02-05 | Ida | Iowa | 19093 | 794 | 31 |
995925 | 995925 | 2021-02-04 | Ida | Iowa | 19093 | 793 | 31 |
992679 | 992679 | 2021-02-03 | Ida | Iowa | 19093 | 792 | 31 |
989433 | 989433 | 2021-02-02 | Ida | Iowa | 19093 | 786 | 30 |
986186 | 986186 | 2021-02-01 | Ida | Iowa | 19093 | 786 | 30 |
982939 | 982939 | 2021-01-31 | Ida | Iowa | 19093 | 781 | 30 |
979693 | 979693 | 2021-01-30 | Ida | Iowa | 19093 | 779 | 30 |
976447 | 976447 | 2021-01-29 | Ida | Iowa | 19093 | 778 | 30 |
973202 | 973202 | 2021-01-28 | Ida | Iowa | 19093 | 776 | 30 |
969957 | 969957 | 2021-01-27 | Ida | Iowa | 19093 | 769 | 30 |
966713 | 966713 | 2021-01-26 | Ida | Iowa | 19093 | 769 | 30 |
963468 | 963468 | 2021-01-25 | Ida | Iowa | 19093 | 764 | 30 |
960223 | 960223 | 2021-01-24 | Ida | Iowa | 19093 | 760 | 30 |
956977 | 956977 | 2021-01-23 | Ida | Iowa | 19093 | 759 | 30 |
953732 | 953732 | 2021-01-22 | Ida | Iowa | 19093 | 758 | 30 |
950487 | 950487 | 2021-01-21 | Ida | Iowa | 19093 | 754 | 30 |
947241 | 947241 | 2021-01-20 | Ida | Iowa | 19093 | 747 | 30 |
943994 | 943994 | 2021-01-19 | Ida | Iowa | 19093 | 746 | 30 |
940749 | 940749 | 2021-01-18 | Ida | Iowa | 19093 | 741 | 30 |
937504 | 937504 | 2021-01-17 | Ida | Iowa | 19093 | 740 | 30 |
934259 | 934259 | 2021-01-16 | Ida | Iowa | 19093 | 738 | 30 |
931014 | 931014 | 2021-01-15 | Ida | Iowa | 19093 | 737 | 30 |
927769 | 927769 | 2021-01-14 | Ida | Iowa | 19093 | 735 | 30 |
924523 | 924523 | 2021-01-13 | Ida | Iowa | 19093 | 731 | 30 |
921278 | 921278 | 2021-01-12 | Ida | Iowa | 19093 | 729 | 30 |
918033 | 918033 | 2021-01-11 | Ida | Iowa | 19093 | 728 | 30 |
914788 | 914788 | 2021-01-10 | Ida | Iowa | 19093 | 725 | 30 |
911543 | 911543 | 2021-01-09 | Ida | Iowa | 19093 | 722 | 30 |
908298 | 908298 | 2021-01-08 | Ida | Iowa | 19093 | 720 | 30 |
905052 | 905052 | 2021-01-07 | Ida | Iowa | 19093 | 718 | 29 |
901807 | 901807 | 2021-01-06 | Ida | Iowa | 19093 | 716 | 29 |
898562 | 898562 | 2021-01-05 | Ida | Iowa | 19093 | 715 | 29 |
895317 | 895317 | 2021-01-04 | Ida | Iowa | 19093 | 711 | 29 |
892070 | 892070 | 2021-01-03 | Ida | Iowa | 19093 | 701 | 29 |
888824 | 888824 | 2021-01-02 | Ida | Iowa | 19093 | 700 | 29 |
885578 | 885578 | 2021-01-01 | Ida | Iowa | 19093 | 699 | 29 |
882333 | 882333 | 2020-12-31 | Ida | Iowa | 19093 | 695 | 28 |
879088 | 879088 | 2020-12-30 | Ida | Iowa | 19093 | 693 | 26 |
875843 | 875843 | 2020-12-29 | Ida | Iowa | 19093 | 688 | 26 |
872598 | 872598 | 2020-12-28 | Ida | Iowa | 19093 | 685 | 22 |
869353 | 869353 | 2020-12-27 | Ida | Iowa | 19093 | 682 | 22 |
866108 | 866108 | 2020-12-26 | Ida | Iowa | 19093 | 682 | 22 |
862863 | 862863 | 2020-12-25 | Ida | Iowa | 19093 | 681 | 22 |
859618 | 859618 | 2020-12-24 | Ida | Iowa | 19093 | 680 | 22 |
856373 | 856373 | 2020-12-23 | Ida | Iowa | 19093 | 679 | 21 |
853128 | 853128 | 2020-12-22 | Ida | Iowa | 19093 | 674 | 21 |
849883 | 849883 | 2020-12-21 | Ida | Iowa | 19093 | 669 | 21 |
846638 | 846638 | 2020-12-20 | Ida | Iowa | 19093 | 665 | 21 |
843392 | 843392 | 2020-12-19 | Ida | Iowa | 19093 | 664 | 21 |
840147 | 840147 | 2020-12-18 | Ida | Iowa | 19093 | 659 | 19 |
836902 | 836902 | 2020-12-17 | Ida | Iowa | 19093 | 649 | 19 |
833656 | 833656 | 2020-12-16 | Ida | Iowa | 19093 | 647 | 17 |
830409 | 830409 | 2020-12-15 | Ida | Iowa | 19093 | 640 | 17 |
827163 | 827163 | 2020-12-14 | Ida | Iowa | 19093 | 636 | 17 |
823916 | 823916 | 2020-12-13 | Ida | Iowa | 19093 | 635 | 17 |
820670 | 820670 | 2020-12-12 | Ida | Iowa | 19093 | 631 | 17 |
817424 | 817424 | 2020-12-11 | Ida | Iowa | 19093 | 616 | 17 |
814178 | 814178 | 2020-12-10 | Ida | Iowa | 19093 | 602 | 16 |
810933 | 810933 | 2020-12-09 | Ida | Iowa | 19093 | 585 | 15 |
807688 | 807688 | 2020-12-08 | Ida | Iowa | 19093 | 581 | 14 |
804443 | 804443 | 2020-12-07 | Ida | Iowa | 19093 | 581 | 16 |
801198 | 801198 | 2020-12-06 | Ida | Iowa | 19093 | 573 | 16 |
797953 | 797953 | 2020-12-05 | Ida | Iowa | 19093 | 570 | 16 |
794708 | 794708 | 2020-12-04 | Ida | Iowa | 19093 | 560 | 16 |
791463 | 791463 | 2020-12-03 | Ida | Iowa | 19093 | 549 | 15 |
788218 | 788218 | 2020-12-02 | Ida | Iowa | 19093 | 530 | 13 |
784974 | 784974 | 2020-12-01 | Ida | Iowa | 19093 | 523 | 13 |
781729 | 781729 | 2020-11-30 | Ida | Iowa | 19093 | 500 | 13 |
778483 | 778483 | 2020-11-29 | Ida | Iowa | 19093 | 489 | 13 |
775238 | 775238 | 2020-11-28 | Ida | Iowa | 19093 | 487 | 13 |
771993 | 771993 | 2020-11-27 | Ida | Iowa | 19093 | 481 | 13 |
768748 | 768748 | 2020-11-26 | Ida | Iowa | 19093 | 468 | 13 |
765502 | 765502 | 2020-11-25 | Ida | Iowa | 19093 | 464 | 11 |
762257 | 762257 | 2020-11-24 | Ida | Iowa | 19093 | 455 | 10 |
759012 | 759012 | 2020-11-23 | Ida | Iowa | 19093 | 439 | 10 |
755765 | 755765 | 2020-11-22 | Ida | Iowa | 19093 | 428 | 10 |
752519 | 752519 | 2020-11-21 | Ida | Iowa | 19093 | 425 | 10 |
749273 | 749273 | 2020-11-20 | Ida | Iowa | 19093 | 423 | 9 |
746027 | 746027 | 2020-11-19 | Ida | Iowa | 19093 | 417 | 9 |
742780 | 742780 | 2020-11-18 | Ida | Iowa | 19093 | 411 | 8 |
739533 | 739533 | 2020-11-17 | Ida | Iowa | 19093 | 404 | 7 |
736289 | 736289 | 2020-11-16 | Ida | Iowa | 19093 | 397 | 6 |
733043 | 733043 | 2020-11-15 | Ida | Iowa | 19093 | 391 | 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);