ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,070 rows where state = "Iowa" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 100
- 19103 797
- 19155 796
- 19027 793
- 19085 792
- 19049 791
- 19005 790
- 19153 790
- 19001 788
- 19013 788
- 19183 787
- 19191 787
- 19061 786
- 19139 786
- 19065 784
- 19087 784
- 19113 784
- 19169 784
- 19033 783
- 19109 783
- 19157 783
- 19163 783
- 19167 783
- 19171 783
- 19193 783
- 19081 782
- 19179 782
- 19019 781
- 19031 781
- 19099 781
- 19181 781
- 19011 780
- 19007 779
- 19043 779
- 19057 779
- 19123 779
- 19133 779
- 19145 779
- 19023 778
- 19045 778
- 19059 778
- 19083 778
- 19095 778
- 19127 778
- 19137 778
- 19187 778
- 19197 778
- 19015 777
- 19107 777
- 19165 777
- 19173 777
- 19009 775
- 19047 775
- 19077 775
- 19097 775
- 19105 775
- 19177 775
- 19041 774
- 19121 773
- 19131 773
- 19017 772
- 19101 772
- 19141 772
- 19115 771
- 19119 771
- 19149 771
- 19075 770
- 19089 770
- 19111 770
- 19129 770
- 19039 769
- 19079 769
- 19037 768
- 19069 768
- 19125 768
- 19189 768
- 19021 767
- 19055 767
- 19073 767
- 19195 766
- 19143 764
- 19175 764
- 19029 761
- 19035 753
- 19091 753
- 19151 747
- 19051 745
- 19025 743
- 19067 743
- 19161 743
- 19185 743
- - 743
- 19135 741
- 19071 736
- 19147 736
- 19093 732
- 19063 731
- 19003 727
- 19117 727
- 19159 725
- 19053 717
county 100
- Johnson 797
- Pottawattamie 796
- Carroll 793
- Harrison 792
- Dallas 791
- Allamakee 790
- Polk 790
- Adair 788
- Black Hawk 788
- Washington 787
- Winneshiek 787
- Dubuque 786
- Muscatine 786
- Fayette 784
- Henry 784
- Linn 784
- Story 784
- Cerro Gordo 783
- Kossuth 783
- Poweshiek 783
- Scott 783
- Sioux 783
- Tama 783
- Woodbury 783
- Hancock 782
- Wapello 782
- Buchanan 781
- Cedar 781
- Jasper 781
- Warren 781
- Benton 780
- Appanoose 779
- Clayton 779
- Des Moines 779
- Mahaska 779
- Monona 779
- Page 779
- Butler 778
- Clinton 778
- Dickinson 778
- Hardin 778
- Iowa 778
- Marshall 778
- Montgomery 778
- Webster 778
- Wright 778
- Boone 777
- Keokuk 777
- Shelby 777
- Taylor 777
- Audubon 775
- Crawford 775
- Guthrie 775
- Jackson 775
- Jones 775
- Van Buren 775
- Clay 774
- Madison 773
- Mitchell 773
- Bremer 772
- Jefferson 772
- O'Brien 772
- Louisa 771
- Lyon 771
- Plymouth 771
- Grundy 770
- Howard 770
- Lee 770
- Mills 770
- Clarke 769
- Hamilton 769
- Chickasaw 768
- Franklin 768
- Marion 768
- Winnebago 768
- Buena Vista 767
- Delaware 767
- Greene 767
- Worth 766
- Osceola 764
- Union 764
- Cass 761
- Cherokee 753
- Humboldt 753
- Pocahontas 747
- Davis 745
- Calhoun 743
- Floyd 743
- Sac 743
- Unknown 743
- Wayne 743
- Monroe 741
- Fremont 736
- Palo Alto 736
- Ida 732
- Emmet 731
- Adams 727
- Lucas 727
- Ringgold 725
- Decatur 717
state 1
- Iowa · 77,070 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
797 | 797 | 2020-03-08 | Johnson | Iowa | 19103 | 3 | 0 |
918 | 918 | 2020-03-09 | Johnson | Iowa | 19103 | 7 | 0 |
919 | 919 | 2020-03-09 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1063 | 1063 | 2020-03-10 | Johnson | Iowa | 19103 | 12 | 0 |
1064 | 1064 | 2020-03-10 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1241 | 1241 | 2020-03-11 | Johnson | Iowa | 19103 | 13 | 0 |
1242 | 1242 | 2020-03-11 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1455 | 1455 | 2020-03-12 | Carroll | Iowa | 19027 | 1 | 0 |
1456 | 1456 | 2020-03-12 | Johnson | Iowa | 19103 | 14 | 0 |
1457 | 1457 | 2020-03-12 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1726 | 1726 | 2020-03-13 | Carroll | Iowa | 19027 | 1 | 0 |
1727 | 1727 | 2020-03-13 | Harrison | Iowa | 19085 | 1 | 0 |
1728 | 1728 | 2020-03-13 | Johnson | Iowa | 19103 | 14 | 0 |
1729 | 1729 | 2020-03-13 | Pottawattamie | Iowa | 19155 | 1 | 0 |
2059 | 2059 | 2020-03-14 | Carroll | Iowa | 19027 | 1 | 0 |
2060 | 2060 | 2020-03-14 | Dallas | Iowa | 19049 | 1 | 0 |
2061 | 2061 | 2020-03-14 | Harrison | Iowa | 19085 | 1 | 0 |
2062 | 2062 | 2020-03-14 | Johnson | Iowa | 19103 | 14 | 0 |
2063 | 2063 | 2020-03-14 | Pottawattamie | Iowa | 19155 | 1 | 0 |
2453 | 2453 | 2020-03-15 | Allamakee | Iowa | 19005 | 2 | 0 |
2454 | 2454 | 2020-03-15 | Carroll | Iowa | 19027 | 1 | 0 |
2455 | 2455 | 2020-03-15 | Dallas | Iowa | 19049 | 1 | 0 |
2456 | 2456 | 2020-03-15 | Harrison | Iowa | 19085 | 1 | 0 |
2457 | 2457 | 2020-03-15 | Johnson | Iowa | 19103 | 15 | 0 |
2458 | 2458 | 2020-03-15 | Polk | Iowa | 19153 | 1 | 0 |
2459 | 2459 | 2020-03-15 | Pottawattamie | Iowa | 19155 | 1 | 0 |
2898 | 2898 | 2020-03-16 | Allamakee | Iowa | 19005 | 2 | 0 |
2899 | 2899 | 2020-03-16 | Carroll | Iowa | 19027 | 1 | 0 |
2900 | 2900 | 2020-03-16 | Dallas | Iowa | 19049 | 1 | 0 |
2901 | 2901 | 2020-03-16 | Harrison | Iowa | 19085 | 1 | 0 |
2902 | 2902 | 2020-03-16 | Johnson | Iowa | 19103 | 15 | 0 |
2903 | 2903 | 2020-03-16 | Polk | Iowa | 19153 | 1 | 0 |
2904 | 2904 | 2020-03-16 | Pottawattamie | Iowa | 19155 | 1 | 0 |
3389 | 3389 | 2020-03-17 | Adair | Iowa | 19001 | 1 | 0 |
3390 | 3390 | 2020-03-17 | Allamakee | Iowa | 19005 | 2 | 0 |
3391 | 3391 | 2020-03-17 | Black Hawk | Iowa | 19013 | 1 | 0 |
3392 | 3392 | 2020-03-17 | Carroll | Iowa | 19027 | 1 | 0 |
3393 | 3393 | 2020-03-17 | Dallas | Iowa | 19049 | 3 | 0 |
3394 | 3394 | 2020-03-17 | Harrison | Iowa | 19085 | 1 | 0 |
3395 | 3395 | 2020-03-17 | Johnson | Iowa | 19103 | 18 | 0 |
3396 | 3396 | 2020-03-17 | Polk | Iowa | 19153 | 1 | 0 |
3397 | 3397 | 2020-03-17 | Pottawattamie | Iowa | 19155 | 1 | 0 |
3963 | 3963 | 2020-03-18 | Adair | Iowa | 19001 | 1 | 0 |
3964 | 3964 | 2020-03-18 | Allamakee | Iowa | 19005 | 2 | 0 |
3965 | 3965 | 2020-03-18 | Black Hawk | Iowa | 19013 | 1 | 0 |
3966 | 3966 | 2020-03-18 | Carroll | Iowa | 19027 | 1 | 0 |
3967 | 3967 | 2020-03-18 | Dallas | Iowa | 19049 | 5 | 0 |
3968 | 3968 | 2020-03-18 | Harrison | Iowa | 19085 | 1 | 0 |
3969 | 3969 | 2020-03-18 | Johnson | Iowa | 19103 | 21 | 0 |
3970 | 3970 | 2020-03-18 | Polk | Iowa | 19153 | 3 | 0 |
3971 | 3971 | 2020-03-18 | Pottawattamie | Iowa | 19155 | 1 | 0 |
3972 | 3972 | 2020-03-18 | Washington | Iowa | 19183 | 1 | 0 |
3973 | 3973 | 2020-03-18 | Winneshiek | Iowa | 19191 | 1 | 0 |
4642 | 4642 | 2020-03-19 | Adair | Iowa | 19001 | 1 | 0 |
4643 | 4643 | 2020-03-19 | Allamakee | Iowa | 19005 | 2 | 0 |
4644 | 4644 | 2020-03-19 | Black Hawk | Iowa | 19013 | 1 | 0 |
4645 | 4645 | 2020-03-19 | Carroll | Iowa | 19027 | 1 | 0 |
4646 | 4646 | 2020-03-19 | Dallas | Iowa | 19049 | 5 | 0 |
4647 | 4647 | 2020-03-19 | Dubuque | Iowa | 19061 | 1 | 0 |
4648 | 4648 | 2020-03-19 | Harrison | Iowa | 19085 | 1 | 0 |
4649 | 4649 | 2020-03-19 | Johnson | Iowa | 19103 | 22 | 0 |
4650 | 4650 | 2020-03-19 | Muscatine | Iowa | 19139 | 1 | 0 |
4651 | 4651 | 2020-03-19 | Polk | Iowa | 19153 | 6 | 0 |
4652 | 4652 | 2020-03-19 | Pottawattamie | Iowa | 19155 | 1 | 0 |
4653 | 4653 | 2020-03-19 | Washington | Iowa | 19183 | 1 | 0 |
4654 | 4654 | 2020-03-19 | Winneshiek | Iowa | 19191 | 1 | 0 |
5453 | 5453 | 2020-03-20 | Adair | Iowa | 19001 | 1 | 0 |
5454 | 5454 | 2020-03-20 | Allamakee | Iowa | 19005 | 3 | 0 |
5455 | 5455 | 2020-03-20 | Black Hawk | Iowa | 19013 | 1 | 0 |
5456 | 5456 | 2020-03-20 | Carroll | Iowa | 19027 | 1 | 0 |
5457 | 5457 | 2020-03-20 | Dallas | Iowa | 19049 | 5 | 0 |
5458 | 5458 | 2020-03-20 | Dubuque | Iowa | 19061 | 1 | 0 |
5459 | 5459 | 2020-03-20 | Harrison | Iowa | 19085 | 1 | 0 |
5460 | 5460 | 2020-03-20 | Johnson | Iowa | 19103 | 22 | 0 |
5461 | 5461 | 2020-03-20 | Muscatine | Iowa | 19139 | 1 | 0 |
5462 | 5462 | 2020-03-20 | Polk | Iowa | 19153 | 6 | 0 |
5463 | 5463 | 2020-03-20 | Pottawattamie | Iowa | 19155 | 1 | 0 |
5464 | 5464 | 2020-03-20 | Washington | Iowa | 19183 | 1 | 0 |
5465 | 5465 | 2020-03-20 | Winneshiek | Iowa | 19191 | 1 | 0 |
6394 | 6394 | 2020-03-21 | Adair | Iowa | 19001 | 1 | 0 |
6395 | 6395 | 2020-03-21 | Allamakee | Iowa | 19005 | 5 | 0 |
6396 | 6396 | 2020-03-21 | Black Hawk | Iowa | 19013 | 3 | 0 |
6397 | 6397 | 2020-03-21 | Carroll | Iowa | 19027 | 1 | 0 |
6398 | 6398 | 2020-03-21 | Dallas | Iowa | 19049 | 5 | 0 |
6399 | 6399 | 2020-03-21 | Dubuque | Iowa | 19061 | 2 | 0 |
6400 | 6400 | 2020-03-21 | Fayette | Iowa | 19065 | 1 | 0 |
6401 | 6401 | 2020-03-21 | Harrison | Iowa | 19085 | 1 | 0 |
6402 | 6402 | 2020-03-21 | Henry | Iowa | 19087 | 1 | 0 |
6403 | 6403 | 2020-03-21 | Johnson | Iowa | 19103 | 27 | 0 |
6404 | 6404 | 2020-03-21 | Linn | Iowa | 19113 | 3 | 0 |
6405 | 6405 | 2020-03-21 | Muscatine | Iowa | 19139 | 2 | 0 |
6406 | 6406 | 2020-03-21 | Polk | Iowa | 19153 | 10 | 0 |
6407 | 6407 | 2020-03-21 | Pottawattamie | Iowa | 19155 | 2 | 0 |
6408 | 6408 | 2020-03-21 | Story | Iowa | 19169 | 1 | 0 |
6409 | 6409 | 2020-03-21 | Washington | Iowa | 19183 | 2 | 0 |
6410 | 6410 | 2020-03-21 | Winneshiek | Iowa | 19191 | 1 | 0 |
7454 | 7454 | 2020-03-22 | Adair | Iowa | 19001 | 1 | 0 |
7455 | 7455 | 2020-03-22 | Allamakee | Iowa | 19005 | 5 | 0 |
7456 | 7456 | 2020-03-22 | Black Hawk | Iowa | 19013 | 3 | 0 |
7457 | 7457 | 2020-03-22 | Carroll | Iowa | 19027 | 1 | 0 |
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);