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-09-27 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
573987 | 573987 | 2020-09-27 | Adams | Indiana | 18001 | 287 | 4 |
573988 | 573988 | 2020-09-27 | Allen | Indiana | 18003 | 6321 | 213 |
573989 | 573989 | 2020-09-27 | Bartholomew | Indiana | 18005 | 1194 | 61 |
573990 | 573990 | 2020-09-27 | Benton | Indiana | 18007 | 87 | 0 |
573991 | 573991 | 2020-09-27 | Blackford | Indiana | 18009 | 128 | 3 |
573992 | 573992 | 2020-09-27 | Boone | Indiana | 18011 | 1006 | 49 |
573993 | 573993 | 2020-09-27 | Brown | Indiana | 18013 | 104 | 3 |
573994 | 573994 | 2020-09-27 | Carroll | Indiana | 18015 | 277 | 13 |
573995 | 573995 | 2020-09-27 | Cass | Indiana | 18017 | 1957 | 10 |
573996 | 573996 | 2020-09-27 | Clark | Indiana | 18019 | 2253 | 64 |
573997 | 573997 | 2020-09-27 | Clay | Indiana | 18021 | 302 | 5 |
573998 | 573998 | 2020-09-27 | Clinton | Indiana | 18023 | 613 | 18 |
573999 | 573999 | 2020-09-27 | Crawford | Indiana | 18025 | 109 | 1 |
574000 | 574000 | 2020-09-27 | Daviess | Indiana | 18027 | 679 | 30 |
574001 | 574001 | 2020-09-27 | DeKalb | Indiana | 18033 | 489 | 12 |
574002 | 574002 | 2020-09-27 | Dearborn | Indiana | 18029 | 672 | 30 |
574003 | 574003 | 2020-09-27 | Decatur | Indiana | 18031 | 485 | 42 |
574004 | 574004 | 2020-09-27 | Delaware | Indiana | 18035 | 1990 | 63 |
574005 | 574005 | 2020-09-27 | Dubois | Indiana | 18037 | 991 | 19 |
574006 | 574006 | 2020-09-27 | Elkhart | Indiana | 18039 | 6761 | 115 |
574007 | 574007 | 2020-09-27 | Fayette | Indiana | 18041 | 537 | 13 |
574008 | 574008 | 2020-09-27 | Floyd | Indiana | 18043 | 1395 | 66 |
574009 | 574009 | 2020-09-27 | Fountain | Indiana | 18045 | 130 | 2 |
574010 | 574010 | 2020-09-27 | Franklin | Indiana | 18047 | 321 | 26 |
574011 | 574011 | 2020-09-27 | Fulton | Indiana | 18049 | 243 | 2 |
574012 | 574012 | 2020-09-27 | Gibson | Indiana | 18051 | 532 | 5 |
574013 | 574013 | 2020-09-27 | Grant | Indiana | 18053 | 1276 | 37 |
574014 | 574014 | 2020-09-27 | Greene | Indiana | 18055 | 432 | 38 |
574015 | 574015 | 2020-09-27 | Hamilton | Indiana | 18057 | 4941 | 118 |
574016 | 574016 | 2020-09-27 | Hancock | Indiana | 18059 | 947 | 46 |
574017 | 574017 | 2020-09-27 | Harrison | Indiana | 18061 | 590 | 26 |
574018 | 574018 | 2020-09-27 | Hendricks | Indiana | 18063 | 2781 | 140 |
574019 | 574019 | 2020-09-27 | Henry | Indiana | 18065 | 821 | 26 |
574020 | 574020 | 2020-09-27 | Howard | Indiana | 18067 | 1326 | 66 |
574021 | 574021 | 2020-09-27 | Huntington | Indiana | 18069 | 248 | 3 |
574022 | 574022 | 2020-09-27 | Jackson | Indiana | 18071 | 772 | 10 |
574023 | 574023 | 2020-09-27 | Jasper | Indiana | 18073 | 401 | 3 |
574024 | 574024 | 2020-09-27 | Jay | Indiana | 18075 | 194 | 0 |
574025 | 574025 | 2020-09-27 | Jefferson | Indiana | 18077 | 249 | 3 |
574026 | 574026 | 2020-09-27 | Jennings | Indiana | 18079 | 319 | 14 |
574027 | 574027 | 2020-09-27 | Johnson | Indiana | 18081 | 2377 | 133 |
574028 | 574028 | 2020-09-27 | Knox | Indiana | 18083 | 526 | 9 |
574029 | 574029 | 2020-09-27 | Kosciusko | Indiana | 18085 | 1268 | 19 |
574030 | 574030 | 2020-09-27 | LaGrange | Indiana | 18087 | 641 | 11 |
574031 | 574031 | 2020-09-27 | LaPorte | Indiana | 18091 | 1478 | 41 |
574032 | 574032 | 2020-09-27 | Lake | Indiana | 18089 | 10680 | 341 |
574033 | 574033 | 2020-09-27 | Lawrence | Indiana | 18093 | 517 | 31 |
574034 | 574034 | 2020-09-27 | Madison | Indiana | 18095 | 1705 | 86 |
574035 | 574035 | 2020-09-27 | Marion | Indiana | 18097 | 21574 | 818 |
574036 | 574036 | 2020-09-27 | Marshall | Indiana | 18099 | 1012 | 24 |
574037 | 574037 | 2020-09-27 | Martin | Indiana | 18101 | 169 | 0 |
574038 | 574038 | 2020-09-27 | Miami | Indiana | 18103 | 442 | 3 |
574039 | 574039 | 2020-09-27 | Monroe | Indiana | 18105 | 2632 | 40 |
574040 | 574040 | 2020-09-27 | Montgomery | Indiana | 18107 | 513 | 22 |
574041 | 574041 | 2020-09-27 | Morgan | Indiana | 18109 | 742 | 41 |
574042 | 574042 | 2020-09-27 | Newton | Indiana | 18111 | 174 | 12 |
574043 | 574043 | 2020-09-27 | Noble | Indiana | 18113 | 929 | 33 |
574044 | 574044 | 2020-09-27 | Ohio | Indiana | 18115 | 79 | 7 |
574045 | 574045 | 2020-09-27 | Orange | Indiana | 18117 | 290 | 26 |
574046 | 574046 | 2020-09-27 | Owen | Indiana | 18119 | 172 | 2 |
574047 | 574047 | 2020-09-27 | Parke | Indiana | 18121 | 109 | 2 |
574048 | 574048 | 2020-09-27 | Perry | Indiana | 18123 | 232 | 14 |
574049 | 574049 | 2020-09-27 | Pike | Indiana | 18125 | 162 | 1 |
574050 | 574050 | 2020-09-27 | Porter | Indiana | 18127 | 2187 | 49 |
574051 | 574051 | 2020-09-27 | Posey | Indiana | 18129 | 340 | 0 |
574052 | 574052 | 2020-09-27 | Pulaski | Indiana | 18131 | 115 | 1 |
574053 | 574053 | 2020-09-27 | Putnam | Indiana | 18133 | 586 | 12 |
574054 | 574054 | 2020-09-27 | Randolph | Indiana | 18135 | 257 | 7 |
574055 | 574055 | 2020-09-27 | Ripley | Indiana | 18137 | 304 | 8 |
574056 | 574056 | 2020-09-27 | Rush | Indiana | 18139 | 201 | 4 |
574057 | 574057 | 2020-09-27 | Scott | Indiana | 18143 | 387 | 13 |
574058 | 574058 | 2020-09-27 | Shelby | Indiana | 18145 | 1165 | 37 |
574059 | 574059 | 2020-09-27 | Spencer | Indiana | 18147 | 262 | 3 |
574060 | 574060 | 2020-09-27 | St. Joseph | Indiana | 18141 | 6594 | 116 |
574061 | 574061 | 2020-09-27 | Starke | Indiana | 18149 | 269 | 8 |
574062 | 574062 | 2020-09-27 | Steuben | Indiana | 18151 | 388 | 7 |
574063 | 574063 | 2020-09-27 | Sullivan | Indiana | 18153 | 342 | 12 |
574064 | 574064 | 2020-09-27 | Switzerland | Indiana | 18155 | 71 | 0 |
574065 | 574065 | 2020-09-27 | Tippecanoe | Indiana | 18157 | 2526 | 14 |
574066 | 574066 | 2020-09-27 | Tipton | Indiana | 18159 | 232 | 25 |
574067 | 574067 | 2020-09-27 | Union | Indiana | 18161 | 105 | 0 |
574068 | 574068 | 2020-09-27 | Vanderburgh | Indiana | 18163 | 3722 | 31 |
574069 | 574069 | 2020-09-27 | Vermillion | Indiana | 18165 | 131 | 0 |
574070 | 574070 | 2020-09-27 | Vigo | Indiana | 18167 | 1848 | 28 |
574071 | 574071 | 2020-09-27 | Wabash | Indiana | 18169 | 275 | 8 |
574072 | 574072 | 2020-09-27 | Warren | Indiana | 18171 | 41 | 1 |
574073 | 574073 | 2020-09-27 | Warrick | Indiana | 18173 | 1346 | 42 |
574074 | 574074 | 2020-09-27 | Washington | Indiana | 18175 | 269 | 1 |
574075 | 574075 | 2020-09-27 | Wayne | Indiana | 18177 | 1128 | 14 |
574076 | 574076 | 2020-09-27 | Wells | Indiana | 18179 | 282 | 4 |
574077 | 574077 | 2020-09-27 | White | Indiana | 18181 | 486 | 14 |
574078 | 574078 | 2020-09-27 | Whitley | Indiana | 18183 | 279 | 6 |
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);