ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where date = "2022-04-20" 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 |
---|---|---|---|---|---|---|---|
2425377 | 2425377 | 2022-04-20 | Adams | Indiana | 18001 | 7265 | 112 |
2425378 | 2425378 | 2022-04-20 | Allen | Indiana | 18003 | 103936 | 1184 |
2425379 | 2425379 | 2022-04-20 | Bartholomew | Indiana | 18005 | 21349 | 249 |
2425380 | 2425380 | 2022-04-20 | Benton | Indiana | 18007 | 2478 | 21 |
2425381 | 2425381 | 2022-04-20 | Blackford | Indiana | 18009 | 3109 | 69 |
2425382 | 2425382 | 2022-04-20 | Boone | Indiana | 18011 | 15255 | 183 |
2425383 | 2425383 | 2022-04-20 | Brown | Indiana | 18013 | 2588 | 62 |
2425384 | 2425384 | 2022-04-20 | Carroll | Indiana | 18015 | 4227 | 68 |
2425385 | 2425385 | 2022-04-20 | Cass | Indiana | 18017 | 11672 | 163 |
2425386 | 2425386 | 2022-04-20 | Clark | Indiana | 18019 | 31139 | 396 |
2425387 | 2425387 | 2022-04-20 | Clay | Indiana | 18021 | 6825 | 88 |
2425388 | 2425388 | 2022-04-20 | Clinton | Indiana | 18023 | 9199 | 126 |
2425389 | 2425389 | 2022-04-20 | Crawford | Indiana | 18025 | 2551 | 40 |
2425390 | 2425390 | 2022-04-20 | Daviess | Indiana | 18027 | 7470 | 153 |
2425391 | 2425391 | 2022-04-20 | DeKalb | Indiana | 18033 | 11359 | 149 |
2425392 | 2425392 | 2022-04-20 | Dearborn | Indiana | 18029 | 13450 | 140 |
2425393 | 2425393 | 2022-04-20 | Decatur | Indiana | 18031 | 6998 | 145 |
2425394 | 2425394 | 2022-04-20 | Delaware | Indiana | 18035 | 24857 | 443 |
2425395 | 2425395 | 2022-04-20 | Dubois | Indiana | 18037 | 12860 | 165 |
2425396 | 2425396 | 2022-04-20 | Elkhart | Indiana | 18039 | 54112 | 730 |
2425397 | 2425397 | 2022-04-20 | Fayette | Indiana | 18041 | 6739 | 146 |
2425398 | 2425398 | 2022-04-20 | Floyd | Indiana | 18043 | 18965 | 300 |
2425399 | 2425399 | 2022-04-20 | Fountain | Indiana | 18045 | 5430 | 102 |
2425400 | 2425400 | 2022-04-20 | Franklin | Indiana | 18047 | 4373 | 65 |
2425401 | 2425401 | 2022-04-20 | Fulton | Indiana | 18049 | 4922 | 103 |
2425402 | 2425402 | 2022-04-20 | Gibson | Indiana | 18051 | 11651 | 145 |
2425403 | 2425403 | 2022-04-20 | Grant | Indiana | 18053 | 17317 | 350 |
2425404 | 2425404 | 2022-04-20 | Greene | Indiana | 18055 | 7208 | 139 |
2425405 | 2425405 | 2022-04-20 | Hamilton | Indiana | 18057 | 82039 | 661 |
2425406 | 2425406 | 2022-04-20 | Hancock | Indiana | 18059 | 20690 | 258 |
2425407 | 2425407 | 2022-04-20 | Harrison | Indiana | 18061 | 10819 | 138 |
2425408 | 2425408 | 2022-04-20 | Hendricks | Indiana | 18063 | 40759 | 554 |
2425409 | 2425409 | 2022-04-20 | Henry | Indiana | 18065 | 12986 | 230 |
2425410 | 2425410 | 2022-04-20 | Howard | Indiana | 18067 | 25416 | 448 |
2425411 | 2425411 | 2022-04-20 | Huntington | Indiana | 18069 | 11503 | 157 |
2425412 | 2425412 | 2022-04-20 | Jackson | Indiana | 18071 | 12519 | 130 |
2425413 | 2425413 | 2022-04-20 | Jasper | Indiana | 18073 | 9025 | 148 |
2425414 | 2425414 | 2022-04-20 | Jay | Indiana | 18075 | 4846 | 78 |
2425415 | 2425415 | 2022-04-20 | Jefferson | Indiana | 18077 | 9344 | 157 |
2425416 | 2425416 | 2022-04-20 | Jennings | Indiana | 18079 | 6936 | 108 |
2425417 | 2425417 | 2022-04-20 | Johnson | Indiana | 18081 | 42306 | 613 |
2425418 | 2425418 | 2022-04-20 | Knox | Indiana | 18083 | 10748 | 153 |
2425419 | 2425419 | 2022-04-20 | Kosciusko | Indiana | 18085 | 19752 | 237 |
2425420 | 2425420 | 2022-04-20 | LaGrange | Indiana | 18087 | 5845 | 102 |
2425421 | 2425421 | 2022-04-20 | LaPorte | Indiana | 18091 | 25499 | 368 |
2425422 | 2425422 | 2022-04-20 | Lake | Indiana | 18089 | 106539 | 1818 |
2425423 | 2425423 | 2022-04-20 | Lawrence | Indiana | 18093 | 11877 | 259 |
2425424 | 2425424 | 2022-04-20 | Madison | Indiana | 18095 | 32707 | 649 |
2425425 | 2425425 | 2022-04-20 | Marion | Indiana | 18097 | 225269 | 2991 |
2425426 | 2425426 | 2022-04-20 | Marshall | Indiana | 18099 | 12355 | 197 |
2425427 | 2425427 | 2022-04-20 | Martin | Indiana | 18101 | 2165 | 25 |
2425428 | 2425428 | 2022-04-20 | Miami | Indiana | 18103 | 9259 | 159 |
2425429 | 2425429 | 2022-04-20 | Monroe | Indiana | 18105 | 27812 | 279 |
2425430 | 2425430 | 2022-04-20 | Montgomery | Indiana | 18107 | 10669 | 164 |
2425431 | 2425431 | 2022-04-20 | Morgan | Indiana | 18109 | 16460 | 286 |
2425432 | 2425432 | 2022-04-20 | Newton | Indiana | 18111 | 2567 | 68 |
2425433 | 2425433 | 2022-04-20 | Noble | Indiana | 18113 | 13075 | 157 |
2425434 | 2425434 | 2022-04-20 | Ohio | Indiana | 18115 | 1444 | 19 |
2425435 | 2425435 | 2022-04-20 | Orange | Indiana | 18117 | 5034 | 96 |
2425436 | 2425436 | 2022-04-20 | Owen | Indiana | 18119 | 5845 | 121 |
2425437 | 2425437 | 2022-04-20 | Parke | Indiana | 18121 | 3594 | 46 |
2425438 | 2425438 | 2022-04-20 | Perry | Indiana | 18123 | 4651 | 69 |
2425439 | 2425439 | 2022-04-20 | Pike | Indiana | 18125 | 3726 | 49 |
2425440 | 2425440 | 2022-04-20 | Porter | Indiana | 18127 | 37807 | 561 |
2425441 | 2425441 | 2022-04-20 | Posey | Indiana | 18129 | 6540 | 58 |
2425442 | 2425442 | 2022-04-20 | Pulaski | Indiana | 18131 | 3074 | 86 |
2425443 | 2425443 | 2022-04-20 | Putnam | Indiana | 18133 | 9328 | 129 |
2425444 | 2425444 | 2022-04-20 | Randolph | Indiana | 18135 | 5901 | 148 |
2425445 | 2425445 | 2022-04-20 | Ripley | Indiana | 18137 | 8297 | 138 |
2425446 | 2425446 | 2022-04-20 | Rush | Indiana | 18139 | 4842 | 58 |
2425447 | 2425447 | 2022-04-20 | Scott | Indiana | 18143 | 7864 | 106 |
2425448 | 2425448 | 2022-04-20 | Shelby | Indiana | 18145 | 13603 | 182 |
2425449 | 2425449 | 2022-04-20 | Spencer | Indiana | 18147 | 5222 | 61 |
2425450 | 2425450 | 2022-04-20 | St. Joseph | Indiana | 18141 | 70806 | 871 |
2425451 | 2425451 | 2022-04-20 | Starke | Indiana | 18149 | 4754 | 98 |
2425452 | 2425452 | 2022-04-20 | Steuben | Indiana | 18151 | 9619 | 121 |
2425453 | 2425453 | 2022-04-20 | Sullivan | Indiana | 18153 | 5274 | 76 |
2425454 | 2425454 | 2022-04-20 | Switzerland | Indiana | 18155 | 2311 | 20 |
2425455 | 2425455 | 2022-04-20 | Tippecanoe | Indiana | 18157 | 50317 | 394 |
2425456 | 2425456 | 2022-04-20 | Tipton | Indiana | 18159 | 3525 | 87 |
2425457 | 2425457 | 2022-04-20 | Union | Indiana | 18161 | 2020 | 21 |
2425458 | 2425458 | 2022-04-20 | Unknown | Indiana | 0 | 7 | |
2425459 | 2425459 | 2022-04-20 | Vanderburgh | Indiana | 18163 | 57324 | 631 |
2425460 | 2425460 | 2022-04-20 | Vermillion | Indiana | 18165 | 4076 | 75 |
2425461 | 2425461 | 2022-04-20 | Vigo | Indiana | 18167 | 28869 | 413 |
2425462 | 2425462 | 2022-04-20 | Wabash | Indiana | 18169 | 8718 | 156 |
2425463 | 2425463 | 2022-04-20 | Warren | Indiana | 18171 | 2093 | 30 |
2425464 | 2425464 | 2022-04-20 | Warrick | Indiana | 18173 | 20285 | 238 |
2425465 | 2425465 | 2022-04-20 | Washington | Indiana | 18175 | 5995 | 83 |
2425466 | 2425466 | 2022-04-20 | Wayne | Indiana | 18177 | 18840 | 335 |
2425467 | 2425467 | 2022-04-20 | Wells | Indiana | 18179 | 6500 | 132 |
2425468 | 2425468 | 2022-04-20 | White | Indiana | 18181 | 6880 | 96 |
2425469 | 2425469 | 2022-04-20 | Whitley | Indiana | 18183 | 9668 | 84 |
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);