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-13 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
726417 | 726417 | 2020-11-13 | Adams | Indiana | 18001 | 1158 | 16 |
726418 | 726418 | 2020-11-13 | Allen | Indiana | 18003 | 13191 | 274 |
726419 | 726419 | 2020-11-13 | Bartholomew | Indiana | 18005 | 2193 | 65 |
726420 | 726420 | 2020-11-13 | Benton | Indiana | 18007 | 193 | 1 |
726421 | 726421 | 2020-11-13 | Blackford | Indiana | 18009 | 379 | 9 |
726422 | 726422 | 2020-11-13 | Boone | Indiana | 18011 | 1857 | 56 |
726423 | 726423 | 2020-11-13 | Brown | Indiana | 18013 | 234 | 3 |
726424 | 726424 | 2020-11-13 | Carroll | Indiana | 18015 | 520 | 13 |
726425 | 726425 | 2020-11-13 | Cass | Indiana | 18017 | 2671 | 28 |
726426 | 726426 | 2020-11-13 | Clark | Indiana | 18019 | 4060 | 79 |
726427 | 726427 | 2020-11-13 | Clay | Indiana | 18021 | 778 | 21 |
726428 | 726428 | 2020-11-13 | Clinton | Indiana | 18023 | 1375 | 22 |
726429 | 726429 | 2020-11-13 | Crawford | Indiana | 18025 | 220 | 2 |
726430 | 726430 | 2020-11-13 | Daviess | Indiana | 18027 | 1195 | 43 |
726431 | 726431 | 2020-11-13 | DeKalb | Indiana | 18033 | 1260 | 17 |
726432 | 726432 | 2020-11-13 | Dearborn | Indiana | 18029 | 1570 | 30 |
726433 | 726433 | 2020-11-13 | Decatur | Indiana | 18031 | 1007 | 43 |
726434 | 726434 | 2020-11-13 | Delaware | Indiana | 18035 | 3986 | 98 |
726435 | 726435 | 2020-11-13 | Dubois | Indiana | 18037 | 2001 | 30 |
726436 | 726436 | 2020-11-13 | Elkhart | Indiana | 18039 | 13622 | 189 |
726437 | 726437 | 2020-11-13 | Fayette | Indiana | 18041 | 1298 | 27 |
726438 | 726438 | 2020-11-13 | Floyd | Indiana | 18043 | 2540 | 77 |
726439 | 726439 | 2020-11-13 | Fountain | Indiana | 18045 | 553 | 7 |
726440 | 726440 | 2020-11-13 | Franklin | Indiana | 18047 | 517 | 26 |
726441 | 726441 | 2020-11-13 | Fulton | Indiana | 18049 | 621 | 14 |
726442 | 726442 | 2020-11-13 | Gibson | Indiana | 18051 | 1360 | 18 |
726443 | 726443 | 2020-11-13 | Grant | Indiana | 18053 | 2348 | 48 |
726444 | 726444 | 2020-11-13 | Greene | Indiana | 18055 | 806 | 52 |
726445 | 726445 | 2020-11-13 | Hamilton | Indiana | 18057 | 9624 | 163 |
726446 | 726446 | 2020-11-13 | Hancock | Indiana | 18059 | 1884 | 50 |
726447 | 726447 | 2020-11-13 | Harrison | Indiana | 18061 | 1098 | 26 |
726448 | 726448 | 2020-11-13 | Hendricks | Indiana | 18063 | 4531 | 165 |
726449 | 726449 | 2020-11-13 | Henry | Indiana | 18065 | 1918 | 33 |
726450 | 726450 | 2020-11-13 | Howard | Indiana | 18067 | 2325 | 74 |
726451 | 726451 | 2020-11-13 | Huntington | Indiana | 18069 | 826 | 7 |
726452 | 726452 | 2020-11-13 | Jackson | Indiana | 18071 | 1640 | 30 |
726453 | 726453 | 2020-11-13 | Jasper | Indiana | 18073 | 1080 | 8 |
726454 | 726454 | 2020-11-13 | Jay | Indiana | 18075 | 682 | 10 |
726455 | 726455 | 2020-11-13 | Jefferson | Indiana | 18077 | 739 | 9 |
726456 | 726456 | 2020-11-13 | Jennings | Indiana | 18079 | 620 | 15 |
726457 | 726457 | 2020-11-13 | Johnson | Indiana | 18081 | 4643 | 169 |
726458 | 726458 | 2020-11-13 | Knox | Indiana | 18083 | 1333 | 13 |
726459 | 726459 | 2020-11-13 | Kosciusko | Indiana | 18085 | 3254 | 38 |
726460 | 726460 | 2020-11-13 | LaGrange | Indiana | 18087 | 1151 | 23 |
726461 | 726461 | 2020-11-13 | LaPorte | Indiana | 18091 | 3573 | 82 |
726462 | 726462 | 2020-11-13 | Lake | Indiana | 18089 | 21363 | 426 |
726463 | 726463 | 2020-11-13 | Lawrence | Indiana | 18093 | 1419 | 45 |
726464 | 726464 | 2020-11-13 | Madison | Indiana | 18095 | 3699 | 125 |
726465 | 726465 | 2020-11-13 | Marion | Indiana | 18097 | 33752 | 869 |
726466 | 726466 | 2020-11-13 | Marshall | Indiana | 18099 | 2263 | 34 |
726467 | 726467 | 2020-11-13 | Martin | Indiana | 18101 | 269 | 2 |
726468 | 726468 | 2020-11-13 | Miami | Indiana | 18103 | 1076 | 9 |
726469 | 726469 | 2020-11-13 | Monroe | Indiana | 18105 | 4204 | 46 |
726470 | 726470 | 2020-11-13 | Montgomery | Indiana | 18107 | 998 | 24 |
726471 | 726471 | 2020-11-13 | Morgan | Indiana | 18109 | 1527 | 45 |
726472 | 726472 | 2020-11-13 | Newton | Indiana | 18111 | 421 | 13 |
726473 | 726473 | 2020-11-13 | Noble | Indiana | 18113 | 1872 | 42 |
726474 | 726474 | 2020-11-13 | Ohio | Indiana | 18115 | 178 | 7 |
726475 | 726475 | 2020-11-13 | Orange | Indiana | 18117 | 543 | 29 |
726476 | 726476 | 2020-11-13 | Owen | Indiana | 18119 | 421 | 3 |
726477 | 726477 | 2020-11-13 | Parke | Indiana | 18121 | 411 | 6 |
726478 | 726478 | 2020-11-13 | Perry | Indiana | 18123 | 700 | 20 |
726479 | 726479 | 2020-11-13 | Pike | Indiana | 18125 | 443 | 18 |
726480 | 726480 | 2020-11-13 | Porter | Indiana | 18127 | 5978 | 69 |
726481 | 726481 | 2020-11-13 | Posey | Indiana | 18129 | 1005 | 13 |
726482 | 726482 | 2020-11-13 | Pulaski | Indiana | 18131 | 303 | 10 |
726483 | 726483 | 2020-11-13 | Putnam | Indiana | 18133 | 987 | 23 |
726484 | 726484 | 2020-11-13 | Randolph | Indiana | 18135 | 905 | 13 |
726485 | 726485 | 2020-11-13 | Ripley | Indiana | 18137 | 862 | 12 |
726486 | 726486 | 2020-11-13 | Rush | Indiana | 18139 | 461 | 6 |
726487 | 726487 | 2020-11-13 | Scott | Indiana | 18143 | 742 | 19 |
726488 | 726488 | 2020-11-13 | Shelby | Indiana | 18145 | 1954 | 56 |
726489 | 726489 | 2020-11-13 | Spencer | Indiana | 18147 | 641 | 7 |
726490 | 726490 | 2020-11-13 | St. Joseph | Indiana | 18141 | 13442 | 203 |
726491 | 726491 | 2020-11-13 | Starke | Indiana | 18149 | 721 | 17 |
726492 | 726492 | 2020-11-13 | Steuben | Indiana | 18151 | 1043 | 11 |
726493 | 726493 | 2020-11-13 | Sullivan | Indiana | 18153 | 634 | 15 |
726494 | 726494 | 2020-11-13 | Switzerland | Indiana | 18155 | 190 | 1 |
726495 | 726495 | 2020-11-13 | Tippecanoe | Indiana | 18157 | 6135 | 24 |
726496 | 726496 | 2020-11-13 | Tipton | Indiana | 18159 | 417 | 26 |
726497 | 726497 | 2020-11-13 | Union | Indiana | 18161 | 232 | 1 |
726498 | 726498 | 2020-11-13 | Vanderburgh | Indiana | 18163 | 7935 | 99 |
726499 | 726499 | 2020-11-13 | Vermillion | Indiana | 18165 | 422 | 2 |
726500 | 726500 | 2020-11-13 | Vigo | Indiana | 18167 | 4365 | 66 |
726501 | 726501 | 2020-11-13 | Wabash | Indiana | 18169 | 1004 | 16 |
726502 | 726502 | 2020-11-13 | Warren | Indiana | 18171 | 167 | 1 |
726503 | 726503 | 2020-11-13 | Warrick | Indiana | 18173 | 2665 | 70 |
726504 | 726504 | 2020-11-13 | Washington | Indiana | 18175 | 542 | 5 |
726505 | 726505 | 2020-11-13 | Wayne | Indiana | 18177 | 2682 | 44 |
726506 | 726506 | 2020-11-13 | Wells | Indiana | 18179 | 869 | 22 |
726507 | 726507 | 2020-11-13 | White | Indiana | 18181 | 922 | 19 |
726508 | 726508 | 2020-11-13 | Whitley | Indiana | 18183 | 921 | 7 |
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);