ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-08-26" 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 |
---|---|---|---|---|---|---|---|
470442 | 470442 | 2020-08-26 | Adams | Indiana | 18001 | 165 | 3 |
470443 | 470443 | 2020-08-26 | Allen | Indiana | 18003 | 4782 | 186 |
470444 | 470444 | 2020-08-26 | Bartholomew | Indiana | 18005 | 1040 | 56 |
470445 | 470445 | 2020-08-26 | Benton | Indiana | 18007 | 77 | 0 |
470446 | 470446 | 2020-08-26 | Blackford | Indiana | 18009 | 76 | 2 |
470447 | 470447 | 2020-08-26 | Boone | Indiana | 18011 | 817 | 49 |
470448 | 470448 | 2020-08-26 | Brown | Indiana | 18013 | 84 | 2 |
470449 | 470449 | 2020-08-26 | Carroll | Indiana | 18015 | 248 | 12 |
470450 | 470450 | 2020-08-26 | Cass | Indiana | 18017 | 1851 | 10 |
470451 | 470451 | 2020-08-26 | Clark | Indiana | 18019 | 1659 | 58 |
470452 | 470452 | 2020-08-26 | Clay | Indiana | 18021 | 209 | 5 |
470453 | 470453 | 2020-08-26 | Clinton | Indiana | 18023 | 526 | 8 |
470454 | 470454 | 2020-08-26 | Crawford | Indiana | 18025 | 57 | 1 |
470455 | 470455 | 2020-08-26 | Daviess | Indiana | 18027 | 432 | 25 |
470456 | 470456 | 2020-08-26 | DeKalb | Indiana | 18033 | 305 | 5 |
470457 | 470457 | 2020-08-26 | Dearborn | Indiana | 18029 | 566 | 30 |
470458 | 470458 | 2020-08-26 | Decatur | Indiana | 18031 | 405 | 37 |
470459 | 470459 | 2020-08-26 | Delaware | Indiana | 18035 | 935 | 55 |
470460 | 470460 | 2020-08-26 | Dubois | Indiana | 18037 | 810 | 17 |
470461 | 470461 | 2020-08-26 | Elkhart | Indiana | 18039 | 5530 | 101 |
470462 | 470462 | 2020-08-26 | Fayette | Indiana | 18041 | 386 | 8 |
470463 | 470463 | 2020-08-26 | Floyd | Indiana | 18043 | 1026 | 57 |
470464 | 470464 | 2020-08-26 | Fountain | Indiana | 18045 | 87 | 2 |
470465 | 470465 | 2020-08-26 | Franklin | Indiana | 18047 | 275 | 24 |
470466 | 470466 | 2020-08-26 | Fulton | Indiana | 18049 | 200 | 2 |
470467 | 470467 | 2020-08-26 | Gibson | Indiana | 18051 | 302 | 4 |
470468 | 470468 | 2020-08-26 | Grant | Indiana | 18053 | 909 | 33 |
470469 | 470469 | 2020-08-26 | Greene | Indiana | 18055 | 350 | 38 |
470470 | 470470 | 2020-08-26 | Hamilton | Indiana | 18057 | 3670 | 116 |
470471 | 470471 | 2020-08-26 | Hancock | Indiana | 18059 | 799 | 44 |
470472 | 470472 | 2020-08-26 | Harrison | Indiana | 18061 | 461 | 26 |
470473 | 470473 | 2020-08-26 | Hendricks | Indiana | 18063 | 2232 | 128 |
470474 | 470474 | 2020-08-26 | Henry | Indiana | 18065 | 576 | 21 |
470475 | 470475 | 2020-08-26 | Howard | Indiana | 18067 | 1043 | 64 |
470476 | 470476 | 2020-08-26 | Huntington | Indiana | 18069 | 156 | 4 |
470477 | 470477 | 2020-08-26 | Jackson | Indiana | 18071 | 679 | 8 |
470478 | 470478 | 2020-08-26 | Jasper | Indiana | 18073 | 307 | 2 |
470479 | 470479 | 2020-08-26 | Jay | Indiana | 18075 | 125 | 0 |
470480 | 470480 | 2020-08-26 | Jefferson | Indiana | 18077 | 201 | 3 |
470481 | 470481 | 2020-08-26 | Jennings | Indiana | 18079 | 264 | 14 |
470482 | 470482 | 2020-08-26 | Johnson | Indiana | 18081 | 2002 | 128 |
470483 | 470483 | 2020-08-26 | Knox | Indiana | 18083 | 304 | 3 |
470484 | 470484 | 2020-08-26 | Kosciusko | Indiana | 18085 | 1021 | 18 |
470485 | 470485 | 2020-08-26 | LaGrange | Indiana | 18087 | 587 | 11 |
470486 | 470486 | 2020-08-26 | LaPorte | Indiana | 18091 | 1131 | 31 |
470487 | 470487 | 2020-08-26 | Lake | Indiana | 18089 | 8859 | 311 |
470488 | 470488 | 2020-08-26 | Lawrence | Indiana | 18093 | 433 | 29 |
470489 | 470489 | 2020-08-26 | Madison | Indiana | 18095 | 1246 | 79 |
470490 | 470490 | 2020-08-26 | Marion | Indiana | 18097 | 17997 | 796 |
470491 | 470491 | 2020-08-26 | Marshall | Indiana | 18099 | 864 | 23 |
470492 | 470492 | 2020-08-26 | Martin | Indiana | 18101 | 84 | 0 |
470493 | 470493 | 2020-08-26 | Miami | Indiana | 18103 | 312 | 2 |
470494 | 470494 | 2020-08-26 | Monroe | Indiana | 18105 | 998 | 40 |
470495 | 470495 | 2020-08-26 | Montgomery | Indiana | 18107 | 393 | 22 |
470496 | 470496 | 2020-08-26 | Morgan | Indiana | 18109 | 569 | 38 |
470497 | 470497 | 2020-08-26 | Newton | Indiana | 18111 | 135 | 11 |
470498 | 470498 | 2020-08-26 | Noble | Indiana | 18113 | 783 | 31 |
470499 | 470499 | 2020-08-26 | Ohio | Indiana | 18115 | 71 | 7 |
470500 | 470500 | 2020-08-26 | Orange | Indiana | 18117 | 226 | 26 |
470501 | 470501 | 2020-08-26 | Owen | Indiana | 18119 | 134 | 2 |
470502 | 470502 | 2020-08-26 | Parke | Indiana | 18121 | 80 | 2 |
470503 | 470503 | 2020-08-26 | Perry | Indiana | 18123 | 207 | 14 |
470504 | 470504 | 2020-08-26 | Pike | Indiana | 18125 | 84 | 1 |
470505 | 470505 | 2020-08-26 | Porter | Indiana | 18127 | 1624 | 43 |
470506 | 470506 | 2020-08-26 | Posey | Indiana | 18129 | 206 | 0 |
470507 | 470507 | 2020-08-26 | Pulaski | Indiana | 18131 | 95 | 1 |
470508 | 470508 | 2020-08-26 | Putnam | Indiana | 18133 | 415 | 8 |
470509 | 470509 | 2020-08-26 | Randolph | Indiana | 18135 | 186 | 7 |
470510 | 470510 | 2020-08-26 | Ripley | Indiana | 18137 | 237 | 8 |
470511 | 470511 | 2020-08-26 | Rush | Indiana | 18139 | 169 | 4 |
470512 | 470512 | 2020-08-26 | Scott | Indiana | 18143 | 311 | 12 |
470513 | 470513 | 2020-08-26 | Shelby | Indiana | 18145 | 1045 | 36 |
470514 | 470514 | 2020-08-26 | Spencer | Indiana | 18147 | 153 | 3 |
470515 | 470515 | 2020-08-26 | St. Joseph | Indiana | 18141 | 4840 | 95 |
470516 | 470516 | 2020-08-26 | Starke | Indiana | 18149 | 195 | 8 |
470517 | 470517 | 2020-08-26 | Steuben | Indiana | 18151 | 252 | 3 |
470518 | 470518 | 2020-08-26 | Sullivan | Indiana | 18153 | 275 | 7 |
470519 | 470519 | 2020-08-26 | Switzerland | Indiana | 18155 | 65 | 0 |
470520 | 470520 | 2020-08-26 | Tippecanoe | Indiana | 18157 | 1503 | 14 |
470521 | 470521 | 2020-08-26 | Tipton | Indiana | 18159 | 176 | 21 |
470522 | 470522 | 2020-08-26 | Union | Indiana | 18161 | 81 | 0 |
470523 | 470523 | 2020-08-26 | Vanderburgh | Indiana | 18163 | 2420 | 18 |
470524 | 470524 | 2020-08-26 | Vermillion | Indiana | 18165 | 83 | 0 |
470525 | 470525 | 2020-08-26 | Vigo | Indiana | 18167 | 1104 | 16 |
470526 | 470526 | 2020-08-26 | Wabash | Indiana | 18169 | 203 | 5 |
470527 | 470527 | 2020-08-26 | Warren | Indiana | 18171 | 37 | 1 |
470528 | 470528 | 2020-08-26 | Warrick | Indiana | 18173 | 723 | 33 |
470529 | 470529 | 2020-08-26 | Washington | Indiana | 18175 | 199 | 1 |
470530 | 470530 | 2020-08-26 | Wayne | Indiana | 18177 | 832 | 10 |
470531 | 470531 | 2020-08-26 | Wells | Indiana | 18179 | 218 | 2 |
470532 | 470532 | 2020-08-26 | White | Indiana | 18181 | 419 | 12 |
470533 | 470533 | 2020-08-26 | Whitley | Indiana | 18183 | 195 | 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);