offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
4 rows where legislator_id = "S001176"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S001176-hammond | Steve Scalise S001176 | 1514 Martens Dr. | Suite 10 | Hammond | LA | 70401 | 30.517849 | -90.47894529999999 | 985-340-2185 | |||
S001176-houma | Steve Scalise S001176 | 8026 Main St. | Suite 700 | Houma | LA | 70360 | 29.5979361 | -90.71805719999999 | 985-879-2300 | |||
S001176-mandeville | Steve Scalise S001176 | 21454 Koop Drive | Suite 2C | Mandeville | LA | 70471 | 30.4172835 | -90.0434162 | 985-893-9064 | |||
S001176-metairie | Steve Scalise S001176 | 110 Veterans Blvd. | Suite 500 | Metairie | LA | 70005 | 29.9992548 | -90.1242066 | 504-837-1259 |
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);