offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3 rows where legislator_id = "H001079"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
H001079-gulfport | Cindy Hyde-Smith H001079 | 2012 15th Street | #451 | Gulfport | MS | 39501 | 30.3701149 | -89.0870838 | 228-867-9710 | 228-867-9789 | ||
H001079-jackson | Cindy Hyde-Smith H001079 | 190 East Capitol St. | #550 | Jackson | MS | 39201 | 32.3004269 | -90.1867448 | 601-965-4459 | 601-965-4919 | ||
H001079-oxford | Cindy Hyde-Smith H001079 | 911 Jackson Ave. | #249 | Oxford | MS | 38655 | 34.3672392 | -89.5212463 | 662-236-1018 | 662-236-7618 |
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);