ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where county = "Cerro Gordo" and deaths = 1 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 |
---|---|---|---|---|---|---|---|
332248 | 332248 | 2020-07-14 | Cerro Gordo | Iowa | 19033 | 345 | 1 |
329061 | 329061 | 2020-07-13 | Cerro Gordo | Iowa | 19033 | 329 | 1 |
325875 | 325875 | 2020-07-12 | Cerro Gordo | Iowa | 19033 | 317 | 1 |
322694 | 322694 | 2020-07-11 | Cerro Gordo | Iowa | 19033 | 285 | 1 |
319515 | 319515 | 2020-07-10 | Cerro Gordo | Iowa | 19033 | 271 | 1 |
316342 | 316342 | 2020-07-09 | Cerro Gordo | Iowa | 19033 | 224 | 1 |
313168 | 313168 | 2020-07-08 | Cerro Gordo | Iowa | 19033 | 206 | 1 |
309998 | 309998 | 2020-07-07 | Cerro Gordo | Iowa | 19033 | 190 | 1 |
306830 | 306830 | 2020-07-06 | Cerro Gordo | Iowa | 19033 | 182 | 1 |
303665 | 303665 | 2020-07-05 | Cerro Gordo | Iowa | 19033 | 179 | 1 |
300501 | 300501 | 2020-07-04 | Cerro Gordo | Iowa | 19033 | 157 | 1 |
297339 | 297339 | 2020-07-03 | Cerro Gordo | Iowa | 19033 | 150 | 1 |
294181 | 294181 | 2020-07-02 | Cerro Gordo | Iowa | 19033 | 138 | 1 |
291027 | 291027 | 2020-07-01 | Cerro Gordo | Iowa | 19033 | 105 | 1 |
287877 | 287877 | 2020-06-30 | Cerro Gordo | Iowa | 19033 | 99 | 1 |
284728 | 284728 | 2020-06-29 | Cerro Gordo | Iowa | 19033 | 99 | 1 |
281583 | 281583 | 2020-06-28 | Cerro Gordo | Iowa | 19033 | 93 | 1 |
278435 | 278435 | 2020-06-27 | Cerro Gordo | Iowa | 19033 | 86 | 1 |
275287 | 275287 | 2020-06-26 | Cerro Gordo | Iowa | 19033 | 81 | 1 |
272145 | 272145 | 2020-06-25 | Cerro Gordo | Iowa | 19033 | 70 | 1 |
269008 | 269008 | 2020-06-24 | Cerro Gordo | Iowa | 19033 | 68 | 1 |
265878 | 265878 | 2020-06-23 | Cerro Gordo | Iowa | 19033 | 62 | 1 |
262750 | 262750 | 2020-06-22 | Cerro Gordo | Iowa | 19033 | 61 | 1 |
259623 | 259623 | 2020-06-21 | Cerro Gordo | Iowa | 19033 | 59 | 1 |
256497 | 256497 | 2020-06-20 | Cerro Gordo | Iowa | 19033 | 58 | 1 |
253377 | 253377 | 2020-06-19 | Cerro Gordo | Iowa | 19033 | 57 | 1 |
250262 | 250262 | 2020-06-18 | Cerro Gordo | Iowa | 19033 | 54 | 1 |
247150 | 247150 | 2020-06-17 | Cerro Gordo | Iowa | 19033 | 49 | 1 |
244037 | 244037 | 2020-06-16 | Cerro Gordo | Iowa | 19033 | 49 | 1 |
240926 | 240926 | 2020-06-15 | Cerro Gordo | Iowa | 19033 | 44 | 1 |
237818 | 237818 | 2020-06-14 | Cerro Gordo | Iowa | 19033 | 42 | 1 |
234711 | 234711 | 2020-06-13 | Cerro Gordo | Iowa | 19033 | 42 | 1 |
231605 | 231605 | 2020-06-12 | Cerro Gordo | Iowa | 19033 | 41 | 1 |
228502 | 228502 | 2020-06-11 | Cerro Gordo | Iowa | 19033 | 39 | 1 |
225400 | 225400 | 2020-06-10 | Cerro Gordo | Iowa | 19033 | 37 | 1 |
222305 | 222305 | 2020-06-09 | Cerro Gordo | Iowa | 19033 | 32 | 1 |
219210 | 219210 | 2020-06-08 | Cerro Gordo | Iowa | 19033 | 32 | 1 |
216118 | 216118 | 2020-06-07 | Cerro Gordo | Iowa | 19033 | 34 | 1 |
213031 | 213031 | 2020-06-06 | Cerro Gordo | Iowa | 19033 | 34 | 1 |
209946 | 209946 | 2020-06-05 | Cerro Gordo | Iowa | 19033 | 34 | 1 |
206865 | 206865 | 2020-06-04 | Cerro Gordo | Iowa | 19033 | 33 | 1 |
203785 | 203785 | 2020-06-03 | Cerro Gordo | Iowa | 19033 | 30 | 1 |
200709 | 200709 | 2020-06-02 | Cerro Gordo | Iowa | 19033 | 29 | 1 |
197636 | 197636 | 2020-06-01 | Cerro Gordo | Iowa | 19033 | 29 | 1 |
194566 | 194566 | 2020-05-31 | Cerro Gordo | Iowa | 19033 | 29 | 1 |
191499 | 191499 | 2020-05-30 | Cerro Gordo | Iowa | 19033 | 29 | 1 |
188434 | 188434 | 2020-05-29 | Cerro Gordo | Iowa | 19033 | 27 | 1 |
185376 | 185376 | 2020-05-28 | Cerro Gordo | Iowa | 19033 | 25 | 1 |
182322 | 182322 | 2020-05-27 | Cerro Gordo | Iowa | 19033 | 24 | 1 |
179278 | 179278 | 2020-05-26 | Cerro Gordo | Iowa | 19033 | 22 | 1 |
176234 | 176234 | 2020-05-25 | Cerro Gordo | Iowa | 19033 | 22 | 1 |
173190 | 173190 | 2020-05-24 | Cerro Gordo | Iowa | 19033 | 22 | 1 |
170149 | 170149 | 2020-05-23 | Cerro Gordo | Iowa | 19033 | 20 | 1 |
167112 | 167112 | 2020-05-22 | Cerro Gordo | Iowa | 19033 | 20 | 1 |
164079 | 164079 | 2020-05-21 | Cerro Gordo | Iowa | 19033 | 19 | 1 |
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);