ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

142,186 rows where state = "Texas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Texas · 142,186 ✖
Link rowid date ▲ county state fips cases deaths
1845232 1845232 2021-10-23 Anderson Texas 48001 7967 199
1845233 1845233 2021-10-23 Andrews Texas 48003 2766 53
1845234 1845234 2021-10-23 Angelina Texas 48005 13665 396
1845235 1845235 2021-10-23 Aransas Texas 48007 2590 66
1845236 1845236 2021-10-23 Archer Texas 48009 1237 19
1845237 1845237 2021-10-23 Armstrong Texas 48011 285 7
1845238 1845238 2021-10-23 Atascosa Texas 48013 8521 202
1845239 1845239 2021-10-23 Austin Texas 48015 3479 51
1845240 1845240 2021-10-23 Bailey Texas 48017 1004 23
1845241 1845241 2021-10-23 Bandera Texas 48019 2309 51
1845242 1845242 2021-10-23 Bastrop Texas 48021 14298 167
1845243 1845243 2021-10-23 Baylor Texas 48023 551 21
1845244 1845244 2021-10-23 Bee Texas 48025 5290 127
1845245 1845245 2021-10-23 Bell Texas 48027 38344 701
1845246 1845246 2021-10-23 Bexar Texas 48029 319170 5064
1845247 1845247 2021-10-23 Blanco Texas 48031 1305 28
1845248 1845248 2021-10-23 Borden Texas 48033 42 2
1845249 1845249 2021-10-23 Bosque Texas 48035 2426 55
1845250 1845250 2021-10-23 Bowie Texas 48037 12678 317
1845251 1845251 2021-10-23 Brazoria Texas 48039 59168 815
1845252 1845252 2021-10-23 Brazos Texas 48041 38518 350
1845253 1845253 2021-10-23 Brewster Texas 48043 1089 20
1845254 1845254 2021-10-23 Briscoe Texas 48045 218 7
1845255 1845255 2021-10-23 Brooks Texas 48047 1119 47
1845256 1845256 2021-10-23 Brown Texas 48049 6987 183
1845257 1845257 2021-10-23 Burleson Texas 48051 3260 59
1845258 1845258 2021-10-23 Burnet Texas 48053 7355 121
1845259 1845259 2021-10-23 Caldwell Texas 48055 8376 150
1845260 1845260 2021-10-23 Calhoun Texas 48057 3906 36
1845261 1845261 2021-10-23 Callahan Texas 48059 1790 53
1845262 1845262 2021-10-23 Cameron Texas 48061 65498 1961
1845263 1845263 2021-10-23 Camp Texas 48063 2011 65
1845264 1845264 2021-10-23 Carson Texas 48065 778 24
1845265 1845265 2021-10-23 Cass Texas 48067 4462 143
1845266 1845266 2021-10-23 Castro Texas 48069 1312 37
1845267 1845267 2021-10-23 Chambers Texas 48071 8755 97
1845268 1845268 2021-10-23 Cherokee Texas 48073 6784 217
1845269 1845269 2021-10-23 Childress Texas 48075 1572 20
1845270 1845270 2021-10-23 Clay Texas 48077 1537 23
1845271 1845271 2021-10-23 Cochran Texas 48079 442 18
1845272 1845272 2021-10-23 Coke Texas 48081 675 16
1845273 1845273 2021-10-23 Coleman Texas 48083 1091 53
1845274 1845274 2021-10-23 Collin Texas 48085 128487 1115
1845275 1845275 2021-10-23 Collingsworth Texas 48087 390 11
1845276 1845276 2021-10-23 Colorado Texas 48089 2535 51
1845277 1845277 2021-10-23 Comal Texas 48091 19304 444
1845278 1845278 2021-10-23 Comanche Texas 48093 2182 64
1845279 1845279 2021-10-23 Concho Texas 48095 702 10
1845280 1845280 2021-10-23 Cooke Texas 48097 5081 99
1845281 1845281 2021-10-23 Coryell Texas 48099 10757 155
1845282 1845282 2021-10-23 Cottle Texas 48101 227 9
1845283 1845283 2021-10-23 Crane Texas 48103 860 17
1845284 1845284 2021-10-23 Crockett Texas 48105 780 16
1845285 1845285 2021-10-23 Crosby Texas 48107 992 36
1845286 1845286 2021-10-23 Culberson Texas 48109 387 11
1845287 1845287 2021-10-23 Dallam Texas 48111 1205 30
1845288 1845288 2021-10-23 Dallas Texas 48113 402022 5273
1845289 1845289 2021-10-23 Dawson Texas 48115 2143 76
1845290 1845290 2021-10-23 DeWitt Texas 48123 2952 82
1845291 1845291 2021-10-23 Deaf Smith Texas 48117 3382 75
1845292 1845292 2021-10-23 Delta Texas 48119 606 21
1845293 1845293 2021-10-23 Denton Texas 48121 106582 999
1845294 1845294 2021-10-23 Dickens Texas 48125 248 13
1845295 1845295 2021-10-23 Dimmit Texas 48127 3777 45
1845296 1845296 2021-10-23 Donley Texas 48129 579 18
1845297 1845297 2021-10-23 Duval Texas 48131 1946 57
1845298 1845298 2021-10-23 Eastland Texas 48133 2147 77
1845299 1845299 2021-10-23 Ector Texas 48135 25606 525
1845300 1845300 2021-10-23 Edwards Texas 48137 325 7
1845301 1845301 2021-10-23 El Paso Texas 48141 147998 2863
1845302 1845302 2021-10-23 Ellis Texas 48139 33241 454
1845303 1845303 2021-10-23 Erath Texas 48143 6284 100
1845304 1845304 2021-10-23 Falls Texas 48145 2615 45
1845305 1845305 2021-10-23 Fannin Texas 48147 4965 149
1845306 1845306 2021-10-23 Fayette Texas 48149 3588 92
1845307 1845307 2021-10-23 Fisher Texas 48151 434 16
1845308 1845308 2021-10-23 Floyd Texas 48153 1168 38
1845309 1845309 2021-10-23 Foard Texas 48155 181 10
1845310 1845310 2021-10-23 Fort Bend Texas 48157 99485 951
1845311 1845311 2021-10-23 Franklin Texas 48159 1321 35
1845312 1845312 2021-10-23 Freestone Texas 48161 2744 67
1845313 1845313 2021-10-23 Frio Texas 48163 3920 69
1845314 1845314 2021-10-23 Gaines Texas 48165 2131 60
1845315 1845315 2021-10-23 Galveston Texas 48167 63832 692
1845316 1845316 2021-10-23 Garza Texas 48169 719 22
1845317 1845317 2021-10-23 Gillespie Texas 48171 3515 77
1845318 1845318 2021-10-23 Glasscock Texas 48173 154 3
1845319 1845319 2021-10-23 Goliad Texas 48175 699 28
1845320 1845320 2021-10-23 Gonzales Texas 48177 3535 83
1845321 1845321 2021-10-23 Gray Texas 48179 3486 79
1845322 1845322 2021-10-23 Grayson Texas 48181 16104 480
1845323 1845323 2021-10-23 Gregg Texas 48183 19123 536
1845324 1845324 2021-10-23 Grimes Texas 48185 5139 105
1845325 1845325 2021-10-23 Guadalupe Texas 48187 24262 333
1845326 1845326 2021-10-23 Hale Texas 48189 7875 187
1845327 1845327 2021-10-23 Hall Texas 48191 541 15
1845328 1845328 2021-10-23 Hamilton Texas 48193 1302 29
1845329 1845329 2021-10-23 Hansford Texas 48195 1127 26
1845330 1845330 2021-10-23 Hardeman Texas 48197 450 14
1845331 1845331 2021-10-23 Hardin Texas 48199 10343 204

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);