ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-08-08" 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 |
---|---|---|---|---|---|---|---|
412377 | 412377 | 2020-08-08 | Adams | Indiana | 18001 | 97 | 3 |
412378 | 412378 | 2020-08-08 | Allen | Indiana | 18003 | 3861 | 173 |
412379 | 412379 | 2020-08-08 | Bartholomew | Indiana | 18005 | 790 | 50 |
412380 | 412380 | 2020-08-08 | Benton | Indiana | 18007 | 61 | 0 |
412381 | 412381 | 2020-08-08 | Blackford | Indiana | 18009 | 68 | 2 |
412382 | 412382 | 2020-08-08 | Boone | Indiana | 18011 | 691 | 49 |
412383 | 412383 | 2020-08-08 | Brown | Indiana | 18013 | 73 | 1 |
412384 | 412384 | 2020-08-08 | Carroll | Indiana | 18015 | 185 | 2 |
412385 | 412385 | 2020-08-08 | Cass | Indiana | 18017 | 1789 | 10 |
412386 | 412386 | 2020-08-08 | Clark | Indiana | 18019 | 1217 | 54 |
412387 | 412387 | 2020-08-08 | Clay | Indiana | 18021 | 116 | 5 |
412388 | 412388 | 2020-08-08 | Clinton | Indiana | 18023 | 431 | 4 |
412389 | 412389 | 2020-08-08 | Crawford | Indiana | 18025 | 45 | 1 |
412390 | 412390 | 2020-08-08 | Daviess | Indiana | 18027 | 266 | 22 |
412391 | 412391 | 2020-08-08 | DeKalb | Indiana | 18033 | 231 | 5 |
412392 | 412392 | 2020-08-08 | Dearborn | Indiana | 18029 | 499 | 30 |
412393 | 412393 | 2020-08-08 | Decatur | Indiana | 18031 | 357 | 35 |
412394 | 412394 | 2020-08-08 | Delaware | Indiana | 18035 | 717 | 53 |
412395 | 412395 | 2020-08-08 | Dubois | Indiana | 18037 | 687 | 12 |
412396 | 412396 | 2020-08-08 | Elkhart | Indiana | 18039 | 4891 | 88 |
412397 | 412397 | 2020-08-08 | Fayette | Indiana | 18041 | 258 | 7 |
412398 | 412398 | 2020-08-08 | Floyd | Indiana | 18043 | 776 | 49 |
412399 | 412399 | 2020-08-08 | Fountain | Indiana | 18045 | 73 | 2 |
412400 | 412400 | 2020-08-08 | Franklin | Indiana | 18047 | 251 | 15 |
412401 | 412401 | 2020-08-08 | Fulton | Indiana | 18049 | 166 | 2 |
412402 | 412402 | 2020-08-08 | Gibson | Indiana | 18051 | 222 | 4 |
412403 | 412403 | 2020-08-08 | Grant | Indiana | 18053 | 780 | 33 |
412404 | 412404 | 2020-08-08 | Greene | Indiana | 18055 | 251 | 37 |
412405 | 412405 | 2020-08-08 | Hamilton | Indiana | 18057 | 2752 | 112 |
412406 | 412406 | 2020-08-08 | Hancock | Indiana | 18059 | 655 | 39 |
412407 | 412407 | 2020-08-08 | Harrison | Indiana | 18061 | 329 | 25 |
412408 | 412408 | 2020-08-08 | Hendricks | Indiana | 18063 | 1897 | 124 |
412409 | 412409 | 2020-08-08 | Henry | Indiana | 18065 | 382 | 20 |
412410 | 412410 | 2020-08-08 | Howard | Indiana | 18067 | 891 | 68 |
412411 | 412411 | 2020-08-08 | Huntington | Indiana | 18069 | 123 | 3 |
412412 | 412412 | 2020-08-08 | Jackson | Indiana | 18071 | 589 | 6 |
412413 | 412413 | 2020-08-08 | Jasper | Indiana | 18073 | 235 | 2 |
412414 | 412414 | 2020-08-08 | Jay | Indiana | 18075 | 96 | 0 |
412415 | 412415 | 2020-08-08 | Jefferson | Indiana | 18077 | 161 | 2 |
412416 | 412416 | 2020-08-08 | Jennings | Indiana | 18079 | 226 | 14 |
412417 | 412417 | 2020-08-08 | Johnson | Indiana | 18081 | 1775 | 126 |
412418 | 412418 | 2020-08-08 | Knox | Indiana | 18083 | 152 | 0 |
412419 | 412419 | 2020-08-08 | Kosciusko | Indiana | 18085 | 866 | 13 |
412420 | 412420 | 2020-08-08 | LaGrange | Indiana | 18087 | 559 | 10 |
412421 | 412421 | 2020-08-08 | LaPorte | Indiana | 18091 | 898 | 30 |
412422 | 412422 | 2020-08-08 | Lake | Indiana | 18089 | 7538 | 291 |
412423 | 412423 | 2020-08-08 | Lawrence | Indiana | 18093 | 343 | 28 |
412424 | 412424 | 2020-08-08 | Madison | Indiana | 18095 | 958 | 76 |
412425 | 412425 | 2020-08-08 | Marion | Indiana | 18097 | 15849 | 773 |
412426 | 412426 | 2020-08-08 | Marshall | Indiana | 18099 | 774 | 22 |
412427 | 412427 | 2020-08-08 | Martin | Indiana | 18101 | 43 | 0 |
412428 | 412428 | 2020-08-08 | Miami | Indiana | 18103 | 273 | 2 |
412429 | 412429 | 2020-08-08 | Monroe | Indiana | 18105 | 750 | 33 |
412430 | 412430 | 2020-08-08 | Montgomery | Indiana | 18107 | 354 | 22 |
412431 | 412431 | 2020-08-08 | Morgan | Indiana | 18109 | 479 | 37 |
412432 | 412432 | 2020-08-08 | Newton | Indiana | 18111 | 119 | 11 |
412433 | 412433 | 2020-08-08 | Noble | Indiana | 18113 | 667 | 30 |
412434 | 412434 | 2020-08-08 | Ohio | Indiana | 18115 | 63 | 5 |
412435 | 412435 | 2020-08-08 | Orange | Indiana | 18117 | 171 | 26 |
412436 | 412436 | 2020-08-08 | Owen | Indiana | 18119 | 88 | 1 |
412437 | 412437 | 2020-08-08 | Parke | Indiana | 18121 | 56 | 1 |
412438 | 412438 | 2020-08-08 | Perry | Indiana | 18123 | 195 | 13 |
412439 | 412439 | 2020-08-08 | Pike | Indiana | 18125 | 53 | 0 |
412440 | 412440 | 2020-08-08 | Porter | Indiana | 18127 | 1304 | 41 |
412441 | 412441 | 2020-08-08 | Posey | Indiana | 18129 | 170 | 0 |
412442 | 412442 | 2020-08-08 | Pulaski | Indiana | 18131 | 81 | 1 |
412443 | 412443 | 2020-08-08 | Putnam | Indiana | 18133 | 291 | 8 |
412444 | 412444 | 2020-08-08 | Randolph | Indiana | 18135 | 148 | 4 |
412445 | 412445 | 2020-08-08 | Ripley | Indiana | 18137 | 199 | 7 |
412446 | 412446 | 2020-08-08 | Rush | Indiana | 18139 | 112 | 4 |
412447 | 412447 | 2020-08-08 | Scott | Indiana | 18143 | 270 | 11 |
412448 | 412448 | 2020-08-08 | Shelby | Indiana | 18145 | 878 | 35 |
412449 | 412449 | 2020-08-08 | Spencer | Indiana | 18147 | 134 | 3 |
412450 | 412450 | 2020-08-08 | St. Joseph | Indiana | 18141 | 3434 | 86 |
412451 | 412451 | 2020-08-08 | Starke | Indiana | 18149 | 179 | 8 |
412452 | 412452 | 2020-08-08 | Steuben | Indiana | 18151 | 207 | 3 |
412453 | 412453 | 2020-08-08 | Sullivan | Indiana | 18153 | 117 | 1 |
412454 | 412454 | 2020-08-08 | Switzerland | Indiana | 18155 | 48 | 0 |
412455 | 412455 | 2020-08-08 | Tippecanoe | Indiana | 18157 | 1192 | 12 |
412456 | 412456 | 2020-08-08 | Tipton | Indiana | 18159 | 139 | 10 |
412457 | 412457 | 2020-08-08 | Union | Indiana | 18161 | 61 | 0 |
412458 | 412458 | 2020-08-08 | Vanderburgh | Indiana | 18163 | 1925 | 13 |
412459 | 412459 | 2020-08-08 | Vermillion | Indiana | 18165 | 50 | 0 |
412460 | 412460 | 2020-08-08 | Vigo | Indiana | 18167 | 622 | 11 |
412461 | 412461 | 2020-08-08 | Wabash | Indiana | 18169 | 169 | 3 |
412462 | 412462 | 2020-08-08 | Warren | Indiana | 18171 | 23 | 1 |
412463 | 412463 | 2020-08-08 | Warrick | Indiana | 18173 | 581 | 32 |
412464 | 412464 | 2020-08-08 | Washington | Indiana | 18175 | 139 | 1 |
412465 | 412465 | 2020-08-08 | Wayne | Indiana | 18177 | 653 | 10 |
412466 | 412466 | 2020-08-08 | Wells | Indiana | 18179 | 179 | 2 |
412467 | 412467 | 2020-08-08 | White | Indiana | 18181 | 361 | 10 |
412468 | 412468 | 2020-08-08 | Whitley | Indiana | 18183 | 151 | 6 |
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);