ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where date = "2022-04-27" 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 |
---|---|---|---|---|---|---|---|
2448169 | 2448169 | 2022-04-27 | Adams | Indiana | 18001 | 7273 | 112 |
2448170 | 2448170 | 2022-04-27 | Allen | Indiana | 18003 | 104131 | 1186 |
2448171 | 2448171 | 2022-04-27 | Bartholomew | Indiana | 18005 | 21392 | 249 |
2448172 | 2448172 | 2022-04-27 | Benton | Indiana | 18007 | 2485 | 21 |
2448173 | 2448173 | 2022-04-27 | Blackford | Indiana | 18009 | 3113 | 69 |
2448174 | 2448174 | 2022-04-27 | Boone | Indiana | 18011 | 15319 | 184 |
2448175 | 2448175 | 2022-04-27 | Brown | Indiana | 18013 | 2591 | 62 |
2448176 | 2448176 | 2022-04-27 | Carroll | Indiana | 18015 | 4241 | 68 |
2448177 | 2448177 | 2022-04-27 | Cass | Indiana | 18017 | 11685 | 163 |
2448178 | 2448178 | 2022-04-27 | Clark | Indiana | 18019 | 31236 | 396 |
2448179 | 2448179 | 2022-04-27 | Clay | Indiana | 18021 | 6835 | 88 |
2448180 | 2448180 | 2022-04-27 | Clinton | Indiana | 18023 | 9212 | 126 |
2448181 | 2448181 | 2022-04-27 | Crawford | Indiana | 18025 | 2552 | 40 |
2448182 | 2448182 | 2022-04-27 | Daviess | Indiana | 18027 | 7480 | 154 |
2448183 | 2448183 | 2022-04-27 | DeKalb | Indiana | 18033 | 11371 | 151 |
2448184 | 2448184 | 2022-04-27 | Dearborn | Indiana | 18029 | 13484 | 140 |
2448185 | 2448185 | 2022-04-27 | Decatur | Indiana | 18031 | 7010 | 145 |
2448186 | 2448186 | 2022-04-27 | Delaware | Indiana | 18035 | 24893 | 443 |
2448187 | 2448187 | 2022-04-27 | Dubois | Indiana | 18037 | 12872 | 165 |
2448188 | 2448188 | 2022-04-27 | Elkhart | Indiana | 18039 | 54178 | 732 |
2448189 | 2448189 | 2022-04-27 | Fayette | Indiana | 18041 | 6745 | 146 |
2448190 | 2448190 | 2022-04-27 | Floyd | Indiana | 18043 | 19027 | 301 |
2448191 | 2448191 | 2022-04-27 | Fountain | Indiana | 18045 | 5448 | 102 |
2448192 | 2448192 | 2022-04-27 | Franklin | Indiana | 18047 | 4375 | 65 |
2448193 | 2448193 | 2022-04-27 | Fulton | Indiana | 18049 | 4927 | 103 |
2448194 | 2448194 | 2022-04-27 | Gibson | Indiana | 18051 | 11667 | 146 |
2448195 | 2448195 | 2022-04-27 | Grant | Indiana | 18053 | 17341 | 351 |
2448196 | 2448196 | 2022-04-27 | Greene | Indiana | 18055 | 7225 | 139 |
2448197 | 2448197 | 2022-04-27 | Hamilton | Indiana | 18057 | 82373 | 661 |
2448198 | 2448198 | 2022-04-27 | Hancock | Indiana | 18059 | 20717 | 258 |
2448199 | 2448199 | 2022-04-27 | Harrison | Indiana | 18061 | 10835 | 138 |
2448200 | 2448200 | 2022-04-27 | Hendricks | Indiana | 18063 | 40834 | 554 |
2448201 | 2448201 | 2022-04-27 | Henry | Indiana | 18065 | 13003 | 231 |
2448202 | 2448202 | 2022-04-27 | Howard | Indiana | 18067 | 25449 | 448 |
2448203 | 2448203 | 2022-04-27 | Huntington | Indiana | 18069 | 11516 | 157 |
2448204 | 2448204 | 2022-04-27 | Jackson | Indiana | 18071 | 12540 | 130 |
2448205 | 2448205 | 2022-04-27 | Jasper | Indiana | 18073 | 9068 | 149 |
2448206 | 2448206 | 2022-04-27 | Jay | Indiana | 18075 | 4853 | 78 |
2448207 | 2448207 | 2022-04-27 | Jefferson | Indiana | 18077 | 9347 | 157 |
2448208 | 2448208 | 2022-04-27 | Jennings | Indiana | 18079 | 6944 | 108 |
2448209 | 2448209 | 2022-04-27 | Johnson | Indiana | 18081 | 42505 | 613 |
2448210 | 2448210 | 2022-04-27 | Knox | Indiana | 18083 | 10756 | 153 |
2448211 | 2448211 | 2022-04-27 | Kosciusko | Indiana | 18085 | 19774 | 237 |
2448212 | 2448212 | 2022-04-27 | LaGrange | Indiana | 18087 | 5848 | 102 |
2448213 | 2448213 | 2022-04-27 | LaPorte | Indiana | 18091 | 25612 | 368 |
2448214 | 2448214 | 2022-04-27 | Lake | Indiana | 18089 | 107101 | 1824 |
2448215 | 2448215 | 2022-04-27 | Lawrence | Indiana | 18093 | 11922 | 259 |
2448216 | 2448216 | 2022-04-27 | Madison | Indiana | 18095 | 32749 | 652 |
2448217 | 2448217 | 2022-04-27 | Marion | Indiana | 18097 | 225983 | 2991 |
2448218 | 2448218 | 2022-04-27 | Marshall | Indiana | 18099 | 12386 | 197 |
2448219 | 2448219 | 2022-04-27 | Martin | Indiana | 18101 | 2165 | 25 |
2448220 | 2448220 | 2022-04-27 | Miami | Indiana | 18103 | 9268 | 159 |
2448221 | 2448221 | 2022-04-27 | Monroe | Indiana | 18105 | 28217 | 280 |
2448222 | 2448222 | 2022-04-27 | Montgomery | Indiana | 18107 | 10686 | 164 |
2448223 | 2448223 | 2022-04-27 | Morgan | Indiana | 18109 | 16501 | 286 |
2448224 | 2448224 | 2022-04-27 | Newton | Indiana | 18111 | 2577 | 68 |
2448225 | 2448225 | 2022-04-27 | Noble | Indiana | 18113 | 13084 | 157 |
2448226 | 2448226 | 2022-04-27 | Ohio | Indiana | 18115 | 1448 | 19 |
2448227 | 2448227 | 2022-04-27 | Orange | Indiana | 18117 | 5042 | 96 |
2448228 | 2448228 | 2022-04-27 | Owen | Indiana | 18119 | 5863 | 121 |
2448229 | 2448229 | 2022-04-27 | Parke | Indiana | 18121 | 3597 | 46 |
2448230 | 2448230 | 2022-04-27 | Perry | Indiana | 18123 | 4656 | 69 |
2448231 | 2448231 | 2022-04-27 | Pike | Indiana | 18125 | 3733 | 49 |
2448232 | 2448232 | 2022-04-27 | Porter | Indiana | 18127 | 38006 | 562 |
2448233 | 2448233 | 2022-04-27 | Posey | Indiana | 18129 | 6549 | 58 |
2448234 | 2448234 | 2022-04-27 | Pulaski | Indiana | 18131 | 3079 | 86 |
2448235 | 2448235 | 2022-04-27 | Putnam | Indiana | 18133 | 9359 | 129 |
2448236 | 2448236 | 2022-04-27 | Randolph | Indiana | 18135 | 5910 | 148 |
2448237 | 2448237 | 2022-04-27 | Ripley | Indiana | 18137 | 8309 | 138 |
2448238 | 2448238 | 2022-04-27 | Rush | Indiana | 18139 | 4845 | 58 |
2448239 | 2448239 | 2022-04-27 | Scott | Indiana | 18143 | 7872 | 106 |
2448240 | 2448240 | 2022-04-27 | Shelby | Indiana | 18145 | 13610 | 182 |
2448241 | 2448241 | 2022-04-27 | Spencer | Indiana | 18147 | 5228 | 61 |
2448242 | 2448242 | 2022-04-27 | St. Joseph | Indiana | 18141 | 71095 | 872 |
2448243 | 2448243 | 2022-04-27 | Starke | Indiana | 18149 | 4761 | 99 |
2448244 | 2448244 | 2022-04-27 | Steuben | Indiana | 18151 | 9623 | 121 |
2448245 | 2448245 | 2022-04-27 | Sullivan | Indiana | 18153 | 5281 | 76 |
2448246 | 2448246 | 2022-04-27 | Switzerland | Indiana | 18155 | 2312 | 20 |
2448247 | 2448247 | 2022-04-27 | Tippecanoe | Indiana | 18157 | 50819 | 396 |
2448248 | 2448248 | 2022-04-27 | Tipton | Indiana | 18159 | 3529 | 87 |
2448249 | 2448249 | 2022-04-27 | Union | Indiana | 18161 | 2020 | 21 |
2448250 | 2448250 | 2022-04-27 | Unknown | Indiana | 0 | 2 | |
2448251 | 2448251 | 2022-04-27 | Vanderburgh | Indiana | 18163 | 57449 | 634 |
2448252 | 2448252 | 2022-04-27 | Vermillion | Indiana | 18165 | 4084 | 75 |
2448253 | 2448253 | 2022-04-27 | Vigo | Indiana | 18167 | 28905 | 413 |
2448254 | 2448254 | 2022-04-27 | Wabash | Indiana | 18169 | 8728 | 156 |
2448255 | 2448255 | 2022-04-27 | Warren | Indiana | 18171 | 2101 | 30 |
2448256 | 2448256 | 2022-04-27 | Warrick | Indiana | 18173 | 20307 | 239 |
2448257 | 2448257 | 2022-04-27 | Washington | Indiana | 18175 | 5996 | 84 |
2448258 | 2448258 | 2022-04-27 | Wayne | Indiana | 18177 | 18853 | 336 |
2448259 | 2448259 | 2022-04-27 | Wells | Indiana | 18179 | 6503 | 132 |
2448260 | 2448260 | 2022-04-27 | White | Indiana | 18181 | 6901 | 96 |
2448261 | 2448261 | 2022-04-27 | Whitley | Indiana | 18183 | 9680 | 84 |
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);