ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2022-04-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 |
---|---|---|---|---|---|---|---|
2451425 | 2451425 | 2022-04-28 | Adams | Indiana | 18001 | 7273 | 112 |
2451426 | 2451426 | 2022-04-28 | Allen | Indiana | 18003 | 104131 | 1186 |
2451427 | 2451427 | 2022-04-28 | Bartholomew | Indiana | 18005 | 21392 | 249 |
2451428 | 2451428 | 2022-04-28 | Benton | Indiana | 18007 | 2485 | 21 |
2451429 | 2451429 | 2022-04-28 | Blackford | Indiana | 18009 | 3113 | 69 |
2451430 | 2451430 | 2022-04-28 | Boone | Indiana | 18011 | 15319 | 184 |
2451431 | 2451431 | 2022-04-28 | Brown | Indiana | 18013 | 2591 | 62 |
2451432 | 2451432 | 2022-04-28 | Carroll | Indiana | 18015 | 4241 | 68 |
2451433 | 2451433 | 2022-04-28 | Cass | Indiana | 18017 | 11685 | 163 |
2451434 | 2451434 | 2022-04-28 | Clark | Indiana | 18019 | 31236 | 396 |
2451435 | 2451435 | 2022-04-28 | Clay | Indiana | 18021 | 6835 | 88 |
2451436 | 2451436 | 2022-04-28 | Clinton | Indiana | 18023 | 9212 | 126 |
2451437 | 2451437 | 2022-04-28 | Crawford | Indiana | 18025 | 2552 | 40 |
2451438 | 2451438 | 2022-04-28 | Daviess | Indiana | 18027 | 7480 | 154 |
2451439 | 2451439 | 2022-04-28 | DeKalb | Indiana | 18033 | 11371 | 151 |
2451440 | 2451440 | 2022-04-28 | Dearborn | Indiana | 18029 | 13484 | 140 |
2451441 | 2451441 | 2022-04-28 | Decatur | Indiana | 18031 | 7010 | 145 |
2451442 | 2451442 | 2022-04-28 | Delaware | Indiana | 18035 | 24893 | 443 |
2451443 | 2451443 | 2022-04-28 | Dubois | Indiana | 18037 | 12872 | 165 |
2451444 | 2451444 | 2022-04-28 | Elkhart | Indiana | 18039 | 54178 | 732 |
2451445 | 2451445 | 2022-04-28 | Fayette | Indiana | 18041 | 6745 | 146 |
2451446 | 2451446 | 2022-04-28 | Floyd | Indiana | 18043 | 19027 | 301 |
2451447 | 2451447 | 2022-04-28 | Fountain | Indiana | 18045 | 5448 | 102 |
2451448 | 2451448 | 2022-04-28 | Franklin | Indiana | 18047 | 4375 | 65 |
2451449 | 2451449 | 2022-04-28 | Fulton | Indiana | 18049 | 4927 | 103 |
2451450 | 2451450 | 2022-04-28 | Gibson | Indiana | 18051 | 11667 | 146 |
2451451 | 2451451 | 2022-04-28 | Grant | Indiana | 18053 | 17341 | 351 |
2451452 | 2451452 | 2022-04-28 | Greene | Indiana | 18055 | 7225 | 139 |
2451453 | 2451453 | 2022-04-28 | Hamilton | Indiana | 18057 | 82373 | 661 |
2451454 | 2451454 | 2022-04-28 | Hancock | Indiana | 18059 | 20717 | 258 |
2451455 | 2451455 | 2022-04-28 | Harrison | Indiana | 18061 | 10835 | 138 |
2451456 | 2451456 | 2022-04-28 | Hendricks | Indiana | 18063 | 40834 | 554 |
2451457 | 2451457 | 2022-04-28 | Henry | Indiana | 18065 | 13003 | 231 |
2451458 | 2451458 | 2022-04-28 | Howard | Indiana | 18067 | 25449 | 448 |
2451459 | 2451459 | 2022-04-28 | Huntington | Indiana | 18069 | 11516 | 157 |
2451460 | 2451460 | 2022-04-28 | Jackson | Indiana | 18071 | 12540 | 130 |
2451461 | 2451461 | 2022-04-28 | Jasper | Indiana | 18073 | 9068 | 149 |
2451462 | 2451462 | 2022-04-28 | Jay | Indiana | 18075 | 4853 | 78 |
2451463 | 2451463 | 2022-04-28 | Jefferson | Indiana | 18077 | 9347 | 157 |
2451464 | 2451464 | 2022-04-28 | Jennings | Indiana | 18079 | 6944 | 108 |
2451465 | 2451465 | 2022-04-28 | Johnson | Indiana | 18081 | 42505 | 613 |
2451466 | 2451466 | 2022-04-28 | Knox | Indiana | 18083 | 10756 | 153 |
2451467 | 2451467 | 2022-04-28 | Kosciusko | Indiana | 18085 | 19774 | 237 |
2451468 | 2451468 | 2022-04-28 | LaGrange | Indiana | 18087 | 5848 | 102 |
2451469 | 2451469 | 2022-04-28 | LaPorte | Indiana | 18091 | 25612 | 368 |
2451470 | 2451470 | 2022-04-28 | Lake | Indiana | 18089 | 107101 | 1824 |
2451471 | 2451471 | 2022-04-28 | Lawrence | Indiana | 18093 | 11922 | 259 |
2451472 | 2451472 | 2022-04-28 | Madison | Indiana | 18095 | 32749 | 652 |
2451473 | 2451473 | 2022-04-28 | Marion | Indiana | 18097 | 225983 | 2991 |
2451474 | 2451474 | 2022-04-28 | Marshall | Indiana | 18099 | 12386 | 197 |
2451475 | 2451475 | 2022-04-28 | Martin | Indiana | 18101 | 2165 | 25 |
2451476 | 2451476 | 2022-04-28 | Miami | Indiana | 18103 | 9268 | 159 |
2451477 | 2451477 | 2022-04-28 | Monroe | Indiana | 18105 | 28217 | 280 |
2451478 | 2451478 | 2022-04-28 | Montgomery | Indiana | 18107 | 10686 | 164 |
2451479 | 2451479 | 2022-04-28 | Morgan | Indiana | 18109 | 16501 | 286 |
2451480 | 2451480 | 2022-04-28 | Newton | Indiana | 18111 | 2577 | 68 |
2451481 | 2451481 | 2022-04-28 | Noble | Indiana | 18113 | 13084 | 157 |
2451482 | 2451482 | 2022-04-28 | Ohio | Indiana | 18115 | 1448 | 19 |
2451483 | 2451483 | 2022-04-28 | Orange | Indiana | 18117 | 5042 | 96 |
2451484 | 2451484 | 2022-04-28 | Owen | Indiana | 18119 | 5863 | 121 |
2451485 | 2451485 | 2022-04-28 | Parke | Indiana | 18121 | 3597 | 46 |
2451486 | 2451486 | 2022-04-28 | Perry | Indiana | 18123 | 4656 | 69 |
2451487 | 2451487 | 2022-04-28 | Pike | Indiana | 18125 | 3733 | 49 |
2451488 | 2451488 | 2022-04-28 | Porter | Indiana | 18127 | 38006 | 562 |
2451489 | 2451489 | 2022-04-28 | Posey | Indiana | 18129 | 6549 | 58 |
2451490 | 2451490 | 2022-04-28 | Pulaski | Indiana | 18131 | 3079 | 86 |
2451491 | 2451491 | 2022-04-28 | Putnam | Indiana | 18133 | 9359 | 129 |
2451492 | 2451492 | 2022-04-28 | Randolph | Indiana | 18135 | 5910 | 148 |
2451493 | 2451493 | 2022-04-28 | Ripley | Indiana | 18137 | 8309 | 138 |
2451494 | 2451494 | 2022-04-28 | Rush | Indiana | 18139 | 4845 | 58 |
2451495 | 2451495 | 2022-04-28 | Scott | Indiana | 18143 | 7872 | 106 |
2451496 | 2451496 | 2022-04-28 | Shelby | Indiana | 18145 | 13610 | 182 |
2451497 | 2451497 | 2022-04-28 | Spencer | Indiana | 18147 | 5228 | 61 |
2451498 | 2451498 | 2022-04-28 | St. Joseph | Indiana | 18141 | 71095 | 872 |
2451499 | 2451499 | 2022-04-28 | Starke | Indiana | 18149 | 4761 | 99 |
2451500 | 2451500 | 2022-04-28 | Steuben | Indiana | 18151 | 9623 | 121 |
2451501 | 2451501 | 2022-04-28 | Sullivan | Indiana | 18153 | 5281 | 76 |
2451502 | 2451502 | 2022-04-28 | Switzerland | Indiana | 18155 | 2312 | 20 |
2451503 | 2451503 | 2022-04-28 | Tippecanoe | Indiana | 18157 | 50819 | 396 |
2451504 | 2451504 | 2022-04-28 | Tipton | Indiana | 18159 | 3529 | 87 |
2451505 | 2451505 | 2022-04-28 | Union | Indiana | 18161 | 2020 | 21 |
2451506 | 2451506 | 2022-04-28 | Unknown | Indiana | 0 | 20 | |
2451507 | 2451507 | 2022-04-28 | Vanderburgh | Indiana | 18163 | 57449 | 634 |
2451508 | 2451508 | 2022-04-28 | Vermillion | Indiana | 18165 | 4084 | 75 |
2451509 | 2451509 | 2022-04-28 | Vigo | Indiana | 18167 | 28905 | 413 |
2451510 | 2451510 | 2022-04-28 | Wabash | Indiana | 18169 | 8728 | 156 |
2451511 | 2451511 | 2022-04-28 | Warren | Indiana | 18171 | 2101 | 30 |
2451512 | 2451512 | 2022-04-28 | Warrick | Indiana | 18173 | 20307 | 239 |
2451513 | 2451513 | 2022-04-28 | Washington | Indiana | 18175 | 5996 | 84 |
2451514 | 2451514 | 2022-04-28 | Wayne | Indiana | 18177 | 18853 | 336 |
2451515 | 2451515 | 2022-04-28 | Wells | Indiana | 18179 | 6503 | 132 |
2451516 | 2451516 | 2022-04-28 | White | Indiana | 18181 | 6901 | 96 |
2451517 | 2451517 | 2022-04-28 | Whitley | Indiana | 18183 | 9680 | 84 |
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);