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-20 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
256389 | 256389 | 2020-06-20 | Adams | Indiana | 18001 | 37 | 2 |
256390 | 256390 | 2020-06-20 | Allen | Indiana | 18003 | 2382 | 101 |
256391 | 256391 | 2020-06-20 | Bartholomew | Indiana | 18005 | 570 | 46 |
256392 | 256392 | 2020-06-20 | Benton | Indiana | 18007 | 39 | 0 |
256393 | 256393 | 2020-06-20 | Blackford | Indiana | 18009 | 35 | 2 |
256394 | 256394 | 2020-06-20 | Boone | Indiana | 18011 | 406 | 43 |
256395 | 256395 | 2020-06-20 | Brown | Indiana | 18013 | 37 | 1 |
256396 | 256396 | 2020-06-20 | Carroll | Indiana | 18015 | 103 | 2 |
256397 | 256397 | 2020-06-20 | Cass | Indiana | 18017 | 1627 | 10 |
256398 | 256398 | 2020-06-20 | Clark | Indiana | 18019 | 599 | 50 |
256399 | 256399 | 2020-06-20 | Clay | Indiana | 18021 | 56 | 3 |
256400 | 256400 | 2020-06-20 | Clinton | Indiana | 18023 | 270 | 2 |
256401 | 256401 | 2020-06-20 | Crawford | Indiana | 18025 | 28 | 1 |
256402 | 256402 | 2020-06-20 | Daviess | Indiana | 18027 | 132 | 18 |
256403 | 256403 | 2020-06-20 | DeKalb | Indiana | 18033 | 140 | 4 |
256404 | 256404 | 2020-06-20 | Dearborn | Indiana | 18029 | 187 | 23 |
256405 | 256405 | 2020-06-20 | Decatur | Indiana | 18031 | 254 | 35 |
256406 | 256406 | 2020-06-20 | Delaware | Indiana | 18035 | 410 | 47 |
256407 | 256407 | 2020-06-20 | Dubois | Indiana | 18037 | 249 | 6 |
256408 | 256408 | 2020-06-20 | Elkhart | Indiana | 18039 | 2593 | 41 |
256409 | 256409 | 2020-06-20 | Fayette | Indiana | 18041 | 133 | 7 |
256410 | 256410 | 2020-06-20 | Floyd | Indiana | 18043 | 346 | 45 |
256411 | 256411 | 2020-06-20 | Fountain | Indiana | 18045 | 24 | 2 |
256412 | 256412 | 2020-06-20 | Franklin | Indiana | 18047 | 127 | 9 |
256413 | 256413 | 2020-06-20 | Fulton | Indiana | 18049 | 61 | 1 |
256414 | 256414 | 2020-06-20 | Gibson | Indiana | 18051 | 26 | 2 |
256415 | 256415 | 2020-06-20 | Grant | Indiana | 18053 | 352 | 28 |
256416 | 256416 | 2020-06-20 | Greene | Indiana | 18055 | 189 | 32 |
256417 | 256417 | 2020-06-20 | Hamilton | Indiana | 18057 | 1378 | 102 |
256418 | 256418 | 2020-06-20 | Hancock | Indiana | 18059 | 392 | 33 |
256419 | 256419 | 2020-06-20 | Harrison | Indiana | 18061 | 202 | 24 |
256420 | 256420 | 2020-06-20 | Hendricks | Indiana | 18063 | 1331 | 110 |
256421 | 256421 | 2020-06-20 | Henry | Indiana | 18065 | 211 | 15 |
256422 | 256422 | 2020-06-20 | Howard | Indiana | 18067 | 502 | 51 |
256423 | 256423 | 2020-06-20 | Huntington | Indiana | 18069 | 57 | 2 |
256424 | 256424 | 2020-06-20 | Jackson | Indiana | 18071 | 432 | 4 |
256425 | 256425 | 2020-06-20 | Jasper | Indiana | 18073 | 91 | 1 |
256426 | 256426 | 2020-06-20 | Jay | Indiana | 18075 | 66 | 0 |
256427 | 256427 | 2020-06-20 | Jefferson | Indiana | 18077 | 57 | 1 |
256428 | 256428 | 2020-06-20 | Jennings | Indiana | 18079 | 161 | 11 |
256429 | 256429 | 2020-06-20 | Johnson | Indiana | 18081 | 1217 | 125 |
256430 | 256430 | 2020-06-20 | Knox | Indiana | 18083 | 42 | 0 |
256431 | 256431 | 2020-06-20 | Kosciusko | Indiana | 18085 | 378 | 3 |
256432 | 256432 | 2020-06-20 | LaGrange | Indiana | 18087 | 367 | 4 |
256433 | 256433 | 2020-06-20 | LaPorte | Indiana | 18091 | 484 | 25 |
256434 | 256434 | 2020-06-20 | Lake | Indiana | 18089 | 4392 | 249 |
256435 | 256435 | 2020-06-20 | Lawrence | Indiana | 18093 | 190 | 25 |
256436 | 256436 | 2020-06-20 | Madison | Indiana | 18095 | 628 | 73 |
256437 | 256437 | 2020-06-20 | Marion | Indiana | 18097 | 11026 | 713 |
256438 | 256438 | 2020-06-20 | Marshall | Indiana | 18099 | 347 | 3 |
256439 | 256439 | 2020-06-20 | Martin | Indiana | 18101 | 20 | 0 |
256440 | 256440 | 2020-06-20 | Miami | Indiana | 18103 | 179 | 2 |
256441 | 256441 | 2020-06-20 | Monroe | Indiana | 18105 | 210 | 28 |
256442 | 256442 | 2020-06-20 | Montgomery | Indiana | 18107 | 274 | 20 |
256443 | 256443 | 2020-06-20 | Morgan | Indiana | 18109 | 313 | 32 |
256444 | 256444 | 2020-06-20 | Newton | Indiana | 18111 | 89 | 11 |
256445 | 256445 | 2020-06-20 | Noble | Indiana | 18113 | 358 | 28 |
256446 | 256446 | 2020-06-20 | Ohio | Indiana | 18115 | 13 | 0 |
256447 | 256447 | 2020-06-20 | Orange | Indiana | 18117 | 134 | 25 |
256448 | 256448 | 2020-06-20 | Owen | Indiana | 18119 | 40 | 1 |
256449 | 256449 | 2020-06-20 | Parke | Indiana | 18121 | 25 | 0 |
256450 | 256450 | 2020-06-20 | Perry | Indiana | 18123 | 114 | 4 |
256451 | 256451 | 2020-06-20 | Pike | Indiana | 18125 | 6 | 0 |
256452 | 256452 | 2020-06-20 | Porter | Indiana | 18127 | 622 | 38 |
256453 | 256453 | 2020-06-20 | Posey | Indiana | 18129 | 24 | 0 |
256454 | 256454 | 2020-06-20 | Pulaski | Indiana | 18131 | 55 | 1 |
256455 | 256455 | 2020-06-20 | Putnam | Indiana | 18133 | 163 | 8 |
256456 | 256456 | 2020-06-20 | Randolph | Indiana | 18135 | 96 | 3 |
256457 | 256457 | 2020-06-20 | Ripley | Indiana | 18137 | 111 | 7 |
256458 | 256458 | 2020-06-20 | Rush | Indiana | 18139 | 71 | 3 |
256459 | 256459 | 2020-06-20 | Scott | Indiana | 18143 | 151 | 7 |
256460 | 256460 | 2020-06-20 | Shelby | Indiana | 18145 | 617 | 32 |
256461 | 256461 | 2020-06-20 | Spencer | Indiana | 18147 | 27 | 1 |
256462 | 256462 | 2020-06-20 | St. Joseph | Indiana | 18141 | 1656 | 61 |
256463 | 256463 | 2020-06-20 | Starke | Indiana | 18149 | 60 | 4 |
256464 | 256464 | 2020-06-20 | Steuben | Indiana | 18151 | 108 | 2 |
256465 | 256465 | 2020-06-20 | Sullivan | Indiana | 18153 | 42 | 1 |
256466 | 256466 | 2020-06-20 | Switzerland | Indiana | 18155 | 24 | 0 |
256467 | 256467 | 2020-06-20 | Tippecanoe | Indiana | 18157 | 529 | 8 |
256468 | 256468 | 2020-06-20 | Tipton | Indiana | 18159 | 29 | 2 |
256469 | 256469 | 2020-06-20 | Union | Indiana | 18161 | 27 | 0 |
256470 | 256470 | 2020-06-20 | Vanderburgh | Indiana | 18163 | 344 | 6 |
256471 | 256471 | 2020-06-20 | Vermillion | Indiana | 18165 | 14 | 0 |
256472 | 256472 | 2020-06-20 | Vigo | Indiana | 18167 | 209 | 9 |
256473 | 256473 | 2020-06-20 | Wabash | Indiana | 18169 | 94 | 2 |
256474 | 256474 | 2020-06-20 | Warren | Indiana | 18171 | 15 | 1 |
256475 | 256475 | 2020-06-20 | Warrick | Indiana | 18173 | 181 | 31 |
256476 | 256476 | 2020-06-20 | Washington | Indiana | 18175 | 61 | 1 |
256477 | 256477 | 2020-06-20 | Wayne | Indiana | 18177 | 278 | 6 |
256478 | 256478 | 2020-06-20 | Wells | Indiana | 18179 | 72 | 0 |
256479 | 256479 | 2020-06-20 | White | Indiana | 18181 | 246 | 10 |
256480 | 256480 | 2020-06-20 | Whitley | Indiana | 18183 | 71 | 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);