ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71,921 rows where state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 18097 131
- 18063 129
- 18113 128
- 18001 127
- 18011 127
- 18067 126
- 18081 126
- 18141 126
- 18091 123
- 18179 123
- 18057 122
- 18005 121
- 18043 121
- 18047 120
- 18089 120
- 18019 119
- 18041 119
- 18079 119
- 18095 119
- 18119 118
- 18157 118
- 18177 118
- 18003 117
- 18053 117
- 18145 117
- 18163 117
- 18167 117
- 18035 116
- 18039 116
- 18059 116
- …
county >30
- Marion 131
- Hendricks 129
- Noble 128
- Adams 127
- Boone 127
- Howard 126
- Johnson 126
- St. Joseph 126
- LaPorte 123
- Wells 123
- Hamilton 122
- Bartholomew 121
- Floyd 121
- Franklin 120
- Lake 120
- Clark 119
- Fayette 119
- Jennings 119
- Madison 119
- Owen 118
- Tippecanoe 118
- Wayne 118
- Allen 117
- Grant 117
- Shelby 117
- Vanderburgh 117
- Vigo 117
- Delaware 116
- Elkhart 116
- Hancock 116
- …
state 1
- Indiana · 10,430 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
332140 | 332140 | 2020-07-14 | Adams | Indiana | 18001 | 50 | 2 |
332141 | 332141 | 2020-07-14 | Allen | Indiana | 18003 | 3007 | 145 |
332142 | 332142 | 2020-07-14 | Bartholomew | Indiana | 18005 | 615 | 48 |
332143 | 332143 | 2020-07-14 | Benton | Indiana | 18007 | 51 | 0 |
332144 | 332144 | 2020-07-14 | Blackford | Indiana | 18009 | 46 | 2 |
332145 | 332145 | 2020-07-14 | Boone | Indiana | 18011 | 515 | 47 |
332146 | 332146 | 2020-07-14 | Brown | Indiana | 18013 | 46 | 1 |
332147 | 332147 | 2020-07-14 | Carroll | Indiana | 18015 | 114 | 2 |
332148 | 332148 | 2020-07-14 | Cass | Indiana | 18017 | 1654 | 10 |
332149 | 332149 | 2020-07-14 | Clark | Indiana | 18019 | 743 | 51 |
332150 | 332150 | 2020-07-14 | Clay | Indiana | 18021 | 65 | 5 |
332151 | 332151 | 2020-07-14 | Clinton | Indiana | 18023 | 292 | 4 |
332152 | 332152 | 2020-07-14 | Crawford | Indiana | 18025 | 36 | 1 |
332153 | 332153 | 2020-07-14 | Daviess | Indiana | 18027 | 153 | 19 |
332154 | 332154 | 2020-07-14 | DeKalb | Indiana | 18033 | 172 | 5 |
332155 | 332155 | 2020-07-14 | Dearborn | Indiana | 18029 | 279 | 24 |
332156 | 332156 | 2020-07-14 | Decatur | Indiana | 18031 | 275 | 35 |
332157 | 332157 | 2020-07-14 | Delaware | Indiana | 18035 | 486 | 53 |
332158 | 332158 | 2020-07-14 | Dubois | Indiana | 18037 | 344 | 7 |
332159 | 332159 | 2020-07-14 | Elkhart | Indiana | 18039 | 3806 | 65 |
332160 | 332160 | 2020-07-14 | Fayette | Indiana | 18041 | 161 | 7 |
332161 | 332161 | 2020-07-14 | Floyd | Indiana | 18043 | 427 | 46 |
332162 | 332162 | 2020-07-14 | Fountain | Indiana | 18045 | 38 | 2 |
332163 | 332163 | 2020-07-14 | Franklin | Indiana | 18047 | 136 | 9 |
332164 | 332164 | 2020-07-14 | Fulton | Indiana | 18049 | 79 | 1 |
332165 | 332165 | 2020-07-14 | Gibson | Indiana | 18051 | 133 | 2 |
332166 | 332166 | 2020-07-14 | Grant | Indiana | 18053 | 476 | 29 |
332167 | 332167 | 2020-07-14 | Greene | Indiana | 18055 | 205 | 35 |
332168 | 332168 | 2020-07-14 | Hamilton | Indiana | 18057 | 1801 | 107 |
332169 | 332169 | 2020-07-14 | Hancock | Indiana | 18059 | 477 | 37 |
332170 | 332170 | 2020-07-14 | Harrison | Indiana | 18061 | 222 | 24 |
332171 | 332171 | 2020-07-14 | Hendricks | Indiana | 18063 | 1506 | 116 |
332172 | 332172 | 2020-07-14 | Henry | Indiana | 18065 | 312 | 18 |
332173 | 332173 | 2020-07-14 | Howard | Indiana | 18067 | 622 | 61 |
332174 | 332174 | 2020-07-14 | Huntington | Indiana | 18069 | 94 | 2 |
332175 | 332175 | 2020-07-14 | Jackson | Indiana | 18071 | 485 | 4 |
332176 | 332176 | 2020-07-14 | Jasper | Indiana | 18073 | 143 | 2 |
332177 | 332177 | 2020-07-14 | Jay | Indiana | 18075 | 77 | 0 |
332178 | 332178 | 2020-07-14 | Jefferson | Indiana | 18077 | 94 | 2 |
332179 | 332179 | 2020-07-14 | Jennings | Indiana | 18079 | 182 | 14 |
332180 | 332180 | 2020-07-14 | Johnson | Indiana | 18081 | 1397 | 126 |
332181 | 332181 | 2020-07-14 | Knox | Indiana | 18083 | 74 | 0 |
332182 | 332182 | 2020-07-14 | Kosciusko | Indiana | 18085 | 592 | 5 |
332183 | 332183 | 2020-07-14 | LaGrange | Indiana | 18087 | 493 | 10 |
332184 | 332184 | 2020-07-14 | LaPorte | Indiana | 18091 | 641 | 28 |
332185 | 332185 | 2020-07-14 | Lake | Indiana | 18089 | 5803 | 267 |
332186 | 332186 | 2020-07-14 | Lawrence | Indiana | 18093 | 254 | 26 |
332187 | 332187 | 2020-07-14 | Madison | Indiana | 18095 | 697 | 74 |
332188 | 332188 | 2020-07-14 | Marion | Indiana | 18097 | 12323 | 743 |
332189 | 332189 | 2020-07-14 | Marshall | Indiana | 18099 | 574 | 12 |
332190 | 332190 | 2020-07-14 | Martin | Indiana | 18101 | 26 | 0 |
332191 | 332191 | 2020-07-14 | Miami | Indiana | 18103 | 200 | 2 |
332192 | 332192 | 2020-07-14 | Monroe | Indiana | 18105 | 377 | 30 |
332193 | 332193 | 2020-07-14 | Montgomery | Indiana | 18107 | 299 | 21 |
332194 | 332194 | 2020-07-14 | Morgan | Indiana | 18109 | 355 | 34 |
332195 | 332195 | 2020-07-14 | Newton | Indiana | 18111 | 102 | 11 |
332196 | 332196 | 2020-07-14 | Noble | Indiana | 18113 | 530 | 29 |
332197 | 332197 | 2020-07-14 | Ohio | Indiana | 18115 | 23 | 0 |
332198 | 332198 | 2020-07-14 | Orange | Indiana | 18117 | 142 | 25 |
332199 | 332199 | 2020-07-14 | Owen | Indiana | 18119 | 54 | 1 |
332200 | 332200 | 2020-07-14 | Parke | Indiana | 18121 | 33 | 0 |
332201 | 332201 | 2020-07-14 | Perry | Indiana | 18123 | 171 | 11 |
332202 | 332202 | 2020-07-14 | Pike | Indiana | 18125 | 15 | 0 |
332203 | 332203 | 2020-07-14 | Porter | Indiana | 18127 | 875 | 40 |
332204 | 332204 | 2020-07-14 | Posey | Indiana | 18129 | 68 | 0 |
332205 | 332205 | 2020-07-14 | Pulaski | Indiana | 18131 | 67 | 1 |
332206 | 332206 | 2020-07-14 | Putnam | Indiana | 18133 | 180 | 8 |
332207 | 332207 | 2020-07-14 | Randolph | Indiana | 18135 | 108 | 4 |
332208 | 332208 | 2020-07-14 | Ripley | Indiana | 18137 | 135 | 7 |
332209 | 332209 | 2020-07-14 | Rush | Indiana | 18139 | 89 | 3 |
332210 | 332210 | 2020-07-14 | Scott | Indiana | 18143 | 170 | 10 |
332211 | 332211 | 2020-07-14 | Shelby | Indiana | 18145 | 710 | 32 |
332212 | 332212 | 2020-07-14 | Spencer | Indiana | 18147 | 65 | 1 |
332213 | 332213 | 2020-07-14 | St. Joseph | Indiana | 18141 | 2245 | 75 |
332214 | 332214 | 2020-07-14 | Starke | Indiana | 18149 | 112 | 4 |
332215 | 332215 | 2020-07-14 | Steuben | Indiana | 18151 | 140 | 3 |
332216 | 332216 | 2020-07-14 | Sullivan | Indiana | 18153 | 56 | 1 |
332217 | 332217 | 2020-07-14 | Switzerland | Indiana | 18155 | 34 | 0 |
332218 | 332218 | 2020-07-14 | Tippecanoe | Indiana | 18157 | 798 | 11 |
332219 | 332219 | 2020-07-14 | Tipton | Indiana | 18159 | 37 | 2 |
332220 | 332220 | 2020-07-14 | Union | Indiana | 18161 | 33 | 0 |
332221 | 332221 | 2020-07-14 | Vanderburgh | Indiana | 18163 | 861 | 6 |
332222 | 332222 | 2020-07-14 | Vermillion | Indiana | 18165 | 21 | 0 |
332223 | 332223 | 2020-07-14 | Vigo | Indiana | 18167 | 264 | 9 |
332224 | 332224 | 2020-07-14 | Wabash | Indiana | 18169 | 123 | 3 |
332225 | 332225 | 2020-07-14 | Warren | Indiana | 18171 | 17 | 1 |
332226 | 332226 | 2020-07-14 | Warrick | Indiana | 18173 | 281 | 31 |
332227 | 332227 | 2020-07-14 | Washington | Indiana | 18175 | 68 | 1 |
332228 | 332228 | 2020-07-14 | Wayne | Indiana | 18177 | 360 | 6 |
332229 | 332229 | 2020-07-14 | Wells | Indiana | 18179 | 101 | 1 |
332230 | 332230 | 2020-07-14 | White | Indiana | 18181 | 281 | 10 |
332231 | 332231 | 2020-07-14 | Whitley | Indiana | 18183 | 108 | 6 |
328953 | 328953 | 2020-07-13 | Adams | Indiana | 18001 | 50 | 2 |
328954 | 328954 | 2020-07-13 | Allen | Indiana | 18003 | 2990 | 144 |
328955 | 328955 | 2020-07-13 | Bartholomew | Indiana | 18005 | 611 | 48 |
328956 | 328956 | 2020-07-13 | Benton | Indiana | 18007 | 51 | 0 |
328957 | 328957 | 2020-07-13 | Blackford | Indiana | 18009 | 44 | 2 |
328958 | 328958 | 2020-07-13 | Boone | Indiana | 18011 | 510 | 47 |
328959 | 328959 | 2020-07-13 | Brown | Indiana | 18013 | 44 | 1 |
328960 | 328960 | 2020-07-13 | Carroll | Indiana | 18015 | 114 | 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);