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-02-16 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2220437 | 2220437 | 2022-02-16 | Adams | Indiana | 18001 | 7289 | 110 |
2220438 | 2220438 | 2022-02-16 | Allen | Indiana | 18003 | 102748 | 1132 |
2220439 | 2220439 | 2022-02-16 | Bartholomew | Indiana | 18005 | 21096 | 241 |
2220440 | 2220440 | 2022-02-16 | Benton | Indiana | 18007 | 2443 | 21 |
2220441 | 2220441 | 2022-02-16 | Blackford | Indiana | 18009 | 3082 | 66 |
2220442 | 2220442 | 2022-02-16 | Boone | Indiana | 18011 | 14946 | 170 |
2220443 | 2220443 | 2022-02-16 | Brown | Indiana | 18013 | 2567 | 62 |
2220444 | 2220444 | 2022-02-16 | Carroll | Indiana | 18015 | 4181 | 62 |
2220445 | 2220445 | 2022-02-16 | Cass | Indiana | 18017 | 11401 | 155 |
2220446 | 2220446 | 2022-02-16 | Clark | Indiana | 18019 | 30439 | 375 |
2220447 | 2220447 | 2022-02-16 | Clay | Indiana | 18021 | 6774 | 84 |
2220448 | 2220448 | 2022-02-16 | Clinton | Indiana | 18023 | 9097 | 114 |
2220449 | 2220449 | 2022-02-16 | Crawford | Indiana | 18025 | 2486 | 35 |
2220450 | 2220450 | 2022-02-16 | Daviess | Indiana | 18027 | 7399 | 144 |
2220451 | 2220451 | 2022-02-16 | DeKalb | Indiana | 18033 | 11248 | 145 |
2220452 | 2220452 | 2022-02-16 | Dearborn | Indiana | 18029 | 13267 | 126 |
2220453 | 2220453 | 2022-02-16 | Decatur | Indiana | 18031 | 6996 | 139 |
2220454 | 2220454 | 2022-02-16 | Delaware | Indiana | 18035 | 24365 | 418 |
2220455 | 2220455 | 2022-02-16 | Dubois | Indiana | 18037 | 12729 | 159 |
2220456 | 2220456 | 2022-02-16 | Elkhart | Indiana | 18039 | 53773 | 709 |
2220457 | 2220457 | 2022-02-16 | Fayette | Indiana | 18041 | 6799 | 141 |
2220458 | 2220458 | 2022-02-16 | Floyd | Indiana | 18043 | 18529 | 280 |
2220459 | 2220459 | 2022-02-16 | Fountain | Indiana | 18045 | 5303 | 96 |
2220460 | 2220460 | 2022-02-16 | Franklin | Indiana | 18047 | 4352 | 61 |
2220461 | 2220461 | 2022-02-16 | Fulton | Indiana | 18049 | 4832 | 101 |
2220462 | 2220462 | 2022-02-16 | Gibson | Indiana | 18051 | 11495 | 137 |
2220463 | 2220463 | 2022-02-16 | Grant | Indiana | 18053 | 17528 | 335 |
2220464 | 2220464 | 2022-02-16 | Greene | Indiana | 18055 | 7102 | 131 |
2220465 | 2220465 | 2022-02-16 | Hamilton | Indiana | 18057 | 80577 | 626 |
2220466 | 2220466 | 2022-02-16 | Hancock | Indiana | 18059 | 20473 | 250 |
2220467 | 2220467 | 2022-02-16 | Harrison | Indiana | 18061 | 10598 | 130 |
2220468 | 2220468 | 2022-02-16 | Hendricks | Indiana | 18063 | 40362 | 528 |
2220469 | 2220469 | 2022-02-16 | Henry | Indiana | 18065 | 12810 | 219 |
2220470 | 2220470 | 2022-02-16 | Howard | Indiana | 18067 | 25140 | 429 |
2220471 | 2220471 | 2022-02-16 | Huntington | Indiana | 18069 | 11374 | 150 |
2220472 | 2220472 | 2022-02-16 | Jackson | Indiana | 18071 | 12343 | 120 |
2220473 | 2220473 | 2022-02-16 | Jasper | Indiana | 18073 | 8908 | 139 |
2220474 | 2220474 | 2022-02-16 | Jay | Indiana | 18075 | 4807 | 76 |
2220475 | 2220475 | 2022-02-16 | Jefferson | Indiana | 18077 | 9273 | 143 |
2220476 | 2220476 | 2022-02-16 | Jennings | Indiana | 18079 | 6881 | 101 |
2220477 | 2220477 | 2022-02-16 | Johnson | Indiana | 18081 | 41972 | 586 |
2220478 | 2220478 | 2022-02-16 | Knox | Indiana | 18083 | 10581 | 139 |
2220479 | 2220479 | 2022-02-16 | Kosciusko | Indiana | 18085 | 19572 | 223 |
2220480 | 2220480 | 2022-02-16 | LaGrange | Indiana | 18087 | 5819 | 100 |
2220481 | 2220481 | 2022-02-16 | LaPorte | Indiana | 18091 | 25149 | 349 |
2220482 | 2220482 | 2022-02-16 | Lake | Indiana | 18089 | 105093 | 1745 |
2220483 | 2220483 | 2022-02-16 | Lawrence | Indiana | 18093 | 11709 | 242 |
2220484 | 2220484 | 2022-02-16 | Madison | Indiana | 18095 | 32294 | 624 |
2220485 | 2220485 | 2022-02-16 | Marion | Indiana | 18097 | 222516 | 2863 |
2220486 | 2220486 | 2022-02-16 | Marshall | Indiana | 18099 | 12239 | 190 |
2220487 | 2220487 | 2022-02-16 | Martin | Indiana | 18101 | 2147 | 25 |
2220488 | 2220488 | 2022-02-16 | Miami | Indiana | 18103 | 9161 | 149 |
2220489 | 2220489 | 2022-02-16 | Monroe | Indiana | 18105 | 27108 | 264 |
2220490 | 2220490 | 2022-02-16 | Montgomery | Indiana | 18107 | 10530 | 156 |
2220491 | 2220491 | 2022-02-16 | Morgan | Indiana | 18109 | 16283 | 269 |
2220492 | 2220492 | 2022-02-16 | Newton | Indiana | 18111 | 2525 | 67 |
2220493 | 2220493 | 2022-02-16 | Noble | Indiana | 18113 | 12943 | 152 |
2220494 | 2220494 | 2022-02-16 | Ohio | Indiana | 18115 | 1434 | 18 |
2220495 | 2220495 | 2022-02-16 | Orange | Indiana | 18117 | 4979 | 92 |
2220496 | 2220496 | 2022-02-16 | Owen | Indiana | 18119 | 5754 | 111 |
2220497 | 2220497 | 2022-02-16 | Parke | Indiana | 18121 | 3581 | 45 |
2220498 | 2220498 | 2022-02-16 | Perry | Indiana | 18123 | 4601 | 64 |
2220499 | 2220499 | 2022-02-16 | Pike | Indiana | 18125 | 3683 | 48 |
2220500 | 2220500 | 2022-02-16 | Porter | Indiana | 18127 | 36931 | 541 |
2220501 | 2220501 | 2022-02-16 | Posey | Indiana | 18129 | 6457 | 53 |
2220502 | 2220502 | 2022-02-16 | Pulaski | Indiana | 18131 | 3027 | 85 |
2220503 | 2220503 | 2022-02-16 | Putnam | Indiana | 18133 | 9195 | 117 |
2220504 | 2220504 | 2022-02-16 | Randolph | Indiana | 18135 | 5858 | 141 |
2220505 | 2220505 | 2022-02-16 | Ripley | Indiana | 18137 | 8206 | 129 |
2220506 | 2220506 | 2022-02-16 | Rush | Indiana | 18139 | 4840 | 52 |
2220507 | 2220507 | 2022-02-16 | Scott | Indiana | 18143 | 7738 | 99 |
2220508 | 2220508 | 2022-02-16 | Shelby | Indiana | 18145 | 14553 | 176 |
2220509 | 2220509 | 2022-02-16 | Spencer | Indiana | 18147 | 5157 | 58 |
2220510 | 2220510 | 2022-02-16 | St. Joseph | Indiana | 18141 | 69876 | 830 |
2220511 | 2220511 | 2022-02-16 | Starke | Indiana | 18149 | 4679 | 92 |
2220512 | 2220512 | 2022-02-16 | Steuben | Indiana | 18151 | 9562 | 116 |
2220513 | 2220513 | 2022-02-16 | Sullivan | Indiana | 18153 | 5224 | 72 |
2220514 | 2220514 | 2022-02-16 | Switzerland | Indiana | 18155 | 2287 | 16 |
2220515 | 2220515 | 2022-02-16 | Tippecanoe | Indiana | 18157 | 49228 | 366 |
2220516 | 2220516 | 2022-02-16 | Tipton | Indiana | 18159 | 3491 | 83 |
2220517 | 2220517 | 2022-02-16 | Union | Indiana | 18161 | 2035 | 21 |
2220518 | 2220518 | 2022-02-16 | Vanderburgh | Indiana | 18163 | 56533 | 591 |
2220519 | 2220519 | 2022-02-16 | Vermillion | Indiana | 18165 | 4011 | 71 |
2220520 | 2220520 | 2022-02-16 | Vigo | Indiana | 18167 | 28542 | 388 |
2220521 | 2220521 | 2022-02-16 | Wabash | Indiana | 18169 | 8624 | 148 |
2220522 | 2220522 | 2022-02-16 | Warren | Indiana | 18171 | 2041 | 25 |
2220523 | 2220523 | 2022-02-16 | Warrick | Indiana | 18173 | 19970 | 227 |
2220524 | 2220524 | 2022-02-16 | Washington | Indiana | 18175 | 5909 | 76 |
2220525 | 2220525 | 2022-02-16 | Wayne | Indiana | 18177 | 19009 | 325 |
2220526 | 2220526 | 2022-02-16 | Wells | Indiana | 18179 | 6474 | 129 |
2220527 | 2220527 | 2022-02-16 | White | Indiana | 18181 | 6720 | 90 |
2220528 | 2220528 | 2022-02-16 | Whitley | Indiana | 18183 | 9588 | 79 |
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);