ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-05-07" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
121951 | 121951 | 2020-05-07 | Adams | Indiana | 18001 | 8 | 1 |
121952 | 121952 | 2020-05-07 | Allen | Indiana | 18003 | 748 | 63 |
121953 | 121953 | 2020-05-07 | Bartholomew | Indiana | 18005 | 319 | 24 |
121954 | 121954 | 2020-05-07 | Benton | Indiana | 18007 | 12 | 0 |
121955 | 121955 | 2020-05-07 | Blackford | Indiana | 18009 | 12 | 1 |
121956 | 121956 | 2020-05-07 | Boone | Indiana | 18011 | 222 | 30 |
121957 | 121957 | 2020-05-07 | Brown | Indiana | 18013 | 25 | 1 |
121958 | 121958 | 2020-05-07 | Carroll | Indiana | 18015 | 66 | 1 |
121959 | 121959 | 2020-05-07 | Cass | Indiana | 18017 | 1471 | 3 |
121960 | 121960 | 2020-05-07 | Clark | Indiana | 18019 | 358 | 26 |
121961 | 121961 | 2020-05-07 | Clay | Indiana | 18021 | 23 | 1 |
121962 | 121962 | 2020-05-07 | Clinton | Indiana | 18023 | 76 | 2 |
121963 | 121963 | 2020-05-07 | Crawford | Indiana | 18025 | 21 | 1 |
121964 | 121964 | 2020-05-07 | Daviess | Indiana | 18027 | 56 | 17 |
121965 | 121965 | 2020-05-07 | DeKalb | Indiana | 18033 | 24 | 2 |
121966 | 121966 | 2020-05-07 | Dearborn | Indiana | 18029 | 145 | 13 |
121967 | 121967 | 2020-05-07 | Decatur | Indiana | 18031 | 216 | 31 |
121968 | 121968 | 2020-05-07 | Delaware | Indiana | 18035 | 213 | 15 |
121969 | 121969 | 2020-05-07 | Dubois | Indiana | 18037 | 35 | 0 |
121970 | 121970 | 2020-05-07 | Elkhart | Indiana | 18039 | 390 | 16 |
121971 | 121971 | 2020-05-07 | Fayette | Indiana | 18041 | 52 | 4 |
121972 | 121972 | 2020-05-07 | Floyd | Indiana | 18043 | 225 | 29 |
121973 | 121973 | 2020-05-07 | Fountain | Indiana | 18045 | 14 | 2 |
121974 | 121974 | 2020-05-07 | Franklin | Indiana | 18047 | 104 | 8 |
121975 | 121975 | 2020-05-07 | Fulton | Indiana | 18049 | 34 | 1 |
121976 | 121976 | 2020-05-07 | Gibson | Indiana | 18051 | 7 | 0 |
121977 | 121977 | 2020-05-07 | Grant | Indiana | 18053 | 165 | 15 |
121978 | 121978 | 2020-05-07 | Greene | Indiana | 18055 | 136 | 11 |
121979 | 121979 | 2020-05-07 | Hamilton | Indiana | 18057 | 903 | 82 |
121980 | 121980 | 2020-05-07 | Hancock | Indiana | 18059 | 243 | 17 |
121981 | 121981 | 2020-05-07 | Harrison | Indiana | 18061 | 151 | 12 |
121982 | 121982 | 2020-05-07 | Hendricks | Indiana | 18063 | 910 | 60 |
121983 | 121983 | 2020-05-07 | Henry | Indiana | 18065 | 61 | 2 |
121984 | 121984 | 2020-05-07 | Howard | Indiana | 18067 | 226 | 10 |
121985 | 121985 | 2020-05-07 | Huntington | Indiana | 18069 | 12 | 2 |
121986 | 121986 | 2020-05-07 | Jackson | Indiana | 18071 | 221 | 1 |
121987 | 121987 | 2020-05-07 | Jasper | Indiana | 18073 | 38 | 1 |
121988 | 121988 | 2020-05-07 | Jay | Indiana | 18075 | 19 | 0 |
121989 | 121989 | 2020-05-07 | Jefferson | Indiana | 18077 | 33 | 0 |
121990 | 121990 | 2020-05-07 | Jennings | Indiana | 18079 | 91 | 5 |
121991 | 121991 | 2020-05-07 | Johnson | Indiana | 18081 | 768 | 81 |
121992 | 121992 | 2020-05-07 | Knox | Indiana | 18083 | 21 | 0 |
121993 | 121993 | 2020-05-07 | Kosciusko | Indiana | 18085 | 40 | 2 |
121994 | 121994 | 2020-05-07 | LaGrange | Indiana | 18087 | 37 | 2 |
121995 | 121995 | 2020-05-07 | LaPorte | Indiana | 18091 | 303 | 10 |
121996 | 121996 | 2020-05-07 | Lake | Indiana | 18089 | 2312 | 121 |
121997 | 121997 | 2020-05-07 | Lawrence | Indiana | 18093 | 113 | 16 |
121998 | 121998 | 2020-05-07 | Madison | Indiana | 18095 | 483 | 65 |
121999 | 121999 | 2020-05-07 | Marion | Indiana | 18097 | 6978 | 425 |
122000 | 122000 | 2020-05-07 | Marshall | Indiana | 18099 | 31 | 1 |
122001 | 122001 | 2020-05-07 | Martin | Indiana | 18101 | 7 | 0 |
122002 | 122002 | 2020-05-07 | Miami | Indiana | 18103 | 122 | 1 |
122003 | 122003 | 2020-05-07 | Monroe | Indiana | 18105 | 137 | 9 |
122004 | 122004 | 2020-05-07 | Montgomery | Indiana | 18107 | 111 | 2 |
122005 | 122005 | 2020-05-07 | Morgan | Indiana | 18109 | 186 | 9 |
122006 | 122006 | 2020-05-07 | Newton | Indiana | 18111 | 63 | 10 |
122007 | 122007 | 2020-05-07 | Noble | Indiana | 18113 | 125 | 15 |
122008 | 122008 | 2020-05-07 | Ohio | Indiana | 18115 | 7 | 0 |
122009 | 122009 | 2020-05-07 | Orange | Indiana | 18117 | 107 | 15 |
122010 | 122010 | 2020-05-07 | Owen | Indiana | 18119 | 24 | 1 |
122011 | 122011 | 2020-05-07 | Parke | Indiana | 18121 | 16 | 0 |
122012 | 122012 | 2020-05-07 | Perry | Indiana | 18123 | 19 | 0 |
122013 | 122013 | 2020-05-07 | Pike | Indiana | 18125 | 2 | 0 |
122014 | 122014 | 2020-05-07 | Porter | Indiana | 18127 | 300 | 8 |
122015 | 122015 | 2020-05-07 | Posey | Indiana | 18129 | 15 | 0 |
122016 | 122016 | 2020-05-07 | Pulaski | Indiana | 18131 | 33 | 0 |
122017 | 122017 | 2020-05-07 | Putnam | Indiana | 18133 | 84 | 5 |
122018 | 122018 | 2020-05-07 | Randolph | Indiana | 18135 | 29 | 2 |
122019 | 122019 | 2020-05-07 | Ripley | Indiana | 18137 | 98 | 6 |
122020 | 122020 | 2020-05-07 | Rush | Indiana | 18139 | 47 | 2 |
122021 | 122021 | 2020-05-07 | Scott | Indiana | 18143 | 63 | 2 |
122022 | 122022 | 2020-05-07 | Shelby | Indiana | 18145 | 300 | 22 |
122023 | 122023 | 2020-05-07 | Spencer | Indiana | 18147 | 9 | 1 |
122024 | 122024 | 2020-05-07 | St. Joseph | Indiana | 18141 | 736 | 29 |
122025 | 122025 | 2020-05-07 | Starke | Indiana | 18149 | 20 | 2 |
122026 | 122026 | 2020-05-07 | Steuben | Indiana | 18151 | 61 | 1 |
122027 | 122027 | 2020-05-07 | Sullivan | Indiana | 18153 | 18 | 0 |
122028 | 122028 | 2020-05-07 | Switzerland | Indiana | 18155 | 16 | 0 |
122029 | 122029 | 2020-05-07 | Tippecanoe | Indiana | 18157 | 203 | 2 |
122030 | 122030 | 2020-05-07 | Tipton | Indiana | 18159 | 20 | 1 |
122031 | 122031 | 2020-05-07 | Union | Indiana | 18161 | 16 | 0 |
122032 | 122032 | 2020-05-07 | Vanderburgh | Indiana | 18163 | 169 | 2 |
122033 | 122033 | 2020-05-07 | Vermillion | Indiana | 18165 | 8 | 0 |
122034 | 122034 | 2020-05-07 | Vigo | Indiana | 18167 | 75 | 6 |
122035 | 122035 | 2020-05-07 | Wabash | Indiana | 18169 | 64 | 2 |
122036 | 122036 | 2020-05-07 | Warren | Indiana | 18171 | 13 | 1 |
122037 | 122037 | 2020-05-07 | Warrick | Indiana | 18173 | 116 | 19 |
122038 | 122038 | 2020-05-07 | Washington | Indiana | 18175 | 45 | 1 |
122039 | 122039 | 2020-05-07 | Wayne | Indiana | 18177 | 126 | 3 |
122040 | 122040 | 2020-05-07 | Wells | Indiana | 18179 | 9 | 0 |
122041 | 122041 | 2020-05-07 | White | Indiana | 18181 | 130 | 1 |
122042 | 122042 | 2020-05-07 | Whitley | Indiana | 18183 | 22 | 1 |
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);