ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-05-09" 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 |
---|---|---|---|---|---|---|---|
127918 | 127918 | 2020-05-09 | Adams | Indiana | 18001 | 8 | 1 |
127919 | 127919 | 2020-05-09 | Allen | Indiana | 18003 | 805 | 63 |
127920 | 127920 | 2020-05-09 | Bartholomew | Indiana | 18005 | 345 | 26 |
127921 | 127921 | 2020-05-09 | Benton | Indiana | 18007 | 12 | 0 |
127922 | 127922 | 2020-05-09 | Blackford | Indiana | 18009 | 13 | 1 |
127923 | 127923 | 2020-05-09 | Boone | Indiana | 18011 | 233 | 33 |
127924 | 127924 | 2020-05-09 | Brown | Indiana | 18013 | 25 | 1 |
127925 | 127925 | 2020-05-09 | Carroll | Indiana | 18015 | 71 | 2 |
127926 | 127926 | 2020-05-09 | Cass | Indiana | 18017 | 1509 | 3 |
127927 | 127927 | 2020-05-09 | Clark | Indiana | 18019 | 379 | 30 |
127928 | 127928 | 2020-05-09 | Clay | Indiana | 18021 | 24 | 1 |
127929 | 127929 | 2020-05-09 | Clinton | Indiana | 18023 | 86 | 2 |
127930 | 127930 | 2020-05-09 | Crawford | Indiana | 18025 | 21 | 1 |
127931 | 127931 | 2020-05-09 | Daviess | Indiana | 18027 | 56 | 17 |
127932 | 127932 | 2020-05-09 | DeKalb | Indiana | 18033 | 24 | 2 |
127933 | 127933 | 2020-05-09 | Dearborn | Indiana | 18029 | 148 | 13 |
127934 | 127934 | 2020-05-09 | Decatur | Indiana | 18031 | 220 | 31 |
127935 | 127935 | 2020-05-09 | Delaware | Indiana | 18035 | 219 | 15 |
127936 | 127936 | 2020-05-09 | Dubois | Indiana | 18037 | 42 | 0 |
127937 | 127937 | 2020-05-09 | Elkhart | Indiana | 18039 | 439 | 18 |
127938 | 127938 | 2020-05-09 | Fayette | Indiana | 18041 | 62 | 4 |
127939 | 127939 | 2020-05-09 | Floyd | Indiana | 18043 | 231 | 29 |
127940 | 127940 | 2020-05-09 | Fountain | Indiana | 18045 | 15 | 2 |
127941 | 127941 | 2020-05-09 | Franklin | Indiana | 18047 | 107 | 8 |
127942 | 127942 | 2020-05-09 | Fulton | Indiana | 18049 | 36 | 1 |
127943 | 127943 | 2020-05-09 | Gibson | Indiana | 18051 | 7 | 0 |
127944 | 127944 | 2020-05-09 | Grant | Indiana | 18053 | 172 | 17 |
127945 | 127945 | 2020-05-09 | Greene | Indiana | 18055 | 151 | 11 |
127946 | 127946 | 2020-05-09 | Hamilton | Indiana | 18057 | 930 | 84 |
127947 | 127947 | 2020-05-09 | Hancock | Indiana | 18059 | 266 | 19 |
127948 | 127948 | 2020-05-09 | Harrison | Indiana | 18061 | 157 | 12 |
127949 | 127949 | 2020-05-09 | Hendricks | Indiana | 18063 | 969 | 65 |
127950 | 127950 | 2020-05-09 | Henry | Indiana | 18065 | 75 | 2 |
127951 | 127951 | 2020-05-09 | Howard | Indiana | 18067 | 243 | 10 |
127952 | 127952 | 2020-05-09 | Huntington | Indiana | 18069 | 13 | 2 |
127953 | 127953 | 2020-05-09 | Jackson | Indiana | 18071 | 276 | 1 |
127954 | 127954 | 2020-05-09 | Jasper | Indiana | 18073 | 38 | 1 |
127955 | 127955 | 2020-05-09 | Jay | Indiana | 18075 | 22 | 0 |
127956 | 127956 | 2020-05-09 | Jefferson | Indiana | 18077 | 35 | 0 |
127957 | 127957 | 2020-05-09 | Jennings | Indiana | 18079 | 97 | 5 |
127958 | 127958 | 2020-05-09 | Johnson | Indiana | 18081 | 805 | 89 |
127959 | 127959 | 2020-05-09 | Knox | Indiana | 18083 | 21 | 0 |
127960 | 127960 | 2020-05-09 | Kosciusko | Indiana | 18085 | 40 | 2 |
127961 | 127961 | 2020-05-09 | LaGrange | Indiana | 18087 | 38 | 2 |
127962 | 127962 | 2020-05-09 | LaPorte | Indiana | 18091 | 321 | 11 |
127963 | 127963 | 2020-05-09 | Lake | Indiana | 18089 | 2416 | 132 |
127964 | 127964 | 2020-05-09 | Lawrence | Indiana | 18093 | 117 | 16 |
127965 | 127965 | 2020-05-09 | Madison | Indiana | 18095 | 506 | 65 |
127966 | 127966 | 2020-05-09 | Marion | Indiana | 18097 | 7314 | 444 |
127967 | 127967 | 2020-05-09 | Marshall | Indiana | 18099 | 32 | 1 |
127968 | 127968 | 2020-05-09 | Martin | Indiana | 18101 | 7 | 0 |
127969 | 127969 | 2020-05-09 | Miami | Indiana | 18103 | 124 | 1 |
127970 | 127970 | 2020-05-09 | Monroe | Indiana | 18105 | 142 | 9 |
127971 | 127971 | 2020-05-09 | Montgomery | Indiana | 18107 | 126 | 3 |
127972 | 127972 | 2020-05-09 | Morgan | Indiana | 18109 | 197 | 9 |
127973 | 127973 | 2020-05-09 | Newton | Indiana | 18111 | 66 | 10 |
127974 | 127974 | 2020-05-09 | Noble | Indiana | 18113 | 129 | 15 |
127975 | 127975 | 2020-05-09 | Ohio | Indiana | 18115 | 9 | 0 |
127976 | 127976 | 2020-05-09 | Orange | Indiana | 18117 | 114 | 19 |
127977 | 127977 | 2020-05-09 | Owen | Indiana | 18119 | 28 | 1 |
127978 | 127978 | 2020-05-09 | Parke | Indiana | 18121 | 19 | 0 |
127979 | 127979 | 2020-05-09 | Perry | Indiana | 18123 | 23 | 0 |
127980 | 127980 | 2020-05-09 | Pike | Indiana | 18125 | 2 | 0 |
127981 | 127981 | 2020-05-09 | Porter | Indiana | 18127 | 315 | 10 |
127982 | 127982 | 2020-05-09 | Posey | Indiana | 18129 | 15 | 0 |
127983 | 127983 | 2020-05-09 | Pulaski | Indiana | 18131 | 34 | 0 |
127984 | 127984 | 2020-05-09 | Putnam | Indiana | 18133 | 90 | 5 |
127985 | 127985 | 2020-05-09 | Randolph | Indiana | 18135 | 37 | 2 |
127986 | 127986 | 2020-05-09 | Ripley | Indiana | 18137 | 98 | 6 |
127987 | 127987 | 2020-05-09 | Rush | Indiana | 18139 | 48 | 2 |
127988 | 127988 | 2020-05-09 | Scott | Indiana | 18143 | 79 | 2 |
127989 | 127989 | 2020-05-09 | Shelby | Indiana | 18145 | 319 | 23 |
127990 | 127990 | 2020-05-09 | Spencer | Indiana | 18147 | 10 | 1 |
127991 | 127991 | 2020-05-09 | St. Joseph | Indiana | 18141 | 792 | 30 |
127992 | 127992 | 2020-05-09 | Starke | Indiana | 18149 | 22 | 2 |
127993 | 127993 | 2020-05-09 | Steuben | Indiana | 18151 | 62 | 2 |
127994 | 127994 | 2020-05-09 | Sullivan | Indiana | 18153 | 20 | 0 |
127995 | 127995 | 2020-05-09 | Switzerland | Indiana | 18155 | 15 | 0 |
127996 | 127996 | 2020-05-09 | Tippecanoe | Indiana | 18157 | 226 | 2 |
127997 | 127997 | 2020-05-09 | Tipton | Indiana | 18159 | 21 | 1 |
127998 | 127998 | 2020-05-09 | Union | Indiana | 18161 | 19 | 0 |
127999 | 127999 | 2020-05-09 | Vanderburgh | Indiana | 18163 | 182 | 2 |
128000 | 128000 | 2020-05-09 | Vermillion | Indiana | 18165 | 8 | 0 |
128001 | 128001 | 2020-05-09 | Vigo | Indiana | 18167 | 78 | 7 |
128002 | 128002 | 2020-05-09 | Wabash | Indiana | 18169 | 64 | 2 |
128003 | 128003 | 2020-05-09 | Warren | Indiana | 18171 | 13 | 1 |
128004 | 128004 | 2020-05-09 | Warrick | Indiana | 18173 | 121 | 20 |
128005 | 128005 | 2020-05-09 | Washington | Indiana | 18175 | 48 | 1 |
128006 | 128006 | 2020-05-09 | Wayne | Indiana | 18177 | 149 | 5 |
128007 | 128007 | 2020-05-09 | Wells | Indiana | 18179 | 10 | 0 |
128008 | 128008 | 2020-05-09 | White | Indiana | 18181 | 145 | 1 |
128009 | 128009 | 2020-05-09 | 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);