ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2020-03-29 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
18161 | 18161 | 2020-03-29 | Adams | Indiana | 18001 | 1 | 0 |
18162 | 18162 | 2020-03-29 | Allen | Indiana | 18003 | 27 | 2 |
18163 | 18163 | 2020-03-29 | Bartholomew | Indiana | 18005 | 10 | 0 |
18164 | 18164 | 2020-03-29 | Boone | Indiana | 18011 | 13 | 0 |
18165 | 18165 | 2020-03-29 | Brown | Indiana | 18013 | 3 | 0 |
18166 | 18166 | 2020-03-29 | Carroll | Indiana | 18015 | 1 | 0 |
18167 | 18167 | 2020-03-29 | Clark | Indiana | 18019 | 20 | 0 |
18168 | 18168 | 2020-03-29 | Clay | Indiana | 18021 | 1 | 0 |
18169 | 18169 | 2020-03-29 | Clinton | Indiana | 18023 | 1 | 0 |
18170 | 18170 | 2020-03-29 | Crawford | Indiana | 18025 | 1 | 0 |
18171 | 18171 | 2020-03-29 | DeKalb | Indiana | 18033 | 1 | 0 |
18172 | 18172 | 2020-03-29 | Dearborn | Indiana | 18029 | 10 | 1 |
18173 | 18173 | 2020-03-29 | Decatur | Indiana | 18031 | 40 | 0 |
18174 | 18174 | 2020-03-29 | Delaware | Indiana | 18035 | 14 | 1 |
18175 | 18175 | 2020-03-29 | Dubois | Indiana | 18037 | 2 | 0 |
18176 | 18176 | 2020-03-29 | Elkhart | Indiana | 18039 | 12 | 0 |
18177 | 18177 | 2020-03-29 | Fayette | Indiana | 18041 | 5 | 1 |
18178 | 18178 | 2020-03-29 | Floyd | Indiana | 18043 | 14 | 0 |
18179 | 18179 | 2020-03-29 | Fountain | Indiana | 18045 | 1 | 0 |
18180 | 18180 | 2020-03-29 | Franklin | Indiana | 18047 | 26 | 3 |
18181 | 18181 | 2020-03-29 | Fulton | Indiana | 18049 | 1 | 0 |
18182 | 18182 | 2020-03-29 | Gibson | Indiana | 18051 | 4 | 0 |
18183 | 18183 | 2020-03-29 | Grant | Indiana | 18053 | 7 | 0 |
18184 | 18184 | 2020-03-29 | Greene | Indiana | 18055 | 1 | 0 |
18185 | 18185 | 2020-03-29 | Hamilton | Indiana | 18057 | 83 | 0 |
18186 | 18186 | 2020-03-29 | Hancock | Indiana | 18059 | 22 | 1 |
18187 | 18187 | 2020-03-29 | Harrison | Indiana | 18061 | 14 | 0 |
18188 | 18188 | 2020-03-29 | Hendricks | Indiana | 18063 | 48 | 1 |
18189 | 18189 | 2020-03-29 | Henry | Indiana | 18065 | 2 | 0 |
18190 | 18190 | 2020-03-29 | Howard | Indiana | 18067 | 13 | 2 |
18191 | 18191 | 2020-03-29 | Huntington | Indiana | 18069 | 1 | 0 |
18192 | 18192 | 2020-03-29 | Jackson | Indiana | 18071 | 7 | 0 |
18193 | 18193 | 2020-03-29 | Jasper | Indiana | 18073 | 6 | 1 |
18194 | 18194 | 2020-03-29 | Jennings | Indiana | 18079 | 14 | 1 |
18195 | 18195 | 2020-03-29 | Johnson | Indiana | 18081 | 71 | 3 |
18196 | 18196 | 2020-03-29 | Knox | Indiana | 18083 | 2 | 0 |
18197 | 18197 | 2020-03-29 | Kosciusko | Indiana | 18085 | 3 | 0 |
18198 | 18198 | 2020-03-29 | LaGrange | Indiana | 18087 | 2 | 0 |
18199 | 18199 | 2020-03-29 | LaPorte | Indiana | 18091 | 6 | 0 |
18200 | 18200 | 2020-03-29 | Lake | Indiana | 18089 | 85 | 1 |
18201 | 18201 | 2020-03-29 | Lawrence | Indiana | 18093 | 8 | 0 |
18202 | 18202 | 2020-03-29 | Madison | Indiana | 18095 | 21 | 4 |
18203 | 18203 | 2020-03-29 | Marion | Indiana | 18097 | 677 | 11 |
18204 | 18204 | 2020-03-29 | Marshall | Indiana | 18099 | 3 | 0 |
18205 | 18205 | 2020-03-29 | Miami | Indiana | 18103 | 1 | 0 |
18206 | 18206 | 2020-03-29 | Monroe | Indiana | 18105 | 22 | 0 |
18207 | 18207 | 2020-03-29 | Montgomery | Indiana | 18107 | 5 | 0 |
18208 | 18208 | 2020-03-29 | Morgan | Indiana | 18109 | 20 | 1 |
18209 | 18209 | 2020-03-29 | Newton | Indiana | 18111 | 1 | 0 |
18210 | 18210 | 2020-03-29 | Noble | Indiana | 18113 | 2 | 0 |
18211 | 18211 | 2020-03-29 | Ohio | Indiana | 18115 | 1 | 0 |
18212 | 18212 | 2020-03-29 | Orange | Indiana | 18117 | 1 | 0 |
18213 | 18213 | 2020-03-29 | Owen | Indiana | 18119 | 9 | 0 |
18214 | 18214 | 2020-03-29 | Porter | Indiana | 18127 | 14 | 0 |
18215 | 18215 | 2020-03-29 | Posey | Indiana | 18129 | 3 | 0 |
18216 | 18216 | 2020-03-29 | Putnam | Indiana | 18133 | 5 | 1 |
18217 | 18217 | 2020-03-29 | Randolph | Indiana | 18135 | 1 | 0 |
18218 | 18218 | 2020-03-29 | Ripley | Indiana | 18137 | 19 | 0 |
18219 | 18219 | 2020-03-29 | Rush | Indiana | 18139 | 2 | 0 |
18220 | 18220 | 2020-03-29 | Scott | Indiana | 18143 | 1 | 1 |
18221 | 18221 | 2020-03-29 | Shelby | Indiana | 18145 | 12 | 0 |
18222 | 18222 | 2020-03-29 | St. Joseph | Indiana | 18141 | 33 | 2 |
18223 | 18223 | 2020-03-29 | Starke | Indiana | 18149 | 1 | 0 |
18224 | 18224 | 2020-03-29 | Steuben | Indiana | 18151 | 1 | 0 |
18225 | 18225 | 2020-03-29 | Sullivan | Indiana | 18153 | 1 | 0 |
18226 | 18226 | 2020-03-29 | Switzerland | Indiana | 18155 | 3 | 0 |
18227 | 18227 | 2020-03-29 | Tippecanoe | Indiana | 18157 | 11 | 1 |
18228 | 18228 | 2020-03-29 | Tipton | Indiana | 18159 | 4 | 0 |
18229 | 18229 | 2020-03-29 | Vanderburgh | Indiana | 18163 | 17 | 0 |
18230 | 18230 | 2020-03-29 | Vermillion | Indiana | 18165 | 1 | 0 |
18231 | 18231 | 2020-03-29 | Vigo | Indiana | 18167 | 7 | 1 |
18232 | 18232 | 2020-03-29 | Wabash | Indiana | 18169 | 1 | 0 |
18233 | 18233 | 2020-03-29 | Warren | Indiana | 18171 | 2 | 0 |
18234 | 18234 | 2020-03-29 | Warrick | Indiana | 18173 | 8 | 0 |
18235 | 18235 | 2020-03-29 | Washington | Indiana | 18175 | 5 | 0 |
18236 | 18236 | 2020-03-29 | Wayne | Indiana | 18177 | 1 | 0 |
18237 | 18237 | 2020-03-29 | Wells | Indiana | 18179 | 1 | 0 |
18238 | 18238 | 2020-03-29 | White | Indiana | 18181 | 1 | 0 |
18239 | 18239 | 2020-03-29 | Whitley | Indiana | 18183 | 1 | 0 |
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);