ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2022-02-22" 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 |
---|---|---|---|---|---|---|---|
2239943 | 2239943 | 2022-02-22 | Adams | Indiana | 18001 | 7299 | 111 |
2239944 | 2239944 | 2022-02-22 | Allen | Indiana | 18003 | 103108 | 1146 |
2239945 | 2239945 | 2022-02-22 | Bartholomew | Indiana | 18005 | 21169 | 244 |
2239946 | 2239946 | 2022-02-22 | Benton | Indiana | 18007 | 2454 | 21 |
2239947 | 2239947 | 2022-02-22 | Blackford | Indiana | 18009 | 3088 | 68 |
2239948 | 2239948 | 2022-02-22 | Boone | Indiana | 18011 | 15022 | 172 |
2239949 | 2239949 | 2022-02-22 | Brown | Indiana | 18013 | 2574 | 62 |
2239950 | 2239950 | 2022-02-22 | Carroll | Indiana | 18015 | 4195 | 62 |
2239951 | 2239951 | 2022-02-22 | Cass | Indiana | 18017 | 11480 | 157 |
2239952 | 2239952 | 2022-02-22 | Clark | Indiana | 18019 | 30687 | 380 |
2239953 | 2239953 | 2022-02-22 | Clay | Indiana | 18021 | 6792 | 85 |
2239954 | 2239954 | 2022-02-22 | Clinton | Indiana | 18023 | 9139 | 118 |
2239955 | 2239955 | 2022-02-22 | Crawford | Indiana | 18025 | 2506 | 35 |
2239956 | 2239956 | 2022-02-22 | Daviess | Indiana | 18027 | 7422 | 145 |
2239957 | 2239957 | 2022-02-22 | DeKalb | Indiana | 18033 | 11278 | 148 |
2239958 | 2239958 | 2022-02-22 | Dearborn | Indiana | 18029 | 13339 | 130 |
2239959 | 2239959 | 2022-02-22 | Decatur | Indiana | 18031 | 7027 | 141 |
2239960 | 2239960 | 2022-02-22 | Delaware | Indiana | 18035 | 24498 | 421 |
2239961 | 2239961 | 2022-02-22 | Dubois | Indiana | 18037 | 12761 | 159 |
2239962 | 2239962 | 2022-02-22 | Elkhart | Indiana | 18039 | 53913 | 716 |
2239963 | 2239963 | 2022-02-22 | Fayette | Indiana | 18041 | 6823 | 143 |
2239964 | 2239964 | 2022-02-22 | Floyd | Indiana | 18043 | 18666 | 280 |
2239965 | 2239965 | 2022-02-22 | Fountain | Indiana | 18045 | 5336 | 97 |
2239966 | 2239966 | 2022-02-22 | Franklin | Indiana | 18047 | 4365 | 64 |
2239967 | 2239967 | 2022-02-22 | Fulton | Indiana | 18049 | 4858 | 101 |
2239968 | 2239968 | 2022-02-22 | Gibson | Indiana | 18051 | 11536 | 137 |
2239969 | 2239969 | 2022-02-22 | Grant | Indiana | 18053 | 17574 | 338 |
2239970 | 2239970 | 2022-02-22 | Greene | Indiana | 18055 | 7148 | 135 |
2239971 | 2239971 | 2022-02-22 | Hamilton | Indiana | 18057 | 81115 | 635 |
2239972 | 2239972 | 2022-02-22 | Hancock | Indiana | 18059 | 20544 | 254 |
2239973 | 2239973 | 2022-02-22 | Harrison | Indiana | 18061 | 10666 | 131 |
2239974 | 2239974 | 2022-02-22 | Hendricks | Indiana | 18063 | 40504 | 535 |
2239975 | 2239975 | 2022-02-22 | Henry | Indiana | 18065 | 12858 | 223 |
2239976 | 2239976 | 2022-02-22 | Howard | Indiana | 18067 | 25229 | 432 |
2239977 | 2239977 | 2022-02-22 | Huntington | Indiana | 18069 | 11409 | 152 |
2239978 | 2239978 | 2022-02-22 | Jackson | Indiana | 18071 | 12411 | 123 |
2239979 | 2239979 | 2022-02-22 | Jasper | Indiana | 18073 | 8943 | 143 |
2239980 | 2239980 | 2022-02-22 | Jay | Indiana | 18075 | 4821 | 76 |
2239981 | 2239981 | 2022-02-22 | Jefferson | Indiana | 18077 | 9304 | 145 |
2239982 | 2239982 | 2022-02-22 | Jennings | Indiana | 18079 | 6902 | 103 |
2239983 | 2239983 | 2022-02-22 | Johnson | Indiana | 18081 | 42096 | 594 |
2239984 | 2239984 | 2022-02-22 | Knox | Indiana | 18083 | 10650 | 140 |
2239985 | 2239985 | 2022-02-22 | Kosciusko | Indiana | 18085 | 19636 | 227 |
2239986 | 2239986 | 2022-02-22 | LaGrange | Indiana | 18087 | 5825 | 100 |
2239987 | 2239987 | 2022-02-22 | LaPorte | Indiana | 18091 | 25220 | 352 |
2239988 | 2239988 | 2022-02-22 | Lake | Indiana | 18089 | 105339 | 1759 |
2239989 | 2239989 | 2022-02-22 | Lawrence | Indiana | 18093 | 11753 | 244 |
2239990 | 2239990 | 2022-02-22 | Madison | Indiana | 18095 | 32441 | 629 |
2239991 | 2239991 | 2022-02-22 | Marion | Indiana | 18097 | 223093 | 2889 |
2239992 | 2239992 | 2022-02-22 | Marshall | Indiana | 18099 | 12268 | 190 |
2239993 | 2239993 | 2022-02-22 | Martin | Indiana | 18101 | 2152 | 25 |
2239994 | 2239994 | 2022-02-22 | Miami | Indiana | 18103 | 9197 | 153 |
2239995 | 2239995 | 2022-02-22 | Monroe | Indiana | 18105 | 27274 | 269 |
2239996 | 2239996 | 2022-02-22 | Montgomery | Indiana | 18107 | 10584 | 160 |
2239997 | 2239997 | 2022-02-22 | Morgan | Indiana | 18109 | 16338 | 271 |
2239998 | 2239998 | 2022-02-22 | Newton | Indiana | 18111 | 2530 | 68 |
2239999 | 2239999 | 2022-02-22 | Noble | Indiana | 18113 | 12998 | 154 |
2240000 | 2240000 | 2022-02-22 | Ohio | Indiana | 18115 | 1437 | 18 |
2240001 | 2240001 | 2022-02-22 | Orange | Indiana | 18117 | 5005 | 92 |
2240002 | 2240002 | 2022-02-22 | Owen | Indiana | 18119 | 5784 | 112 |
2240003 | 2240003 | 2022-02-22 | Parke | Indiana | 18121 | 3590 | 45 |
2240004 | 2240004 | 2022-02-22 | Perry | Indiana | 18123 | 4618 | 67 |
2240005 | 2240005 | 2022-02-22 | Pike | Indiana | 18125 | 3702 | 48 |
2240006 | 2240006 | 2022-02-22 | Porter | Indiana | 18127 | 37051 | 541 |
2240007 | 2240007 | 2022-02-22 | Posey | Indiana | 18129 | 6491 | 54 |
2240008 | 2240008 | 2022-02-22 | Pulaski | Indiana | 18131 | 3041 | 85 |
2240009 | 2240009 | 2022-02-22 | Putnam | Indiana | 18133 | 9233 | 123 |
2240010 | 2240010 | 2022-02-22 | Randolph | Indiana | 18135 | 5891 | 141 |
2240011 | 2240011 | 2022-02-22 | Ripley | Indiana | 18137 | 8228 | 130 |
2240012 | 2240012 | 2022-02-22 | Rush | Indiana | 18139 | 4864 | 55 |
2240013 | 2240013 | 2022-02-22 | Scott | Indiana | 18143 | 7784 | 99 |
2240014 | 2240014 | 2022-02-22 | Shelby | Indiana | 18145 | 14591 | 178 |
2240015 | 2240015 | 2022-02-22 | Spencer | Indiana | 18147 | 5178 | 58 |
2240016 | 2240016 | 2022-02-22 | St. Joseph | Indiana | 18141 | 70057 | 841 |
2240017 | 2240017 | 2022-02-22 | Starke | Indiana | 18149 | 4690 | 93 |
2240018 | 2240018 | 2022-02-22 | Steuben | Indiana | 18151 | 9581 | 118 |
2240019 | 2240019 | 2022-02-22 | Sullivan | Indiana | 18153 | 5242 | 72 |
2240020 | 2240020 | 2022-02-22 | Switzerland | Indiana | 18155 | 2292 | 17 |
2240021 | 2240021 | 2022-02-22 | Tippecanoe | Indiana | 18157 | 49441 | 372 |
2240022 | 2240022 | 2022-02-22 | Tipton | Indiana | 18159 | 3504 | 84 |
2240023 | 2240023 | 2022-02-22 | Union | Indiana | 18161 | 2038 | 21 |
2240024 | 2240024 | 2022-02-22 | Vanderburgh | Indiana | 18163 | 56834 | 597 |
2240025 | 2240025 | 2022-02-22 | Vermillion | Indiana | 18165 | 4032 | 71 |
2240026 | 2240026 | 2022-02-22 | Vigo | Indiana | 18167 | 28670 | 394 |
2240027 | 2240027 | 2022-02-22 | Wabash | Indiana | 18169 | 8653 | 149 |
2240028 | 2240028 | 2022-02-22 | Warren | Indiana | 18171 | 2051 | 25 |
2240029 | 2240029 | 2022-02-22 | Warrick | Indiana | 18173 | 20095 | 231 |
2240030 | 2240030 | 2022-02-22 | Washington | Indiana | 18175 | 5941 | 76 |
2240031 | 2240031 | 2022-02-22 | Wayne | Indiana | 18177 | 19083 | 327 |
2240032 | 2240032 | 2022-02-22 | Wells | Indiana | 18179 | 6485 | 131 |
2240033 | 2240033 | 2022-02-22 | White | Indiana | 18181 | 6752 | 91 |
2240034 | 2240034 | 2022-02-22 | Whitley | Indiana | 18183 | 9599 | 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);