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-09-01 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1674367 | 1674367 | 2021-09-01 | Adams | Indiana | 18001 | 4167 | 64 |
1674368 | 1674368 | 2021-09-01 | Allen | Indiana | 18003 | 49183 | 745 |
1674369 | 1674369 | 2021-09-01 | Bartholomew | Indiana | 18005 | 9432 | 166 |
1674370 | 1674370 | 2021-09-01 | Benton | Indiana | 18007 | 1268 | 15 |
1674371 | 1674371 | 2021-09-01 | Blackford | Indiana | 18009 | 1528 | 34 |
1674372 | 1674372 | 2021-09-01 | Boone | Indiana | 18011 | 7844 | 114 |
1674373 | 1674373 | 2021-09-01 | Brown | Indiana | 18013 | 1232 | 45 |
1674374 | 1674374 | 2021-09-01 | Carroll | Indiana | 18015 | 2250 | 27 |
1674375 | 1674375 | 2021-09-01 | Cass | Indiana | 18017 | 6635 | 118 |
1674376 | 1674376 | 2021-09-01 | Clark | Indiana | 18019 | 16036 | 220 |
1674377 | 1674377 | 2021-09-01 | Clay | Indiana | 18021 | 3411 | 51 |
1674378 | 1674378 | 2021-09-01 | Clinton | Indiana | 18023 | 5024 | 65 |
1674379 | 1674379 | 2021-09-01 | Crawford | Indiana | 18025 | 1289 | 19 |
1674380 | 1674380 | 2021-09-01 | Daviess | Indiana | 18027 | 3624 | 104 |
1674381 | 1674381 | 2021-09-01 | DeKalb | Indiana | 18033 | 5186 | 92 |
1674382 | 1674382 | 2021-09-01 | Dearborn | Indiana | 18029 | 6826 | 87 |
1674383 | 1674383 | 2021-09-01 | Decatur | Indiana | 18031 | 3516 | 98 |
1674384 | 1674384 | 2021-09-01 | Delaware | Indiana | 18035 | 12557 | 212 |
1674385 | 1674385 | 2021-09-01 | Dubois | Indiana | 18037 | 7005 | 120 |
1674386 | 1674386 | 2021-09-01 | Elkhart | Indiana | 18039 | 31429 | 495 |
1674387 | 1674387 | 2021-09-01 | Fayette | Indiana | 18041 | 3414 | 69 |
1674388 | 1674388 | 2021-09-01 | Floyd | Indiana | 18043 | 9442 | 197 |
1674389 | 1674389 | 2021-09-01 | Fountain | Indiana | 18045 | 2756 | 54 |
1674390 | 1674390 | 2021-09-01 | Franklin | Indiana | 18047 | 2040 | 36 |
1674391 | 1674391 | 2021-09-01 | Fulton | Indiana | 18049 | 2389 | 48 |
1674392 | 1674392 | 2021-09-01 | Gibson | Indiana | 18051 | 5557 | 105 |
1674393 | 1674393 | 2021-09-01 | Grant | Indiana | 18053 | 8661 | 195 |
1674394 | 1674394 | 2021-09-01 | Greene | Indiana | 18055 | 3428 | 90 |
1674395 | 1674395 | 2021-09-01 | Hamilton | Indiana | 18057 | 40992 | 453 |
1674396 | 1674396 | 2021-09-01 | Hancock | Indiana | 18059 | 9904 | 158 |
1674397 | 1674397 | 2021-09-01 | Harrison | Indiana | 18061 | 5428 | 82 |
1674398 | 1674398 | 2021-09-01 | Hendricks | Indiana | 18063 | 20392 | 352 |
1674399 | 1674399 | 2021-09-01 | Henry | Indiana | 18065 | 6884 | 122 |
1674400 | 1674400 | 2021-09-01 | Howard | Indiana | 18067 | 12538 | 253 |
1674401 | 1674401 | 2021-09-01 | Huntington | Indiana | 18069 | 5522 | 89 |
1674402 | 1674402 | 2021-09-01 | Jackson | Indiana | 18071 | 5979 | 80 |
1674403 | 1674403 | 2021-09-01 | Jasper | Indiana | 18073 | 4358 | 61 |
1674404 | 1674404 | 2021-09-01 | Jay | Indiana | 18075 | 2322 | 36 |
1674405 | 1674405 | 2021-09-01 | Jefferson | Indiana | 18077 | 4189 | 91 |
1674406 | 1674406 | 2021-09-01 | Jennings | Indiana | 18079 | 3042 | 54 |
1674407 | 1674407 | 2021-09-01 | Johnson | Indiana | 18081 | 21770 | 422 |
1674408 | 1674408 | 2021-09-01 | Knox | Indiana | 18083 | 4980 | 96 |
1674409 | 1674409 | 2021-09-01 | Kosciusko | Indiana | 18085 | 10542 | 134 |
1674410 | 1674410 | 2021-09-01 | LaGrange | Indiana | 18087 | 2918 | 75 |
1674411 | 1674411 | 2021-09-01 | LaPorte | Indiana | 18091 | 13374 | 231 |
1674412 | 1674412 | 2021-09-01 | Lake | Indiana | 18089 | 60258 | 1102 |
1674413 | 1674413 | 2021-09-01 | Lawrence | Indiana | 18093 | 6301 | 142 |
1674414 | 1674414 | 2021-09-01 | Madison | Indiana | 18095 | 15819 | 384 |
1674415 | 1674415 | 2021-09-01 | Marion | Indiana | 18097 | 118404 | 1952 |
1674416 | 1674416 | 2021-09-01 | Marshall | Indiana | 18099 | 6841 | 124 |
1674417 | 1674417 | 2021-09-01 | Martin | Indiana | 18101 | 1108 | 15 |
1674418 | 1674418 | 2021-09-01 | Miami | Indiana | 18103 | 4811 | 78 |
1674419 | 1674419 | 2021-09-01 | Monroe | Indiana | 18105 | 13620 | 190 |
1674420 | 1674420 | 2021-09-01 | Montgomery | Indiana | 18107 | 5258 | 98 |
1674421 | 1674421 | 2021-09-01 | Morgan | Indiana | 18109 | 8020 | 157 |
1674422 | 1674422 | 2021-09-01 | Newton | Indiana | 18111 | 1296 | 42 |
1674423 | 1674423 | 2021-09-01 | Noble | Indiana | 18113 | 6767 | 101 |
1674424 | 1674424 | 2021-09-01 | Ohio | Indiana | 18115 | 701 | 11 |
1674425 | 1674425 | 2021-09-01 | Orange | Indiana | 18117 | 2522 | 60 |
1674426 | 1674426 | 2021-09-01 | Owen | Indiana | 18119 | 2581 | 63 |
1674427 | 1674427 | 2021-09-01 | Parke | Indiana | 18121 | 1932 | 18 |
1674428 | 1674428 | 2021-09-01 | Perry | Indiana | 18123 | 2292 | 45 |
1674429 | 1674429 | 2021-09-01 | Pike | Indiana | 18125 | 1750 | 35 |
1674430 | 1674430 | 2021-09-01 | Porter | Indiana | 18127 | 20633 | 346 |
1674431 | 1674431 | 2021-09-01 | Posey | Indiana | 18129 | 3305 | 38 |
1674432 | 1674432 | 2021-09-01 | Pulaski | Indiana | 18131 | 1413 | 50 |
1674433 | 1674433 | 2021-09-01 | Putnam | Indiana | 18133 | 4777 | 68 |
1674434 | 1674434 | 2021-09-01 | Randolph | Indiana | 18135 | 2805 | 85 |
1674435 | 1674435 | 2021-09-01 | Ripley | Indiana | 18137 | 4011 | 72 |
1674436 | 1674436 | 2021-09-01 | Rush | Indiana | 18139 | 2046 | 27 |
1674437 | 1674437 | 2021-09-01 | Scott | Indiana | 18143 | 3557 | 63 |
1674438 | 1674438 | 2021-09-01 | Shelby | Indiana | 18145 | 6863 | 110 |
1674439 | 1674439 | 2021-09-01 | Spencer | Indiana | 18147 | 2886 | 32 |
1674440 | 1674440 | 2021-09-01 | St. Joseph | Indiana | 18141 | 39603 | 595 |
1674441 | 1674441 | 2021-09-01 | Starke | Indiana | 18149 | 2518 | 62 |
1674442 | 1674442 | 2021-09-01 | Steuben | Indiana | 18151 | 4565 | 66 |
1674443 | 1674443 | 2021-09-01 | Sullivan | Indiana | 18153 | 2665 | 47 |
1674444 | 1674444 | 2021-09-01 | Switzerland | Indiana | 18155 | 1075 | 9 |
1674445 | 1674445 | 2021-09-01 | Tippecanoe | Indiana | 18157 | 25542 | 240 |
1674446 | 1674446 | 2021-09-01 | Tipton | Indiana | 18159 | 1948 | 53 |
1674447 | 1674447 | 2021-09-01 | Union | Indiana | 18161 | 878 | 11 |
1674448 | 1674448 | 2021-09-01 | Vanderburgh | Indiana | 18163 | 27610 | 426 |
1674449 | 1674449 | 2021-09-01 | Vermillion | Indiana | 18165 | 2094 | 47 |
1674450 | 1674450 | 2021-09-01 | Vigo | Indiana | 18167 | 14387 | 268 |
1674451 | 1674451 | 2021-09-01 | Wabash | Indiana | 18169 | 4371 | 86 |
1674452 | 1674452 | 2021-09-01 | Warren | Indiana | 18171 | 1026 | 18 |
1674453 | 1674453 | 2021-09-01 | Warrick | Indiana | 18173 | 9648 | 169 |
1674454 | 1674454 | 2021-09-01 | Washington | Indiana | 18175 | 2981 | 43 |
1674455 | 1674455 | 2021-09-01 | Wayne | Indiana | 18177 | 8970 | 209 |
1674456 | 1674456 | 2021-09-01 | Wells | Indiana | 18179 | 3501 | 84 |
1674457 | 1674457 | 2021-09-01 | White | Indiana | 18181 | 3665 | 57 |
1674458 | 1674458 | 2021-09-01 | Whitley | Indiana | 18183 | 4785 | 48 |
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);