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-11-25 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
765364 | 765364 | 2020-11-25 | Adams | Indiana | 18001 | 1683 | 23 |
765365 | 765365 | 2020-11-25 | Allen | Indiana | 18003 | 18045 | 310 |
765366 | 765366 | 2020-11-25 | Bartholomew | Indiana | 18005 | 3185 | 68 |
765367 | 765367 | 2020-11-25 | Benton | Indiana | 18007 | 340 | 2 |
765368 | 765368 | 2020-11-25 | Blackford | Indiana | 18009 | 545 | 12 |
765369 | 765369 | 2020-11-25 | Boone | Indiana | 18011 | 2463 | 57 |
765370 | 765370 | 2020-11-25 | Brown | Indiana | 18013 | 342 | 4 |
765371 | 765371 | 2020-11-25 | Carroll | Indiana | 18015 | 686 | 13 |
765372 | 765372 | 2020-11-25 | Cass | Indiana | 18017 | 3002 | 32 |
765373 | 765373 | 2020-11-25 | Clark | Indiana | 18019 | 5170 | 84 |
765374 | 765374 | 2020-11-25 | Clay | Indiana | 18021 | 1225 | 23 |
765375 | 765375 | 2020-11-25 | Clinton | Indiana | 18023 | 1807 | 25 |
765376 | 765376 | 2020-11-25 | Crawford | Indiana | 18025 | 295 | 2 |
765377 | 765377 | 2020-11-25 | Daviess | Indiana | 18027 | 1566 | 45 |
765378 | 765378 | 2020-11-25 | DeKalb | Indiana | 18033 | 1780 | 32 |
765379 | 765379 | 2020-11-25 | Dearborn | Indiana | 18029 | 2198 | 32 |
765380 | 765380 | 2020-11-25 | Decatur | Indiana | 18031 | 1301 | 46 |
765381 | 765381 | 2020-11-25 | Delaware | Indiana | 18035 | 4917 | 107 |
765382 | 765382 | 2020-11-25 | Dubois | Indiana | 18037 | 2380 | 32 |
765383 | 765383 | 2020-11-25 | Elkhart | Indiana | 18039 | 17272 | 229 |
765384 | 765384 | 2020-11-25 | Fayette | Indiana | 18041 | 1621 | 35 |
765385 | 765385 | 2020-11-25 | Floyd | Indiana | 18043 | 3170 | 80 |
765386 | 765386 | 2020-11-25 | Fountain | Indiana | 18045 | 780 | 8 |
765387 | 765387 | 2020-11-25 | Franklin | Indiana | 18047 | 712 | 28 |
765388 | 765388 | 2020-11-25 | Fulton | Indiana | 18049 | 847 | 18 |
765389 | 765389 | 2020-11-25 | Gibson | Indiana | 18051 | 1871 | 25 |
765390 | 765390 | 2020-11-25 | Grant | Indiana | 18053 | 3153 | 53 |
765391 | 765391 | 2020-11-25 | Greene | Indiana | 18055 | 1034 | 56 |
765392 | 765392 | 2020-11-25 | Hamilton | Indiana | 18057 | 13047 | 177 |
765393 | 765393 | 2020-11-25 | Hancock | Indiana | 18059 | 2557 | 55 |
765394 | 765394 | 2020-11-25 | Harrison | Indiana | 18061 | 1432 | 26 |
765395 | 765395 | 2020-11-25 | Hendricks | Indiana | 18063 | 6133 | 174 |
765396 | 765396 | 2020-11-25 | Henry | Indiana | 18065 | 2489 | 38 |
765397 | 765397 | 2020-11-25 | Howard | Indiana | 18067 | 3451 | 80 |
765398 | 765398 | 2020-11-25 | Huntington | Indiana | 18069 | 1277 | 10 |
765399 | 765399 | 2020-11-25 | Jackson | Indiana | 18071 | 2159 | 35 |
765400 | 765400 | 2020-11-25 | Jasper | Indiana | 18073 | 1446 | 13 |
765401 | 765401 | 2020-11-25 | Jay | Indiana | 18075 | 1000 | 15 |
765402 | 765402 | 2020-11-25 | Jefferson | Indiana | 18077 | 1189 | 16 |
765403 | 765403 | 2020-11-25 | Jennings | Indiana | 18079 | 857 | 16 |
765404 | 765404 | 2020-11-25 | Johnson | Indiana | 18081 | 6434 | 174 |
765405 | 765405 | 2020-11-25 | Knox | Indiana | 18083 | 1880 | 19 |
765406 | 765406 | 2020-11-25 | Kosciusko | Indiana | 18085 | 4643 | 41 |
765407 | 765407 | 2020-11-25 | LaGrange | Indiana | 18087 | 1430 | 31 |
765408 | 765408 | 2020-11-25 | LaPorte | Indiana | 18091 | 4662 | 96 |
765409 | 765409 | 2020-11-25 | Lake | Indiana | 18089 | 27213 | 474 |
765410 | 765410 | 2020-11-25 | Lawrence | Indiana | 18093 | 1778 | 50 |
765411 | 765411 | 2020-11-25 | Madison | Indiana | 18095 | 5084 | 135 |
765412 | 765412 | 2020-11-25 | Marion | Indiana | 18097 | 42819 | 904 |
765413 | 765413 | 2020-11-25 | Marshall | Indiana | 18099 | 2991 | 44 |
765414 | 765414 | 2020-11-25 | Martin | Indiana | 18101 | 359 | 5 |
765415 | 765415 | 2020-11-25 | Miami | Indiana | 18103 | 1631 | 14 |
765416 | 765416 | 2020-11-25 | Monroe | Indiana | 18105 | 5372 | 54 |
765417 | 765417 | 2020-11-25 | Montgomery | Indiana | 18107 | 1423 | 28 |
765418 | 765418 | 2020-11-25 | Morgan | Indiana | 18109 | 2122 | 47 |
765419 | 765419 | 2020-11-25 | Newton | Indiana | 18111 | 564 | 13 |
765420 | 765420 | 2020-11-25 | Noble | Indiana | 18113 | 2554 | 48 |
765421 | 765421 | 2020-11-25 | Ohio | Indiana | 18115 | 231 | 7 |
765422 | 765422 | 2020-11-25 | Orange | Indiana | 18117 | 675 | 30 |
765423 | 765423 | 2020-11-25 | Owen | Indiana | 18119 | 609 | 8 |
765424 | 765424 | 2020-11-25 | Parke | Indiana | 18121 | 584 | 6 |
765425 | 765425 | 2020-11-25 | Perry | Indiana | 18123 | 835 | 22 |
765426 | 765426 | 2020-11-25 | Pike | Indiana | 18125 | 509 | 19 |
765427 | 765427 | 2020-11-25 | Porter | Indiana | 18127 | 8292 | 89 |
765428 | 765428 | 2020-11-25 | Posey | Indiana | 18129 | 1221 | 16 |
765429 | 765429 | 2020-11-25 | Pulaski | Indiana | 18131 | 397 | 15 |
765430 | 765430 | 2020-11-25 | Putnam | Indiana | 18133 | 1253 | 27 |
765431 | 765431 | 2020-11-25 | Randolph | Indiana | 18135 | 1285 | 19 |
765432 | 765432 | 2020-11-25 | Ripley | Indiana | 18137 | 1322 | 15 |
765433 | 765433 | 2020-11-25 | Rush | Indiana | 18139 | 595 | 8 |
765434 | 765434 | 2020-11-25 | Scott | Indiana | 18143 | 1097 | 22 |
765435 | 765435 | 2020-11-25 | Shelby | Indiana | 18145 | 2463 | 64 |
765436 | 765436 | 2020-11-25 | Spencer | Indiana | 18147 | 840 | 8 |
765437 | 765437 | 2020-11-25 | St. Joseph | Indiana | 18141 | 16826 | 240 |
765438 | 765438 | 2020-11-25 | Starke | Indiana | 18149 | 922 | 22 |
765439 | 765439 | 2020-11-25 | Steuben | Indiana | 18151 | 1475 | 13 |
765440 | 765440 | 2020-11-25 | Sullivan | Indiana | 18153 | 969 | 16 |
765441 | 765441 | 2020-11-25 | Switzerland | Indiana | 18155 | 259 | 5 |
765442 | 765442 | 2020-11-25 | Tippecanoe | Indiana | 18157 | 8590 | 28 |
765443 | 765443 | 2020-11-25 | Tipton | Indiana | 18159 | 581 | 30 |
765444 | 765444 | 2020-11-25 | Union | Indiana | 18161 | 299 | 2 |
765445 | 765445 | 2020-11-25 | Vanderburgh | Indiana | 18163 | 9756 | 121 |
765446 | 765446 | 2020-11-25 | Vermillion | Indiana | 18165 | 625 | 3 |
765447 | 765447 | 2020-11-25 | Vigo | Indiana | 18167 | 6091 | 86 |
765448 | 765448 | 2020-11-25 | Wabash | Indiana | 18169 | 1631 | 21 |
765449 | 765449 | 2020-11-25 | Warren | Indiana | 18171 | 240 | 3 |
765450 | 765450 | 2020-11-25 | Warrick | Indiana | 18173 | 3258 | 74 |
765451 | 765451 | 2020-11-25 | Washington | Indiana | 18175 | 752 | 7 |
765452 | 765452 | 2020-11-25 | Wayne | Indiana | 18177 | 3473 | 72 |
765453 | 765453 | 2020-11-25 | Wells | Indiana | 18179 | 1268 | 31 |
765454 | 765454 | 2020-11-25 | White | Indiana | 18181 | 1232 | 22 |
765455 | 765455 | 2020-11-25 | Whitley | Indiana | 18183 | 1371 | 14 |
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);