offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3 rows where legislator_id = "O000171"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
O000171-casa_grande | Tom O’Halleran O000171 | 211 N. Florence St. | Suite 1 | Casa Grande | AZ | 85122 | 32.8770219 | -111.7541607 | 520-316-0839 | |||
O000171-flagstaff | Tom O’Halleran O000171 | 405 N. Beaver St. | Suite 6 | Flagstaff | AZ | 86001 | 35.2019797 | -111.6486132 | 928-286-5338 | |||
O000171-tucson | Tom O’Halleran O000171 | 3037 W. Ina Rd | Suite 101 | Tucson | AZ | 85741 | 32.3363922 | -111.0318291 | 928-304-0131 |
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);