offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2 rows where legislator_id = "H001056"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
H001056-chehalis | Jaime Herrera Beutler H001056 | 350 N. Market Blvd. | Chehalis | WA | 98532 | 46.6639928 | -122.9672327 | Chehalis City Hall Building | Tuesdays from 11:30am - 1:00pm | |||
H001056-vancouver | Jaime Herrera Beutler H001056 | 750 Anderson St. | Suite B | Vancouver | WA | 98661 | 45.6281298 | -122.6643142 | 360-695-6292 | 360-695-6197 | O.O. Howard House (Officers' Row) |
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);