ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-05-17" 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 |
---|---|---|---|---|---|---|---|
1326944 | 1326944 | 2021-05-17 | Adams | Indiana | 18001 | 3492 | 56 |
1326945 | 1326945 | 2021-05-17 | Allen | Indiana | 18003 | 41001 | 701 |
1326946 | 1326946 | 2021-05-17 | Bartholomew | Indiana | 18005 | 8119 | 161 |
1326947 | 1326947 | 2021-05-17 | Benton | Indiana | 18007 | 990 | 14 |
1326948 | 1326948 | 2021-05-17 | Blackford | Indiana | 18009 | 1363 | 32 |
1326949 | 1326949 | 2021-05-17 | Boone | Indiana | 18011 | 6764 | 105 |
1326950 | 1326950 | 2021-05-17 | Brown | Indiana | 18013 | 1026 | 41 |
1326951 | 1326951 | 2021-05-17 | Carroll | Indiana | 18015 | 1906 | 22 |
1326952 | 1326952 | 2021-05-17 | Cass | Indiana | 18017 | 5881 | 107 |
1326953 | 1326953 | 2021-05-17 | Clark | Indiana | 18019 | 13057 | 201 |
1326954 | 1326954 | 2021-05-17 | Clay | Indiana | 18021 | 2613 | 47 |
1326955 | 1326955 | 2021-05-17 | Clinton | Indiana | 18023 | 4289 | 58 |
1326956 | 1326956 | 2021-05-17 | Crawford | Indiana | 18025 | 1015 | 16 |
1326957 | 1326957 | 2021-05-17 | Daviess | Indiana | 18027 | 2985 | 101 |
1326958 | 1326958 | 2021-05-17 | DeKalb | Indiana | 18033 | 4309 | 88 |
1326959 | 1326959 | 2021-05-17 | Dearborn | Indiana | 18029 | 5840 | 81 |
1326960 | 1326960 | 2021-05-17 | Decatur | Indiana | 18031 | 2915 | 96 |
1326961 | 1326961 | 2021-05-17 | Delaware | Indiana | 18035 | 10770 | 194 |
1326962 | 1326962 | 2021-05-17 | Dubois | Indiana | 18037 | 6167 | 118 |
1326963 | 1326963 | 2021-05-17 | Elkhart | Indiana | 18039 | 28944 | 458 |
1326964 | 1326964 | 2021-05-17 | Fayette | Indiana | 18041 | 2957 | 64 |
1326965 | 1326965 | 2021-05-17 | Floyd | Indiana | 18043 | 7700 | 183 |
1326966 | 1326966 | 2021-05-17 | Fountain | Indiana | 18045 | 2141 | 47 |
1326967 | 1326967 | 2021-05-17 | Franklin | Indiana | 18047 | 1703 | 36 |
1326968 | 1326968 | 2021-05-17 | Fulton | Indiana | 18049 | 1961 | 40 |
1326969 | 1326969 | 2021-05-17 | Gibson | Indiana | 18051 | 4376 | 95 |
1326970 | 1326970 | 2021-05-17 | Grant | Indiana | 18053 | 7510 | 181 |
1326971 | 1326971 | 2021-05-17 | Greene | Indiana | 18055 | 2814 | 89 |
1326972 | 1326972 | 2021-05-17 | Hamilton | Indiana | 18057 | 35875 | 426 |
1326973 | 1326973 | 2021-05-17 | Hancock | Indiana | 18059 | 8397 | 146 |
1326974 | 1326974 | 2021-05-17 | Harrison | Indiana | 18061 | 4369 | 74 |
1326975 | 1326975 | 2021-05-17 | Hendricks | Indiana | 18063 | 17381 | 336 |
1326976 | 1326976 | 2021-05-17 | Henry | Indiana | 18065 | 5799 | 107 |
1326977 | 1326977 | 2021-05-17 | Howard | Indiana | 18067 | 10011 | 222 |
1326978 | 1326978 | 2021-05-17 | Huntington | Indiana | 18069 | 3949 | 82 |
1326979 | 1326979 | 2021-05-17 | Jackson | Indiana | 18071 | 5041 | 74 |
1326980 | 1326980 | 2021-05-17 | Jasper | Indiana | 18073 | 3730 | 51 |
1326981 | 1326981 | 2021-05-17 | Jay | Indiana | 18075 | 1989 | 32 |
1326982 | 1326982 | 2021-05-17 | Jefferson | Indiana | 18077 | 3319 | 82 |
1326983 | 1326983 | 2021-05-17 | Jennings | Indiana | 18079 | 2313 | 51 |
1326984 | 1326984 | 2021-05-17 | Johnson | Indiana | 18081 | 18133 | 397 |
1326985 | 1326985 | 2021-05-17 | Knox | Indiana | 18083 | 3730 | 90 |
1326986 | 1326986 | 2021-05-17 | Kosciusko | Indiana | 18085 | 9486 | 121 |
1326987 | 1326987 | 2021-05-17 | LaGrange | Indiana | 18087 | 2694 | 72 |
1326988 | 1326988 | 2021-05-17 | LaPorte | Indiana | 18091 | 12097 | 217 |
1326989 | 1326989 | 2021-05-17 | Lake | Indiana | 18089 | 54330 | 1018 |
1326990 | 1326990 | 2021-05-17 | Lawrence | Indiana | 18093 | 4605 | 123 |
1326991 | 1326991 | 2021-05-17 | Madison | Indiana | 18095 | 12792 | 359 |
1326992 | 1326992 | 2021-05-17 | Marion | Indiana | 18097 | 100918 | 1817 |
1326993 | 1326993 | 2021-05-17 | Marshall | Indiana | 18099 | 6115 | 114 |
1326994 | 1326994 | 2021-05-17 | Martin | Indiana | 18101 | 896 | 15 |
1326995 | 1326995 | 2021-05-17 | Miami | Indiana | 18103 | 3845 | 69 |
1326996 | 1326996 | 2021-05-17 | Monroe | Indiana | 18105 | 11960 | 174 |
1326997 | 1326997 | 2021-05-17 | Montgomery | Indiana | 18107 | 4261 | 91 |
1326998 | 1326998 | 2021-05-17 | Morgan | Indiana | 18109 | 6628 | 145 |
1326999 | 1326999 | 2021-05-17 | Newton | Indiana | 18111 | 1091 | 36 |
1327000 | 1327000 | 2021-05-17 | Noble | Indiana | 18113 | 5663 | 87 |
1327001 | 1327001 | 2021-05-17 | Ohio | Indiana | 18115 | 571 | 11 |
1327002 | 1327002 | 2021-05-17 | Orange | Indiana | 18117 | 1851 | 57 |
1327003 | 1327003 | 2021-05-17 | Owen | Indiana | 18119 | 2036 | 58 |
1327004 | 1327004 | 2021-05-17 | Parke | Indiana | 18121 | 1481 | 16 |
1327005 | 1327005 | 2021-05-17 | Perry | Indiana | 18123 | 1856 | 38 |
1327006 | 1327006 | 2021-05-17 | Pike | Indiana | 18125 | 1356 | 34 |
1327007 | 1327007 | 2021-05-17 | Porter | Indiana | 18127 | 18966 | 322 |
1327008 | 1327008 | 2021-05-17 | Posey | Indiana | 18129 | 2720 | 34 |
1327009 | 1327009 | 2021-05-17 | Pulaski | Indiana | 18131 | 1175 | 45 |
1327010 | 1327010 | 2021-05-17 | Putnam | Indiana | 18133 | 3646 | 60 |
1327011 | 1327011 | 2021-05-17 | Randolph | Indiana | 18135 | 2461 | 82 |
1327012 | 1327012 | 2021-05-17 | Ripley | Indiana | 18137 | 3409 | 70 |
1327013 | 1327013 | 2021-05-17 | Rush | Indiana | 18139 | 1809 | 25 |
1327014 | 1327014 | 2021-05-17 | Scott | Indiana | 18143 | 2682 | 56 |
1327015 | 1327015 | 2021-05-17 | Shelby | Indiana | 18145 | 5924 | 106 |
1327016 | 1327016 | 2021-05-17 | Spencer | Indiana | 18147 | 2331 | 31 |
1327017 | 1327017 | 2021-05-17 | St. Joseph | Indiana | 18141 | 36370 | 571 |
1327018 | 1327018 | 2021-05-17 | Starke | Indiana | 18149 | 2196 | 56 |
1327019 | 1327019 | 2021-05-17 | Steuben | Indiana | 18151 | 3916 | 59 |
1327020 | 1327020 | 2021-05-17 | Sullivan | Indiana | 18153 | 2126 | 42 |
1327021 | 1327021 | 2021-05-17 | Switzerland | Indiana | 18155 | 795 | 8 |
1327022 | 1327022 | 2021-05-17 | Tippecanoe | Indiana | 18157 | 22480 | 221 |
1327023 | 1327023 | 2021-05-17 | Tipton | Indiana | 18159 | 1638 | 47 |
1327024 | 1327024 | 2021-05-17 | Union | Indiana | 18161 | 742 | 11 |
1327025 | 1327025 | 2021-05-17 | Vanderburgh | Indiana | 18163 | 22376 | 402 |
1327026 | 1327026 | 2021-05-17 | Vermillion | Indiana | 18165 | 1701 | 44 |
1327027 | 1327027 | 2021-05-17 | Vigo | Indiana | 18167 | 12513 | 254 |
1327028 | 1327028 | 2021-05-17 | Wabash | Indiana | 18169 | 3558 | 80 |
1327029 | 1327029 | 2021-05-17 | Warren | Indiana | 18171 | 828 | 16 |
1327030 | 1327030 | 2021-05-17 | Warrick | Indiana | 18173 | 7802 | 158 |
1327031 | 1327031 | 2021-05-17 | Washington | Indiana | 18175 | 2421 | 32 |
1327032 | 1327032 | 2021-05-17 | Wayne | Indiana | 18177 | 7455 | 203 |
1327033 | 1327033 | 2021-05-17 | Wells | Indiana | 18179 | 2946 | 83 |
1327034 | 1327034 | 2021-05-17 | White | Indiana | 18181 | 3178 | 55 |
1327035 | 1327035 | 2021-05-17 | Whitley | Indiana | 18183 | 3987 | 39 |
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);