offices

Table actions Table actions

3 rows where legislator_id = "C001063"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
C001063-laredo C001063 602 E. Calton Rd. Suite 2 Laredo TX 78041 27.5423782 -99.4887937 956-725-2647 956-725-0639   Monday - Friday 8:00 a.m. CST to 5:30 p.m. CST
C001063-rio_grande_city C001063 100 N. FM 3167 Suite 208 Rio Grande City TX 78582 26.3738676 -98.8594816 956-424-3936 956-487-5603    
C001063-san_antonio C001063 1145 E. Commerce St. Suite 205 San Antonio TX 78205 29.4219124 -98.4788622 210-277-6671 210-271-2851    

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