offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
7 rows where legislator_id = "C001075" sorted by city descending
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city ▲ | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
C001075-shreveport | Bill Cassidy C001075 | 6425 Youree Dr. | Suite 415 | Shreveport | LA | 71105 | 32.448457 | -93.71986679999999 | 318-798-3215 | 318-798-6959 | ||
C001075-monroe | Bill Cassidy C001075 | 1651 Louisville Ave. | Suite 123 | Monroe | LA | 70201 | 32.5175209 | -92.1087384 | 318-324-2111 | 318-324-2197 | ||
C001075-metairie | Bill Cassidy C001075 | 3421 N. Causeway Blvd. | Suite 204 | Metairie | LA | 70002 | 30.0112259 | -90.15417479999999 | 504-838-0130 | 504-838-0133 | ||
C001075-lake_charles | Bill Cassidy C001075 | 1 Lakeshore Dr. | Suite 1155 | Lake Charles | LA | 70629 | 30.2305579 | -93.2196294 | 337-493-5398 | 337-493-5629 | ||
C001075-lafayette | Bill Cassidy C001075 | 101 La Rue France | Suite 505 | Lafayette | LA | 70508 | 30.1948666 | -92.014654 | 337-261-1400 | 337-261-1490 | ||
C001075-baton_rouge | Bill Cassidy C001075 | 5555 Hilton Ave. | Suite 100 | Baton Rouge | LA | 70808 | 30.423884 | -91.1325791 | 225-929-7711 | 225-929-7688 | ||
C001075-alexandria | Bill Cassidy C001075 | 3600 Jackson St. | Suite 115A | Alexandria | LA | 71303 | 31.2852075 | -92.47677350000001 | 318-448-7176 | 318-448-5175 |
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);