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-08-15 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1619149 | 1619149 | 2021-08-15 | Adams | Indiana | 18001 | 3792 | 57 |
1619150 | 1619150 | 2021-08-15 | Allen | Indiana | 18003 | 44983 | 728 |
1619151 | 1619151 | 2021-08-15 | Bartholomew | Indiana | 18005 | 8637 | 162 |
1619152 | 1619152 | 2021-08-15 | Benton | Indiana | 18007 | 1133 | 15 |
1619153 | 1619153 | 2021-08-15 | Blackford | Indiana | 18009 | 1419 | 33 |
1619154 | 1619154 | 2021-08-15 | Boone | Indiana | 18011 | 7481 | 110 |
1619155 | 1619155 | 2021-08-15 | Brown | Indiana | 18013 | 1110 | 43 |
1619156 | 1619156 | 2021-08-15 | Carroll | Indiana | 18015 | 2103 | 26 |
1619157 | 1619157 | 2021-08-15 | Cass | Indiana | 18017 | 6264 | 114 |
1619158 | 1619158 | 2021-08-15 | Clark | Indiana | 18019 | 14380 | 208 |
1619159 | 1619159 | 2021-08-15 | Clay | Indiana | 18021 | 2962 | 49 |
1619160 | 1619160 | 2021-08-15 | Clinton | Indiana | 18023 | 4781 | 64 |
1619161 | 1619161 | 2021-08-15 | Crawford | Indiana | 18025 | 1099 | 19 |
1619162 | 1619162 | 2021-08-15 | Daviess | Indiana | 18027 | 3208 | 103 |
1619163 | 1619163 | 2021-08-15 | DeKalb | Indiana | 18033 | 4781 | 90 |
1619164 | 1619164 | 2021-08-15 | Dearborn | Indiana | 18029 | 6208 | 81 |
1619165 | 1619165 | 2021-08-15 | Decatur | Indiana | 18031 | 3092 | 97 |
1619166 | 1619166 | 2021-08-15 | Delaware | Indiana | 18035 | 11487 | 206 |
1619167 | 1619167 | 2021-08-15 | Dubois | Indiana | 18037 | 6501 | 119 |
1619168 | 1619168 | 2021-08-15 | Elkhart | Indiana | 18039 | 30355 | 490 |
1619169 | 1619169 | 2021-08-15 | Fayette | Indiana | 18041 | 3066 | 67 |
1619170 | 1619170 | 2021-08-15 | Floyd | Indiana | 18043 | 8488 | 190 |
1619171 | 1619171 | 2021-08-15 | Fountain | Indiana | 18045 | 2466 | 51 |
1619172 | 1619172 | 2021-08-15 | Franklin | Indiana | 18047 | 1809 | 36 |
1619173 | 1619173 | 2021-08-15 | Fulton | Indiana | 18049 | 2158 | 46 |
1619174 | 1619174 | 2021-08-15 | Gibson | Indiana | 18051 | 4890 | 100 |
1619175 | 1619175 | 2021-08-15 | Grant | Indiana | 18053 | 8078 | 190 |
1619176 | 1619176 | 2021-08-15 | Greene | Indiana | 18055 | 3104 | 89 |
1619177 | 1619177 | 2021-08-15 | Hamilton | Indiana | 18057 | 38480 | 447 |
1619178 | 1619178 | 2021-08-15 | Hancock | Indiana | 18059 | 9123 | 156 |
1619179 | 1619179 | 2021-08-15 | Harrison | Indiana | 18061 | 4759 | 80 |
1619180 | 1619180 | 2021-08-15 | Hendricks | Indiana | 18063 | 18847 | 345 |
1619181 | 1619181 | 2021-08-15 | Henry | Indiana | 18065 | 6190 | 114 |
1619182 | 1619182 | 2021-08-15 | Howard | Indiana | 18067 | 11203 | 245 |
1619183 | 1619183 | 2021-08-15 | Huntington | Indiana | 18069 | 4680 | 84 |
1619184 | 1619184 | 2021-08-15 | Jackson | Indiana | 18071 | 5364 | 78 |
1619185 | 1619185 | 2021-08-15 | Jasper | Indiana | 18073 | 4098 | 59 |
1619186 | 1619186 | 2021-08-15 | Jay | Indiana | 18075 | 2116 | 35 |
1619187 | 1619187 | 2021-08-15 | Jefferson | Indiana | 18077 | 3738 | 88 |
1619188 | 1619188 | 2021-08-15 | Jennings | Indiana | 18079 | 2575 | 52 |
1619189 | 1619189 | 2021-08-15 | Johnson | Indiana | 18081 | 19691 | 413 |
1619190 | 1619190 | 2021-08-15 | Knox | Indiana | 18083 | 4193 | 91 |
1619191 | 1619191 | 2021-08-15 | Kosciusko | Indiana | 18085 | 9980 | 129 |
1619192 | 1619192 | 2021-08-15 | LaGrange | Indiana | 18087 | 2828 | 75 |
1619193 | 1619193 | 2021-08-15 | LaPorte | Indiana | 18091 | 12823 | 229 |
1619194 | 1619194 | 2021-08-15 | Lake | Indiana | 18089 | 58039 | 1077 |
1619195 | 1619195 | 2021-08-15 | Lawrence | Indiana | 18093 | 5316 | 134 |
1619196 | 1619196 | 2021-08-15 | Madison | Indiana | 18095 | 14270 | 372 |
1619197 | 1619197 | 2021-08-15 | Marion | Indiana | 18097 | 109734 | 1898 |
1619198 | 1619198 | 2021-08-15 | Marshall | Indiana | 18099 | 6464 | 119 |
1619199 | 1619199 | 2021-08-15 | Martin | Indiana | 18101 | 957 | 15 |
1619200 | 1619200 | 2021-08-15 | Miami | Indiana | 18103 | 4289 | 74 |
1619201 | 1619201 | 2021-08-15 | Monroe | Indiana | 18105 | 12939 | 185 |
1619202 | 1619202 | 2021-08-15 | Montgomery | Indiana | 18107 | 4775 | 95 |
1619203 | 1619203 | 2021-08-15 | Morgan | Indiana | 18109 | 7227 | 152 |
1619204 | 1619204 | 2021-08-15 | Newton | Indiana | 18111 | 1257 | 41 |
1619205 | 1619205 | 2021-08-15 | Noble | Indiana | 18113 | 6199 | 95 |
1619206 | 1619206 | 2021-08-15 | Ohio | Indiana | 18115 | 610 | 11 |
1619207 | 1619207 | 2021-08-15 | Orange | Indiana | 18117 | 2057 | 59 |
1619208 | 1619208 | 2021-08-15 | Owen | Indiana | 18119 | 2358 | 62 |
1619209 | 1619209 | 2021-08-15 | Parke | Indiana | 18121 | 1673 | 16 |
1619210 | 1619210 | 2021-08-15 | Perry | Indiana | 18123 | 2043 | 41 |
1619211 | 1619211 | 2021-08-15 | Pike | Indiana | 18125 | 1495 | 35 |
1619212 | 1619212 | 2021-08-15 | Porter | Indiana | 18127 | 19937 | 340 |
1619213 | 1619213 | 2021-08-15 | Posey | Indiana | 18129 | 2999 | 36 |
1619214 | 1619214 | 2021-08-15 | Pulaski | Indiana | 18131 | 1274 | 49 |
1619215 | 1619215 | 2021-08-15 | Putnam | Indiana | 18133 | 4096 | 63 |
1619216 | 1619216 | 2021-08-15 | Randolph | Indiana | 18135 | 2566 | 85 |
1619217 | 1619217 | 2021-08-15 | Ripley | Indiana | 18137 | 3637 | 72 |
1619218 | 1619218 | 2021-08-15 | Rush | Indiana | 18139 | 1914 | 27 |
1619219 | 1619219 | 2021-08-15 | Scott | Indiana | 18143 | 3041 | 60 |
1619220 | 1619220 | 2021-08-15 | Shelby | Indiana | 18145 | 6311 | 109 |
1619221 | 1619221 | 2021-08-15 | Spencer | Indiana | 18147 | 2515 | 31 |
1619222 | 1619222 | 2021-08-15 | St. Joseph | Indiana | 18141 | 37981 | 587 |
1619223 | 1619223 | 2021-08-15 | Starke | Indiana | 18149 | 2376 | 61 |
1619224 | 1619224 | 2021-08-15 | Steuben | Indiana | 18151 | 4243 | 64 |
1619225 | 1619225 | 2021-08-15 | Sullivan | Indiana | 18153 | 2352 | 44 |
1619226 | 1619226 | 2021-08-15 | Switzerland | Indiana | 18155 | 903 | 8 |
1619227 | 1619227 | 2021-08-15 | Tippecanoe | Indiana | 18157 | 24230 | 237 |
1619228 | 1619228 | 2021-08-15 | Tipton | Indiana | 18159 | 1801 | 51 |
1619229 | 1619229 | 2021-08-15 | Union | Indiana | 18161 | 786 | 11 |
1619230 | 1619230 | 2021-08-15 | Vanderburgh | Indiana | 18163 | 24689 | 414 |
1619231 | 1619231 | 2021-08-15 | Vermillion | Indiana | 18165 | 1912 | 45 |
1619232 | 1619232 | 2021-08-15 | Vigo | Indiana | 18167 | 13373 | 262 |
1619233 | 1619233 | 2021-08-15 | Wabash | Indiana | 18169 | 3874 | 84 |
1619234 | 1619234 | 2021-08-15 | Warren | Indiana | 18171 | 922 | 16 |
1619235 | 1619235 | 2021-08-15 | Warrick | Indiana | 18173 | 8676 | 160 |
1619236 | 1619236 | 2021-08-15 | Washington | Indiana | 18175 | 2653 | 39 |
1619237 | 1619237 | 2021-08-15 | Wayne | Indiana | 18177 | 7807 | 206 |
1619238 | 1619238 | 2021-08-15 | Wells | Indiana | 18179 | 3178 | 83 |
1619239 | 1619239 | 2021-08-15 | White | Indiana | 18181 | 3476 | 55 |
1619240 | 1619240 | 2021-08-15 | Whitley | Indiana | 18183 | 4349 | 45 |
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);