ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-10-06" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1788078 | 1788078 | 2021-10-06 | Adams | Indiana | 18001 | 4680 | 71 |
1788079 | 1788079 | 2021-10-06 | Allen | Indiana | 18003 | 55794 | 811 |
1788080 | 1788080 | 2021-10-06 | Bartholomew | Indiana | 18005 | 11165 | 182 |
1788081 | 1788081 | 2021-10-06 | Benton | Indiana | 18007 | 1476 | 16 |
1788082 | 1788082 | 2021-10-06 | Blackford | Indiana | 18009 | 1797 | 38 |
1788083 | 1788083 | 2021-10-06 | Boone | Indiana | 18011 | 8690 | 121 |
1788084 | 1788084 | 2021-10-06 | Brown | Indiana | 18013 | 1401 | 47 |
1788085 | 1788085 | 2021-10-06 | Carroll | Indiana | 18015 | 2527 | 33 |
1788086 | 1788086 | 2021-10-06 | Cass | Indiana | 18017 | 7340 | 121 |
1788087 | 1788087 | 2021-10-06 | Clark | Indiana | 18019 | 18069 | 251 |
1788088 | 1788088 | 2021-10-06 | Clay | Indiana | 18021 | 4080 | 60 |
1788089 | 1788089 | 2021-10-06 | Clinton | Indiana | 18023 | 5515 | 74 |
1788090 | 1788090 | 2021-10-06 | Crawford | Indiana | 18025 | 1533 | 22 |
1788091 | 1788091 | 2021-10-06 | Daviess | Indiana | 18027 | 4447 | 113 |
1788092 | 1788092 | 2021-10-06 | DeKalb | Indiana | 18033 | 6062 | 98 |
1788093 | 1788093 | 2021-10-06 | Dearborn | Indiana | 18029 | 7997 | 95 |
1788094 | 1788094 | 2021-10-06 | Decatur | Indiana | 18031 | 4094 | 105 |
1788095 | 1788095 | 2021-10-06 | Delaware | Indiana | 18035 | 14683 | 255 |
1788096 | 1788096 | 2021-10-06 | Dubois | Indiana | 18037 | 8045 | 127 |
1788097 | 1788097 | 2021-10-06 | Elkhart | Indiana | 18039 | 34922 | 515 |
1788098 | 1788098 | 2021-10-06 | Fayette | Indiana | 18041 | 4084 | 89 |
1788099 | 1788099 | 2021-10-06 | Floyd | Indiana | 18043 | 10823 | 219 |
1788100 | 1788100 | 2021-10-06 | Fountain | Indiana | 18045 | 3267 | 60 |
1788101 | 1788101 | 2021-10-06 | Franklin | Indiana | 18047 | 2570 | 44 |
1788102 | 1788102 | 2021-10-06 | Fulton | Indiana | 18049 | 2952 | 62 |
1788103 | 1788103 | 2021-10-06 | Gibson | Indiana | 18051 | 6389 | 113 |
1788104 | 1788104 | 2021-10-06 | Grant | Indiana | 18053 | 9989 | 223 |
1788105 | 1788105 | 2021-10-06 | Greene | Indiana | 18055 | 4110 | 99 |
1788106 | 1788106 | 2021-10-06 | Hamilton | Indiana | 18057 | 45286 | 475 |
1788107 | 1788107 | 2021-10-06 | Hancock | Indiana | 18059 | 11410 | 180 |
1788108 | 1788108 | 2021-10-06 | Harrison | Indiana | 18061 | 6264 | 93 |
1788109 | 1788109 | 2021-10-06 | Hendricks | Indiana | 18063 | 23232 | 370 |
1788110 | 1788110 | 2021-10-06 | Henry | Indiana | 18065 | 7981 | 150 |
1788111 | 1788111 | 2021-10-06 | Howard | Indiana | 18067 | 14348 | 285 |
1788112 | 1788112 | 2021-10-06 | Huntington | Indiana | 18069 | 6203 | 99 |
1788113 | 1788113 | 2021-10-06 | Jackson | Indiana | 18071 | 6800 | 88 |
1788114 | 1788114 | 2021-10-06 | Jasper | Indiana | 18073 | 5064 | 71 |
1788115 | 1788115 | 2021-10-06 | Jay | Indiana | 18075 | 2730 | 46 |
1788116 | 1788116 | 2021-10-06 | Jefferson | Indiana | 18077 | 4946 | 98 |
1788117 | 1788117 | 2021-10-06 | Jennings | Indiana | 18079 | 3757 | 60 |
1788118 | 1788118 | 2021-10-06 | Johnson | Indiana | 18081 | 24471 | 451 |
1788119 | 1788119 | 2021-10-06 | Knox | Indiana | 18083 | 5915 | 105 |
1788120 | 1788120 | 2021-10-06 | Kosciusko | Indiana | 18085 | 11896 | 150 |
1788121 | 1788121 | 2021-10-06 | LaGrange | Indiana | 18087 | 3411 | 79 |
1788122 | 1788122 | 2021-10-06 | LaPorte | Indiana | 18091 | 14768 | 247 |
1788123 | 1788123 | 2021-10-06 | Lake | Indiana | 18089 | 64997 | 1177 |
1788124 | 1788124 | 2021-10-06 | Lawrence | Indiana | 18093 | 7269 | 169 |
1788125 | 1788125 | 2021-10-06 | Madison | Indiana | 18095 | 18138 | 420 |
1788126 | 1788126 | 2021-10-06 | Marion | Indiana | 18097 | 132636 | 2127 |
1788127 | 1788127 | 2021-10-06 | Marshall | Indiana | 18099 | 7615 | 135 |
1788128 | 1788128 | 2021-10-06 | Martin | Indiana | 18101 | 1348 | 19 |
1788129 | 1788129 | 2021-10-06 | Miami | Indiana | 18103 | 5749 | 94 |
1788130 | 1788130 | 2021-10-06 | Monroe | Indiana | 18105 | 14888 | 199 |
1788131 | 1788131 | 2021-10-06 | Montgomery | Indiana | 18107 | 6053 | 110 |
1788132 | 1788132 | 2021-10-06 | Morgan | Indiana | 18109 | 9223 | 179 |
1788133 | 1788133 | 2021-10-06 | Newton | Indiana | 18111 | 1519 | 49 |
1788134 | 1788134 | 2021-10-06 | Noble | Indiana | 18113 | 7683 | 107 |
1788135 | 1788135 | 2021-10-06 | Ohio | Indiana | 18115 | 831 | 12 |
1788136 | 1788136 | 2021-10-06 | Orange | Indiana | 18117 | 2842 | 64 |
1788137 | 1788137 | 2021-10-06 | Owen | Indiana | 18119 | 3007 | 69 |
1788138 | 1788138 | 2021-10-06 | Parke | Indiana | 18121 | 2286 | 25 |
1788139 | 1788139 | 2021-10-06 | Perry | Indiana | 18123 | 2629 | 57 |
1788140 | 1788140 | 2021-10-06 | Pike | Indiana | 18125 | 2219 | 42 |
1788141 | 1788141 | 2021-10-06 | Porter | Indiana | 18127 | 22373 | 368 |
1788142 | 1788142 | 2021-10-06 | Posey | Indiana | 18129 | 3693 | 42 |
1788143 | 1788143 | 2021-10-06 | Pulaski | Indiana | 18131 | 1751 | 52 |
1788144 | 1788144 | 2021-10-06 | Putnam | Indiana | 18133 | 5622 | 75 |
1788145 | 1788145 | 2021-10-06 | Randolph | Indiana | 18135 | 3346 | 95 |
1788146 | 1788146 | 2021-10-06 | Ripley | Indiana | 18137 | 4785 | 81 |
1788147 | 1788147 | 2021-10-06 | Rush | Indiana | 18139 | 2559 | 32 |
1788148 | 1788148 | 2021-10-06 | Scott | Indiana | 18143 | 4258 | 70 |
1788149 | 1788149 | 2021-10-06 | Shelby | Indiana | 18145 | 7919 | 124 |
1788150 | 1788150 | 2021-10-06 | Spencer | Indiana | 18147 | 3314 | 38 |
1788151 | 1788151 | 2021-10-06 | St. Joseph | Indiana | 18141 | 43196 | 617 |
1788152 | 1788152 | 2021-10-06 | Starke | Indiana | 18149 | 3019 | 69 |
1788153 | 1788153 | 2021-10-06 | Steuben | Indiana | 18151 | 5303 | 72 |
1788154 | 1788154 | 2021-10-06 | Sullivan | Indiana | 18153 | 3217 | 52 |
1788155 | 1788155 | 2021-10-06 | Switzerland | Indiana | 18155 | 1312 | 11 |
1788156 | 1788156 | 2021-10-06 | Tippecanoe | Indiana | 18157 | 27334 | 258 |
1788157 | 1788157 | 2021-10-06 | Tipton | Indiana | 18159 | 2201 | 59 |
1788158 | 1788158 | 2021-10-06 | Union | Indiana | 18161 | 1065 | 16 |
1788159 | 1788159 | 2021-10-06 | Vanderburgh | Indiana | 18163 | 31375 | 477 |
1788160 | 1788160 | 2021-10-06 | Vermillion | Indiana | 18165 | 2475 | 52 |
1788161 | 1788161 | 2021-10-06 | Vigo | Indiana | 18167 | 16906 | 301 |
1788162 | 1788162 | 2021-10-06 | Wabash | Indiana | 18169 | 5097 | 96 |
1788163 | 1788163 | 2021-10-06 | Warren | Indiana | 18171 | 1179 | 18 |
1788164 | 1788164 | 2021-10-06 | Warrick | Indiana | 18173 | 11022 | 187 |
1788165 | 1788165 | 2021-10-06 | Washington | Indiana | 18175 | 3439 | 47 |
1788166 | 1788166 | 2021-10-06 | Wayne | Indiana | 18177 | 10913 | 244 |
1788167 | 1788167 | 2021-10-06 | Wells | Indiana | 18179 | 4083 | 88 |
1788168 | 1788168 | 2021-10-06 | White | Indiana | 18181 | 4059 | 60 |
1788169 | 1788169 | 2021-10-06 | Whitley | Indiana | 18183 | 5476 | 55 |
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);