ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where date = "2022-05-09" 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 |
---|---|---|---|---|---|---|---|
2487249 | 2487249 | 2022-05-09 | Adams | Indiana | 18001 | 7281 | 112 |
2487250 | 2487250 | 2022-05-09 | Allen | Indiana | 18003 | 104497 | 1187 |
2487251 | 2487251 | 2022-05-09 | Bartholomew | Indiana | 18005 | 21510 | 249 |
2487252 | 2487252 | 2022-05-09 | Benton | Indiana | 18007 | 2498 | 21 |
2487253 | 2487253 | 2022-05-09 | Blackford | Indiana | 18009 | 3118 | 69 |
2487254 | 2487254 | 2022-05-09 | Boone | Indiana | 18011 | 15404 | 185 |
2487255 | 2487255 | 2022-05-09 | Brown | Indiana | 18013 | 2603 | 62 |
2487256 | 2487256 | 2022-05-09 | Carroll | Indiana | 18015 | 4261 | 68 |
2487257 | 2487257 | 2022-05-09 | Cass | Indiana | 18017 | 11699 | 164 |
2487258 | 2487258 | 2022-05-09 | Clark | Indiana | 18019 | 31461 | 396 |
2487259 | 2487259 | 2022-05-09 | Clay | Indiana | 18021 | 6849 | 88 |
2487260 | 2487260 | 2022-05-09 | Clinton | Indiana | 18023 | 9245 | 127 |
2487261 | 2487261 | 2022-05-09 | Crawford | Indiana | 18025 | 2559 | 40 |
2487262 | 2487262 | 2022-05-09 | Daviess | Indiana | 18027 | 7495 | 154 |
2487263 | 2487263 | 2022-05-09 | DeKalb | Indiana | 18033 | 11393 | 152 |
2487264 | 2487264 | 2022-05-09 | Dearborn | Indiana | 18029 | 13536 | 140 |
2487265 | 2487265 | 2022-05-09 | Decatur | Indiana | 18031 | 7011 | 146 |
2487266 | 2487266 | 2022-05-09 | Delaware | Indiana | 18035 | 25046 | 443 |
2487267 | 2487267 | 2022-05-09 | Dubois | Indiana | 18037 | 12889 | 165 |
2487268 | 2487268 | 2022-05-09 | Elkhart | Indiana | 18039 | 54308 | 733 |
2487269 | 2487269 | 2022-05-09 | Fayette | Indiana | 18041 | 6747 | 146 |
2487270 | 2487270 | 2022-05-09 | Floyd | Indiana | 18043 | 19137 | 302 |
2487271 | 2487271 | 2022-05-09 | Fountain | Indiana | 18045 | 5466 | 103 |
2487272 | 2487272 | 2022-05-09 | Franklin | Indiana | 18047 | 4378 | 65 |
2487273 | 2487273 | 2022-05-09 | Fulton | Indiana | 18049 | 4933 | 103 |
2487274 | 2487274 | 2022-05-09 | Gibson | Indiana | 18051 | 11720 | 145 |
2487275 | 2487275 | 2022-05-09 | Grant | Indiana | 18053 | 17366 | 352 |
2487276 | 2487276 | 2022-05-09 | Greene | Indiana | 18055 | 7245 | 139 |
2487277 | 2487277 | 2022-05-09 | Hamilton | Indiana | 18057 | 83088 | 661 |
2487278 | 2487278 | 2022-05-09 | Hancock | Indiana | 18059 | 20831 | 258 |
2487279 | 2487279 | 2022-05-09 | Harrison | Indiana | 18061 | 10865 | 138 |
2487280 | 2487280 | 2022-05-09 | Hendricks | Indiana | 18063 | 40964 | 554 |
2487281 | 2487281 | 2022-05-09 | Henry | Indiana | 18065 | 13037 | 231 |
2487282 | 2487282 | 2022-05-09 | Howard | Indiana | 18067 | 25523 | 449 |
2487283 | 2487283 | 2022-05-09 | Huntington | Indiana | 18069 | 11554 | 157 |
2487284 | 2487284 | 2022-05-09 | Jackson | Indiana | 18071 | 12560 | 130 |
2487285 | 2487285 | 2022-05-09 | Jasper | Indiana | 18073 | 9126 | 149 |
2487286 | 2487286 | 2022-05-09 | Jay | Indiana | 18075 | 4860 | 78 |
2487287 | 2487287 | 2022-05-09 | Jefferson | Indiana | 18077 | 9368 | 159 |
2487288 | 2487288 | 2022-05-09 | Jennings | Indiana | 18079 | 6987 | 108 |
2487289 | 2487289 | 2022-05-09 | Johnson | Indiana | 18081 | 42702 | 615 |
2487290 | 2487290 | 2022-05-09 | Knox | Indiana | 18083 | 10785 | 153 |
2487291 | 2487291 | 2022-05-09 | Kosciusko | Indiana | 18085 | 19829 | 237 |
2487292 | 2487292 | 2022-05-09 | LaGrange | Indiana | 18087 | 5869 | 102 |
2487293 | 2487293 | 2022-05-09 | LaPorte | Indiana | 18091 | 25800 | 367 |
2487294 | 2487294 | 2022-05-09 | Lake | Indiana | 18089 | 108094 | 1830 |
2487295 | 2487295 | 2022-05-09 | Lawrence | Indiana | 18093 | 11993 | 261 |
2487296 | 2487296 | 2022-05-09 | Madison | Indiana | 18095 | 32835 | 653 |
2487297 | 2487297 | 2022-05-09 | Marion | Indiana | 18097 | 227007 | 3000 |
2487298 | 2487298 | 2022-05-09 | Marshall | Indiana | 18099 | 12415 | 197 |
2487299 | 2487299 | 2022-05-09 | Martin | Indiana | 18101 | 2173 | 25 |
2487300 | 2487300 | 2022-05-09 | Miami | Indiana | 18103 | 9285 | 159 |
2487301 | 2487301 | 2022-05-09 | Monroe | Indiana | 18105 | 28636 | 280 |
2487302 | 2487302 | 2022-05-09 | Montgomery | Indiana | 18107 | 10726 | 164 |
2487303 | 2487303 | 2022-05-09 | Morgan | Indiana | 18109 | 16553 | 287 |
2487304 | 2487304 | 2022-05-09 | Newton | Indiana | 18111 | 2587 | 68 |
2487305 | 2487305 | 2022-05-09 | Noble | Indiana | 18113 | 13118 | 157 |
2487306 | 2487306 | 2022-05-09 | Ohio | Indiana | 18115 | 1455 | 19 |
2487307 | 2487307 | 2022-05-09 | Orange | Indiana | 18117 | 5048 | 96 |
2487308 | 2487308 | 2022-05-09 | Owen | Indiana | 18119 | 5897 | 121 |
2487309 | 2487309 | 2022-05-09 | Parke | Indiana | 18121 | 3603 | 46 |
2487310 | 2487310 | 2022-05-09 | Perry | Indiana | 18123 | 4666 | 69 |
2487311 | 2487311 | 2022-05-09 | Pike | Indiana | 18125 | 3747 | 49 |
2487312 | 2487312 | 2022-05-09 | Porter | Indiana | 18127 | 38400 | 564 |
2487313 | 2487313 | 2022-05-09 | Posey | Indiana | 18129 | 6565 | 58 |
2487314 | 2487314 | 2022-05-09 | Pulaski | Indiana | 18131 | 3083 | 86 |
2487315 | 2487315 | 2022-05-09 | Putnam | Indiana | 18133 | 9397 | 129 |
2487316 | 2487316 | 2022-05-09 | Randolph | Indiana | 18135 | 5911 | 148 |
2487317 | 2487317 | 2022-05-09 | Ripley | Indiana | 18137 | 8341 | 138 |
2487318 | 2487318 | 2022-05-09 | Rush | Indiana | 18139 | 4854 | 58 |
2487319 | 2487319 | 2022-05-09 | Scott | Indiana | 18143 | 7914 | 106 |
2487320 | 2487320 | 2022-05-09 | Shelby | Indiana | 18145 | 13635 | 182 |
2487321 | 2487321 | 2022-05-09 | Spencer | Indiana | 18147 | 5246 | 61 |
2487322 | 2487322 | 2022-05-09 | St. Joseph | Indiana | 18141 | 71550 | 874 |
2487323 | 2487323 | 2022-05-09 | Starke | Indiana | 18149 | 4773 | 99 |
2487324 | 2487324 | 2022-05-09 | Steuben | Indiana | 18151 | 9667 | 121 |
2487325 | 2487325 | 2022-05-09 | Sullivan | Indiana | 18153 | 5291 | 76 |
2487326 | 2487326 | 2022-05-09 | Switzerland | Indiana | 18155 | 2319 | 20 |
2487327 | 2487327 | 2022-05-09 | Tippecanoe | Indiana | 18157 | 51554 | 396 |
2487328 | 2487328 | 2022-05-09 | Tipton | Indiana | 18159 | 3539 | 87 |
2487329 | 2487329 | 2022-05-09 | Union | Indiana | 18161 | 2023 | 21 |
2487330 | 2487330 | 2022-05-09 | Unknown | Indiana | 0 | 21 | |
2487331 | 2487331 | 2022-05-09 | Vanderburgh | Indiana | 18163 | 57701 | 639 |
2487332 | 2487332 | 2022-05-09 | Vermillion | Indiana | 18165 | 4101 | 75 |
2487333 | 2487333 | 2022-05-09 | Vigo | Indiana | 18167 | 28988 | 413 |
2487334 | 2487334 | 2022-05-09 | Wabash | Indiana | 18169 | 8745 | 156 |
2487335 | 2487335 | 2022-05-09 | Warren | Indiana | 18171 | 2107 | 30 |
2487336 | 2487336 | 2022-05-09 | Warrick | Indiana | 18173 | 20368 | 239 |
2487337 | 2487337 | 2022-05-09 | Washington | Indiana | 18175 | 6006 | 85 |
2487338 | 2487338 | 2022-05-09 | Wayne | Indiana | 18177 | 18877 | 337 |
2487339 | 2487339 | 2022-05-09 | Wells | Indiana | 18179 | 6508 | 132 |
2487340 | 2487340 | 2022-05-09 | White | Indiana | 18181 | 6926 | 96 |
2487341 | 2487341 | 2022-05-09 | Whitley | Indiana | 18183 | 9720 | 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);