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-10-19 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
645327 | 645327 | 2020-10-19 | Adams | Indiana | 18001 | 465 | 6 |
645328 | 645328 | 2020-10-19 | Allen | Indiana | 18003 | 7850 | 232 |
645329 | 645329 | 2020-10-19 | Bartholomew | Indiana | 18005 | 1401 | 61 |
645330 | 645330 | 2020-10-19 | Benton | Indiana | 18007 | 107 | 0 |
645331 | 645331 | 2020-10-19 | Blackford | Indiana | 18009 | 200 | 3 |
645332 | 645332 | 2020-10-19 | Boone | Indiana | 18011 | 1205 | 51 |
645333 | 645333 | 2020-10-19 | Brown | Indiana | 18013 | 128 | 3 |
645334 | 645334 | 2020-10-19 | Carroll | Indiana | 18015 | 308 | 13 |
645335 | 645335 | 2020-10-19 | Cass | Indiana | 18017 | 2214 | 21 |
645336 | 645336 | 2020-10-19 | Clark | Indiana | 18019 | 2839 | 64 |
645337 | 645337 | 2020-10-19 | Clay | Indiana | 18021 | 427 | 6 |
645338 | 645338 | 2020-10-19 | Clinton | Indiana | 18023 | 817 | 20 |
645339 | 645339 | 2020-10-19 | Crawford | Indiana | 18025 | 149 | 2 |
645340 | 645340 | 2020-10-19 | Daviess | Indiana | 18027 | 839 | 34 |
645341 | 645341 | 2020-10-19 | DeKalb | Indiana | 18033 | 688 | 12 |
645342 | 645342 | 2020-10-19 | Dearborn | Indiana | 18029 | 910 | 30 |
645343 | 645343 | 2020-10-19 | Decatur | Indiana | 18031 | 521 | 42 |
645344 | 645344 | 2020-10-19 | Delaware | Indiana | 18035 | 2801 | 75 |
645345 | 645345 | 2020-10-19 | Dubois | Indiana | 18037 | 1337 | 24 |
645346 | 645346 | 2020-10-19 | Elkhart | Indiana | 18039 | 8464 | 136 |
645347 | 645347 | 2020-10-19 | Fayette | Indiana | 18041 | 694 | 15 |
645348 | 645348 | 2020-10-19 | Floyd | Indiana | 18043 | 1733 | 69 |
645349 | 645349 | 2020-10-19 | Fountain | Indiana | 18045 | 275 | 3 |
645350 | 645350 | 2020-10-19 | Franklin | Indiana | 18047 | 373 | 26 |
645351 | 645351 | 2020-10-19 | Fulton | Indiana | 18049 | 331 | 2 |
645352 | 645352 | 2020-10-19 | Gibson | Indiana | 18051 | 828 | 11 |
645353 | 645353 | 2020-10-19 | Grant | Indiana | 18053 | 1575 | 42 |
645354 | 645354 | 2020-10-19 | Greene | Indiana | 18055 | 517 | 40 |
645355 | 645355 | 2020-10-19 | Hamilton | Indiana | 18057 | 5955 | 122 |
645356 | 645356 | 2020-10-19 | Hancock | Indiana | 18059 | 1158 | 47 |
645357 | 645357 | 2020-10-19 | Harrison | Indiana | 18061 | 736 | 26 |
645358 | 645358 | 2020-10-19 | Hendricks | Indiana | 18063 | 3176 | 147 |
645359 | 645359 | 2020-10-19 | Henry | Indiana | 18065 | 1230 | 28 |
645360 | 645360 | 2020-10-19 | Howard | Indiana | 18067 | 1582 | 69 |
645361 | 645361 | 2020-10-19 | Huntington | Indiana | 18069 | 372 | 5 |
645362 | 645362 | 2020-10-19 | Jackson | Indiana | 18071 | 1078 | 13 |
645363 | 645363 | 2020-10-19 | Jasper | Indiana | 18073 | 548 | 5 |
645364 | 645364 | 2020-10-19 | Jay | Indiana | 18075 | 290 | 7 |
645365 | 645365 | 2020-10-19 | Jefferson | Indiana | 18077 | 329 | 5 |
645366 | 645366 | 2020-10-19 | Jennings | Indiana | 18079 | 362 | 15 |
645367 | 645367 | 2020-10-19 | Johnson | Indiana | 18081 | 3013 | 136 |
645368 | 645368 | 2020-10-19 | Knox | Indiana | 18083 | 697 | 10 |
645369 | 645369 | 2020-10-19 | Kosciusko | Indiana | 18085 | 1750 | 22 |
645370 | 645370 | 2020-10-19 | LaGrange | Indiana | 18087 | 770 | 16 |
645371 | 645371 | 2020-10-19 | LaPorte | Indiana | 18091 | 2134 | 57 |
645372 | 645372 | 2020-10-19 | Lake | Indiana | 18089 | 13139 | 368 |
645373 | 645373 | 2020-10-19 | Lawrence | Indiana | 18093 | 780 | 34 |
645374 | 645374 | 2020-10-19 | Madison | Indiana | 18095 | 2286 | 102 |
645375 | 645375 | 2020-10-19 | Marion | Indiana | 18097 | 24738 | 834 |
645376 | 645376 | 2020-10-19 | Marshall | Indiana | 18099 | 1306 | 26 |
645377 | 645377 | 2020-10-19 | Martin | Indiana | 18101 | 196 | 0 |
645378 | 645378 | 2020-10-19 | Miami | Indiana | 18103 | 580 | 5 |
645379 | 645379 | 2020-10-19 | Monroe | Indiana | 18105 | 3199 | 42 |
645380 | 645380 | 2020-10-19 | Montgomery | Indiana | 18107 | 566 | 23 |
645381 | 645381 | 2020-10-19 | Morgan | Indiana | 18109 | 928 | 43 |
645382 | 645382 | 2020-10-19 | Newton | Indiana | 18111 | 212 | 12 |
645383 | 645383 | 2020-10-19 | Noble | Indiana | 18113 | 1117 | 34 |
645384 | 645384 | 2020-10-19 | Ohio | Indiana | 18115 | 118 | 7 |
645385 | 645385 | 2020-10-19 | Orange | Indiana | 18117 | 388 | 26 |
645386 | 645386 | 2020-10-19 | Owen | Indiana | 18119 | 200 | 2 |
645387 | 645387 | 2020-10-19 | Parke | Indiana | 18121 | 231 | 2 |
645388 | 645388 | 2020-10-19 | Perry | Indiana | 18123 | 300 | 15 |
645389 | 645389 | 2020-10-19 | Pike | Indiana | 18125 | 316 | 12 |
645390 | 645390 | 2020-10-19 | Porter | Indiana | 18127 | 2943 | 50 |
645391 | 645391 | 2020-10-19 | Posey | Indiana | 18129 | 674 | 5 |
645392 | 645392 | 2020-10-19 | Pulaski | Indiana | 18131 | 145 | 1 |
645393 | 645393 | 2020-10-19 | Putnam | Indiana | 18133 | 702 | 15 |
645394 | 645394 | 2020-10-19 | Randolph | Indiana | 18135 | 376 | 8 |
645395 | 645395 | 2020-10-19 | Ripley | Indiana | 18137 | 418 | 8 |
645396 | 645396 | 2020-10-19 | Rush | Indiana | 18139 | 249 | 4 |
645397 | 645397 | 2020-10-19 | Scott | Indiana | 18143 | 512 | 15 |
645398 | 645398 | 2020-10-19 | Shelby | Indiana | 18145 | 1298 | 37 |
645399 | 645399 | 2020-10-19 | Spencer | Indiana | 18147 | 371 | 6 |
645400 | 645400 | 2020-10-19 | St. Joseph | Indiana | 18141 | 8811 | 164 |
645401 | 645401 | 2020-10-19 | Starke | Indiana | 18149 | 386 | 8 |
645402 | 645402 | 2020-10-19 | Steuben | Indiana | 18151 | 593 | 8 |
645403 | 645403 | 2020-10-19 | Sullivan | Indiana | 18153 | 428 | 12 |
645404 | 645404 | 2020-10-19 | Switzerland | Indiana | 18155 | 86 | 0 |
645405 | 645405 | 2020-10-19 | Tippecanoe | Indiana | 18157 | 3512 | 15 |
645406 | 645406 | 2020-10-19 | Tipton | Indiana | 18159 | 271 | 26 |
645407 | 645407 | 2020-10-19 | Union | Indiana | 18161 | 129 | 0 |
645408 | 645408 | 2020-10-19 | Vanderburgh | Indiana | 18163 | 5533 | 50 |
645409 | 645409 | 2020-10-19 | Vermillion | Indiana | 18165 | 212 | 1 |
645410 | 645410 | 2020-10-19 | Vigo | Indiana | 18167 | 2495 | 38 |
645411 | 645411 | 2020-10-19 | Wabash | Indiana | 18169 | 390 | 9 |
645412 | 645412 | 2020-10-19 | Warren | Indiana | 18171 | 74 | 1 |
645413 | 645413 | 2020-10-19 | Warrick | Indiana | 18173 | 1867 | 65 |
645414 | 645414 | 2020-10-19 | Washington | Indiana | 18175 | 351 | 2 |
645415 | 645415 | 2020-10-19 | Wayne | Indiana | 18177 | 1556 | 24 |
645416 | 645416 | 2020-10-19 | Wells | Indiana | 18179 | 437 | 7 |
645417 | 645417 | 2020-10-19 | White | Indiana | 18181 | 562 | 15 |
645418 | 645418 | 2020-10-19 | Whitley | Indiana | 18183 | 431 | 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);