ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,070 rows where state = "Iowa" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 100
- 19103 797
- 19155 796
- 19027 793
- 19085 792
- 19049 791
- 19005 790
- 19153 790
- 19001 788
- 19013 788
- 19183 787
- 19191 787
- 19061 786
- 19139 786
- 19065 784
- 19087 784
- 19113 784
- 19169 784
- 19033 783
- 19109 783
- 19157 783
- 19163 783
- 19167 783
- 19171 783
- 19193 783
- 19081 782
- 19179 782
- 19019 781
- 19031 781
- 19099 781
- 19181 781
- 19011 780
- 19007 779
- 19043 779
- 19057 779
- 19123 779
- 19133 779
- 19145 779
- 19023 778
- 19045 778
- 19059 778
- 19083 778
- 19095 778
- 19127 778
- 19137 778
- 19187 778
- 19197 778
- 19015 777
- 19107 777
- 19165 777
- 19173 777
- 19009 775
- 19047 775
- 19077 775
- 19097 775
- 19105 775
- 19177 775
- 19041 774
- 19121 773
- 19131 773
- 19017 772
- 19101 772
- 19141 772
- 19115 771
- 19119 771
- 19149 771
- 19075 770
- 19089 770
- 19111 770
- 19129 770
- 19039 769
- 19079 769
- 19037 768
- 19069 768
- 19125 768
- 19189 768
- 19021 767
- 19055 767
- 19073 767
- 19195 766
- 19143 764
- 19175 764
- 19029 761
- 19035 753
- 19091 753
- 19151 747
- 19051 745
- 19025 743
- 19067 743
- 19161 743
- 19185 743
- - 743
- 19135 741
- 19071 736
- 19147 736
- 19093 732
- 19063 731
- 19003 727
- 19117 727
- 19159 725
- 19053 717
county 100
- Johnson 797
- Pottawattamie 796
- Carroll 793
- Harrison 792
- Dallas 791
- Allamakee 790
- Polk 790
- Adair 788
- Black Hawk 788
- Washington 787
- Winneshiek 787
- Dubuque 786
- Muscatine 786
- Fayette 784
- Henry 784
- Linn 784
- Story 784
- Cerro Gordo 783
- Kossuth 783
- Poweshiek 783
- Scott 783
- Sioux 783
- Tama 783
- Woodbury 783
- Hancock 782
- Wapello 782
- Buchanan 781
- Cedar 781
- Jasper 781
- Warren 781
- Benton 780
- Appanoose 779
- Clayton 779
- Des Moines 779
- Mahaska 779
- Monona 779
- Page 779
- Butler 778
- Clinton 778
- Dickinson 778
- Hardin 778
- Iowa 778
- Marshall 778
- Montgomery 778
- Webster 778
- Wright 778
- Boone 777
- Keokuk 777
- Shelby 777
- Taylor 777
- Audubon 775
- Crawford 775
- Guthrie 775
- Jackson 775
- Jones 775
- Van Buren 775
- Clay 774
- Madison 773
- Mitchell 773
- Bremer 772
- Jefferson 772
- O'Brien 772
- Louisa 771
- Lyon 771
- Plymouth 771
- Grundy 770
- Howard 770
- Lee 770
- Mills 770
- Clarke 769
- Hamilton 769
- Chickasaw 768
- Franklin 768
- Marion 768
- Winnebago 768
- Buena Vista 767
- Delaware 767
- Greene 767
- Worth 766
- Osceola 764
- Union 764
- Cass 761
- Cherokee 753
- Humboldt 753
- Pocahontas 747
- Davis 745
- Calhoun 743
- Floyd 743
- Sac 743
- Unknown 743
- Wayne 743
- Monroe 741
- Fremont 736
- Palo Alto 736
- Ida 732
- Emmet 731
- Adams 727
- Lucas 727
- Ringgold 725
- Decatur 717
state 1
- Iowa · 77,070 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
3389 | 3389 | 2020-03-17 | Adair | Iowa | 19001 | 1 | 0 |
3963 | 3963 | 2020-03-18 | Adair | Iowa | 19001 | 1 | 0 |
4642 | 4642 | 2020-03-19 | Adair | Iowa | 19001 | 1 | 0 |
5453 | 5453 | 2020-03-20 | Adair | Iowa | 19001 | 1 | 0 |
6394 | 6394 | 2020-03-21 | Adair | Iowa | 19001 | 1 | 0 |
7454 | 7454 | 2020-03-22 | Adair | Iowa | 19001 | 1 | 0 |
8612 | 8612 | 2020-03-23 | Adair | Iowa | 19001 | 1 | 0 |
9888 | 9888 | 2020-03-24 | Adair | Iowa | 19001 | 1 | 0 |
11284 | 11284 | 2020-03-25 | Adair | Iowa | 19001 | 1 | 0 |
12845 | 12845 | 2020-03-26 | Adair | Iowa | 19001 | 1 | 0 |
14532 | 14532 | 2020-03-27 | Adair | Iowa | 19001 | 1 | 0 |
16335 | 16335 | 2020-03-28 | Adair | Iowa | 19001 | 1 | 0 |
18240 | 18240 | 2020-03-29 | Adair | Iowa | 19001 | 1 | 0 |
20246 | 20246 | 2020-03-30 | Adair | Iowa | 19001 | 1 | 0 |
22341 | 22341 | 2020-03-31 | Adair | Iowa | 19001 | 1 | 0 |
24513 | 24513 | 2020-04-01 | Adair | Iowa | 19001 | 1 | 0 |
26753 | 26753 | 2020-04-02 | Adair | Iowa | 19001 | 1 | 0 |
29064 | 29064 | 2020-04-03 | Adair | Iowa | 19001 | 1 | 0 |
31432 | 31432 | 2020-04-04 | Adair | Iowa | 19001 | 1 | 0 |
33843 | 33843 | 2020-04-05 | Adair | Iowa | 19001 | 1 | 0 |
36296 | 36296 | 2020-04-06 | Adair | Iowa | 19001 | 1 | 0 |
38794 | 38794 | 2020-04-07 | Adair | Iowa | 19001 | 1 | 0 |
41340 | 41340 | 2020-04-08 | Adair | Iowa | 19001 | 1 | 0 |
43916 | 43916 | 2020-04-09 | Adair | Iowa | 19001 | 1 | 0 |
46521 | 46521 | 2020-04-10 | Adair | Iowa | 19001 | 1 | 0 |
49155 | 49155 | 2020-04-11 | Adair | Iowa | 19001 | 1 | 0 |
51819 | 51819 | 2020-04-12 | Adair | Iowa | 19001 | 1 | 0 |
54500 | 54500 | 2020-04-13 | Adair | Iowa | 19001 | 1 | 0 |
57193 | 57193 | 2020-04-14 | Adair | Iowa | 19001 | 1 | 0 |
59901 | 59901 | 2020-04-15 | Adair | Iowa | 19001 | 1 | 0 |
62622 | 62622 | 2020-04-16 | Adair | Iowa | 19001 | 1 | 0 |
65356 | 65356 | 2020-04-17 | Adair | Iowa | 19001 | 1 | 0 |
68105 | 68105 | 2020-04-18 | Adair | Iowa | 19001 | 1 | 0 |
70867 | 70867 | 2020-04-19 | Adair | Iowa | 19001 | 1 | 0 |
73638 | 73638 | 2020-04-20 | Adair | Iowa | 19001 | 1 | 0 |
76415 | 76415 | 2020-04-21 | Adair | Iowa | 19001 | 1 | 0 |
79199 | 79199 | 2020-04-22 | Adair | Iowa | 19001 | 1 | 0 |
81992 | 81992 | 2020-04-23 | Adair | Iowa | 19001 | 1 | 0 |
84792 | 84792 | 2020-04-24 | Adair | Iowa | 19001 | 1 | 0 |
87602 | 87602 | 2020-04-25 | Adair | Iowa | 19001 | 1 | 0 |
90418 | 90418 | 2020-04-26 | Adair | Iowa | 19001 | 1 | 0 |
93237 | 93237 | 2020-04-27 | Adair | Iowa | 19001 | 1 | 0 |
96069 | 96069 | 2020-04-28 | Adair | Iowa | 19001 | 1 | 0 |
98913 | 98913 | 2020-04-29 | Adair | Iowa | 19001 | 1 | 0 |
101764 | 101764 | 2020-04-30 | Adair | Iowa | 19001 | 1 | 0 |
104620 | 104620 | 2020-05-01 | Adair | Iowa | 19001 | 1 | 0 |
107485 | 107485 | 2020-05-02 | Adair | Iowa | 19001 | 1 | 0 |
110355 | 110355 | 2020-05-03 | Adair | Iowa | 19001 | 1 | 0 |
113230 | 113230 | 2020-05-04 | Adair | Iowa | 19001 | 1 | 0 |
116113 | 116113 | 2020-05-05 | Adair | Iowa | 19001 | 2 | 0 |
119073 | 119073 | 2020-05-06 | Adair | Iowa | 19001 | 3 | 0 |
122043 | 122043 | 2020-05-07 | Adair | Iowa | 19001 | 3 | 0 |
125023 | 125023 | 2020-05-08 | Adair | Iowa | 19001 | 3 | 0 |
128010 | 128010 | 2020-05-09 | Adair | Iowa | 19001 | 3 | 0 |
131001 | 131001 | 2020-05-10 | Adair | Iowa | 19001 | 3 | 0 |
133991 | 133991 | 2020-05-11 | Adair | Iowa | 19001 | 3 | 0 |
136980 | 136980 | 2020-05-12 | Adair | Iowa | 19001 | 3 | 0 |
139972 | 139972 | 2020-05-13 | Adair | Iowa | 19001 | 4 | 0 |
142968 | 142968 | 2020-05-14 | Adair | Iowa | 19001 | 4 | 0 |
145968 | 145968 | 2020-05-15 | Adair | Iowa | 19001 | 4 | 0 |
148972 | 148972 | 2020-05-16 | Adair | Iowa | 19001 | 4 | 0 |
151981 | 151981 | 2020-05-17 | Adair | Iowa | 19001 | 5 | 0 |
154993 | 154993 | 2020-05-18 | Adair | Iowa | 19001 | 6 | 0 |
158009 | 158009 | 2020-05-19 | Adair | Iowa | 19001 | 6 | 0 |
161035 | 161035 | 2020-05-20 | Adair | Iowa | 19001 | 6 | 0 |
164063 | 164063 | 2020-05-21 | Adair | Iowa | 19001 | 6 | 0 |
167096 | 167096 | 2020-05-22 | Adair | Iowa | 19001 | 6 | 0 |
170133 | 170133 | 2020-05-23 | Adair | Iowa | 19001 | 6 | 0 |
173174 | 173174 | 2020-05-24 | Adair | Iowa | 19001 | 8 | 0 |
176218 | 176218 | 2020-05-25 | Adair | Iowa | 19001 | 8 | 0 |
179262 | 179262 | 2020-05-26 | Adair | Iowa | 19001 | 7 | 0 |
182306 | 182306 | 2020-05-27 | Adair | Iowa | 19001 | 8 | 0 |
185360 | 185360 | 2020-05-28 | Adair | Iowa | 19001 | 8 | 0 |
188418 | 188418 | 2020-05-29 | Adair | Iowa | 19001 | 9 | 0 |
191483 | 191483 | 2020-05-30 | Adair | Iowa | 19001 | 9 | 0 |
194550 | 194550 | 2020-05-31 | Adair | Iowa | 19001 | 9 | 0 |
197620 | 197620 | 2020-06-01 | Adair | Iowa | 19001 | 9 | 0 |
200693 | 200693 | 2020-06-02 | Adair | Iowa | 19001 | 9 | 0 |
203769 | 203769 | 2020-06-03 | Adair | Iowa | 19001 | 9 | 0 |
206849 | 206849 | 2020-06-04 | Adair | Iowa | 19001 | 9 | 0 |
209930 | 209930 | 2020-06-05 | Adair | Iowa | 19001 | 9 | 0 |
213015 | 213015 | 2020-06-06 | Adair | Iowa | 19001 | 9 | 0 |
216102 | 216102 | 2020-06-07 | Adair | Iowa | 19001 | 9 | 0 |
219194 | 219194 | 2020-06-08 | Adair | Iowa | 19001 | 9 | 0 |
222289 | 222289 | 2020-06-09 | Adair | Iowa | 19001 | 10 | 0 |
225384 | 225384 | 2020-06-10 | Adair | Iowa | 19001 | 10 | 0 |
228486 | 228486 | 2020-06-11 | Adair | Iowa | 19001 | 11 | 0 |
231589 | 231589 | 2020-06-12 | Adair | Iowa | 19001 | 11 | 0 |
234695 | 234695 | 2020-06-13 | Adair | Iowa | 19001 | 11 | 0 |
237802 | 237802 | 2020-06-14 | Adair | Iowa | 19001 | 11 | 0 |
240910 | 240910 | 2020-06-15 | Adair | Iowa | 19001 | 11 | 0 |
244021 | 244021 | 2020-06-16 | Adair | Iowa | 19001 | 12 | 0 |
247134 | 247134 | 2020-06-17 | Adair | Iowa | 19001 | 12 | 0 |
250246 | 250246 | 2020-06-18 | Adair | Iowa | 19001 | 12 | 0 |
253361 | 253361 | 2020-06-19 | Adair | Iowa | 19001 | 12 | 0 |
256481 | 256481 | 2020-06-20 | Adair | Iowa | 19001 | 12 | 0 |
259607 | 259607 | 2020-06-21 | Adair | Iowa | 19001 | 12 | 0 |
262734 | 262734 | 2020-06-22 | Adair | Iowa | 19001 | 12 | 0 |
265862 | 265862 | 2020-06-23 | Adair | Iowa | 19001 | 12 | 0 |
268992 | 268992 | 2020-06-24 | Adair | Iowa | 19001 | 13 | 0 |
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);