ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-08-30" 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 |
---|---|---|---|---|---|---|---|
483374 | 483374 | 2020-08-30 | Adams | Indiana | 18001 | 185 | 3 |
483375 | 483375 | 2020-08-30 | Allen | Indiana | 18003 | 4979 | 187 |
483376 | 483376 | 2020-08-30 | Bartholomew | Indiana | 18005 | 1065 | 58 |
483377 | 483377 | 2020-08-30 | Benton | Indiana | 18007 | 79 | 0 |
483378 | 483378 | 2020-08-30 | Blackford | Indiana | 18009 | 79 | 2 |
483379 | 483379 | 2020-08-30 | Boone | Indiana | 18011 | 852 | 49 |
483380 | 483380 | 2020-08-30 | Brown | Indiana | 18013 | 89 | 2 |
483381 | 483381 | 2020-08-30 | Carroll | Indiana | 18015 | 255 | 13 |
483382 | 483382 | 2020-08-30 | Cass | Indiana | 18017 | 1872 | 10 |
483383 | 483383 | 2020-08-30 | Clark | Indiana | 18019 | 1747 | 58 |
483384 | 483384 | 2020-08-30 | Clay | Indiana | 18021 | 227 | 5 |
483385 | 483385 | 2020-08-30 | Clinton | Indiana | 18023 | 547 | 11 |
483386 | 483386 | 2020-08-30 | Crawford | Indiana | 18025 | 63 | 1 |
483387 | 483387 | 2020-08-30 | Daviess | Indiana | 18027 | 482 | 25 |
483388 | 483388 | 2020-08-30 | DeKalb | Indiana | 18033 | 333 | 8 |
483389 | 483389 | 2020-08-30 | Dearborn | Indiana | 18029 | 578 | 30 |
483390 | 483390 | 2020-08-30 | Decatur | Indiana | 18031 | 423 | 38 |
483391 | 483391 | 2020-08-30 | Delaware | Indiana | 18035 | 1144 | 57 |
483392 | 483392 | 2020-08-30 | Dubois | Indiana | 18037 | 837 | 17 |
483393 | 483393 | 2020-08-30 | Elkhart | Indiana | 18039 | 5668 | 102 |
483394 | 483394 | 2020-08-30 | Fayette | Indiana | 18041 | 418 | 8 |
483395 | 483395 | 2020-08-30 | Floyd | Indiana | 18043 | 1075 | 57 |
483396 | 483396 | 2020-08-30 | Fountain | Indiana | 18045 | 94 | 2 |
483397 | 483397 | 2020-08-30 | Franklin | Indiana | 18047 | 283 | 26 |
483398 | 483398 | 2020-08-30 | Fulton | Indiana | 18049 | 207 | 2 |
483399 | 483399 | 2020-08-30 | Gibson | Indiana | 18051 | 314 | 4 |
483400 | 483400 | 2020-08-30 | Grant | Indiana | 18053 | 946 | 33 |
483401 | 483401 | 2020-08-30 | Greene | Indiana | 18055 | 371 | 38 |
483402 | 483402 | 2020-08-30 | Hamilton | Indiana | 18057 | 3883 | 116 |
483403 | 483403 | 2020-08-30 | Hancock | Indiana | 18059 | 832 | 44 |
483404 | 483404 | 2020-08-30 | Harrison | Indiana | 18061 | 480 | 26 |
483405 | 483405 | 2020-08-30 | Hendricks | Indiana | 18063 | 2332 | 128 |
483406 | 483406 | 2020-08-30 | Henry | Indiana | 18065 | 610 | 21 |
483407 | 483407 | 2020-08-30 | Howard | Indiana | 18067 | 1075 | 65 |
483408 | 483408 | 2020-08-30 | Huntington | Indiana | 18069 | 166 | 3 |
483409 | 483409 | 2020-08-30 | Jackson | Indiana | 18071 | 700 | 9 |
483410 | 483410 | 2020-08-30 | Jasper | Indiana | 18073 | 321 | 2 |
483411 | 483411 | 2020-08-30 | Jay | Indiana | 18075 | 134 | 0 |
483412 | 483412 | 2020-08-30 | Jefferson | Indiana | 18077 | 206 | 3 |
483413 | 483413 | 2020-08-30 | Jennings | Indiana | 18079 | 270 | 14 |
483414 | 483414 | 2020-08-30 | Johnson | Indiana | 18081 | 2061 | 129 |
483415 | 483415 | 2020-08-30 | Knox | Indiana | 18083 | 340 | 3 |
483416 | 483416 | 2020-08-30 | Kosciusko | Indiana | 18085 | 1043 | 18 |
483417 | 483417 | 2020-08-30 | LaGrange | Indiana | 18087 | 601 | 11 |
483418 | 483418 | 2020-08-30 | LaPorte | Indiana | 18091 | 1177 | 31 |
483419 | 483419 | 2020-08-30 | Lake | Indiana | 18089 | 9135 | 314 |
483420 | 483420 | 2020-08-30 | Lawrence | Indiana | 18093 | 453 | 29 |
483421 | 483421 | 2020-08-30 | Madison | Indiana | 18095 | 1295 | 80 |
483422 | 483422 | 2020-08-30 | Marion | Indiana | 18097 | 18500 | 799 |
483423 | 483423 | 2020-08-30 | Marshall | Indiana | 18099 | 888 | 23 |
483424 | 483424 | 2020-08-30 | Martin | Indiana | 18101 | 109 | 0 |
483425 | 483425 | 2020-08-30 | Miami | Indiana | 18103 | 320 | 2 |
483426 | 483426 | 2020-08-30 | Monroe | Indiana | 18105 | 1098 | 40 |
483427 | 483427 | 2020-08-30 | Montgomery | Indiana | 18107 | 425 | 22 |
483428 | 483428 | 2020-08-30 | Morgan | Indiana | 18109 | 600 | 38 |
483429 | 483429 | 2020-08-30 | Newton | Indiana | 18111 | 144 | 11 |
483430 | 483430 | 2020-08-30 | Noble | Indiana | 18113 | 805 | 31 |
483431 | 483431 | 2020-08-30 | Ohio | Indiana | 18115 | 73 | 7 |
483432 | 483432 | 2020-08-30 | Orange | Indiana | 18117 | 239 | 26 |
483433 | 483433 | 2020-08-30 | Owen | Indiana | 18119 | 141 | 2 |
483434 | 483434 | 2020-08-30 | Parke | Indiana | 18121 | 86 | 2 |
483435 | 483435 | 2020-08-30 | Perry | Indiana | 18123 | 207 | 14 |
483436 | 483436 | 2020-08-30 | Pike | Indiana | 18125 | 99 | 1 |
483437 | 483437 | 2020-08-30 | Porter | Indiana | 18127 | 1715 | 43 |
483438 | 483438 | 2020-08-30 | Posey | Indiana | 18129 | 212 | 0 |
483439 | 483439 | 2020-08-30 | Pulaski | Indiana | 18131 | 101 | 1 |
483440 | 483440 | 2020-08-30 | Putnam | Indiana | 18133 | 437 | 8 |
483441 | 483441 | 2020-08-30 | Randolph | Indiana | 18135 | 200 | 7 |
483442 | 483442 | 2020-08-30 | Ripley | Indiana | 18137 | 244 | 8 |
483443 | 483443 | 2020-08-30 | Rush | Indiana | 18139 | 175 | 4 |
483444 | 483444 | 2020-08-30 | Scott | Indiana | 18143 | 318 | 12 |
483445 | 483445 | 2020-08-30 | Shelby | Indiana | 18145 | 1073 | 36 |
483446 | 483446 | 2020-08-30 | Spencer | Indiana | 18147 | 161 | 3 |
483447 | 483447 | 2020-08-30 | St. Joseph | Indiana | 18141 | 5117 | 97 |
483448 | 483448 | 2020-08-30 | Starke | Indiana | 18149 | 211 | 8 |
483449 | 483449 | 2020-08-30 | Steuben | Indiana | 18151 | 271 | 4 |
483450 | 483450 | 2020-08-30 | Sullivan | Indiana | 18153 | 293 | 8 |
483451 | 483451 | 2020-08-30 | Switzerland | Indiana | 18155 | 66 | 0 |
483452 | 483452 | 2020-08-30 | Tippecanoe | Indiana | 18157 | 1573 | 14 |
483453 | 483453 | 2020-08-30 | Tipton | Indiana | 18159 | 188 | 21 |
483454 | 483454 | 2020-08-30 | Union | Indiana | 18161 | 85 | 0 |
483455 | 483455 | 2020-08-30 | Vanderburgh | Indiana | 18163 | 2563 | 19 |
483456 | 483456 | 2020-08-30 | Vermillion | Indiana | 18165 | 95 | 0 |
483457 | 483457 | 2020-08-30 | Vigo | Indiana | 18167 | 1253 | 18 |
483458 | 483458 | 2020-08-30 | Wabash | Indiana | 18169 | 210 | 5 |
483459 | 483459 | 2020-08-30 | Warren | Indiana | 18171 | 39 | 1 |
483460 | 483460 | 2020-08-30 | Warrick | Indiana | 18173 | 765 | 33 |
483461 | 483461 | 2020-08-30 | Washington | Indiana | 18175 | 218 | 1 |
483462 | 483462 | 2020-08-30 | Wayne | Indiana | 18177 | 876 | 10 |
483463 | 483463 | 2020-08-30 | Wells | Indiana | 18179 | 225 | 2 |
483464 | 483464 | 2020-08-30 | White | Indiana | 18181 | 439 | 12 |
483465 | 483465 | 2020-08-30 | Whitley | Indiana | 18183 | 211 | 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);