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-08-26 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1654880 | 1654880 | 2021-08-26 | Adams | Indiana | 18001 | 4033 | 61 |
1654881 | 1654881 | 2021-08-26 | Allen | Indiana | 18003 | 47742 | 735 |
1654882 | 1654882 | 2021-08-26 | Bartholomew | Indiana | 18005 | 9100 | 164 |
1654883 | 1654883 | 2021-08-26 | Benton | Indiana | 18007 | 1207 | 15 |
1654884 | 1654884 | 2021-08-26 | Blackford | Indiana | 18009 | 1475 | 33 |
1654885 | 1654885 | 2021-08-26 | Boone | Indiana | 18011 | 7691 | 111 |
1654886 | 1654886 | 2021-08-26 | Brown | Indiana | 18013 | 1189 | 44 |
1654887 | 1654887 | 2021-08-26 | Carroll | Indiana | 18015 | 2207 | 26 |
1654888 | 1654888 | 2021-08-26 | Cass | Indiana | 18017 | 6467 | 116 |
1654889 | 1654889 | 2021-08-26 | Clark | Indiana | 18019 | 15518 | 215 |
1654890 | 1654890 | 2021-08-26 | Clay | Indiana | 18021 | 3275 | 51 |
1654891 | 1654891 | 2021-08-26 | Clinton | Indiana | 18023 | 4957 | 64 |
1654892 | 1654892 | 2021-08-26 | Crawford | Indiana | 18025 | 1203 | 19 |
1654893 | 1654893 | 2021-08-26 | Daviess | Indiana | 18027 | 3474 | 104 |
1654894 | 1654894 | 2021-08-26 | DeKalb | Indiana | 18033 | 5034 | 92 |
1654895 | 1654895 | 2021-08-26 | Dearborn | Indiana | 18029 | 6603 | 85 |
1654896 | 1654896 | 2021-08-26 | Decatur | Indiana | 18031 | 3363 | 98 |
1654897 | 1654897 | 2021-08-26 | Delaware | Indiana | 18035 | 12127 | 209 |
1654898 | 1654898 | 2021-08-26 | Dubois | Indiana | 18037 | 6788 | 120 |
1654899 | 1654899 | 2021-08-26 | Elkhart | Indiana | 18039 | 30958 | 494 |
1654900 | 1654900 | 2021-08-26 | Fayette | Indiana | 18041 | 3246 | 68 |
1654901 | 1654901 | 2021-08-26 | Floyd | Indiana | 18043 | 9123 | 196 |
1654902 | 1654902 | 2021-08-26 | Fountain | Indiana | 18045 | 2636 | 54 |
1654903 | 1654903 | 2021-08-26 | Franklin | Indiana | 18047 | 1951 | 36 |
1654904 | 1654904 | 2021-08-26 | Fulton | Indiana | 18049 | 2302 | 48 |
1654905 | 1654905 | 2021-08-26 | Gibson | Indiana | 18051 | 5284 | 103 |
1654906 | 1654906 | 2021-08-26 | Grant | Indiana | 18053 | 8399 | 193 |
1654907 | 1654907 | 2021-08-26 | Greene | Indiana | 18055 | 3299 | 90 |
1654908 | 1654908 | 2021-08-26 | Hamilton | Indiana | 18057 | 40142 | 450 |
1654909 | 1654909 | 2021-08-26 | Hancock | Indiana | 18059 | 9624 | 159 |
1654910 | 1654910 | 2021-08-26 | Harrison | Indiana | 18061 | 5246 | 81 |
1654911 | 1654911 | 2021-08-26 | Hendricks | Indiana | 18063 | 19797 | 349 |
1654912 | 1654912 | 2021-08-26 | Henry | Indiana | 18065 | 6627 | 119 |
1654913 | 1654913 | 2021-08-26 | Howard | Indiana | 18067 | 12083 | 251 |
1654914 | 1654914 | 2021-08-26 | Huntington | Indiana | 18069 | 5319 | 87 |
1654915 | 1654915 | 2021-08-26 | Jackson | Indiana | 18071 | 5721 | 79 |
1654916 | 1654916 | 2021-08-26 | Jasper | Indiana | 18073 | 4256 | 60 |
1654917 | 1654917 | 2021-08-26 | Jay | Indiana | 18075 | 2248 | 36 |
1654918 | 1654918 | 2021-08-26 | Jefferson | Indiana | 18077 | 4020 | 91 |
1654919 | 1654919 | 2021-08-26 | Jennings | Indiana | 18079 | 2845 | 54 |
1654920 | 1654920 | 2021-08-26 | Johnson | Indiana | 18081 | 21056 | 419 |
1654921 | 1654921 | 2021-08-26 | Knox | Indiana | 18083 | 4894 | 92 |
1654922 | 1654922 | 2021-08-26 | Kosciusko | Indiana | 18085 | 10298 | 132 |
1654923 | 1654923 | 2021-08-26 | LaGrange | Indiana | 18087 | 2888 | 75 |
1654924 | 1654924 | 2021-08-26 | LaPorte | Indiana | 18091 | 13164 | 231 |
1654925 | 1654925 | 2021-08-26 | Lake | Indiana | 18089 | 59365 | 1095 |
1654926 | 1654926 | 2021-08-26 | Lawrence | Indiana | 18093 | 6006 | 138 |
1654927 | 1654927 | 2021-08-26 | Madison | Indiana | 18095 | 15240 | 376 |
1654928 | 1654928 | 2021-08-26 | Marion | Indiana | 18097 | 115180 | 1924 |
1654929 | 1654929 | 2021-08-26 | Marshall | Indiana | 18099 | 6715 | 121 |
1654930 | 1654930 | 2021-08-26 | Martin | Indiana | 18101 | 1069 | 15 |
1654931 | 1654931 | 2021-08-26 | Miami | Indiana | 18103 | 4669 | 76 |
1654932 | 1654932 | 2021-08-26 | Monroe | Indiana | 18105 | 13363 | 187 |
1654933 | 1654933 | 2021-08-26 | Montgomery | Indiana | 18107 | 5064 | 97 |
1654934 | 1654934 | 2021-08-26 | Morgan | Indiana | 18109 | 7717 | 155 |
1654935 | 1654935 | 2021-08-26 | Newton | Indiana | 18111 | 1282 | 42 |
1654936 | 1654936 | 2021-08-26 | Noble | Indiana | 18113 | 6541 | 98 |
1654937 | 1654937 | 2021-08-26 | Ohio | Indiana | 18115 | 680 | 11 |
1654938 | 1654938 | 2021-08-26 | Orange | Indiana | 18117 | 2383 | 60 |
1654939 | 1654939 | 2021-08-26 | Owen | Indiana | 18119 | 2496 | 63 |
1654940 | 1654940 | 2021-08-26 | Parke | Indiana | 18121 | 1850 | 18 |
1654941 | 1654941 | 2021-08-26 | Perry | Indiana | 18123 | 2199 | 43 |
1654942 | 1654942 | 2021-08-26 | Pike | Indiana | 18125 | 1647 | 35 |
1654943 | 1654943 | 2021-08-26 | Porter | Indiana | 18127 | 20368 | 343 |
1654944 | 1654944 | 2021-08-26 | Posey | Indiana | 18129 | 3173 | 37 |
1654945 | 1654945 | 2021-08-26 | Pulaski | Indiana | 18131 | 1353 | 50 |
1654946 | 1654946 | 2021-08-26 | Putnam | Indiana | 18133 | 4594 | 65 |
1654947 | 1654947 | 2021-08-26 | Randolph | Indiana | 18135 | 2723 | 85 |
1654948 | 1654948 | 2021-08-26 | Ripley | Indiana | 18137 | 3875 | 72 |
1654949 | 1654949 | 2021-08-26 | Rush | Indiana | 18139 | 1999 | 27 |
1654950 | 1654950 | 2021-08-26 | Scott | Indiana | 18143 | 3358 | 61 |
1654951 | 1654951 | 2021-08-26 | Shelby | Indiana | 18145 | 6604 | 109 |
1654952 | 1654952 | 2021-08-26 | Spencer | Indiana | 18147 | 2752 | 31 |
1654953 | 1654953 | 2021-08-26 | St. Joseph | Indiana | 18141 | 38932 | 589 |
1654954 | 1654954 | 2021-08-26 | Starke | Indiana | 18149 | 2447 | 62 |
1654955 | 1654955 | 2021-08-26 | Steuben | Indiana | 18151 | 4470 | 66 |
1654956 | 1654956 | 2021-08-26 | Sullivan | Indiana | 18153 | 2511 | 46 |
1654957 | 1654957 | 2021-08-26 | Switzerland | Indiana | 18155 | 1006 | 9 |
1654958 | 1654958 | 2021-08-26 | Tippecanoe | Indiana | 18157 | 25065 | 240 |
1654959 | 1654959 | 2021-08-26 | Tipton | Indiana | 18159 | 1900 | 53 |
1654960 | 1654960 | 2021-08-26 | Union | Indiana | 18161 | 847 | 11 |
1654961 | 1654961 | 2021-08-26 | Vanderburgh | Indiana | 18163 | 26566 | 419 |
1654962 | 1654962 | 2021-08-26 | Vermillion | Indiana | 18165 | 2038 | 45 |
1654963 | 1654963 | 2021-08-26 | Vigo | Indiana | 18167 | 13992 | 266 |
1654964 | 1654964 | 2021-08-26 | Wabash | Indiana | 18169 | 4177 | 86 |
1654965 | 1654965 | 2021-08-26 | Warren | Indiana | 18171 | 989 | 17 |
1654966 | 1654966 | 2021-08-26 | Warrick | Indiana | 18173 | 9276 | 164 |
1654967 | 1654967 | 2021-08-26 | Washington | Indiana | 18175 | 2869 | 42 |
1654968 | 1654968 | 2021-08-26 | Wayne | Indiana | 18177 | 8432 | 208 |
1654969 | 1654969 | 2021-08-26 | Wells | Indiana | 18179 | 3370 | 83 |
1654970 | 1654970 | 2021-08-26 | White | Indiana | 18181 | 3589 | 56 |
1654971 | 1654971 | 2021-08-26 | Whitley | Indiana | 18183 | 4610 | 47 |
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);