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 2021-01-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 |
---|---|---|---|---|---|---|---|
963330 | 963330 | 2021-01-25 | Adams | Indiana | 18001 | 3029 | 37 |
963331 | 963331 | 2021-01-25 | Allen | Indiana | 18003 | 33029 | 575 |
963332 | 963332 | 2021-01-25 | Bartholomew | Indiana | 18005 | 6659 | 106 |
963333 | 963333 | 2021-01-25 | Benton | Indiana | 18007 | 871 | 10 |
963334 | 963334 | 2021-01-25 | Blackford | Indiana | 18009 | 1129 | 22 |
963335 | 963335 | 2021-01-25 | Boone | Indiana | 18011 | 5583 | 72 |
963336 | 963336 | 2021-01-25 | Brown | Indiana | 18013 | 883 | 35 |
963337 | 963337 | 2021-01-25 | Carroll | Indiana | 18015 | 1598 | 16 |
963338 | 963338 | 2021-01-25 | Cass | Indiana | 18017 | 4872 | 65 |
963339 | 963339 | 2021-01-25 | Clark | Indiana | 18019 | 10832 | 152 |
963340 | 963340 | 2021-01-25 | Clay | Indiana | 18021 | 2243 | 32 |
963341 | 963341 | 2021-01-25 | Clinton | Indiana | 18023 | 3754 | 48 |
963342 | 963342 | 2021-01-25 | Crawford | Indiana | 18025 | 811 | 10 |
963343 | 963343 | 2021-01-25 | Daviess | Indiana | 18027 | 2720 | 77 |
963344 | 963344 | 2021-01-25 | DeKalb | Indiana | 18033 | 3503 | 68 |
963345 | 963345 | 2021-01-25 | Dearborn | Indiana | 18029 | 4873 | 47 |
963346 | 963346 | 2021-01-25 | Decatur | Indiana | 18031 | 2547 | 87 |
963347 | 963347 | 2021-01-25 | Delaware | Indiana | 18035 | 9182 | 138 |
963348 | 963348 | 2021-01-25 | Dubois | Indiana | 18037 | 5587 | 81 |
963349 | 963349 | 2021-01-25 | Elkhart | Indiana | 18039 | 24576 | 357 |
963350 | 963350 | 2021-01-25 | Fayette | Indiana | 18041 | 2620 | 49 |
963351 | 963351 | 2021-01-25 | Floyd | Indiana | 18043 | 6518 | 115 |
963352 | 963352 | 2021-01-25 | Fountain | Indiana | 18045 | 1851 | 28 |
963353 | 963353 | 2021-01-25 | Franklin | Indiana | 18047 | 1510 | 34 |
963354 | 963354 | 2021-01-25 | Fulton | Indiana | 18049 | 1649 | 30 |
963355 | 963355 | 2021-01-25 | Gibson | Indiana | 18051 | 3748 | 61 |
963356 | 963356 | 2021-01-25 | Grant | Indiana | 18053 | 6437 | 121 |
963357 | 963357 | 2021-01-25 | Greene | Indiana | 18055 | 2430 | 65 |
963358 | 963358 | 2021-01-25 | Hamilton | Indiana | 18057 | 29691 | 330 |
963359 | 963359 | 2021-01-25 | Hancock | Indiana | 18059 | 6804 | 107 |
963360 | 963360 | 2021-01-25 | Harrison | Indiana | 18061 | 3533 | 47 |
963361 | 963361 | 2021-01-25 | Hendricks | Indiana | 18063 | 14538 | 270 |
963362 | 963362 | 2021-01-25 | Henry | Indiana | 18065 | 5128 | 65 |
963363 | 963363 | 2021-01-25 | Howard | Indiana | 18067 | 8302 | 147 |
963364 | 963364 | 2021-01-25 | Huntington | Indiana | 18069 | 2951 | 60 |
963365 | 963365 | 2021-01-25 | Jackson | Indiana | 18071 | 4281 | 48 |
963366 | 963366 | 2021-01-25 | Jasper | Indiana | 18073 | 2921 | 36 |
963367 | 963367 | 2021-01-25 | Jay | Indiana | 18075 | 1695 | 25 |
963368 | 963368 | 2021-01-25 | Jefferson | Indiana | 18077 | 2666 | 42 |
963369 | 963369 | 2021-01-25 | Jennings | Indiana | 18079 | 2010 | 38 |
963370 | 963370 | 2021-01-25 | Johnson | Indiana | 18081 | 15248 | 306 |
963371 | 963371 | 2021-01-25 | Knox | Indiana | 18083 | 3365 | 39 |
963372 | 963372 | 2021-01-25 | Kosciusko | Indiana | 18085 | 8120 | 86 |
963373 | 963373 | 2021-01-25 | LaGrange | Indiana | 18087 | 2305 | 63 |
963374 | 963374 | 2021-01-25 | LaPorte | Indiana | 18091 | 9154 | 167 |
963375 | 963375 | 2021-01-25 | Lake | Indiana | 18089 | 45746 | 715 |
963376 | 963376 | 2021-01-25 | Lawrence | Indiana | 18093 | 3940 | 83 |
963377 | 963377 | 2021-01-25 | Madison | Indiana | 18095 | 11072 | 239 |
963378 | 963378 | 2021-01-25 | Marion | Indiana | 18097 | 84884 | 1401 |
963379 | 963379 | 2021-01-25 | Marshall | Indiana | 18099 | 5071 | 84 |
963380 | 963380 | 2021-01-25 | Martin | Indiana | 18101 | 750 | 13 |
963381 | 963381 | 2021-01-25 | Miami | Indiana | 18103 | 3251 | 45 |
963382 | 963382 | 2021-01-25 | Monroe | Indiana | 18105 | 9463 | 117 |
963383 | 963383 | 2021-01-25 | Montgomery | Indiana | 18107 | 3478 | 55 |
963384 | 963384 | 2021-01-25 | Morgan | Indiana | 18109 | 5501 | 100 |
963385 | 963385 | 2021-01-25 | Newton | Indiana | 18111 | 922 | 23 |
963386 | 963386 | 2021-01-25 | Noble | Indiana | 18113 | 4760 | 62 |
963387 | 963387 | 2021-01-25 | Ohio | Indiana | 18115 | 497 | 7 |
963388 | 963388 | 2021-01-25 | Orange | Indiana | 18117 | 1612 | 37 |
963389 | 963389 | 2021-01-25 | Owen | Indiana | 18119 | 1679 | 39 |
963390 | 963390 | 2021-01-25 | Parke | Indiana | 18121 | 1322 | 8 |
963391 | 963391 | 2021-01-25 | Perry | Indiana | 18123 | 1569 | 30 |
963392 | 963392 | 2021-01-25 | Pike | Indiana | 18125 | 1187 | 28 |
963393 | 963393 | 2021-01-25 | Porter | Indiana | 18127 | 14967 | 182 |
963394 | 963394 | 2021-01-25 | Posey | Indiana | 18129 | 2410 | 28 |
963395 | 963395 | 2021-01-25 | Pulaski | Indiana | 18131 | 979 | 37 |
963396 | 963396 | 2021-01-25 | Putnam | Indiana | 18133 | 2998 | 50 |
963397 | 963397 | 2021-01-25 | Randolph | Indiana | 18135 | 2194 | 49 |
963398 | 963398 | 2021-01-25 | Ripley | Indiana | 18137 | 3007 | 46 |
963399 | 963399 | 2021-01-25 | Rush | Indiana | 18139 | 1624 | 18 |
963400 | 963400 | 2021-01-25 | Scott | Indiana | 18143 | 2275 | 41 |
963401 | 963401 | 2021-01-25 | Shelby | Indiana | 18145 | 5079 | 91 |
963402 | 963402 | 2021-01-25 | Spencer | Indiana | 18147 | 1933 | 22 |
963403 | 963403 | 2021-01-25 | St. Joseph | Indiana | 18141 | 27566 | 402 |
963404 | 963404 | 2021-01-25 | Starke | Indiana | 18149 | 1768 | 47 |
963405 | 963405 | 2021-01-25 | Steuben | Indiana | 18151 | 3155 | 47 |
963406 | 963406 | 2021-01-25 | Sullivan | Indiana | 18153 | 1939 | 33 |
963407 | 963407 | 2021-01-25 | Switzerland | Indiana | 18155 | 670 | 5 |
963408 | 963408 | 2021-01-25 | Tippecanoe | Indiana | 18157 | 18112 | 142 |
963409 | 963409 | 2021-01-25 | Tipton | Indiana | 18159 | 1336 | 36 |
963410 | 963410 | 2021-01-25 | Union | Indiana | 18161 | 656 | 7 |
963411 | 963411 | 2021-01-25 | Vanderburgh | Indiana | 18163 | 19618 | 254 |
963412 | 963412 | 2021-01-25 | Vermillion | Indiana | 18165 | 1498 | 34 |
963413 | 963413 | 2021-01-25 | Vigo | Indiana | 18167 | 10807 | 186 |
963414 | 963414 | 2021-01-25 | Wabash | Indiana | 18169 | 3063 | 51 |
963415 | 963415 | 2021-01-25 | Warren | Indiana | 18171 | 687 | 8 |
963416 | 963416 | 2021-01-25 | Warrick | Indiana | 18173 | 6804 | 101 |
963417 | 963417 | 2021-01-25 | Washington | Indiana | 18175 | 1880 | 23 |
963418 | 963418 | 2021-01-25 | Wayne | Indiana | 18177 | 6569 | 165 |
963419 | 963419 | 2021-01-25 | Wells | Indiana | 18179 | 2394 | 54 |
963420 | 963420 | 2021-01-25 | White | Indiana | 18181 | 2751 | 43 |
963421 | 963421 | 2021-01-25 | Whitley | Indiana | 18183 | 3111 | 26 |
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);