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 2021-07-19 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1531448 | 1531448 | 2021-07-19 | Adams | Indiana | 18001 | 3558 | 57 |
1531449 | 1531449 | 2021-07-19 | Allen | Indiana | 18003 | 42471 | 719 |
1531450 | 1531450 | 2021-07-19 | Bartholomew | Indiana | 18005 | 8236 | 162 |
1531451 | 1531451 | 2021-07-19 | Benton | Indiana | 18007 | 1085 | 15 |
1531452 | 1531452 | 2021-07-19 | Blackford | Indiana | 18009 | 1387 | 32 |
1531453 | 1531453 | 2021-07-19 | Boone | Indiana | 18011 | 7131 | 109 |
1531454 | 1531454 | 2021-07-19 | Brown | Indiana | 18013 | 1053 | 43 |
1531455 | 1531455 | 2021-07-19 | Carroll | Indiana | 18015 | 1957 | 24 |
1531456 | 1531456 | 2021-07-19 | Cass | Indiana | 18017 | 6078 | 113 |
1531457 | 1531457 | 2021-07-19 | Clark | Indiana | 18019 | 13398 | 207 |
1531458 | 1531458 | 2021-07-19 | Clay | Indiana | 18021 | 2723 | 48 |
1531459 | 1531459 | 2021-07-19 | Clinton | Indiana | 18023 | 4516 | 60 |
1531460 | 1531460 | 2021-07-19 | Crawford | Indiana | 18025 | 1039 | 17 |
1531461 | 1531461 | 2021-07-19 | Daviess | Indiana | 18027 | 3081 | 102 |
1531462 | 1531462 | 2021-07-19 | DeKalb | Indiana | 18033 | 4492 | 88 |
1531463 | 1531463 | 2021-07-19 | Dearborn | Indiana | 18029 | 5968 | 81 |
1531464 | 1531464 | 2021-07-19 | Decatur | Indiana | 18031 | 2965 | 96 |
1531465 | 1531465 | 2021-07-19 | Delaware | Indiana | 18035 | 11075 | 205 |
1531466 | 1531466 | 2021-07-19 | Dubois | Indiana | 18037 | 6248 | 119 |
1531467 | 1531467 | 2021-07-19 | Elkhart | Indiana | 18039 | 29734 | 482 |
1531468 | 1531468 | 2021-07-19 | Fayette | Indiana | 18041 | 2994 | 66 |
1531469 | 1531469 | 2021-07-19 | Floyd | Indiana | 18043 | 7938 | 185 |
1531470 | 1531470 | 2021-07-19 | Fountain | Indiana | 18045 | 2321 | 50 |
1531471 | 1531471 | 2021-07-19 | Franklin | Indiana | 18047 | 1726 | 36 |
1531472 | 1531472 | 2021-07-19 | Fulton | Indiana | 18049 | 2072 | 45 |
1531473 | 1531473 | 2021-07-19 | Gibson | Indiana | 18051 | 4590 | 99 |
1531474 | 1531474 | 2021-07-19 | Grant | Indiana | 18053 | 7732 | 188 |
1531475 | 1531475 | 2021-07-19 | Greene | Indiana | 18055 | 2914 | 89 |
1531476 | 1531476 | 2021-07-19 | Hamilton | Indiana | 18057 | 37041 | 446 |
1531477 | 1531477 | 2021-07-19 | Hancock | Indiana | 18059 | 8713 | 151 |
1531478 | 1531478 | 2021-07-19 | Harrison | Indiana | 18061 | 4476 | 77 |
1531479 | 1531479 | 2021-07-19 | Hendricks | Indiana | 18063 | 18020 | 343 |
1531480 | 1531480 | 2021-07-19 | Henry | Indiana | 18065 | 5941 | 113 |
1531481 | 1531481 | 2021-07-19 | Howard | Indiana | 18067 | 10555 | 240 |
1531482 | 1531482 | 2021-07-19 | Huntington | Indiana | 18069 | 4101 | 83 |
1531483 | 1531483 | 2021-07-19 | Jackson | Indiana | 18071 | 5122 | 78 |
1531484 | 1531484 | 2021-07-19 | Jasper | Indiana | 18073 | 3986 | 57 |
1531485 | 1531485 | 2021-07-19 | Jay | Indiana | 18075 | 2039 | 35 |
1531486 | 1531486 | 2021-07-19 | Jefferson | Indiana | 18077 | 3396 | 87 |
1531487 | 1531487 | 2021-07-19 | Jennings | Indiana | 18079 | 2366 | 51 |
1531488 | 1531488 | 2021-07-19 | Johnson | Indiana | 18081 | 18746 | 407 |
1531489 | 1531489 | 2021-07-19 | Knox | Indiana | 18083 | 3857 | 91 |
1531490 | 1531490 | 2021-07-19 | Kosciusko | Indiana | 18085 | 9726 | 128 |
1531491 | 1531491 | 2021-07-19 | LaGrange | Indiana | 18087 | 2765 | 74 |
1531492 | 1531492 | 2021-07-19 | LaPorte | Indiana | 18091 | 12516 | 226 |
1531493 | 1531493 | 2021-07-19 | Lake | Indiana | 18089 | 56787 | 1069 |
1531494 | 1531494 | 2021-07-19 | Lawrence | Indiana | 18093 | 4857 | 130 |
1531495 | 1531495 | 2021-07-19 | Madison | Indiana | 18095 | 13422 | 365 |
1531496 | 1531496 | 2021-07-19 | Marion | Indiana | 18097 | 104753 | 1870 |
1531497 | 1531497 | 2021-07-19 | Marshall | Indiana | 18099 | 6309 | 118 |
1531498 | 1531498 | 2021-07-19 | Martin | Indiana | 18101 | 928 | 15 |
1531499 | 1531499 | 2021-07-19 | Miami | Indiana | 18103 | 4035 | 73 |
1531500 | 1531500 | 2021-07-19 | Monroe | Indiana | 18105 | 12448 | 181 |
1531501 | 1531501 | 2021-07-19 | Montgomery | Indiana | 18107 | 4525 | 94 |
1531502 | 1531502 | 2021-07-19 | Morgan | Indiana | 18109 | 6876 | 147 |
1531503 | 1531503 | 2021-07-19 | Newton | Indiana | 18111 | 1215 | 38 |
1531504 | 1531504 | 2021-07-19 | Noble | Indiana | 18113 | 5927 | 93 |
1531505 | 1531505 | 2021-07-19 | Ohio | Indiana | 18115 | 581 | 11 |
1531506 | 1531506 | 2021-07-19 | Orange | Indiana | 18117 | 1906 | 59 |
1531507 | 1531507 | 2021-07-19 | Owen | Indiana | 18119 | 2200 | 60 |
1531508 | 1531508 | 2021-07-19 | Parke | Indiana | 18121 | 1533 | 16 |
1531509 | 1531509 | 2021-07-19 | Perry | Indiana | 18123 | 1896 | 40 |
1531510 | 1531510 | 2021-07-19 | Pike | Indiana | 18125 | 1401 | 34 |
1531511 | 1531511 | 2021-07-19 | Porter | Indiana | 18127 | 19529 | 338 |
1531512 | 1531512 | 2021-07-19 | Posey | Indiana | 18129 | 2787 | 35 |
1531513 | 1531513 | 2021-07-19 | Pulaski | Indiana | 18131 | 1223 | 48 |
1531514 | 1531514 | 2021-07-19 | Putnam | Indiana | 18133 | 3813 | 62 |
1531515 | 1531515 | 2021-07-19 | Randolph | Indiana | 18135 | 2498 | 84 |
1531516 | 1531516 | 2021-07-19 | Ripley | Indiana | 18137 | 3502 | 72 |
1531517 | 1531517 | 2021-07-19 | Rush | Indiana | 18139 | 1837 | 27 |
1531518 | 1531518 | 2021-07-19 | Scott | Indiana | 18143 | 2756 | 60 |
1531519 | 1531519 | 2021-07-19 | Shelby | Indiana | 18145 | 6068 | 108 |
1531520 | 1531520 | 2021-07-19 | Spencer | Indiana | 18147 | 2362 | 31 |
1531521 | 1531521 | 2021-07-19 | St. Joseph | Indiana | 18141 | 37223 | 585 |
1531522 | 1531522 | 2021-07-19 | Starke | Indiana | 18149 | 2299 | 61 |
1531523 | 1531523 | 2021-07-19 | Steuben | Indiana | 18151 | 4077 | 62 |
1531524 | 1531524 | 2021-07-19 | Sullivan | Indiana | 18153 | 2185 | 43 |
1531525 | 1531525 | 2021-07-19 | Switzerland | Indiana | 18155 | 823 | 8 |
1531526 | 1531526 | 2021-07-19 | Tippecanoe | Indiana | 18157 | 23259 | 233 |
1531527 | 1531527 | 2021-07-19 | Tipton | Indiana | 18159 | 1705 | 50 |
1531528 | 1531528 | 2021-07-19 | Union | Indiana | 18161 | 762 | 11 |
1531529 | 1531529 | 2021-07-19 | Vanderburgh | Indiana | 18163 | 22965 | 410 |
1531530 | 1531530 | 2021-07-19 | Vermillion | Indiana | 18165 | 1795 | 44 |
1531531 | 1531531 | 2021-07-19 | Vigo | Indiana | 18167 | 12765 | 260 |
1531532 | 1531532 | 2021-07-19 | Wabash | Indiana | 18169 | 3662 | 83 |
1531533 | 1531533 | 2021-07-19 | Warren | Indiana | 18171 | 876 | 16 |
1531534 | 1531534 | 2021-07-19 | Warrick | Indiana | 18173 | 7980 | 160 |
1531535 | 1531535 | 2021-07-19 | Washington | Indiana | 18175 | 2503 | 37 |
1531536 | 1531536 | 2021-07-19 | Wayne | Indiana | 18177 | 7588 | 205 |
1531537 | 1531537 | 2021-07-19 | Wells | Indiana | 18179 | 3033 | 83 |
1531538 | 1531538 | 2021-07-19 | White | Indiana | 18181 | 3381 | 55 |
1531539 | 1531539 | 2021-07-19 | Whitley | Indiana | 18183 | 4130 | 44 |
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);