ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-05-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 |
---|---|---|---|---|---|---|---|
1356167 | 1356167 | 2021-05-26 | Adams | Indiana | 18001 | 3502 | 56 |
1356168 | 1356168 | 2021-05-26 | Allen | Indiana | 18003 | 41330 | 705 |
1356169 | 1356169 | 2021-05-26 | Bartholomew | Indiana | 18005 | 8142 | 161 |
1356170 | 1356170 | 2021-05-26 | Benton | Indiana | 18007 | 993 | 14 |
1356171 | 1356171 | 2021-05-26 | Blackford | Indiana | 18009 | 1364 | 32 |
1356172 | 1356172 | 2021-05-26 | Boone | Indiana | 18011 | 6826 | 106 |
1356173 | 1356173 | 2021-05-26 | Brown | Indiana | 18013 | 1030 | 41 |
1356174 | 1356174 | 2021-05-26 | Carroll | Indiana | 18015 | 1920 | 22 |
1356175 | 1356175 | 2021-05-26 | Cass | Indiana | 18017 | 5943 | 108 |
1356176 | 1356176 | 2021-05-26 | Clark | Indiana | 18019 | 13116 | 201 |
1356177 | 1356177 | 2021-05-26 | Clay | Indiana | 18021 | 2627 | 47 |
1356178 | 1356178 | 2021-05-26 | Clinton | Indiana | 18023 | 4326 | 58 |
1356179 | 1356179 | 2021-05-26 | Crawford | Indiana | 18025 | 1017 | 17 |
1356180 | 1356180 | 2021-05-26 | Daviess | Indiana | 18027 | 3001 | 101 |
1356181 | 1356181 | 2021-05-26 | DeKalb | Indiana | 18033 | 4354 | 88 |
1356182 | 1356182 | 2021-05-26 | Dearborn | Indiana | 18029 | 5867 | 81 |
1356183 | 1356183 | 2021-05-26 | Decatur | Indiana | 18031 | 2934 | 96 |
1356184 | 1356184 | 2021-05-26 | Delaware | Indiana | 18035 | 10869 | 196 |
1356185 | 1356185 | 2021-05-26 | Dubois | Indiana | 18037 | 6183 | 118 |
1356186 | 1356186 | 2021-05-26 | Elkhart | Indiana | 18039 | 29204 | 463 |
1356187 | 1356187 | 2021-05-26 | Fayette | Indiana | 18041 | 2972 | 65 |
1356188 | 1356188 | 2021-05-26 | Floyd | Indiana | 18043 | 7723 | 184 |
1356189 | 1356189 | 2021-05-26 | Fountain | Indiana | 18045 | 2158 | 47 |
1356190 | 1356190 | 2021-05-26 | Franklin | Indiana | 18047 | 1712 | 36 |
1356191 | 1356191 | 2021-05-26 | Fulton | Indiana | 18049 | 1976 | 41 |
1356192 | 1356192 | 2021-05-26 | Gibson | Indiana | 18051 | 4419 | 95 |
1356193 | 1356193 | 2021-05-26 | Grant | Indiana | 18053 | 7571 | 181 |
1356194 | 1356194 | 2021-05-26 | Greene | Indiana | 18055 | 2842 | 89 |
1356195 | 1356195 | 2021-05-26 | Hamilton | Indiana | 18057 | 36124 | 429 |
1356196 | 1356196 | 2021-05-26 | Hancock | Indiana | 18059 | 8457 | 146 |
1356197 | 1356197 | 2021-05-26 | Harrison | Indiana | 18061 | 4384 | 75 |
1356198 | 1356198 | 2021-05-26 | Hendricks | Indiana | 18063 | 17505 | 336 |
1356199 | 1356199 | 2021-05-26 | Henry | Indiana | 18065 | 5855 | 107 |
1356200 | 1356200 | 2021-05-26 | Howard | Indiana | 18067 | 10141 | 226 |
1356201 | 1356201 | 2021-05-26 | Huntington | Indiana | 18069 | 3990 | 82 |
1356202 | 1356202 | 2021-05-26 | Jackson | Indiana | 18071 | 5060 | 75 |
1356203 | 1356203 | 2021-05-26 | Jasper | Indiana | 18073 | 3792 | 54 |
1356204 | 1356204 | 2021-05-26 | Jay | Indiana | 18075 | 2003 | 33 |
1356205 | 1356205 | 2021-05-26 | Jefferson | Indiana | 18077 | 3329 | 83 |
1356206 | 1356206 | 2021-05-26 | Jennings | Indiana | 18079 | 2332 | 51 |
1356207 | 1356207 | 2021-05-26 | Johnson | Indiana | 18081 | 18249 | 398 |
1356208 | 1356208 | 2021-05-26 | Knox | Indiana | 18083 | 3745 | 90 |
1356209 | 1356209 | 2021-05-26 | Kosciusko | Indiana | 18085 | 9566 | 121 |
1356210 | 1356210 | 2021-05-26 | LaGrange | Indiana | 18087 | 2710 | 73 |
1356211 | 1356211 | 2021-05-26 | LaPorte | Indiana | 18091 | 12247 | 219 |
1356212 | 1356212 | 2021-05-26 | Lake | Indiana | 18089 | 54870 | 1035 |
1356213 | 1356213 | 2021-05-26 | Lawrence | Indiana | 18093 | 4661 | 124 |
1356214 | 1356214 | 2021-05-26 | Madison | Indiana | 18095 | 12890 | 360 |
1356215 | 1356215 | 2021-05-26 | Marion | Indiana | 18097 | 101802 | 1823 |
1356216 | 1356216 | 2021-05-26 | Marshall | Indiana | 18099 | 6172 | 115 |
1356217 | 1356217 | 2021-05-26 | Martin | Indiana | 18101 | 905 | 15 |
1356218 | 1356218 | 2021-05-26 | Miami | Indiana | 18103 | 3884 | 69 |
1356219 | 1356219 | 2021-05-26 | Monroe | Indiana | 18105 | 12037 | 174 |
1356220 | 1356220 | 2021-05-26 | Montgomery | Indiana | 18107 | 4283 | 91 |
1356221 | 1356221 | 2021-05-26 | Morgan | Indiana | 18109 | 6672 | 145 |
1356222 | 1356222 | 2021-05-26 | Newton | Indiana | 18111 | 1108 | 37 |
1356223 | 1356223 | 2021-05-26 | Noble | Indiana | 18113 | 5732 | 88 |
1356224 | 1356224 | 2021-05-26 | Ohio | Indiana | 18115 | 577 | 11 |
1356225 | 1356225 | 2021-05-26 | Orange | Indiana | 18117 | 1876 | 57 |
1356226 | 1356226 | 2021-05-26 | Owen | Indiana | 18119 | 2071 | 58 |
1356227 | 1356227 | 2021-05-26 | Parke | Indiana | 18121 | 1486 | 16 |
1356228 | 1356228 | 2021-05-26 | Perry | Indiana | 18123 | 1863 | 38 |
1356229 | 1356229 | 2021-05-26 | Pike | Indiana | 18125 | 1364 | 34 |
1356230 | 1356230 | 2021-05-26 | Porter | Indiana | 18127 | 19159 | 331 |
1356231 | 1356231 | 2021-05-26 | Posey | Indiana | 18129 | 2726 | 34 |
1356232 | 1356232 | 2021-05-26 | Pulaski | Indiana | 18131 | 1185 | 46 |
1356233 | 1356233 | 2021-05-26 | Putnam | Indiana | 18133 | 3682 | 60 |
1356234 | 1356234 | 2021-05-26 | Randolph | Indiana | 18135 | 2473 | 83 |
1356235 | 1356235 | 2021-05-26 | Ripley | Indiana | 18137 | 3433 | 70 |
1356236 | 1356236 | 2021-05-26 | Rush | Indiana | 18139 | 1816 | 25 |
1356237 | 1356237 | 2021-05-26 | Scott | Indiana | 18143 | 2690 | 57 |
1356238 | 1356238 | 2021-05-26 | Shelby | Indiana | 18145 | 5964 | 106 |
1356239 | 1356239 | 2021-05-26 | Spencer | Indiana | 18147 | 2336 | 31 |
1356240 | 1356240 | 2021-05-26 | St. Joseph | Indiana | 18141 | 36686 | 573 |
1356241 | 1356241 | 2021-05-26 | Starke | Indiana | 18149 | 2215 | 57 |
1356242 | 1356242 | 2021-05-26 | Steuben | Indiana | 18151 | 3949 | 59 |
1356243 | 1356243 | 2021-05-26 | Sullivan | Indiana | 18153 | 2130 | 42 |
1356244 | 1356244 | 2021-05-26 | Switzerland | Indiana | 18155 | 801 | 8 |
1356245 | 1356245 | 2021-05-26 | Tippecanoe | Indiana | 18157 | 22634 | 224 |
1356246 | 1356246 | 2021-05-26 | Tipton | Indiana | 18159 | 1647 | 47 |
1356247 | 1356247 | 2021-05-26 | Union | Indiana | 18161 | 751 | 11 |
1356248 | 1356248 | 2021-05-26 | Vanderburgh | Indiana | 18163 | 22459 | 402 |
1356249 | 1356249 | 2021-05-26 | Vermillion | Indiana | 18165 | 1713 | 44 |
1356250 | 1356250 | 2021-05-26 | Vigo | Indiana | 18167 | 12552 | 256 |
1356251 | 1356251 | 2021-05-26 | Wabash | Indiana | 18169 | 3583 | 81 |
1356252 | 1356252 | 2021-05-26 | Warren | Indiana | 18171 | 831 | 16 |
1356253 | 1356253 | 2021-05-26 | Warrick | Indiana | 18173 | 7825 | 158 |
1356254 | 1356254 | 2021-05-26 | Washington | Indiana | 18175 | 2431 | 33 |
1356255 | 1356255 | 2021-05-26 | Wayne | Indiana | 18177 | 7492 | 203 |
1356256 | 1356256 | 2021-05-26 | Wells | Indiana | 18179 | 2962 | 83 |
1356257 | 1356257 | 2021-05-26 | White | Indiana | 18181 | 3220 | 54 |
1356258 | 1356258 | 2021-05-26 | Whitley | Indiana | 18183 | 4024 | 40 |
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);