offices
3 rows where legislator_id = "A000055"
This data as json, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | fax | phone | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
A000055-cullman | Robert Aderholt A000055 | 205 4th Ave. NE | Suite 104 | Cullman | AL | 35055 | 34.181059 | -86.840631 | 202-225-5587 | 256-734-6043 | ||
A000055-jasper | Robert Aderholt A000055 | 1710 Alabama Ave. | 247 | Jasper | AL | 35501 | 33.83438 | -87.274935 | 205-221-2310 | Carl Elliott Building | ||
A000055-tuscumbia | Robert Aderholt A000055 | 1011 George Wallace Blvd. | Suite 146 | Tuscumbia | AL | 35674 | 34.7412348 | -87.6794142 | 202-225-5587 | 256-381-3450 |
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, [fax] TEXT, [phone] TEXT, [building] TEXT , [hours] TEXT);