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-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 |
---|---|---|---|---|---|---|---|
2461193 | 2461193 | 2022-05-01 | Adams | Indiana | 18001 | 7275 | 112 |
2461194 | 2461194 | 2022-05-01 | Allen | Indiana | 18003 | 104168 | 1186 |
2461195 | 2461195 | 2022-05-01 | Bartholomew | Indiana | 18005 | 21410 | 249 |
2461196 | 2461196 | 2022-05-01 | Benton | Indiana | 18007 | 2487 | 21 |
2461197 | 2461197 | 2022-05-01 | Blackford | Indiana | 18009 | 3115 | 69 |
2461198 | 2461198 | 2022-05-01 | Boone | Indiana | 18011 | 15328 | 183 |
2461199 | 2461199 | 2022-05-01 | Brown | Indiana | 18013 | 2591 | 62 |
2461200 | 2461200 | 2022-05-01 | Carroll | Indiana | 18015 | 4249 | 68 |
2461201 | 2461201 | 2022-05-01 | Cass | Indiana | 18017 | 11689 | 163 |
2461202 | 2461202 | 2022-05-01 | Clark | Indiana | 18019 | 31287 | 396 |
2461203 | 2461203 | 2022-05-01 | Clay | Indiana | 18021 | 6835 | 88 |
2461204 | 2461204 | 2022-05-01 | Clinton | Indiana | 18023 | 9215 | 126 |
2461205 | 2461205 | 2022-05-01 | Crawford | Indiana | 18025 | 2554 | 40 |
2461206 | 2461206 | 2022-05-01 | Daviess | Indiana | 18027 | 7482 | 154 |
2461207 | 2461207 | 2022-05-01 | DeKalb | Indiana | 18033 | 11374 | 152 |
2461208 | 2461208 | 2022-05-01 | Dearborn | Indiana | 18029 | 13495 | 140 |
2461209 | 2461209 | 2022-05-01 | Decatur | Indiana | 18031 | 7011 | 145 |
2461210 | 2461210 | 2022-05-01 | Delaware | Indiana | 18035 | 24935 | 443 |
2461211 | 2461211 | 2022-05-01 | Dubois | Indiana | 18037 | 12877 | 165 |
2461212 | 2461212 | 2022-05-01 | Elkhart | Indiana | 18039 | 54197 | 733 |
2461213 | 2461213 | 2022-05-01 | Fayette | Indiana | 18041 | 6744 | 146 |
2461214 | 2461214 | 2022-05-01 | Floyd | Indiana | 18043 | 19047 | 301 |
2461215 | 2461215 | 2022-05-01 | Fountain | Indiana | 18045 | 5456 | 103 |
2461216 | 2461216 | 2022-05-01 | Franklin | Indiana | 18047 | 4377 | 65 |
2461217 | 2461217 | 2022-05-01 | Fulton | Indiana | 18049 | 4927 | 103 |
2461218 | 2461218 | 2022-05-01 | Gibson | Indiana | 18051 | 11680 | 146 |
2461219 | 2461219 | 2022-05-01 | Grant | Indiana | 18053 | 17347 | 351 |
2461220 | 2461220 | 2022-05-01 | Greene | Indiana | 18055 | 7230 | 139 |
2461221 | 2461221 | 2022-05-01 | Hamilton | Indiana | 18057 | 82492 | 661 |
2461222 | 2461222 | 2022-05-01 | Hancock | Indiana | 18059 | 20741 | 258 |
2461223 | 2461223 | 2022-05-01 | Harrison | Indiana | 18061 | 10839 | 138 |
2461224 | 2461224 | 2022-05-01 | Hendricks | Indiana | 18063 | 40867 | 554 |
2461225 | 2461225 | 2022-05-01 | Henry | Indiana | 18065 | 13008 | 231 |
2461226 | 2461226 | 2022-05-01 | Howard | Indiana | 18067 | 25457 | 449 |
2461227 | 2461227 | 2022-05-01 | Huntington | Indiana | 18069 | 11525 | 157 |
2461228 | 2461228 | 2022-05-01 | Jackson | Indiana | 18071 | 12544 | 130 |
2461229 | 2461229 | 2022-05-01 | Jasper | Indiana | 18073 | 9079 | 149 |
2461230 | 2461230 | 2022-05-01 | Jay | Indiana | 18075 | 4855 | 78 |
2461231 | 2461231 | 2022-05-01 | Jefferson | Indiana | 18077 | 9350 | 159 |
2461232 | 2461232 | 2022-05-01 | Jennings | Indiana | 18079 | 6953 | 108 |
2461233 | 2461233 | 2022-05-01 | Johnson | Indiana | 18081 | 42546 | 614 |
2461234 | 2461234 | 2022-05-01 | Knox | Indiana | 18083 | 10761 | 153 |
2461235 | 2461235 | 2022-05-01 | Kosciusko | Indiana | 18085 | 19782 | 237 |
2461236 | 2461236 | 2022-05-01 | LaGrange | Indiana | 18087 | 5851 | 102 |
2461237 | 2461237 | 2022-05-01 | LaPorte | Indiana | 18091 | 25653 | 368 |
2461238 | 2461238 | 2022-05-01 | Lake | Indiana | 18089 | 107252 | 1825 |
2461239 | 2461239 | 2022-05-01 | Lawrence | Indiana | 18093 | 11941 | 260 |
2461240 | 2461240 | 2022-05-01 | Madison | Indiana | 18095 | 32763 | 652 |
2461241 | 2461241 | 2022-05-01 | Marion | Indiana | 18097 | 226157 | 2995 |
2461242 | 2461242 | 2022-05-01 | Marshall | Indiana | 18099 | 12394 | 197 |
2461243 | 2461243 | 2022-05-01 | Martin | Indiana | 18101 | 2165 | 25 |
2461244 | 2461244 | 2022-05-01 | Miami | Indiana | 18103 | 9270 | 159 |
2461245 | 2461245 | 2022-05-01 | Monroe | Indiana | 18105 | 28305 | 280 |
2461246 | 2461246 | 2022-05-01 | Montgomery | Indiana | 18107 | 10700 | 164 |
2461247 | 2461247 | 2022-05-01 | Morgan | Indiana | 18109 | 16507 | 287 |
2461248 | 2461248 | 2022-05-01 | Newton | Indiana | 18111 | 2577 | 68 |
2461249 | 2461249 | 2022-05-01 | Noble | Indiana | 18113 | 13090 | 157 |
2461250 | 2461250 | 2022-05-01 | Ohio | Indiana | 18115 | 1448 | 19 |
2461251 | 2461251 | 2022-05-01 | Orange | Indiana | 18117 | 5045 | 96 |
2461252 | 2461252 | 2022-05-01 | Owen | Indiana | 18119 | 5871 | 121 |
2461253 | 2461253 | 2022-05-01 | Parke | Indiana | 18121 | 3597 | 46 |
2461254 | 2461254 | 2022-05-01 | Perry | Indiana | 18123 | 4656 | 69 |
2461255 | 2461255 | 2022-05-01 | Pike | Indiana | 18125 | 3735 | 49 |
2461256 | 2461256 | 2022-05-01 | Porter | Indiana | 18127 | 38064 | 562 |
2461257 | 2461257 | 2022-05-01 | Posey | Indiana | 18129 | 6552 | 58 |
2461258 | 2461258 | 2022-05-01 | Pulaski | Indiana | 18131 | 3080 | 86 |
2461259 | 2461259 | 2022-05-01 | Putnam | Indiana | 18133 | 9367 | 129 |
2461260 | 2461260 | 2022-05-01 | Randolph | Indiana | 18135 | 5912 | 148 |
2461261 | 2461261 | 2022-05-01 | Ripley | Indiana | 18137 | 8317 | 138 |
2461262 | 2461262 | 2022-05-01 | Rush | Indiana | 18139 | 4845 | 58 |
2461263 | 2461263 | 2022-05-01 | Scott | Indiana | 18143 | 7877 | 106 |
2461264 | 2461264 | 2022-05-01 | Shelby | Indiana | 18145 | 13611 | 182 |
2461265 | 2461265 | 2022-05-01 | Spencer | Indiana | 18147 | 5232 | 61 |
2461266 | 2461266 | 2022-05-01 | St. Joseph | Indiana | 18141 | 71191 | 872 |
2461267 | 2461267 | 2022-05-01 | Starke | Indiana | 18149 | 4762 | 99 |
2461268 | 2461268 | 2022-05-01 | Steuben | Indiana | 18151 | 9627 | 121 |
2461269 | 2461269 | 2022-05-01 | Sullivan | Indiana | 18153 | 5285 | 76 |
2461270 | 2461270 | 2022-05-01 | Switzerland | Indiana | 18155 | 2312 | 20 |
2461271 | 2461271 | 2022-05-01 | Tippecanoe | Indiana | 18157 | 50955 | 396 |
2461272 | 2461272 | 2022-05-01 | Tipton | Indiana | 18159 | 3533 | 87 |
2461273 | 2461273 | 2022-05-01 | Union | Indiana | 18161 | 2021 | 21 |
2461274 | 2461274 | 2022-05-01 | Unknown | Indiana | 0 | 21 | |
2461275 | 2461275 | 2022-05-01 | Vanderburgh | Indiana | 18163 | 57478 | 635 |
2461276 | 2461276 | 2022-05-01 | Vermillion | Indiana | 18165 | 4089 | 75 |
2461277 | 2461277 | 2022-05-01 | Vigo | Indiana | 18167 | 28931 | 413 |
2461278 | 2461278 | 2022-05-01 | Wabash | Indiana | 18169 | 8730 | 156 |
2461279 | 2461279 | 2022-05-01 | Warren | Indiana | 18171 | 2102 | 30 |
2461280 | 2461280 | 2022-05-01 | Warrick | Indiana | 18173 | 20313 | 239 |
2461281 | 2461281 | 2022-05-01 | Washington | Indiana | 18175 | 5999 | 85 |
2461282 | 2461282 | 2022-05-01 | Wayne | Indiana | 18177 | 18856 | 337 |
2461283 | 2461283 | 2022-05-01 | Wells | Indiana | 18179 | 6506 | 132 |
2461284 | 2461284 | 2022-05-01 | White | Indiana | 18181 | 6905 | 96 |
2461285 | 2461285 | 2022-05-01 | Whitley | Indiana | 18183 | 9682 | 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);