ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-09-13" 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 |
---|---|---|---|---|---|---|---|
528652 | 528652 | 2020-09-13 | Adams | Indiana | 18001 | 221 | 4 |
528653 | 528653 | 2020-09-13 | Allen | Indiana | 18003 | 5655 | 203 |
528654 | 528654 | 2020-09-13 | Bartholomew | Indiana | 18005 | 1136 | 60 |
528655 | 528655 | 2020-09-13 | Benton | Indiana | 18007 | 87 | 0 |
528656 | 528656 | 2020-09-13 | Blackford | Indiana | 18009 | 105 | 2 |
528657 | 528657 | 2020-09-13 | Boone | Indiana | 18011 | 947 | 49 |
528658 | 528658 | 2020-09-13 | Brown | Indiana | 18013 | 91 | 3 |
528659 | 528659 | 2020-09-13 | Carroll | Indiana | 18015 | 265 | 13 |
528660 | 528660 | 2020-09-13 | Cass | Indiana | 18017 | 1914 | 10 |
528661 | 528661 | 2020-09-13 | Clark | Indiana | 18019 | 1993 | 60 |
528662 | 528662 | 2020-09-13 | Clay | Indiana | 18021 | 272 | 5 |
528663 | 528663 | 2020-09-13 | Clinton | Indiana | 18023 | 588 | 15 |
528664 | 528664 | 2020-09-13 | Crawford | Indiana | 18025 | 95 | 1 |
528665 | 528665 | 2020-09-13 | Daviess | Indiana | 18027 | 588 | 28 |
528666 | 528666 | 2020-09-13 | DeKalb | Indiana | 18033 | 406 | 10 |
528667 | 528667 | 2020-09-13 | Dearborn | Indiana | 18029 | 609 | 30 |
528668 | 528668 | 2020-09-13 | Decatur | Indiana | 18031 | 468 | 41 |
528669 | 528669 | 2020-09-13 | Delaware | Indiana | 18035 | 1722 | 60 |
528670 | 528670 | 2020-09-13 | Dubois | Indiana | 18037 | 907 | 18 |
528671 | 528671 | 2020-09-13 | Elkhart | Indiana | 18039 | 6136 | 108 |
528672 | 528672 | 2020-09-13 | Fayette | Indiana | 18041 | 503 | 13 |
528673 | 528673 | 2020-09-13 | Floyd | Indiana | 18043 | 1226 | 63 |
528674 | 528674 | 2020-09-13 | Fountain | Indiana | 18045 | 110 | 2 |
528675 | 528675 | 2020-09-13 | Franklin | Indiana | 18047 | 297 | 26 |
528676 | 528676 | 2020-09-13 | Fulton | Indiana | 18049 | 225 | 2 |
528677 | 528677 | 2020-09-13 | Gibson | Indiana | 18051 | 386 | 4 |
528678 | 528678 | 2020-09-13 | Grant | Indiana | 18053 | 1160 | 35 |
528679 | 528679 | 2020-09-13 | Greene | Indiana | 18055 | 398 | 38 |
528680 | 528680 | 2020-09-13 | Hamilton | Indiana | 18057 | 4546 | 117 |
528681 | 528681 | 2020-09-13 | Hancock | Indiana | 18059 | 895 | 45 |
528682 | 528682 | 2020-09-13 | Harrison | Indiana | 18061 | 532 | 26 |
528683 | 528683 | 2020-09-13 | Hendricks | Indiana | 18063 | 2579 | 137 |
528684 | 528684 | 2020-09-13 | Henry | Indiana | 18065 | 715 | 24 |
528685 | 528685 | 2020-09-13 | Howard | Indiana | 18067 | 1227 | 65 |
528686 | 528686 | 2020-09-13 | Huntington | Indiana | 18069 | 201 | 3 |
528687 | 528687 | 2020-09-13 | Jackson | Indiana | 18071 | 725 | 10 |
528688 | 528688 | 2020-09-13 | Jasper | Indiana | 18073 | 371 | 2 |
528689 | 528689 | 2020-09-13 | Jay | Indiana | 18075 | 159 | 0 |
528690 | 528690 | 2020-09-13 | Jefferson | Indiana | 18077 | 231 | 3 |
528691 | 528691 | 2020-09-13 | Jennings | Indiana | 18079 | 306 | 14 |
528692 | 528692 | 2020-09-13 | Johnson | Indiana | 18081 | 2229 | 131 |
528693 | 528693 | 2020-09-13 | Knox | Indiana | 18083 | 435 | 8 |
528694 | 528694 | 2020-09-13 | Kosciusko | Indiana | 18085 | 1162 | 19 |
528695 | 528695 | 2020-09-13 | LaGrange | Indiana | 18087 | 628 | 11 |
528696 | 528696 | 2020-09-13 | LaPorte | Indiana | 18091 | 1319 | 37 |
528697 | 528697 | 2020-09-13 | Lake | Indiana | 18089 | 9913 | 326 |
528698 | 528698 | 2020-09-13 | Lawrence | Indiana | 18093 | 494 | 29 |
528699 | 528699 | 2020-09-13 | Madison | Indiana | 18095 | 1503 | 85 |
528700 | 528700 | 2020-09-13 | Marion | Indiana | 18097 | 20233 | 805 |
528701 | 528701 | 2020-09-13 | Marshall | Indiana | 18099 | 958 | 23 |
528702 | 528702 | 2020-09-13 | Martin | Indiana | 18101 | 142 | 0 |
528703 | 528703 | 2020-09-13 | Miami | Indiana | 18103 | 420 | 2 |
528704 | 528704 | 2020-09-13 | Monroe | Indiana | 18105 | 1991 | 40 |
528705 | 528705 | 2020-09-13 | Montgomery | Indiana | 18107 | 494 | 22 |
528706 | 528706 | 2020-09-13 | Morgan | Indiana | 18109 | 673 | 39 |
528707 | 528707 | 2020-09-13 | Newton | Indiana | 18111 | 156 | 11 |
528708 | 528708 | 2020-09-13 | Noble | Indiana | 18113 | 854 | 33 |
528709 | 528709 | 2020-09-13 | Ohio | Indiana | 18115 | 75 | 7 |
528710 | 528710 | 2020-09-13 | Orange | Indiana | 18117 | 277 | 26 |
528711 | 528711 | 2020-09-13 | Owen | Indiana | 18119 | 162 | 2 |
528712 | 528712 | 2020-09-13 | Parke | Indiana | 18121 | 94 | 2 |
528713 | 528713 | 2020-09-13 | Perry | Indiana | 18123 | 210 | 15 |
528714 | 528714 | 2020-09-13 | Pike | Indiana | 18125 | 126 | 1 |
528715 | 528715 | 2020-09-13 | Porter | Indiana | 18127 | 1937 | 45 |
528716 | 528716 | 2020-09-13 | Posey | Indiana | 18129 | 279 | 0 |
528717 | 528717 | 2020-09-13 | Pulaski | Indiana | 18131 | 113 | 1 |
528718 | 528718 | 2020-09-13 | Putnam | Indiana | 18133 | 507 | 8 |
528719 | 528719 | 2020-09-13 | Randolph | Indiana | 18135 | 231 | 7 |
528720 | 528720 | 2020-09-13 | Ripley | Indiana | 18137 | 265 | 8 |
528721 | 528721 | 2020-09-13 | Rush | Indiana | 18139 | 189 | 4 |
528722 | 528722 | 2020-09-13 | Scott | Indiana | 18143 | 344 | 12 |
528723 | 528723 | 2020-09-13 | Shelby | Indiana | 18145 | 1118 | 37 |
528724 | 528724 | 2020-09-13 | Spencer | Indiana | 18147 | 185 | 3 |
528725 | 528725 | 2020-09-13 | St. Joseph | Indiana | 18141 | 5741 | 102 |
528726 | 528726 | 2020-09-13 | Starke | Indiana | 18149 | 229 | 8 |
528727 | 528727 | 2020-09-13 | Steuben | Indiana | 18151 | 338 | 7 |
528728 | 528728 | 2020-09-13 | Sullivan | Indiana | 18153 | 323 | 12 |
528729 | 528729 | 2020-09-13 | Switzerland | Indiana | 18155 | 67 | 0 |
528730 | 528730 | 2020-09-13 | Tippecanoe | Indiana | 18157 | 1994 | 14 |
528731 | 528731 | 2020-09-13 | Tipton | Indiana | 18159 | 217 | 25 |
528732 | 528732 | 2020-09-13 | Union | Indiana | 18161 | 97 | 0 |
528733 | 528733 | 2020-09-13 | Vanderburgh | Indiana | 18163 | 3030 | 24 |
528734 | 528734 | 2020-09-13 | Vermillion | Indiana | 18165 | 118 | 0 |
528735 | 528735 | 2020-09-13 | Vigo | Indiana | 18167 | 1653 | 21 |
528736 | 528736 | 2020-09-13 | Wabash | Indiana | 18169 | 253 | 7 |
528737 | 528737 | 2020-09-13 | Warren | Indiana | 18171 | 39 | 1 |
528738 | 528738 | 2020-09-13 | Warrick | Indiana | 18173 | 959 | 33 |
528739 | 528739 | 2020-09-13 | Washington | Indiana | 18175 | 243 | 1 |
528740 | 528740 | 2020-09-13 | Wayne | Indiana | 18177 | 1055 | 13 |
528741 | 528741 | 2020-09-13 | Wells | Indiana | 18179 | 248 | 2 |
528742 | 528742 | 2020-09-13 | White | Indiana | 18181 | 466 | 14 |
528743 | 528743 | 2020-09-13 | Whitley | Indiana | 18183 | 237 | 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);