ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-04-12" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1213302 | 1213302 | 2021-04-12 | Adams | Indiana | 18001 | 3432 | 53 |
1213303 | 1213303 | 2021-04-12 | Allen | Indiana | 18003 | 38741 | 691 |
1213304 | 1213304 | 2021-04-12 | Bartholomew | Indiana | 18005 | 7839 | 158 |
1213305 | 1213305 | 2021-04-12 | Benton | Indiana | 18007 | 952 | 13 |
1213306 | 1213306 | 2021-04-12 | Blackford | Indiana | 18009 | 1335 | 30 |
1213307 | 1213307 | 2021-04-12 | Boone | Indiana | 18011 | 6513 | 103 |
1213308 | 1213308 | 2021-04-12 | Brown | Indiana | 18013 | 990 | 40 |
1213309 | 1213309 | 2021-04-12 | Carroll | Indiana | 18015 | 1850 | 22 |
1213310 | 1213310 | 2021-04-12 | Cass | Indiana | 18017 | 5664 | 103 |
1213311 | 1213311 | 2021-04-12 | Clark | Indiana | 18019 | 12635 | 199 |
1213312 | 1213312 | 2021-04-12 | Clay | Indiana | 18021 | 2512 | 44 |
1213313 | 1213313 | 2021-04-12 | Clinton | Indiana | 18023 | 4147 | 58 |
1213314 | 1213314 | 2021-04-12 | Crawford | Indiana | 18025 | 970 | 15 |
1213315 | 1213315 | 2021-04-12 | Daviess | Indiana | 18027 | 2883 | 101 |
1213316 | 1213316 | 2021-04-12 | DeKalb | Indiana | 18033 | 4050 | 86 |
1213317 | 1213317 | 2021-04-12 | Dearborn | Indiana | 18029 | 5667 | 78 |
1213318 | 1213318 | 2021-04-12 | Decatur | Indiana | 18031 | 2841 | 96 |
1213319 | 1213319 | 2021-04-12 | Delaware | Indiana | 18035 | 10277 | 189 |
1213320 | 1213320 | 2021-04-12 | Dubois | Indiana | 18037 | 6059 | 118 |
1213321 | 1213321 | 2021-04-12 | Elkhart | Indiana | 18039 | 27010 | 446 |
1213322 | 1213322 | 2021-04-12 | Fayette | Indiana | 18041 | 2905 | 64 |
1213323 | 1213323 | 2021-04-12 | Floyd | Indiana | 18043 | 7530 | 180 |
1213324 | 1213324 | 2021-04-12 | Fountain | Indiana | 18045 | 2074 | 46 |
1213325 | 1213325 | 2021-04-12 | Franklin | Indiana | 18047 | 1667 | 36 |
1213326 | 1213326 | 2021-04-12 | Fulton | Indiana | 18049 | 1894 | 39 |
1213327 | 1213327 | 2021-04-12 | Gibson | Indiana | 18051 | 4263 | 91 |
1213328 | 1213328 | 2021-04-12 | Grant | Indiana | 18053 | 7157 | 174 |
1213329 | 1213329 | 2021-04-12 | Greene | Indiana | 18055 | 2697 | 89 |
1213330 | 1213330 | 2021-04-12 | Hamilton | Indiana | 18057 | 34134 | 423 |
1213331 | 1213331 | 2021-04-12 | Hancock | Indiana | 18059 | 7903 | 143 |
1213332 | 1213332 | 2021-04-12 | Harrison | Indiana | 18061 | 4260 | 72 |
1213333 | 1213333 | 2021-04-12 | Hendricks | Indiana | 18063 | 16732 | 329 |
1213334 | 1213334 | 2021-04-12 | Henry | Indiana | 18065 | 5563 | 102 |
1213335 | 1213335 | 2021-04-12 | Howard | Indiana | 18067 | 9594 | 215 |
1213336 | 1213336 | 2021-04-12 | Huntington | Indiana | 18069 | 3746 | 82 |
1213337 | 1213337 | 2021-04-12 | Jackson | Indiana | 18071 | 4905 | 70 |
1213338 | 1213338 | 2021-04-12 | Jasper | Indiana | 18073 | 3433 | 48 |
1213339 | 1213339 | 2021-04-12 | Jay | Indiana | 18075 | 1861 | 31 |
1213340 | 1213340 | 2021-04-12 | Jefferson | Indiana | 18077 | 3071 | 79 |
1213341 | 1213341 | 2021-04-12 | Jennings | Indiana | 18079 | 2245 | 49 |
1213342 | 1213342 | 2021-04-12 | Johnson | Indiana | 18081 | 17435 | 387 |
1213343 | 1213343 | 2021-04-12 | Knox | Indiana | 18083 | 3647 | 89 |
1213344 | 1213344 | 2021-04-12 | Kosciusko | Indiana | 18085 | 9042 | 116 |
1213345 | 1213345 | 2021-04-12 | LaGrange | Indiana | 18087 | 2507 | 72 |
1213346 | 1213346 | 2021-04-12 | LaPorte | Indiana | 18091 | 10692 | 206 |
1213347 | 1213347 | 2021-04-12 | Lake | Indiana | 18089 | 51049 | 972 |
1213348 | 1213348 | 2021-04-12 | Lawrence | Indiana | 18093 | 4311 | 121 |
1213349 | 1213349 | 2021-04-12 | Madison | Indiana | 18095 | 12286 | 354 |
1213350 | 1213350 | 2021-04-12 | Marion | Indiana | 18097 | 95711 | 1769 |
1213351 | 1213351 | 2021-04-12 | Marshall | Indiana | 18099 | 5727 | 109 |
1213352 | 1213352 | 2021-04-12 | Martin | Indiana | 18101 | 823 | 15 |
1213353 | 1213353 | 2021-04-12 | Miami | Indiana | 18103 | 3708 | 66 |
1213354 | 1213354 | 2021-04-12 | Monroe | Indiana | 18105 | 11287 | 168 |
1213355 | 1213355 | 2021-04-12 | Montgomery | Indiana | 18107 | 4156 | 87 |
1213356 | 1213356 | 2021-04-12 | Morgan | Indiana | 18109 | 6372 | 142 |
1213357 | 1213357 | 2021-04-12 | Newton | Indiana | 18111 | 1029 | 36 |
1213358 | 1213358 | 2021-04-12 | Noble | Indiana | 18113 | 5353 | 86 |
1213359 | 1213359 | 2021-04-12 | Ohio | Indiana | 18115 | 554 | 11 |
1213360 | 1213360 | 2021-04-12 | Orange | Indiana | 18117 | 1762 | 55 |
1213361 | 1213361 | 2021-04-12 | Owen | Indiana | 18119 | 1913 | 58 |
1213362 | 1213362 | 2021-04-12 | Parke | Indiana | 18121 | 1450 | 16 |
1213363 | 1213363 | 2021-04-12 | Perry | Indiana | 18123 | 1798 | 37 |
1213364 | 1213364 | 2021-04-12 | Pike | Indiana | 18125 | 1298 | 34 |
1213365 | 1213365 | 2021-04-12 | Porter | Indiana | 18127 | 17111 | 308 |
1213366 | 1213366 | 2021-04-12 | Posey | Indiana | 18129 | 2677 | 33 |
1213367 | 1213367 | 2021-04-12 | Pulaski | Indiana | 18131 | 1128 | 45 |
1213368 | 1213368 | 2021-04-12 | Putnam | Indiana | 18133 | 3522 | 60 |
1213369 | 1213369 | 2021-04-12 | Randolph | Indiana | 18135 | 2380 | 80 |
1213370 | 1213370 | 2021-04-12 | Ripley | Indiana | 18137 | 3332 | 68 |
1213371 | 1213371 | 2021-04-12 | Rush | Indiana | 18139 | 1764 | 24 |
1213372 | 1213372 | 2021-04-12 | Scott | Indiana | 18143 | 2594 | 55 |
1213373 | 1213373 | 2021-04-12 | Shelby | Indiana | 18145 | 5718 | 105 |
1213374 | 1213374 | 2021-04-12 | Spencer | Indiana | 18147 | 2274 | 31 |
1213375 | 1213375 | 2021-04-12 | St. Joseph | Indiana | 18141 | 33519 | 554 |
1213376 | 1213376 | 2021-04-12 | Starke | Indiana | 18149 | 2003 | 54 |
1213377 | 1213377 | 2021-04-12 | Steuben | Indiana | 18151 | 3607 | 59 |
1213378 | 1213378 | 2021-04-12 | Sullivan | Indiana | 18153 | 2075 | 41 |
1213379 | 1213379 | 2021-04-12 | Switzerland | Indiana | 18155 | 770 | 8 |
1213380 | 1213380 | 2021-04-12 | Tippecanoe | Indiana | 18157 | 21537 | 214 |
1213381 | 1213381 | 2021-04-12 | Tipton | Indiana | 18159 | 1611 | 45 |
1213382 | 1213382 | 2021-04-12 | Union | Indiana | 18161 | 723 | 11 |
1213383 | 1213383 | 2021-04-12 | Vanderburgh | Indiana | 18163 | 21969 | 398 |
1213384 | 1213384 | 2021-04-12 | Vermillion | Indiana | 18165 | 1657 | 43 |
1213385 | 1213385 | 2021-04-12 | Vigo | Indiana | 18167 | 12127 | 248 |
1213386 | 1213386 | 2021-04-12 | Wabash | Indiana | 18169 | 3457 | 77 |
1213387 | 1213387 | 2021-04-12 | Warren | Indiana | 18171 | 790 | 16 |
1213388 | 1213388 | 2021-04-12 | Warrick | Indiana | 18173 | 7667 | 158 |
1213389 | 1213389 | 2021-04-12 | Washington | Indiana | 18175 | 2293 | 29 |
1213390 | 1213390 | 2021-04-12 | Wayne | Indiana | 18177 | 7238 | 200 |
1213391 | 1213391 | 2021-04-12 | Wells | Indiana | 18179 | 2865 | 82 |
1213392 | 1213392 | 2021-04-12 | White | Indiana | 18181 | 3066 | 55 |
1213393 | 1213393 | 2021-04-12 | Whitley | Indiana | 18183 | 3733 | 39 |
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);