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-05-25 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
176126 | 176126 | 2020-05-25 | Adams | Indiana | 18001 | 12 | 1 |
176127 | 176127 | 2020-05-25 | Allen | Indiana | 18003 | 1285 | 74 |
176128 | 176128 | 2020-05-25 | Bartholomew | Indiana | 18005 | 484 | 36 |
176129 | 176129 | 2020-05-25 | Benton | Indiana | 18007 | 25 | 0 |
176130 | 176130 | 2020-05-25 | Blackford | Indiana | 18009 | 21 | 1 |
176131 | 176131 | 2020-05-25 | Boone | Indiana | 18011 | 301 | 38 |
176132 | 176132 | 2020-05-25 | Brown | Indiana | 18013 | 33 | 1 |
176133 | 176133 | 2020-05-25 | Carroll | Indiana | 18015 | 92 | 2 |
176134 | 176134 | 2020-05-25 | Cass | Indiana | 18017 | 1584 | 7 |
176135 | 176135 | 2020-05-25 | Clark | Indiana | 18019 | 465 | 45 |
176136 | 176136 | 2020-05-25 | Clay | Indiana | 18021 | 39 | 1 |
176137 | 176137 | 2020-05-25 | Clinton | Indiana | 18023 | 216 | 2 |
176138 | 176138 | 2020-05-25 | Crawford | Indiana | 18025 | 24 | 1 |
176139 | 176139 | 2020-05-25 | Daviess | Indiana | 18027 | 84 | 18 |
176140 | 176140 | 2020-05-25 | DeKalb | Indiana | 18033 | 30 | 2 |
176141 | 176141 | 2020-05-25 | Dearborn | Indiana | 18029 | 162 | 21 |
176142 | 176142 | 2020-05-25 | Decatur | Indiana | 18031 | 234 | 34 |
176143 | 176143 | 2020-05-25 | Delaware | Indiana | 18035 | 354 | 34 |
176144 | 176144 | 2020-05-25 | Dubois | Indiana | 18037 | 182 | 2 |
176145 | 176145 | 2020-05-25 | Elkhart | Indiana | 18039 | 1013 | 28 |
176146 | 176146 | 2020-05-25 | Fayette | Indiana | 18041 | 99 | 4 |
176147 | 176147 | 2020-05-25 | Floyd | Indiana | 18043 | 315 | 40 |
176148 | 176148 | 2020-05-25 | Fountain | Indiana | 18045 | 18 | 2 |
176149 | 176149 | 2020-05-25 | Franklin | Indiana | 18047 | 112 | 9 |
176150 | 176150 | 2020-05-25 | Fulton | Indiana | 18049 | 47 | 1 |
176151 | 176151 | 2020-05-25 | Gibson | Indiana | 18051 | 14 | 2 |
176152 | 176152 | 2020-05-25 | Grant | Indiana | 18053 | 230 | 22 |
176153 | 176153 | 2020-05-25 | Greene | Indiana | 18055 | 171 | 26 |
176154 | 176154 | 2020-05-25 | Hamilton | Indiana | 18057 | 1112 | 97 |
176155 | 176155 | 2020-05-25 | Hancock | Indiana | 18059 | 323 | 28 |
176156 | 176156 | 2020-05-25 | Harrison | Indiana | 18061 | 186 | 22 |
176157 | 176157 | 2020-05-25 | Hendricks | Indiana | 18063 | 1143 | 80 |
176158 | 176158 | 2020-05-25 | Henry | Indiana | 18065 | 162 | 7 |
176159 | 176159 | 2020-05-25 | Howard | Indiana | 18067 | 359 | 19 |
176160 | 176160 | 2020-05-25 | Huntington | Indiana | 18069 | 26 | 2 |
176161 | 176161 | 2020-05-25 | Jackson | Indiana | 18071 | 365 | 2 |
176162 | 176162 | 2020-05-25 | Jasper | Indiana | 18073 | 57 | 1 |
176163 | 176163 | 2020-05-25 | Jay | Indiana | 18075 | 45 | 0 |
176164 | 176164 | 2020-05-25 | Jefferson | Indiana | 18077 | 42 | 1 |
176165 | 176165 | 2020-05-25 | Jennings | Indiana | 18079 | 129 | 6 |
176166 | 176166 | 2020-05-25 | Johnson | Indiana | 18081 | 1107 | 109 |
176167 | 176167 | 2020-05-25 | Knox | Indiana | 18083 | 25 | 0 |
176168 | 176168 | 2020-05-25 | Kosciusko | Indiana | 18085 | 88 | 2 |
176169 | 176169 | 2020-05-25 | LaGrange | Indiana | 18087 | 61 | 2 |
176170 | 176170 | 2020-05-25 | LaPorte | Indiana | 18091 | 409 | 21 |
176171 | 176171 | 2020-05-25 | Lake | Indiana | 18089 | 3328 | 179 |
176172 | 176172 | 2020-05-25 | Lawrence | Indiana | 18093 | 144 | 23 |
176173 | 176173 | 2020-05-25 | Madison | Indiana | 18095 | 591 | 67 |
176174 | 176174 | 2020-05-25 | Marion | Indiana | 18097 | 9287 | 571 |
176175 | 176175 | 2020-05-25 | Marshall | Indiana | 18099 | 64 | 1 |
176176 | 176176 | 2020-05-25 | Martin | Indiana | 18101 | 9 | 0 |
176177 | 176177 | 2020-05-25 | Miami | Indiana | 18103 | 141 | 1 |
176178 | 176178 | 2020-05-25 | Monroe | Indiana | 18105 | 160 | 10 |
176179 | 176179 | 2020-05-25 | Montgomery | Indiana | 18107 | 228 | 17 |
176180 | 176180 | 2020-05-25 | Morgan | Indiana | 18109 | 269 | 26 |
176181 | 176181 | 2020-05-25 | Newton | Indiana | 18111 | 75 | 11 |
176182 | 176182 | 2020-05-25 | Noble | Indiana | 18113 | 187 | 21 |
176183 | 176183 | 2020-05-25 | Ohio | Indiana | 18115 | 13 | 0 |
176184 | 176184 | 2020-05-25 | Orange | Indiana | 18117 | 126 | 24 |
176185 | 176185 | 2020-05-25 | Owen | Indiana | 18119 | 31 | 1 |
176186 | 176186 | 2020-05-25 | Parke | Indiana | 18121 | 21 | 0 |
176187 | 176187 | 2020-05-25 | Perry | Indiana | 18123 | 38 | 1 |
176188 | 176188 | 2020-05-25 | Pike | Indiana | 18125 | 6 | 0 |
176189 | 176189 | 2020-05-25 | Porter | Indiana | 18127 | 494 | 22 |
176190 | 176190 | 2020-05-25 | Posey | Indiana | 18129 | 17 | 0 |
176191 | 176191 | 2020-05-25 | Pulaski | Indiana | 18131 | 39 | 0 |
176192 | 176192 | 2020-05-25 | Putnam | Indiana | 18133 | 138 | 7 |
176193 | 176193 | 2020-05-25 | Randolph | Indiana | 18135 | 61 | 3 |
176194 | 176194 | 2020-05-25 | Ripley | Indiana | 18137 | 112 | 6 |
176195 | 176195 | 2020-05-25 | Rush | Indiana | 18139 | 59 | 2 |
176196 | 176196 | 2020-05-25 | Scott | Indiana | 18143 | 119 | 3 |
176197 | 176197 | 2020-05-25 | Shelby | Indiana | 18145 | 460 | 29 |
176198 | 176198 | 2020-05-25 | Spencer | Indiana | 18147 | 19 | 1 |
176199 | 176199 | 2020-05-25 | St. Joseph | Indiana | 18141 | 1179 | 39 |
176200 | 176200 | 2020-05-25 | Starke | Indiana | 18149 | 32 | 3 |
176201 | 176201 | 2020-05-25 | Steuben | Indiana | 18151 | 79 | 2 |
176202 | 176202 | 2020-05-25 | Sullivan | Indiana | 18153 | 32 | 1 |
176203 | 176203 | 2020-05-25 | Switzerland | Indiana | 18155 | 20 | 0 |
176204 | 176204 | 2020-05-25 | Tippecanoe | Indiana | 18157 | 375 | 3 |
176205 | 176205 | 2020-05-25 | Tipton | Indiana | 18159 | 22 | 1 |
176206 | 176206 | 2020-05-25 | Union | Indiana | 18161 | 21 | 0 |
176207 | 176207 | 2020-05-25 | Vanderburgh | Indiana | 18163 | 251 | 2 |
176208 | 176208 | 2020-05-25 | Vermillion | Indiana | 18165 | 10 | 0 |
176209 | 176209 | 2020-05-25 | Vigo | Indiana | 18167 | 148 | 8 |
176210 | 176210 | 2020-05-25 | Wabash | Indiana | 18169 | 72 | 2 |
176211 | 176211 | 2020-05-25 | Warren | Indiana | 18171 | 13 | 1 |
176212 | 176212 | 2020-05-25 | Warrick | Indiana | 18173 | 165 | 27 |
176213 | 176213 | 2020-05-25 | Washington | Indiana | 18175 | 52 | 1 |
176214 | 176214 | 2020-05-25 | Wayne | Indiana | 18177 | 209 | 5 |
176215 | 176215 | 2020-05-25 | Wells | Indiana | 18179 | 23 | 0 |
176216 | 176216 | 2020-05-25 | White | Indiana | 18181 | 226 | 8 |
176217 | 176217 | 2020-05-25 | Whitley | Indiana | 18183 | 39 | 2 |
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);