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-04-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 |
---|---|---|---|---|---|---|---|
90326 | 90326 | 2020-04-26 | Adams | Indiana | 18001 | 8 | 1 |
90327 | 90327 | 2020-04-26 | Allen | Indiana | 18003 | 444 | 32 |
90328 | 90328 | 2020-04-26 | Bartholomew | Indiana | 18005 | 209 | 13 |
90329 | 90329 | 2020-04-26 | Benton | Indiana | 18007 | 6 | 0 |
90330 | 90330 | 2020-04-26 | Blackford | Indiana | 18009 | 7 | 1 |
90331 | 90331 | 2020-04-26 | Boone | Indiana | 18011 | 186 | 23 |
90332 | 90332 | 2020-04-26 | Brown | Indiana | 18013 | 15 | 1 |
90333 | 90333 | 2020-04-26 | Carroll | Indiana | 18015 | 13 | 1 |
90334 | 90334 | 2020-04-26 | Cass | Indiana | 18017 | 587 | 2 |
90335 | 90335 | 2020-04-26 | Clark | Indiana | 18019 | 229 | 15 |
90336 | 90336 | 2020-04-26 | Clay | Indiana | 18021 | 19 | 1 |
90337 | 90337 | 2020-04-26 | Clinton | Indiana | 18023 | 32 | 2 |
90338 | 90338 | 2020-04-26 | Crawford | Indiana | 18025 | 17 | 1 |
90339 | 90339 | 2020-04-26 | Daviess | Indiana | 18027 | 45 | 11 |
90340 | 90340 | 2020-04-26 | DeKalb | Indiana | 18033 | 16 | 2 |
90341 | 90341 | 2020-04-26 | Dearborn | Indiana | 18029 | 84 | 5 |
90342 | 90342 | 2020-04-26 | Decatur | Indiana | 18031 | 198 | 30 |
90343 | 90343 | 2020-04-26 | Delaware | Indiana | 18035 | 146 | 11 |
90344 | 90344 | 2020-04-26 | Dubois | Indiana | 18037 | 17 | 0 |
90345 | 90345 | 2020-04-26 | Elkhart | Indiana | 18039 | 245 | 4 |
90346 | 90346 | 2020-04-26 | Fayette | Indiana | 18041 | 30 | 4 |
90347 | 90347 | 2020-04-26 | Floyd | Indiana | 18043 | 165 | 13 |
90348 | 90348 | 2020-04-26 | Fountain | Indiana | 18045 | 9 | 2 |
90349 | 90349 | 2020-04-26 | Franklin | Indiana | 18047 | 95 | 8 |
90350 | 90350 | 2020-04-26 | Fulton | Indiana | 18049 | 13 | 0 |
90351 | 90351 | 2020-04-26 | Gibson | Indiana | 18051 | 6 | 0 |
90352 | 90352 | 2020-04-26 | Grant | Indiana | 18053 | 122 | 8 |
90353 | 90353 | 2020-04-26 | Greene | Indiana | 18055 | 49 | 7 |
90354 | 90354 | 2020-04-26 | Hamilton | Indiana | 18057 | 709 | 53 |
90355 | 90355 | 2020-04-26 | Hancock | Indiana | 18059 | 179 | 8 |
90356 | 90356 | 2020-04-26 | Harrison | Indiana | 18061 | 119 | 6 |
90357 | 90357 | 2020-04-26 | Hendricks | Indiana | 18063 | 656 | 38 |
90358 | 90358 | 2020-04-26 | Henry | Indiana | 18065 | 34 | 1 |
90359 | 90359 | 2020-04-26 | Howard | Indiana | 18067 | 118 | 6 |
90360 | 90360 | 2020-04-26 | Huntington | Indiana | 18069 | 7 | 2 |
90361 | 90361 | 2020-04-26 | Jackson | Indiana | 18071 | 115 | 0 |
90362 | 90362 | 2020-04-26 | Jasper | Indiana | 18073 | 29 | 1 |
90363 | 90363 | 2020-04-26 | Jay | Indiana | 18075 | 12 | 0 |
90364 | 90364 | 2020-04-26 | Jefferson | Indiana | 18077 | 23 | 0 |
90365 | 90365 | 2020-04-26 | Jennings | Indiana | 18079 | 74 | 3 |
90366 | 90366 | 2020-04-26 | Johnson | Indiana | 18081 | 538 | 56 |
90367 | 90367 | 2020-04-26 | Knox | Indiana | 18083 | 20 | 0 |
90368 | 90368 | 2020-04-26 | Kosciusko | Indiana | 18085 | 30 | 2 |
90369 | 90369 | 2020-04-26 | LaGrange | Indiana | 18087 | 22 | 1 |
90370 | 90370 | 2020-04-26 | LaPorte | Indiana | 18091 | 188 | 5 |
90371 | 90371 | 2020-04-26 | Lake | Indiana | 18089 | 1546 | 78 |
90372 | 90372 | 2020-04-26 | Lawrence | Indiana | 18093 | 93 | 12 |
90373 | 90373 | 2020-04-26 | Madison | Indiana | 18095 | 403 | 54 |
90374 | 90374 | 2020-04-26 | Marion | Indiana | 18097 | 4832 | 287 |
90375 | 90375 | 2020-04-26 | Marshall | Indiana | 18099 | 27 | 1 |
90376 | 90376 | 2020-04-26 | Martin | Indiana | 18101 | 7 | 0 |
90377 | 90377 | 2020-04-26 | Miami | Indiana | 18103 | 66 | 0 |
90378 | 90378 | 2020-04-26 | Monroe | Indiana | 18105 | 120 | 7 |
90379 | 90379 | 2020-04-26 | Montgomery | Indiana | 18107 | 33 | 0 |
90380 | 90380 | 2020-04-26 | Morgan | Indiana | 18109 | 132 | 5 |
90381 | 90381 | 2020-04-26 | Newton | Indiana | 18111 | 47 | 6 |
90382 | 90382 | 2020-04-26 | Noble | Indiana | 18113 | 55 | 8 |
90383 | 90383 | 2020-04-26 | Ohio | Indiana | 18115 | 3 | 0 |
90384 | 90384 | 2020-04-26 | Orange | Indiana | 18117 | 60 | 6 |
90385 | 90385 | 2020-04-26 | Owen | Indiana | 18119 | 22 | 1 |
90386 | 90386 | 2020-04-26 | Parke | Indiana | 18121 | 12 | 0 |
90387 | 90387 | 2020-04-26 | Perry | Indiana | 18123 | 11 | 0 |
90388 | 90388 | 2020-04-26 | Pike | Indiana | 18125 | 1 | 0 |
90389 | 90389 | 2020-04-26 | Porter | Indiana | 18127 | 216 | 6 |
90390 | 90390 | 2020-04-26 | Posey | Indiana | 18129 | 9 | 0 |
90391 | 90391 | 2020-04-26 | Pulaski | Indiana | 18131 | 13 | 0 |
90392 | 90392 | 2020-04-26 | Putnam | Indiana | 18133 | 59 | 4 |
90393 | 90393 | 2020-04-26 | Randolph | Indiana | 18135 | 15 | 2 |
90394 | 90394 | 2020-04-26 | Ripley | Indiana | 18137 | 89 | 5 |
90395 | 90395 | 2020-04-26 | Rush | Indiana | 18139 | 30 | 1 |
90396 | 90396 | 2020-04-26 | Scott | Indiana | 18143 | 37 | 2 |
90397 | 90397 | 2020-04-26 | Shelby | Indiana | 18145 | 188 | 13 |
90398 | 90398 | 2020-04-26 | Spencer | Indiana | 18147 | 8 | 0 |
90399 | 90399 | 2020-04-26 | St. Joseph | Indiana | 18141 | 582 | 19 |
90400 | 90400 | 2020-04-26 | Starke | Indiana | 18149 | 16 | 1 |
90401 | 90401 | 2020-04-26 | Steuben | Indiana | 18151 | 21 | 1 |
90402 | 90402 | 2020-04-26 | Sullivan | Indiana | 18153 | 13 | 0 |
90403 | 90403 | 2020-04-26 | Switzerland | Indiana | 18155 | 15 | 0 |
90404 | 90404 | 2020-04-26 | Tippecanoe | Indiana | 18157 | 75 | 2 |
90405 | 90405 | 2020-04-26 | Tipton | Indiana | 18159 | 17 | 1 |
90406 | 90406 | 2020-04-26 | Union | Indiana | 18161 | 6 | 0 |
90407 | 90407 | 2020-04-26 | Vanderburgh | Indiana | 18163 | 117 | 1 |
90408 | 90408 | 2020-04-26 | Vermillion | Indiana | 18165 | 7 | 0 |
90409 | 90409 | 2020-04-26 | Vigo | Indiana | 18167 | 63 | 6 |
90410 | 90410 | 2020-04-26 | Wabash | Indiana | 18169 | 19 | 1 |
90411 | 90411 | 2020-04-26 | Warren | Indiana | 18171 | 11 | 1 |
90412 | 90412 | 2020-04-26 | Warrick | Indiana | 18173 | 83 | 13 |
90413 | 90413 | 2020-04-26 | Washington | Indiana | 18175 | 40 | 0 |
90414 | 90414 | 2020-04-26 | Wayne | Indiana | 18177 | 36 | 3 |
90415 | 90415 | 2020-04-26 | Wells | Indiana | 18179 | 5 | 0 |
90416 | 90416 | 2020-04-26 | White | Indiana | 18181 | 26 | 0 |
90417 | 90417 | 2020-04-26 | Whitley | Indiana | 18183 | 16 | 1 |
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);