ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2022-03-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 |
---|---|---|---|---|---|---|---|
2269204 | 2269204 | 2022-03-03 | Adams | Indiana | 18001 | 7316 | 112 |
2269205 | 2269205 | 2022-03-03 | Allen | Indiana | 18003 | 103374 | 1160 |
2269206 | 2269206 | 2022-03-03 | Bartholomew | Indiana | 18005 | 21256 | 247 |
2269207 | 2269207 | 2022-03-03 | Benton | Indiana | 18007 | 2463 | 21 |
2269208 | 2269208 | 2022-03-03 | Blackford | Indiana | 18009 | 3114 | 69 |
2269209 | 2269209 | 2022-03-03 | Boone | Indiana | 18011 | 15072 | 173 |
2269210 | 2269210 | 2022-03-03 | Brown | Indiana | 18013 | 2580 | 62 |
2269211 | 2269211 | 2022-03-03 | Carroll | Indiana | 18015 | 4209 | 64 |
2269212 | 2269212 | 2022-03-03 | Cass | Indiana | 18017 | 11574 | 160 |
2269213 | 2269213 | 2022-03-03 | Clark | Indiana | 18019 | 30860 | 386 |
2269214 | 2269214 | 2022-03-03 | Clay | Indiana | 18021 | 6808 | 87 |
2269215 | 2269215 | 2022-03-03 | Clinton | Indiana | 18023 | 9167 | 120 |
2269216 | 2269216 | 2022-03-03 | Crawford | Indiana | 18025 | 2528 | 36 |
2269217 | 2269217 | 2022-03-03 | Daviess | Indiana | 18027 | 7449 | 150 |
2269218 | 2269218 | 2022-03-03 | DeKalb | Indiana | 18033 | 11293 | 148 |
2269219 | 2269219 | 2022-03-03 | Dearborn | Indiana | 18029 | 13388 | 134 |
2269220 | 2269220 | 2022-03-03 | Decatur | Indiana | 18031 | 7044 | 141 |
2269221 | 2269221 | 2022-03-03 | Delaware | Indiana | 18035 | 24651 | 428 |
2269222 | 2269222 | 2022-03-03 | Dubois | Indiana | 18037 | 12814 | 163 |
2269223 | 2269223 | 2022-03-03 | Elkhart | Indiana | 18039 | 54018 | 721 |
2269224 | 2269224 | 2022-03-03 | Fayette | Indiana | 18041 | 6846 | 145 |
2269225 | 2269225 | 2022-03-03 | Floyd | Indiana | 18043 | 18796 | 285 |
2269226 | 2269226 | 2022-03-03 | Fountain | Indiana | 18045 | 5357 | 97 |
2269227 | 2269227 | 2022-03-03 | Franklin | Indiana | 18047 | 4385 | 64 |
2269228 | 2269228 | 2022-03-03 | Fulton | Indiana | 18049 | 4880 | 102 |
2269229 | 2269229 | 2022-03-03 | Gibson | Indiana | 18051 | 11596 | 141 |
2269230 | 2269230 | 2022-03-03 | Grant | Indiana | 18053 | 17625 | 342 |
2269231 | 2269231 | 2022-03-03 | Greene | Indiana | 18055 | 7173 | 137 |
2269232 | 2269232 | 2022-03-03 | Hamilton | Indiana | 18057 | 81315 | 646 |
2269233 | 2269233 | 2022-03-03 | Hancock | Indiana | 18059 | 20592 | 256 |
2269234 | 2269234 | 2022-03-03 | Harrison | Indiana | 18061 | 10733 | 136 |
2269235 | 2269235 | 2022-03-03 | Hendricks | Indiana | 18063 | 40643 | 545 |
2269236 | 2269236 | 2022-03-03 | Henry | Indiana | 18065 | 12910 | 226 |
2269237 | 2269237 | 2022-03-03 | Howard | Indiana | 18067 | 25313 | 435 |
2269238 | 2269238 | 2022-03-03 | Huntington | Indiana | 18069 | 11458 | 153 |
2269239 | 2269239 | 2022-03-03 | Jackson | Indiana | 18071 | 12471 | 125 |
2269240 | 2269240 | 2022-03-03 | Jasper | Indiana | 18073 | 8967 | 144 |
2269241 | 2269241 | 2022-03-03 | Jay | Indiana | 18075 | 4842 | 77 |
2269242 | 2269242 | 2022-03-03 | Jefferson | Indiana | 18077 | 9329 | 151 |
2269243 | 2269243 | 2022-03-03 | Jennings | Indiana | 18079 | 6928 | 103 |
2269244 | 2269244 | 2022-03-03 | Johnson | Indiana | 18081 | 42190 | 599 |
2269245 | 2269245 | 2022-03-03 | Knox | Indiana | 18083 | 10694 | 147 |
2269246 | 2269246 | 2022-03-03 | Kosciusko | Indiana | 18085 | 19697 | 232 |
2269247 | 2269247 | 2022-03-03 | LaGrange | Indiana | 18087 | 5838 | 102 |
2269248 | 2269248 | 2022-03-03 | LaPorte | Indiana | 18091 | 25284 | 357 |
2269249 | 2269249 | 2022-03-03 | Lake | Indiana | 18089 | 105586 | 1782 |
2269250 | 2269250 | 2022-03-03 | Lawrence | Indiana | 18093 | 11795 | 252 |
2269251 | 2269251 | 2022-03-03 | Madison | Indiana | 18095 | 32532 | 637 |
2269252 | 2269252 | 2022-03-03 | Marion | Indiana | 18097 | 223606 | 2923 |
2269253 | 2269253 | 2022-03-03 | Marshall | Indiana | 18099 | 12289 | 193 |
2269254 | 2269254 | 2022-03-03 | Martin | Indiana | 18101 | 2155 | 25 |
2269255 | 2269255 | 2022-03-03 | Miami | Indiana | 18103 | 9228 | 158 |
2269256 | 2269256 | 2022-03-03 | Monroe | Indiana | 18105 | 27420 | 273 |
2269257 | 2269257 | 2022-03-03 | Montgomery | Indiana | 18107 | 10612 | 161 |
2269258 | 2269258 | 2022-03-03 | Morgan | Indiana | 18109 | 16401 | 276 |
2269259 | 2269259 | 2022-03-03 | Newton | Indiana | 18111 | 2544 | 68 |
2269260 | 2269260 | 2022-03-03 | Noble | Indiana | 18113 | 13027 | 156 |
2269261 | 2269261 | 2022-03-03 | Ohio | Indiana | 18115 | 1441 | 19 |
2269262 | 2269262 | 2022-03-03 | Orange | Indiana | 18117 | 5020 | 94 |
2269263 | 2269263 | 2022-03-03 | Owen | Indiana | 18119 | 5805 | 114 |
2269264 | 2269264 | 2022-03-03 | Parke | Indiana | 18121 | 3603 | 48 |
2269265 | 2269265 | 2022-03-03 | Perry | Indiana | 18123 | 4640 | 68 |
2269266 | 2269266 | 2022-03-03 | Pike | Indiana | 18125 | 3715 | 48 |
2269267 | 2269267 | 2022-03-03 | Porter | Indiana | 18127 | 37193 | 551 |
2269268 | 2269268 | 2022-03-03 | Posey | Indiana | 18129 | 6509 | 55 |
2269269 | 2269269 | 2022-03-03 | Pulaski | Indiana | 18131 | 3050 | 85 |
2269270 | 2269270 | 2022-03-03 | Putnam | Indiana | 18133 | 9274 | 125 |
2269271 | 2269271 | 2022-03-03 | Randolph | Indiana | 18135 | 5914 | 142 |
2269272 | 2269272 | 2022-03-03 | Ripley | Indiana | 18137 | 8249 | 136 |
2269273 | 2269273 | 2022-03-03 | Rush | Indiana | 18139 | 4891 | 56 |
2269274 | 2269274 | 2022-03-03 | Scott | Indiana | 18143 | 7834 | 103 |
2269275 | 2269275 | 2022-03-03 | Shelby | Indiana | 18145 | 14635 | 180 |
2269276 | 2269276 | 2022-03-03 | Spencer | Indiana | 18147 | 5210 | 59 |
2269277 | 2269277 | 2022-03-03 | St. Joseph | Indiana | 18141 | 70255 | 850 |
2269278 | 2269278 | 2022-03-03 | Starke | Indiana | 18149 | 4705 | 94 |
2269279 | 2269279 | 2022-03-03 | Steuben | Indiana | 18151 | 9604 | 119 |
2269280 | 2269280 | 2022-03-03 | Sullivan | Indiana | 18153 | 5256 | 73 |
2269281 | 2269281 | 2022-03-03 | Switzerland | Indiana | 18155 | 2302 | 18 |
2269282 | 2269282 | 2022-03-03 | Tippecanoe | Indiana | 18157 | 49650 | 379 |
2269283 | 2269283 | 2022-03-03 | Tipton | Indiana | 18159 | 3508 | 86 |
2269284 | 2269284 | 2022-03-03 | Union | Indiana | 18161 | 2042 | 21 |
2269285 | 2269285 | 2022-03-03 | Vanderburgh | Indiana | 18163 | 57045 | 608 |
2269286 | 2269286 | 2022-03-03 | Vermillion | Indiana | 18165 | 4047 | 73 |
2269287 | 2269287 | 2022-03-03 | Vigo | Indiana | 18167 | 28764 | 403 |
2269288 | 2269288 | 2022-03-03 | Wabash | Indiana | 18169 | 8689 | 151 |
2269289 | 2269289 | 2022-03-03 | Warren | Indiana | 18171 | 2065 | 26 |
2269290 | 2269290 | 2022-03-03 | Warrick | Indiana | 18173 | 20179 | 232 |
2269291 | 2269291 | 2022-03-03 | Washington | Indiana | 18175 | 5968 | 78 |
2269292 | 2269292 | 2022-03-03 | Wayne | Indiana | 18177 | 19141 | 330 |
2269293 | 2269293 | 2022-03-03 | Wells | Indiana | 18179 | 6508 | 132 |
2269294 | 2269294 | 2022-03-03 | White | Indiana | 18181 | 6799 | 92 |
2269295 | 2269295 | 2022-03-03 | Whitley | Indiana | 18183 | 9625 | 82 |
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);