ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where date = "2022-04-26" 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 |
---|---|---|---|---|---|---|---|
2444913 | 2444913 | 2022-04-26 | Adams | Indiana | 18001 | 7268 | 112 |
2444914 | 2444914 | 2022-04-26 | Allen | Indiana | 18003 | 104042 | 1185 |
2444915 | 2444915 | 2022-04-26 | Bartholomew | Indiana | 18005 | 21378 | 249 |
2444916 | 2444916 | 2022-04-26 | Benton | Indiana | 18007 | 2481 | 21 |
2444917 | 2444917 | 2022-04-26 | Blackford | Indiana | 18009 | 3109 | 69 |
2444918 | 2444918 | 2022-04-26 | Boone | Indiana | 18011 | 15299 | 184 |
2444919 | 2444919 | 2022-04-26 | Brown | Indiana | 18013 | 2590 | 62 |
2444920 | 2444920 | 2022-04-26 | Carroll | Indiana | 18015 | 4238 | 68 |
2444921 | 2444921 | 2022-04-26 | Cass | Indiana | 18017 | 11677 | 163 |
2444922 | 2444922 | 2022-04-26 | Clark | Indiana | 18019 | 31204 | 396 |
2444923 | 2444923 | 2022-04-26 | Clay | Indiana | 18021 | 6834 | 88 |
2444924 | 2444924 | 2022-04-26 | Clinton | Indiana | 18023 | 9212 | 126 |
2444925 | 2444925 | 2022-04-26 | Crawford | Indiana | 18025 | 2552 | 40 |
2444926 | 2444926 | 2022-04-26 | Daviess | Indiana | 18027 | 7476 | 153 |
2444927 | 2444927 | 2022-04-26 | DeKalb | Indiana | 18033 | 11366 | 149 |
2444928 | 2444928 | 2022-04-26 | Dearborn | Indiana | 18029 | 13472 | 140 |
2444929 | 2444929 | 2022-04-26 | Decatur | Indiana | 18031 | 7005 | 145 |
2444930 | 2444930 | 2022-04-26 | Delaware | Indiana | 18035 | 24885 | 443 |
2444931 | 2444931 | 2022-04-26 | Dubois | Indiana | 18037 | 12871 | 165 |
2444932 | 2444932 | 2022-04-26 | Elkhart | Indiana | 18039 | 54156 | 731 |
2444933 | 2444933 | 2022-04-26 | Fayette | Indiana | 18041 | 6744 | 146 |
2444934 | 2444934 | 2022-04-26 | Floyd | Indiana | 18043 | 19006 | 300 |
2444935 | 2444935 | 2022-04-26 | Fountain | Indiana | 18045 | 5432 | 102 |
2444936 | 2444936 | 2022-04-26 | Franklin | Indiana | 18047 | 4374 | 65 |
2444937 | 2444937 | 2022-04-26 | Fulton | Indiana | 18049 | 4927 | 103 |
2444938 | 2444938 | 2022-04-26 | Gibson | Indiana | 18051 | 11656 | 146 |
2444939 | 2444939 | 2022-04-26 | Grant | Indiana | 18053 | 17334 | 350 |
2444940 | 2444940 | 2022-04-26 | Greene | Indiana | 18055 | 7220 | 139 |
2444941 | 2444941 | 2022-04-26 | Hamilton | Indiana | 18057 | 82271 | 661 |
2444942 | 2444942 | 2022-04-26 | Hancock | Indiana | 18059 | 20706 | 258 |
2444943 | 2444943 | 2022-04-26 | Harrison | Indiana | 18061 | 10831 | 138 |
2444944 | 2444944 | 2022-04-26 | Hendricks | Indiana | 18063 | 40808 | 554 |
2444945 | 2444945 | 2022-04-26 | Henry | Indiana | 18065 | 12992 | 231 |
2444946 | 2444946 | 2022-04-26 | Howard | Indiana | 18067 | 25436 | 448 |
2444947 | 2444947 | 2022-04-26 | Huntington | Indiana | 18069 | 11510 | 157 |
2444948 | 2444948 | 2022-04-26 | Jackson | Indiana | 18071 | 12534 | 130 |
2444949 | 2444949 | 2022-04-26 | Jasper | Indiana | 18073 | 9057 | 148 |
2444950 | 2444950 | 2022-04-26 | Jay | Indiana | 18075 | 4853 | 78 |
2444951 | 2444951 | 2022-04-26 | Jefferson | Indiana | 18077 | 9347 | 157 |
2444952 | 2444952 | 2022-04-26 | Jennings | Indiana | 18079 | 6944 | 108 |
2444953 | 2444953 | 2022-04-26 | Johnson | Indiana | 18081 | 42472 | 613 |
2444954 | 2444954 | 2022-04-26 | Knox | Indiana | 18083 | 10755 | 153 |
2444955 | 2444955 | 2022-04-26 | Kosciusko | Indiana | 18085 | 19762 | 237 |
2444956 | 2444956 | 2022-04-26 | LaGrange | Indiana | 18087 | 5846 | 102 |
2444957 | 2444957 | 2022-04-26 | LaPorte | Indiana | 18091 | 25580 | 368 |
2444958 | 2444958 | 2022-04-26 | Lake | Indiana | 18089 | 106872 | 1820 |
2444959 | 2444959 | 2022-04-26 | Lawrence | Indiana | 18093 | 11910 | 259 |
2444960 | 2444960 | 2022-04-26 | Madison | Indiana | 18095 | 32734 | 651 |
2444961 | 2444961 | 2022-04-26 | Marion | Indiana | 18097 | 225832 | 2991 |
2444962 | 2444962 | 2022-04-26 | Marshall | Indiana | 18099 | 12381 | 197 |
2444963 | 2444963 | 2022-04-26 | Martin | Indiana | 18101 | 2165 | 25 |
2444964 | 2444964 | 2022-04-26 | Miami | Indiana | 18103 | 9263 | 159 |
2444965 | 2444965 | 2022-04-26 | Monroe | Indiana | 18105 | 28133 | 280 |
2444966 | 2444966 | 2022-04-26 | Montgomery | Indiana | 18107 | 10678 | 164 |
2444967 | 2444967 | 2022-04-26 | Morgan | Indiana | 18109 | 16486 | 286 |
2444968 | 2444968 | 2022-04-26 | Newton | Indiana | 18111 | 2572 | 68 |
2444969 | 2444969 | 2022-04-26 | Noble | Indiana | 18113 | 13081 | 157 |
2444970 | 2444970 | 2022-04-26 | Ohio | Indiana | 18115 | 1445 | 19 |
2444971 | 2444971 | 2022-04-26 | Orange | Indiana | 18117 | 5038 | 96 |
2444972 | 2444972 | 2022-04-26 | Owen | Indiana | 18119 | 5858 | 121 |
2444973 | 2444973 | 2022-04-26 | Parke | Indiana | 18121 | 3595 | 46 |
2444974 | 2444974 | 2022-04-26 | Perry | Indiana | 18123 | 4656 | 69 |
2444975 | 2444975 | 2022-04-26 | Pike | Indiana | 18125 | 3730 | 49 |
2444976 | 2444976 | 2022-04-26 | Porter | Indiana | 18127 | 37946 | 562 |
2444977 | 2444977 | 2022-04-26 | Posey | Indiana | 18129 | 6545 | 58 |
2444978 | 2444978 | 2022-04-26 | Pulaski | Indiana | 18131 | 3076 | 86 |
2444979 | 2444979 | 2022-04-26 | Putnam | Indiana | 18133 | 9346 | 129 |
2444980 | 2444980 | 2022-04-26 | Randolph | Indiana | 18135 | 5904 | 148 |
2444981 | 2444981 | 2022-04-26 | Ripley | Indiana | 18137 | 8304 | 138 |
2444982 | 2444982 | 2022-04-26 | Rush | Indiana | 18139 | 4844 | 58 |
2444983 | 2444983 | 2022-04-26 | Scott | Indiana | 18143 | 7867 | 106 |
2444984 | 2444984 | 2022-04-26 | Shelby | Indiana | 18145 | 13607 | 182 |
2444985 | 2444985 | 2022-04-26 | Spencer | Indiana | 18147 | 5227 | 61 |
2444986 | 2444986 | 2022-04-26 | St. Joseph | Indiana | 18141 | 71010 | 871 |
2444987 | 2444987 | 2022-04-26 | Starke | Indiana | 18149 | 4758 | 98 |
2444988 | 2444988 | 2022-04-26 | Steuben | Indiana | 18151 | 9620 | 121 |
2444989 | 2444989 | 2022-04-26 | Sullivan | Indiana | 18153 | 5281 | 76 |
2444990 | 2444990 | 2022-04-26 | Switzerland | Indiana | 18155 | 2311 | 20 |
2444991 | 2444991 | 2022-04-26 | Tippecanoe | Indiana | 18157 | 50678 | 394 |
2444992 | 2444992 | 2022-04-26 | Tipton | Indiana | 18159 | 3528 | 87 |
2444993 | 2444993 | 2022-04-26 | Union | Indiana | 18161 | 2020 | 21 |
2444994 | 2444994 | 2022-04-26 | Unknown | Indiana | 0 | 20 | |
2444995 | 2444995 | 2022-04-26 | Vanderburgh | Indiana | 18163 | 57401 | 633 |
2444996 | 2444996 | 2022-04-26 | Vermillion | Indiana | 18165 | 4077 | 75 |
2444997 | 2444997 | 2022-04-26 | Vigo | Indiana | 18167 | 28887 | 413 |
2444998 | 2444998 | 2022-04-26 | Wabash | Indiana | 18169 | 8724 | 156 |
2444999 | 2444999 | 2022-04-26 | Warren | Indiana | 18171 | 2096 | 30 |
2445000 | 2445000 | 2022-04-26 | Warrick | Indiana | 18173 | 20301 | 239 |
2445001 | 2445001 | 2022-04-26 | Washington | Indiana | 18175 | 5995 | 84 |
2445002 | 2445002 | 2022-04-26 | Wayne | Indiana | 18177 | 18846 | 336 |
2445003 | 2445003 | 2022-04-26 | Wells | Indiana | 18179 | 6501 | 132 |
2445004 | 2445004 | 2022-04-26 | White | Indiana | 18181 | 6896 | 96 |
2445005 | 2445005 | 2022-04-26 | Whitley | Indiana | 18183 | 9676 | 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);