offices

Table actions

7 rows where legislator_id = "B001319"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
B001319-anniston Katie Britt B001319 1100 Gurnee Avenue Suite 306 Anniston AL 36206 33.6587881 -85.83167089999999        
B001319-birmingham Katie Britt B001319 1800 5th Avenue North   Birmingham AL 35203 33.5172948 -86.8104961   205-731-1384 321 Federal Building  
B001319-dothan Katie Britt B001319 100 W. Troy St Suite 101 Dothan AL 36303 31.2254074 -85.3951147   334-500-4097 Dothan Courthouse and Federal Building  
B001319-huntsville Katie Britt B001319 660 Gallatin St SW Suite 1400 Huntsville AL 35801 34.7242889 -86.5875595   256-429-3450    
B001319-mobile Katie Britt B001319 113 Saint Joseph Street Room 365 Mobile AL 36602 30.6938968 -88.0431577   251-662-9990    
B001319-montgomery Katie Britt B001319 One Church Street Suite F-401 Montgomery AL 36104 32.3717481 -86.32518429999999   334-777-1150 United States Federal Courthouse  
B001319-tuscaloosa Katie Britt B001319 2005 University Boulevard Suite 2100 Tuscaloosa AL 35401 33.210198 -87.5631669   659-251-2880    

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