ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-08-27" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, 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 |
---|---|---|---|---|---|---|---|
473766 | 473766 | 2020-08-27 | Adair | Iowa | 19001 | 48 | 1 |
473767 | 473767 | 2020-08-27 | Adams | Iowa | 19003 | 20 | 0 |
473768 | 473768 | 2020-08-27 | Allamakee | Iowa | 19005 | 172 | 4 |
473769 | 473769 | 2020-08-27 | Appanoose | Iowa | 19007 | 76 | 3 |
473770 | 473770 | 2020-08-27 | Audubon | Iowa | 19009 | 37 | 1 |
473771 | 473771 | 2020-08-27 | Benton | Iowa | 19011 | 189 | 1 |
473772 | 473772 | 2020-08-27 | Black Hawk | Iowa | 19013 | 3641 | 73 |
473773 | 473773 | 2020-08-27 | Boone | Iowa | 19015 | 335 | 4 |
473774 | 473774 | 2020-08-27 | Bremer | Iowa | 19017 | 282 | 7 |
473775 | 473775 | 2020-08-27 | Buchanan | Iowa | 19019 | 170 | 1 |
473776 | 473776 | 2020-08-27 | Buena Vista | Iowa | 19021 | 1822 | 12 |
473777 | 473777 | 2020-08-27 | Butler | Iowa | 19023 | 182 | 2 |
473778 | 473778 | 2020-08-27 | Calhoun | Iowa | 19025 | 117 | 2 |
473779 | 473779 | 2020-08-27 | Carroll | Iowa | 19027 | 336 | 2 |
473780 | 473780 | 2020-08-27 | Cass | Iowa | 19029 | 112 | 2 |
473781 | 473781 | 2020-08-27 | Cedar | Iowa | 19031 | 147 | 1 |
473782 | 473782 | 2020-08-27 | Cerro Gordo | Iowa | 19033 | 786 | 20 |
473783 | 473783 | 2020-08-27 | Cherokee | Iowa | 19035 | 135 | 1 |
473784 | 473784 | 2020-08-27 | Chickasaw | Iowa | 19037 | 97 | 0 |
473785 | 473785 | 2020-08-27 | Clarke | Iowa | 19039 | 231 | 3 |
473786 | 473786 | 2020-08-27 | Clay | Iowa | 19041 | 236 | 2 |
473787 | 473787 | 2020-08-27 | Clayton | Iowa | 19043 | 175 | 3 |
473788 | 473788 | 2020-08-27 | Clinton | Iowa | 19045 | 757 | 9 |
473789 | 473789 | 2020-08-27 | Crawford | Iowa | 19047 | 812 | 3 |
473790 | 473790 | 2020-08-27 | Dallas | Iowa | 19049 | 2306 | 38 |
473791 | 473791 | 2020-08-27 | Davis | Iowa | 19051 | 80 | 2 |
473792 | 473792 | 2020-08-27 | Decatur | Iowa | 19053 | 43 | 0 |
473793 | 473793 | 2020-08-27 | Delaware | Iowa | 19055 | 189 | 3 |
473794 | 473794 | 2020-08-27 | Des Moines | Iowa | 19057 | 511 | 5 |
473795 | 473795 | 2020-08-27 | Dickinson | Iowa | 19059 | 417 | 5 |
473796 | 473796 | 2020-08-27 | Dubuque | Iowa | 19061 | 1966 | 36 |
473797 | 473797 | 2020-08-27 | Emmet | Iowa | 19063 | 217 | 7 |
473798 | 473798 | 2020-08-27 | Fayette | Iowa | 19065 | 134 | 1 |
473799 | 473799 | 2020-08-27 | Floyd | Iowa | 19067 | 209 | 3 |
473800 | 473800 | 2020-08-27 | Franklin | Iowa | 19069 | 292 | 16 |
473801 | 473801 | 2020-08-27 | Fremont | Iowa | 19071 | 55 | 0 |
473802 | 473802 | 2020-08-27 | Greene | Iowa | 19073 | 54 | 0 |
473803 | 473803 | 2020-08-27 | Grundy | Iowa | 19075 | 120 | 1 |
473804 | 473804 | 2020-08-27 | Guthrie | Iowa | 19077 | 166 | 5 |
473805 | 473805 | 2020-08-27 | Hamilton | Iowa | 19079 | 278 | 2 |
473806 | 473806 | 2020-08-27 | Hancock | Iowa | 19081 | 149 | 2 |
473807 | 473807 | 2020-08-27 | Hardin | Iowa | 19083 | 221 | 1 |
473808 | 473808 | 2020-08-27 | Harrison | Iowa | 19085 | 142 | 1 |
473809 | 473809 | 2020-08-27 | Henry | Iowa | 19087 | 235 | 4 |
473810 | 473810 | 2020-08-27 | Howard | Iowa | 19089 | 120 | 2 |
473811 | 473811 | 2020-08-27 | Humboldt | Iowa | 19091 | 151 | 2 |
473812 | 473812 | 2020-08-27 | Ida | Iowa | 19093 | 38 | 0 |
473813 | 473813 | 2020-08-27 | Iowa | Iowa | 19095 | 109 | 1 |
473814 | 473814 | 2020-08-27 | Jackson | Iowa | 19097 | 193 | 1 |
473815 | 473815 | 2020-08-27 | Jasper | Iowa | 19099 | 556 | 30 |
473816 | 473816 | 2020-08-27 | Jefferson | Iowa | 19101 | 116 | 0 |
473817 | 473817 | 2020-08-27 | Johnson | Iowa | 19103 | 3219 | 26 |
473818 | 473818 | 2020-08-27 | Jones | Iowa | 19105 | 165 | 2 |
473819 | 473819 | 2020-08-27 | Keokuk | Iowa | 19107 | 55 | 1 |
473820 | 473820 | 2020-08-27 | Kossuth | Iowa | 19109 | 117 | 0 |
473821 | 473821 | 2020-08-27 | Lee | Iowa | 19111 | 353 | 5 |
473822 | 473822 | 2020-08-27 | Linn | Iowa | 19113 | 2871 | 93 |
473823 | 473823 | 2020-08-27 | Louisa | Iowa | 19115 | 392 | 14 |
473824 | 473824 | 2020-08-27 | Lucas | Iowa | 19117 | 93 | 5 |
473825 | 473825 | 2020-08-27 | Lyon | Iowa | 19119 | 141 | 2 |
473826 | 473826 | 2020-08-27 | Madison | Iowa | 19121 | 160 | 2 |
473827 | 473827 | 2020-08-27 | Mahaska | Iowa | 19123 | 208 | 18 |
473828 | 473828 | 2020-08-27 | Marion | Iowa | 19125 | 423 | 0 |
473829 | 473829 | 2020-08-27 | Marshall | Iowa | 19127 | 1606 | 29 |
473830 | 473830 | 2020-08-27 | Mills | Iowa | 19129 | 122 | 1 |
473831 | 473831 | 2020-08-27 | Mitchell | Iowa | 19131 | 93 | 0 |
473832 | 473832 | 2020-08-27 | Monona | Iowa | 19133 | 106 | 1 |
473833 | 473833 | 2020-08-27 | Monroe | Iowa | 19135 | 96 | 8 |
473834 | 473834 | 2020-08-27 | Montgomery | Iowa | 19137 | 70 | 4 |
473835 | 473835 | 2020-08-27 | Muscatine | Iowa | 19139 | 943 | 51 |
473836 | 473836 | 2020-08-27 | O'Brien | Iowa | 19141 | 181 | 7 |
473837 | 473837 | 2020-08-27 | Osceola | Iowa | 19143 | 93 | 0 |
473838 | 473838 | 2020-08-27 | Page | Iowa | 19145 | 107 | 0 |
473839 | 473839 | 2020-08-27 | Palo Alto | Iowa | 19147 | 111 | 0 |
473840 | 473840 | 2020-08-27 | Plymouth | Iowa | 19149 | 672 | 18 |
473841 | 473841 | 2020-08-27 | Pocahontas | Iowa | 19151 | 128 | 2 |
473842 | 473842 | 2020-08-27 | Polk | Iowa | 19153 | 12792 | 222 |
473843 | 473843 | 2020-08-27 | Pottawattamie | Iowa | 19155 | 1565 | 34 |
473844 | 473844 | 2020-08-27 | Poweshiek | Iowa | 19157 | 181 | 8 |
473845 | 473845 | 2020-08-27 | Ringgold | Iowa | 19159 | 30 | 1 |
473846 | 473846 | 2020-08-27 | Sac | Iowa | 19161 | 105 | 0 |
473847 | 473847 | 2020-08-27 | Scott | Iowa | 19163 | 2110 | 19 |
473848 | 473848 | 2020-08-27 | Shelby | Iowa | 19165 | 212 | 1 |
473849 | 473849 | 2020-08-27 | Sioux | Iowa | 19167 | 852 | 3 |
473850 | 473850 | 2020-08-27 | Story | Iowa | 19169 | 2079 | 16 |
473851 | 473851 | 2020-08-27 | Tama | Iowa | 19171 | 610 | 29 |
473852 | 473852 | 2020-08-27 | Taylor | Iowa | 19173 | 108 | 1 |
473853 | 473853 | 2020-08-27 | Union | Iowa | 19175 | 93 | 3 |
473854 | 473854 | 2020-08-27 | Unknown | Iowa | 11 | 0 | |
473855 | 473855 | 2020-08-27 | Van Buren | Iowa | 19177 | 95 | 1 |
473856 | 473856 | 2020-08-27 | Wapello | Iowa | 19179 | 1053 | 48 |
473857 | 473857 | 2020-08-27 | Warren | Iowa | 19181 | 742 | 5 |
473858 | 473858 | 2020-08-27 | Washington | Iowa | 19183 | 330 | 11 |
473859 | 473859 | 2020-08-27 | Wayne | Iowa | 19185 | 45 | 2 |
473860 | 473860 | 2020-08-27 | Webster | Iowa | 19187 | 993 | 8 |
473861 | 473861 | 2020-08-27 | Winnebago | Iowa | 19189 | 154 | 7 |
473862 | 473862 | 2020-08-27 | Winneshiek | Iowa | 19191 | 198 | 1 |
473863 | 473863 | 2020-08-27 | Woodbury | Iowa | 19193 | 4028 | 56 |
473864 | 473864 | 2020-08-27 | Worth | Iowa | 19195 | 78 | 0 |
473865 | 473865 | 2020-08-27 | Wright | Iowa | 19197 | 513 | 1 |
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);