ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2022-05-08 and state = "Indiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2484048 | 2484048 | 2022-05-08 | Ohio | Indiana | 18115 | 1451 | 19 |
2484072 | 2484072 | 2022-05-08 | Unknown | Indiana | 1691 | 44 | |
2484071 | 2484071 | 2022-05-08 | Union | Indiana | 18161 | 2022 | 21 |
2484077 | 2484077 | 2022-05-08 | Warren | Indiana | 18171 | 2107 | 30 |
2484041 | 2484041 | 2022-05-08 | Martin | Indiana | 18101 | 2169 | 25 |
2484068 | 2484068 | 2022-05-08 | Switzerland | Indiana | 18155 | 2315 | 20 |
2483994 | 2483994 | 2022-05-08 | Benton | Indiana | 18007 | 2491 | 21 |
2484003 | 2484003 | 2022-05-08 | Crawford | Indiana | 18025 | 2558 | 40 |
2484046 | 2484046 | 2022-05-08 | Newton | Indiana | 18111 | 2581 | 68 |
2483997 | 2483997 | 2022-05-08 | Brown | Indiana | 18013 | 2593 | 62 |
2484056 | 2484056 | 2022-05-08 | Pulaski | Indiana | 18131 | 3081 | 86 |
2483995 | 2483995 | 2022-05-08 | Blackford | Indiana | 18009 | 3115 | 69 |
2484070 | 2484070 | 2022-05-08 | Tipton | Indiana | 18159 | 3534 | 87 |
2484051 | 2484051 | 2022-05-08 | Parke | Indiana | 18121 | 3600 | 46 |
2484053 | 2484053 | 2022-05-08 | Pike | Indiana | 18125 | 3743 | 49 |
2484074 | 2484074 | 2022-05-08 | Vermillion | Indiana | 18165 | 4095 | 75 |
2483998 | 2483998 | 2022-05-08 | Carroll | Indiana | 18015 | 4258 | 68 |
2484014 | 2484014 | 2022-05-08 | Franklin | Indiana | 18047 | 4380 | 65 |
2484052 | 2484052 | 2022-05-08 | Perry | Indiana | 18123 | 4659 | 69 |
2484065 | 2484065 | 2022-05-08 | Starke | Indiana | 18149 | 4765 | 99 |
2484060 | 2484060 | 2022-05-08 | Rush | Indiana | 18139 | 4849 | 58 |
2484028 | 2484028 | 2022-05-08 | Jay | Indiana | 18075 | 4856 | 78 |
2484015 | 2484015 | 2022-05-08 | Fulton | Indiana | 18049 | 4929 | 103 |
2484049 | 2484049 | 2022-05-08 | Orange | Indiana | 18117 | 5049 | 96 |
2484063 | 2484063 | 2022-05-08 | Spencer | Indiana | 18147 | 5240 | 61 |
2484067 | 2484067 | 2022-05-08 | Sullivan | Indiana | 18153 | 5288 | 76 |
2484013 | 2484013 | 2022-05-08 | Fountain | Indiana | 18045 | 5462 | 103 |
2484034 | 2484034 | 2022-05-08 | LaGrange | Indiana | 18087 | 5860 | 102 |
2484050 | 2484050 | 2022-05-08 | Owen | Indiana | 18119 | 5877 | 121 |
2484058 | 2484058 | 2022-05-08 | Randolph | Indiana | 18135 | 5912 | 148 |
2484079 | 2484079 | 2022-05-08 | Washington | Indiana | 18175 | 6004 | 85 |
2484081 | 2484081 | 2022-05-08 | Wells | Indiana | 18179 | 6507 | 132 |
2484055 | 2484055 | 2022-05-08 | Posey | Indiana | 18129 | 6559 | 58 |
2484011 | 2484011 | 2022-05-08 | Fayette | Indiana | 18041 | 6745 | 146 |
2484001 | 2484001 | 2022-05-08 | Clay | Indiana | 18021 | 6840 | 88 |
2484082 | 2484082 | 2022-05-08 | White | Indiana | 18181 | 6917 | 96 |
2484030 | 2484030 | 2022-05-08 | Jennings | Indiana | 18079 | 6974 | 108 |
2484007 | 2484007 | 2022-05-08 | Decatur | Indiana | 18031 | 7010 | 145 |
2484018 | 2484018 | 2022-05-08 | Greene | Indiana | 18055 | 7236 | 139 |
2483991 | 2483991 | 2022-05-08 | Adams | Indiana | 18001 | 7276 | 112 |
2484004 | 2484004 | 2022-05-08 | Daviess | Indiana | 18027 | 7489 | 154 |
2484061 | 2484061 | 2022-05-08 | Scott | Indiana | 18143 | 7885 | 106 |
2484059 | 2484059 | 2022-05-08 | Ripley | Indiana | 18137 | 8329 | 138 |
2484076 | 2484076 | 2022-05-08 | Wabash | Indiana | 18169 | 8736 | 156 |
2484027 | 2484027 | 2022-05-08 | Jasper | Indiana | 18073 | 9104 | 149 |
2484002 | 2484002 | 2022-05-08 | Clinton | Indiana | 18023 | 9227 | 126 |
2484042 | 2484042 | 2022-05-08 | Miami | Indiana | 18103 | 9280 | 159 |
2484029 | 2484029 | 2022-05-08 | Jefferson | Indiana | 18077 | 9357 | 159 |
2484057 | 2484057 | 2022-05-08 | Putnam | Indiana | 18133 | 9381 | 129 |
2484066 | 2484066 | 2022-05-08 | Steuben | Indiana | 18151 | 9642 | 121 |
2484083 | 2484083 | 2022-05-08 | Whitley | Indiana | 18183 | 9691 | 84 |
2484044 | 2484044 | 2022-05-08 | Montgomery | Indiana | 18107 | 10706 | 164 |
2484032 | 2484032 | 2022-05-08 | Knox | Indiana | 18083 | 10770 | 153 |
2484021 | 2484021 | 2022-05-08 | Harrison | Indiana | 18061 | 10851 | 138 |
2484005 | 2484005 | 2022-05-08 | DeKalb | Indiana | 18033 | 11382 | 152 |
2484025 | 2484025 | 2022-05-08 | Huntington | Indiana | 18069 | 11542 | 157 |
2483999 | 2483999 | 2022-05-08 | Cass | Indiana | 18017 | 11692 | 163 |
2484016 | 2484016 | 2022-05-08 | Gibson | Indiana | 18051 | 11695 | 145 |
2484037 | 2484037 | 2022-05-08 | Lawrence | Indiana | 18093 | 11950 | 260 |
2484040 | 2484040 | 2022-05-08 | Marshall | Indiana | 18099 | 12400 | 197 |
2484026 | 2484026 | 2022-05-08 | Jackson | Indiana | 18071 | 12548 | 130 |
2484009 | 2484009 | 2022-05-08 | Dubois | Indiana | 18037 | 12881 | 165 |
2484023 | 2484023 | 2022-05-08 | Henry | Indiana | 18065 | 13020 | 231 |
2484047 | 2484047 | 2022-05-08 | Noble | Indiana | 18113 | 13100 | 157 |
2484006 | 2484006 | 2022-05-08 | Dearborn | Indiana | 18029 | 13509 | 140 |
2484062 | 2484062 | 2022-05-08 | Shelby | Indiana | 18145 | 13622 | 182 |
2483996 | 2483996 | 2022-05-08 | Boone | Indiana | 18011 | 15357 | 184 |
2484045 | 2484045 | 2022-05-08 | Morgan | Indiana | 18109 | 16529 | 287 |
2484017 | 2484017 | 2022-05-08 | Grant | Indiana | 18053 | 17352 | 352 |
2484080 | 2484080 | 2022-05-08 | Wayne | Indiana | 18177 | 18864 | 337 |
2484012 | 2484012 | 2022-05-08 | Floyd | Indiana | 18043 | 19087 | 301 |
2484033 | 2484033 | 2022-05-08 | Kosciusko | Indiana | 18085 | 19797 | 237 |
2484078 | 2484078 | 2022-05-08 | Warrick | Indiana | 18173 | 20343 | 239 |
2484020 | 2484020 | 2022-05-08 | Hancock | Indiana | 18059 | 20778 | 258 |
2483993 | 2483993 | 2022-05-08 | Bartholomew | Indiana | 18005 | 21442 | 249 |
2484008 | 2484008 | 2022-05-08 | Delaware | Indiana | 18035 | 24990 | 443 |
2484024 | 2484024 | 2022-05-08 | Howard | Indiana | 18067 | 25481 | 449 |
2484035 | 2484035 | 2022-05-08 | LaPorte | Indiana | 18091 | 25721 | 368 |
2484043 | 2484043 | 2022-05-08 | Monroe | Indiana | 18105 | 28457 | 280 |
2484075 | 2484075 | 2022-05-08 | Vigo | Indiana | 18167 | 28961 | 413 |
2484000 | 2484000 | 2022-05-08 | Clark | Indiana | 18019 | 31369 | 396 |
2484038 | 2484038 | 2022-05-08 | Madison | Indiana | 18095 | 32790 | 652 |
2484054 | 2484054 | 2022-05-08 | Porter | Indiana | 18127 | 38223 | 562 |
2484022 | 2484022 | 2022-05-08 | Hendricks | Indiana | 18063 | 40913 | 555 |
2484031 | 2484031 | 2022-05-08 | Johnson | Indiana | 18081 | 42622 | 614 |
2484069 | 2484069 | 2022-05-08 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2484010 | 2484010 | 2022-05-08 | Elkhart | Indiana | 18039 | 54248 | 733 |
2484073 | 2484073 | 2022-05-08 | Vanderburgh | Indiana | 18163 | 57582 | 635 |
2484064 | 2484064 | 2022-05-08 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2484019 | 2484019 | 2022-05-08 | Hamilton | Indiana | 18057 | 82726 | 661 |
2483992 | 2483992 | 2022-05-08 | Allen | Indiana | 18003 | 104305 | 1186 |
2484036 | 2484036 | 2022-05-08 | Lake | Indiana | 18089 | 107616 | 1826 |
2484039 | 2484039 | 2022-05-08 | Marion | Indiana | 18097 | 226560 | 2995 |
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);