offices
6 rows where legislator_id = "C001098"
This data as json, CSV (advanced)
| id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | fax | phone | building | hours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C001098-austin | Ted Cruz C001098 | 300 E 8th | Suite 961 | Austin | TX | 78701 | 30.269401 | -97.7390867 | 512-916-5839 | 512-916-5834 | ||
| C001098-dallas | Ted Cruz C001098 | 3626 N. Hall St. | Suite 410 | Dallas | TX | 75219 | 32.8092691 | -96.8059281 | 214-361-3518 | 214-599-8749 | Lee Park Tower II | |
| C001098-houston | Ted Cruz C001098 | 1919 Smith St. | Suite 9047 | Houston | TX | 77002 | 29.758844 | -95.3650242 | 713-209-3459 | 713-718-3057 | The Mickey Leland Federal Building | |
| C001098-mcallen | Ted Cruz C001098 | 200 S. 10th St. | Suite 1603 | McAllen | TX | 78501 | 26.2019273 | -98.2313667 | 956-686-7339 | |||
| C001098-san_antonio | Ted Cruz C001098 | 9901 Ih-10w | Suite 950 | San Antonio | TX | 78230 | 29.533858 | -98.5619881 | 210-349-6753 | 210-340-2885 | ||
| C001098-tyler | Ted Cruz C001098 | 305 S. Broadway | Suite 501 | Tyler | TX | 75702 | 32.3480097 | -95.3009807 | 903-593-5130 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);