ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-11-21" 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 |
---|---|---|---|---|---|---|---|
752381 | 752381 | 2020-11-21 | Adams | Indiana | 18001 | 1575 | 20 |
752382 | 752382 | 2020-11-21 | Allen | Indiana | 18003 | 16684 | 299 |
752383 | 752383 | 2020-11-21 | Bartholomew | Indiana | 18005 | 2905 | 66 |
752384 | 752384 | 2020-11-21 | Benton | Indiana | 18007 | 302 | 1 |
752385 | 752385 | 2020-11-21 | Blackford | Indiana | 18009 | 493 | 10 |
752386 | 752386 | 2020-11-21 | Boone | Indiana | 18011 | 2289 | 57 |
752387 | 752387 | 2020-11-21 | Brown | Indiana | 18013 | 308 | 3 |
752388 | 752388 | 2020-11-21 | Carroll | Indiana | 18015 | 637 | 13 |
752389 | 752389 | 2020-11-21 | Cass | Indiana | 18017 | 2892 | 32 |
752390 | 752390 | 2020-11-21 | Clark | Indiana | 18019 | 4813 | 81 |
752391 | 752391 | 2020-11-21 | Clay | Indiana | 18021 | 1073 | 21 |
752392 | 752392 | 2020-11-21 | Clinton | Indiana | 18023 | 1679 | 24 |
752393 | 752393 | 2020-11-21 | Crawford | Indiana | 18025 | 267 | 2 |
752394 | 752394 | 2020-11-21 | Daviess | Indiana | 18027 | 1413 | 45 |
752395 | 752395 | 2020-11-21 | DeKalb | Indiana | 18033 | 1650 | 27 |
752396 | 752396 | 2020-11-21 | Dearborn | Indiana | 18029 | 2007 | 31 |
752397 | 752397 | 2020-11-21 | Decatur | Indiana | 18031 | 1226 | 45 |
752398 | 752398 | 2020-11-21 | Delaware | Indiana | 18035 | 4665 | 107 |
752399 | 752399 | 2020-11-21 | Dubois | Indiana | 18037 | 2259 | 31 |
752400 | 752400 | 2020-11-21 | Elkhart | Indiana | 18039 | 16170 | 217 |
752401 | 752401 | 2020-11-21 | Fayette | Indiana | 18041 | 1523 | 34 |
752402 | 752402 | 2020-11-21 | Floyd | Indiana | 18043 | 2955 | 80 |
752403 | 752403 | 2020-11-21 | Fountain | Indiana | 18045 | 718 | 7 |
752404 | 752404 | 2020-11-21 | Franklin | Indiana | 18047 | 629 | 26 |
752405 | 752405 | 2020-11-21 | Fulton | Indiana | 18049 | 777 | 17 |
752406 | 752406 | 2020-11-21 | Gibson | Indiana | 18051 | 1692 | 20 |
752407 | 752407 | 2020-11-21 | Grant | Indiana | 18053 | 2899 | 49 |
752408 | 752408 | 2020-11-21 | Greene | Indiana | 18055 | 952 | 56 |
752409 | 752409 | 2020-11-21 | Hamilton | Indiana | 18057 | 11925 | 170 |
752410 | 752410 | 2020-11-21 | Hancock | Indiana | 18059 | 2366 | 52 |
752411 | 752411 | 2020-11-21 | Harrison | Indiana | 18061 | 1310 | 26 |
752412 | 752412 | 2020-11-21 | Hendricks | Indiana | 18063 | 5574 | 170 |
752413 | 752413 | 2020-11-21 | Henry | Indiana | 18065 | 2314 | 37 |
752414 | 752414 | 2020-11-21 | Howard | Indiana | 18067 | 3124 | 78 |
752415 | 752415 | 2020-11-21 | Huntington | Indiana | 18069 | 1100 | 9 |
752416 | 752416 | 2020-11-21 | Jackson | Indiana | 18071 | 1957 | 34 |
752417 | 752417 | 2020-11-21 | Jasper | Indiana | 18073 | 1339 | 12 |
752418 | 752418 | 2020-11-21 | Jay | Indiana | 18075 | 928 | 13 |
752419 | 752419 | 2020-11-21 | Jefferson | Indiana | 18077 | 1083 | 14 |
752420 | 752420 | 2020-11-21 | Jennings | Indiana | 18079 | 779 | 16 |
752421 | 752421 | 2020-11-21 | Johnson | Indiana | 18081 | 5857 | 170 |
752422 | 752422 | 2020-11-21 | Knox | Indiana | 18083 | 1648 | 14 |
752423 | 752423 | 2020-11-21 | Kosciusko | Indiana | 18085 | 4269 | 40 |
752424 | 752424 | 2020-11-21 | LaGrange | Indiana | 18087 | 1342 | 28 |
752425 | 752425 | 2020-11-21 | LaPorte | Indiana | 18091 | 4307 | 90 |
752426 | 752426 | 2020-11-21 | Lake | Indiana | 18089 | 25580 | 460 |
752427 | 752427 | 2020-11-21 | Lawrence | Indiana | 18093 | 1674 | 46 |
752428 | 752428 | 2020-11-21 | Madison | Indiana | 18095 | 4510 | 130 |
752429 | 752429 | 2020-11-21 | Marion | Indiana | 18097 | 40035 | 892 |
752430 | 752430 | 2020-11-21 | Marshall | Indiana | 18099 | 2796 | 41 |
752431 | 752431 | 2020-11-21 | Martin | Indiana | 18101 | 336 | 5 |
752432 | 752432 | 2020-11-21 | Miami | Indiana | 18103 | 1477 | 14 |
752433 | 752433 | 2020-11-21 | Monroe | Indiana | 18105 | 5120 | 49 |
752434 | 752434 | 2020-11-21 | Montgomery | Indiana | 18107 | 1259 | 27 |
752435 | 752435 | 2020-11-21 | Morgan | Indiana | 18109 | 1922 | 47 |
752436 | 752436 | 2020-11-21 | Newton | Indiana | 18111 | 528 | 13 |
752437 | 752437 | 2020-11-21 | Noble | Indiana | 18113 | 2384 | 47 |
752438 | 752438 | 2020-11-21 | Ohio | Indiana | 18115 | 221 | 7 |
752439 | 752439 | 2020-11-21 | Orange | Indiana | 18117 | 637 | 30 |
752440 | 752440 | 2020-11-21 | Owen | Indiana | 18119 | 550 | 7 |
752441 | 752441 | 2020-11-21 | Parke | Indiana | 18121 | 526 | 6 |
752442 | 752442 | 2020-11-21 | Perry | Indiana | 18123 | 808 | 22 |
752443 | 752443 | 2020-11-21 | Pike | Indiana | 18125 | 489 | 18 |
752444 | 752444 | 2020-11-21 | Porter | Indiana | 18127 | 7589 | 75 |
752445 | 752445 | 2020-11-21 | Posey | Indiana | 18129 | 1152 | 13 |
752446 | 752446 | 2020-11-21 | Pulaski | Indiana | 18131 | 361 | 10 |
752447 | 752447 | 2020-11-21 | Putnam | Indiana | 18133 | 1130 | 25 |
752448 | 752448 | 2020-11-21 | Randolph | Indiana | 18135 | 1166 | 18 |
752449 | 752449 | 2020-11-21 | Ripley | Indiana | 18137 | 1172 | 13 |
752450 | 752450 | 2020-11-21 | Rush | Indiana | 18139 | 544 | 6 |
752451 | 752451 | 2020-11-21 | Scott | Indiana | 18143 | 975 | 20 |
752452 | 752452 | 2020-11-21 | Shelby | Indiana | 18145 | 2278 | 62 |
752453 | 752453 | 2020-11-21 | Spencer | Indiana | 18147 | 785 | 7 |
752454 | 752454 | 2020-11-21 | St. Joseph | Indiana | 18141 | 15894 | 226 |
752455 | 752455 | 2020-11-21 | Starke | Indiana | 18149 | 868 | 21 |
752456 | 752456 | 2020-11-21 | Steuben | Indiana | 18151 | 1360 | 13 |
752457 | 752457 | 2020-11-21 | Sullivan | Indiana | 18153 | 817 | 15 |
752458 | 752458 | 2020-11-21 | Switzerland | Indiana | 18155 | 244 | 3 |
752459 | 752459 | 2020-11-21 | Tippecanoe | Indiana | 18157 | 7868 | 28 |
752460 | 752460 | 2020-11-21 | Tipton | Indiana | 18159 | 524 | 29 |
752461 | 752461 | 2020-11-21 | Union | Indiana | 18161 | 280 | 1 |
752462 | 752462 | 2020-11-21 | Vanderburgh | Indiana | 18163 | 9096 | 112 |
752463 | 752463 | 2020-11-21 | Vermillion | Indiana | 18165 | 555 | 2 |
752464 | 752464 | 2020-11-21 | Vigo | Indiana | 18167 | 5519 | 74 |
752465 | 752465 | 2020-11-21 | Wabash | Indiana | 18169 | 1421 | 18 |
752466 | 752466 | 2020-11-21 | Warren | Indiana | 18171 | 226 | 3 |
752467 | 752467 | 2020-11-21 | Warrick | Indiana | 18173 | 3046 | 74 |
752468 | 752468 | 2020-11-21 | Washington | Indiana | 18175 | 675 | 6 |
752469 | 752469 | 2020-11-21 | Wayne | Indiana | 18177 | 3248 | 60 |
752470 | 752470 | 2020-11-21 | Wells | Indiana | 18179 | 1153 | 26 |
752471 | 752471 | 2020-11-21 | White | Indiana | 18181 | 1125 | 21 |
752472 | 752472 | 2020-11-21 | Whitley | Indiana | 18183 | 1241 | 10 |
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);