ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 19177 and state = "Iowa" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
20294 | 20294 | 2020-03-30 | Van Buren | Iowa | 19177 | 1 | 0 |
22390 | 22390 | 2020-03-31 | Van Buren | Iowa | 19177 | 1 | 0 |
24565 | 24565 | 2020-04-01 | Van Buren | Iowa | 19177 | 2 | 0 |
26807 | 26807 | 2020-04-02 | Van Buren | Iowa | 19177 | 3 | 0 |
29121 | 29121 | 2020-04-03 | Van Buren | Iowa | 19177 | 5 | 0 |
31493 | 31493 | 2020-04-04 | Van Buren | Iowa | 19177 | 6 | 0 |
33906 | 33906 | 2020-04-05 | Van Buren | Iowa | 19177 | 6 | 0 |
36362 | 36362 | 2020-04-06 | Van Buren | Iowa | 19177 | 6 | 0 |
38863 | 38863 | 2020-04-07 | Van Buren | Iowa | 19177 | 6 | 0 |
41409 | 41409 | 2020-04-08 | Van Buren | Iowa | 19177 | 6 | 0 |
43985 | 43985 | 2020-04-09 | Van Buren | Iowa | 19177 | 6 | 0 |
46592 | 46592 | 2020-04-10 | Van Buren | Iowa | 19177 | 6 | 0 |
49226 | 49226 | 2020-04-11 | Van Buren | Iowa | 19177 | 6 | 0 |
51890 | 51890 | 2020-04-12 | Van Buren | Iowa | 19177 | 6 | 0 |
54572 | 54572 | 2020-04-13 | Van Buren | Iowa | 19177 | 8 | 0 |
57265 | 57265 | 2020-04-14 | Van Buren | Iowa | 19177 | 8 | 0 |
59973 | 59973 | 2020-04-15 | Van Buren | Iowa | 19177 | 8 | 0 |
62694 | 62694 | 2020-04-16 | Van Buren | Iowa | 19177 | 8 | 0 |
65429 | 65429 | 2020-04-17 | Van Buren | Iowa | 19177 | 8 | 0 |
68178 | 68178 | 2020-04-18 | Van Buren | Iowa | 19177 | 8 | 0 |
70939 | 70939 | 2020-04-19 | Van Buren | Iowa | 19177 | 8 | 0 |
73710 | 73710 | 2020-04-20 | Van Buren | Iowa | 19177 | 8 | 0 |
76490 | 76490 | 2020-04-21 | Van Buren | Iowa | 19177 | 8 | 0 |
79274 | 79274 | 2020-04-22 | Van Buren | Iowa | 19177 | 8 | 0 |
82066 | 82066 | 2020-04-23 | Van Buren | Iowa | 19177 | 8 | 0 |
84867 | 84867 | 2020-04-24 | Van Buren | Iowa | 19177 | 8 | 0 |
87676 | 87676 | 2020-04-25 | Van Buren | Iowa | 19177 | 8 | 0 |
90492 | 90492 | 2020-04-26 | Van Buren | Iowa | 19177 | 8 | 0 |
93313 | 93313 | 2020-04-27 | Van Buren | Iowa | 19177 | 8 | 0 |
96145 | 96145 | 2020-04-28 | Van Buren | Iowa | 19177 | 8 | 0 |
98990 | 98990 | 2020-04-29 | Van Buren | Iowa | 19177 | 8 | 0 |
101841 | 101841 | 2020-04-30 | Van Buren | Iowa | 19177 | 8 | 0 |
104700 | 104700 | 2020-05-01 | Van Buren | Iowa | 19177 | 8 | 0 |
107565 | 107565 | 2020-05-02 | Van Buren | Iowa | 19177 | 8 | 0 |
110436 | 110436 | 2020-05-03 | Van Buren | Iowa | 19177 | 8 | 0 |
113311 | 113311 | 2020-05-04 | Van Buren | Iowa | 19177 | 8 | 0 |
116193 | 116193 | 2020-05-05 | Van Buren | Iowa | 19177 | 8 | 0 |
119154 | 119154 | 2020-05-06 | Van Buren | Iowa | 19177 | 8 | 0 |
122124 | 122124 | 2020-05-07 | Van Buren | Iowa | 19177 | 8 | 0 |
125106 | 125106 | 2020-05-08 | Van Buren | Iowa | 19177 | 8 | 0 |
128093 | 128093 | 2020-05-09 | Van Buren | Iowa | 19177 | 8 | 0 |
131083 | 131083 | 2020-05-10 | Van Buren | Iowa | 19177 | 8 | 0 |
134074 | 134074 | 2020-05-11 | Van Buren | Iowa | 19177 | 8 | 0 |
137064 | 137064 | 2020-05-12 | Van Buren | Iowa | 19177 | 8 | 0 |
140057 | 140057 | 2020-05-13 | Van Buren | Iowa | 19177 | 8 | 0 |
143053 | 143053 | 2020-05-14 | Van Buren | Iowa | 19177 | 8 | 0 |
146053 | 146053 | 2020-05-15 | Van Buren | Iowa | 19177 | 8 | 0 |
149057 | 149057 | 2020-05-16 | Van Buren | Iowa | 19177 | 8 | 0 |
152068 | 152068 | 2020-05-17 | Van Buren | Iowa | 19177 | 8 | 0 |
155080 | 155080 | 2020-05-18 | Van Buren | Iowa | 19177 | 8 | 0 |
158097 | 158097 | 2020-05-19 | Van Buren | Iowa | 19177 | 8 | 0 |
161122 | 161122 | 2020-05-20 | Van Buren | Iowa | 19177 | 8 | 0 |
164151 | 164151 | 2020-05-21 | Van Buren | Iowa | 19177 | 8 | 0 |
167183 | 167183 | 2020-05-22 | Van Buren | Iowa | 19177 | 8 | 0 |
170221 | 170221 | 2020-05-23 | Van Buren | Iowa | 19177 | 8 | 0 |
173262 | 173262 | 2020-05-24 | Van Buren | Iowa | 19177 | 10 | 0 |
176306 | 176306 | 2020-05-25 | Van Buren | Iowa | 19177 | 10 | 0 |
179350 | 179350 | 2020-05-26 | Van Buren | Iowa | 19177 | 9 | 0 |
182395 | 182395 | 2020-05-27 | Van Buren | Iowa | 19177 | 9 | 0 |
185449 | 185449 | 2020-05-28 | Van Buren | Iowa | 19177 | 9 | 0 |
188507 | 188507 | 2020-05-29 | Van Buren | Iowa | 19177 | 9 | 0 |
191571 | 191571 | 2020-05-30 | Van Buren | Iowa | 19177 | 9 | 0 |
194639 | 194639 | 2020-05-31 | Van Buren | Iowa | 19177 | 9 | 0 |
197709 | 197709 | 2020-06-01 | Van Buren | Iowa | 19177 | 9 | 0 |
200781 | 200781 | 2020-06-02 | Van Buren | Iowa | 19177 | 9 | 0 |
203857 | 203857 | 2020-06-03 | Van Buren | Iowa | 19177 | 9 | 0 |
206938 | 206938 | 2020-06-04 | Van Buren | Iowa | 19177 | 9 | 0 |
210019 | 210019 | 2020-06-05 | Van Buren | Iowa | 19177 | 9 | 0 |
213104 | 213104 | 2020-06-06 | Van Buren | Iowa | 19177 | 9 | 0 |
216191 | 216191 | 2020-06-07 | Van Buren | Iowa | 19177 | 10 | 0 |
219283 | 219283 | 2020-06-08 | Van Buren | Iowa | 19177 | 10 | 0 |
222378 | 222378 | 2020-06-09 | Van Buren | Iowa | 19177 | 10 | 0 |
225473 | 225473 | 2020-06-10 | Van Buren | Iowa | 19177 | 11 | 0 |
228575 | 228575 | 2020-06-11 | Van Buren | Iowa | 19177 | 11 | 0 |
231678 | 231678 | 2020-06-12 | Van Buren | Iowa | 19177 | 11 | 0 |
234784 | 234784 | 2020-06-13 | Van Buren | Iowa | 19177 | 11 | 0 |
237891 | 237891 | 2020-06-14 | Van Buren | Iowa | 19177 | 11 | 0 |
240999 | 240999 | 2020-06-15 | Van Buren | Iowa | 19177 | 11 | 0 |
244110 | 244110 | 2020-06-16 | Van Buren | Iowa | 19177 | 12 | 0 |
247223 | 247223 | 2020-06-17 | Van Buren | Iowa | 19177 | 11 | 0 |
250335 | 250335 | 2020-06-18 | Van Buren | Iowa | 19177 | 11 | 0 |
253450 | 253450 | 2020-06-19 | Van Buren | Iowa | 19177 | 11 | 0 |
256570 | 256570 | 2020-06-20 | Van Buren | Iowa | 19177 | 12 | 0 |
259696 | 259696 | 2020-06-21 | Van Buren | Iowa | 19177 | 12 | 0 |
262823 | 262823 | 2020-06-22 | Van Buren | Iowa | 19177 | 14 | 0 |
265951 | 265951 | 2020-06-23 | Van Buren | Iowa | 19177 | 16 | 0 |
269081 | 269081 | 2020-06-24 | Van Buren | Iowa | 19177 | 17 | 0 |
272218 | 272218 | 2020-06-25 | Van Buren | Iowa | 19177 | 17 | 0 |
275360 | 275360 | 2020-06-26 | Van Buren | Iowa | 19177 | 18 | 0 |
278508 | 278508 | 2020-06-27 | Van Buren | Iowa | 19177 | 18 | 0 |
281656 | 281656 | 2020-06-28 | Van Buren | Iowa | 19177 | 18 | 0 |
284801 | 284801 | 2020-06-29 | Van Buren | Iowa | 19177 | 19 | 0 |
287950 | 287950 | 2020-06-30 | Van Buren | Iowa | 19177 | 19 | 0 |
291100 | 291100 | 2020-07-01 | Van Buren | Iowa | 19177 | 20 | 0 |
294254 | 294254 | 2020-07-02 | Van Buren | Iowa | 19177 | 19 | 0 |
297412 | 297412 | 2020-07-03 | Van Buren | Iowa | 19177 | 19 | 0 |
300574 | 300574 | 2020-07-04 | Van Buren | Iowa | 19177 | 20 | 0 |
303738 | 303738 | 2020-07-05 | Van Buren | Iowa | 19177 | 21 | 0 |
306903 | 306903 | 2020-07-06 | Van Buren | Iowa | 19177 | 22 | 0 |
310071 | 310071 | 2020-07-07 | Van Buren | Iowa | 19177 | 21 | 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);