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-04-20 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 |
---|---|---|---|---|---|---|---|
1239375 | 1239375 | 2021-04-20 | Adair | Iowa | 19001 | 848 | 32 |
1239376 | 1239376 | 2021-04-20 | Adams | Iowa | 19003 | 331 | 4 |
1239377 | 1239377 | 2021-04-20 | Allamakee | Iowa | 19005 | 1493 | 51 |
1239378 | 1239378 | 2021-04-20 | Appanoose | Iowa | 19007 | 1267 | 47 |
1239379 | 1239379 | 2021-04-20 | Audubon | Iowa | 19009 | 495 | 9 |
1239380 | 1239380 | 2021-04-20 | Benton | Iowa | 19011 | 2508 | 55 |
1239381 | 1239381 | 2021-04-20 | Black Hawk | Iowa | 19013 | 15579 | 306 |
1239382 | 1239382 | 2021-04-20 | Boone | Iowa | 19015 | 2594 | 33 |
1239383 | 1239383 | 2021-04-20 | Bremer | Iowa | 19017 | 2798 | 60 |
1239384 | 1239384 | 2021-04-20 | Buchanan | Iowa | 19019 | 1889 | 31 |
1239385 | 1239385 | 2021-04-20 | Buena Vista | Iowa | 19021 | 4219 | 40 |
1239386 | 1239386 | 2021-04-20 | Butler | Iowa | 19023 | 1625 | 34 |
1239387 | 1239387 | 2021-04-20 | Calhoun | Iowa | 19025 | 1334 | 11 |
1239388 | 1239388 | 2021-04-20 | Carroll | Iowa | 19027 | 2798 | 52 |
1239389 | 1239389 | 2021-04-20 | Cass | Iowa | 19029 | 1349 | 54 |
1239390 | 1239390 | 2021-04-20 | Cedar | Iowa | 19031 | 1847 | 23 |
1239391 | 1239391 | 2021-04-20 | Cerro Gordo | Iowa | 19033 | 5240 | 86 |
1239392 | 1239392 | 2021-04-20 | Cherokee | Iowa | 19035 | 1575 | 38 |
1239393 | 1239393 | 2021-04-20 | Chickasaw | Iowa | 19037 | 1226 | 15 |
1239394 | 1239394 | 2021-04-20 | Clarke | Iowa | 19039 | 984 | 24 |
1239395 | 1239395 | 2021-04-20 | Clay | Iowa | 19041 | 2120 | 25 |
1239396 | 1239396 | 2021-04-20 | Clayton | Iowa | 19043 | 1672 | 55 |
1239397 | 1239397 | 2021-04-20 | Clinton | Iowa | 19045 | 5402 | 91 |
1239398 | 1239398 | 2021-04-20 | Crawford | Iowa | 19047 | 2625 | 40 |
1239399 | 1239399 | 2021-04-20 | Dallas | Iowa | 19049 | 10923 | 96 |
1239400 | 1239400 | 2021-04-20 | Davis | Iowa | 19051 | 799 | 24 |
1239401 | 1239401 | 2021-04-20 | Decatur | Iowa | 19053 | 591 | 9 |
1239402 | 1239402 | 2021-04-20 | Delaware | Iowa | 19055 | 2036 | 39 |
1239403 | 1239403 | 2021-04-20 | Des Moines | Iowa | 19057 | 4421 | 65 |
1239404 | 1239404 | 2021-04-20 | Dickinson | Iowa | 19059 | 2429 | 43 |
1239405 | 1239405 | 2021-04-20 | Dubuque | Iowa | 19061 | 13182 | 203 |
1239406 | 1239406 | 2021-04-20 | Emmet | Iowa | 19063 | 1293 | 40 |
1239407 | 1239407 | 2021-04-20 | Fayette | Iowa | 19065 | 1832 | 41 |
1239408 | 1239408 | 2021-04-20 | Floyd | Iowa | 19067 | 1558 | 42 |
1239409 | 1239409 | 2021-04-20 | Franklin | Iowa | 19069 | 1131 | 21 |
1239410 | 1239410 | 2021-04-20 | Fremont | Iowa | 19071 | 616 | 10 |
1239411 | 1239411 | 2021-04-20 | Greene | Iowa | 19073 | 767 | 10 |
1239412 | 1239412 | 2021-04-20 | Grundy | Iowa | 19075 | 1354 | 32 |
1239413 | 1239413 | 2021-04-20 | Guthrie | Iowa | 19077 | 1181 | 29 |
1239414 | 1239414 | 2021-04-20 | Hamilton | Iowa | 19079 | 1783 | 49 |
1239415 | 1239415 | 2021-04-20 | Hancock | Iowa | 19081 | 1438 | 34 |
1239416 | 1239416 | 2021-04-20 | Hardin | Iowa | 19083 | 1804 | 42 |
1239417 | 1239417 | 2021-04-20 | Harrison | Iowa | 19085 | 1766 | 73 |
1239418 | 1239418 | 2021-04-20 | Henry | Iowa | 19087 | 2865 | 37 |
1239419 | 1239419 | 2021-04-20 | Howard | Iowa | 19089 | 1029 | 22 |
1239420 | 1239420 | 2021-04-20 | Humboldt | Iowa | 19091 | 1184 | 26 |
1239421 | 1239421 | 2021-04-20 | Ida | Iowa | 19093 | 897 | 33 |
1239422 | 1239422 | 2021-04-20 | Iowa | Iowa | 19095 | 1459 | 24 |
1239423 | 1239423 | 2021-04-20 | Jackson | Iowa | 19097 | 2186 | 42 |
1239424 | 1239424 | 2021-04-20 | Jasper | Iowa | 19099 | 4078 | 70 |
1239425 | 1239425 | 2021-04-20 | Jefferson | Iowa | 19101 | 1310 | 35 |
1239426 | 1239426 | 2021-04-20 | Johnson | Iowa | 19103 | 14113 | 81 |
1239427 | 1239427 | 2021-04-20 | Jones | Iowa | 19105 | 2933 | 55 |
1239428 | 1239428 | 2021-04-20 | Keokuk | Iowa | 19107 | 948 | 31 |
1239429 | 1239429 | 2021-04-20 | Kossuth | Iowa | 19109 | 2136 | 63 |
1239430 | 1239430 | 2021-04-20 | Lee | Iowa | 19111 | 3686 | 55 |
1239431 | 1239431 | 2021-04-20 | Linn | Iowa | 19113 | 20364 | 330 |
1239432 | 1239432 | 2021-04-20 | Louisa | Iowa | 19115 | 1273 | 49 |
1239433 | 1239433 | 2021-04-20 | Lucas | Iowa | 19117 | 750 | 23 |
1239434 | 1239434 | 2021-04-20 | Lyon | Iowa | 19119 | 1551 | 41 |
1239435 | 1239435 | 2021-04-20 | Madison | Iowa | 19121 | 1546 | 19 |
1239436 | 1239436 | 2021-04-20 | Mahaska | Iowa | 19123 | 2253 | 50 |
1239437 | 1239437 | 2021-04-20 | Marion | Iowa | 19125 | 3551 | 75 |
1239438 | 1239438 | 2021-04-20 | Marshall | Iowa | 19127 | 4772 | 75 |
1239439 | 1239439 | 2021-04-20 | Mills | Iowa | 19129 | 1588 | 20 |
1239440 | 1239440 | 2021-04-20 | Mitchell | Iowa | 19131 | 1253 | 41 |
1239441 | 1239441 | 2021-04-20 | Monona | Iowa | 19133 | 814 | 30 |
1239442 | 1239442 | 2021-04-20 | Monroe | Iowa | 19135 | 941 | 28 |
1239443 | 1239443 | 2021-04-20 | Montgomery | Iowa | 19137 | 1008 | 37 |
1239444 | 1239444 | 2021-04-20 | Muscatine | Iowa | 19139 | 4623 | 97 |
1239445 | 1239445 | 2021-04-20 | O'Brien | Iowa | 19141 | 1970 | 60 |
1239446 | 1239446 | 2021-04-20 | Osceola | Iowa | 19143 | 763 | 16 |
1239447 | 1239447 | 2021-04-20 | Page | Iowa | 19145 | 1906 | 21 |
1239448 | 1239448 | 2021-04-20 | Palo Alto | Iowa | 19147 | 1111 | 22 |
1239449 | 1239449 | 2021-04-20 | Plymouth | Iowa | 19149 | 3984 | 79 |
1239450 | 1239450 | 2021-04-20 | Pocahontas | Iowa | 19151 | 838 | 21 |
1239451 | 1239451 | 2021-04-20 | Polk | Iowa | 19153 | 56151 | 607 |
1239452 | 1239452 | 2021-04-20 | Pottawattamie | Iowa | 19155 | 10784 | 162 |
1239453 | 1239453 | 2021-04-20 | Poweshiek | Iowa | 19157 | 1530 | 33 |
1239454 | 1239454 | 2021-04-20 | Ringgold | Iowa | 19159 | 536 | 24 |
1239455 | 1239455 | 2021-04-20 | Sac | Iowa | 19161 | 1278 | 19 |
1239456 | 1239456 | 2021-04-20 | Scott | Iowa | 19163 | 19192 | 235 |
1239457 | 1239457 | 2021-04-20 | Shelby | Iowa | 19165 | 1289 | 37 |
1239458 | 1239458 | 2021-04-20 | Sioux | Iowa | 19167 | 5073 | 73 |
1239459 | 1239459 | 2021-04-20 | Story | Iowa | 19169 | 10338 | 47 |
1239460 | 1239460 | 2021-04-20 | Tama | Iowa | 19171 | 2068 | 71 |
1239461 | 1239461 | 2021-04-20 | Taylor | Iowa | 19173 | 654 | 12 |
1239462 | 1239462 | 2021-04-20 | Union | Iowa | 19175 | 1241 | 32 |
1239463 | 1239463 | 2021-04-20 | Unknown | Iowa | 994 | 0 | |
1239464 | 1239464 | 2021-04-20 | Van Buren | Iowa | 19177 | 555 | 18 |
1239465 | 1239465 | 2021-04-20 | Wapello | Iowa | 19179 | 4255 | 120 |
1239466 | 1239466 | 2021-04-20 | Warren | Iowa | 19181 | 5577 | 86 |
1239467 | 1239467 | 2021-04-20 | Washington | Iowa | 19183 | 2497 | 50 |
1239468 | 1239468 | 2021-04-20 | Wayne | Iowa | 19185 | 521 | 23 |
1239469 | 1239469 | 2021-04-20 | Webster | Iowa | 19187 | 5086 | 91 |
1239470 | 1239470 | 2021-04-20 | Winnebago | Iowa | 19189 | 1365 | 31 |
1239471 | 1239471 | 2021-04-20 | Winneshiek | Iowa | 19191 | 1947 | 33 |
1239472 | 1239472 | 2021-04-20 | Woodbury | Iowa | 19193 | 14929 | 221 |
1239473 | 1239473 | 2021-04-20 | Worth | Iowa | 19195 | 712 | 8 |
1239474 | 1239474 | 2021-04-20 | Wright | Iowa | 19197 | 1805 | 35 |
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);