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 2022-03-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 |
---|---|---|---|---|---|---|---|
2344015 | 2344015 | 2022-03-26 | Adams | Indiana | 18001 | 7331 | 112 |
2344016 | 2344016 | 2022-03-26 | Allen | Indiana | 18003 | 103671 | 1173 |
2344017 | 2344017 | 2022-03-26 | Bartholomew | Indiana | 18005 | 21323 | 248 |
2344018 | 2344018 | 2022-03-26 | Benton | Indiana | 18007 | 2475 | 21 |
2344019 | 2344019 | 2022-03-26 | Blackford | Indiana | 18009 | 3123 | 69 |
2344020 | 2344020 | 2022-03-26 | Boone | Indiana | 18011 | 15177 | 181 |
2344021 | 2344021 | 2022-03-26 | Brown | Indiana | 18013 | 2585 | 62 |
2344022 | 2344022 | 2022-03-26 | Carroll | Indiana | 18015 | 4221 | 67 |
2344023 | 2344023 | 2022-03-26 | Cass | Indiana | 18017 | 11653 | 163 |
2344024 | 2344024 | 2022-03-26 | Clark | Indiana | 18019 | 31043 | 393 |
2344025 | 2344025 | 2022-03-26 | Clay | Indiana | 18021 | 6825 | 87 |
2344026 | 2344026 | 2022-03-26 | Clinton | Indiana | 18023 | 9187 | 123 |
2344027 | 2344027 | 2022-03-26 | Crawford | Indiana | 18025 | 2545 | 38 |
2344028 | 2344028 | 2022-03-26 | Daviess | Indiana | 18027 | 7468 | 151 |
2344029 | 2344029 | 2022-03-26 | DeKalb | Indiana | 18033 | 11337 | 149 |
2344030 | 2344030 | 2022-03-26 | Dearborn | Indiana | 18029 | 13426 | 138 |
2344031 | 2344031 | 2022-03-26 | Decatur | Indiana | 18031 | 7059 | 145 |
2344032 | 2344032 | 2022-03-26 | Delaware | Indiana | 18035 | 24791 | 439 |
2344033 | 2344033 | 2022-03-26 | Dubois | Indiana | 18037 | 12854 | 165 |
2344034 | 2344034 | 2022-03-26 | Elkhart | Indiana | 18039 | 54132 | 728 |
2344035 | 2344035 | 2022-03-26 | Fayette | Indiana | 18041 | 6869 | 146 |
2344036 | 2344036 | 2022-03-26 | Floyd | Indiana | 18043 | 18905 | 295 |
2344037 | 2344037 | 2022-03-26 | Fountain | Indiana | 18045 | 5394 | 101 |
2344038 | 2344038 | 2022-03-26 | Franklin | Indiana | 18047 | 4398 | 65 |
2344039 | 2344039 | 2022-03-26 | Fulton | Indiana | 18049 | 4909 | 102 |
2344040 | 2344040 | 2022-03-26 | Gibson | Indiana | 18051 | 11630 | 145 |
2344041 | 2344041 | 2022-03-26 | Grant | Indiana | 18053 | 17678 | 346 |
2344042 | 2344042 | 2022-03-26 | Greene | Indiana | 18055 | 7202 | 139 |
2344043 | 2344043 | 2022-03-26 | Hamilton | Indiana | 18057 | 81728 | 654 |
2344044 | 2344044 | 2022-03-26 | Hancock | Indiana | 18059 | 20653 | 258 |
2344045 | 2344045 | 2022-03-26 | Harrison | Indiana | 18061 | 10795 | 138 |
2344046 | 2344046 | 2022-03-26 | Hendricks | Indiana | 18063 | 40748 | 552 |
2344047 | 2344047 | 2022-03-26 | Henry | Indiana | 18065 | 12975 | 229 |
2344048 | 2344048 | 2022-03-26 | Howard | Indiana | 18067 | 25391 | 444 |
2344049 | 2344049 | 2022-03-26 | Huntington | Indiana | 18069 | 11493 | 155 |
2344050 | 2344050 | 2022-03-26 | Jackson | Indiana | 18071 | 12512 | 130 |
2344051 | 2344051 | 2022-03-26 | Jasper | Indiana | 18073 | 9010 | 147 |
2344052 | 2344052 | 2022-03-26 | Jay | Indiana | 18075 | 4851 | 78 |
2344053 | 2344053 | 2022-03-26 | Jefferson | Indiana | 18077 | 9349 | 154 |
2344054 | 2344054 | 2022-03-26 | Jennings | Indiana | 18079 | 6945 | 108 |
2344055 | 2344055 | 2022-03-26 | Johnson | Indiana | 18081 | 42300 | 608 |
2344056 | 2344056 | 2022-03-26 | Knox | Indiana | 18083 | 10738 | 153 |
2344057 | 2344057 | 2022-03-26 | Kosciusko | Indiana | 18085 | 19736 | 236 |
2344058 | 2344058 | 2022-03-26 | LaGrange | Indiana | 18087 | 5849 | 102 |
2344059 | 2344059 | 2022-03-26 | LaPorte | Indiana | 18091 | 25411 | 365 |
2344060 | 2344060 | 2022-03-26 | Lake | Indiana | 18089 | 106081 | 1811 |
2344061 | 2344061 | 2022-03-26 | Lawrence | Indiana | 18093 | 11839 | 258 |
2344062 | 2344062 | 2022-03-26 | Madison | Indiana | 18095 | 32650 | 647 |
2344063 | 2344063 | 2022-03-26 | Marion | Indiana | 18097 | 224868 | 2965 |
2344064 | 2344064 | 2022-03-26 | Marshall | Indiana | 18099 | 12325 | 195 |
2344065 | 2344065 | 2022-03-26 | Martin | Indiana | 18101 | 2164 | 25 |
2344066 | 2344066 | 2022-03-26 | Miami | Indiana | 18103 | 9258 | 159 |
2344067 | 2344067 | 2022-03-26 | Monroe | Indiana | 18105 | 27601 | 279 |
2344068 | 2344068 | 2022-03-26 | Montgomery | Indiana | 18107 | 10661 | 164 |
2344069 | 2344069 | 2022-03-26 | Morgan | Indiana | 18109 | 16463 | 286 |
2344070 | 2344070 | 2022-03-26 | Newton | Indiana | 18111 | 2560 | 68 |
2344071 | 2344071 | 2022-03-26 | Noble | Indiana | 18113 | 13059 | 156 |
2344072 | 2344072 | 2022-03-26 | Ohio | Indiana | 18115 | 1443 | 19 |
2344073 | 2344073 | 2022-03-26 | Orange | Indiana | 18117 | 5033 | 96 |
2344074 | 2344074 | 2022-03-26 | Owen | Indiana | 18119 | 5830 | 118 |
2344075 | 2344075 | 2022-03-26 | Parke | Indiana | 18121 | 3608 | 49 |
2344076 | 2344076 | 2022-03-26 | Perry | Indiana | 18123 | 4665 | 68 |
2344077 | 2344077 | 2022-03-26 | Pike | Indiana | 18125 | 3726 | 49 |
2344078 | 2344078 | 2022-03-26 | Porter | Indiana | 18127 | 37563 | 557 |
2344079 | 2344079 | 2022-03-26 | Posey | Indiana | 18129 | 6527 | 58 |
2344080 | 2344080 | 2022-03-26 | Pulaski | Indiana | 18131 | 3070 | 86 |
2344081 | 2344081 | 2022-03-26 | Putnam | Indiana | 18133 | 9318 | 127 |
2344082 | 2344082 | 2022-03-26 | Randolph | Indiana | 18135 | 5935 | 147 |
2344083 | 2344083 | 2022-03-26 | Ripley | Indiana | 18137 | 8281 | 138 |
2344084 | 2344084 | 2022-03-26 | Rush | Indiana | 18139 | 4906 | 58 |
2344085 | 2344085 | 2022-03-26 | Scott | Indiana | 18143 | 7862 | 106 |
2344086 | 2344086 | 2022-03-26 | Shelby | Indiana | 18145 | 14674 | 181 |
2344087 | 2344087 | 2022-03-26 | Spencer | Indiana | 18147 | 5219 | 60 |
2344088 | 2344088 | 2022-03-26 | St. Joseph | Indiana | 18141 | 70522 | 863 |
2344089 | 2344089 | 2022-03-26 | Starke | Indiana | 18149 | 4744 | 96 |
2344090 | 2344090 | 2022-03-26 | Steuben | Indiana | 18151 | 9622 | 120 |
2344091 | 2344091 | 2022-03-26 | Sullivan | Indiana | 18153 | 5275 | 76 |
2344092 | 2344092 | 2022-03-26 | Switzerland | Indiana | 18155 | 2308 | 20 |
2344093 | 2344093 | 2022-03-26 | Tippecanoe | Indiana | 18157 | 49866 | 392 |
2344094 | 2344094 | 2022-03-26 | Tipton | Indiana | 18159 | 3528 | 87 |
2344095 | 2344095 | 2022-03-26 | Union | Indiana | 18161 | 2046 | 21 |
2344096 | 2344096 | 2022-03-26 | Vanderburgh | Indiana | 18163 | 57237 | 621 |
2344097 | 2344097 | 2022-03-26 | Vermillion | Indiana | 18165 | 4068 | 74 |
2344098 | 2344098 | 2022-03-26 | Vigo | Indiana | 18167 | 28826 | 410 |
2344099 | 2344099 | 2022-03-26 | Wabash | Indiana | 18169 | 8714 | 154 |
2344100 | 2344100 | 2022-03-26 | Warren | Indiana | 18171 | 2083 | 30 |
2344101 | 2344101 | 2022-03-26 | Warrick | Indiana | 18173 | 20244 | 237 |
2344102 | 2344102 | 2022-03-26 | Washington | Indiana | 18175 | 5989 | 81 |
2344103 | 2344103 | 2022-03-26 | Wayne | Indiana | 18177 | 19194 | 334 |
2344104 | 2344104 | 2022-03-26 | Wells | Indiana | 18179 | 6521 | 132 |
2344105 | 2344105 | 2022-03-26 | White | Indiana | 18181 | 6845 | 93 |
2344106 | 2344106 | 2022-03-26 | Whitley | Indiana | 18183 | 9647 | 83 |
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);