offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
4 rows where legislator_id = "B001135" sorted by zip descending
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city | state | zip ▲ | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
B001135-asheville | Richard Burr B001135 | 151 Patton Ave. | Suite 204 | Asheville | NC | 28801 | 35.594066 | -82.55792 | 828-350-2437 | 828-350-2439 | Federal Building | By appointment only |
B001135-wilmington | Richard Burr B001135 | 201 N. Front St. | Suite 809 | Wilmington | NC | 28401 | 34.2376985 | -77.9492582 | 888-848-1833 | 910-251-7975 | ||
B001135-rocky_mount | Richard Burr B001135 | 100 Coast Line St. | Room 210 | Rocky Mount | NC | 27804 | 35.9379802 | -77.7977748 | 252-977-9522 | 252-977-7902 | By appointment only. | |
B001135-winston_salem | Richard Burr B001135 | 2000 W. First St. | Suite 508 | Winston-Salem | NC | 27104 | 36.0960116 | -80.27480249999999 | 336-631-5125 | 336-725-4493 |
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);