offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
4 rows where legislator_id = "C001047" sorted by address
This data as json, copyable, CSV (advanced)
Suggested facets: phone
id | legislator_id | address ▼ | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
C001047-beckley | Shelley Capito C001047 | 220 N. Kanawha St. | Suite 1 | Beckley | WV | 25801 | 37.779625 | -81.188172 | 304-347-5372 | Appointments are required at this location. | ||
C001047-martinsburg | Shelley Capito C001047 | 300 Foxcroft Ave. | Suite 202A | Martinsburg | WV | 25401 | 39.4607489 | -77.986887 | 304-262-9285 | |||
C001047-morgantown | Shelley Capito C001047 | 48 Donley St. | Suite 504 | Morgantown | WV | 26501 | 39.6256581 | -79.96312549999999 | 304-292-2310 | |||
C001047-charleston | Shelley Capito C001047 | 500 Virgina Street East | Suite 950 | Charleston | WV | 25301 | 38.3511449 | -81.6380602 | 304-347-5372 |
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);