offices

Table actions Table actions

6 rows where legislator_id = "C000127"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
C000127-everett C000127 2930 Wetmore Ave. Suite 9B Everett WA 98201 47.9781562 -122.2076204 425-303-8351 425-303-0114    
C000127-richland C000127 825 Jadwin Ave. Suite 206 Richland WA 99352 46.2775762 -119.2760977 509-946-6937 509-946-8106    
C000127-seattle C000127 915 Second Ave. Suite 3206 Seattle WA 98174 47.6045895 -122.3354608 206-220-6404 206-220-6400    
C000127-spokane C000127 920 W. Riverside Ave. Suite 697 Spokane WA 99201 47.6585992 -117.4260094 509-353-2547 509-353-2507    
C000127-tacoma C000127 950 Pacific Ave. Suite 615 Tacoma WA 98402 47.2535757 -122.4390697 253-572-5879 253-572-2281    
C000127-vancouver C000127 1313 Officers Row   Vancouver WA 98661 45.628864 -122.6641029 360-696-7844 360-696-7838    

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);