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 193
- 18063 191
- 18113 190
- 18001 188
- 18011 188
- 18067 188
- 18081 188
- 18141 188
- 18091 185
- 18179 185
- 18057 184
- 18043 183
- 18005 182
- 18047 182
- 18089 182
- 18019 181
- 18041 181
- 18079 181
- 18095 181
- 18119 180
- 18157 180
- 18177 180
- 18053 179
- 18145 179
- 18163 179
- 18167 179
- 18003 178
- 18035 178
- 18039 178
- 18059 178
- …
county >30
- Marion 193
- Hendricks 191
- Noble 190
- Adams 188
- Boone 188
- Howard 188
- Johnson 188
- St. Joseph 188
- LaPorte 185
- Wells 185
- Hamilton 184
- Floyd 183
- Bartholomew 182
- Franklin 182
- Lake 182
- Clark 181
- Fayette 181
- Jennings 181
- Madison 181
- Owen 180
- Tippecanoe 180
- Wayne 180
- Grant 179
- Shelby 179
- Vanderburgh 179
- Vigo 179
- Allen 178
- Delaware 178
- Elkhart 178
- Hancock 178
- …
state 1
- Indiana · 16,126 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531897 | 531897 | 2020-09-14 | Cass | Indiana | 18017 | 1914 | 10 |
531898 | 531898 | 2020-09-14 | Clark | Indiana | 18019 | 2019 | 60 |
531899 | 531899 | 2020-09-14 | Clay | Indiana | 18021 | 277 | 5 |
531900 | 531900 | 2020-09-14 | Clinton | Indiana | 18023 | 589 | 15 |
531901 | 531901 | 2020-09-14 | Crawford | Indiana | 18025 | 97 | 1 |
531902 | 531902 | 2020-09-14 | Daviess | Indiana | 18027 | 593 | 28 |
531903 | 531903 | 2020-09-14 | DeKalb | Indiana | 18033 | 413 | 10 |
531904 | 531904 | 2020-09-14 | Dearborn | Indiana | 18029 | 615 | 30 |
531905 | 531905 | 2020-09-14 | Decatur | Indiana | 18031 | 472 | 41 |
531906 | 531906 | 2020-09-14 | Delaware | Indiana | 18035 | 1752 | 60 |
531907 | 531907 | 2020-09-14 | Dubois | Indiana | 18037 | 909 | 18 |
531908 | 531908 | 2020-09-14 | Elkhart | Indiana | 18039 | 6161 | 108 |
531909 | 531909 | 2020-09-14 | Fayette | Indiana | 18041 | 506 | 13 |
531910 | 531910 | 2020-09-14 | Floyd | Indiana | 18043 | 1247 | 63 |
531911 | 531911 | 2020-09-14 | Fountain | Indiana | 18045 | 113 | 2 |
531912 | 531912 | 2020-09-14 | Franklin | Indiana | 18047 | 298 | 26 |
531913 | 531913 | 2020-09-14 | Fulton | Indiana | 18049 | 226 | 2 |
531914 | 531914 | 2020-09-14 | Gibson | Indiana | 18051 | 400 | 4 |
531915 | 531915 | 2020-09-14 | Grant | Indiana | 18053 | 1171 | 35 |
531916 | 531916 | 2020-09-14 | Greene | Indiana | 18055 | 405 | 38 |
531917 | 531917 | 2020-09-14 | Hamilton | Indiana | 18057 | 4568 | 117 |
531918 | 531918 | 2020-09-14 | Hancock | Indiana | 18059 | 892 | 45 |
531919 | 531919 | 2020-09-14 | Harrison | Indiana | 18061 | 536 | 26 |
531920 | 531920 | 2020-09-14 | Hendricks | Indiana | 18063 | 2595 | 136 |
531921 | 531921 | 2020-09-14 | Henry | Indiana | 18065 | 718 | 24 |
531922 | 531922 | 2020-09-14 | Howard | Indiana | 18067 | 1239 | 65 |
531923 | 531923 | 2020-09-14 | Huntington | Indiana | 18069 | 202 | 3 |
531924 | 531924 | 2020-09-14 | Jackson | Indiana | 18071 | 726 | 10 |
531925 | 531925 | 2020-09-14 | Jasper | Indiana | 18073 | 373 | 2 |
531926 | 531926 | 2020-09-14 | Jay | Indiana | 18075 | 160 | 0 |
531927 | 531927 | 2020-09-14 | Jefferson | Indiana | 18077 | 232 | 3 |
531928 | 531928 | 2020-09-14 | Jennings | Indiana | 18079 | 307 | 14 |
531929 | 531929 | 2020-09-14 | Johnson | Indiana | 18081 | 2248 | 131 |
531930 | 531930 | 2020-09-14 | Knox | Indiana | 18083 | 442 | 8 |
531931 | 531931 | 2020-09-14 | Kosciusko | Indiana | 18085 | 1169 | 19 |
531932 | 531932 | 2020-09-14 | LaGrange | Indiana | 18087 | 629 | 11 |
531933 | 531933 | 2020-09-14 | LaPorte | Indiana | 18091 | 1328 | 37 |
531934 | 531934 | 2020-09-14 | Lake | Indiana | 18089 | 9963 | 326 |
531935 | 531935 | 2020-09-14 | Lawrence | Indiana | 18093 | 495 | 30 |
531936 | 531936 | 2020-09-14 | Madison | Indiana | 18095 | 1513 | 85 |
531937 | 531937 | 2020-09-14 | Marion | Indiana | 18097 | 20314 | 806 |
531938 | 531938 | 2020-09-14 | Marshall | Indiana | 18099 | 965 | 23 |
531939 | 531939 | 2020-09-14 | Martin | Indiana | 18101 | 147 | 0 |
531940 | 531940 | 2020-09-14 | Miami | Indiana | 18103 | 421 | 2 |
531941 | 531941 | 2020-09-14 | Monroe | Indiana | 18105 | 2031 | 40 |
531942 | 531942 | 2020-09-14 | Montgomery | Indiana | 18107 | 495 | 22 |
531943 | 531943 | 2020-09-14 | Morgan | Indiana | 18109 | 678 | 39 |
531944 | 531944 | 2020-09-14 | Newton | Indiana | 18111 | 160 | 11 |
531945 | 531945 | 2020-09-14 | Noble | Indiana | 18113 | 858 | 33 |
531946 | 531946 | 2020-09-14 | Ohio | Indiana | 18115 | 75 | 7 |
531947 | 531947 | 2020-09-14 | Orange | Indiana | 18117 | 278 | 26 |
531948 | 531948 | 2020-09-14 | Owen | Indiana | 18119 | 162 | 2 |
531949 | 531949 | 2020-09-14 | Parke | Indiana | 18121 | 94 | 2 |
531950 | 531950 | 2020-09-14 | Perry | Indiana | 18123 | 211 | 15 |
531951 | 531951 | 2020-09-14 | Pike | Indiana | 18125 | 126 | 1 |
531952 | 531952 | 2020-09-14 | Porter | Indiana | 18127 | 1951 | 45 |
531953 | 531953 | 2020-09-14 | Posey | Indiana | 18129 | 280 | 0 |
531954 | 531954 | 2020-09-14 | Pulaski | Indiana | 18131 | 115 | 1 |
531955 | 531955 | 2020-09-14 | Putnam | Indiana | 18133 | 512 | 8 |
531956 | 531956 | 2020-09-14 | Randolph | Indiana | 18135 | 233 | 7 |
531957 | 531957 | 2020-09-14 | Ripley | Indiana | 18137 | 267 | 8 |
531958 | 531958 | 2020-09-14 | Rush | Indiana | 18139 | 190 | 4 |
531959 | 531959 | 2020-09-14 | Scott | Indiana | 18143 | 346 | 12 |
531960 | 531960 | 2020-09-14 | Shelby | Indiana | 18145 | 1120 | 37 |
531961 | 531961 | 2020-09-14 | Spencer | Indiana | 18147 | 191 | 3 |
531962 | 531962 | 2020-09-14 | St. Joseph | Indiana | 18141 | 5790 | 102 |
531963 | 531963 | 2020-09-14 | Starke | Indiana | 18149 | 232 | 8 |
531964 | 531964 | 2020-09-14 | Steuben | Indiana | 18151 | 343 | 7 |
531965 | 531965 | 2020-09-14 | Sullivan | Indiana | 18153 | 324 | 12 |
531966 | 531966 | 2020-09-14 | Switzerland | Indiana | 18155 | 68 | 0 |
531967 | 531967 | 2020-09-14 | Tippecanoe | Indiana | 18157 | 2001 | 14 |
531968 | 531968 | 2020-09-14 | Tipton | Indiana | 18159 | 218 | 25 |
531969 | 531969 | 2020-09-14 | Union | Indiana | 18161 | 99 | 0 |
531970 | 531970 | 2020-09-14 | Vanderburgh | Indiana | 18163 | 3058 | 24 |
531971 | 531971 | 2020-09-14 | Vermillion | Indiana | 18165 | 120 | 0 |
531972 | 531972 | 2020-09-14 | Vigo | Indiana | 18167 | 1672 | 21 |
531973 | 531973 | 2020-09-14 | Wabash | Indiana | 18169 | 255 | 7 |
531974 | 531974 | 2020-09-14 | Warren | Indiana | 18171 | 39 | 1 |
531975 | 531975 | 2020-09-14 | Warrick | Indiana | 18173 | 989 | 33 |
531976 | 531976 | 2020-09-14 | Washington | Indiana | 18175 | 245 | 1 |
531977 | 531977 | 2020-09-14 | Wayne | Indiana | 18177 | 1065 | 13 |
531978 | 531978 | 2020-09-14 | Wells | Indiana | 18179 | 251 | 2 |
531979 | 531979 | 2020-09-14 | White | Indiana | 18181 | 466 | 14 |
531980 | 531980 | 2020-09-14 | Whitley | Indiana | 18183 | 238 | 6 |
528652 | 528652 | 2020-09-13 | Adams | Indiana | 18001 | 221 | 4 |
528653 | 528653 | 2020-09-13 | Allen | Indiana | 18003 | 5655 | 203 |
528654 | 528654 | 2020-09-13 | Bartholomew | Indiana | 18005 | 1136 | 60 |
528655 | 528655 | 2020-09-13 | Benton | Indiana | 18007 | 87 | 0 |
528656 | 528656 | 2020-09-13 | Blackford | Indiana | 18009 | 105 | 2 |
528657 | 528657 | 2020-09-13 | Boone | Indiana | 18011 | 947 | 49 |
528658 | 528658 | 2020-09-13 | Brown | Indiana | 18013 | 91 | 3 |
528659 | 528659 | 2020-09-13 | Carroll | Indiana | 18015 | 265 | 13 |
528660 | 528660 | 2020-09-13 | Cass | Indiana | 18017 | 1914 | 10 |
528661 | 528661 | 2020-09-13 | Clark | Indiana | 18019 | 1993 | 60 |
528662 | 528662 | 2020-09-13 | Clay | Indiana | 18021 | 272 | 5 |
528663 | 528663 | 2020-09-13 | Clinton | Indiana | 18023 | 588 | 15 |
528664 | 528664 | 2020-09-13 | Crawford | Indiana | 18025 | 95 | 1 |
528665 | 528665 | 2020-09-13 | Daviess | Indiana | 18027 | 588 | 28 |
528666 | 528666 | 2020-09-13 | DeKalb | Indiana | 18033 | 406 | 10 |
528667 | 528667 | 2020-09-13 | Dearborn | Indiana | 18029 | 609 | 30 |
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);