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-11-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 |
---|---|---|---|---|---|---|---|
736151 | 736151 | 2020-11-16 | Adams | Indiana | 18001 | 1351 | 16 |
736152 | 736152 | 2020-11-16 | Allen | Indiana | 18003 | 14579 | 279 |
736153 | 736153 | 2020-11-16 | Bartholomew | Indiana | 18005 | 2461 | 65 |
736154 | 736154 | 2020-11-16 | Benton | Indiana | 18007 | 249 | 1 |
736155 | 736155 | 2020-11-16 | Blackford | Indiana | 18009 | 413 | 10 |
736156 | 736156 | 2020-11-16 | Boone | Indiana | 18011 | 2017 | 56 |
736157 | 736157 | 2020-11-16 | Brown | Indiana | 18013 | 273 | 3 |
736158 | 736158 | 2020-11-16 | Carroll | Indiana | 18015 | 564 | 13 |
736159 | 736159 | 2020-11-16 | Cass | Indiana | 18017 | 2761 | 28 |
736160 | 736160 | 2020-11-16 | Clark | Indiana | 18019 | 4326 | 81 |
736161 | 736161 | 2020-11-16 | Clay | Indiana | 18021 | 862 | 21 |
736162 | 736162 | 2020-11-16 | Clinton | Indiana | 18023 | 1492 | 23 |
736163 | 736163 | 2020-11-16 | Crawford | Indiana | 18025 | 238 | 2 |
736164 | 736164 | 2020-11-16 | Daviess | Indiana | 18027 | 1265 | 44 |
736165 | 736165 | 2020-11-16 | DeKalb | Indiana | 18033 | 1439 | 18 |
736166 | 736166 | 2020-11-16 | Dearborn | Indiana | 18029 | 1724 | 30 |
736167 | 736167 | 2020-11-16 | Decatur | Indiana | 18031 | 1089 | 44 |
736168 | 736168 | 2020-11-16 | Delaware | Indiana | 18035 | 4207 | 101 |
736169 | 736169 | 2020-11-16 | Dubois | Indiana | 18037 | 2078 | 30 |
736170 | 736170 | 2020-11-16 | Elkhart | Indiana | 18039 | 14713 | 194 |
736171 | 736171 | 2020-11-16 | Fayette | Indiana | 18041 | 1381 | 27 |
736172 | 736172 | 2020-11-16 | Floyd | Indiana | 18043 | 2680 | 79 |
736173 | 736173 | 2020-11-16 | Fountain | Indiana | 18045 | 623 | 8 |
736174 | 736174 | 2020-11-16 | Franklin | Indiana | 18047 | 559 | 26 |
736175 | 736175 | 2020-11-16 | Fulton | Indiana | 18049 | 697 | 14 |
736176 | 736176 | 2020-11-16 | Gibson | Indiana | 18051 | 1495 | 18 |
736177 | 736177 | 2020-11-16 | Grant | Indiana | 18053 | 2509 | 49 |
736178 | 736178 | 2020-11-16 | Greene | Indiana | 18055 | 852 | 53 |
736179 | 736179 | 2020-11-16 | Hamilton | Indiana | 18057 | 10435 | 163 |
736180 | 736180 | 2020-11-16 | Hancock | Indiana | 18059 | 2045 | 51 |
736181 | 736181 | 2020-11-16 | Harrison | Indiana | 18061 | 1185 | 26 |
736182 | 736182 | 2020-11-16 | Hendricks | Indiana | 18063 | 4893 | 167 |
736183 | 736183 | 2020-11-16 | Henry | Indiana | 18065 | 2069 | 35 |
736184 | 736184 | 2020-11-16 | Howard | Indiana | 18067 | 2459 | 75 |
736185 | 736185 | 2020-11-16 | Huntington | Indiana | 18069 | 923 | 7 |
736186 | 736186 | 2020-11-16 | Jackson | Indiana | 18071 | 1737 | 30 |
736187 | 736187 | 2020-11-16 | Jasper | Indiana | 18073 | 1165 | 8 |
736188 | 736188 | 2020-11-16 | Jay | Indiana | 18075 | 758 | 10 |
736189 | 736189 | 2020-11-16 | Jefferson | Indiana | 18077 | 829 | 12 |
736190 | 736190 | 2020-11-16 | Jennings | Indiana | 18079 | 683 | 15 |
736191 | 736191 | 2020-11-16 | Johnson | Indiana | 18081 | 5157 | 169 |
736192 | 736192 | 2020-11-16 | Knox | Indiana | 18083 | 1454 | 13 |
736193 | 736193 | 2020-11-16 | Kosciusko | Indiana | 18085 | 3621 | 39 |
736194 | 736194 | 2020-11-16 | LaGrange | Indiana | 18087 | 1232 | 24 |
736195 | 736195 | 2020-11-16 | LaPorte | Indiana | 18091 | 3852 | 82 |
736196 | 736196 | 2020-11-16 | Lake | Indiana | 18089 | 23228 | 432 |
736197 | 736197 | 2020-11-16 | Lawrence | Indiana | 18093 | 1519 | 45 |
736198 | 736198 | 2020-11-16 | Madison | Indiana | 18095 | 4001 | 125 |
736199 | 736199 | 2020-11-16 | Marion | Indiana | 18097 | 36180 | 876 |
736200 | 736200 | 2020-11-16 | Marshall | Indiana | 18099 | 2501 | 34 |
736201 | 736201 | 2020-11-16 | Martin | Indiana | 18101 | 287 | 2 |
736202 | 736202 | 2020-11-16 | Miami | Indiana | 18103 | 1204 | 10 |
736203 | 736203 | 2020-11-16 | Monroe | Indiana | 18105 | 4499 | 46 |
736204 | 736204 | 2020-11-16 | Montgomery | Indiana | 18107 | 1109 | 25 |
736205 | 736205 | 2020-11-16 | Morgan | Indiana | 18109 | 1692 | 46 |
736206 | 736206 | 2020-11-16 | Newton | Indiana | 18111 | 465 | 13 |
736207 | 736207 | 2020-11-16 | Noble | Indiana | 18113 | 2102 | 44 |
736208 | 736208 | 2020-11-16 | Ohio | Indiana | 18115 | 196 | 7 |
736209 | 736209 | 2020-11-16 | Orange | Indiana | 18117 | 587 | 30 |
736210 | 736210 | 2020-11-16 | Owen | Indiana | 18119 | 471 | 3 |
736211 | 736211 | 2020-11-16 | Parke | Indiana | 18121 | 434 | 6 |
736212 | 736212 | 2020-11-16 | Perry | Indiana | 18123 | 752 | 21 |
736213 | 736213 | 2020-11-16 | Pike | Indiana | 18125 | 457 | 18 |
736214 | 736214 | 2020-11-16 | Porter | Indiana | 18127 | 6675 | 69 |
736215 | 736215 | 2020-11-16 | Posey | Indiana | 18129 | 1069 | 13 |
736216 | 736216 | 2020-11-16 | Pulaski | Indiana | 18131 | 329 | 10 |
736217 | 736217 | 2020-11-16 | Putnam | Indiana | 18133 | 1035 | 24 |
736218 | 736218 | 2020-11-16 | Randolph | Indiana | 18135 | 988 | 13 |
736219 | 736219 | 2020-11-16 | Ripley | Indiana | 18137 | 994 | 12 |
736220 | 736220 | 2020-11-16 | Rush | Indiana | 18139 | 489 | 6 |
736221 | 736221 | 2020-11-16 | Scott | Indiana | 18143 | 794 | 19 |
736222 | 736222 | 2020-11-16 | Shelby | Indiana | 18145 | 2038 | 57 |
736223 | 736223 | 2020-11-16 | Spencer | Indiana | 18147 | 689 | 7 |
736224 | 736224 | 2020-11-16 | St. Joseph | Indiana | 18141 | 14486 | 207 |
736225 | 736225 | 2020-11-16 | Starke | Indiana | 18149 | 771 | 17 |
736226 | 736226 | 2020-11-16 | Steuben | Indiana | 18151 | 1161 | 12 |
736227 | 736227 | 2020-11-16 | Sullivan | Indiana | 18153 | 681 | 15 |
736228 | 736228 | 2020-11-16 | Switzerland | Indiana | 18155 | 210 | 1 |
736229 | 736229 | 2020-11-16 | Tippecanoe | Indiana | 18157 | 6814 | 24 |
736230 | 736230 | 2020-11-16 | Tipton | Indiana | 18159 | 455 | 28 |
736231 | 736231 | 2020-11-16 | Union | Indiana | 18161 | 256 | 1 |
736232 | 736232 | 2020-11-16 | Vanderburgh | Indiana | 18163 | 8397 | 101 |
736233 | 736233 | 2020-11-16 | Vermillion | Indiana | 18165 | 466 | 2 |
736234 | 736234 | 2020-11-16 | Vigo | Indiana | 18167 | 4856 | 67 |
736235 | 736235 | 2020-11-16 | Wabash | Indiana | 18169 | 1148 | 17 |
736236 | 736236 | 2020-11-16 | Warren | Indiana | 18171 | 180 | 1 |
736237 | 736237 | 2020-11-16 | Warrick | Indiana | 18173 | 2827 | 71 |
736238 | 736238 | 2020-11-16 | Washington | Indiana | 18175 | 581 | 5 |
736239 | 736239 | 2020-11-16 | Wayne | Indiana | 18177 | 2851 | 46 |
736240 | 736240 | 2020-11-16 | Wells | Indiana | 18179 | 963 | 22 |
736241 | 736241 | 2020-11-16 | White | Indiana | 18181 | 1003 | 19 |
736242 | 736242 | 2020-11-16 | Whitley | Indiana | 18183 | 1034 | 8 |
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);