offices

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

7 rows where legislator_id = "C001056"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude phone fax building hours
C001056-austin John Cornyn C001056 221 W. Sixth St. Suite 1530 Austin TX 78701 30.2681008 -97.7448471 512-469-6034 512-469-6020 Chase Tower  
C001056-dallas John Cornyn C001056 5001 Spring Valley Rd. Suite 1125 E Dallas TX 75244 32.9400414 -96.82359749999999 972-239-1310 972-239-2110    
C001056-harlingen John Cornyn C001056 222 E. Van Buren Suite 404 Harlingen TX 78550 26.1914148 -97.69402009999999 956-423-0162 956-423-0193    
C001056-houston John Cornyn C001056 5300 Memorial Dr. Suite 980 Houston TX 77007 29.7620629 -95.41595319999999 713-572-3337 713-572-3777    
C001056-lubbock John Cornyn C001056 1500 Broadway Suite 1230 Lubbock TX 79401 33.5849492 -101.8519083 806-472-7533 806-472-7536 Wells Fargo Center  
C001056-san_antonio John Cornyn C001056 600 Navarro Suite 210 San Antonio TX 78205 29.4267857 -98.48957639999999 210-224-7485 210-224-8569    
C001056-tyler John Cornyn C001056 100 E. Ferguson St. Suite 1004 Tyler TX 75702 32.3522862 -95.30028709999999 903-593-0902 903-593-0920 Regions Bank Building  

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] FLOAT,
   [longitude] FLOAT,
   [phone] TEXT,
   [fax] TEXT,
   [building] TEXT
, [hours] TEXT);