ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 19169 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054385 | 1054385 | 2021-02-22 | Story | Iowa | 19169 | 9363 | 45 |
1051138 | 1051138 | 2021-02-21 | Story | Iowa | 19169 | 9363 | 45 |
1047891 | 1047891 | 2021-02-20 | Story | Iowa | 19169 | 9363 | 45 |
1044646 | 1044646 | 2021-02-19 | Story | Iowa | 19169 | 9363 | 45 |
1041401 | 1041401 | 2021-02-18 | Story | Iowa | 19169 | 9361 | 44 |
1038156 | 1038156 | 2021-02-17 | Story | Iowa | 19169 | 9339 | 44 |
1034911 | 1034911 | 2021-02-16 | Story | Iowa | 19169 | 9318 | 43 |
1031665 | 1031665 | 2021-02-15 | Story | Iowa | 19169 | 9298 | 43 |
1028418 | 1028418 | 2021-02-14 | Story | Iowa | 19169 | 9273 | 43 |
1025173 | 1025173 | 2021-02-13 | Story | Iowa | 19169 | 9271 | 43 |
1021928 | 1021928 | 2021-02-12 | Story | Iowa | 19169 | 9247 | 43 |
1018683 | 1018683 | 2021-02-11 | Story | Iowa | 19169 | 9223 | 43 |
1015438 | 1015438 | 2021-02-10 | Story | Iowa | 19169 | 9219 | 43 |
1012193 | 1012193 | 2021-02-09 | Story | Iowa | 19169 | 9204 | 43 |
1008947 | 1008947 | 2021-02-08 | Story | Iowa | 19169 | 9179 | 43 |
1005701 | 1005701 | 2021-02-07 | Story | Iowa | 19169 | 9165 | 43 |
1002455 | 1002455 | 2021-02-06 | Story | Iowa | 19169 | 9162 | 43 |
999209 | 999209 | 2021-02-05 | Story | Iowa | 19169 | 9145 | 42 |
995963 | 995963 | 2021-02-04 | Story | Iowa | 19169 | 9125 | 41 |
992717 | 992717 | 2021-02-03 | Story | Iowa | 19169 | 9096 | 41 |
989471 | 989471 | 2021-02-02 | Story | Iowa | 19169 | 9058 | 40 |
986224 | 986224 | 2021-02-01 | Story | Iowa | 19169 | 9041 | 40 |
982977 | 982977 | 2021-01-31 | Story | Iowa | 19169 | 9011 | 40 |
979731 | 979731 | 2021-01-30 | Story | Iowa | 19169 | 9010 | 39 |
976485 | 976485 | 2021-01-29 | Story | Iowa | 19169 | 8954 | 39 |
973240 | 973240 | 2021-01-28 | Story | Iowa | 19169 | 8941 | 38 |
969995 | 969995 | 2021-01-27 | Story | Iowa | 19169 | 8905 | 38 |
966751 | 966751 | 2021-01-26 | Story | Iowa | 19169 | 8866 | 38 |
963506 | 963506 | 2021-01-25 | Story | Iowa | 19169 | 8835 | 38 |
960261 | 960261 | 2021-01-24 | Story | Iowa | 19169 | 8810 | 38 |
957015 | 957015 | 2021-01-23 | Story | Iowa | 19169 | 8794 | 38 |
953770 | 953770 | 2021-01-22 | Story | Iowa | 19169 | 8778 | 38 |
950525 | 950525 | 2021-01-21 | Story | Iowa | 19169 | 8755 | 36 |
947279 | 947279 | 2021-01-20 | Story | Iowa | 19169 | 8712 | 35 |
944032 | 944032 | 2021-01-19 | Story | Iowa | 19169 | 8694 | 34 |
940787 | 940787 | 2021-01-18 | Story | Iowa | 19169 | 8654 | 34 |
937542 | 937542 | 2021-01-17 | Story | Iowa | 19169 | 8638 | 34 |
934297 | 934297 | 2021-01-16 | Story | Iowa | 19169 | 8634 | 34 |
931052 | 931052 | 2021-01-15 | Story | Iowa | 19169 | 8604 | 33 |
927807 | 927807 | 2021-01-14 | Story | Iowa | 19169 | 8574 | 33 |
924561 | 924561 | 2021-01-13 | Story | Iowa | 19169 | 8539 | 33 |
921316 | 921316 | 2021-01-12 | Story | Iowa | 19169 | 8462 | 33 |
918071 | 918071 | 2021-01-11 | Story | Iowa | 19169 | 8436 | 32 |
914826 | 914826 | 2021-01-10 | Story | Iowa | 19169 | 8398 | 32 |
911581 | 911581 | 2021-01-09 | Story | Iowa | 19169 | 8385 | 32 |
908336 | 908336 | 2021-01-08 | Story | Iowa | 19169 | 8344 | 32 |
905090 | 905090 | 2021-01-07 | Story | Iowa | 19169 | 8308 | 32 |
901845 | 901845 | 2021-01-06 | Story | Iowa | 19169 | 8256 | 32 |
898600 | 898600 | 2021-01-05 | Story | Iowa | 19169 | 8194 | 31 |
895355 | 895355 | 2021-01-04 | Story | Iowa | 19169 | 8112 | 31 |
892108 | 892108 | 2021-01-03 | Story | Iowa | 19169 | 8070 | 31 |
888862 | 888862 | 2021-01-02 | Story | Iowa | 19169 | 8048 | 31 |
885616 | 885616 | 2021-01-01 | Story | Iowa | 19169 | 8033 | 31 |
882371 | 882371 | 2020-12-31 | Story | Iowa | 19169 | 8008 | 31 |
879126 | 879126 | 2020-12-30 | Story | Iowa | 19169 | 7981 | 29 |
875881 | 875881 | 2020-12-29 | Story | Iowa | 19169 | 7940 | 29 |
872636 | 872636 | 2020-12-28 | Story | Iowa | 19169 | 7903 | 29 |
869391 | 869391 | 2020-12-27 | Story | Iowa | 19169 | 7868 | 29 |
866146 | 866146 | 2020-12-26 | Story | Iowa | 19169 | 7862 | 29 |
862901 | 862901 | 2020-12-25 | Story | Iowa | 19169 | 7856 | 29 |
859656 | 859656 | 2020-12-24 | Story | Iowa | 19169 | 7842 | 29 |
856411 | 856411 | 2020-12-23 | Story | Iowa | 19169 | 7812 | 27 |
853166 | 853166 | 2020-12-22 | Story | Iowa | 19169 | 7780 | 27 |
849921 | 849921 | 2020-12-21 | Story | Iowa | 19169 | 7755 | 26 |
846676 | 846676 | 2020-12-20 | Story | Iowa | 19169 | 7710 | 26 |
843430 | 843430 | 2020-12-19 | Story | Iowa | 19169 | 7702 | 26 |
840185 | 840185 | 2020-12-18 | Story | Iowa | 19169 | 7642 | 24 |
836940 | 836940 | 2020-12-17 | Story | Iowa | 19169 | 7568 | 24 |
833694 | 833694 | 2020-12-16 | Story | Iowa | 19169 | 7520 | 23 |
830447 | 830447 | 2020-12-15 | Story | Iowa | 19169 | 7461 | 23 |
827201 | 827201 | 2020-12-14 | Story | Iowa | 19169 | 7424 | 23 |
823954 | 823954 | 2020-12-13 | Story | Iowa | 19169 | 7416 | 22 |
820708 | 820708 | 2020-12-12 | Story | Iowa | 19169 | 7379 | 22 |
817462 | 817462 | 2020-12-11 | Story | Iowa | 19169 | 7341 | 22 |
814216 | 814216 | 2020-12-10 | Story | Iowa | 19169 | 7283 | 21 |
810971 | 810971 | 2020-12-09 | Story | Iowa | 19169 | 7239 | 19 |
807726 | 807726 | 2020-12-08 | Story | Iowa | 19169 | 7176 | 18 |
804481 | 804481 | 2020-12-07 | Story | Iowa | 19169 | 7174 | 25 |
801236 | 801236 | 2020-12-06 | Story | Iowa | 19169 | 7140 | 25 |
797991 | 797991 | 2020-12-05 | Story | Iowa | 19169 | 7116 | 25 |
794746 | 794746 | 2020-12-04 | Story | Iowa | 19169 | 7076 | 25 |
791501 | 791501 | 2020-12-03 | Story | Iowa | 19169 | 7019 | 24 |
788256 | 788256 | 2020-12-02 | Story | Iowa | 19169 | 6983 | 23 |
785012 | 785012 | 2020-12-01 | Story | Iowa | 19169 | 6892 | 22 |
781767 | 781767 | 2020-11-30 | Story | Iowa | 19169 | 6844 | 22 |
778521 | 778521 | 2020-11-29 | Story | Iowa | 19169 | 6790 | 22 |
775276 | 775276 | 2020-11-28 | Story | Iowa | 19169 | 6775 | 21 |
772031 | 772031 | 2020-11-27 | Story | Iowa | 19169 | 6749 | 21 |
768786 | 768786 | 2020-11-26 | Story | Iowa | 19169 | 6697 | 21 |
765540 | 765540 | 2020-11-25 | Story | Iowa | 19169 | 6666 | 20 |
762295 | 762295 | 2020-11-24 | Story | Iowa | 19169 | 6566 | 19 |
759050 | 759050 | 2020-11-23 | Story | Iowa | 19169 | 6476 | 19 |
755803 | 755803 | 2020-11-22 | Story | Iowa | 19169 | 6378 | 19 |
752557 | 752557 | 2020-11-21 | Story | Iowa | 19169 | 6313 | 19 |
749311 | 749311 | 2020-11-20 | Story | Iowa | 19169 | 6170 | 19 |
746065 | 746065 | 2020-11-19 | Story | Iowa | 19169 | 6025 | 19 |
742818 | 742818 | 2020-11-18 | Story | Iowa | 19169 | 5905 | 19 |
739571 | 739571 | 2020-11-17 | Story | Iowa | 19169 | 5734 | 19 |
736327 | 736327 | 2020-11-16 | Story | Iowa | 19169 | 5605 | 19 |
733081 | 733081 | 2020-11-15 | Story | Iowa | 19169 | 5517 | 18 |
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);