offices

Table actions

6 rows where legislator_id = "B001243"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
B001243-chattanooga Marsha Blackburn B001243 10 West M. L. King Blvd 6th Floor Chattanooga TN 37402 35.0455268 -85.3100155 423-541-2944 423-541-2939    
B001243-jackson Marsha Blackburn B001243 109 S Highland Ave Suite 218 Jackson TN 38301 35.6138097 -88.8199198 731-660-3978 731-660-3971    
B001243-johnson_city Marsha Blackburn B001243 207 Mocking Bird Ln Suite 502 Johnson City TN 37604 36.3355276 -82.37505809999999 423-788-0250 423-753-4009    
B001243-knoxville Marsha Blackburn B001243 800 Market St Suite 121 Knoxville TN 37902-2327 35.96225 -83.91771 865-540-7952 865-540-3781    
B001243-memphis Marsha Blackburn B001243 100 Peabody Pl Suite 1125 Memphis TN 38103-3654 35.14132 -90.05396 901-527-9515 901-527-9199    
B001243-nashville Marsha Blackburn B001243 719 Church Street Suite 2100 Nashville TN 37203 36.1615561 -86.78303760000001 615-298-2148 629-800-6600    

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