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 2020-05-11 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
133899 | 133899 | 2020-05-11 | Adams | Indiana | 18001 | 8 | 1 |
133900 | 133900 | 2020-05-11 | Allen | Indiana | 18003 | 839 | 64 |
133901 | 133901 | 2020-05-11 | Bartholomew | Indiana | 18005 | 363 | 29 |
133902 | 133902 | 2020-05-11 | Benton | Indiana | 18007 | 13 | 0 |
133903 | 133903 | 2020-05-11 | Blackford | Indiana | 18009 | 14 | 1 |
133904 | 133904 | 2020-05-11 | Boone | Indiana | 18011 | 240 | 34 |
133905 | 133905 | 2020-05-11 | Brown | Indiana | 18013 | 26 | 1 |
133906 | 133906 | 2020-05-11 | Carroll | Indiana | 18015 | 71 | 2 |
133907 | 133907 | 2020-05-11 | Cass | Indiana | 18017 | 1526 | 4 |
133908 | 133908 | 2020-05-11 | Clark | Indiana | 18019 | 385 | 30 |
133909 | 133909 | 2020-05-11 | Clay | Indiana | 18021 | 24 | 1 |
133910 | 133910 | 2020-05-11 | Clinton | Indiana | 18023 | 97 | 2 |
133911 | 133911 | 2020-05-11 | Crawford | Indiana | 18025 | 21 | 1 |
133912 | 133912 | 2020-05-11 | Daviess | Indiana | 18027 | 56 | 17 |
133913 | 133913 | 2020-05-11 | DeKalb | Indiana | 18033 | 24 | 2 |
133914 | 133914 | 2020-05-11 | Dearborn | Indiana | 18029 | 151 | 13 |
133915 | 133915 | 2020-05-11 | Decatur | Indiana | 18031 | 223 | 32 |
133916 | 133916 | 2020-05-11 | Delaware | Indiana | 18035 | 229 | 19 |
133917 | 133917 | 2020-05-11 | Dubois | Indiana | 18037 | 46 | 0 |
133918 | 133918 | 2020-05-11 | Elkhart | Indiana | 18039 | 497 | 18 |
133919 | 133919 | 2020-05-11 | Fayette | Indiana | 18041 | 64 | 4 |
133920 | 133920 | 2020-05-11 | Floyd | Indiana | 18043 | 233 | 30 |
133921 | 133921 | 2020-05-11 | Fountain | Indiana | 18045 | 16 | 2 |
133922 | 133922 | 2020-05-11 | Franklin | Indiana | 18047 | 109 | 8 |
133923 | 133923 | 2020-05-11 | Fulton | Indiana | 18049 | 36 | 1 |
133924 | 133924 | 2020-05-11 | Gibson | Indiana | 18051 | 8 | 0 |
133925 | 133925 | 2020-05-11 | Grant | Indiana | 18053 | 172 | 18 |
133926 | 133926 | 2020-05-11 | Greene | Indiana | 18055 | 151 | 17 |
133927 | 133927 | 2020-05-11 | Hamilton | Indiana | 18057 | 946 | 86 |
133928 | 133928 | 2020-05-11 | Hancock | Indiana | 18059 | 272 | 20 |
133929 | 133929 | 2020-05-11 | Harrison | Indiana | 18061 | 161 | 13 |
133930 | 133930 | 2020-05-11 | Hendricks | Indiana | 18063 | 991 | 66 |
133931 | 133931 | 2020-05-11 | Henry | Indiana | 18065 | 88 | 2 |
133932 | 133932 | 2020-05-11 | Howard | Indiana | 18067 | 257 | 10 |
133933 | 133933 | 2020-05-11 | Huntington | Indiana | 18069 | 14 | 2 |
133934 | 133934 | 2020-05-11 | Jackson | Indiana | 18071 | 284 | 1 |
133935 | 133935 | 2020-05-11 | Jasper | Indiana | 18073 | 41 | 1 |
133936 | 133936 | 2020-05-11 | Jay | Indiana | 18075 | 23 | 0 |
133937 | 133937 | 2020-05-11 | Jefferson | Indiana | 18077 | 36 | 0 |
133938 | 133938 | 2020-05-11 | Jennings | Indiana | 18079 | 98 | 5 |
133939 | 133939 | 2020-05-11 | Johnson | Indiana | 18081 | 842 | 94 |
133940 | 133940 | 2020-05-11 | Knox | Indiana | 18083 | 22 | 0 |
133941 | 133941 | 2020-05-11 | Kosciusko | Indiana | 18085 | 46 | 2 |
133942 | 133942 | 2020-05-11 | LaGrange | Indiana | 18087 | 39 | 2 |
133943 | 133943 | 2020-05-11 | LaPorte | Indiana | 18091 | 329 | 12 |
133944 | 133944 | 2020-05-11 | Lake | Indiana | 18089 | 2516 | 135 |
133945 | 133945 | 2020-05-11 | Lawrence | Indiana | 18093 | 121 | 17 |
133946 | 133946 | 2020-05-11 | Madison | Indiana | 18095 | 518 | 66 |
133947 | 133947 | 2020-05-11 | Marion | Indiana | 18097 | 7580 | 455 |
133948 | 133948 | 2020-05-11 | Marshall | Indiana | 18099 | 34 | 1 |
133949 | 133949 | 2020-05-11 | Martin | Indiana | 18101 | 7 | 0 |
133950 | 133950 | 2020-05-11 | Miami | Indiana | 18103 | 127 | 1 |
133951 | 133951 | 2020-05-11 | Monroe | Indiana | 18105 | 145 | 9 |
133952 | 133952 | 2020-05-11 | Montgomery | Indiana | 18107 | 141 | 5 |
133953 | 133953 | 2020-05-11 | Morgan | Indiana | 18109 | 211 | 9 |
133954 | 133954 | 2020-05-11 | Newton | Indiana | 18111 | 66 | 10 |
133955 | 133955 | 2020-05-11 | Noble | Indiana | 18113 | 136 | 16 |
133956 | 133956 | 2020-05-11 | Ohio | Indiana | 18115 | 9 | 0 |
133957 | 133957 | 2020-05-11 | Orange | Indiana | 18117 | 114 | 19 |
133958 | 133958 | 2020-05-11 | Owen | Indiana | 18119 | 28 | 1 |
133959 | 133959 | 2020-05-11 | Parke | Indiana | 18121 | 19 | 0 |
133960 | 133960 | 2020-05-11 | Perry | Indiana | 18123 | 28 | 0 |
133961 | 133961 | 2020-05-11 | Pike | Indiana | 18125 | 3 | 0 |
133962 | 133962 | 2020-05-11 | Porter | Indiana | 18127 | 338 | 10 |
133963 | 133963 | 2020-05-11 | Posey | Indiana | 18129 | 15 | 0 |
133964 | 133964 | 2020-05-11 | Pulaski | Indiana | 18131 | 34 | 0 |
133965 | 133965 | 2020-05-11 | Putnam | Indiana | 18133 | 94 | 5 |
133966 | 133966 | 2020-05-11 | Randolph | Indiana | 18135 | 39 | 2 |
133967 | 133967 | 2020-05-11 | Ripley | Indiana | 18137 | 101 | 6 |
133968 | 133968 | 2020-05-11 | Rush | Indiana | 18139 | 48 | 2 |
133969 | 133969 | 2020-05-11 | Scott | Indiana | 18143 | 81 | 2 |
133970 | 133970 | 2020-05-11 | Shelby | Indiana | 18145 | 336 | 23 |
133971 | 133971 | 2020-05-11 | Spencer | Indiana | 18147 | 10 | 1 |
133972 | 133972 | 2020-05-11 | St. Joseph | Indiana | 18141 | 836 | 31 |
133973 | 133973 | 2020-05-11 | Starke | Indiana | 18149 | 22 | 2 |
133974 | 133974 | 2020-05-11 | Steuben | Indiana | 18151 | 62 | 2 |
133975 | 133975 | 2020-05-11 | Sullivan | Indiana | 18153 | 20 | 0 |
133976 | 133976 | 2020-05-11 | Switzerland | Indiana | 18155 | 15 | 0 |
133977 | 133977 | 2020-05-11 | Tippecanoe | Indiana | 18157 | 245 | 2 |
133978 | 133978 | 2020-05-11 | Tipton | Indiana | 18159 | 21 | 1 |
133979 | 133979 | 2020-05-11 | Union | Indiana | 18161 | 19 | 0 |
133980 | 133980 | 2020-05-11 | Vanderburgh | Indiana | 18163 | 189 | 2 |
133981 | 133981 | 2020-05-11 | Vermillion | Indiana | 18165 | 8 | 0 |
133982 | 133982 | 2020-05-11 | Vigo | Indiana | 18167 | 84 | 7 |
133983 | 133983 | 2020-05-11 | Wabash | Indiana | 18169 | 64 | 2 |
133984 | 133984 | 2020-05-11 | Warren | Indiana | 18171 | 13 | 1 |
133985 | 133985 | 2020-05-11 | Warrick | Indiana | 18173 | 123 | 20 |
133986 | 133986 | 2020-05-11 | Washington | Indiana | 18175 | 48 | 1 |
133987 | 133987 | 2020-05-11 | Wayne | Indiana | 18177 | 150 | 5 |
133988 | 133988 | 2020-05-11 | Wells | Indiana | 18179 | 11 | 0 |
133989 | 133989 | 2020-05-11 | White | Indiana | 18181 | 152 | 1 |
133990 | 133990 | 2020-05-11 | Whitley | Indiana | 18183 | 22 | 1 |
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);