offices

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

6 rows where legislator_id = "C001035"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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,
   [phone] TEXT,
   [fax] TEXT,
   [building] TEXT
, [hours] TEXT);