ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2022-02-03" 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 |
---|---|---|---|---|---|---|---|
2178153 | 2178153 | 2022-02-03 | Adams | Indiana | 18001 | 7204 | 106 |
2178154 | 2178154 | 2022-02-03 | Allen | Indiana | 18003 | 101249 | 1091 |
2178155 | 2178155 | 2022-02-03 | Bartholomew | Indiana | 18005 | 20596 | 231 |
2178156 | 2178156 | 2022-02-03 | Benton | Indiana | 18007 | 2402 | 21 |
2178157 | 2178157 | 2022-02-03 | Blackford | Indiana | 18009 | 3024 | 66 |
2178158 | 2178158 | 2022-02-03 | Boone | Indiana | 18011 | 14636 | 156 |
2178159 | 2178159 | 2022-02-03 | Brown | Indiana | 18013 | 2519 | 60 |
2178160 | 2178160 | 2022-02-03 | Carroll | Indiana | 18015 | 4131 | 59 |
2178161 | 2178161 | 2022-02-03 | Cass | Indiana | 18017 | 11175 | 154 |
2178162 | 2178162 | 2022-02-03 | Clark | Indiana | 18019 | 29573 | 361 |
2178163 | 2178163 | 2022-02-03 | Clay | Indiana | 18021 | 6655 | 81 |
2178164 | 2178164 | 2022-02-03 | Clinton | Indiana | 18023 | 8946 | 111 |
2178165 | 2178165 | 2022-02-03 | Crawford | Indiana | 18025 | 2410 | 35 |
2178166 | 2178166 | 2022-02-03 | Daviess | Indiana | 18027 | 7260 | 135 |
2178167 | 2178167 | 2022-02-03 | DeKalb | Indiana | 18033 | 11084 | 143 |
2178168 | 2178168 | 2022-02-03 | Dearborn | Indiana | 18029 | 13026 | 123 |
2178169 | 2178169 | 2022-02-03 | Decatur | Indiana | 18031 | 6826 | 136 |
2178170 | 2178170 | 2022-02-03 | Delaware | Indiana | 18035 | 23767 | 409 |
2178171 | 2178171 | 2022-02-03 | Dubois | Indiana | 18037 | 12455 | 157 |
2178172 | 2178172 | 2022-02-03 | Elkhart | Indiana | 18039 | 53173 | 686 |
2178173 | 2178173 | 2022-02-03 | Fayette | Indiana | 18041 | 6635 | 133 |
2178174 | 2178174 | 2022-02-03 | Floyd | Indiana | 18043 | 17984 | 272 |
2178175 | 2178175 | 2022-02-03 | Fountain | Indiana | 18045 | 5213 | 92 |
2178176 | 2178176 | 2022-02-03 | Franklin | Indiana | 18047 | 4241 | 58 |
2178177 | 2178177 | 2022-02-03 | Fulton | Indiana | 18049 | 4745 | 100 |
2178178 | 2178178 | 2022-02-03 | Gibson | Indiana | 18051 | 11198 | 135 |
2178179 | 2178179 | 2022-02-03 | Grant | Indiana | 18053 | 17220 | 327 |
2178180 | 2178180 | 2022-02-03 | Greene | Indiana | 18055 | 6864 | 126 |
2178181 | 2178181 | 2022-02-03 | Hamilton | Indiana | 18057 | 79365 | 602 |
2178182 | 2178182 | 2022-02-03 | Hancock | Indiana | 18059 | 20204 | 239 |
2178183 | 2178183 | 2022-02-03 | Harrison | Indiana | 18061 | 10267 | 126 |
2178184 | 2178184 | 2022-02-03 | Hendricks | Indiana | 18063 | 39779 | 511 |
2178185 | 2178185 | 2022-02-03 | Henry | Indiana | 18065 | 12585 | 213 |
2178186 | 2178186 | 2022-02-03 | Howard | Indiana | 18067 | 24722 | 409 |
2178187 | 2178187 | 2022-02-03 | Huntington | Indiana | 18069 | 11184 | 146 |
2178188 | 2178188 | 2022-02-03 | Jackson | Indiana | 18071 | 12023 | 111 |
2178189 | 2178189 | 2022-02-03 | Jasper | Indiana | 18073 | 8804 | 135 |
2178190 | 2178190 | 2022-02-03 | Jay | Indiana | 18075 | 4693 | 75 |
2178191 | 2178191 | 2022-02-03 | Jefferson | Indiana | 18077 | 9027 | 138 |
2178192 | 2178192 | 2022-02-03 | Jennings | Indiana | 18079 | 6712 | 96 |
2178193 | 2178193 | 2022-02-03 | Johnson | Indiana | 18081 | 41377 | 576 |
2178194 | 2178194 | 2022-02-03 | Knox | Indiana | 18083 | 10322 | 133 |
2178195 | 2178195 | 2022-02-03 | Kosciusko | Indiana | 18085 | 19249 | 218 |
2178196 | 2178196 | 2022-02-03 | LaGrange | Indiana | 18087 | 5767 | 99 |
2178197 | 2178197 | 2022-02-03 | LaPorte | Indiana | 18091 | 24817 | 331 |
2178198 | 2178198 | 2022-02-03 | Lake | Indiana | 18089 | 104223 | 1690 |
2178199 | 2178199 | 2022-02-03 | Lawrence | Indiana | 18093 | 11395 | 232 |
2178200 | 2178200 | 2022-02-03 | Madison | Indiana | 18095 | 31754 | 603 |
2178201 | 2178201 | 2022-02-03 | Marion | Indiana | 18097 | 219817 | 2781 |
2178202 | 2178202 | 2022-02-03 | Marshall | Indiana | 18099 | 12079 | 187 |
2178203 | 2178203 | 2022-02-03 | Martin | Indiana | 18101 | 2113 | 24 |
2178204 | 2178204 | 2022-02-03 | Miami | Indiana | 18103 | 8965 | 145 |
2178205 | 2178205 | 2022-02-03 | Monroe | Indiana | 18105 | 26312 | 258 |
2178206 | 2178206 | 2022-02-03 | Montgomery | Indiana | 18107 | 10299 | 153 |
2178207 | 2178207 | 2022-02-03 | Morgan | Indiana | 18109 | 16003 | 262 |
2178208 | 2178208 | 2022-02-03 | Newton | Indiana | 18111 | 2497 | 65 |
2178209 | 2178209 | 2022-02-03 | Noble | Indiana | 18113 | 12777 | 149 |
2178210 | 2178210 | 2022-02-03 | Ohio | Indiana | 18115 | 1404 | 17 |
2178211 | 2178211 | 2022-02-03 | Orange | Indiana | 18117 | 4848 | 91 |
2178212 | 2178212 | 2022-02-03 | Owen | Indiana | 18119 | 5608 | 107 |
2178213 | 2178213 | 2022-02-03 | Parke | Indiana | 18121 | 3505 | 43 |
2178214 | 2178214 | 2022-02-03 | Perry | Indiana | 18123 | 4482 | 64 |
2178215 | 2178215 | 2022-02-03 | Pike | Indiana | 18125 | 3595 | 49 |
2178216 | 2178216 | 2022-02-03 | Porter | Indiana | 18127 | 36185 | 522 |
2178217 | 2178217 | 2022-02-03 | Posey | Indiana | 18129 | 6307 | 50 |
2178218 | 2178218 | 2022-02-03 | Pulaski | Indiana | 18131 | 2964 | 81 |
2178219 | 2178219 | 2022-02-03 | Putnam | Indiana | 18133 | 9001 | 110 |
2178220 | 2178220 | 2022-02-03 | Randolph | Indiana | 18135 | 5748 | 138 |
2178221 | 2178221 | 2022-02-03 | Ripley | Indiana | 18137 | 8055 | 126 |
2178222 | 2178222 | 2022-02-03 | Rush | Indiana | 18139 | 4717 | 46 |
2178223 | 2178223 | 2022-02-03 | Scott | Indiana | 18143 | 7516 | 93 |
2178224 | 2178224 | 2022-02-03 | Shelby | Indiana | 18145 | 14276 | 167 |
2178225 | 2178225 | 2022-02-03 | Spencer | Indiana | 18147 | 5022 | 58 |
2178226 | 2178226 | 2022-02-03 | St. Joseph | Indiana | 18141 | 68971 | 810 |
2178227 | 2178227 | 2022-02-03 | Starke | Indiana | 18149 | 4627 | 92 |
2178228 | 2178228 | 2022-02-03 | Steuben | Indiana | 18151 | 9415 | 113 |
2178229 | 2178229 | 2022-02-03 | Sullivan | Indiana | 18153 | 5058 | 70 |
2178230 | 2178230 | 2022-02-03 | Switzerland | Indiana | 18155 | 2232 | 15 |
2178231 | 2178231 | 2022-02-03 | Tippecanoe | Indiana | 18157 | 48413 | 356 |
2178232 | 2178232 | 2022-02-03 | Tipton | Indiana | 18159 | 3441 | 81 |
2178233 | 2178233 | 2022-02-03 | Union | Indiana | 18161 | 1967 | 21 |
2178234 | 2178234 | 2022-02-03 | Vanderburgh | Indiana | 18163 | 55135 | 562 |
2178235 | 2178235 | 2022-02-03 | Vermillion | Indiana | 18165 | 3930 | 67 |
2178236 | 2178236 | 2022-02-03 | Vigo | Indiana | 18167 | 28055 | 369 |
2178237 | 2178237 | 2022-02-03 | Wabash | Indiana | 18169 | 8423 | 144 |
2178238 | 2178238 | 2022-02-03 | Warren | Indiana | 18171 | 2006 | 24 |
2178239 | 2178239 | 2022-02-03 | Warrick | Indiana | 18173 | 19457 | 225 |
2178240 | 2178240 | 2022-02-03 | Washington | Indiana | 18175 | 5738 | 74 |
2178241 | 2178241 | 2022-02-03 | Wayne | Indiana | 18177 | 18589 | 318 |
2178242 | 2178242 | 2022-02-03 | Wells | Indiana | 18179 | 6382 | 127 |
2178243 | 2178243 | 2022-02-03 | White | Indiana | 18181 | 6633 | 88 |
2178244 | 2178244 | 2022-02-03 | Whitley | Indiana | 18183 | 9486 | 77 |
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);