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-01-06 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 |
---|---|---|---|---|---|---|---|
901761 | 901761 | 2021-01-06 | Adair | Iowa | 19001 | 636 | 17 |
901762 | 901762 | 2021-01-06 | Adams | Iowa | 19003 | 275 | 3 |
901763 | 901763 | 2021-01-06 | Allamakee | Iowa | 19005 | 1224 | 26 |
901764 | 901764 | 2021-01-06 | Appanoose | Iowa | 19007 | 1017 | 36 |
901765 | 901765 | 2021-01-06 | Audubon | Iowa | 19009 | 395 | 8 |
901766 | 901766 | 2021-01-06 | Benton | Iowa | 19011 | 2030 | 39 |
901767 | 901767 | 2021-01-06 | Black Hawk | Iowa | 19013 | 13067 | 222 |
901768 | 901768 | 2021-01-06 | Boone | Iowa | 19015 | 2027 | 15 |
901769 | 901769 | 2021-01-06 | Bremer | Iowa | 19017 | 2312 | 46 |
901770 | 901770 | 2021-01-06 | Buchanan | Iowa | 19019 | 1496 | 17 |
901771 | 901771 | 2021-01-06 | Buena Vista | Iowa | 19021 | 3808 | 27 |
901772 | 901772 | 2021-01-06 | Butler | Iowa | 19023 | 1346 | 23 |
901773 | 901773 | 2021-01-06 | Calhoun | Iowa | 19025 | 1200 | 9 |
901774 | 901774 | 2021-01-06 | Carroll | Iowa | 19027 | 2446 | 31 |
901775 | 901775 | 2021-01-06 | Cass | Iowa | 19029 | 1082 | 40 |
901776 | 901776 | 2021-01-06 | Cedar | Iowa | 19031 | 1427 | 19 |
901777 | 901777 | 2021-01-06 | Cerro Gordo | Iowa | 19033 | 4428 | 63 |
901778 | 901778 | 2021-01-06 | Cherokee | Iowa | 19035 | 1301 | 25 |
901779 | 901779 | 2021-01-06 | Chickasaw | Iowa | 19037 | 1069 | 11 |
901780 | 901780 | 2021-01-06 | Clarke | Iowa | 19039 | 726 | 7 |
901781 | 901781 | 2021-01-06 | Clay | Iowa | 19041 | 1594 | 17 |
901782 | 901782 | 2021-01-06 | Clayton | Iowa | 19043 | 1456 | 46 |
901783 | 901783 | 2021-01-06 | Clinton | Iowa | 19045 | 4267 | 60 |
901784 | 901784 | 2021-01-06 | Crawford | Iowa | 19047 | 2199 | 22 |
901785 | 901785 | 2021-01-06 | Dallas | Iowa | 19049 | 8248 | 66 |
901786 | 901786 | 2021-01-06 | Davis | Iowa | 19051 | 663 | 20 |
901787 | 901787 | 2021-01-06 | Decatur | Iowa | 19053 | 455 | 4 |
901788 | 901788 | 2021-01-06 | Delaware | Iowa | 19055 | 1665 | 33 |
901789 | 901789 | 2021-01-06 | Des Moines | Iowa | 19057 | 3641 | 37 |
901790 | 901790 | 2021-01-06 | Dickinson | Iowa | 19059 | 1767 | 21 |
901791 | 901791 | 2021-01-06 | Dubuque | Iowa | 19061 | 10866 | 140 |
901792 | 901792 | 2021-01-06 | Emmet | Iowa | 19063 | 1050 | 28 |
901793 | 901793 | 2021-01-06 | Fayette | Iowa | 19065 | 1481 | 21 |
901794 | 901794 | 2021-01-06 | Floyd | Iowa | 19067 | 1313 | 36 |
901795 | 901795 | 2021-01-06 | Franklin | Iowa | 19069 | 947 | 17 |
901796 | 901796 | 2021-01-06 | Fremont | Iowa | 19071 | 480 | 5 |
901797 | 901797 | 2021-01-06 | Greene | Iowa | 19073 | 662 | 7 |
901798 | 901798 | 2021-01-06 | Grundy | Iowa | 19075 | 1138 | 21 |
901799 | 901799 | 2021-01-06 | Guthrie | Iowa | 19077 | 984 | 23 |
901800 | 901800 | 2021-01-06 | Hamilton | Iowa | 19079 | 1527 | 25 |
901801 | 901801 | 2021-01-06 | Hancock | Iowa | 19081 | 1222 | 24 |
901802 | 901802 | 2021-01-06 | Hardin | Iowa | 19083 | 1490 | 29 |
901803 | 901803 | 2021-01-06 | Harrison | Iowa | 19085 | 1482 | 59 |
901804 | 901804 | 2021-01-06 | Henry | Iowa | 19087 | 2534 | 29 |
901805 | 901805 | 2021-01-06 | Howard | Iowa | 19089 | 769 | 18 |
901806 | 901806 | 2021-01-06 | Humboldt | Iowa | 19091 | 1004 | 18 |
901807 | 901807 | 2021-01-06 | Ida | Iowa | 19093 | 716 | 29 |
901808 | 901808 | 2021-01-06 | Iowa | Iowa | 19095 | 1169 | 21 |
901809 | 901809 | 2021-01-06 | Jackson | Iowa | 19097 | 1820 | 30 |
901810 | 901810 | 2021-01-06 | Jasper | Iowa | 19099 | 2994 | 55 |
901811 | 901811 | 2021-01-06 | Jefferson | Iowa | 19101 | 1111 | 22 |
901812 | 901812 | 2021-01-06 | Johnson | Iowa | 19103 | 11472 | 47 |
901813 | 901813 | 2021-01-06 | Jones | Iowa | 19105 | 2641 | 48 |
901814 | 901814 | 2021-01-06 | Keokuk | Iowa | 19107 | 818 | 25 |
901815 | 901815 | 2021-01-06 | Kossuth | Iowa | 19109 | 1584 | 35 |
901816 | 901816 | 2021-01-06 | Lee | Iowa | 19111 | 2990 | 28 |
901817 | 901817 | 2021-01-06 | Linn | Iowa | 19113 | 17071 | 258 |
901818 | 901818 | 2021-01-06 | Louisa | Iowa | 19115 | 1105 | 26 |
901819 | 901819 | 2021-01-06 | Lucas | Iowa | 19117 | 616 | 8 |
901820 | 901820 | 2021-01-06 | Lyon | Iowa | 19119 | 1285 | 28 |
901821 | 901821 | 2021-01-06 | Madison | Iowa | 19121 | 1045 | 9 |
901822 | 901822 | 2021-01-06 | Mahaska | Iowa | 19123 | 1807 | 35 |
901823 | 901823 | 2021-01-06 | Marion | Iowa | 19125 | 2858 | 50 |
901824 | 901824 | 2021-01-06 | Marshall | Iowa | 19127 | 4151 | 58 |
901825 | 901825 | 2021-01-06 | Mills | Iowa | 19129 | 1320 | 15 |
901826 | 901826 | 2021-01-06 | Mitchell | Iowa | 19131 | 1087 | 31 |
901827 | 901827 | 2021-01-06 | Monona | Iowa | 19133 | 565 | 16 |
901828 | 901828 | 2021-01-06 | Monroe | Iowa | 19135 | 727 | 17 |
901829 | 901829 | 2021-01-06 | Montgomery | Iowa | 19137 | 790 | 17 |
901830 | 901830 | 2021-01-06 | Muscatine | Iowa | 19139 | 3678 | 75 |
901831 | 901831 | 2021-01-06 | O'Brien | Iowa | 19141 | 1633 | 53 |
901832 | 901832 | 2021-01-06 | Osceola | Iowa | 19143 | 624 | 8 |
901833 | 901833 | 2021-01-06 | Page | Iowa | 19145 | 1401 | 14 |
901834 | 901834 | 2021-01-06 | Palo Alto | Iowa | 19147 | 848 | 9 |
901835 | 901835 | 2021-01-06 | Plymouth | Iowa | 19149 | 3423 | 61 |
901836 | 901836 | 2021-01-06 | Pocahontas | Iowa | 19151 | 754 | 11 |
901837 | 901837 | 2021-01-06 | Polk | Iowa | 19153 | 42888 | 421 |
901838 | 901838 | 2021-01-06 | Pottawattamie | Iowa | 19155 | 8569 | 102 |
901839 | 901839 | 2021-01-06 | Poweshiek | Iowa | 19157 | 1245 | 24 |
901840 | 901840 | 2021-01-06 | Ringgold | Iowa | 19159 | 383 | 8 |
901841 | 901841 | 2021-01-06 | Sac | Iowa | 19161 | 1066 | 14 |
901842 | 901842 | 2021-01-06 | Scott | Iowa | 19163 | 14557 | 153 |
901843 | 901843 | 2021-01-06 | Shelby | Iowa | 19165 | 977 | 26 |
901844 | 901844 | 2021-01-06 | Sioux | Iowa | 19167 | 4405 | 46 |
901845 | 901845 | 2021-01-06 | Story | Iowa | 19169 | 8256 | 32 |
901846 | 901846 | 2021-01-06 | Tama | Iowa | 19171 | 1807 | 57 |
901847 | 901847 | 2021-01-06 | Taylor | Iowa | 19173 | 566 | 9 |
901848 | 901848 | 2021-01-06 | Union | Iowa | 19175 | 1048 | 19 |
901849 | 901849 | 2021-01-06 | Unknown | Iowa | 809 | 0 | |
901850 | 901850 | 2021-01-06 | Van Buren | Iowa | 19177 | 472 | 12 |
901851 | 901851 | 2021-01-06 | Wapello | Iowa | 19179 | 3221 | 93 |
901852 | 901852 | 2021-01-06 | Warren | Iowa | 19181 | 4009 | 37 |
901853 | 901853 | 2021-01-06 | Washington | Iowa | 19183 | 1995 | 29 |
901854 | 901854 | 2021-01-06 | Wayne | Iowa | 19185 | 399 | 21 |
901855 | 901855 | 2021-01-06 | Webster | Iowa | 19187 | 4548 | 66 |
901856 | 901856 | 2021-01-06 | Winnebago | Iowa | 19189 | 1128 | 28 |
901857 | 901857 | 2021-01-06 | Winneshiek | Iowa | 19191 | 1424 | 19 |
901858 | 901858 | 2021-01-06 | Woodbury | Iowa | 19193 | 12575 | 171 |
901859 | 901859 | 2021-01-06 | Worth | Iowa | 19195 | 549 | 3 |
901860 | 901860 | 2021-01-06 | Wright | Iowa | 19197 | 1561 | 21 |
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);