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 2022-02-15 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217186 | 2217186 | 2022-02-15 | Adams | Indiana | 18001 | 7288 | 110 |
2217187 | 2217187 | 2022-02-15 | Allen | Indiana | 18003 | 102658 | 1122 |
2217188 | 2217188 | 2022-02-15 | Bartholomew | Indiana | 18005 | 21082 | 240 |
2217189 | 2217189 | 2022-02-15 | Benton | Indiana | 18007 | 2439 | 21 |
2217190 | 2217190 | 2022-02-15 | Blackford | Indiana | 18009 | 3078 | 66 |
2217191 | 2217191 | 2022-02-15 | Boone | Indiana | 18011 | 14934 | 164 |
2217192 | 2217192 | 2022-02-15 | Brown | Indiana | 18013 | 2565 | 61 |
2217193 | 2217193 | 2022-02-15 | Carroll | Indiana | 18015 | 4176 | 62 |
2217194 | 2217194 | 2022-02-15 | Cass | Indiana | 18017 | 11377 | 155 |
2217195 | 2217195 | 2022-02-15 | Clark | Indiana | 18019 | 30401 | 373 |
2217196 | 2217196 | 2022-02-15 | Clay | Indiana | 18021 | 6764 | 82 |
2217197 | 2217197 | 2022-02-15 | Clinton | Indiana | 18023 | 9094 | 113 |
2217198 | 2217198 | 2022-02-15 | Crawford | Indiana | 18025 | 2482 | 35 |
2217199 | 2217199 | 2022-02-15 | Daviess | Indiana | 18027 | 7395 | 144 |
2217200 | 2217200 | 2022-02-15 | DeKalb | Indiana | 18033 | 11241 | 145 |
2217201 | 2217201 | 2022-02-15 | Dearborn | Indiana | 18029 | 13256 | 125 |
2217202 | 2217202 | 2022-02-15 | Decatur | Indiana | 18031 | 6987 | 138 |
2217203 | 2217203 | 2022-02-15 | Delaware | Indiana | 18035 | 24336 | 418 |
2217204 | 2217204 | 2022-02-15 | Dubois | Indiana | 18037 | 12712 | 159 |
2217205 | 2217205 | 2022-02-15 | Elkhart | Indiana | 18039 | 53752 | 707 |
2217206 | 2217206 | 2022-02-15 | Fayette | Indiana | 18041 | 6789 | 140 |
2217207 | 2217207 | 2022-02-15 | Floyd | Indiana | 18043 | 18495 | 279 |
2217208 | 2217208 | 2022-02-15 | Fountain | Indiana | 18045 | 5286 | 95 |
2217209 | 2217209 | 2022-02-15 | Franklin | Indiana | 18047 | 4342 | 61 |
2217210 | 2217210 | 2022-02-15 | Fulton | Indiana | 18049 | 4830 | 101 |
2217211 | 2217211 | 2022-02-15 | Gibson | Indiana | 18051 | 11480 | 136 |
2217212 | 2217212 | 2022-02-15 | Grant | Indiana | 18053 | 17515 | 334 |
2217213 | 2217213 | 2022-02-15 | Greene | Indiana | 18055 | 7088 | 130 |
2217214 | 2217214 | 2022-02-15 | Hamilton | Indiana | 18057 | 80521 | 623 |
2217215 | 2217215 | 2022-02-15 | Hancock | Indiana | 18059 | 20471 | 249 |
2217216 | 2217216 | 2022-02-15 | Harrison | Indiana | 18061 | 10581 | 130 |
2217217 | 2217217 | 2022-02-15 | Hendricks | Indiana | 18063 | 40333 | 526 |
2217218 | 2217218 | 2022-02-15 | Henry | Indiana | 18065 | 12797 | 219 |
2217219 | 2217219 | 2022-02-15 | Howard | Indiana | 18067 | 25111 | 426 |
2217220 | 2217220 | 2022-02-15 | Huntington | Indiana | 18069 | 11363 | 149 |
2217221 | 2217221 | 2022-02-15 | Jackson | Indiana | 18071 | 12329 | 119 |
2217222 | 2217222 | 2022-02-15 | Jasper | Indiana | 18073 | 8906 | 138 |
2217223 | 2217223 | 2022-02-15 | Jay | Indiana | 18075 | 4801 | 76 |
2217224 | 2217224 | 2022-02-15 | Jefferson | Indiana | 18077 | 9268 | 142 |
2217225 | 2217225 | 2022-02-15 | Jennings | Indiana | 18079 | 6865 | 99 |
2217226 | 2217226 | 2022-02-15 | Johnson | Indiana | 18081 | 41944 | 580 |
2217227 | 2217227 | 2022-02-15 | Knox | Indiana | 18083 | 10577 | 139 |
2217228 | 2217228 | 2022-02-15 | Kosciusko | Indiana | 18085 | 19553 | 223 |
2217229 | 2217229 | 2022-02-15 | LaGrange | Indiana | 18087 | 5817 | 100 |
2217230 | 2217230 | 2022-02-15 | LaPorte | Indiana | 18091 | 25128 | 348 |
2217231 | 2217231 | 2022-02-15 | Lake | Indiana | 18089 | 105055 | 1739 |
2217232 | 2217232 | 2022-02-15 | Lawrence | Indiana | 18093 | 11696 | 240 |
2217233 | 2217233 | 2022-02-15 | Madison | Indiana | 18095 | 32272 | 622 |
2217234 | 2217234 | 2022-02-15 | Marion | Indiana | 18097 | 222403 | 2852 |
2217235 | 2217235 | 2022-02-15 | Marshall | Indiana | 18099 | 12229 | 189 |
2217236 | 2217236 | 2022-02-15 | Martin | Indiana | 18101 | 2147 | 24 |
2217237 | 2217237 | 2022-02-15 | Miami | Indiana | 18103 | 9152 | 149 |
2217238 | 2217238 | 2022-02-15 | Monroe | Indiana | 18105 | 27036 | 262 |
2217239 | 2217239 | 2022-02-15 | Montgomery | Indiana | 18107 | 10522 | 156 |
2217240 | 2217240 | 2022-02-15 | Morgan | Indiana | 18109 | 16277 | 268 |
2217241 | 2217241 | 2022-02-15 | Newton | Indiana | 18111 | 2525 | 66 |
2217242 | 2217242 | 2022-02-15 | Noble | Indiana | 18113 | 12930 | 151 |
2217243 | 2217243 | 2022-02-15 | Ohio | Indiana | 18115 | 1434 | 17 |
2217244 | 2217244 | 2022-02-15 | Orange | Indiana | 18117 | 4974 | 92 |
2217245 | 2217245 | 2022-02-15 | Owen | Indiana | 18119 | 5739 | 111 |
2217246 | 2217246 | 2022-02-15 | Parke | Indiana | 18121 | 3579 | 44 |
2217247 | 2217247 | 2022-02-15 | Perry | Indiana | 18123 | 4592 | 64 |
2217248 | 2217248 | 2022-02-15 | Pike | Indiana | 18125 | 3677 | 48 |
2217249 | 2217249 | 2022-02-15 | Porter | Indiana | 18127 | 36890 | 539 |
2217250 | 2217250 | 2022-02-15 | Posey | Indiana | 18129 | 6445 | 53 |
2217251 | 2217251 | 2022-02-15 | Pulaski | Indiana | 18131 | 3022 | 83 |
2217252 | 2217252 | 2022-02-15 | Putnam | Indiana | 18133 | 9188 | 115 |
2217253 | 2217253 | 2022-02-15 | Randolph | Indiana | 18135 | 5848 | 140 |
2217254 | 2217254 | 2022-02-15 | Ripley | Indiana | 18137 | 8201 | 129 |
2217255 | 2217255 | 2022-02-15 | Rush | Indiana | 18139 | 4837 | 51 |
2217256 | 2217256 | 2022-02-15 | Scott | Indiana | 18143 | 7723 | 97 |
2217257 | 2217257 | 2022-02-15 | Shelby | Indiana | 18145 | 14548 | 174 |
2217258 | 2217258 | 2022-02-15 | Spencer | Indiana | 18147 | 5153 | 58 |
2217259 | 2217259 | 2022-02-15 | St. Joseph | Indiana | 18141 | 69825 | 827 |
2217260 | 2217260 | 2022-02-15 | Starke | Indiana | 18149 | 4677 | 92 |
2217261 | 2217261 | 2022-02-15 | Steuben | Indiana | 18151 | 9559 | 115 |
2217262 | 2217262 | 2022-02-15 | Sullivan | Indiana | 18153 | 5223 | 70 |
2217263 | 2217263 | 2022-02-15 | Switzerland | Indiana | 18155 | 2277 | 16 |
2217264 | 2217264 | 2022-02-15 | Tippecanoe | Indiana | 18157 | 49190 | 364 |
2217265 | 2217265 | 2022-02-15 | Tipton | Indiana | 18159 | 3489 | 83 |
2217266 | 2217266 | 2022-02-15 | Union | Indiana | 18161 | 2033 | 21 |
2217267 | 2217267 | 2022-02-15 | Vanderburgh | Indiana | 18163 | 56462 | 583 |
2217268 | 2217268 | 2022-02-15 | Vermillion | Indiana | 18165 | 4007 | 70 |
2217269 | 2217269 | 2022-02-15 | Vigo | Indiana | 18167 | 28517 | 382 |
2217270 | 2217270 | 2022-02-15 | Wabash | Indiana | 18169 | 8618 | 147 |
2217271 | 2217271 | 2022-02-15 | Warren | Indiana | 18171 | 2036 | 24 |
2217272 | 2217272 | 2022-02-15 | Warrick | Indiana | 18173 | 19948 | 227 |
2217273 | 2217273 | 2022-02-15 | Washington | Indiana | 18175 | 5904 | 75 |
2217274 | 2217274 | 2022-02-15 | Wayne | Indiana | 18177 | 18984 | 323 |
2217275 | 2217275 | 2022-02-15 | Wells | Indiana | 18179 | 6471 | 129 |
2217276 | 2217276 | 2022-02-15 | White | Indiana | 18181 | 6716 | 89 |
2217277 | 2217277 | 2022-02-15 | Whitley | Indiana | 18183 | 9583 | 79 |
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);