ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2020-06-26 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
275179 | 275179 | 2020-06-26 | Adams | Indiana | 18001 | 43 | 2 |
275180 | 275180 | 2020-06-26 | Allen | Indiana | 18003 | 2566 | 110 |
275181 | 275181 | 2020-06-26 | Bartholomew | Indiana | 18005 | 580 | 46 |
275182 | 275182 | 2020-06-26 | Benton | Indiana | 18007 | 45 | 0 |
275183 | 275183 | 2020-06-26 | Blackford | Indiana | 18009 | 38 | 2 |
275184 | 275184 | 2020-06-26 | Boone | Indiana | 18011 | 424 | 44 |
275185 | 275185 | 2020-06-26 | Brown | Indiana | 18013 | 37 | 1 |
275186 | 275186 | 2020-06-26 | Carroll | Indiana | 18015 | 109 | 2 |
275187 | 275187 | 2020-06-26 | Cass | Indiana | 18017 | 1641 | 10 |
275188 | 275188 | 2020-06-26 | Clark | Indiana | 18019 | 617 | 51 |
275189 | 275189 | 2020-06-26 | Clay | Indiana | 18021 | 56 | 4 |
275190 | 275190 | 2020-06-26 | Clinton | Indiana | 18023 | 276 | 2 |
275191 | 275191 | 2020-06-26 | Crawford | Indiana | 18025 | 28 | 1 |
275192 | 275192 | 2020-06-26 | Daviess | Indiana | 18027 | 134 | 18 |
275193 | 275193 | 2020-06-26 | DeKalb | Indiana | 18033 | 149 | 5 |
275194 | 275194 | 2020-06-26 | Dearborn | Indiana | 18029 | 196 | 23 |
275195 | 275195 | 2020-06-26 | Decatur | Indiana | 18031 | 256 | 35 |
275196 | 275196 | 2020-06-26 | Delaware | Indiana | 18035 | 416 | 48 |
275197 | 275197 | 2020-06-26 | Dubois | Indiana | 18037 | 255 | 6 |
275198 | 275198 | 2020-06-26 | Elkhart | Indiana | 18039 | 2921 | 44 |
275199 | 275199 | 2020-06-26 | Fayette | Indiana | 18041 | 140 | 7 |
275200 | 275200 | 2020-06-26 | Floyd | Indiana | 18043 | 356 | 45 |
275201 | 275201 | 2020-06-26 | Fountain | Indiana | 18045 | 25 | 2 |
275202 | 275202 | 2020-06-26 | Franklin | Indiana | 18047 | 131 | 9 |
275203 | 275203 | 2020-06-26 | Fulton | Indiana | 18049 | 64 | 1 |
275204 | 275204 | 2020-06-26 | Gibson | Indiana | 18051 | 29 | 2 |
275205 | 275205 | 2020-06-26 | Grant | Indiana | 18053 | 371 | 29 |
275206 | 275206 | 2020-06-26 | Greene | Indiana | 18055 | 190 | 32 |
275207 | 275207 | 2020-06-26 | Hamilton | Indiana | 18057 | 1431 | 102 |
275208 | 275208 | 2020-06-26 | Hancock | Indiana | 18059 | 402 | 36 |
275209 | 275209 | 2020-06-26 | Harrison | Indiana | 18061 | 205 | 24 |
275210 | 275210 | 2020-06-26 | Hendricks | Indiana | 18063 | 1372 | 113 |
275211 | 275211 | 2020-06-26 | Henry | Indiana | 18065 | 221 | 15 |
275212 | 275212 | 2020-06-26 | Howard | Indiana | 18067 | 532 | 54 |
275213 | 275213 | 2020-06-26 | Huntington | Indiana | 18069 | 65 | 2 |
275214 | 275214 | 2020-06-26 | Jackson | Indiana | 18071 | 447 | 4 |
275215 | 275215 | 2020-06-26 | Jasper | Indiana | 18073 | 102 | 2 |
275216 | 275216 | 2020-06-26 | Jay | Indiana | 18075 | 70 | 0 |
275217 | 275217 | 2020-06-26 | Jefferson | Indiana | 18077 | 59 | 1 |
275218 | 275218 | 2020-06-26 | Jennings | Indiana | 18079 | 166 | 11 |
275219 | 275219 | 2020-06-26 | Johnson | Indiana | 18081 | 1240 | 125 |
275220 | 275220 | 2020-06-26 | Knox | Indiana | 18083 | 54 | 0 |
275221 | 275221 | 2020-06-26 | Kosciusko | Indiana | 18085 | 442 | 3 |
275222 | 275222 | 2020-06-26 | LaGrange | Indiana | 18087 | 432 | 6 |
275223 | 275223 | 2020-06-26 | LaPorte | Indiana | 18091 | 512 | 25 |
275224 | 275224 | 2020-06-26 | Lake | Indiana | 18089 | 4687 | 254 |
275225 | 275225 | 2020-06-26 | Lawrence | Indiana | 18093 | 210 | 25 |
275226 | 275226 | 2020-06-26 | Madison | Indiana | 18095 | 642 | 73 |
275227 | 275227 | 2020-06-26 | Marion | Indiana | 18097 | 11226 | 723 |
275228 | 275228 | 2020-06-26 | Marshall | Indiana | 18099 | 393 | 3 |
275229 | 275229 | 2020-06-26 | Martin | Indiana | 18101 | 22 | 0 |
275230 | 275230 | 2020-06-26 | Miami | Indiana | 18103 | 179 | 2 |
275231 | 275231 | 2020-06-26 | Monroe | Indiana | 18105 | 223 | 30 |
275232 | 275232 | 2020-06-26 | Montgomery | Indiana | 18107 | 285 | 20 |
275233 | 275233 | 2020-06-26 | Morgan | Indiana | 18109 | 319 | 34 |
275234 | 275234 | 2020-06-26 | Newton | Indiana | 18111 | 91 | 11 |
275235 | 275235 | 2020-06-26 | Noble | Indiana | 18113 | 407 | 29 |
275236 | 275236 | 2020-06-26 | Ohio | Indiana | 18115 | 14 | 0 |
275237 | 275237 | 2020-06-26 | Orange | Indiana | 18117 | 135 | 25 |
275238 | 275238 | 2020-06-26 | Owen | Indiana | 18119 | 41 | 1 |
275239 | 275239 | 2020-06-26 | Parke | Indiana | 18121 | 27 | 0 |
275240 | 275240 | 2020-06-26 | Perry | Indiana | 18123 | 128 | 6 |
275241 | 275241 | 2020-06-26 | Pike | Indiana | 18125 | 6 | 0 |
275242 | 275242 | 2020-06-26 | Porter | Indiana | 18127 | 662 | 38 |
275243 | 275243 | 2020-06-26 | Posey | Indiana | 18129 | 28 | 0 |
275244 | 275244 | 2020-06-26 | Pulaski | Indiana | 18131 | 59 | 1 |
275245 | 275245 | 2020-06-26 | Putnam | Indiana | 18133 | 167 | 8 |
275246 | 275246 | 2020-06-26 | Randolph | Indiana | 18135 | 100 | 4 |
275247 | 275247 | 2020-06-26 | Ripley | Indiana | 18137 | 112 | 7 |
275248 | 275248 | 2020-06-26 | Rush | Indiana | 18139 | 77 | 3 |
275249 | 275249 | 2020-06-26 | Scott | Indiana | 18143 | 156 | 7 |
275250 | 275250 | 2020-06-26 | Shelby | Indiana | 18145 | 627 | 32 |
275251 | 275251 | 2020-06-26 | Spencer | Indiana | 18147 | 31 | 1 |
275252 | 275252 | 2020-06-26 | St. Joseph | Indiana | 18141 | 1790 | 65 |
275253 | 275253 | 2020-06-26 | Starke | Indiana | 18149 | 65 | 4 |
275254 | 275254 | 2020-06-26 | Steuben | Indiana | 18151 | 116 | 2 |
275255 | 275255 | 2020-06-26 | Sullivan | Indiana | 18153 | 47 | 1 |
275256 | 275256 | 2020-06-26 | Switzerland | Indiana | 18155 | 24 | 0 |
275257 | 275257 | 2020-06-26 | Tippecanoe | Indiana | 18157 | 582 | 9 |
275258 | 275258 | 2020-06-26 | Tipton | Indiana | 18159 | 30 | 2 |
275259 | 275259 | 2020-06-26 | Union | Indiana | 18161 | 29 | 0 |
275260 | 275260 | 2020-06-26 | Vanderburgh | Indiana | 18163 | 379 | 6 |
275261 | 275261 | 2020-06-26 | Vermillion | Indiana | 18165 | 14 | 0 |
275262 | 275262 | 2020-06-26 | Vigo | Indiana | 18167 | 217 | 9 |
275263 | 275263 | 2020-06-26 | Wabash | Indiana | 18169 | 103 | 2 |
275264 | 275264 | 2020-06-26 | Warren | Indiana | 18171 | 15 | 1 |
275265 | 275265 | 2020-06-26 | Warrick | Indiana | 18173 | 185 | 31 |
275266 | 275266 | 2020-06-26 | Washington | Indiana | 18175 | 63 | 1 |
275267 | 275267 | 2020-06-26 | Wayne | Indiana | 18177 | 297 | 6 |
275268 | 275268 | 2020-06-26 | Wells | Indiana | 18179 | 83 | 1 |
275269 | 275269 | 2020-06-26 | White | Indiana | 18181 | 256 | 10 |
275270 | 275270 | 2020-06-26 | Whitley | Indiana | 18183 | 75 | 4 |
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);