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 2020-12-23 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
856327 | 856327 | 2020-12-23 | Adair | Iowa | 19001 | 561 | 17 |
856328 | 856328 | 2020-12-23 | Adams | Iowa | 19003 | 245 | 2 |
856329 | 856329 | 2020-12-23 | Allamakee | Iowa | 19005 | 1122 | 20 |
856330 | 856330 | 2020-12-23 | Appanoose | Iowa | 19007 | 927 | 34 |
856331 | 856331 | 2020-12-23 | Audubon | Iowa | 19009 | 363 | 7 |
856332 | 856332 | 2020-12-23 | Benton | Iowa | 19011 | 1947 | 35 |
856333 | 856333 | 2020-12-23 | Black Hawk | Iowa | 19013 | 12394 | 211 |
856334 | 856334 | 2020-12-23 | Boone | Iowa | 19015 | 1784 | 15 |
856335 | 856335 | 2020-12-23 | Bremer | Iowa | 19017 | 2208 | 40 |
856336 | 856336 | 2020-12-23 | Buchanan | Iowa | 19019 | 1393 | 16 |
856337 | 856337 | 2020-12-23 | Buena Vista | Iowa | 19021 | 3595 | 25 |
856338 | 856338 | 2020-12-23 | Butler | Iowa | 19023 | 1221 | 17 |
856339 | 856339 | 2020-12-23 | Calhoun | Iowa | 19025 | 1162 | 9 |
856340 | 856340 | 2020-12-23 | Carroll | Iowa | 19027 | 2300 | 27 |
856341 | 856341 | 2020-12-23 | Cass | Iowa | 19029 | 1005 | 38 |
856342 | 856342 | 2020-12-23 | Cedar | Iowa | 19031 | 1337 | 18 |
856343 | 856343 | 2020-12-23 | Cerro Gordo | Iowa | 19033 | 4216 | 59 |
856344 | 856344 | 2020-12-23 | Cherokee | Iowa | 19035 | 1182 | 19 |
856345 | 856345 | 2020-12-23 | Chickasaw | Iowa | 19037 | 1008 | 10 |
856346 | 856346 | 2020-12-23 | Clarke | Iowa | 19039 | 626 | 6 |
856347 | 856347 | 2020-12-23 | Clay | Iowa | 19041 | 1507 | 11 |
856348 | 856348 | 2020-12-23 | Clayton | Iowa | 19043 | 1320 | 39 |
856349 | 856349 | 2020-12-23 | Clinton | Iowa | 19045 | 4002 | 52 |
856350 | 856350 | 2020-12-23 | Crawford | Iowa | 19047 | 2049 | 20 |
856351 | 856351 | 2020-12-23 | Dallas | Iowa | 19049 | 7629 | 62 |
856352 | 856352 | 2020-12-23 | Davis | Iowa | 19051 | 609 | 18 |
856353 | 856353 | 2020-12-23 | Decatur | Iowa | 19053 | 408 | 3 |
856354 | 856354 | 2020-12-23 | Delaware | Iowa | 19055 | 1594 | 28 |
856355 | 856355 | 2020-12-23 | Des Moines | Iowa | 19057 | 3410 | 32 |
856356 | 856356 | 2020-12-23 | Dickinson | Iowa | 19059 | 1662 | 13 |
856357 | 856357 | 2020-12-23 | Dubuque | Iowa | 19061 | 10345 | 135 |
856358 | 856358 | 2020-12-23 | Emmet | Iowa | 19063 | 961 | 23 |
856359 | 856359 | 2020-12-23 | Fayette | Iowa | 19065 | 1301 | 16 |
856360 | 856360 | 2020-12-23 | Floyd | Iowa | 19067 | 1245 | 33 |
856361 | 856361 | 2020-12-23 | Franklin | Iowa | 19069 | 859 | 17 |
856362 | 856362 | 2020-12-23 | Fremont | Iowa | 19071 | 451 | 5 |
856363 | 856363 | 2020-12-23 | Greene | Iowa | 19073 | 631 | 7 |
856364 | 856364 | 2020-12-23 | Grundy | Iowa | 19075 | 1025 | 14 |
856365 | 856365 | 2020-12-23 | Guthrie | Iowa | 19077 | 914 | 22 |
856366 | 856366 | 2020-12-23 | Hamilton | Iowa | 19079 | 1427 | 21 |
856367 | 856367 | 2020-12-23 | Hancock | Iowa | 19081 | 1138 | 24 |
856368 | 856368 | 2020-12-23 | Hardin | Iowa | 19083 | 1414 | 24 |
856369 | 856369 | 2020-12-23 | Harrison | Iowa | 19085 | 1379 | 52 |
856370 | 856370 | 2020-12-23 | Henry | Iowa | 19087 | 2429 | 23 |
856371 | 856371 | 2020-12-23 | Howard | Iowa | 19089 | 672 | 15 |
856372 | 856372 | 2020-12-23 | Humboldt | Iowa | 19091 | 929 | 18 |
856373 | 856373 | 2020-12-23 | Ida | Iowa | 19093 | 679 | 21 |
856374 | 856374 | 2020-12-23 | Iowa | Iowa | 19095 | 1115 | 19 |
856375 | 856375 | 2020-12-23 | Jackson | Iowa | 19097 | 1735 | 29 |
856376 | 856376 | 2020-12-23 | Jasper | Iowa | 19099 | 2762 | 51 |
856377 | 856377 | 2020-12-23 | Jefferson | Iowa | 19101 | 952 | 20 |
856378 | 856378 | 2020-12-23 | Johnson | Iowa | 19103 | 10744 | 47 |
856379 | 856379 | 2020-12-23 | Jones | Iowa | 19105 | 2543 | 41 |
856380 | 856380 | 2020-12-23 | Keokuk | Iowa | 19107 | 761 | 22 |
856381 | 856381 | 2020-12-23 | Kossuth | Iowa | 19109 | 1465 | 26 |
856382 | 856382 | 2020-12-23 | Lee | Iowa | 19111 | 2773 | 23 |
856383 | 856383 | 2020-12-23 | Linn | Iowa | 19113 | 16216 | 234 |
856384 | 856384 | 2020-12-23 | Louisa | Iowa | 19115 | 1018 | 24 |
856385 | 856385 | 2020-12-23 | Lucas | Iowa | 19117 | 509 | 7 |
856386 | 856386 | 2020-12-23 | Lyon | Iowa | 19119 | 1215 | 23 |
856387 | 856387 | 2020-12-23 | Madison | Iowa | 19121 | 904 | 8 |
856388 | 856388 | 2020-12-23 | Mahaska | Iowa | 19123 | 1628 | 32 |
856389 | 856389 | 2020-12-23 | Marion | Iowa | 19125 | 2582 | 40 |
856390 | 856390 | 2020-12-23 | Marshall | Iowa | 19127 | 3917 | 53 |
856391 | 856391 | 2020-12-23 | Mills | Iowa | 19129 | 1249 | 13 |
856392 | 856392 | 2020-12-23 | Mitchell | Iowa | 19131 | 979 | 26 |
856393 | 856393 | 2020-12-23 | Monona | Iowa | 19133 | 537 | 15 |
856394 | 856394 | 2020-12-23 | Monroe | Iowa | 19135 | 599 | 16 |
856395 | 856395 | 2020-12-23 | Montgomery | Iowa | 19137 | 695 | 14 |
856396 | 856396 | 2020-12-23 | Muscatine | Iowa | 19139 | 3456 | 73 |
856397 | 856397 | 2020-12-23 | O'Brien | Iowa | 19141 | 1560 | 50 |
856398 | 856398 | 2020-12-23 | Osceola | Iowa | 19143 | 604 | 7 |
856399 | 856399 | 2020-12-23 | Page | Iowa | 19145 | 1329 | 13 |
856400 | 856400 | 2020-12-23 | Palo Alto | Iowa | 19147 | 786 | 7 |
856401 | 856401 | 2020-12-23 | Plymouth | Iowa | 19149 | 3285 | 49 |
856402 | 856402 | 2020-12-23 | Pocahontas | Iowa | 19151 | 678 | 8 |
856403 | 856403 | 2020-12-23 | Polk | Iowa | 19153 | 40049 | 401 |
856404 | 856404 | 2020-12-23 | Pottawattamie | Iowa | 19155 | 8010 | 87 |
856405 | 856405 | 2020-12-23 | Poweshiek | Iowa | 19157 | 1160 | 24 |
856406 | 856406 | 2020-12-23 | Ringgold | Iowa | 19159 | 348 | 7 |
856407 | 856407 | 2020-12-23 | Sac | Iowa | 19161 | 1017 | 14 |
856408 | 856408 | 2020-12-23 | Scott | Iowa | 19163 | 13660 | 142 |
856409 | 856409 | 2020-12-23 | Shelby | Iowa | 19165 | 913 | 23 |
856410 | 856410 | 2020-12-23 | Sioux | Iowa | 19167 | 4251 | 41 |
856411 | 856411 | 2020-12-23 | Story | Iowa | 19169 | 7812 | 27 |
856412 | 856412 | 2020-12-23 | Tama | Iowa | 19171 | 1715 | 55 |
856413 | 856413 | 2020-12-23 | Taylor | Iowa | 19173 | 522 | 8 |
856414 | 856414 | 2020-12-23 | Union | Iowa | 19175 | 994 | 16 |
856415 | 856415 | 2020-12-23 | Unknown | Iowa | 580 | 1 | |
856416 | 856416 | 2020-12-23 | Van Buren | Iowa | 19177 | 445 | 11 |
856417 | 856417 | 2020-12-23 | Wapello | Iowa | 19179 | 3014 | 90 |
856418 | 856418 | 2020-12-23 | Warren | Iowa | 19181 | 3589 | 30 |
856419 | 856419 | 2020-12-23 | Washington | Iowa | 19183 | 1798 | 27 |
856420 | 856420 | 2020-12-23 | Wayne | Iowa | 19185 | 357 | 21 |
856421 | 856421 | 2020-12-23 | Webster | Iowa | 19187 | 4323 | 58 |
856422 | 856422 | 2020-12-23 | Winnebago | Iowa | 19189 | 1084 | 28 |
856423 | 856423 | 2020-12-23 | Winneshiek | Iowa | 19191 | 1330 | 17 |
856424 | 856424 | 2020-12-23 | Woodbury | Iowa | 19193 | 11979 | 160 |
856425 | 856425 | 2020-12-23 | Worth | Iowa | 19195 | 491 | 2 |
856426 | 856426 | 2020-12-23 | Wright | Iowa | 19197 | 1490 | 15 |
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);