offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
4 rows where legislator_id = "M001157"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
M001157-austin | Michael McCaul M001157 | 9009 Mountain Ridge Dr. | Suite 230 | Austin | TX | 78759 | 30.3864963 | -97.7528485 | 512-473-2357 | 512-473-0514 | Austin Building | By appointment only |
M001157-brenham | Michael McCaul M001157 | 2000 S. Market St. | Suite 303 | Brenham | TX | 77833 | 30.1510408 | -96.3912448 | 979-830-8497 | 979-830-1984 | Tuesday and Thursday 8-5pm | |
M001157-katy | Michael McCaul M001157 | 1773 Westborough Dr. | Suite 223 | Katy | TX | 77449 | 29.7918796 | -95.7318468 | 281-398-1247 | Katy Commerce Center | By Appointment Only | |
M001157-tomball | Michael McCaul M001157 | 990 Village Sq. | Suite B | Tomball | TX | 77375 | 30.096319 | -95.625406 | 281-255-8372 | 281-255-0034 | Rosewood Professional Building | M-F 8am-5:00pm |
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, [phone] TEXT, [fax] TEXT, [building] TEXT , [hours] TEXT);