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-07-20 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 |
---|---|---|---|---|---|---|---|
351418 | 351418 | 2020-07-20 | Adair | Iowa | 19001 | 20 | 0 |
351419 | 351419 | 2020-07-20 | Adams | Iowa | 19003 | 12 | 0 |
351420 | 351420 | 2020-07-20 | Allamakee | Iowa | 19005 | 141 | 4 |
351421 | 351421 | 2020-07-20 | Appanoose | Iowa | 19007 | 34 | 3 |
351422 | 351422 | 2020-07-20 | Audubon | Iowa | 19009 | 21 | 1 |
351423 | 351423 | 2020-07-20 | Benton | Iowa | 19011 | 94 | 1 |
351424 | 351424 | 2020-07-20 | Black Hawk | Iowa | 19013 | 2707 | 61 |
351425 | 351425 | 2020-07-20 | Boone | Iowa | 19015 | 188 | 1 |
351426 | 351426 | 2020-07-20 | Bremer | Iowa | 19017 | 139 | 7 |
351427 | 351427 | 2020-07-20 | Buchanan | Iowa | 19019 | 76 | 1 |
351428 | 351428 | 2020-07-20 | Buena Vista | Iowa | 19021 | 1757 | 12 |
351429 | 351429 | 2020-07-20 | Butler | Iowa | 19023 | 84 | 2 |
351430 | 351430 | 2020-07-20 | Calhoun | Iowa | 19025 | 70 | 2 |
351431 | 351431 | 2020-07-20 | Carroll | Iowa | 19027 | 135 | 1 |
351432 | 351432 | 2020-07-20 | Cass | Iowa | 19029 | 30 | 0 |
351433 | 351433 | 2020-07-20 | Cedar | Iowa | 19031 | 103 | 1 |
351434 | 351434 | 2020-07-20 | Cerro Gordo | Iowa | 19033 | 450 | 13 |
351435 | 351435 | 2020-07-20 | Cherokee | Iowa | 19035 | 89 | 1 |
351436 | 351436 | 2020-07-20 | Chickasaw | Iowa | 19037 | 41 | 0 |
351437 | 351437 | 2020-07-20 | Clarke | Iowa | 19039 | 152 | 3 |
351438 | 351438 | 2020-07-20 | Clay | Iowa | 19041 | 161 | 1 |
351439 | 351439 | 2020-07-20 | Clayton | Iowa | 19043 | 60 | 3 |
351440 | 351440 | 2020-07-20 | Clinton | Iowa | 19045 | 178 | 2 |
351441 | 351441 | 2020-07-20 | Crawford | Iowa | 19047 | 690 | 3 |
351442 | 351442 | 2020-07-20 | Dallas | Iowa | 19049 | 1571 | 34 |
351443 | 351443 | 2020-07-20 | Davis | Iowa | 19051 | 46 | 1 |
351444 | 351444 | 2020-07-20 | Decatur | Iowa | 19053 | 16 | 0 |
351445 | 351445 | 2020-07-20 | Delaware | Iowa | 19055 | 66 | 1 |
351446 | 351446 | 2020-07-20 | Des Moines | Iowa | 19057 | 115 | 2 |
351447 | 351447 | 2020-07-20 | Dickinson | Iowa | 19059 | 344 | 3 |
351448 | 351448 | 2020-07-20 | Dubuque | Iowa | 19061 | 1215 | 23 |
351449 | 351449 | 2020-07-20 | Emmet | Iowa | 19063 | 120 | 0 |
351450 | 351450 | 2020-07-20 | Fayette | Iowa | 19065 | 65 | 0 |
351451 | 351451 | 2020-07-20 | Floyd | Iowa | 19067 | 95 | 2 |
351452 | 351452 | 2020-07-20 | Franklin | Iowa | 19069 | 144 | 0 |
351453 | 351453 | 2020-07-20 | Fremont | Iowa | 19071 | 14 | 0 |
351454 | 351454 | 2020-07-20 | Greene | Iowa | 19073 | 37 | 0 |
351455 | 351455 | 2020-07-20 | Grundy | Iowa | 19075 | 58 | 0 |
351456 | 351456 | 2020-07-20 | Guthrie | Iowa | 19077 | 107 | 5 |
351457 | 351457 | 2020-07-20 | Hamilton | Iowa | 19079 | 212 | 1 |
351458 | 351458 | 2020-07-20 | Hancock | Iowa | 19081 | 81 | 2 |
351459 | 351459 | 2020-07-20 | Hardin | Iowa | 19083 | 109 | 0 |
351460 | 351460 | 2020-07-20 | Harrison | Iowa | 19085 | 71 | 0 |
351461 | 351461 | 2020-07-20 | Henry | Iowa | 19087 | 100 | 3 |
351462 | 351462 | 2020-07-20 | Howard | Iowa | 19089 | 42 | 0 |
351463 | 351463 | 2020-07-20 | Humboldt | Iowa | 19091 | 70 | 1 |
351464 | 351464 | 2020-07-20 | Ida | Iowa | 19093 | 25 | 0 |
351465 | 351465 | 2020-07-20 | Iowa | Iowa | 19095 | 66 | 1 |
351466 | 351466 | 2020-07-20 | Jackson | Iowa | 19097 | 97 | 0 |
351467 | 351467 | 2020-07-20 | Jasper | Iowa | 19099 | 413 | 17 |
351468 | 351468 | 2020-07-20 | Jefferson | Iowa | 19101 | 67 | 0 |
351469 | 351469 | 2020-07-20 | Johnson | Iowa | 19103 | 1636 | 10 |
351470 | 351470 | 2020-07-20 | Jones | Iowa | 19105 | 97 | 1 |
351471 | 351471 | 2020-07-20 | Keokuk | Iowa | 19107 | 24 | 1 |
351472 | 351472 | 2020-07-20 | Kossuth | Iowa | 19109 | 71 | 0 |
351473 | 351473 | 2020-07-20 | Lee | Iowa | 19111 | 62 | 2 |
351474 | 351474 | 2020-07-20 | Linn | Iowa | 19113 | 1604 | 87 |
351475 | 351475 | 2020-07-20 | Louisa | Iowa | 19115 | 371 | 13 |
351476 | 351476 | 2020-07-20 | Lucas | Iowa | 19117 | 38 | 4 |
351477 | 351477 | 2020-07-20 | Lyon | Iowa | 19119 | 75 | 0 |
351478 | 351478 | 2020-07-20 | Madison | Iowa | 19121 | 73 | 2 |
351479 | 351479 | 2020-07-20 | Mahaska | Iowa | 19123 | 129 | 17 |
351480 | 351480 | 2020-07-20 | Marion | Iowa | 19125 | 105 | 0 |
351481 | 351481 | 2020-07-20 | Marshall | Iowa | 19127 | 1197 | 21 |
351482 | 351482 | 2020-07-20 | Mills | Iowa | 19129 | 60 | 0 |
351483 | 351483 | 2020-07-20 | Mitchell | Iowa | 19131 | 68 | 0 |
351484 | 351484 | 2020-07-20 | Monona | Iowa | 19133 | 81 | 0 |
351485 | 351485 | 2020-07-20 | Monroe | Iowa | 19135 | 61 | 7 |
351486 | 351486 | 2020-07-20 | Montgomery | Iowa | 19137 | 21 | 2 |
351487 | 351487 | 2020-07-20 | Muscatine | Iowa | 19139 | 732 | 45 |
351488 | 351488 | 2020-07-20 | O'Brien | Iowa | 19141 | 107 | 1 |
351489 | 351489 | 2020-07-20 | Osceola | Iowa | 19143 | 71 | 0 |
351490 | 351490 | 2020-07-20 | Page | Iowa | 19145 | 32 | 0 |
351491 | 351491 | 2020-07-20 | Palo Alto | Iowa | 19147 | 63 | 0 |
351492 | 351492 | 2020-07-20 | Plymouth | Iowa | 19149 | 380 | 6 |
351493 | 351493 | 2020-07-20 | Pocahontas | Iowa | 19151 | 110 | 1 |
351494 | 351494 | 2020-07-20 | Polk | Iowa | 19153 | 8465 | 189 |
351495 | 351495 | 2020-07-20 | Pottawattamie | Iowa | 19155 | 925 | 15 |
351496 | 351496 | 2020-07-20 | Poweshiek | Iowa | 19157 | 114 | 8 |
351497 | 351497 | 2020-07-20 | Ringgold | Iowa | 19159 | 17 | 1 |
351498 | 351498 | 2020-07-20 | Sac | Iowa | 19161 | 75 | 0 |
351499 | 351499 | 2020-07-20 | Scott | Iowa | 19163 | 1318 | 11 |
351500 | 351500 | 2020-07-20 | Shelby | Iowa | 19165 | 127 | 0 |
351501 | 351501 | 2020-07-20 | Sioux | Iowa | 19167 | 535 | 0 |
351502 | 351502 | 2020-07-20 | Story | Iowa | 19169 | 947 | 9 |
351503 | 351503 | 2020-07-20 | Tama | Iowa | 19171 | 510 | 29 |
351504 | 351504 | 2020-07-20 | Taylor | Iowa | 19173 | 81 | 0 |
351505 | 351505 | 2020-07-20 | Union | Iowa | 19175 | 56 | 1 |
351506 | 351506 | 2020-07-20 | Unknown | Iowa | 22 | 0 | |
351507 | 351507 | 2020-07-20 | Van Buren | Iowa | 19177 | 22 | 1 |
351508 | 351508 | 2020-07-20 | Wapello | Iowa | 19179 | 746 | 31 |
351509 | 351509 | 2020-07-20 | Warren | Iowa | 19181 | 415 | 1 |
351510 | 351510 | 2020-07-20 | Washington | Iowa | 19183 | 267 | 9 |
351511 | 351511 | 2020-07-20 | Wayne | Iowa | 19185 | 11 | 1 |
351512 | 351512 | 2020-07-20 | Webster | Iowa | 19187 | 565 | 5 |
351513 | 351513 | 2020-07-20 | Winnebago | Iowa | 19189 | 58 | 0 |
351514 | 351514 | 2020-07-20 | Winneshiek | Iowa | 19191 | 58 | 1 |
351515 | 351515 | 2020-07-20 | Woodbury | Iowa | 19193 | 3482 | 46 |
351516 | 351516 | 2020-07-20 | Worth | Iowa | 19195 | 44 | 0 |
351517 | 351517 | 2020-07-20 | Wright | Iowa | 19197 | 417 | 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);