ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2020-07-21 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
354528 | 354528 | 2020-07-21 | Adams | Indiana | 18001 | 59 | 2 |
354529 | 354529 | 2020-07-21 | Allen | Indiana | 18003 | 3224 | 154 |
354530 | 354530 | 2020-07-21 | Bartholomew | Indiana | 18005 | 647 | 48 |
354531 | 354531 | 2020-07-21 | Benton | Indiana | 18007 | 54 | 0 |
354532 | 354532 | 2020-07-21 | Blackford | Indiana | 18009 | 50 | 2 |
354533 | 354533 | 2020-07-21 | Boone | Indiana | 18011 | 565 | 48 |
354534 | 354534 | 2020-07-21 | Brown | Indiana | 18013 | 55 | 1 |
354535 | 354535 | 2020-07-21 | Carroll | Indiana | 18015 | 120 | 2 |
354536 | 354536 | 2020-07-21 | Cass | Indiana | 18017 | 1677 | 10 |
354537 | 354537 | 2020-07-21 | Clark | Indiana | 18019 | 821 | 52 |
354538 | 354538 | 2020-07-21 | Clay | Indiana | 18021 | 73 | 5 |
354539 | 354539 | 2020-07-21 | Clinton | Indiana | 18023 | 312 | 4 |
354540 | 354540 | 2020-07-21 | Crawford | Indiana | 18025 | 38 | 1 |
354541 | 354541 | 2020-07-21 | Daviess | Indiana | 18027 | 176 | 19 |
354542 | 354542 | 2020-07-21 | DeKalb | Indiana | 18033 | 180 | 5 |
354543 | 354543 | 2020-07-21 | Dearborn | Indiana | 18029 | 348 | 26 |
354544 | 354544 | 2020-07-21 | Decatur | Indiana | 18031 | 286 | 35 |
354545 | 354545 | 2020-07-21 | Delaware | Indiana | 18035 | 518 | 53 |
354546 | 354546 | 2020-07-21 | Dubois | Indiana | 18037 | 446 | 7 |
354547 | 354547 | 2020-07-21 | Elkhart | Indiana | 18039 | 4167 | 72 |
354548 | 354548 | 2020-07-21 | Fayette | Indiana | 18041 | 175 | 7 |
354549 | 354549 | 2020-07-21 | Floyd | Indiana | 18043 | 503 | 46 |
354550 | 354550 | 2020-07-21 | Fountain | Indiana | 18045 | 43 | 2 |
354551 | 354551 | 2020-07-21 | Franklin | Indiana | 18047 | 159 | 9 |
354552 | 354552 | 2020-07-21 | Fulton | Indiana | 18049 | 99 | 2 |
354553 | 354553 | 2020-07-21 | Gibson | Indiana | 18051 | 163 | 2 |
354554 | 354554 | 2020-07-21 | Grant | Indiana | 18053 | 582 | 31 |
354555 | 354555 | 2020-07-21 | Greene | Indiana | 18055 | 213 | 36 |
354556 | 354556 | 2020-07-21 | Hamilton | Indiana | 18057 | 2017 | 108 |
354557 | 354557 | 2020-07-21 | Hancock | Indiana | 18059 | 524 | 37 |
354558 | 354558 | 2020-07-21 | Harrison | Indiana | 18061 | 238 | 24 |
354559 | 354559 | 2020-07-21 | Hendricks | Indiana | 18063 | 1597 | 122 |
354560 | 354560 | 2020-07-21 | Henry | Indiana | 18065 | 330 | 18 |
354561 | 354561 | 2020-07-21 | Howard | Indiana | 18067 | 689 | 63 |
354562 | 354562 | 2020-07-21 | Huntington | Indiana | 18069 | 112 | 2 |
354563 | 354563 | 2020-07-21 | Jackson | Indiana | 18071 | 512 | 4 |
354564 | 354564 | 2020-07-21 | Jasper | Indiana | 18073 | 163 | 2 |
354565 | 354565 | 2020-07-21 | Jay | Indiana | 18075 | 78 | 0 |
354566 | 354566 | 2020-07-21 | Jefferson | Indiana | 18077 | 134 | 2 |
354567 | 354567 | 2020-07-21 | Jennings | Indiana | 18079 | 190 | 14 |
354568 | 354568 | 2020-07-21 | Johnson | Indiana | 18081 | 1496 | 126 |
354569 | 354569 | 2020-07-21 | Knox | Indiana | 18083 | 91 | 0 |
354570 | 354570 | 2020-07-21 | Kosciusko | Indiana | 18085 | 708 | 9 |
354571 | 354571 | 2020-07-21 | LaGrange | Indiana | 18087 | 502 | 10 |
354572 | 354572 | 2020-07-21 | LaPorte | Indiana | 18091 | 701 | 28 |
354573 | 354573 | 2020-07-21 | Lake | Indiana | 18089 | 6316 | 272 |
354574 | 354574 | 2020-07-21 | Lawrence | Indiana | 18093 | 282 | 27 |
354575 | 354575 | 2020-07-21 | Madison | Indiana | 18095 | 729 | 75 |
354576 | 354576 | 2020-07-21 | Marion | Indiana | 18097 | 13124 | 755 |
354577 | 354577 | 2020-07-21 | Marshall | Indiana | 18099 | 671 | 14 |
354578 | 354578 | 2020-07-21 | Martin | Indiana | 18101 | 35 | 0 |
354579 | 354579 | 2020-07-21 | Miami | Indiana | 18103 | 217 | 2 |
354580 | 354580 | 2020-07-21 | Monroe | Indiana | 18105 | 492 | 30 |
354581 | 354581 | 2020-07-21 | Montgomery | Indiana | 18107 | 308 | 21 |
354582 | 354582 | 2020-07-21 | Morgan | Indiana | 18109 | 379 | 34 |
354583 | 354583 | 2020-07-21 | Newton | Indiana | 18111 | 102 | 11 |
354584 | 354584 | 2020-07-21 | Noble | Indiana | 18113 | 578 | 29 |
354585 | 354585 | 2020-07-21 | Ohio | Indiana | 18115 | 33 | 2 |
354586 | 354586 | 2020-07-21 | Orange | Indiana | 18117 | 156 | 26 |
354587 | 354587 | 2020-07-21 | Owen | Indiana | 18119 | 58 | 1 |
354588 | 354588 | 2020-07-21 | Parke | Indiana | 18121 | 38 | 0 |
354589 | 354589 | 2020-07-21 | Perry | Indiana | 18123 | 172 | 13 |
354590 | 354590 | 2020-07-21 | Pike | Indiana | 18125 | 21 | 0 |
354591 | 354591 | 2020-07-21 | Porter | Indiana | 18127 | 950 | 40 |
354592 | 354592 | 2020-07-21 | Posey | Indiana | 18129 | 115 | 0 |
354593 | 354593 | 2020-07-21 | Pulaski | Indiana | 18131 | 69 | 1 |
354594 | 354594 | 2020-07-21 | Putnam | Indiana | 18133 | 201 | 8 |
354595 | 354595 | 2020-07-21 | Randolph | Indiana | 18135 | 111 | 4 |
354596 | 354596 | 2020-07-21 | Ripley | Indiana | 18137 | 163 | 7 |
354597 | 354597 | 2020-07-21 | Rush | Indiana | 18139 | 99 | 3 |
354598 | 354598 | 2020-07-21 | Scott | Indiana | 18143 | 204 | 10 |
354599 | 354599 | 2020-07-21 | Shelby | Indiana | 18145 | 745 | 32 |
354600 | 354600 | 2020-07-21 | Spencer | Indiana | 18147 | 96 | 1 |
354601 | 354601 | 2020-07-21 | St. Joseph | Indiana | 18141 | 2564 | 79 |
354602 | 354602 | 2020-07-21 | Starke | Indiana | 18149 | 143 | 5 |
354603 | 354603 | 2020-07-21 | Steuben | Indiana | 18151 | 162 | 3 |
354604 | 354604 | 2020-07-21 | Sullivan | Indiana | 18153 | 67 | 1 |
354605 | 354605 | 2020-07-21 | Switzerland | Indiana | 18155 | 38 | 0 |
354606 | 354606 | 2020-07-21 | Tippecanoe | Indiana | 18157 | 892 | 11 |
354607 | 354607 | 2020-07-21 | Tipton | Indiana | 18159 | 49 | 3 |
354608 | 354608 | 2020-07-21 | Union | Indiana | 18161 | 39 | 0 |
354609 | 354609 | 2020-07-21 | Vanderburgh | Indiana | 18163 | 1194 | 6 |
354610 | 354610 | 2020-07-21 | Vermillion | Indiana | 18165 | 21 | 0 |
354611 | 354611 | 2020-07-21 | Vigo | Indiana | 18167 | 311 | 10 |
354612 | 354612 | 2020-07-21 | Wabash | Indiana | 18169 | 134 | 3 |
354613 | 354613 | 2020-07-21 | Warren | Indiana | 18171 | 18 | 1 |
354614 | 354614 | 2020-07-21 | Warrick | Indiana | 18173 | 360 | 31 |
354615 | 354615 | 2020-07-21 | Washington | Indiana | 18175 | 77 | 1 |
354616 | 354616 | 2020-07-21 | Wayne | Indiana | 18177 | 432 | 7 |
354617 | 354617 | 2020-07-21 | Wells | Indiana | 18179 | 118 | 1 |
354618 | 354618 | 2020-07-21 | White | Indiana | 18181 | 306 | 10 |
354619 | 354619 | 2020-07-21 | Whitley | Indiana | 18183 | 120 | 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);