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-31 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1671118 | 1671118 | 2021-08-31 | Adams | Indiana | 18001 | 4143 | 64 |
1671119 | 1671119 | 2021-08-31 | Allen | Indiana | 18003 | 48857 | 743 |
1671120 | 1671120 | 2021-08-31 | Bartholomew | Indiana | 18005 | 9358 | 166 |
1671121 | 1671121 | 2021-08-31 | Benton | Indiana | 18007 | 1249 | 15 |
1671122 | 1671122 | 2021-08-31 | Blackford | Indiana | 18009 | 1518 | 34 |
1671123 | 1671123 | 2021-08-31 | Boone | Indiana | 18011 | 7821 | 114 |
1671124 | 1671124 | 2021-08-31 | Brown | Indiana | 18013 | 1228 | 45 |
1671125 | 1671125 | 2021-08-31 | Carroll | Indiana | 18015 | 2244 | 27 |
1671126 | 1671126 | 2021-08-31 | Cass | Indiana | 18017 | 6603 | 117 |
1671127 | 1671127 | 2021-08-31 | Clark | Indiana | 18019 | 15942 | 219 |
1671128 | 1671128 | 2021-08-31 | Clay | Indiana | 18021 | 3385 | 51 |
1671129 | 1671129 | 2021-08-31 | Clinton | Indiana | 18023 | 5012 | 65 |
1671130 | 1671130 | 2021-08-31 | Crawford | Indiana | 18025 | 1282 | 19 |
1671131 | 1671131 | 2021-08-31 | Daviess | Indiana | 18027 | 3591 | 104 |
1671132 | 1671132 | 2021-08-31 | DeKalb | Indiana | 18033 | 5150 | 92 |
1671133 | 1671133 | 2021-08-31 | Dearborn | Indiana | 18029 | 6795 | 87 |
1671134 | 1671134 | 2021-08-31 | Decatur | Indiana | 18031 | 3483 | 98 |
1671135 | 1671135 | 2021-08-31 | Delaware | Indiana | 18035 | 12479 | 211 |
1671136 | 1671136 | 2021-08-31 | Dubois | Indiana | 18037 | 6969 | 120 |
1671137 | 1671137 | 2021-08-31 | Elkhart | Indiana | 18039 | 31311 | 495 |
1671138 | 1671138 | 2021-08-31 | Fayette | Indiana | 18041 | 3371 | 69 |
1671139 | 1671139 | 2021-08-31 | Floyd | Indiana | 18043 | 9379 | 197 |
1671140 | 1671140 | 2021-08-31 | Fountain | Indiana | 18045 | 2720 | 54 |
1671141 | 1671141 | 2021-08-31 | Franklin | Indiana | 18047 | 2026 | 36 |
1671142 | 1671142 | 2021-08-31 | Fulton | Indiana | 18049 | 2373 | 48 |
1671143 | 1671143 | 2021-08-31 | Gibson | Indiana | 18051 | 5481 | 105 |
1671144 | 1671144 | 2021-08-31 | Grant | Indiana | 18053 | 8624 | 195 |
1671145 | 1671145 | 2021-08-31 | Greene | Indiana | 18055 | 3407 | 90 |
1671146 | 1671146 | 2021-08-31 | Hamilton | Indiana | 18057 | 40826 | 453 |
1671147 | 1671147 | 2021-08-31 | Hancock | Indiana | 18059 | 9844 | 158 |
1671148 | 1671148 | 2021-08-31 | Harrison | Indiana | 18061 | 5401 | 82 |
1671149 | 1671149 | 2021-08-31 | Hendricks | Indiana | 18063 | 20313 | 351 |
1671150 | 1671150 | 2021-08-31 | Henry | Indiana | 18065 | 6833 | 121 |
1671151 | 1671151 | 2021-08-31 | Howard | Indiana | 18067 | 12439 | 253 |
1671152 | 1671152 | 2021-08-31 | Huntington | Indiana | 18069 | 5471 | 89 |
1671153 | 1671153 | 2021-08-31 | Jackson | Indiana | 18071 | 5916 | 80 |
1671154 | 1671154 | 2021-08-31 | Jasper | Indiana | 18073 | 4336 | 61 |
1671155 | 1671155 | 2021-08-31 | Jay | Indiana | 18075 | 2321 | 36 |
1671156 | 1671156 | 2021-08-31 | Jefferson | Indiana | 18077 | 4143 | 91 |
1671157 | 1671157 | 2021-08-31 | Jennings | Indiana | 18079 | 2971 | 54 |
1671158 | 1671158 | 2021-08-31 | Johnson | Indiana | 18081 | 21625 | 422 |
1671159 | 1671159 | 2021-08-31 | Knox | Indiana | 18083 | 4968 | 95 |
1671160 | 1671160 | 2021-08-31 | Kosciusko | Indiana | 18085 | 10470 | 133 |
1671161 | 1671161 | 2021-08-31 | LaGrange | Indiana | 18087 | 2916 | 75 |
1671162 | 1671162 | 2021-08-31 | LaPorte | Indiana | 18091 | 13343 | 231 |
1671163 | 1671163 | 2021-08-31 | Lake | Indiana | 18089 | 60090 | 1100 |
1671164 | 1671164 | 2021-08-31 | Lawrence | Indiana | 18093 | 6264 | 140 |
1671165 | 1671165 | 2021-08-31 | Madison | Indiana | 18095 | 15715 | 382 |
1671166 | 1671166 | 2021-08-31 | Marion | Indiana | 18097 | 117885 | 1950 |
1671167 | 1671167 | 2021-08-31 | Marshall | Indiana | 18099 | 6797 | 122 |
1671168 | 1671168 | 2021-08-31 | Martin | Indiana | 18101 | 1102 | 15 |
1671169 | 1671169 | 2021-08-31 | Miami | Indiana | 18103 | 4779 | 78 |
1671170 | 1671170 | 2021-08-31 | Monroe | Indiana | 18105 | 13592 | 190 |
1671171 | 1671171 | 2021-08-31 | Montgomery | Indiana | 18107 | 5234 | 97 |
1671172 | 1671172 | 2021-08-31 | Morgan | Indiana | 18109 | 7977 | 156 |
1671173 | 1671173 | 2021-08-31 | Newton | Indiana | 18111 | 1292 | 42 |
1671174 | 1671174 | 2021-08-31 | Noble | Indiana | 18113 | 6721 | 100 |
1671175 | 1671175 | 2021-08-31 | Ohio | Indiana | 18115 | 697 | 11 |
1671176 | 1671176 | 2021-08-31 | Orange | Indiana | 18117 | 2501 | 60 |
1671177 | 1671177 | 2021-08-31 | Owen | Indiana | 18119 | 2568 | 63 |
1671178 | 1671178 | 2021-08-31 | Parke | Indiana | 18121 | 1909 | 18 |
1671179 | 1671179 | 2021-08-31 | Perry | Indiana | 18123 | 2278 | 45 |
1671180 | 1671180 | 2021-08-31 | Pike | Indiana | 18125 | 1732 | 35 |
1671181 | 1671181 | 2021-08-31 | Porter | Indiana | 18127 | 20585 | 345 |
1671182 | 1671182 | 2021-08-31 | Posey | Indiana | 18129 | 3275 | 38 |
1671183 | 1671183 | 2021-08-31 | Pulaski | Indiana | 18131 | 1392 | 50 |
1671184 | 1671184 | 2021-08-31 | Putnam | Indiana | 18133 | 4771 | 68 |
1671185 | 1671185 | 2021-08-31 | Randolph | Indiana | 18135 | 2789 | 85 |
1671186 | 1671186 | 2021-08-31 | Ripley | Indiana | 18137 | 3990 | 72 |
1671187 | 1671187 | 2021-08-31 | Rush | Indiana | 18139 | 2034 | 27 |
1671188 | 1671188 | 2021-08-31 | Scott | Indiana | 18143 | 3494 | 62 |
1671189 | 1671189 | 2021-08-31 | Shelby | Indiana | 18145 | 6827 | 110 |
1671190 | 1671190 | 2021-08-31 | Spencer | Indiana | 18147 | 2859 | 32 |
1671191 | 1671191 | 2021-08-31 | St. Joseph | Indiana | 18141 | 39447 | 595 |
1671192 | 1671192 | 2021-08-31 | Starke | Indiana | 18149 | 2500 | 62 |
1671193 | 1671193 | 2021-08-31 | Steuben | Indiana | 18151 | 4550 | 66 |
1671194 | 1671194 | 2021-08-31 | Sullivan | Indiana | 18153 | 2641 | 47 |
1671195 | 1671195 | 2021-08-31 | Switzerland | Indiana | 18155 | 1056 | 9 |
1671196 | 1671196 | 2021-08-31 | Tippecanoe | Indiana | 18157 | 25453 | 240 |
1671197 | 1671197 | 2021-08-31 | Tipton | Indiana | 18159 | 1938 | 53 |
1671198 | 1671198 | 2021-08-31 | Union | Indiana | 18161 | 873 | 11 |
1671199 | 1671199 | 2021-08-31 | Vanderburgh | Indiana | 18163 | 27445 | 425 |
1671200 | 1671200 | 2021-08-31 | Vermillion | Indiana | 18165 | 2081 | 46 |
1671201 | 1671201 | 2021-08-31 | Vigo | Indiana | 18167 | 14301 | 267 |
1671202 | 1671202 | 2021-08-31 | Wabash | Indiana | 18169 | 4336 | 86 |
1671203 | 1671203 | 2021-08-31 | Warren | Indiana | 18171 | 1018 | 17 |
1671204 | 1671204 | 2021-08-31 | Warrick | Indiana | 18173 | 9564 | 168 |
1671205 | 1671205 | 2021-08-31 | Washington | Indiana | 18175 | 2964 | 43 |
1671206 | 1671206 | 2021-08-31 | Wayne | Indiana | 18177 | 8827 | 209 |
1671207 | 1671207 | 2021-08-31 | Wells | Indiana | 18179 | 3467 | 84 |
1671208 | 1671208 | 2021-08-31 | White | Indiana | 18181 | 3650 | 57 |
1671209 | 1671209 | 2021-08-31 | Whitley | Indiana | 18183 | 4740 | 48 |
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);