ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-06-10" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Adair 1
- Adams 1
- Allamakee 1
- Appanoose 1
- Audubon 1
- Benton 1
- Black Hawk 1
- Boone 1
- Bremer 1
- Buchanan 1
- Buena Vista 1
- Butler 1
- Calhoun 1
- Carroll 1
- Cass 1
- Cedar 1
- Cerro Gordo 1
- Cherokee 1
- Chickasaw 1
- Clarke 1
- Clay 1
- Clayton 1
- Clinton 1
- Crawford 1
- Dallas 1
- Davis 1
- Decatur 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- …
state 1
- Iowa · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
225384 | 225384 | 2020-06-10 | Adair | Iowa | 19001 | 10 | 0 |
225385 | 225385 | 2020-06-10 | Adams | Iowa | 19003 | 7 | 0 |
225386 | 225386 | 2020-06-10 | Allamakee | Iowa | 19005 | 121 | 4 |
225387 | 225387 | 2020-06-10 | Appanoose | Iowa | 19007 | 16 | 3 |
225388 | 225388 | 2020-06-10 | Audubon | Iowa | 19009 | 14 | 1 |
225389 | 225389 | 2020-06-10 | Benton | Iowa | 19011 | 46 | 1 |
225390 | 225390 | 2020-06-10 | Black Hawk | Iowa | 19013 | 1817 | 53 |
225391 | 225391 | 2020-06-10 | Boone | Iowa | 19015 | 79 | 0 |
225392 | 225392 | 2020-06-10 | Bremer | Iowa | 19017 | 74 | 6 |
225393 | 225393 | 2020-06-10 | Buchanan | Iowa | 19019 | 34 | 1 |
225394 | 225394 | 2020-06-10 | Buena Vista | Iowa | 19021 | 1359 | 4 |
225395 | 225395 | 2020-06-10 | Butler | Iowa | 19023 | 19 | 2 |
225396 | 225396 | 2020-06-10 | Calhoun | Iowa | 19025 | 16 | 0 |
225397 | 225397 | 2020-06-10 | Carroll | Iowa | 19027 | 18 | 1 |
225398 | 225398 | 2020-06-10 | Cass | Iowa | 19029 | 13 | 0 |
225399 | 225399 | 2020-06-10 | Cedar | Iowa | 19031 | 52 | 1 |
225400 | 225400 | 2020-06-10 | Cerro Gordo | Iowa | 19033 | 37 | 1 |
225401 | 225401 | 2020-06-10 | Cherokee | Iowa | 19035 | 52 | 0 |
225402 | 225402 | 2020-06-10 | Chickasaw | Iowa | 19037 | 15 | 0 |
225403 | 225403 | 2020-06-10 | Clarke | Iowa | 19039 | 83 | 1 |
225404 | 225404 | 2020-06-10 | Clay | Iowa | 19041 | 39 | 0 |
225405 | 225405 | 2020-06-10 | Clayton | Iowa | 19043 | 34 | 3 |
225406 | 225406 | 2020-06-10 | Clinton | Iowa | 19045 | 67 | 1 |
225407 | 225407 | 2020-06-10 | Crawford | Iowa | 19047 | 589 | 2 |
225408 | 225408 | 2020-06-10 | Dallas | Iowa | 19049 | 974 | 26 |
225409 | 225409 | 2020-06-10 | Davis | Iowa | 19051 | 30 | 1 |
225410 | 225410 | 2020-06-10 | Decatur | Iowa | 19053 | 3 | 0 |
225411 | 225411 | 2020-06-10 | Delaware | Iowa | 19055 | 25 | 1 |
225412 | 225412 | 2020-06-10 | Des Moines | Iowa | 19057 | 68 | 2 |
225413 | 225413 | 2020-06-10 | Dickinson | Iowa | 19059 | 90 | 0 |
225414 | 225414 | 2020-06-10 | Dubuque | Iowa | 19061 | 371 | 21 |
225415 | 225415 | 2020-06-10 | Emmet | Iowa | 19063 | 34 | 0 |
225416 | 225416 | 2020-06-10 | Fayette | Iowa | 19065 | 28 | 0 |
225417 | 225417 | 2020-06-10 | Floyd | Iowa | 19067 | 19 | 1 |
225418 | 225418 | 2020-06-10 | Franklin | Iowa | 19069 | 38 | 0 |
225419 | 225419 | 2020-06-10 | Fremont | Iowa | 19071 | 4 | 0 |
225420 | 225420 | 2020-06-10 | Greene | Iowa | 19073 | 16 | 0 |
225421 | 225421 | 2020-06-10 | Grundy | Iowa | 19075 | 24 | 0 |
225422 | 225422 | 2020-06-10 | Guthrie | Iowa | 19077 | 55 | 3 |
225423 | 225423 | 2020-06-10 | Hamilton | Iowa | 19079 | 106 | 0 |
225424 | 225424 | 2020-06-10 | Hancock | Iowa | 19081 | 25 | 0 |
225425 | 225425 | 2020-06-10 | Hardin | Iowa | 19083 | 39 | 0 |
225426 | 225426 | 2020-06-10 | Harrison | Iowa | 19085 | 30 | 0 |
225427 | 225427 | 2020-06-10 | Henry | Iowa | 19087 | 73 | 2 |
225428 | 225428 | 2020-06-10 | Howard | Iowa | 19089 | 12 | 0 |
225429 | 225429 | 2020-06-10 | Humboldt | Iowa | 19091 | 27 | 1 |
225430 | 225430 | 2020-06-10 | Ida | Iowa | 19093 | 16 | 0 |
225431 | 225431 | 2020-06-10 | Iowa | Iowa | 19095 | 34 | 0 |
225432 | 225432 | 2020-06-10 | Jackson | Iowa | 19097 | 14 | 0 |
225433 | 225433 | 2020-06-10 | Jasper | Iowa | 19099 | 277 | 17 |
225434 | 225434 | 2020-06-10 | Jefferson | Iowa | 19101 | 43 | 0 |
225435 | 225435 | 2020-06-10 | Johnson | Iowa | 19103 | 625 | 8 |
225436 | 225436 | 2020-06-10 | Jones | Iowa | 19105 | 38 | 0 |
225437 | 225437 | 2020-06-10 | Keokuk | Iowa | 19107 | 17 | 0 |
225438 | 225438 | 2020-06-10 | Kossuth | Iowa | 19109 | 16 | 0 |
225439 | 225439 | 2020-06-10 | Lee | Iowa | 19111 | 36 | 1 |
225440 | 225440 | 2020-06-10 | Linn | Iowa | 19113 | 1007 | 80 |
225441 | 225441 | 2020-06-10 | Louisa | Iowa | 19115 | 354 | 11 |
225442 | 225442 | 2020-06-10 | Lucas | Iowa | 19117 | 22 | 2 |
225443 | 225443 | 2020-06-10 | Lyon | Iowa | 19119 | 26 | 0 |
225444 | 225444 | 2020-06-10 | Madison | Iowa | 19121 | 30 | 2 |
225445 | 225445 | 2020-06-10 | Mahaska | Iowa | 19123 | 104 | 14 |
225446 | 225446 | 2020-06-10 | Marion | Iowa | 19125 | 38 | 0 |
225447 | 225447 | 2020-06-10 | Marshall | Iowa | 19127 | 933 | 18 |
225448 | 225448 | 2020-06-10 | Mills | Iowa | 19129 | 21 | 0 |
225449 | 225449 | 2020-06-10 | Mitchell | Iowa | 19131 | 6 | 0 |
225450 | 225450 | 2020-06-10 | Monona | Iowa | 19133 | 29 | 0 |
225451 | 225451 | 2020-06-10 | Monroe | Iowa | 19135 | 46 | 6 |
225452 | 225452 | 2020-06-10 | Montgomery | Iowa | 19137 | 9 | 2 |
225453 | 225453 | 2020-06-10 | Muscatine | Iowa | 19139 | 569 | 43 |
225454 | 225454 | 2020-06-10 | O'Brien | Iowa | 19141 | 60 | 1 |
225455 | 225455 | 2020-06-10 | Osceola | Iowa | 19143 | 53 | 0 |
225456 | 225456 | 2020-06-10 | Page | Iowa | 19145 | 16 | 0 |
225457 | 225457 | 2020-06-10 | Palo Alto | Iowa | 19147 | 9 | 0 |
225458 | 225458 | 2020-06-10 | Plymouth | Iowa | 19149 | 179 | 4 |
225459 | 225459 | 2020-06-10 | Pocahontas | Iowa | 19151 | 29 | 0 |
225460 | 225460 | 2020-06-10 | Polk | Iowa | 19153 | 4924 | 155 |
225461 | 225461 | 2020-06-10 | Pottawattamie | Iowa | 19155 | 439 | 10 |
225462 | 225462 | 2020-06-10 | Poweshiek | Iowa | 19157 | 95 | 8 |
225463 | 225463 | 2020-06-10 | Ringgold | Iowa | 19159 | 7 | 0 |
225464 | 225464 | 2020-06-10 | Sac | Iowa | 19161 | 34 | 0 |
225465 | 225465 | 2020-06-10 | Scott | Iowa | 19163 | 398 | 10 |
225466 | 225466 | 2020-06-10 | Shelby | Iowa | 19165 | 42 | 0 |
225467 | 225467 | 2020-06-10 | Sioux | Iowa | 19167 | 337 | 0 |
225468 | 225468 | 2020-06-10 | Story | Iowa | 19169 | 177 | 2 |
225469 | 225469 | 2020-06-10 | Tama | Iowa | 19171 | 418 | 29 |
225470 | 225470 | 2020-06-10 | Taylor | Iowa | 19173 | 70 | 0 |
225471 | 225471 | 2020-06-10 | Union | Iowa | 19175 | 10 | 0 |
225472 | 225472 | 2020-06-10 | Unknown | Iowa | 5 | 0 | |
225473 | 225473 | 2020-06-10 | Van Buren | Iowa | 19177 | 11 | 0 |
225474 | 225474 | 2020-06-10 | Wapello | Iowa | 19179 | 660 | 23 |
225475 | 225475 | 2020-06-10 | Warren | Iowa | 19181 | 184 | 1 |
225476 | 225476 | 2020-06-10 | Washington | Iowa | 19183 | 205 | 9 |
225477 | 225477 | 2020-06-10 | Wayne | Iowa | 19185 | 4 | 0 |
225478 | 225478 | 2020-06-10 | Webster | Iowa | 19187 | 89 | 1 |
225479 | 225479 | 2020-06-10 | Winnebago | Iowa | 19189 | 12 | 0 |
225480 | 225480 | 2020-06-10 | Winneshiek | Iowa | 19191 | 25 | 0 |
225481 | 225481 | 2020-06-10 | Woodbury | Iowa | 19193 | 2960 | 38 |
225482 | 225482 | 2020-06-10 | Worth | Iowa | 19195 | 3 | 0 |
225483 | 225483 | 2020-06-10 | Wright | Iowa | 19197 | 266 | 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);