ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-01-12" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921140 | 921140 | 2021-01-12 | Adams | Indiana | 18001 | 2876 | 36 |
921141 | 921141 | 2021-01-12 | Allen | Indiana | 18003 | 31055 | 552 |
921142 | 921142 | 2021-01-12 | Bartholomew | Indiana | 18005 | 6110 | 99 |
921143 | 921143 | 2021-01-12 | Benton | Indiana | 18007 | 823 | 10 |
921144 | 921144 | 2021-01-12 | Blackford | Indiana | 18009 | 1052 | 22 |
921145 | 921145 | 2021-01-12 | Boone | Indiana | 18011 | 5190 | 69 |
921146 | 921146 | 2021-01-12 | Brown | Indiana | 18013 | 839 | 28 |
921147 | 921147 | 2021-01-12 | Carroll | Indiana | 18015 | 1486 | 16 |
921148 | 921148 | 2021-01-12 | Cass | Indiana | 18017 | 4602 | 60 |
921149 | 921149 | 2021-01-12 | Clark | Indiana | 18019 | 9778 | 133 |
921150 | 921150 | 2021-01-12 | Clay | Indiana | 18021 | 2090 | 32 |
921151 | 921151 | 2021-01-12 | Clinton | Indiana | 18023 | 3564 | 42 |
921152 | 921152 | 2021-01-12 | Crawford | Indiana | 18025 | 705 | 10 |
921153 | 921153 | 2021-01-12 | Daviess | Indiana | 18027 | 2524 | 73 |
921154 | 921154 | 2021-01-12 | DeKalb | Indiana | 18033 | 3297 | 66 |
921155 | 921155 | 2021-01-12 | Dearborn | Indiana | 18029 | 4374 | 43 |
921156 | 921156 | 2021-01-12 | Decatur | Indiana | 18031 | 2392 | 85 |
921157 | 921157 | 2021-01-12 | Delaware | Indiana | 18035 | 8508 | 133 |
921158 | 921158 | 2021-01-12 | Dubois | Indiana | 18037 | 5235 | 71 |
921159 | 921159 | 2021-01-12 | Elkhart | Indiana | 18039 | 23783 | 346 |
921160 | 921160 | 2021-01-12 | Fayette | Indiana | 18041 | 2494 | 49 |
921161 | 921161 | 2021-01-12 | Floyd | Indiana | 18043 | 5862 | 110 |
921162 | 921162 | 2021-01-12 | Fountain | Indiana | 18045 | 1715 | 26 |
921163 | 921163 | 2021-01-12 | Franklin | Indiana | 18047 | 1391 | 33 |
921164 | 921164 | 2021-01-12 | Fulton | Indiana | 18049 | 1552 | 29 |
921165 | 921165 | 2021-01-12 | Gibson | Indiana | 18051 | 3418 | 57 |
921166 | 921166 | 2021-01-12 | Grant | Indiana | 18053 | 6036 | 113 |
921167 | 921167 | 2021-01-12 | Greene | Indiana | 18055 | 2263 | 61 |
921168 | 921168 | 2021-01-12 | Hamilton | Indiana | 18057 | 27267 | 312 |
921169 | 921169 | 2021-01-12 | Hancock | Indiana | 18059 | 6126 | 94 |
921170 | 921170 | 2021-01-12 | Harrison | Indiana | 18061 | 3115 | 44 |
921171 | 921171 | 2021-01-12 | Hendricks | Indiana | 18063 | 13317 | 251 |
921172 | 921172 | 2021-01-12 | Henry | Indiana | 18065 | 4785 | 62 |
921173 | 921173 | 2021-01-12 | Howard | Indiana | 18067 | 7572 | 137 |
921174 | 921174 | 2021-01-12 | Huntington | Indiana | 18069 | 2749 | 56 |
921175 | 921175 | 2021-01-12 | Jackson | Indiana | 18071 | 4058 | 46 |
921176 | 921176 | 2021-01-12 | Jasper | Indiana | 18073 | 2723 | 35 |
921177 | 921177 | 2021-01-12 | Jay | Indiana | 18075 | 1605 | 23 |
921178 | 921178 | 2021-01-12 | Jefferson | Indiana | 18077 | 2391 | 42 |
921179 | 921179 | 2021-01-12 | Jennings | Indiana | 18079 | 1865 | 37 |
921180 | 921180 | 2021-01-12 | Johnson | Indiana | 18081 | 13969 | 285 |
921181 | 921181 | 2021-01-12 | Knox | Indiana | 18083 | 3165 | 39 |
921182 | 921182 | 2021-01-12 | Kosciusko | Indiana | 18085 | 7688 | 78 |
921183 | 921183 | 2021-01-12 | LaGrange | Indiana | 18087 | 2208 | 62 |
921184 | 921184 | 2021-01-12 | LaPorte | Indiana | 18091 | 8420 | 155 |
921185 | 921185 | 2021-01-12 | Lake | Indiana | 18089 | 43268 | 681 |
921186 | 921186 | 2021-01-12 | Lawrence | Indiana | 18093 | 3699 | 74 |
921187 | 921187 | 2021-01-12 | Madison | Indiana | 18095 | 10196 | 223 |
921188 | 921188 | 2021-01-12 | Marion | Indiana | 18097 | 79099 | 1329 |
921189 | 921189 | 2021-01-12 | Marshall | Indiana | 18099 | 4819 | 84 |
921190 | 921190 | 2021-01-12 | Martin | Indiana | 18101 | 679 | 13 |
921191 | 921191 | 2021-01-12 | Miami | Indiana | 18103 | 2996 | 43 |
921192 | 921192 | 2021-01-12 | Monroe | Indiana | 18105 | 8815 | 106 |
921193 | 921193 | 2021-01-12 | Montgomery | Indiana | 18107 | 3203 | 51 |
921194 | 921194 | 2021-01-12 | Morgan | Indiana | 18109 | 4958 | 89 |
921195 | 921195 | 2021-01-12 | Newton | Indiana | 18111 | 873 | 22 |
921196 | 921196 | 2021-01-12 | Noble | Indiana | 18113 | 4498 | 59 |
921197 | 921197 | 2021-01-12 | Ohio | Indiana | 18115 | 445 | 7 |
921198 | 921198 | 2021-01-12 | Orange | Indiana | 18117 | 1440 | 35 |
921199 | 921199 | 2021-01-12 | Owen | Indiana | 18119 | 1542 | 36 |
921200 | 921200 | 2021-01-12 | Parke | Indiana | 18121 | 1269 | 8 |
921201 | 921201 | 2021-01-12 | Perry | Indiana | 18123 | 1400 | 27 |
921202 | 921202 | 2021-01-12 | Pike | Indiana | 18125 | 1073 | 27 |
921203 | 921203 | 2021-01-12 | Porter | Indiana | 18127 | 14025 | 167 |
921204 | 921204 | 2021-01-12 | Posey | Indiana | 18129 | 2210 | 26 |
921205 | 921205 | 2021-01-12 | Pulaski | Indiana | 18131 | 926 | 35 |
921206 | 921206 | 2021-01-12 | Putnam | Indiana | 18133 | 2738 | 45 |
921207 | 921207 | 2021-01-12 | Randolph | Indiana | 18135 | 2061 | 41 |
921208 | 921208 | 2021-01-12 | Ripley | Indiana | 18137 | 2831 | 45 |
921209 | 921209 | 2021-01-12 | Rush | Indiana | 18139 | 1475 | 19 |
921210 | 921210 | 2021-01-12 | Scott | Indiana | 18143 | 2103 | 39 |
921211 | 921211 | 2021-01-12 | Shelby | Indiana | 18145 | 4722 | 84 |
921212 | 921212 | 2021-01-12 | Spencer | Indiana | 18147 | 1747 | 17 |
921213 | 921213 | 2021-01-12 | St. Joseph | Indiana | 18141 | 26101 | 388 |
921214 | 921214 | 2021-01-12 | Starke | Indiana | 18149 | 1681 | 44 |
921215 | 921215 | 2021-01-12 | Steuben | Indiana | 18151 | 2977 | 41 |
921216 | 921216 | 2021-01-12 | Sullivan | Indiana | 18153 | 1845 | 31 |
921217 | 921217 | 2021-01-12 | Switzerland | Indiana | 18155 | 580 | 5 |
921218 | 921218 | 2021-01-12 | Tippecanoe | Indiana | 18157 | 16811 | 115 |
921219 | 921219 | 2021-01-12 | Tipton | Indiana | 18159 | 1248 | 35 |
921220 | 921220 | 2021-01-12 | Union | Indiana | 18161 | 624 | 2 |
921221 | 921221 | 2021-01-12 | Vanderburgh | Indiana | 18163 | 17871 | 213 |
921222 | 921222 | 2021-01-12 | Vermillion | Indiana | 18165 | 1403 | 33 |
921223 | 921223 | 2021-01-12 | Vigo | Indiana | 18167 | 10207 | 175 |
921224 | 921224 | 2021-01-12 | Wabash | Indiana | 18169 | 2825 | 45 |
921225 | 921225 | 2021-01-12 | Warren | Indiana | 18171 | 636 | 8 |
921226 | 921226 | 2021-01-12 | Warrick | Indiana | 18173 | 6112 | 92 |
921227 | 921227 | 2021-01-12 | Washington | Indiana | 18175 | 1671 | 16 |
921228 | 921228 | 2021-01-12 | Wayne | Indiana | 18177 | 6122 | 156 |
921229 | 921229 | 2021-01-12 | Wells | Indiana | 18179 | 2232 | 49 |
921230 | 921230 | 2021-01-12 | White | Indiana | 18181 | 2595 | 38 |
921231 | 921231 | 2021-01-12 | Whitley | Indiana | 18183 | 2817 | 24 |
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);