ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2022-05-05 and state = "Indiana" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474217 | 2474217 | 2022-05-05 | Adams | Indiana | 18001 | 7276 | 112 |
2474218 | 2474218 | 2022-05-05 | Allen | Indiana | 18003 | 104305 | 1186 |
2474219 | 2474219 | 2022-05-05 | Bartholomew | Indiana | 18005 | 21442 | 249 |
2474220 | 2474220 | 2022-05-05 | Benton | Indiana | 18007 | 2491 | 21 |
2474221 | 2474221 | 2022-05-05 | Blackford | Indiana | 18009 | 3115 | 69 |
2474222 | 2474222 | 2022-05-05 | Boone | Indiana | 18011 | 15357 | 184 |
2474223 | 2474223 | 2022-05-05 | Brown | Indiana | 18013 | 2593 | 62 |
2474224 | 2474224 | 2022-05-05 | Carroll | Indiana | 18015 | 4258 | 68 |
2474225 | 2474225 | 2022-05-05 | Cass | Indiana | 18017 | 11692 | 163 |
2474226 | 2474226 | 2022-05-05 | Clark | Indiana | 18019 | 31369 | 396 |
2474227 | 2474227 | 2022-05-05 | Clay | Indiana | 18021 | 6840 | 88 |
2474228 | 2474228 | 2022-05-05 | Clinton | Indiana | 18023 | 9227 | 126 |
2474229 | 2474229 | 2022-05-05 | Crawford | Indiana | 18025 | 2558 | 40 |
2474230 | 2474230 | 2022-05-05 | Daviess | Indiana | 18027 | 7489 | 154 |
2474231 | 2474231 | 2022-05-05 | DeKalb | Indiana | 18033 | 11382 | 152 |
2474232 | 2474232 | 2022-05-05 | Dearborn | Indiana | 18029 | 13509 | 140 |
2474233 | 2474233 | 2022-05-05 | Decatur | Indiana | 18031 | 7010 | 145 |
2474234 | 2474234 | 2022-05-05 | Delaware | Indiana | 18035 | 24990 | 443 |
2474235 | 2474235 | 2022-05-05 | Dubois | Indiana | 18037 | 12881 | 165 |
2474236 | 2474236 | 2022-05-05 | Elkhart | Indiana | 18039 | 54248 | 733 |
2474237 | 2474237 | 2022-05-05 | Fayette | Indiana | 18041 | 6745 | 146 |
2474238 | 2474238 | 2022-05-05 | Floyd | Indiana | 18043 | 19087 | 301 |
2474239 | 2474239 | 2022-05-05 | Fountain | Indiana | 18045 | 5462 | 103 |
2474240 | 2474240 | 2022-05-05 | Franklin | Indiana | 18047 | 4380 | 65 |
2474241 | 2474241 | 2022-05-05 | Fulton | Indiana | 18049 | 4929 | 103 |
2474242 | 2474242 | 2022-05-05 | Gibson | Indiana | 18051 | 11695 | 145 |
2474243 | 2474243 | 2022-05-05 | Grant | Indiana | 18053 | 17352 | 352 |
2474244 | 2474244 | 2022-05-05 | Greene | Indiana | 18055 | 7236 | 139 |
2474245 | 2474245 | 2022-05-05 | Hamilton | Indiana | 18057 | 82726 | 661 |
2474246 | 2474246 | 2022-05-05 | Hancock | Indiana | 18059 | 20778 | 258 |
2474247 | 2474247 | 2022-05-05 | Harrison | Indiana | 18061 | 10851 | 138 |
2474248 | 2474248 | 2022-05-05 | Hendricks | Indiana | 18063 | 40913 | 555 |
2474249 | 2474249 | 2022-05-05 | Henry | Indiana | 18065 | 13020 | 231 |
2474250 | 2474250 | 2022-05-05 | Howard | Indiana | 18067 | 25481 | 449 |
2474251 | 2474251 | 2022-05-05 | Huntington | Indiana | 18069 | 11542 | 157 |
2474252 | 2474252 | 2022-05-05 | Jackson | Indiana | 18071 | 12548 | 130 |
2474253 | 2474253 | 2022-05-05 | Jasper | Indiana | 18073 | 9104 | 149 |
2474254 | 2474254 | 2022-05-05 | Jay | Indiana | 18075 | 4856 | 78 |
2474255 | 2474255 | 2022-05-05 | Jefferson | Indiana | 18077 | 9357 | 159 |
2474256 | 2474256 | 2022-05-05 | Jennings | Indiana | 18079 | 6974 | 108 |
2474257 | 2474257 | 2022-05-05 | Johnson | Indiana | 18081 | 42622 | 614 |
2474258 | 2474258 | 2022-05-05 | Knox | Indiana | 18083 | 10770 | 153 |
2474259 | 2474259 | 2022-05-05 | Kosciusko | Indiana | 18085 | 19797 | 237 |
2474260 | 2474260 | 2022-05-05 | LaGrange | Indiana | 18087 | 5860 | 102 |
2474261 | 2474261 | 2022-05-05 | LaPorte | Indiana | 18091 | 25721 | 368 |
2474262 | 2474262 | 2022-05-05 | Lake | Indiana | 18089 | 107616 | 1826 |
2474263 | 2474263 | 2022-05-05 | Lawrence | Indiana | 18093 | 11950 | 260 |
2474264 | 2474264 | 2022-05-05 | Madison | Indiana | 18095 | 32790 | 652 |
2474265 | 2474265 | 2022-05-05 | Marion | Indiana | 18097 | 226560 | 2995 |
2474266 | 2474266 | 2022-05-05 | Marshall | Indiana | 18099 | 12400 | 197 |
2474267 | 2474267 | 2022-05-05 | Martin | Indiana | 18101 | 2169 | 25 |
2474268 | 2474268 | 2022-05-05 | Miami | Indiana | 18103 | 9280 | 159 |
2474269 | 2474269 | 2022-05-05 | Monroe | Indiana | 18105 | 28457 | 280 |
2474270 | 2474270 | 2022-05-05 | Montgomery | Indiana | 18107 | 10706 | 164 |
2474271 | 2474271 | 2022-05-05 | Morgan | Indiana | 18109 | 16529 | 287 |
2474272 | 2474272 | 2022-05-05 | Newton | Indiana | 18111 | 2581 | 68 |
2474273 | 2474273 | 2022-05-05 | Noble | Indiana | 18113 | 13100 | 157 |
2474274 | 2474274 | 2022-05-05 | Ohio | Indiana | 18115 | 1451 | 19 |
2474275 | 2474275 | 2022-05-05 | Orange | Indiana | 18117 | 5049 | 96 |
2474276 | 2474276 | 2022-05-05 | Owen | Indiana | 18119 | 5877 | 121 |
2474277 | 2474277 | 2022-05-05 | Parke | Indiana | 18121 | 3600 | 46 |
2474278 | 2474278 | 2022-05-05 | Perry | Indiana | 18123 | 4659 | 69 |
2474279 | 2474279 | 2022-05-05 | Pike | Indiana | 18125 | 3743 | 49 |
2474280 | 2474280 | 2022-05-05 | Porter | Indiana | 18127 | 38223 | 562 |
2474281 | 2474281 | 2022-05-05 | Posey | Indiana | 18129 | 6559 | 58 |
2474282 | 2474282 | 2022-05-05 | Pulaski | Indiana | 18131 | 3081 | 86 |
2474283 | 2474283 | 2022-05-05 | Putnam | Indiana | 18133 | 9381 | 129 |
2474284 | 2474284 | 2022-05-05 | Randolph | Indiana | 18135 | 5912 | 148 |
2474285 | 2474285 | 2022-05-05 | Ripley | Indiana | 18137 | 8329 | 138 |
2474286 | 2474286 | 2022-05-05 | Rush | Indiana | 18139 | 4849 | 58 |
2474287 | 2474287 | 2022-05-05 | Scott | Indiana | 18143 | 7885 | 106 |
2474288 | 2474288 | 2022-05-05 | Shelby | Indiana | 18145 | 13622 | 182 |
2474289 | 2474289 | 2022-05-05 | Spencer | Indiana | 18147 | 5240 | 61 |
2474290 | 2474290 | 2022-05-05 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2474291 | 2474291 | 2022-05-05 | Starke | Indiana | 18149 | 4765 | 99 |
2474292 | 2474292 | 2022-05-05 | Steuben | Indiana | 18151 | 9642 | 121 |
2474293 | 2474293 | 2022-05-05 | Sullivan | Indiana | 18153 | 5288 | 76 |
2474294 | 2474294 | 2022-05-05 | Switzerland | Indiana | 18155 | 2315 | 20 |
2474295 | 2474295 | 2022-05-05 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2474296 | 2474296 | 2022-05-05 | Tipton | Indiana | 18159 | 3534 | 87 |
2474297 | 2474297 | 2022-05-05 | Union | Indiana | 18161 | 2022 | 21 |
2474298 | 2474298 | 2022-05-05 | Unknown | Indiana | 0 | 21 | |
2474299 | 2474299 | 2022-05-05 | Vanderburgh | Indiana | 18163 | 57582 | 635 |
2474300 | 2474300 | 2022-05-05 | Vermillion | Indiana | 18165 | 4095 | 75 |
2474301 | 2474301 | 2022-05-05 | Vigo | Indiana | 18167 | 28961 | 413 |
2474302 | 2474302 | 2022-05-05 | Wabash | Indiana | 18169 | 8736 | 156 |
2474303 | 2474303 | 2022-05-05 | Warren | Indiana | 18171 | 2107 | 30 |
2474304 | 2474304 | 2022-05-05 | Warrick | Indiana | 18173 | 20343 | 239 |
2474305 | 2474305 | 2022-05-05 | Washington | Indiana | 18175 | 6004 | 85 |
2474306 | 2474306 | 2022-05-05 | Wayne | Indiana | 18177 | 18864 | 337 |
2474307 | 2474307 | 2022-05-05 | Wells | Indiana | 18179 | 6507 | 132 |
2474308 | 2474308 | 2022-05-05 | White | Indiana | 18181 | 6917 | 96 |
2474309 | 2474309 | 2022-05-05 | Whitley | Indiana | 18183 | 9691 | 84 |
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);