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-05-28 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
185268 | 185268 | 2020-05-28 | Adams | Indiana | 18001 | 13 | 1 |
185269 | 185269 | 2020-05-28 | Allen | Indiana | 18003 | 1427 | 74 |
185270 | 185270 | 2020-05-28 | Bartholomew | Indiana | 18005 | 495 | 37 |
185271 | 185271 | 2020-05-28 | Benton | Indiana | 18007 | 26 | 0 |
185272 | 185272 | 2020-05-28 | Blackford | Indiana | 18009 | 23 | 2 |
185273 | 185273 | 2020-05-28 | Boone | Indiana | 18011 | 324 | 38 |
185274 | 185274 | 2020-05-28 | Brown | Indiana | 18013 | 33 | 1 |
185275 | 185275 | 2020-05-28 | Carroll | Indiana | 18015 | 93 | 3 |
185276 | 185276 | 2020-05-28 | Cass | Indiana | 18017 | 1591 | 8 |
185277 | 185277 | 2020-05-28 | Clark | Indiana | 18019 | 486 | 48 |
185278 | 185278 | 2020-05-28 | Clay | Indiana | 18021 | 46 | 1 |
185279 | 185279 | 2020-05-28 | Clinton | Indiana | 18023 | 223 | 2 |
185280 | 185280 | 2020-05-28 | Crawford | Indiana | 18025 | 24 | 1 |
185281 | 185281 | 2020-05-28 | Daviess | Indiana | 18027 | 86 | 18 |
185282 | 185282 | 2020-05-28 | DeKalb | Indiana | 18033 | 34 | 2 |
185283 | 185283 | 2020-05-28 | Dearborn | Indiana | 18029 | 166 | 22 |
185284 | 185284 | 2020-05-28 | Decatur | Indiana | 18031 | 236 | 34 |
185285 | 185285 | 2020-05-28 | Delaware | Indiana | 18035 | 377 | 37 |
185286 | 185286 | 2020-05-28 | Dubois | Indiana | 18037 | 190 | 3 |
185287 | 185287 | 2020-05-28 | Elkhart | Indiana | 18039 | 1107 | 30 |
185288 | 185288 | 2020-05-28 | Fayette | Indiana | 18041 | 110 | 7 |
185289 | 185289 | 2020-05-28 | Floyd | Indiana | 18043 | 319 | 41 |
185290 | 185290 | 2020-05-28 | Fountain | Indiana | 18045 | 18 | 2 |
185291 | 185291 | 2020-05-28 | Franklin | Indiana | 18047 | 115 | 9 |
185292 | 185292 | 2020-05-28 | Fulton | Indiana | 18049 | 47 | 1 |
185293 | 185293 | 2020-05-28 | Gibson | Indiana | 18051 | 14 | 2 |
185294 | 185294 | 2020-05-28 | Grant | Indiana | 18053 | 247 | 23 |
185295 | 185295 | 2020-05-28 | Greene | Indiana | 18055 | 172 | 27 |
185296 | 185296 | 2020-05-28 | Hamilton | Indiana | 18057 | 1146 | 98 |
185297 | 185297 | 2020-05-28 | Hancock | Indiana | 18059 | 331 | 28 |
185298 | 185298 | 2020-05-28 | Harrison | Indiana | 18061 | 191 | 23 |
185299 | 185299 | 2020-05-28 | Hendricks | Indiana | 18063 | 1162 | 81 |
185300 | 185300 | 2020-05-28 | Henry | Indiana | 18065 | 173 | 10 |
185301 | 185301 | 2020-05-28 | Howard | Indiana | 18067 | 382 | 26 |
185302 | 185302 | 2020-05-28 | Huntington | Indiana | 18069 | 26 | 2 |
185303 | 185303 | 2020-05-28 | Jackson | Indiana | 18071 | 376 | 2 |
185304 | 185304 | 2020-05-28 | Jasper | Indiana | 18073 | 67 | 1 |
185305 | 185305 | 2020-05-28 | Jay | Indiana | 18075 | 51 | 0 |
185306 | 185306 | 2020-05-28 | Jefferson | Indiana | 18077 | 44 | 1 |
185307 | 185307 | 2020-05-28 | Jennings | Indiana | 18079 | 131 | 6 |
185308 | 185308 | 2020-05-28 | Johnson | Indiana | 18081 | 1121 | 113 |
185309 | 185309 | 2020-05-28 | Knox | Indiana | 18083 | 26 | 0 |
185310 | 185310 | 2020-05-28 | Kosciusko | Indiana | 18085 | 103 | 2 |
185311 | 185311 | 2020-05-28 | LaGrange | Indiana | 18087 | 69 | 2 |
185312 | 185312 | 2020-05-28 | LaPorte | Indiana | 18091 | 421 | 22 |
185313 | 185313 | 2020-05-28 | Lake | Indiana | 18089 | 3525 | 187 |
185314 | 185314 | 2020-05-28 | Lawrence | Indiana | 18093 | 153 | 24 |
185315 | 185315 | 2020-05-28 | Madison | Indiana | 18095 | 593 | 68 |
185316 | 185316 | 2020-05-28 | Marion | Indiana | 18097 | 9626 | 596 |
185317 | 185317 | 2020-05-28 | Marshall | Indiana | 18099 | 80 | 1 |
185318 | 185318 | 2020-05-28 | Martin | Indiana | 18101 | 9 | 0 |
185319 | 185319 | 2020-05-28 | Miami | Indiana | 18103 | 142 | 1 |
185320 | 185320 | 2020-05-28 | Monroe | Indiana | 18105 | 165 | 12 |
185321 | 185321 | 2020-05-28 | Montgomery | Indiana | 18107 | 235 | 17 |
185322 | 185322 | 2020-05-28 | Morgan | Indiana | 18109 | 285 | 26 |
185323 | 185323 | 2020-05-28 | Newton | Indiana | 18111 | 77 | 11 |
185324 | 185324 | 2020-05-28 | Noble | Indiana | 18113 | 206 | 22 |
185325 | 185325 | 2020-05-28 | Ohio | Indiana | 18115 | 13 | 0 |
185326 | 185326 | 2020-05-28 | Orange | Indiana | 18117 | 126 | 24 |
185327 | 185327 | 2020-05-28 | Owen | Indiana | 18119 | 35 | 1 |
185328 | 185328 | 2020-05-28 | Parke | Indiana | 18121 | 23 | 0 |
185329 | 185329 | 2020-05-28 | Perry | Indiana | 18123 | 39 | 1 |
185330 | 185330 | 2020-05-28 | Pike | Indiana | 18125 | 6 | 0 |
185331 | 185331 | 2020-05-28 | Porter | Indiana | 18127 | 512 | 23 |
185332 | 185332 | 2020-05-28 | Posey | Indiana | 18129 | 16 | 0 |
185333 | 185333 | 2020-05-28 | Pulaski | Indiana | 18131 | 41 | 0 |
185334 | 185334 | 2020-05-28 | Putnam | Indiana | 18133 | 140 | 7 |
185335 | 185335 | 2020-05-28 | Randolph | Indiana | 18135 | 67 | 3 |
185336 | 185336 | 2020-05-28 | Ripley | Indiana | 18137 | 110 | 6 |
185337 | 185337 | 2020-05-28 | Rush | Indiana | 18139 | 59 | 2 |
185338 | 185338 | 2020-05-28 | Scott | Indiana | 18143 | 121 | 3 |
185339 | 185339 | 2020-05-28 | Shelby | Indiana | 18145 | 522 | 30 |
185340 | 185340 | 2020-05-28 | Spencer | Indiana | 18147 | 22 | 1 |
185341 | 185341 | 2020-05-28 | St. Joseph | Indiana | 18141 | 1230 | 39 |
185342 | 185342 | 2020-05-28 | Starke | Indiana | 18149 | 33 | 3 |
185343 | 185343 | 2020-05-28 | Steuben | Indiana | 18151 | 81 | 2 |
185344 | 185344 | 2020-05-28 | Sullivan | Indiana | 18153 | 34 | 1 |
185345 | 185345 | 2020-05-28 | Switzerland | Indiana | 18155 | 20 | 0 |
185346 | 185346 | 2020-05-28 | Tippecanoe | Indiana | 18157 | 384 | 3 |
185347 | 185347 | 2020-05-28 | Tipton | Indiana | 18159 | 25 | 2 |
185348 | 185348 | 2020-05-28 | Union | Indiana | 18161 | 21 | 0 |
185349 | 185349 | 2020-05-28 | Vanderburgh | Indiana | 18163 | 262 | 2 |
185350 | 185350 | 2020-05-28 | Vermillion | Indiana | 18165 | 11 | 0 |
185351 | 185351 | 2020-05-28 | Vigo | Indiana | 18167 | 154 | 9 |
185352 | 185352 | 2020-05-28 | Wabash | Indiana | 18169 | 74 | 2 |
185353 | 185353 | 2020-05-28 | Warren | Indiana | 18171 | 13 | 1 |
185354 | 185354 | 2020-05-28 | Warrick | Indiana | 18173 | 166 | 29 |
185355 | 185355 | 2020-05-28 | Washington | Indiana | 18175 | 51 | 1 |
185356 | 185356 | 2020-05-28 | Wayne | Indiana | 18177 | 221 | 6 |
185357 | 185357 | 2020-05-28 | Wells | Indiana | 18179 | 27 | 0 |
185358 | 185358 | 2020-05-28 | White | Indiana | 18181 | 230 | 8 |
185359 | 185359 | 2020-05-28 | Whitley | Indiana | 18183 | 38 | 3 |
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);