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 |
---|---|---|---|---|---|---|---|
1193988 | 1193988 | 2021-04-06 | Story | Iowa | 19169 | 10184 | 47 |
1190738 | 1190738 | 2021-04-05 | Story | Iowa | 19169 | 10161 | 47 |
1187491 | 1187491 | 2021-04-04 | Story | Iowa | 19169 | 10147 | 47 |
1184244 | 1184244 | 2021-04-03 | Story | Iowa | 19169 | 10145 | 47 |
1180997 | 1180997 | 2021-04-02 | Story | Iowa | 19169 | 10124 | 46 |
1177750 | 1177750 | 2021-04-01 | Story | Iowa | 19169 | 10109 | 46 |
1174503 | 1174503 | 2021-03-31 | Story | Iowa | 19169 | 10074 | 46 |
1171256 | 1171256 | 2021-03-30 | Story | Iowa | 19169 | 10048 | 46 |
1168008 | 1168008 | 2021-03-29 | Story | Iowa | 19169 | 10028 | 46 |
1164760 | 1164760 | 2021-03-28 | Story | Iowa | 19169 | 9986 | 46 |
1161512 | 1161512 | 2021-03-27 | Story | Iowa | 19169 | 9981 | 46 |
1158264 | 1158264 | 2021-03-26 | Story | Iowa | 19169 | 9972 | 46 |
1155017 | 1155017 | 2021-03-25 | Story | Iowa | 19169 | 9948 | 46 |
1151770 | 1151770 | 2021-03-24 | Story | Iowa | 19169 | 9902 | 46 |
1148523 | 1148523 | 2021-03-23 | Story | Iowa | 19169 | 9886 | 46 |
1145276 | 1145276 | 2021-03-22 | Story | Iowa | 19169 | 9863 | 46 |
1142029 | 1142029 | 2021-03-21 | Story | Iowa | 19169 | 9847 | 46 |
1138783 | 1138783 | 2021-03-20 | Story | Iowa | 19169 | 9844 | 46 |
1135537 | 1135537 | 2021-03-19 | Story | Iowa | 19169 | 9830 | 46 |
1132290 | 1132290 | 2021-03-18 | Story | Iowa | 19169 | 9819 | 46 |
1129042 | 1129042 | 2021-03-17 | Story | Iowa | 19169 | 9804 | 46 |
1125796 | 1125796 | 2021-03-16 | Story | Iowa | 19169 | 9794 | 46 |
1122550 | 1122550 | 2021-03-15 | Story | Iowa | 19169 | 9769 | 46 |
1119303 | 1119303 | 2021-03-14 | Story | Iowa | 19169 | 9753 | 46 |
1116056 | 1116056 | 2021-03-13 | Story | Iowa | 19169 | 9750 | 46 |
1112810 | 1112810 | 2021-03-12 | Story | Iowa | 19169 | 9742 | 46 |
1109564 | 1109564 | 2021-03-11 | Story | Iowa | 19169 | 9734 | 46 |
1106318 | 1106318 | 2021-03-10 | Story | Iowa | 19169 | 9722 | 46 |
1103072 | 1103072 | 2021-03-09 | Story | Iowa | 19169 | 9672 | 45 |
1099826 | 1099826 | 2021-03-08 | Story | Iowa | 19169 | 9654 | 45 |
1096578 | 1096578 | 2021-03-07 | Story | Iowa | 19169 | 9619 | 45 |
1093332 | 1093332 | 2021-03-06 | Story | Iowa | 19169 | 9619 | 45 |
1090086 | 1090086 | 2021-03-05 | Story | Iowa | 19169 | 9619 | 45 |
1086841 | 1086841 | 2021-03-04 | Story | Iowa | 19169 | 9600 | 45 |
1083595 | 1083595 | 2021-03-03 | Story | Iowa | 19169 | 9582 | 45 |
1080349 | 1080349 | 2021-03-02 | Story | Iowa | 19169 | 9545 | 45 |
1077104 | 1077104 | 2021-03-01 | Story | Iowa | 19169 | 9522 | 45 |
1073858 | 1073858 | 2021-02-28 | Story | Iowa | 19169 | 9487 | 45 |
1070612 | 1070612 | 2021-02-27 | Story | Iowa | 19169 | 9487 | 45 |
1067367 | 1067367 | 2021-02-26 | Story | Iowa | 19169 | 9487 | 45 |
1064122 | 1064122 | 2021-02-25 | Story | Iowa | 19169 | 9469 | 45 |
1060877 | 1060877 | 2021-02-24 | Story | Iowa | 19169 | 9363 | 45 |
1057631 | 1057631 | 2021-02-23 | Story | Iowa | 19169 | 9363 | 45 |
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 |
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);