ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-11-24" 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 |
---|---|---|---|---|---|---|---|
762119 | 762119 | 2020-11-24 | Adams | Indiana | 18001 | 1665 | 23 |
762120 | 762120 | 2020-11-24 | Allen | Indiana | 18003 | 17656 | 307 |
762121 | 762121 | 2020-11-24 | Bartholomew | Indiana | 18005 | 3101 | 67 |
762122 | 762122 | 2020-11-24 | Benton | Indiana | 18007 | 336 | 2 |
762123 | 762123 | 2020-11-24 | Blackford | Indiana | 18009 | 530 | 12 |
762124 | 762124 | 2020-11-24 | Boone | Indiana | 18011 | 2420 | 57 |
762125 | 762125 | 2020-11-24 | Brown | Indiana | 18013 | 335 | 3 |
762126 | 762126 | 2020-11-24 | Carroll | Indiana | 18015 | 679 | 13 |
762127 | 762127 | 2020-11-24 | Cass | Indiana | 18017 | 2961 | 32 |
762128 | 762128 | 2020-11-24 | Clark | Indiana | 18019 | 5060 | 84 |
762129 | 762129 | 2020-11-24 | Clay | Indiana | 18021 | 1198 | 22 |
762130 | 762130 | 2020-11-24 | Clinton | Indiana | 18023 | 1782 | 25 |
762131 | 762131 | 2020-11-24 | Crawford | Indiana | 18025 | 289 | 2 |
762132 | 762132 | 2020-11-24 | Daviess | Indiana | 18027 | 1548 | 45 |
762133 | 762133 | 2020-11-24 | DeKalb | Indiana | 18033 | 1730 | 30 |
762134 | 762134 | 2020-11-24 | Dearborn | Indiana | 18029 | 2165 | 32 |
762135 | 762135 | 2020-11-24 | Decatur | Indiana | 18031 | 1286 | 46 |
762136 | 762136 | 2020-11-24 | Delaware | Indiana | 18035 | 4832 | 107 |
762137 | 762137 | 2020-11-24 | Dubois | Indiana | 18037 | 2347 | 32 |
762138 | 762138 | 2020-11-24 | Elkhart | Indiana | 18039 | 17000 | 227 |
762139 | 762139 | 2020-11-24 | Fayette | Indiana | 18041 | 1606 | 34 |
762140 | 762140 | 2020-11-24 | Floyd | Indiana | 18043 | 3122 | 80 |
762141 | 762141 | 2020-11-24 | Fountain | Indiana | 18045 | 774 | 8 |
762142 | 762142 | 2020-11-24 | Franklin | Indiana | 18047 | 698 | 27 |
762143 | 762143 | 2020-11-24 | Fulton | Indiana | 18049 | 837 | 18 |
762144 | 762144 | 2020-11-24 | Gibson | Indiana | 18051 | 1819 | 25 |
762145 | 762145 | 2020-11-24 | Grant | Indiana | 18053 | 3058 | 52 |
762146 | 762146 | 2020-11-24 | Greene | Indiana | 18055 | 1021 | 56 |
762147 | 762147 | 2020-11-24 | Hamilton | Indiana | 18057 | 12732 | 177 |
762148 | 762148 | 2020-11-24 | Hancock | Indiana | 18059 | 2482 | 54 |
762149 | 762149 | 2020-11-24 | Harrison | Indiana | 18061 | 1421 | 26 |
762150 | 762150 | 2020-11-24 | Hendricks | Indiana | 18063 | 5979 | 173 |
762151 | 762151 | 2020-11-24 | Henry | Indiana | 18065 | 2416 | 38 |
762152 | 762152 | 2020-11-24 | Howard | Indiana | 18067 | 3358 | 78 |
762153 | 762153 | 2020-11-24 | Huntington | Indiana | 18069 | 1238 | 10 |
762154 | 762154 | 2020-11-24 | Jackson | Indiana | 18071 | 2130 | 34 |
762155 | 762155 | 2020-11-24 | Jasper | Indiana | 18073 | 1423 | 12 |
762156 | 762156 | 2020-11-24 | Jay | Indiana | 18075 | 974 | 15 |
762157 | 762157 | 2020-11-24 | Jefferson | Indiana | 18077 | 1163 | 16 |
762158 | 762158 | 2020-11-24 | Jennings | Indiana | 18079 | 836 | 16 |
762159 | 762159 | 2020-11-24 | Johnson | Indiana | 18081 | 6275 | 174 |
762160 | 762160 | 2020-11-24 | Knox | Indiana | 18083 | 1816 | 19 |
762161 | 762161 | 2020-11-24 | Kosciusko | Indiana | 18085 | 4577 | 41 |
762162 | 762162 | 2020-11-24 | LaGrange | Indiana | 18087 | 1405 | 30 |
762163 | 762163 | 2020-11-24 | LaPorte | Indiana | 18091 | 4578 | 95 |
762164 | 762164 | 2020-11-24 | Lake | Indiana | 18089 | 26933 | 472 |
762165 | 762165 | 2020-11-24 | Lawrence | Indiana | 18093 | 1742 | 49 |
762166 | 762166 | 2020-11-24 | Madison | Indiana | 18095 | 4882 | 134 |
762167 | 762167 | 2020-11-24 | Marion | Indiana | 18097 | 42131 | 904 |
762168 | 762168 | 2020-11-24 | Marshall | Indiana | 18099 | 2937 | 44 |
762169 | 762169 | 2020-11-24 | Martin | Indiana | 18101 | 352 | 5 |
762170 | 762170 | 2020-11-24 | Miami | Indiana | 18103 | 1583 | 14 |
762171 | 762171 | 2020-11-24 | Monroe | Indiana | 18105 | 5308 | 53 |
762172 | 762172 | 2020-11-24 | Montgomery | Indiana | 18107 | 1392 | 28 |
762173 | 762173 | 2020-11-24 | Morgan | Indiana | 18109 | 2058 | 47 |
762174 | 762174 | 2020-11-24 | Newton | Indiana | 18111 | 554 | 13 |
762175 | 762175 | 2020-11-24 | Noble | Indiana | 18113 | 2502 | 48 |
762176 | 762176 | 2020-11-24 | Ohio | Indiana | 18115 | 230 | 7 |
762177 | 762177 | 2020-11-24 | Orange | Indiana | 18117 | 668 | 30 |
762178 | 762178 | 2020-11-24 | Owen | Indiana | 18119 | 599 | 8 |
762179 | 762179 | 2020-11-24 | Parke | Indiana | 18121 | 574 | 6 |
762180 | 762180 | 2020-11-24 | Perry | Indiana | 18123 | 825 | 22 |
762181 | 762181 | 2020-11-24 | Pike | Indiana | 18125 | 503 | 18 |
762182 | 762182 | 2020-11-24 | Porter | Indiana | 18127 | 8150 | 88 |
762183 | 762183 | 2020-11-24 | Posey | Indiana | 18129 | 1196 | 16 |
762184 | 762184 | 2020-11-24 | Pulaski | Indiana | 18131 | 379 | 10 |
762185 | 762185 | 2020-11-24 | Putnam | Indiana | 18133 | 1237 | 27 |
762186 | 762186 | 2020-11-24 | Randolph | Indiana | 18135 | 1247 | 19 |
762187 | 762187 | 2020-11-24 | Ripley | Indiana | 18137 | 1282 | 14 |
762188 | 762188 | 2020-11-24 | Rush | Indiana | 18139 | 582 | 7 |
762189 | 762189 | 2020-11-24 | Scott | Indiana | 18143 | 1039 | 21 |
762190 | 762190 | 2020-11-24 | Shelby | Indiana | 18145 | 2416 | 63 |
762191 | 762191 | 2020-11-24 | Spencer | Indiana | 18147 | 822 | 8 |
762192 | 762192 | 2020-11-24 | St. Joseph | Indiana | 18141 | 16551 | 234 |
762193 | 762193 | 2020-11-24 | Starke | Indiana | 18149 | 908 | 22 |
762194 | 762194 | 2020-11-24 | Steuben | Indiana | 18151 | 1439 | 13 |
762195 | 762195 | 2020-11-24 | Sullivan | Indiana | 18153 | 894 | 16 |
762196 | 762196 | 2020-11-24 | Switzerland | Indiana | 18155 | 257 | 5 |
762197 | 762197 | 2020-11-24 | Tippecanoe | Indiana | 18157 | 8452 | 28 |
762198 | 762198 | 2020-11-24 | Tipton | Indiana | 18159 | 557 | 29 |
762199 | 762199 | 2020-11-24 | Union | Indiana | 18161 | 296 | 1 |
762200 | 762200 | 2020-11-24 | Vanderburgh | Indiana | 18163 | 9557 | 116 |
762201 | 762201 | 2020-11-24 | Vermillion | Indiana | 18165 | 600 | 3 |
762202 | 762202 | 2020-11-24 | Vigo | Indiana | 18167 | 5987 | 81 |
762203 | 762203 | 2020-11-24 | Wabash | Indiana | 18169 | 1586 | 20 |
762204 | 762204 | 2020-11-24 | Warren | Indiana | 18171 | 240 | 3 |
762205 | 762205 | 2020-11-24 | Warrick | Indiana | 18173 | 3197 | 74 |
762206 | 762206 | 2020-11-24 | Washington | Indiana | 18175 | 741 | 7 |
762207 | 762207 | 2020-11-24 | Wayne | Indiana | 18177 | 3410 | 69 |
762208 | 762208 | 2020-11-24 | Wells | Indiana | 18179 | 1228 | 30 |
762209 | 762209 | 2020-11-24 | White | Indiana | 18181 | 1203 | 21 |
762210 | 762210 | 2020-11-24 | Whitley | Indiana | 18183 | 1334 | 12 |
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);