offices

Table actions Table actions

6 rows where legislator_id = "C001035"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
C001035-augusta C001035 68 Sewall St. Room 507 Augusta ME 04330 44.310824 -69.783697   207-622-8414    
C001035-bangor C001035 202 Harlow St. Room 20100 Bangor ME 04401 44.8046399 -68.7737891   207-945-0417    
C001035-biddeford C001035 160 Main St.   Biddeford ME 04005 43.493177 -70.4548329   207-283-1101    
C001035-caribou C001035 25 Sweden St. Suite A Caribou ME 04736 46.860458 -68.013198   207-493-7873    
C001035-lewiston C001035 55 Lisbon St.   Lewiston ME 04240 44.097439 -70.217972   207-784-6969    
C001035-portland C001035 One Canal Plaza Suite 802 Portland ME 04101 43.6566885 -70.2551294   207-618-5560    

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