ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2022-04-07 and state = "Indiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2383135 | 2383135 | 2022-04-07 | Unknown | Indiana | 0 | 2 | |
2383111 | 2383111 | 2022-04-07 | Ohio | Indiana | 18115 | 1442 | 19 |
2383134 | 2383134 | 2022-04-07 | Union | Indiana | 18161 | 2018 | 21 |
2383140 | 2383140 | 2022-04-07 | Warren | Indiana | 18171 | 2090 | 30 |
2383104 | 2383104 | 2022-04-07 | Martin | Indiana | 18101 | 2162 | 25 |
2383131 | 2383131 | 2022-04-07 | Switzerland | Indiana | 18155 | 2311 | 20 |
2383057 | 2383057 | 2022-04-07 | Benton | Indiana | 18007 | 2477 | 21 |
2383066 | 2383066 | 2022-04-07 | Crawford | Indiana | 18025 | 2546 | 40 |
2383109 | 2383109 | 2022-04-07 | Newton | Indiana | 18111 | 2562 | 68 |
2383060 | 2383060 | 2022-04-07 | Brown | Indiana | 18013 | 2585 | 62 |
2383119 | 2383119 | 2022-04-07 | Pulaski | Indiana | 18131 | 3068 | 86 |
2383058 | 2383058 | 2022-04-07 | Blackford | Indiana | 18009 | 3107 | 69 |
2383133 | 2383133 | 2022-04-07 | Tipton | Indiana | 18159 | 3521 | 87 |
2383114 | 2383114 | 2022-04-07 | Parke | Indiana | 18121 | 3588 | 52 |
2383116 | 2383116 | 2022-04-07 | Pike | Indiana | 18125 | 3725 | 49 |
2383137 | 2383137 | 2022-04-07 | Vermillion | Indiana | 18165 | 4071 | 75 |
2383061 | 2383061 | 2022-04-07 | Carroll | Indiana | 18015 | 4219 | 68 |
2383077 | 2383077 | 2022-04-07 | Franklin | Indiana | 18047 | 4372 | 65 |
2383115 | 2383115 | 2022-04-07 | Perry | Indiana | 18123 | 4650 | 68 |
2383128 | 2383128 | 2022-04-07 | Starke | Indiana | 18149 | 4747 | 97 |
2383123 | 2383123 | 2022-04-07 | Rush | Indiana | 18139 | 4835 | 58 |
2383091 | 2383091 | 2022-04-07 | Jay | Indiana | 18075 | 4837 | 78 |
2383078 | 2383078 | 2022-04-07 | Fulton | Indiana | 18049 | 4913 | 102 |
2383112 | 2383112 | 2022-04-07 | Orange | Indiana | 18117 | 5029 | 96 |
2383126 | 2383126 | 2022-04-07 | Spencer | Indiana | 18147 | 5217 | 60 |
2383130 | 2383130 | 2022-04-07 | Sullivan | Indiana | 18153 | 5271 | 76 |
2383076 | 2383076 | 2022-04-07 | Fountain | Indiana | 18045 | 5411 | 102 |
2383113 | 2383113 | 2022-04-07 | Owen | Indiana | 18119 | 5833 | 120 |
2383097 | 2383097 | 2022-04-07 | LaGrange | Indiana | 18087 | 5842 | 102 |
2383121 | 2383121 | 2022-04-07 | Randolph | Indiana | 18135 | 5896 | 148 |
2383142 | 2383142 | 2022-04-07 | Washington | Indiana | 18175 | 5994 | 82 |
2383144 | 2383144 | 2022-04-07 | Wells | Indiana | 18179 | 6494 | 132 |
2383118 | 2383118 | 2022-04-07 | Posey | Indiana | 18129 | 6531 | 58 |
2383074 | 2383074 | 2022-04-07 | Fayette | Indiana | 18041 | 6735 | 146 |
2383064 | 2383064 | 2022-04-07 | Clay | Indiana | 18021 | 6824 | 88 |
2383145 | 2383145 | 2022-04-07 | White | Indiana | 18181 | 6859 | 95 |
2383093 | 2383093 | 2022-04-07 | Jennings | Indiana | 18079 | 6935 | 108 |
2383070 | 2383070 | 2022-04-07 | Decatur | Indiana | 18031 | 6993 | 145 |
2383081 | 2383081 | 2022-04-07 | Greene | Indiana | 18055 | 7195 | 139 |
2383054 | 2383054 | 2022-04-07 | Adams | Indiana | 18001 | 7259 | 112 |
2383067 | 2383067 | 2022-04-07 | Daviess | Indiana | 18027 | 7468 | 153 |
2383124 | 2383124 | 2022-04-07 | Scott | Indiana | 18143 | 7856 | 106 |
2383122 | 2383122 | 2022-04-07 | Ripley | Indiana | 18137 | 8285 | 138 |
2383139 | 2383139 | 2022-04-07 | Wabash | Indiana | 18169 | 8717 | 155 |
2383090 | 2383090 | 2022-04-07 | Jasper | Indiana | 18073 | 9010 | 148 |
2383065 | 2383065 | 2022-04-07 | Clinton | Indiana | 18023 | 9183 | 125 |
2383105 | 2383105 | 2022-04-07 | Miami | Indiana | 18103 | 9252 | 159 |
2383120 | 2383120 | 2022-04-07 | Putnam | Indiana | 18133 | 9312 | 129 |
2383092 | 2383092 | 2022-04-07 | Jefferson | Indiana | 18077 | 9339 | 157 |
2383129 | 2383129 | 2022-04-07 | Steuben | Indiana | 18151 | 9615 | 120 |
2383146 | 2383146 | 2022-04-07 | Whitley | Indiana | 18183 | 9653 | 84 |
2383107 | 2383107 | 2022-04-07 | Montgomery | Indiana | 18107 | 10665 | 164 |
2383095 | 2383095 | 2022-04-07 | Knox | Indiana | 18083 | 10739 | 153 |
2383084 | 2383084 | 2022-04-07 | Harrison | Indiana | 18061 | 10806 | 138 |
2383068 | 2383068 | 2022-04-07 | DeKalb | Indiana | 18033 | 11345 | 149 |
2383088 | 2383088 | 2022-04-07 | Huntington | Indiana | 18069 | 11490 | 155 |
2383079 | 2383079 | 2022-04-07 | Gibson | Indiana | 18051 | 11631 | 145 |
2383062 | 2383062 | 2022-04-07 | Cass | Indiana | 18017 | 11659 | 163 |
2383100 | 2383100 | 2022-04-07 | Lawrence | Indiana | 18093 | 11846 | 259 |
2383103 | 2383103 | 2022-04-07 | Marshall | Indiana | 18099 | 12319 | 195 |
2383089 | 2383089 | 2022-04-07 | Jackson | Indiana | 18071 | 12512 | 130 |
2383072 | 2383072 | 2022-04-07 | Dubois | Indiana | 18037 | 12858 | 165 |
2383086 | 2383086 | 2022-04-07 | Henry | Indiana | 18065 | 12969 | 230 |
2383110 | 2383110 | 2022-04-07 | Noble | Indiana | 18113 | 13069 | 157 |
2383069 | 2383069 | 2022-04-07 | Dearborn | Indiana | 18029 | 13424 | 139 |
2383125 | 2383125 | 2022-04-07 | Shelby | Indiana | 18145 | 13589 | 181 |
2383059 | 2383059 | 2022-04-07 | Boone | Indiana | 18011 | 15190 | 181 |
2383108 | 2383108 | 2022-04-07 | Morgan | Indiana | 18109 | 16444 | 286 |
2383080 | 2383080 | 2022-04-07 | Grant | Indiana | 18053 | 17293 | 347 |
2383143 | 2383143 | 2022-04-07 | Wayne | Indiana | 18177 | 18832 | 334 |
2383075 | 2383075 | 2022-04-07 | Floyd | Indiana | 18043 | 18916 | 299 |
2383096 | 2383096 | 2022-04-07 | Kosciusko | Indiana | 18085 | 19727 | 237 |
2383141 | 2383141 | 2022-04-07 | Warrick | Indiana | 18173 | 20259 | 238 |
2383083 | 2383083 | 2022-04-07 | Hancock | Indiana | 18059 | 20647 | 258 |
2383056 | 2383056 | 2022-04-07 | Bartholomew | Indiana | 18005 | 21310 | 249 |
2383071 | 2383071 | 2022-04-07 | Delaware | Indiana | 18035 | 24814 | 440 |
2383087 | 2383087 | 2022-04-07 | Howard | Indiana | 18067 | 25394 | 447 |
2383098 | 2383098 | 2022-04-07 | LaPorte | Indiana | 18091 | 25426 | 368 |
2383106 | 2383106 | 2022-04-07 | Monroe | Indiana | 18105 | 27675 | 279 |
2383138 | 2383138 | 2022-04-07 | Vigo | Indiana | 18167 | 28826 | 411 |
2383063 | 2383063 | 2022-04-07 | Clark | Indiana | 18019 | 31055 | 396 |
2383101 | 2383101 | 2022-04-07 | Madison | Indiana | 18095 | 32649 | 648 |
2383117 | 2383117 | 2022-04-07 | Porter | Indiana | 18127 | 37618 | 559 |
2383085 | 2383085 | 2022-04-07 | Hendricks | Indiana | 18063 | 40706 | 554 |
2383094 | 2383094 | 2022-04-07 | Johnson | Indiana | 18081 | 42241 | 613 |
2383132 | 2383132 | 2022-04-07 | Tippecanoe | Indiana | 18157 | 50005 | 394 |
2383073 | 2383073 | 2022-04-07 | Elkhart | Indiana | 18039 | 54062 | 729 |
2383136 | 2383136 | 2022-04-07 | Vanderburgh | Indiana | 18163 | 57246 | 626 |
2383127 | 2383127 | 2022-04-07 | St. Joseph | Indiana | 18141 | 70589 | 867 |
2383082 | 2383082 | 2022-04-07 | Hamilton | Indiana | 18057 | 81801 | 658 |
2383055 | 2383055 | 2022-04-07 | Allen | Indiana | 18003 | 103712 | 1175 |
2383099 | 2383099 | 2022-04-07 | Lake | Indiana | 18089 | 106174 | 1817 |
2383102 | 2383102 | 2022-04-07 | Marion | Indiana | 18097 | 224862 | 2982 |
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);