ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-11-10" 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 |
---|---|---|---|---|---|---|---|
716780 | 716780 | 2020-11-10 | Adair | Iowa | 19001 | 294 | 3 |
716781 | 716781 | 2020-11-10 | Adams | Iowa | 19003 | 106 | 1 |
716782 | 716782 | 2020-11-10 | Allamakee | Iowa | 19005 | 544 | 9 |
716783 | 716783 | 2020-11-10 | Appanoose | Iowa | 19007 | 466 | 3 |
716784 | 716784 | 2020-11-10 | Audubon | Iowa | 19009 | 234 | 1 |
716785 | 716785 | 2020-11-10 | Benton | Iowa | 19011 | 1122 | 7 |
716786 | 716786 | 2020-11-10 | Black Hawk | Iowa | 19013 | 8103 | 110 |
716787 | 716787 | 2020-11-10 | Boone | Iowa | 19015 | 966 | 10 |
716788 | 716788 | 2020-11-10 | Bremer | Iowa | 19017 | 1225 | 12 |
716789 | 716789 | 2020-11-10 | Buchanan | Iowa | 19019 | 755 | 6 |
716790 | 716790 | 2020-11-10 | Buena Vista | Iowa | 19021 | 2564 | 13 |
716791 | 716791 | 2020-11-10 | Butler | Iowa | 19023 | 640 | 3 |
716792 | 716792 | 2020-11-10 | Calhoun | Iowa | 19025 | 731 | 6 |
716793 | 716793 | 2020-11-10 | Carroll | Iowa | 19027 | 1542 | 14 |
716794 | 716794 | 2020-11-10 | Cass | Iowa | 19029 | 593 | 11 |
716795 | 716795 | 2020-11-10 | Cedar | Iowa | 19031 | 730 | 10 |
716796 | 716796 | 2020-11-10 | Cerro Gordo | Iowa | 19033 | 2192 | 31 |
716797 | 716797 | 2020-11-10 | Cherokee | Iowa | 19035 | 565 | 3 |
716798 | 716798 | 2020-11-10 | Chickasaw | Iowa | 19037 | 524 | 1 |
716799 | 716799 | 2020-11-10 | Clarke | Iowa | 19039 | 406 | 4 |
716800 | 716800 | 2020-11-10 | Clay | Iowa | 19041 | 766 | 4 |
716801 | 716801 | 2020-11-10 | Clayton | Iowa | 19043 | 727 | 4 |
716802 | 716802 | 2020-11-10 | Clinton | Iowa | 19045 | 2181 | 33 |
716803 | 716803 | 2020-11-10 | Crawford | Iowa | 19047 | 1527 | 15 |
716804 | 716804 | 2020-11-10 | Dallas | Iowa | 19049 | 4678 | 53 |
716805 | 716805 | 2020-11-10 | Davis | Iowa | 19051 | 277 | 4 |
716806 | 716806 | 2020-11-10 | Decatur | Iowa | 19053 | 233 | 0 |
716807 | 716807 | 2020-11-10 | Delaware | Iowa | 19055 | 1082 | 18 |
716808 | 716808 | 2020-11-10 | Des Moines | Iowa | 19057 | 2018 | 13 |
716809 | 716809 | 2020-11-10 | Dickinson | Iowa | 19059 | 983 | 9 |
716810 | 716810 | 2020-11-10 | Dubuque | Iowa | 19061 | 7135 | 74 |
716811 | 716811 | 2020-11-10 | Emmet | Iowa | 19063 | 538 | 21 |
716812 | 716812 | 2020-11-10 | Fayette | Iowa | 19065 | 672 | 6 |
716813 | 716813 | 2020-11-10 | Floyd | Iowa | 19067 | 629 | 12 |
716814 | 716814 | 2020-11-10 | Franklin | Iowa | 19069 | 498 | 19 |
716815 | 716815 | 2020-11-10 | Fremont | Iowa | 19071 | 263 | 2 |
716816 | 716816 | 2020-11-10 | Greene | Iowa | 19073 | 314 | 0 |
716817 | 716817 | 2020-11-10 | Grundy | Iowa | 19075 | 531 | 6 |
716818 | 716818 | 2020-11-10 | Guthrie | Iowa | 19077 | 539 | 15 |
716819 | 716819 | 2020-11-10 | Hamilton | Iowa | 19079 | 631 | 6 |
716820 | 716820 | 2020-11-10 | Hancock | Iowa | 19081 | 571 | 6 |
716821 | 716821 | 2020-11-10 | Hardin | Iowa | 19083 | 745 | 8 |
716822 | 716822 | 2020-11-10 | Harrison | Iowa | 19085 | 841 | 21 |
716823 | 716823 | 2020-11-10 | Henry | Iowa | 19087 | 1365 | 7 |
716824 | 716824 | 2020-11-10 | Howard | Iowa | 19089 | 340 | 9 |
716825 | 716825 | 2020-11-10 | Humboldt | Iowa | 19091 | 518 | 3 |
716826 | 716826 | 2020-11-10 | Ida | Iowa | 19093 | 337 | 4 |
716827 | 716827 | 2020-11-10 | Iowa | Iowa | 19095 | 654 | 11 |
716828 | 716828 | 2020-11-10 | Jackson | Iowa | 19097 | 1070 | 5 |
716829 | 716829 | 2020-11-10 | Jasper | Iowa | 19099 | 1633 | 34 |
716830 | 716830 | 2020-11-10 | Jefferson | Iowa | 19101 | 392 | 1 |
716831 | 716831 | 2020-11-10 | Johnson | Iowa | 19103 | 7505 | 34 |
716832 | 716832 | 2020-11-10 | Jones | Iowa | 19105 | 1512 | 6 |
716833 | 716833 | 2020-11-10 | Keokuk | Iowa | 19107 | 353 | 2 |
716834 | 716834 | 2020-11-10 | Kossuth | Iowa | 19109 | 663 | 1 |
716835 | 716835 | 2020-11-10 | Lee | Iowa | 19111 | 1387 | 14 |
716836 | 716836 | 2020-11-10 | Linn | Iowa | 19113 | 9878 | 142 |
716837 | 716837 | 2020-11-10 | Louisa | Iowa | 19115 | 664 | 15 |
716838 | 716838 | 2020-11-10 | Lucas | Iowa | 19117 | 270 | 6 |
716839 | 716839 | 2020-11-10 | Lyon | Iowa | 19119 | 697 | 8 |
716840 | 716840 | 2020-11-10 | Madison | Iowa | 19121 | 486 | 4 |
716841 | 716841 | 2020-11-10 | Mahaska | Iowa | 19123 | 975 | 26 |
716842 | 716842 | 2020-11-10 | Marion | Iowa | 19125 | 1451 | 14 |
716843 | 716843 | 2020-11-10 | Marshall | Iowa | 19127 | 2714 | 38 |
716844 | 716844 | 2020-11-10 | Mills | Iowa | 19129 | 658 | 4 |
716845 | 716845 | 2020-11-10 | Mitchell | Iowa | 19131 | 467 | 2 |
716846 | 716846 | 2020-11-10 | Monona | Iowa | 19133 | 306 | 2 |
716847 | 716847 | 2020-11-10 | Monroe | Iowa | 19135 | 334 | 12 |
716848 | 716848 | 2020-11-10 | Montgomery | Iowa | 19137 | 288 | 8 |
716849 | 716849 | 2020-11-10 | Muscatine | Iowa | 19139 | 2019 | 61 |
716850 | 716850 | 2020-11-10 | O'Brien | Iowa | 19141 | 1004 | 20 |
716851 | 716851 | 2020-11-10 | Osceola | Iowa | 19143 | 375 | 0 |
716852 | 716852 | 2020-11-10 | Page | Iowa | 19145 | 733 | 1 |
716853 | 716853 | 2020-11-10 | Palo Alto | Iowa | 19147 | 434 | 3 |
716854 | 716854 | 2020-11-10 | Plymouth | Iowa | 19149 | 2147 | 34 |
716855 | 716855 | 2020-11-10 | Pocahontas | Iowa | 19151 | 387 | 2 |
716856 | 716856 | 2020-11-10 | Polk | Iowa | 19153 | 24717 | 300 |
716857 | 716857 | 2020-11-10 | Pottawattamie | Iowa | 19155 | 4206 | 51 |
716858 | 716858 | 2020-11-10 | Poweshiek | Iowa | 19157 | 710 | 11 |
716859 | 716859 | 2020-11-10 | Ringgold | Iowa | 19159 | 128 | 2 |
716860 | 716860 | 2020-11-10 | Sac | Iowa | 19161 | 589 | 5 |
716861 | 716861 | 2020-11-10 | Scott | Iowa | 19163 | 7066 | 54 |
716862 | 716862 | 2020-11-10 | Shelby | Iowa | 19165 | 561 | 2 |
716863 | 716863 | 2020-11-10 | Sioux | Iowa | 19167 | 2983 | 21 |
716864 | 716864 | 2020-11-10 | Story | Iowa | 19169 | 5065 | 18 |
716865 | 716865 | 2020-11-10 | Tama | Iowa | 19171 | 1227 | 38 |
716866 | 716866 | 2020-11-10 | Taylor | Iowa | 19173 | 334 | 2 |
716867 | 716867 | 2020-11-10 | Union | Iowa | 19175 | 399 | 6 |
716868 | 716868 | 2020-11-10 | Unknown | Iowa | 282 | 0 | |
716869 | 716869 | 2020-11-10 | Van Buren | Iowa | 19177 | 258 | 2 |
716870 | 716870 | 2020-11-10 | Wapello | Iowa | 19179 | 1940 | 65 |
716871 | 716871 | 2020-11-10 | Warren | Iowa | 19181 | 1833 | 9 |
716872 | 716872 | 2020-11-10 | Washington | Iowa | 19183 | 948 | 12 |
716873 | 716873 | 2020-11-10 | Wayne | Iowa | 19185 | 233 | 5 |
716874 | 716874 | 2020-11-10 | Webster | Iowa | 19187 | 2577 | 18 |
716875 | 716875 | 2020-11-10 | Winnebago | Iowa | 19189 | 653 | 21 |
716876 | 716876 | 2020-11-10 | Winneshiek | Iowa | 19191 | 658 | 9 |
716877 | 716877 | 2020-11-10 | Woodbury | Iowa | 19193 | 8607 | 105 |
716878 | 716878 | 2020-11-10 | Worth | Iowa | 19195 | 217 | 0 |
716879 | 716879 | 2020-11-10 | Wright | Iowa | 19197 | 939 | 2 |
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);