ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-03-11" 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 |
---|---|---|---|---|---|---|---|
1109388 | 1109388 | 2021-03-11 | Adams | Indiana | 18001 | 3349 | 51 |
1109389 | 1109389 | 2021-03-11 | Allen | Indiana | 18003 | 36432 | 673 |
1109390 | 1109390 | 2021-03-11 | Bartholomew | Indiana | 18005 | 7576 | 154 |
1109391 | 1109391 | 2021-03-11 | Benton | Indiana | 18007 | 926 | 13 |
1109392 | 1109392 | 2021-03-11 | Blackford | Indiana | 18009 | 1220 | 27 |
1109393 | 1109393 | 2021-03-11 | Boone | Indiana | 18011 | 6246 | 96 |
1109394 | 1109394 | 2021-03-11 | Brown | Indiana | 18013 | 953 | 40 |
1109395 | 1109395 | 2021-03-11 | Carroll | Indiana | 18015 | 1776 | 21 |
1109396 | 1109396 | 2021-03-11 | Cass | Indiana | 18017 | 5521 | 102 |
1109397 | 1109397 | 2021-03-11 | Clark | Indiana | 18019 | 12151 | 190 |
1109398 | 1109398 | 2021-03-11 | Clay | Indiana | 18021 | 2427 | 44 |
1109399 | 1109399 | 2021-03-11 | Clinton | Indiana | 18023 | 4000 | 58 |
1109400 | 1109400 | 2021-03-11 | Crawford | Indiana | 18025 | 931 | 14 |
1109401 | 1109401 | 2021-03-11 | Daviess | Indiana | 18027 | 2869 | 98 |
1109402 | 1109402 | 2021-03-11 | DeKalb | Indiana | 18033 | 3899 | 83 |
1109403 | 1109403 | 2021-03-11 | Dearborn | Indiana | 18029 | 5540 | 74 |
1109404 | 1109404 | 2021-03-11 | Decatur | Indiana | 18031 | 2778 | 94 |
1109405 | 1109405 | 2021-03-11 | Delaware | Indiana | 18035 | 9953 | 186 |
1109406 | 1109406 | 2021-03-11 | Dubois | Indiana | 18037 | 5961 | 113 |
1109407 | 1109407 | 2021-03-11 | Elkhart | Indiana | 18039 | 25728 | 435 |
1109408 | 1109408 | 2021-03-11 | Fayette | Indiana | 18041 | 2869 | 60 |
1109409 | 1109409 | 2021-03-11 | Floyd | Indiana | 18043 | 7290 | 179 |
1109410 | 1109410 | 2021-03-11 | Fountain | Indiana | 18045 | 2036 | 43 |
1109411 | 1109411 | 2021-03-11 | Franklin | Indiana | 18047 | 1625 | 36 |
1109412 | 1109412 | 2021-03-11 | Fulton | Indiana | 18049 | 1808 | 38 |
1109413 | 1109413 | 2021-03-11 | Gibson | Indiana | 18051 | 4095 | 88 |
1109414 | 1109414 | 2021-03-11 | Grant | Indiana | 18053 | 6908 | 169 |
1109415 | 1109415 | 2021-03-11 | Greene | Indiana | 18055 | 2651 | 84 |
1109416 | 1109416 | 2021-03-11 | Hamilton | Indiana | 18057 | 32670 | 417 |
1109417 | 1109417 | 2021-03-11 | Hancock | Indiana | 18059 | 7526 | 139 |
1109418 | 1109418 | 2021-03-11 | Harrison | Indiana | 18061 | 4068 | 68 |
1109419 | 1109419 | 2021-03-11 | Hendricks | Indiana | 18063 | 16071 | 323 |
1109420 | 1109420 | 2021-03-11 | Henry | Indiana | 18065 | 5461 | 97 |
1109421 | 1109421 | 2021-03-11 | Howard | Indiana | 18067 | 9182 | 208 |
1109422 | 1109422 | 2021-03-11 | Huntington | Indiana | 18069 | 3537 | 80 |
1109423 | 1109423 | 2021-03-11 | Jackson | Indiana | 18071 | 4671 | 68 |
1109424 | 1109424 | 2021-03-11 | Jasper | Indiana | 18073 | 3217 | 45 |
1109425 | 1109425 | 2021-03-11 | Jay | Indiana | 18075 | 1808 | 30 |
1109426 | 1109426 | 2021-03-11 | Jefferson | Indiana | 18077 | 2970 | 75 |
1109427 | 1109427 | 2021-03-11 | Jennings | Indiana | 18079 | 2191 | 47 |
1109428 | 1109428 | 2021-03-11 | Johnson | Indiana | 18081 | 16625 | 379 |
1109429 | 1109429 | 2021-03-11 | Knox | Indiana | 18083 | 3582 | 86 |
1109430 | 1109430 | 2021-03-11 | Kosciusko | Indiana | 18085 | 8644 | 116 |
1109431 | 1109431 | 2021-03-11 | LaGrange | Indiana | 18087 | 2435 | 72 |
1109432 | 1109432 | 2021-03-11 | LaPorte | Indiana | 18091 | 9894 | 204 |
1109433 | 1109433 | 2021-03-11 | Lake | Indiana | 18089 | 48987 | 934 |
1109434 | 1109434 | 2021-03-11 | Lawrence | Indiana | 18093 | 4211 | 118 |
1109435 | 1109435 | 2021-03-11 | Madison | Indiana | 18095 | 11879 | 346 |
1109436 | 1109436 | 2021-03-11 | Marion | Indiana | 18097 | 91861 | 1735 |
1109437 | 1109437 | 2021-03-11 | Marshall | Indiana | 18099 | 5485 | 107 |
1109438 | 1109438 | 2021-03-11 | Martin | Indiana | 18101 | 805 | 14 |
1109439 | 1109439 | 2021-03-11 | Miami | Indiana | 18103 | 3607 | 64 |
1109440 | 1109440 | 2021-03-11 | Monroe | Indiana | 18105 | 10490 | 167 |
1109441 | 1109441 | 2021-03-11 | Montgomery | Indiana | 18107 | 3951 | 85 |
1109442 | 1109442 | 2021-03-11 | Morgan | Indiana | 18109 | 6176 | 134 |
1109443 | 1109443 | 2021-03-11 | Newton | Indiana | 18111 | 972 | 35 |
1109444 | 1109444 | 2021-03-11 | Noble | Indiana | 18113 | 5152 | 81 |
1109445 | 1109445 | 2021-03-11 | Ohio | Indiana | 18115 | 543 | 11 |
1109446 | 1109446 | 2021-03-11 | Orange | Indiana | 18117 | 1720 | 54 |
1109447 | 1109447 | 2021-03-11 | Owen | Indiana | 18119 | 1856 | 56 |
1109448 | 1109448 | 2021-03-11 | Parke | Indiana | 18121 | 1418 | 16 |
1109449 | 1109449 | 2021-03-11 | Perry | Indiana | 18123 | 1756 | 37 |
1109450 | 1109450 | 2021-03-11 | Pike | Indiana | 18125 | 1284 | 33 |
1109451 | 1109451 | 2021-03-11 | Porter | Indiana | 18127 | 16192 | 295 |
1109452 | 1109452 | 2021-03-11 | Posey | Indiana | 18129 | 2628 | 32 |
1109453 | 1109453 | 2021-03-11 | Pulaski | Indiana | 18131 | 1084 | 44 |
1109454 | 1109454 | 2021-03-11 | Putnam | Indiana | 18133 | 3381 | 60 |
1109455 | 1109455 | 2021-03-11 | Randolph | Indiana | 18135 | 2310 | 78 |
1109456 | 1109456 | 2021-03-11 | Ripley | Indiana | 18137 | 3285 | 64 |
1109457 | 1109457 | 2021-03-11 | Rush | Indiana | 18139 | 1723 | 23 |
1109458 | 1109458 | 2021-03-11 | Scott | Indiana | 18143 | 2538 | 52 |
1109459 | 1109459 | 2021-03-11 | Shelby | Indiana | 18145 | 5607 | 102 |
1109460 | 1109460 | 2021-03-11 | Spencer | Indiana | 18147 | 2208 | 30 |
1109461 | 1109461 | 2021-03-11 | St. Joseph | Indiana | 18141 | 30668 | 536 |
1109462 | 1109462 | 2021-03-11 | Starke | Indiana | 18149 | 1905 | 54 |
1109463 | 1109463 | 2021-03-11 | Steuben | Indiana | 18151 | 3422 | 59 |
1109464 | 1109464 | 2021-03-11 | Sullivan | Indiana | 18153 | 2046 | 40 |
1109465 | 1109465 | 2021-03-11 | Switzerland | Indiana | 18155 | 757 | 8 |
1109466 | 1109466 | 2021-03-11 | Tippecanoe | Indiana | 18157 | 20369 | 209 |
1109467 | 1109467 | 2021-03-11 | Tipton | Indiana | 18159 | 1513 | 44 |
1109468 | 1109468 | 2021-03-11 | Union | Indiana | 18161 | 710 | 11 |
1109469 | 1109469 | 2021-03-11 | Vanderburgh | Indiana | 18163 | 21418 | 389 |
1109470 | 1109470 | 2021-03-11 | Vermillion | Indiana | 18165 | 1620 | 43 |
1109471 | 1109471 | 2021-03-11 | Vigo | Indiana | 18167 | 11755 | 242 |
1109472 | 1109472 | 2021-03-11 | Wabash | Indiana | 18169 | 3350 | 76 |
1109473 | 1109473 | 2021-03-11 | Warren | Indiana | 18171 | 764 | 15 |
1109474 | 1109474 | 2021-03-11 | Warrick | Indiana | 18173 | 7480 | 156 |
1109475 | 1109475 | 2021-03-11 | Washington | Indiana | 18175 | 2139 | 28 |
1109476 | 1109476 | 2021-03-11 | Wayne | Indiana | 18177 | 7070 | 195 |
1109477 | 1109477 | 2021-03-11 | Wells | Indiana | 18179 | 2643 | 80 |
1109478 | 1109478 | 2021-03-11 | White | Indiana | 18181 | 2998 | 54 |
1109479 | 1109479 | 2021-03-11 | Whitley | Indiana | 18183 | 3543 | 39 |
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);