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 2020-10-18 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
642080 | 642080 | 2020-10-18 | Adams | Indiana | 18001 | 456 | 6 |
642081 | 642081 | 2020-10-18 | Allen | Indiana | 18003 | 7791 | 232 |
642082 | 642082 | 2020-10-18 | Bartholomew | Indiana | 18005 | 1390 | 61 |
642083 | 642083 | 2020-10-18 | Benton | Indiana | 18007 | 106 | 0 |
642084 | 642084 | 2020-10-18 | Blackford | Indiana | 18009 | 194 | 3 |
642085 | 642085 | 2020-10-18 | Boone | Indiana | 18011 | 1196 | 51 |
642086 | 642086 | 2020-10-18 | Brown | Indiana | 18013 | 128 | 3 |
642087 | 642087 | 2020-10-18 | Carroll | Indiana | 18015 | 305 | 13 |
642088 | 642088 | 2020-10-18 | Cass | Indiana | 18017 | 2205 | 21 |
642089 | 642089 | 2020-10-18 | Clark | Indiana | 18019 | 2826 | 64 |
642090 | 642090 | 2020-10-18 | Clay | Indiana | 18021 | 426 | 6 |
642091 | 642091 | 2020-10-18 | Clinton | Indiana | 18023 | 805 | 20 |
642092 | 642092 | 2020-10-18 | Crawford | Indiana | 18025 | 141 | 2 |
642093 | 642093 | 2020-10-18 | Daviess | Indiana | 18027 | 829 | 34 |
642094 | 642094 | 2020-10-18 | DeKalb | Indiana | 18033 | 676 | 12 |
642095 | 642095 | 2020-10-18 | Dearborn | Indiana | 18029 | 902 | 30 |
642096 | 642096 | 2020-10-18 | Decatur | Indiana | 18031 | 520 | 42 |
642097 | 642097 | 2020-10-18 | Delaware | Indiana | 18035 | 2776 | 75 |
642098 | 642098 | 2020-10-18 | Dubois | Indiana | 18037 | 1334 | 23 |
642099 | 642099 | 2020-10-18 | Elkhart | Indiana | 18039 | 8374 | 134 |
642100 | 642100 | 2020-10-18 | Fayette | Indiana | 18041 | 675 | 15 |
642101 | 642101 | 2020-10-18 | Floyd | Indiana | 18043 | 1714 | 68 |
642102 | 642102 | 2020-10-18 | Fountain | Indiana | 18045 | 274 | 3 |
642103 | 642103 | 2020-10-18 | Franklin | Indiana | 18047 | 369 | 26 |
642104 | 642104 | 2020-10-18 | Fulton | Indiana | 18049 | 325 | 2 |
642105 | 642105 | 2020-10-18 | Gibson | Indiana | 18051 | 824 | 9 |
642106 | 642106 | 2020-10-18 | Grant | Indiana | 18053 | 1563 | 42 |
642107 | 642107 | 2020-10-18 | Greene | Indiana | 18055 | 510 | 40 |
642108 | 642108 | 2020-10-18 | Hamilton | Indiana | 18057 | 5904 | 122 |
642109 | 642109 | 2020-10-18 | Hancock | Indiana | 18059 | 1145 | 47 |
642110 | 642110 | 2020-10-18 | Harrison | Indiana | 18061 | 732 | 26 |
642111 | 642111 | 2020-10-18 | Hendricks | Indiana | 18063 | 3152 | 147 |
642112 | 642112 | 2020-10-18 | Henry | Indiana | 18065 | 1219 | 28 |
642113 | 642113 | 2020-10-18 | Howard | Indiana | 18067 | 1561 | 69 |
642114 | 642114 | 2020-10-18 | Huntington | Indiana | 18069 | 367 | 5 |
642115 | 642115 | 2020-10-18 | Jackson | Indiana | 18071 | 1068 | 13 |
642116 | 642116 | 2020-10-18 | Jasper | Indiana | 18073 | 528 | 5 |
642117 | 642117 | 2020-10-18 | Jay | Indiana | 18075 | 284 | 7 |
642118 | 642118 | 2020-10-18 | Jefferson | Indiana | 18077 | 328 | 5 |
642119 | 642119 | 2020-10-18 | Jennings | Indiana | 18079 | 361 | 15 |
642120 | 642120 | 2020-10-18 | Johnson | Indiana | 18081 | 2988 | 136 |
642121 | 642121 | 2020-10-18 | Knox | Indiana | 18083 | 687 | 10 |
642122 | 642122 | 2020-10-18 | Kosciusko | Indiana | 18085 | 1711 | 22 |
642123 | 642123 | 2020-10-18 | LaGrange | Indiana | 18087 | 765 | 15 |
642124 | 642124 | 2020-10-18 | LaPorte | Indiana | 18091 | 2092 | 53 |
642125 | 642125 | 2020-10-18 | Lake | Indiana | 18089 | 12972 | 368 |
642126 | 642126 | 2020-10-18 | Lawrence | Indiana | 18093 | 769 | 34 |
642127 | 642127 | 2020-10-18 | Madison | Indiana | 18095 | 2262 | 98 |
642128 | 642128 | 2020-10-18 | Marion | Indiana | 18097 | 24584 | 833 |
642129 | 642129 | 2020-10-18 | Marshall | Indiana | 18099 | 1298 | 26 |
642130 | 642130 | 2020-10-18 | Martin | Indiana | 18101 | 194 | 0 |
642131 | 642131 | 2020-10-18 | Miami | Indiana | 18103 | 569 | 5 |
642132 | 642132 | 2020-10-18 | Monroe | Indiana | 18105 | 3167 | 42 |
642133 | 642133 | 2020-10-18 | Montgomery | Indiana | 18107 | 559 | 23 |
642134 | 642134 | 2020-10-18 | Morgan | Indiana | 18109 | 921 | 43 |
642135 | 642135 | 2020-10-18 | Newton | Indiana | 18111 | 206 | 12 |
642136 | 642136 | 2020-10-18 | Noble | Indiana | 18113 | 1104 | 34 |
642137 | 642137 | 2020-10-18 | Ohio | Indiana | 18115 | 116 | 7 |
642138 | 642138 | 2020-10-18 | Orange | Indiana | 18117 | 383 | 26 |
642139 | 642139 | 2020-10-18 | Owen | Indiana | 18119 | 200 | 2 |
642140 | 642140 | 2020-10-18 | Parke | Indiana | 18121 | 228 | 2 |
642141 | 642141 | 2020-10-18 | Perry | Indiana | 18123 | 293 | 15 |
642142 | 642142 | 2020-10-18 | Pike | Indiana | 18125 | 315 | 12 |
642143 | 642143 | 2020-10-18 | Porter | Indiana | 18127 | 2900 | 50 |
642144 | 642144 | 2020-10-18 | Posey | Indiana | 18129 | 669 | 5 |
642145 | 642145 | 2020-10-18 | Pulaski | Indiana | 18131 | 142 | 1 |
642146 | 642146 | 2020-10-18 | Putnam | Indiana | 18133 | 701 | 15 |
642147 | 642147 | 2020-10-18 | Randolph | Indiana | 18135 | 370 | 8 |
642148 | 642148 | 2020-10-18 | Ripley | Indiana | 18137 | 414 | 8 |
642149 | 642149 | 2020-10-18 | Rush | Indiana | 18139 | 244 | 4 |
642150 | 642150 | 2020-10-18 | Scott | Indiana | 18143 | 509 | 15 |
642151 | 642151 | 2020-10-18 | Shelby | Indiana | 18145 | 1284 | 37 |
642152 | 642152 | 2020-10-18 | Spencer | Indiana | 18147 | 368 | 6 |
642153 | 642153 | 2020-10-18 | St. Joseph | Indiana | 18141 | 8674 | 161 |
642154 | 642154 | 2020-10-18 | Starke | Indiana | 18149 | 380 | 8 |
642155 | 642155 | 2020-10-18 | Steuben | Indiana | 18151 | 584 | 8 |
642156 | 642156 | 2020-10-18 | Sullivan | Indiana | 18153 | 410 | 12 |
642157 | 642157 | 2020-10-18 | Switzerland | Indiana | 18155 | 86 | 0 |
642158 | 642158 | 2020-10-18 | Tippecanoe | Indiana | 18157 | 3467 | 15 |
642159 | 642159 | 2020-10-18 | Tipton | Indiana | 18159 | 266 | 26 |
642160 | 642160 | 2020-10-18 | Union | Indiana | 18161 | 128 | 0 |
642161 | 642161 | 2020-10-18 | Vanderburgh | Indiana | 18163 | 5480 | 50 |
642162 | 642162 | 2020-10-18 | Vermillion | Indiana | 18165 | 204 | 1 |
642163 | 642163 | 2020-10-18 | Vigo | Indiana | 18167 | 2462 | 35 |
642164 | 642164 | 2020-10-18 | Wabash | Indiana | 18169 | 381 | 9 |
642165 | 642165 | 2020-10-18 | Warren | Indiana | 18171 | 73 | 1 |
642166 | 642166 | 2020-10-18 | Warrick | Indiana | 18173 | 1855 | 64 |
642167 | 642167 | 2020-10-18 | Washington | Indiana | 18175 | 345 | 2 |
642168 | 642168 | 2020-10-18 | Wayne | Indiana | 18177 | 1534 | 24 |
642169 | 642169 | 2020-10-18 | Wells | Indiana | 18179 | 429 | 7 |
642170 | 642170 | 2020-10-18 | White | Indiana | 18181 | 556 | 15 |
642171 | 642171 | 2020-10-18 | Whitley | Indiana | 18183 | 424 | 6 |
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);