ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2020-08-08 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 |
---|---|---|---|---|---|---|---|
412469 | 412469 | 2020-08-08 | Adair | Iowa | 19001 | 29 | 0 |
412470 | 412470 | 2020-08-08 | Adams | Iowa | 19003 | 16 | 0 |
412471 | 412471 | 2020-08-08 | Allamakee | Iowa | 19005 | 154 | 4 |
412472 | 412472 | 2020-08-08 | Appanoose | Iowa | 19007 | 48 | 3 |
412473 | 412473 | 2020-08-08 | Audubon | Iowa | 19009 | 28 | 1 |
412474 | 412474 | 2020-08-08 | Benton | Iowa | 19011 | 154 | 1 |
412475 | 412475 | 2020-08-08 | Black Hawk | Iowa | 19013 | 3104 | 66 |
412476 | 412476 | 2020-08-08 | Boone | Iowa | 19015 | 253 | 3 |
412477 | 412477 | 2020-08-08 | Bremer | Iowa | 19017 | 221 | 7 |
412478 | 412478 | 2020-08-08 | Buchanan | Iowa | 19019 | 124 | 1 |
412479 | 412479 | 2020-08-08 | Buena Vista | Iowa | 19021 | 1791 | 12 |
412480 | 412480 | 2020-08-08 | Butler | Iowa | 19023 | 120 | 2 |
412481 | 412481 | 2020-08-08 | Calhoun | Iowa | 19025 | 83 | 2 |
412482 | 412482 | 2020-08-08 | Carroll | Iowa | 19027 | 185 | 1 |
412483 | 412483 | 2020-08-08 | Cass | Iowa | 19029 | 62 | 1 |
412484 | 412484 | 2020-08-08 | Cedar | Iowa | 19031 | 130 | 1 |
412485 | 412485 | 2020-08-08 | Cerro Gordo | Iowa | 19033 | 603 | 17 |
412486 | 412486 | 2020-08-08 | Cherokee | Iowa | 19035 | 107 | 1 |
412487 | 412487 | 2020-08-08 | Chickasaw | Iowa | 19037 | 54 | 0 |
412488 | 412488 | 2020-08-08 | Clarke | Iowa | 19039 | 197 | 3 |
412489 | 412489 | 2020-08-08 | Clay | Iowa | 19041 | 186 | 1 |
412490 | 412490 | 2020-08-08 | Clayton | Iowa | 19043 | 104 | 3 |
412491 | 412491 | 2020-08-08 | Clinton | Iowa | 19045 | 373 | 3 |
412492 | 412492 | 2020-08-08 | Crawford | Iowa | 19047 | 727 | 3 |
412493 | 412493 | 2020-08-08 | Dallas | Iowa | 19049 | 1864 | 35 |
412494 | 412494 | 2020-08-08 | Davis | Iowa | 19051 | 55 | 1 |
412495 | 412495 | 2020-08-08 | Decatur | Iowa | 19053 | 23 | 0 |
412496 | 412496 | 2020-08-08 | Delaware | Iowa | 19055 | 110 | 1 |
412497 | 412497 | 2020-08-08 | Des Moines | Iowa | 19057 | 167 | 2 |
412498 | 412498 | 2020-08-08 | Dickinson | Iowa | 19059 | 377 | 4 |
412499 | 412499 | 2020-08-08 | Dubuque | Iowa | 19061 | 1665 | 31 |
412500 | 412500 | 2020-08-08 | Emmet | Iowa | 19063 | 190 | 4 |
412501 | 412501 | 2020-08-08 | Fayette | Iowa | 19065 | 82 | 0 |
412502 | 412502 | 2020-08-08 | Floyd | Iowa | 19067 | 148 | 2 |
412503 | 412503 | 2020-08-08 | Franklin | Iowa | 19069 | 238 | 10 |
412504 | 412504 | 2020-08-08 | Fremont | Iowa | 19071 | 42 | 0 |
412505 | 412505 | 2020-08-08 | Greene | Iowa | 19073 | 41 | 0 |
412506 | 412506 | 2020-08-08 | Grundy | Iowa | 19075 | 79 | 1 |
412507 | 412507 | 2020-08-08 | Guthrie | Iowa | 19077 | 131 | 5 |
412508 | 412508 | 2020-08-08 | Hamilton | Iowa | 19079 | 246 | 1 |
412509 | 412509 | 2020-08-08 | Hancock | Iowa | 19081 | 121 | 2 |
412510 | 412510 | 2020-08-08 | Hardin | Iowa | 19083 | 178 | 0 |
412511 | 412511 | 2020-08-08 | Harrison | Iowa | 19085 | 105 | 0 |
412512 | 412512 | 2020-08-08 | Henry | Iowa | 19087 | 120 | 3 |
412513 | 412513 | 2020-08-08 | Howard | Iowa | 19089 | 49 | 0 |
412514 | 412514 | 2020-08-08 | Humboldt | Iowa | 19091 | 108 | 1 |
412515 | 412515 | 2020-08-08 | Ida | Iowa | 19093 | 29 | 0 |
412516 | 412516 | 2020-08-08 | Iowa | Iowa | 19095 | 97 | 1 |
412517 | 412517 | 2020-08-08 | Jackson | Iowa | 19097 | 151 | 1 |
412518 | 412518 | 2020-08-08 | Jasper | Iowa | 19099 | 473 | 26 |
412519 | 412519 | 2020-08-08 | Jefferson | Iowa | 19101 | 83 | 0 |
412520 | 412520 | 2020-08-08 | Johnson | Iowa | 19103 | 2063 | 19 |
412521 | 412521 | 2020-08-08 | Jones | Iowa | 19105 | 129 | 2 |
412522 | 412522 | 2020-08-08 | Keokuk | Iowa | 19107 | 34 | 1 |
412523 | 412523 | 2020-08-08 | Kossuth | Iowa | 19109 | 85 | 0 |
412524 | 412524 | 2020-08-08 | Lee | Iowa | 19111 | 110 | 3 |
412525 | 412525 | 2020-08-08 | Linn | Iowa | 19113 | 2329 | 87 |
412526 | 412526 | 2020-08-08 | Louisa | Iowa | 19115 | 378 | 14 |
412527 | 412527 | 2020-08-08 | Lucas | Iowa | 19117 | 60 | 4 |
412528 | 412528 | 2020-08-08 | Lyon | Iowa | 19119 | 113 | 2 |
412529 | 412529 | 2020-08-08 | Madison | Iowa | 19121 | 116 | 2 |
412530 | 412530 | 2020-08-08 | Mahaska | Iowa | 19123 | 139 | 17 |
412531 | 412531 | 2020-08-08 | Marion | Iowa | 19125 | 169 | 0 |
412532 | 412532 | 2020-08-08 | Marshall | Iowa | 19127 | 1436 | 26 |
412533 | 412533 | 2020-08-08 | Mills | Iowa | 19129 | 88 | 0 |
412534 | 412534 | 2020-08-08 | Mitchell | Iowa | 19131 | 78 | 0 |
412535 | 412535 | 2020-08-08 | Monona | Iowa | 19133 | 91 | 0 |
412536 | 412536 | 2020-08-08 | Monroe | Iowa | 19135 | 72 | 7 |
412537 | 412537 | 2020-08-08 | Montgomery | Iowa | 19137 | 59 | 4 |
412538 | 412538 | 2020-08-08 | Muscatine | Iowa | 19139 | 846 | 48 |
412539 | 412539 | 2020-08-08 | O'Brien | Iowa | 19141 | 137 | 2 |
412540 | 412540 | 2020-08-08 | Osceola | Iowa | 19143 | 82 | 0 |
412541 | 412541 | 2020-08-08 | Page | Iowa | 19145 | 94 | 0 |
412542 | 412542 | 2020-08-08 | Palo Alto | Iowa | 19147 | 84 | 0 |
412543 | 412543 | 2020-08-08 | Plymouth | Iowa | 19149 | 456 | 9 |
412544 | 412544 | 2020-08-08 | Pocahontas | Iowa | 19151 | 115 | 2 |
412545 | 412545 | 2020-08-08 | Polk | Iowa | 19153 | 10159 | 207 |
412546 | 412546 | 2020-08-08 | Pottawattamie | Iowa | 19155 | 1308 | 26 |
412547 | 412547 | 2020-08-08 | Poweshiek | Iowa | 19157 | 157 | 8 |
412548 | 412548 | 2020-08-08 | Ringgold | Iowa | 19159 | 21 | 1 |
412549 | 412549 | 2020-08-08 | Sac | Iowa | 19161 | 83 | 0 |
412550 | 412550 | 2020-08-08 | Scott | Iowa | 19163 | 1705 | 14 |
412551 | 412551 | 2020-08-08 | Shelby | Iowa | 19165 | 182 | 1 |
412552 | 412552 | 2020-08-08 | Sioux | Iowa | 19167 | 625 | 3 |
412553 | 412553 | 2020-08-08 | Story | Iowa | 19169 | 1157 | 14 |
412554 | 412554 | 2020-08-08 | Tama | Iowa | 19171 | 548 | 29 |
412555 | 412555 | 2020-08-08 | Taylor | Iowa | 19173 | 98 | 0 |
412556 | 412556 | 2020-08-08 | Union | Iowa | 19175 | 76 | 1 |
412557 | 412557 | 2020-08-08 | Unknown | Iowa | 7 | 0 | |
412558 | 412558 | 2020-08-08 | Van Buren | Iowa | 19177 | 34 | 1 |
412559 | 412559 | 2020-08-08 | Wapello | Iowa | 19179 | 880 | 33 |
412560 | 412560 | 2020-08-08 | Warren | Iowa | 19181 | 550 | 1 |
412561 | 412561 | 2020-08-08 | Washington | Iowa | 19183 | 295 | 10 |
412562 | 412562 | 2020-08-08 | Wayne | Iowa | 19185 | 19 | 1 |
412563 | 412563 | 2020-08-08 | Webster | Iowa | 19187 | 800 | 7 |
412564 | 412564 | 2020-08-08 | Winnebago | Iowa | 19189 | 79 | 0 |
412565 | 412565 | 2020-08-08 | Winneshiek | Iowa | 19191 | 95 | 1 |
412566 | 412566 | 2020-08-08 | Woodbury | Iowa | 19193 | 3715 | 51 |
412567 | 412567 | 2020-08-08 | Worth | Iowa | 19195 | 66 | 0 |
412568 | 412568 | 2020-08-08 | Wright | Iowa | 19197 | 464 | 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);