offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "C001035"
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
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);