ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where date = "2020-03-31" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22260 | 22260 | 2020-03-31 | Adams | Indiana | 18001 | 1 | 0 |
22261 | 22261 | 2020-03-31 | Allen | Indiana | 18003 | 37 | 3 |
22262 | 22262 | 2020-03-31 | Bartholomew | Indiana | 18005 | 13 | 0 |
22263 | 22263 | 2020-03-31 | Boone | Indiana | 18011 | 22 | 0 |
22264 | 22264 | 2020-03-31 | Brown | Indiana | 18013 | 3 | 0 |
22265 | 22265 | 2020-03-31 | Carroll | Indiana | 18015 | 2 | 0 |
22266 | 22266 | 2020-03-31 | Cass | Indiana | 18017 | 1 | 0 |
22267 | 22267 | 2020-03-31 | Clark | Indiana | 18019 | 33 | 0 |
22268 | 22268 | 2020-03-31 | Clay | Indiana | 18021 | 1 | 0 |
22269 | 22269 | 2020-03-31 | Clinton | Indiana | 18023 | 1 | 0 |
22270 | 22270 | 2020-03-31 | Crawford | Indiana | 18025 | 1 | 0 |
22271 | 22271 | 2020-03-31 | DeKalb | Indiana | 18033 | 1 | 0 |
22272 | 22272 | 2020-03-31 | Dearborn | Indiana | 18029 | 14 | 1 |
22273 | 22273 | 2020-03-31 | Decatur | Indiana | 18031 | 47 | 1 |
22274 | 22274 | 2020-03-31 | Delaware | Indiana | 18035 | 18 | 1 |
22275 | 22275 | 2020-03-31 | Dubois | Indiana | 18037 | 3 | 0 |
22276 | 22276 | 2020-03-31 | Elkhart | Indiana | 18039 | 20 | 1 |
22277 | 22277 | 2020-03-31 | Fayette | Indiana | 18041 | 9 | 1 |
22278 | 22278 | 2020-03-31 | Floyd | Indiana | 18043 | 21 | 0 |
22279 | 22279 | 2020-03-31 | Fountain | Indiana | 18045 | 1 | 0 |
22280 | 22280 | 2020-03-31 | Franklin | Indiana | 18047 | 35 | 4 |
22281 | 22281 | 2020-03-31 | Fulton | Indiana | 18049 | 1 | 0 |
22282 | 22282 | 2020-03-31 | Gibson | Indiana | 18051 | 4 | 0 |
22283 | 22283 | 2020-03-31 | Grant | Indiana | 18053 | 7 | 0 |
22284 | 22284 | 2020-03-31 | Greene | Indiana | 18055 | 2 | 0 |
22285 | 22285 | 2020-03-31 | Hamilton | Indiana | 18057 | 127 | 0 |
22286 | 22286 | 2020-03-31 | Hancock | Indiana | 18059 | 26 | 2 |
22287 | 22287 | 2020-03-31 | Harrison | Indiana | 18061 | 15 | 0 |
22288 | 22288 | 2020-03-31 | Hendricks | Indiana | 18063 | 70 | 1 |
22289 | 22289 | 2020-03-31 | Henry | Indiana | 18065 | 1 | 0 |
22290 | 22290 | 2020-03-31 | Howard | Indiana | 18067 | 17 | 2 |
22291 | 22291 | 2020-03-31 | Huntington | Indiana | 18069 | 2 | 0 |
22292 | 22292 | 2020-03-31 | Jackson | Indiana | 18071 | 8 | 0 |
22293 | 22293 | 2020-03-31 | Jasper | Indiana | 18073 | 8 | 1 |
22294 | 22294 | 2020-03-31 | Jefferson | Indiana | 18077 | 1 | 0 |
22295 | 22295 | 2020-03-31 | Jennings | Indiana | 18079 | 16 | 1 |
22296 | 22296 | 2020-03-31 | Johnson | Indiana | 18081 | 101 | 3 |
22297 | 22297 | 2020-03-31 | Knox | Indiana | 18083 | 2 | 0 |
22298 | 22298 | 2020-03-31 | Kosciusko | Indiana | 18085 | 5 | 0 |
22299 | 22299 | 2020-03-31 | LaGrange | Indiana | 18087 | 2 | 0 |
22300 | 22300 | 2020-03-31 | LaPorte | Indiana | 18091 | 8 | 0 |
22301 | 22301 | 2020-03-31 | Lake | Indiana | 18089 | 147 | 6 |
22302 | 22302 | 2020-03-31 | Lawrence | Indiana | 18093 | 9 | 0 |
22303 | 22303 | 2020-03-31 | Madison | Indiana | 18095 | 41 | 4 |
22304 | 22304 | 2020-03-31 | Marion | Indiana | 18097 | 965 | 18 |
22305 | 22305 | 2020-03-31 | Marshall | Indiana | 18099 | 3 | 0 |
22306 | 22306 | 2020-03-31 | Miami | Indiana | 18103 | 3 | 0 |
22307 | 22307 | 2020-03-31 | Monroe | Indiana | 18105 | 30 | 0 |
22308 | 22308 | 2020-03-31 | Montgomery | Indiana | 18107 | 6 | 0 |
22309 | 22309 | 2020-03-31 | Morgan | Indiana | 18109 | 32 | 1 |
22310 | 22310 | 2020-03-31 | Newton | Indiana | 18111 | 1 | 0 |
22311 | 22311 | 2020-03-31 | Noble | Indiana | 18113 | 2 | 0 |
22312 | 22312 | 2020-03-31 | Ohio | Indiana | 18115 | 1 | 0 |
22313 | 22313 | 2020-03-31 | Orange | Indiana | 18117 | 3 | 0 |
22314 | 22314 | 2020-03-31 | Owen | Indiana | 18119 | 11 | 0 |
22315 | 22315 | 2020-03-31 | Porter | Indiana | 18127 | 21 | 0 |
22316 | 22316 | 2020-03-31 | Posey | Indiana | 18129 | 4 | 0 |
22317 | 22317 | 2020-03-31 | Putnam | Indiana | 18133 | 7 | 1 |
22318 | 22318 | 2020-03-31 | Randolph | Indiana | 18135 | 3 | 0 |
22319 | 22319 | 2020-03-31 | Ripley | Indiana | 18137 | 31 | 1 |
22320 | 22320 | 2020-03-31 | Rush | Indiana | 18139 | 4 | 0 |
22321 | 22321 | 2020-03-31 | Scott | Indiana | 18143 | 1 | 1 |
22322 | 22322 | 2020-03-31 | Shelby | Indiana | 18145 | 15 | 0 |
22323 | 22323 | 2020-03-31 | St. Joseph | Indiana | 18141 | 51 | 3 |
22324 | 22324 | 2020-03-31 | Starke | Indiana | 18149 | 1 | 0 |
22325 | 22325 | 2020-03-31 | Steuben | Indiana | 18151 | 1 | 0 |
22326 | 22326 | 2020-03-31 | Sullivan | Indiana | 18153 | 2 | 0 |
22327 | 22327 | 2020-03-31 | Switzerland | Indiana | 18155 | 3 | 0 |
22328 | 22328 | 2020-03-31 | Tippecanoe | Indiana | 18157 | 14 | 1 |
22329 | 22329 | 2020-03-31 | Tipton | Indiana | 18159 | 4 | 0 |
22330 | 22330 | 2020-03-31 | Vanderburgh | Indiana | 18163 | 18 | 0 |
22331 | 22331 | 2020-03-31 | Vermillion | Indiana | 18165 | 1 | 0 |
22332 | 22332 | 2020-03-31 | Vigo | Indiana | 18167 | 10 | 2 |
22333 | 22333 | 2020-03-31 | Wabash | Indiana | 18169 | 1 | 0 |
22334 | 22334 | 2020-03-31 | Warren | Indiana | 18171 | 2 | 1 |
22335 | 22335 | 2020-03-31 | Warrick | Indiana | 18173 | 8 | 0 |
22336 | 22336 | 2020-03-31 | Washington | Indiana | 18175 | 6 | 0 |
22337 | 22337 | 2020-03-31 | Wayne | Indiana | 18177 | 2 | 0 |
22338 | 22338 | 2020-03-31 | Wells | Indiana | 18179 | 2 | 0 |
22339 | 22339 | 2020-03-31 | White | Indiana | 18181 | 2 | 0 |
22340 | 22340 | 2020-03-31 | Whitley | Indiana | 18183 | 2 | 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);