offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "C000127"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
C000127-everett | Maria Cantwell C000127 | 2930 Wetmore Ave. | Suite 9B | Everett | WA | 98201 | 47.9781562 | -122.2076204 | 425-303-0114 | 425-303-8351 | ||
C000127-richland | Maria Cantwell C000127 | 825 Jadwin Ave. | Suite 206 | Richland | WA | 99352 | 46.2775762 | -119.2760977 | 509-946-8106 | 509-946-6937 | ||
C000127-seattle | Maria Cantwell C000127 | 915 Second Ave. | Suite 3206 | Seattle | WA | 98174 | 47.6045895 | -122.3354608 | 206-220-6400 | 206-220-6404 | ||
C000127-spokane | Maria Cantwell C000127 | 920 W. Riverside Ave. | Suite 697 | Spokane | WA | 99201 | 47.6585992 | -117.4260094 | 509-353-2507 | 509-353-2547 | ||
C000127-tacoma | Maria Cantwell C000127 | 950 Pacific Ave. | Suite 615 | Tacoma | WA | 98402 | 47.2535757 | -122.4390697 | 253-572-2281 | 253-572-5879 | ||
C000127-vancouver | Maria Cantwell C000127 | 1313 Officers Row | Vancouver | WA | 98661 | 45.628864 | -122.6641029 | 360-696-7838 | 360-696-7844 |
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);