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-10-14 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
629097 | 629097 | 2020-10-14 | Adams | Indiana | 18001 | 406 | 5 |
629098 | 629098 | 2020-10-14 | Allen | Indiana | 18003 | 7354 | 223 |
629099 | 629099 | 2020-10-14 | Bartholomew | Indiana | 18005 | 1327 | 61 |
629100 | 629100 | 2020-10-14 | Benton | Indiana | 18007 | 95 | 0 |
629101 | 629101 | 2020-10-14 | Blackford | Indiana | 18009 | 179 | 3 |
629102 | 629102 | 2020-10-14 | Boone | Indiana | 18011 | 1150 | 51 |
629103 | 629103 | 2020-10-14 | Brown | Indiana | 18013 | 123 | 3 |
629104 | 629104 | 2020-10-14 | Carroll | Indiana | 18015 | 300 | 13 |
629105 | 629105 | 2020-10-14 | Cass | Indiana | 18017 | 2157 | 17 |
629106 | 629106 | 2020-10-14 | Clark | Indiana | 18019 | 2658 | 64 |
629107 | 629107 | 2020-10-14 | Clay | Indiana | 18021 | 385 | 6 |
629108 | 629108 | 2020-10-14 | Clinton | Indiana | 18023 | 758 | 18 |
629109 | 629109 | 2020-10-14 | Crawford | Indiana | 18025 | 134 | 2 |
629110 | 629110 | 2020-10-14 | Daviess | Indiana | 18027 | 769 | 33 |
629111 | 629111 | 2020-10-14 | DeKalb | Indiana | 18033 | 623 | 12 |
629112 | 629112 | 2020-10-14 | Dearborn | Indiana | 18029 | 819 | 30 |
629113 | 629113 | 2020-10-14 | Decatur | Indiana | 18031 | 510 | 42 |
629114 | 629114 | 2020-10-14 | Delaware | Indiana | 18035 | 2542 | 73 |
629115 | 629115 | 2020-10-14 | Dubois | Indiana | 18037 | 1229 | 21 |
629116 | 629116 | 2020-10-14 | Elkhart | Indiana | 18039 | 7867 | 130 |
629117 | 629117 | 2020-10-14 | Fayette | Indiana | 18041 | 635 | 14 |
629118 | 629118 | 2020-10-14 | Floyd | Indiana | 18043 | 1637 | 68 |
629119 | 629119 | 2020-10-14 | Fountain | Indiana | 18045 | 230 | 2 |
629120 | 629120 | 2020-10-14 | Franklin | Indiana | 18047 | 345 | 26 |
629121 | 629121 | 2020-10-14 | Fulton | Indiana | 18049 | 297 | 2 |
629122 | 629122 | 2020-10-14 | Gibson | Indiana | 18051 | 765 | 9 |
629123 | 629123 | 2020-10-14 | Grant | Indiana | 18053 | 1499 | 41 |
629124 | 629124 | 2020-10-14 | Greene | Indiana | 18055 | 479 | 39 |
629125 | 629125 | 2020-10-14 | Hamilton | Indiana | 18057 | 5635 | 121 |
629126 | 629126 | 2020-10-14 | Hancock | Indiana | 18059 | 1091 | 47 |
629127 | 629127 | 2020-10-14 | Harrison | Indiana | 18061 | 692 | 26 |
629128 | 629128 | 2020-10-14 | Hendricks | Indiana | 18063 | 3041 | 145 |
629129 | 629129 | 2020-10-14 | Henry | Indiana | 18065 | 1084 | 27 |
629130 | 629130 | 2020-10-14 | Howard | Indiana | 18067 | 1515 | 69 |
629131 | 629131 | 2020-10-14 | Huntington | Indiana | 18069 | 350 | 5 |
629132 | 629132 | 2020-10-14 | Jackson | Indiana | 18071 | 968 | 11 |
629133 | 629133 | 2020-10-14 | Jasper | Indiana | 18073 | 474 | 4 |
629134 | 629134 | 2020-10-14 | Jay | Indiana | 18075 | 258 | 4 |
629135 | 629135 | 2020-10-14 | Jefferson | Indiana | 18077 | 315 | 4 |
629136 | 629136 | 2020-10-14 | Jennings | Indiana | 18079 | 348 | 15 |
629137 | 629137 | 2020-10-14 | Johnson | Indiana | 18081 | 2861 | 136 |
629138 | 629138 | 2020-10-14 | Knox | Indiana | 18083 | 616 | 10 |
629139 | 629139 | 2020-10-14 | Kosciusko | Indiana | 18085 | 1565 | 21 |
629140 | 629140 | 2020-10-14 | LaGrange | Indiana | 18087 | 737 | 14 |
629141 | 629141 | 2020-10-14 | LaPorte | Indiana | 18091 | 1932 | 50 |
629142 | 629142 | 2020-10-14 | Lake | Indiana | 18089 | 12251 | 358 |
629143 | 629143 | 2020-10-14 | Lawrence | Indiana | 18093 | 667 | 33 |
629144 | 629144 | 2020-10-14 | Madison | Indiana | 18095 | 2101 | 95 |
629145 | 629145 | 2020-10-14 | Marion | Indiana | 18097 | 23785 | 827 |
629146 | 629146 | 2020-10-14 | Marshall | Indiana | 18099 | 1218 | 26 |
629147 | 629147 | 2020-10-14 | Martin | Indiana | 18101 | 186 | 0 |
629148 | 629148 | 2020-10-14 | Miami | Indiana | 18103 | 516 | 4 |
629149 | 629149 | 2020-10-14 | Monroe | Indiana | 18105 | 3072 | 42 |
629150 | 629150 | 2020-10-14 | Montgomery | Indiana | 18107 | 542 | 23 |
629151 | 629151 | 2020-10-14 | Morgan | Indiana | 18109 | 866 | 43 |
629152 | 629152 | 2020-10-14 | Newton | Indiana | 18111 | 192 | 12 |
629153 | 629153 | 2020-10-14 | Noble | Indiana | 18113 | 1039 | 34 |
629154 | 629154 | 2020-10-14 | Ohio | Indiana | 18115 | 94 | 7 |
629155 | 629155 | 2020-10-14 | Orange | Indiana | 18117 | 352 | 26 |
629156 | 629156 | 2020-10-14 | Owen | Indiana | 18119 | 185 | 2 |
629157 | 629157 | 2020-10-14 | Parke | Indiana | 18121 | 195 | 2 |
629158 | 629158 | 2020-10-14 | Perry | Indiana | 18123 | 270 | 14 |
629159 | 629159 | 2020-10-14 | Pike | Indiana | 18125 | 292 | 8 |
629160 | 629160 | 2020-10-14 | Porter | Indiana | 18127 | 2709 | 49 |
629161 | 629161 | 2020-10-14 | Posey | Indiana | 18129 | 621 | 3 |
629162 | 629162 | 2020-10-14 | Pulaski | Indiana | 18131 | 127 | 1 |
629163 | 629163 | 2020-10-14 | Putnam | Indiana | 18133 | 678 | 15 |
629164 | 629164 | 2020-10-14 | Randolph | Indiana | 18135 | 330 | 8 |
629165 | 629165 | 2020-10-14 | Ripley | Indiana | 18137 | 383 | 8 |
629166 | 629166 | 2020-10-14 | Rush | Indiana | 18139 | 221 | 4 |
629167 | 629167 | 2020-10-14 | Scott | Indiana | 18143 | 488 | 14 |
629168 | 629168 | 2020-10-14 | Shelby | Indiana | 18145 | 1241 | 37 |
629169 | 629169 | 2020-10-14 | Spencer | Indiana | 18147 | 347 | 6 |
629170 | 629170 | 2020-10-14 | St. Joseph | Indiana | 18141 | 8211 | 154 |
629171 | 629171 | 2020-10-14 | Starke | Indiana | 18149 | 356 | 8 |
629172 | 629172 | 2020-10-14 | Steuben | Indiana | 18151 | 541 | 9 |
629173 | 629173 | 2020-10-14 | Sullivan | Indiana | 18153 | 391 | 12 |
629174 | 629174 | 2020-10-14 | Switzerland | Indiana | 18155 | 78 | 0 |
629175 | 629175 | 2020-10-14 | Tippecanoe | Indiana | 18157 | 3247 | 14 |
629176 | 629176 | 2020-10-14 | Tipton | Indiana | 18159 | 261 | 26 |
629177 | 629177 | 2020-10-14 | Union | Indiana | 18161 | 115 | 0 |
629178 | 629178 | 2020-10-14 | Vanderburgh | Indiana | 18163 | 5126 | 46 |
629179 | 629179 | 2020-10-14 | Vermillion | Indiana | 18165 | 176 | 1 |
629180 | 629180 | 2020-10-14 | Vigo | Indiana | 18167 | 2292 | 32 |
629181 | 629181 | 2020-10-14 | Wabash | Indiana | 18169 | 335 | 9 |
629182 | 629182 | 2020-10-14 | Warren | Indiana | 18171 | 61 | 1 |
629183 | 629183 | 2020-10-14 | Warrick | Indiana | 18173 | 1765 | 60 |
629184 | 629184 | 2020-10-14 | Washington | Indiana | 18175 | 317 | 2 |
629185 | 629185 | 2020-10-14 | Wayne | Indiana | 18177 | 1400 | 18 |
629186 | 629186 | 2020-10-14 | Wells | Indiana | 18179 | 367 | 5 |
629187 | 629187 | 2020-10-14 | White | Indiana | 18181 | 530 | 15 |
629188 | 629188 | 2020-10-14 | Whitley | Indiana | 18183 | 379 | 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);