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 2021-07-29 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1563921 | 1563921 | 2021-07-29 | Adams | Indiana | 18001 | 3606 | 57 |
1563922 | 1563922 | 2021-07-29 | Allen | Indiana | 18003 | 43168 | 722 |
1563923 | 1563923 | 2021-07-29 | Bartholomew | Indiana | 18005 | 8308 | 162 |
1563924 | 1563924 | 2021-07-29 | Benton | Indiana | 18007 | 1099 | 15 |
1563925 | 1563925 | 2021-07-29 | Blackford | Indiana | 18009 | 1392 | 32 |
1563926 | 1563926 | 2021-07-29 | Boone | Indiana | 18011 | 7240 | 109 |
1563927 | 1563927 | 2021-07-29 | Brown | Indiana | 18013 | 1064 | 43 |
1563928 | 1563928 | 2021-07-29 | Carroll | Indiana | 18015 | 1987 | 24 |
1563929 | 1563929 | 2021-07-29 | Cass | Indiana | 18017 | 6106 | 114 |
1563930 | 1563930 | 2021-07-29 | Clark | Indiana | 18019 | 13616 | 207 |
1563931 | 1563931 | 2021-07-29 | Clay | Indiana | 18021 | 2756 | 49 |
1563932 | 1563932 | 2021-07-29 | Clinton | Indiana | 18023 | 4579 | 60 |
1563933 | 1563933 | 2021-07-29 | Crawford | Indiana | 18025 | 1063 | 17 |
1563934 | 1563934 | 2021-07-29 | Daviess | Indiana | 18027 | 3096 | 102 |
1563935 | 1563935 | 2021-07-29 | DeKalb | Indiana | 18033 | 4582 | 88 |
1563936 | 1563936 | 2021-07-29 | Dearborn | Indiana | 18029 | 6044 | 81 |
1563937 | 1563937 | 2021-07-29 | Decatur | Indiana | 18031 | 2989 | 97 |
1563938 | 1563938 | 2021-07-29 | Delaware | Indiana | 18035 | 11185 | 205 |
1563939 | 1563939 | 2021-07-29 | Dubois | Indiana | 18037 | 6292 | 119 |
1563940 | 1563940 | 2021-07-29 | Elkhart | Indiana | 18039 | 29900 | 486 |
1563941 | 1563941 | 2021-07-29 | Fayette | Indiana | 18041 | 3008 | 66 |
1563942 | 1563942 | 2021-07-29 | Floyd | Indiana | 18043 | 8073 | 187 |
1563943 | 1563943 | 2021-07-29 | Fountain | Indiana | 18045 | 2367 | 51 |
1563944 | 1563944 | 2021-07-29 | Franklin | Indiana | 18047 | 1748 | 36 |
1563945 | 1563945 | 2021-07-29 | Fulton | Indiana | 18049 | 2092 | 45 |
1563946 | 1563946 | 2021-07-29 | Gibson | Indiana | 18051 | 4647 | 99 |
1563947 | 1563947 | 2021-07-29 | Grant | Indiana | 18053 | 7798 | 188 |
1563948 | 1563948 | 2021-07-29 | Greene | Indiana | 18055 | 2964 | 89 |
1563949 | 1563949 | 2021-07-29 | Hamilton | Indiana | 18057 | 37441 | 445 |
1563950 | 1563950 | 2021-07-29 | Hancock | Indiana | 18059 | 8803 | 154 |
1563951 | 1563951 | 2021-07-29 | Harrison | Indiana | 18061 | 4567 | 79 |
1563952 | 1563952 | 2021-07-29 | Hendricks | Indiana | 18063 | 18193 | 344 |
1563953 | 1563953 | 2021-07-29 | Henry | Indiana | 18065 | 5984 | 113 |
1563954 | 1563954 | 2021-07-29 | Howard | Indiana | 18067 | 10733 | 240 |
1563955 | 1563955 | 2021-07-29 | Huntington | Indiana | 18069 | 4198 | 84 |
1563956 | 1563956 | 2021-07-29 | Jackson | Indiana | 18071 | 5184 | 78 |
1563957 | 1563957 | 2021-07-29 | Jasper | Indiana | 18073 | 4025 | 57 |
1563958 | 1563958 | 2021-07-29 | Jay | Indiana | 18075 | 2045 | 35 |
1563959 | 1563959 | 2021-07-29 | Jefferson | Indiana | 18077 | 3454 | 88 |
1563960 | 1563960 | 2021-07-29 | Jennings | Indiana | 18079 | 2403 | 51 |
1563961 | 1563961 | 2021-07-29 | Johnson | Indiana | 18081 | 18947 | 411 |
1563962 | 1563962 | 2021-07-29 | Knox | Indiana | 18083 | 3906 | 91 |
1563963 | 1563963 | 2021-07-29 | Kosciusko | Indiana | 18085 | 9825 | 129 |
1563964 | 1563964 | 2021-07-29 | LaGrange | Indiana | 18087 | 2786 | 74 |
1563965 | 1563965 | 2021-07-29 | LaPorte | Indiana | 18091 | 12596 | 227 |
1563966 | 1563966 | 2021-07-29 | Lake | Indiana | 18089 | 57110 | 1072 |
1563967 | 1563967 | 2021-07-29 | Lawrence | Indiana | 18093 | 4949 | 130 |
1563968 | 1563968 | 2021-07-29 | Madison | Indiana | 18095 | 13620 | 367 |
1563969 | 1563969 | 2021-07-29 | Marion | Indiana | 18097 | 105966 | 1874 |
1563970 | 1563970 | 2021-07-29 | Marshall | Indiana | 18099 | 6355 | 119 |
1563971 | 1563971 | 2021-07-29 | Martin | Indiana | 18101 | 926 | 15 |
1563972 | 1563972 | 2021-07-29 | Miami | Indiana | 18103 | 4073 | 74 |
1563973 | 1563973 | 2021-07-29 | Monroe | Indiana | 18105 | 12602 | 181 |
1563974 | 1563974 | 2021-07-29 | Montgomery | Indiana | 18107 | 4606 | 94 |
1563975 | 1563975 | 2021-07-29 | Morgan | Indiana | 18109 | 6951 | 148 |
1563976 | 1563976 | 2021-07-29 | Newton | Indiana | 18111 | 1237 | 38 |
1563977 | 1563977 | 2021-07-29 | Noble | Indiana | 18113 | 6024 | 93 |
1563978 | 1563978 | 2021-07-29 | Ohio | Indiana | 18115 | 585 | 11 |
1563979 | 1563979 | 2021-07-29 | Orange | Indiana | 18117 | 1927 | 59 |
1563980 | 1563980 | 2021-07-29 | Owen | Indiana | 18119 | 2241 | 61 |
1563981 | 1563981 | 2021-07-29 | Parke | Indiana | 18121 | 1575 | 16 |
1563982 | 1563982 | 2021-07-29 | Perry | Indiana | 18123 | 1916 | 40 |
1563983 | 1563983 | 2021-07-29 | Pike | Indiana | 18125 | 1430 | 34 |
1563984 | 1563984 | 2021-07-29 | Porter | Indiana | 18127 | 19614 | 339 |
1563985 | 1563985 | 2021-07-29 | Posey | Indiana | 18129 | 2831 | 35 |
1563986 | 1563986 | 2021-07-29 | Pulaski | Indiana | 18131 | 1240 | 48 |
1563987 | 1563987 | 2021-07-29 | Putnam | Indiana | 18133 | 3869 | 62 |
1563988 | 1563988 | 2021-07-29 | Randolph | Indiana | 18135 | 2520 | 84 |
1563989 | 1563989 | 2021-07-29 | Ripley | Indiana | 18137 | 3526 | 72 |
1563990 | 1563990 | 2021-07-29 | Rush | Indiana | 18139 | 1853 | 27 |
1563991 | 1563991 | 2021-07-29 | Scott | Indiana | 18143 | 2830 | 60 |
1563992 | 1563992 | 2021-07-29 | Shelby | Indiana | 18145 | 6117 | 109 |
1563993 | 1563993 | 2021-07-29 | Spencer | Indiana | 18147 | 2395 | 31 |
1563994 | 1563994 | 2021-07-29 | St. Joseph | Indiana | 18141 | 37412 | 586 |
1563995 | 1563995 | 2021-07-29 | Starke | Indiana | 18149 | 2302 | 61 |
1563996 | 1563996 | 2021-07-29 | Steuben | Indiana | 18151 | 4123 | 62 |
1563997 | 1563997 | 2021-07-29 | Sullivan | Indiana | 18153 | 2225 | 43 |
1563998 | 1563998 | 2021-07-29 | Switzerland | Indiana | 18155 | 847 | 8 |
1563999 | 1563999 | 2021-07-29 | Tippecanoe | Indiana | 18157 | 23551 | 234 |
1564000 | 1564000 | 2021-07-29 | Tipton | Indiana | 18159 | 1739 | 50 |
1564001 | 1564001 | 2021-07-29 | Union | Indiana | 18161 | 764 | 11 |
1564002 | 1564002 | 2021-07-29 | Vanderburgh | Indiana | 18163 | 23279 | 411 |
1564003 | 1564003 | 2021-07-29 | Vermillion | Indiana | 18165 | 1816 | 44 |
1564004 | 1564004 | 2021-07-29 | Vigo | Indiana | 18167 | 12902 | 261 |
1564005 | 1564005 | 2021-07-29 | Wabash | Indiana | 18169 | 3713 | 84 |
1564006 | 1564006 | 2021-07-29 | Warren | Indiana | 18171 | 882 | 16 |
1564007 | 1564007 | 2021-07-29 | Warrick | Indiana | 18173 | 8097 | 160 |
1564008 | 1564008 | 2021-07-29 | Washington | Indiana | 18175 | 2553 | 37 |
1564009 | 1564009 | 2021-07-29 | Wayne | Indiana | 18177 | 7627 | 205 |
1564010 | 1564010 | 2021-07-29 | Wells | Indiana | 18179 | 3070 | 83 |
1564011 | 1564011 | 2021-07-29 | White | Indiana | 18181 | 3408 | 55 |
1564012 | 1564012 | 2021-07-29 | Whitley | Indiana | 18183 | 4179 | 45 |
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);