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-03-11 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2295222 | 2295222 | 2022-03-11 | Adams | Indiana | 18001 | 7323 | 112 |
2295223 | 2295223 | 2022-03-11 | Allen | Indiana | 18003 | 103495 | 1167 |
2295224 | 2295224 | 2022-03-11 | Bartholomew | Indiana | 18005 | 21286 | 247 |
2295225 | 2295225 | 2022-03-11 | Benton | Indiana | 18007 | 2470 | 21 |
2295226 | 2295226 | 2022-03-11 | Blackford | Indiana | 18009 | 3120 | 69 |
2295227 | 2295227 | 2022-03-11 | Boone | Indiana | 18011 | 15124 | 175 |
2295228 | 2295228 | 2022-03-11 | Brown | Indiana | 18013 | 2581 | 62 |
2295229 | 2295229 | 2022-03-11 | Carroll | Indiana | 18015 | 4211 | 65 |
2295230 | 2295230 | 2022-03-11 | Cass | Indiana | 18017 | 11625 | 162 |
2295231 | 2295231 | 2022-03-11 | Clark | Indiana | 18019 | 30956 | 388 |
2295232 | 2295232 | 2022-03-11 | Clay | Indiana | 18021 | 6817 | 87 |
2295233 | 2295233 | 2022-03-11 | Clinton | Indiana | 18023 | 9177 | 120 |
2295234 | 2295234 | 2022-03-11 | Crawford | Indiana | 18025 | 2538 | 37 |
2295235 | 2295235 | 2022-03-11 | Daviess | Indiana | 18027 | 7456 | 150 |
2295236 | 2295236 | 2022-03-11 | DeKalb | Indiana | 18033 | 11316 | 148 |
2295237 | 2295237 | 2022-03-11 | Dearborn | Indiana | 18029 | 13407 | 136 |
2295238 | 2295238 | 2022-03-11 | Decatur | Indiana | 18031 | 7051 | 145 |
2295239 | 2295239 | 2022-03-11 | Delaware | Indiana | 18035 | 24729 | 433 |
2295240 | 2295240 | 2022-03-11 | Dubois | Indiana | 18037 | 12832 | 165 |
2295241 | 2295241 | 2022-03-11 | Elkhart | Indiana | 18039 | 54075 | 726 |
2295242 | 2295242 | 2022-03-11 | Fayette | Indiana | 18041 | 6860 | 146 |
2295243 | 2295243 | 2022-03-11 | Floyd | Indiana | 18043 | 18849 | 291 |
2295244 | 2295244 | 2022-03-11 | Fountain | Indiana | 18045 | 5378 | 100 |
2295245 | 2295245 | 2022-03-11 | Franklin | Indiana | 18047 | 4390 | 65 |
2295246 | 2295246 | 2022-03-11 | Fulton | Indiana | 18049 | 4895 | 102 |
2295247 | 2295247 | 2022-03-11 | Gibson | Indiana | 18051 | 11613 | 143 |
2295248 | 2295248 | 2022-03-11 | Grant | Indiana | 18053 | 17649 | 345 |
2295249 | 2295249 | 2022-03-11 | Greene | Indiana | 18055 | 7186 | 138 |
2295250 | 2295250 | 2022-03-11 | Hamilton | Indiana | 18057 | 81531 | 650 |
2295251 | 2295251 | 2022-03-11 | Hancock | Indiana | 18059 | 20620 | 257 |
2295252 | 2295252 | 2022-03-11 | Harrison | Indiana | 18061 | 10768 | 136 |
2295253 | 2295253 | 2022-03-11 | Hendricks | Indiana | 18063 | 40704 | 550 |
2295254 | 2295254 | 2022-03-11 | Henry | Indiana | 18065 | 12944 | 227 |
2295255 | 2295255 | 2022-03-11 | Howard | Indiana | 18067 | 25360 | 438 |
2295256 | 2295256 | 2022-03-11 | Huntington | Indiana | 18069 | 11473 | 153 |
2295257 | 2295257 | 2022-03-11 | Jackson | Indiana | 18071 | 12493 | 126 |
2295258 | 2295258 | 2022-03-11 | Jasper | Indiana | 18073 | 8983 | 145 |
2295259 | 2295259 | 2022-03-11 | Jay | Indiana | 18075 | 4846 | 77 |
2295260 | 2295260 | 2022-03-11 | Jefferson | Indiana | 18077 | 9342 | 153 |
2295261 | 2295261 | 2022-03-11 | Jennings | Indiana | 18079 | 6939 | 105 |
2295262 | 2295262 | 2022-03-11 | Johnson | Indiana | 18081 | 42249 | 603 |
2295263 | 2295263 | 2022-03-11 | Knox | Indiana | 18083 | 10721 | 149 |
2295264 | 2295264 | 2022-03-11 | Kosciusko | Indiana | 18085 | 19714 | 235 |
2295265 | 2295265 | 2022-03-11 | LaGrange | Indiana | 18087 | 5845 | 102 |
2295266 | 2295266 | 2022-03-11 | LaPorte | Indiana | 18091 | 25335 | 361 |
2295267 | 2295267 | 2022-03-11 | Lake | Indiana | 18089 | 105787 | 1802 |
2295268 | 2295268 | 2022-03-11 | Lawrence | Indiana | 18093 | 11815 | 256 |
2295269 | 2295269 | 2022-03-11 | Madison | Indiana | 18095 | 32595 | 643 |
2295270 | 2295270 | 2022-03-11 | Marion | Indiana | 18097 | 224393 | 2939 |
2295271 | 2295271 | 2022-03-11 | Marshall | Indiana | 18099 | 12300 | 193 |
2295272 | 2295272 | 2022-03-11 | Martin | Indiana | 18101 | 2161 | 25 |
2295273 | 2295273 | 2022-03-11 | Miami | Indiana | 18103 | 9237 | 158 |
2295274 | 2295274 | 2022-03-11 | Monroe | Indiana | 18105 | 27498 | 277 |
2295275 | 2295275 | 2022-03-11 | Montgomery | Indiana | 18107 | 10638 | 163 |
2295276 | 2295276 | 2022-03-11 | Morgan | Indiana | 18109 | 16431 | 279 |
2295277 | 2295277 | 2022-03-11 | Newton | Indiana | 18111 | 2552 | 68 |
2295278 | 2295278 | 2022-03-11 | Noble | Indiana | 18113 | 13037 | 156 |
2295279 | 2295279 | 2022-03-11 | Ohio | Indiana | 18115 | 1442 | 19 |
2295280 | 2295280 | 2022-03-11 | Orange | Indiana | 18117 | 5027 | 96 |
2295281 | 2295281 | 2022-03-11 | Owen | Indiana | 18119 | 5813 | 114 |
2295282 | 2295282 | 2022-03-11 | Parke | Indiana | 18121 | 3606 | 49 |
2295283 | 2295283 | 2022-03-11 | Perry | Indiana | 18123 | 4651 | 68 |
2295284 | 2295284 | 2022-03-11 | Pike | Indiana | 18125 | 3720 | 48 |
2295285 | 2295285 | 2022-03-11 | Porter | Indiana | 18127 | 37348 | 554 |
2295286 | 2295286 | 2022-03-11 | Posey | Indiana | 18129 | 6521 | 56 |
2295287 | 2295287 | 2022-03-11 | Pulaski | Indiana | 18131 | 3065 | 85 |
2295288 | 2295288 | 2022-03-11 | Putnam | Indiana | 18133 | 9291 | 125 |
2295289 | 2295289 | 2022-03-11 | Randolph | Indiana | 18135 | 5921 | 144 |
2295290 | 2295290 | 2022-03-11 | Ripley | Indiana | 18137 | 8269 | 137 |
2295291 | 2295291 | 2022-03-11 | Rush | Indiana | 18139 | 4898 | 59 |
2295292 | 2295292 | 2022-03-11 | Scott | Indiana | 18143 | 7853 | 105 |
2295293 | 2295293 | 2022-03-11 | Shelby | Indiana | 18145 | 14653 | 181 |
2295294 | 2295294 | 2022-03-11 | Spencer | Indiana | 18147 | 5213 | 60 |
2295295 | 2295295 | 2022-03-11 | St. Joseph | Indiana | 18141 | 70361 | 859 |
2295296 | 2295296 | 2022-03-11 | Starke | Indiana | 18149 | 4722 | 94 |
2295297 | 2295297 | 2022-03-11 | Steuben | Indiana | 18151 | 9617 | 120 |
2295298 | 2295298 | 2022-03-11 | Sullivan | Indiana | 18153 | 5264 | 76 |
2295299 | 2295299 | 2022-03-11 | Switzerland | Indiana | 18155 | 2306 | 19 |
2295300 | 2295300 | 2022-03-11 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2295301 | 2295301 | 2022-03-11 | Tipton | Indiana | 18159 | 3513 | 87 |
2295302 | 2295302 | 2022-03-11 | Union | Indiana | 18161 | 2044 | 21 |
2295303 | 2295303 | 2022-03-11 | Vanderburgh | Indiana | 18163 | 57129 | 621 |
2295304 | 2295304 | 2022-03-11 | Vermillion | Indiana | 18165 | 4057 | 74 |
2295305 | 2295305 | 2022-03-11 | Vigo | Indiana | 18167 | 28799 | 405 |
2295306 | 2295306 | 2022-03-11 | Wabash | Indiana | 18169 | 8701 | 152 |
2295307 | 2295307 | 2022-03-11 | Warren | Indiana | 18171 | 2076 | 29 |
2295308 | 2295308 | 2022-03-11 | Warrick | Indiana | 18173 | 20214 | 236 |
2295309 | 2295309 | 2022-03-11 | Washington | Indiana | 18175 | 5979 | 79 |
2295310 | 2295310 | 2022-03-11 | Wayne | Indiana | 18177 | 19172 | 330 |
2295311 | 2295311 | 2022-03-11 | Wells | Indiana | 18179 | 6514 | 132 |
2295312 | 2295312 | 2022-03-11 | White | Indiana | 18181 | 6822 | 92 |
2295313 | 2295313 | 2022-03-11 | Whitley | Indiana | 18183 | 9634 | 83 |
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);