offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3 rows where legislator_id = "G000565"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
G000565-gold_canyon | Paul Gosar G000565 | 6499 S. Kings Ranch Rd. | #4 | Gold Canyon | AZ | 85118 | 33.3557193 | -111.4526421 | 480-882-2697 | |||
G000565-kingman | Paul Gosar G000565 | 220 N. 4th St. | Kingman | AZ | 86401 | 35.1904088 | -114.0525545 | |||||
G000565-prescott | Paul Gosar G000565 | 122 N. Cortez St. | Suite 104 | Prescott | AZ | 86301 | 34.5427185 | -112.4690897 | 928-445-1683 |
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);