ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Henry" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054344 | 1054344 | 2021-02-22 | Henry | Iowa | 19087 | 2774 | 35 |
1051097 | 1051097 | 2021-02-21 | Henry | Iowa | 19087 | 2774 | 35 |
1047850 | 1047850 | 2021-02-20 | Henry | Iowa | 19087 | 2774 | 35 |
1044605 | 1044605 | 2021-02-19 | Henry | Iowa | 19087 | 2774 | 35 |
1041360 | 1041360 | 2021-02-18 | Henry | Iowa | 19087 | 2772 | 35 |
1038115 | 1038115 | 2021-02-17 | Henry | Iowa | 19087 | 2772 | 35 |
1034870 | 1034870 | 2021-02-16 | Henry | Iowa | 19087 | 2771 | 35 |
1031624 | 1031624 | 2021-02-15 | Henry | Iowa | 19087 | 2767 | 35 |
1028377 | 1028377 | 2021-02-14 | Henry | Iowa | 19087 | 2763 | 35 |
1025132 | 1025132 | 2021-02-13 | Henry | Iowa | 19087 | 2760 | 35 |
1021887 | 1021887 | 2021-02-12 | Henry | Iowa | 19087 | 2759 | 34 |
1018642 | 1018642 | 2021-02-11 | Henry | Iowa | 19087 | 2744 | 34 |
1015397 | 1015397 | 2021-02-10 | Henry | Iowa | 19087 | 2741 | 34 |
1012152 | 1012152 | 2021-02-09 | Henry | Iowa | 19087 | 2737 | 33 |
1008906 | 1008906 | 2021-02-08 | Henry | Iowa | 19087 | 2733 | 33 |
1005660 | 1005660 | 2021-02-07 | Henry | Iowa | 19087 | 2731 | 33 |
1002414 | 1002414 | 2021-02-06 | Henry | Iowa | 19087 | 2732 | 33 |
999168 | 999168 | 2021-02-05 | Henry | Iowa | 19087 | 2729 | 33 |
995922 | 995922 | 2021-02-04 | Henry | Iowa | 19087 | 2727 | 33 |
992676 | 992676 | 2021-02-03 | Henry | Iowa | 19087 | 2724 | 33 |
989430 | 989430 | 2021-02-02 | Henry | Iowa | 19087 | 2722 | 33 |
986183 | 986183 | 2021-02-01 | Henry | Iowa | 19087 | 2720 | 33 |
982936 | 982936 | 2021-01-31 | Henry | Iowa | 19087 | 2717 | 33 |
979690 | 979690 | 2021-01-30 | Henry | Iowa | 19087 | 2717 | 33 |
976444 | 976444 | 2021-01-29 | Henry | Iowa | 19087 | 2711 | 32 |
973199 | 973199 | 2021-01-28 | Henry | Iowa | 19087 | 2711 | 32 |
969954 | 969954 | 2021-01-27 | Henry | Iowa | 19087 | 2702 | 31 |
966710 | 966710 | 2021-01-26 | Henry | Iowa | 19087 | 2699 | 31 |
963465 | 963465 | 2021-01-25 | Henry | Iowa | 19087 | 2693 | 31 |
960220 | 960220 | 2021-01-24 | Henry | Iowa | 19087 | 2671 | 31 |
956974 | 956974 | 2021-01-23 | Henry | Iowa | 19087 | 2673 | 31 |
953729 | 953729 | 2021-01-22 | Henry | Iowa | 19087 | 2661 | 31 |
950484 | 950484 | 2021-01-21 | Henry | Iowa | 19087 | 2658 | 31 |
947238 | 947238 | 2021-01-20 | Henry | Iowa | 19087 | 2648 | 31 |
943991 | 943991 | 2021-01-19 | Henry | Iowa | 19087 | 2643 | 30 |
940746 | 940746 | 2021-01-18 | Henry | Iowa | 19087 | 2639 | 30 |
937501 | 937501 | 2021-01-17 | Henry | Iowa | 19087 | 2633 | 30 |
934256 | 934256 | 2021-01-16 | Henry | Iowa | 19087 | 2633 | 30 |
931011 | 931011 | 2021-01-15 | Henry | Iowa | 19087 | 2626 | 30 |
927766 | 927766 | 2021-01-14 | Henry | Iowa | 19087 | 2620 | 30 |
924520 | 924520 | 2021-01-13 | Henry | Iowa | 19087 | 2610 | 30 |
921275 | 921275 | 2021-01-12 | Henry | Iowa | 19087 | 2593 | 30 |
918030 | 918030 | 2021-01-11 | Henry | Iowa | 19087 | 2580 | 29 |
914785 | 914785 | 2021-01-10 | Henry | Iowa | 19087 | 2579 | 29 |
911540 | 911540 | 2021-01-09 | Henry | Iowa | 19087 | 2578 | 29 |
908295 | 908295 | 2021-01-08 | Henry | Iowa | 19087 | 2567 | 29 |
905049 | 905049 | 2021-01-07 | Henry | Iowa | 19087 | 2551 | 29 |
901804 | 901804 | 2021-01-06 | Henry | Iowa | 19087 | 2534 | 29 |
898559 | 898559 | 2021-01-05 | Henry | Iowa | 19087 | 2508 | 28 |
895314 | 895314 | 2021-01-04 | Henry | Iowa | 19087 | 2499 | 28 |
892067 | 892067 | 2021-01-03 | Henry | Iowa | 19087 | 2494 | 27 |
888821 | 888821 | 2021-01-02 | Henry | Iowa | 19087 | 2492 | 27 |
885575 | 885575 | 2021-01-01 | Henry | Iowa | 19087 | 2485 | 27 |
882330 | 882330 | 2020-12-31 | Henry | Iowa | 19087 | 2483 | 27 |
879085 | 879085 | 2020-12-30 | Henry | Iowa | 19087 | 2469 | 26 |
875840 | 875840 | 2020-12-29 | Henry | Iowa | 19087 | 2452 | 26 |
872595 | 872595 | 2020-12-28 | Henry | Iowa | 19087 | 2448 | 24 |
869350 | 869350 | 2020-12-27 | Henry | Iowa | 19087 | 2442 | 24 |
866105 | 866105 | 2020-12-26 | Henry | Iowa | 19087 | 2439 | 24 |
862860 | 862860 | 2020-12-25 | Henry | Iowa | 19087 | 2437 | 24 |
859615 | 859615 | 2020-12-24 | Henry | Iowa | 19087 | 2437 | 24 |
856370 | 856370 | 2020-12-23 | Henry | Iowa | 19087 | 2429 | 23 |
853125 | 853125 | 2020-12-22 | Henry | Iowa | 19087 | 2418 | 22 |
849880 | 849880 | 2020-12-21 | Henry | Iowa | 19087 | 2403 | 21 |
846635 | 846635 | 2020-12-20 | Henry | Iowa | 19087 | 2396 | 21 |
843389 | 843389 | 2020-12-19 | Henry | Iowa | 19087 | 2395 | 21 |
840144 | 840144 | 2020-12-18 | Henry | Iowa | 19087 | 2383 | 20 |
836899 | 836899 | 2020-12-17 | Henry | Iowa | 19087 | 2364 | 20 |
833653 | 833653 | 2020-12-16 | Henry | Iowa | 19087 | 2352 | 20 |
830406 | 830406 | 2020-12-15 | Henry | Iowa | 19087 | 2315 | 20 |
827160 | 827160 | 2020-12-14 | Henry | Iowa | 19087 | 2301 | 19 |
823913 | 823913 | 2020-12-13 | Henry | Iowa | 19087 | 2296 | 19 |
820667 | 820667 | 2020-12-12 | Henry | Iowa | 19087 | 2285 | 19 |
817421 | 817421 | 2020-12-11 | Henry | Iowa | 19087 | 2275 | 19 |
814175 | 814175 | 2020-12-10 | Henry | Iowa | 19087 | 2139 | 18 |
810930 | 810930 | 2020-12-09 | Henry | Iowa | 19087 | 2111 | 17 |
807685 | 807685 | 2020-12-08 | Henry | Iowa | 19087 | 2018 | 17 |
804440 | 804440 | 2020-12-07 | Henry | Iowa | 19087 | 2009 | 8 |
801195 | 801195 | 2020-12-06 | Henry | Iowa | 19087 | 2001 | 8 |
797950 | 797950 | 2020-12-05 | Henry | Iowa | 19087 | 1985 | 8 |
794705 | 794705 | 2020-12-04 | Henry | Iowa | 19087 | 1972 | 8 |
791460 | 791460 | 2020-12-03 | Henry | Iowa | 19087 | 1937 | 7 |
788215 | 788215 | 2020-12-02 | Henry | Iowa | 19087 | 1913 | 7 |
784971 | 784971 | 2020-12-01 | Henry | Iowa | 19087 | 1870 | 7 |
781726 | 781726 | 2020-11-30 | Henry | Iowa | 19087 | 1840 | 7 |
778480 | 778480 | 2020-11-29 | Henry | Iowa | 19087 | 1831 | 7 |
775235 | 775235 | 2020-11-28 | Henry | Iowa | 19087 | 1821 | 7 |
771990 | 771990 | 2020-11-27 | Henry | Iowa | 19087 | 1810 | 7 |
768745 | 768745 | 2020-11-26 | Henry | Iowa | 19087 | 1803 | 7 |
765499 | 765499 | 2020-11-25 | Henry | Iowa | 19087 | 1791 | 7 |
762254 | 762254 | 2020-11-24 | Henry | Iowa | 19087 | 1725 | 7 |
759009 | 759009 | 2020-11-23 | Henry | Iowa | 19087 | 1710 | 7 |
755762 | 755762 | 2020-11-22 | Henry | Iowa | 19087 | 1684 | 7 |
752516 | 752516 | 2020-11-21 | Henry | Iowa | 19087 | 1678 | 7 |
749270 | 749270 | 2020-11-20 | Henry | Iowa | 19087 | 1660 | 7 |
746024 | 746024 | 2020-11-19 | Henry | Iowa | 19087 | 1637 | 7 |
742777 | 742777 | 2020-11-18 | Henry | Iowa | 19087 | 1607 | 7 |
739530 | 739530 | 2020-11-17 | Henry | Iowa | 19087 | 1571 | 7 |
736286 | 736286 | 2020-11-16 | Henry | Iowa | 19087 | 1555 | 7 |
733040 | 733040 | 2020-11-15 | Henry | Iowa | 19087 | 1538 | 7 |
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);