ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-12-14" 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 |
---|---|---|---|---|---|---|---|
2012313 | 2012313 | 2021-12-14 | Adams | Indiana | 18001 | 5726 | 85 |
2012314 | 2012314 | 2021-12-14 | Allen | Indiana | 18003 | 70394 | 939 |
2012315 | 2012315 | 2021-12-14 | Bartholomew | Indiana | 18005 | 13668 | 201 |
2012316 | 2012316 | 2021-12-14 | Benton | Indiana | 18007 | 1773 | 18 |
2012317 | 2012317 | 2021-12-14 | Blackford | Indiana | 18009 | 2339 | 47 |
2012318 | 2012318 | 2021-12-14 | Boone | Indiana | 18011 | 10237 | 134 |
2012319 | 2012319 | 2021-12-14 | Brown | Indiana | 18013 | 1873 | 51 |
2012320 | 2012320 | 2021-12-14 | Carroll | Indiana | 18015 | 3148 | 45 |
2012321 | 2012321 | 2021-12-14 | Cass | Indiana | 18017 | 8477 | 136 |
2012322 | 2012322 | 2021-12-14 | Clark | Indiana | 18019 | 20816 | 295 |
2012323 | 2012323 | 2021-12-14 | Clay | Indiana | 18021 | 4805 | 64 |
2012324 | 2012324 | 2021-12-14 | Clinton | Indiana | 18023 | 6526 | 88 |
2012325 | 2012325 | 2021-12-14 | Crawford | Indiana | 18025 | 1761 | 30 |
2012326 | 2012326 | 2021-12-14 | Daviess | Indiana | 18027 | 5265 | 121 |
2012327 | 2012327 | 2021-12-14 | DeKalb | Indiana | 18033 | 8291 | 117 |
2012328 | 2012328 | 2021-12-14 | Dearborn | Indiana | 18029 | 9284 | 110 |
2012329 | 2012329 | 2021-12-14 | Decatur | Indiana | 18031 | 4878 | 117 |
2012330 | 2012330 | 2021-12-14 | Delaware | Indiana | 18035 | 17578 | 323 |
2012331 | 2012331 | 2021-12-14 | Dubois | Indiana | 18037 | 9078 | 146 |
2012332 | 2012332 | 2021-12-14 | Elkhart | Indiana | 18039 | 41766 | 585 |
2012333 | 2012333 | 2021-12-14 | Fayette | Indiana | 18041 | 4987 | 107 |
2012334 | 2012334 | 2021-12-14 | Floyd | Indiana | 18043 | 12398 | 241 |
2012335 | 2012335 | 2021-12-14 | Fountain | Indiana | 18045 | 3962 | 70 |
2012336 | 2012336 | 2021-12-14 | Franklin | Indiana | 18047 | 3096 | 50 |
2012337 | 2012337 | 2021-12-14 | Fulton | Indiana | 18049 | 3778 | 78 |
2012338 | 2012338 | 2021-12-14 | Gibson | Indiana | 18051 | 7413 | 124 |
2012339 | 2012339 | 2021-12-14 | Grant | Indiana | 18053 | 13081 | 268 |
2012340 | 2012340 | 2021-12-14 | Greene | Indiana | 18055 | 4922 | 108 |
2012341 | 2012341 | 2021-12-14 | Hamilton | Indiana | 18057 | 53530 | 521 |
2012342 | 2012342 | 2021-12-14 | Hancock | Indiana | 18059 | 13787 | 194 |
2012343 | 2012343 | 2021-12-14 | Harrison | Indiana | 18061 | 7252 | 105 |
2012344 | 2012344 | 2021-12-14 | Hendricks | Indiana | 18063 | 27400 | 421 |
2012345 | 2012345 | 2021-12-14 | Henry | Indiana | 18065 | 9600 | 179 |
2012346 | 2012346 | 2021-12-14 | Howard | Indiana | 18067 | 17485 | 331 |
2012347 | 2012347 | 2021-12-14 | Huntington | Indiana | 18069 | 8102 | 121 |
2012348 | 2012348 | 2021-12-14 | Jackson | Indiana | 18071 | 8188 | 100 |
2012349 | 2012349 | 2021-12-14 | Jasper | Indiana | 18073 | 6494 | 101 |
2012350 | 2012350 | 2021-12-14 | Jay | Indiana | 18075 | 3529 | 57 |
2012351 | 2012351 | 2021-12-14 | Jefferson | Indiana | 18077 | 6276 | 110 |
2012352 | 2012352 | 2021-12-14 | Jennings | Indiana | 18079 | 4755 | 70 |
2012353 | 2012353 | 2021-12-14 | Johnson | Indiana | 18081 | 28788 | 493 |
2012354 | 2012354 | 2021-12-14 | Knox | Indiana | 18083 | 7189 | 119 |
2012355 | 2012355 | 2021-12-14 | Kosciusko | Indiana | 18085 | 15044 | 174 |
2012356 | 2012356 | 2021-12-14 | LaGrange | Indiana | 18087 | 4502 | 94 |
2012357 | 2012357 | 2021-12-14 | LaPorte | Indiana | 18091 | 18073 | 279 |
2012358 | 2012358 | 2021-12-14 | Lake | Indiana | 18089 | 75664 | 1332 |
2012359 | 2012359 | 2021-12-14 | Lawrence | Indiana | 18093 | 8391 | 195 |
2012360 | 2012360 | 2021-12-14 | Madison | Indiana | 18095 | 22154 | 493 |
2012361 | 2012361 | 2021-12-14 | Marion | Indiana | 18097 | 150706 | 2367 |
2012362 | 2012362 | 2021-12-14 | Marshall | Indiana | 18099 | 9576 | 156 |
2012363 | 2012363 | 2021-12-14 | Martin | Indiana | 18101 | 1563 | 20 |
2012364 | 2012364 | 2021-12-14 | Miami | Indiana | 18103 | 6876 | 119 |
2012365 | 2012365 | 2021-12-14 | Monroe | Indiana | 18105 | 17215 | 227 |
2012366 | 2012366 | 2021-12-14 | Montgomery | Indiana | 18107 | 7496 | 125 |
2012367 | 2012367 | 2021-12-14 | Morgan | Indiana | 18109 | 10897 | 208 |
2012368 | 2012368 | 2021-12-14 | Newton | Indiana | 18111 | 1919 | 56 |
2012369 | 2012369 | 2021-12-14 | Noble | Indiana | 18113 | 9756 | 130 |
2012370 | 2012370 | 2021-12-14 | Ohio | Indiana | 18115 | 948 | 13 |
2012371 | 2012371 | 2021-12-14 | Orange | Indiana | 18117 | 3484 | 79 |
2012372 | 2012372 | 2021-12-14 | Owen | Indiana | 18119 | 3702 | 81 |
2012373 | 2012373 | 2021-12-14 | Parke | Indiana | 18121 | 2596 | 34 |
2012374 | 2012374 | 2021-12-14 | Perry | Indiana | 18123 | 3067 | 58 |
2012375 | 2012375 | 2021-12-14 | Pike | Indiana | 18125 | 2634 | 46 |
2012376 | 2012376 | 2021-12-14 | Porter | Indiana | 18127 | 26866 | 415 |
2012377 | 2012377 | 2021-12-14 | Posey | Indiana | 18129 | 4242 | 45 |
2012378 | 2012378 | 2021-12-14 | Pulaski | Indiana | 18131 | 2206 | 62 |
2012379 | 2012379 | 2021-12-14 | Putnam | Indiana | 18133 | 6683 | 90 |
2012380 | 2012380 | 2021-12-14 | Randolph | Indiana | 18135 | 4239 | 113 |
2012381 | 2012381 | 2021-12-14 | Ripley | Indiana | 18137 | 5871 | 96 |
2012382 | 2012382 | 2021-12-14 | Rush | Indiana | 18139 | 3346 | 33 |
2012383 | 2012383 | 2021-12-14 | Scott | Indiana | 18143 | 5161 | 83 |
2012384 | 2012384 | 2021-12-14 | Shelby | Indiana | 18145 | 9867 | 147 |
2012385 | 2012385 | 2021-12-14 | Spencer | Indiana | 18147 | 3774 | 50 |
2012386 | 2012386 | 2021-12-14 | St. Joseph | Indiana | 18141 | 52249 | 689 |
2012387 | 2012387 | 2021-12-14 | Starke | Indiana | 18149 | 3756 | 79 |
2012388 | 2012388 | 2021-12-14 | Steuben | Indiana | 18151 | 7039 | 92 |
2012389 | 2012389 | 2021-12-14 | Sullivan | Indiana | 18153 | 3606 | 58 |
2012390 | 2012390 | 2021-12-14 | Switzerland | Indiana | 18155 | 1532 | 14 |
2012391 | 2012391 | 2021-12-14 | Tippecanoe | Indiana | 18157 | 32232 | 288 |
2012392 | 2012392 | 2021-12-14 | Tipton | Indiana | 18159 | 2602 | 70 |
2012393 | 2012393 | 2021-12-14 | Union | Indiana | 18161 | 1332 | 17 |
2012394 | 2012394 | 2021-12-14 | Vanderburgh | Indiana | 18163 | 35902 | 518 |
2012395 | 2012395 | 2021-12-14 | Vermillion | Indiana | 18165 | 2944 | 59 |
2012396 | 2012396 | 2021-12-14 | Vigo | Indiana | 18167 | 19752 | 325 |
2012397 | 2012397 | 2021-12-14 | Wabash | Indiana | 18169 | 6559 | 120 |
2012398 | 2012398 | 2021-12-14 | Warren | Indiana | 18171 | 1449 | 19 |
2012399 | 2012399 | 2021-12-14 | Warrick | Indiana | 18173 | 12750 | 200 |
2012400 | 2012400 | 2021-12-14 | Washington | Indiana | 18175 | 4051 | 58 |
2012401 | 2012401 | 2021-12-14 | Wayne | Indiana | 18177 | 12907 | 278 |
2012402 | 2012402 | 2021-12-14 | Wells | Indiana | 18179 | 5096 | 113 |
2012403 | 2012403 | 2021-12-14 | White | Indiana | 18181 | 5032 | 73 |
2012404 | 2012404 | 2021-12-14 | Whitley | Indiana | 18183 | 6934 | 66 |
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);