ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2022-02-23" 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 |
---|---|---|---|---|---|---|---|
2243194 | 2243194 | 2022-02-23 | Adams | Indiana | 18001 | 7303 | 111 |
2243195 | 2243195 | 2022-02-23 | Allen | Indiana | 18003 | 103165 | 1147 |
2243196 | 2243196 | 2022-02-23 | Bartholomew | Indiana | 18005 | 21182 | 244 |
2243197 | 2243197 | 2022-02-23 | Benton | Indiana | 18007 | 2456 | 21 |
2243198 | 2243198 | 2022-02-23 | Blackford | Indiana | 18009 | 3095 | 68 |
2243199 | 2243199 | 2022-02-23 | Boone | Indiana | 18011 | 15030 | 172 |
2243200 | 2243200 | 2022-02-23 | Brown | Indiana | 18013 | 2575 | 62 |
2243201 | 2243201 | 2022-02-23 | Carroll | Indiana | 18015 | 4196 | 62 |
2243202 | 2243202 | 2022-02-23 | Cass | Indiana | 18017 | 11492 | 158 |
2243203 | 2243203 | 2022-02-23 | Clark | Indiana | 18019 | 30706 | 381 |
2243204 | 2243204 | 2022-02-23 | Clay | Indiana | 18021 | 6794 | 85 |
2243205 | 2243205 | 2022-02-23 | Clinton | Indiana | 18023 | 9142 | 118 |
2243206 | 2243206 | 2022-02-23 | Crawford | Indiana | 18025 | 2507 | 35 |
2243207 | 2243207 | 2022-02-23 | Daviess | Indiana | 18027 | 7424 | 147 |
2243208 | 2243208 | 2022-02-23 | DeKalb | Indiana | 18033 | 11279 | 148 |
2243209 | 2243209 | 2022-02-23 | Dearborn | Indiana | 18029 | 13348 | 130 |
2243210 | 2243210 | 2022-02-23 | Decatur | Indiana | 18031 | 7029 | 141 |
2243211 | 2243211 | 2022-02-23 | Delaware | Indiana | 18035 | 24523 | 422 |
2243212 | 2243212 | 2022-02-23 | Dubois | Indiana | 18037 | 12772 | 159 |
2243213 | 2243213 | 2022-02-23 | Elkhart | Indiana | 18039 | 53928 | 717 |
2243214 | 2243214 | 2022-02-23 | Fayette | Indiana | 18041 | 6825 | 144 |
2243215 | 2243215 | 2022-02-23 | Floyd | Indiana | 18043 | 18692 | 281 |
2243216 | 2243216 | 2022-02-23 | Fountain | Indiana | 18045 | 5336 | 97 |
2243217 | 2243217 | 2022-02-23 | Franklin | Indiana | 18047 | 4369 | 64 |
2243218 | 2243218 | 2022-02-23 | Fulton | Indiana | 18049 | 4860 | 101 |
2243219 | 2243219 | 2022-02-23 | Gibson | Indiana | 18051 | 11546 | 138 |
2243220 | 2243220 | 2022-02-23 | Grant | Indiana | 18053 | 17584 | 338 |
2243221 | 2243221 | 2022-02-23 | Greene | Indiana | 18055 | 7151 | 135 |
2243222 | 2243222 | 2022-02-23 | Hamilton | Indiana | 18057 | 81161 | 639 |
2243223 | 2243223 | 2022-02-23 | Hancock | Indiana | 18059 | 20559 | 255 |
2243224 | 2243224 | 2022-02-23 | Harrison | Indiana | 18061 | 10675 | 134 |
2243225 | 2243225 | 2022-02-23 | Hendricks | Indiana | 18063 | 40528 | 535 |
2243226 | 2243226 | 2022-02-23 | Henry | Indiana | 18065 | 12874 | 223 |
2243227 | 2243227 | 2022-02-23 | Howard | Indiana | 18067 | 25241 | 432 |
2243228 | 2243228 | 2022-02-23 | Huntington | Indiana | 18069 | 11415 | 152 |
2243229 | 2243229 | 2022-02-23 | Jackson | Indiana | 18071 | 12426 | 123 |
2243230 | 2243230 | 2022-02-23 | Jasper | Indiana | 18073 | 8946 | 143 |
2243231 | 2243231 | 2022-02-23 | Jay | Indiana | 18075 | 4824 | 76 |
2243232 | 2243232 | 2022-02-23 | Jefferson | Indiana | 18077 | 9310 | 148 |
2243233 | 2243233 | 2022-02-23 | Jennings | Indiana | 18079 | 6907 | 103 |
2243234 | 2243234 | 2022-02-23 | Johnson | Indiana | 18081 | 42112 | 594 |
2243235 | 2243235 | 2022-02-23 | Knox | Indiana | 18083 | 10657 | 140 |
2243236 | 2243236 | 2022-02-23 | Kosciusko | Indiana | 18085 | 19651 | 227 |
2243237 | 2243237 | 2022-02-23 | LaGrange | Indiana | 18087 | 5825 | 102 |
2243238 | 2243238 | 2022-02-23 | LaPorte | Indiana | 18091 | 25235 | 354 |
2243239 | 2243239 | 2022-02-23 | Lake | Indiana | 18089 | 105367 | 1766 |
2243240 | 2243240 | 2022-02-23 | Lawrence | Indiana | 18093 | 11756 | 245 |
2243241 | 2243241 | 2022-02-23 | Madison | Indiana | 18095 | 32458 | 631 |
2243242 | 2243242 | 2022-02-23 | Marion | Indiana | 18097 | 223174 | 2896 |
2243243 | 2243243 | 2022-02-23 | Marshall | Indiana | 18099 | 12269 | 190 |
2243244 | 2243244 | 2022-02-23 | Martin | Indiana | 18101 | 2153 | 25 |
2243245 | 2243245 | 2022-02-23 | Miami | Indiana | 18103 | 9199 | 153 |
2243246 | 2243246 | 2022-02-23 | Monroe | Indiana | 18105 | 27304 | 269 |
2243247 | 2243247 | 2022-02-23 | Montgomery | Indiana | 18107 | 10588 | 160 |
2243248 | 2243248 | 2022-02-23 | Morgan | Indiana | 18109 | 16341 | 272 |
2243249 | 2243249 | 2022-02-23 | Newton | Indiana | 18111 | 2533 | 68 |
2243250 | 2243250 | 2022-02-23 | Noble | Indiana | 18113 | 13007 | 154 |
2243251 | 2243251 | 2022-02-23 | Ohio | Indiana | 18115 | 1437 | 18 |
2243252 | 2243252 | 2022-02-23 | Orange | Indiana | 18117 | 5008 | 92 |
2243253 | 2243253 | 2022-02-23 | Owen | Indiana | 18119 | 5791 | 112 |
2243254 | 2243254 | 2022-02-23 | Parke | Indiana | 18121 | 3590 | 47 |
2243255 | 2243255 | 2022-02-23 | Perry | Indiana | 18123 | 4619 | 68 |
2243256 | 2243256 | 2022-02-23 | Pike | Indiana | 18125 | 3704 | 48 |
2243257 | 2243257 | 2022-02-23 | Porter | Indiana | 18127 | 37064 | 545 |
2243258 | 2243258 | 2022-02-23 | Posey | Indiana | 18129 | 6493 | 55 |
2243259 | 2243259 | 2022-02-23 | Pulaski | Indiana | 18131 | 3043 | 85 |
2243260 | 2243260 | 2022-02-23 | Putnam | Indiana | 18133 | 9242 | 123 |
2243261 | 2243261 | 2022-02-23 | Randolph | Indiana | 18135 | 5896 | 141 |
2243262 | 2243262 | 2022-02-23 | Ripley | Indiana | 18137 | 8232 | 130 |
2243263 | 2243263 | 2022-02-23 | Rush | Indiana | 18139 | 4870 | 55 |
2243264 | 2243264 | 2022-02-23 | Scott | Indiana | 18143 | 7798 | 100 |
2243265 | 2243265 | 2022-02-23 | Shelby | Indiana | 18145 | 14597 | 178 |
2243266 | 2243266 | 2022-02-23 | Spencer | Indiana | 18147 | 5184 | 58 |
2243267 | 2243267 | 2022-02-23 | St. Joseph | Indiana | 18141 | 70087 | 843 |
2243268 | 2243268 | 2022-02-23 | Starke | Indiana | 18149 | 4692 | 93 |
2243269 | 2243269 | 2022-02-23 | Steuben | Indiana | 18151 | 9585 | 118 |
2243270 | 2243270 | 2022-02-23 | Sullivan | Indiana | 18153 | 5245 | 72 |
2243271 | 2243271 | 2022-02-23 | Switzerland | Indiana | 18155 | 2293 | 17 |
2243272 | 2243272 | 2022-02-23 | Tippecanoe | Indiana | 18157 | 49474 | 374 |
2243273 | 2243273 | 2022-02-23 | Tipton | Indiana | 18159 | 3505 | 84 |
2243274 | 2243274 | 2022-02-23 | Union | Indiana | 18161 | 2038 | 21 |
2243275 | 2243275 | 2022-02-23 | Vanderburgh | Indiana | 18163 | 56878 | 599 |
2243276 | 2243276 | 2022-02-23 | Vermillion | Indiana | 18165 | 4033 | 72 |
2243277 | 2243277 | 2022-02-23 | Vigo | Indiana | 18167 | 28689 | 396 |
2243278 | 2243278 | 2022-02-23 | Wabash | Indiana | 18169 | 8659 | 149 |
2243279 | 2243279 | 2022-02-23 | Warren | Indiana | 18171 | 2054 | 25 |
2243280 | 2243280 | 2022-02-23 | Warrick | Indiana | 18173 | 20109 | 232 |
2243281 | 2243281 | 2022-02-23 | Washington | Indiana | 18175 | 5944 | 76 |
2243282 | 2243282 | 2022-02-23 | Wayne | Indiana | 18177 | 19099 | 329 |
2243283 | 2243283 | 2022-02-23 | Wells | Indiana | 18179 | 6486 | 131 |
2243284 | 2243284 | 2022-02-23 | White | Indiana | 18181 | 6759 | 91 |
2243285 | 2243285 | 2022-02-23 | Whitley | Indiana | 18183 | 9603 | 81 |
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);