offices

2 rows where legislator_id = "A000375"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
A000375-abilene A000375 500 Chestnut St. Suite 819 Abilene TX 79602 32.4443053 -99.73461449999999 325-675-5038 325-675-9779    
A000375-lubbock A000375 1312 Texas Ave. Suite 219 Lubbock TX 79401 33.5830588 -101.8456125 806-767-9168 806-763-1611    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "offices" (
   "id" TEXT PRIMARY KEY,
   "legislator_id" TEXT REFERENCES "legislators"("id"),
   "address" TEXT,
   "suite" TEXT,
   "city" TEXT,
   "state" TEXT,
   "zip" TEXT,
   "latitude" REAL,
   "longitude" REAL,
   "fax" TEXT,
   "phone" TEXT,
   "building" TEXT
, "hours" TEXT);