ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 19153 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386806 | 386806 | 2020-07-31 | Polk | Iowa | 19153 | 9479 | 201 |
383588 | 383588 | 2020-07-30 | Polk | Iowa | 19153 | 9388 | 201 |
380371 | 380371 | 2020-07-29 | Polk | Iowa | 19153 | 9262 | 193 |
377154 | 377154 | 2020-07-28 | Polk | Iowa | 19153 | 9126 | 193 |
373939 | 373939 | 2020-07-27 | Polk | Iowa | 19153 | 9109 | 193 |
370727 | 370727 | 2020-07-26 | Polk | Iowa | 19153 | 9080 | 191 |
367517 | 367517 | 2020-07-25 | Polk | Iowa | 19153 | 8985 | 191 |
364310 | 364310 | 2020-07-24 | Polk | Iowa | 19153 | 8906 | 191 |
361103 | 361103 | 2020-07-23 | Polk | Iowa | 19153 | 8786 | 191 |
357898 | 357898 | 2020-07-22 | Polk | Iowa | 19153 | 8644 | 191 |
354696 | 354696 | 2020-07-21 | Polk | Iowa | 19153 | 8557 | 189 |
351494 | 351494 | 2020-07-20 | Polk | Iowa | 19153 | 8465 | 189 |
348294 | 348294 | 2020-07-19 | Polk | Iowa | 19153 | 8354 | 189 |
345093 | 345093 | 2020-07-18 | Polk | Iowa | 19153 | 8244 | 189 |
341893 | 341893 | 2020-07-17 | Polk | Iowa | 19153 | 8121 | 188 |
338697 | 338697 | 2020-07-16 | Polk | Iowa | 19153 | 8001 | 188 |
335501 | 335501 | 2020-07-15 | Polk | Iowa | 19153 | 7803 | 188 |
332308 | 332308 | 2020-07-14 | Polk | Iowa | 19153 | 7679 | 186 |
329121 | 329121 | 2020-07-13 | Polk | Iowa | 19153 | 7611 | 185 |
325935 | 325935 | 2020-07-12 | Polk | Iowa | 19153 | 7538 | 185 |
322754 | 322754 | 2020-07-11 | Polk | Iowa | 19153 | 7334 | 184 |
319575 | 319575 | 2020-07-10 | Polk | Iowa | 19153 | 7212 | 184 |
316402 | 316402 | 2020-07-09 | Polk | Iowa | 19153 | 7002 | 182 |
313228 | 313228 | 2020-07-08 | Polk | Iowa | 19153 | 6846 | 182 |
310058 | 310058 | 2020-07-07 | Polk | Iowa | 19153 | 6739 | 181 |
306890 | 306890 | 2020-07-06 | Polk | Iowa | 19153 | 6638 | 180 |
303725 | 303725 | 2020-07-05 | Polk | Iowa | 19153 | 6614 | 179 |
300561 | 300561 | 2020-07-04 | Polk | Iowa | 19153 | 6494 | 179 |
297399 | 297399 | 2020-07-03 | Polk | Iowa | 19153 | 6366 | 179 |
294241 | 294241 | 2020-07-02 | Polk | Iowa | 19153 | 6275 | 178 |
291087 | 291087 | 2020-07-01 | Polk | Iowa | 19153 | 6139 | 178 |
287937 | 287937 | 2020-06-30 | Polk | Iowa | 19153 | 6046 | 177 |
284788 | 284788 | 2020-06-29 | Polk | Iowa | 19153 | 6007 | 177 |
281643 | 281643 | 2020-06-28 | Polk | Iowa | 19153 | 5947 | 174 |
278495 | 278495 | 2020-06-27 | Polk | Iowa | 19153 | 5881 | 174 |
275347 | 275347 | 2020-06-26 | Polk | Iowa | 19153 | 5800 | 174 |
272205 | 272205 | 2020-06-25 | Polk | Iowa | 19153 | 5738 | 174 |
269068 | 269068 | 2020-06-24 | Polk | Iowa | 19153 | 5645 | 171 |
265938 | 265938 | 2020-06-23 | Polk | Iowa | 19153 | 5582 | 169 |
262810 | 262810 | 2020-06-22 | Polk | Iowa | 19153 | 5548 | 168 |
259683 | 259683 | 2020-06-21 | Polk | Iowa | 19153 | 5508 | 167 |
256557 | 256557 | 2020-06-20 | Polk | Iowa | 19153 | 5436 | 166 |
253437 | 253437 | 2020-06-19 | Polk | Iowa | 19153 | 5410 | 165 |
250322 | 250322 | 2020-06-18 | Polk | Iowa | 19153 | 5323 | 165 |
247210 | 247210 | 2020-06-17 | Polk | Iowa | 19153 | 5276 | 164 |
244097 | 244097 | 2020-06-16 | Polk | Iowa | 19153 | 5210 | 163 |
240986 | 240986 | 2020-06-15 | Polk | Iowa | 19153 | 5180 | 163 |
237878 | 237878 | 2020-06-14 | Polk | Iowa | 19153 | 5169 | 161 |
234771 | 234771 | 2020-06-13 | Polk | Iowa | 19153 | 5119 | 160 |
231665 | 231665 | 2020-06-12 | Polk | Iowa | 19153 | 5046 | 159 |
228562 | 228562 | 2020-06-11 | Polk | Iowa | 19153 | 4991 | 156 |
225460 | 225460 | 2020-06-10 | Polk | Iowa | 19153 | 4924 | 155 |
222365 | 222365 | 2020-06-09 | Polk | Iowa | 19153 | 4868 | 151 |
219270 | 219270 | 2020-06-08 | Polk | Iowa | 19153 | 4841 | 150 |
216178 | 216178 | 2020-06-07 | Polk | Iowa | 19153 | 4750 | 144 |
213091 | 213091 | 2020-06-06 | Polk | Iowa | 19153 | 4691 | 143 |
210006 | 210006 | 2020-06-05 | Polk | Iowa | 19153 | 4650 | 142 |
206925 | 206925 | 2020-06-04 | Polk | Iowa | 19153 | 4565 | 139 |
203845 | 203845 | 2020-06-03 | Polk | Iowa | 19153 | 4418 | 134 |
200769 | 200769 | 2020-06-02 | Polk | Iowa | 19153 | 4344 | 133 |
197696 | 197696 | 2020-06-01 | Polk | Iowa | 19153 | 4269 | 133 |
194626 | 194626 | 2020-05-31 | Polk | Iowa | 19153 | 4239 | 126 |
191559 | 191559 | 2020-05-30 | Polk | Iowa | 19153 | 4189 | 125 |
188494 | 188494 | 2020-05-29 | Polk | Iowa | 19153 | 4072 | 123 |
185436 | 185436 | 2020-05-28 | Polk | Iowa | 19153 | 3959 | 119 |
182382 | 182382 | 2020-05-27 | Polk | Iowa | 19153 | 3890 | 115 |
179337 | 179337 | 2020-05-26 | Polk | Iowa | 19153 | 3833 | 112 |
176293 | 176293 | 2020-05-25 | Polk | Iowa | 19153 | 3795 | 109 |
173249 | 173249 | 2020-05-24 | Polk | Iowa | 19153 | 3744 | 108 |
170208 | 170208 | 2020-05-23 | Polk | Iowa | 19153 | 3525 | 105 |
167171 | 167171 | 2020-05-22 | Polk | Iowa | 19153 | 3525 | 105 |
164138 | 164138 | 2020-05-21 | Polk | Iowa | 19153 | 3381 | 91 |
161110 | 161110 | 2020-05-20 | Polk | Iowa | 19153 | 3298 | 90 |
158084 | 158084 | 2020-05-19 | Polk | Iowa | 19153 | 3128 | 83 |
155068 | 155068 | 2020-05-18 | Polk | Iowa | 19153 | 3001 | 81 |
152056 | 152056 | 2020-05-17 | Polk | Iowa | 19153 | 2922 | 79 |
149045 | 149045 | 2020-05-16 | Polk | Iowa | 19153 | 2845 | 78 |
146041 | 146041 | 2020-05-15 | Polk | Iowa | 19153 | 2767 | 76 |
143041 | 143041 | 2020-05-14 | Polk | Iowa | 19153 | 2634 | 67 |
140045 | 140045 | 2020-05-13 | Polk | Iowa | 19153 | 2551 | 65 |
137052 | 137052 | 2020-05-12 | Polk | Iowa | 19153 | 2447 | 64 |
134062 | 134062 | 2020-05-11 | Polk | Iowa | 19153 | 2368 | 61 |
131072 | 131072 | 2020-05-10 | Polk | Iowa | 19153 | 2238 | 60 |
128081 | 128081 | 2020-05-09 | Polk | Iowa | 19153 | 2194 | 58 |
125094 | 125094 | 2020-05-08 | Polk | Iowa | 19153 | 2150 | 54 |
122112 | 122112 | 2020-05-07 | Polk | Iowa | 19153 | 2053 | 54 |
119142 | 119142 | 2020-05-06 | Polk | Iowa | 19153 | 1875 | 45 |
116182 | 116182 | 2020-05-05 | Polk | Iowa | 19153 | 1778 | 42 |
113299 | 113299 | 2020-05-04 | Polk | Iowa | 19153 | 1661 | 40 |
110424 | 110424 | 2020-05-03 | Polk | Iowa | 19153 | 1476 | 40 |
107553 | 107553 | 2020-05-02 | Polk | Iowa | 19153 | 1350 | 38 |
104688 | 104688 | 2020-05-01 | Polk | Iowa | 19153 | 1176 | 37 |
101830 | 101830 | 2020-04-30 | Polk | Iowa | 19153 | 985 | 35 |
98979 | 98979 | 2020-04-29 | Polk | Iowa | 19153 | 905 | 32 |
96134 | 96134 | 2020-04-28 | Polk | Iowa | 19153 | 813 | 31 |
93302 | 93302 | 2020-04-27 | Polk | Iowa | 19153 | 756 | 27 |
90482 | 90482 | 2020-04-26 | Polk | Iowa | 19153 | 732 | 24 |
87666 | 87666 | 2020-04-25 | Polk | Iowa | 19153 | 660 | 24 |
84856 | 84856 | 2020-04-24 | Polk | Iowa | 19153 | 575 | 22 |
82056 | 82056 | 2020-04-23 | Polk | Iowa | 19153 | 486 | 20 |
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);