ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2020-05-08 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
124931 | 124931 | 2020-05-08 | Adams | Indiana | 18001 | 8 | 1 |
124932 | 124932 | 2020-05-08 | Allen | Indiana | 18003 | 786 | 63 |
124933 | 124933 | 2020-05-08 | Bartholomew | Indiana | 18005 | 334 | 25 |
124934 | 124934 | 2020-05-08 | Benton | Indiana | 18007 | 12 | 0 |
124935 | 124935 | 2020-05-08 | Blackford | Indiana | 18009 | 13 | 1 |
124936 | 124936 | 2020-05-08 | Boone | Indiana | 18011 | 228 | 30 |
124937 | 124937 | 2020-05-08 | Brown | Indiana | 18013 | 25 | 1 |
124938 | 124938 | 2020-05-08 | Carroll | Indiana | 18015 | 70 | 2 |
124939 | 124939 | 2020-05-08 | Cass | Indiana | 18017 | 1499 | 3 |
124940 | 124940 | 2020-05-08 | Clark | Indiana | 18019 | 361 | 26 |
124941 | 124941 | 2020-05-08 | Clay | Indiana | 18021 | 24 | 1 |
124942 | 124942 | 2020-05-08 | Clinton | Indiana | 18023 | 81 | 2 |
124943 | 124943 | 2020-05-08 | Crawford | Indiana | 18025 | 21 | 1 |
124944 | 124944 | 2020-05-08 | Daviess | Indiana | 18027 | 56 | 17 |
124945 | 124945 | 2020-05-08 | DeKalb | Indiana | 18033 | 24 | 2 |
124946 | 124946 | 2020-05-08 | Dearborn | Indiana | 18029 | 146 | 13 |
124947 | 124947 | 2020-05-08 | Decatur | Indiana | 18031 | 218 | 31 |
124948 | 124948 | 2020-05-08 | Delaware | Indiana | 18035 | 214 | 15 |
124949 | 124949 | 2020-05-08 | Dubois | Indiana | 18037 | 38 | 0 |
124950 | 124950 | 2020-05-08 | Elkhart | Indiana | 18039 | 413 | 16 |
124951 | 124951 | 2020-05-08 | Fayette | Indiana | 18041 | 54 | 4 |
124952 | 124952 | 2020-05-08 | Floyd | Indiana | 18043 | 227 | 29 |
124953 | 124953 | 2020-05-08 | Fountain | Indiana | 18045 | 14 | 2 |
124954 | 124954 | 2020-05-08 | Franklin | Indiana | 18047 | 107 | 8 |
124955 | 124955 | 2020-05-08 | Fulton | Indiana | 18049 | 34 | 1 |
124956 | 124956 | 2020-05-08 | Gibson | Indiana | 18051 | 7 | 0 |
124957 | 124957 | 2020-05-08 | Grant | Indiana | 18053 | 170 | 16 |
124958 | 124958 | 2020-05-08 | Greene | Indiana | 18055 | 150 | 11 |
124959 | 124959 | 2020-05-08 | Hamilton | Indiana | 18057 | 913 | 82 |
124960 | 124960 | 2020-05-08 | Hancock | Indiana | 18059 | 248 | 18 |
124961 | 124961 | 2020-05-08 | Harrison | Indiana | 18061 | 154 | 12 |
124962 | 124962 | 2020-05-08 | Hendricks | Indiana | 18063 | 944 | 63 |
124963 | 124963 | 2020-05-08 | Henry | Indiana | 18065 | 73 | 2 |
124964 | 124964 | 2020-05-08 | Howard | Indiana | 18067 | 235 | 10 |
124965 | 124965 | 2020-05-08 | Huntington | Indiana | 18069 | 13 | 2 |
124966 | 124966 | 2020-05-08 | Jackson | Indiana | 18071 | 253 | 1 |
124967 | 124967 | 2020-05-08 | Jasper | Indiana | 18073 | 37 | 1 |
124968 | 124968 | 2020-05-08 | Jay | Indiana | 18075 | 19 | 0 |
124969 | 124969 | 2020-05-08 | Jefferson | Indiana | 18077 | 35 | 0 |
124970 | 124970 | 2020-05-08 | Jennings | Indiana | 18079 | 95 | 5 |
124971 | 124971 | 2020-05-08 | Johnson | Indiana | 18081 | 783 | 87 |
124972 | 124972 | 2020-05-08 | Knox | Indiana | 18083 | 21 | 0 |
124973 | 124973 | 2020-05-08 | Kosciusko | Indiana | 18085 | 40 | 2 |
124974 | 124974 | 2020-05-08 | LaGrange | Indiana | 18087 | 37 | 2 |
124975 | 124975 | 2020-05-08 | LaPorte | Indiana | 18091 | 307 | 11 |
124976 | 124976 | 2020-05-08 | Lake | Indiana | 18089 | 2383 | 128 |
124977 | 124977 | 2020-05-08 | Lawrence | Indiana | 18093 | 116 | 16 |
124978 | 124978 | 2020-05-08 | Madison | Indiana | 18095 | 488 | 65 |
124979 | 124979 | 2020-05-08 | Marion | Indiana | 18097 | 7142 | 430 |
124980 | 124980 | 2020-05-08 | Marshall | Indiana | 18099 | 31 | 1 |
124981 | 124981 | 2020-05-08 | Martin | Indiana | 18101 | 7 | 0 |
124982 | 124982 | 2020-05-08 | Miami | Indiana | 18103 | 123 | 1 |
124983 | 124983 | 2020-05-08 | Monroe | Indiana | 18105 | 141 | 9 |
124984 | 124984 | 2020-05-08 | Montgomery | Indiana | 18107 | 115 | 2 |
124985 | 124985 | 2020-05-08 | Morgan | Indiana | 18109 | 185 | 9 |
124986 | 124986 | 2020-05-08 | Newton | Indiana | 18111 | 66 | 10 |
124987 | 124987 | 2020-05-08 | Noble | Indiana | 18113 | 128 | 15 |
124988 | 124988 | 2020-05-08 | Ohio | Indiana | 18115 | 7 | 0 |
124989 | 124989 | 2020-05-08 | Orange | Indiana | 18117 | 109 | 18 |
124990 | 124990 | 2020-05-08 | Owen | Indiana | 18119 | 26 | 1 |
124991 | 124991 | 2020-05-08 | Parke | Indiana | 18121 | 17 | 0 |
124992 | 124992 | 2020-05-08 | Perry | Indiana | 18123 | 21 | 0 |
124993 | 124993 | 2020-05-08 | Pike | Indiana | 18125 | 2 | 0 |
124994 | 124994 | 2020-05-08 | Porter | Indiana | 18127 | 309 | 9 |
124995 | 124995 | 2020-05-08 | Posey | Indiana | 18129 | 15 | 0 |
124996 | 124996 | 2020-05-08 | Pulaski | Indiana | 18131 | 33 | 0 |
124997 | 124997 | 2020-05-08 | Putnam | Indiana | 18133 | 89 | 5 |
124998 | 124998 | 2020-05-08 | Randolph | Indiana | 18135 | 35 | 2 |
124999 | 124999 | 2020-05-08 | Ripley | Indiana | 18137 | 98 | 6 |
125000 | 125000 | 2020-05-08 | Rush | Indiana | 18139 | 47 | 2 |
125001 | 125001 | 2020-05-08 | Scott | Indiana | 18143 | 73 | 2 |
125002 | 125002 | 2020-05-08 | Shelby | Indiana | 18145 | 311 | 22 |
125003 | 125003 | 2020-05-08 | Spencer | Indiana | 18147 | 10 | 1 |
125004 | 125004 | 2020-05-08 | St. Joseph | Indiana | 18141 | 779 | 30 |
125005 | 125005 | 2020-05-08 | Starke | Indiana | 18149 | 22 | 2 |
125006 | 125006 | 2020-05-08 | Steuben | Indiana | 18151 | 63 | 1 |
125007 | 125007 | 2020-05-08 | Sullivan | Indiana | 18153 | 19 | 0 |
125008 | 125008 | 2020-05-08 | Switzerland | Indiana | 18155 | 16 | 0 |
125009 | 125009 | 2020-05-08 | Tippecanoe | Indiana | 18157 | 208 | 2 |
125010 | 125010 | 2020-05-08 | Tipton | Indiana | 18159 | 20 | 1 |
125011 | 125011 | 2020-05-08 | Union | Indiana | 18161 | 19 | 0 |
125012 | 125012 | 2020-05-08 | Vanderburgh | Indiana | 18163 | 175 | 2 |
125013 | 125013 | 2020-05-08 | Vermillion | Indiana | 18165 | 8 | 0 |
125014 | 125014 | 2020-05-08 | Vigo | Indiana | 18167 | 74 | 6 |
125015 | 125015 | 2020-05-08 | Wabash | Indiana | 18169 | 64 | 2 |
125016 | 125016 | 2020-05-08 | Warren | Indiana | 18171 | 13 | 1 |
125017 | 125017 | 2020-05-08 | Warrick | Indiana | 18173 | 119 | 19 |
125018 | 125018 | 2020-05-08 | Washington | Indiana | 18175 | 45 | 1 |
125019 | 125019 | 2020-05-08 | Wayne | Indiana | 18177 | 138 | 5 |
125020 | 125020 | 2020-05-08 | Wells | Indiana | 18179 | 9 | 0 |
125021 | 125021 | 2020-05-08 | White | Indiana | 18181 | 139 | 1 |
125022 | 125022 | 2020-05-08 | 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);