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-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 |
---|---|---|---|---|---|---|---|
1830315 | 1830315 | 2021-10-19 | Adams | Indiana | 18001 | 4838 | 76 |
1830316 | 1830316 | 2021-10-19 | Allen | Indiana | 18003 | 57576 | 821 |
1830317 | 1830317 | 2021-10-19 | Bartholomew | Indiana | 18005 | 11541 | 185 |
1830318 | 1830318 | 2021-10-19 | Benton | Indiana | 18007 | 1502 | 17 |
1830319 | 1830319 | 2021-10-19 | Blackford | Indiana | 18009 | 1923 | 42 |
1830320 | 1830320 | 2021-10-19 | Boone | Indiana | 18011 | 8895 | 122 |
1830321 | 1830321 | 2021-10-19 | Brown | Indiana | 18013 | 1453 | 48 |
1830322 | 1830322 | 2021-10-19 | Carroll | Indiana | 18015 | 2600 | 34 |
1830323 | 1830323 | 2021-10-19 | Cass | Indiana | 18017 | 7518 | 122 |
1830324 | 1830324 | 2021-10-19 | Clark | Indiana | 18019 | 18471 | 262 |
1830325 | 1830325 | 2021-10-19 | Clay | Indiana | 18021 | 4207 | 61 |
1830326 | 1830326 | 2021-10-19 | Clinton | Indiana | 18023 | 5719 | 76 |
1830327 | 1830327 | 2021-10-19 | Crawford | Indiana | 18025 | 1590 | 24 |
1830328 | 1830328 | 2021-10-19 | Daviess | Indiana | 18027 | 4634 | 115 |
1830329 | 1830329 | 2021-10-19 | DeKalb | Indiana | 18033 | 6280 | 102 |
1830330 | 1830330 | 2021-10-19 | Dearborn | Indiana | 18029 | 8191 | 97 |
1830331 | 1830331 | 2021-10-19 | Decatur | Indiana | 18031 | 4198 | 106 |
1830332 | 1830332 | 2021-10-19 | Delaware | Indiana | 18035 | 15024 | 270 |
1830333 | 1830333 | 2021-10-19 | Dubois | Indiana | 18037 | 8241 | 132 |
1830334 | 1830334 | 2021-10-19 | Elkhart | Indiana | 18039 | 35856 | 527 |
1830335 | 1830335 | 2021-10-19 | Fayette | Indiana | 18041 | 4188 | 90 |
1830336 | 1830336 | 2021-10-19 | Floyd | Indiana | 18043 | 11051 | 220 |
1830337 | 1830337 | 2021-10-19 | Fountain | Indiana | 18045 | 3331 | 60 |
1830338 | 1830338 | 2021-10-19 | Franklin | Indiana | 18047 | 2666 | 45 |
1830339 | 1830339 | 2021-10-19 | Fulton | Indiana | 18049 | 3079 | 68 |
1830340 | 1830340 | 2021-10-19 | Gibson | Indiana | 18051 | 6539 | 117 |
1830341 | 1830341 | 2021-10-19 | Grant | Indiana | 18053 | 10407 | 226 |
1830342 | 1830342 | 2021-10-19 | Greene | Indiana | 18055 | 4233 | 100 |
1830343 | 1830343 | 2021-10-19 | Hamilton | Indiana | 18057 | 46211 | 490 |
1830344 | 1830344 | 2021-10-19 | Hancock | Indiana | 18059 | 11666 | 180 |
1830345 | 1830345 | 2021-10-19 | Harrison | Indiana | 18061 | 6463 | 94 |
1830346 | 1830346 | 2021-10-19 | Hendricks | Indiana | 18063 | 23833 | 376 |
1830347 | 1830347 | 2021-10-19 | Henry | Indiana | 18065 | 8172 | 157 |
1830348 | 1830348 | 2021-10-19 | Howard | Indiana | 18067 | 14664 | 293 |
1830349 | 1830349 | 2021-10-19 | Huntington | Indiana | 18069 | 6358 | 101 |
1830350 | 1830350 | 2021-10-19 | Jackson | Indiana | 18071 | 6951 | 90 |
1830351 | 1830351 | 2021-10-19 | Jasper | Indiana | 18073 | 5273 | 82 |
1830352 | 1830352 | 2021-10-19 | Jay | Indiana | 18075 | 2836 | 50 |
1830353 | 1830353 | 2021-10-19 | Jefferson | Indiana | 18077 | 5078 | 99 |
1830354 | 1830354 | 2021-10-19 | Jennings | Indiana | 18079 | 3856 | 62 |
1830355 | 1830355 | 2021-10-19 | Johnson | Indiana | 18081 | 25034 | 463 |
1830356 | 1830356 | 2021-10-19 | Knox | Indiana | 18083 | 6302 | 107 |
1830357 | 1830357 | 2021-10-19 | Kosciusko | Indiana | 18085 | 12255 | 152 |
1830358 | 1830358 | 2021-10-19 | LaGrange | Indiana | 18087 | 3554 | 80 |
1830359 | 1830359 | 2021-10-19 | LaPorte | Indiana | 18091 | 15089 | 253 |
1830360 | 1830360 | 2021-10-19 | Lake | Indiana | 18089 | 66185 | 1205 |
1830361 | 1830361 | 2021-10-19 | Lawrence | Indiana | 18093 | 7417 | 173 |
1830362 | 1830362 | 2021-10-19 | Madison | Indiana | 18095 | 18694 | 428 |
1830363 | 1830363 | 2021-10-19 | Marion | Indiana | 18097 | 135132 | 2194 |
1830364 | 1830364 | 2021-10-19 | Marshall | Indiana | 18099 | 7860 | 138 |
1830365 | 1830365 | 2021-10-19 | Martin | Indiana | 18101 | 1376 | 20 |
1830366 | 1830366 | 2021-10-19 | Miami | Indiana | 18103 | 5913 | 101 |
1830367 | 1830367 | 2021-10-19 | Monroe | Indiana | 18105 | 15209 | 201 |
1830368 | 1830368 | 2021-10-19 | Montgomery | Indiana | 18107 | 6218 | 111 |
1830369 | 1830369 | 2021-10-19 | Morgan | Indiana | 18109 | 9446 | 184 |
1830370 | 1830370 | 2021-10-19 | Newton | Indiana | 18111 | 1568 | 50 |
1830371 | 1830371 | 2021-10-19 | Noble | Indiana | 18113 | 7989 | 109 |
1830372 | 1830372 | 2021-10-19 | Ohio | Indiana | 18115 | 842 | 12 |
1830373 | 1830373 | 2021-10-19 | Orange | Indiana | 18117 | 2926 | 68 |
1830374 | 1830374 | 2021-10-19 | Owen | Indiana | 18119 | 3130 | 72 |
1830375 | 1830375 | 2021-10-19 | Parke | Indiana | 18121 | 2315 | 27 |
1830376 | 1830376 | 2021-10-19 | Perry | Indiana | 18123 | 2659 | 55 |
1830377 | 1830377 | 2021-10-19 | Pike | Indiana | 18125 | 2282 | 44 |
1830378 | 1830378 | 2021-10-19 | Porter | Indiana | 18127 | 22857 | 378 |
1830379 | 1830379 | 2021-10-19 | Posey | Indiana | 18129 | 3753 | 43 |
1830380 | 1830380 | 2021-10-19 | Pulaski | Indiana | 18131 | 1822 | 56 |
1830381 | 1830381 | 2021-10-19 | Putnam | Indiana | 18133 | 5774 | 81 |
1830382 | 1830382 | 2021-10-19 | Randolph | Indiana | 18135 | 3466 | 100 |
1830383 | 1830383 | 2021-10-19 | Ripley | Indiana | 18137 | 4971 | 87 |
1830384 | 1830384 | 2021-10-19 | Rush | Indiana | 18139 | 2665 | 32 |
1830385 | 1830385 | 2021-10-19 | Scott | Indiana | 18143 | 4373 | 74 |
1830386 | 1830386 | 2021-10-19 | Shelby | Indiana | 18145 | 8199 | 128 |
1830387 | 1830387 | 2021-10-19 | Spencer | Indiana | 18147 | 3378 | 42 |
1830388 | 1830388 | 2021-10-19 | St. Joseph | Indiana | 18141 | 44192 | 626 |
1830389 | 1830389 | 2021-10-19 | Starke | Indiana | 18149 | 3143 | 71 |
1830390 | 1830390 | 2021-10-19 | Steuben | Indiana | 18151 | 5577 | 77 |
1830391 | 1830391 | 2021-10-19 | Sullivan | Indiana | 18153 | 3281 | 54 |
1830392 | 1830392 | 2021-10-19 | Switzerland | Indiana | 18155 | 1344 | 11 |
1830393 | 1830393 | 2021-10-19 | Tippecanoe | Indiana | 18157 | 27834 | 262 |
1830394 | 1830394 | 2021-10-19 | Tipton | Indiana | 18159 | 2275 | 61 |
1830395 | 1830395 | 2021-10-19 | Union | Indiana | 18161 | 1098 | 17 |
1830396 | 1830396 | 2021-10-19 | Vanderburgh | Indiana | 18163 | 32135 | 489 |
1830397 | 1830397 | 2021-10-19 | Vermillion | Indiana | 18165 | 2565 | 54 |
1830398 | 1830398 | 2021-10-19 | Vigo | Indiana | 18167 | 17392 | 308 |
1830399 | 1830399 | 2021-10-19 | Wabash | Indiana | 18169 | 5293 | 103 |
1830400 | 1830400 | 2021-10-19 | Warren | Indiana | 18171 | 1209 | 18 |
1830401 | 1830401 | 2021-10-19 | Warrick | Indiana | 18173 | 11268 | 193 |
1830402 | 1830402 | 2021-10-19 | Washington | Indiana | 18175 | 3541 | 50 |
1830403 | 1830403 | 2021-10-19 | Wayne | Indiana | 18177 | 11292 | 257 |
1830404 | 1830404 | 2021-10-19 | Wells | Indiana | 18179 | 4242 | 90 |
1830405 | 1830405 | 2021-10-19 | White | Indiana | 18181 | 4171 | 66 |
1830406 | 1830406 | 2021-10-19 | Whitley | Indiana | 18183 | 5616 | 56 |
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);