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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 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
- …
county >30
- 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
- …
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);