offices

Table actions

4 rows where legislator_id = "C001118"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
C001118-harrisonburg Ben Cline C001118 70 N Mason St Suite 110 Harrisonburg VA 22802-4126 38.44978 -78.86637 540-857-2675 540-432-2391    
C001118-roanoke Ben Cline C001118 10 Franklin Rd SE Suite 510 Roanoke VA 24011-2133 37.2694 -79.94051 540-857-2675 540-857-2672    
C001118-staunton Ben Cline C001118 117 S Lewis St Suite 215 Staunton VA 24401-4282 38.14838 -79.07444 540-857-2675 540-885-3861    
C001118-winchester Ben Cline C001118 100 N. Loudoun St. Suite 120 Winchester VA 22601 39.1847091 -78.1651274 540-857-2675 540-546-0876    

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