offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where legislator_id = "T000476"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
T000476-charlotte | Thom Tillis T000476 | 9300 Harris Corners Pkwy. | Suite 170 | Charlotte | NC | 28269 | 35.34589709999999 | -80.8466732 | 704-509-9087 | 704-509-9162 | ||
T000476-greenville | Thom Tillis T000476 | 1694 E. Arlington Blvd. | Suite B | Greenville | NC | 27858 | 35.5709032 | -77.3592441 | 252-329-0371 | 252-329-0290 | By appointment only. | |
T000476-hendersonville | Thom Tillis T000476 | 1 Historic Courthouse Square | Suite 112 | Hendersonville | NC | 28792 | 35.314451 | -82.460467 | 828-693-8750 | 828-693-9724 | By appointment only. | |
T000476-high_point | Thom Tillis T000476 | 1840 Eastchester Dr. | Suite 200 | High Point | NC | 27265 | 36.008425 | -79.98567299999999 | 336-885-0685 | 336-885-0692 | ||
T000476-raleigh | Thom Tillis T000476 | 310 New Bern Ave. | Suite 122 | Raleigh | NC | 27601 | 35.7799621 | -78.63388100000002 | 919-856-4630 | 919-856-4053 |
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);