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-09-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 |
---|---|---|---|---|---|---|---|
577229 | 577229 | 2020-09-28 | Adams | Indiana | 18001 | 277 | 4 |
577230 | 577230 | 2020-09-28 | Allen | Indiana | 18003 | 6359 | 215 |
577231 | 577231 | 2020-09-28 | Bartholomew | Indiana | 18005 | 1199 | 61 |
577232 | 577232 | 2020-09-28 | Benton | Indiana | 18007 | 87 | 0 |
577233 | 577233 | 2020-09-28 | Blackford | Indiana | 18009 | 129 | 3 |
577234 | 577234 | 2020-09-28 | Boone | Indiana | 18011 | 1011 | 49 |
577235 | 577235 | 2020-09-28 | Brown | Indiana | 18013 | 104 | 3 |
577236 | 577236 | 2020-09-28 | Carroll | Indiana | 18015 | 278 | 13 |
577237 | 577237 | 2020-09-28 | Cass | Indiana | 18017 | 1958 | 10 |
577238 | 577238 | 2020-09-28 | Clark | Indiana | 18019 | 2276 | 64 |
577239 | 577239 | 2020-09-28 | Clay | Indiana | 18021 | 308 | 5 |
577240 | 577240 | 2020-09-28 | Clinton | Indiana | 18023 | 627 | 18 |
577241 | 577241 | 2020-09-28 | Crawford | Indiana | 18025 | 111 | 1 |
577242 | 577242 | 2020-09-28 | Daviess | Indiana | 18027 | 682 | 30 |
577243 | 577243 | 2020-09-28 | DeKalb | Indiana | 18033 | 490 | 12 |
577244 | 577244 | 2020-09-28 | Dearborn | Indiana | 18029 | 682 | 30 |
577245 | 577245 | 2020-09-28 | Decatur | Indiana | 18031 | 486 | 42 |
577246 | 577246 | 2020-09-28 | Delaware | Indiana | 18035 | 2006 | 63 |
577247 | 577247 | 2020-09-28 | Dubois | Indiana | 18037 | 999 | 19 |
577248 | 577248 | 2020-09-28 | Elkhart | Indiana | 18039 | 6801 | 115 |
577249 | 577249 | 2020-09-28 | Fayette | Indiana | 18041 | 537 | 13 |
577250 | 577250 | 2020-09-28 | Floyd | Indiana | 18043 | 1402 | 67 |
577251 | 577251 | 2020-09-28 | Fountain | Indiana | 18045 | 131 | 2 |
577252 | 577252 | 2020-09-28 | Franklin | Indiana | 18047 | 323 | 26 |
577253 | 577253 | 2020-09-28 | Fulton | Indiana | 18049 | 246 | 2 |
577254 | 577254 | 2020-09-28 | Gibson | Indiana | 18051 | 537 | 5 |
577255 | 577255 | 2020-09-28 | Grant | Indiana | 18053 | 1295 | 37 |
577256 | 577256 | 2020-09-28 | Greene | Indiana | 18055 | 432 | 38 |
577257 | 577257 | 2020-09-28 | Hamilton | Indiana | 18057 | 4970 | 118 |
577258 | 577258 | 2020-09-28 | Hancock | Indiana | 18059 | 961 | 46 |
577259 | 577259 | 2020-09-28 | Harrison | Indiana | 18061 | 595 | 26 |
577260 | 577260 | 2020-09-28 | Hendricks | Indiana | 18063 | 2800 | 141 |
577261 | 577261 | 2020-09-28 | Henry | Indiana | 18065 | 824 | 26 |
577262 | 577262 | 2020-09-28 | Howard | Indiana | 18067 | 1334 | 66 |
577263 | 577263 | 2020-09-28 | Huntington | Indiana | 18069 | 250 | 3 |
577264 | 577264 | 2020-09-28 | Jackson | Indiana | 18071 | 777 | 10 |
577265 | 577265 | 2020-09-28 | Jasper | Indiana | 18073 | 403 | 3 |
577266 | 577266 | 2020-09-28 | Jay | Indiana | 18075 | 198 | 0 |
577267 | 577267 | 2020-09-28 | Jefferson | Indiana | 18077 | 251 | 3 |
577268 | 577268 | 2020-09-28 | Jennings | Indiana | 18079 | 319 | 14 |
577269 | 577269 | 2020-09-28 | Johnson | Indiana | 18081 | 2391 | 133 |
577270 | 577270 | 2020-09-28 | Knox | Indiana | 18083 | 529 | 9 |
577271 | 577271 | 2020-09-28 | Kosciusko | Indiana | 18085 | 1279 | 19 |
577272 | 577272 | 2020-09-28 | LaGrange | Indiana | 18087 | 642 | 11 |
577273 | 577273 | 2020-09-28 | LaPorte | Indiana | 18091 | 1495 | 41 |
577274 | 577274 | 2020-09-28 | Lake | Indiana | 18089 | 10750 | 341 |
577275 | 577275 | 2020-09-28 | Lawrence | Indiana | 18093 | 518 | 31 |
577276 | 577276 | 2020-09-28 | Madison | Indiana | 18095 | 1719 | 86 |
577277 | 577277 | 2020-09-28 | Marion | Indiana | 18097 | 21673 | 819 |
577278 | 577278 | 2020-09-28 | Marshall | Indiana | 18099 | 1015 | 24 |
577279 | 577279 | 2020-09-28 | Martin | Indiana | 18101 | 169 | 0 |
577280 | 577280 | 2020-09-28 | Miami | Indiana | 18103 | 443 | 4 |
577281 | 577281 | 2020-09-28 | Monroe | Indiana | 18105 | 2660 | 40 |
577282 | 577282 | 2020-09-28 | Montgomery | Indiana | 18107 | 513 | 22 |
577283 | 577283 | 2020-09-28 | Morgan | Indiana | 18109 | 747 | 41 |
577284 | 577284 | 2020-09-28 | Newton | Indiana | 18111 | 175 | 12 |
577285 | 577285 | 2020-09-28 | Noble | Indiana | 18113 | 935 | 33 |
577286 | 577286 | 2020-09-28 | Ohio | Indiana | 18115 | 79 | 7 |
577287 | 577287 | 2020-09-28 | Orange | Indiana | 18117 | 290 | 26 |
577288 | 577288 | 2020-09-28 | Owen | Indiana | 18119 | 172 | 2 |
577289 | 577289 | 2020-09-28 | Parke | Indiana | 18121 | 113 | 2 |
577290 | 577290 | 2020-09-28 | Perry | Indiana | 18123 | 232 | 14 |
577291 | 577291 | 2020-09-28 | Pike | Indiana | 18125 | 164 | 1 |
577292 | 577292 | 2020-09-28 | Porter | Indiana | 18127 | 2210 | 49 |
577293 | 577293 | 2020-09-28 | Posey | Indiana | 18129 | 346 | 0 |
577294 | 577294 | 2020-09-28 | Pulaski | Indiana | 18131 | 116 | 1 |
577295 | 577295 | 2020-09-28 | Putnam | Indiana | 18133 | 589 | 11 |
577296 | 577296 | 2020-09-28 | Randolph | Indiana | 18135 | 260 | 8 |
577297 | 577297 | 2020-09-28 | Ripley | Indiana | 18137 | 308 | 8 |
577298 | 577298 | 2020-09-28 | Rush | Indiana | 18139 | 201 | 4 |
577299 | 577299 | 2020-09-28 | Scott | Indiana | 18143 | 396 | 13 |
577300 | 577300 | 2020-09-28 | Shelby | Indiana | 18145 | 1168 | 37 |
577301 | 577301 | 2020-09-28 | Spencer | Indiana | 18147 | 266 | 3 |
577302 | 577302 | 2020-09-28 | St. Joseph | Indiana | 18141 | 6637 | 119 |
577303 | 577303 | 2020-09-28 | Starke | Indiana | 18149 | 273 | 8 |
577304 | 577304 | 2020-09-28 | Steuben | Indiana | 18151 | 391 | 7 |
577305 | 577305 | 2020-09-28 | Sullivan | Indiana | 18153 | 342 | 12 |
577306 | 577306 | 2020-09-28 | Switzerland | Indiana | 18155 | 71 | 0 |
577307 | 577307 | 2020-09-28 | Tippecanoe | Indiana | 18157 | 2569 | 14 |
577308 | 577308 | 2020-09-28 | Tipton | Indiana | 18159 | 232 | 25 |
577309 | 577309 | 2020-09-28 | Union | Indiana | 18161 | 105 | 0 |
577310 | 577310 | 2020-09-28 | Vanderburgh | Indiana | 18163 | 3784 | 31 |
577311 | 577311 | 2020-09-28 | Vermillion | Indiana | 18165 | 132 | 0 |
577312 | 577312 | 2020-09-28 | Vigo | Indiana | 18167 | 1873 | 28 |
577313 | 577313 | 2020-09-28 | Wabash | Indiana | 18169 | 276 | 8 |
577314 | 577314 | 2020-09-28 | Warren | Indiana | 18171 | 42 | 1 |
577315 | 577315 | 2020-09-28 | Warrick | Indiana | 18173 | 1384 | 44 |
577316 | 577316 | 2020-09-28 | Washington | Indiana | 18175 | 270 | 1 |
577317 | 577317 | 2020-09-28 | Wayne | Indiana | 18177 | 1129 | 14 |
577318 | 577318 | 2020-09-28 | Wells | Indiana | 18179 | 284 | 4 |
577319 | 577319 | 2020-09-28 | White | Indiana | 18181 | 487 | 14 |
577320 | 577320 | 2020-09-28 | Whitley | Indiana | 18183 | 282 | 6 |
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);