ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-11-14" 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 |
---|---|---|---|---|---|---|---|
729752 | 729752 | 2020-11-14 | Adair | Iowa | 19001 | 342 | 5 |
729753 | 729753 | 2020-11-14 | Adams | Iowa | 19003 | 134 | 1 |
729754 | 729754 | 2020-11-14 | Allamakee | Iowa | 19005 | 606 | 9 |
729755 | 729755 | 2020-11-14 | Appanoose | Iowa | 19007 | 605 | 3 |
729756 | 729756 | 2020-11-14 | Audubon | Iowa | 19009 | 252 | 1 |
729757 | 729757 | 2020-11-14 | Benton | Iowa | 19011 | 1343 | 10 |
729758 | 729758 | 2020-11-14 | Black Hawk | Iowa | 19013 | 8967 | 115 |
729759 | 729759 | 2020-11-14 | Boone | Iowa | 19015 | 1064 | 10 |
729760 | 729760 | 2020-11-14 | Bremer | Iowa | 19017 | 1455 | 12 |
729761 | 729761 | 2020-11-14 | Buchanan | Iowa | 19019 | 881 | 6 |
729762 | 729762 | 2020-11-14 | Buena Vista | Iowa | 19021 | 2709 | 13 |
729763 | 729763 | 2020-11-14 | Butler | Iowa | 19023 | 756 | 3 |
729764 | 729764 | 2020-11-14 | Calhoun | Iowa | 19025 | 864 | 6 |
729765 | 729765 | 2020-11-14 | Carroll | Iowa | 19027 | 1684 | 14 |
729766 | 729766 | 2020-11-14 | Cass | Iowa | 19029 | 647 | 14 |
729767 | 729767 | 2020-11-14 | Cedar | Iowa | 19031 | 837 | 13 |
729768 | 729768 | 2020-11-14 | Cerro Gordo | Iowa | 19033 | 2592 | 32 |
729769 | 729769 | 2020-11-14 | Cherokee | Iowa | 19035 | 619 | 4 |
729770 | 729770 | 2020-11-14 | Chickasaw | Iowa | 19037 | 618 | 1 |
729771 | 729771 | 2020-11-14 | Clarke | Iowa | 19039 | 425 | 4 |
729772 | 729772 | 2020-11-14 | Clay | Iowa | 19041 | 880 | 4 |
729773 | 729773 | 2020-11-14 | Clayton | Iowa | 19043 | 829 | 4 |
729774 | 729774 | 2020-11-14 | Clinton | Iowa | 19045 | 2581 | 35 |
729775 | 729775 | 2020-11-14 | Crawford | Iowa | 19047 | 1594 | 15 |
729776 | 729776 | 2020-11-14 | Dallas | Iowa | 19049 | 5210 | 53 |
729777 | 729777 | 2020-11-14 | Davis | Iowa | 19051 | 315 | 4 |
729778 | 729778 | 2020-11-14 | Decatur | Iowa | 19053 | 261 | 0 |
729779 | 729779 | 2020-11-14 | Delaware | Iowa | 19055 | 1179 | 18 |
729780 | 729780 | 2020-11-14 | Des Moines | Iowa | 19057 | 2320 | 13 |
729781 | 729781 | 2020-11-14 | Dickinson | Iowa | 19059 | 1100 | 9 |
729782 | 729782 | 2020-11-14 | Dubuque | Iowa | 19061 | 7744 | 78 |
729783 | 729783 | 2020-11-14 | Emmet | Iowa | 19063 | 616 | 22 |
729784 | 729784 | 2020-11-14 | Fayette | Iowa | 19065 | 783 | 8 |
729785 | 729785 | 2020-11-14 | Floyd | Iowa | 19067 | 735 | 12 |
729786 | 729786 | 2020-11-14 | Franklin | Iowa | 19069 | 579 | 19 |
729787 | 729787 | 2020-11-14 | Fremont | Iowa | 19071 | 281 | 2 |
729788 | 729788 | 2020-11-14 | Greene | Iowa | 19073 | 387 | 0 |
729789 | 729789 | 2020-11-14 | Grundy | Iowa | 19075 | 633 | 7 |
729790 | 729790 | 2020-11-14 | Guthrie | Iowa | 19077 | 612 | 15 |
729791 | 729791 | 2020-11-14 | Hamilton | Iowa | 19079 | 755 | 6 |
729792 | 729792 | 2020-11-14 | Hancock | Iowa | 19081 | 659 | 6 |
729793 | 729793 | 2020-11-14 | Hardin | Iowa | 19083 | 885 | 9 |
729794 | 729794 | 2020-11-14 | Harrison | Iowa | 19085 | 882 | 24 |
729795 | 729795 | 2020-11-14 | Henry | Iowa | 19087 | 1511 | 7 |
729796 | 729796 | 2020-11-14 | Howard | Iowa | 19089 | 398 | 9 |
729797 | 729797 | 2020-11-14 | Humboldt | Iowa | 19091 | 567 | 3 |
729798 | 729798 | 2020-11-14 | Ida | Iowa | 19093 | 383 | 6 |
729799 | 729799 | 2020-11-14 | Iowa | Iowa | 19095 | 733 | 11 |
729800 | 729800 | 2020-11-14 | Jackson | Iowa | 19097 | 1201 | 5 |
729801 | 729801 | 2020-11-14 | Jasper | Iowa | 19099 | 1774 | 36 |
729802 | 729802 | 2020-11-14 | Jefferson | Iowa | 19101 | 486 | 1 |
729803 | 729803 | 2020-11-14 | Johnson | Iowa | 19103 | 8125 | 35 |
729804 | 729804 | 2020-11-14 | Jones | Iowa | 19105 | 1817 | 8 |
729805 | 729805 | 2020-11-14 | Keokuk | Iowa | 19107 | 424 | 2 |
729806 | 729806 | 2020-11-14 | Kossuth | Iowa | 19109 | 765 | 2 |
729807 | 729807 | 2020-11-14 | Lee | Iowa | 19111 | 1606 | 14 |
729808 | 729808 | 2020-11-14 | Linn | Iowa | 19113 | 11495 | 148 |
729809 | 729809 | 2020-11-14 | Louisa | Iowa | 19115 | 707 | 16 |
729810 | 729810 | 2020-11-14 | Lucas | Iowa | 19117 | 279 | 6 |
729811 | 729811 | 2020-11-14 | Lyon | Iowa | 19119 | 771 | 8 |
729812 | 729812 | 2020-11-14 | Madison | Iowa | 19121 | 549 | 4 |
729813 | 729813 | 2020-11-14 | Mahaska | Iowa | 19123 | 1044 | 26 |
729814 | 729814 | 2020-11-14 | Marion | Iowa | 19125 | 1597 | 16 |
729815 | 729815 | 2020-11-14 | Marshall | Iowa | 19127 | 2939 | 38 |
729816 | 729816 | 2020-11-14 | Mills | Iowa | 19129 | 759 | 4 |
729817 | 729817 | 2020-11-14 | Mitchell | Iowa | 19131 | 567 | 3 |
729818 | 729818 | 2020-11-14 | Monona | Iowa | 19133 | 330 | 2 |
729819 | 729819 | 2020-11-14 | Monroe | Iowa | 19135 | 367 | 12 |
729820 | 729820 | 2020-11-14 | Montgomery | Iowa | 19137 | 343 | 9 |
729821 | 729821 | 2020-11-14 | Muscatine | Iowa | 19139 | 2261 | 61 |
729822 | 729822 | 2020-11-14 | O'Brien | Iowa | 19141 | 1085 | 24 |
729823 | 729823 | 2020-11-14 | Osceola | Iowa | 19143 | 436 | 0 |
729824 | 729824 | 2020-11-14 | Page | Iowa | 19145 | 955 | 2 |
729825 | 729825 | 2020-11-14 | Palo Alto | Iowa | 19147 | 505 | 3 |
729826 | 729826 | 2020-11-14 | Plymouth | Iowa | 19149 | 2348 | 34 |
729827 | 729827 | 2020-11-14 | Pocahontas | Iowa | 19151 | 441 | 2 |
729828 | 729828 | 2020-11-14 | Polk | Iowa | 19153 | 27414 | 304 |
729829 | 729829 | 2020-11-14 | Pottawattamie | Iowa | 19155 | 4651 | 55 |
729830 | 729830 | 2020-11-14 | Poweshiek | Iowa | 19157 | 805 | 11 |
729831 | 729831 | 2020-11-14 | Ringgold | Iowa | 19159 | 137 | 2 |
729832 | 729832 | 2020-11-14 | Sac | Iowa | 19161 | 653 | 6 |
729833 | 729833 | 2020-11-14 | Scott | Iowa | 19163 | 8452 | 58 |
729834 | 729834 | 2020-11-14 | Shelby | Iowa | 19165 | 624 | 3 |
729835 | 729835 | 2020-11-14 | Sioux | Iowa | 19167 | 3193 | 22 |
729836 | 729836 | 2020-11-14 | Story | Iowa | 19169 | 5490 | 18 |
729837 | 729837 | 2020-11-14 | Tama | Iowa | 19171 | 1325 | 39 |
729838 | 729838 | 2020-11-14 | Taylor | Iowa | 19173 | 374 | 2 |
729839 | 729839 | 2020-11-14 | Union | Iowa | 19175 | 546 | 6 |
729840 | 729840 | 2020-11-14 | Unknown | Iowa | 514 | 0 | |
729841 | 729841 | 2020-11-14 | Van Buren | Iowa | 19177 | 286 | 3 |
729842 | 729842 | 2020-11-14 | Wapello | Iowa | 19179 | 2100 | 69 |
729843 | 729843 | 2020-11-14 | Warren | Iowa | 19181 | 2120 | 9 |
729844 | 729844 | 2020-11-14 | Washington | Iowa | 19183 | 1074 | 12 |
729845 | 729845 | 2020-11-14 | Wayne | Iowa | 19185 | 259 | 6 |
729846 | 729846 | 2020-11-14 | Webster | Iowa | 19187 | 2874 | 25 |
729847 | 729847 | 2020-11-14 | Winnebago | Iowa | 19189 | 752 | 21 |
729848 | 729848 | 2020-11-14 | Winneshiek | Iowa | 19191 | 733 | 9 |
729849 | 729849 | 2020-11-14 | Woodbury | Iowa | 19193 | 9118 | 106 |
729850 | 729850 | 2020-11-14 | Worth | Iowa | 19195 | 259 | 0 |
729851 | 729851 | 2020-11-14 | Wright | Iowa | 19197 | 1016 | 3 |
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);