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-05 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
116021 | 116021 | 2020-05-05 | Adams | Indiana | 18001 | 9 | 1 |
116022 | 116022 | 2020-05-05 | Allen | Indiana | 18003 | 700 | 60 |
116023 | 116023 | 2020-05-05 | Bartholomew | Indiana | 18005 | 300 | 20 |
116024 | 116024 | 2020-05-05 | Benton | Indiana | 18007 | 10 | 0 |
116025 | 116025 | 2020-05-05 | Blackford | Indiana | 18009 | 10 | 1 |
116026 | 116026 | 2020-05-05 | Boone | Indiana | 18011 | 217 | 29 |
116027 | 116027 | 2020-05-05 | Brown | Indiana | 18013 | 18 | 1 |
116028 | 116028 | 2020-05-05 | Carroll | Indiana | 18015 | 63 | 1 |
116029 | 116029 | 2020-05-05 | Cass | Indiana | 18017 | 1408 | 3 |
116030 | 116030 | 2020-05-05 | Clark | Indiana | 18019 | 342 | 24 |
116031 | 116031 | 2020-05-05 | Clay | Indiana | 18021 | 22 | 1 |
116032 | 116032 | 2020-05-05 | Clinton | Indiana | 18023 | 66 | 2 |
116033 | 116033 | 2020-05-05 | Crawford | Indiana | 18025 | 20 | 1 |
116034 | 116034 | 2020-05-05 | Daviess | Indiana | 18027 | 54 | 17 |
116035 | 116035 | 2020-05-05 | DeKalb | Indiana | 18033 | 23 | 2 |
116036 | 116036 | 2020-05-05 | Dearborn | Indiana | 18029 | 138 | 11 |
116037 | 116037 | 2020-05-05 | Decatur | Indiana | 18031 | 213 | 31 |
116038 | 116038 | 2020-05-05 | Delaware | Indiana | 18035 | 209 | 15 |
116039 | 116039 | 2020-05-05 | Dubois | Indiana | 18037 | 27 | 0 |
116040 | 116040 | 2020-05-05 | Elkhart | Indiana | 18039 | 345 | 13 |
116041 | 116041 | 2020-05-05 | Fayette | Indiana | 18041 | 46 | 4 |
116042 | 116042 | 2020-05-05 | Floyd | Indiana | 18043 | 213 | 28 |
116043 | 116043 | 2020-05-05 | Fountain | Indiana | 18045 | 14 | 2 |
116044 | 116044 | 2020-05-05 | Franklin | Indiana | 18047 | 101 | 7 |
116045 | 116045 | 2020-05-05 | Fulton | Indiana | 18049 | 34 | 1 |
116046 | 116046 | 2020-05-05 | Gibson | Indiana | 18051 | 7 | 0 |
116047 | 116047 | 2020-05-05 | Grant | Indiana | 18053 | 159 | 14 |
116048 | 116048 | 2020-05-05 | Greene | Indiana | 18055 | 100 | 9 |
116049 | 116049 | 2020-05-05 | Hamilton | Indiana | 18057 | 867 | 77 |
116050 | 116050 | 2020-05-05 | Hancock | Indiana | 18059 | 235 | 14 |
116051 | 116051 | 2020-05-05 | Harrison | Indiana | 18061 | 139 | 10 |
116052 | 116052 | 2020-05-05 | Hendricks | Indiana | 18063 | 801 | 54 |
116053 | 116053 | 2020-05-05 | Henry | Indiana | 18065 | 49 | 2 |
116054 | 116054 | 2020-05-05 | Howard | Indiana | 18067 | 212 | 10 |
116055 | 116055 | 2020-05-05 | Huntington | Indiana | 18069 | 11 | 2 |
116056 | 116056 | 2020-05-05 | Jackson | Indiana | 18071 | 185 | 1 |
116057 | 116057 | 2020-05-05 | Jasper | Indiana | 18073 | 38 | 1 |
116058 | 116058 | 2020-05-05 | Jay | Indiana | 18075 | 19 | 0 |
116059 | 116059 | 2020-05-05 | Jefferson | Indiana | 18077 | 31 | 0 |
116060 | 116060 | 2020-05-05 | Jennings | Indiana | 18079 | 88 | 5 |
116061 | 116061 | 2020-05-05 | Johnson | Indiana | 18081 | 739 | 80 |
116062 | 116062 | 2020-05-05 | Knox | Indiana | 18083 | 21 | 0 |
116063 | 116063 | 2020-05-05 | Kosciusko | Indiana | 18085 | 39 | 2 |
116064 | 116064 | 2020-05-05 | LaGrange | Indiana | 18087 | 34 | 2 |
116065 | 116065 | 2020-05-05 | LaPorte | Indiana | 18091 | 268 | 8 |
116066 | 116066 | 2020-05-05 | Lake | Indiana | 18089 | 2184 | 112 |
116067 | 116067 | 2020-05-05 | Lawrence | Indiana | 18093 | 110 | 15 |
116068 | 116068 | 2020-05-05 | Madison | Indiana | 18095 | 461 | 64 |
116069 | 116069 | 2020-05-05 | Marion | Indiana | 18097 | 6469 | 398 |
116070 | 116070 | 2020-05-05 | Marshall | Indiana | 18099 | 32 | 1 |
116071 | 116071 | 2020-05-05 | Martin | Indiana | 18101 | 7 | 0 |
116072 | 116072 | 2020-05-05 | Miami | Indiana | 18103 | 121 | 1 |
116073 | 116073 | 2020-05-05 | Monroe | Indiana | 18105 | 132 | 8 |
116074 | 116074 | 2020-05-05 | Montgomery | Indiana | 18107 | 106 | 2 |
116075 | 116075 | 2020-05-05 | Morgan | Indiana | 18109 | 174 | 8 |
116076 | 116076 | 2020-05-05 | Newton | Indiana | 18111 | 63 | 10 |
116077 | 116077 | 2020-05-05 | Noble | Indiana | 18113 | 123 | 15 |
116078 | 116078 | 2020-05-05 | Ohio | Indiana | 18115 | 6 | 0 |
116079 | 116079 | 2020-05-05 | Orange | Indiana | 18117 | 106 | 13 |
116080 | 116080 | 2020-05-05 | Owen | Indiana | 18119 | 24 | 1 |
116081 | 116081 | 2020-05-05 | Parke | Indiana | 18121 | 16 | 0 |
116082 | 116082 | 2020-05-05 | Perry | Indiana | 18123 | 17 | 0 |
116083 | 116083 | 2020-05-05 | Pike | Indiana | 18125 | 2 | 0 |
116084 | 116084 | 2020-05-05 | Porter | Indiana | 18127 | 271 | 8 |
116085 | 116085 | 2020-05-05 | Posey | Indiana | 18129 | 14 | 0 |
116086 | 116086 | 2020-05-05 | Pulaski | Indiana | 18131 | 29 | 0 |
116087 | 116087 | 2020-05-05 | Putnam | Indiana | 18133 | 85 | 5 |
116088 | 116088 | 2020-05-05 | Randolph | Indiana | 18135 | 27 | 2 |
116089 | 116089 | 2020-05-05 | Ripley | Indiana | 18137 | 98 | 6 |
116090 | 116090 | 2020-05-05 | Rush | Indiana | 18139 | 43 | 2 |
116091 | 116091 | 2020-05-05 | Scott | Indiana | 18143 | 54 | 2 |
116092 | 116092 | 2020-05-05 | Shelby | Indiana | 18145 | 275 | 21 |
116093 | 116093 | 2020-05-05 | Spencer | Indiana | 18147 | 8 | 1 |
116094 | 116094 | 2020-05-05 | St. Joseph | Indiana | 18141 | 693 | 26 |
116095 | 116095 | 2020-05-05 | Starke | Indiana | 18149 | 18 | 2 |
116096 | 116096 | 2020-05-05 | Steuben | Indiana | 18151 | 51 | 1 |
116097 | 116097 | 2020-05-05 | Sullivan | Indiana | 18153 | 16 | 0 |
116098 | 116098 | 2020-05-05 | Switzerland | Indiana | 18155 | 16 | 0 |
116099 | 116099 | 2020-05-05 | Tippecanoe | Indiana | 18157 | 191 | 2 |
116100 | 116100 | 2020-05-05 | Tipton | Indiana | 18159 | 20 | 1 |
116101 | 116101 | 2020-05-05 | Union | Indiana | 18161 | 15 | 0 |
116102 | 116102 | 2020-05-05 | Vanderburgh | Indiana | 18163 | 153 | 2 |
116103 | 116103 | 2020-05-05 | Vermillion | Indiana | 18165 | 8 | 0 |
116104 | 116104 | 2020-05-05 | Vigo | Indiana | 18167 | 71 | 6 |
116105 | 116105 | 2020-05-05 | Wabash | Indiana | 18169 | 63 | 2 |
116106 | 116106 | 2020-05-05 | Warren | Indiana | 18171 | 13 | 1 |
116107 | 116107 | 2020-05-05 | Warrick | Indiana | 18173 | 106 | 18 |
116108 | 116108 | 2020-05-05 | Washington | Indiana | 18175 | 45 | 0 |
116109 | 116109 | 2020-05-05 | Wayne | Indiana | 18177 | 114 | 3 |
116110 | 116110 | 2020-05-05 | Wells | Indiana | 18179 | 7 | 0 |
116111 | 116111 | 2020-05-05 | White | Indiana | 18181 | 100 | 0 |
116112 | 116112 | 2020-05-05 | 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);