ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 6, fips = 19017 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
306822 | 306822 | 2020-07-06 | Bremer | Iowa | 19017 | 94 | 6 |
303657 | 303657 | 2020-07-05 | Bremer | Iowa | 19017 | 94 | 6 |
300493 | 300493 | 2020-07-04 | Bremer | Iowa | 19017 | 93 | 6 |
297331 | 297331 | 2020-07-03 | Bremer | Iowa | 19017 | 92 | 6 |
294173 | 294173 | 2020-07-02 | Bremer | Iowa | 19017 | 90 | 6 |
291019 | 291019 | 2020-07-01 | Bremer | Iowa | 19017 | 88 | 6 |
287869 | 287869 | 2020-06-30 | Bremer | Iowa | 19017 | 87 | 6 |
284720 | 284720 | 2020-06-29 | Bremer | Iowa | 19017 | 87 | 6 |
281575 | 281575 | 2020-06-28 | Bremer | Iowa | 19017 | 86 | 6 |
278427 | 278427 | 2020-06-27 | Bremer | Iowa | 19017 | 85 | 6 |
275279 | 275279 | 2020-06-26 | Bremer | Iowa | 19017 | 85 | 6 |
272137 | 272137 | 2020-06-25 | Bremer | Iowa | 19017 | 86 | 6 |
269000 | 269000 | 2020-06-24 | Bremer | Iowa | 19017 | 85 | 6 |
265870 | 265870 | 2020-06-23 | Bremer | Iowa | 19017 | 85 | 6 |
262742 | 262742 | 2020-06-22 | Bremer | Iowa | 19017 | 82 | 6 |
259615 | 259615 | 2020-06-21 | Bremer | Iowa | 19017 | 82 | 6 |
256489 | 256489 | 2020-06-20 | Bremer | Iowa | 19017 | 81 | 6 |
253369 | 253369 | 2020-06-19 | Bremer | Iowa | 19017 | 81 | 6 |
250254 | 250254 | 2020-06-18 | Bremer | Iowa | 19017 | 81 | 6 |
247142 | 247142 | 2020-06-17 | Bremer | Iowa | 19017 | 78 | 6 |
244029 | 244029 | 2020-06-16 | Bremer | Iowa | 19017 | 74 | 6 |
240918 | 240918 | 2020-06-15 | Bremer | Iowa | 19017 | 74 | 6 |
237810 | 237810 | 2020-06-14 | Bremer | Iowa | 19017 | 74 | 6 |
234703 | 234703 | 2020-06-13 | Bremer | Iowa | 19017 | 74 | 6 |
231597 | 231597 | 2020-06-12 | Bremer | Iowa | 19017 | 74 | 6 |
228494 | 228494 | 2020-06-11 | Bremer | Iowa | 19017 | 74 | 6 |
225392 | 225392 | 2020-06-10 | Bremer | Iowa | 19017 | 74 | 6 |
222297 | 222297 | 2020-06-09 | Bremer | Iowa | 19017 | 74 | 6 |
219202 | 219202 | 2020-06-08 | Bremer | Iowa | 19017 | 74 | 6 |
216110 | 216110 | 2020-06-07 | Bremer | Iowa | 19017 | 74 | 6 |
213023 | 213023 | 2020-06-06 | Bremer | Iowa | 19017 | 71 | 6 |
209938 | 209938 | 2020-06-05 | Bremer | Iowa | 19017 | 71 | 6 |
206857 | 206857 | 2020-06-04 | Bremer | Iowa | 19017 | 71 | 6 |
203777 | 203777 | 2020-06-03 | Bremer | Iowa | 19017 | 70 | 6 |
200701 | 200701 | 2020-06-02 | Bremer | Iowa | 19017 | 69 | 6 |
197628 | 197628 | 2020-06-01 | Bremer | Iowa | 19017 | 69 | 6 |
194558 | 194558 | 2020-05-31 | Bremer | Iowa | 19017 | 70 | 6 |
191491 | 191491 | 2020-05-30 | Bremer | Iowa | 19017 | 69 | 6 |
188426 | 188426 | 2020-05-29 | Bremer | Iowa | 19017 | 69 | 6 |
185368 | 185368 | 2020-05-28 | Bremer | Iowa | 19017 | 67 | 6 |
182314 | 182314 | 2020-05-27 | Bremer | Iowa | 19017 | 67 | 6 |
179270 | 179270 | 2020-05-26 | Bremer | Iowa | 19017 | 67 | 6 |
176226 | 176226 | 2020-05-25 | Bremer | Iowa | 19017 | 67 | 6 |
173182 | 173182 | 2020-05-24 | Bremer | Iowa | 19017 | 67 | 6 |
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);