ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 19033 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193920 | 1193920 | 2021-04-06 | Cerro Gordo | Iowa | 19033 | 5152 | 86 |
1190670 | 1190670 | 2021-04-05 | Cerro Gordo | Iowa | 19033 | 5142 | 85 |
1187423 | 1187423 | 2021-04-04 | Cerro Gordo | Iowa | 19033 | 5135 | 85 |
1184176 | 1184176 | 2021-04-03 | Cerro Gordo | Iowa | 19033 | 5131 | 85 |
1180929 | 1180929 | 2021-04-02 | Cerro Gordo | Iowa | 19033 | 5125 | 85 |
1177682 | 1177682 | 2021-04-01 | Cerro Gordo | Iowa | 19033 | 5119 | 85 |
1174435 | 1174435 | 2021-03-31 | Cerro Gordo | Iowa | 19033 | 5114 | 85 |
1171188 | 1171188 | 2021-03-30 | Cerro Gordo | Iowa | 19033 | 5104 | 85 |
1167940 | 1167940 | 2021-03-29 | Cerro Gordo | Iowa | 19033 | 5098 | 85 |
1164692 | 1164692 | 2021-03-28 | Cerro Gordo | Iowa | 19033 | 5094 | 85 |
1161444 | 1161444 | 2021-03-27 | Cerro Gordo | Iowa | 19033 | 5094 | 85 |
1158196 | 1158196 | 2021-03-26 | Cerro Gordo | Iowa | 19033 | 5090 | 85 |
1154949 | 1154949 | 2021-03-25 | Cerro Gordo | Iowa | 19033 | 5083 | 85 |
1151702 | 1151702 | 2021-03-24 | Cerro Gordo | Iowa | 19033 | 5083 | 85 |
1148455 | 1148455 | 2021-03-23 | Cerro Gordo | Iowa | 19033 | 5070 | 85 |
1145208 | 1145208 | 2021-03-22 | Cerro Gordo | Iowa | 19033 | 5062 | 85 |
1141961 | 1141961 | 2021-03-21 | Cerro Gordo | Iowa | 19033 | 5061 | 85 |
1138715 | 1138715 | 2021-03-20 | Cerro Gordo | Iowa | 19033 | 5061 | 85 |
1135469 | 1135469 | 2021-03-19 | Cerro Gordo | Iowa | 19033 | 5060 | 85 |
1132222 | 1132222 | 2021-03-18 | Cerro Gordo | Iowa | 19033 | 5057 | 85 |
1128974 | 1128974 | 2021-03-17 | Cerro Gordo | Iowa | 19033 | 5052 | 85 |
1125728 | 1125728 | 2021-03-16 | Cerro Gordo | Iowa | 19033 | 5051 | 85 |
1122482 | 1122482 | 2021-03-15 | Cerro Gordo | Iowa | 19033 | 5048 | 85 |
1119235 | 1119235 | 2021-03-14 | Cerro Gordo | Iowa | 19033 | 5045 | 85 |
1115988 | 1115988 | 2021-03-13 | Cerro Gordo | Iowa | 19033 | 5045 | 85 |
1112742 | 1112742 | 2021-03-12 | Cerro Gordo | Iowa | 19033 | 5039 | 85 |
1109496 | 1109496 | 2021-03-11 | Cerro Gordo | Iowa | 19033 | 5034 | 84 |
1106250 | 1106250 | 2021-03-10 | Cerro Gordo | Iowa | 19033 | 5028 | 83 |
1103004 | 1103004 | 2021-03-09 | Cerro Gordo | Iowa | 19033 | 5020 | 83 |
1099758 | 1099758 | 2021-03-08 | Cerro Gordo | Iowa | 19033 | 5014 | 83 |
1096510 | 1096510 | 2021-03-07 | Cerro Gordo | Iowa | 19033 | 4995 | 83 |
1093264 | 1093264 | 2021-03-06 | Cerro Gordo | Iowa | 19033 | 4995 | 83 |
1090018 | 1090018 | 2021-03-05 | Cerro Gordo | Iowa | 19033 | 4995 | 83 |
1086773 | 1086773 | 2021-03-04 | Cerro Gordo | Iowa | 19033 | 4993 | 83 |
1083527 | 1083527 | 2021-03-03 | Cerro Gordo | Iowa | 19033 | 4984 | 82 |
1080281 | 1080281 | 2021-03-02 | Cerro Gordo | Iowa | 19033 | 4982 | 82 |
1077036 | 1077036 | 2021-03-01 | Cerro Gordo | Iowa | 19033 | 4976 | 81 |
1073790 | 1073790 | 2021-02-28 | Cerro Gordo | Iowa | 19033 | 4971 | 81 |
1070544 | 1070544 | 2021-02-27 | Cerro Gordo | Iowa | 19033 | 4971 | 81 |
1067299 | 1067299 | 2021-02-26 | Cerro Gordo | Iowa | 19033 | 4971 | 81 |
1064054 | 1064054 | 2021-02-25 | Cerro Gordo | Iowa | 19033 | 4968 | 80 |
1060809 | 1060809 | 2021-02-24 | Cerro Gordo | Iowa | 19033 | 4939 | 80 |
1057563 | 1057563 | 2021-02-23 | Cerro Gordo | Iowa | 19033 | 4939 | 80 |
1054317 | 1054317 | 2021-02-22 | Cerro Gordo | Iowa | 19033 | 4939 | 80 |
1051070 | 1051070 | 2021-02-21 | Cerro Gordo | Iowa | 19033 | 4939 | 79 |
1047823 | 1047823 | 2021-02-20 | Cerro Gordo | Iowa | 19033 | 4939 | 79 |
1044578 | 1044578 | 2021-02-19 | Cerro Gordo | Iowa | 19033 | 4939 | 79 |
1041333 | 1041333 | 2021-02-18 | Cerro Gordo | Iowa | 19033 | 4934 | 79 |
1038088 | 1038088 | 2021-02-17 | Cerro Gordo | Iowa | 19033 | 4933 | 79 |
1034843 | 1034843 | 2021-02-16 | Cerro Gordo | Iowa | 19033 | 4932 | 79 |
1031597 | 1031597 | 2021-02-15 | Cerro Gordo | Iowa | 19033 | 4927 | 79 |
1028350 | 1028350 | 2021-02-14 | Cerro Gordo | Iowa | 19033 | 4922 | 79 |
1025105 | 1025105 | 2021-02-13 | Cerro Gordo | Iowa | 19033 | 4922 | 79 |
1021860 | 1021860 | 2021-02-12 | Cerro Gordo | Iowa | 19033 | 4919 | 79 |
1018615 | 1018615 | 2021-02-11 | Cerro Gordo | Iowa | 19033 | 4911 | 79 |
1015370 | 1015370 | 2021-02-10 | Cerro Gordo | Iowa | 19033 | 4911 | 77 |
1012125 | 1012125 | 2021-02-09 | Cerro Gordo | Iowa | 19033 | 4898 | 77 |
1008879 | 1008879 | 2021-02-08 | Cerro Gordo | Iowa | 19033 | 4879 | 76 |
1005633 | 1005633 | 2021-02-07 | Cerro Gordo | Iowa | 19033 | 4877 | 76 |
1002387 | 1002387 | 2021-02-06 | Cerro Gordo | Iowa | 19033 | 4871 | 76 |
999141 | 999141 | 2021-02-05 | Cerro Gordo | Iowa | 19033 | 4864 | 76 |
995895 | 995895 | 2021-02-04 | Cerro Gordo | Iowa | 19033 | 4856 | 76 |
992649 | 992649 | 2021-02-03 | Cerro Gordo | Iowa | 19033 | 4847 | 76 |
989403 | 989403 | 2021-02-02 | Cerro Gordo | Iowa | 19033 | 4825 | 74 |
986156 | 986156 | 2021-02-01 | Cerro Gordo | Iowa | 19033 | 4818 | 74 |
982909 | 982909 | 2021-01-31 | Cerro Gordo | Iowa | 19033 | 4814 | 74 |
979663 | 979663 | 2021-01-30 | Cerro Gordo | Iowa | 19033 | 4806 | 73 |
976417 | 976417 | 2021-01-29 | Cerro Gordo | Iowa | 19033 | 4795 | 72 |
973172 | 973172 | 2021-01-28 | Cerro Gordo | Iowa | 19033 | 4789 | 72 |
969927 | 969927 | 2021-01-27 | Cerro Gordo | Iowa | 19033 | 4776 | 72 |
966683 | 966683 | 2021-01-26 | Cerro Gordo | Iowa | 19033 | 4761 | 72 |
963438 | 963438 | 2021-01-25 | Cerro Gordo | Iowa | 19033 | 4743 | 72 |
960193 | 960193 | 2021-01-24 | Cerro Gordo | Iowa | 19033 | 4735 | 72 |
956947 | 956947 | 2021-01-23 | Cerro Gordo | Iowa | 19033 | 4725 | 72 |
953702 | 953702 | 2021-01-22 | Cerro Gordo | Iowa | 19033 | 4714 | 72 |
950457 | 950457 | 2021-01-21 | Cerro Gordo | Iowa | 19033 | 4699 | 72 |
947211 | 947211 | 2021-01-20 | Cerro Gordo | Iowa | 19033 | 4678 | 71 |
943964 | 943964 | 2021-01-19 | Cerro Gordo | Iowa | 19033 | 4667 | 68 |
940719 | 940719 | 2021-01-18 | Cerro Gordo | Iowa | 19033 | 4647 | 68 |
937474 | 937474 | 2021-01-17 | Cerro Gordo | Iowa | 19033 | 4635 | 68 |
934229 | 934229 | 2021-01-16 | Cerro Gordo | Iowa | 19033 | 4629 | 68 |
930984 | 930984 | 2021-01-15 | Cerro Gordo | Iowa | 19033 | 4619 | 66 |
927739 | 927739 | 2021-01-14 | Cerro Gordo | Iowa | 19033 | 4587 | 66 |
924493 | 924493 | 2021-01-13 | Cerro Gordo | Iowa | 19033 | 4566 | 65 |
921248 | 921248 | 2021-01-12 | Cerro Gordo | Iowa | 19033 | 4529 | 65 |
918003 | 918003 | 2021-01-11 | Cerro Gordo | Iowa | 19033 | 4528 | 64 |
914758 | 914758 | 2021-01-10 | Cerro Gordo | Iowa | 19033 | 4516 | 64 |
911513 | 911513 | 2021-01-09 | Cerro Gordo | Iowa | 19033 | 4500 | 64 |
908268 | 908268 | 2021-01-08 | Cerro Gordo | Iowa | 19033 | 4488 | 64 |
905022 | 905022 | 2021-01-07 | Cerro Gordo | Iowa | 19033 | 4463 | 63 |
901777 | 901777 | 2021-01-06 | Cerro Gordo | Iowa | 19033 | 4428 | 63 |
898532 | 898532 | 2021-01-05 | Cerro Gordo | Iowa | 19033 | 4401 | 63 |
895287 | 895287 | 2021-01-04 | Cerro Gordo | Iowa | 19033 | 4376 | 63 |
892040 | 892040 | 2021-01-03 | Cerro Gordo | Iowa | 19033 | 4361 | 62 |
888794 | 888794 | 2021-01-02 | Cerro Gordo | Iowa | 19033 | 4358 | 62 |
885548 | 885548 | 2021-01-01 | Cerro Gordo | Iowa | 19033 | 4353 | 62 |
882303 | 882303 | 2020-12-31 | Cerro Gordo | Iowa | 19033 | 4329 | 62 |
879058 | 879058 | 2020-12-30 | Cerro Gordo | Iowa | 19033 | 4309 | 61 |
875813 | 875813 | 2020-12-29 | Cerro Gordo | Iowa | 19033 | 4293 | 61 |
872568 | 872568 | 2020-12-28 | Cerro Gordo | Iowa | 19033 | 4279 | 59 |
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);