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-11-29 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 |
---|---|---|---|---|---|---|---|
778437 | 778437 | 2020-11-29 | Adair | Iowa | 19001 | 441 | 8 |
778438 | 778438 | 2020-11-29 | Adams | Iowa | 19003 | 170 | 2 |
778439 | 778439 | 2020-11-29 | Allamakee | Iowa | 19005 | 818 | 11 |
778440 | 778440 | 2020-11-29 | Appanoose | Iowa | 19007 | 793 | 12 |
778441 | 778441 | 2020-11-29 | Audubon | Iowa | 19009 | 296 | 2 |
778442 | 778442 | 2020-11-29 | Benton | Iowa | 19011 | 1706 | 19 |
778443 | 778443 | 2020-11-29 | Black Hawk | Iowa | 19013 | 10892 | 135 |
778444 | 778444 | 2020-11-29 | Boone | Iowa | 19015 | 1370 | 11 |
778445 | 778445 | 2020-11-29 | Bremer | Iowa | 19017 | 1952 | 12 |
778446 | 778446 | 2020-11-29 | Buchanan | Iowa | 19019 | 1170 | 10 |
778447 | 778447 | 2020-11-29 | Buena Vista | Iowa | 19021 | 3054 | 14 |
778448 | 778448 | 2020-11-29 | Butler | Iowa | 19023 | 1021 | 6 |
778449 | 778449 | 2020-11-29 | Calhoun | Iowa | 19025 | 1061 | 7 |
778450 | 778450 | 2020-11-29 | Carroll | Iowa | 19027 | 1985 | 22 |
778451 | 778451 | 2020-11-29 | Cass | Iowa | 19029 | 816 | 23 |
778452 | 778452 | 2020-11-29 | Cedar | Iowa | 19031 | 1085 | 13 |
778453 | 778453 | 2020-11-29 | Cerro Gordo | Iowa | 19033 | 3571 | 44 |
778454 | 778454 | 2020-11-29 | Cherokee | Iowa | 19035 | 848 | 4 |
778455 | 778455 | 2020-11-29 | Chickasaw | Iowa | 19037 | 857 | 4 |
778456 | 778456 | 2020-11-29 | Clarke | Iowa | 19039 | 487 | 4 |
778457 | 778457 | 2020-11-29 | Clay | Iowa | 19041 | 1178 | 4 |
778458 | 778458 | 2020-11-29 | Clayton | Iowa | 19043 | 1117 | 5 |
778459 | 778459 | 2020-11-29 | Clinton | Iowa | 19045 | 3313 | 44 |
778460 | 778460 | 2020-11-29 | Crawford | Iowa | 19047 | 1745 | 16 |
778461 | 778461 | 2020-11-29 | Dallas | Iowa | 19049 | 6373 | 57 |
778462 | 778462 | 2020-11-29 | Davis | Iowa | 19051 | 470 | 9 |
778463 | 778463 | 2020-11-29 | Decatur | Iowa | 19053 | 317 | 0 |
778464 | 778464 | 2020-11-29 | Delaware | Iowa | 19055 | 1442 | 21 |
778465 | 778465 | 2020-11-29 | Des Moines | Iowa | 19057 | 2916 | 20 |
778466 | 778466 | 2020-11-29 | Dickinson | Iowa | 19059 | 1392 | 10 |
778467 | 778467 | 2020-11-29 | Dubuque | Iowa | 19061 | 9234 | 91 |
778468 | 778468 | 2020-11-29 | Emmet | Iowa | 19063 | 764 | 24 |
778469 | 778469 | 2020-11-29 | Fayette | Iowa | 19065 | 1039 | 10 |
778470 | 778470 | 2020-11-29 | Floyd | Iowa | 19067 | 1050 | 16 |
778471 | 778471 | 2020-11-29 | Franklin | Iowa | 19069 | 739 | 21 |
778472 | 778472 | 2020-11-29 | Fremont | Iowa | 19071 | 358 | 3 |
778473 | 778473 | 2020-11-29 | Greene | Iowa | 19073 | 525 | 0 |
778474 | 778474 | 2020-11-29 | Grundy | Iowa | 19075 | 863 | 11 |
778475 | 778475 | 2020-11-29 | Guthrie | Iowa | 19077 | 754 | 15 |
778476 | 778476 | 2020-11-29 | Hamilton | Iowa | 19079 | 1119 | 9 |
778477 | 778477 | 2020-11-29 | Hancock | Iowa | 19081 | 867 | 7 |
778478 | 778478 | 2020-11-29 | Hardin | Iowa | 19083 | 1157 | 10 |
778479 | 778479 | 2020-11-29 | Harrison | Iowa | 19085 | 1077 | 29 |
778480 | 778480 | 2020-11-29 | Henry | Iowa | 19087 | 1831 | 7 |
778481 | 778481 | 2020-11-29 | Howard | Iowa | 19089 | 559 | 9 |
778482 | 778482 | 2020-11-29 | Humboldt | Iowa | 19091 | 771 | 5 |
778483 | 778483 | 2020-11-29 | Ida | Iowa | 19093 | 489 | 13 |
778484 | 778484 | 2020-11-29 | Iowa | Iowa | 19095 | 958 | 12 |
778485 | 778485 | 2020-11-29 | Jackson | Iowa | 19097 | 1446 | 13 |
778486 | 778486 | 2020-11-29 | Jasper | Iowa | 19099 | 2179 | 44 |
778487 | 778487 | 2020-11-29 | Jefferson | Iowa | 19101 | 714 | 2 |
778488 | 778488 | 2020-11-29 | Johnson | Iowa | 19103 | 9552 | 36 |
778489 | 778489 | 2020-11-29 | Jones | Iowa | 19105 | 2323 | 13 |
778490 | 778490 | 2020-11-29 | Keokuk | Iowa | 19107 | 599 | 7 |
778491 | 778491 | 2020-11-29 | Kossuth | Iowa | 19109 | 1066 | 7 |
778492 | 778492 | 2020-11-29 | Lee | Iowa | 19111 | 2039 | 17 |
778493 | 778493 | 2020-11-29 | Linn | Iowa | 19113 | 14350 | 165 |
778494 | 778494 | 2020-11-29 | Louisa | Iowa | 19115 | 862 | 16 |
778495 | 778495 | 2020-11-29 | Lucas | Iowa | 19117 | 325 | 6 |
778496 | 778496 | 2020-11-29 | Lyon | Iowa | 19119 | 1033 | 8 |
778497 | 778497 | 2020-11-29 | Madison | Iowa | 19121 | 685 | 4 |
778498 | 778498 | 2020-11-29 | Mahaska | Iowa | 19123 | 1268 | 27 |
778499 | 778499 | 2020-11-29 | Marion | Iowa | 19125 | 2053 | 20 |
778500 | 778500 | 2020-11-29 | Marshall | Iowa | 19127 | 3485 | 46 |
778501 | 778501 | 2020-11-29 | Mills | Iowa | 19129 | 1048 | 7 |
778502 | 778502 | 2020-11-29 | Mitchell | Iowa | 19131 | 798 | 4 |
778503 | 778503 | 2020-11-29 | Monona | Iowa | 19133 | 435 | 2 |
778504 | 778504 | 2020-11-29 | Monroe | Iowa | 19135 | 444 | 12 |
778505 | 778505 | 2020-11-29 | Montgomery | Iowa | 19137 | 463 | 11 |
778506 | 778506 | 2020-11-29 | Muscatine | Iowa | 19139 | 2892 | 68 |
778507 | 778507 | 2020-11-29 | O'Brien | Iowa | 19141 | 1292 | 31 |
778508 | 778508 | 2020-11-29 | Osceola | Iowa | 19143 | 524 | 1 |
778509 | 778509 | 2020-11-29 | Page | Iowa | 19145 | 1137 | 4 |
778510 | 778510 | 2020-11-29 | Palo Alto | Iowa | 19147 | 655 | 4 |
778511 | 778511 | 2020-11-29 | Plymouth | Iowa | 19149 | 2760 | 42 |
778512 | 778512 | 2020-11-29 | Pocahontas | Iowa | 19151 | 558 | 4 |
778513 | 778513 | 2020-11-29 | Polk | Iowa | 19153 | 33642 | 336 |
778514 | 778514 | 2020-11-29 | Pottawattamie | Iowa | 19155 | 6319 | 70 |
778515 | 778515 | 2020-11-29 | Poweshiek | Iowa | 19157 | 993 | 13 |
778516 | 778516 | 2020-11-29 | Ringgold | Iowa | 19159 | 211 | 2 |
778517 | 778517 | 2020-11-29 | Sac | Iowa | 19161 | 860 | 8 |
778518 | 778518 | 2020-11-29 | Scott | Iowa | 19163 | 11248 | 86 |
778519 | 778519 | 2020-11-29 | Shelby | Iowa | 19165 | 765 | 11 |
778520 | 778520 | 2020-11-29 | Sioux | Iowa | 19167 | 3703 | 25 |
778521 | 778521 | 2020-11-29 | Story | Iowa | 19169 | 6790 | 22 |
778522 | 778522 | 2020-11-29 | Tama | Iowa | 19171 | 1543 | 40 |
778523 | 778523 | 2020-11-29 | Taylor | Iowa | 19173 | 465 | 3 |
778524 | 778524 | 2020-11-29 | Union | Iowa | 19175 | 770 | 6 |
778525 | 778525 | 2020-11-29 | Unknown | Iowa | 668 | 0 | |
778526 | 778526 | 2020-11-29 | Van Buren | Iowa | 19177 | 358 | 5 |
778527 | 778527 | 2020-11-29 | Wapello | Iowa | 19179 | 2558 | 72 |
778528 | 778528 | 2020-11-29 | Warren | Iowa | 19181 | 2818 | 14 |
778529 | 778529 | 2020-11-29 | Washington | Iowa | 19183 | 1414 | 14 |
778530 | 778530 | 2020-11-29 | Wayne | Iowa | 19185 | 300 | 7 |
778531 | 778531 | 2020-11-29 | Webster | Iowa | 19187 | 3584 | 35 |
778532 | 778532 | 2020-11-29 | Winnebago | Iowa | 19189 | 930 | 23 |
778533 | 778533 | 2020-11-29 | Winneshiek | Iowa | 19191 | 976 | 13 |
778534 | 778534 | 2020-11-29 | Woodbury | Iowa | 19193 | 10372 | 126 |
778535 | 778535 | 2020-11-29 | Worth | Iowa | 19195 | 363 | 0 |
778536 | 778536 | 2020-11-29 | Wright | Iowa | 19197 | 1245 | 6 |
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);