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 2021-01-04 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
895179 | 895179 | 2021-01-04 | Adams | Indiana | 18001 | 2690 | 35 |
895180 | 895180 | 2021-01-04 | Allen | Indiana | 18003 | 28954 | 517 |
895181 | 895181 | 2021-01-04 | Bartholomew | Indiana | 18005 | 5676 | 95 |
895182 | 895182 | 2021-01-04 | Benton | Indiana | 18007 | 768 | 9 |
895183 | 895183 | 2021-01-04 | Blackford | Indiana | 18009 | 926 | 22 |
895184 | 895184 | 2021-01-04 | Boone | Indiana | 18011 | 4750 | 67 |
895185 | 895185 | 2021-01-04 | Brown | Indiana | 18013 | 760 | 9 |
895186 | 895186 | 2021-01-04 | Carroll | Indiana | 18015 | 1390 | 15 |
895187 | 895187 | 2021-01-04 | Cass | Indiana | 18017 | 4333 | 45 |
895188 | 895188 | 2021-01-04 | Clark | Indiana | 18019 | 8894 | 121 |
895189 | 895189 | 2021-01-04 | Clay | Indiana | 18021 | 1921 | 31 |
895190 | 895190 | 2021-01-04 | Clinton | Indiana | 18023 | 3329 | 39 |
895191 | 895191 | 2021-01-04 | Crawford | Indiana | 18025 | 624 | 8 |
895192 | 895192 | 2021-01-04 | Daviess | Indiana | 18027 | 2351 | 73 |
895193 | 895193 | 2021-01-04 | DeKalb | Indiana | 18033 | 3101 | 63 |
895194 | 895194 | 2021-01-04 | Dearborn | Indiana | 18029 | 3973 | 42 |
895195 | 895195 | 2021-01-04 | Decatur | Indiana | 18031 | 2218 | 79 |
895196 | 895196 | 2021-01-04 | Delaware | Indiana | 18035 | 7838 | 129 |
895197 | 895197 | 2021-01-04 | Dubois | Indiana | 18037 | 4874 | 62 |
895198 | 895198 | 2021-01-04 | Elkhart | Indiana | 18039 | 23112 | 331 |
895199 | 895199 | 2021-01-04 | Fayette | Indiana | 18041 | 2380 | 43 |
895200 | 895200 | 2021-01-04 | Floyd | Indiana | 18043 | 5353 | 104 |
895201 | 895201 | 2021-01-04 | Fountain | Indiana | 18045 | 1571 | 26 |
895202 | 895202 | 2021-01-04 | Franklin | Indiana | 18047 | 1285 | 30 |
895203 | 895203 | 2021-01-04 | Fulton | Indiana | 18049 | 1444 | 27 |
895204 | 895204 | 2021-01-04 | Gibson | Indiana | 18051 | 3123 | 56 |
895205 | 895205 | 2021-01-04 | Grant | Indiana | 18053 | 5582 | 106 |
895206 | 895206 | 2021-01-04 | Greene | Indiana | 18055 | 2013 | 60 |
895207 | 895207 | 2021-01-04 | Hamilton | Indiana | 18057 | 24963 | 301 |
895208 | 895208 | 2021-01-04 | Hancock | Indiana | 18059 | 5484 | 87 |
895209 | 895209 | 2021-01-04 | Harrison | Indiana | 18061 | 2796 | 38 |
895210 | 895210 | 2021-01-04 | Hendricks | Indiana | 18063 | 12111 | 240 |
895211 | 895211 | 2021-01-04 | Henry | Indiana | 18065 | 4412 | 57 |
895212 | 895212 | 2021-01-04 | Howard | Indiana | 18067 | 6883 | 126 |
895213 | 895213 | 2021-01-04 | Huntington | Indiana | 18069 | 2543 | 49 |
895214 | 895214 | 2021-01-04 | Jackson | Indiana | 18071 | 3849 | 44 |
895215 | 895215 | 2021-01-04 | Jasper | Indiana | 18073 | 2533 | 33 |
895216 | 895216 | 2021-01-04 | Jay | Indiana | 18075 | 1541 | 23 |
895217 | 895217 | 2021-01-04 | Jefferson | Indiana | 18077 | 2225 | 41 |
895218 | 895218 | 2021-01-04 | Jennings | Indiana | 18079 | 1741 | 35 |
895219 | 895219 | 2021-01-04 | Johnson | Indiana | 18081 | 12730 | 257 |
895220 | 895220 | 2021-01-04 | Knox | Indiana | 18083 | 2985 | 38 |
895221 | 895221 | 2021-01-04 | Kosciusko | Indiana | 18085 | 7059 | 73 |
895222 | 895222 | 2021-01-04 | LaGrange | Indiana | 18087 | 2079 | 58 |
895223 | 895223 | 2021-01-04 | LaPorte | Indiana | 18091 | 7841 | 142 |
895224 | 895224 | 2021-01-04 | Lake | Indiana | 18089 | 41028 | 641 |
895225 | 895225 | 2021-01-04 | Lawrence | Indiana | 18093 | 3419 | 67 |
895226 | 895226 | 2021-01-04 | Madison | Indiana | 18095 | 9333 | 201 |
895227 | 895227 | 2021-01-04 | Marion | Indiana | 18097 | 73341 | 1235 |
895228 | 895228 | 2021-01-04 | Marshall | Indiana | 18099 | 4623 | 81 |
895229 | 895229 | 2021-01-04 | Martin | Indiana | 18101 | 624 | 13 |
895230 | 895230 | 2021-01-04 | Miami | Indiana | 18103 | 2811 | 33 |
895231 | 895231 | 2021-01-04 | Monroe | Indiana | 18105 | 8223 | 102 |
895232 | 895232 | 2021-01-04 | Montgomery | Indiana | 18107 | 2948 | 51 |
895233 | 895233 | 2021-01-04 | Morgan | Indiana | 18109 | 4512 | 84 |
895234 | 895234 | 2021-01-04 | Newton | Indiana | 18111 | 845 | 20 |
895235 | 895235 | 2021-01-04 | Noble | Indiana | 18113 | 4192 | 57 |
895236 | 895236 | 2021-01-04 | Ohio | Indiana | 18115 | 408 | 7 |
895237 | 895237 | 2021-01-04 | Orange | Indiana | 18117 | 1317 | 34 |
895238 | 895238 | 2021-01-04 | Owen | Indiana | 18119 | 1393 | 34 |
895239 | 895239 | 2021-01-04 | Parke | Indiana | 18121 | 1204 | 8 |
895240 | 895240 | 2021-01-04 | Perry | Indiana | 18123 | 1258 | 24 |
895241 | 895241 | 2021-01-04 | Pike | Indiana | 18125 | 977 | 27 |
895242 | 895242 | 2021-01-04 | Porter | Indiana | 18127 | 13218 | 158 |
895243 | 895243 | 2021-01-04 | Posey | Indiana | 18129 | 2002 | 26 |
895244 | 895244 | 2021-01-04 | Pulaski | Indiana | 18131 | 868 | 33 |
895245 | 895245 | 2021-01-04 | Putnam | Indiana | 18133 | 2555 | 40 |
895246 | 895246 | 2021-01-04 | Randolph | Indiana | 18135 | 1932 | 37 |
895247 | 895247 | 2021-01-04 | Ripley | Indiana | 18137 | 2587 | 42 |
895248 | 895248 | 2021-01-04 | Rush | Indiana | 18139 | 1326 | 15 |
895249 | 895249 | 2021-01-04 | Scott | Indiana | 18143 | 1968 | 39 |
895250 | 895250 | 2021-01-04 | Shelby | Indiana | 18145 | 4329 | 83 |
895251 | 895251 | 2021-01-04 | Spencer | Indiana | 18147 | 1578 | 14 |
895252 | 895252 | 2021-01-04 | St. Joseph | Indiana | 18141 | 24864 | 371 |
895253 | 895253 | 2021-01-04 | Starke | Indiana | 18149 | 1588 | 44 |
895254 | 895254 | 2021-01-04 | Steuben | Indiana | 18151 | 2747 | 28 |
895255 | 895255 | 2021-01-04 | Sullivan | Indiana | 18153 | 1715 | 28 |
895256 | 895256 | 2021-01-04 | Switzerland | Indiana | 18155 | 524 | 5 |
895257 | 895257 | 2021-01-04 | Tippecanoe | Indiana | 18157 | 15517 | 98 |
895258 | 895258 | 2021-01-04 | Tipton | Indiana | 18159 | 1130 | 33 |
895259 | 895259 | 2021-01-04 | Union | Indiana | 18161 | 557 | 2 |
895260 | 895260 | 2021-01-04 | Vanderburgh | Indiana | 18163 | 16266 | 208 |
895261 | 895261 | 2021-01-04 | Vermillion | Indiana | 18165 | 1293 | 32 |
895262 | 895262 | 2021-01-04 | Vigo | Indiana | 18167 | 9621 | 165 |
895263 | 895263 | 2021-01-04 | Wabash | Indiana | 18169 | 2670 | 44 |
895264 | 895264 | 2021-01-04 | Warren | Indiana | 18171 | 576 | 8 |
895265 | 895265 | 2021-01-04 | Warrick | Indiana | 18173 | 5498 | 89 |
895266 | 895266 | 2021-01-04 | Washington | Indiana | 18175 | 1514 | 16 |
895267 | 895267 | 2021-01-04 | Wayne | Indiana | 18177 | 5762 | 149 |
895268 | 895268 | 2021-01-04 | Wells | Indiana | 18179 | 2015 | 48 |
895269 | 895269 | 2021-01-04 | White | Indiana | 18181 | 2423 | 33 |
895270 | 895270 | 2021-01-04 | Whitley | Indiana | 18183 | 2564 | 21 |
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);