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

71,320 rows where state = "Texas" sorted by date descending

✎ View and edit SQL

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

fips

county

state

  • Texas · 71,320 ✖
Link rowid date ▲ county state fips cases deaths
939365 939365 2021-01-17 Anderson Texas 48001 5575 74
939366 939366 2021-01-17 Andrews Texas 48003 1606 36
939367 939367 2021-01-17 Angelina Texas 48005 6552 191
939368 939368 2021-01-17 Aransas Texas 48007 893 26
939369 939369 2021-01-17 Archer Texas 48009 694 8
939370 939370 2021-01-17 Armstrong Texas 48011 126 6
939371 939371 2021-01-17 Atascosa Texas 48013 3781 87
939372 939372 2021-01-17 Austin Texas 48015 1368 17
939373 939373 2021-01-17 Bailey Texas 48017 741 14
939374 939374 2021-01-17 Bandera Texas 48019 820 20
939375 939375 2021-01-17 Bastrop Texas 48021 4361 55
939376 939376 2021-01-17 Baylor Texas 48023 274 9
939377 939377 2021-01-17 Bee Texas 48025 3060 53
939378 939378 2021-01-17 Bell Texas 48027 16512 208
939379 939379 2021-01-17 Bexar Texas 48029 148567 2019
939380 939380 2021-01-17 Blanco Texas 48031 318 11
939381 939381 2021-01-17 Borden Texas 48033 18 0
939382 939382 2021-01-17 Bosque Texas 48035 984 20
939383 939383 2021-01-17 Bowie Texas 48037 4779 138
939384 939384 2021-01-17 Brazoria Texas 48039 25714 275
939385 939385 2021-01-17 Brazos Texas 48041 16634 161
939386 939386 2021-01-17 Brewster Texas 48043 939 8
939387 939387 2021-01-17 Briscoe Texas 48045 113 3
939388 939388 2021-01-17 Brooks Texas 48047 683 29
939389 939389 2021-01-17 Brown Texas 48049 3382 93
939390 939390 2021-01-17 Burleson Texas 48051 1092 22
939391 939391 2021-01-17 Burnet Texas 48053 2193 34
939392 939392 2021-01-17 Caldwell Texas 48055 2726 55
939393 939393 2021-01-17 Calhoun Texas 48057 1361 12
939394 939394 2021-01-17 Callahan Texas 48059 931 27
939395 939395 2021-01-17 Cameron Texas 48061 32698 1225
939396 939396 2021-01-17 Camp Texas 48063 961 32
939397 939397 2021-01-17 Carson Texas 48065 330 11
939398 939398 2021-01-17 Cass Texas 48067 1476 58
939399 939399 2021-01-17 Castro Texas 48069 831 22
939400 939400 2021-01-17 Chambers Texas 48071 3431 31
939401 939401 2021-01-17 Cherokee Texas 48073 3491 88
939402 939402 2021-01-17 Childress Texas 48075 1284 13
939403 939403 2021-01-17 Clay Texas 48077 874 13
939404 939404 2021-01-17 Cochran Texas 48079 215 12
939405 939405 2021-01-17 Coke Texas 48081 426 10
939406 939406 2021-01-17 Coleman Texas 48083 579 20
939407 939407 2021-01-17 Collin Texas 48085 63239 472
939408 939408 2021-01-17 Collingsworth Texas 48087 236 8
939409 939409 2021-01-17 Colorado Texas 48089 1235 17
939410 939410 2021-01-17 Comal Texas 48091 7314 220
939411 939411 2021-01-17 Comanche Texas 48093 1118 36
939412 939412 2021-01-17 Concho Texas 48095 245 4
939413 939413 2021-01-17 Cooke Texas 48097 2806 45
939414 939414 2021-01-17 Coryell Texas 48099 4313 42
939415 939415 2021-01-17 Cottle Texas 48101 176 7
939416 939416 2021-01-17 Crane Texas 48103 482 11
939417 939417 2021-01-17 Crockett Texas 48105 468 13
939418 939418 2021-01-17 Crosby Texas 48107 380 22
939419 939419 2021-01-17 Culberson Texas 48109 293 4
939420 939420 2021-01-17 Dallam Texas 48111 465 20
939421 939421 2021-01-17 Dallas Texas 48113 234625 2425
939422 939422 2021-01-17 Dawson Texas 48115 1575 59
939423 939423 2021-01-17 DeWitt Texas 48123 1553 50
939424 939424 2021-01-17 Deaf Smith Texas 48117 2512 60
939425 939425 2021-01-17 Delta Texas 48119 208 5
939426 939426 2021-01-17 Denton Texas 48121 46272 433
939427 939427 2021-01-17 Dickens Texas 48125 135 7
939428 939428 2021-01-17 Dimmit Texas 48127 904 13
939429 939429 2021-01-17 Donley Texas 48129 281 7
939430 939430 2021-01-17 Duval Texas 48131 1053 32
939431 939431 2021-01-17 Eastland Texas 48133 972 23
939432 939432 2021-01-17 Ector Texas 48135 12222 267
939433 939433 2021-01-17 Edwards Texas 48137 207 3
939434 939434 2021-01-17 El Paso Texas 48141 106677 1935
939435 939435 2021-01-17 Ellis Texas 48139 16403 199
939436 939436 2021-01-17 Erath Texas 48143 3470 42
939437 939437 2021-01-17 Falls Texas 48145 1308 22
939438 939438 2021-01-17 Fannin Texas 48147 2439 66
939439 939439 2021-01-17 Fayette Texas 48149 1431 43
939440 939440 2021-01-17 Fisher Texas 48151 266 10
939441 939441 2021-01-17 Floyd Texas 48153 628 25
939442 939442 2021-01-17 Foard Texas 48155 91 5
939443 939443 2021-01-17 Fort Bend Texas 48157 43662 436
939444 939444 2021-01-17 Franklin Texas 48159 558 15
939445 939445 2021-01-17 Freestone Texas 48161 988 29
939446 939446 2021-01-17 Frio Texas 48163 2148 23
939447 939447 2021-01-17 Gaines Texas 48165 1302 36
939448 939448 2021-01-17 Galveston Texas 48167 26898 248
939449 939449 2021-01-17 Garza Texas 48169 277 18
939450 939450 2021-01-17 Gillespie Texas 48171 1830 31
939451 939451 2021-01-17 Glasscock Texas 48173 94 1
939452 939452 2021-01-17 Goliad Texas 48175 299 9
939453 939453 2021-01-17 Gonzales Texas 48177 1962 29
939454 939454 2021-01-17 Gray Texas 48179 1748 40
939455 939455 2021-01-17 Grayson Texas 48181 8766 220
939456 939456 2021-01-17 Gregg Texas 48183 8451 217
939457 939457 2021-01-17 Grimes Texas 48185 1960 51
939458 939458 2021-01-17 Guadalupe Texas 48187 9123 126
939459 939459 2021-01-17 Hale Texas 48189 5636 134
939460 939460 2021-01-17 Hall Texas 48191 339 11
939461 939461 2021-01-17 Hamilton Texas 48193 546 21
939462 939462 2021-01-17 Hansford Texas 48195 671 17
939463 939463 2021-01-17 Hardeman Texas 48197 319 9
939464 939464 2021-01-17 Hardin Texas 48199 4080 68

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