ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-12-24" 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 |
---|---|---|---|---|---|---|---|
859572 | 859572 | 2020-12-24 | Adair | Iowa | 19001 | 566 | 17 |
859573 | 859573 | 2020-12-24 | Adams | Iowa | 19003 | 249 | 2 |
859574 | 859574 | 2020-12-24 | Allamakee | Iowa | 19005 | 1133 | 20 |
859575 | 859575 | 2020-12-24 | Appanoose | Iowa | 19007 | 933 | 34 |
859576 | 859576 | 2020-12-24 | Audubon | Iowa | 19009 | 363 | 7 |
859577 | 859577 | 2020-12-24 | Benton | Iowa | 19011 | 1953 | 36 |
859578 | 859578 | 2020-12-24 | Black Hawk | Iowa | 19013 | 12480 | 214 |
859579 | 859579 | 2020-12-24 | Boone | Iowa | 19015 | 1797 | 15 |
859580 | 859580 | 2020-12-24 | Bremer | Iowa | 19017 | 2214 | 41 |
859581 | 859581 | 2020-12-24 | Buchanan | Iowa | 19019 | 1401 | 16 |
859582 | 859582 | 2020-12-24 | Buena Vista | Iowa | 19021 | 3623 | 25 |
859583 | 859583 | 2020-12-24 | Butler | Iowa | 19023 | 1235 | 18 |
859584 | 859584 | 2020-12-24 | Calhoun | Iowa | 19025 | 1164 | 9 |
859585 | 859585 | 2020-12-24 | Carroll | Iowa | 19027 | 2309 | 27 |
859586 | 859586 | 2020-12-24 | Cass | Iowa | 19029 | 1007 | 38 |
859587 | 859587 | 2020-12-24 | Cedar | Iowa | 19031 | 1343 | 18 |
859588 | 859588 | 2020-12-24 | Cerro Gordo | Iowa | 19033 | 4227 | 59 |
859589 | 859589 | 2020-12-24 | Cherokee | Iowa | 19035 | 1188 | 20 |
859590 | 859590 | 2020-12-24 | Chickasaw | Iowa | 19037 | 1010 | 10 |
859591 | 859591 | 2020-12-24 | Clarke | Iowa | 19039 | 645 | 6 |
859592 | 859592 | 2020-12-24 | Clay | Iowa | 19041 | 1508 | 11 |
859593 | 859593 | 2020-12-24 | Clayton | Iowa | 19043 | 1331 | 39 |
859594 | 859594 | 2020-12-24 | Clinton | Iowa | 19045 | 4018 | 53 |
859595 | 859595 | 2020-12-24 | Crawford | Iowa | 19047 | 2060 | 20 |
859596 | 859596 | 2020-12-24 | Dallas | Iowa | 19049 | 7689 | 63 |
859597 | 859597 | 2020-12-24 | Davis | Iowa | 19051 | 621 | 18 |
859598 | 859598 | 2020-12-24 | Decatur | Iowa | 19053 | 411 | 3 |
859599 | 859599 | 2020-12-24 | Delaware | Iowa | 19055 | 1599 | 29 |
859600 | 859600 | 2020-12-24 | Des Moines | Iowa | 19057 | 3429 | 32 |
859601 | 859601 | 2020-12-24 | Dickinson | Iowa | 19059 | 1667 | 15 |
859602 | 859602 | 2020-12-24 | Dubuque | Iowa | 19061 | 10400 | 135 |
859603 | 859603 | 2020-12-24 | Emmet | Iowa | 19063 | 978 | 23 |
859604 | 859604 | 2020-12-24 | Fayette | Iowa | 19065 | 1308 | 16 |
859605 | 859605 | 2020-12-24 | Floyd | Iowa | 19067 | 1249 | 33 |
859606 | 859606 | 2020-12-24 | Franklin | Iowa | 19069 | 864 | 17 |
859607 | 859607 | 2020-12-24 | Fremont | Iowa | 19071 | 454 | 5 |
859608 | 859608 | 2020-12-24 | Greene | Iowa | 19073 | 632 | 7 |
859609 | 859609 | 2020-12-24 | Grundy | Iowa | 19075 | 1035 | 15 |
859610 | 859610 | 2020-12-24 | Guthrie | Iowa | 19077 | 924 | 22 |
859611 | 859611 | 2020-12-24 | Hamilton | Iowa | 19079 | 1431 | 22 |
859612 | 859612 | 2020-12-24 | Hancock | Iowa | 19081 | 1140 | 24 |
859613 | 859613 | 2020-12-24 | Hardin | Iowa | 19083 | 1420 | 25 |
859614 | 859614 | 2020-12-24 | Harrison | Iowa | 19085 | 1386 | 52 |
859615 | 859615 | 2020-12-24 | Henry | Iowa | 19087 | 2437 | 24 |
859616 | 859616 | 2020-12-24 | Howard | Iowa | 19089 | 679 | 15 |
859617 | 859617 | 2020-12-24 | Humboldt | Iowa | 19091 | 930 | 18 |
859618 | 859618 | 2020-12-24 | Ida | Iowa | 19093 | 680 | 22 |
859619 | 859619 | 2020-12-24 | Iowa | Iowa | 19095 | 1118 | 20 |
859620 | 859620 | 2020-12-24 | Jackson | Iowa | 19097 | 1744 | 29 |
859621 | 859621 | 2020-12-24 | Jasper | Iowa | 19099 | 2803 | 52 |
859622 | 859622 | 2020-12-24 | Jefferson | Iowa | 19101 | 963 | 20 |
859623 | 859623 | 2020-12-24 | Johnson | Iowa | 19103 | 10779 | 47 |
859624 | 859624 | 2020-12-24 | Jones | Iowa | 19105 | 2551 | 44 |
859625 | 859625 | 2020-12-24 | Keokuk | Iowa | 19107 | 766 | 23 |
859626 | 859626 | 2020-12-24 | Kossuth | Iowa | 19109 | 1468 | 27 |
859627 | 859627 | 2020-12-24 | Lee | Iowa | 19111 | 2785 | 24 |
859628 | 859628 | 2020-12-24 | Linn | Iowa | 19113 | 16292 | 240 |
859629 | 859629 | 2020-12-24 | Louisa | Iowa | 19115 | 1029 | 24 |
859630 | 859630 | 2020-12-24 | Lucas | Iowa | 19117 | 524 | 7 |
859631 | 859631 | 2020-12-24 | Lyon | Iowa | 19119 | 1220 | 24 |
859632 | 859632 | 2020-12-24 | Madison | Iowa | 19121 | 913 | 8 |
859633 | 859633 | 2020-12-24 | Mahaska | Iowa | 19123 | 1649 | 32 |
859634 | 859634 | 2020-12-24 | Marion | Iowa | 19125 | 2596 | 46 |
859635 | 859635 | 2020-12-24 | Marshall | Iowa | 19127 | 3930 | 54 |
859636 | 859636 | 2020-12-24 | Mills | Iowa | 19129 | 1253 | 14 |
859637 | 859637 | 2020-12-24 | Mitchell | Iowa | 19131 | 986 | 27 |
859638 | 859638 | 2020-12-24 | Monona | Iowa | 19133 | 539 | 15 |
859639 | 859639 | 2020-12-24 | Monroe | Iowa | 19135 | 603 | 16 |
859640 | 859640 | 2020-12-24 | Montgomery | Iowa | 19137 | 712 | 15 |
859641 | 859641 | 2020-12-24 | Muscatine | Iowa | 19139 | 3471 | 73 |
859642 | 859642 | 2020-12-24 | O'Brien | Iowa | 19141 | 1566 | 50 |
859643 | 859643 | 2020-12-24 | Osceola | Iowa | 19143 | 604 | 7 |
859644 | 859644 | 2020-12-24 | Page | Iowa | 19145 | 1333 | 13 |
859645 | 859645 | 2020-12-24 | Palo Alto | Iowa | 19147 | 786 | 8 |
859646 | 859646 | 2020-12-24 | Plymouth | Iowa | 19149 | 3300 | 51 |
859647 | 859647 | 2020-12-24 | Pocahontas | Iowa | 19151 | 683 | 11 |
859648 | 859648 | 2020-12-24 | Polk | Iowa | 19153 | 40318 | 406 |
859649 | 859649 | 2020-12-24 | Pottawattamie | Iowa | 19155 | 8056 | 89 |
859650 | 859650 | 2020-12-24 | Poweshiek | Iowa | 19157 | 1165 | 24 |
859651 | 859651 | 2020-12-24 | Ringgold | Iowa | 19159 | 352 | 7 |
859652 | 859652 | 2020-12-24 | Sac | Iowa | 19161 | 1018 | 14 |
859653 | 859653 | 2020-12-24 | Scott | Iowa | 19163 | 13725 | 146 |
859654 | 859654 | 2020-12-24 | Shelby | Iowa | 19165 | 921 | 23 |
859655 | 859655 | 2020-12-24 | Sioux | Iowa | 19167 | 4266 | 41 |
859656 | 859656 | 2020-12-24 | Story | Iowa | 19169 | 7842 | 29 |
859657 | 859657 | 2020-12-24 | Tama | Iowa | 19171 | 1726 | 55 |
859658 | 859658 | 2020-12-24 | Taylor | Iowa | 19173 | 527 | 8 |
859659 | 859659 | 2020-12-24 | Union | Iowa | 19175 | 999 | 16 |
859660 | 859660 | 2020-12-24 | Unknown | Iowa | 615 | 1 | |
859661 | 859661 | 2020-12-24 | Van Buren | Iowa | 19177 | 447 | 11 |
859662 | 859662 | 2020-12-24 | Wapello | Iowa | 19179 | 3034 | 90 |
859663 | 859663 | 2020-12-24 | Warren | Iowa | 19181 | 3629 | 33 |
859664 | 859664 | 2020-12-24 | Washington | Iowa | 19183 | 1805 | 27 |
859665 | 859665 | 2020-12-24 | Wayne | Iowa | 19185 | 360 | 21 |
859666 | 859666 | 2020-12-24 | Webster | Iowa | 19187 | 4327 | 61 |
859667 | 859667 | 2020-12-24 | Winnebago | Iowa | 19189 | 1088 | 28 |
859668 | 859668 | 2020-12-24 | Winneshiek | Iowa | 19191 | 1339 | 17 |
859669 | 859669 | 2020-12-24 | Woodbury | Iowa | 19193 | 12028 | 163 |
859670 | 859670 | 2020-12-24 | Worth | Iowa | 19195 | 492 | 2 |
859671 | 859671 | 2020-12-24 | Wright | Iowa | 19197 | 1496 | 16 |
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);