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 2021-07-03 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 |
---|---|---|---|---|---|---|---|
1479592 | 1479592 | 2021-07-03 | Adair | Iowa | 19001 | 876 | 32 |
1479593 | 1479593 | 2021-07-03 | Adams | Iowa | 19003 | 349 | 4 |
1479594 | 1479594 | 2021-07-03 | Allamakee | Iowa | 19005 | 1530 | 52 |
1479595 | 1479595 | 2021-07-03 | Appanoose | Iowa | 19007 | 1291 | 49 |
1479596 | 1479596 | 2021-07-03 | Audubon | Iowa | 19009 | 536 | 11 |
1479597 | 1479597 | 2021-07-03 | Benton | Iowa | 19011 | 2617 | 55 |
1479598 | 1479598 | 2021-07-03 | Black Hawk | Iowa | 19013 | 16337 | 316 |
1479599 | 1479599 | 2021-07-03 | Boone | Iowa | 19015 | 2686 | 34 |
1479600 | 1479600 | 2021-07-03 | Bremer | Iowa | 19017 | 2895 | 62 |
1479601 | 1479601 | 2021-07-03 | Buchanan | Iowa | 19019 | 1944 | 34 |
1479602 | 1479602 | 2021-07-03 | Buena Vista | Iowa | 19021 | 4274 | 40 |
1479603 | 1479603 | 2021-07-03 | Butler | Iowa | 19023 | 1669 | 35 |
1479604 | 1479604 | 2021-07-03 | Calhoun | Iowa | 19025 | 1395 | 13 |
1479605 | 1479605 | 2021-07-03 | Carroll | Iowa | 19027 | 2873 | 52 |
1479606 | 1479606 | 2021-07-03 | Cass | Iowa | 19029 | 1392 | 55 |
1479607 | 1479607 | 2021-07-03 | Cedar | Iowa | 19031 | 1925 | 23 |
1479608 | 1479608 | 2021-07-03 | Cerro Gordo | Iowa | 19033 | 5560 | 97 |
1479609 | 1479609 | 2021-07-03 | Cherokee | Iowa | 19035 | 1599 | 38 |
1479610 | 1479610 | 2021-07-03 | Chickasaw | Iowa | 19037 | 1251 | 17 |
1479611 | 1479611 | 2021-07-03 | Clarke | Iowa | 19039 | 1015 | 24 |
1479612 | 1479612 | 2021-07-03 | Clay | Iowa | 19041 | 2168 | 27 |
1479613 | 1479613 | 2021-07-03 | Clayton | Iowa | 19043 | 1713 | 57 |
1479614 | 1479614 | 2021-07-03 | Clinton | Iowa | 19045 | 5618 | 93 |
1479615 | 1479615 | 2021-07-03 | Crawford | Iowa | 19047 | 2690 | 41 |
1479616 | 1479616 | 2021-07-03 | Dallas | Iowa | 19049 | 11305 | 99 |
1479617 | 1479617 | 2021-07-03 | Davis | Iowa | 19051 | 853 | 25 |
1479618 | 1479618 | 2021-07-03 | Decatur | Iowa | 19053 | 623 | 9 |
1479619 | 1479619 | 2021-07-03 | Delaware | Iowa | 19055 | 2112 | 43 |
1479620 | 1479620 | 2021-07-03 | Des Moines | Iowa | 19057 | 4702 | 73 |
1479621 | 1479621 | 2021-07-03 | Dickinson | Iowa | 19059 | 2497 | 45 |
1479622 | 1479622 | 2021-07-03 | Dubuque | Iowa | 19061 | 13539 | 213 |
1479623 | 1479623 | 2021-07-03 | Emmet | Iowa | 19063 | 1361 | 41 |
1479624 | 1479624 | 2021-07-03 | Fayette | Iowa | 19065 | 1875 | 43 |
1479625 | 1479625 | 2021-07-03 | Floyd | Iowa | 19067 | 1639 | 42 |
1479626 | 1479626 | 2021-07-03 | Franklin | Iowa | 19069 | 1240 | 23 |
1479627 | 1479627 | 2021-07-03 | Fremont | Iowa | 19071 | 628 | 10 |
1479628 | 1479628 | 2021-07-03 | Greene | Iowa | 19073 | 781 | 11 |
1479629 | 1479629 | 2021-07-03 | Grundy | Iowa | 19075 | 1377 | 33 |
1479630 | 1479630 | 2021-07-03 | Guthrie | Iowa | 19077 | 1237 | 32 |
1479631 | 1479631 | 2021-07-03 | Hamilton | Iowa | 19079 | 1821 | 51 |
1479632 | 1479632 | 2021-07-03 | Hancock | Iowa | 19081 | 1507 | 34 |
1479633 | 1479633 | 2021-07-03 | Hardin | Iowa | 19083 | 1885 | 44 |
1479634 | 1479634 | 2021-07-03 | Harrison | Iowa | 19085 | 1802 | 73 |
1479635 | 1479635 | 2021-07-03 | Henry | Iowa | 19087 | 2955 | 37 |
1479636 | 1479636 | 2021-07-03 | Howard | Iowa | 19089 | 1051 | 22 |
1479637 | 1479637 | 2021-07-03 | Humboldt | Iowa | 19091 | 1207 | 26 |
1479638 | 1479638 | 2021-07-03 | Ida | Iowa | 19093 | 918 | 35 |
1479639 | 1479639 | 2021-07-03 | Iowa | Iowa | 19095 | 1500 | 24 |
1479640 | 1479640 | 2021-07-03 | Jackson | Iowa | 19097 | 2252 | 42 |
1479641 | 1479641 | 2021-07-03 | Jasper | Iowa | 19099 | 4220 | 73 |
1479642 | 1479642 | 2021-07-03 | Jefferson | Iowa | 19101 | 1341 | 35 |
1479643 | 1479643 | 2021-07-03 | Johnson | Iowa | 19103 | 14647 | 85 |
1479644 | 1479644 | 2021-07-03 | Jones | Iowa | 19105 | 3013 | 57 |
1479645 | 1479645 | 2021-07-03 | Keokuk | Iowa | 19107 | 971 | 32 |
1479646 | 1479646 | 2021-07-03 | Kossuth | Iowa | 19109 | 2164 | 66 |
1479647 | 1479647 | 2021-07-03 | Lee | Iowa | 19111 | 3856 | 57 |
1479648 | 1479648 | 2021-07-03 | Linn | Iowa | 19113 | 21299 | 341 |
1479649 | 1479649 | 2021-07-03 | Louisa | Iowa | 19115 | 1301 | 49 |
1479650 | 1479650 | 2021-07-03 | Lucas | Iowa | 19117 | 780 | 23 |
1479651 | 1479651 | 2021-07-03 | Lyon | Iowa | 19119 | 1599 | 41 |
1479652 | 1479652 | 2021-07-03 | Madison | Iowa | 19121 | 1648 | 19 |
1479653 | 1479653 | 2021-07-03 | Mahaska | Iowa | 19123 | 2330 | 51 |
1479654 | 1479654 | 2021-07-03 | Marion | Iowa | 19125 | 3663 | 77 |
1479655 | 1479655 | 2021-07-03 | Marshall | Iowa | 19127 | 4889 | 76 |
1479656 | 1479656 | 2021-07-03 | Mills | Iowa | 19129 | 1644 | 24 |
1479657 | 1479657 | 2021-07-03 | Mitchell | Iowa | 19131 | 1267 | 43 |
1479658 | 1479658 | 2021-07-03 | Monona | Iowa | 19133 | 836 | 31 |
1479659 | 1479659 | 2021-07-03 | Monroe | Iowa | 19135 | 964 | 32 |
1479660 | 1479660 | 2021-07-03 | Montgomery | Iowa | 19137 | 1036 | 38 |
1479661 | 1479661 | 2021-07-03 | Muscatine | Iowa | 19139 | 4892 | 106 |
1479662 | 1479662 | 2021-07-03 | O'Brien | Iowa | 19141 | 1998 | 61 |
1479663 | 1479663 | 2021-07-03 | Osceola | Iowa | 19143 | 789 | 17 |
1479664 | 1479664 | 2021-07-03 | Page | Iowa | 19145 | 1945 | 22 |
1479665 | 1479665 | 2021-07-03 | Palo Alto | Iowa | 19147 | 1136 | 24 |
1479666 | 1479666 | 2021-07-03 | Plymouth | Iowa | 19149 | 4034 | 82 |
1479667 | 1479667 | 2021-07-03 | Pocahontas | Iowa | 19151 | 858 | 22 |
1479668 | 1479668 | 2021-07-03 | Polk | Iowa | 19153 | 58371 | 643 |
1479669 | 1479669 | 2021-07-03 | Pottawattamie | Iowa | 19155 | 11249 | 177 |
1479670 | 1479670 | 2021-07-03 | Poweshiek | Iowa | 19157 | 1572 | 36 |
1479671 | 1479671 | 2021-07-03 | Ringgold | Iowa | 19159 | 567 | 24 |
1479672 | 1479672 | 2021-07-03 | Sac | Iowa | 19161 | 1310 | 20 |
1479673 | 1479673 | 2021-07-03 | Scott | Iowa | 19163 | 20339 | 249 |
1479674 | 1479674 | 2021-07-03 | Shelby | Iowa | 19165 | 1320 | 37 |
1479675 | 1479675 | 2021-07-03 | Sioux | Iowa | 19167 | 5179 | 74 |
1479676 | 1479676 | 2021-07-03 | Story | Iowa | 19169 | 10731 | 48 |
1479677 | 1479677 | 2021-07-03 | Tama | Iowa | 19171 | 2127 | 72 |
1479678 | 1479678 | 2021-07-03 | Taylor | Iowa | 19173 | 668 | 12 |
1479679 | 1479679 | 2021-07-03 | Union | Iowa | 19175 | 1301 | 35 |
1479680 | 1479680 | 2021-07-03 | Unknown | Iowa | 948 | 0 | |
1479681 | 1479681 | 2021-07-03 | Van Buren | Iowa | 19177 | 566 | 18 |
1479682 | 1479682 | 2021-07-03 | Wapello | Iowa | 19179 | 4349 | 122 |
1479683 | 1479683 | 2021-07-03 | Warren | Iowa | 19181 | 5854 | 92 |
1479684 | 1479684 | 2021-07-03 | Washington | Iowa | 19183 | 2575 | 51 |
1479685 | 1479685 | 2021-07-03 | Wayne | Iowa | 19185 | 551 | 23 |
1479686 | 1479686 | 2021-07-03 | Webster | Iowa | 19187 | 5213 | 94 |
1479687 | 1479687 | 2021-07-03 | Winnebago | Iowa | 19189 | 1448 | 31 |
1479688 | 1479688 | 2021-07-03 | Winneshiek | Iowa | 19191 | 2005 | 35 |
1479689 | 1479689 | 2021-07-03 | Woodbury | Iowa | 19193 | 15258 | 230 |
1479690 | 1479690 | 2021-07-03 | Worth | Iowa | 19195 | 763 | 8 |
1479691 | 1479691 | 2021-07-03 | Wright | Iowa | 19197 | 1866 | 40 |
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);