ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where "date" is on date 2020-03-28 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16260 | 16260 | 2020-03-28 | Adams | Indiana | 18001 | 1 | 0 |
16261 | 16261 | 2020-03-28 | Allen | Indiana | 18003 | 24 | 2 |
16262 | 16262 | 2020-03-28 | Bartholomew | Indiana | 18005 | 7 | 0 |
16263 | 16263 | 2020-03-28 | Boone | Indiana | 18011 | 8 | 0 |
16264 | 16264 | 2020-03-28 | Brown | Indiana | 18013 | 2 | 0 |
16265 | 16265 | 2020-03-28 | Carroll | Indiana | 18015 | 1 | 0 |
16266 | 16266 | 2020-03-28 | Clark | Indiana | 18019 | 18 | 0 |
16267 | 16267 | 2020-03-28 | Clinton | Indiana | 18023 | 1 | 0 |
16268 | 16268 | 2020-03-28 | Crawford | Indiana | 18025 | 1 | 0 |
16269 | 16269 | 2020-03-28 | DeKalb | Indiana | 18033 | 1 | 0 |
16270 | 16270 | 2020-03-28 | Dearborn | Indiana | 18029 | 8 | 1 |
16271 | 16271 | 2020-03-28 | Decatur | Indiana | 18031 | 30 | 0 |
16272 | 16272 | 2020-03-28 | Delaware | Indiana | 18035 | 8 | 1 |
16273 | 16273 | 2020-03-28 | Dubois | Indiana | 18037 | 1 | 0 |
16274 | 16274 | 2020-03-28 | Elkhart | Indiana | 18039 | 11 | 0 |
16275 | 16275 | 2020-03-28 | Fayette | Indiana | 18041 | 4 | 1 |
16276 | 16276 | 2020-03-28 | Floyd | Indiana | 18043 | 13 | 0 |
16277 | 16277 | 2020-03-28 | Fountain | Indiana | 18045 | 1 | 0 |
16278 | 16278 | 2020-03-28 | Franklin | Indiana | 18047 | 23 | 2 |
16279 | 16279 | 2020-03-28 | Fulton | Indiana | 18049 | 1 | 0 |
16280 | 16280 | 2020-03-28 | Gibson | Indiana | 18051 | 4 | 0 |
16281 | 16281 | 2020-03-28 | Grant | Indiana | 18053 | 5 | 0 |
16282 | 16282 | 2020-03-28 | Hamilton | Indiana | 18057 | 64 | 0 |
16283 | 16283 | 2020-03-28 | Hancock | Indiana | 18059 | 19 | 1 |
16284 | 16284 | 2020-03-28 | Harrison | Indiana | 18061 | 7 | 0 |
16285 | 16285 | 2020-03-28 | Hendricks | Indiana | 18063 | 36 | 2 |
16286 | 16286 | 2020-03-28 | Henry | Indiana | 18065 | 1 | 0 |
16287 | 16287 | 2020-03-28 | Howard | Indiana | 18067 | 9 | 1 |
16288 | 16288 | 2020-03-28 | Huntington | Indiana | 18069 | 1 | 0 |
16289 | 16289 | 2020-03-28 | Jackson | Indiana | 18071 | 7 | 0 |
16290 | 16290 | 2020-03-28 | Jasper | Indiana | 18073 | 5 | 1 |
16291 | 16291 | 2020-03-28 | Jennings | Indiana | 18079 | 11 | 1 |
16292 | 16292 | 2020-03-28 | Johnson | Indiana | 18081 | 52 | 3 |
16293 | 16293 | 2020-03-28 | Kosciusko | Indiana | 18085 | 2 | 0 |
16294 | 16294 | 2020-03-28 | LaGrange | Indiana | 18087 | 2 | 0 |
16295 | 16295 | 2020-03-28 | LaPorte | Indiana | 18091 | 4 | 0 |
16296 | 16296 | 2020-03-28 | Lake | Indiana | 18089 | 68 | 1 |
16297 | 16297 | 2020-03-28 | Lawrence | Indiana | 18093 | 4 | 0 |
16298 | 16298 | 2020-03-28 | Madison | Indiana | 18095 | 15 | 4 |
16299 | 16299 | 2020-03-28 | Marion | Indiana | 18097 | 585 | 11 |
16300 | 16300 | 2020-03-28 | Marshall | Indiana | 18099 | 3 | 0 |
16301 | 16301 | 2020-03-28 | Miami | Indiana | 18103 | 1 | 0 |
16302 | 16302 | 2020-03-28 | Monroe | Indiana | 18105 | 16 | 0 |
16303 | 16303 | 2020-03-28 | Montgomery | Indiana | 18107 | 4 | 0 |
16304 | 16304 | 2020-03-28 | Morgan | Indiana | 18109 | 14 | 0 |
16305 | 16305 | 2020-03-28 | Newton | Indiana | 18111 | 1 | 0 |
16306 | 16306 | 2020-03-28 | Noble | Indiana | 18113 | 2 | 0 |
16307 | 16307 | 2020-03-28 | Ohio | Indiana | 18115 | 1 | 0 |
16308 | 16308 | 2020-03-28 | Orange | Indiana | 18117 | 1 | 0 |
16309 | 16309 | 2020-03-28 | Owen | Indiana | 18119 | 7 | 0 |
16310 | 16310 | 2020-03-28 | Porter | Indiana | 18127 | 9 | 0 |
16311 | 16311 | 2020-03-28 | Posey | Indiana | 18129 | 2 | 0 |
16312 | 16312 | 2020-03-28 | Putnam | Indiana | 18133 | 5 | 1 |
16313 | 16313 | 2020-03-28 | Randolph | Indiana | 18135 | 1 | 0 |
16314 | 16314 | 2020-03-28 | Ripley | Indiana | 18137 | 15 | 0 |
16315 | 16315 | 2020-03-28 | Rush | Indiana | 18139 | 2 | 0 |
16316 | 16316 | 2020-03-28 | Scott | Indiana | 18143 | 1 | 1 |
16317 | 16317 | 2020-03-28 | Shelby | Indiana | 18145 | 10 | 0 |
16318 | 16318 | 2020-03-28 | St. Joseph | Indiana | 18141 | 32 | 2 |
16319 | 16319 | 2020-03-28 | Starke | Indiana | 18149 | 1 | 0 |
16320 | 16320 | 2020-03-28 | Sullivan | Indiana | 18153 | 1 | 0 |
16321 | 16321 | 2020-03-28 | Switzerland | Indiana | 18155 | 1 | 0 |
16322 | 16322 | 2020-03-28 | Tippecanoe | Indiana | 18157 | 11 | 1 |
16323 | 16323 | 2020-03-28 | Tipton | Indiana | 18159 | 2 | 0 |
16324 | 16324 | 2020-03-28 | Vanderburgh | Indiana | 18163 | 10 | 0 |
16325 | 16325 | 2020-03-28 | Vermillion | Indiana | 18165 | 1 | 0 |
16326 | 16326 | 2020-03-28 | Vigo | Indiana | 18167 | 4 | 1 |
16327 | 16327 | 2020-03-28 | Wabash | Indiana | 18169 | 1 | 0 |
16328 | 16328 | 2020-03-28 | Warren | Indiana | 18171 | 1 | 0 |
16329 | 16329 | 2020-03-28 | Warrick | Indiana | 18173 | 6 | 0 |
16330 | 16330 | 2020-03-28 | Washington | Indiana | 18175 | 4 | 0 |
16331 | 16331 | 2020-03-28 | Wayne | Indiana | 18177 | 1 | 0 |
16332 | 16332 | 2020-03-28 | Wells | Indiana | 18179 | 1 | 0 |
16333 | 16333 | 2020-03-28 | White | Indiana | 18181 | 1 | 0 |
16334 | 16334 | 2020-03-28 | 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);