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-08-17 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
441391 | 441391 | 2020-08-17 | Adams | Indiana | 18001 | 140 | 3 |
441392 | 441392 | 2020-08-17 | Allen | Indiana | 18003 | 4340 | 176 |
441393 | 441393 | 2020-08-17 | Bartholomew | Indiana | 18005 | 936 | 50 |
441394 | 441394 | 2020-08-17 | Benton | Indiana | 18007 | 69 | 0 |
441395 | 441395 | 2020-08-17 | Blackford | Indiana | 18009 | 73 | 2 |
441396 | 441396 | 2020-08-17 | Boone | Indiana | 18011 | 759 | 49 |
441397 | 441397 | 2020-08-17 | Brown | Indiana | 18013 | 79 | 2 |
441398 | 441398 | 2020-08-17 | Carroll | Indiana | 18015 | 230 | 7 |
441399 | 441399 | 2020-08-17 | Cass | Indiana | 18017 | 1823 | 10 |
441400 | 441400 | 2020-08-17 | Clark | Indiana | 18019 | 1436 | 57 |
441401 | 441401 | 2020-08-17 | Clay | Indiana | 18021 | 175 | 5 |
441402 | 441402 | 2020-08-17 | Clinton | Indiana | 18023 | 479 | 5 |
441403 | 441403 | 2020-08-17 | Crawford | Indiana | 18025 | 53 | 1 |
441404 | 441404 | 2020-08-17 | Daviess | Indiana | 18027 | 322 | 23 |
441405 | 441405 | 2020-08-17 | DeKalb | Indiana | 18033 | 255 | 5 |
441406 | 441406 | 2020-08-17 | Dearborn | Indiana | 18029 | 541 | 30 |
441407 | 441407 | 2020-08-17 | Decatur | Indiana | 18031 | 382 | 35 |
441408 | 441408 | 2020-08-17 | Delaware | Indiana | 18035 | 809 | 54 |
441409 | 441409 | 2020-08-17 | Dubois | Indiana | 18037 | 747 | 13 |
441410 | 441410 | 2020-08-17 | Elkhart | Indiana | 18039 | 5243 | 96 |
441411 | 441411 | 2020-08-17 | Fayette | Indiana | 18041 | 302 | 7 |
441412 | 441412 | 2020-08-17 | Floyd | Indiana | 18043 | 906 | 53 |
441413 | 441413 | 2020-08-17 | Fountain | Indiana | 18045 | 76 | 2 |
441414 | 441414 | 2020-08-17 | Franklin | Indiana | 18047 | 263 | 20 |
441415 | 441415 | 2020-08-17 | Fulton | Indiana | 18049 | 182 | 2 |
441416 | 441416 | 2020-08-17 | Gibson | Indiana | 18051 | 250 | 4 |
441417 | 441417 | 2020-08-17 | Grant | Indiana | 18053 | 833 | 33 |
441418 | 441418 | 2020-08-17 | Greene | Indiana | 18055 | 278 | 37 |
441419 | 441419 | 2020-08-17 | Hamilton | Indiana | 18057 | 3200 | 114 |
441420 | 441420 | 2020-08-17 | Hancock | Indiana | 18059 | 730 | 42 |
441421 | 441421 | 2020-08-17 | Harrison | Indiana | 18061 | 392 | 26 |
441422 | 441422 | 2020-08-17 | Hendricks | Indiana | 18063 | 2045 | 125 |
441423 | 441423 | 2020-08-17 | Henry | Indiana | 18065 | 511 | 21 |
441424 | 441424 | 2020-08-17 | Howard | Indiana | 18067 | 991 | 64 |
441425 | 441425 | 2020-08-17 | Huntington | Indiana | 18069 | 139 | 3 |
441426 | 441426 | 2020-08-17 | Jackson | Indiana | 18071 | 636 | 6 |
441427 | 441427 | 2020-08-17 | Jasper | Indiana | 18073 | 273 | 2 |
441428 | 441428 | 2020-08-17 | Jay | Indiana | 18075 | 108 | 0 |
441429 | 441429 | 2020-08-17 | Jefferson | Indiana | 18077 | 185 | 2 |
441430 | 441430 | 2020-08-17 | Jennings | Indiana | 18079 | 240 | 14 |
441431 | 441431 | 2020-08-17 | Johnson | Indiana | 18081 | 1883 | 127 |
441432 | 441432 | 2020-08-17 | Knox | Indiana | 18083 | 197 | 3 |
441433 | 441433 | 2020-08-17 | Kosciusko | Indiana | 18085 | 905 | 13 |
441434 | 441434 | 2020-08-17 | LaGrange | Indiana | 18087 | 576 | 10 |
441435 | 441435 | 2020-08-17 | LaPorte | Indiana | 18091 | 1015 | 30 |
441436 | 441436 | 2020-08-17 | Lake | Indiana | 18089 | 8231 | 301 |
441437 | 441437 | 2020-08-17 | Lawrence | Indiana | 18093 | 370 | 29 |
441438 | 441438 | 2020-08-17 | Madison | Indiana | 18095 | 1124 | 77 |
441439 | 441439 | 2020-08-17 | Marion | Indiana | 18097 | 16863 | 785 |
441440 | 441440 | 2020-08-17 | Marshall | Indiana | 18099 | 814 | 23 |
441441 | 441441 | 2020-08-17 | Martin | Indiana | 18101 | 56 | 0 |
441442 | 441442 | 2020-08-17 | Miami | Indiana | 18103 | 290 | 2 |
441443 | 441443 | 2020-08-17 | Monroe | Indiana | 18105 | 809 | 37 |
441444 | 441444 | 2020-08-17 | Montgomery | Indiana | 18107 | 372 | 22 |
441445 | 441445 | 2020-08-17 | Morgan | Indiana | 18109 | 524 | 38 |
441446 | 441446 | 2020-08-17 | Newton | Indiana | 18111 | 123 | 11 |
441447 | 441447 | 2020-08-17 | Noble | Indiana | 18113 | 745 | 30 |
441448 | 441448 | 2020-08-17 | Ohio | Indiana | 18115 | 68 | 7 |
441449 | 441449 | 2020-08-17 | Orange | Indiana | 18117 | 195 | 26 |
441450 | 441450 | 2020-08-17 | Owen | Indiana | 18119 | 116 | 1 |
441451 | 441451 | 2020-08-17 | Parke | Indiana | 18121 | 70 | 1 |
441452 | 441452 | 2020-08-17 | Perry | Indiana | 18123 | 205 | 14 |
441453 | 441453 | 2020-08-17 | Pike | Indiana | 18125 | 73 | 0 |
441454 | 441454 | 2020-08-17 | Porter | Indiana | 18127 | 1480 | 41 |
441455 | 441455 | 2020-08-17 | Posey | Indiana | 18129 | 190 | 0 |
441456 | 441456 | 2020-08-17 | Pulaski | Indiana | 18131 | 88 | 1 |
441457 | 441457 | 2020-08-17 | Putnam | Indiana | 18133 | 348 | 8 |
441458 | 441458 | 2020-08-17 | Randolph | Indiana | 18135 | 170 | 5 |
441459 | 441459 | 2020-08-17 | Ripley | Indiana | 18137 | 226 | 8 |
441460 | 441460 | 2020-08-17 | Rush | Indiana | 18139 | 143 | 4 |
441461 | 441461 | 2020-08-17 | Scott | Indiana | 18143 | 294 | 11 |
441462 | 441462 | 2020-08-17 | Shelby | Indiana | 18145 | 948 | 36 |
441463 | 441463 | 2020-08-17 | Spencer | Indiana | 18147 | 144 | 3 |
441464 | 441464 | 2020-08-17 | St. Joseph | Indiana | 18141 | 3898 | 90 |
441465 | 441465 | 2020-08-17 | Starke | Indiana | 18149 | 188 | 8 |
441466 | 441466 | 2020-08-17 | Steuben | Indiana | 18151 | 225 | 3 |
441467 | 441467 | 2020-08-17 | Sullivan | Indiana | 18153 | 197 | 1 |
441468 | 441468 | 2020-08-17 | Switzerland | Indiana | 18155 | 62 | 0 |
441469 | 441469 | 2020-08-17 | Tippecanoe | Indiana | 18157 | 1355 | 13 |
441470 | 441470 | 2020-08-17 | Tipton | Indiana | 18159 | 167 | 19 |
441471 | 441471 | 2020-08-17 | Union | Indiana | 18161 | 70 | 0 |
441472 | 441472 | 2020-08-17 | Vanderburgh | Indiana | 18163 | 2203 | 15 |
441473 | 441473 | 2020-08-17 | Vermillion | Indiana | 18165 | 69 | 0 |
441474 | 441474 | 2020-08-17 | Vigo | Indiana | 18167 | 863 | 14 |
441475 | 441475 | 2020-08-17 | Wabash | Indiana | 18169 | 188 | 5 |
441476 | 441476 | 2020-08-17 | Warren | Indiana | 18171 | 28 | 1 |
441477 | 441477 | 2020-08-17 | Warrick | Indiana | 18173 | 635 | 32 |
441478 | 441478 | 2020-08-17 | Washington | Indiana | 18175 | 162 | 1 |
441479 | 441479 | 2020-08-17 | Wayne | Indiana | 18177 | 746 | 10 |
441480 | 441480 | 2020-08-17 | Wells | Indiana | 18179 | 200 | 2 |
441481 | 441481 | 2020-08-17 | White | Indiana | 18181 | 397 | 11 |
441482 | 441482 | 2020-08-17 | Whitley | Indiana | 18183 | 170 | 6 |
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);