offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "K000384"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
K000384-abingdon | Timothy Kaine K000384 | 121 Russell Rd. | Suite 2 | Abingdon | VA | 24210 | 36.709042 | -81.981768 | 276-525-4790 | 276-525-4792 | ||
K000384-danville | Timothy Kaine K000384 | 308 Craghead Street | Suite 102A | Danville | VA | 24541 | 36.5867166 | -79.38939599999999 | 434-792-0976 | 434-792-0978 | ||
K000384-manassas | Timothy Kaine K000384 | 9408 Grant Avenue | Suite 202 | Manassas | VA | 20110 | 38.7515843 | -77.4755912 | 703-361-3192 | 703-361-3198 | ||
K000384-richmond | Timothy Kaine K000384 | 919 E. Main St. | Suite 970 | Richmond | VA | 23219 | 37.5374358 | -77.4362913 | 804-771-2221 | 804-771-8313 | ||
K000384-roanoke | Timothy Kaine K000384 | 611 S. Jefferson St. | Suite 5B | Roanoke | VA | 24011 | 37.268654 | -79.9408098 | 540-682-5693 | 540-682-5697 | ||
K000384-virginia_beach | Timothy Kaine K000384 | 222 Central Park Ave. | Suite 120 | Virginia Beach | VA | 23462 | 36.842768 | -76.13327699999999 | 757-518-1674 | 757-518-1679 |
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);