ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

100 rows where "date" is on date 2022-04-27 and state = "Iowa" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Iowa · 100 ✖
Link rowid date ▲ county state fips cases deaths
2448262 2448262 2022-04-27 Adair Iowa 19001 1587 50
2448263 2448263 2022-04-27 Adams Iowa 19003 819 13
2448264 2448264 2022-04-27 Allamakee Iowa 19005 2873 60
2448265 2448265 2022-04-27 Appanoose Iowa 19007 2917 68
2448266 2448266 2022-04-27 Audubon Iowa 19009 1114 19
2448267 2448267 2022-04-27 Benton Iowa 19011 6044 77
2448268 2448268 2022-04-27 Black Hawk Iowa 19013 32876 477
2448269 2448269 2022-04-27 Boone Iowa 19015 5495 54
2448270 2448270 2022-04-27 Bremer Iowa 19017 5518 82
2448271 2448271 2022-04-27 Buchanan Iowa 19019 4595 58
2448272 2448272 2022-04-27 Buena Vista Iowa 19021 6404 57
2448273 2448273 2022-04-27 Butler Iowa 19023 3231 53
2448274 2448274 2022-04-27 Calhoun Iowa 19025 2599 25
2448275 2448275 2022-04-27 Carroll Iowa 19027 4943 65
2448276 2448276 2022-04-27 Cass Iowa 19029 2960 78
2448277 2448277 2022-04-27 Cedar Iowa 19031 4161 35
2448278 2448278 2022-04-27 Cerro Gordo Iowa 19033 11123 169
2448279 2448279 2022-04-27 Cherokee Iowa 19035 2975 61
2448280 2448280 2022-04-27 Chickasaw Iowa 19037 2687 32
2448281 2448281 2022-04-27 Clarke Iowa 19039 2264 37
2448282 2448282 2022-04-27 Clay Iowa 19041 4107 44
2448283 2448283 2022-04-27 Clayton Iowa 19043 3483 72
2448284 2448284 2022-04-27 Clinton Iowa 19045 11561 146
2448285 2448285 2022-04-27 Crawford Iowa 19047 4526 54
2448286 2448286 2022-04-27 Dallas Iowa 19049 23152 144
2448287 2448287 2022-04-27 Davis Iowa 19051 1601 32
2448288 2448288 2022-04-27 Decatur Iowa 19053 1515 26
2448289 2448289 2022-04-27 Delaware Iowa 19055 4031 68
2448290 2448290 2022-04-27 Des Moines Iowa 19057 9152 138
2448291 2448291 2022-04-27 Dickinson Iowa 19059 4129 72
2448292 2448292 2022-04-27 Dubuque Iowa 19061 26053 294
2448293 2448293 2022-04-27 Emmet Iowa 19063 2355 52
2448294 2448294 2022-04-27 Fayette Iowa 19065 4097 74
2448295 2448295 2022-04-27 Floyd Iowa 19067 3560 62
2448296 2448296 2022-04-27 Franklin Iowa 19069 2514 42
2448297 2448297 2022-04-27 Fremont Iowa 19071 1387 25
2448298 2448298 2022-04-27 Greene Iowa 19073 1742 21
2448299 2448299 2022-04-27 Grundy Iowa 19075 2561 43
2448300 2448300 2022-04-27 Guthrie Iowa 19077 2353 46
2448301 2448301 2022-04-27 Hamilton Iowa 19079 3475 72
2448302 2448302 2022-04-27 Hancock Iowa 19081 2842 47
2448303 2448303 2022-04-27 Hardin Iowa 19083 4129 62
2448304 2448304 2022-04-27 Harrison Iowa 19085 3435 95
2448305 2448305 2022-04-27 Henry Iowa 19087 5567 74
2448306 2448306 2022-04-27 Howard Iowa 19089 2053 35
2448307 2448307 2022-04-27 Humboldt Iowa 19091 2622 38
2448308 2448308 2022-04-27 Ida Iowa 19093 1829 49
2448309 2448309 2022-04-27 Iowa Iowa 19095 3689 50
2448310 2448310 2022-04-27 Jackson Iowa 19097 4611 69
2448311 2448311 2022-04-27 Jasper Iowa 19099 8657 110
2448312 2448312 2022-04-27 Jefferson Iowa 19101 3510 51
2448313 2448313 2022-04-27 Johnson Iowa 19103 34672 152
2448314 2448314 2022-04-27 Jones Iowa 19105 5480 73
2448315 2448315 2022-04-27 Keokuk Iowa 19107 2080 48
2448316 2448316 2022-04-27 Kossuth Iowa 19109 3773 88
2448317 2448317 2022-04-27 Lee Iowa 19111 7863 142
2448318 2448318 2022-04-27 Linn Iowa 19113 52517 581
2448319 2448319 2022-04-27 Louisa Iowa 19115 2485 62
2448320 2448320 2022-04-27 Lucas Iowa 19117 1755 32
2448321 2448321 2022-04-27 Lyon Iowa 19119 2742 50
2448322 2448322 2022-04-27 Madison Iowa 19121 3167 40
2448323 2448323 2022-04-27 Mahaska Iowa 19123 4910 87
2448324 2448324 2022-04-27 Marion Iowa 19125 7578 125
2448325 2448325 2022-04-27 Marshall Iowa 19127 9433 111
2448326 2448326 2022-04-27 Mills Iowa 19129 3357 41
2448327 2448327 2022-04-27 Mitchell Iowa 19131 2497 49
2448328 2448328 2022-04-27 Monona Iowa 19133 1721 48
2448329 2448329 2022-04-27 Monroe Iowa 19135 1882 49
2448330 2448330 2022-04-27 Montgomery Iowa 19137 2209 55
2448331 2448331 2022-04-27 Muscatine Iowa 19139 9638 130
2448332 2448332 2022-04-27 O'Brien Iowa 19141 3451 71
2448333 2448333 2022-04-27 Osceola Iowa 19143 1395 22
2448334 2448334 2022-04-27 Page Iowa 19145 3336 45
2448335 2448335 2022-04-27 Palo Alto Iowa 19147 2040 38
2448336 2448336 2022-04-27 Plymouth Iowa 19149 6325 100
2448337 2448337 2022-04-27 Pocahontas Iowa 19151 1606 27
2448338 2448338 2022-04-27 Polk Iowa 19153 125306 1102
2448339 2448339 2022-04-27 Pottawattamie Iowa 19155 24324 316
2448340 2448340 2022-04-27 Poweshiek Iowa 19157 3663 61
2448341 2448341 2022-04-27 Ringgold Iowa 19159 1135 34
2448342 2448342 2022-04-27 Sac Iowa 19161 2409 33
2448343 2448343 2022-04-27 Scott Iowa 19163 41174 395
2448344 2448344 2022-04-27 Shelby Iowa 19165 2716 50
2448345 2448345 2022-04-27 Sioux Iowa 19167 7980 86
2448346 2448346 2022-04-27 Story Iowa 19169 19859 90
2448347 2448347 2022-04-27 Tama Iowa 19171 3906 90
2448348 2448348 2022-04-27 Taylor Iowa 19173 1314 22
2448349 2448349 2022-04-27 Union Iowa 19175 2716 51
2448350 2448350 2022-04-27 Unknown Iowa   9 0
2448351 2448351 2022-04-27 Van Buren Iowa 19177 1381 27
2448352 2448352 2022-04-27 Wapello Iowa 19179 8981 203
2448353 2448353 2022-04-27 Warren Iowa 19181 12518 134
2448354 2448354 2022-04-27 Washington Iowa 19183 5651 79
2448355 2448355 2022-04-27 Wayne Iowa 19185 1267 33
2448356 2448356 2022-04-27 Webster Iowa 19187 10348 164
2448357 2448357 2022-04-27 Winnebago Iowa 19189 2964 47
2448358 2448358 2022-04-27 Winneshiek Iowa 19191 3860 50
2448359 2448359 2022-04-27 Woodbury Iowa 19193 28815 339
2448360 2448360 2022-04-27 Worth Iowa 19195 1768 17
2448361 2448361 2022-04-27 Wright Iowa 19197 3613 63

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);