ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-06-09" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
222197 | 222197 | 2020-06-09 | Adams | Indiana | 18001 | 23 | 1 |
222198 | 222198 | 2020-06-09 | Allen | Indiana | 18003 | 1965 | 86 |
222199 | 222199 | 2020-06-09 | Bartholomew | Indiana | 18005 | 544 | 43 |
222200 | 222200 | 2020-06-09 | Benton | Indiana | 18007 | 33 | 0 |
222201 | 222201 | 2020-06-09 | Blackford | Indiana | 18009 | 30 | 2 |
222202 | 222202 | 2020-06-09 | Boone | Indiana | 18011 | 355 | 39 |
222203 | 222203 | 2020-06-09 | Brown | Indiana | 18013 | 35 | 1 |
222204 | 222204 | 2020-06-09 | Carroll | Indiana | 18015 | 95 | 2 |
222205 | 222205 | 2020-06-09 | Cass | Indiana | 18017 | 1596 | 10 |
222206 | 222206 | 2020-06-09 | Clark | Indiana | 18019 | 555 | 49 |
222207 | 222207 | 2020-06-09 | Clay | Indiana | 18021 | 55 | 3 |
222208 | 222208 | 2020-06-09 | Clinton | Indiana | 18023 | 251 | 2 |
222209 | 222209 | 2020-06-09 | Crawford | Indiana | 18025 | 28 | 1 |
222210 | 222210 | 2020-06-09 | Daviess | Indiana | 18027 | 113 | 18 |
222211 | 222211 | 2020-06-09 | DeKalb | Indiana | 18033 | 80 | 2 |
222212 | 222212 | 2020-06-09 | Dearborn | Indiana | 18029 | 176 | 23 |
222213 | 222213 | 2020-06-09 | Decatur | Indiana | 18031 | 250 | 35 |
222214 | 222214 | 2020-06-09 | Delaware | Indiana | 18035 | 402 | 43 |
222215 | 222215 | 2020-06-09 | Dubois | Indiana | 18037 | 231 | 4 |
222216 | 222216 | 2020-06-09 | Elkhart | Indiana | 18039 | 1826 | 31 |
222217 | 222217 | 2020-06-09 | Fayette | Indiana | 18041 | 124 | 7 |
222218 | 222218 | 2020-06-09 | Floyd | Indiana | 18043 | 329 | 44 |
222219 | 222219 | 2020-06-09 | Fountain | Indiana | 18045 | 23 | 2 |
222220 | 222220 | 2020-06-09 | Franklin | Indiana | 18047 | 125 | 9 |
222221 | 222221 | 2020-06-09 | Fulton | Indiana | 18049 | 51 | 1 |
222222 | 222222 | 2020-06-09 | Gibson | Indiana | 18051 | 21 | 2 |
222223 | 222223 | 2020-06-09 | Grant | Indiana | 18053 | 309 | 26 |
222224 | 222224 | 2020-06-09 | Greene | Indiana | 18055 | 179 | 31 |
222225 | 222225 | 2020-06-09 | Hamilton | Indiana | 18057 | 1234 | 99 |
222226 | 222226 | 2020-06-09 | Hancock | Indiana | 18059 | 371 | 29 |
222227 | 222227 | 2020-06-09 | Harrison | Indiana | 18061 | 200 | 24 |
222228 | 222228 | 2020-06-09 | Hendricks | Indiana | 18063 | 1245 | 96 |
222229 | 222229 | 2020-06-09 | Henry | Indiana | 18065 | 194 | 12 |
222230 | 222230 | 2020-06-09 | Howard | Indiana | 18067 | 454 | 44 |
222231 | 222231 | 2020-06-09 | Huntington | Indiana | 18069 | 46 | 2 |
222232 | 222232 | 2020-06-09 | Jackson | Indiana | 18071 | 410 | 3 |
222233 | 222233 | 2020-06-09 | Jasper | Indiana | 18073 | 81 | 1 |
222234 | 222234 | 2020-06-09 | Jay | Indiana | 18075 | 61 | 0 |
222235 | 222235 | 2020-06-09 | Jefferson | Indiana | 18077 | 53 | 1 |
222236 | 222236 | 2020-06-09 | Jennings | Indiana | 18079 | 135 | 6 |
222237 | 222237 | 2020-06-09 | Johnson | Indiana | 18081 | 1172 | 122 |
222238 | 222238 | 2020-06-09 | Knox | Indiana | 18083 | 34 | 0 |
222239 | 222239 | 2020-06-09 | Kosciusko | Indiana | 18085 | 244 | 3 |
222240 | 222240 | 2020-06-09 | LaGrange | Indiana | 18087 | 182 | 2 |
222241 | 222241 | 2020-06-09 | LaPorte | Indiana | 18091 | 463 | 24 |
222242 | 222242 | 2020-06-09 | Lake | Indiana | 18089 | 4040 | 232 |
222243 | 222243 | 2020-06-09 | Lawrence | Indiana | 18093 | 173 | 25 |
222244 | 222244 | 2020-06-09 | Madison | Indiana | 18095 | 615 | 71 |
222245 | 222245 | 2020-06-09 | Marion | Indiana | 18097 | 10559 | 676 |
222246 | 222246 | 2020-06-09 | Marshall | Indiana | 18099 | 230 | 2 |
222247 | 222247 | 2020-06-09 | Martin | Indiana | 18101 | 15 | 0 |
222248 | 222248 | 2020-06-09 | Miami | Indiana | 18103 | 156 | 1 |
222249 | 222249 | 2020-06-09 | Monroe | Indiana | 18105 | 181 | 19 |
222250 | 222250 | 2020-06-09 | Montgomery | Indiana | 18107 | 261 | 20 |
222251 | 222251 | 2020-06-09 | Morgan | Indiana | 18109 | 303 | 30 |
222252 | 222252 | 2020-06-09 | Newton | Indiana | 18111 | 82 | 11 |
222253 | 222253 | 2020-06-09 | Noble | Indiana | 18113 | 307 | 24 |
222254 | 222254 | 2020-06-09 | Ohio | Indiana | 18115 | 13 | 0 |
222255 | 222255 | 2020-06-09 | Orange | Indiana | 18117 | 134 | 25 |
222256 | 222256 | 2020-06-09 | Owen | Indiana | 18119 | 36 | 1 |
222257 | 222257 | 2020-06-09 | Parke | Indiana | 18121 | 24 | 0 |
222258 | 222258 | 2020-06-09 | Perry | Indiana | 18123 | 58 | 2 |
222259 | 222259 | 2020-06-09 | Pike | Indiana | 18125 | 6 | 0 |
222260 | 222260 | 2020-06-09 | Porter | Indiana | 18127 | 584 | 35 |
222261 | 222261 | 2020-06-09 | Posey | Indiana | 18129 | 17 | 0 |
222262 | 222262 | 2020-06-09 | Pulaski | Indiana | 18131 | 53 | 1 |
222263 | 222263 | 2020-06-09 | Putnam | Indiana | 18133 | 152 | 7 |
222264 | 222264 | 2020-06-09 | Randolph | Indiana | 18135 | 79 | 3 |
222265 | 222265 | 2020-06-09 | Ripley | Indiana | 18137 | 110 | 6 |
222266 | 222266 | 2020-06-09 | Rush | Indiana | 18139 | 67 | 3 |
222267 | 222267 | 2020-06-09 | Scott | Indiana | 18143 | 132 | 3 |
222268 | 222268 | 2020-06-09 | Shelby | Indiana | 18145 | 592 | 30 |
222269 | 222269 | 2020-06-09 | Spencer | Indiana | 18147 | 25 | 1 |
222270 | 222270 | 2020-06-09 | St. Joseph | Indiana | 18141 | 1447 | 48 |
222271 | 222271 | 2020-06-09 | Starke | Indiana | 18149 | 47 | 3 |
222272 | 222272 | 2020-06-09 | Steuben | Indiana | 18151 | 95 | 2 |
222273 | 222273 | 2020-06-09 | Sullivan | Indiana | 18153 | 40 | 1 |
222274 | 222274 | 2020-06-09 | Switzerland | Indiana | 18155 | 23 | 0 |
222275 | 222275 | 2020-06-09 | Tippecanoe | Indiana | 18157 | 462 | 5 |
222276 | 222276 | 2020-06-09 | Tipton | Indiana | 18159 | 28 | 2 |
222277 | 222277 | 2020-06-09 | Union | Indiana | 18161 | 26 | 0 |
222278 | 222278 | 2020-06-09 | Vanderburgh | Indiana | 18163 | 311 | 4 |
222279 | 222279 | 2020-06-09 | Vermillion | Indiana | 18165 | 11 | 0 |
222280 | 222280 | 2020-06-09 | Vigo | Indiana | 18167 | 198 | 9 |
222281 | 222281 | 2020-06-09 | Wabash | Indiana | 18169 | 87 | 2 |
222282 | 222282 | 2020-06-09 | Warren | Indiana | 18171 | 14 | 1 |
222283 | 222283 | 2020-06-09 | Warrick | Indiana | 18173 | 169 | 30 |
222284 | 222284 | 2020-06-09 | Washington | Indiana | 18175 | 52 | 1 |
222285 | 222285 | 2020-06-09 | Wayne | Indiana | 18177 | 248 | 6 |
222286 | 222286 | 2020-06-09 | Wells | Indiana | 18179 | 43 | 0 |
222287 | 222287 | 2020-06-09 | White | Indiana | 18181 | 242 | 9 |
222288 | 222288 | 2020-06-09 | Whitley | Indiana | 18183 | 55 | 3 |
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);