ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-08-30" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|
483466 | 483466 | 2020-08-30 | Adair | Iowa | 19001 | 51 | 1 |
483467 | 483467 | 2020-08-30 | Adams | Iowa | 19003 | 22 | 0 |
483468 | 483468 | 2020-08-30 | Allamakee | Iowa | 19005 | 174 | 4 |
483469 | 483469 | 2020-08-30 | Appanoose | Iowa | 19007 | 82 | 3 |
483470 | 483470 | 2020-08-30 | Audubon | Iowa | 19009 | 41 | 1 |
483471 | 483471 | 2020-08-30 | Benton | Iowa | 19011 | 200 | 1 |
483472 | 483472 | 2020-08-30 | Black Hawk | Iowa | 19013 | 3787 | 74 |
483473 | 483473 | 2020-08-30 | Boone | Iowa | 19015 | 344 | 4 |
483474 | 483474 | 2020-08-30 | Bremer | Iowa | 19017 | 298 | 7 |
483475 | 483475 | 2020-08-30 | Buchanan | Iowa | 19019 | 174 | 1 |
483476 | 483476 | 2020-08-30 | Buena Vista | Iowa | 19021 | 1826 | 12 |
483477 | 483477 | 2020-08-30 | Butler | Iowa | 19023 | 201 | 2 |
483478 | 483478 | 2020-08-30 | Calhoun | Iowa | 19025 | 126 | 2 |
483479 | 483479 | 2020-08-30 | Carroll | Iowa | 19027 | 387 | 2 |
483480 | 483480 | 2020-08-30 | Cass | Iowa | 19029 | 112 | 2 |
483481 | 483481 | 2020-08-30 | Cedar | Iowa | 19031 | 154 | 1 |
483482 | 483482 | 2020-08-30 | Cerro Gordo | Iowa | 19033 | 822 | 20 |
483483 | 483483 | 2020-08-30 | Cherokee | Iowa | 19035 | 140 | 2 |
483484 | 483484 | 2020-08-30 | Chickasaw | Iowa | 19037 | 107 | 0 |
483485 | 483485 | 2020-08-30 | Clarke | Iowa | 19039 | 239 | 3 |
483486 | 483486 | 2020-08-30 | Clay | Iowa | 19041 | 236 | 3 |
483487 | 483487 | 2020-08-30 | Clayton | Iowa | 19043 | 179 | 3 |
483488 | 483488 | 2020-08-30 | Clinton | Iowa | 19045 | 821 | 10 |
483489 | 483489 | 2020-08-30 | Crawford | Iowa | 19047 | 832 | 3 |
483490 | 483490 | 2020-08-30 | Dallas | Iowa | 19049 | 2378 | 39 |
483491 | 483491 | 2020-08-30 | Davis | Iowa | 19051 | 81 | 2 |
483492 | 483492 | 2020-08-30 | Decatur | Iowa | 19053 | 44 | 0 |
483493 | 483493 | 2020-08-30 | Delaware | Iowa | 19055 | 212 | 3 |
483494 | 483494 | 2020-08-30 | Des Moines | Iowa | 19057 | 567 | 5 |
483495 | 483495 | 2020-08-30 | Dickinson | Iowa | 19059 | 424 | 6 |
483496 | 483496 | 2020-08-30 | Dubuque | Iowa | 19061 | 2027 | 36 |
483497 | 483497 | 2020-08-30 | Emmet | Iowa | 19063 | 221 | 8 |
483498 | 483498 | 2020-08-30 | Fayette | Iowa | 19065 | 138 | 1 |
483499 | 483499 | 2020-08-30 | Floyd | Iowa | 19067 | 215 | 3 |
483500 | 483500 | 2020-08-30 | Franklin | Iowa | 19069 | 296 | 17 |
483501 | 483501 | 2020-08-30 | Fremont | Iowa | 19071 | 58 | 0 |
483502 | 483502 | 2020-08-30 | Greene | Iowa | 19073 | 54 | 0 |
483503 | 483503 | 2020-08-30 | Grundy | Iowa | 19075 | 128 | 1 |
483504 | 483504 | 2020-08-30 | Guthrie | Iowa | 19077 | 173 | 5 |
483505 | 483505 | 2020-08-30 | Hamilton | Iowa | 19079 | 279 | 2 |
483506 | 483506 | 2020-08-30 | Hancock | Iowa | 19081 | 154 | 2 |
483507 | 483507 | 2020-08-30 | Hardin | Iowa | 19083 | 230 | 1 |
483508 | 483508 | 2020-08-30 | Harrison | Iowa | 19085 | 147 | 1 |
483509 | 483509 | 2020-08-30 | Henry | Iowa | 19087 | 279 | 4 |
483510 | 483510 | 2020-08-30 | Howard | Iowa | 19089 | 132 | 2 |
483511 | 483511 | 2020-08-30 | Humboldt | Iowa | 19091 | 153 | 2 |
483512 | 483512 | 2020-08-30 | Ida | Iowa | 19093 | 40 | 0 |
483513 | 483513 | 2020-08-30 | Iowa | Iowa | 19095 | 113 | 1 |
483514 | 483514 | 2020-08-30 | Jackson | Iowa | 19097 | 208 | 1 |
483515 | 483515 | 2020-08-30 | Jasper | Iowa | 19099 | 585 | 30 |
483516 | 483516 | 2020-08-30 | Jefferson | Iowa | 19101 | 117 | 0 |
483517 | 483517 | 2020-08-30 | Johnson | Iowa | 19103 | 3828 | 26 |
483518 | 483518 | 2020-08-30 | Jones | Iowa | 19105 | 170 | 2 |
483519 | 483519 | 2020-08-30 | Keokuk | Iowa | 19107 | 60 | 1 |
483520 | 483520 | 2020-08-30 | Kossuth | Iowa | 19109 | 121 | 0 |
483521 | 483521 | 2020-08-30 | Lee | Iowa | 19111 | 409 | 5 |
483522 | 483522 | 2020-08-30 | Linn | Iowa | 19113 | 2971 | 94 |
483523 | 483523 | 2020-08-30 | Louisa | Iowa | 19115 | 397 | 14 |
483524 | 483524 | 2020-08-30 | Lucas | Iowa | 19117 | 93 | 5 |
483525 | 483525 | 2020-08-30 | Lyon | Iowa | 19119 | 148 | 2 |
483526 | 483526 | 2020-08-30 | Madison | Iowa | 19121 | 164 | 2 |
483527 | 483527 | 2020-08-30 | Mahaska | Iowa | 19123 | 216 | 18 |
483528 | 483528 | 2020-08-30 | Marion | Iowa | 19125 | 475 | 0 |
483529 | 483529 | 2020-08-30 | Marshall | Iowa | 19127 | 1639 | 32 |
483530 | 483530 | 2020-08-30 | Mills | Iowa | 19129 | 128 | 1 |
483531 | 483531 | 2020-08-30 | Mitchell | Iowa | 19131 | 109 | 0 |
483532 | 483532 | 2020-08-30 | Monona | Iowa | 19133 | 107 | 1 |
483533 | 483533 | 2020-08-30 | Monroe | Iowa | 19135 | 107 | 8 |
483534 | 483534 | 2020-08-30 | Montgomery | Iowa | 19137 | 76 | 5 |
483535 | 483535 | 2020-08-30 | Muscatine | Iowa | 19139 | 959 | 51 |
483536 | 483536 | 2020-08-30 | O'Brien | Iowa | 19141 | 196 | 7 |
483537 | 483537 | 2020-08-30 | Osceola | Iowa | 19143 | 99 | 0 |
483538 | 483538 | 2020-08-30 | Page | Iowa | 19145 | 112 | 0 |
483539 | 483539 | 2020-08-30 | Palo Alto | Iowa | 19147 | 112 | 0 |
483540 | 483540 | 2020-08-30 | Plymouth | Iowa | 19149 | 737 | 18 |
483541 | 483541 | 2020-08-30 | Pocahontas | Iowa | 19151 | 130 | 2 |
483542 | 483542 | 2020-08-30 | Polk | Iowa | 19153 | 13292 | 225 |
483543 | 483543 | 2020-08-30 | Pottawattamie | Iowa | 19155 | 1631 | 34 |
483544 | 483544 | 2020-08-30 | Poweshiek | Iowa | 19157 | 184 | 8 |
483545 | 483545 | 2020-08-30 | Ringgold | Iowa | 19159 | 32 | 1 |
483546 | 483546 | 2020-08-30 | Sac | Iowa | 19161 | 114 | 0 |
483547 | 483547 | 2020-08-30 | Scott | Iowa | 19163 | 2208 | 21 |
483548 | 483548 | 2020-08-30 | Shelby | Iowa | 19165 | 215 | 1 |
483549 | 483549 | 2020-08-30 | Sioux | Iowa | 19167 | 893 | 3 |
483550 | 483550 | 2020-08-30 | Story | Iowa | 19169 | 2362 | 16 |
483551 | 483551 | 2020-08-30 | Tama | Iowa | 19171 | 622 | 29 |
483552 | 483552 | 2020-08-30 | Taylor | Iowa | 19173 | 113 | 1 |
483553 | 483553 | 2020-08-30 | Union | Iowa | 19175 | 93 | 3 |
483554 | 483554 | 2020-08-30 | Unknown | Iowa | 19 | 0 | |
483555 | 483555 | 2020-08-30 | Van Buren | Iowa | 19177 | 101 | 1 |
483556 | 483556 | 2020-08-30 | Wapello | Iowa | 19179 | 1082 | 49 |
483557 | 483557 | 2020-08-30 | Warren | Iowa | 19181 | 775 | 5 |
483558 | 483558 | 2020-08-30 | Washington | Iowa | 19183 | 336 | 11 |
483559 | 483559 | 2020-08-30 | Wayne | Iowa | 19185 | 48 | 2 |
483560 | 483560 | 2020-08-30 | Webster | Iowa | 19187 | 1006 | 8 |
483561 | 483561 | 2020-08-30 | Winnebago | Iowa | 19189 | 161 | 8 |
483562 | 483562 | 2020-08-30 | Winneshiek | Iowa | 19191 | 217 | 3 |
483563 | 483563 | 2020-08-30 | Woodbury | Iowa | 19193 | 4126 | 56 |
483564 | 483564 | 2020-08-30 | Worth | Iowa | 19195 | 79 | 0 |
483565 | 483565 | 2020-08-30 | Wright | Iowa | 19197 | 519 | 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);