home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

193,519 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 >30

  • 48029 822
  • 48157 801
  • 48201 800
  • 48085 796
  • 48113 795
  • 48339 795
  • 48439 795
  • 48183 794
  • 48027 792
  • 48141 792
  • 48167 792
  • 48423 792
  • 48453 792
  • 48039 791
  • 48209 791
  • 48121 790
  • 48037 789
  • 48321 789
  • 48041 788
  • 48139 788
  • 48303 788
  • 48285 787
  • 48309 787
  • 48325 787
  • 48401 787
  • 48479 787
  • 48485 787
  • 48491 787
  • 48061 786
  • 48103 786
  • …

county >30

  • Bexar 822
  • Fort Bend 801
  • Harris 800
  • Collin 796
  • Dallas 795
  • Montgomery 795
  • Tarrant 795
  • Gregg 794
  • Bell 792
  • El Paso 792
  • Galveston 792
  • Smith 792
  • Travis 792
  • Brazoria 791
  • Hays 791
  • Denton 790
  • Bowie 789
  • Matagorda 789
  • Brazos 788
  • Ellis 788
  • Lubbock 788
  • Lavaca 787
  • McLennan 787
  • Medina 787
  • Rusk 787
  • Webb 787
  • Wichita 787
  • Williamson 787
  • Cameron 786
  • Crane 786
  • …

state 1

  • Texas · 193,519 ✖
Link rowid date ▲ county state fips cases deaths
2502207 2502207 2022-05-13 Anderson Texas 48001 9691 239
2502208 2502208 2022-05-13 Andrews Texas 48003 3822 72
2502209 2502209 2022-05-13 Angelina Texas 48005 15501 481
2502210 2502210 2022-05-13 Aransas Texas 48007 4177 86
2502211 2502211 2022-05-13 Archer Texas 48009 2213 28
2502212 2502212 2022-05-13 Armstrong Texas 48011 555 9
2502213 2502213 2022-05-13 Atascosa Texas 48013 13647 231
2502214 2502214 2022-05-13 Austin Texas 48015 5818 73
2502215 2502215 2022-05-13 Bailey Texas 48017 1511 39
2502216 2502216 2022-05-13 Bandera Texas 48019 3636 77
2502217 2502217 2022-05-13 Bastrop Texas 48021 21971 239
2502218 2502218 2022-05-13 Baylor Texas 48023 818 32
2502219 2502219 2022-05-13 Bee Texas 48025 8418 153
2502220 2502220 2022-05-13 Bell Texas 48027 67290 901
2502221 2502221 2022-05-13 Bexar Texas 48029 565111 6131
2502222 2502222 2022-05-13 Blanco Texas 48031 2568 34
2502223 2502223 2022-05-13 Borden Texas 48033 100 2
2502224 2502224 2022-05-13 Bosque Texas 48035 4130 70
2502225 2502225 2022-05-13 Bowie Texas 48037 20222 432
2502226 2502226 2022-05-13 Brazoria Texas 48039 94245 983
2502227 2502227 2022-05-13 Brazos Texas 48041 60873 413
2502228 2502228 2022-05-13 Brewster Texas 48043 1079 29
2502229 2502229 2022-05-13 Briscoe Texas 48045 465 8
2502230 2502230 2022-05-13 Brooks Texas 48047 1642 52
2502231 2502231 2022-05-13 Brown Texas 48049 12056 253
2502232 2502232 2022-05-13 Burleson Texas 48051 5048 66
2502233 2502233 2022-05-13 Burnet Texas 48053 11095 171
2502234 2502234 2022-05-13 Caldwell Texas 48055 14339 176
2502235 2502235 2022-05-13 Calhoun Texas 48057 5731 48
2502236 2502236 2022-05-13 Callahan Texas 48059 2920 72
2502237 2502237 2022-05-13 Cameron Texas 48061 105092 2032
2502238 2502238 2022-05-13 Camp Texas 48063 2873 75
2502239 2502239 2022-05-13 Carson Texas 48065 1532 36
2502240 2502240 2022-05-13 Cass Texas 48067 7260 197
2502241 2502241 2022-05-13 Castro Texas 48069 2297 47
2502242 2502242 2022-05-13 Chambers Texas 48071 11706 112
2502243 2502243 2022-05-13 Cherokee Texas 48073 7989 254
2502244 2502244 2022-05-13 Childress Texas 48075 2638 33
2502245 2502245 2022-05-13 Clay Texas 48077 2096 35
2502246 2502246 2022-05-13 Cochran Texas 48079 891 23
2502247 2502247 2022-05-13 Coke Texas 48081 843 20
2502248 2502248 2022-05-13 Coleman Texas 48083 1646 71
2502249 2502249 2022-05-13 Collin Texas 48085 215831 1507
2502250 2502250 2022-05-13 Collingsworth Texas 48087 702 16
2502251 2502251 2022-05-13 Colorado Texas 48089 3808 64
2502252 2502252 2022-05-13 Comal Texas 48091 34812 551
2502253 2502253 2022-05-13 Comanche Texas 48093 3698 78
2502254 2502254 2022-05-13 Concho Texas 48095 1084 11
2502255 2502255 2022-05-13 Cooke Texas 48097 7409 134
2502256 2502256 2022-05-13 Coryell Texas 48099 17626 211
2502257 2502257 2022-05-13 Cottle Texas 48101 319 9
2502258 2502258 2022-05-13 Crane Texas 48103 1285 24
2502259 2502259 2022-05-13 Crockett Texas 48105 1091 19
2502260 2502260 2022-05-13 Crosby Texas 48107 1894 45
2502261 2502261 2022-05-13 Culberson Texas 48109 514 14
2502262 2502262 2022-05-13 Dallam Texas 48111 2155 40
2502263 2502263 2022-05-13 Dallas Texas 48113 573644 6772
2502264 2502264 2022-05-13 Dawson Texas 48115 2998 94
2502265 2502265 2022-05-13 DeWitt Texas 48123 6486 99
2502266 2502266 2022-05-13 Deaf Smith Texas 48117 4809 111
2502267 2502267 2022-05-13 Delta Texas 48119 1820 25
2502268 2502268 2022-05-13 Denton Texas 48121 181158 1354
2502269 2502269 2022-05-13 Dickens Texas 48125 453 16
2502270 2502270 2022-05-13 Dimmit Texas 48127 5760 51
2502271 2502271 2022-05-13 Donley Texas 48129 1153 26
2502272 2502272 2022-05-13 Duval Texas 48131 3412 70
2502273 2502273 2022-05-13 Eastland Texas 48133 2829 113
2502274 2502274 2022-05-13 Ector Texas 48135 37544 703
2502275 2502275 2022-05-13 Edwards Texas 48137 467 11
2502276 2502276 2022-05-13 El Paso Texas 48141 208635 3734
2502277 2502277 2022-05-13 Ellis Texas 48139 49172 582
2502278 2502278 2022-05-13 Erath Texas 48143 8790 123
2502279 2502279 2022-05-13 Falls Texas 48145 3797 65
2502280 2502280 2022-05-13 Fannin Texas 48147 6897 183
2502281 2502281 2022-05-13 Fayette Texas 48149 4796 105
2502282 2502282 2022-05-13 Fisher Texas 48151 609 24
2502283 2502283 2022-05-13 Floyd Texas 48153 1961 48
2502284 2502284 2022-05-13 Foard Texas 48155 209 11
2502285 2502285 2022-05-13 Fort Bend Texas 48157 189442 1260
2502286 2502286 2022-05-13 Franklin Texas 48159 2228 42
2502287 2502287 2022-05-13 Freestone Texas 48161 3880 82
2502288 2502288 2022-05-13 Frio Texas 48163 5935 93
2502289 2502289 2022-05-13 Gaines Texas 48165 2215 83
2502290 2502290 2022-05-13 Galveston Texas 48167 96616 853
2502291 2502291 2022-05-13 Garza Texas 48169 1279 28
2502292 2502292 2022-05-13 Gillespie Texas 48171 5426 109
2502293 2502293 2022-05-13 Glasscock Texas 48173 199 3
2502294 2502294 2022-05-13 Goliad Texas 48175 1216 32
2502295 2502295 2022-05-13 Gonzales Texas 48177 4736 99
2502296 2502296 2022-05-13 Gray Texas 48179 6195 125
2502297 2502297 2022-05-13 Grayson Texas 48181 27166 636
2502298 2502298 2022-05-13 Gregg Texas 48183 23237 687
2502299 2502299 2022-05-13 Grimes Texas 48185 8511 120
2502300 2502300 2022-05-13 Guadalupe Texas 48187 38361 398
2502301 2502301 2022-05-13 Hale Texas 48189 6571 245
2502302 2502302 2022-05-13 Hall Texas 48191 1102 24
2502303 2502303 2022-05-13 Hamilton Texas 48193 1972 33
2502304 2502304 2022-05-13 Hansford Texas 48195 1929 29
2502305 2502305 2022-05-13 Hardeman Texas 48197 556 19
2502306 2502306 2022-05-13 Hardin Texas 48199 12078 251

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);
Powered by Datasette · Queries took 836.121ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette