ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where "date" is on date 2020-12-15 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
832191 | 832191 | 2020-12-15 | Anderson | Texas | 48001 | 4003 | 54 |
832192 | 832192 | 2020-12-15 | Andrews | Texas | 48003 | 1237 | 19 |
832193 | 832193 | 2020-12-15 | Angelina | Texas | 48005 | 4607 | 116 |
832194 | 832194 | 2020-12-15 | Aransas | Texas | 48007 | 612 | 21 |
832195 | 832195 | 2020-12-15 | Archer | Texas | 48009 | 423 | 4 |
832196 | 832196 | 2020-12-15 | Armstrong | Texas | 48011 | 96 | 4 |
832197 | 832197 | 2020-12-15 | Atascosa | Texas | 48013 | 2376 | 51 |
832198 | 832198 | 2020-12-15 | Austin | Texas | 48015 | 795 | 13 |
832199 | 832199 | 2020-12-15 | Bailey | Texas | 48017 | 693 | 11 |
832200 | 832200 | 2020-12-15 | Bandera | Texas | 48019 | 420 | 11 |
832201 | 832201 | 2020-12-15 | Bastrop | Texas | 48021 | 3228 | 39 |
832202 | 832202 | 2020-12-15 | Baylor | Texas | 48023 | 153 | 5 |
832203 | 832203 | 2020-12-15 | Bee | Texas | 48025 | 2343 | 40 |
832204 | 832204 | 2020-12-15 | Bell | Texas | 48027 | 10536 | 140 |
832205 | 832205 | 2020-12-15 | Bexar | Texas | 48029 | 96152 | 1582 |
832206 | 832206 | 2020-12-15 | Blanco | Texas | 48031 | 244 | 7 |
832207 | 832207 | 2020-12-15 | Borden | Texas | 48033 | 16 | 0 |
832208 | 832208 | 2020-12-15 | Bosque | Texas | 48035 | 657 | 16 |
832209 | 832209 | 2020-12-15 | Bowie | Texas | 48037 | 3513 | 111 |
832210 | 832210 | 2020-12-15 | Brazoria | Texas | 48039 | 17511 | 212 |
832211 | 832211 | 2020-12-15 | Brazos | Texas | 48041 | 12634 | 124 |
832212 | 832212 | 2020-12-15 | Brewster | Texas | 48043 | 797 | 6 |
832213 | 832213 | 2020-12-15 | Briscoe | Texas | 48045 | 77 | 2 |
832214 | 832214 | 2020-12-15 | Brooks | Texas | 48047 | 517 | 27 |
832215 | 832215 | 2020-12-15 | Brown | Texas | 48049 | 2256 | 53 |
832216 | 832216 | 2020-12-15 | Burleson | Texas | 48051 | 842 | 13 |
832217 | 832217 | 2020-12-15 | Burnet | Texas | 48053 | 1751 | 20 |
832218 | 832218 | 2020-12-15 | Caldwell | Texas | 48055 | 2156 | 40 |
832219 | 832219 | 2020-12-15 | Calhoun | Texas | 48057 | 1106 | 10 |
832220 | 832220 | 2020-12-15 | Callahan | Texas | 48059 | 582 | 10 |
832221 | 832221 | 2020-12-15 | Cameron | Texas | 48061 | 27742 | 1153 |
832222 | 832222 | 2020-12-15 | Camp | Texas | 48063 | 659 | 19 |
832223 | 832223 | 2020-12-15 | Carson | Texas | 48065 | 246 | 4 |
832224 | 832224 | 2020-12-15 | Cass | Texas | 48067 | 1189 | 42 |
832225 | 832225 | 2020-12-15 | Castro | Texas | 48069 | 711 | 12 |
832226 | 832226 | 2020-12-15 | Chambers | Texas | 48071 | 2357 | 22 |
832227 | 832227 | 2020-12-15 | Cherokee | Texas | 48073 | 2756 | 68 |
832228 | 832228 | 2020-12-15 | Childress | Texas | 48075 | 1127 | 3 |
832229 | 832229 | 2020-12-15 | Clay | Texas | 48077 | 537 | 8 |
832230 | 832230 | 2020-12-15 | Cochran | Texas | 48079 | 189 | 5 |
832231 | 832231 | 2020-12-15 | Coke | Texas | 48081 | 337 | 9 |
832232 | 832232 | 2020-12-15 | Coleman | Texas | 48083 | 308 | 11 |
832233 | 832233 | 2020-12-15 | Collin | Texas | 48085 | 36640 | 302 |
832234 | 832234 | 2020-12-15 | Collingsworth | Texas | 48087 | 194 | 3 |
832235 | 832235 | 2020-12-15 | Colorado | Texas | 48089 | 878 | 11 |
832236 | 832236 | 2020-12-15 | Comal | Texas | 48091 | 5420 | 138 |
832237 | 832237 | 2020-12-15 | Comanche | Texas | 48093 | 818 | 15 |
832238 | 832238 | 2020-12-15 | Concho | Texas | 48095 | 186 | 3 |
832239 | 832239 | 2020-12-15 | Cooke | Texas | 48097 | 1706 | 21 |
832240 | 832240 | 2020-12-15 | Coryell | Texas | 48099 | 2873 | 22 |
832241 | 832241 | 2020-12-15 | Cottle | Texas | 48101 | 124 | 5 |
832242 | 832242 | 2020-12-15 | Crane | Texas | 48103 | 476 | 9 |
832243 | 832243 | 2020-12-15 | Crockett | Texas | 48105 | 481 | 8 |
832244 | 832244 | 2020-12-15 | Crosby | Texas | 48107 | 298 | 16 |
832245 | 832245 | 2020-12-15 | Culberson | Texas | 48109 | 266 | 3 |
832246 | 832246 | 2020-12-15 | Dallam | Texas | 48111 | 477 | 15 |
832247 | 832247 | 2020-12-15 | Dallas | Texas | 48113 | 161845 | 1740 |
832248 | 832248 | 2020-12-15 | Dawson | Texas | 48115 | 1318 | 42 |
832249 | 832249 | 2020-12-15 | DeWitt | Texas | 48123 | 1340 | 46 |
832250 | 832250 | 2020-12-15 | Deaf Smith | Texas | 48117 | 2285 | 45 |
832251 | 832251 | 2020-12-15 | Delta | Texas | 48119 | 122 | 2 |
832252 | 832252 | 2020-12-15 | Denton | Texas | 48121 | 31587 | 270 |
832253 | 832253 | 2020-12-15 | Dickens | Texas | 48125 | 108 | 6 |
832254 | 832254 | 2020-12-15 | Dimmit | Texas | 48127 | 478 | 10 |
832255 | 832255 | 2020-12-15 | Donley | Texas | 48129 | 224 | 5 |
832256 | 832256 | 2020-12-15 | Duval | Texas | 48131 | 733 | 27 |
832257 | 832257 | 2020-12-15 | Eastland | Texas | 48133 | 674 | 12 |
832258 | 832258 | 2020-12-15 | Ector | Texas | 48135 | 10880 | 174 |
832259 | 832259 | 2020-12-15 | Edwards | Texas | 48137 | 160 | 2 |
832260 | 832260 | 2020-12-15 | El Paso | Texas | 48141 | 93455 | 1394 |
832261 | 832261 | 2020-12-15 | Ellis | Texas | 48139 | 10189 | 139 |
832262 | 832262 | 2020-12-15 | Erath | Texas | 48143 | 2495 | 25 |
832263 | 832263 | 2020-12-15 | Falls | Texas | 48145 | 951 | 15 |
832264 | 832264 | 2020-12-15 | Fannin | Texas | 48147 | 1467 | 46 |
832265 | 832265 | 2020-12-15 | Fayette | Texas | 48149 | 1127 | 30 |
832266 | 832266 | 2020-12-15 | Fisher | Texas | 48151 | 199 | 6 |
832267 | 832267 | 2020-12-15 | Floyd | Texas | 48153 | 480 | 16 |
832268 | 832268 | 2020-12-15 | Foard | Texas | 48155 | 61 | 4 |
832269 | 832269 | 2020-12-15 | Fort Bend | Texas | 48157 | 30201 | 353 |
832270 | 832270 | 2020-12-15 | Franklin | Texas | 48159 | 382 | 11 |
832271 | 832271 | 2020-12-15 | Freestone | Texas | 48161 | 833 | 20 |
832272 | 832272 | 2020-12-15 | Frio | Texas | 48163 | 1538 | 10 |
832273 | 832273 | 2020-12-15 | Gaines | Texas | 48165 | 1106 | 23 |
832274 | 832274 | 2020-12-15 | Galveston | Texas | 48167 | 17629 | 196 |
832275 | 832275 | 2020-12-15 | Garza | Texas | 48169 | 233 | 16 |
832276 | 832276 | 2020-12-15 | Gillespie | Texas | 48171 | 1072 | 13 |
832277 | 832277 | 2020-12-15 | Glasscock | Texas | 48173 | 71 | 1 |
832278 | 832278 | 2020-12-15 | Goliad | Texas | 48175 | 248 | 7 |
832279 | 832279 | 2020-12-15 | Gonzales | Texas | 48177 | 1449 | 24 |
832280 | 832280 | 2020-12-15 | Gray | Texas | 48179 | 1592 | 28 |
832281 | 832281 | 2020-12-15 | Grayson | Texas | 48181 | 5404 | 135 |
832282 | 832282 | 2020-12-15 | Gregg | Texas | 48183 | 5974 | 128 |
832283 | 832283 | 2020-12-15 | Grimes | Texas | 48185 | 1636 | 41 |
832284 | 832284 | 2020-12-15 | Guadalupe | Texas | 48187 | 5846 | 92 |
832285 | 832285 | 2020-12-15 | Hale | Texas | 48189 | 4720 | 109 |
832286 | 832286 | 2020-12-15 | Hall | Texas | 48191 | 189 | 3 |
832287 | 832287 | 2020-12-15 | Hamilton | Texas | 48193 | 370 | 12 |
832288 | 832288 | 2020-12-15 | Hansford | Texas | 48195 | 482 | 12 |
832289 | 832289 | 2020-12-15 | Hardeman | Texas | 48197 | 187 | 6 |
832290 | 832290 | 2020-12-15 | Hardin | Texas | 48199 | 2753 | 46 |
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);