ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where "date" is on date 2020-10-23 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
660224 | 660224 | 2020-10-23 | Anderson | Texas | 48001 | 2934 | 39 |
660225 | 660225 | 2020-10-23 | Andrews | Texas | 48003 | 567 | 10 |
660226 | 660226 | 2020-10-23 | Angelina | Texas | 48005 | 2813 | 90 |
660227 | 660227 | 2020-10-23 | Aransas | Texas | 48007 | 340 | 18 |
660228 | 660228 | 2020-10-23 | Archer | Texas | 48009 | 133 | 1 |
660229 | 660229 | 2020-10-23 | Armstrong | Texas | 48011 | 22 | 1 |
660230 | 660230 | 2020-10-23 | Atascosa | Texas | 48013 | 1268 | 35 |
660231 | 660231 | 2020-10-23 | Austin | Texas | 48015 | 509 | 9 |
660232 | 660232 | 2020-10-23 | Bailey | Texas | 48017 | 271 | 5 |
660233 | 660233 | 2020-10-23 | Bandera | Texas | 48019 | 185 | 8 |
660234 | 660234 | 2020-10-23 | Bastrop | Texas | 48021 | 1976 | 31 |
660235 | 660235 | 2020-10-23 | Baylor | Texas | 48023 | 43 | 2 |
660236 | 660236 | 2020-10-23 | Bee | Texas | 48025 | 1838 | 39 |
660237 | 660237 | 2020-10-23 | Bell | Texas | 48027 | 6221 | 97 |
660238 | 660238 | 2020-10-23 | Bexar | Texas | 48029 | 64273 | 1386 |
660239 | 660239 | 2020-10-23 | Blanco | Texas | 48031 | 158 | 6 |
660240 | 660240 | 2020-10-23 | Borden | Texas | 48033 | 2 | 0 |
660241 | 660241 | 2020-10-23 | Bosque | Texas | 48035 | 394 | 10 |
660242 | 660242 | 2020-10-23 | Bowie | Texas | 48037 | 1759 | 76 |
660243 | 660243 | 2020-10-23 | Brazoria | Texas | 48039 | 12105 | 181 |
660244 | 660244 | 2020-10-23 | Brazos | Texas | 48041 | 8461 | 66 |
660245 | 660245 | 2020-10-23 | Brewster | Texas | 48043 | 246 | 5 |
660246 | 660246 | 2020-10-23 | Briscoe | Texas | 48045 | 20 | 1 |
660247 | 660247 | 2020-10-23 | Brooks | Texas | 48047 | 341 | 23 |
660248 | 660248 | 2020-10-23 | Brown | Texas | 48049 | 990 | 35 |
660249 | 660249 | 2020-10-23 | Burleson | Texas | 48051 | 432 | 6 |
660250 | 660250 | 2020-10-23 | Burnet | Texas | 48053 | 857 | 13 |
660251 | 660251 | 2020-10-23 | Caldwell | Texas | 48055 | 1685 | 37 |
660252 | 660252 | 2020-10-23 | Calhoun | Texas | 48057 | 881 | 9 |
660253 | 660253 | 2020-10-23 | Callahan | Texas | 48059 | 113 | 4 |
660254 | 660254 | 2020-10-23 | Cameron | Texas | 48061 | 23976 | 1078 |
660255 | 660255 | 2020-10-23 | Camp | Texas | 48063 | 390 | 13 |
660256 | 660256 | 2020-10-23 | Carson | Texas | 48065 | 52 | 0 |
660257 | 660257 | 2020-10-23 | Cass | Texas | 48067 | 495 | 22 |
660258 | 660258 | 2020-10-23 | Castro | Texas | 48069 | 289 | 6 |
660259 | 660259 | 2020-10-23 | Chambers | Texas | 48071 | 1542 | 20 |
660260 | 660260 | 2020-10-23 | Cherokee | Texas | 48073 | 1618 | 32 |
660261 | 660261 | 2020-10-23 | Childress | Texas | 48075 | 116 | 0 |
660262 | 660262 | 2020-10-23 | Clay | Texas | 48077 | 103 | 2 |
660263 | 660263 | 2020-10-23 | Cochran | Texas | 48079 | 98 | 1 |
660264 | 660264 | 2020-10-23 | Coke | Texas | 48081 | 105 | 5 |
660265 | 660265 | 2020-10-23 | Coleman | Texas | 48083 | 86 | 4 |
660266 | 660266 | 2020-10-23 | Collin | Texas | 48085 | 17248 | 174 |
660267 | 660267 | 2020-10-23 | Collingsworth | Texas | 48087 | 20 | 0 |
660268 | 660268 | 2020-10-23 | Colorado | Texas | 48089 | 500 | 4 |
660269 | 660269 | 2020-10-23 | Comal | Texas | 48091 | 3701 | 120 |
660270 | 660270 | 2020-10-23 | Comanche | Texas | 48093 | 348 | 5 |
660271 | 660271 | 2020-10-23 | Concho | Texas | 48095 | 141 | 2 |
660272 | 660272 | 2020-10-23 | Cooke | Texas | 48097 | 529 | 8 |
660273 | 660273 | 2020-10-23 | Coryell | Texas | 48099 | 1947 | 13 |
660274 | 660274 | 2020-10-23 | Cottle | Texas | 48101 | 33 | 3 |
660275 | 660275 | 2020-10-23 | Crane | Texas | 48103 | 73 | 2 |
660276 | 660276 | 2020-10-23 | Crockett | Texas | 48105 | 166 | 7 |
660277 | 660277 | 2020-10-23 | Crosby | Texas | 48107 | 113 | 6 |
660278 | 660278 | 2020-10-23 | Culberson | Texas | 48109 | 91 | 2 |
660279 | 660279 | 2020-10-23 | Dallam | Texas | 48111 | 352 | 10 |
660280 | 660280 | 2020-10-23 | Dallas | Texas | 48113 | 97095 | 1211 |
660281 | 660281 | 2020-10-23 | Dawson | Texas | 48115 | 787 | 16 |
660282 | 660282 | 2020-10-23 | DeWitt | Texas | 48123 | 1078 | 42 |
660283 | 660283 | 2020-10-23 | Deaf Smith | Texas | 48117 | 1309 | 25 |
660284 | 660284 | 2020-10-23 | Delta | Texas | 48119 | 33 | 0 |
660285 | 660285 | 2020-10-23 | Denton | Texas | 48121 | 15929 | 166 |
660286 | 660286 | 2020-10-23 | Dickens | Texas | 48125 | 51 | 2 |
660287 | 660287 | 2020-10-23 | Dimmit | Texas | 48127 | 284 | 7 |
660288 | 660288 | 2020-10-23 | Donley | Texas | 48129 | 85 | 1 |
660289 | 660289 | 2020-10-23 | Duval | Texas | 48131 | 472 | 21 |
660290 | 660290 | 2020-10-23 | Eastland | Texas | 48133 | 237 | 6 |
660291 | 660291 | 2020-10-23 | Ector | Texas | 48135 | 6025 | 115 |
660292 | 660292 | 2020-10-23 | Edwards | Texas | 48137 | 68 | 2 |
660293 | 660293 | 2020-10-23 | El Paso | Texas | 48141 | 37263 | 581 |
660294 | 660294 | 2020-10-23 | Ellis | Texas | 48139 | 4816 | 75 |
660295 | 660295 | 2020-10-23 | Erath | Texas | 48143 | 993 | 13 |
660296 | 660296 | 2020-10-23 | Falls | Texas | 48145 | 646 | 5 |
660297 | 660297 | 2020-10-23 | Fannin | Texas | 48147 | 758 | 16 |
660298 | 660298 | 2020-10-23 | Fayette | Texas | 48149 | 515 | 22 |
660299 | 660299 | 2020-10-23 | Fisher | Texas | 48151 | 96 | 3 |
660300 | 660300 | 2020-10-23 | Floyd | Texas | 48153 | 125 | 9 |
660301 | 660301 | 2020-10-23 | Foard | Texas | 48155 | 20 | 0 |
660302 | 660302 | 2020-10-23 | Fort Bend | Texas | 48157 | 17997 | 305 |
660303 | 660303 | 2020-10-23 | Franklin | Texas | 48159 | 200 | 7 |
660304 | 660304 | 2020-10-23 | Freestone | Texas | 48161 | 449 | 4 |
660305 | 660305 | 2020-10-23 | Frio | Texas | 48163 | 1007 | 9 |
660306 | 660306 | 2020-10-23 | Gaines | Texas | 48165 | 503 | 10 |
660307 | 660307 | 2020-10-23 | Galveston | Texas | 48167 | 12297 | 168 |
660308 | 660308 | 2020-10-23 | Garza | Texas | 48169 | 122 | 5 |
660309 | 660309 | 2020-10-23 | Gillespie | Texas | 48171 | 353 | 10 |
660310 | 660310 | 2020-10-23 | Glasscock | Texas | 48173 | 12 | 0 |
660311 | 660311 | 2020-10-23 | Goliad | Texas | 48175 | 157 | 6 |
660312 | 660312 | 2020-10-23 | Gonzales | Texas | 48177 | 1110 | 20 |
660313 | 660313 | 2020-10-23 | Gray | Texas | 48179 | 412 | 10 |
660314 | 660314 | 2020-10-23 | Grayson | Texas | 48181 | 2419 | 64 |
660315 | 660315 | 2020-10-23 | Gregg | Texas | 48183 | 3337 | 84 |
660316 | 660316 | 2020-10-23 | Grimes | Texas | 48185 | 1170 | 35 |
660317 | 660317 | 2020-10-23 | Guadalupe | Texas | 48187 | 3818 | 79 |
660318 | 660318 | 2020-10-23 | Hale | Texas | 48189 | 2508 | 63 |
660319 | 660319 | 2020-10-23 | Hall | Texas | 48191 | 44 | 1 |
660320 | 660320 | 2020-10-23 | Hamilton | Texas | 48193 | 185 | 4 |
660321 | 660321 | 2020-10-23 | Hansford | Texas | 48195 | 193 | 6 |
660322 | 660322 | 2020-10-23 | Hardeman | Texas | 48197 | 60 | 1 |
660323 | 660323 | 2020-10-23 | Hardin | Texas | 48199 | 1424 | 34 |
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);