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 2021-12-13 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2009062 | 2009062 | 2021-12-13 | Adams | Indiana | 18001 | 5716 | 83 |
2009063 | 2009063 | 2021-12-13 | Allen | Indiana | 18003 | 70199 | 929 |
2009064 | 2009064 | 2021-12-13 | Bartholomew | Indiana | 18005 | 13608 | 201 |
2009065 | 2009065 | 2021-12-13 | Benton | Indiana | 18007 | 1766 | 18 |
2009066 | 2009066 | 2021-12-13 | Blackford | Indiana | 18009 | 2335 | 47 |
2009067 | 2009067 | 2021-12-13 | Boone | Indiana | 18011 | 10223 | 134 |
2009068 | 2009068 | 2021-12-13 | Brown | Indiana | 18013 | 1865 | 51 |
2009069 | 2009069 | 2021-12-13 | Carroll | Indiana | 18015 | 3137 | 44 |
2009070 | 2009070 | 2021-12-13 | Cass | Indiana | 18017 | 8455 | 134 |
2009071 | 2009071 | 2021-12-13 | Clark | Indiana | 18019 | 20773 | 294 |
2009072 | 2009072 | 2021-12-13 | Clay | Indiana | 18021 | 4799 | 63 |
2009073 | 2009073 | 2021-12-13 | Clinton | Indiana | 18023 | 6501 | 88 |
2009074 | 2009074 | 2021-12-13 | Crawford | Indiana | 18025 | 1755 | 30 |
2009075 | 2009075 | 2021-12-13 | Daviess | Indiana | 18027 | 5255 | 121 |
2009076 | 2009076 | 2021-12-13 | DeKalb | Indiana | 18033 | 8270 | 115 |
2009077 | 2009077 | 2021-12-13 | Dearborn | Indiana | 18029 | 9262 | 110 |
2009078 | 2009078 | 2021-12-13 | Decatur | Indiana | 18031 | 4864 | 117 |
2009079 | 2009079 | 2021-12-13 | Delaware | Indiana | 18035 | 17541 | 320 |
2009080 | 2009080 | 2021-12-13 | Dubois | Indiana | 18037 | 9040 | 145 |
2009081 | 2009081 | 2021-12-13 | Elkhart | Indiana | 18039 | 41633 | 584 |
2009082 | 2009082 | 2021-12-13 | Fayette | Indiana | 18041 | 4965 | 105 |
2009083 | 2009083 | 2021-12-13 | Floyd | Indiana | 18043 | 12362 | 241 |
2009084 | 2009084 | 2021-12-13 | Fountain | Indiana | 18045 | 3951 | 70 |
2009085 | 2009085 | 2021-12-13 | Franklin | Indiana | 18047 | 3083 | 50 |
2009086 | 2009086 | 2021-12-13 | Fulton | Indiana | 18049 | 3768 | 77 |
2009087 | 2009087 | 2021-12-13 | Gibson | Indiana | 18051 | 7379 | 123 |
2009088 | 2009088 | 2021-12-13 | Grant | Indiana | 18053 | 13048 | 266 |
2009089 | 2009089 | 2021-12-13 | Greene | Indiana | 18055 | 4900 | 107 |
2009090 | 2009090 | 2021-12-13 | Hamilton | Indiana | 18057 | 53298 | 521 |
2009091 | 2009091 | 2021-12-13 | Hancock | Indiana | 18059 | 13751 | 194 |
2009092 | 2009092 | 2021-12-13 | Harrison | Indiana | 18061 | 7237 | 105 |
2009093 | 2009093 | 2021-12-13 | Hendricks | Indiana | 18063 | 27321 | 416 |
2009094 | 2009094 | 2021-12-13 | Henry | Indiana | 18065 | 9560 | 177 |
2009095 | 2009095 | 2021-12-13 | Howard | Indiana | 18067 | 17430 | 329 |
2009096 | 2009096 | 2021-12-13 | Huntington | Indiana | 18069 | 8073 | 121 |
2009097 | 2009097 | 2021-12-13 | Jackson | Indiana | 18071 | 8145 | 97 |
2009098 | 2009098 | 2021-12-13 | Jasper | Indiana | 18073 | 6477 | 101 |
2009099 | 2009099 | 2021-12-13 | Jay | Indiana | 18075 | 3517 | 57 |
2009100 | 2009100 | 2021-12-13 | Jefferson | Indiana | 18077 | 6247 | 110 |
2009101 | 2009101 | 2021-12-13 | Jennings | Indiana | 18079 | 4733 | 70 |
2009102 | 2009102 | 2021-12-13 | Johnson | Indiana | 18081 | 28692 | 492 |
2009103 | 2009103 | 2021-12-13 | Knox | Indiana | 18083 | 7170 | 119 |
2009104 | 2009104 | 2021-12-13 | Kosciusko | Indiana | 18085 | 15002 | 174 |
2009105 | 2009105 | 2021-12-13 | LaGrange | Indiana | 18087 | 4496 | 94 |
2009106 | 2009106 | 2021-12-13 | LaPorte | Indiana | 18091 | 17990 | 275 |
2009107 | 2009107 | 2021-12-13 | Lake | Indiana | 18089 | 75347 | 1325 |
2009108 | 2009108 | 2021-12-13 | Lawrence | Indiana | 18093 | 8351 | 192 |
2009109 | 2009109 | 2021-12-13 | Madison | Indiana | 18095 | 22069 | 492 |
2009110 | 2009110 | 2021-12-13 | Marion | Indiana | 18097 | 150255 | 2360 |
2009111 | 2009111 | 2021-12-13 | Marshall | Indiana | 18099 | 9550 | 156 |
2009112 | 2009112 | 2021-12-13 | Martin | Indiana | 18101 | 1558 | 20 |
2009113 | 2009113 | 2021-12-13 | Miami | Indiana | 18103 | 6846 | 117 |
2009114 | 2009114 | 2021-12-13 | Monroe | Indiana | 18105 | 17182 | 225 |
2009115 | 2009115 | 2021-12-13 | Montgomery | Indiana | 18107 | 7476 | 125 |
2009116 | 2009116 | 2021-12-13 | Morgan | Indiana | 18109 | 10867 | 208 |
2009117 | 2009117 | 2021-12-13 | Newton | Indiana | 18111 | 1907 | 56 |
2009118 | 2009118 | 2021-12-13 | Noble | Indiana | 18113 | 9730 | 130 |
2009119 | 2009119 | 2021-12-13 | Ohio | Indiana | 18115 | 946 | 13 |
2009120 | 2009120 | 2021-12-13 | Orange | Indiana | 18117 | 3468 | 79 |
2009121 | 2009121 | 2021-12-13 | Owen | Indiana | 18119 | 3687 | 81 |
2009122 | 2009122 | 2021-12-13 | Parke | Indiana | 18121 | 2588 | 33 |
2009123 | 2009123 | 2021-12-13 | Perry | Indiana | 18123 | 3055 | 58 |
2009124 | 2009124 | 2021-12-13 | Pike | Indiana | 18125 | 2618 | 46 |
2009125 | 2009125 | 2021-12-13 | Porter | Indiana | 18127 | 26727 | 411 |
2009126 | 2009126 | 2021-12-13 | Posey | Indiana | 18129 | 4231 | 45 |
2009127 | 2009127 | 2021-12-13 | Pulaski | Indiana | 18131 | 2200 | 61 |
2009128 | 2009128 | 2021-12-13 | Putnam | Indiana | 18133 | 6659 | 90 |
2009129 | 2009129 | 2021-12-13 | Randolph | Indiana | 18135 | 4222 | 111 |
2009130 | 2009130 | 2021-12-13 | Ripley | Indiana | 18137 | 5847 | 96 |
2009131 | 2009131 | 2021-12-13 | Rush | Indiana | 18139 | 3327 | 33 |
2009132 | 2009132 | 2021-12-13 | Scott | Indiana | 18143 | 5143 | 83 |
2009133 | 2009133 | 2021-12-13 | Shelby | Indiana | 18145 | 9779 | 147 |
2009134 | 2009134 | 2021-12-13 | Spencer | Indiana | 18147 | 3756 | 50 |
2009135 | 2009135 | 2021-12-13 | St. Joseph | Indiana | 18141 | 52034 | 683 |
2009136 | 2009136 | 2021-12-13 | Starke | Indiana | 18149 | 3740 | 79 |
2009137 | 2009137 | 2021-12-13 | Steuben | Indiana | 18151 | 7013 | 92 |
2009138 | 2009138 | 2021-12-13 | Sullivan | Indiana | 18153 | 3599 | 58 |
2009139 | 2009139 | 2021-12-13 | Switzerland | Indiana | 18155 | 1527 | 14 |
2009140 | 2009140 | 2021-12-13 | Tippecanoe | Indiana | 18157 | 32138 | 288 |
2009141 | 2009141 | 2021-12-13 | Tipton | Indiana | 18159 | 2599 | 70 |
2009142 | 2009142 | 2021-12-13 | Union | Indiana | 18161 | 1321 | 17 |
2009143 | 2009143 | 2021-12-13 | Vanderburgh | Indiana | 18163 | 35762 | 517 |
2009144 | 2009144 | 2021-12-13 | Vermillion | Indiana | 18165 | 2932 | 59 |
2009145 | 2009145 | 2021-12-13 | Vigo | Indiana | 18167 | 19704 | 324 |
2009146 | 2009146 | 2021-12-13 | Wabash | Indiana | 18169 | 6530 | 119 |
2009147 | 2009147 | 2021-12-13 | Warren | Indiana | 18171 | 1444 | 19 |
2009148 | 2009148 | 2021-12-13 | Warrick | Indiana | 18173 | 12696 | 200 |
2009149 | 2009149 | 2021-12-13 | Washington | Indiana | 18175 | 4033 | 57 |
2009150 | 2009150 | 2021-12-13 | Wayne | Indiana | 18177 | 12876 | 278 |
2009151 | 2009151 | 2021-12-13 | Wells | Indiana | 18179 | 5088 | 113 |
2009152 | 2009152 | 2021-12-13 | White | Indiana | 18181 | 5005 | 72 |
2009153 | 2009153 | 2021-12-13 | Whitley | Indiana | 18183 | 6912 | 63 |
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);