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 2022-03-19 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2321242 | 2321242 | 2022-03-19 | Adams | Indiana | 18001 | 7330 | 112 |
2321243 | 2321243 | 2022-03-19 | Allen | Indiana | 18003 | 103599 | 1172 |
2321244 | 2321244 | 2022-03-19 | Bartholomew | Indiana | 18005 | 21304 | 248 |
2321245 | 2321245 | 2022-03-19 | Benton | Indiana | 18007 | 2473 | 21 |
2321246 | 2321246 | 2022-03-19 | Blackford | Indiana | 18009 | 3121 | 69 |
2321247 | 2321247 | 2022-03-19 | Boone | Indiana | 18011 | 15152 | 179 |
2321248 | 2321248 | 2022-03-19 | Brown | Indiana | 18013 | 2583 | 62 |
2321249 | 2321249 | 2022-03-19 | Carroll | Indiana | 18015 | 4218 | 65 |
2321250 | 2321250 | 2022-03-19 | Cass | Indiana | 18017 | 11649 | 163 |
2321251 | 2321251 | 2022-03-19 | Clark | Indiana | 18019 | 31015 | 390 |
2321252 | 2321252 | 2022-03-19 | Clay | Indiana | 18021 | 6822 | 87 |
2321253 | 2321253 | 2022-03-19 | Clinton | Indiana | 18023 | 9183 | 122 |
2321254 | 2321254 | 2022-03-19 | Crawford | Indiana | 18025 | 2542 | 38 |
2321255 | 2321255 | 2022-03-19 | Daviess | Indiana | 18027 | 7463 | 151 |
2321256 | 2321256 | 2022-03-19 | DeKalb | Indiana | 18033 | 11322 | 149 |
2321257 | 2321257 | 2022-03-19 | Dearborn | Indiana | 18029 | 13420 | 137 |
2321258 | 2321258 | 2022-03-19 | Decatur | Indiana | 18031 | 7057 | 145 |
2321259 | 2321259 | 2022-03-19 | Delaware | Indiana | 18035 | 24771 | 438 |
2321260 | 2321260 | 2022-03-19 | Dubois | Indiana | 18037 | 12847 | 165 |
2321261 | 2321261 | 2022-03-19 | Elkhart | Indiana | 18039 | 54106 | 727 |
2321262 | 2321262 | 2022-03-19 | Fayette | Indiana | 18041 | 6866 | 146 |
2321263 | 2321263 | 2022-03-19 | Floyd | Indiana | 18043 | 18884 | 292 |
2321264 | 2321264 | 2022-03-19 | Fountain | Indiana | 18045 | 5382 | 101 |
2321265 | 2321265 | 2022-03-19 | Franklin | Indiana | 18047 | 4395 | 65 |
2321266 | 2321266 | 2022-03-19 | Fulton | Indiana | 18049 | 4908 | 102 |
2321267 | 2321267 | 2022-03-19 | Gibson | Indiana | 18051 | 11621 | 145 |
2321268 | 2321268 | 2022-03-19 | Grant | Indiana | 18053 | 17662 | 346 |
2321269 | 2321269 | 2022-03-19 | Greene | Indiana | 18055 | 7197 | 138 |
2321270 | 2321270 | 2022-03-19 | Hamilton | Indiana | 18057 | 81626 | 653 |
2321271 | 2321271 | 2022-03-19 | Hancock | Indiana | 18059 | 20639 | 258 |
2321272 | 2321272 | 2022-03-19 | Harrison | Indiana | 18061 | 10789 | 138 |
2321273 | 2321273 | 2022-03-19 | Hendricks | Indiana | 18063 | 40732 | 550 |
2321274 | 2321274 | 2022-03-19 | Henry | Indiana | 18065 | 12960 | 228 |
2321275 | 2321275 | 2022-03-19 | Howard | Indiana | 18067 | 25376 | 442 |
2321276 | 2321276 | 2022-03-19 | Huntington | Indiana | 18069 | 11481 | 155 |
2321277 | 2321277 | 2022-03-19 | Jackson | Indiana | 18071 | 12504 | 129 |
2321278 | 2321278 | 2022-03-19 | Jasper | Indiana | 18073 | 8994 | 147 |
2321279 | 2321279 | 2022-03-19 | Jay | Indiana | 18075 | 4850 | 78 |
2321280 | 2321280 | 2022-03-19 | Jefferson | Indiana | 18077 | 9345 | 154 |
2321281 | 2321281 | 2022-03-19 | Jennings | Indiana | 18079 | 6942 | 107 |
2321282 | 2321282 | 2022-03-19 | Johnson | Indiana | 18081 | 42281 | 606 |
2321283 | 2321283 | 2022-03-19 | Knox | Indiana | 18083 | 10729 | 152 |
2321284 | 2321284 | 2022-03-19 | Kosciusko | Indiana | 18085 | 19724 | 235 |
2321285 | 2321285 | 2022-03-19 | LaGrange | Indiana | 18087 | 5847 | 102 |
2321286 | 2321286 | 2022-03-19 | LaPorte | Indiana | 18091 | 25373 | 363 |
2321287 | 2321287 | 2022-03-19 | Lake | Indiana | 18089 | 105933 | 1808 |
2321288 | 2321288 | 2022-03-19 | Lawrence | Indiana | 18093 | 11824 | 258 |
2321289 | 2321289 | 2022-03-19 | Madison | Indiana | 18095 | 32631 | 647 |
2321290 | 2321290 | 2022-03-19 | Marion | Indiana | 18097 | 224810 | 2955 |
2321291 | 2321291 | 2022-03-19 | Marshall | Indiana | 18099 | 12315 | 195 |
2321292 | 2321292 | 2022-03-19 | Martin | Indiana | 18101 | 2163 | 25 |
2321293 | 2321293 | 2022-03-19 | Miami | Indiana | 18103 | 9252 | 158 |
2321294 | 2321294 | 2022-03-19 | Monroe | Indiana | 18105 | 27545 | 278 |
2321295 | 2321295 | 2022-03-19 | Montgomery | Indiana | 18107 | 10655 | 163 |
2321296 | 2321296 | 2022-03-19 | Morgan | Indiana | 18109 | 16443 | 281 |
2321297 | 2321297 | 2022-03-19 | Newton | Indiana | 18111 | 2558 | 68 |
2321298 | 2321298 | 2022-03-19 | Noble | Indiana | 18113 | 13051 | 156 |
2321299 | 2321299 | 2022-03-19 | Ohio | Indiana | 18115 | 1442 | 19 |
2321300 | 2321300 | 2022-03-19 | Orange | Indiana | 18117 | 5031 | 96 |
2321301 | 2321301 | 2022-03-19 | Owen | Indiana | 18119 | 5823 | 117 |
2321302 | 2321302 | 2022-03-19 | Parke | Indiana | 18121 | 3607 | 49 |
2321303 | 2321303 | 2022-03-19 | Perry | Indiana | 18123 | 4661 | 68 |
2321304 | 2321304 | 2022-03-19 | Pike | Indiana | 18125 | 3723 | 48 |
2321305 | 2321305 | 2022-03-19 | Porter | Indiana | 18127 | 37487 | 557 |
2321306 | 2321306 | 2022-03-19 | Posey | Indiana | 18129 | 6523 | 56 |
2321307 | 2321307 | 2022-03-19 | Pulaski | Indiana | 18131 | 3068 | 85 |
2321308 | 2321308 | 2022-03-19 | Putnam | Indiana | 18133 | 9309 | 126 |
2321309 | 2321309 | 2022-03-19 | Randolph | Indiana | 18135 | 5933 | 146 |
2321310 | 2321310 | 2022-03-19 | Ripley | Indiana | 18137 | 8279 | 138 |
2321311 | 2321311 | 2022-03-19 | Rush | Indiana | 18139 | 4903 | 58 |
2321312 | 2321312 | 2022-03-19 | Scott | Indiana | 18143 | 7859 | 106 |
2321313 | 2321313 | 2022-03-19 | Shelby | Indiana | 18145 | 14662 | 181 |
2321314 | 2321314 | 2022-03-19 | Spencer | Indiana | 18147 | 5215 | 60 |
2321315 | 2321315 | 2022-03-19 | St. Joseph | Indiana | 18141 | 70448 | 863 |
2321316 | 2321316 | 2022-03-19 | Starke | Indiana | 18149 | 4736 | 96 |
2321317 | 2321317 | 2022-03-19 | Steuben | Indiana | 18151 | 9619 | 120 |
2321318 | 2321318 | 2022-03-19 | Sullivan | Indiana | 18153 | 5270 | 76 |
2321319 | 2321319 | 2022-03-19 | Switzerland | Indiana | 18155 | 2307 | 20 |
2321320 | 2321320 | 2022-03-19 | Tippecanoe | Indiana | 18157 | 49795 | 391 |
2321321 | 2321321 | 2022-03-19 | Tipton | Indiana | 18159 | 3527 | 87 |
2321322 | 2321322 | 2022-03-19 | Union | Indiana | 18161 | 2046 | 21 |
2321323 | 2321323 | 2022-03-19 | Vanderburgh | Indiana | 18163 | 57183 | 621 |
2321324 | 2321324 | 2022-03-19 | Vermillion | Indiana | 18165 | 4064 | 74 |
2321325 | 2321325 | 2022-03-19 | Vigo | Indiana | 18167 | 28812 | 406 |
2321326 | 2321326 | 2022-03-19 | Wabash | Indiana | 18169 | 8711 | 154 |
2321327 | 2321327 | 2022-03-19 | Warren | Indiana | 18171 | 2077 | 30 |
2321328 | 2321328 | 2022-03-19 | Warrick | Indiana | 18173 | 20230 | 237 |
2321329 | 2321329 | 2022-03-19 | Washington | Indiana | 18175 | 5986 | 81 |
2321330 | 2321330 | 2022-03-19 | Wayne | Indiana | 18177 | 19187 | 331 |
2321331 | 2321331 | 2022-03-19 | Wells | Indiana | 18179 | 6518 | 132 |
2321332 | 2321332 | 2022-03-19 | White | Indiana | 18181 | 6836 | 93 |
2321333 | 2321333 | 2022-03-19 | Whitley | Indiana | 18183 | 9643 | 83 |
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);