ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-05-27" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
182214 | 182214 | 2020-05-27 | Adams | Indiana | 18001 | 12 | 1 |
182215 | 182215 | 2020-05-27 | Allen | Indiana | 18003 | 1361 | 74 |
182216 | 182216 | 2020-05-27 | Bartholomew | Indiana | 18005 | 490 | 37 |
182217 | 182217 | 2020-05-27 | Benton | Indiana | 18007 | 25 | 0 |
182218 | 182218 | 2020-05-27 | Blackford | Indiana | 18009 | 21 | 2 |
182219 | 182219 | 2020-05-27 | Boone | Indiana | 18011 | 312 | 38 |
182220 | 182220 | 2020-05-27 | Brown | Indiana | 18013 | 33 | 1 |
182221 | 182221 | 2020-05-27 | Carroll | Indiana | 18015 | 93 | 2 |
182222 | 182222 | 2020-05-27 | Cass | Indiana | 18017 | 1588 | 8 |
182223 | 182223 | 2020-05-27 | Clark | Indiana | 18019 | 478 | 48 |
182224 | 182224 | 2020-05-27 | Clay | Indiana | 18021 | 41 | 1 |
182225 | 182225 | 2020-05-27 | Clinton | Indiana | 18023 | 223 | 2 |
182226 | 182226 | 2020-05-27 | Crawford | Indiana | 18025 | 24 | 1 |
182227 | 182227 | 2020-05-27 | Daviess | Indiana | 18027 | 86 | 18 |
182228 | 182228 | 2020-05-27 | DeKalb | Indiana | 18033 | 34 | 2 |
182229 | 182229 | 2020-05-27 | Dearborn | Indiana | 18029 | 164 | 21 |
182230 | 182230 | 2020-05-27 | Decatur | Indiana | 18031 | 235 | 34 |
182231 | 182231 | 2020-05-27 | Delaware | Indiana | 18035 | 360 | 37 |
182232 | 182232 | 2020-05-27 | Dubois | Indiana | 18037 | 185 | 2 |
182233 | 182233 | 2020-05-27 | Elkhart | Indiana | 18039 | 1076 | 30 |
182234 | 182234 | 2020-05-27 | Fayette | Indiana | 18041 | 107 | 4 |
182235 | 182235 | 2020-05-27 | Floyd | Indiana | 18043 | 317 | 41 |
182236 | 182236 | 2020-05-27 | Fountain | Indiana | 18045 | 18 | 2 |
182237 | 182237 | 2020-05-27 | Franklin | Indiana | 18047 | 112 | 9 |
182238 | 182238 | 2020-05-27 | Fulton | Indiana | 18049 | 47 | 1 |
182239 | 182239 | 2020-05-27 | Gibson | Indiana | 18051 | 14 | 2 |
182240 | 182240 | 2020-05-27 | Grant | Indiana | 18053 | 244 | 23 |
182241 | 182241 | 2020-05-27 | Greene | Indiana | 18055 | 172 | 27 |
182242 | 182242 | 2020-05-27 | Hamilton | Indiana | 18057 | 1136 | 96 |
182243 | 182243 | 2020-05-27 | Hancock | Indiana | 18059 | 327 | 28 |
182244 | 182244 | 2020-05-27 | Harrison | Indiana | 18061 | 190 | 23 |
182245 | 182245 | 2020-05-27 | Hendricks | Indiana | 18063 | 1155 | 80 |
182246 | 182246 | 2020-05-27 | Henry | Indiana | 18065 | 174 | 9 |
182247 | 182247 | 2020-05-27 | Howard | Indiana | 18067 | 380 | 22 |
182248 | 182248 | 2020-05-27 | Huntington | Indiana | 18069 | 26 | 2 |
182249 | 182249 | 2020-05-27 | Jackson | Indiana | 18071 | 372 | 2 |
182250 | 182250 | 2020-05-27 | Jasper | Indiana | 18073 | 63 | 1 |
182251 | 182251 | 2020-05-27 | Jay | Indiana | 18075 | 48 | 0 |
182252 | 182252 | 2020-05-27 | Jefferson | Indiana | 18077 | 43 | 1 |
182253 | 182253 | 2020-05-27 | Jennings | Indiana | 18079 | 130 | 6 |
182254 | 182254 | 2020-05-27 | Johnson | Indiana | 18081 | 1119 | 111 |
182255 | 182255 | 2020-05-27 | Knox | Indiana | 18083 | 26 | 0 |
182256 | 182256 | 2020-05-27 | Kosciusko | Indiana | 18085 | 99 | 2 |
182257 | 182257 | 2020-05-27 | LaGrange | Indiana | 18087 | 63 | 2 |
182258 | 182258 | 2020-05-27 | LaPorte | Indiana | 18091 | 416 | 23 |
182259 | 182259 | 2020-05-27 | Lake | Indiana | 18089 | 3378 | 182 |
182260 | 182260 | 2020-05-27 | Lawrence | Indiana | 18093 | 147 | 24 |
182261 | 182261 | 2020-05-27 | Madison | Indiana | 18095 | 591 | 68 |
182262 | 182262 | 2020-05-27 | Marion | Indiana | 18097 | 9471 | 584 |
182263 | 182263 | 2020-05-27 | Marshall | Indiana | 18099 | 80 | 1 |
182264 | 182264 | 2020-05-27 | Martin | Indiana | 18101 | 9 | 0 |
182265 | 182265 | 2020-05-27 | Miami | Indiana | 18103 | 141 | 1 |
182266 | 182266 | 2020-05-27 | Monroe | Indiana | 18105 | 162 | 11 |
182267 | 182267 | 2020-05-27 | Montgomery | Indiana | 18107 | 234 | 17 |
182268 | 182268 | 2020-05-27 | Morgan | Indiana | 18109 | 278 | 26 |
182269 | 182269 | 2020-05-27 | Newton | Indiana | 18111 | 75 | 11 |
182270 | 182270 | 2020-05-27 | Noble | Indiana | 18113 | 194 | 22 |
182271 | 182271 | 2020-05-27 | Ohio | Indiana | 18115 | 13 | 0 |
182272 | 182272 | 2020-05-27 | Orange | Indiana | 18117 | 126 | 24 |
182273 | 182273 | 2020-05-27 | Owen | Indiana | 18119 | 34 | 1 |
182274 | 182274 | 2020-05-27 | Parke | Indiana | 18121 | 22 | 0 |
182275 | 182275 | 2020-05-27 | Perry | Indiana | 18123 | 37 | 1 |
182276 | 182276 | 2020-05-27 | Pike | Indiana | 18125 | 6 | 0 |
182277 | 182277 | 2020-05-27 | Porter | Indiana | 18127 | 502 | 22 |
182278 | 182278 | 2020-05-27 | Posey | Indiana | 18129 | 16 | 0 |
182279 | 182279 | 2020-05-27 | Pulaski | Indiana | 18131 | 40 | 0 |
182280 | 182280 | 2020-05-27 | Putnam | Indiana | 18133 | 139 | 7 |
182281 | 182281 | 2020-05-27 | Randolph | Indiana | 18135 | 67 | 3 |
182282 | 182282 | 2020-05-27 | Ripley | Indiana | 18137 | 113 | 6 |
182283 | 182283 | 2020-05-27 | Rush | Indiana | 18139 | 59 | 2 |
182284 | 182284 | 2020-05-27 | Scott | Indiana | 18143 | 119 | 3 |
182285 | 182285 | 2020-05-27 | Shelby | Indiana | 18145 | 472 | 29 |
182286 | 182286 | 2020-05-27 | Spencer | Indiana | 18147 | 20 | 1 |
182287 | 182287 | 2020-05-27 | St. Joseph | Indiana | 18141 | 1227 | 39 |
182288 | 182288 | 2020-05-27 | Starke | Indiana | 18149 | 32 | 3 |
182289 | 182289 | 2020-05-27 | Steuben | Indiana | 18151 | 80 | 2 |
182290 | 182290 | 2020-05-27 | Sullivan | Indiana | 18153 | 33 | 1 |
182291 | 182291 | 2020-05-27 | Switzerland | Indiana | 18155 | 20 | 0 |
182292 | 182292 | 2020-05-27 | Tippecanoe | Indiana | 18157 | 382 | 3 |
182293 | 182293 | 2020-05-27 | Tipton | Indiana | 18159 | 25 | 2 |
182294 | 182294 | 2020-05-27 | Union | Indiana | 18161 | 21 | 0 |
182295 | 182295 | 2020-05-27 | Vanderburgh | Indiana | 18163 | 256 | 2 |
182296 | 182296 | 2020-05-27 | Vermillion | Indiana | 18165 | 11 | 0 |
182297 | 182297 | 2020-05-27 | Vigo | Indiana | 18167 | 151 | 8 |
182298 | 182298 | 2020-05-27 | Wabash | Indiana | 18169 | 73 | 2 |
182299 | 182299 | 2020-05-27 | Warren | Indiana | 18171 | 13 | 1 |
182300 | 182300 | 2020-05-27 | Warrick | Indiana | 18173 | 166 | 29 |
182301 | 182301 | 2020-05-27 | Washington | Indiana | 18175 | 52 | 1 |
182302 | 182302 | 2020-05-27 | Wayne | Indiana | 18177 | 221 | 5 |
182303 | 182303 | 2020-05-27 | Wells | Indiana | 18179 | 26 | 0 |
182304 | 182304 | 2020-05-27 | White | Indiana | 18181 | 228 | 8 |
182305 | 182305 | 2020-05-27 | Whitley | Indiana | 18183 | 41 | 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);