ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where "date" is on date 2020-04-03 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
28978 | 28978 | 2020-04-03 | Adams | Indiana | 18001 | 1 | 0 |
28979 | 28979 | 2020-04-03 | Allen | Indiana | 18003 | 59 | 3 |
28980 | 28980 | 2020-04-03 | Bartholomew | Indiana | 18005 | 23 | 0 |
28981 | 28981 | 2020-04-03 | Blackford | Indiana | 18009 | 1 | 0 |
28982 | 28982 | 2020-04-03 | Boone | Indiana | 18011 | 38 | 0 |
28983 | 28983 | 2020-04-03 | Brown | Indiana | 18013 | 3 | 0 |
28984 | 28984 | 2020-04-03 | Carroll | Indiana | 18015 | 2 | 0 |
28985 | 28985 | 2020-04-03 | Cass | Indiana | 18017 | 2 | 0 |
28986 | 28986 | 2020-04-03 | Clark | Indiana | 18019 | 55 | 2 |
28987 | 28987 | 2020-04-03 | Clay | Indiana | 18021 | 2 | 0 |
28988 | 28988 | 2020-04-03 | Clinton | Indiana | 18023 | 3 | 0 |
28989 | 28989 | 2020-04-03 | Crawford | Indiana | 18025 | 3 | 0 |
28990 | 28990 | 2020-04-03 | DeKalb | Indiana | 18033 | 3 | 0 |
28991 | 28991 | 2020-04-03 | Dearborn | Indiana | 18029 | 25 | 1 |
28992 | 28992 | 2020-04-03 | Decatur | Indiana | 18031 | 71 | 5 |
28993 | 28993 | 2020-04-03 | Delaware | Indiana | 18035 | 30 | 1 |
28994 | 28994 | 2020-04-03 | Dubois | Indiana | 18037 | 3 | 0 |
28995 | 28995 | 2020-04-03 | Elkhart | Indiana | 18039 | 29 | 3 |
28996 | 28996 | 2020-04-03 | Fayette | Indiana | 18041 | 13 | 3 |
28997 | 28997 | 2020-04-03 | Floyd | Indiana | 18043 | 37 | 0 |
28998 | 28998 | 2020-04-03 | Fountain | Indiana | 18045 | 2 | 1 |
28999 | 28999 | 2020-04-03 | Franklin | Indiana | 18047 | 48 | 6 |
29000 | 29000 | 2020-04-03 | Fulton | Indiana | 18049 | 1 | 0 |
29001 | 29001 | 2020-04-03 | Gibson | Indiana | 18051 | 4 | 0 |
29002 | 29002 | 2020-04-03 | Grant | Indiana | 18053 | 12 | 0 |
29003 | 29003 | 2020-04-03 | Greene | Indiana | 18055 | 9 | 0 |
29004 | 29004 | 2020-04-03 | Hamilton | Indiana | 18057 | 220 | 4 |
29005 | 29005 | 2020-04-03 | Hancock | Indiana | 18059 | 41 | 2 |
29006 | 29006 | 2020-04-03 | Harrison | Indiana | 18061 | 23 | 1 |
29007 | 29007 | 2020-04-03 | Hendricks | Indiana | 18063 | 138 | 1 |
29008 | 29008 | 2020-04-03 | Henry | Indiana | 18065 | 7 | 0 |
29009 | 29009 | 2020-04-03 | Howard | Indiana | 18067 | 26 | 3 |
29010 | 29010 | 2020-04-03 | Huntington | Indiana | 18069 | 3 | 1 |
29011 | 29011 | 2020-04-03 | Jackson | Indiana | 18071 | 25 | 0 |
29012 | 29012 | 2020-04-03 | Jasper | Indiana | 18073 | 13 | 1 |
29013 | 29013 | 2020-04-03 | Jay | Indiana | 18075 | 2 | 0 |
29014 | 29014 | 2020-04-03 | Jefferson | Indiana | 18077 | 5 | 0 |
29015 | 29015 | 2020-04-03 | Jennings | Indiana | 18079 | 32 | 1 |
29016 | 29016 | 2020-04-03 | Johnson | Indiana | 18081 | 136 | 4 |
29017 | 29017 | 2020-04-03 | Knox | Indiana | 18083 | 4 | 0 |
29018 | 29018 | 2020-04-03 | Kosciusko | Indiana | 18085 | 8 | 0 |
29019 | 29019 | 2020-04-03 | LaGrange | Indiana | 18087 | 4 | 0 |
29020 | 29020 | 2020-04-03 | LaPorte | Indiana | 18091 | 17 | 1 |
29021 | 29021 | 2020-04-03 | Lake | Indiana | 18089 | 245 | 8 |
29022 | 29022 | 2020-04-03 | Lawrence | Indiana | 18093 | 23 | 5 |
29023 | 29023 | 2020-04-03 | Madison | Indiana | 18095 | 71 | 11 |
29024 | 29024 | 2020-04-03 | Marion | Indiana | 18097 | 1431 | 35 |
29025 | 29025 | 2020-04-03 | Marshall | Indiana | 18099 | 4 | 0 |
29026 | 29026 | 2020-04-03 | Miami | Indiana | 18103 | 5 | 0 |
29027 | 29027 | 2020-04-03 | Monroe | Indiana | 18105 | 40 | 0 |
29028 | 29028 | 2020-04-03 | Montgomery | Indiana | 18107 | 12 | 0 |
29029 | 29029 | 2020-04-03 | Morgan | Indiana | 18109 | 52 | 1 |
29030 | 29030 | 2020-04-03 | Newton | Indiana | 18111 | 1 | 0 |
29031 | 29031 | 2020-04-03 | Noble | Indiana | 18113 | 5 | 0 |
29032 | 29032 | 2020-04-03 | Ohio | Indiana | 18115 | 1 | 0 |
29033 | 29033 | 2020-04-03 | Orange | Indiana | 18117 | 5 | 0 |
29034 | 29034 | 2020-04-03 | Owen | Indiana | 18119 | 13 | 0 |
29035 | 29035 | 2020-04-03 | Parke | Indiana | 18121 | 1 | 0 |
29036 | 29036 | 2020-04-03 | Porter | Indiana | 18127 | 45 | 0 |
29037 | 29037 | 2020-04-03 | Posey | Indiana | 18129 | 5 | 0 |
29038 | 29038 | 2020-04-03 | Putnam | Indiana | 18133 | 13 | 1 |
29039 | 29039 | 2020-04-03 | Randolph | Indiana | 18135 | 4 | 1 |
29040 | 29040 | 2020-04-03 | Ripley | Indiana | 18137 | 47 | 1 |
29041 | 29041 | 2020-04-03 | Rush | Indiana | 18139 | 8 | 1 |
29042 | 29042 | 2020-04-03 | Scott | Indiana | 18143 | 6 | 1 |
29043 | 29043 | 2020-04-03 | Shelby | Indiana | 18145 | 26 | 0 |
29044 | 29044 | 2020-04-03 | Spencer | Indiana | 18147 | 1 | 0 |
29045 | 29045 | 2020-04-03 | St. Joseph | Indiana | 18141 | 75 | 4 |
29046 | 29046 | 2020-04-03 | Starke | Indiana | 18149 | 2 | 0 |
29047 | 29047 | 2020-04-03 | Steuben | Indiana | 18151 | 2 | 0 |
29048 | 29048 | 2020-04-03 | Sullivan | Indiana | 18153 | 3 | 0 |
29049 | 29049 | 2020-04-03 | Switzerland | Indiana | 18155 | 6 | 0 |
29050 | 29050 | 2020-04-03 | Tippecanoe | Indiana | 18157 | 26 | 1 |
29051 | 29051 | 2020-04-03 | Tipton | Indiana | 18159 | 5 | 0 |
29052 | 29052 | 2020-04-03 | Unknown | Indiana | 2 | 0 | |
29053 | 29053 | 2020-04-03 | Vanderburgh | Indiana | 18163 | 33 | 0 |
29054 | 29054 | 2020-04-03 | Vermillion | Indiana | 18165 | 2 | 0 |
29055 | 29055 | 2020-04-03 | Vigo | Indiana | 18167 | 10 | 3 |
29056 | 29056 | 2020-04-03 | Wabash | Indiana | 18169 | 1 | 0 |
29057 | 29057 | 2020-04-03 | Warren | Indiana | 18171 | 2 | 1 |
29058 | 29058 | 2020-04-03 | Warrick | Indiana | 18173 | 10 | 0 |
29059 | 29059 | 2020-04-03 | Washington | Indiana | 18175 | 14 | 0 |
29060 | 29060 | 2020-04-03 | Wayne | Indiana | 18177 | 6 | 0 |
29061 | 29061 | 2020-04-03 | Wells | Indiana | 18179 | 2 | 0 |
29062 | 29062 | 2020-04-03 | White | Indiana | 18181 | 3 | 0 |
29063 | 29063 | 2020-04-03 | Whitley | Indiana | 18183 | 4 | 0 |
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);