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-11-21 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
754301 | 754301 | 2020-11-21 | Anderson | Texas | 48001 | 3127 | 46 |
754302 | 754302 | 2020-11-21 | Andrews | Texas | 48003 | 977 | 13 |
754303 | 754303 | 2020-11-21 | Angelina | Texas | 48005 | 3394 | 97 |
754304 | 754304 | 2020-11-21 | Aransas | Texas | 48007 | 376 | 18 |
754305 | 754305 | 2020-11-21 | Archer | Texas | 48009 | 231 | 2 |
754306 | 754306 | 2020-11-21 | Armstrong | Texas | 48011 | 42 | 1 |
754307 | 754307 | 2020-11-21 | Atascosa | Texas | 48013 | 1417 | 38 |
754308 | 754308 | 2020-11-21 | Austin | Texas | 48015 | 558 | 11 |
754309 | 754309 | 2020-11-21 | Bailey | Texas | 48017 | 454 | 6 |
754310 | 754310 | 2020-11-21 | Bandera | Texas | 48019 | 223 | 11 |
754311 | 754311 | 2020-11-21 | Bastrop | Texas | 48021 | 2216 | 35 |
754312 | 754312 | 2020-11-21 | Baylor | Texas | 48023 | 52 | 4 |
754313 | 754313 | 2020-11-21 | Bee | Texas | 48025 | 1936 | 40 |
754314 | 754314 | 2020-11-21 | Bell | Texas | 48027 | 8018 | 112 |
754315 | 754315 | 2020-11-21 | Bexar | Texas | 48029 | 72817 | 1473 |
754316 | 754316 | 2020-11-21 | Blanco | Texas | 48031 | 178 | 6 |
754317 | 754317 | 2020-11-21 | Borden | Texas | 48033 | 5 | 0 |
754318 | 754318 | 2020-11-21 | Bosque | Texas | 48035 | 507 | 15 |
754319 | 754319 | 2020-11-21 | Bowie | Texas | 48037 | 2479 | 97 |
754320 | 754320 | 2020-11-21 | Brazoria | Texas | 48039 | 13722 | 194 |
754321 | 754321 | 2020-11-21 | Brazos | Texas | 48041 | 10392 | 100 |
754322 | 754322 | 2020-11-21 | Brewster | Texas | 48043 | 439 | 6 |
754323 | 754323 | 2020-11-21 | Briscoe | Texas | 48045 | 39 | 1 |
754324 | 754324 | 2020-11-21 | Brooks | Texas | 48047 | 389 | 25 |
754325 | 754325 | 2020-11-21 | Brown | Texas | 48049 | 1554 | 39 |
754326 | 754326 | 2020-11-21 | Burleson | Texas | 48051 | 628 | 7 |
754327 | 754327 | 2020-11-21 | Burnet | Texas | 48053 | 1324 | 16 |
754328 | 754328 | 2020-11-21 | Caldwell | Texas | 48055 | 1820 | 39 |
754329 | 754329 | 2020-11-21 | Calhoun | Texas | 48057 | 973 | 9 |
754330 | 754330 | 2020-11-21 | Callahan | Texas | 48059 | 197 | 8 |
754331 | 754331 | 2020-11-21 | Cameron | Texas | 48061 | 25507 | 1110 |
754332 | 754332 | 2020-11-21 | Camp | Texas | 48063 | 441 | 15 |
754333 | 754333 | 2020-11-21 | Carson | Texas | 48065 | 87 | 2 |
754334 | 754334 | 2020-11-21 | Cass | Texas | 48067 | 719 | 33 |
754335 | 754335 | 2020-11-21 | Castro | Texas | 48069 | 439 | 8 |
754336 | 754336 | 2020-11-21 | Chambers | Texas | 48071 | 1845 | 21 |
754337 | 754337 | 2020-11-21 | Cherokee | Texas | 48073 | 1726 | 49 |
754338 | 754338 | 2020-11-21 | Childress | Texas | 48075 | 812 | 0 |
754339 | 754339 | 2020-11-21 | Clay | Texas | 48077 | 244 | 6 |
754340 | 754340 | 2020-11-21 | Cochran | Texas | 48079 | 148 | 4 |
754341 | 754341 | 2020-11-21 | Coke | Texas | 48081 | 163 | 9 |
754342 | 754342 | 2020-11-21 | Coleman | Texas | 48083 | 173 | 5 |
754343 | 754343 | 2020-11-21 | Collin | Texas | 48085 | 22691 | 238 |
754344 | 754344 | 2020-11-21 | Collingsworth | Texas | 48087 | 38 | 0 |
754345 | 754345 | 2020-11-21 | Colorado | Texas | 48089 | 559 | 4 |
754346 | 754346 | 2020-11-21 | Comal | Texas | 48091 | 4355 | 125 |
754347 | 754347 | 2020-11-21 | Comanche | Texas | 48093 | 421 | 6 |
754348 | 754348 | 2020-11-21 | Concho | Texas | 48095 | 181 | 2 |
754349 | 754349 | 2020-11-21 | Cooke | Texas | 48097 | 715 | 13 |
754350 | 754350 | 2020-11-21 | Coryell | Texas | 48099 | 2301 | 16 |
754351 | 754351 | 2020-11-21 | Cottle | Texas | 48101 | 52 | 4 |
754352 | 754352 | 2020-11-21 | Crane | Texas | 48103 | 159 | 7 |
754353 | 754353 | 2020-11-21 | Crockett | Texas | 48105 | 210 | 7 |
754354 | 754354 | 2020-11-21 | Crosby | Texas | 48107 | 165 | 14 |
754355 | 754355 | 2020-11-21 | Culberson | Texas | 48109 | 175 | 3 |
754356 | 754356 | 2020-11-21 | Dallam | Texas | 48111 | 426 | 14 |
754357 | 754357 | 2020-11-21 | Dallas | Texas | 48113 | 128324 | 1463 |
754358 | 754358 | 2020-11-21 | Dawson | Texas | 48115 | 1147 | 33 |
754359 | 754359 | 2020-11-21 | DeWitt | Texas | 48123 | 1190 | 44 |
754360 | 754360 | 2020-11-21 | Deaf Smith | Texas | 48117 | 1641 | 36 |
754361 | 754361 | 2020-11-21 | Delta | Texas | 48119 | 46 | 1 |
754362 | 754362 | 2020-11-21 | Denton | Texas | 48121 | 21453 | 200 |
754363 | 754363 | 2020-11-21 | Dickens | Texas | 48125 | 65 | 4 |
754364 | 754364 | 2020-11-21 | Dimmit | Texas | 48127 | 341 | 8 |
754365 | 754365 | 2020-11-21 | Donley | Texas | 48129 | 107 | 1 |
754366 | 754366 | 2020-11-21 | Duval | Texas | 48131 | 570 | 22 |
754367 | 754367 | 2020-11-21 | Eastland | Texas | 48133 | 338 | 9 |
754368 | 754368 | 2020-11-21 | Ector | Texas | 48135 | 8206 | 130 |
754369 | 754369 | 2020-11-21 | Edwards | Texas | 48137 | 81 | 2 |
754370 | 754370 | 2020-11-21 | El Paso | Texas | 48141 | 80291 | 949 |
754371 | 754371 | 2020-11-21 | Ellis | Texas | 48139 | 6107 | 106 |
754372 | 754372 | 2020-11-21 | Erath | Texas | 48143 | 1251 | 19 |
754373 | 754373 | 2020-11-21 | Falls | Texas | 48145 | 771 | 14 |
754374 | 754374 | 2020-11-21 | Fannin | Texas | 48147 | 948 | 27 |
754375 | 754375 | 2020-11-21 | Fayette | Texas | 48149 | 583 | 23 |
754376 | 754376 | 2020-11-21 | Fisher | Texas | 48151 | 145 | 4 |
754377 | 754377 | 2020-11-21 | Floyd | Texas | 48153 | 182 | 15 |
754378 | 754378 | 2020-11-21 | Foard | Texas | 48155 | 25 | 1 |
754379 | 754379 | 2020-11-21 | Fort Bend | Texas | 48157 | 20593 | 325 |
754380 | 754380 | 2020-11-21 | Franklin | Texas | 48159 | 245 | 10 |
754381 | 754381 | 2020-11-21 | Freestone | Texas | 48161 | 500 | 10 |
754382 | 754382 | 2020-11-21 | Frio | Texas | 48163 | 1084 | 9 |
754383 | 754383 | 2020-11-21 | Gaines | Texas | 48165 | 870 | 14 |
754384 | 754384 | 2020-11-21 | Galveston | Texas | 48167 | 14126 | 178 |
754385 | 754385 | 2020-11-21 | Garza | Texas | 48169 | 159 | 13 |
754386 | 754386 | 2020-11-21 | Gillespie | Texas | 48171 | 443 | 10 |
754387 | 754387 | 2020-11-21 | Glasscock | Texas | 48173 | 30 | 0 |
754388 | 754388 | 2020-11-21 | Goliad | Texas | 48175 | 177 | 6 |
754389 | 754389 | 2020-11-21 | Gonzales | Texas | 48177 | 1208 | 23 |
754390 | 754390 | 2020-11-21 | Gray | Texas | 48179 | 1201 | 18 |
754391 | 754391 | 2020-11-21 | Grayson | Texas | 48181 | 3921 | 99 |
754392 | 754392 | 2020-11-21 | Gregg | Texas | 48183 | 4681 | 108 |
754393 | 754393 | 2020-11-21 | Grimes | Texas | 48185 | 1327 | 38 |
754394 | 754394 | 2020-11-21 | Guadalupe | Texas | 48187 | 4145 | 83 |
754395 | 754395 | 2020-11-21 | Hale | Texas | 48189 | 3742 | 86 |
754396 | 754396 | 2020-11-21 | Hall | Texas | 48191 | 76 | 3 |
754397 | 754397 | 2020-11-21 | Hamilton | Texas | 48193 | 278 | 7 |
754398 | 754398 | 2020-11-21 | Hansford | Texas | 48195 | 226 | 9 |
754399 | 754399 | 2020-11-21 | Hardeman | Texas | 48197 | 77 | 4 |
754400 | 754400 | 2020-11-21 | Hardin | Texas | 48199 | 1578 | 40 |
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);