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-22 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
167004 | 167004 | 2020-05-22 | Adams | Indiana | 18001 | 11 | 1 |
167005 | 167005 | 2020-05-22 | Allen | Indiana | 18003 | 1199 | 73 |
167006 | 167006 | 2020-05-22 | Bartholomew | Indiana | 18005 | 460 | 36 |
167007 | 167007 | 2020-05-22 | Benton | Indiana | 18007 | 24 | 0 |
167008 | 167008 | 2020-05-22 | Blackford | Indiana | 18009 | 19 | 1 |
167009 | 167009 | 2020-05-22 | Boone | Indiana | 18011 | 297 | 38 |
167010 | 167010 | 2020-05-22 | Brown | Indiana | 18013 | 33 | 1 |
167011 | 167011 | 2020-05-22 | Carroll | Indiana | 18015 | 87 | 2 |
167012 | 167012 | 2020-05-22 | Cass | Indiana | 18017 | 1580 | 7 |
167013 | 167013 | 2020-05-22 | Clark | Indiana | 18019 | 453 | 45 |
167014 | 167014 | 2020-05-22 | Clay | Indiana | 18021 | 36 | 1 |
167015 | 167015 | 2020-05-22 | Clinton | Indiana | 18023 | 195 | 2 |
167016 | 167016 | 2020-05-22 | Crawford | Indiana | 18025 | 24 | 1 |
167017 | 167017 | 2020-05-22 | Daviess | Indiana | 18027 | 75 | 18 |
167018 | 167018 | 2020-05-22 | DeKalb | Indiana | 18033 | 27 | 2 |
167019 | 167019 | 2020-05-22 | Dearborn | Indiana | 18029 | 161 | 21 |
167020 | 167020 | 2020-05-22 | Decatur | Indiana | 18031 | 230 | 34 |
167021 | 167021 | 2020-05-22 | Delaware | Indiana | 18035 | 328 | 26 |
167022 | 167022 | 2020-05-22 | Dubois | Indiana | 18037 | 171 | 2 |
167023 | 167023 | 2020-05-22 | Elkhart | Indiana | 18039 | 908 | 28 |
167024 | 167024 | 2020-05-22 | Fayette | Indiana | 18041 | 83 | 4 |
167025 | 167025 | 2020-05-22 | Floyd | Indiana | 18043 | 313 | 40 |
167026 | 167026 | 2020-05-22 | Fountain | Indiana | 18045 | 17 | 2 |
167027 | 167027 | 2020-05-22 | Franklin | Indiana | 18047 | 112 | 9 |
167028 | 167028 | 2020-05-22 | Fulton | Indiana | 18049 | 46 | 1 |
167029 | 167029 | 2020-05-22 | Gibson | Indiana | 18051 | 13 | 1 |
167030 | 167030 | 2020-05-22 | Grant | Indiana | 18053 | 214 | 22 |
167031 | 167031 | 2020-05-22 | Greene | Indiana | 18055 | 171 | 25 |
167032 | 167032 | 2020-05-22 | Hamilton | Indiana | 18057 | 1097 | 96 |
167033 | 167033 | 2020-05-22 | Hancock | Indiana | 18059 | 316 | 28 |
167034 | 167034 | 2020-05-22 | Harrison | Indiana | 18061 | 180 | 21 |
167035 | 167035 | 2020-05-22 | Hendricks | Indiana | 18063 | 1114 | 76 |
167036 | 167036 | 2020-05-22 | Henry | Indiana | 18065 | 156 | 5 |
167037 | 167037 | 2020-05-22 | Howard | Indiana | 18067 | 342 | 18 |
167038 | 167038 | 2020-05-22 | Huntington | Indiana | 18069 | 20 | 2 |
167039 | 167039 | 2020-05-22 | Jackson | Indiana | 18071 | 355 | 2 |
167040 | 167040 | 2020-05-22 | Jasper | Indiana | 18073 | 51 | 1 |
167041 | 167041 | 2020-05-22 | Jay | Indiana | 18075 | 40 | 0 |
167042 | 167042 | 2020-05-22 | Jefferson | Indiana | 18077 | 42 | 1 |
167043 | 167043 | 2020-05-22 | Jennings | Indiana | 18079 | 127 | 6 |
167044 | 167044 | 2020-05-22 | Johnson | Indiana | 18081 | 1077 | 107 |
167045 | 167045 | 2020-05-22 | Knox | Indiana | 18083 | 24 | 0 |
167046 | 167046 | 2020-05-22 | Kosciusko | Indiana | 18085 | 73 | 2 |
167047 | 167047 | 2020-05-22 | LaGrange | Indiana | 18087 | 59 | 2 |
167048 | 167048 | 2020-05-22 | LaPorte | Indiana | 18091 | 377 | 20 |
167049 | 167049 | 2020-05-22 | Lake | Indiana | 18089 | 3157 | 178 |
167050 | 167050 | 2020-05-22 | Lawrence | Indiana | 18093 | 142 | 22 |
167051 | 167051 | 2020-05-22 | Madison | Indiana | 18095 | 585 | 66 |
167052 | 167052 | 2020-05-22 | Marion | Indiana | 18097 | 9024 | 564 |
167053 | 167053 | 2020-05-22 | Marshall | Indiana | 18099 | 54 | 1 |
167054 | 167054 | 2020-05-22 | Martin | Indiana | 18101 | 8 | 0 |
167055 | 167055 | 2020-05-22 | Miami | Indiana | 18103 | 136 | 1 |
167056 | 167056 | 2020-05-22 | Monroe | Indiana | 18105 | 157 | 10 |
167057 | 167057 | 2020-05-22 | Montgomery | Indiana | 18107 | 203 | 14 |
167058 | 167058 | 2020-05-22 | Morgan | Indiana | 18109 | 261 | 24 |
167059 | 167059 | 2020-05-22 | Newton | Indiana | 18111 | 73 | 11 |
167060 | 167060 | 2020-05-22 | Noble | Indiana | 18113 | 169 | 21 |
167061 | 167061 | 2020-05-22 | Ohio | Indiana | 18115 | 13 | 0 |
167062 | 167062 | 2020-05-22 | Orange | Indiana | 18117 | 124 | 23 |
167063 | 167063 | 2020-05-22 | Owen | Indiana | 18119 | 29 | 1 |
167064 | 167064 | 2020-05-22 | Parke | Indiana | 18121 | 21 | 0 |
167065 | 167065 | 2020-05-22 | Perry | Indiana | 18123 | 33 | 1 |
167066 | 167066 | 2020-05-22 | Pike | Indiana | 18125 | 5 | 0 |
167067 | 167067 | 2020-05-22 | Porter | Indiana | 18127 | 466 | 20 |
167068 | 167068 | 2020-05-22 | Posey | Indiana | 18129 | 16 | 0 |
167069 | 167069 | 2020-05-22 | Pulaski | Indiana | 18131 | 37 | 0 |
167070 | 167070 | 2020-05-22 | Putnam | Indiana | 18133 | 132 | 6 |
167071 | 167071 | 2020-05-22 | Randolph | Indiana | 18135 | 56 | 3 |
167072 | 167072 | 2020-05-22 | Ripley | Indiana | 18137 | 110 | 6 |
167073 | 167073 | 2020-05-22 | Rush | Indiana | 18139 | 58 | 2 |
167074 | 167074 | 2020-05-22 | Scott | Indiana | 18143 | 107 | 3 |
167075 | 167075 | 2020-05-22 | Shelby | Indiana | 18145 | 455 | 29 |
167076 | 167076 | 2020-05-22 | Spencer | Indiana | 18147 | 17 | 1 |
167077 | 167077 | 2020-05-22 | St. Joseph | Indiana | 18141 | 1106 | 38 |
167078 | 167078 | 2020-05-22 | Starke | Indiana | 18149 | 31 | 3 |
167079 | 167079 | 2020-05-22 | Steuben | Indiana | 18151 | 77 | 2 |
167080 | 167080 | 2020-05-22 | Sullivan | Indiana | 18153 | 31 | 1 |
167081 | 167081 | 2020-05-22 | Switzerland | Indiana | 18155 | 20 | 0 |
167082 | 167082 | 2020-05-22 | Tippecanoe | Indiana | 18157 | 350 | 3 |
167083 | 167083 | 2020-05-22 | Tipton | Indiana | 18159 | 21 | 1 |
167084 | 167084 | 2020-05-22 | Union | Indiana | 18161 | 21 | 0 |
167085 | 167085 | 2020-05-22 | Vanderburgh | Indiana | 18163 | 233 | 2 |
167086 | 167086 | 2020-05-22 | Vermillion | Indiana | 18165 | 9 | 0 |
167087 | 167087 | 2020-05-22 | Vigo | Indiana | 18167 | 132 | 8 |
167088 | 167088 | 2020-05-22 | Wabash | Indiana | 18169 | 71 | 2 |
167089 | 167089 | 2020-05-22 | Warren | Indiana | 18171 | 13 | 1 |
167090 | 167090 | 2020-05-22 | Warrick | Indiana | 18173 | 159 | 27 |
167091 | 167091 | 2020-05-22 | Washington | Indiana | 18175 | 52 | 1 |
167092 | 167092 | 2020-05-22 | Wayne | Indiana | 18177 | 195 | 5 |
167093 | 167093 | 2020-05-22 | Wells | Indiana | 18179 | 22 | 0 |
167094 | 167094 | 2020-05-22 | White | Indiana | 18181 | 206 | 8 |
167095 | 167095 | 2020-05-22 | Whitley | Indiana | 18183 | 31 | 2 |
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);