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
county >30
- Marion 111
- Hendricks 109
- Noble 108
- Adams 107
- Boone 107
- Howard 106
- Johnson 106
- St. Joseph 106
- LaPorte 103
- Wells 103
- Hamilton 102
- Bartholomew 101
- Floyd 101
- Franklin 100
- Lake 100
- Clark 99
- Fayette 99
- Jennings 99
- Madison 99
- Owen 98
- Tippecanoe 98
- Wayne 98
- Allen 97
- Grant 97
- Shelby 97
- Vanderburgh 97
- Vigo 97
- Delaware 96
- Elkhart 96
- Hancock 96
- …
state 1
- Indiana · 8,590 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
268900 | 268900 | 2020-06-24 | Adams | Indiana | 18001 | 39 | 2 |
268901 | 268901 | 2020-06-24 | Allen | Indiana | 18003 | 2485 | 107 |
268902 | 268902 | 2020-06-24 | Bartholomew | Indiana | 18005 | 573 | 46 |
268903 | 268903 | 2020-06-24 | Benton | Indiana | 18007 | 44 | 0 |
268904 | 268904 | 2020-06-24 | Blackford | Indiana | 18009 | 36 | 2 |
268905 | 268905 | 2020-06-24 | Boone | Indiana | 18011 | 418 | 44 |
268906 | 268906 | 2020-06-24 | Brown | Indiana | 18013 | 37 | 1 |
268907 | 268907 | 2020-06-24 | Carroll | Indiana | 18015 | 103 | 2 |
268908 | 268908 | 2020-06-24 | Cass | Indiana | 18017 | 1628 | 10 |
268909 | 268909 | 2020-06-24 | Clark | Indiana | 18019 | 610 | 50 |
268910 | 268910 | 2020-06-24 | Clay | Indiana | 18021 | 56 | 4 |
268911 | 268911 | 2020-06-24 | Clinton | Indiana | 18023 | 275 | 2 |
268912 | 268912 | 2020-06-24 | Crawford | Indiana | 18025 | 28 | 1 |
268913 | 268913 | 2020-06-24 | Daviess | Indiana | 18027 | 134 | 18 |
268914 | 268914 | 2020-06-24 | DeKalb | Indiana | 18033 | 141 | 5 |
268915 | 268915 | 2020-06-24 | Dearborn | Indiana | 18029 | 191 | 24 |
268916 | 268916 | 2020-06-24 | Decatur | Indiana | 18031 | 256 | 35 |
268917 | 268917 | 2020-06-24 | Delaware | Indiana | 18035 | 414 | 48 |
268918 | 268918 | 2020-06-24 | Dubois | Indiana | 18037 | 255 | 6 |
268919 | 268919 | 2020-06-24 | Elkhart | Indiana | 18039 | 2761 | 43 |
268920 | 268920 | 2020-06-24 | Fayette | Indiana | 18041 | 136 | 7 |
268921 | 268921 | 2020-06-24 | Floyd | Indiana | 18043 | 353 | 45 |
268922 | 268922 | 2020-06-24 | Fountain | Indiana | 18045 | 24 | 2 |
268923 | 268923 | 2020-06-24 | Franklin | Indiana | 18047 | 128 | 9 |
268924 | 268924 | 2020-06-24 | Fulton | Indiana | 18049 | 64 | 1 |
268925 | 268925 | 2020-06-24 | Gibson | Indiana | 18051 | 29 | 2 |
268926 | 268926 | 2020-06-24 | Grant | Indiana | 18053 | 364 | 29 |
268927 | 268927 | 2020-06-24 | Greene | Indiana | 18055 | 189 | 32 |
268928 | 268928 | 2020-06-24 | Hamilton | Indiana | 18057 | 1412 | 102 |
268929 | 268929 | 2020-06-24 | Hancock | Indiana | 18059 | 399 | 35 |
268930 | 268930 | 2020-06-24 | Harrison | Indiana | 18061 | 203 | 24 |
268931 | 268931 | 2020-06-24 | Hendricks | Indiana | 18063 | 1361 | 111 |
268932 | 268932 | 2020-06-24 | Henry | Indiana | 18065 | 216 | 15 |
268933 | 268933 | 2020-06-24 | Howard | Indiana | 18067 | 514 | 53 |
268934 | 268934 | 2020-06-24 | Huntington | Indiana | 18069 | 63 | 2 |
268935 | 268935 | 2020-06-24 | Jackson | Indiana | 18071 | 437 | 4 |
268936 | 268936 | 2020-06-24 | Jasper | Indiana | 18073 | 97 | 2 |
268937 | 268937 | 2020-06-24 | Jay | Indiana | 18075 | 70 | 0 |
268938 | 268938 | 2020-06-24 | Jefferson | Indiana | 18077 | 59 | 1 |
268939 | 268939 | 2020-06-24 | Jennings | Indiana | 18079 | 166 | 11 |
268940 | 268940 | 2020-06-24 | Johnson | Indiana | 18081 | 1233 | 125 |
268941 | 268941 | 2020-06-24 | Knox | Indiana | 18083 | 48 | 0 |
268942 | 268942 | 2020-06-24 | Kosciusko | Indiana | 18085 | 410 | 3 |
268943 | 268943 | 2020-06-24 | LaGrange | Indiana | 18087 | 414 | 6 |
268944 | 268944 | 2020-06-24 | LaPorte | Indiana | 18091 | 496 | 25 |
268945 | 268945 | 2020-06-24 | Lake | Indiana | 18089 | 4562 | 254 |
268946 | 268946 | 2020-06-24 | Lawrence | Indiana | 18093 | 198 | 25 |
268947 | 268947 | 2020-06-24 | Madison | Indiana | 18095 | 634 | 73 |
268948 | 268948 | 2020-06-24 | Marion | Indiana | 18097 | 11118 | 720 |
268949 | 268949 | 2020-06-24 | Marshall | Indiana | 18099 | 374 | 3 |
268950 | 268950 | 2020-06-24 | Martin | Indiana | 18101 | 22 | 0 |
268951 | 268951 | 2020-06-24 | Miami | Indiana | 18103 | 179 | 2 |
268952 | 268952 | 2020-06-24 | Monroe | Indiana | 18105 | 216 | 28 |
268953 | 268953 | 2020-06-24 | Montgomery | Indiana | 18107 | 277 | 20 |
268954 | 268954 | 2020-06-24 | Morgan | Indiana | 18109 | 317 | 33 |
268955 | 268955 | 2020-06-24 | Newton | Indiana | 18111 | 91 | 11 |
268956 | 268956 | 2020-06-24 | Noble | Indiana | 18113 | 385 | 29 |
268957 | 268957 | 2020-06-24 | Ohio | Indiana | 18115 | 13 | 0 |
268958 | 268958 | 2020-06-24 | Orange | Indiana | 18117 | 134 | 25 |
268959 | 268959 | 2020-06-24 | Owen | Indiana | 18119 | 40 | 1 |
268960 | 268960 | 2020-06-24 | Parke | Indiana | 18121 | 25 | 0 |
268961 | 268961 | 2020-06-24 | Perry | Indiana | 18123 | 119 | 5 |
268962 | 268962 | 2020-06-24 | Pike | Indiana | 18125 | 6 | 0 |
268963 | 268963 | 2020-06-24 | Porter | Indiana | 18127 | 638 | 38 |
268964 | 268964 | 2020-06-24 | Posey | Indiana | 18129 | 26 | 0 |
268965 | 268965 | 2020-06-24 | Pulaski | Indiana | 18131 | 55 | 1 |
268966 | 268966 | 2020-06-24 | Putnam | Indiana | 18133 | 164 | 8 |
268967 | 268967 | 2020-06-24 | Randolph | Indiana | 18135 | 99 | 4 |
268968 | 268968 | 2020-06-24 | Ripley | Indiana | 18137 | 113 | 7 |
268969 | 268969 | 2020-06-24 | Rush | Indiana | 18139 | 74 | 3 |
268970 | 268970 | 2020-06-24 | Scott | Indiana | 18143 | 154 | 7 |
268971 | 268971 | 2020-06-24 | Shelby | Indiana | 18145 | 622 | 31 |
268972 | 268972 | 2020-06-24 | Spencer | Indiana | 18147 | 30 | 1 |
268973 | 268973 | 2020-06-24 | St. Joseph | Indiana | 18141 | 1715 | 64 |
268974 | 268974 | 2020-06-24 | Starke | Indiana | 18149 | 64 | 4 |
268975 | 268975 | 2020-06-24 | Steuben | Indiana | 18151 | 112 | 2 |
268976 | 268976 | 2020-06-24 | Sullivan | Indiana | 18153 | 43 | 1 |
268977 | 268977 | 2020-06-24 | Switzerland | Indiana | 18155 | 24 | 0 |
268978 | 268978 | 2020-06-24 | Tippecanoe | Indiana | 18157 | 547 | 9 |
268979 | 268979 | 2020-06-24 | Tipton | Indiana | 18159 | 29 | 2 |
268980 | 268980 | 2020-06-24 | Union | Indiana | 18161 | 28 | 0 |
268981 | 268981 | 2020-06-24 | Vanderburgh | Indiana | 18163 | 362 | 6 |
268982 | 268982 | 2020-06-24 | Vermillion | Indiana | 18165 | 14 | 0 |
268983 | 268983 | 2020-06-24 | Vigo | Indiana | 18167 | 215 | 9 |
268984 | 268984 | 2020-06-24 | Wabash | Indiana | 18169 | 98 | 2 |
268985 | 268985 | 2020-06-24 | Warren | Indiana | 18171 | 15 | 1 |
268986 | 268986 | 2020-06-24 | Warrick | Indiana | 18173 | 184 | 31 |
268987 | 268987 | 2020-06-24 | Washington | Indiana | 18175 | 62 | 1 |
268988 | 268988 | 2020-06-24 | Wayne | Indiana | 18177 | 290 | 6 |
268989 | 268989 | 2020-06-24 | Wells | Indiana | 18179 | 83 | 1 |
268990 | 268990 | 2020-06-24 | White | Indiana | 18181 | 249 | 10 |
268991 | 268991 | 2020-06-24 | Whitley | Indiana | 18183 | 72 | 4 |
265770 | 265770 | 2020-06-23 | Adams | Indiana | 18001 | 37 | 2 |
265771 | 265771 | 2020-06-23 | Allen | Indiana | 18003 | 2451 | 107 |
265772 | 265772 | 2020-06-23 | Bartholomew | Indiana | 18005 | 573 | 46 |
265773 | 265773 | 2020-06-23 | Benton | Indiana | 18007 | 44 | 0 |
265774 | 265774 | 2020-06-23 | Blackford | Indiana | 18009 | 36 | 2 |
265775 | 265775 | 2020-06-23 | Boone | Indiana | 18011 | 414 | 44 |
265776 | 265776 | 2020-06-23 | Brown | Indiana | 18013 | 37 | 1 |
265777 | 265777 | 2020-06-23 | Carroll | Indiana | 18015 | 103 | 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);