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-18 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
154901 | 154901 | 2020-05-18 | Adams | Indiana | 18001 | 10 | 1 |
154902 | 154902 | 2020-05-18 | Allen | Indiana | 18003 | 1040 | 68 |
154903 | 154903 | 2020-05-18 | Bartholomew | Indiana | 18005 | 436 | 33 |
154904 | 154904 | 2020-05-18 | Benton | Indiana | 18007 | 23 | 0 |
154905 | 154905 | 2020-05-18 | Blackford | Indiana | 18009 | 15 | 1 |
154906 | 154906 | 2020-05-18 | Boone | Indiana | 18011 | 278 | 36 |
154907 | 154907 | 2020-05-18 | Brown | Indiana | 18013 | 32 | 1 |
154908 | 154908 | 2020-05-18 | Carroll | Indiana | 18015 | 79 | 2 |
154909 | 154909 | 2020-05-18 | Cass | Indiana | 18017 | 1554 | 6 |
154910 | 154910 | 2020-05-18 | Clark | Indiana | 18019 | 430 | 36 |
154911 | 154911 | 2020-05-18 | Clay | Indiana | 18021 | 31 | 1 |
154912 | 154912 | 2020-05-18 | Clinton | Indiana | 18023 | 143 | 2 |
154913 | 154913 | 2020-05-18 | Crawford | Indiana | 18025 | 23 | 1 |
154914 | 154914 | 2020-05-18 | Daviess | Indiana | 18027 | 73 | 17 |
154915 | 154915 | 2020-05-18 | DeKalb | Indiana | 18033 | 26 | 2 |
154916 | 154916 | 2020-05-18 | Dearborn | Indiana | 18029 | 158 | 19 |
154917 | 154917 | 2020-05-18 | Decatur | Indiana | 18031 | 229 | 34 |
154918 | 154918 | 2020-05-18 | Delaware | Indiana | 18035 | 296 | 23 |
154919 | 154919 | 2020-05-18 | Dubois | Indiana | 18037 | 161 | 2 |
154920 | 154920 | 2020-05-18 | Elkhart | Indiana | 18039 | 690 | 23 |
154921 | 154921 | 2020-05-18 | Fayette | Indiana | 18041 | 71 | 4 |
154922 | 154922 | 2020-05-18 | Floyd | Indiana | 18043 | 303 | 39 |
154923 | 154923 | 2020-05-18 | Fountain | Indiana | 18045 | 18 | 2 |
154924 | 154924 | 2020-05-18 | Franklin | Indiana | 18047 | 110 | 8 |
154925 | 154925 | 2020-05-18 | Fulton | Indiana | 18049 | 44 | 1 |
154926 | 154926 | 2020-05-18 | Gibson | Indiana | 18051 | 10 | 0 |
154927 | 154927 | 2020-05-18 | Grant | Indiana | 18053 | 197 | 20 |
154928 | 154928 | 2020-05-18 | Greene | Indiana | 18055 | 164 | 24 |
154929 | 154929 | 2020-05-18 | Hamilton | Indiana | 18057 | 1044 | 95 |
154930 | 154930 | 2020-05-18 | Hancock | Indiana | 18059 | 295 | 24 |
154931 | 154931 | 2020-05-18 | Harrison | Indiana | 18061 | 174 | 17 |
154932 | 154932 | 2020-05-18 | Hendricks | Indiana | 18063 | 1057 | 74 |
154933 | 154933 | 2020-05-18 | Henry | Indiana | 18065 | 131 | 3 |
154934 | 154934 | 2020-05-18 | Howard | Indiana | 18067 | 299 | 13 |
154935 | 154935 | 2020-05-18 | Huntington | Indiana | 18069 | 21 | 2 |
154936 | 154936 | 2020-05-18 | Jackson | Indiana | 18071 | 335 | 2 |
154937 | 154937 | 2020-05-18 | Jasper | Indiana | 18073 | 44 | 1 |
154938 | 154938 | 2020-05-18 | Jay | Indiana | 18075 | 33 | 0 |
154939 | 154939 | 2020-05-18 | Jefferson | Indiana | 18077 | 40 | 1 |
154940 | 154940 | 2020-05-18 | Jennings | Indiana | 18079 | 118 | 6 |
154941 | 154941 | 2020-05-18 | Johnson | Indiana | 18081 | 1026 | 99 |
154942 | 154942 | 2020-05-18 | Knox | Indiana | 18083 | 23 | 0 |
154943 | 154943 | 2020-05-18 | Kosciusko | Indiana | 18085 | 59 | 2 |
154944 | 154944 | 2020-05-18 | LaGrange | Indiana | 18087 | 51 | 2 |
154945 | 154945 | 2020-05-18 | LaPorte | Indiana | 18091 | 360 | 16 |
154946 | 154946 | 2020-05-18 | Lake | Indiana | 18089 | 2914 | 150 |
154947 | 154947 | 2020-05-18 | Lawrence | Indiana | 18093 | 140 | 22 |
154948 | 154948 | 2020-05-18 | Madison | Indiana | 18095 | 560 | 66 |
154949 | 154949 | 2020-05-18 | Marion | Indiana | 18097 | 8495 | 515 |
154950 | 154950 | 2020-05-18 | Marshall | Indiana | 18099 | 42 | 1 |
154951 | 154951 | 2020-05-18 | Martin | Indiana | 18101 | 8 | 0 |
154952 | 154952 | 2020-05-18 | Miami | Indiana | 18103 | 131 | 1 |
154953 | 154953 | 2020-05-18 | Monroe | Indiana | 18105 | 149 | 9 |
154954 | 154954 | 2020-05-18 | Montgomery | Indiana | 18107 | 174 | 13 |
154955 | 154955 | 2020-05-18 | Morgan | Indiana | 18109 | 254 | 21 |
154956 | 154956 | 2020-05-18 | Newton | Indiana | 18111 | 72 | 10 |
154957 | 154957 | 2020-05-18 | Noble | Indiana | 18113 | 153 | 21 |
154958 | 154958 | 2020-05-18 | Ohio | Indiana | 18115 | 13 | 0 |
154959 | 154959 | 2020-05-18 | Orange | Indiana | 18117 | 124 | 21 |
154960 | 154960 | 2020-05-18 | Owen | Indiana | 18119 | 27 | 1 |
154961 | 154961 | 2020-05-18 | Parke | Indiana | 18121 | 21 | 0 |
154962 | 154962 | 2020-05-18 | Perry | Indiana | 18123 | 29 | 1 |
154963 | 154963 | 2020-05-18 | Pike | Indiana | 18125 | 5 | 0 |
154964 | 154964 | 2020-05-18 | Porter | Indiana | 18127 | 412 | 13 |
154965 | 154965 | 2020-05-18 | Posey | Indiana | 18129 | 16 | 0 |
154966 | 154966 | 2020-05-18 | Pulaski | Indiana | 18131 | 35 | 0 |
154967 | 154967 | 2020-05-18 | Putnam | Indiana | 18133 | 125 | 5 |
154968 | 154968 | 2020-05-18 | Randolph | Indiana | 18135 | 50 | 3 |
154969 | 154969 | 2020-05-18 | Ripley | Indiana | 18137 | 108 | 6 |
154970 | 154970 | 2020-05-18 | Rush | Indiana | 18139 | 55 | 2 |
154971 | 154971 | 2020-05-18 | Scott | Indiana | 18143 | 98 | 2 |
154972 | 154972 | 2020-05-18 | Shelby | Indiana | 18145 | 403 | 28 |
154973 | 154973 | 2020-05-18 | Spencer | Indiana | 18147 | 15 | 1 |
154974 | 154974 | 2020-05-18 | St. Joseph | Indiana | 18141 | 992 | 33 |
154975 | 154975 | 2020-05-18 | Starke | Indiana | 18149 | 29 | 2 |
154976 | 154976 | 2020-05-18 | Steuben | Indiana | 18151 | 67 | 2 |
154977 | 154977 | 2020-05-18 | Sullivan | Indiana | 18153 | 28 | 0 |
154978 | 154978 | 2020-05-18 | Switzerland | Indiana | 18155 | 18 | 0 |
154979 | 154979 | 2020-05-18 | Tippecanoe | Indiana | 18157 | 308 | 2 |
154980 | 154980 | 2020-05-18 | Tipton | Indiana | 18159 | 21 | 1 |
154981 | 154981 | 2020-05-18 | Union | Indiana | 18161 | 20 | 0 |
154982 | 154982 | 2020-05-18 | Vanderburgh | Indiana | 18163 | 222 | 2 |
154983 | 154983 | 2020-05-18 | Vermillion | Indiana | 18165 | 8 | 0 |
154984 | 154984 | 2020-05-18 | Vigo | Indiana | 18167 | 119 | 7 |
154985 | 154985 | 2020-05-18 | Wabash | Indiana | 18169 | 71 | 2 |
154986 | 154986 | 2020-05-18 | Warren | Indiana | 18171 | 13 | 1 |
154987 | 154987 | 2020-05-18 | Warrick | Indiana | 18173 | 152 | 25 |
154988 | 154988 | 2020-05-18 | Washington | Indiana | 18175 | 50 | 1 |
154989 | 154989 | 2020-05-18 | Wayne | Indiana | 18177 | 170 | 5 |
154990 | 154990 | 2020-05-18 | Wells | Indiana | 18179 | 16 | 0 |
154991 | 154991 | 2020-05-18 | White | Indiana | 18181 | 183 | 5 |
154992 | 154992 | 2020-05-18 | Whitley | Indiana | 18183 | 28 | 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);