ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193,519 rows where state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 48029 335
- 48157 314
- 48201 314
- 48085 309
- 48339 309
- 48439 309
- 48113 308
- 48183 307
- 48423 306
- 48453 306
- 48027 305
- 48141 305
- 48167 305
- 48209 305
- 48039 304
- 48121 303
- 48321 303
- 48037 302
- 48303 302
- 48041 301
- 48139 301
- 48285 301
- 48309 301
- 48325 301
- 48401 301
- 48479 301
- 48485 301
- 48491 301
- 48251 300
- 48467 300
- …
county >30
- Bexar 335
- Fort Bend 314
- Harris 314
- Collin 309
- Montgomery 309
- Tarrant 309
- Dallas 308
- Gregg 307
- Smith 306
- Travis 306
- Bell 305
- El Paso 305
- Galveston 305
- Hays 305
- Brazoria 304
- Denton 303
- Matagorda 303
- Bowie 302
- Lubbock 302
- Brazos 301
- Ellis 301
- Lavaca 301
- McLennan 301
- Medina 301
- Rusk 301
- Webb 301
- Wichita 301
- Williamson 301
- Johnson 300
- Van Zandt 300
- …
state 1
- Texas · 69,950 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923159 | 923159 | 2021-01-12 | Harris | Texas | 48201 | 267729 | 3618 |
923160 | 923160 | 2021-01-12 | Harrison | Texas | 48203 | 3042 | 68 |
923161 | 923161 | 2021-01-12 | Hartley | Texas | 48205 | 317 | 2 |
923162 | 923162 | 2021-01-12 | Haskell | Texas | 48207 | 350 | 13 |
923163 | 923163 | 2021-01-12 | Hays | Texas | 48209 | 13915 | 146 |
923164 | 923164 | 2021-01-12 | Hemphill | Texas | 48211 | 430 | 2 |
923165 | 923165 | 2021-01-12 | Henderson | Texas | 48213 | 4277 | 92 |
923166 | 923166 | 2021-01-12 | Hidalgo | Texas | 48215 | 54763 | 2260 |
923167 | 923167 | 2021-01-12 | Hill | Texas | 48217 | 2310 | 40 |
923168 | 923168 | 2021-01-12 | Hockley | Texas | 48219 | 2017 | 89 |
923169 | 923169 | 2021-01-12 | Hood | Texas | 48221 | 4779 | 79 |
923170 | 923170 | 2021-01-12 | Hopkins | Texas | 48223 | 2441 | 81 |
923171 | 923171 | 2021-01-12 | Houston | Texas | 48225 | 1240 | 28 |
923172 | 923172 | 2021-01-12 | Howard | Texas | 48227 | 4123 | 70 |
923173 | 923173 | 2021-01-12 | Hudspeth | Texas | 48229 | 479 | 8 |
923174 | 923174 | 2021-01-12 | Hunt | Texas | 48231 | 4315 | 96 |
923175 | 923175 | 2021-01-12 | Hutchinson | Texas | 48233 | 1239 | 53 |
923176 | 923176 | 2021-01-12 | Irion | Texas | 48235 | 77 | 1 |
923177 | 923177 | 2021-01-12 | Jack | Texas | 48237 | 511 | 12 |
923178 | 923178 | 2021-01-12 | Jackson | Texas | 48239 | 1220 | 22 |
923179 | 923179 | 2021-01-12 | Jasper | Texas | 48241 | 2569 | 47 |
923180 | 923180 | 2021-01-12 | Jeff Davis | Texas | 48243 | 114 | 1 |
923181 | 923181 | 2021-01-12 | Jefferson | Texas | 48245 | 15188 | 253 |
923182 | 923182 | 2021-01-12 | Jim Hogg | Texas | 48247 | 415 | 11 |
923183 | 923183 | 2021-01-12 | Jim Wells | Texas | 48249 | 3204 | 68 |
923184 | 923184 | 2021-01-12 | Johnson | Texas | 48251 | 13401 | 187 |
923185 | 923185 | 2021-01-12 | Jones | Texas | 48253 | 2470 | 35 |
923186 | 923186 | 2021-01-12 | Karnes | Texas | 48255 | 1358 | 25 |
923187 | 923187 | 2021-01-12 | Kaufman | Texas | 48257 | 10975 | 144 |
923188 | 923188 | 2021-01-12 | Kendall | Texas | 48259 | 1692 | 36 |
923189 | 923189 | 2021-01-12 | Kenedy | Texas | 48261 | 29 | 2 |
923190 | 923190 | 2021-01-12 | Kent | Texas | 48263 | 62 | 1 |
923191 | 923191 | 2021-01-12 | Kerr | Texas | 48265 | 2850 | 46 |
923192 | 923192 | 2021-01-12 | Kimble | Texas | 48267 | 215 | 6 |
923193 | 923193 | 2021-01-12 | King | Texas | 48269 | 9 | 0 |
923194 | 923194 | 2021-01-12 | Kinney | Texas | 48271 | 222 | 3 |
923195 | 923195 | 2021-01-12 | Kleberg | Texas | 48273 | 1892 | 63 |
923196 | 923196 | 2021-01-12 | Knox | Texas | 48275 | 182 | 12 |
923197 | 923197 | 2021-01-12 | La Salle | Texas | 48283 | 703 | 15 |
923198 | 923198 | 2021-01-12 | Lamar | Texas | 48277 | 4761 | 103 |
923199 | 923199 | 2021-01-12 | Lamb | Texas | 48279 | 1747 | 72 |
923200 | 923200 | 2021-01-12 | Lampasas | Texas | 48281 | 839 | 16 |
923201 | 923201 | 2021-01-12 | Lavaca | Texas | 48285 | 1794 | 58 |
923202 | 923202 | 2021-01-12 | Lee | Texas | 48287 | 1103 | 33 |
923203 | 923203 | 2021-01-12 | Leon | Texas | 48289 | 830 | 27 |
923204 | 923204 | 2021-01-12 | Liberty | Texas | 48291 | 4680 | 105 |
923205 | 923205 | 2021-01-12 | Limestone | Texas | 48293 | 1352 | 32 |
923206 | 923206 | 2021-01-12 | Lipscomb | Texas | 48295 | 242 | 9 |
923207 | 923207 | 2021-01-12 | Live Oak | Texas | 48297 | 936 | 16 |
923208 | 923208 | 2021-01-12 | Llano | Texas | 48299 | 731 | 23 |
923209 | 923209 | 2021-01-12 | Loving | Texas | 48301 | 1 | 0 |
923210 | 923210 | 2021-01-12 | Lubbock | Texas | 48303 | 44757 | 618 |
923211 | 923211 | 2021-01-12 | Lynn | Texas | 48305 | 560 | 15 |
923212 | 923212 | 2021-01-12 | Madison | Texas | 48313 | 1147 | 18 |
923213 | 923213 | 2021-01-12 | Marion | Texas | 48315 | 338 | 19 |
923214 | 923214 | 2021-01-12 | Martin | Texas | 48317 | 581 | 17 |
923215 | 923215 | 2021-01-12 | Mason | Texas | 48319 | 310 | 4 |
923216 | 923216 | 2021-01-12 | Matagorda | Texas | 48321 | 2174 | 69 |
923217 | 923217 | 2021-01-12 | Maverick | Texas | 48323 | 7473 | 207 |
923218 | 923218 | 2021-01-12 | McCulloch | Texas | 48307 | 456 | 12 |
923219 | 923219 | 2021-01-12 | McLennan | Texas | 48309 | 21296 | 323 |
923220 | 923220 | 2021-01-12 | McMullen | Texas | 48311 | 69 | 2 |
923221 | 923221 | 2021-01-12 | Medina | Texas | 48325 | 3060 | 58 |
923222 | 923222 | 2021-01-12 | Menard | Texas | 48327 | 174 | 4 |
923223 | 923223 | 2021-01-12 | Midland | Texas | 48329 | 13165 | 200 |
923224 | 923224 | 2021-01-12 | Milam | Texas | 48331 | 1577 | 15 |
923225 | 923225 | 2021-01-12 | Mills | Texas | 48333 | 298 | 13 |
923226 | 923226 | 2021-01-12 | Mitchell | Texas | 48335 | 522 | 17 |
923227 | 923227 | 2021-01-12 | Montague | Texas | 48337 | 1643 | 44 |
923228 | 923228 | 2021-01-12 | Montgomery | Texas | 48339 | 31822 | 296 |
923229 | 923229 | 2021-01-12 | Moore | Texas | 48341 | 2105 | 55 |
923230 | 923230 | 2021-01-12 | Morris | Texas | 48343 | 623 | 11 |
923231 | 923231 | 2021-01-12 | Motley | Texas | 48345 | 79 | 5 |
923232 | 923232 | 2021-01-12 | Nacogdoches | Texas | 48347 | 3383 | 102 |
923233 | 923233 | 2021-01-12 | Navarro | Texas | 48349 | 4719 | 70 |
923234 | 923234 | 2021-01-12 | Newton | Texas | 48351 | 672 | 19 |
923235 | 923235 | 2021-01-12 | Nolan | Texas | 48353 | 1367 | 32 |
923236 | 923236 | 2021-01-12 | Nueces | Texas | 48355 | 30827 | 586 |
923237 | 923237 | 2021-01-12 | Ochiltree | Texas | 48357 | 956 | 18 |
923238 | 923238 | 2021-01-12 | Oldham | Texas | 48359 | 164 | 2 |
923239 | 923239 | 2021-01-12 | Orange | Texas | 48361 | 5842 | 78 |
923240 | 923240 | 2021-01-12 | Palo Pinto | Texas | 48363 | 2220 | 48 |
923241 | 923241 | 2021-01-12 | Panola | Texas | 48365 | 1156 | 46 |
923242 | 923242 | 2021-01-12 | Parker | Texas | 48367 | 10721 | 105 |
923243 | 923243 | 2021-01-12 | Parmer | Texas | 48369 | 1103 | 32 |
923244 | 923244 | 2021-01-12 | Pecos | Texas | 48371 | 1403 | 26 |
923245 | 923245 | 2021-01-12 | Polk | Texas | 48373 | 2352 | 63 |
923246 | 923246 | 2021-01-12 | Potter | Texas | 48375 | 15778 | 324 |
923247 | 923247 | 2021-01-12 | Presidio | Texas | 48377 | 640 | 18 |
923248 | 923248 | 2021-01-12 | Rains | Texas | 48379 | 611 | 19 |
923249 | 923249 | 2021-01-12 | Randall | Texas | 48381 | 14935 | 214 |
923250 | 923250 | 2021-01-12 | Reagan | Texas | 48383 | 349 | 7 |
923251 | 923251 | 2021-01-12 | Real | Texas | 48385 | 247 | 12 |
923252 | 923252 | 2021-01-12 | Red River | Texas | 48387 | 506 | 27 |
923253 | 923253 | 2021-01-12 | Reeves | Texas | 48389 | 1465 | 33 |
923254 | 923254 | 2021-01-12 | Refugio | Texas | 48391 | 515 | 17 |
923255 | 923255 | 2021-01-12 | Roberts | Texas | 48393 | 48 | 1 |
923256 | 923256 | 2021-01-12 | Robertson | Texas | 48395 | 1004 | 23 |
923257 | 923257 | 2021-01-12 | Rockwall | Texas | 48397 | 7782 | 61 |
923258 | 923258 | 2021-01-12 | Runnels | Texas | 48399 | 1060 | 23 |
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);