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-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 |
---|---|---|---|---|---|---|---|
2370040 | 2370040 | 2022-04-03 | Adams | Indiana | 18001 | 7258 | 112 |
2370041 | 2370041 | 2022-04-03 | Allen | Indiana | 18003 | 103678 | 1174 |
2370042 | 2370042 | 2022-04-03 | Bartholomew | Indiana | 18005 | 21304 | 249 |
2370043 | 2370043 | 2022-04-03 | Benton | Indiana | 18007 | 2477 | 21 |
2370044 | 2370044 | 2022-04-03 | Blackford | Indiana | 18009 | 3107 | 69 |
2370045 | 2370045 | 2022-04-03 | Boone | Indiana | 18011 | 15173 | 181 |
2370046 | 2370046 | 2022-04-03 | Brown | Indiana | 18013 | 2585 | 62 |
2370047 | 2370047 | 2022-04-03 | Carroll | Indiana | 18015 | 4216 | 68 |
2370048 | 2370048 | 2022-04-03 | Cass | Indiana | 18017 | 11655 | 163 |
2370049 | 2370049 | 2022-04-03 | Clark | Indiana | 18019 | 31038 | 396 |
2370050 | 2370050 | 2022-04-03 | Clay | Indiana | 18021 | 6823 | 88 |
2370051 | 2370051 | 2022-04-03 | Clinton | Indiana | 18023 | 9181 | 125 |
2370052 | 2370052 | 2022-04-03 | Crawford | Indiana | 18025 | 2546 | 39 |
2370053 | 2370053 | 2022-04-03 | Daviess | Indiana | 18027 | 7467 | 153 |
2370054 | 2370054 | 2022-04-03 | DeKalb | Indiana | 18033 | 11339 | 149 |
2370055 | 2370055 | 2022-04-03 | Dearborn | Indiana | 18029 | 13419 | 139 |
2370056 | 2370056 | 2022-04-03 | Decatur | Indiana | 18031 | 6992 | 145 |
2370057 | 2370057 | 2022-04-03 | Delaware | Indiana | 18035 | 24787 | 440 |
2370058 | 2370058 | 2022-04-03 | Dubois | Indiana | 18037 | 12853 | 165 |
2370059 | 2370059 | 2022-04-03 | Elkhart | Indiana | 18039 | 54043 | 728 |
2370060 | 2370060 | 2022-04-03 | Fayette | Indiana | 18041 | 6731 | 146 |
2370061 | 2370061 | 2022-04-03 | Floyd | Indiana | 18043 | 18902 | 299 |
2370062 | 2370062 | 2022-04-03 | Fountain | Indiana | 18045 | 5405 | 102 |
2370063 | 2370063 | 2022-04-03 | Franklin | Indiana | 18047 | 4373 | 65 |
2370064 | 2370064 | 2022-04-03 | Fulton | Indiana | 18049 | 4912 | 102 |
2370065 | 2370065 | 2022-04-03 | Gibson | Indiana | 18051 | 11629 | 145 |
2370066 | 2370066 | 2022-04-03 | Grant | Indiana | 18053 | 17280 | 347 |
2370067 | 2370067 | 2022-04-03 | Greene | Indiana | 18055 | 7193 | 139 |
2370068 | 2370068 | 2022-04-03 | Hamilton | Indiana | 18057 | 81748 | 656 |
2370069 | 2370069 | 2022-04-03 | Hancock | Indiana | 18059 | 20636 | 258 |
2370070 | 2370070 | 2022-04-03 | Harrison | Indiana | 18061 | 10801 | 138 |
2370071 | 2370071 | 2022-04-03 | Hendricks | Indiana | 18063 | 40692 | 553 |
2370072 | 2370072 | 2022-04-03 | Henry | Indiana | 18065 | 12965 | 230 |
2370073 | 2370073 | 2022-04-03 | Howard | Indiana | 18067 | 25382 | 446 |
2370074 | 2370074 | 2022-04-03 | Huntington | Indiana | 18069 | 11486 | 155 |
2370075 | 2370075 | 2022-04-03 | Jackson | Indiana | 18071 | 12508 | 130 |
2370076 | 2370076 | 2022-04-03 | Jasper | Indiana | 18073 | 9008 | 148 |
2370077 | 2370077 | 2022-04-03 | Jay | Indiana | 18075 | 4835 | 78 |
2370078 | 2370078 | 2022-04-03 | Jefferson | Indiana | 18077 | 9338 | 156 |
2370079 | 2370079 | 2022-04-03 | Jennings | Indiana | 18079 | 6936 | 108 |
2370080 | 2370080 | 2022-04-03 | Johnson | Indiana | 18081 | 42234 | 612 |
2370081 | 2370081 | 2022-04-03 | Knox | Indiana | 18083 | 10739 | 153 |
2370082 | 2370082 | 2022-04-03 | Kosciusko | Indiana | 18085 | 19724 | 237 |
2370083 | 2370083 | 2022-04-03 | LaGrange | Indiana | 18087 | 5843 | 102 |
2370084 | 2370084 | 2022-04-03 | LaPorte | Indiana | 18091 | 25417 | 367 |
2370085 | 2370085 | 2022-04-03 | Lake | Indiana | 18089 | 106092 | 1816 |
2370086 | 2370086 | 2022-04-03 | Lawrence | Indiana | 18093 | 11840 | 259 |
2370087 | 2370087 | 2022-04-03 | Madison | Indiana | 18095 | 32633 | 648 |
2370088 | 2370088 | 2022-04-03 | Marion | Indiana | 18097 | 224788 | 2978 |
2370089 | 2370089 | 2022-04-03 | Marshall | Indiana | 18099 | 12316 | 195 |
2370090 | 2370090 | 2022-04-03 | Martin | Indiana | 18101 | 2162 | 25 |
2370091 | 2370091 | 2022-04-03 | Miami | Indiana | 18103 | 9251 | 159 |
2370092 | 2370092 | 2022-04-03 | Monroe | Indiana | 18105 | 27640 | 279 |
2370093 | 2370093 | 2022-04-03 | Montgomery | Indiana | 18107 | 10660 | 164 |
2370094 | 2370094 | 2022-04-03 | Morgan | Indiana | 18109 | 16440 | 286 |
2370095 | 2370095 | 2022-04-03 | Newton | Indiana | 18111 | 2560 | 68 |
2370096 | 2370096 | 2022-04-03 | Noble | Indiana | 18113 | 13064 | 156 |
2370097 | 2370097 | 2022-04-03 | Ohio | Indiana | 18115 | 1443 | 19 |
2370098 | 2370098 | 2022-04-03 | Orange | Indiana | 18117 | 5029 | 96 |
2370099 | 2370099 | 2022-04-03 | Owen | Indiana | 18119 | 5832 | 120 |
2370100 | 2370100 | 2022-04-03 | Parke | Indiana | 18121 | 3588 | 49 |
2370101 | 2370101 | 2022-04-03 | Perry | Indiana | 18123 | 4650 | 68 |
2370102 | 2370102 | 2022-04-03 | Pike | Indiana | 18125 | 3726 | 49 |
2370103 | 2370103 | 2022-04-03 | Porter | Indiana | 18127 | 37583 | 558 |
2370104 | 2370104 | 2022-04-03 | Posey | Indiana | 18129 | 6529 | 58 |
2370105 | 2370105 | 2022-04-03 | Pulaski | Indiana | 18131 | 3066 | 86 |
2370106 | 2370106 | 2022-04-03 | Putnam | Indiana | 18133 | 9308 | 128 |
2370107 | 2370107 | 2022-04-03 | Randolph | Indiana | 18135 | 5893 | 147 |
2370108 | 2370108 | 2022-04-03 | Ripley | Indiana | 18137 | 8279 | 138 |
2370109 | 2370109 | 2022-04-03 | Rush | Indiana | 18139 | 4835 | 58 |
2370110 | 2370110 | 2022-04-03 | Scott | Indiana | 18143 | 7855 | 106 |
2370111 | 2370111 | 2022-04-03 | Shelby | Indiana | 18145 | 13582 | 181 |
2370112 | 2370112 | 2022-04-03 | Spencer | Indiana | 18147 | 5217 | 60 |
2370113 | 2370113 | 2022-04-03 | St. Joseph | Indiana | 18141 | 70541 | 865 |
2370114 | 2370114 | 2022-04-03 | Starke | Indiana | 18149 | 4744 | 96 |
2370115 | 2370115 | 2022-04-03 | Steuben | Indiana | 18151 | 9614 | 120 |
2370116 | 2370116 | 2022-04-03 | Sullivan | Indiana | 18153 | 5269 | 76 |
2370117 | 2370117 | 2022-04-03 | Switzerland | Indiana | 18155 | 2311 | 20 |
2370118 | 2370118 | 2022-04-03 | Tippecanoe | Indiana | 18157 | 49936 | 394 |
2370119 | 2370119 | 2022-04-03 | Tipton | Indiana | 18159 | 3520 | 87 |
2370120 | 2370120 | 2022-04-03 | Union | Indiana | 18161 | 2016 | 21 |
2370121 | 2370121 | 2022-04-03 | Vanderburgh | Indiana | 18163 | 57237 | 624 |
2370122 | 2370122 | 2022-04-03 | Vermillion | Indiana | 18165 | 4072 | 75 |
2370123 | 2370123 | 2022-04-03 | Vigo | Indiana | 18167 | 28822 | 411 |
2370124 | 2370124 | 2022-04-03 | Wabash | Indiana | 18169 | 8715 | 155 |
2370125 | 2370125 | 2022-04-03 | Warren | Indiana | 18171 | 2090 | 30 |
2370126 | 2370126 | 2022-04-03 | Warrick | Indiana | 18173 | 20252 | 238 |
2370127 | 2370127 | 2022-04-03 | Washington | Indiana | 18175 | 5989 | 81 |
2370128 | 2370128 | 2022-04-03 | Wayne | Indiana | 18177 | 18825 | 334 |
2370129 | 2370129 | 2022-04-03 | Wells | Indiana | 18179 | 6495 | 132 |
2370130 | 2370130 | 2022-04-03 | White | Indiana | 18181 | 6855 | 94 |
2370131 | 2370131 | 2022-04-03 | Whitley | Indiana | 18183 | 9648 | 84 |
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);